DBA Data[Home] [Help]

PACKAGE: APPS.XTR_XTRDISRE_XMLP_PKG

Source


1 PACKAGE XTR_XTRDISRE_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRDISRES.pls 120.1 2007/12/28 12:47:48 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   FROM_DATE DATE;
14 
15   TO_DATE1 DATE;
16 
17   COMPANY_CODE VARCHAR2(7);
18 
19   PORTFOLIO VARCHAR2(7);
20 
21   CPARTY_CODE VARCHAR2(7);
22 
23   ACCEPTOR VARCHAR2(7);
24 
25   ISS_PURCH VARCHAR2(12);
26 
27   PRODUCT_TYPE VARCHAR2(10);
28 
29   Z1REPORT_NOS VARCHAR2(300);
30 
31   Z2CCY VARCHAR2(300);
32 
33   Z2STATUS VARCHAR2(300);
34 
35   Z2END_OF_REPORT VARCHAR2(300);
36 
37   Z2INTEREST_RATE VARCHAR2(300);
38 
39   Z2AVAIL VARCHAR2(300);
40 
41   Z2PARCEL_REMAIN VARCHAR2(300);
42 
43   Z2FACE_VALUE_AMOUNT VARCHAR2(300);
44 
45   Z2RESERVED_YN VARCHAR2(300);
46 
47   Z1PARAMETERS VARCHAR2(300);
48 
49   Z1MATURITIES_BETWEEN VARCHAR2(300);
50 
51   Z1COMPANY_CODE VARCHAR2(300);
52 
53   Z1AND VARCHAR2(300);
54 
55   Z1PORTFOLIO VARCHAR2(300);
56 
57   Z1CPARTY_CODE VARCHAR2(300);
58 
59   Z1ACCEPTOR VARCHAR2(300);
60 
61   Z1ISSUED_BUY_ALL VARCHAR2(300);
62 
63   Z1PRODUCT_TYPE VARCHAR2(300);
64 
65   Z2SUBTYPE VARCHAR2(300);
66 
67   Z2MATURITY_DATE VARCHAR2(300);
68 
69   Z2DEAL_NUMBER VARCHAR2(300);
70 
71   Z2COMMENCE_DATE VARCHAR2(300);
72 
73   Z2ACCEPTOR_CODE VARCHAR2(300);
74 
75   Z2COMPANY VARCHAR2(300);
76 
77   Z2PAGE VARCHAR2(300);
78 
79   Z2REPORT VARCHAR2(300);
80 
81   Z2REQUESTED_BY VARCHAR2(300);
82 
83   P_COMPANY VARCHAR2(7);
84 
85   P_DATE_FROM VARCHAR2(32767);
86   P_DATE_FROM_T VARCHAR2(32767);
87 
88   P_DATE_TO VARCHAR2(32767);
89   P_DATE_TO_T VARCHAR2(32767);
90 
91   P_PORTFOLIO VARCHAR2(7);
92 
93   P_CPARTY VARCHAR2(7);
94 
95   P_PRODUCT_TYPE VARCHAR2(10);
96 
97   P_ACCEPTOR_CODE VARCHAR2(7);
98 
99   P_ISSUED_PURCHASED_BOTH VARCHAR2(12);
100 
101   P_SQL_TRACE VARCHAR2(32767);
102 
103   P_DISPLAY_DEBUG VARCHAR2(32767);
104 
105   COMPANY_CODE2 VARCHAR2(7);
106 
107   FROM_DATE2 DATE;
108 
109   TO_DATE2 DATE;
110 
111   PORTFOLIO2 VARCHAR2(7);
112 
113   CPARTY_CODE2 VARCHAR2(7);
114 
115   PRODUCT_TYPE2 VARCHAR2(10);
116 
117   ACCEPTOR2 VARCHAR2(7);
118 
119   ISS_PURCH2 VARCHAR2(12);
120 
121   COMPANY_NAME_HEADER VARCHAR2(80);
122 
123   P_CONC_REQUEST_ID NUMBER;
124 
125   REPORT_SHORT_NAME2 VARCHAR2(240);
126 
127   REPORT_DATE VARCHAR2(100);
128 
129   P_FACTOR VARCHAR2(10);
130 
131   AMT_UNIT2 NUMBER;
132 
133   LP_FACTOR_DESC VARCHAR2(32767);
134 
135   Z1P_FACTOR VARCHAR2(300);
136 
137   P_FACTOR_DSP VARCHAR2(100);
138 
139   P_ISSUED_DSP VARCHAR2(100);
140 
141   CP_PARA VARCHAR2(30);
142 
143   FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
144 
145   FUNCTION BEFOREREPORT RETURN BOOLEAN;
146 
147   FUNCTION AFTERPFORM RETURN BOOLEAN;
148 
149   FUNCTION AFTERREPORT RETURN BOOLEAN;
150 
151   FUNCTION CP_PARA_P RETURN VARCHAR2;
152 
153 END XTR_XTRDISRE_XMLP_PKG;
154