DBA Data[Home] [Help]

APPS.OKL_RTP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rtp_pvt.rtp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE

Line 44: , a4 out nocopy JTF_VARCHAR2_TABLE_100

40: procedure rosetta_table_copy_out_p2(t okl_rtp_pvt.rtp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_VARCHAR2_TABLE_100
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_DATE_TABLE
47: , a7 out nocopy JTF_NUMBER_TABLE
48: , a8 out nocopy JTF_DATE_TABLE

Line 58: a4 := JTF_VARCHAR2_TABLE_100();

54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_NUMBER_TABLE();
56: a2 := JTF_NUMBER_TABLE();
57: a3 := JTF_NUMBER_TABLE();
58: a4 := JTF_VARCHAR2_TABLE_100();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_DATE_TABLE();
61: a7 := JTF_NUMBER_TABLE();
62: a8 := JTF_DATE_TABLE();

Line 69: a4 := JTF_VARCHAR2_TABLE_100();

65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_NUMBER_TABLE();
67: a2 := JTF_NUMBER_TABLE();
68: a3 := JTF_NUMBER_TABLE();
69: a4 := JTF_VARCHAR2_TABLE_100();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_DATE_TABLE();
72: a7 := JTF_NUMBER_TABLE();
73: a8 := JTF_DATE_TABLE();

Line 197: , p5_a4 JTF_VARCHAR2_TABLE_100

193: , p5_a0 JTF_NUMBER_TABLE
194: , p5_a1 JTF_NUMBER_TABLE
195: , p5_a2 JTF_NUMBER_TABLE
196: , p5_a3 JTF_NUMBER_TABLE
197: , p5_a4 JTF_VARCHAR2_TABLE_100
198: , p5_a5 JTF_NUMBER_TABLE
199: , p5_a6 JTF_DATE_TABLE
200: , p5_a7 JTF_NUMBER_TABLE
201: , p5_a8 JTF_DATE_TABLE

Line 207: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

203: , p6_a0 out nocopy JTF_NUMBER_TABLE
204: , p6_a1 out nocopy JTF_NUMBER_TABLE
205: , p6_a2 out nocopy JTF_NUMBER_TABLE
206: , p6_a3 out nocopy JTF_NUMBER_TABLE
207: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
208: , p6_a5 out nocopy JTF_NUMBER_TABLE
209: , p6_a6 out nocopy JTF_DATE_TABLE
210: , p6_a7 out nocopy JTF_NUMBER_TABLE
211: , p6_a8 out nocopy JTF_DATE_TABLE

Line 214: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

210: , p6_a7 out nocopy JTF_NUMBER_TABLE
211: , p6_a8 out nocopy JTF_DATE_TABLE
212: , p6_a9 out nocopy JTF_NUMBER_TABLE
213: , p7_a0 in out nocopy JTF_NUMBER_TABLE
214: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
215: , p7_a2 in out nocopy JTF_NUMBER_TABLE
216: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
217: , p7_a4 in out nocopy JTF_NUMBER_TABLE
218: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 218: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

214: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
215: , p7_a2 in out nocopy JTF_NUMBER_TABLE
216: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
217: , p7_a4 in out nocopy JTF_NUMBER_TABLE
218: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
220: )
221:
222: as

Line 219: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

215: , p7_a2 in out nocopy JTF_NUMBER_TABLE
216: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
217: , p7_a4 in out nocopy JTF_NUMBER_TABLE
218: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
220: )
221:
222: as
223: ddp_rtp_tbl okl_rtp_pvt.rtp_tbl_type;

Line 305: , p5_a4 JTF_VARCHAR2_TABLE_100

301: , p5_a0 JTF_NUMBER_TABLE
302: , p5_a1 JTF_NUMBER_TABLE
303: , p5_a2 JTF_NUMBER_TABLE
304: , p5_a3 JTF_NUMBER_TABLE
305: , p5_a4 JTF_VARCHAR2_TABLE_100
306: , p5_a5 JTF_NUMBER_TABLE
307: , p5_a6 JTF_DATE_TABLE
308: , p5_a7 JTF_NUMBER_TABLE
309: , p5_a8 JTF_DATE_TABLE

Line 315: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

311: , p6_a0 out nocopy JTF_NUMBER_TABLE
312: , p6_a1 out nocopy JTF_NUMBER_TABLE
313: , p6_a2 out nocopy JTF_NUMBER_TABLE
314: , p6_a3 out nocopy JTF_NUMBER_TABLE
315: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a5 out nocopy JTF_NUMBER_TABLE
317: , p6_a6 out nocopy JTF_DATE_TABLE
318: , p6_a7 out nocopy JTF_NUMBER_TABLE
319: , p6_a8 out nocopy JTF_DATE_TABLE

Line 441: , p5_a4 JTF_VARCHAR2_TABLE_100

