21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_drs_pvt.drs_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_drs_pvt.drs_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_500
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_drs_pvt.drs_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_500
31: , a6 JTF_VARCHAR2_TABLE_500
41: , a16 JTF_VARCHAR2_TABLE_500
42: , a17 JTF_VARCHAR2_TABLE_500
43: , a18 JTF_VARCHAR2_TABLE_500
44: , a19 JTF_VARCHAR2_TABLE_500
45: , a20 JTF_NUMBER_TABLE
46: , a21 JTF_DATE_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_DATE_TABLE
49: , a24 JTF_NUMBER_TABLE
43: , a18 JTF_VARCHAR2_TABLE_500
44: , a19 JTF_VARCHAR2_TABLE_500
45: , a20 JTF_NUMBER_TABLE
46: , a21 JTF_DATE_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_DATE_TABLE
49: , a24 JTF_NUMBER_TABLE
50: ) as
51: ddindx binary_integer; indx binary_integer;
45: , a20 JTF_NUMBER_TABLE
46: , a21 JTF_DATE_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_DATE_TABLE
49: , a24 JTF_NUMBER_TABLE
50: ) as
51: ddindx binary_integer; indx binary_integer;
52: begin
53: if a0 is not null and a0.count > 0 then
88: end loop;
89: end if;
90: end if;
91: end rosetta_table_copy_in_p2;
92: procedure rosetta_table_copy_out_p2(t okl_drs_pvt.drs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_NUMBER_TABLE
94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_100
89: end if;
90: end if;
91: end rosetta_table_copy_in_p2;
92: procedure rosetta_table_copy_out_p2(t okl_drs_pvt.drs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_NUMBER_TABLE
94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_100
97: , a5 out nocopy JTF_VARCHAR2_TABLE_500
90: end if;
91: end rosetta_table_copy_in_p2;
92: procedure rosetta_table_copy_out_p2(t okl_drs_pvt.drs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_NUMBER_TABLE
94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_100
97: , a5 out nocopy JTF_VARCHAR2_TABLE_500
98: , a6 out nocopy JTF_VARCHAR2_TABLE_500
108: , a16 out nocopy JTF_VARCHAR2_TABLE_500
109: , a17 out nocopy JTF_VARCHAR2_TABLE_500
110: , a18 out nocopy JTF_VARCHAR2_TABLE_500
111: , a19 out nocopy JTF_VARCHAR2_TABLE_500
112: , a20 out nocopy JTF_NUMBER_TABLE
113: , a21 out nocopy JTF_DATE_TABLE
114: , a22 out nocopy JTF_NUMBER_TABLE
115: , a23 out nocopy JTF_DATE_TABLE
116: , a24 out nocopy JTF_NUMBER_TABLE
110: , a18 out nocopy JTF_VARCHAR2_TABLE_500
111: , a19 out nocopy JTF_VARCHAR2_TABLE_500
112: , a20 out nocopy JTF_NUMBER_TABLE
113: , a21 out nocopy JTF_DATE_TABLE
114: , a22 out nocopy JTF_NUMBER_TABLE
115: , a23 out nocopy JTF_DATE_TABLE
116: , a24 out nocopy JTF_NUMBER_TABLE
117: ) as
118: ddindx binary_integer; indx binary_integer;
112: , a20 out nocopy JTF_NUMBER_TABLE
113: , a21 out nocopy JTF_DATE_TABLE
114: , a22 out nocopy JTF_NUMBER_TABLE
115: , a23 out nocopy JTF_DATE_TABLE
116: , a24 out nocopy JTF_NUMBER_TABLE
117: ) as
118: ddindx binary_integer; indx binary_integer;
119: begin
120: if t is null or t.count = 0 then
117: ) as
118: ddindx binary_integer; indx binary_integer;
119: begin
120: if t is null or t.count = 0 then
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_VARCHAR2_TABLE_100();
118: ddindx binary_integer; indx binary_integer;
119: begin
120: if t is null or t.count = 0 then
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_VARCHAR2_TABLE_100();
126: a5 := JTF_VARCHAR2_TABLE_500();
119: begin
120: if t is null or t.count = 0 then
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_VARCHAR2_TABLE_100();
126: a5 := JTF_VARCHAR2_TABLE_500();
127: a6 := JTF_VARCHAR2_TABLE_500();
137: a16 := JTF_VARCHAR2_TABLE_500();
138: a17 := JTF_VARCHAR2_TABLE_500();
139: a18 := JTF_VARCHAR2_TABLE_500();
140: a19 := JTF_VARCHAR2_TABLE_500();
141: a20 := JTF_NUMBER_TABLE();
142: a21 := JTF_DATE_TABLE();
143: a22 := JTF_NUMBER_TABLE();
144: a23 := JTF_DATE_TABLE();
145: a24 := JTF_NUMBER_TABLE();
139: a18 := JTF_VARCHAR2_TABLE_500();
140: a19 := JTF_VARCHAR2_TABLE_500();
141: a20 := JTF_NUMBER_TABLE();
142: a21 := JTF_DATE_TABLE();
143: a22 := JTF_NUMBER_TABLE();
144: a23 := JTF_DATE_TABLE();
145: a24 := JTF_NUMBER_TABLE();
146: else
147: a0 := JTF_NUMBER_TABLE();
141: a20 := JTF_NUMBER_TABLE();
142: a21 := JTF_DATE_TABLE();
143: a22 := JTF_NUMBER_TABLE();
144: a23 := JTF_DATE_TABLE();
145: a24 := JTF_NUMBER_TABLE();
146: else
147: a0 := JTF_NUMBER_TABLE();
148: a1 := JTF_NUMBER_TABLE();
149: a2 := JTF_NUMBER_TABLE();
143: a22 := JTF_NUMBER_TABLE();
144: a23 := JTF_DATE_TABLE();
145: a24 := JTF_NUMBER_TABLE();
146: else
147: a0 := JTF_NUMBER_TABLE();
148: a1 := JTF_NUMBER_TABLE();
149: a2 := JTF_NUMBER_TABLE();
150: a3 := JTF_VARCHAR2_TABLE_100();
151: a4 := JTF_VARCHAR2_TABLE_100();
144: a23 := JTF_DATE_TABLE();
145: a24 := JTF_NUMBER_TABLE();
146: else
147: a0 := JTF_NUMBER_TABLE();
148: a1 := JTF_NUMBER_TABLE();
149: a2 := JTF_NUMBER_TABLE();
150: a3 := JTF_VARCHAR2_TABLE_100();
151: a4 := JTF_VARCHAR2_TABLE_100();
152: a5 := JTF_VARCHAR2_TABLE_500();
145: a24 := JTF_NUMBER_TABLE();
146: else
147: a0 := JTF_NUMBER_TABLE();
148: a1 := JTF_NUMBER_TABLE();
149: a2 := JTF_NUMBER_TABLE();
150: a3 := JTF_VARCHAR2_TABLE_100();
151: a4 := JTF_VARCHAR2_TABLE_100();
152: a5 := JTF_VARCHAR2_TABLE_500();
153: a6 := JTF_VARCHAR2_TABLE_500();
163: a16 := JTF_VARCHAR2_TABLE_500();
164: a17 := JTF_VARCHAR2_TABLE_500();
165: a18 := JTF_VARCHAR2_TABLE_500();
166: a19 := JTF_VARCHAR2_TABLE_500();
167: a20 := JTF_NUMBER_TABLE();
168: a21 := JTF_DATE_TABLE();
169: a22 := JTF_NUMBER_TABLE();
170: a23 := JTF_DATE_TABLE();
171: a24 := JTF_NUMBER_TABLE();
165: a18 := JTF_VARCHAR2_TABLE_500();
166: a19 := JTF_VARCHAR2_TABLE_500();
167: a20 := JTF_NUMBER_TABLE();
168: a21 := JTF_DATE_TABLE();
169: a22 := JTF_NUMBER_TABLE();
170: a23 := JTF_DATE_TABLE();
171: a24 := JTF_NUMBER_TABLE();
172: if t.count > 0 then
173: a0.extend(t.count);
167: a20 := JTF_NUMBER_TABLE();
168: a21 := JTF_DATE_TABLE();
169: a22 := JTF_NUMBER_TABLE();
170: a23 := JTF_DATE_TABLE();
171: a24 := JTF_NUMBER_TABLE();
172: if t.count > 0 then
173: a0.extend(t.count);
174: a1.extend(t.count);
175: a2.extend(t.count);
376: , p_init_msg_list VARCHAR2
377: , x_return_status out nocopy VARCHAR2
378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_VARCHAR2_TABLE_100
384: , p5_a4 JTF_VARCHAR2_TABLE_100
377: , x_return_status out nocopy VARCHAR2
378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_VARCHAR2_TABLE_100
384: , p5_a4 JTF_VARCHAR2_TABLE_100
385: , p5_a5 JTF_VARCHAR2_TABLE_500
378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_VARCHAR2_TABLE_100
384: , p5_a4 JTF_VARCHAR2_TABLE_100
385: , p5_a5 JTF_VARCHAR2_TABLE_500
386: , p5_a6 JTF_VARCHAR2_TABLE_500
396: , p5_a16 JTF_VARCHAR2_TABLE_500
397: , p5_a17 JTF_VARCHAR2_TABLE_500
398: , p5_a18 JTF_VARCHAR2_TABLE_500
399: , p5_a19 JTF_VARCHAR2_TABLE_500
400: , p5_a20 JTF_NUMBER_TABLE
401: , p5_a21 JTF_DATE_TABLE
402: , p5_a22 JTF_NUMBER_TABLE
403: , p5_a23 JTF_DATE_TABLE
404: , p5_a24 JTF_NUMBER_TABLE
398: , p5_a18 JTF_VARCHAR2_TABLE_500
399: , p5_a19 JTF_VARCHAR2_TABLE_500
400: , p5_a20 JTF_NUMBER_TABLE
401: , p5_a21 JTF_DATE_TABLE
402: , p5_a22 JTF_NUMBER_TABLE
403: , p5_a23 JTF_DATE_TABLE
404: , p5_a24 JTF_NUMBER_TABLE
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_NUMBER_TABLE
400: , p5_a20 JTF_NUMBER_TABLE
401: , p5_a21 JTF_DATE_TABLE
402: , p5_a22 JTF_NUMBER_TABLE
403: , p5_a23 JTF_DATE_TABLE
404: , p5_a24 JTF_NUMBER_TABLE
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_NUMBER_TABLE
407: , p6_a2 out nocopy JTF_NUMBER_TABLE
408: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
401: , p5_a21 JTF_DATE_TABLE
402: , p5_a22 JTF_NUMBER_TABLE
403: , p5_a23 JTF_DATE_TABLE
404: , p5_a24 JTF_NUMBER_TABLE
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_NUMBER_TABLE
407: , p6_a2 out nocopy JTF_NUMBER_TABLE
408: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
409: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
402: , p5_a22 JTF_NUMBER_TABLE
403: , p5_a23 JTF_DATE_TABLE
404: , p5_a24 JTF_NUMBER_TABLE
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_NUMBER_TABLE
407: , p6_a2 out nocopy JTF_NUMBER_TABLE
408: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
409: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
410: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
403: , p5_a23 JTF_DATE_TABLE
404: , p5_a24 JTF_NUMBER_TABLE
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_NUMBER_TABLE
407: , p6_a2 out nocopy JTF_NUMBER_TABLE
408: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
409: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
410: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
411: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
421: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
422: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
423: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
424: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
425: , p6_a20 out nocopy JTF_NUMBER_TABLE
426: , p6_a21 out nocopy JTF_DATE_TABLE
427: , p6_a22 out nocopy JTF_NUMBER_TABLE
428: , p6_a23 out nocopy JTF_DATE_TABLE
429: , p6_a24 out nocopy JTF_NUMBER_TABLE
423: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
424: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
425: , p6_a20 out nocopy JTF_NUMBER_TABLE
426: , p6_a21 out nocopy JTF_DATE_TABLE
427: , p6_a22 out nocopy JTF_NUMBER_TABLE
428: , p6_a23 out nocopy JTF_DATE_TABLE
429: , p6_a24 out nocopy JTF_NUMBER_TABLE
430: )
431:
425: , p6_a20 out nocopy JTF_NUMBER_TABLE
426: , p6_a21 out nocopy JTF_DATE_TABLE
427: , p6_a22 out nocopy JTF_NUMBER_TABLE
428: , p6_a23 out nocopy JTF_DATE_TABLE
429: , p6_a24 out nocopy JTF_NUMBER_TABLE
430: )
431:
432: as
433: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;
602: , p_init_msg_list VARCHAR2
603: , x_return_status out nocopy VARCHAR2
604: , x_msg_count out nocopy NUMBER
605: , x_msg_data out nocopy VARCHAR2
606: , p5_a0 JTF_NUMBER_TABLE
607: , p5_a1 JTF_NUMBER_TABLE
608: , p5_a2 JTF_NUMBER_TABLE
609: , p5_a3 JTF_VARCHAR2_TABLE_100
610: , p5_a4 JTF_VARCHAR2_TABLE_100
603: , x_return_status out nocopy VARCHAR2
604: , x_msg_count out nocopy NUMBER
605: , x_msg_data out nocopy VARCHAR2
606: , p5_a0 JTF_NUMBER_TABLE
607: , p5_a1 JTF_NUMBER_TABLE
608: , p5_a2 JTF_NUMBER_TABLE
609: , p5_a3 JTF_VARCHAR2_TABLE_100
610: , p5_a4 JTF_VARCHAR2_TABLE_100
611: , p5_a5 JTF_VARCHAR2_TABLE_500
604: , x_msg_count out nocopy NUMBER
605: , x_msg_data out nocopy VARCHAR2
606: , p5_a0 JTF_NUMBER_TABLE
607: , p5_a1 JTF_NUMBER_TABLE
608: , p5_a2 JTF_NUMBER_TABLE
609: , p5_a3 JTF_VARCHAR2_TABLE_100
610: , p5_a4 JTF_VARCHAR2_TABLE_100
611: , p5_a5 JTF_VARCHAR2_TABLE_500
612: , p5_a6 JTF_VARCHAR2_TABLE_500
622: , p5_a16 JTF_VARCHAR2_TABLE_500
623: , p5_a17 JTF_VARCHAR2_TABLE_500
624: , p5_a18 JTF_VARCHAR2_TABLE_500
625: , p5_a19 JTF_VARCHAR2_TABLE_500
626: , p5_a20 JTF_NUMBER_TABLE
627: , p5_a21 JTF_DATE_TABLE
628: , p5_a22 JTF_NUMBER_TABLE
629: , p5_a23 JTF_DATE_TABLE
630: , p5_a24 JTF_NUMBER_TABLE
624: , p5_a18 JTF_VARCHAR2_TABLE_500
625: , p5_a19 JTF_VARCHAR2_TABLE_500
626: , p5_a20 JTF_NUMBER_TABLE
627: , p5_a21 JTF_DATE_TABLE
628: , p5_a22 JTF_NUMBER_TABLE
629: , p5_a23 JTF_DATE_TABLE
630: , p5_a24 JTF_NUMBER_TABLE
631: )
632:
626: , p5_a20 JTF_NUMBER_TABLE
627: , p5_a21 JTF_DATE_TABLE
628: , p5_a22 JTF_NUMBER_TABLE
629: , p5_a23 JTF_DATE_TABLE
630: , p5_a24 JTF_NUMBER_TABLE
631: )
632:
633: as
634: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;
827: , p_init_msg_list VARCHAR2
828: , x_return_status out nocopy VARCHAR2
829: , x_msg_count out nocopy NUMBER
830: , x_msg_data out nocopy VARCHAR2
831: , p5_a0 JTF_NUMBER_TABLE
832: , p5_a1 JTF_NUMBER_TABLE
833: , p5_a2 JTF_NUMBER_TABLE
834: , p5_a3 JTF_VARCHAR2_TABLE_100
835: , p5_a4 JTF_VARCHAR2_TABLE_100
828: , x_return_status out nocopy VARCHAR2
829: , x_msg_count out nocopy NUMBER
830: , x_msg_data out nocopy VARCHAR2
831: , p5_a0 JTF_NUMBER_TABLE
832: , p5_a1 JTF_NUMBER_TABLE
833: , p5_a2 JTF_NUMBER_TABLE
834: , p5_a3 JTF_VARCHAR2_TABLE_100
835: , p5_a4 JTF_VARCHAR2_TABLE_100
836: , p5_a5 JTF_VARCHAR2_TABLE_500
829: , x_msg_count out nocopy NUMBER
830: , x_msg_data out nocopy VARCHAR2
831: , p5_a0 JTF_NUMBER_TABLE
832: , p5_a1 JTF_NUMBER_TABLE
833: , p5_a2 JTF_NUMBER_TABLE
834: , p5_a3 JTF_VARCHAR2_TABLE_100
835: , p5_a4 JTF_VARCHAR2_TABLE_100
836: , p5_a5 JTF_VARCHAR2_TABLE_500
837: , p5_a6 JTF_VARCHAR2_TABLE_500
847: , p5_a16 JTF_VARCHAR2_TABLE_500
848: , p5_a17 JTF_VARCHAR2_TABLE_500
849: , p5_a18 JTF_VARCHAR2_TABLE_500
850: , p5_a19 JTF_VARCHAR2_TABLE_500
851: , p5_a20 JTF_NUMBER_TABLE
852: , p5_a21 JTF_DATE_TABLE
853: , p5_a22 JTF_NUMBER_TABLE
854: , p5_a23 JTF_DATE_TABLE
855: , p5_a24 JTF_NUMBER_TABLE
849: , p5_a18 JTF_VARCHAR2_TABLE_500
850: , p5_a19 JTF_VARCHAR2_TABLE_500
851: , p5_a20 JTF_NUMBER_TABLE
852: , p5_a21 JTF_DATE_TABLE
853: , p5_a22 JTF_NUMBER_TABLE
854: , p5_a23 JTF_DATE_TABLE
855: , p5_a24 JTF_NUMBER_TABLE
856: , p6_a0 out nocopy JTF_NUMBER_TABLE
857: , p6_a1 out nocopy JTF_NUMBER_TABLE
851: , p5_a20 JTF_NUMBER_TABLE
852: , p5_a21 JTF_DATE_TABLE
853: , p5_a22 JTF_NUMBER_TABLE
854: , p5_a23 JTF_DATE_TABLE
855: , p5_a24 JTF_NUMBER_TABLE
856: , p6_a0 out nocopy JTF_NUMBER_TABLE
857: , p6_a1 out nocopy JTF_NUMBER_TABLE
858: , p6_a2 out nocopy JTF_NUMBER_TABLE
859: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
852: , p5_a21 JTF_DATE_TABLE
853: , p5_a22 JTF_NUMBER_TABLE
854: , p5_a23 JTF_DATE_TABLE
855: , p5_a24 JTF_NUMBER_TABLE
856: , p6_a0 out nocopy JTF_NUMBER_TABLE
857: , p6_a1 out nocopy JTF_NUMBER_TABLE
858: , p6_a2 out nocopy JTF_NUMBER_TABLE
859: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
860: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
853: , p5_a22 JTF_NUMBER_TABLE
854: , p5_a23 JTF_DATE_TABLE
855: , p5_a24 JTF_NUMBER_TABLE
856: , p6_a0 out nocopy JTF_NUMBER_TABLE
857: , p6_a1 out nocopy JTF_NUMBER_TABLE
858: , p6_a2 out nocopy JTF_NUMBER_TABLE
859: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
860: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
861: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
854: , p5_a23 JTF_DATE_TABLE
855: , p5_a24 JTF_NUMBER_TABLE
856: , p6_a0 out nocopy JTF_NUMBER_TABLE
857: , p6_a1 out nocopy JTF_NUMBER_TABLE
858: , p6_a2 out nocopy JTF_NUMBER_TABLE
859: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
860: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
861: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
862: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
872: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
873: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
874: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
875: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
876: , p6_a20 out nocopy JTF_NUMBER_TABLE
877: , p6_a21 out nocopy JTF_DATE_TABLE
878: , p6_a22 out nocopy JTF_NUMBER_TABLE
879: , p6_a23 out nocopy JTF_DATE_TABLE
880: , p6_a24 out nocopy JTF_NUMBER_TABLE
874: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
875: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
876: , p6_a20 out nocopy JTF_NUMBER_TABLE
877: , p6_a21 out nocopy JTF_DATE_TABLE
878: , p6_a22 out nocopy JTF_NUMBER_TABLE
879: , p6_a23 out nocopy JTF_DATE_TABLE
880: , p6_a24 out nocopy JTF_NUMBER_TABLE
881: )
882:
876: , p6_a20 out nocopy JTF_NUMBER_TABLE
877: , p6_a21 out nocopy JTF_DATE_TABLE
878: , p6_a22 out nocopy JTF_NUMBER_TABLE
879: , p6_a23 out nocopy JTF_DATE_TABLE
880: , p6_a24 out nocopy JTF_NUMBER_TABLE
881: )
882:
883: as
884: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;
1053: , p_init_msg_list VARCHAR2
1054: , x_return_status out nocopy VARCHAR2
1055: , x_msg_count out nocopy NUMBER
1056: , x_msg_data out nocopy VARCHAR2
1057: , p5_a0 JTF_NUMBER_TABLE
1058: , p5_a1 JTF_NUMBER_TABLE
1059: , p5_a2 JTF_NUMBER_TABLE
1060: , p5_a3 JTF_VARCHAR2_TABLE_100
1061: , p5_a4 JTF_VARCHAR2_TABLE_100
1054: , x_return_status out nocopy VARCHAR2
1055: , x_msg_count out nocopy NUMBER
1056: , x_msg_data out nocopy VARCHAR2
1057: , p5_a0 JTF_NUMBER_TABLE
1058: , p5_a1 JTF_NUMBER_TABLE
1059: , p5_a2 JTF_NUMBER_TABLE
1060: , p5_a3 JTF_VARCHAR2_TABLE_100
1061: , p5_a4 JTF_VARCHAR2_TABLE_100
1062: , p5_a5 JTF_VARCHAR2_TABLE_500
1055: , x_msg_count out nocopy NUMBER
1056: , x_msg_data out nocopy VARCHAR2
1057: , p5_a0 JTF_NUMBER_TABLE
1058: , p5_a1 JTF_NUMBER_TABLE
1059: , p5_a2 JTF_NUMBER_TABLE
1060: , p5_a3 JTF_VARCHAR2_TABLE_100
1061: , p5_a4 JTF_VARCHAR2_TABLE_100
1062: , p5_a5 JTF_VARCHAR2_TABLE_500
1063: , p5_a6 JTF_VARCHAR2_TABLE_500
1073: , p5_a16 JTF_VARCHAR2_TABLE_500
1074: , p5_a17 JTF_VARCHAR2_TABLE_500
1075: , p5_a18 JTF_VARCHAR2_TABLE_500
1076: , p5_a19 JTF_VARCHAR2_TABLE_500
1077: , p5_a20 JTF_NUMBER_TABLE
1078: , p5_a21 JTF_DATE_TABLE
1079: , p5_a22 JTF_NUMBER_TABLE
1080: , p5_a23 JTF_DATE_TABLE
1081: , p5_a24 JTF_NUMBER_TABLE
1075: , p5_a18 JTF_VARCHAR2_TABLE_500
1076: , p5_a19 JTF_VARCHAR2_TABLE_500
1077: , p5_a20 JTF_NUMBER_TABLE
1078: , p5_a21 JTF_DATE_TABLE
1079: , p5_a22 JTF_NUMBER_TABLE
1080: , p5_a23 JTF_DATE_TABLE
1081: , p5_a24 JTF_NUMBER_TABLE
1082: )
1083:
1077: , p5_a20 JTF_NUMBER_TABLE
1078: , p5_a21 JTF_DATE_TABLE
1079: , p5_a22 JTF_NUMBER_TABLE
1080: , p5_a23 JTF_DATE_TABLE
1081: , p5_a24 JTF_NUMBER_TABLE
1082: )
1083:
1084: as
1085: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;
1224: , p_init_msg_list VARCHAR2
1225: , x_return_status out nocopy VARCHAR2
1226: , x_msg_count out nocopy NUMBER
1227: , x_msg_data out nocopy VARCHAR2
1228: , p5_a0 JTF_NUMBER_TABLE
1229: , p5_a1 JTF_NUMBER_TABLE
1230: , p5_a2 JTF_NUMBER_TABLE
1231: , p5_a3 JTF_VARCHAR2_TABLE_100
1232: , p5_a4 JTF_VARCHAR2_TABLE_100
1225: , x_return_status out nocopy VARCHAR2
1226: , x_msg_count out nocopy NUMBER
1227: , x_msg_data out nocopy VARCHAR2
1228: , p5_a0 JTF_NUMBER_TABLE
1229: , p5_a1 JTF_NUMBER_TABLE
1230: , p5_a2 JTF_NUMBER_TABLE
1231: , p5_a3 JTF_VARCHAR2_TABLE_100
1232: , p5_a4 JTF_VARCHAR2_TABLE_100
1233: , p5_a5 JTF_VARCHAR2_TABLE_500
1226: , x_msg_count out nocopy NUMBER
1227: , x_msg_data out nocopy VARCHAR2
1228: , p5_a0 JTF_NUMBER_TABLE
1229: , p5_a1 JTF_NUMBER_TABLE
1230: , p5_a2 JTF_NUMBER_TABLE
1231: , p5_a3 JTF_VARCHAR2_TABLE_100
1232: , p5_a4 JTF_VARCHAR2_TABLE_100
1233: , p5_a5 JTF_VARCHAR2_TABLE_500
1234: , p5_a6 JTF_VARCHAR2_TABLE_500
1244: , p5_a16 JTF_VARCHAR2_TABLE_500
1245: , p5_a17 JTF_VARCHAR2_TABLE_500
1246: , p5_a18 JTF_VARCHAR2_TABLE_500
1247: , p5_a19 JTF_VARCHAR2_TABLE_500
1248: , p5_a20 JTF_NUMBER_TABLE
1249: , p5_a21 JTF_DATE_TABLE
1250: , p5_a22 JTF_NUMBER_TABLE
1251: , p5_a23 JTF_DATE_TABLE
1252: , p5_a24 JTF_NUMBER_TABLE
1246: , p5_a18 JTF_VARCHAR2_TABLE_500
1247: , p5_a19 JTF_VARCHAR2_TABLE_500
1248: , p5_a20 JTF_NUMBER_TABLE
1249: , p5_a21 JTF_DATE_TABLE
1250: , p5_a22 JTF_NUMBER_TABLE
1251: , p5_a23 JTF_DATE_TABLE
1252: , p5_a24 JTF_NUMBER_TABLE
1253: )
1254:
1248: , p5_a20 JTF_NUMBER_TABLE
1249: , p5_a21 JTF_DATE_TABLE
1250: , p5_a22 JTF_NUMBER_TABLE
1251: , p5_a23 JTF_DATE_TABLE
1252: , p5_a24 JTF_NUMBER_TABLE
1253: )
1254:
1255: as
1256: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;