DBA Data[Home] [Help]

APPS.OKL_LOP_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 21: , a18 JTF_VARCHAR2_TABLE_200

17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE

Line 54: , a51 JTF_VARCHAR2_TABLE_2000

50: , a47 JTF_NUMBER_TABLE
51: , a48 JTF_NUMBER_TABLE
52: , a49 JTF_VARCHAR2_TABLE_300
53: , a50 JTF_VARCHAR2_TABLE_300
54: , a51 JTF_VARCHAR2_TABLE_2000
55: , a52 JTF_VARCHAR2_TABLE_2000
56: ) as
57: ddindx binary_integer; indx binary_integer;
58: begin

Line 55: , a52 JTF_VARCHAR2_TABLE_2000

51: , a48 JTF_NUMBER_TABLE
52: , a49 JTF_VARCHAR2_TABLE_300
53: , a50 JTF_VARCHAR2_TABLE_300
54: , a51 JTF_VARCHAR2_TABLE_2000
55: , a52 JTF_VARCHAR2_TABLE_2000
56: ) as
57: ddindx binary_integer; indx binary_integer;
58: begin
59: if a0 is not null and a0.count > 0 then

Line 144: , a18 out nocopy JTF_VARCHAR2_TABLE_200

140: , a14 out nocopy JTF_VARCHAR2_TABLE_500
141: , a15 out nocopy JTF_VARCHAR2_TABLE_500
142: , a16 out nocopy JTF_VARCHAR2_TABLE_500
143: , a17 out nocopy JTF_VARCHAR2_TABLE_500
144: , a18 out nocopy JTF_VARCHAR2_TABLE_200
145: , a19 out nocopy JTF_VARCHAR2_TABLE_100
146: , a20 out nocopy JTF_DATE_TABLE
147: , a21 out nocopy JTF_DATE_TABLE
148: , a22 out nocopy JTF_NUMBER_TABLE

Line 177: , a51 out nocopy JTF_VARCHAR2_TABLE_2000

173: , a47 out nocopy JTF_NUMBER_TABLE
174: , a48 out nocopy JTF_NUMBER_TABLE
175: , a49 out nocopy JTF_VARCHAR2_TABLE_300
176: , a50 out nocopy JTF_VARCHAR2_TABLE_300
177: , a51 out nocopy JTF_VARCHAR2_TABLE_2000
178: , a52 out nocopy JTF_VARCHAR2_TABLE_2000
179: ) as
180: ddindx binary_integer; indx binary_integer;
181: begin

Line 178: , a52 out nocopy JTF_VARCHAR2_TABLE_2000

174: , a48 out nocopy JTF_NUMBER_TABLE
175: , a49 out nocopy JTF_VARCHAR2_TABLE_300
176: , a50 out nocopy JTF_VARCHAR2_TABLE_300
177: , a51 out nocopy JTF_VARCHAR2_TABLE_2000
178: , a52 out nocopy JTF_VARCHAR2_TABLE_2000
179: ) as
180: ddindx binary_integer; indx binary_integer;
181: begin
182: if t is null or t.count = 0 then

Line 201: a18 := JTF_VARCHAR2_TABLE_200();

197: a14 := JTF_VARCHAR2_TABLE_500();
198: a15 := JTF_VARCHAR2_TABLE_500();
199: a16 := JTF_VARCHAR2_TABLE_500();
200: a17 := JTF_VARCHAR2_TABLE_500();
201: a18 := JTF_VARCHAR2_TABLE_200();
202: a19 := JTF_VARCHAR2_TABLE_100();
203: a20 := JTF_DATE_TABLE();
204: a21 := JTF_DATE_TABLE();
205: a22 := JTF_NUMBER_TABLE();

Line 234: a51 := JTF_VARCHAR2_TABLE_2000();

230: a47 := JTF_NUMBER_TABLE();
231: a48 := JTF_NUMBER_TABLE();
232: a49 := JTF_VARCHAR2_TABLE_300();
233: a50 := JTF_VARCHAR2_TABLE_300();
234: a51 := JTF_VARCHAR2_TABLE_2000();
235: a52 := JTF_VARCHAR2_TABLE_2000();
236: else
237: a0 := JTF_NUMBER_TABLE();
238: a1 := JTF_NUMBER_TABLE();

Line 235: a52 := JTF_VARCHAR2_TABLE_2000();

231: a48 := JTF_NUMBER_TABLE();
232: a49 := JTF_VARCHAR2_TABLE_300();
233: a50 := JTF_VARCHAR2_TABLE_300();
234: a51 := JTF_VARCHAR2_TABLE_2000();
235: a52 := JTF_VARCHAR2_TABLE_2000();
236: else
237: a0 := JTF_NUMBER_TABLE();
238: a1 := JTF_NUMBER_TABLE();
239: a2 := JTF_VARCHAR2_TABLE_100();

