PACKAGE: APPS.AR_ARZACS_XMLP_PKG

Source

1 PACKAGE AR_ARZACS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARZACSS.pls 120.0 2007/12/27 14:13:20 abraghun noship $ */
3   P_GL_DATE DATE;
4 
5   LP_GL_DATE varchar2(20);
6 
7   P_CLR_REMITTED_RECEIPTS VARCHAR2(1);
8 
9   P_CLR_DISC_RECEIPTS VARCHAR2(1);
10 
11   P_CLEAR_DATE DATE;
12 
13   LP_CLEAR_DATE varchar2(20);
14 
15   P_REMITTANCE_BANK_ID NUMBER;
16 
17   P_REMITTANCE_BANK_ACCOUNT_ID NUMBER;
18 
19   P_PAYMENT_METHOD_ID NUMBER;
20 
21   P_RECEIPT_NUMBER_LOW VARCHAR2(30);
22 
23   P_RECEIPT_NUMBER_HIGH VARCHAR2(30);
24 
25   P_CUSTOMER_NAME_LOW VARCHAR2(50);
26 
27   P_CUSTOMER_NAME_HIGH VARCHAR2(50);
28 
29   P_CUSTOMER_NUMBER_LOW VARCHAR2(30);
30 
31   P_CUSTOMER_NUMBER_HIGH VARCHAR2(30);
32 
33   P_ELIMINATE_BANK_RISK VARCHAR2(1);
34 
35   P_EXCHANGE_RATE_TYPE VARCHAR2(30);
36 
37   P_CONC_REQUEST_ID VARCHAR2(32767);
38 
39   P_NLS_CLR_REM_REC VARCHAR2(80);
40 
41   P_NLS_CLR_DISC_REC VARCHAR2(80);
42 
43   P_NLS_ELI_BANK_RISK VARCHAR2(80);
44 
45   P_BATCH_ID NUMBER;
46 
47   P_UNDO_CLEARING VARCHAR2(32767);
48 
49   P_BATCH_NAME VARCHAR2(32767);
50 
51   P_BR_TRANSACTION_TYPE VARCHAR2(32767);
52 
53   P_BR_EFFECTIVE_DATE DATE;
54 
55   P_BR_GL_DATE_FROM DATE;
56 
57   P_BR_GL_DATE_TO DATE;
58 
59   P_BR_MATURITY_DATE_FROM DATE;
60 
61   P_BR_MATURITY_DATE_TO DATE;
62 
63   P_BR_INCLUDE_FACTORED VARCHAR2(1);
64 
65   P_BR_INCLUDE_REMITTED VARCHAR2(1);
66 
67   P_BR_INCLUDE_ENDORSED VARCHAR2(1);
68 
69   P_BR_REPORT VARCHAR2(3);
70 
71   P_NLS_BR_INCLUDE_ENDORSED VARCHAR2(80);
72 
73   P_NLS_BR_INCLUDE_FACTORED VARCHAR2(80);
74 
75   P_NLS_BR_INCLUDE_REMITTED VARCHAR2(32767);
76 
77   P_NLS_BR_REPORT VARCHAR2(80) := 'N';
78 
79   SET_OF_BOOKS_ID VARCHAR2(40);
80 
81   P_AUTO_CLEAR_RECEIPTS VARCHAR2(1000);
82 
83   C_REC1 NUMBER := 1;
84 
85   FUNC_CURRENCY_CODE VARCHAR2(15);
86 
87   COMPANY_NAME VARCHAR2(30);
88 
89   C_NLS_YES VARCHAR2(80);
90 
91   C_NLS_NO VARCHAR2(80);
92 
93   C_PAYMENT_METHOD_NAME VARCHAR2(30);
94 
95   C_REMITTANCE_BANK_ACC_NAME VARCHAR2(80);
96 
97   C_REMITTANCE_BATCH_NAME VARCHAR2(20);
98 
99   MAX_CRH_ID NUMBER;
100 
101   FUNCTION BEFOREREPORT RETURN BOOLEAN;
102 
103   FUNCTION AFTERREPORT RETURN BOOLEAN;
104 
105   FUNCTION BEFOREPFORM RETURN BOOLEAN;
106 
107   FUNCTION CF_TRANS_TYPEFORMULA RETURN CHAR;
108 
109   FUNCTION CF_BR_DATE_DISPFORMULA(BR_DATE IN DATE) RETURN CHAR;
110 
111   FUNCTION AFTERPFORM RETURN BOOLEAN;
112 
113   FUNCTION C_REC1_P RETURN NUMBER;
114 
115   FUNCTION FUNC_CURRENCY_CODE_P RETURN VARCHAR2;
116 
117   FUNCTION COMPANY_NAME_P RETURN VARCHAR2;
118 
119   FUNCTION C_NLS_YES_P RETURN VARCHAR2;
120 
121   FUNCTION C_NLS_NO_P RETURN VARCHAR2;
122 
123   FUNCTION C_PAYMENT_METHOD_NAME_P RETURN VARCHAR2;
124 
125   FUNCTION C_REMITTANCE_BANK_ACC_NAME_P RETURN VARCHAR2;
126 
127   FUNCTION C_REMITTANCE_BATCH_NAME_P RETURN VARCHAR2;
128 
129   FUNCTION MAX_CRH_ID_P RETURN NUMBER;
130 
131   PROCEDURE GET_SET_OF_BOOKS;
132 
133   PROCEDURE GET_PAYMENT_METHOD;
134 
135   PROCEDURE GET_REMITTANCE_BANK_ACCOUNT;
136 
137   PROCEDURE GET_BATCH_DETAILS;
138 
139   PROCEDURE GET_MAX_CHR;
140 
141   PROCEDURE POPULATE_YES_FIELD;
142 
143   PROCEDURE POPULATE_NO_FIELD;
144 
145   PROCEDURE POPULATE_VARIOUS_YES_NO_FIELDS;
146 
147   PROCEDURE CHECK_AUTOMATIC_CLEARING;
148 
149   PROCEDURE BR_POPUL_VARIOUS_YES_NO_FIELDS;
150 
151   PROCEDURE BR_HOUSEKEEPER_PROGRAM;
152 
153   PROCEDURE CHECK_GL_DATE;
154 
155 END AR_ARZACS_XMLP_PKG;
156