437: , p5_a0 JTF_NUMBER_TABLE
438: , p5_a1 JTF_NUMBER_TABLE
439: , p5_a2 JTF_NUMBER_TABLE
440: , p5_a3 JTF_NUMBER_TABLE
441: , p5_a4 JTF_VARCHAR2_TABLE_100
442: , p5_a5 JTF_NUMBER_TABLE
443: , p5_a6 JTF_DATE_TABLE
444: , p5_a7 JTF_NUMBER_TABLE
445: , p5_a8 JTF_DATE_TABLE

Line 448: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

444: , p5_a7 JTF_NUMBER_TABLE
445: , p5_a8 JTF_DATE_TABLE
446: , p5_a9 JTF_NUMBER_TABLE
447: , p6_a0 in out nocopy JTF_NUMBER_TABLE
448: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
449: , p6_a2 in out nocopy JTF_NUMBER_TABLE
450: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
451: , p6_a4 in out nocopy JTF_NUMBER_TABLE
452: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 452: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

448: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
449: , p6_a2 in out nocopy JTF_NUMBER_TABLE
450: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
451: , p6_a4 in out nocopy JTF_NUMBER_TABLE
452: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
453: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
454: )
455:
456: as

Line 453: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

449: , p6_a2 in out nocopy JTF_NUMBER_TABLE
450: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
451: , p6_a4 in out nocopy JTF_NUMBER_TABLE
452: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
453: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
454: )
455:
456: as
457: ddp_rtp_tbl okl_rtp_pvt.rtp_tbl_type;

Line 524: , p5_a4 JTF_VARCHAR2_TABLE_100

520: , p5_a0 JTF_NUMBER_TABLE
521: , p5_a1 JTF_NUMBER_TABLE
522: , p5_a2 JTF_NUMBER_TABLE
523: , p5_a3 JTF_NUMBER_TABLE
524: , p5_a4 JTF_VARCHAR2_TABLE_100
525: , p5_a5 JTF_NUMBER_TABLE
526: , p5_a6 JTF_DATE_TABLE
527: , p5_a7 JTF_NUMBER_TABLE
528: , p5_a8 JTF_DATE_TABLE

Line 659: , p5_a4 JTF_VARCHAR2_TABLE_100

655: , p5_a0 JTF_NUMBER_TABLE
656: , p5_a1 JTF_NUMBER_TABLE
657: , p5_a2 JTF_NUMBER_TABLE
658: , p5_a3 JTF_NUMBER_TABLE
659: , p5_a4 JTF_VARCHAR2_TABLE_100
660: , p5_a5 JTF_NUMBER_TABLE
661: , p5_a6 JTF_DATE_TABLE
662: , p5_a7 JTF_NUMBER_TABLE
663: , p5_a8 JTF_DATE_TABLE

Line 669: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

665: , p6_a0 out nocopy JTF_NUMBER_TABLE
666: , p6_a1 out nocopy JTF_NUMBER_TABLE
667: , p6_a2 out nocopy JTF_NUMBER_TABLE
668: , p6_a3 out nocopy JTF_NUMBER_TABLE
669: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
670: , p6_a5 out nocopy JTF_NUMBER_TABLE
671: , p6_a6 out nocopy JTF_DATE_TABLE
672: , p6_a7 out nocopy JTF_NUMBER_TABLE
673: , p6_a8 out nocopy JTF_DATE_TABLE

Line 676: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

672: , p6_a7 out nocopy JTF_NUMBER_TABLE
673: , p6_a8 out nocopy JTF_DATE_TABLE
674: , p6_a9 out nocopy JTF_NUMBER_TABLE
675: , p7_a0 in out nocopy JTF_NUMBER_TABLE
676: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
677: , p7_a2 in out nocopy JTF_NUMBER_TABLE
678: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
679: , p7_a4 in out nocopy JTF_NUMBER_TABLE
680: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 680: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

676: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
677: , p7_a2 in out nocopy JTF_NUMBER_TABLE
678: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
679: , p7_a4 in out nocopy JTF_NUMBER_TABLE
680: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
681: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
682: )
683:
684: as

Line 681: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

677: , p7_a2 in out nocopy JTF_NUMBER_TABLE
678: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
679: , p7_a4 in out nocopy JTF_NUMBER_TABLE
680: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
681: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
682: )
683:
684: as
685: ddp_rtp_tbl okl_rtp_pvt.rtp_tbl_type;

Line 767: , p5_a4 JTF_VARCHAR2_TABLE_100

763: , p5_a0 JTF_NUMBER_TABLE
764: , p5_a1 JTF_NUMBER_TABLE
765: , p5_a2 JTF_NUMBER_TABLE
766: , p5_a3 JTF_NUMBER_TABLE
767: , p5_a4 JTF_VARCHAR2_TABLE_100
768: , p5_a5 JTF_NUMBER_TABLE
769: , p5_a6 JTF_DATE_TABLE
770: , p5_a7 JTF_NUMBER_TABLE
771: , p5_a8 JTF_DATE_TABLE

