PACKAGE: APPS.AR_ARXAPIPM_XMLP_PKG

Source

1 PACKAGE AR_ARXAPIPM_XMLP_PKG AS
2 /* $Header: ARXAPIPMS.pls 120.0 2007/12/27 13:27:21 abraghun noship $ */
3 	P_CONC_REQUEST_ID	number;
4 	P_Set_of_Books_Id	number;
5 	P_SORT_BY	varchar2(30);
6 	P_STATUS	varchar2(30);
7 	P_INV_DATE_HIGH	date;
8 	P_INV_DATE_LOW	date;
9 	P_DUE_DATE_HIGH	date;
10 	P_DUE_DATE_LOW	date;
11 	P_PMT_MTD	varchar2(100);
12 	P_CUST_NAME	varchar2(100);
13 	P_CUST_NUMBER	varchar2(32767);
14 	P_INV_NUM_HIGH	varchar2(100);
15 	P_INV_NUM_LOW	varchar2(100);
16 	P_INV_TYPE	varchar2(100);
17 	P_CURRENCY	varchar2(300);
18 	LP_CURRENCY	varchar2(200):=' ';
19 	LP_STATUS	varchar2(200):=' ';
20 	LP_INV_DATE	varchar2(200):=' ';
21 	LP_DUE_DATE	varchar2(200):=' ';
22 	LP_PMT_METHOD	varchar2(200):=' ';
23 	LP_CUST_NAME	varchar2(200):=' ';
24 	LP_CUST_NUM	varchar2(200):=' ';
25 	LP_INV_NUM	varchar2(200):=' ';
26 	LP_INV_TYPE	varchar2(200):=' ';
27 	P_SUMMARIZE	varchar2(200);
28 	RP_SUMMARIZE	varchar2(32767):='NO';
29 	LP_GROUP_BY	varchar2(1000):=' ';
30 	LP_SUM_COLUMN	varchar2(800):='nvl(pays.amount_due_remaining, 0)';
31 	RP_COMPANY_NAME	varchar2(50);
32 	RP_REPORT_NAME	varchar2(80);
33 	RP_SUB_TITLE1	varchar2(80);
34 	RP_SUB_TITLE2	varchar2(300);
35 	RP_DATA_FOUND	varchar2(300);
36 	RP_FUNCTIONAL_CURRENCY	varchar2(200);
37 	--ADDED AS FIX
38 	P_INV_DATE_LOW_T VARCHAR2(60);
39 	P_INV_DATE_HIGH_T VARCHAR2(60);
40 	P_DUE_DATE_LOW_T VARCHAR2(60);
41 	P_DUE_DATE_HIGH_T VARCHAR2(60);
42 	--FIX ENDS
43 	function report_nameformula(Company_Name in varchar2, functional_currency in varchar2) return varchar2  ;
44 	function BeforeReport return boolean  ;
45 	function Sub_TitleFormula return VARCHAR2  ;
46 	function AfterReport return boolean  ;
47 	function AfterPForm return boolean  ;
48 	function RP_DSP_SORT_BYFormula return VARCHAR2  ;
49 	function RP_DSP_SUMMARIZEFormula return VARCHAR2  ;
50 	function RP_DSP_STATUSFormula return VARCHAR2  ;
51 	function CF_report_dateFormula return Char  ;
52 	Function RP_COMPANY_NAME_p return varchar2;
53 	Function RP_REPORT_NAME_p return varchar2;
54 	Function RP_SUB_TITLE1_p return varchar2;
55 	Function RP_SUB_TITLE2_p return varchar2;
56 	Function RP_DATA_FOUND_p return varchar2;
57 	Function RP_FUNCTIONAL_CURRENCY_p return varchar2;
58 	Function D_SUM_AMOUNT_DUE_CURRFormula return varchar2;
59 END AR_ARXAPIPM_XMLP_PKG;
60