21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_300
25: , a22 JTF_VARCHAR2_TABLE_2000
26: , a23 JTF_VARCHAR2_TABLE_2000
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_300
25: , a22 JTF_VARCHAR2_TABLE_2000
26: , a23 JTF_VARCHAR2_TABLE_2000
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if a0 is not null and a0.count > 0 then
86: , a18 out nocopy JTF_NUMBER_TABLE
87: , a19 out nocopy JTF_NUMBER_TABLE
88: , a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , a21 out nocopy JTF_VARCHAR2_TABLE_300
90: , a22 out nocopy JTF_VARCHAR2_TABLE_2000
91: , a23 out nocopy JTF_VARCHAR2_TABLE_2000
92: ) as
93: ddindx binary_integer; indx binary_integer;
94: begin
87: , a19 out nocopy JTF_NUMBER_TABLE
88: , a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , a21 out nocopy JTF_VARCHAR2_TABLE_300
90: , a22 out nocopy JTF_VARCHAR2_TABLE_2000
91: , a23 out nocopy JTF_VARCHAR2_TABLE_2000
92: ) as
93: ddindx binary_integer; indx binary_integer;
94: begin
95: if t is null or t.count = 0 then
114: a18 := JTF_NUMBER_TABLE();
115: a19 := JTF_NUMBER_TABLE();
116: a20 := JTF_VARCHAR2_TABLE_100();
117: a21 := JTF_VARCHAR2_TABLE_300();
118: a22 := JTF_VARCHAR2_TABLE_2000();
119: a23 := JTF_VARCHAR2_TABLE_2000();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
115: a19 := JTF_NUMBER_TABLE();
116: a20 := JTF_VARCHAR2_TABLE_100();
117: a21 := JTF_VARCHAR2_TABLE_300();
118: a22 := JTF_VARCHAR2_TABLE_2000();
119: a23 := JTF_VARCHAR2_TABLE_2000();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
139: a18 := JTF_NUMBER_TABLE();
140: a19 := JTF_NUMBER_TABLE();
141: a20 := JTF_VARCHAR2_TABLE_100();
142: a21 := JTF_VARCHAR2_TABLE_300();
143: a22 := JTF_VARCHAR2_TABLE_2000();
144: a23 := JTF_VARCHAR2_TABLE_2000();
145: if t.count > 0 then
146: a0.extend(t.count);
147: a1.extend(t.count);
140: a19 := JTF_NUMBER_TABLE();
141: a20 := JTF_VARCHAR2_TABLE_100();
142: a21 := JTF_VARCHAR2_TABLE_300();
143: a22 := JTF_VARCHAR2_TABLE_2000();
144: a23 := JTF_VARCHAR2_TABLE_2000();
145: if t.count > 0 then
146: a0.extend(t.count);
147: a1.extend(t.count);
148: a2.extend(t.count);
230: , p5_a18 JTF_NUMBER_TABLE
231: , p5_a19 JTF_NUMBER_TABLE
232: , p5_a20 JTF_VARCHAR2_TABLE_100
233: , p5_a21 JTF_VARCHAR2_TABLE_300
234: , p5_a22 JTF_VARCHAR2_TABLE_2000
235: , p5_a23 JTF_VARCHAR2_TABLE_2000
236: , p6_a0 out nocopy JTF_NUMBER_TABLE
237: , p6_a1 out nocopy JTF_NUMBER_TABLE
238: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
231: , p5_a19 JTF_NUMBER_TABLE
232: , p5_a20 JTF_VARCHAR2_TABLE_100
233: , p5_a21 JTF_VARCHAR2_TABLE_300
234: , p5_a22 JTF_VARCHAR2_TABLE_2000
235: , p5_a23 JTF_VARCHAR2_TABLE_2000
236: , p6_a0 out nocopy JTF_NUMBER_TABLE
237: , p6_a1 out nocopy JTF_NUMBER_TABLE
238: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
254: , p6_a18 out nocopy JTF_NUMBER_TABLE
255: , p6_a19 out nocopy JTF_NUMBER_TABLE
256: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
257: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
258: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_2000
259: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_2000
260: )
261:
262: as
255: , p6_a19 out nocopy JTF_NUMBER_TABLE
256: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
257: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
258: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_2000
259: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_2000
260: )
261:
262: as
263: ddp_vldv_tbl okl_vld_pvt.vldv_tbl_type;
367: , p5_a18 JTF_NUMBER_TABLE
368: , p5_a19 JTF_NUMBER_TABLE
369: , p5_a20 JTF_VARCHAR2_TABLE_100
370: , p5_a21 JTF_VARCHAR2_TABLE_300
371: , p5_a22 JTF_VARCHAR2_TABLE_2000
372: , p5_a23 JTF_VARCHAR2_TABLE_2000
373: , p6_a0 out nocopy JTF_NUMBER_TABLE
374: , p6_a1 out nocopy JTF_NUMBER_TABLE
375: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
368: , p5_a19 JTF_NUMBER_TABLE
369: , p5_a20 JTF_VARCHAR2_TABLE_100
370: , p5_a21 JTF_VARCHAR2_TABLE_300
371: , p5_a22 JTF_VARCHAR2_TABLE_2000
372: , p5_a23 JTF_VARCHAR2_TABLE_2000
373: , p6_a0 out nocopy JTF_NUMBER_TABLE
374: , p6_a1 out nocopy JTF_NUMBER_TABLE
375: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
376: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
391: , p6_a18 out nocopy JTF_NUMBER_TABLE
392: , p6_a19 out nocopy JTF_NUMBER_TABLE
393: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
394: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
395: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_2000
396: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_2000
397: )
398:
399: as
392: , p6_a19 out nocopy JTF_NUMBER_TABLE
393: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
394: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
395: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_2000
396: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_2000
397: )
398:
399: as
400: ddp_vldv_tbl okl_vld_pvt.vldv_tbl_type;
504: , p5_a18 JTF_NUMBER_TABLE
505: , p5_a19 JTF_NUMBER_TABLE
506: , p5_a20 JTF_VARCHAR2_TABLE_100
507: , p5_a21 JTF_VARCHAR2_TABLE_300
508: , p5_a22 JTF_VARCHAR2_TABLE_2000
509: , p5_a23 JTF_VARCHAR2_TABLE_2000
510: )
511:
512: as
505: , p5_a19 JTF_NUMBER_TABLE
506: , p5_a20 JTF_VARCHAR2_TABLE_100
507: , p5_a21 JTF_VARCHAR2_TABLE_300
508: , p5_a22 JTF_VARCHAR2_TABLE_2000
509: , p5_a23 JTF_VARCHAR2_TABLE_2000
510: )
511:
512: as
513: ddp_vldv_tbl okl_vld_pvt.vldv_tbl_type;