DBA Data[Home] [Help]

APPS.OKL_LSQ_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_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE

Line 73: , a70 JTF_VARCHAR2_TABLE_2000

69: , a66 JTF_VARCHAR2_TABLE_100
70: , a67 JTF_NUMBER_TABLE
71: , a68 JTF_VARCHAR2_TABLE_300
72: , a69 JTF_VARCHAR2_TABLE_300
73: , a70 JTF_VARCHAR2_TABLE_2000
74: , a71 JTF_VARCHAR2_TABLE_2000
75: ) as
76: ddindx binary_integer; indx binary_integer;
77: begin

Line 74: , a71 JTF_VARCHAR2_TABLE_2000

70: , a67 JTF_NUMBER_TABLE
71: , a68 JTF_VARCHAR2_TABLE_300
72: , a69 JTF_VARCHAR2_TABLE_300
73: , a70 JTF_VARCHAR2_TABLE_2000
74: , a71 JTF_VARCHAR2_TABLE_2000
75: ) as
76: ddindx binary_integer; indx binary_integer;
77: begin
78: if a0 is not null and a0.count > 0 then

Line 182: , a18 out nocopy JTF_VARCHAR2_TABLE_200

178: , a14 out nocopy JTF_VARCHAR2_TABLE_500
179: , a15 out nocopy JTF_VARCHAR2_TABLE_500
180: , a16 out nocopy JTF_VARCHAR2_TABLE_500
181: , a17 out nocopy JTF_VARCHAR2_TABLE_500
182: , a18 out nocopy JTF_VARCHAR2_TABLE_200
183: , a19 out nocopy JTF_VARCHAR2_TABLE_100
184: , a20 out nocopy JTF_VARCHAR2_TABLE_100
185: , a21 out nocopy JTF_NUMBER_TABLE
186: , a22 out nocopy JTF_DATE_TABLE

Line 234: , a70 out nocopy JTF_VARCHAR2_TABLE_2000

230: , a66 out nocopy JTF_VARCHAR2_TABLE_100
231: , a67 out nocopy JTF_NUMBER_TABLE
232: , a68 out nocopy JTF_VARCHAR2_TABLE_300
233: , a69 out nocopy JTF_VARCHAR2_TABLE_300
234: , a70 out nocopy JTF_VARCHAR2_TABLE_2000
235: , a71 out nocopy JTF_VARCHAR2_TABLE_2000
236: ) as
237: ddindx binary_integer; indx binary_integer;
238: begin

Line 235: , a71 out nocopy JTF_VARCHAR2_TABLE_2000

231: , a67 out nocopy JTF_NUMBER_TABLE
232: , a68 out nocopy JTF_VARCHAR2_TABLE_300
233: , a69 out nocopy JTF_VARCHAR2_TABLE_300
234: , a70 out nocopy JTF_VARCHAR2_TABLE_2000
235: , a71 out nocopy JTF_VARCHAR2_TABLE_2000
236: ) as
237: ddindx binary_integer; indx binary_integer;
238: begin
239: if t is null or t.count = 0 then

Line 258: a18 := JTF_VARCHAR2_TABLE_200();

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

Line 310: a70 := JTF_VARCHAR2_TABLE_2000();

306: a66 := JTF_VARCHAR2_TABLE_100();
307: a67 := JTF_NUMBER_TABLE();
308: a68 := JTF_VARCHAR2_TABLE_300();
309: a69 := JTF_VARCHAR2_TABLE_300();
310: a70 := JTF_VARCHAR2_TABLE_2000();
311: a71 := JTF_VARCHAR2_TABLE_2000();
312: else
313: a0 := JTF_NUMBER_TABLE();
314: a1 := JTF_NUMBER_TABLE();

Line 311: a71 := JTF_VARCHAR2_TABLE_2000();

307: a67 := JTF_NUMBER_TABLE();
308: a68 := JTF_VARCHAR2_TABLE_300();
309: a69 := JTF_VARCHAR2_TABLE_300();
310: a70 := JTF_VARCHAR2_TABLE_2000();
311: a71 := JTF_VARCHAR2_TABLE_2000();
312: else
313: a0 := JTF_NUMBER_TABLE();
314: a1 := JTF_NUMBER_TABLE();
315: a2 := JTF_VARCHAR2_TABLE_100();

Line 331: a18 := JTF_VARCHAR2_TABLE_200();

327: a14 := JTF_VARCHAR2_TABLE_500();
328: a15 := JTF_VARCHAR2_TABLE_500();
329: a16 := JTF_VARCHAR2_TABLE_500();
330: a17 := JTF_VARCHAR2_TABLE_500();
331: a18 := JTF_VARCHAR2_TABLE_200();
332: a19 := JTF_VARCHAR2_TABLE_100();
333: a20 := JTF_VARCHAR2_TABLE_100();
334: a21 := JTF_NUMBER_TABLE();
335: a22 := JTF_DATE_TABLE();

