DBA Data[Home] [Help]

APPS.OKL_PVN_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_pvn_pvt.pvn_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_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE

Line 31: , a9 JTF_VARCHAR2_TABLE_2000

27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_2000
32: , a10 JTF_DATE_TABLE
33: , a11 JTF_DATE_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_500

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_pvn_pvt.pvn_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_NUMBER_TABLE
110: , a5 out nocopy JTF_NUMBER_TABLE

Line 114: , a9 out nocopy JTF_VARCHAR2_TABLE_2000

110: , a5 out nocopy JTF_NUMBER_TABLE
111: , a6 out nocopy JTF_NUMBER_TABLE
112: , a7 out nocopy JTF_NUMBER_TABLE
113: , a8 out nocopy JTF_VARCHAR2_TABLE_100
114: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
115: , a10 out nocopy JTF_DATE_TABLE
116: , a11 out nocopy JTF_DATE_TABLE
117: , a12 out nocopy JTF_VARCHAR2_TABLE_100
118: , a13 out nocopy JTF_VARCHAR2_TABLE_500

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_NUMBER_TABLE();
147: a5 := JTF_NUMBER_TABLE();

Line 151: a9 := JTF_VARCHAR2_TABLE_2000();

147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_NUMBER_TABLE();
150: a8 := JTF_VARCHAR2_TABLE_100();
151: a9 := JTF_VARCHAR2_TABLE_2000();
152: a10 := JTF_DATE_TABLE();
153: a11 := JTF_DATE_TABLE();
154: a12 := JTF_VARCHAR2_TABLE_100();
155: a13 := JTF_VARCHAR2_TABLE_500();

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_NUMBER_TABLE();
181: a5 := JTF_NUMBER_TABLE();

Line 185: a9 := JTF_VARCHAR2_TABLE_2000();

181: a5 := JTF_NUMBER_TABLE();
182: a6 := JTF_NUMBER_TABLE();
183: a7 := JTF_NUMBER_TABLE();
184: a8 := JTF_VARCHAR2_TABLE_100();
185: a9 := JTF_VARCHAR2_TABLE_2000();
186: a10 := JTF_DATE_TABLE();
187: a11 := JTF_DATE_TABLE();
188: a12 := JTF_VARCHAR2_TABLE_100();
189: a13 := JTF_VARCHAR2_TABLE_500();

Line 296: , a7 JTF_VARCHAR2_TABLE_200

292: , a3 JTF_NUMBER_TABLE
293: , a4 JTF_NUMBER_TABLE
294: , a5 JTF_NUMBER_TABLE
295: , a6 JTF_NUMBER_TABLE
296: , a7 JTF_VARCHAR2_TABLE_200
297: , a8 JTF_VARCHAR2_TABLE_2000
298: , a9 JTF_VARCHAR2_TABLE_100
299: , a10 JTF_VARCHAR2_TABLE_500
300: , a11 JTF_VARCHAR2_TABLE_500

Line 297: , a8 JTF_VARCHAR2_TABLE_2000

293: , a4 JTF_NUMBER_TABLE
294: , a5 JTF_NUMBER_TABLE
295: , a6 JTF_NUMBER_TABLE
296: , a7 JTF_VARCHAR2_TABLE_200
297: , a8 JTF_VARCHAR2_TABLE_2000
298: , a9 JTF_VARCHAR2_TABLE_100
299: , a10 JTF_VARCHAR2_TABLE_500
300: , a11 JTF_VARCHAR2_TABLE_500
301: , a12 JTF_VARCHAR2_TABLE_500

Line 379: , a7 out nocopy JTF_VARCHAR2_TABLE_200

375: , a3 out nocopy JTF_NUMBER_TABLE
376: , a4 out nocopy JTF_NUMBER_TABLE
377: , a5 out nocopy JTF_NUMBER_TABLE
378: , a6 out nocopy JTF_NUMBER_TABLE
379: , a7 out nocopy JTF_VARCHAR2_TABLE_200
380: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
381: , a9 out nocopy JTF_VARCHAR2_TABLE_100
382: , a10 out nocopy JTF_VARCHAR2_TABLE_500
383: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 380: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

376: , a4 out nocopy JTF_NUMBER_TABLE
377: , a5 out nocopy JTF_NUMBER_TABLE
378: , a6 out nocopy JTF_NUMBER_TABLE
379: , a7 out nocopy JTF_VARCHAR2_TABLE_200
380: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
381: , a9 out nocopy JTF_VARCHAR2_TABLE_100
382: , a10 out nocopy JTF_VARCHAR2_TABLE_500
383: , a11 out nocopy JTF_VARCHAR2_TABLE_500
384: , a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 416: a7 := JTF_VARCHAR2_TABLE_200();

