[Home] [Help]
PACKAGE: APPS.AR_ARXSOC_XMLP_PKG
Source
1 PACKAGE AR_ARXSOC_XMLP_PKG AS
2 /* $Header: ARXSOCS.pls 120.0 2007/12/27 14:09:44 abraghun noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4 P_DATE_LOW DATE;
5 P_DATE_HIGH DATE;
6 P_DATE_LOW1 varchar2(10);
7 P_DATE_HIGH1 varchar2(10);
8 P_BANK_ACCOUNT_NAME_LOW VARCHAR2(80);
9 P_BANK_ACCOUNT_NAME_HIGH VARCHAR2(80);
10 P_ORDER_BY VARCHAR2(32767);
11 P_ORDER_BY_1 VARCHAR2(32767);
12 P_SET_OF_BOOKS_ID NUMBER;
13 LP_BANK_ACCOUNT_NAME_LOW VARCHAR2(800):=' ';
14 LP_BANK_ACCOUNT_NAME_HIGH VARCHAR2(800):=' ';
15 LP_DATE_LOW VARCHAR2(200):=' ';
16 LP_DATE_HIGH VARCHAR2(200):=' ';
17 P_BANK_COUNT NUMBER := 0;
18 PH_ORDER_BY VARCHAR2(32767);
19 P_ACTUAL_AMOUNT NUMBER;
20 P_UNIDENTIFIED_AMOUNT NUMBER;
21 P_MISC_AMOUNT NUMBER;
22 P_NSF_AMOUNT NUMBER;
23 P_APPLIED_COUNT NUMBER := 0;
24 P_UNAPPLIED_COUNT NUMBER;
25 P_UNIDENTIFIED_COUNT NUMBER;
26 P_MISC_COUNT NUMBER;
27 PA_ACTUAL_AMOUNT NUMBER;
28 PA_UNIDENTIFIED_AMOUNT NUMBER;
29 PA_MISC_AMOUNT NUMBER;
30 PA_NSF_AMOUNT NUMBER;
31 PA_APPLIED_COUNT NUMBER := 0;
32 PA_UNAPPLIED_COUNT NUMBER;
33 PA_UNIDENTIFIED_COUNT NUMBER;
34 PA_MISC_COUNT NUMBER;
35 RP_COMPANY_NAME VARCHAR2(50);
36 RP_REPORT_NAME VARCHAR2(80);
37 RP_DATA_FOUND3 VARCHAR2(300);
38 RP_DATE_RANGE VARCHAR2(200);
39 RP_DATA_FOUND1 VARCHAR2(300);
40 RP_DATA_FOUND2 VARCHAR2(300);
41 RP_ORDER_BY VARCHAR2(80);
42 FUNCTION BEFOREREPORT RETURN BOOLEAN;
43 FUNCTION AFTERREPORT RETURN BOOLEAN;
44 FUNCTION REPORT_NAMEFORMULA(COMPANY_NAME IN VARCHAR2) RETURN VARCHAR2;
45 FUNCTION C_DIFFERENCE_AMOUNTFORMULA(C_RCPT_CONTROL_AMOUNT IN NUMBER
46 ,C_ACTUAL_AMOUNT IN NUMBER) RETURN NUMBER;
47 FUNCTION C_SUMMARY_LABELFORMULA(CURRENCY_A IN VARCHAR2) RETURN VARCHAR2;
48 FUNCTION CA_DIFFERENCE_AMOUNTFORMULA(C_RCPT_CONTROL_AMOUNT_B IN NUMBER
49 ,CA_ACTUAL_AMOUNT IN NUMBER) RETURN NUMBER;
50 FUNCTION CA_SUMMARY_LABELFORMULA(CURRENCY_B IN VARCHAR2) RETURN VARCHAR2;
51 FUNCTION CF_DATA_NOT_FOUNDFORMULA(BANK_ACCOUNT_NAME_C IN VARCHAR2) RETURN NUMBER;
52 FUNCTION CR_DATA_FOUNDFORMULA(CURRENCY_B IN VARCHAR2) RETURN NUMBER;
53 FUNCTION CM_DATA_NOT_FOUNDFORMULA(CURRENCY_A IN VARCHAR2) RETURN NUMBER;
54 FUNCTION AFTERPFORM RETURN BOOLEAN;
55 FUNCTION F_AMOUNTSFORMULA(AMOUNT IN NUMBER
56 ,CR_STATUS IN VARCHAR2
57 ,CR_TYPE IN VARCHAR2
58 ,REVERSAL_CATEGORY IN VARCHAR2
59 ,CASH_RECEIPT_ID IN NUMBER) RETURN NUMBER;
60 FUNCTION F_ALL_AMOUNTSFORMULA(AMOUNT_B IN NUMBER
61 ,CR_STATUS_BB IN VARCHAR2
62 ,CR_TYPE_B IN VARCHAR2
63 ,REVERSAL_CATEGORY_B IN VARCHAR2
64 ,CASH_RECEIPT_ID_B IN NUMBER) RETURN NUMBER;
65 FUNCTION C_APPLIED_AMOUNTFORMULA(C_APPLIED_AMOUNT_A IN NUMBER
66 ,C_MISC_AMOUNT IN NUMBER) RETURN NUMBER;
67 FUNCTION CA_APPLIED_AMOUNTFORMULA(CA_APPLIED_AMOUNT_B IN NUMBER
68 ,CA_MISC_AMOUNT IN NUMBER) RETURN NUMBER;
69 FUNCTION ORDER_BY_MEANINGFORMULA RETURN VARCHAR2;
70 FUNCTION P_ACTUAL_AMOUNT_P RETURN NUMBER;
71 FUNCTION P_UNIDENTIFIED_AMOUNT_P RETURN NUMBER;
72 FUNCTION P_MISC_AMOUNT_P RETURN NUMBER;
73 FUNCTION P_NSF_AMOUNT_P RETURN NUMBER;
74 FUNCTION P_APPLIED_COUNT_P RETURN NUMBER;
75 FUNCTION P_UNAPPLIED_COUNT_P RETURN NUMBER;
76 FUNCTION P_UNIDENTIFIED_COUNT_P RETURN NUMBER;
77 FUNCTION P_MISC_COUNT_P RETURN NUMBER;
78 FUNCTION PA_ACTUAL_AMOUNT_P RETURN NUMBER;
79 FUNCTION PA_UNIDENTIFIED_AMOUNT_P RETURN NUMBER;
80 FUNCTION PA_MISC_AMOUNT_P RETURN NUMBER;
81 FUNCTION PA_NSF_AMOUNT_P RETURN NUMBER;
82 FUNCTION PA_APPLIED_COUNT_P RETURN NUMBER;
83 FUNCTION PA_UNAPPLIED_COUNT_P RETURN NUMBER;
84 FUNCTION PA_UNIDENTIFIED_COUNT_P RETURN NUMBER;
85 FUNCTION PA_MISC_COUNT_P RETURN NUMBER;
86 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
87 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
88 FUNCTION RP_DATA_FOUND3_P RETURN VARCHAR2;
89 FUNCTION RP_DATE_RANGE_P RETURN VARCHAR2;
90 FUNCTION RP_DATA_FOUND1_P RETURN VARCHAR2;
91 FUNCTION RP_DATA_FOUND2_P RETURN VARCHAR2;
92 FUNCTION RP_ORDER_BY_P RETURN VARCHAR2;
93 END AR_ARXSOC_XMLP_PKG;
94