Line 383: a70 := JTF_VARCHAR2_TABLE_2000();

379: a66 := JTF_VARCHAR2_TABLE_100();
380: a67 := JTF_NUMBER_TABLE();
381: a68 := JTF_VARCHAR2_TABLE_300();
382: a69 := JTF_VARCHAR2_TABLE_300();
383: a70 := JTF_VARCHAR2_TABLE_2000();
384: a71 := JTF_VARCHAR2_TABLE_2000();
385: if t.count > 0 then
386: a0.extend(t.count);
387: a1.extend(t.count);

Line 384: a71 := JTF_VARCHAR2_TABLE_2000();

380: a67 := JTF_NUMBER_TABLE();
381: a68 := JTF_VARCHAR2_TABLE_300();
382: a69 := JTF_VARCHAR2_TABLE_300();
383: a70 := JTF_VARCHAR2_TABLE_2000();
384: a71 := JTF_VARCHAR2_TABLE_2000();
385: if t.count > 0 then
386: a0.extend(t.count);
387: a1.extend(t.count);
388: a2.extend(t.count);

Line 566: , p5_a18 JTF_VARCHAR2_TABLE_200

562: , p5_a14 JTF_VARCHAR2_TABLE_500
563: , p5_a15 JTF_VARCHAR2_TABLE_500
564: , p5_a16 JTF_VARCHAR2_TABLE_500
565: , p5_a17 JTF_VARCHAR2_TABLE_500
566: , p5_a18 JTF_VARCHAR2_TABLE_200
567: , p5_a19 JTF_VARCHAR2_TABLE_100
568: , p5_a20 JTF_VARCHAR2_TABLE_100
569: , p5_a21 JTF_NUMBER_TABLE
570: , p5_a22 JTF_DATE_TABLE

Line 618: , p5_a70 JTF_VARCHAR2_TABLE_2000

614: , p5_a66 JTF_VARCHAR2_TABLE_100
615: , p5_a67 JTF_NUMBER_TABLE
616: , p5_a68 JTF_VARCHAR2_TABLE_300
617: , p5_a69 JTF_VARCHAR2_TABLE_300
618: , p5_a70 JTF_VARCHAR2_TABLE_2000
619: , p5_a71 JTF_VARCHAR2_TABLE_2000
620: , p6_a0 out nocopy JTF_NUMBER_TABLE
621: , p6_a1 out nocopy JTF_NUMBER_TABLE
622: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 619: , p5_a71 JTF_VARCHAR2_TABLE_2000

615: , p5_a67 JTF_NUMBER_TABLE
616: , p5_a68 JTF_VARCHAR2_TABLE_300
617: , p5_a69 JTF_VARCHAR2_TABLE_300
618: , p5_a70 JTF_VARCHAR2_TABLE_2000
619: , p5_a71 JTF_VARCHAR2_TABLE_2000
620: , p6_a0 out nocopy JTF_NUMBER_TABLE
621: , p6_a1 out nocopy JTF_NUMBER_TABLE
622: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500

Line 638: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200

634: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
635: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
636: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
637: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
638: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
639: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
640: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
641: , p6_a21 out nocopy JTF_NUMBER_TABLE
642: , p6_a22 out nocopy JTF_DATE_TABLE

Line 690: , p6_a70 out nocopy JTF_VARCHAR2_TABLE_2000

686: , p6_a66 out nocopy JTF_VARCHAR2_TABLE_100
687: , p6_a67 out nocopy JTF_NUMBER_TABLE
688: , p6_a68 out nocopy JTF_VARCHAR2_TABLE_300
689: , p6_a69 out nocopy JTF_VARCHAR2_TABLE_300
690: , p6_a70 out nocopy JTF_VARCHAR2_TABLE_2000
691: , p6_a71 out nocopy JTF_VARCHAR2_TABLE_2000
692: )
693:
694: as

Line 691: , p6_a71 out nocopy JTF_VARCHAR2_TABLE_2000

687: , p6_a67 out nocopy JTF_NUMBER_TABLE
688: , p6_a68 out nocopy JTF_VARCHAR2_TABLE_300
689: , p6_a69 out nocopy JTF_VARCHAR2_TABLE_300
690: , p6_a70 out nocopy JTF_VARCHAR2_TABLE_2000
691: , p6_a71 out nocopy JTF_VARCHAR2_TABLE_2000
692: )
693:
694: as
695: ddp_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;

Line 895: , p5_a18 JTF_VARCHAR2_TABLE_200

