DBA Data[Home] [Help]

APPS.OKL_QQL_PVT_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 32: , a29 JTF_VARCHAR2_TABLE_2000

28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_300
32: , a29 JTF_VARCHAR2_TABLE_2000
33: , a30 JTF_VARCHAR2_TABLE_2000
34: ) as
35: ddindx binary_integer; indx binary_integer;
36: begin

Line 33: , a30 JTF_VARCHAR2_TABLE_2000

29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_300
32: , a29 JTF_VARCHAR2_TABLE_2000
33: , a30 JTF_VARCHAR2_TABLE_2000
34: ) as
35: ddindx binary_integer; indx binary_integer;
36: begin
37: if a0 is not null and a0.count > 0 then

Line 111: , a29 out nocopy JTF_VARCHAR2_TABLE_2000

107: , a25 out nocopy JTF_NUMBER_TABLE
108: , a26 out nocopy JTF_NUMBER_TABLE
109: , a27 out nocopy JTF_NUMBER_TABLE
110: , a28 out nocopy JTF_VARCHAR2_TABLE_300
111: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
113: ) as
114: ddindx binary_integer; indx binary_integer;
115: begin

Line 112: , a30 out nocopy JTF_VARCHAR2_TABLE_2000

108: , a26 out nocopy JTF_NUMBER_TABLE
109: , a27 out nocopy JTF_NUMBER_TABLE
110: , a28 out nocopy JTF_VARCHAR2_TABLE_300
111: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
113: ) as
114: ddindx binary_integer; indx binary_integer;
115: begin
116: if t is null or t.count = 0 then

Line 146: a29 := JTF_VARCHAR2_TABLE_2000();

142: a25 := JTF_NUMBER_TABLE();
143: a26 := JTF_NUMBER_TABLE();
144: a27 := JTF_NUMBER_TABLE();
145: a28 := JTF_VARCHAR2_TABLE_300();
146: a29 := JTF_VARCHAR2_TABLE_2000();
147: a30 := JTF_VARCHAR2_TABLE_2000();
148: else
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_NUMBER_TABLE();

Line 147: a30 := JTF_VARCHAR2_TABLE_2000();

143: a26 := JTF_NUMBER_TABLE();
144: a27 := JTF_NUMBER_TABLE();
145: a28 := JTF_VARCHAR2_TABLE_300();
146: a29 := JTF_VARCHAR2_TABLE_2000();
147: a30 := JTF_VARCHAR2_TABLE_2000();
148: else
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_NUMBER_TABLE();
151: a2 := JTF_VARCHAR2_TABLE_100();

Line 178: a29 := JTF_VARCHAR2_TABLE_2000();

174: a25 := JTF_NUMBER_TABLE();
175: a26 := JTF_NUMBER_TABLE();
176: a27 := JTF_NUMBER_TABLE();
177: a28 := JTF_VARCHAR2_TABLE_300();
178: a29 := JTF_VARCHAR2_TABLE_2000();
179: a30 := JTF_VARCHAR2_TABLE_2000();
180: if t.count > 0 then
181: a0.extend(t.count);
182: a1.extend(t.count);

Line 179: a30 := JTF_VARCHAR2_TABLE_2000();

175: a26 := JTF_NUMBER_TABLE();
176: a27 := JTF_NUMBER_TABLE();
177: a28 := JTF_VARCHAR2_TABLE_300();
178: a29 := JTF_VARCHAR2_TABLE_2000();
179: a30 := JTF_VARCHAR2_TABLE_2000();
180: if t.count > 0 then
181: a0.extend(t.count);
182: a1.extend(t.count);
183: a2.extend(t.count);

Line 290: , p5_a29 JTF_VARCHAR2_TABLE_2000

286: , p5_a25 JTF_NUMBER_TABLE
287: , p5_a26 JTF_NUMBER_TABLE
288: , p5_a27 JTF_NUMBER_TABLE
289: , p5_a28 JTF_VARCHAR2_TABLE_300
290: , p5_a29 JTF_VARCHAR2_TABLE_2000
291: , p5_a30 JTF_VARCHAR2_TABLE_2000
292: , p6_a0 out nocopy JTF_NUMBER_TABLE
293: , p6_a1 out nocopy JTF_NUMBER_TABLE
294: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 291: , p5_a30 JTF_VARCHAR2_TABLE_2000

