1 /*
2 * Copyright 2009 The Kuali Foundation
3 *
4 * Licensed under the Educational Community License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
7 *
8 * http://www.opensource.org/licenses/ecl2.php
9 *
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
15 */
16 package org.kuali.ole.gl.dataaccess.impl;
17
18 import org.kuali.ole.gl.dataaccess.SufficientFundRebuildDao;
19 import org.kuali.rice.core.framework.persistence.jdbc.dao.PlatformAwareDaoBaseJdbc;
20
21 /**
22 * This class...
23 */
24 public class SufficientFundRebuildDaoJdbc extends PlatformAwareDaoBaseJdbc implements SufficientFundRebuildDao {
25
26 /**
27 * @see org.kuali.ole.gl.dataaccess.SufficientFundRebuildDao#populateSufficientFundRebuild()
28 */
29 public void populateSufficientFundRebuild() {
30 getSimpleJdbcTemplate().update("INSERT INTO GL_SF_REBUILD_T (FIN_COA_CD, ACCT_NBR_FOBJ_CD, acct_fobj_typ_cd, obj_id, ver_nbr) "+
31 "(SELECT FIN_COA_CD, ACCOUNT_NBR, 'A', obj_id, 1 FROM CA_ACCOUNT_T WHERE ACCT_CLOSED_IND = 'N')");
32
33 }
34
35 /**
36 * @see org.kuali.ole.gl.dataaccess.SufficientFundRebuildDao#purgeSufficientFundRebuild()
37 */
38 public void purgeSufficientFundRebuild() {
39 getSimpleJdbcTemplate().update("DELETE FROM GL_SF_REBUILD_T");
40
41 }
42
43 }