APPS.OKL_RSP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLIRSPB.pls 120.0 2007/12/10 18:31:11 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rsp_pvt.rps_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE

Line 41: , a3 out nocopy JTF_VARCHAR2_TABLE_100

37: end rosetta_table_copy_in_p2;
38: procedure rosetta_table_copy_out_p2(t okl_rsp_pvt.rps_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_100
42: , a4 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_DATE_TABLE
44: , a6 out nocopy JTF_NUMBER_TABLE
45: , a7 out nocopy JTF_DATE_TABLE

Line 54: a3 := JTF_VARCHAR2_TABLE_100();

50: if t is null or t.count = 0 then
51: a0 := JTF_NUMBER_TABLE();
52: a1 := JTF_NUMBER_TABLE();
53: a2 := JTF_NUMBER_TABLE();
54: a3 := JTF_VARCHAR2_TABLE_100();
55: a4 := JTF_NUMBER_TABLE();
56: a5 := JTF_DATE_TABLE();
57: a6 := JTF_NUMBER_TABLE();
58: a7 := JTF_DATE_TABLE();

Line 64: a3 := JTF_VARCHAR2_TABLE_100();

60: else
61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_NUMBER_TABLE();
63: a2 := JTF_NUMBER_TABLE();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_NUMBER_TABLE();
66: a5 := JTF_DATE_TABLE();
67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_DATE_TABLE();

Line 185: , p5_a3 JTF_VARCHAR2_TABLE_100

181: , x_msg_data out nocopy VARCHAR2
182: , p5_a0 JTF_NUMBER_TABLE
183: , p5_a1 JTF_NUMBER_TABLE
184: , p5_a2 JTF_NUMBER_TABLE
185: , p5_a3 JTF_VARCHAR2_TABLE_100
186: , p5_a4 JTF_NUMBER_TABLE
187: , p5_a5 JTF_DATE_TABLE
188: , p5_a6 JTF_NUMBER_TABLE
189: , p5_a7 JTF_DATE_TABLE

Line 194: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

190: , p5_a8 JTF_NUMBER_TABLE
191: , p6_a0 out nocopy JTF_NUMBER_TABLE
192: , p6_a1 out nocopy JTF_NUMBER_TABLE
193: , p6_a2 out nocopy JTF_NUMBER_TABLE
194: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a4 out nocopy JTF_NUMBER_TABLE
196: , p6_a5 out nocopy JTF_DATE_TABLE
197: , p6_a6 out nocopy JTF_NUMBER_TABLE
198: , p6_a7 out nocopy JTF_DATE_TABLE

Line 201: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

197: , p6_a6 out nocopy JTF_NUMBER_TABLE
198: , p6_a7 out nocopy JTF_DATE_TABLE
199: , p6_a8 out nocopy JTF_NUMBER_TABLE
200: , p7_a0 in out nocopy JTF_NUMBER_TABLE
201: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
202: , p7_a2 in out nocopy JTF_NUMBER_TABLE
203: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
204: , p7_a4 in out nocopy JTF_NUMBER_TABLE
205: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 205: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

201: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
202: , p7_a2 in out nocopy JTF_NUMBER_TABLE
203: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
204: , p7_a4 in out nocopy JTF_NUMBER_TABLE
205: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
206: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
207: )
208:
209: as

Line 206: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

202: , p7_a2 in out nocopy JTF_NUMBER_TABLE
203: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
204: , p7_a4 in out nocopy JTF_NUMBER_TABLE
205: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
206: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
207: )
208:
209: as
210: ddp_rps_tbl okl_rsp_pvt.rps_tbl_type;

Line 289: , p5_a3 JTF_VARCHAR2_TABLE_100

285: , x_msg_data out nocopy VARCHAR2
286: , p5_a0 JTF_NUMBER_TABLE
287: , p5_a1 JTF_NUMBER_TABLE
288: , p5_a2 JTF_NUMBER_TABLE
289: , p5_a3 JTF_VARCHAR2_TABLE_100
290: , p5_a4 JTF_NUMBER_TABLE
291: , p5_a5 JTF_DATE_TABLE
292: , p5_a6 JTF_NUMBER_TABLE
293: , p5_a7 JTF_DATE_TABLE

Line 298: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

294: , p5_a8 JTF_NUMBER_TABLE
295: , p6_a0 out nocopy JTF_NUMBER_TABLE
296: , p6_a1 out nocopy JTF_NUMBER_TABLE
297: , p6_a2 out nocopy JTF_NUMBER_TABLE
298: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
299: , p6_a4 out nocopy JTF_NUMBER_TABLE
300: , p6_a5 out nocopy JTF_DATE_TABLE
301: , p6_a6 out nocopy JTF_NUMBER_TABLE
302: , p6_a7 out nocopy JTF_DATE_TABLE

