PACKAGE: APPS.XTR_XTRMTDAT_XMLP_PKG

Source

1 PACKAGE XTR_XTRMTDAT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRMTDATS.pls 120.1 2007/12/28 12:58:01 npannamp noship $ */
3   REPORT_DATE2 DATE;
4 
5   REPORT_NOS VARCHAR2(30);
6 
7   REPORT_SHORT_NAME VARCHAR2(80);
8 
9   REPORT_GROUP VARCHAR2(32767);
10 
11   USE_DEFAULTS VARCHAR2(1);
12 
13   COMPANY_CODE VARCHAR2(7);
14 
15   DEAL_TYPE1 VARCHAR2(7);
16 
17   DEAL_SUBTYPE VARCHAR2(7);
18 
19   PRODUCT_TYPE VARCHAR2(10);
20 
21   CURRENCY_CODE VARCHAR2(15);
22 
23   CPARTY_CODE VARCHAR2(7);
24 
25   FROM_DATE DATE;
26 
27  -- TO_DATE DATE;
28  TO_DATE_1 DATE;
29 
30   AS_PRINCIPAL VARCHAR2(1);
31 
32   CLIENT_CODE VARCHAR2(7);
33 
34   PORT_CODE VARCHAR2(40);
35 
36   Z1PARAMETERS VARCHAR2(300);
37 
38   Z1COMPANY VARCHAR2(300);
39 
40   Z1CPARTY VARCHAR2(300);
41 
42   Z1DEALTYPE VARCHAR2(300);
43 
44   Z1AS_PRINCIPAL VARCHAR2(300);
45 
46   Z1SUBTYPE VARCHAR2(300);
47 
48   Z1CLIENT VARCHAR2(300);
49 
50   Z1CURRENCY VARCHAR2(300);
51 
52   Z1PORTFOLIO VARCHAR2(300);
53 
54   Z1DATE_FROM VARCHAR2(300);
55 
56   Z2MATURITY VARCHAR2(300);
57 
58   Z2DEAL_REF VARCHAR2(300);
59 
60   Z2DEAL_TYPE_SUB VARCHAR2(300);
61 
62   Z2PRODUCT VARCHAR2(300);
63 
64   Z2AMOUNT_TYPE VARCHAR2(300);
65 
66   Z2RATE VARCHAR2(300);
67 
68   Z2CCY VARCHAR2(300);
69 
70   Z2AMOUNT VARCHAR2(300);
71 
72   Z2HCE_AMOUNT VARCHAR2(300);
73 
74   Z2END_OF_REPORT VARCHAR2(300);
75 
76   Z1TO VARCHAR2(300);
77 
78   Z2PAGE VARCHAR2(300);
79 
80   Z2STATUS_CODE VARCHAR2(300);
81 
82   P_COMPANY VARCHAR2(7);
83 
84   P_DEAL_TYPE VARCHAR2(7);
85 
86   P_DEAL_SUBTYPE VARCHAR2(7);
87 
88   P_PRODUCT_TYPE VARCHAR2(10);
89 
90   P_CURRENCY VARCHAR2(15);
91 
92   P_CPARTY VARCHAR2(7);
93 
94   P_PERIOD_FROM VARCHAR2(32767);
95 
96   P_PERIOD_TO VARCHAR2(32767);
97  P_PERIOD_FROM_1 VARCHAR2(32767);
98 
99   P_PERIOD_TO_1 VARCHAR2(32767);
100   P_AS_PRINCIPAL VARCHAR2(1);
101 
102   P_CLIENT VARCHAR2(7);
103 
104   P_PORTFOLIO VARCHAR2(40);
105 
106   P_CONC_REQUEST_ID NUMBER;
107 
108   REPORT_SHORT_NAME2 VARCHAR2(240);
109 
110   P_SQL_TRACE VARCHAR2(32767);
111 
112   P_DISPLAY_DEBUG VARCHAR2(32767);
113 
114   COMPANY_NAME_HEADER VARCHAR2(100);
115 
116   REPORT_DATE VARCHAR2(100);
117 
118   Z1PRODUCT_TYPE VARCHAR2(300);
119 
120   P_FACTOR VARCHAR2(10);
121 
122   AMT_UNIT2 NUMBER;
123 
124   LP_FACTOR_DESC VARCHAR2(32767);
125 
126   Z1P_FACTOR VARCHAR2(300);
127 
128   Z1P_DATE_TYPE VARCHAR2(300);
129 
130   P_PERIOD_WHERE_CLAUSE VARCHAR2(200) := ' 1 =1';
131 
132   CP_PARA VARCHAR2(30);
133 
134   FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
135 
136   FUNCTION BEFOREREPORT RETURN BOOLEAN;
137 
138   FUNCTION AFTERPFORM RETURN BOOLEAN;
139 
140   FUNCTION AFTERREPORT RETURN BOOLEAN;
141 
142   FUNCTION BEFOREPFORM RETURN BOOLEAN;
143 
144   FUNCTION BETWEENPAGE RETURN BOOLEAN;
145 
146   FUNCTION CP_PARA_P RETURN VARCHAR2;
147 
148 END XTR_XTRMTDAT_XMLP_PKG;
149