Line 255: a18 := JTF_VARCHAR2_TABLE_200();

251: a14 := JTF_VARCHAR2_TABLE_500();
252: a15 := JTF_VARCHAR2_TABLE_500();
253: a16 := JTF_VARCHAR2_TABLE_500();
254: a17 := JTF_VARCHAR2_TABLE_500();
255: a18 := JTF_VARCHAR2_TABLE_200();
256: a19 := JTF_VARCHAR2_TABLE_100();
257: a20 := JTF_DATE_TABLE();
258: a21 := JTF_DATE_TABLE();
259: a22 := JTF_NUMBER_TABLE();

Line 288: a51 := JTF_VARCHAR2_TABLE_2000();

284: a47 := JTF_NUMBER_TABLE();
285: a48 := JTF_NUMBER_TABLE();
286: a49 := JTF_VARCHAR2_TABLE_300();
287: a50 := JTF_VARCHAR2_TABLE_300();
288: a51 := JTF_VARCHAR2_TABLE_2000();
289: a52 := JTF_VARCHAR2_TABLE_2000();
290: if t.count > 0 then
291: a0.extend(t.count);
292: a1.extend(t.count);

Line 289: a52 := JTF_VARCHAR2_TABLE_2000();

285: a48 := JTF_NUMBER_TABLE();
286: a49 := JTF_VARCHAR2_TABLE_300();
287: a50 := JTF_VARCHAR2_TABLE_300();
288: a51 := JTF_VARCHAR2_TABLE_2000();
289: a52 := JTF_VARCHAR2_TABLE_2000();
290: if t.count > 0 then
291: a0.extend(t.count);
292: a1.extend(t.count);
293: a2.extend(t.count);

Line 433: , p5_a18 JTF_VARCHAR2_TABLE_200

429: , p5_a14 JTF_VARCHAR2_TABLE_500
430: , p5_a15 JTF_VARCHAR2_TABLE_500
431: , p5_a16 JTF_VARCHAR2_TABLE_500
432: , p5_a17 JTF_VARCHAR2_TABLE_500
433: , p5_a18 JTF_VARCHAR2_TABLE_200
434: , p5_a19 JTF_VARCHAR2_TABLE_100
435: , p5_a20 JTF_DATE_TABLE
436: , p5_a21 JTF_DATE_TABLE
437: , p5_a22 JTF_NUMBER_TABLE

Line 466: , p5_a51 JTF_VARCHAR2_TABLE_2000

462: , p5_a47 JTF_NUMBER_TABLE
463: , p5_a48 JTF_NUMBER_TABLE
464: , p5_a49 JTF_VARCHAR2_TABLE_300
465: , p5_a50 JTF_VARCHAR2_TABLE_300
466: , p5_a51 JTF_VARCHAR2_TABLE_2000
467: , p5_a52 JTF_VARCHAR2_TABLE_2000
468: , p6_a0 out nocopy JTF_NUMBER_TABLE
469: , p6_a1 out nocopy JTF_NUMBER_TABLE
470: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 467: , p5_a52 JTF_VARCHAR2_TABLE_2000

463: , p5_a48 JTF_NUMBER_TABLE
464: , p5_a49 JTF_VARCHAR2_TABLE_300
465: , p5_a50 JTF_VARCHAR2_TABLE_300
466: , p5_a51 JTF_VARCHAR2_TABLE_2000
467: , p5_a52 JTF_VARCHAR2_TABLE_2000
468: , p6_a0 out nocopy JTF_NUMBER_TABLE
469: , p6_a1 out nocopy JTF_NUMBER_TABLE
470: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
471: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500

Line 486: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200

482: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
483: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
484: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
485: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
486: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
487: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
488: , p6_a20 out nocopy JTF_DATE_TABLE
489: , p6_a21 out nocopy JTF_DATE_TABLE
490: , p6_a22 out nocopy JTF_NUMBER_TABLE

Line 519: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000

515: , p6_a47 out nocopy JTF_NUMBER_TABLE
516: , p6_a48 out nocopy JTF_NUMBER_TABLE
517: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_300
518: , p6_a50 out nocopy JTF_VARCHAR2_TABLE_300
519: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000
520: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
521: )
522:
523: as

Line 520: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000

516: , p6_a48 out nocopy JTF_NUMBER_TABLE
517: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_300
518: , p6_a50 out nocopy JTF_VARCHAR2_TABLE_300
519: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000
520: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
521: )
522:
523: as
524: ddp_lopv_tbl okl_lop_pvt.lopv_tbl_type;

