DBA Data[Home] [Help]

APPS.OKL_ILT_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ilt_pvt.ilt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_500
28: , a6 JTF_VARCHAR2_TABLE_500
29: , a7 JTF_VARCHAR2_TABLE_500
30: , a8 JTF_VARCHAR2_TABLE_500

Line 93: , a4 out nocopy JTF_VARCHAR2_TABLE_100

89: procedure rosetta_table_copy_out_p2(t okl_ilt_pvt.ilt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: , a2 out nocopy JTF_NUMBER_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: , a4 out nocopy JTF_VARCHAR2_TABLE_100
94: , a5 out nocopy JTF_VARCHAR2_TABLE_500
95: , a6 out nocopy JTF_VARCHAR2_TABLE_500
96: , a7 out nocopy JTF_VARCHAR2_TABLE_500
97: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 122: a4 := JTF_VARCHAR2_TABLE_100();

118: a0 := JTF_NUMBER_TABLE();
119: a1 := JTF_NUMBER_TABLE();
120: a2 := JTF_NUMBER_TABLE();
121: a3 := JTF_NUMBER_TABLE();
122: a4 := JTF_VARCHAR2_TABLE_100();
123: a5 := JTF_VARCHAR2_TABLE_500();
124: a6 := JTF_VARCHAR2_TABLE_500();
125: a7 := JTF_VARCHAR2_TABLE_500();
126: a8 := JTF_VARCHAR2_TABLE_500();

Line 148: a4 := JTF_VARCHAR2_TABLE_100();

144: a0 := JTF_NUMBER_TABLE();
145: a1 := JTF_NUMBER_TABLE();
146: a2 := JTF_NUMBER_TABLE();
147: a3 := JTF_NUMBER_TABLE();
148: a4 := JTF_VARCHAR2_TABLE_100();
149: a5 := JTF_VARCHAR2_TABLE_500();
150: a6 := JTF_VARCHAR2_TABLE_500();
151: a7 := JTF_VARCHAR2_TABLE_500();
152: a8 := JTF_VARCHAR2_TABLE_500();

Line 234: , a1 JTF_VARCHAR2_TABLE_100

230: end if;
231: end rosetta_table_copy_out_p2;
232:
233: procedure rosetta_table_copy_in_p5(t out nocopy okl_ilt_pvt.oklinvclinetypestltbltype, a0 JTF_NUMBER_TABLE
234: , a1 JTF_VARCHAR2_TABLE_100
235: , a2 JTF_VARCHAR2_TABLE_100
236: , a3 JTF_VARCHAR2_TABLE_100
237: , a4 JTF_VARCHAR2_TABLE_200
238: , a5 JTF_VARCHAR2_TABLE_2000

Line 235: , a2 JTF_VARCHAR2_TABLE_100

231: end rosetta_table_copy_out_p2;
232:
233: procedure rosetta_table_copy_in_p5(t out nocopy okl_ilt_pvt.oklinvclinetypestltbltype, a0 JTF_NUMBER_TABLE
234: , a1 JTF_VARCHAR2_TABLE_100
235: , a2 JTF_VARCHAR2_TABLE_100
236: , a3 JTF_VARCHAR2_TABLE_100
237: , a4 JTF_VARCHAR2_TABLE_200
238: , a5 JTF_VARCHAR2_TABLE_2000
239: , a6 JTF_NUMBER_TABLE

Line 236: , a3 JTF_VARCHAR2_TABLE_100

232:
233: procedure rosetta_table_copy_in_p5(t out nocopy okl_ilt_pvt.oklinvclinetypestltbltype, a0 JTF_NUMBER_TABLE
234: , a1 JTF_VARCHAR2_TABLE_100
235: , a2 JTF_VARCHAR2_TABLE_100
236: , a3 JTF_VARCHAR2_TABLE_100
237: , a4 JTF_VARCHAR2_TABLE_200
238: , a5 JTF_VARCHAR2_TABLE_2000
239: , a6 JTF_NUMBER_TABLE
240: , a7 JTF_DATE_TABLE

Line 273: , a1 out nocopy JTF_VARCHAR2_TABLE_100

269: end if;
270: end if;
271: end rosetta_table_copy_in_p5;
272: procedure rosetta_table_copy_out_p5(t okl_ilt_pvt.oklinvclinetypestltbltype, a0 out nocopy JTF_NUMBER_TABLE
273: , a1 out nocopy JTF_VARCHAR2_TABLE_100
274: , a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , a3 out nocopy JTF_VARCHAR2_TABLE_100
276: , a4 out nocopy JTF_VARCHAR2_TABLE_200
277: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 274: , a2 out nocopy JTF_VARCHAR2_TABLE_100

270: end if;
271: end rosetta_table_copy_in_p5;
272: procedure rosetta_table_copy_out_p5(t okl_ilt_pvt.oklinvclinetypestltbltype, a0 out nocopy JTF_NUMBER_TABLE
273: , a1 out nocopy JTF_VARCHAR2_TABLE_100
274: , a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , a3 out nocopy JTF_VARCHAR2_TABLE_100
276: , a4 out nocopy JTF_VARCHAR2_TABLE_200
277: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
278: , a6 out nocopy JTF_NUMBER_TABLE

Line 275: , a3 out nocopy JTF_VARCHAR2_TABLE_100

271: end rosetta_table_copy_in_p5;
272: procedure rosetta_table_copy_out_p5(t okl_ilt_pvt.oklinvclinetypestltbltype, a0 out nocopy JTF_NUMBER_TABLE
273: , a1 out nocopy JTF_VARCHAR2_TABLE_100
274: , a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , a3 out nocopy JTF_VARCHAR2_TABLE_100
276: , a4 out nocopy JTF_VARCHAR2_TABLE_200
277: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
278: , a6 out nocopy JTF_NUMBER_TABLE
279: , a7 out nocopy JTF_DATE_TABLE

Line 288: a1 := JTF_VARCHAR2_TABLE_100();

284: ddindx binary_integer; indx binary_integer;
285: begin
286: if t is null or t.count = 0 then
287: a0 := JTF_NUMBER_TABLE();
288: a1 := JTF_VARCHAR2_TABLE_100();
289: a2 := JTF_VARCHAR2_TABLE_100();
290: a3 := JTF_VARCHAR2_TABLE_100();
291: a4 := JTF_VARCHAR2_TABLE_200();
292: a5 := JTF_VARCHAR2_TABLE_2000();

Line 289: a2 := JTF_VARCHAR2_TABLE_100();

285: begin
286: if t is null or t.count = 0 then
287: a0 := JTF_NUMBER_TABLE();
288: a1 := JTF_VARCHAR2_TABLE_100();
289: a2 := JTF_VARCHAR2_TABLE_100();
290: a3 := JTF_VARCHAR2_TABLE_100();
291: a4 := JTF_VARCHAR2_TABLE_200();
292: a5 := JTF_VARCHAR2_TABLE_2000();
293: a6 := JTF_NUMBER_TABLE();

Line 290: a3 := JTF_VARCHAR2_TABLE_100();

286: if t is null or t.count = 0 then
287: a0 := JTF_NUMBER_TABLE();
288: a1 := JTF_VARCHAR2_TABLE_100();
289: a2 := JTF_VARCHAR2_TABLE_100();
290: a3 := JTF_VARCHAR2_TABLE_100();
291: a4 := JTF_VARCHAR2_TABLE_200();
292: a5 := JTF_VARCHAR2_TABLE_2000();
293: a6 := JTF_NUMBER_TABLE();
294: a7 := JTF_DATE_TABLE();

Line 300: a1 := JTF_VARCHAR2_TABLE_100();

296: a9 := JTF_DATE_TABLE();
297: a10 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_VARCHAR2_TABLE_100();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_200();
304: a5 := JTF_VARCHAR2_TABLE_2000();

Line 301: a2 := JTF_VARCHAR2_TABLE_100();

297: a10 := JTF_NUMBER_TABLE();
298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_VARCHAR2_TABLE_100();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_200();
304: a5 := JTF_VARCHAR2_TABLE_2000();
305: a6 := JTF_NUMBER_TABLE();

Line 302: a3 := JTF_VARCHAR2_TABLE_100();

298: else
299: a0 := JTF_NUMBER_TABLE();
300: a1 := JTF_VARCHAR2_TABLE_100();
301: a2 := JTF_VARCHAR2_TABLE_100();
302: a3 := JTF_VARCHAR2_TABLE_100();
303: a4 := JTF_VARCHAR2_TABLE_200();
304: a5 := JTF_VARCHAR2_TABLE_2000();
305: a6 := JTF_NUMBER_TABLE();
306: a7 := JTF_DATE_TABLE();

Line 348: , a2 JTF_VARCHAR2_TABLE_100

344: end rosetta_table_copy_out_p5;
345:
346: procedure rosetta_table_copy_in_p8(t out nocopy okl_ilt_pvt.iltv_tbl_type, a0 JTF_NUMBER_TABLE
347: , a1 JTF_NUMBER_TABLE
348: , a2 JTF_VARCHAR2_TABLE_100
349: , a3 JTF_NUMBER_TABLE
350: , a4 JTF_NUMBER_TABLE
351: , a5 JTF_VARCHAR2_TABLE_200
352: , a6 JTF_VARCHAR2_TABLE_2000

Line 353: , a7 JTF_VARCHAR2_TABLE_100

349: , a3 JTF_NUMBER_TABLE
350: , a4 JTF_NUMBER_TABLE
351: , a5 JTF_VARCHAR2_TABLE_200
352: , a6 JTF_VARCHAR2_TABLE_2000
353: , a7 JTF_VARCHAR2_TABLE_100
354: , a8 JTF_VARCHAR2_TABLE_500
355: , a9 JTF_VARCHAR2_TABLE_500
356: , a10 JTF_VARCHAR2_TABLE_500
357: , a11 JTF_VARCHAR2_TABLE_500

Line 421: , a2 out nocopy JTF_VARCHAR2_TABLE_100

417: end if;
418: end rosetta_table_copy_in_p8;
419: procedure rosetta_table_copy_out_p8(t okl_ilt_pvt.iltv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , a3 out nocopy JTF_NUMBER_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
424: , a5 out nocopy JTF_VARCHAR2_TABLE_200
425: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 426: , a7 out nocopy JTF_VARCHAR2_TABLE_100

422: , a3 out nocopy JTF_NUMBER_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE
424: , a5 out nocopy JTF_VARCHAR2_TABLE_200
425: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
426: , a7 out nocopy JTF_VARCHAR2_TABLE_100
427: , a8 out nocopy JTF_VARCHAR2_TABLE_500
428: , a9 out nocopy JTF_VARCHAR2_TABLE_500
429: , a10 out nocopy JTF_VARCHAR2_TABLE_500
430: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 453: a2 := JTF_VARCHAR2_TABLE_100();

449: begin
450: if t is null or t.count = 0 then
451: a0 := JTF_NUMBER_TABLE();
452: a1 := JTF_NUMBER_TABLE();
453: a2 := JTF_VARCHAR2_TABLE_100();
454: a3 := JTF_NUMBER_TABLE();
455: a4 := JTF_NUMBER_TABLE();
456: a5 := JTF_VARCHAR2_TABLE_200();
457: a6 := JTF_VARCHAR2_TABLE_2000();

Line 458: a7 := JTF_VARCHAR2_TABLE_100();

454: a3 := JTF_NUMBER_TABLE();
455: a4 := JTF_NUMBER_TABLE();
456: a5 := JTF_VARCHAR2_TABLE_200();
457: a6 := JTF_VARCHAR2_TABLE_2000();
458: a7 := JTF_VARCHAR2_TABLE_100();
459: a8 := JTF_VARCHAR2_TABLE_500();
460: a9 := JTF_VARCHAR2_TABLE_500();
461: a10 := JTF_VARCHAR2_TABLE_500();
462: a11 := JTF_VARCHAR2_TABLE_500();

Line 482: a2 := JTF_VARCHAR2_TABLE_100();

478: a27 := JTF_NUMBER_TABLE();
479: else
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_NUMBER_TABLE();
482: a2 := JTF_VARCHAR2_TABLE_100();
483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_NUMBER_TABLE();
485: a5 := JTF_VARCHAR2_TABLE_200();
486: a6 := JTF_VARCHAR2_TABLE_2000();

Line 487: a7 := JTF_VARCHAR2_TABLE_100();

483: a3 := JTF_NUMBER_TABLE();
484: a4 := JTF_NUMBER_TABLE();
485: a5 := JTF_VARCHAR2_TABLE_200();
486: a6 := JTF_VARCHAR2_TABLE_2000();
487: a7 := JTF_VARCHAR2_TABLE_100();
488: a8 := JTF_VARCHAR2_TABLE_500();
489: a9 := JTF_VARCHAR2_TABLE_500();
490: a10 := JTF_VARCHAR2_TABLE_500();
491: a11 := JTF_VARCHAR2_TABLE_500();

Line 736: , p5_a2 JTF_VARCHAR2_TABLE_100

732: , x_msg_count out nocopy NUMBER
733: , x_msg_data out nocopy VARCHAR2
734: , p5_a0 JTF_NUMBER_TABLE
735: , p5_a1 JTF_NUMBER_TABLE
736: , p5_a2 JTF_VARCHAR2_TABLE_100
737: , p5_a3 JTF_NUMBER_TABLE
738: , p5_a4 JTF_NUMBER_TABLE
739: , p5_a5 JTF_VARCHAR2_TABLE_200
740: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 741: , p5_a7 JTF_VARCHAR2_TABLE_100

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

Line 764: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

760: , p5_a26 JTF_DATE_TABLE
761: , p5_a27 JTF_NUMBER_TABLE
762: , p6_a0 out nocopy JTF_NUMBER_TABLE
763: , p6_a1 out nocopy JTF_NUMBER_TABLE
764: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a3 out nocopy JTF_NUMBER_TABLE
766: , p6_a4 out nocopy JTF_NUMBER_TABLE
767: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
768: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 769: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 980: , p5_a2 JTF_VARCHAR2_TABLE_100

976: , x_msg_count out nocopy NUMBER
977: , x_msg_data out nocopy VARCHAR2
978: , p5_a0 JTF_NUMBER_TABLE
979: , p5_a1 JTF_NUMBER_TABLE
980: , p5_a2 JTF_VARCHAR2_TABLE_100
981: , p5_a3 JTF_NUMBER_TABLE
982: , p5_a4 JTF_NUMBER_TABLE
983: , p5_a5 JTF_VARCHAR2_TABLE_200
984: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 985: , p5_a7 JTF_VARCHAR2_TABLE_100

981: , p5_a3 JTF_NUMBER_TABLE
982: , p5_a4 JTF_NUMBER_TABLE
983: , p5_a5 JTF_VARCHAR2_TABLE_200
984: , p5_a6 JTF_VARCHAR2_TABLE_2000
985: , p5_a7 JTF_VARCHAR2_TABLE_100
986: , p5_a8 JTF_VARCHAR2_TABLE_500
987: , p5_a9 JTF_VARCHAR2_TABLE_500
988: , p5_a10 JTF_VARCHAR2_TABLE_500
989: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1223: , p5_a2 JTF_VARCHAR2_TABLE_100

1219: , x_msg_count out nocopy NUMBER
1220: , x_msg_data out nocopy VARCHAR2
1221: , p5_a0 JTF_NUMBER_TABLE
1222: , p5_a1 JTF_NUMBER_TABLE
1223: , p5_a2 JTF_VARCHAR2_TABLE_100
1224: , p5_a3 JTF_NUMBER_TABLE
1225: , p5_a4 JTF_NUMBER_TABLE
1226: , p5_a5 JTF_VARCHAR2_TABLE_200
1227: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 1228: , p5_a7 JTF_VARCHAR2_TABLE_100

1224: , p5_a3 JTF_NUMBER_TABLE
1225: , p5_a4 JTF_NUMBER_TABLE
1226: , p5_a5 JTF_VARCHAR2_TABLE_200
1227: , p5_a6 JTF_VARCHAR2_TABLE_2000
1228: , p5_a7 JTF_VARCHAR2_TABLE_100
1229: , p5_a8 JTF_VARCHAR2_TABLE_500
1230: , p5_a9 JTF_VARCHAR2_TABLE_500
1231: , p5_a10 JTF_VARCHAR2_TABLE_500
1232: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

1247: , p5_a26 JTF_DATE_TABLE
1248: , p5_a27 JTF_NUMBER_TABLE
1249: , p6_a0 out nocopy JTF_NUMBER_TABLE
1250: , p6_a1 out nocopy JTF_NUMBER_TABLE
1251: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a3 out nocopy JTF_NUMBER_TABLE
1253: , p6_a4 out nocopy JTF_NUMBER_TABLE
1254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1255: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1256: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

1252: , p6_a3 out nocopy JTF_NUMBER_TABLE
1253: , p6_a4 out nocopy JTF_NUMBER_TABLE
1254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
1255: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
1256: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1257: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1258: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
1259: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
1260: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 1467: , p5_a2 JTF_VARCHAR2_TABLE_100

1463: , x_msg_count out nocopy NUMBER
1464: , x_msg_data out nocopy VARCHAR2
1465: , p5_a0 JTF_NUMBER_TABLE
1466: , p5_a1 JTF_NUMBER_TABLE
1467: , p5_a2 JTF_VARCHAR2_TABLE_100
1468: , p5_a3 JTF_NUMBER_TABLE
1469: , p5_a4 JTF_NUMBER_TABLE
1470: , p5_a5 JTF_VARCHAR2_TABLE_200
1471: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 1472: , p5_a7 JTF_VARCHAR2_TABLE_100

1468: , p5_a3 JTF_NUMBER_TABLE
1469: , p5_a4 JTF_NUMBER_TABLE
1470: , p5_a5 JTF_VARCHAR2_TABLE_200
1471: , p5_a6 JTF_VARCHAR2_TABLE_2000
1472: , p5_a7 JTF_VARCHAR2_TABLE_100
1473: , p5_a8 JTF_VARCHAR2_TABLE_500
1474: , p5_a9 JTF_VARCHAR2_TABLE_500
1475: , p5_a10 JTF_VARCHAR2_TABLE_500
1476: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 1650: , p5_a2 JTF_VARCHAR2_TABLE_100

1646: , x_msg_count out nocopy NUMBER
1647: , x_msg_data out nocopy VARCHAR2
1648: , p5_a0 JTF_NUMBER_TABLE
1649: , p5_a1 JTF_NUMBER_TABLE
1650: , p5_a2 JTF_VARCHAR2_TABLE_100
1651: , p5_a3 JTF_NUMBER_TABLE
1652: , p5_a4 JTF_NUMBER_TABLE
1653: , p5_a5 JTF_VARCHAR2_TABLE_200
1654: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 1655: , p5_a7 JTF_VARCHAR2_TABLE_100

1651: , p5_a3 JTF_NUMBER_TABLE
1652: , p5_a4 JTF_NUMBER_TABLE
1653: , p5_a5 JTF_VARCHAR2_TABLE_200
1654: , p5_a6 JTF_VARCHAR2_TABLE_2000
1655: , p5_a7 JTF_VARCHAR2_TABLE_100
1656: , p5_a8 JTF_VARCHAR2_TABLE_500
1657: , p5_a9 JTF_VARCHAR2_TABLE_500
1658: , p5_a10 JTF_VARCHAR2_TABLE_500
1659: , p5_a11 JTF_VARCHAR2_TABLE_500