26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin
35: if a0 is not null and a0.count > 0 then
101: , a23 out nocopy JTF_VARCHAR2_TABLE_100
102: , a24 out nocopy JTF_VARCHAR2_TABLE_100
103: , a25 out nocopy JTF_VARCHAR2_TABLE_100
104: , a26 out nocopy JTF_VARCHAR2_TABLE_300
105: , a27 out nocopy JTF_DATE_TABLE
106: , a28 out nocopy JTF_DATE_TABLE
107: ) as
108: ddindx binary_integer; indx binary_integer;
109: begin
102: , a24 out nocopy JTF_VARCHAR2_TABLE_100
103: , a25 out nocopy JTF_VARCHAR2_TABLE_100
104: , a26 out nocopy JTF_VARCHAR2_TABLE_300
105: , a27 out nocopy JTF_DATE_TABLE
106: , a28 out nocopy JTF_DATE_TABLE
107: ) as
108: ddindx binary_integer; indx binary_integer;
109: begin
110: if t is null or t.count = 0 then
134: a23 := JTF_VARCHAR2_TABLE_100();
135: a24 := JTF_VARCHAR2_TABLE_100();
136: a25 := JTF_VARCHAR2_TABLE_100();
137: a26 := JTF_VARCHAR2_TABLE_300();
138: a27 := JTF_DATE_TABLE();
139: a28 := JTF_DATE_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
135: a24 := JTF_VARCHAR2_TABLE_100();
136: a25 := JTF_VARCHAR2_TABLE_100();
137: a26 := JTF_VARCHAR2_TABLE_300();
138: a27 := JTF_DATE_TABLE();
139: a28 := JTF_DATE_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_NUMBER_TABLE();
164: a23 := JTF_VARCHAR2_TABLE_100();
165: a24 := JTF_VARCHAR2_TABLE_100();
166: a25 := JTF_VARCHAR2_TABLE_100();
167: a26 := JTF_VARCHAR2_TABLE_300();
168: a27 := JTF_DATE_TABLE();
169: a28 := JTF_DATE_TABLE();
170: if t.count > 0 then
171: a0.extend(t.count);
172: a1.extend(t.count);
165: a24 := JTF_VARCHAR2_TABLE_100();
166: a25 := JTF_VARCHAR2_TABLE_100();
167: a26 := JTF_VARCHAR2_TABLE_300();
168: a27 := JTF_DATE_TABLE();
169: a28 := JTF_DATE_TABLE();
170: if t.count > 0 then
171: a0.extend(t.count);
172: a1.extend(t.count);
173: a2.extend(t.count);
394: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
395: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_300
398: , p9_a27 in out nocopy JTF_DATE_TABLE
399: , p9_a28 in out nocopy JTF_DATE_TABLE
400: )
401:
402: as
395: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_100
396: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_300
398: , p9_a27 in out nocopy JTF_DATE_TABLE
399: , p9_a28 in out nocopy JTF_DATE_TABLE
400: )
401:
402: as
403: ddp_x_prd_resrc_txn_tbl ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl;
624: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
625: , p10_a24 out nocopy JTF_VARCHAR2_TABLE_100
626: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
627: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_300
628: , p10_a27 out nocopy JTF_DATE_TABLE
629: , p10_a28 out nocopy JTF_DATE_TABLE
630: )
631:
632: as
625: , p10_a24 out nocopy JTF_VARCHAR2_TABLE_100
626: , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
627: , p10_a26 out nocopy JTF_VARCHAR2_TABLE_300
628: , p10_a27 out nocopy JTF_DATE_TABLE
629: , p10_a28 out nocopy JTF_DATE_TABLE
630: )
631:
632: as
633: ddx_resource_txn_tbl ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl;