DBA Data[Home] [Help]

APPS.OKL_LSQ_PVT_W dependencies on JTF_VARCHAR2_TABLE_2000

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 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 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 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 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 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 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 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 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;