[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