PACKAGE: APPS.JA_JAINBBR_XMLP_PKG

Source

1 PACKAGE JA_JAINBBR_XMLP_PKG AS
2 /* $Header: JAINBBRS.pls 120.1 2007/12/25 16:14:00 dwkrishn noship $ */
3   P_START_DATE DATE;
4 
5   P_END_DATE DATE;
6 
7   LP_START_DATE varchar2(20);
8 
9   LP_END_DATE varchar2(20);
10 
11   LP1_START_DATE varchar2(20);
12 
13   LP1_END_DATE varchar2(20);
14 
15   P_BANK_ACCOUNT_NAME VARCHAR2(40);
16 
17   P_BANK_ACCOUNT_NUM VARCHAR2(40);
18 
19   P_CHART_OF_ACCTS_ID NUMBER;
20 
21   P_ORG_ID NUMBER;
22 
23   P_BOOK_TYPE VARCHAR2(1);
24 
25   P_DUMMY VARCHAR2(32767);
26 
27   P_COLUMN_VALUE VARCHAR2(30);
28 
29   P_BANK_ACCOUNT_ID NUMBER;
30 
31   P_TRACE_SWITCH VARCHAR2(1);
32 
33   P_CONC_REQUEST_ID NUMBER;
34 
35   LP_SET_OF_BOOKS_ID NUMBER;
36 
37   FUNCTION CF_CLOSING_BALANCEFORMULA(CF_CLOSING_BALANCE IN NUMBER
38                                     ,CF_OPEN_BALANCE IN NUMBER
39                                     ,RECEIPTS IN VARCHAR2
40                                     ,PAYMENTS IN VARCHAR2) RETURN NUMBER;
41 
42   FUNCTION CF_BALANCEFORMULA(RECEIPTS IN VARCHAR2
43                             ,PAYMENTS IN VARCHAR2) RETURN NUMBER;
44 
45   FUNCTION CF_ACCOUNT_CODEFORMULA(ACCOUNT_CODE IN NUMBER) RETURN VARCHAR2;
46 
47   FUNCTION BEFOREREPORT RETURN BOOLEAN;
48 
49   FUNCTION CF_1FORMULA RETURN VARCHAR2;
50 
51    FUNCTION CF_ACCT_DESCFORMULA (account_code IN NUMBER) RETURN VARCHAR2;
52 
53   FUNCTION CF_P_BOOKFORMULA RETURN VARCHAR2;
54 
55   FUNCTION JA_IN_CAL_BAL(P_BASE_DATE IN DATE
56                         ,P_BALANCE_TYPE IN VARCHAR2
57                         ,P_OPEN_CLOSE IN VARCHAR2) RETURN NUMBER;
58 
59   FUNCTION AFTERREPORT RETURN BOOLEAN;
60 
61   FUNCTION CF_OPEN_BAL_DRFORMULA RETURN NUMBER;
62 
63   FUNCTION CF_OPEN_BAL_CRFORMULA RETURN NUMBER;
64 
65   FUNCTION CF_OPEN_BALANCEFORMULA(CF_OPEN_BAL_CR IN NUMBER
66                                  ,CF_OPEN_BAL_DR IN NUMBER) RETURN NUMBER;
67 
68 END JA_JAINBBR_XMLP_PKG;
69