DBA Data[Home] [Help]

APPS.OKL_PDT_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 23: , a1 JTF_VARCHAR2_TABLE_200

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_pdt_pvt.pdt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100

Line 29: , a7 JTF_VARCHAR2_TABLE_2000

25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_2000
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_DATE_TABLE

Line 106: , a1 out nocopy JTF_VARCHAR2_TABLE_200

102: end if;
103: end if;
104: end rosetta_table_copy_in_p2;
105: procedure rosetta_table_copy_out_p2(t okl_pdt_pvt.pdt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
106: , a1 out nocopy JTF_VARCHAR2_TABLE_200
107: , a2 out nocopy JTF_NUMBER_TABLE
108: , a3 out nocopy JTF_NUMBER_TABLE
109: , a4 out nocopy JTF_VARCHAR2_TABLE_100
110: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 112: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

108: , a3 out nocopy JTF_NUMBER_TABLE
109: , a4 out nocopy JTF_VARCHAR2_TABLE_100
110: , a5 out nocopy JTF_VARCHAR2_TABLE_100
111: , a6 out nocopy JTF_NUMBER_TABLE
112: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
113: , a8 out nocopy JTF_NUMBER_TABLE
114: , a9 out nocopy JTF_VARCHAR2_TABLE_100
115: , a10 out nocopy JTF_DATE_TABLE
116: , a11 out nocopy JTF_DATE_TABLE

Line 143: a1 := JTF_VARCHAR2_TABLE_200();

139: ddindx binary_integer; indx binary_integer;
140: begin
141: if t is null or t.count = 0 then
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_VARCHAR2_TABLE_200();
144: a2 := JTF_NUMBER_TABLE();
145: a3 := JTF_NUMBER_TABLE();
146: a4 := JTF_VARCHAR2_TABLE_100();
147: a5 := JTF_VARCHAR2_TABLE_100();

Line 149: a7 := JTF_VARCHAR2_TABLE_2000();

145: a3 := JTF_NUMBER_TABLE();
146: a4 := JTF_VARCHAR2_TABLE_100();
147: a5 := JTF_VARCHAR2_TABLE_100();
148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_VARCHAR2_TABLE_2000();
150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_VARCHAR2_TABLE_100();
152: a10 := JTF_DATE_TABLE();
153: a11 := JTF_DATE_TABLE();

Line 177: a1 := JTF_VARCHAR2_TABLE_200();

173: a31 := JTF_DATE_TABLE();
174: a32 := JTF_NUMBER_TABLE();
175: else
176: a0 := JTF_NUMBER_TABLE();
177: a1 := JTF_VARCHAR2_TABLE_200();
178: a2 := JTF_NUMBER_TABLE();
179: a3 := JTF_NUMBER_TABLE();
180: a4 := JTF_VARCHAR2_TABLE_100();
181: a5 := JTF_VARCHAR2_TABLE_100();

Line 183: a7 := JTF_VARCHAR2_TABLE_2000();

179: a3 := JTF_NUMBER_TABLE();
180: a4 := JTF_VARCHAR2_TABLE_100();
181: a5 := JTF_VARCHAR2_TABLE_100();
182: a6 := JTF_NUMBER_TABLE();
183: a7 := JTF_VARCHAR2_TABLE_2000();
184: a8 := JTF_NUMBER_TABLE();
185: a9 := JTF_VARCHAR2_TABLE_100();
186: a10 := JTF_DATE_TABLE();
187: a11 := JTF_DATE_TABLE();

Line 293: , a4 JTF_VARCHAR2_TABLE_200

289: procedure rosetta_table_copy_in_p5(t out nocopy okl_pdt_pvt.pdtv_tbl_type, a0 JTF_NUMBER_TABLE
290: , a1 JTF_NUMBER_TABLE
291: , a2 JTF_NUMBER_TABLE
292: , a3 JTF_NUMBER_TABLE
293: , a4 JTF_VARCHAR2_TABLE_200
294: , a5 JTF_VARCHAR2_TABLE_2000
295: , a6 JTF_NUMBER_TABLE
296: , a7 JTF_VARCHAR2_TABLE_100
297: , a8 JTF_VARCHAR2_TABLE_100

Line 294: , a5 JTF_VARCHAR2_TABLE_2000

290: , a1 JTF_NUMBER_TABLE
291: , a2 JTF_NUMBER_TABLE
292: , a3 JTF_NUMBER_TABLE
293: , a4 JTF_VARCHAR2_TABLE_200
294: , a5 JTF_VARCHAR2_TABLE_2000
295: , a6 JTF_NUMBER_TABLE
296: , a7 JTF_VARCHAR2_TABLE_100
297: , a8 JTF_VARCHAR2_TABLE_100
298: , a9 JTF_DATE_TABLE

Line 376: , a4 out nocopy JTF_VARCHAR2_TABLE_200

372: procedure rosetta_table_copy_out_p5(t okl_pdt_pvt.pdtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
373: , a1 out nocopy JTF_NUMBER_TABLE
374: , a2 out nocopy JTF_NUMBER_TABLE
375: , a3 out nocopy JTF_NUMBER_TABLE
376: , a4 out nocopy JTF_VARCHAR2_TABLE_200
377: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
378: , a6 out nocopy JTF_NUMBER_TABLE
379: , a7 out nocopy JTF_VARCHAR2_TABLE_100
380: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 377: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

373: , a1 out nocopy JTF_NUMBER_TABLE
374: , a2 out nocopy JTF_NUMBER_TABLE
375: , a3 out nocopy JTF_NUMBER_TABLE
376: , a4 out nocopy JTF_VARCHAR2_TABLE_200
377: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
378: , a6 out nocopy JTF_NUMBER_TABLE
379: , a7 out nocopy JTF_VARCHAR2_TABLE_100
380: , a8 out nocopy JTF_VARCHAR2_TABLE_100
381: , a9 out nocopy JTF_DATE_TABLE

Line 413: a4 := JTF_VARCHAR2_TABLE_200();

409: a0 := JTF_NUMBER_TABLE();
410: a1 := JTF_NUMBER_TABLE();
411: a2 := JTF_NUMBER_TABLE();
412: a3 := JTF_NUMBER_TABLE();
413: a4 := JTF_VARCHAR2_TABLE_200();
414: a5 := JTF_VARCHAR2_TABLE_2000();
415: a6 := JTF_NUMBER_TABLE();
416: a7 := JTF_VARCHAR2_TABLE_100();
417: a8 := JTF_VARCHAR2_TABLE_100();

Line 414: a5 := JTF_VARCHAR2_TABLE_2000();

410: a1 := JTF_NUMBER_TABLE();
411: a2 := JTF_NUMBER_TABLE();
412: a3 := JTF_NUMBER_TABLE();
413: a4 := JTF_VARCHAR2_TABLE_200();
414: a5 := JTF_VARCHAR2_TABLE_2000();
415: a6 := JTF_NUMBER_TABLE();
416: a7 := JTF_VARCHAR2_TABLE_100();
417: a8 := JTF_VARCHAR2_TABLE_100();
418: a9 := JTF_DATE_TABLE();

Line 447: a4 := JTF_VARCHAR2_TABLE_200();

443: a0 := JTF_NUMBER_TABLE();
444: a1 := JTF_NUMBER_TABLE();
445: a2 := JTF_NUMBER_TABLE();
446: a3 := JTF_NUMBER_TABLE();
447: a4 := JTF_VARCHAR2_TABLE_200();
448: a5 := JTF_VARCHAR2_TABLE_2000();
449: a6 := JTF_NUMBER_TABLE();
450: a7 := JTF_VARCHAR2_TABLE_100();
451: a8 := JTF_VARCHAR2_TABLE_100();

Line 448: a5 := JTF_VARCHAR2_TABLE_2000();

444: a1 := JTF_NUMBER_TABLE();
445: a2 := JTF_NUMBER_TABLE();
446: a3 := JTF_NUMBER_TABLE();
447: a4 := JTF_VARCHAR2_TABLE_200();
448: a5 := JTF_VARCHAR2_TABLE_2000();
449: a6 := JTF_NUMBER_TABLE();
450: a7 := JTF_VARCHAR2_TABLE_100();
451: a8 := JTF_VARCHAR2_TABLE_100();
452: a9 := JTF_DATE_TABLE();

Line 736: , p5_a4 JTF_VARCHAR2_TABLE_200

732: , p5_a0 JTF_NUMBER_TABLE
733: , p5_a1 JTF_NUMBER_TABLE
734: , p5_a2 JTF_NUMBER_TABLE
735: , p5_a3 JTF_NUMBER_TABLE
736: , p5_a4 JTF_VARCHAR2_TABLE_200
737: , p5_a5 JTF_VARCHAR2_TABLE_2000
738: , p5_a6 JTF_NUMBER_TABLE
739: , p5_a7 JTF_VARCHAR2_TABLE_100
740: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 737: , p5_a5 JTF_VARCHAR2_TABLE_2000

733: , p5_a1 JTF_NUMBER_TABLE
734: , p5_a2 JTF_NUMBER_TABLE
735: , p5_a3 JTF_NUMBER_TABLE
736: , p5_a4 JTF_VARCHAR2_TABLE_200
737: , p5_a5 JTF_VARCHAR2_TABLE_2000
738: , p5_a6 JTF_NUMBER_TABLE
739: , p5_a7 JTF_VARCHAR2_TABLE_100
740: , p5_a8 JTF_VARCHAR2_TABLE_100
741: , p5_a9 JTF_DATE_TABLE

Line 769: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

765: , p6_a0 out nocopy JTF_NUMBER_TABLE
766: , p6_a1 out nocopy JTF_NUMBER_TABLE
767: , p6_a2 out nocopy JTF_NUMBER_TABLE
768: , p6_a3 out nocopy JTF_NUMBER_TABLE
769: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
770: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
771: , p6_a6 out nocopy JTF_NUMBER_TABLE
772: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
773: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 770: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

766: , p6_a1 out nocopy JTF_NUMBER_TABLE
767: , p6_a2 out nocopy JTF_NUMBER_TABLE
768: , p6_a3 out nocopy JTF_NUMBER_TABLE
769: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
770: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
771: , p6_a6 out nocopy JTF_NUMBER_TABLE
772: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
773: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
774: , p6_a9 out nocopy JTF_DATE_TABLE

Line 1010: , p5_a4 JTF_VARCHAR2_TABLE_200

1006: , p5_a0 JTF_NUMBER_TABLE
1007: , p5_a1 JTF_NUMBER_TABLE
1008: , p5_a2 JTF_NUMBER_TABLE
1009: , p5_a3 JTF_NUMBER_TABLE
1010: , p5_a4 JTF_VARCHAR2_TABLE_200
1011: , p5_a5 JTF_VARCHAR2_TABLE_2000
1012: , p5_a6 JTF_NUMBER_TABLE
1013: , p5_a7 JTF_VARCHAR2_TABLE_100
1014: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 1011: , p5_a5 JTF_VARCHAR2_TABLE_2000

1007: , p5_a1 JTF_NUMBER_TABLE
1008: , p5_a2 JTF_NUMBER_TABLE
1009: , p5_a3 JTF_NUMBER_TABLE
1010: , p5_a4 JTF_VARCHAR2_TABLE_200
1011: , p5_a5 JTF_VARCHAR2_TABLE_2000
1012: , p5_a6 JTF_NUMBER_TABLE
1013: , p5_a7 JTF_VARCHAR2_TABLE_100
1014: , p5_a8 JTF_VARCHAR2_TABLE_100
1015: , p5_a9 JTF_DATE_TABLE

Line 1283: , p5_a4 JTF_VARCHAR2_TABLE_200

1279: , p5_a0 JTF_NUMBER_TABLE
1280: , p5_a1 JTF_NUMBER_TABLE
1281: , p5_a2 JTF_NUMBER_TABLE
1282: , p5_a3 JTF_NUMBER_TABLE
1283: , p5_a4 JTF_VARCHAR2_TABLE_200
1284: , p5_a5 JTF_VARCHAR2_TABLE_2000
1285: , p5_a6 JTF_NUMBER_TABLE
1286: , p5_a7 JTF_VARCHAR2_TABLE_100
1287: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 1284: , p5_a5 JTF_VARCHAR2_TABLE_2000

1280: , p5_a1 JTF_NUMBER_TABLE
1281: , p5_a2 JTF_NUMBER_TABLE
1282: , p5_a3 JTF_NUMBER_TABLE
1283: , p5_a4 JTF_VARCHAR2_TABLE_200
1284: , p5_a5 JTF_VARCHAR2_TABLE_2000
1285: , p5_a6 JTF_NUMBER_TABLE
1286: , p5_a7 JTF_VARCHAR2_TABLE_100
1287: , p5_a8 JTF_VARCHAR2_TABLE_100
1288: , p5_a9 JTF_DATE_TABLE

Line 1316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

1312: , p6_a0 out nocopy JTF_NUMBER_TABLE
1313: , p6_a1 out nocopy JTF_NUMBER_TABLE
1314: , p6_a2 out nocopy JTF_NUMBER_TABLE
1315: , p6_a3 out nocopy JTF_NUMBER_TABLE
1316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1318: , p6_a6 out nocopy JTF_NUMBER_TABLE
1319: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1320: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

1313: , p6_a1 out nocopy JTF_NUMBER_TABLE
1314: , p6_a2 out nocopy JTF_NUMBER_TABLE
1315: , p6_a3 out nocopy JTF_NUMBER_TABLE
1316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1318: , p6_a6 out nocopy JTF_NUMBER_TABLE
1319: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1320: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1321: , p6_a9 out nocopy JTF_DATE_TABLE

Line 1557: , p5_a4 JTF_VARCHAR2_TABLE_200

1553: , p5_a0 JTF_NUMBER_TABLE
1554: , p5_a1 JTF_NUMBER_TABLE
1555: , p5_a2 JTF_NUMBER_TABLE
1556: , p5_a3 JTF_NUMBER_TABLE
1557: , p5_a4 JTF_VARCHAR2_TABLE_200
1558: , p5_a5 JTF_VARCHAR2_TABLE_2000
1559: , p5_a6 JTF_NUMBER_TABLE
1560: , p5_a7 JTF_VARCHAR2_TABLE_100
1561: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 1558: , p5_a5 JTF_VARCHAR2_TABLE_2000

1554: , p5_a1 JTF_NUMBER_TABLE
1555: , p5_a2 JTF_NUMBER_TABLE
1556: , p5_a3 JTF_NUMBER_TABLE
1557: , p5_a4 JTF_VARCHAR2_TABLE_200
1558: , p5_a5 JTF_VARCHAR2_TABLE_2000
1559: , p5_a6 JTF_NUMBER_TABLE
1560: , p5_a7 JTF_VARCHAR2_TABLE_100
1561: , p5_a8 JTF_VARCHAR2_TABLE_100
1562: , p5_a9 JTF_DATE_TABLE

Line 1760: , p5_a4 JTF_VARCHAR2_TABLE_200

1756: , p5_a0 JTF_NUMBER_TABLE
1757: , p5_a1 JTF_NUMBER_TABLE
1758: , p5_a2 JTF_NUMBER_TABLE
1759: , p5_a3 JTF_NUMBER_TABLE
1760: , p5_a4 JTF_VARCHAR2_TABLE_200
1761: , p5_a5 JTF_VARCHAR2_TABLE_2000
1762: , p5_a6 JTF_NUMBER_TABLE
1763: , p5_a7 JTF_VARCHAR2_TABLE_100
1764: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 1761: , p5_a5 JTF_VARCHAR2_TABLE_2000

1757: , p5_a1 JTF_NUMBER_TABLE
1758: , p5_a2 JTF_NUMBER_TABLE
1759: , p5_a3 JTF_NUMBER_TABLE
1760: , p5_a4 JTF_VARCHAR2_TABLE_200
1761: , p5_a5 JTF_VARCHAR2_TABLE_2000
1762: , p5_a6 JTF_NUMBER_TABLE
1763: , p5_a7 JTF_VARCHAR2_TABLE_100
1764: , p5_a8 JTF_VARCHAR2_TABLE_100
1765: , p5_a9 JTF_DATE_TABLE