412: a3 := JTF_NUMBER_TABLE();
413: a4 := JTF_NUMBER_TABLE();
414: a5 := JTF_NUMBER_TABLE();
415: a6 := JTF_NUMBER_TABLE();
416: a7 := JTF_VARCHAR2_TABLE_200();
417: a8 := JTF_VARCHAR2_TABLE_2000();
418: a9 := JTF_VARCHAR2_TABLE_100();
419: a10 := JTF_VARCHAR2_TABLE_500();
420: a11 := JTF_VARCHAR2_TABLE_500();

Line 417: a8 := JTF_VARCHAR2_TABLE_2000();

413: a4 := JTF_NUMBER_TABLE();
414: a5 := JTF_NUMBER_TABLE();
415: a6 := JTF_NUMBER_TABLE();
416: a7 := JTF_VARCHAR2_TABLE_200();
417: a8 := JTF_VARCHAR2_TABLE_2000();
418: a9 := JTF_VARCHAR2_TABLE_100();
419: a10 := JTF_VARCHAR2_TABLE_500();
420: a11 := JTF_VARCHAR2_TABLE_500();
421: a12 := JTF_VARCHAR2_TABLE_500();

Line 450: a7 := JTF_VARCHAR2_TABLE_200();

446: a3 := JTF_NUMBER_TABLE();
447: a4 := JTF_NUMBER_TABLE();
448: a5 := JTF_NUMBER_TABLE();
449: a6 := JTF_NUMBER_TABLE();
450: a7 := JTF_VARCHAR2_TABLE_200();
451: a8 := JTF_VARCHAR2_TABLE_2000();
452: a9 := JTF_VARCHAR2_TABLE_100();
453: a10 := JTF_VARCHAR2_TABLE_500();
454: a11 := JTF_VARCHAR2_TABLE_500();

Line 451: a8 := JTF_VARCHAR2_TABLE_2000();

447: a4 := JTF_NUMBER_TABLE();
448: a5 := JTF_NUMBER_TABLE();
449: a6 := JTF_NUMBER_TABLE();
450: a7 := JTF_VARCHAR2_TABLE_200();
451: a8 := JTF_VARCHAR2_TABLE_2000();
452: a9 := JTF_VARCHAR2_TABLE_100();
453: a10 := JTF_VARCHAR2_TABLE_500();
454: a11 := JTF_VARCHAR2_TABLE_500();
455: a12 := JTF_VARCHAR2_TABLE_500();

Line 739: , p5_a7 JTF_VARCHAR2_TABLE_200

735: , p5_a3 JTF_NUMBER_TABLE
736: , p5_a4 JTF_NUMBER_TABLE
737: , p5_a5 JTF_NUMBER_TABLE
738: , p5_a6 JTF_NUMBER_TABLE
739: , p5_a7 JTF_VARCHAR2_TABLE_200
740: , p5_a8 JTF_VARCHAR2_TABLE_2000
741: , p5_a9 JTF_VARCHAR2_TABLE_100
742: , p5_a10 JTF_VARCHAR2_TABLE_500
743: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 740: , p5_a8 JTF_VARCHAR2_TABLE_2000

736: , p5_a4 JTF_NUMBER_TABLE
737: , p5_a5 JTF_NUMBER_TABLE
738: , p5_a6 JTF_NUMBER_TABLE
739: , p5_a7 JTF_VARCHAR2_TABLE_200
740: , p5_a8 JTF_VARCHAR2_TABLE_2000
741: , p5_a9 JTF_VARCHAR2_TABLE_100
742: , p5_a10 JTF_VARCHAR2_TABLE_500
743: , p5_a11 JTF_VARCHAR2_TABLE_500
744: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 772: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200

768: , p6_a3 out nocopy JTF_NUMBER_TABLE
769: , p6_a4 out nocopy JTF_NUMBER_TABLE
770: , p6_a5 out nocopy JTF_NUMBER_TABLE
771: , p6_a6 out nocopy JTF_NUMBER_TABLE
772: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
773: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
774: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
775: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
776: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 773: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000

769: , p6_a4 out nocopy JTF_NUMBER_TABLE
770: , p6_a5 out nocopy JTF_NUMBER_TABLE
771: , p6_a6 out nocopy JTF_NUMBER_TABLE
772: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
773: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
774: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
775: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
776: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
777: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 1013: , p5_a7 JTF_VARCHAR2_TABLE_200

1009: , p5_a3 JTF_NUMBER_TABLE
1010: , p5_a4 JTF_NUMBER_TABLE
1011: , p5_a5 JTF_NUMBER_TABLE
1012: , p5_a6 JTF_NUMBER_TABLE
1013: , p5_a7 JTF_VARCHAR2_TABLE_200
1014: , p5_a8 JTF_VARCHAR2_TABLE_2000
1015: , p5_a9 JTF_VARCHAR2_TABLE_100
1016: , p5_a10 JTF_VARCHAR2_TABLE_500
1017: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1014: , p5_a8 JTF_VARCHAR2_TABLE_2000

