PACKAGE BODY: APPS.AR_ARXCOBLX_XMLP_PKG

Source

1 PACKAGE BODY AR_ARXCOBLX_XMLP_PKG AS
2 /* $Header: ARXCOBLXB.pls 120.0 2007/12/27 13:41:45 abraghun noship $ */
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 day   varchar2(2);
58 month varchar2(50);
59 year  varchar2(4);
60 begin
61 
62 
63   month := substrb(rtrim(to_char(p_as_of_date,'Month'),' '),1,50);
64   day   := to_char(p_as_of_date,'DD');
65   year  := to_char(p_as_of_DATE,'YYYY');
66 
67   return(day||' '||month||' '||year);
68 end;
69 
70 function AfterReport return boolean is
71 begin
72   /*srw.user_exit('FND SRWEXIT');*/null;
73 
74   return (TRUE);
75 end;
76 
77 --Functions to refer Oracle report placeholders--
78 
79 END AR_ARXCOBLX_XMLP_PKG ;
80