287: , p5_a26 JTF_NUMBER_TABLE
288: , p5_a27 JTF_NUMBER_TABLE
289: , p5_a28 JTF_VARCHAR2_TABLE_300
290: , p5_a29 JTF_VARCHAR2_TABLE_2000
291: , p5_a30 JTF_VARCHAR2_TABLE_2000
292: , p6_a0 out nocopy JTF_NUMBER_TABLE
293: , p6_a1 out nocopy JTF_NUMBER_TABLE
294: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
295: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500

Line 321: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_2000

317: , p6_a25 out nocopy JTF_NUMBER_TABLE
318: , p6_a26 out nocopy JTF_NUMBER_TABLE
319: , p6_a27 out nocopy JTF_NUMBER_TABLE
320: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_300
321: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_2000
322: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_2000
323: )
324:
325: as

Line 322: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_2000

318: , p6_a26 out nocopy JTF_NUMBER_TABLE
319: , p6_a27 out nocopy JTF_NUMBER_TABLE
320: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_300
321: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_2000
322: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_2000
323: )
324:
325: as
326: ddp_qqlv_tbl okl_qql_pvt.qqlv_tbl_type;

Line 455: , p5_a29 JTF_VARCHAR2_TABLE_2000

451: , p5_a25 JTF_NUMBER_TABLE
452: , p5_a26 JTF_NUMBER_TABLE
453: , p5_a27 JTF_NUMBER_TABLE
454: , p5_a28 JTF_VARCHAR2_TABLE_300
455: , p5_a29 JTF_VARCHAR2_TABLE_2000
456: , p5_a30 JTF_VARCHAR2_TABLE_2000
457: , p6_a0 out nocopy JTF_NUMBER_TABLE
458: , p6_a1 out nocopy JTF_NUMBER_TABLE
459: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 456: , p5_a30 JTF_VARCHAR2_TABLE_2000

452: , p5_a26 JTF_NUMBER_TABLE
453: , p5_a27 JTF_NUMBER_TABLE
454: , p5_a28 JTF_VARCHAR2_TABLE_300
455: , p5_a29 JTF_VARCHAR2_TABLE_2000
456: , p5_a30 JTF_VARCHAR2_TABLE_2000
457: , p6_a0 out nocopy JTF_NUMBER_TABLE
458: , p6_a1 out nocopy JTF_NUMBER_TABLE
459: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
460: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500

Line 486: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_2000

482: , p6_a25 out nocopy JTF_NUMBER_TABLE
483: , p6_a26 out nocopy JTF_NUMBER_TABLE
484: , p6_a27 out nocopy JTF_NUMBER_TABLE
485: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_300
486: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_2000
487: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_2000
488: )
489:
490: as

Line 487: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_2000

483: , p6_a26 out nocopy JTF_NUMBER_TABLE
484: , p6_a27 out nocopy JTF_NUMBER_TABLE
485: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_300
486: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_2000
487: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_2000
488: )
489:
490: as
491: ddp_qqlv_tbl okl_qql_pvt.qqlv_tbl_type;

Line 620: , p5_a29 JTF_VARCHAR2_TABLE_2000

616: , p5_a25 JTF_NUMBER_TABLE
617: , p5_a26 JTF_NUMBER_TABLE
618: , p5_a27 JTF_NUMBER_TABLE
619: , p5_a28 JTF_VARCHAR2_TABLE_300
620: , p5_a29 JTF_VARCHAR2_TABLE_2000
621: , p5_a30 JTF_VARCHAR2_TABLE_2000
622: )
623:
624: as

Line 621: , p5_a30 JTF_VARCHAR2_TABLE_2000

617: , p5_a26 JTF_NUMBER_TABLE
618: , p5_a27 JTF_NUMBER_TABLE
619: , p5_a28 JTF_VARCHAR2_TABLE_300
620: , p5_a29 JTF_VARCHAR2_TABLE_2000
621: , p5_a30 JTF_VARCHAR2_TABLE_2000
622: )
623:
624: as
625: ddp_qqlv_tbl okl_qql_pvt.qqlv_tbl_type;