1010: , p5_a4 JTF_NUMBER_TABLE
1011: , p5_a5 JTF_NUMBER_TABLE
1012: , p5_a6 JTF_NUMBER_TABLE
1013: , p5_a7 JTF_VARCHAR2_TABLE_200
1014: , p5_a8 JTF_VARCHAR2_TABLE_2000
1015: , p5_a9 JTF_VARCHAR2_TABLE_100
1016: , p5_a10 JTF_VARCHAR2_TABLE_500
1017: , p5_a11 JTF_VARCHAR2_TABLE_500
1018: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 1286: , p5_a7 JTF_VARCHAR2_TABLE_200

1282: , p5_a3 JTF_NUMBER_TABLE
1283: , p5_a4 JTF_NUMBER_TABLE
1284: , p5_a5 JTF_NUMBER_TABLE
1285: , p5_a6 JTF_NUMBER_TABLE
1286: , p5_a7 JTF_VARCHAR2_TABLE_200
1287: , p5_a8 JTF_VARCHAR2_TABLE_2000
1288: , p5_a9 JTF_VARCHAR2_TABLE_100
1289: , p5_a10 JTF_VARCHAR2_TABLE_500
1290: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1287: , p5_a8 JTF_VARCHAR2_TABLE_2000

1283: , p5_a4 JTF_NUMBER_TABLE
1284: , p5_a5 JTF_NUMBER_TABLE
1285: , p5_a6 JTF_NUMBER_TABLE
1286: , p5_a7 JTF_VARCHAR2_TABLE_200
1287: , p5_a8 JTF_VARCHAR2_TABLE_2000
1288: , p5_a9 JTF_VARCHAR2_TABLE_100
1289: , p5_a10 JTF_VARCHAR2_TABLE_500
1290: , p5_a11 JTF_VARCHAR2_TABLE_500
1291: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 1319: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200

1315: , p6_a3 out nocopy JTF_NUMBER_TABLE
1316: , p6_a4 out nocopy JTF_NUMBER_TABLE
1317: , p6_a5 out nocopy JTF_NUMBER_TABLE
1318: , p6_a6 out nocopy JTF_NUMBER_TABLE
1319: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1320: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
1321: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1322: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
1323: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 1320: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000

1316: , p6_a4 out nocopy JTF_NUMBER_TABLE
1317: , p6_a5 out nocopy JTF_NUMBER_TABLE
1318: , p6_a6 out nocopy JTF_NUMBER_TABLE
1319: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
1320: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
1321: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1322: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
1323: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1324: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 1560: , p5_a7 JTF_VARCHAR2_TABLE_200

1556: , p5_a3 JTF_NUMBER_TABLE
1557: , p5_a4 JTF_NUMBER_TABLE
1558: , p5_a5 JTF_NUMBER_TABLE
1559: , p5_a6 JTF_NUMBER_TABLE
1560: , p5_a7 JTF_VARCHAR2_TABLE_200
1561: , p5_a8 JTF_VARCHAR2_TABLE_2000
1562: , p5_a9 JTF_VARCHAR2_TABLE_100
1563: , p5_a10 JTF_VARCHAR2_TABLE_500
1564: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1561: , p5_a8 JTF_VARCHAR2_TABLE_2000

1557: , p5_a4 JTF_NUMBER_TABLE
1558: , p5_a5 JTF_NUMBER_TABLE
1559: , p5_a6 JTF_NUMBER_TABLE
1560: , p5_a7 JTF_VARCHAR2_TABLE_200
1561: , p5_a8 JTF_VARCHAR2_TABLE_2000
1562: , p5_a9 JTF_VARCHAR2_TABLE_100
1563: , p5_a10 JTF_VARCHAR2_TABLE_500
1564: , p5_a11 JTF_VARCHAR2_TABLE_500
1565: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 1763: , p5_a7 JTF_VARCHAR2_TABLE_200

1759: , p5_a3 JTF_NUMBER_TABLE
1760: , p5_a4 JTF_NUMBER_TABLE
1761: , p5_a5 JTF_NUMBER_TABLE
1762: , p5_a6 JTF_NUMBER_TABLE
1763: , p5_a7 JTF_VARCHAR2_TABLE_200
1764: , p5_a8 JTF_VARCHAR2_TABLE_2000
1765: , p5_a9 JTF_VARCHAR2_TABLE_100
1766: , p5_a10 JTF_VARCHAR2_TABLE_500
1767: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1764: , p5_a8 JTF_VARCHAR2_TABLE_2000

1760: , p5_a4 JTF_NUMBER_TABLE
1761: , p5_a5 JTF_NUMBER_TABLE
1762: , p5_a6 JTF_NUMBER_TABLE
1763: , p5_a7 JTF_VARCHAR2_TABLE_200
1764: , p5_a8 JTF_VARCHAR2_TABLE_2000
1765: , p5_a9 JTF_VARCHAR2_TABLE_100
1766: , p5_a10 JTF_VARCHAR2_TABLE_500
1767: , p5_a11 JTF_VARCHAR2_TABLE_500
1768: , p5_a12 JTF_VARCHAR2_TABLE_500