PACKAGE: APPS.XTR_XTRMTCPY_XMLP_PKG

Source

1 PACKAGE XTR_XTRMTCPY_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRMTCPYS.pls 120.1 2007/12/28 12:57:31 npannamp noship $ */
3   REPORT_DATE2 DATE;
4 X VARCHAR2(30);
5   REPORT_NOS VARCHAR2(30);
6   REPORT_SHORT_NAME VARCHAR2(80);
7   REPORT_GROUP VARCHAR2(32767);
8   USE_DEFAULTS VARCHAR2(1);
9   CPARTY_CODE VARCHAR2(7);
10   COMPANY_CODE VARCHAR2(7);
11   DEAL_TYPE1 VARCHAR2(7);
12   DEAL_SUBTYPE VARCHAR2(7);
13   PRODUCT_TYPE VARCHAR2(10);
14   CURRENCY_CODE VARCHAR2(15);
15   FROM_DATE DATE;
16   TO_DATE1 DATE;
17   AS_PRINCIPAL VARCHAR2(1);
18   CLIENT_CODE VARCHAR2(7);
19   Z1REPORT_NOS VARCHAR2(300);
20   Z2PRODUCT VARCHAR2(300);
21   Z2AMT_TYPE VARCHAR2(300);
22   Z2RATE VARCHAR2(300);
23   Z2CCY VARCHAR2(300);
24   Z2AMOUNT VARCHAR2(300);
25   Z2HCE_AMOUNT VARCHAR2(300);
26   Z1PARAMETERS VARCHAR2(300);
27   Z1COMPANY VARCHAR2(300);
28   Z1CPARTY VARCHAR2(300);
29   Z1DEAL_TYPE VARCHAR2(300);
30   Z1SUBTYPE VARCHAR2(300);
31   Z1CLIENT VARCHAR2(300);
32   Z1CURRENCY VARCHAR2(300);
33   Z1DATE_FROM VARCHAR2(300);
34   Z1TO VARCHAR2(300);
35   Z2VALUE_DATE VARCHAR2(300);
36   Z2DEAL_REF VARCHAR2(300);
37   Z2DEAL_TYPE_SUB VARCHAR2(300);
38   Z2END_OF_REPORT VARCHAR2(300);
39   Z2PAGE VARCHAR2(300);
40   Z2REPORT VARCHAR2(300);
41   Z2REQUESTED_BY VARCHAR2(300);
42   P_CPARTY VARCHAR2(7);
43   P_COMPANY VARCHAR2(7);
44   P_DEAL_TYPE VARCHAR2(7);
45   P_DEAL_SUBTYPE VARCHAR2(7);
46   P_PRODUCT_TYPE VARCHAR2(10);
47   P_CURRENCY VARCHAR2(15);
48   P_PERIOD_FROM VARCHAR2(32767);
49   P_PERIOD_TO VARCHAR2(32767);
50   P_AS_PRINCIPAL VARCHAR2(1);
51   P_CLIENT VARCHAR2(7);
52   P_PORTFOLIO VARCHAR2(32767);
53   CPARTY_CODE2 VARCHAR2(7);
54   DEAL_TYPE2 VARCHAR2(7);
55   DEAL_SUBTYPE2 VARCHAR2(7);
56   PRODUCT_TYPE2 VARCHAR2(10);
57   CURRENCY2 VARCHAR2(15);
58   FROM_DATE2 VARCHAR2(32767);
59   TO_DATE2 VARCHAR2(32767);
60   AS_PRINCIPAL2 VARCHAR2(1);
61   CLIENT_CODE2 VARCHAR2(7);
62   COMPANY_CODE2 VARCHAR2(7);
63   REPORT_SHORT_NAME2 VARCHAR2(240);
64   P_CONC_REQUEST_ID NUMBER;
65   COMPANY_NAME_HEADER VARCHAR2(70);
66   P_SQL_TRACE VARCHAR2(32767);
67   P_DISPLAY_DEBUG VARCHAR2(32767);
68   REPORT_DATE VARCHAR2(100);
69   Z1AS_PRINCIPAL VARCHAR2(300);
70   Z1PRODUCT_TYPE VARCHAR2(300);
71   P_FACTOR VARCHAR2(10);
72   AMT_UNIT2 NUMBER;
73   LP_FACTOR_DESC VARCHAR2(32767);
74   Z1P_FACTOR VARCHAR2(300);
75   Z1PORTFOLIO VARCHAR2(300);
76   PORTFOLIO VARCHAR2(32767);
77   PORTFOLIO2 VARCHAR2(32767);
78   COMPANY_NAME VARCHAR2(256);
79   CPARTY_NAME VARCHAR2(256);
80   CP_PARA VARCHAR2(30);
81   --added
82   P_PERIOD_FROM1 VARCHAR2(30);
83   P_PERIOD_TO1 VARCHAR2(30);
84   --FUNCTION CPARTY_NAME1FORMULA RETURN VARCHAR2;
85   FUNCTION CPARTY_NAME1FORMULA(CPARTY varchar2) RETURN VARCHAR2;
86   FUNCTION CPARTY_NAMEFORMULA RETURN VARCHAR2;
87   FUNCTION COMPANY_NAME1FORMULA(COMPANY varchar2) RETURN VARCHAR2;
88   FUNCTION COMPANY_NAMEFORMULA RETURN VARCHAR2;
89   FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
90   FUNCTION BEFOREREPORT RETURN BOOLEAN;
91   FUNCTION AFTERREPORT RETURN BOOLEAN;
92   FUNCTION AFTERPFORM RETURN BOOLEAN;
93   FUNCTION COMPANY_NAME_P RETURN VARCHAR2;
94   FUNCTION CPARTY_NAME_P RETURN VARCHAR2;
95   FUNCTION CP_PARA_P RETURN VARCHAR2;
96 END XTR_XTRMTCPY_XMLP_PKG;
97