DBA Data[Home] [Help]

PACKAGE: APPS.AR_ARXRECON_XMLP_PKG

Source


1 PACKAGE AR_ARXRECON_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARXRECONS.pls 120.0 2007/12/27 14:04:28 abraghun noship $ */
3 	L_BEGIN_AS_OF	date;
4 	L_END_AS_OF	date;
5 	L_CUR	varchar2(6);
6 	P_CA_SET_OF_BOOKS_ID	number;
7 	P_CHART_OF_ACCOUNTS_ID	number;
8 	P_COMPANY_NAME	varchar2(60);
9 	P_CONC_REQUEST_ID	number;
10 	P_CO_SEG_LOW	varchar2(30);
11 	P_CO_SEG_HIGH	varchar2(30);
12 	P_FUNCTIONAL_CURRENCY	varchar2(32767);
13 	P_GL_DATE_HIGH	date;
14 	LP_GL_DATE_HIGH	varchar2(11);
15 	P_GL_DATE_LOW	date;
16 	LP_GL_DATE_LOW	varchar2(11);
17 	P_MIN_PRECISION	number;
18 	P_MRCSOBTYPE	varchar2(10);
19 	P_REPORTING_LEVEL	varchar2(30);
20 	P_REPORTING_ENTITY_ID	number;
21 	P_Potential_rec_items	varchar2(10);
22 	SO_ORGANIZATION_ID	number;
23 	P_SYSDATE	varchar2(20);
24 	P_BEGIN_AGE_AMT	number;
25 	P_BEGIN_AGE_ACCTD_AMT	number;
26 	P_BEGIN_AGE_ACCTD_AMT_DSP	varchar2(22);
27 	P_UNAPP_REG_AMT	number;
28 	P_UNAPP_REG_ACCTD_AMT	number;
29 	P_UNAPP_REG_ACCTD_AMT_DSP	varchar2(22);
30 	P_UNAPP_AMT	number;
31 	P_UNAPP_ACCTD_AMT	number;
32 	P_ACC_AMT	number;
33 	P_ACC_ACCTD_AMT	number;
34 	P_CLAIM_AMT	number;
35 	P_UNAPP_ACCTD_AMT_DSP	varchar2(22);
36 	P_ACC_ACCTD_AMT_DSP	varchar2(22);
37 	P_CLAIM_ACCTD_AMT	number;
38 	P_CLAIM_ACCTD_AMT_DSP	varchar2(22);
39 	P_PREPAY_AMT	number;
40 	P_PREPAY_ACCTD_AMT	number;
41 	P_PREPAY_ACCTD_AMT_DSP	varchar2(22);
42 	P_TRX_REG_AMT	number;
43 	P_TRX_REG_ACCTD_AMT	number;
44 	P_TRX_REG_ACCTD_AMT_DSP	varchar2(22);
45 	P_NON_POST_AMT	number;
46 	P_NON_POST_ACCTD_AMT	number;
47 	P_NON_POST_ACCTD_AMT_DSP	varchar2(22);
48 	P_POST_AMT	number;
49 	P_POST_ACCTD_AMT	number;
50 	P_POST_ACCTD_AMT_DSP	varchar2(22);
51 	P_ADJ_REG_AMT	number;
52 	P_ADJ_REG_ACCTD_AMT	number;
53 	P_ADJ_REG_ACCTD_AMT_DSP	varchar2(22);
54 	P_FIN_CHRG_AMT	number;
55 	P_FIN_CHRG_ACCTD_AMT	number;
56 	P_FIN_CHRG_ACCTD_AMT_DSP	varchar2(22);
57 	P_ADJ_AMT	number;
58 	P_ADJ_ACCTD_AMT	number;
59 	P_ADJ_ACCTD_AMT_DSP	varchar2(22);
60 	P_GUAR_AMT	number;
61 	P_GUAR_ACCTD_AMT_DSP	varchar2(22);
62 	P_GUAR_ACCTD_AMT	number;
63 	P_DEP_AMT	number;
64 	P_DEP_ACCTD_AMT	number;
65 	P_DEP_ACCTD_AMT_DSP	varchar2(22);
66 	P_ENDORSMNT_AMT	number;
67 	P_ENDORSMNT_ACCTD_AMT	number;
68 	P_ENDORSMNT_ACCTD_AMT_DSP	varchar2(22);
69 	P_CM_GAIN_LOSS	number;
70 	P_CM_GAIN_LOSS_DSP	varchar2(20);
71 	P_PERIOD_TOTAL_AMT	number;
72 	P_PERIOD_TOTAL_ACCTD_AMT	number;
73 	P_PERIOD_TOTAL_ACCTD_AMT_DSP	varchar2(22);
74 	P_AMT_DIFF	number;
75 	P_ACCTD_AMT_DIFF	number;
76 	P_ACCTD_AMT_DIFF_DSP	varchar2(20);
77 	P_END_AGE_AMT	number;
78 	P_END_AGE_ACCTD_AMT	number;
79 	P_END_AGE_ACCTD_AMT_DSP	varchar2(22);
80 	P_APP_REG_AMT	number;
81 	P_APP_REG_ACCTD_AMT	number;
82 	P_APP_REG_ACCTD_AMT_DSP	varchar2(22);
83 	P_APP_AMT	number;
84 	P_APP_ACCTD_AMT	number;
85 	P_APP_ACCTD_AMT_DSP	varchar2(22);
86 	P_EDISC_AMT	number;
87 	P_EDISC_ACCTD_AMT	number;
88 	P_UNEDISC_AMT	number;
89 	P_UNEDISC_ACCTD_AMT	number;
90 	P_EDISC_ACCTD_AMT_DSP	varchar2(22);
91 	P_UNEDISC_ACCTD_AMT_DSP	varchar2(22);
92 	P_INV_EXP_AMT	number;
93 	P_INV_EXP_ACCTD_AMT	number;
94 	P_INV_EXP_ACCTD_AMT_DSP	varchar2(22);
95 	P_POST_EXCP_AMT	number;
96 	P_POST_EXCP_ACCTD_AMT	number;
97 	P_POST_EXCP_ACCTD_AMT_DSP	varchar2(22);
98 	P_NON_POST_EXCP_AMT	number;
99 	P_NON_POST_EXCP_ACCTD_AMT	number;
100 	P_NON_POST_EXCP_ACCTD_AMT_DSP	varchar2(22);
101 	P_SALES_JOURNAL_AMT	number;
102 	P_SALES_JOURNAL_ACCTD_AMT	number;
103 	P_SALES_JOURNAL_ACCTD_AMT_DSP	varchar2(22);
104 	P_TRX_DIFF_ACCTD_AMT	number;
105 	P_TRX_DIFF_ACCTD_AMT_DSP	varchar2(22);
106 	P_ADJ_JOURNAL_AMT	number;
107 	P_ADJ_JOURNAL_ACCTD_AMT	number;
108 	P_ADJ_JOURNAL_ACCTD_AMT_DSP	varchar2(22);
109 	P_ADJ_DIFF_ACCTD_AMT	number;
110 	P_ADJ_DIFF_ACCTD_AMT_DSP	varchar2(22);
111 	P_APP_JOURNAL_AMT	number;
112 	P_APP_JOURNAL_ACCTD_AMT	number;
113 	P_APP_JOURNAL_ACCTD_AMT_DSP	varchar2(22);
114 	P_APP_DIFF_ACCTD_AMT	number;
115 	P_APP_DIFF_ACCTD_AMT_DSP	varchar2(22);
116 	P_UNAPP_JOURNAL_AMT	number;
117 	P_UNAPP_JOURNAL_ACCTD_AMT	number;
118 	P_UNAPP_JOURNAL_ACCTD_AMT_DSP	varchar2(22);
119 	P_UNAPP_DIFF_ACCTD_AMT	number;
120 	P_UNAPP_DIFF_ACCTD_AMT_DSP	varchar2(22);
121 	P_CM_JOURNAL_ACCTD_AMT	number;
122 	P_CM_JOURNAL_ACCTD_AMT_DSP	varchar2(22);
123 	P_CM_DIFF_ACCTD_AMT	number;
124 	P_CM_DIFF_ACCTD_AMT_DSP	varchar2(22);
125 	P_ORGANIZATION	varchar2(2000);
126 	P_BILLS_RECEIVABLE_FLAG	varchar2(1);
127 	rp_message	varchar2(2000);
128 	CP_ACC_MESSAGE	varchar2(2000);
129 	P_ON_ACC_CM_REF_AMT	number;
130 	P_ON_ACC_CM_REF_ACCTD_AMT	number;
131 	P_ON_ACC_CM_REF_ACCTD_AMT_DSP	varchar2(22);
132 	function CF_AR_CACL_AGINGFormula return Number  ;
133 	function BeforeReport return boolean  ;
134 	function AfterPForm return boolean  ;
135 	function CF_COMPANY_SEGMENTFormula return Char  ;
136 	function AfterReport return boolean  ;
137 	function BeforePForm return boolean  ;
138 	function P_TRX_REG_ACCTD_AMT_DSPFormula return Char  ;
139 	Function SO_ORGANIZATION_ID_p return number;
140 	Function P_SYSDATE_p return varchar2;
141 	Function P_BEGIN_AGE_AMT_p return number;
142 	Function P_BEGIN_AGE_ACCTD_AMT_p return number;
143 	Function P_BEGIN_AGE_ACCTD_AMT_DSP_p return varchar2;
144 	Function P_UNAPP_REG_AMT_p return number;
145 	Function P_UNAPP_REG_ACCTD_AMT_p return number;
146 	Function P_UNAPP_REG_ACCTD_AMT_DSP_p return varchar2;
147 	Function P_UNAPP_AMT_p return number;
148 	Function P_UNAPP_ACCTD_AMT_p return number;
149 	Function P_ACC_AMT_p return number;
150 	Function P_ACC_ACCTD_AMT_p return number;
151 	Function P_CLAIM_AMT_p return number;
152 	Function P_UNAPP_ACCTD_AMT_DSP_p return varchar2;
153 	Function P_ACC_ACCTD_AMT_DSP_p return varchar2;
154 	Function P_CLAIM_ACCTD_AMT_p return number;
155 	Function P_CLAIM_ACCTD_AMT_DSP_p return varchar2;
156 	Function P_PREPAY_AMT_p return number;
157 	Function P_PREPAY_ACCTD_AMT_p return number;
158 	Function P_PREPAY_ACCTD_AMT_DSP_p return varchar2;
159 	Function P_TRX_REG_AMT_p return number;
160 	Function P_TRX_REG_ACCTD_AMT_p return number;
161 	Function P_TRX_REG_ACCTD_AMT_DSP_p return varchar2;
162 	Function P_NON_POST_AMT_p return number;
163 	Function P_NON_POST_ACCTD_AMT_p return number;
164 	Function P_NON_POST_ACCTD_AMT_DSP_p return varchar2;
165 	Function P_POST_AMT_p return number;
166 	Function P_POST_ACCTD_AMT_p return number;
167 	Function P_POST_ACCTD_AMT_DSP_p return varchar2;
168 	Function P_ADJ_REG_AMT_p return number;
169 	Function P_ADJ_REG_ACCTD_AMT_p return number;
170 	Function P_ADJ_REG_ACCTD_AMT_DSP_p return varchar2;
171 	Function P_FIN_CHRG_AMT_p return number;
172 	Function P_FIN_CHRG_ACCTD_AMT_p return number;
173 	Function P_FIN_CHRG_ACCTD_AMT_DSP_p return varchar2;
174 	Function P_ADJ_AMT_p return number;
175 	Function P_ADJ_ACCTD_AMT_p return number;
176 	Function P_ADJ_ACCTD_AMT_DSP_p return varchar2;
177 	Function P_GUAR_AMT_p return number;
178 	Function P_GUAR_ACCTD_AMT_DSP_p return varchar2;
179 	Function P_GUAR_ACCTD_AMT_p return number;
180 	Function P_DEP_AMT_p return number;
181 	Function P_DEP_ACCTD_AMT_p return number;
182 	Function P_DEP_ACCTD_AMT_DSP_p return varchar2;
183 	Function P_ENDORSMNT_AMT_p return number;
184 	Function P_ENDORSMNT_ACCTD_AMT_p return number;
185 	Function P_ENDORSMNT_ACCTD_AMT_DSP_p return varchar2;
186 	Function P_CM_GAIN_LOSS_p return number;
187 	Function P_CM_GAIN_LOSS_DSP_p return varchar2;
188 	Function P_PERIOD_TOTAL_AMT_p return number;
189 	Function P_PERIOD_TOTAL_ACCTD_AMT_p return number;
190 	Function P_PERIOD_TOTAL_ACCTD_AMT_DSP_p return varchar2;
191 	Function P_AMT_DIFF_p return number;
192 	Function P_ACCTD_AMT_DIFF_p return number;
193 	Function P_ACCTD_AMT_DIFF_DSP_p return varchar2;
194 	Function P_END_AGE_AMT_p return number;
195 	Function P_END_AGE_ACCTD_AMT_p return number;
196 	Function P_END_AGE_ACCTD_AMT_DSP_p return varchar2;
197 	Function P_APP_REG_AMT_p return number;
198 	Function P_APP_REG_ACCTD_AMT_p return number;
199 	Function P_APP_REG_ACCTD_AMT_DSP_p return varchar2;
200 	Function P_APP_AMT_p return number;
201 	Function P_APP_ACCTD_AMT_p return number;
202 	Function P_APP_ACCTD_AMT_DSP_p return varchar2;
203 	Function P_EDISC_AMT_p return number;
204 	Function P_EDISC_ACCTD_AMT_p return number;
205 	Function P_UNEDISC_AMT_p return number;
206 	Function P_UNEDISC_ACCTD_AMT_p return number;
207 	Function P_EDISC_ACCTD_AMT_DSP_p return varchar2;
208 	Function P_UNEDISC_ACCTD_AMT_DSP_p return varchar2;
209 	Function P_INV_EXP_AMT_p return number;
210 	Function P_INV_EXP_ACCTD_AMT_p return number;
211 	Function P_INV_EXP_ACCTD_AMT_DSP_p return varchar2;
212 	Function P_POST_EXCP_AMT_p return number;
213 	Function P_POST_EXCP_ACCTD_AMT_p return number;
214 	Function P_POST_EXCP_ACCTD_AMT_DSP_p return varchar2;
215 	Function P_NON_POST_EXCP_AMT_p return number;
216 	Function P_NON_POST_EXCP_ACCTD_AMT_p return number;
217 	Function P_NON_POST_EXCP_ACCTD_AMT_f return varchar2;
218 	Function P_SALES_JOURNAL_AMT_p return number;
219 	Function P_SALES_JOURNAL_ACCTD_AMT_p return number;
220 	Function P_SALES_JOURNAL_ACCTD_AMT_f return varchar2;
221 	Function P_TRX_DIFF_ACCTD_AMT_p return number;
222 	Function P_TRX_DIFF_ACCTD_AMT_DSP_p return varchar2;
223 	Function P_ADJ_JOURNAL_AMT_p return number;
224 	Function P_ADJ_JOURNAL_ACCTD_AMT_p return number;
225 	Function P_ADJ_JOURNAL_ACCTD_AMT_DSP_p return varchar2;
226 	Function P_ADJ_DIFF_ACCTD_AMT_p return number;
227 	Function P_ADJ_DIFF_ACCTD_AMT_DSP_p return varchar2;
228 	Function P_APP_JOURNAL_AMT_p return number;
229 	Function P_APP_JOURNAL_ACCTD_AMT_p return number;
230 	Function P_APP_JOURNAL_ACCTD_AMT_DSP_p return varchar2;
231 	Function P_APP_DIFF_ACCTD_AMT_p return number;
232 	Function P_APP_DIFF_ACCTD_AMT_DSP_p return varchar2;
233 	Function P_UNAPP_JOURNAL_AMT_p return number;
234 	Function P_UNAPP_JOURNAL_ACCTD_AMT_p return number;
235 	Function P_UNAPP_JOURNAL_ACCTD_AMT_f return varchar2;
236 	Function P_UNAPP_DIFF_ACCTD_AMT_p return number;
237 	Function P_UNAPP_DIFF_ACCTD_AMT_DSP_p return varchar2;
238 	Function P_CM_JOURNAL_ACCTD_AMT_p return number;
239 	Function P_CM_JOURNAL_ACCTD_AMT_DSP_p return varchar2;
240 	Function P_CM_DIFF_ACCTD_AMT_p return number;
241 	Function P_CM_DIFF_ACCTD_AMT_DSP_p return varchar2;
242 	Function P_ORGANIZATION_p return varchar2;
243 	Function P_BILLS_RECEIVABLE_FLAG_p return varchar2;
244 	Function rp_message_p return varchar2;
245 	Function CP_ACC_MESSAGE_p return varchar2;
246 	Function P_ON_ACC_CM_REF_AMT_p return number;
247 	Function P_ON_ACC_CM_REF_ACCTD_AMT_p return number;
248 	Function P_ON_ACC_CM_REF_ACCTD_AMT_f return varchar2;
249 	function F_ACC_MESSAGEFormatTrigger return char;
250 END AR_ARXRECON_XMLP_PKG;
251