PACKAGE: APPS.AR_ARXCHR_XMLP_PKG

Source

1 PACKAGE AR_ARXCHR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARXCHRS.pls 120.0 2007/12/27 13:40:48 abraghun noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_CUSTOMER_NUMBER_LOW	varchar2(30);
5 	P_CUSTOMER_NUMBER_HIGH	varchar2(30);
6 	P_CUSTOMER_NAME_LOW	varchar2(50);
7 	P_CUSTOMER_NAME_HIGH	varchar2(50);
8 	P_ORDER_BY	varchar2(50);
9 	P_SET_OF_BOOKS_ID	number;
10 	P_COLLECTOR_LOW	varchar2(40);
11 	P_COLLECTOR_HIGH	varchar2(40);
12 	P_CURRENCY_CODE	varchar2(32767);
13 	lp_collector_low	varchar2(800):=' ';
14 	lp_collector_high	varchar2(800):=' ';
15 	lp_customer_number_low	varchar2(800):=' ';
16 	lp_customer_number_high	varchar2(800):=' ';
17 	lp_customer_name_low	varchar2(800):=' ';
18 	lp_customer_name_high	varchar2(800):=' ';
19 	lp_currency_code	varchar2(800):=' ';
20 	lp_status_low	varchar2(800):=' ';
21 	lp_status_high	varchar2(800):=' ';
22 	P_STATUS_LOW	varchar2(80);
23 	P_STATUS_HIGH	varchar2(80);
24 	P_REPORTING_ENTITY_ID	number;
25 	P_REPORTING_ENTITY_NAME	varchar2(60);
26 	P_REPORTING_LEVEL	varchar2(30);
27 	P_REPORTING_LEVEL_NAME	varchar2(80);
28 	P_ORG_WHERE_PS	varchar2(2000);
29 	P_ORG_WHERE_SITE	varchar2(2000):=' ';
30 	P_ORG_WHERE_ADDR	varchar2(2000):=' ';
31 	c_phone_number	varchar2(100);
32 	c_contact_id	number;
33 	c_contact_name	varchar2(60);
34 	RP_COMPANY_NAME	varchar2(50);
35 	RP_REPORT_NAME	varchar2(80);
36 	RP_DATA_FOUND	varchar2(300);
37 	RP_DATE_RANGE	varchar2(100);
38 	RP_message	varchar2(2000);
39 	function BeforeReport return boolean  ;
40 	function AfterReport return boolean  ;
41 	function report_nameformula(Company_Name in varchar2) return varchar2  ;
42 	function AfterPForm return boolean  ;
43 	function c_get_phone_numberformula(address_id in number, customer_id in number) return number  ;
44 	function C_PRIMARY_CONTACTFormula(p_address_id in varchar2) return Number  ;
45 	function c_no_data_foundformula(Currency_Main in varchar2) return number  ;
46 	Function c_phone_number_p return varchar2;
47 	Function c_contact_id_p return number;
48 	Function c_contact_name_p return varchar2;
49 	Function RP_COMPANY_NAME_p return varchar2;
50 	Function RP_REPORT_NAME_p return varchar2;
51 	Function RP_DATA_FOUND_p return varchar2;
52 	Function RP_DATE_RANGE_p return varchar2;
53 	Function RP_message_p return varchar2;
54 END AR_ARXCHR_XMLP_PKG;
55