Line 777: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

773: , p6_a0 out nocopy JTF_NUMBER_TABLE
774: , p6_a1 out nocopy JTF_NUMBER_TABLE
775: , p6_a2 out nocopy JTF_NUMBER_TABLE
776: , p6_a3 out nocopy JTF_NUMBER_TABLE
777: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
778: , p6_a5 out nocopy JTF_NUMBER_TABLE
779: , p6_a6 out nocopy JTF_DATE_TABLE
780: , p6_a7 out nocopy JTF_NUMBER_TABLE
781: , p6_a8 out nocopy JTF_DATE_TABLE

Line 903: , p5_a4 JTF_VARCHAR2_TABLE_100

899: , p5_a0 JTF_NUMBER_TABLE
900: , p5_a1 JTF_NUMBER_TABLE
901: , p5_a2 JTF_NUMBER_TABLE
902: , p5_a3 JTF_NUMBER_TABLE
903: , p5_a4 JTF_VARCHAR2_TABLE_100
904: , p5_a5 JTF_NUMBER_TABLE
905: , p5_a6 JTF_DATE_TABLE
906: , p5_a7 JTF_NUMBER_TABLE
907: , p5_a8 JTF_DATE_TABLE

Line 910: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

906: , p5_a7 JTF_NUMBER_TABLE
907: , p5_a8 JTF_DATE_TABLE
908: , p5_a9 JTF_NUMBER_TABLE
909: , p6_a0 in out nocopy JTF_NUMBER_TABLE
910: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
911: , p6_a2 in out nocopy JTF_NUMBER_TABLE
912: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
913: , p6_a4 in out nocopy JTF_NUMBER_TABLE
914: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 914: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

910: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
911: , p6_a2 in out nocopy JTF_NUMBER_TABLE
912: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
913: , p6_a4 in out nocopy JTF_NUMBER_TABLE
914: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
916: )
917:
918: as

Line 915: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

911: , p6_a2 in out nocopy JTF_NUMBER_TABLE
912: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
913: , p6_a4 in out nocopy JTF_NUMBER_TABLE
914: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
916: )
917:
918: as
919: ddp_rtp_tbl okl_rtp_pvt.rtp_tbl_type;

Line 986: , p5_a4 JTF_VARCHAR2_TABLE_100

982: , p5_a0 JTF_NUMBER_TABLE
983: , p5_a1 JTF_NUMBER_TABLE
984: , p5_a2 JTF_NUMBER_TABLE
985: , p5_a3 JTF_NUMBER_TABLE
986: , p5_a4 JTF_VARCHAR2_TABLE_100
987: , p5_a5 JTF_NUMBER_TABLE
988: , p5_a6 JTF_DATE_TABLE
989: , p5_a7 JTF_NUMBER_TABLE
990: , p5_a8 JTF_DATE_TABLE

Line 1097: , p5_a4 JTF_VARCHAR2_TABLE_100

1093: , p5_a0 JTF_NUMBER_TABLE
1094: , p5_a1 JTF_NUMBER_TABLE
1095: , p5_a2 JTF_NUMBER_TABLE
1096: , p5_a3 JTF_NUMBER_TABLE
1097: , p5_a4 JTF_VARCHAR2_TABLE_100
1098: , p5_a5 JTF_NUMBER_TABLE
1099: , p5_a6 JTF_DATE_TABLE
1100: , p5_a7 JTF_NUMBER_TABLE
1101: , p5_a8 JTF_DATE_TABLE

Line 1104: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

1100: , p5_a7 JTF_NUMBER_TABLE
1101: , p5_a8 JTF_DATE_TABLE
1102: , p5_a9 JTF_NUMBER_TABLE
1103: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1104: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1105: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1106: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1107: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1108: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1108: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

1104: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1105: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1106: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1107: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1108: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1109: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1110: )
1111:
1112: as

Line 1109: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

1105: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1106: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1107: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1108: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1109: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1110: )
1111:
1112: as
1113: ddp_rtp_tbl okl_rtp_pvt.rtp_tbl_type;

Line 1180: , p5_a4 JTF_VARCHAR2_TABLE_100

1176: , p5_a0 JTF_NUMBER_TABLE
1177: , p5_a1 JTF_NUMBER_TABLE
1178: , p5_a2 JTF_NUMBER_TABLE
1179: , p5_a3 JTF_NUMBER_TABLE
1180: , p5_a4 JTF_VARCHAR2_TABLE_100
1181: , p5_a5 JTF_NUMBER_TABLE
1182: , p5_a6 JTF_DATE_TABLE
1183: , p5_a7 JTF_NUMBER_TABLE
1184: , p5_a8 JTF_DATE_TABLE