DBA Data[Home] [Help]

APPS.OKL_DRS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 25: procedure rosetta_table_copy_in_p2(t out nocopy okl_drs_pvt.drs_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 26: , a1 JTF_NUMBER_TABLE

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

Line 27: , a2 JTF_NUMBER_TABLE

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

Line 45: , a20 JTF_NUMBER_TABLE

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

Line 47: , a22 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;

Line 49: , a24 JTF_NUMBER_TABLE

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

Line 92: procedure rosetta_table_copy_out_p2(t okl_drs_pvt.drs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 93: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 94: , a2 out nocopy JTF_NUMBER_TABLE

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

Line 112: , a20 out nocopy JTF_NUMBER_TABLE

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

Line 114: , a22 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;

Line 116: , a24 out nocopy JTF_NUMBER_TABLE

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

Line 121: a0 := JTF_NUMBER_TABLE();

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();

Line 122: a1 := JTF_NUMBER_TABLE();

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();

Line 123: a2 := JTF_NUMBER_TABLE();

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();

Line 141: a20 := JTF_NUMBER_TABLE();

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();

Line 143: a22 := 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();

Line 145: a24 := 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();

Line 147: a0 := 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();

Line 148: a1 := 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();
152: a5 := JTF_VARCHAR2_TABLE_500();

Line 149: a2 := JTF_NUMBER_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();
153: a6 := JTF_VARCHAR2_TABLE_500();

Line 167: a20 := JTF_NUMBER_TABLE();

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();

Line 169: a22 := 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);

Line 171: a24 := JTF_NUMBER_TABLE();

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);

Line 380: , p5_a0 JTF_NUMBER_TABLE

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

Line 381: , p5_a1 JTF_NUMBER_TABLE

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

Line 382: , p5_a2 JTF_NUMBER_TABLE

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

Line 400: , p5_a20 JTF_NUMBER_TABLE

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

Line 402: , p5_a22 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

Line 404: , p5_a24 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

Line 405: , p6_a0 out nocopy 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
409: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 406: , p6_a1 out nocopy JTF_NUMBER_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
410: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 407: , p6_a2 out nocopy 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
411: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 425: , p6_a20 out nocopy JTF_NUMBER_TABLE

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

Line 427: , p6_a22 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:

Line 429: , p6_a24 out nocopy JTF_NUMBER_TABLE

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;

Line 606: , p5_a0 JTF_NUMBER_TABLE

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

Line 607: , p5_a1 JTF_NUMBER_TABLE

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

Line 608: , p5_a2 JTF_NUMBER_TABLE

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

Line 626: , p5_a20 JTF_NUMBER_TABLE

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

Line 628: , p5_a22 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:

Line 630: , p5_a24 JTF_NUMBER_TABLE

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;

Line 831: , p5_a0 JTF_NUMBER_TABLE

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

Line 832: , p5_a1 JTF_NUMBER_TABLE

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

Line 833: , p5_a2 JTF_NUMBER_TABLE

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

Line 851: , p5_a20 JTF_NUMBER_TABLE

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

Line 853: , p5_a22 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

Line 855: , p5_a24 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

Line 856: , p6_a0 out nocopy 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
860: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 857: , p6_a1 out nocopy JTF_NUMBER_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
861: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 858: , p6_a2 out nocopy 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
862: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 876: , p6_a20 out nocopy JTF_NUMBER_TABLE

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

Line 878: , p6_a22 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:

Line 880: , p6_a24 out nocopy JTF_NUMBER_TABLE

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;

Line 1057: , p5_a0 JTF_NUMBER_TABLE

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

Line 1058: , p5_a1 JTF_NUMBER_TABLE

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

Line 1059: , p5_a2 JTF_NUMBER_TABLE

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

Line 1077: , p5_a20 JTF_NUMBER_TABLE

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

Line 1079: , p5_a22 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:

Line 1081: , p5_a24 JTF_NUMBER_TABLE

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;

Line 1228: , p5_a0 JTF_NUMBER_TABLE

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

Line 1229: , p5_a1 JTF_NUMBER_TABLE

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

Line 1230: , p5_a2 JTF_NUMBER_TABLE

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

Line 1248: , p5_a20 JTF_NUMBER_TABLE

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

Line 1250: , p5_a22 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:

Line 1252: , p5_a24 JTF_NUMBER_TABLE

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;