PACKAGE: APPS.AR_ARXCBH_XMLP_PKG

Source

1 PACKAGE AR_ARXCBH_XMLP_PKG AS
2 /* $Header: ARXCBHS.pls 120.0 2007/12/27 13:37:31 abraghun noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_IN_CUSTOMER_NUM_LOW	varchar2(30);
5 	P_IN_CUSTOMER_NUM_HIGH	varchar2(30);
6 	P_IN_CUSTOMER_LOW	varchar2(50);
7 	P_IN_CUSTOMER_HIGH	varchar2(50);
8 	P_IN_INVOICE_NUMBER_LOW	varchar2(30);
9 	P_IN_INVOICE_NUMBER_HIGH	varchar2(30);
10 	P_TRX_DATE_LOW	date;
11 	P_TRX_DATE_HIGH	date;
12 	P_IN_TRX_DATE_LOW	date;
13 	P_IN_TRX_DATE_HIGH	date;
14 	P_IN_COLLECTOR_LOW	varchar2(30);
15 	P_IN_COLLECTOR_HIGH	varchar2(30);
16 	P_IN_TERMS_LOW	varchar2(30);
17 	P_IN_TERMS_HIGH	varchar2(30);
18 	P_TERMS_NAME_HIGH	varchar2(40):=' ';
19 	P_TERMS_NAME_LOW	varchar2(40):=' ';
20 	P_WHERE_11	varchar2(200):=' ';
21 	lp_in_customer_num_low	varchar2(200):=' ';
22 	lp_in_customer_num_high	varchar2(200):=' ';
23 	Lp_in_invoice_number_low	varchar2(200):=' ';
24 	lp_in_invoice_number_high	varchar2(200):=' ';
25 	lp_in_collector_high	varchar2(200):=' ';
26 	lp_in_collector_low	varchar2(200):=' ';
27 	lp_in_trx_date_low	varchar2(200):=' ';
28 	lp_in_trx_date_high	varchar2(200):=' ';
29 	lp_terms_low	varchar2(200):=' ';
30 	lp_terms_high	varchar2(200):=' ';
31 	P_WHERE_12	varchar2(200):=' ';
32 	P_TERMS_NAME	varchar2(200):=' ';
33 	P_Set_of_books_id	number;
34 	P_MIN_PRECISION	number;
35 	P_TERMS_NAME1	varchar2(200):=' ';
36 	P_FROM_1	varchar2(200):=' ';
37 	P_WHERE_2	varchar2(400):=' ';
38 	Addr_Prn_Flag	varchar2(1);
39 	Previous_Addr_Id	number := 0 ;
40 	RP_COMPANY_NAME	varchar2(50);
41 	RP_REPORT_NAME	varchar2(80);
42 	RP_DATA_FOUND	varchar2(100);
43 	/*ADDED AS FIX*/
44 	P_IN_TRX_DATE_LOW_T  VARCHAR2(50);
45  	P_IN_TRX_DATE_HIGH_T VARCHAR2(50);
46 	function BeforeReport return boolean  ;
47 	function AfterReport return boolean  ;
48 	function report_nameformula(Company_Name in varchar2) return varchar2  ;
49 	function AfterPForm return boolean  ;
50 	function set_prn_flagformula(address_id in number) return number  ;
51 	function cf_currency_flagformula(p_payment_schedule_id in number) return char  ;
52 	Function Addr_Prn_Flag_p return varchar2;
53 	Function Previous_Addr_Id_p return number;
54 	Function RP_COMPANY_NAME_p return varchar2;
55 	Function RP_REPORT_NAME_p return varchar2;
56 	Function RP_DATA_FOUND_p return varchar2;
57 	function D_INVOICE_AMOUNTFormula(customer_name in varchar2) return VARCHAR2;
58 END AR_ARXCBH_XMLP_PKG;
59