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}