Line 686: , p5_a18 JTF_VARCHAR2_TABLE_200

682: , p5_a14 JTF_VARCHAR2_TABLE_500
683: , p5_a15 JTF_VARCHAR2_TABLE_500
684: , p5_a16 JTF_VARCHAR2_TABLE_500
685: , p5_a17 JTF_VARCHAR2_TABLE_500
686: , p5_a18 JTF_VARCHAR2_TABLE_200
687: , p5_a19 JTF_VARCHAR2_TABLE_100
688: , p5_a20 JTF_DATE_TABLE
689: , p5_a21 JTF_DATE_TABLE
690: , p5_a22 JTF_NUMBER_TABLE

Line 719: , p5_a51 JTF_VARCHAR2_TABLE_2000

715: , p5_a47 JTF_NUMBER_TABLE
716: , p5_a48 JTF_NUMBER_TABLE
717: , p5_a49 JTF_VARCHAR2_TABLE_300
718: , p5_a50 JTF_VARCHAR2_TABLE_300
719: , p5_a51 JTF_VARCHAR2_TABLE_2000
720: , p5_a52 JTF_VARCHAR2_TABLE_2000
721: , p6_a0 out nocopy JTF_NUMBER_TABLE
722: , p6_a1 out nocopy JTF_NUMBER_TABLE
723: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 720: , p5_a52 JTF_VARCHAR2_TABLE_2000

716: , p5_a48 JTF_NUMBER_TABLE
717: , p5_a49 JTF_VARCHAR2_TABLE_300
718: , p5_a50 JTF_VARCHAR2_TABLE_300
719: , p5_a51 JTF_VARCHAR2_TABLE_2000
720: , p5_a52 JTF_VARCHAR2_TABLE_2000
721: , p6_a0 out nocopy JTF_NUMBER_TABLE
722: , p6_a1 out nocopy JTF_NUMBER_TABLE
723: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
724: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500

Line 739: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200

735: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
736: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
737: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
738: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
739: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
740: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a20 out nocopy JTF_DATE_TABLE
742: , p6_a21 out nocopy JTF_DATE_TABLE
743: , p6_a22 out nocopy JTF_NUMBER_TABLE

Line 772: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000

768: , p6_a47 out nocopy JTF_NUMBER_TABLE
769: , p6_a48 out nocopy JTF_NUMBER_TABLE
770: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_300
771: , p6_a50 out nocopy JTF_VARCHAR2_TABLE_300
772: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000
773: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
774: )
775:
776: as

Line 773: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000

769: , p6_a48 out nocopy JTF_NUMBER_TABLE
770: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_300
771: , p6_a50 out nocopy JTF_VARCHAR2_TABLE_300
772: , p6_a51 out nocopy JTF_VARCHAR2_TABLE_2000
773: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_2000
774: )
775:
776: as
777: ddp_lopv_tbl okl_lop_pvt.lopv_tbl_type;

Line 939: , p5_a18 JTF_VARCHAR2_TABLE_200

935: , p5_a14 JTF_VARCHAR2_TABLE_500
936: , p5_a15 JTF_VARCHAR2_TABLE_500
937: , p5_a16 JTF_VARCHAR2_TABLE_500
938: , p5_a17 JTF_VARCHAR2_TABLE_500
939: , p5_a18 JTF_VARCHAR2_TABLE_200
940: , p5_a19 JTF_VARCHAR2_TABLE_100
941: , p5_a20 JTF_DATE_TABLE
942: , p5_a21 JTF_DATE_TABLE
943: , p5_a22 JTF_NUMBER_TABLE

Line 972: , p5_a51 JTF_VARCHAR2_TABLE_2000

968: , p5_a47 JTF_NUMBER_TABLE
969: , p5_a48 JTF_NUMBER_TABLE
970: , p5_a49 JTF_VARCHAR2_TABLE_300
971: , p5_a50 JTF_VARCHAR2_TABLE_300
972: , p5_a51 JTF_VARCHAR2_TABLE_2000
973: , p5_a52 JTF_VARCHAR2_TABLE_2000
974: )
975:
976: as

Line 973: , p5_a52 JTF_VARCHAR2_TABLE_2000

969: , p5_a48 JTF_NUMBER_TABLE
970: , p5_a49 JTF_VARCHAR2_TABLE_300
971: , p5_a50 JTF_VARCHAR2_TABLE_300
972: , p5_a51 JTF_VARCHAR2_TABLE_2000
973: , p5_a52 JTF_VARCHAR2_TABLE_2000
974: )
975:
976: as
977: ddp_lopv_tbl okl_lop_pvt.lopv_tbl_type;