[Home] [Help]
PACKAGE: APPS.OKL_ECC_VALUES_PVT_W
Source
1 package okl_ecc_values_pvt_w as
2 /* $Header: OKLEECVS.pls 120.1 2005/10/30 04:58:27 appldev noship $ */
3 procedure remove_ec_line(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p5_a0 NUMBER
9 , p5_a1 NUMBER
10 , p5_a2 NUMBER
11 , p5_a3 NUMBER
12 , p5_a4 DATE
13 , p5_a5 DATE
14 , p5_a6 VARCHAR2
15 , p5_a7 VARCHAR2
16 , p5_a8 NUMBER
17 , p5_a9 DATE
18 , p5_a10 NUMBER
19 , p5_a11 DATE
20 , p5_a12 NUMBER
21 );
22 procedure handle_eligibility_criteria(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , x_return_status out nocopy VARCHAR2
25 , x_msg_count out nocopy NUMBER
26 , x_msg_data out nocopy VARCHAR2
27 , p5_a0 NUMBER
28 , p5_a1 NUMBER
29 , p5_a2 NUMBER
30 , p5_a3 VARCHAR2
31 , p5_a4 VARCHAR2
32 , p5_a5 VARCHAR2
33 , p5_a6 NUMBER
34 , p5_a7 DATE
35 , p5_a8 NUMBER
36 , p5_a9 DATE
37 , p5_a10 NUMBER
38 , p6_a0 out nocopy NUMBER
39 , p6_a1 out nocopy NUMBER
40 , p6_a2 out nocopy NUMBER
41 , p6_a3 out nocopy VARCHAR2
42 , p6_a4 out nocopy VARCHAR2
43 , p6_a5 out nocopy VARCHAR2
44 , p6_a6 out nocopy NUMBER
45 , p6_a7 out nocopy DATE
46 , p6_a8 out nocopy NUMBER
47 , p6_a9 out nocopy DATE
48 , p6_a10 out nocopy NUMBER
49 , p7_a0 JTF_NUMBER_TABLE
50 , p7_a1 JTF_NUMBER_TABLE
51 , p7_a2 JTF_NUMBER_TABLE
52 , p7_a3 JTF_NUMBER_TABLE
53 , p7_a4 JTF_DATE_TABLE
54 , p7_a5 JTF_DATE_TABLE
55 , p7_a6 JTF_VARCHAR2_TABLE_100
56 , p7_a7 JTF_VARCHAR2_TABLE_100
57 , p7_a8 JTF_NUMBER_TABLE
58 , p7_a9 JTF_DATE_TABLE
59 , p7_a10 JTF_NUMBER_TABLE
60 , p7_a11 JTF_DATE_TABLE
61 , p7_a12 JTF_NUMBER_TABLE
62 , p8_a0 out nocopy JTF_NUMBER_TABLE
63 , p8_a1 out nocopy JTF_NUMBER_TABLE
64 , p8_a2 out nocopy JTF_NUMBER_TABLE
65 , p8_a3 out nocopy JTF_NUMBER_TABLE
66 , p8_a4 out nocopy JTF_DATE_TABLE
67 , p8_a5 out nocopy JTF_DATE_TABLE
68 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
69 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
70 , p8_a8 out nocopy JTF_NUMBER_TABLE
71 , p8_a9 out nocopy JTF_DATE_TABLE
72 , p8_a10 out nocopy JTF_NUMBER_TABLE
73 , p8_a11 out nocopy JTF_DATE_TABLE
74 , p8_a12 out nocopy JTF_NUMBER_TABLE
75 , p9_a0 JTF_NUMBER_TABLE
76 , p9_a1 JTF_NUMBER_TABLE
77 , p9_a2 JTF_NUMBER_TABLE
78 , p9_a3 JTF_VARCHAR2_TABLE_100
79 , p9_a4 JTF_VARCHAR2_TABLE_100
80 , p9_a5 JTF_VARCHAR2_TABLE_100
81 , p9_a6 JTF_VARCHAR2_TABLE_100
82 , p9_a7 JTF_VARCHAR2_TABLE_300
83 , p9_a8 JTF_VARCHAR2_TABLE_300
84 , p9_a9 JTF_NUMBER_TABLE
85 , p9_a10 JTF_NUMBER_TABLE
86 , p9_a11 JTF_DATE_TABLE
87 , p9_a12 JTF_DATE_TABLE
88 , p9_a13 JTF_VARCHAR2_TABLE_100
89 , p9_a14 JTF_NUMBER_TABLE
90 , p9_a15 JTF_NUMBER_TABLE
91 , p9_a16 JTF_DATE_TABLE
92 , p9_a17 JTF_NUMBER_TABLE
93 , p9_a18 JTF_DATE_TABLE
94 , p9_a19 JTF_NUMBER_TABLE
95 , p9_a20 JTF_VARCHAR2_TABLE_100
96 , p9_a21 JTF_VARCHAR2_TABLE_500
97 , p9_a22 JTF_VARCHAR2_TABLE_500
98 , p9_a23 JTF_VARCHAR2_TABLE_500
99 , p9_a24 JTF_VARCHAR2_TABLE_500
100 , p9_a25 JTF_VARCHAR2_TABLE_500
101 , p9_a26 JTF_VARCHAR2_TABLE_500
102 , p9_a27 JTF_VARCHAR2_TABLE_500
103 , p9_a28 JTF_VARCHAR2_TABLE_500
104 , p9_a29 JTF_VARCHAR2_TABLE_500
105 , p9_a30 JTF_VARCHAR2_TABLE_500
106 , p9_a31 JTF_VARCHAR2_TABLE_500
107 , p9_a32 JTF_VARCHAR2_TABLE_500
108 , p9_a33 JTF_VARCHAR2_TABLE_500
109 , p9_a34 JTF_VARCHAR2_TABLE_500
110 , p9_a35 JTF_VARCHAR2_TABLE_500
111 , p10_a0 out nocopy JTF_NUMBER_TABLE
112 , p10_a1 out nocopy JTF_NUMBER_TABLE
113 , p10_a2 out nocopy JTF_NUMBER_TABLE
114 , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
115 , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
116 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
117 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
118 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_300
119 , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
120 , p10_a9 out nocopy JTF_NUMBER_TABLE
121 , p10_a10 out nocopy JTF_NUMBER_TABLE
122 , p10_a11 out nocopy JTF_DATE_TABLE
123 , p10_a12 out nocopy JTF_DATE_TABLE
124 , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
125 , p10_a14 out nocopy JTF_NUMBER_TABLE
126 , p10_a15 out nocopy JTF_NUMBER_TABLE
127 , p10_a16 out nocopy JTF_DATE_TABLE
128 , p10_a17 out nocopy JTF_NUMBER_TABLE
129 , p10_a18 out nocopy JTF_DATE_TABLE
130 , p10_a19 out nocopy JTF_NUMBER_TABLE
131 , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
132 , p10_a21 out nocopy JTF_VARCHAR2_TABLE_500
133 , p10_a22 out nocopy JTF_VARCHAR2_TABLE_500
134 , p10_a23 out nocopy JTF_VARCHAR2_TABLE_500
135 , p10_a24 out nocopy JTF_VARCHAR2_TABLE_500
136 , p10_a25 out nocopy JTF_VARCHAR2_TABLE_500
137 , p10_a26 out nocopy JTF_VARCHAR2_TABLE_500
138 , p10_a27 out nocopy JTF_VARCHAR2_TABLE_500
139 , p10_a28 out nocopy JTF_VARCHAR2_TABLE_500
140 , p10_a29 out nocopy JTF_VARCHAR2_TABLE_500
141 , p10_a30 out nocopy JTF_VARCHAR2_TABLE_500
142 , p10_a31 out nocopy JTF_VARCHAR2_TABLE_500
143 , p10_a32 out nocopy JTF_VARCHAR2_TABLE_500
144 , p10_a33 out nocopy JTF_VARCHAR2_TABLE_500
145 , p10_a34 out nocopy JTF_VARCHAR2_TABLE_500
146 , p10_a35 out nocopy JTF_VARCHAR2_TABLE_500
147 , p_source_eff_from DATE
148 , p_source_eff_to DATE
149 );
150 procedure get_eligibility_criteria(p_api_version NUMBER
151 , p_init_msg_list VARCHAR2
152 , x_return_status out nocopy VARCHAR2
153 , x_msg_count out nocopy NUMBER
154 , x_msg_data out nocopy VARCHAR2
155 , p_source_id NUMBER
156 , p_source_type VARCHAR2
157 , p_eff_from DATE
158 , p_eff_to DATE
159 , p9_a0 out nocopy NUMBER
160 , p9_a1 out nocopy NUMBER
161 , p9_a2 out nocopy NUMBER
162 , p9_a3 out nocopy VARCHAR2
163 , p9_a4 out nocopy VARCHAR2
164 , p9_a5 out nocopy VARCHAR2
165 , p9_a6 out nocopy NUMBER
166 , p9_a7 out nocopy DATE
167 , p9_a8 out nocopy NUMBER
168 , p9_a9 out nocopy DATE
169 , p9_a10 out nocopy NUMBER
170 , p10_a0 out nocopy JTF_NUMBER_TABLE
171 , p10_a1 out nocopy JTF_NUMBER_TABLE
172 , p10_a2 out nocopy JTF_NUMBER_TABLE
173 , p10_a3 out nocopy JTF_NUMBER_TABLE
174 , p10_a4 out nocopy JTF_DATE_TABLE
175 , p10_a5 out nocopy JTF_DATE_TABLE
176 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
177 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
178 , p10_a8 out nocopy JTF_NUMBER_TABLE
179 , p10_a9 out nocopy JTF_DATE_TABLE
180 , p10_a10 out nocopy JTF_NUMBER_TABLE
181 , p10_a11 out nocopy JTF_DATE_TABLE
182 , p10_a12 out nocopy JTF_NUMBER_TABLE
183 , p11_a0 out nocopy JTF_NUMBER_TABLE
184 , p11_a1 out nocopy JTF_NUMBER_TABLE
185 , p11_a2 out nocopy JTF_NUMBER_TABLE
186 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
187 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
188 , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
189 , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
190 , p11_a7 out nocopy JTF_VARCHAR2_TABLE_300
191 , p11_a8 out nocopy JTF_VARCHAR2_TABLE_300
192 , p11_a9 out nocopy JTF_NUMBER_TABLE
193 , p11_a10 out nocopy JTF_NUMBER_TABLE
194 , p11_a11 out nocopy JTF_DATE_TABLE
195 , p11_a12 out nocopy JTF_DATE_TABLE
196 , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
197 , p11_a14 out nocopy JTF_NUMBER_TABLE
198 , p11_a15 out nocopy JTF_NUMBER_TABLE
199 , p11_a16 out nocopy JTF_DATE_TABLE
200 , p11_a17 out nocopy JTF_NUMBER_TABLE
201 , p11_a18 out nocopy JTF_DATE_TABLE
202 , p11_a19 out nocopy JTF_NUMBER_TABLE
203 , p11_a20 out nocopy JTF_VARCHAR2_TABLE_100
204 , p11_a21 out nocopy JTF_VARCHAR2_TABLE_500
205 , p11_a22 out nocopy JTF_VARCHAR2_TABLE_500
206 , p11_a23 out nocopy JTF_VARCHAR2_TABLE_500
207 , p11_a24 out nocopy JTF_VARCHAR2_TABLE_500
208 , p11_a25 out nocopy JTF_VARCHAR2_TABLE_500
209 , p11_a26 out nocopy JTF_VARCHAR2_TABLE_500
210 , p11_a27 out nocopy JTF_VARCHAR2_TABLE_500
211 , p11_a28 out nocopy JTF_VARCHAR2_TABLE_500
212 , p11_a29 out nocopy JTF_VARCHAR2_TABLE_500
213 , p11_a30 out nocopy JTF_VARCHAR2_TABLE_500
214 , p11_a31 out nocopy JTF_VARCHAR2_TABLE_500
215 , p11_a32 out nocopy JTF_VARCHAR2_TABLE_500
216 , p11_a33 out nocopy JTF_VARCHAR2_TABLE_500
217 , p11_a34 out nocopy JTF_VARCHAR2_TABLE_500
218 , p11_a35 out nocopy JTF_VARCHAR2_TABLE_500
219 );
220 procedure get_eligibility_criteria(p_api_version NUMBER
221 , p_init_msg_list VARCHAR2
222 , x_return_status out nocopy VARCHAR2
223 , x_msg_count out nocopy NUMBER
224 , x_msg_data out nocopy VARCHAR2
225 , p_source_id NUMBER
226 , p_source_type VARCHAR2
227 , p7_a0 out nocopy NUMBER
228 , p7_a1 out nocopy NUMBER
229 , p7_a2 out nocopy NUMBER
230 , p7_a3 out nocopy VARCHAR2
231 , p7_a4 out nocopy VARCHAR2
232 , p7_a5 out nocopy VARCHAR2
233 , p7_a6 out nocopy NUMBER
234 , p7_a7 out nocopy DATE
235 , p7_a8 out nocopy NUMBER
236 , p7_a9 out nocopy DATE
237 , p7_a10 out nocopy NUMBER
238 , p8_a0 out nocopy JTF_NUMBER_TABLE
239 , p8_a1 out nocopy JTF_NUMBER_TABLE
240 , p8_a2 out nocopy JTF_NUMBER_TABLE
241 , p8_a3 out nocopy JTF_NUMBER_TABLE
242 , p8_a4 out nocopy JTF_DATE_TABLE
243 , p8_a5 out nocopy JTF_DATE_TABLE
244 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
245 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
246 , p8_a8 out nocopy JTF_NUMBER_TABLE
247 , p8_a9 out nocopy JTF_DATE_TABLE
248 , p8_a10 out nocopy JTF_NUMBER_TABLE
249 , p8_a11 out nocopy JTF_DATE_TABLE
250 , p8_a12 out nocopy JTF_NUMBER_TABLE
251 , p9_a0 out nocopy JTF_NUMBER_TABLE
252 , p9_a1 out nocopy JTF_NUMBER_TABLE
253 , p9_a2 out nocopy JTF_NUMBER_TABLE
254 , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
255 , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
256 , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
257 , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
258 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_300
259 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_300
260 , p9_a9 out nocopy JTF_NUMBER_TABLE
261 , p9_a10 out nocopy JTF_NUMBER_TABLE
262 , p9_a11 out nocopy JTF_DATE_TABLE
263 , p9_a12 out nocopy JTF_DATE_TABLE
264 , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
265 , p9_a14 out nocopy JTF_NUMBER_TABLE
266 , p9_a15 out nocopy JTF_NUMBER_TABLE
267 , p9_a16 out nocopy JTF_DATE_TABLE
268 , p9_a17 out nocopy JTF_NUMBER_TABLE
269 , p9_a18 out nocopy JTF_DATE_TABLE
270 , p9_a19 out nocopy JTF_NUMBER_TABLE
271 , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
272 , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
273 , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
274 , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
275 , p9_a24 out nocopy JTF_VARCHAR2_TABLE_500
276 , p9_a25 out nocopy JTF_VARCHAR2_TABLE_500
277 , p9_a26 out nocopy JTF_VARCHAR2_TABLE_500
278 , p9_a27 out nocopy JTF_VARCHAR2_TABLE_500
279 , p9_a28 out nocopy JTF_VARCHAR2_TABLE_500
280 , p9_a29 out nocopy JTF_VARCHAR2_TABLE_500
281 , p9_a30 out nocopy JTF_VARCHAR2_TABLE_500
282 , p9_a31 out nocopy JTF_VARCHAR2_TABLE_500
283 , p9_a32 out nocopy JTF_VARCHAR2_TABLE_500
284 , p9_a33 out nocopy JTF_VARCHAR2_TABLE_500
285 , p9_a34 out nocopy JTF_VARCHAR2_TABLE_500
286 , p9_a35 out nocopy JTF_VARCHAR2_TABLE_500
287 );
288 end okl_ecc_values_pvt_w;