Line 419: , p5_a3 JTF_VARCHAR2_TABLE_100

415: , x_msg_data out nocopy VARCHAR2
416: , p5_a0 JTF_NUMBER_TABLE
417: , p5_a1 JTF_NUMBER_TABLE
418: , p5_a2 JTF_NUMBER_TABLE
419: , p5_a3 JTF_VARCHAR2_TABLE_100
420: , p5_a4 JTF_NUMBER_TABLE
421: , p5_a5 JTF_DATE_TABLE
422: , p5_a6 JTF_NUMBER_TABLE
423: , p5_a7 JTF_DATE_TABLE

Line 426: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

422: , p5_a6 JTF_NUMBER_TABLE
423: , p5_a7 JTF_DATE_TABLE
424: , p5_a8 JTF_NUMBER_TABLE
425: , p6_a0 in out nocopy JTF_NUMBER_TABLE
426: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
427: , p6_a2 in out nocopy JTF_NUMBER_TABLE
428: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
429: , p6_a4 in out nocopy JTF_NUMBER_TABLE
430: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 430: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

426: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
427: , p6_a2 in out nocopy JTF_NUMBER_TABLE
428: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
429: , p6_a4 in out nocopy JTF_NUMBER_TABLE
430: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
432: )
433:
434: as

Line 431: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

427: , p6_a2 in out nocopy JTF_NUMBER_TABLE
428: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
429: , p6_a4 in out nocopy JTF_NUMBER_TABLE
430: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
432: )
433:
434: as
435: ddp_rps_tbl okl_rsp_pvt.rps_tbl_type;

Line 500: , p5_a3 JTF_VARCHAR2_TABLE_100

496: , x_msg_data out nocopy VARCHAR2
497: , p5_a0 JTF_NUMBER_TABLE
498: , p5_a1 JTF_NUMBER_TABLE
499: , p5_a2 JTF_NUMBER_TABLE
500: , p5_a3 JTF_VARCHAR2_TABLE_100
501: , p5_a4 JTF_NUMBER_TABLE
502: , p5_a5 JTF_DATE_TABLE
503: , p5_a6 JTF_NUMBER_TABLE
504: , p5_a7 JTF_DATE_TABLE

Line 629: , p5_a3 JTF_VARCHAR2_TABLE_100

625: , x_msg_data out nocopy VARCHAR2
626: , p5_a0 JTF_NUMBER_TABLE
627: , p5_a1 JTF_NUMBER_TABLE
628: , p5_a2 JTF_NUMBER_TABLE
629: , p5_a3 JTF_VARCHAR2_TABLE_100
630: , p5_a4 JTF_NUMBER_TABLE
631: , p5_a5 JTF_DATE_TABLE
632: , p5_a6 JTF_NUMBER_TABLE
633: , p5_a7 JTF_DATE_TABLE

Line 638: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

634: , p5_a8 JTF_NUMBER_TABLE
635: , p6_a0 out nocopy JTF_NUMBER_TABLE
636: , p6_a1 out nocopy JTF_NUMBER_TABLE
637: , p6_a2 out nocopy JTF_NUMBER_TABLE
638: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
639: , p6_a4 out nocopy JTF_NUMBER_TABLE
640: , p6_a5 out nocopy JTF_DATE_TABLE
641: , p6_a6 out nocopy JTF_NUMBER_TABLE
642: , p6_a7 out nocopy JTF_DATE_TABLE

Line 645: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

641: , p6_a6 out nocopy JTF_NUMBER_TABLE
642: , p6_a7 out nocopy JTF_DATE_TABLE
643: , p6_a8 out nocopy JTF_NUMBER_TABLE
644: , p7_a0 in out nocopy JTF_NUMBER_TABLE
645: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
646: , p7_a2 in out nocopy JTF_NUMBER_TABLE
647: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
648: , p7_a4 in out nocopy JTF_NUMBER_TABLE
649: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 649: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

645: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
646: , p7_a2 in out nocopy JTF_NUMBER_TABLE
647: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
648: , p7_a4 in out nocopy JTF_NUMBER_TABLE
649: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
650: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
651: )
652:
653: as

Line 650: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

646: , p7_a2 in out nocopy JTF_NUMBER_TABLE
647: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
648: , p7_a4 in out nocopy JTF_NUMBER_TABLE
649: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
650: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
651: )
652:
653: as
654: ddp_rps_tbl okl_rsp_pvt.rps_tbl_type;

Line 733: , p5_a3 JTF_VARCHAR2_TABLE_100

729: , x_msg_data out nocopy VARCHAR2
730: , p5_a0 JTF_NUMBER_TABLE
731: , p5_a1 JTF_NUMBER_TABLE
732: , p5_a2 JTF_NUMBER_TABLE
733: , p5_a3 JTF_VARCHAR2_TABLE_100
734: , p5_a4 JTF_NUMBER_TABLE
735: , p5_a5 JTF_DATE_TABLE
736: , p5_a6 JTF_NUMBER_TABLE
737: , p5_a7 JTF_DATE_TABLE

