[Home] [Help]
PACKAGE BODY: APPS.AR_ARXRECON_XMLP_PKG
Source
1 PACKAGE BODY AR_ARXRECON_XMLP_PKG AS
2 /* $Header: ARXRECONB.pls 120.0 2007/12/27 14:03:59 abraghun noship $ */
3 function CF_AR_CACL_AGINGFormula return Number is
4 l_begin_age_amt number;
5 l_begin_age_acctd_amt number;
6 l_end_age_amt number;
7 l_end_age_acctd_amt number;
8 l_fin_chrg_amt number;
9 l_fin_chrg_acctd_amt number;
10 l_adj_amt number;
11 l_adj_acctd_amt number;
12 l_guar_amt number;
13 l_guar_acctd_amt number;
14 l_dep_amt number;
15 l_dep_acctd_amt number;
16 l_endorsmnt_amt number;
17 l_endorsmnt_acctd_amt number;
18 l_non_post_amt number;
19 l_non_post_acctd_amt number;
20 l_post_amt number;
21 l_post_acctd_amt number;
22 l_unapp_amt number;
23 l_unapp_acctd_amt number;
24 l_acc_amt number;
25 l_acc_acctd_amt number;
26 l_claim_amt number;
27 l_claim_acctd_amt number;
28 l_prepay_amt number;
29 l_prepay_acctd_amt number;
30 l_app_amt number;
31 l_app_acctd_amt number;
32 l_edisc_amt number;
33 l_edisc_acctd_amt number;
34 l_unedisc_amt number;
35 l_unedisc_acctd_amt number;
36 l_cm_gain_loss number;
37 l_post_excp_amt number;
38 l_post_excp_acctd_amt number;
39 l_nonpost_excp_amt number;
40 l_nonpost_excp_acctd_amt number;
41 l_period_total_amt number;
42 l_period_total_acctd_amt number;
43 l_recon_diff_amt number;
44 l_recon_diff_acctd_amt number;
45 l_sales_journal_amt number;
46 l_sales_journal_acctd_amt number;
47 l_adj_journal_amt number;
48 l_adj_journal_acctd_amt number;
49 l_app_journal_amt number;
50 l_app_journal_acctd_amt number;
51 l_unapp_journal_amt number;
52 l_unapp_journal_acctd_amt number;
53 l_cm_journal_acctd_amt number;
54 l_on_acc_cm_ref_amt number;
55 l_on_acc_cm_ref_acctd_amt number;
56 begin
57 /*srw.reference(p_company_name);*/null;
58 /*srw.reference(p_functional_currency);*/null;
59 /*srw.reference(p_min_precision);*/null;
60 /*srw.reference(p_gl_date_low);*/null;
61 /*srw.reference(p_gl_date_high);*/null;
62 /*srw.reference(l_begin_as_of);*/null;
63 /*srw.reference(l_end_as_of);*/null;
64 /*srw.reference(p_chart_of_accounts_id);*/null;
65 /*srw.reference(p_co_seg_low);*/null;
66 /*srw.reference(p_co_seg_high);*/null;
67 /*srw.reference(p_reporting_level);*/null;
68 /*srw.reference(p_reporting_entity_id);*/null;
69 /*srw.reference(p_ca_set_of_books_id);*/null;
70 ar_calc_aging.get_report_heading (p_reporting_level,
71 p_reporting_entity_id,
72 p_ca_set_of_books_id,
73 p_company_name,
74 p_functional_currency,
75 p_chart_of_accounts_id,
76 p_min_precision,
77 p_sysdate,
78 p_organization,
79 p_bills_receivable_flag);
80 l_begin_as_of := nvl(p_gl_date_low, TRUNC(sysdate) ) -1;
81 l_end_as_of:= nvl(p_gl_date_high, TRUNC(sysdate)) ;
82 ar_calc_aging.aging_as_of (l_begin_as_of ,
83 l_end_as_of,
84 p_reporting_level,
85 p_reporting_entity_id,
86 p_co_seg_low,
87 p_co_seg_high,
88 p_chart_of_accounts_id,
89 l_begin_age_amt,
90 l_end_age_amt,
91 l_begin_age_acctd_amt,
92 l_end_age_acctd_amt);
93 p_begin_age_amt := l_begin_age_amt ;
94 p_begin_age_acctd_amt := l_begin_age_acctd_amt ;
95 p_end_age_amt := l_end_age_amt;
96 p_end_age_acctd_amt := l_end_age_acctd_amt;
97 ar_calc_aging.transaction_register(p_gl_date_low ,
98 p_gl_date_high ,
99 p_reporting_level,
100 p_reporting_entity_id,
101 p_co_seg_low,
102 p_co_seg_high,
103 p_chart_of_accounts_id,
104 l_non_post_amt,
105 l_non_post_acctd_amt,
106 l_post_amt,
107 l_post_acctd_amt);
108 p_non_post_amt := nvl(l_non_post_amt,0);
109 p_non_post_acctd_amt := nvl(l_non_post_acctd_amt,0);
110 p_post_amt := nvl(l_post_amt,0);
111 p_post_acctd_amt := nvl(l_post_acctd_amt,0);
112 p_trx_reg_amt := nvl(l_post_amt ,0)+
113 nvl(l_non_post_amt,0);
114 p_trx_reg_acctd_amt := nvl(l_post_acctd_amt,0)+
115 nvl(l_non_post_acctd_amt,0);
116 ar_calc_aging.cash_receipts_register(p_gl_date_low,
117 p_gl_date_high,
118 p_reporting_level,
119 p_reporting_entity_id,
120 p_co_seg_low,
121 p_co_seg_high,
122 p_chart_of_accounts_id,
123 l_unapp_amt,
124 l_unapp_acctd_amt,
125 l_acc_amt,
126 l_acc_acctd_amt,
127 l_claim_amt,
128 l_claim_acctd_amt,
129 l_prepay_amt,
130 l_prepay_acctd_amt,
131 l_app_amt,
132 l_app_acctd_amt,
133 l_edisc_amt,
134 l_edisc_acctd_amt,
135 l_unedisc_amt,
136 l_unedisc_acctd_amt,
137 l_cm_gain_loss,
138 l_on_acc_cm_ref_amt,
139 l_on_acc_cm_ref_acctd_amt );
140 p_unapp_amt := nvl(l_unapp_amt,0);
141 p_unapp_acctd_amt := nvl(l_unapp_acctd_amt,0);
142 p_acc_amt := nvl(l_acc_amt,0);
143 p_acc_acctd_amt := nvl(l_acc_acctd_amt,0);
144 p_claim_amt := nvl(l_claim_amt,0);
145 p_claim_acctd_amt := nvl(l_claim_acctd_amt,0);
146 p_prepay_amt := nvl(l_prepay_amt,0);
147 p_prepay_acctd_amt := nvl(l_prepay_acctd_amt,0);
148 p_app_amt := nvl(l_app_amt,0);
149 p_app_acctd_amt := nvl(l_app_acctd_amt,0);
150 p_edisc_amt := nvl(l_edisc_amt,0);
151 p_edisc_acctd_amt := nvl(l_edisc_acctd_amt,0);
152 p_unedisc_amt := nvl(l_unedisc_amt,0);
153 p_unedisc_acctd_amt := nvl(l_unedisc_acctd_amt,0);
154 p_on_acc_cm_ref_amt := nvl(l_on_acc_cm_ref_amt,0);
155 p_on_acc_cm_ref_acctd_amt := nvl(l_on_acc_cm_ref_acctd_amt,0);
156 p_unapp_reg_amt := nvl(l_unapp_amt,0) +
157 nvl(l_acc_amt,0) +
158 nvl(l_claim_amt,0) +
159 nvl(l_prepay_amt,0);
160 p_unapp_reg_acctd_amt := nvl(l_unapp_acctd_amt,0) +
161 nvl(l_acc_acctd_amt,0) +
162 nvl(l_claim_acctd_amt,0) +
163 nvl(l_prepay_acctd_amt,0);
164 p_app_reg_amt := nvl(l_app_amt,0) +
165 nvl(l_edisc_amt,0) +
166 nvl(l_unedisc_amt,0);
167 p_app_reg_acctd_amt := nvl(l_app_acctd_amt,0) +
168 nvl(l_edisc_acctd_amt,0) +
169 nvl(l_unedisc_acctd_amt,0);
170 p_cm_gain_loss := nvl(l_cm_gain_loss,0) ;
171 ar_calc_aging.adjustment_register(p_gl_date_low,
172 p_gl_date_high,
173 p_reporting_level,
174 p_reporting_entity_id,
175 p_co_seg_low,
176 p_co_seg_high,
177 p_chart_of_accounts_id,
178 l_fin_chrg_amt,
179 l_fin_chrg_acctd_amt,
180 l_adj_amt,
181 l_adj_acctd_amt,
182 l_guar_amt,
183 l_guar_acctd_amt,
184 l_dep_amt,
185 l_dep_acctd_amt,
186 l_endorsmnt_amt,
187 l_endorsmnt_acctd_amt);
188 p_fin_chrg_amt := nvl(l_fin_chrg_amt,0);
189 p_fin_chrg_acctd_amt := nvl(l_fin_chrg_acctd_amt,0);
190 p_adj_amt := nvl(l_adj_amt,0);
191 p_adj_acctd_amt := nvl(l_adj_acctd_amt,0);
192 p_guar_amt := nvl(l_guar_amt,0);
193 p_guar_acctd_amt := nvl(l_guar_acctd_amt,0);
194 p_dep_amt := nvl(l_dep_amt,0);
195 p_dep_acctd_amt := nvl(l_dep_acctd_amt,0);
196 p_endorsmnt_amt := nvl(l_endorsmnt_amt,0);
197 p_endorsmnt_acctd_amt := nvl(l_endorsmnt_acctd_amt,0);
198 p_adj_reg_amt := nvl(l_fin_chrg_amt,0) +
199 nvl(l_adj_amt,0) +
200 nvl(l_guar_amt,0) +
201 nvl(l_dep_amt,0) +
202 nvl(l_endorsmnt_amt,0) ;
203 p_adj_reg_acctd_amt := nvl(l_fin_chrg_acctd_amt,0) +
204 nvl(l_adj_acctd_amt,0) +
205 nvl(l_guar_acctd_amt,0) +
206 nvl(l_dep_acctd_amt,0) +
207 nvl(l_endorsmnt_acctd_amt,0);
208 ar_calc_aging.invoice_exceptions(p_gl_date_low,
209 p_gl_date_high,
210 p_reporting_level,
211 p_reporting_entity_id,
212 p_co_seg_low,
213 p_co_seg_high,
214 p_chart_of_accounts_id,
215 l_post_excp_amt,
216 l_post_excp_acctd_amt,
217 l_nonpost_excp_amt,
218 l_nonpost_excp_acctd_amt);
219 p_post_excp_amt := nvl(l_post_excp_amt,0);
220 p_post_excp_acctd_amt := nvl(l_post_excp_acctd_amt,0);
221 p_non_post_excp_amt := nvl(l_nonpost_excp_amt,0);
222 p_non_post_excp_acctd_amt := nvl(l_nonpost_excp_acctd_amt,0);
223 p_inv_exp_amt := nvl(l_post_excp_amt,0) +
224 nvl(l_nonpost_excp_amt,0);
225 p_inv_exp_acctd_amt := nvl(l_post_excp_acctd_amt,0) +
226 nvl(l_nonpost_excp_acctd_amt,0);
227 p_period_total_amt := p_begin_age_amt
228 + p_trx_reg_amt
229 - p_app_reg_amt
230 - p_unapp_reg_amt
231 + p_adj_reg_amt
232 - p_inv_exp_amt
233 + p_on_acc_cm_ref_amt;
234 p_period_total_acctd_amt := p_begin_age_acctd_amt
235 + p_trx_reg_acctd_amt
236 - p_app_reg_acctd_amt
237 - p_unapp_reg_acctd_amt
238 + p_adj_reg_acctd_amt
239 - p_inv_exp_acctd_amt
240 + p_cm_gain_loss
241 + p_on_acc_cm_ref_acctd_amt;
242 p_amt_diff := NVL(p_period_total_amt - p_end_age_amt , 0 );
243 p_acctd_amt_diff := nvl(p_period_total_acctd_amt - p_end_age_acctd_amt , 0);
244 ar_calc_aging.journal_reports (p_gl_date_low,
245 p_gl_date_high,
246 p_reporting_level,
247 p_reporting_entity_id,
248 p_co_seg_low,
249 p_co_seg_high,
250 p_chart_of_accounts_id,
251 l_sales_journal_amt,
252 l_sales_journal_acctd_amt,
253 l_adj_journal_amt,
254 l_adj_journal_acctd_amt,
255 l_app_journal_amt,
256 l_app_journal_acctd_amt,
257 l_unapp_journal_amt,
258 l_unapp_journal_acctd_amt,
259 l_cm_journal_acctd_amt);
260 p_sales_journal_amt := nvl(l_sales_journal_amt,0);
261 p_sales_journal_acctd_amt := nvl(l_sales_journal_acctd_amt,0);
265 p_app_journal_acctd_amt := nvl(l_app_journal_acctd_amt,0);
262 p_adj_journal_amt := nvl(l_adj_journal_amt,0);
263 p_adj_journal_acctd_amt := nvl(l_adj_journal_acctd_amt,0);
264 p_app_journal_amt := nvl(l_app_journal_amt,0);
266 p_unapp_journal_amt := nvl(l_unapp_journal_amt,0);
267 p_unapp_journal_acctd_amt := nvl(l_unapp_journal_acctd_amt,0);
268 p_cm_journal_acctd_amt := nvl(l_cm_journal_acctd_amt,0);
269 p_trx_diff_acctd_amt := nvl(p_post_acctd_amt,0) -
270 nvl(p_sales_journal_acctd_amt,0);
271 p_adj_diff_acctd_amt := nvl(p_adj_journal_acctd_amt,0) -
272 nvl(p_adj_reg_acctd_amt,0);
273 p_app_diff_acctd_amt := nvl(p_app_reg_acctd_amt,0) -
274 nvl(p_app_journal_acctd_amt,0);
275 p_unapp_diff_acctd_amt := nvl(p_unapp_reg_acctd_amt,0) -
276 nvl(p_unapp_journal_acctd_amt,0);
277 p_cm_diff_acctd_amt := nvl(p_cm_gain_loss,0)-
278 nvl(p_cm_journal_acctd_amt,0);
279 return (1);
280 RETURN NULL; EXCEPTION
281 WHEN NO_DATA_FOUND THEN
282 /*srw.message('100', 'No Data found.');*/null;
283 RETURN NULL; WHEN OTHERS THEN
284 /*srw.message('100', sqlerrm);*/null;
285 RETURN NULL; end;
286 function BeforeReport return boolean is
287 l_ld_sp varchar2(1);
288 begin
289 /*SRW.USER_EXIT('FND SRWINIT');*/null;
290 arp_util.debug('Before Report');
291 LP_GL_DATE_HIGH := to_char(P_GL_DATE_HIGH, 'DD-MON-YYYY');
292 LP_GL_DATE_LOW := to_char(P_GL_DATE_LOW, 'DD-MON-YYYY');
293 rp_message:=null;
294 IF to_number(p_reporting_level) = 1000 THEN
295 l_ld_sp:= mo_utils.check_ledger_in_sp(TO_NUMBER(p_reporting_entity_id));
296 IF l_ld_sp = 'N' THEN
297 FND_MESSAGE.SET_NAME('FND','FND_MO_RPT_PARTIAL_LEDGER');
298 rp_message := FND_MESSAGE.get;
299 END IF;
300 END IF;
301 FND_MESSAGE.SET_NAME('AR','AR_REPORT_ACC_NOT_GEN');
302 cp_acc_message := FND_MESSAGE.get;
303 ar_calc_aging.initialize;
304 arp_util.debug('End of Before Report');
305 return (TRUE);
306 end;
307 function AfterPForm return boolean is
308 begin
309 /*SRW.USER_EXIT('FND SRWINIT');*/null;
310 /*srw.reference(p_reporting_level);*/null;
311 /*srw.reference(p_reporting_entity_id);*/null;
312 IF p_reporting_level = 3000 THEN
313 select set_of_books_id
314 into p_ca_set_of_books_id
315 from ar_system_parameters_all
316 where org_id = p_reporting_entity_id;
317 ELSIF p_reporting_level = 1000 THEN
318 p_ca_set_of_books_id := p_reporting_entity_id;
319 END IF;
320 return (TRUE);
321 end;
322 function CF_COMPANY_SEGMENTFormula return Char is
323 l_co_seg VARCHAR2(70);
324 begin
325 /*srw.reference(p_co_seg_low);*/null;
326 /*srw.reference(p_co_seg_high);*/null;
327 IF p_co_seg_low IS NULL AND p_co_seg_high IS NULL THEN
328 select meaning into l_co_seg
329 from ar_lookups
330 where lookup_type = 'ALL'
331 and lookup_code = 'ALL';
332 ELSIF p_co_seg_low IS NULL THEN
333 l_co_seg := '<= '||p_co_seg_high;
334 ELSIF p_co_seg_high IS NULL THEN
335 l_co_seg := '>= '||p_co_seg_low;
336 ELSIF p_co_seg_low = p_co_seg_high THEN
337 l_co_seg := p_co_seg_low;
338 ELSE
339 l_co_seg := p_co_seg_low||' to '||p_co_seg_high;
340 END IF;
341 Return l_co_seg;
342 end;
343 function AfterReport return boolean is
344 l_request_id number;
345 begin
346 /*SRW.USER_EXIT('FND SRWINIT');*/null;
347 arp_util.debug('Begin of After Report');
348 IF p_potential_rec_items = 'Y' THEN
349 /*srw.message('1001','p_bal_high '||p_co_seg_high);*/null;
350 /*srw.message('1001','p_bal_low '||p_co_seg_low);*/null;
351 /*srw.message('1001','p_ca_set_of_books_id '||p_ca_set_of_books_id);*/null;
352 /*srw.message('1001','p_coaid '||p_chart_of_accounts_id);*/null;
353 /*srw.message('1001','p_gl_date_high '||p_gl_date_high);*/null;
354 /*srw.message('1001','p_gl_date_low '||p_gl_date_low);*/null;
355 /*srw.message('1001','p_min_precision '||p_min_precision);*/null;
356 /*srw.message('1001','p_mrc_sobtype '||p_mrcsobtype);*/null;
357 /*srw.message('1001','p_reporting_entity_id '||to_char(p_reporting_entity_id));*/null;
358 /*srw.message('1001','p_reporting_level '||p_reporting_level);*/null;
359 l_request_id := FND_REQUEST.SUBMIT_REQUEST(application=>'AR',
360 program=>'ARXPIREP_XML',
361 description=>'',
362 start_time=>'',
363 sub_request=>FALSE,
364 argument1=>'P_BAL_HIGH='||P_CO_SEG_HIGH,
365 argument2=>'P_BAL_LOW='||p_co_seg_low,
366 argument3=>'P_CA_SET_OF_BOOKS_ID='||p_ca_set_of_books_id,
367 argument4=>'P_COAID='||p_chart_of_accounts_id,
368 argument5=>'P_CURRENCY_CODE='||'All',
369 argument6=>'P_HIGH_DATE='||to_char(p_gl_date_high,'YYYY/MM/DD HH24:MI:SS'),
370 argument7=>'P_LOW_DATE='||to_char(p_gl_date_low,'YYYY/MM/DD HH24:MI:SS'),
371 argument8=>'P_MIN_PRECISION='||p_min_precision,
372 argument9=>'P_MRCSOBTYPE='||p_mrcsobtype,
373 argument10=>'P_REPORTING_ENTITY_ID='||to_char(p_reporting_entity_id),
374 argument11=>'P_REPORTING_LEVEL='||p_reporting_level,
375 argument12=>'',
376 argument13=>'',
377 argument14=>'',
378 argument15=>'',
379 argument16=>'',
380 argument17=>'',
381 argument18=>'',
382 argument19=>'',
383 argument20=>'',
384 argument21=>'',
385 argument22=>'',
386 argument23=>'',
387 argument24=>'',
388 argument25=>'',
389 argument26=>'',
390 argument27=>'',
391 argument28=>'',
392 argument29=>'',
393 argument30=>'',
394 argument31=>'',
395 argument32=>'',
396 argument33=>'',
400 argument37=>'',
397 argument34=>'',
398 argument35=>'',
399 argument36=>'',
401 argument38=>'',
402 argument39=>'',
403 argument40=>'',
404 argument41=>'',
405 argument42=>'',
406 argument43=>'',
407 argument44=>'',
408 argument45=>'',
409 argument46=>'',
410 argument47=>'',
411 argument48=>'',
412 argument49=>'',
413 argument50=>'',
414 argument51=>'',
415 argument52=>'',
416 argument53=>'',
417 argument54=>'',
418 argument55=>'',
419 argument56=>'',
420 argument57=>'',
421 argument58=>'',
422 argument59=>'',
423 argument60=>'',
424 argument61=>'',
425 argument62=>'',
426 argument63=>'',
427 argument64=>'',
428 argument65=>'',
429 argument66=>'',
430 argument67=>'',
431 argument68=>'',
432 argument69=>'',
433 argument70=>'',
434 argument71=>'',
435 argument72=>'',
436 argument73=>'',
437 argument74=>'',
438 argument75=>'',
439 argument76=>'',
440 argument77=>'',
441 argument78=>'',
442 argument79=>'',
443 argument80=>'',
444 argument81=>'',
445 argument82=>'',
446 argument83=>'',
447 argument84=>'',
448 argument85=>'',
449 argument86=>'',
450 argument87=>'',
451 argument88=>'',
452 argument89=>'',
453 argument90=>'',
454 argument91=>'',
455 argument92=>'',
456 argument93=>'',
457 argument94=>'',
458 argument95=>'',
459 argument96=>'',
460 argument97=>'',
461 argument98=>'',
462 argument99=>'',
463 argument100=>'');
464 Commit;
465 /*srw.message('100', 'Request id ' || l_request_id);*/null;
466 IF l_request_id = 0 THEN
467 /*srw.message(100,' FAILED to submit the Potential Reconciling Items Report ' );*/null;
468 ELSE
469 /*srw.message(100,'Potential Reconciling Items Report has been succesfully submitted');*/null;
470 END IF;
471 END IF;
472 /*SRW.USER_EXIT('FND SRWEXIT');*/null;
473 return TRUE;
474 end;
475 function BeforePForm return boolean is
476 begin
477 return (TRUE);
478 end;
479 function P_TRX_REG_ACCTD_AMT_DSPFormula return Char is
480 begin
481 return 0;
482 end;
483 --Functions to refer Oracle report placeholders--
484 Function SO_ORGANIZATION_ID_p return number is
485 Begin
486 return SO_ORGANIZATION_ID;
487 END;
488 Function P_SYSDATE_p return varchar2 is
489 Begin
490 return P_SYSDATE;
491 END;
492 Function P_BEGIN_AGE_AMT_p return number is
493 Begin
494 return P_BEGIN_AGE_AMT;
495 END;
496 Function P_BEGIN_AGE_ACCTD_AMT_p return number is
497 Begin
498 return P_BEGIN_AGE_ACCTD_AMT;
499 END;
500 Function P_BEGIN_AGE_ACCTD_AMT_DSP_p return varchar2 is
501 Begin
502 return P_BEGIN_AGE_ACCTD_AMT_DSP;
503 END;
504 Function P_UNAPP_REG_AMT_p return number is
505 Begin
506 return P_UNAPP_REG_AMT;
507 END;
508 Function P_UNAPP_REG_ACCTD_AMT_p return number is
509 Begin
510 return P_UNAPP_REG_ACCTD_AMT;
511 END;
512 Function P_UNAPP_REG_ACCTD_AMT_DSP_p return varchar2 is
513 Begin
514 return P_UNAPP_REG_ACCTD_AMT_DSP;
515 END;
516 Function P_UNAPP_AMT_p return number is
517 Begin
518 return P_UNAPP_AMT;
519 END;
520 Function P_UNAPP_ACCTD_AMT_p return number is
521 Begin
522 return P_UNAPP_ACCTD_AMT;
523 END;
524 Function P_ACC_AMT_p return number is
525 Begin
526 return P_ACC_AMT;
527 END;
528 Function P_ACC_ACCTD_AMT_p return number is
529 Begin
530 return P_ACC_ACCTD_AMT;
531 END;
532 Function P_CLAIM_AMT_p return number is
533 Begin
534 return P_CLAIM_AMT;
535 END;
536 Function P_UNAPP_ACCTD_AMT_DSP_p return varchar2 is
537 Begin
538 return P_UNAPP_ACCTD_AMT_DSP;
539 END;
540 Function P_ACC_ACCTD_AMT_DSP_p return varchar2 is
541 Begin
542 return P_ACC_ACCTD_AMT_DSP;
543 END;
544 Function P_CLAIM_ACCTD_AMT_p return number is
545 Begin
546 return P_CLAIM_ACCTD_AMT;
547 END;
548 Function P_CLAIM_ACCTD_AMT_DSP_p return varchar2 is
549 Begin
550 return P_CLAIM_ACCTD_AMT_DSP;
551 END;
552 Function P_PREPAY_AMT_p return number is
553 Begin
554 return P_PREPAY_AMT;
555 END;
556 Function P_PREPAY_ACCTD_AMT_p return number is
557 Begin
558 return P_PREPAY_ACCTD_AMT;
559 END;
560 Function P_PREPAY_ACCTD_AMT_DSP_p return varchar2 is
561 Begin
562 return P_PREPAY_ACCTD_AMT_DSP;
563 END;
564 Function P_TRX_REG_AMT_p return number is
565 Begin
566 return P_TRX_REG_AMT;
567 END;
568 Function P_TRX_REG_ACCTD_AMT_p return number is
569 Begin
570 return P_TRX_REG_ACCTD_AMT;
571 END;
572 Function P_TRX_REG_ACCTD_AMT_DSP_p return varchar2 is
573 Begin
574 return P_TRX_REG_ACCTD_AMT_DSP;
575 END;
576 Function P_NON_POST_AMT_p return number is
577 Begin
578 return P_NON_POST_AMT;
579 END;
580 Function P_NON_POST_ACCTD_AMT_p return number is
581 Begin
582 return P_NON_POST_ACCTD_AMT;
583 END;
584 Function P_NON_POST_ACCTD_AMT_DSP_p return varchar2 is
585 Begin
586 return P_NON_POST_ACCTD_AMT_DSP;
587 END;
588 Function P_POST_AMT_p return number is
589 Begin
590 return P_POST_AMT;
591 END;
592 Function P_POST_ACCTD_AMT_p return number is
593 Begin
597 Begin
594 return P_POST_ACCTD_AMT;
595 END;
596 Function P_POST_ACCTD_AMT_DSP_p return varchar2 is
598 return P_POST_ACCTD_AMT_DSP;
599 END;
600 Function P_ADJ_REG_AMT_p return number is
601 Begin
602 return P_ADJ_REG_AMT;
603 END;
604 Function P_ADJ_REG_ACCTD_AMT_p return number is
605 Begin
606 return P_ADJ_REG_ACCTD_AMT;
607 END;
608 Function P_ADJ_REG_ACCTD_AMT_DSP_p return varchar2 is
609 Begin
610 return P_ADJ_REG_ACCTD_AMT_DSP;
611 END;
612 Function P_FIN_CHRG_AMT_p return number is
613 Begin
614 return P_FIN_CHRG_AMT;
615 END;
616 Function P_FIN_CHRG_ACCTD_AMT_p return number is
617 Begin
618 return P_FIN_CHRG_ACCTD_AMT;
619 END;
620 Function P_FIN_CHRG_ACCTD_AMT_DSP_p return varchar2 is
621 Begin
622 return P_FIN_CHRG_ACCTD_AMT_DSP;
623 END;
624 Function P_ADJ_AMT_p return number is
625 Begin
626 return P_ADJ_AMT;
627 END;
628 Function P_ADJ_ACCTD_AMT_p return number is
629 Begin
630 return P_ADJ_ACCTD_AMT;
631 END;
632 Function P_ADJ_ACCTD_AMT_DSP_p return varchar2 is
633 Begin
634 return P_ADJ_ACCTD_AMT_DSP;
635 END;
636 Function P_GUAR_AMT_p return number is
637 Begin
638 return P_GUAR_AMT;
639 END;
640 Function P_GUAR_ACCTD_AMT_DSP_p return varchar2 is
641 Begin
642 return P_GUAR_ACCTD_AMT_DSP;
643 END;
644 Function P_GUAR_ACCTD_AMT_p return number is
645 Begin
646 return P_GUAR_ACCTD_AMT;
647 END;
648 Function P_DEP_AMT_p return number is
649 Begin
650 return P_DEP_AMT;
651 END;
652 Function P_DEP_ACCTD_AMT_p return number is
653 Begin
654 return P_DEP_ACCTD_AMT;
655 END;
656 Function P_DEP_ACCTD_AMT_DSP_p return varchar2 is
657 Begin
658 return P_DEP_ACCTD_AMT_DSP;
659 END;
660 Function P_ENDORSMNT_AMT_p return number is
661 Begin
662 return P_ENDORSMNT_AMT;
663 END;
664 Function P_ENDORSMNT_ACCTD_AMT_p return number is
665 Begin
666 return P_ENDORSMNT_ACCTD_AMT;
667 END;
668 Function P_ENDORSMNT_ACCTD_AMT_DSP_p return varchar2 is
669 Begin
670 return P_ENDORSMNT_ACCTD_AMT_DSP;
671 END;
672 Function P_CM_GAIN_LOSS_p return number is
673 Begin
674 return P_CM_GAIN_LOSS;
675 END;
676 Function P_CM_GAIN_LOSS_DSP_p return varchar2 is
677 Begin
678 return P_CM_GAIN_LOSS_DSP;
679 END;
680 Function P_PERIOD_TOTAL_AMT_p return number is
681 Begin
682 return P_PERIOD_TOTAL_AMT;
683 END;
684 Function P_PERIOD_TOTAL_ACCTD_AMT_p return number is
685 Begin
686 return P_PERIOD_TOTAL_ACCTD_AMT;
687 END;
688 Function P_PERIOD_TOTAL_ACCTD_AMT_DSP_p return varchar2 is
689 Begin
690 return P_PERIOD_TOTAL_ACCTD_AMT_DSP;
691 END;
692 Function P_AMT_DIFF_p return number is
693 Begin
694 return P_AMT_DIFF;
695 END;
696 Function P_ACCTD_AMT_DIFF_p return number is
697 Begin
698 return P_ACCTD_AMT_DIFF;
699 END;
700 Function P_ACCTD_AMT_DIFF_DSP_p return varchar2 is
701 Begin
702 return P_ACCTD_AMT_DIFF_DSP;
703 END;
704 Function P_END_AGE_AMT_p return number is
705 Begin
706 return P_END_AGE_AMT;
707 END;
708 Function P_END_AGE_ACCTD_AMT_p return number is
709 Begin
710 return P_END_AGE_ACCTD_AMT;
711 END;
712 Function P_END_AGE_ACCTD_AMT_DSP_p return varchar2 is
713 Begin
714 return P_END_AGE_ACCTD_AMT_DSP;
715 END;
716 Function P_APP_REG_AMT_p return number is
717 Begin
718 return P_APP_REG_AMT;
719 END;
720 Function P_APP_REG_ACCTD_AMT_p return number is
721 Begin
722 return P_APP_REG_ACCTD_AMT;
723 END;
724 Function P_APP_REG_ACCTD_AMT_DSP_p return varchar2 is
725 Begin
726 return P_APP_REG_ACCTD_AMT_DSP;
727 END;
728 Function P_APP_AMT_p return number is
729 Begin
730 return P_APP_AMT;
731 END;
732 Function P_APP_ACCTD_AMT_p return number is
733 Begin
734 return P_APP_ACCTD_AMT;
735 END;
736 Function P_APP_ACCTD_AMT_DSP_p return varchar2 is
737 Begin
738 return P_APP_ACCTD_AMT_DSP;
739 END;
740 Function P_EDISC_AMT_p return number is
741 Begin
742 return P_EDISC_AMT;
743 END;
744 Function P_EDISC_ACCTD_AMT_p return number is
745 Begin
746 return P_EDISC_ACCTD_AMT;
747 END;
748 Function P_UNEDISC_AMT_p return number is
749 Begin
750 return P_UNEDISC_AMT;
751 END;
752 Function P_UNEDISC_ACCTD_AMT_p return number is
753 Begin
754 return P_UNEDISC_ACCTD_AMT;
755 END;
756 Function P_EDISC_ACCTD_AMT_DSP_p return varchar2 is
757 Begin
758 return P_EDISC_ACCTD_AMT_DSP;
759 END;
760 Function P_UNEDISC_ACCTD_AMT_DSP_p return varchar2 is
761 Begin
762 return P_UNEDISC_ACCTD_AMT_DSP;
763 END;
764 Function P_INV_EXP_AMT_p return number is
765 Begin
766 return P_INV_EXP_AMT;
767 END;
768 Function P_INV_EXP_ACCTD_AMT_p return number is
769 Begin
770 return P_INV_EXP_ACCTD_AMT;
771 END;
772 Function P_INV_EXP_ACCTD_AMT_DSP_p return varchar2 is
773 Begin
774 return P_INV_EXP_ACCTD_AMT_DSP;
775 END;
776 Function P_POST_EXCP_AMT_p return number is
777 Begin
778 return P_POST_EXCP_AMT;
779 END;
780 Function P_POST_EXCP_ACCTD_AMT_p return number is
781 Begin
782 return P_POST_EXCP_ACCTD_AMT;
783 END;
784 Function P_POST_EXCP_ACCTD_AMT_DSP_p return varchar2 is
785 Begin
786 return P_POST_EXCP_ACCTD_AMT_DSP;
790 return P_NON_POST_EXCP_AMT;
787 END;
788 Function P_NON_POST_EXCP_AMT_p return number is
789 Begin
791 END;
792 Function P_NON_POST_EXCP_ACCTD_AMT_p return number is
793 Begin
794 return P_NON_POST_EXCP_ACCTD_AMT;
795 END;
796 Function P_NON_POST_EXCP_ACCTD_AMT_f return varchar2 is
797 Begin
798 return P_NON_POST_EXCP_ACCTD_AMT_DSP;
799 END;
800 Function P_SALES_JOURNAL_AMT_p return number is
801 Begin
802 return P_SALES_JOURNAL_AMT;
803 END;
804 Function P_SALES_JOURNAL_ACCTD_AMT_p return number is
805 Begin
806 return P_SALES_JOURNAL_ACCTD_AMT;
807 END;
808 Function P_SALES_JOURNAL_ACCTD_AMT_f return varchar2 is
809 Begin
810 return P_SALES_JOURNAL_ACCTD_AMT_DSP;
811 END;
812 Function P_TRX_DIFF_ACCTD_AMT_p return number is
813 Begin
814 return P_TRX_DIFF_ACCTD_AMT;
815 END;
816 Function P_TRX_DIFF_ACCTD_AMT_DSP_p return varchar2 is
817 Begin
818 return P_TRX_DIFF_ACCTD_AMT_DSP;
819 END;
820 Function P_ADJ_JOURNAL_AMT_p return number is
821 Begin
822 return P_ADJ_JOURNAL_AMT;
823 END;
824 Function P_ADJ_JOURNAL_ACCTD_AMT_p return number is
825 Begin
826 return P_ADJ_JOURNAL_ACCTD_AMT;
827 END;
828 Function P_ADJ_JOURNAL_ACCTD_AMT_DSP_p return varchar2 is
829 Begin
830 return P_ADJ_JOURNAL_ACCTD_AMT_DSP;
831 END;
832 Function P_ADJ_DIFF_ACCTD_AMT_p return number is
833 Begin
834 return P_ADJ_DIFF_ACCTD_AMT;
835 END;
836 Function P_ADJ_DIFF_ACCTD_AMT_DSP_p return varchar2 is
837 Begin
838 return P_ADJ_DIFF_ACCTD_AMT_DSP;
839 END;
840 Function P_APP_JOURNAL_AMT_p return number is
841 Begin
842 return P_APP_JOURNAL_AMT;
843 END;
844 Function P_APP_JOURNAL_ACCTD_AMT_p return number is
845 Begin
846 return P_APP_JOURNAL_ACCTD_AMT;
847 END;
848 Function P_APP_JOURNAL_ACCTD_AMT_DSP_p return varchar2 is
849 Begin
850 return P_APP_JOURNAL_ACCTD_AMT_DSP;
851 END;
852 Function P_APP_DIFF_ACCTD_AMT_p return number is
853 Begin
854 return P_APP_DIFF_ACCTD_AMT;
855 END;
856 Function P_APP_DIFF_ACCTD_AMT_DSP_p return varchar2 is
857 Begin
858 return P_APP_DIFF_ACCTD_AMT_DSP;
859 END;
860 Function P_UNAPP_JOURNAL_AMT_p return number is
861 Begin
862 return P_UNAPP_JOURNAL_AMT;
863 END;
864 Function P_UNAPP_JOURNAL_ACCTD_AMT_p return number is
865 Begin
866 return P_UNAPP_JOURNAL_ACCTD_AMT;
867 END;
868 Function P_UNAPP_JOURNAL_ACCTD_AMT_f return varchar2 is
869 Begin
870 return P_UNAPP_JOURNAL_ACCTD_AMT_DSP;
871 END;
872 Function P_UNAPP_DIFF_ACCTD_AMT_p return number is
873 Begin
874 return P_UNAPP_DIFF_ACCTD_AMT;
875 END;
876 Function P_UNAPP_DIFF_ACCTD_AMT_DSP_p return varchar2 is
877 Begin
878 return P_UNAPP_DIFF_ACCTD_AMT_DSP;
879 END;
880 Function P_CM_JOURNAL_ACCTD_AMT_p return number is
881 Begin
882 return P_CM_JOURNAL_ACCTD_AMT;
883 END;
884 Function P_CM_JOURNAL_ACCTD_AMT_DSP_p return varchar2 is
885 Begin
886 return P_CM_JOURNAL_ACCTD_AMT_DSP;
887 END;
888 Function P_CM_DIFF_ACCTD_AMT_p return number is
889 Begin
890 return P_CM_DIFF_ACCTD_AMT;
891 END;
892 Function P_CM_DIFF_ACCTD_AMT_DSP_p return varchar2 is
893 Begin
894 return P_CM_DIFF_ACCTD_AMT_DSP;
895 END;
896 Function P_ORGANIZATION_p return varchar2 is
897 Begin
898 return P_ORGANIZATION;
899 END;
900 Function P_BILLS_RECEIVABLE_FLAG_p return varchar2 is
901 Begin
902 return P_BILLS_RECEIVABLE_FLAG;
903 END;
904 Function rp_message_p return varchar2 is
905 Begin
906 return rp_message;
907 END;
908 Function CP_ACC_MESSAGE_p return varchar2 is
909 Begin
910 return CP_ACC_MESSAGE;
911 END;
912 Function P_ON_ACC_CM_REF_AMT_p return number is
913 Begin
914 return P_ON_ACC_CM_REF_AMT;
915 END;
916 Function P_ON_ACC_CM_REF_ACCTD_AMT_p return number is
917 Begin
918 return P_ON_ACC_CM_REF_ACCTD_AMT;
919 END;
920 Function P_ON_ACC_CM_REF_ACCTD_AMT_f return varchar2 is
921 Begin
922 return P_ON_ACC_CM_REF_ACCTD_AMT_DSP;
923 END;
924 function F_ACC_MESSAGEFormatTrigger return char is
925 begin
926 if (arp_util.open_period_exists(p_reporting_level,p_reporting_entity_id,p_gl_date_low,p_gl_date_high)) then
927 return 'TRUE';
928 else
929 return 'FALSE';
930 end if;
931 end;
932 END AR_ARXRECON_XMLP_PKG ;
933