PACKAGE: APPS.AR_ARXCPH_XMLP_PKG

Source

1 PACKAGE AR_ARXCPH_XMLP_PKG AS
2 /* $Header: ARXCPHS.pls 120.0 2007/12/27 13:43:45 abraghun noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	CP_IN_TRX_DATE_LOW VARCHAR2(20);
5 	CP_IN_TRX_DATE_HIGH VARCHAR2(20);
6 	P_in_sorting_order	varchar2(50);
7 	P_in_customer_low	varchar2(100);
8 	P_IN_CUSTOMER_HIGH	varchar2(200);
9 	P_IN_CUSTOMER_NUM_LOW	varchar2(30);
10 	P_IN_INV_NUM_LOW	varchar2(30);
11 	P_IN_INV_NUM_HIGH	varchar2(30);
12 	P_IN_TRX_DATE_LOW	date;
13 	P_IN_TRX_DATE_HIGH	date;
14 	P_IN_TERMS_LOW	varchar2(30);
15 	P_IN_TERMS_HIGH	varchar2(30);
16 	P_IN_COLLECTOR_LOW	varchar2(30);
17 	P_IN_COLLECTOR_HIGH	varchar2(200);
18 	P_MIN_PRECISION	number;
19 	lp_customer_name_low	varchar2(200):=' ';
20 	lp_customer_name_high	varchar2(200):=' ';
21 	lp_cust_num_low	varchar2(200):=' ';
22 	lp_cust_num_high	varchar2(200):=' ';
23 	lp_invoice_num_low	varchar2(200):=' ';
24 	lp_invoice_num_high	varchar2(200):=' ';
25 	P_IN_CUSTOMER_NUM_HIGH	varchar2(200);
26 	lp_trx_date_low	varchar2(200):=' ';
27 	lp_trx_date_high	varchar2(200):=' ';
28 	lp_terms_low	varchar2(200):=' ';
29 	lp_terms_high	varchar2(200):=' ';
30 	lp_collector_low	varchar2(200):=' ';
31 	lp_collector_high	varchar2(200):=' ';
32 	P_SET_OF_BOOKS_ID	varchar2(40);
33 	P_SYSDATE	date;
34 	SORT_BY_PHONETICS	varchar2(1);
35 	P_SORT	varchar2(40);
36 	Skip_Sum	number;
37 	Addr_Prn_Flag	varchar2(1);
38 	Prev_Addr_Id	number := 0 ;
39 	prev_customer_trx_id	varchar2(30);
40 	prev_currency_code	varchar2(32767);
41 	prev_customer_id	varchar2(50);
42 	prev_terms	varchar2(50);
43 	RP_COMPANY_NAME	varchar2(50);
44 	RP_REPORT_NAME	varchar2(240);
45 	RP_DATA_FOUND	varchar2(100);
46 	RP_SUB_TITLE	varchar2(80);
47 	RP_SORT_ORDER	varchar2(80);
48 	Actual_Invoice_Sum	number;
49 	function BeforeReport return boolean  ;
50 	function AfterReport return boolean  ;
51 	function AfterPForm return boolean  ;
52 	function report_nameformula(Company_Name in varchar2) return varchar2  ;
53 	function Report_SubtitleFormula return Char  ;
54 	function Sort_OrderFormula return VARCHAR2  ;
55 	function average_days_lateformula(rec_counter in number, sum_days_late in number) return number  ;
56 	function wt_avg_days_lateformula(sum_payment in number, sum_w_days_late in number) return number  ;
57 	function skip_inv_sumformula(invoice_amount in number, customer_id in number, currency_code in varchar2, customer_trx_id in number, terms_sequence_number in number) return number  ;
58 	function set_addr_flagformula(address_id in number) return number  ;
59 	Function Skip_Sum_p return number;
60 	Function Addr_Prn_Flag_p return varchar2;
61 	Function Prev_Addr_Id_p return number;
62 	Function prev_customer_trx_id_p return varchar2;
63 	Function prev_currency_code_p return varchar2;
64 	Function prev_customer_id_p return varchar2;
65 	Function prev_terms_p return varchar2;
66 	Function RP_COMPANY_NAME_p return varchar2;
67 	Function RP_REPORT_NAME_p return varchar2;
68 	Function RP_DATA_FOUND_p return varchar2;
69 	Function RP_SUB_TITLE_p return varchar2;
70 	Function RP_SORT_ORDER_p return varchar2;
71 	Function Actual_Invoice_Sum_p return number;
72     function D_invoice_amountFormula(customer varchar2) return VARCHAR2;
73 END AR_ARXCPH_XMLP_PKG;
74