PACKAGE BODY: APPS.AR_ARXCOBLX_XMLP_PKG

Source

1 PACKAGE BODY AR_ARXCOBLX_XMLP_PKG AS
2 /* $Header: ARXCOBLXB.pls 120.3 2011/03/11 11:36:33 dgaurab ship $ */
3 
4 function cf_totalformula(c_inv_open_balance in number, cf_credits_and_receipts in number) return number is
5 begin
6 /*srw.reference(cf_credits_and_receipts);*/null;
7 
8   return(c_inv_open_balance+(cf_credits_and_receipts));
9 end;
10 
11 function cf_credits_and_receiptsformula(c_unapplied_receipts in number, c_on_account_receipts in number, c_on_account_credits in number) return number is
12 begin
13     return((c_unapplied_receipts+c_on_account_receipts)+c_on_account_credits);
14 end;
15 
16 function BeforeReport return boolean is
17 l_date date;
18 begin
19  	P_CONC_REQUEST_ID:=FND_GLOBAL.conc_request_id;
20   begin
21 /*srw.user_exit('FND SRWINIT');*/null;
22 
23 
24 
25 
26 l_date:=fnd_date.chardate_to_date(p_as_of_date);
27 
28 
29 select set_of_books_id into p_set_of_books_id
30 from ar_system_parameters;
31 
32 
33 AR_GET_CUSTOMER_BALANCE_PKG.ar_get_customer_balance(
34                                 p_conc_request_id
35                                ,p_set_of_books_id
36                                ,l_date
37                                ,p_customer_name_from
38                                ,p_customer_name_to
39                                ,p_customer_number_low
40                                ,p_customer_number_high
41                                ,p_currency
42                                ,p_min_invoice_balance
43                                ,p_min_customer_balance
44                                ,p_include_on_account_credits
45                                ,p_include_on_account_receipts
46                                ,p_include_unapplied_receipts
47                                ,p_include_uncleared_receipts
48                                ,p_reference_number
49                                ,p_debug_flag
50                                ,p_trace_flag
51                                       );
52  end;
53   return (TRUE);
54 end;
55 
56 function C_as_of_date_displayFormula return char is
57 begin
58 -- Bug 11799279
59 RETURN (fnd_date.date_to_chardate(p_as_of_date, calendar_aware=> FND_DATE.calendar_aware_alt));
60 
61 end;
62 
63 function AfterReport return boolean is
64 begin
65   /*srw.user_exit('FND SRWEXIT');*/null;
66 
67   return (TRUE);
68 end;
69 
70 --Functions to refer Oracle report placeholders--
71 
72 END AR_ARXCOBLX_XMLP_PKG ;
73