891: , p5_a14 JTF_VARCHAR2_TABLE_500
892: , p5_a15 JTF_VARCHAR2_TABLE_500
893: , p5_a16 JTF_VARCHAR2_TABLE_500
894: , p5_a17 JTF_VARCHAR2_TABLE_500
895: , p5_a18 JTF_VARCHAR2_TABLE_200
896: , p5_a19 JTF_VARCHAR2_TABLE_100
897: , p5_a20 JTF_VARCHAR2_TABLE_100
898: , p5_a21 JTF_NUMBER_TABLE
899: , p5_a22 JTF_DATE_TABLE

Line 947: , p5_a70 JTF_VARCHAR2_TABLE_2000

943: , p5_a66 JTF_VARCHAR2_TABLE_100
944: , p5_a67 JTF_NUMBER_TABLE
945: , p5_a68 JTF_VARCHAR2_TABLE_300
946: , p5_a69 JTF_VARCHAR2_TABLE_300
947: , p5_a70 JTF_VARCHAR2_TABLE_2000
948: , p5_a71 JTF_VARCHAR2_TABLE_2000
949: , p6_a0 out nocopy JTF_NUMBER_TABLE
950: , p6_a1 out nocopy JTF_NUMBER_TABLE
951: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 948: , p5_a71 JTF_VARCHAR2_TABLE_2000

944: , p5_a67 JTF_NUMBER_TABLE
945: , p5_a68 JTF_VARCHAR2_TABLE_300
946: , p5_a69 JTF_VARCHAR2_TABLE_300
947: , p5_a70 JTF_VARCHAR2_TABLE_2000
948: , p5_a71 JTF_VARCHAR2_TABLE_2000
949: , p6_a0 out nocopy JTF_NUMBER_TABLE
950: , p6_a1 out nocopy JTF_NUMBER_TABLE
951: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
952: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500

Line 967: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200

963: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
964: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
965: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
966: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
967: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
968: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
969: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
970: , p6_a21 out nocopy JTF_NUMBER_TABLE
971: , p6_a22 out nocopy JTF_DATE_TABLE

Line 1019: , p6_a70 out nocopy JTF_VARCHAR2_TABLE_2000

1015: , p6_a66 out nocopy JTF_VARCHAR2_TABLE_100
1016: , p6_a67 out nocopy JTF_NUMBER_TABLE
1017: , p6_a68 out nocopy JTF_VARCHAR2_TABLE_300
1018: , p6_a69 out nocopy JTF_VARCHAR2_TABLE_300
1019: , p6_a70 out nocopy JTF_VARCHAR2_TABLE_2000
1020: , p6_a71 out nocopy JTF_VARCHAR2_TABLE_2000
1021: )
1022:
1023: as

Line 1020: , p6_a71 out nocopy JTF_VARCHAR2_TABLE_2000

1016: , p6_a67 out nocopy JTF_NUMBER_TABLE
1017: , p6_a68 out nocopy JTF_VARCHAR2_TABLE_300
1018: , p6_a69 out nocopy JTF_VARCHAR2_TABLE_300
1019: , p6_a70 out nocopy JTF_VARCHAR2_TABLE_2000
1020: , p6_a71 out nocopy JTF_VARCHAR2_TABLE_2000
1021: )
1022:
1023: as
1024: ddp_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;

Line 1224: , p5_a18 JTF_VARCHAR2_TABLE_200

1220: , p5_a14 JTF_VARCHAR2_TABLE_500
1221: , p5_a15 JTF_VARCHAR2_TABLE_500
1222: , p5_a16 JTF_VARCHAR2_TABLE_500
1223: , p5_a17 JTF_VARCHAR2_TABLE_500
1224: , p5_a18 JTF_VARCHAR2_TABLE_200
1225: , p5_a19 JTF_VARCHAR2_TABLE_100
1226: , p5_a20 JTF_VARCHAR2_TABLE_100
1227: , p5_a21 JTF_NUMBER_TABLE
1228: , p5_a22 JTF_DATE_TABLE

Line 1276: , p5_a70 JTF_VARCHAR2_TABLE_2000

1272: , p5_a66 JTF_VARCHAR2_TABLE_100
1273: , p5_a67 JTF_NUMBER_TABLE
1274: , p5_a68 JTF_VARCHAR2_TABLE_300
1275: , p5_a69 JTF_VARCHAR2_TABLE_300
1276: , p5_a70 JTF_VARCHAR2_TABLE_2000
1277: , p5_a71 JTF_VARCHAR2_TABLE_2000
1278: )
1279:
1280: as

Line 1277: , p5_a71 JTF_VARCHAR2_TABLE_2000

1273: , p5_a67 JTF_NUMBER_TABLE
1274: , p5_a68 JTF_VARCHAR2_TABLE_300
1275: , p5_a69 JTF_VARCHAR2_TABLE_300
1276: , p5_a70 JTF_VARCHAR2_TABLE_2000
1277: , p5_a71 JTF_VARCHAR2_TABLE_2000
1278: )
1279:
1280: as
1281: ddp_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;