Line 742: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

738: , p5_a8 JTF_NUMBER_TABLE
739: , p6_a0 out nocopy JTF_NUMBER_TABLE
740: , p6_a1 out nocopy JTF_NUMBER_TABLE
741: , p6_a2 out nocopy JTF_NUMBER_TABLE
742: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
743: , p6_a4 out nocopy JTF_NUMBER_TABLE
744: , p6_a5 out nocopy JTF_DATE_TABLE
745: , p6_a6 out nocopy JTF_NUMBER_TABLE
746: , p6_a7 out nocopy JTF_DATE_TABLE

Line 863: , p5_a3 JTF_VARCHAR2_TABLE_100

859: , x_msg_data out nocopy VARCHAR2
860: , p5_a0 JTF_NUMBER_TABLE
861: , p5_a1 JTF_NUMBER_TABLE
862: , p5_a2 JTF_NUMBER_TABLE
863: , p5_a3 JTF_VARCHAR2_TABLE_100
864: , p5_a4 JTF_NUMBER_TABLE
865: , p5_a5 JTF_DATE_TABLE
866: , p5_a6 JTF_NUMBER_TABLE
867: , p5_a7 JTF_DATE_TABLE

Line 870: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

866: , p5_a6 JTF_NUMBER_TABLE
867: , p5_a7 JTF_DATE_TABLE
868: , p5_a8 JTF_NUMBER_TABLE
869: , p6_a0 in out nocopy JTF_NUMBER_TABLE
870: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a2 in out nocopy JTF_NUMBER_TABLE
872: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
873: , p6_a4 in out nocopy JTF_NUMBER_TABLE
874: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 874: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

870: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a2 in out nocopy JTF_NUMBER_TABLE
872: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
873: , p6_a4 in out nocopy JTF_NUMBER_TABLE
874: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
875: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
876: )
877:
878: as

Line 875: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

871: , p6_a2 in out nocopy JTF_NUMBER_TABLE
872: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
873: , p6_a4 in out nocopy JTF_NUMBER_TABLE
874: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
875: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
876: )
877:
878: as
879: ddp_rps_tbl okl_rsp_pvt.rps_tbl_type;

Line 944: , p5_a3 JTF_VARCHAR2_TABLE_100

940: , x_msg_data out nocopy VARCHAR2
941: , p5_a0 JTF_NUMBER_TABLE
942: , p5_a1 JTF_NUMBER_TABLE
943: , p5_a2 JTF_NUMBER_TABLE
944: , p5_a3 JTF_VARCHAR2_TABLE_100
945: , p5_a4 JTF_NUMBER_TABLE
946: , p5_a5 JTF_DATE_TABLE
947: , p5_a6 JTF_NUMBER_TABLE
948: , p5_a7 JTF_DATE_TABLE

Line 1051: , p5_a3 JTF_VARCHAR2_TABLE_100

1047: , x_msg_data out nocopy VARCHAR2
1048: , p5_a0 JTF_NUMBER_TABLE
1049: , p5_a1 JTF_NUMBER_TABLE
1050: , p5_a2 JTF_NUMBER_TABLE
1051: , p5_a3 JTF_VARCHAR2_TABLE_100
1052: , p5_a4 JTF_NUMBER_TABLE
1053: , p5_a5 JTF_DATE_TABLE
1054: , p5_a6 JTF_NUMBER_TABLE
1055: , p5_a7 JTF_DATE_TABLE

Line 1058: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

1054: , p5_a6 JTF_NUMBER_TABLE
1055: , p5_a7 JTF_DATE_TABLE
1056: , p5_a8 JTF_NUMBER_TABLE
1057: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1058: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1059: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1060: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1061: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1062: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1062: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

1058: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1059: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1060: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1061: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1062: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1063: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1064: )
1065:
1066: as

Line 1063: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

1059: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1060: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1061: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1062: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1063: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1064: )
1065:
1066: as
1067: ddp_rps_tbl okl_rsp_pvt.rps_tbl_type;

Line 1132: , p5_a3 JTF_VARCHAR2_TABLE_100

1128: , x_msg_data out nocopy VARCHAR2
1129: , p5_a0 JTF_NUMBER_TABLE
1130: , p5_a1 JTF_NUMBER_TABLE
1131: , p5_a2 JTF_NUMBER_TABLE
1132: , p5_a3 JTF_VARCHAR2_TABLE_100
1133: , p5_a4 JTF_NUMBER_TABLE
1134: , p5_a5 JTF_DATE_TABLE
1135: , p5_a6 JTF_NUMBER_TABLE
1136: , p5_a7 JTF_DATE_TABLE