1 /*
2 * Copyright 2005-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;
17
18
19 /**
20 * DAO interface for the balancing process of ledger entries
21 */
22 public interface LedgerEntryBalancingDao {
23 /**
24 * Does a group by query on the parameters passed in and returns an object array with the count as first parameter and sum of TRANSACTION_LEDGER_ENTRY_AMOUNT of the second.
25 * @param universityFiscalYear the given university fiscal year
26 * @param chartOfAccountsCode the given chart of account code
27 * @param financialObjectCode the given object code
28 * @param financialBalanceTypeCode the given balance type code
29 * @param universityFiscalPeriodCode the given university fiscal period code
30 * @param transactionDebitCreditCode the given transaction debit or credit code
31 * @return object array with [0] being count(*) and [1] sum(TRANSACTION_LEDGER_ENTRY_AMOUNT). Returns null if data was not found
32 */
33 public Object[] findEntryByGroup(Integer universityFiscalYear, String chartOfAccountsCode, String financialObjectCode, String financialBalanceTypeCode, String universityFiscalPeriodCode, String transactionDebitCreditCode);
34
35 /**
36 * Finds the count of rows for >= fiscal year passed in.
37 * @param the given university fiscal year
38 * @return count
39 */
40 public Integer findCountGreaterOrEqualThan(Integer year);
41 }