001/* 002 * Copyright 2009 The Kuali Foundation 003 * 004 * Licensed under the Educational Community License, Version 2.0 (the "License"); 005 * you may not use this file except in compliance with the License. 006 * You may obtain a copy of the License at 007 * 008 * http://www.opensource.org/licenses/ecl2.php 009 * 010 * Unless required by applicable law or agreed to in writing, software 011 * distributed under the License is distributed on an "AS IS" BASIS, 012 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 013 * See the License for the specific language governing permissions and 014 * limitations under the License. 015 */ 016package org.kuali.ole.gl.dataaccess.impl; 017 018import org.kuali.ole.gl.dataaccess.SufficientFundRebuildDao; 019import org.kuali.rice.core.framework.persistence.jdbc.dao.PlatformAwareDaoBaseJdbc; 020 021/** 022 * This class... 023 */ 024public class SufficientFundRebuildDaoJdbc extends PlatformAwareDaoBaseJdbc implements SufficientFundRebuildDao { 025 026 /** 027 * @see org.kuali.ole.gl.dataaccess.SufficientFundRebuildDao#populateSufficientFundRebuild() 028 */ 029 public void populateSufficientFundRebuild() { 030 getSimpleJdbcTemplate().update("INSERT INTO GL_SF_REBUILD_T (FIN_COA_CD, ACCT_NBR_FOBJ_CD, acct_fobj_typ_cd, obj_id, ver_nbr) "+ 031 "(SELECT FIN_COA_CD, ACCOUNT_NBR, 'A', obj_id, 1 FROM CA_ACCOUNT_T WHERE ACCT_CLOSED_IND = 'N')"); 032 033 } 034 035 /** 036 * @see org.kuali.ole.gl.dataaccess.SufficientFundRebuildDao#purgeSufficientFundRebuild() 037 */ 038 public void purgeSufficientFundRebuild() { 039 getSimpleJdbcTemplate().update("DELETE FROM GL_SF_REBUILD_T"); 040 041 } 042 043}