18: , p5_a10 DATE
19: , p5_a11 NUMBER
20: , p5_a12 DATE
21: , p5_a13 NUMBER
22: , p6_a0 JTF_NUMBER_TABLE
23: , p6_a1 JTF_NUMBER_TABLE
24: , p6_a2 JTF_NUMBER_TABLE
25: , p6_a3 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
19: , p5_a11 NUMBER
20: , p5_a12 DATE
21: , p5_a13 NUMBER
22: , p6_a0 JTF_NUMBER_TABLE
23: , p6_a1 JTF_NUMBER_TABLE
24: , p6_a2 JTF_NUMBER_TABLE
25: , p6_a3 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
27: , p6_a5 JTF_NUMBER_TABLE
20: , p5_a12 DATE
21: , p5_a13 NUMBER
22: , p6_a0 JTF_NUMBER_TABLE
23: , p6_a1 JTF_NUMBER_TABLE
24: , p6_a2 JTF_NUMBER_TABLE
25: , p6_a3 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
27: , p6_a5 JTF_NUMBER_TABLE
28: , p6_a6 JTF_DATE_TABLE
21: , p5_a13 NUMBER
22: , p6_a0 JTF_NUMBER_TABLE
23: , p6_a1 JTF_NUMBER_TABLE
24: , p6_a2 JTF_NUMBER_TABLE
25: , p6_a3 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
27: , p6_a5 JTF_NUMBER_TABLE
28: , p6_a6 JTF_DATE_TABLE
29: , p6_a7 JTF_NUMBER_TABLE
23: , p6_a1 JTF_NUMBER_TABLE
24: , p6_a2 JTF_NUMBER_TABLE
25: , p6_a3 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
27: , p6_a5 JTF_NUMBER_TABLE
28: , p6_a6 JTF_DATE_TABLE
29: , p6_a7 JTF_NUMBER_TABLE
30: , p6_a8 JTF_NUMBER_TABLE
31: , p6_a9 JTF_NUMBER_TABLE
25: , p6_a3 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
27: , p6_a5 JTF_NUMBER_TABLE
28: , p6_a6 JTF_DATE_TABLE
29: , p6_a7 JTF_NUMBER_TABLE
30: , p6_a8 JTF_NUMBER_TABLE
31: , p6_a9 JTF_NUMBER_TABLE
32: , p6_a10 JTF_NUMBER_TABLE
33: , p6_a11 JTF_NUMBER_TABLE
26: , p6_a4 JTF_DATE_TABLE
27: , p6_a5 JTF_NUMBER_TABLE
28: , p6_a6 JTF_DATE_TABLE
29: , p6_a7 JTF_NUMBER_TABLE
30: , p6_a8 JTF_NUMBER_TABLE
31: , p6_a9 JTF_NUMBER_TABLE
32: , p6_a10 JTF_NUMBER_TABLE
33: , p6_a11 JTF_NUMBER_TABLE
34: , p7_a0 out nocopy NUMBER
27: , p6_a5 JTF_NUMBER_TABLE
28: , p6_a6 JTF_DATE_TABLE
29: , p6_a7 JTF_NUMBER_TABLE
30: , p6_a8 JTF_NUMBER_TABLE
31: , p6_a9 JTF_NUMBER_TABLE
32: , p6_a10 JTF_NUMBER_TABLE
33: , p6_a11 JTF_NUMBER_TABLE
34: , p7_a0 out nocopy NUMBER
35: , p7_a1 out nocopy NUMBER
28: , p6_a6 JTF_DATE_TABLE
29: , p6_a7 JTF_NUMBER_TABLE
30: , p6_a8 JTF_NUMBER_TABLE
31: , p6_a9 JTF_NUMBER_TABLE
32: , p6_a10 JTF_NUMBER_TABLE
33: , p6_a11 JTF_NUMBER_TABLE
34: , p7_a0 out nocopy NUMBER
35: , p7_a1 out nocopy NUMBER
36: , p7_a2 out nocopy NUMBER
29: , p6_a7 JTF_NUMBER_TABLE
30: , p6_a8 JTF_NUMBER_TABLE
31: , p6_a9 JTF_NUMBER_TABLE
32: , p6_a10 JTF_NUMBER_TABLE
33: , p6_a11 JTF_NUMBER_TABLE
34: , p7_a0 out nocopy NUMBER
35: , p7_a1 out nocopy NUMBER
36: , p7_a2 out nocopy NUMBER
37: , p7_a3 out nocopy NUMBER
44: , p7_a10 out nocopy DATE
45: , p7_a11 out nocopy NUMBER
46: , p7_a12 out nocopy DATE
47: , p7_a13 out nocopy NUMBER
48: , p8_a0 out nocopy JTF_NUMBER_TABLE
49: , p8_a1 out nocopy JTF_NUMBER_TABLE
50: , p8_a2 out nocopy JTF_NUMBER_TABLE
51: , p8_a3 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
45: , p7_a11 out nocopy NUMBER
46: , p7_a12 out nocopy DATE
47: , p7_a13 out nocopy NUMBER
48: , p8_a0 out nocopy JTF_NUMBER_TABLE
49: , p8_a1 out nocopy JTF_NUMBER_TABLE
50: , p8_a2 out nocopy JTF_NUMBER_TABLE
51: , p8_a3 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
46: , p7_a12 out nocopy DATE
47: , p7_a13 out nocopy NUMBER
48: , p8_a0 out nocopy JTF_NUMBER_TABLE
49: , p8_a1 out nocopy JTF_NUMBER_TABLE
50: , p8_a2 out nocopy JTF_NUMBER_TABLE
51: , p8_a3 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
54: , p8_a6 out nocopy JTF_DATE_TABLE
47: , p7_a13 out nocopy NUMBER
48: , p8_a0 out nocopy JTF_NUMBER_TABLE
49: , p8_a1 out nocopy JTF_NUMBER_TABLE
50: , p8_a2 out nocopy JTF_NUMBER_TABLE
51: , p8_a3 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
54: , p8_a6 out nocopy JTF_DATE_TABLE
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
49: , p8_a1 out nocopy JTF_NUMBER_TABLE
50: , p8_a2 out nocopy JTF_NUMBER_TABLE
51: , p8_a3 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
54: , p8_a6 out nocopy JTF_DATE_TABLE
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
56: , p8_a8 out nocopy JTF_NUMBER_TABLE
57: , p8_a9 out nocopy JTF_NUMBER_TABLE
51: , p8_a3 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
54: , p8_a6 out nocopy JTF_DATE_TABLE
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
56: , p8_a8 out nocopy JTF_NUMBER_TABLE
57: , p8_a9 out nocopy JTF_NUMBER_TABLE
58: , p8_a10 out nocopy JTF_NUMBER_TABLE
59: , p8_a11 out nocopy JTF_NUMBER_TABLE
52: , p8_a4 out nocopy JTF_DATE_TABLE
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
54: , p8_a6 out nocopy JTF_DATE_TABLE
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
56: , p8_a8 out nocopy JTF_NUMBER_TABLE
57: , p8_a9 out nocopy JTF_NUMBER_TABLE
58: , p8_a10 out nocopy JTF_NUMBER_TABLE
59: , p8_a11 out nocopy JTF_NUMBER_TABLE
60: )
53: , p8_a5 out nocopy JTF_NUMBER_TABLE
54: , p8_a6 out nocopy JTF_DATE_TABLE
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
56: , p8_a8 out nocopy JTF_NUMBER_TABLE
57: , p8_a9 out nocopy JTF_NUMBER_TABLE
58: , p8_a10 out nocopy JTF_NUMBER_TABLE
59: , p8_a11 out nocopy JTF_NUMBER_TABLE
60: )
61:
54: , p8_a6 out nocopy JTF_DATE_TABLE
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
56: , p8_a8 out nocopy JTF_NUMBER_TABLE
57: , p8_a9 out nocopy JTF_NUMBER_TABLE
58: , p8_a10 out nocopy JTF_NUMBER_TABLE
59: , p8_a11 out nocopy JTF_NUMBER_TABLE
60: )
61:
62: as
55: , p8_a7 out nocopy JTF_NUMBER_TABLE
56: , p8_a8 out nocopy JTF_NUMBER_TABLE
57: , p8_a9 out nocopy JTF_NUMBER_TABLE
58: , p8_a10 out nocopy JTF_NUMBER_TABLE
59: , p8_a11 out nocopy JTF_NUMBER_TABLE
60: )
61:
62: as
63: ddp_rcsv_rec okl_resi_cat_sets_pvt.okl_rcsv_rec;
171: , p5_a10 DATE
172: , p5_a11 NUMBER
173: , p5_a12 DATE
174: , p5_a13 NUMBER
175: , p6_a0 JTF_NUMBER_TABLE
176: , p6_a1 JTF_NUMBER_TABLE
177: , p6_a2 JTF_NUMBER_TABLE
178: , p6_a3 JTF_NUMBER_TABLE
179: , p6_a4 JTF_DATE_TABLE
172: , p5_a11 NUMBER
173: , p5_a12 DATE
174: , p5_a13 NUMBER
175: , p6_a0 JTF_NUMBER_TABLE
176: , p6_a1 JTF_NUMBER_TABLE
177: , p6_a2 JTF_NUMBER_TABLE
178: , p6_a3 JTF_NUMBER_TABLE
179: , p6_a4 JTF_DATE_TABLE
180: , p6_a5 JTF_NUMBER_TABLE
173: , p5_a12 DATE
174: , p5_a13 NUMBER
175: , p6_a0 JTF_NUMBER_TABLE
176: , p6_a1 JTF_NUMBER_TABLE
177: , p6_a2 JTF_NUMBER_TABLE
178: , p6_a3 JTF_NUMBER_TABLE
179: , p6_a4 JTF_DATE_TABLE
180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_DATE_TABLE
174: , p5_a13 NUMBER
175: , p6_a0 JTF_NUMBER_TABLE
176: , p6_a1 JTF_NUMBER_TABLE
177: , p6_a2 JTF_NUMBER_TABLE
178: , p6_a3 JTF_NUMBER_TABLE
179: , p6_a4 JTF_DATE_TABLE
180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_DATE_TABLE
182: , p6_a7 JTF_NUMBER_TABLE
176: , p6_a1 JTF_NUMBER_TABLE
177: , p6_a2 JTF_NUMBER_TABLE
178: , p6_a3 JTF_NUMBER_TABLE
179: , p6_a4 JTF_DATE_TABLE
180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_DATE_TABLE
182: , p6_a7 JTF_NUMBER_TABLE
183: , p6_a8 JTF_NUMBER_TABLE
184: , p6_a9 JTF_NUMBER_TABLE
178: , p6_a3 JTF_NUMBER_TABLE
179: , p6_a4 JTF_DATE_TABLE
180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_DATE_TABLE
182: , p6_a7 JTF_NUMBER_TABLE
183: , p6_a8 JTF_NUMBER_TABLE
184: , p6_a9 JTF_NUMBER_TABLE
185: , p6_a10 JTF_NUMBER_TABLE
186: , p6_a11 JTF_NUMBER_TABLE
179: , p6_a4 JTF_DATE_TABLE
180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_DATE_TABLE
182: , p6_a7 JTF_NUMBER_TABLE
183: , p6_a8 JTF_NUMBER_TABLE
184: , p6_a9 JTF_NUMBER_TABLE
185: , p6_a10 JTF_NUMBER_TABLE
186: , p6_a11 JTF_NUMBER_TABLE
187: , p7_a0 out nocopy NUMBER
180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_DATE_TABLE
182: , p6_a7 JTF_NUMBER_TABLE
183: , p6_a8 JTF_NUMBER_TABLE
184: , p6_a9 JTF_NUMBER_TABLE
185: , p6_a10 JTF_NUMBER_TABLE
186: , p6_a11 JTF_NUMBER_TABLE
187: , p7_a0 out nocopy NUMBER
188: , p7_a1 out nocopy NUMBER
181: , p6_a6 JTF_DATE_TABLE
182: , p6_a7 JTF_NUMBER_TABLE
183: , p6_a8 JTF_NUMBER_TABLE
184: , p6_a9 JTF_NUMBER_TABLE
185: , p6_a10 JTF_NUMBER_TABLE
186: , p6_a11 JTF_NUMBER_TABLE
187: , p7_a0 out nocopy NUMBER
188: , p7_a1 out nocopy NUMBER
189: , p7_a2 out nocopy NUMBER
182: , p6_a7 JTF_NUMBER_TABLE
183: , p6_a8 JTF_NUMBER_TABLE
184: , p6_a9 JTF_NUMBER_TABLE
185: , p6_a10 JTF_NUMBER_TABLE
186: , p6_a11 JTF_NUMBER_TABLE
187: , p7_a0 out nocopy NUMBER
188: , p7_a1 out nocopy NUMBER
189: , p7_a2 out nocopy NUMBER
190: , p7_a3 out nocopy NUMBER
295: , p5_a10 DATE
296: , p5_a11 NUMBER
297: , p5_a12 DATE
298: , p5_a13 NUMBER
299: , p6_a0 JTF_NUMBER_TABLE
300: , p6_a1 JTF_NUMBER_TABLE
301: , p6_a2 JTF_NUMBER_TABLE
302: , p6_a3 JTF_NUMBER_TABLE
303: , p6_a4 JTF_DATE_TABLE
296: , p5_a11 NUMBER
297: , p5_a12 DATE
298: , p5_a13 NUMBER
299: , p6_a0 JTF_NUMBER_TABLE
300: , p6_a1 JTF_NUMBER_TABLE
301: , p6_a2 JTF_NUMBER_TABLE
302: , p6_a3 JTF_NUMBER_TABLE
303: , p6_a4 JTF_DATE_TABLE
304: , p6_a5 JTF_NUMBER_TABLE
297: , p5_a12 DATE
298: , p5_a13 NUMBER
299: , p6_a0 JTF_NUMBER_TABLE
300: , p6_a1 JTF_NUMBER_TABLE
301: , p6_a2 JTF_NUMBER_TABLE
302: , p6_a3 JTF_NUMBER_TABLE
303: , p6_a4 JTF_DATE_TABLE
304: , p6_a5 JTF_NUMBER_TABLE
305: , p6_a6 JTF_DATE_TABLE
298: , p5_a13 NUMBER
299: , p6_a0 JTF_NUMBER_TABLE
300: , p6_a1 JTF_NUMBER_TABLE
301: , p6_a2 JTF_NUMBER_TABLE
302: , p6_a3 JTF_NUMBER_TABLE
303: , p6_a4 JTF_DATE_TABLE
304: , p6_a5 JTF_NUMBER_TABLE
305: , p6_a6 JTF_DATE_TABLE
306: , p6_a7 JTF_NUMBER_TABLE
300: , p6_a1 JTF_NUMBER_TABLE
301: , p6_a2 JTF_NUMBER_TABLE
302: , p6_a3 JTF_NUMBER_TABLE
303: , p6_a4 JTF_DATE_TABLE
304: , p6_a5 JTF_NUMBER_TABLE
305: , p6_a6 JTF_DATE_TABLE
306: , p6_a7 JTF_NUMBER_TABLE
307: , p6_a8 JTF_NUMBER_TABLE
308: , p6_a9 JTF_NUMBER_TABLE
302: , p6_a3 JTF_NUMBER_TABLE
303: , p6_a4 JTF_DATE_TABLE
304: , p6_a5 JTF_NUMBER_TABLE
305: , p6_a6 JTF_DATE_TABLE
306: , p6_a7 JTF_NUMBER_TABLE
307: , p6_a8 JTF_NUMBER_TABLE
308: , p6_a9 JTF_NUMBER_TABLE
309: , p6_a10 JTF_NUMBER_TABLE
310: , p6_a11 JTF_NUMBER_TABLE
303: , p6_a4 JTF_DATE_TABLE
304: , p6_a5 JTF_NUMBER_TABLE
305: , p6_a6 JTF_DATE_TABLE
306: , p6_a7 JTF_NUMBER_TABLE
307: , p6_a8 JTF_NUMBER_TABLE
308: , p6_a9 JTF_NUMBER_TABLE
309: , p6_a10 JTF_NUMBER_TABLE
310: , p6_a11 JTF_NUMBER_TABLE
311: , p7_a0 out nocopy NUMBER
304: , p6_a5 JTF_NUMBER_TABLE
305: , p6_a6 JTF_DATE_TABLE
306: , p6_a7 JTF_NUMBER_TABLE
307: , p6_a8 JTF_NUMBER_TABLE
308: , p6_a9 JTF_NUMBER_TABLE
309: , p6_a10 JTF_NUMBER_TABLE
310: , p6_a11 JTF_NUMBER_TABLE
311: , p7_a0 out nocopy NUMBER
312: , p7_a1 out nocopy NUMBER
305: , p6_a6 JTF_DATE_TABLE
306: , p6_a7 JTF_NUMBER_TABLE
307: , p6_a8 JTF_NUMBER_TABLE
308: , p6_a9 JTF_NUMBER_TABLE
309: , p6_a10 JTF_NUMBER_TABLE
310: , p6_a11 JTF_NUMBER_TABLE
311: , p7_a0 out nocopy NUMBER
312: , p7_a1 out nocopy NUMBER
313: , p7_a2 out nocopy NUMBER
306: , p6_a7 JTF_NUMBER_TABLE
307: , p6_a8 JTF_NUMBER_TABLE
308: , p6_a9 JTF_NUMBER_TABLE
309: , p6_a10 JTF_NUMBER_TABLE
310: , p6_a11 JTF_NUMBER_TABLE
311: , p7_a0 out nocopy NUMBER
312: , p7_a1 out nocopy NUMBER
313: , p7_a2 out nocopy NUMBER
314: , p7_a3 out nocopy NUMBER
405: , p_init_msg_list VARCHAR2
406: , x_return_status out nocopy VARCHAR2
407: , x_msg_count out nocopy NUMBER
408: , x_msg_data out nocopy VARCHAR2
409: , p5_a0 JTF_NUMBER_TABLE
410: , p5_a1 JTF_NUMBER_TABLE
411: , p5_a2 JTF_NUMBER_TABLE
412: , p5_a3 JTF_NUMBER_TABLE
413: , p5_a4 JTF_DATE_TABLE
406: , x_return_status out nocopy VARCHAR2
407: , x_msg_count out nocopy NUMBER
408: , x_msg_data out nocopy VARCHAR2
409: , p5_a0 JTF_NUMBER_TABLE
410: , p5_a1 JTF_NUMBER_TABLE
411: , p5_a2 JTF_NUMBER_TABLE
412: , p5_a3 JTF_NUMBER_TABLE
413: , p5_a4 JTF_DATE_TABLE
414: , p5_a5 JTF_NUMBER_TABLE
407: , x_msg_count out nocopy NUMBER
408: , x_msg_data out nocopy VARCHAR2
409: , p5_a0 JTF_NUMBER_TABLE
410: , p5_a1 JTF_NUMBER_TABLE
411: , p5_a2 JTF_NUMBER_TABLE
412: , p5_a3 JTF_NUMBER_TABLE
413: , p5_a4 JTF_DATE_TABLE
414: , p5_a5 JTF_NUMBER_TABLE
415: , p5_a6 JTF_DATE_TABLE
408: , x_msg_data out nocopy VARCHAR2
409: , p5_a0 JTF_NUMBER_TABLE
410: , p5_a1 JTF_NUMBER_TABLE
411: , p5_a2 JTF_NUMBER_TABLE
412: , p5_a3 JTF_NUMBER_TABLE
413: , p5_a4 JTF_DATE_TABLE
414: , p5_a5 JTF_NUMBER_TABLE
415: , p5_a6 JTF_DATE_TABLE
416: , p5_a7 JTF_NUMBER_TABLE
410: , p5_a1 JTF_NUMBER_TABLE
411: , p5_a2 JTF_NUMBER_TABLE
412: , p5_a3 JTF_NUMBER_TABLE
413: , p5_a4 JTF_DATE_TABLE
414: , p5_a5 JTF_NUMBER_TABLE
415: , p5_a6 JTF_DATE_TABLE
416: , p5_a7 JTF_NUMBER_TABLE
417: , p5_a8 JTF_NUMBER_TABLE
418: , p5_a9 JTF_NUMBER_TABLE
412: , p5_a3 JTF_NUMBER_TABLE
413: , p5_a4 JTF_DATE_TABLE
414: , p5_a5 JTF_NUMBER_TABLE
415: , p5_a6 JTF_DATE_TABLE
416: , p5_a7 JTF_NUMBER_TABLE
417: , p5_a8 JTF_NUMBER_TABLE
418: , p5_a9 JTF_NUMBER_TABLE
419: , p5_a10 JTF_NUMBER_TABLE
420: , p5_a11 JTF_NUMBER_TABLE
413: , p5_a4 JTF_DATE_TABLE
414: , p5_a5 JTF_NUMBER_TABLE
415: , p5_a6 JTF_DATE_TABLE
416: , p5_a7 JTF_NUMBER_TABLE
417: , p5_a8 JTF_NUMBER_TABLE
418: , p5_a9 JTF_NUMBER_TABLE
419: , p5_a10 JTF_NUMBER_TABLE
420: , p5_a11 JTF_NUMBER_TABLE
421: )
414: , p5_a5 JTF_NUMBER_TABLE
415: , p5_a6 JTF_DATE_TABLE
416: , p5_a7 JTF_NUMBER_TABLE
417: , p5_a8 JTF_NUMBER_TABLE
418: , p5_a9 JTF_NUMBER_TABLE
419: , p5_a10 JTF_NUMBER_TABLE
420: , p5_a11 JTF_NUMBER_TABLE
421: )
422:
415: , p5_a6 JTF_DATE_TABLE
416: , p5_a7 JTF_NUMBER_TABLE
417: , p5_a8 JTF_NUMBER_TABLE
418: , p5_a9 JTF_NUMBER_TABLE
419: , p5_a10 JTF_NUMBER_TABLE
420: , p5_a11 JTF_NUMBER_TABLE
421: )
422:
423: as
416: , p5_a7 JTF_NUMBER_TABLE
417: , p5_a8 JTF_NUMBER_TABLE
418: , p5_a9 JTF_NUMBER_TABLE
419: , p5_a10 JTF_NUMBER_TABLE
420: , p5_a11 JTF_NUMBER_TABLE
421: )
422:
423: as
424: ddp_res_tbl okl_resi_cat_sets_pvt.okl_res_tbl;