[Home] [Help]
PACKAGE: APPS.XTR_XTRLIUTL_XMLP_PKG
Source
1 PACKAGE XTR_XTRLIUTL_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRLIUTLS.pls 120.1 2007/12/28 12:53:39 npannamp noship $ */
3 USE_DEFAULTS VARCHAR2(40);
4
5 REPORT_SHORT_NAME VARCHAR2(80);
6
7 REPORT_GROUP VARCHAR2(40);
8
9 REPORT_NOS VARCHAR2(40);
10
11 VERSION_NUM NUMBER;
12
13 CCY VARCHAR2(40);
14
15 AMT_UNIT VARCHAR2(40);
16
17 REF_NUMBER VARCHAR2(40);
18
19 BASE_CCY VARCHAR2(40);
20
21 COMPANY VARCHAR2(40);
22
23 INCL_OPTIONS VARCHAR2(40);
24
25 INCL_INDIC_EXP VARCHAR2(40);
26
27 PORTFOLIO VARCHAR2(40);
28
29 YIELD_CURVE VARCHAR2(40);
30
31 DFLT_DISC_RATE VARCHAR2(40);
32
33 SHOW_DETAILS VARCHAR2(40);
34
35 Z1PARAMETERS VARCHAR2(300);
36
37 Z2END_OF_REPORT VARCHAR2(300);
38
39 Z2PAGE VARCHAR2(300);
40
41 LIMIT_TYPE VARCHAR2(32767);
42
43 AVAILABLE_LOW_RANGE VARCHAR2(40);
44
45 AVAILABLE_HIGH_RANGE VARCHAR2(40);
46
47 LIMIT_CODE VARCHAR2(32767);
48
49 PERIOD_FROM DATE;
50
51 PERIOD_TO DATE;
52
53 Z2COMPANY VARCHAR2(300);
54
55 Z2LIMIT_PARTY VARCHAR2(300);
56
57 Z2LIMIT_GROUP VARCHAR2(300);
58
59 Z2COUNTRY VARCHAR2(300);
60
61 Z2CURRENCY VARCHAR2(300);
62
63 Z2EFFECTIVE_DATE VARCHAR2(300);
64
65 Z2LIMIT_AMT VARCHAR2(300);
66
67 Z2UTILISED VARCHAR2(300);
68
69 Z2AVAILABLE VARCHAR2(300);
70
71 Z1EFFECTIVE_DATE_FROM VARCHAR2(300);
72
73 Z1EFFECTIVE_DATE_TO VARCHAR2(300);
74
75 Z1AVAILABLE_LOW_RANGE VARCHAR2(300);
76
77 Z1AVAILABLE_HIGH_RANGE VARCHAR2(300);
78
79 Z1LIMIT_CODE VARCHAR2(300);
80
81 Z1LIMIT_TYPE VARCHAR2(300);
82
83 P_LIMIT_TYPE VARCHAR2(32767);
84
85 P_AVAILABLE_LOW NUMBER;
86
87 P_AVAILABLE_HIGH NUMBER;
88
89 P_LIMIT_CODE VARCHAR2(7);
90
91 P_EFFECTIVE_DATE_FROM VARCHAR2(32767);
92
93 P_EFFECTIVE_DATE_TO VARCHAR2(32767);
94
95 P_EFFECTIVE_DATE_FROM_1 VARCHAR2(32767);
96
97 P_EFFECTIVE_DATE_TO_1 VARCHAR2(32767);
98
99 P_DISPLAY_DEBUG VARCHAR2(32767);
100
101 P_DISPLAY_BUG VARCHAR2(32767);
102
103 REPORT_SHORT_NAME2 VARCHAR2(240);
104
105 LIMIT_TYPE2 VARCHAR2(7);
106
107 AVAILABLE_HIGH_RANGE2 VARCHAR2(40);
108
109 AVAILABLE_LOW_RANGE2 VARCHAR2(40);
110
111 LIMIT_CODE2 VARCHAR2(7);
112
113 EFFECTIVE_DATE_FROM2 VARCHAR2(40);
114
115 EFFECTIVE_DATE_TO2 VARCHAR2(40);
116
117 P_CONC_REQUEST_ID NUMBER;
118
119 P_SQL_TRACE VARCHAR2(32767);
120
121 COMPANY_NAME_HEADER VARCHAR2(80);
122
123 REPORT_DATE VARCHAR2(100);
124
125 AMT_UNIT2 NUMBER;
126
127 Z1P_FACTOR VARCHAR2(300);
128
129 P_FACTOR VARCHAR2(10);
130
131 LP_FACTOR_DESC VARCHAR2(32767);
132
133 P_COMPANY_CODE VARCHAR2(32767);
134
135 Z3_CPARTY VARCHAR2(200);
136
137 Z3_CURR VARCHAR2(200);
138
139 Z3_GLOBAL VARCHAR2(200);
140
141 Z3_GROUP VARCHAR2(200);
142
143 Z3_NA VARCHAR2(200);
144
145 Z3_SETTLE VARCHAR2(200);
146
147 Z3_SOVGN VARCHAR2(200);
148
149 CP_PARA VARCHAR2(30);
150
151 FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
152
153 FUNCTION BEFOREREPORT RETURN BOOLEAN;
154
155 FUNCTION AFTERREPORT RETURN BOOLEAN;
156
157 FUNCTION AFTERPFORM RETURN BOOLEAN;
158
159 FUNCTION FC_GET_LIMIT_TYPE_DESCFORMULA(QRY_LIMIT_TYPE IN VARCHAR2) RETURN CHAR;
160
161 FUNCTION CP_PARA_P RETURN VARCHAR2;
162
163 END XTR_XTRLIUTL_XMLP_PKG;
164