[Home] [Help]
PACKAGE BODY: APPS.OKL_LS_RT_FCTR_SETS_PUB_W
Source
1 package body okl_ls_rt_fctr_sets_pub_w as
2 /* $Header: OKLULRTB.pls 120.2 2005/08/11 11:56:26 asawanka noship $ */
3 procedure insert_ls_rt_fctr_sets(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 JTF_NUMBER_TABLE
9 , p5_a1 JTF_NUMBER_TABLE
10 , p5_a2 JTF_VARCHAR2_TABLE_100
11 , p5_a3 JTF_NUMBER_TABLE
12 , p5_a4 JTF_NUMBER_TABLE
13 , p5_a5 JTF_NUMBER_TABLE
14 , p5_a6 JTF_VARCHAR2_TABLE_100
15 , p5_a7 JTF_VARCHAR2_TABLE_100
16 , p5_a8 JTF_DATE_TABLE
17 , p5_a9 JTF_DATE_TABLE
18 , p5_a10 JTF_VARCHAR2_TABLE_200
19 , p5_a11 JTF_VARCHAR2_TABLE_2000
20 , p5_a12 JTF_NUMBER_TABLE
21 , p5_a13 JTF_DATE_TABLE
22 , p5_a14 JTF_NUMBER_TABLE
23 , p5_a15 JTF_DATE_TABLE
24 , p5_a16 JTF_NUMBER_TABLE
25 , p5_a17 JTF_VARCHAR2_TABLE_100
26 , p5_a18 JTF_VARCHAR2_TABLE_500
27 , p5_a19 JTF_VARCHAR2_TABLE_500
28 , p5_a20 JTF_VARCHAR2_TABLE_500
29 , p5_a21 JTF_VARCHAR2_TABLE_500
30 , p5_a22 JTF_VARCHAR2_TABLE_500
31 , p5_a23 JTF_VARCHAR2_TABLE_500
32 , p5_a24 JTF_VARCHAR2_TABLE_500
33 , p5_a25 JTF_VARCHAR2_TABLE_500
34 , p5_a26 JTF_VARCHAR2_TABLE_500
35 , p5_a27 JTF_VARCHAR2_TABLE_500
36 , p5_a28 JTF_VARCHAR2_TABLE_500
37 , p5_a29 JTF_VARCHAR2_TABLE_500
38 , p5_a30 JTF_VARCHAR2_TABLE_500
39 , p5_a31 JTF_VARCHAR2_TABLE_500
40 , p5_a32 JTF_VARCHAR2_TABLE_500
41 , p6_a0 out nocopy JTF_NUMBER_TABLE
42 , p6_a1 out nocopy JTF_NUMBER_TABLE
43 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
44 , p6_a3 out nocopy JTF_NUMBER_TABLE
45 , p6_a4 out nocopy JTF_NUMBER_TABLE
46 , p6_a5 out nocopy JTF_NUMBER_TABLE
47 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
48 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
49 , p6_a8 out nocopy JTF_DATE_TABLE
50 , p6_a9 out nocopy JTF_DATE_TABLE
51 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
52 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
53 , p6_a12 out nocopy JTF_NUMBER_TABLE
54 , p6_a13 out nocopy JTF_DATE_TABLE
55 , p6_a14 out nocopy JTF_NUMBER_TABLE
56 , p6_a15 out nocopy JTF_DATE_TABLE
57 , p6_a16 out nocopy JTF_NUMBER_TABLE
58 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
59 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
60 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
61 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
62 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
63 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
64 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
65 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
66 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
67 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
68 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
69 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
70 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
71 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
72 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
73 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
74 )
75
76 as
77 ddp_lrtv_tbl okl_ls_rt_fctr_sets_pub.lrtv_tbl_type;
78 ddx_lrtv_tbl okl_ls_rt_fctr_sets_pub.lrtv_tbl_type;
79 ddindx binary_integer; indx binary_integer;
80 begin
81 null;
82 end;
83
84 procedure insert_ls_rt_fctr_sets(p_api_version NUMBER
85 , p_init_msg_list VARCHAR2
86 , x_return_status out nocopy VARCHAR2
87 , x_msg_count out nocopy NUMBER
88 , x_msg_data out nocopy VARCHAR2
89 , p5_a0 NUMBER
90 , p5_a1 NUMBER
91 , p5_a2 VARCHAR2
92 , p5_a3 NUMBER
93 , p5_a4 NUMBER
94 , p5_a5 NUMBER
95 , p5_a6 VARCHAR2
96 , p5_a7 VARCHAR2
97 , p5_a8 DATE
98 , p5_a9 DATE
99 , p5_a10 VARCHAR2
100 , p5_a11 VARCHAR2
101 , p5_a12 NUMBER
102 , p5_a13 DATE
103 , p5_a14 NUMBER
104 , p5_a15 DATE
105 , p5_a16 NUMBER
106 , p5_a17 VARCHAR2
107 , p5_a18 VARCHAR2
108 , p5_a19 VARCHAR2
109 , p5_a20 VARCHAR2
110 , p5_a21 VARCHAR2
111 , p5_a22 VARCHAR2
112 , p5_a23 VARCHAR2
113 , p5_a24 VARCHAR2
114 , p5_a25 VARCHAR2
115 , p5_a26 VARCHAR2
116 , p5_a27 VARCHAR2
117 , p5_a28 VARCHAR2
118 , p5_a29 VARCHAR2
119 , p5_a30 VARCHAR2
120 , p5_a31 VARCHAR2
121 , p5_a32 VARCHAR2
122 , p6_a0 out nocopy NUMBER
123 , p6_a1 out nocopy NUMBER
124 , p6_a2 out nocopy VARCHAR2
125 , p6_a3 out nocopy NUMBER
126 , p6_a4 out nocopy NUMBER
127 , p6_a5 out nocopy NUMBER
128 , p6_a6 out nocopy VARCHAR2
129 , p6_a7 out nocopy VARCHAR2
130 , p6_a8 out nocopy DATE
131 , p6_a9 out nocopy DATE
132 , p6_a10 out nocopy VARCHAR2
133 , p6_a11 out nocopy VARCHAR2
134 , p6_a12 out nocopy NUMBER
135 , p6_a13 out nocopy DATE
136 , p6_a14 out nocopy NUMBER
137 , p6_a15 out nocopy DATE
138 , p6_a16 out nocopy NUMBER
139 , p6_a17 out nocopy VARCHAR2
140 , p6_a18 out nocopy VARCHAR2
141 , p6_a19 out nocopy VARCHAR2
142 , p6_a20 out nocopy VARCHAR2
143 , p6_a21 out nocopy VARCHAR2
144 , p6_a22 out nocopy VARCHAR2
145 , p6_a23 out nocopy VARCHAR2
146 , p6_a24 out nocopy VARCHAR2
147 , p6_a25 out nocopy VARCHAR2
148 , p6_a26 out nocopy VARCHAR2
149 , p6_a27 out nocopy VARCHAR2
150 , p6_a28 out nocopy VARCHAR2
151 , p6_a29 out nocopy VARCHAR2
152 , p6_a30 out nocopy VARCHAR2
153 , p6_a31 out nocopy VARCHAR2
154 , p6_a32 out nocopy VARCHAR2
155 )
156
157 as
158 ddp_lrtv_rec okl_ls_rt_fctr_sets_pub.lrtv_rec_type;
159 ddx_lrtv_rec okl_ls_rt_fctr_sets_pub.lrtv_rec_type;
160 ddindx binary_integer; indx binary_integer;
161 begin
162 null;
163 end;
164
165 procedure lock_ls_rt_fctr_sets(p_api_version NUMBER
166 , p_init_msg_list VARCHAR2
167 , x_return_status out nocopy VARCHAR2
168 , x_msg_count out nocopy NUMBER
169 , x_msg_data out nocopy VARCHAR2
170 , p5_a0 JTF_NUMBER_TABLE
171 , p5_a1 JTF_NUMBER_TABLE
172 , p5_a2 JTF_VARCHAR2_TABLE_100
173 , p5_a3 JTF_NUMBER_TABLE
174 , p5_a4 JTF_NUMBER_TABLE
175 , p5_a5 JTF_NUMBER_TABLE
176 , p5_a6 JTF_VARCHAR2_TABLE_100
177 , p5_a7 JTF_VARCHAR2_TABLE_100
178 , p5_a8 JTF_DATE_TABLE
179 , p5_a9 JTF_DATE_TABLE
180 , p5_a10 JTF_VARCHAR2_TABLE_200
181 , p5_a11 JTF_VARCHAR2_TABLE_2000
182 , p5_a12 JTF_NUMBER_TABLE
183 , p5_a13 JTF_DATE_TABLE
184 , p5_a14 JTF_NUMBER_TABLE
185 , p5_a15 JTF_DATE_TABLE
186 , p5_a16 JTF_NUMBER_TABLE
187 , p5_a17 JTF_VARCHAR2_TABLE_100
188 , p5_a18 JTF_VARCHAR2_TABLE_500
189 , p5_a19 JTF_VARCHAR2_TABLE_500
190 , p5_a20 JTF_VARCHAR2_TABLE_500
191 , p5_a21 JTF_VARCHAR2_TABLE_500
192 , p5_a22 JTF_VARCHAR2_TABLE_500
193 , p5_a23 JTF_VARCHAR2_TABLE_500
194 , p5_a24 JTF_VARCHAR2_TABLE_500
195 , p5_a25 JTF_VARCHAR2_TABLE_500
196 , p5_a26 JTF_VARCHAR2_TABLE_500
197 , p5_a27 JTF_VARCHAR2_TABLE_500
198 , p5_a28 JTF_VARCHAR2_TABLE_500
199 , p5_a29 JTF_VARCHAR2_TABLE_500
200 , p5_a30 JTF_VARCHAR2_TABLE_500
201 , p5_a31 JTF_VARCHAR2_TABLE_500
202 , p5_a32 JTF_VARCHAR2_TABLE_500
203 )
204
205 as
206 ddp_lrtv_tbl okl_ls_rt_fctr_sets_pub.lrtv_tbl_type;
207 ddindx binary_integer; indx binary_integer;
208 begin
209 null;
210 end;
211
212 procedure lock_ls_rt_fctr_sets(p_api_version NUMBER
213 , p_init_msg_list VARCHAR2
214 , x_return_status out nocopy VARCHAR2
215 , x_msg_count out nocopy NUMBER
216 , x_msg_data out nocopy VARCHAR2
217 , p5_a0 NUMBER
218 , p5_a1 NUMBER
219 , p5_a2 VARCHAR2
220 , p5_a3 NUMBER
221 , p5_a4 NUMBER
222 , p5_a5 NUMBER
223 , p5_a6 VARCHAR2
224 , p5_a7 VARCHAR2
225 , p5_a8 DATE
226 , p5_a9 DATE
227 , p5_a10 VARCHAR2
228 , p5_a11 VARCHAR2
229 , p5_a12 NUMBER
230 , p5_a13 DATE
231 , p5_a14 NUMBER
232 , p5_a15 DATE
233 , p5_a16 NUMBER
234 , p5_a17 VARCHAR2
235 , p5_a18 VARCHAR2
236 , p5_a19 VARCHAR2
237 , p5_a20 VARCHAR2
238 , p5_a21 VARCHAR2
239 , p5_a22 VARCHAR2
240 , p5_a23 VARCHAR2
241 , p5_a24 VARCHAR2
242 , p5_a25 VARCHAR2
243 , p5_a26 VARCHAR2
244 , p5_a27 VARCHAR2
245 , p5_a28 VARCHAR2
246 , p5_a29 VARCHAR2
247 , p5_a30 VARCHAR2
248 , p5_a31 VARCHAR2
249 , p5_a32 VARCHAR2
250 )
251
252 as
253 ddp_lrtv_rec okl_ls_rt_fctr_sets_pub.lrtv_rec_type;
254 ddindx binary_integer; indx binary_integer;
255 begin
256 null;
257 end;
258
259 procedure update_ls_rt_fctr_sets(p_api_version NUMBER
260 , p_init_msg_list VARCHAR2
261 , x_return_status out nocopy VARCHAR2
262 , x_msg_count out nocopy NUMBER
263 , x_msg_data out nocopy VARCHAR2
264 , p5_a0 JTF_NUMBER_TABLE
265 , p5_a1 JTF_NUMBER_TABLE
266 , p5_a2 JTF_VARCHAR2_TABLE_100
267 , p5_a3 JTF_NUMBER_TABLE
268 , p5_a4 JTF_NUMBER_TABLE
269 , p5_a5 JTF_NUMBER_TABLE
270 , p5_a6 JTF_VARCHAR2_TABLE_100
271 , p5_a7 JTF_VARCHAR2_TABLE_100
272 , p5_a8 JTF_DATE_TABLE
273 , p5_a9 JTF_DATE_TABLE
274 , p5_a10 JTF_VARCHAR2_TABLE_200
275 , p5_a11 JTF_VARCHAR2_TABLE_2000
276 , p5_a12 JTF_NUMBER_TABLE
277 , p5_a13 JTF_DATE_TABLE
278 , p5_a14 JTF_NUMBER_TABLE
279 , p5_a15 JTF_DATE_TABLE
280 , p5_a16 JTF_NUMBER_TABLE
281 , p5_a17 JTF_VARCHAR2_TABLE_100
282 , p5_a18 JTF_VARCHAR2_TABLE_500
283 , p5_a19 JTF_VARCHAR2_TABLE_500
284 , p5_a20 JTF_VARCHAR2_TABLE_500
285 , p5_a21 JTF_VARCHAR2_TABLE_500
286 , p5_a22 JTF_VARCHAR2_TABLE_500
287 , p5_a23 JTF_VARCHAR2_TABLE_500
288 , p5_a24 JTF_VARCHAR2_TABLE_500
289 , p5_a25 JTF_VARCHAR2_TABLE_500
290 , p5_a26 JTF_VARCHAR2_TABLE_500
291 , p5_a27 JTF_VARCHAR2_TABLE_500
292 , p5_a28 JTF_VARCHAR2_TABLE_500
293 , p5_a29 JTF_VARCHAR2_TABLE_500
294 , p5_a30 JTF_VARCHAR2_TABLE_500
295 , p5_a31 JTF_VARCHAR2_TABLE_500
296 , p5_a32 JTF_VARCHAR2_TABLE_500
297 , p6_a0 out nocopy JTF_NUMBER_TABLE
298 , p6_a1 out nocopy JTF_NUMBER_TABLE
299 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
300 , p6_a3 out nocopy JTF_NUMBER_TABLE
301 , p6_a4 out nocopy JTF_NUMBER_TABLE
302 , p6_a5 out nocopy JTF_NUMBER_TABLE
303 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
304 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
305 , p6_a8 out nocopy JTF_DATE_TABLE
306 , p6_a9 out nocopy JTF_DATE_TABLE
307 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
308 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
309 , p6_a12 out nocopy JTF_NUMBER_TABLE
310 , p6_a13 out nocopy JTF_DATE_TABLE
311 , p6_a14 out nocopy JTF_NUMBER_TABLE
312 , p6_a15 out nocopy JTF_DATE_TABLE
313 , p6_a16 out nocopy JTF_NUMBER_TABLE
314 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
315 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
316 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
317 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
318 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
319 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
320 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
321 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
322 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
323 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
324 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
325 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
326 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
327 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
328 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
329 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
330 )
331
332 as
333 ddp_lrtv_tbl okl_ls_rt_fctr_sets_pub.lrtv_tbl_type;
334 ddx_lrtv_tbl okl_ls_rt_fctr_sets_pub.lrtv_tbl_type;
335 ddindx binary_integer; indx binary_integer;
336 begin
337 null;
338 end;
339
340 procedure update_ls_rt_fctr_sets(p_api_version NUMBER
341 , p_init_msg_list VARCHAR2
342 , x_return_status out nocopy VARCHAR2
343 , x_msg_count out nocopy NUMBER
344 , x_msg_data out nocopy VARCHAR2
345 , p5_a0 NUMBER
346 , p5_a1 NUMBER
347 , p5_a2 VARCHAR2
348 , p5_a3 NUMBER
349 , p5_a4 NUMBER
350 , p5_a5 NUMBER
351 , p5_a6 VARCHAR2
352 , p5_a7 VARCHAR2
353 , p5_a8 DATE
354 , p5_a9 DATE
355 , p5_a10 VARCHAR2
356 , p5_a11 VARCHAR2
357 , p5_a12 NUMBER
358 , p5_a13 DATE
359 , p5_a14 NUMBER
360 , p5_a15 DATE
361 , p5_a16 NUMBER
362 , p5_a17 VARCHAR2
363 , p5_a18 VARCHAR2
364 , p5_a19 VARCHAR2
365 , p5_a20 VARCHAR2
366 , p5_a21 VARCHAR2
367 , p5_a22 VARCHAR2
368 , p5_a23 VARCHAR2
369 , p5_a24 VARCHAR2
370 , p5_a25 VARCHAR2
371 , p5_a26 VARCHAR2
372 , p5_a27 VARCHAR2
373 , p5_a28 VARCHAR2
374 , p5_a29 VARCHAR2
375 , p5_a30 VARCHAR2
376 , p5_a31 VARCHAR2
377 , p5_a32 VARCHAR2
378 , p6_a0 out nocopy NUMBER
379 , p6_a1 out nocopy NUMBER
380 , p6_a2 out nocopy VARCHAR2
381 , p6_a3 out nocopy NUMBER
382 , p6_a4 out nocopy NUMBER
383 , p6_a5 out nocopy NUMBER
384 , p6_a6 out nocopy VARCHAR2
385 , p6_a7 out nocopy VARCHAR2
386 , p6_a8 out nocopy DATE
387 , p6_a9 out nocopy DATE
388 , p6_a10 out nocopy VARCHAR2
389 , p6_a11 out nocopy VARCHAR2
390 , p6_a12 out nocopy NUMBER
391 , p6_a13 out nocopy DATE
392 , p6_a14 out nocopy NUMBER
393 , p6_a15 out nocopy DATE
394 , p6_a16 out nocopy NUMBER
395 , p6_a17 out nocopy VARCHAR2
396 , p6_a18 out nocopy VARCHAR2
397 , p6_a19 out nocopy VARCHAR2
398 , p6_a20 out nocopy VARCHAR2
399 , p6_a21 out nocopy VARCHAR2
400 , p6_a22 out nocopy VARCHAR2
401 , p6_a23 out nocopy VARCHAR2
402 , p6_a24 out nocopy VARCHAR2
403 , p6_a25 out nocopy VARCHAR2
404 , p6_a26 out nocopy VARCHAR2
405 , p6_a27 out nocopy VARCHAR2
406 , p6_a28 out nocopy VARCHAR2
407 , p6_a29 out nocopy VARCHAR2
408 , p6_a30 out nocopy VARCHAR2
409 , p6_a31 out nocopy VARCHAR2
410 , p6_a32 out nocopy VARCHAR2
411 )
412
413 as
414 ddp_lrtv_rec okl_ls_rt_fctr_sets_pub.lrtv_rec_type;
415 ddx_lrtv_rec okl_ls_rt_fctr_sets_pub.lrtv_rec_type;
416 ddindx binary_integer; indx binary_integer;
417 begin
418 null;
419 end;
420
421 procedure delete_ls_rt_fctr_sets(p_api_version NUMBER
422 , p_init_msg_list VARCHAR2
423 , x_return_status out nocopy VARCHAR2
424 , x_msg_count out nocopy NUMBER
425 , x_msg_data out nocopy VARCHAR2
426 , p5_a0 JTF_NUMBER_TABLE
427 , p5_a1 JTF_NUMBER_TABLE
428 , p5_a2 JTF_VARCHAR2_TABLE_100
429 , p5_a3 JTF_NUMBER_TABLE
430 , p5_a4 JTF_NUMBER_TABLE
431 , p5_a5 JTF_NUMBER_TABLE
432 , p5_a6 JTF_VARCHAR2_TABLE_100
433 , p5_a7 JTF_VARCHAR2_TABLE_100
434 , p5_a8 JTF_DATE_TABLE
435 , p5_a9 JTF_DATE_TABLE
436 , p5_a10 JTF_VARCHAR2_TABLE_200
437 , p5_a11 JTF_VARCHAR2_TABLE_2000
438 , p5_a12 JTF_NUMBER_TABLE
439 , p5_a13 JTF_DATE_TABLE
440 , p5_a14 JTF_NUMBER_TABLE
441 , p5_a15 JTF_DATE_TABLE
442 , p5_a16 JTF_NUMBER_TABLE
443 , p5_a17 JTF_VARCHAR2_TABLE_100
444 , p5_a18 JTF_VARCHAR2_TABLE_500
445 , p5_a19 JTF_VARCHAR2_TABLE_500
446 , p5_a20 JTF_VARCHAR2_TABLE_500
447 , p5_a21 JTF_VARCHAR2_TABLE_500
448 , p5_a22 JTF_VARCHAR2_TABLE_500
449 , p5_a23 JTF_VARCHAR2_TABLE_500
450 , p5_a24 JTF_VARCHAR2_TABLE_500
451 , p5_a25 JTF_VARCHAR2_TABLE_500
452 , p5_a26 JTF_VARCHAR2_TABLE_500
453 , p5_a27 JTF_VARCHAR2_TABLE_500
454 , p5_a28 JTF_VARCHAR2_TABLE_500
455 , p5_a29 JTF_VARCHAR2_TABLE_500
456 , p5_a30 JTF_VARCHAR2_TABLE_500
457 , p5_a31 JTF_VARCHAR2_TABLE_500
458 , p5_a32 JTF_VARCHAR2_TABLE_500
459 )
460
461 as
462 ddp_lrtv_tbl okl_ls_rt_fctr_sets_pub.lrtv_tbl_type;
463 ddindx binary_integer; indx binary_integer;
464 begin
465 null;
466 end;
467
468 procedure delete_ls_rt_fctr_sets(p_api_version NUMBER
469 , p_init_msg_list VARCHAR2
470 , x_return_status out nocopy VARCHAR2
471 , x_msg_count out nocopy NUMBER
472 , x_msg_data out nocopy VARCHAR2
473 , p5_a0 NUMBER
474 , p5_a1 NUMBER
475 , p5_a2 VARCHAR2
476 , p5_a3 NUMBER
477 , p5_a4 NUMBER
478 , p5_a5 NUMBER
479 , p5_a6 VARCHAR2
480 , p5_a7 VARCHAR2
481 , p5_a8 DATE
482 , p5_a9 DATE
483 , p5_a10 VARCHAR2
484 , p5_a11 VARCHAR2
485 , p5_a12 NUMBER
486 , p5_a13 DATE
487 , p5_a14 NUMBER
488 , p5_a15 DATE
489 , p5_a16 NUMBER
490 , p5_a17 VARCHAR2
491 , p5_a18 VARCHAR2
492 , p5_a19 VARCHAR2
493 , p5_a20 VARCHAR2
494 , p5_a21 VARCHAR2
495 , p5_a22 VARCHAR2
496 , p5_a23 VARCHAR2
497 , p5_a24 VARCHAR2
498 , p5_a25 VARCHAR2
499 , p5_a26 VARCHAR2
500 , p5_a27 VARCHAR2
501 , p5_a28 VARCHAR2
502 , p5_a29 VARCHAR2
503 , p5_a30 VARCHAR2
504 , p5_a31 VARCHAR2
505 , p5_a32 VARCHAR2
506 )
507
508 as
509 ddp_lrtv_rec okl_ls_rt_fctr_sets_pub.lrtv_rec_type;
510 ddindx binary_integer; indx binary_integer;
511 begin
512 null;
513 end;
514
515 procedure validate_ls_rt_fctr_sets(p_api_version NUMBER
516 , p_init_msg_list VARCHAR2
517 , x_return_status out nocopy VARCHAR2
518 , x_msg_count out nocopy NUMBER
519 , x_msg_data out nocopy VARCHAR2
520 , p5_a0 JTF_NUMBER_TABLE
521 , p5_a1 JTF_NUMBER_TABLE
522 , p5_a2 JTF_VARCHAR2_TABLE_100
523 , p5_a3 JTF_NUMBER_TABLE
524 , p5_a4 JTF_NUMBER_TABLE
525 , p5_a5 JTF_NUMBER_TABLE
526 , p5_a6 JTF_VARCHAR2_TABLE_100
527 , p5_a7 JTF_VARCHAR2_TABLE_100
528 , p5_a8 JTF_DATE_TABLE
529 , p5_a9 JTF_DATE_TABLE
530 , p5_a10 JTF_VARCHAR2_TABLE_200
531 , p5_a11 JTF_VARCHAR2_TABLE_2000
532 , p5_a12 JTF_NUMBER_TABLE
533 , p5_a13 JTF_DATE_TABLE
534 , p5_a14 JTF_NUMBER_TABLE
535 , p5_a15 JTF_DATE_TABLE
536 , p5_a16 JTF_NUMBER_TABLE
537 , p5_a17 JTF_VARCHAR2_TABLE_100
538 , p5_a18 JTF_VARCHAR2_TABLE_500
539 , p5_a19 JTF_VARCHAR2_TABLE_500
540 , p5_a20 JTF_VARCHAR2_TABLE_500
541 , p5_a21 JTF_VARCHAR2_TABLE_500
542 , p5_a22 JTF_VARCHAR2_TABLE_500
543 , p5_a23 JTF_VARCHAR2_TABLE_500
544 , p5_a24 JTF_VARCHAR2_TABLE_500
545 , p5_a25 JTF_VARCHAR2_TABLE_500
546 , p5_a26 JTF_VARCHAR2_TABLE_500
547 , p5_a27 JTF_VARCHAR2_TABLE_500
548 , p5_a28 JTF_VARCHAR2_TABLE_500
549 , p5_a29 JTF_VARCHAR2_TABLE_500
550 , p5_a30 JTF_VARCHAR2_TABLE_500
551 , p5_a31 JTF_VARCHAR2_TABLE_500
552 , p5_a32 JTF_VARCHAR2_TABLE_500
553 )
554
555 as
556 ddp_lrtv_tbl okl_ls_rt_fctr_sets_pub.lrtv_tbl_type;
557 ddindx binary_integer; indx binary_integer;
558 begin
559 null;
560 end;
561
562 procedure validate_ls_rt_fctr_sets(p_api_version NUMBER
563 , p_init_msg_list VARCHAR2
564 , x_return_status out nocopy VARCHAR2
565 , x_msg_count out nocopy NUMBER
566 , x_msg_data out nocopy VARCHAR2
567 , p5_a0 NUMBER
568 , p5_a1 NUMBER
569 , p5_a2 VARCHAR2
570 , p5_a3 NUMBER
571 , p5_a4 NUMBER
572 , p5_a5 NUMBER
573 , p5_a6 VARCHAR2
574 , p5_a7 VARCHAR2
575 , p5_a8 DATE
576 , p5_a9 DATE
577 , p5_a10 VARCHAR2
578 , p5_a11 VARCHAR2
579 , p5_a12 NUMBER
580 , p5_a13 DATE
581 , p5_a14 NUMBER
582 , p5_a15 DATE
583 , p5_a16 NUMBER
584 , p5_a17 VARCHAR2
585 , p5_a18 VARCHAR2
586 , p5_a19 VARCHAR2
587 , p5_a20 VARCHAR2
588 , p5_a21 VARCHAR2
589 , p5_a22 VARCHAR2
590 , p5_a23 VARCHAR2
591 , p5_a24 VARCHAR2
592 , p5_a25 VARCHAR2
593 , p5_a26 VARCHAR2
594 , p5_a27 VARCHAR2
595 , p5_a28 VARCHAR2
596 , p5_a29 VARCHAR2
597 , p5_a30 VARCHAR2
598 , p5_a31 VARCHAR2
599 , p5_a32 VARCHAR2
600 )
601
602 as
603 ddp_lrtv_rec okl_ls_rt_fctr_sets_pub.lrtv_rec_type;
604 ddindx binary_integer; indx binary_integer;
605 begin
606 null;
607 end;
608
609 end okl_ls_rt_fctr_sets_pub_w;