APPS.OKL_RAP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_rap_pvt_w as
2: /* $Header: OKLIRAPB.pls 120.0 2007/12/10 18:29:48 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rap_pvt.rap_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE

Line 42: , a2 out nocopy JTF_VARCHAR2_TABLE_100

38: end if;
39: end rosetta_table_copy_in_p2;
40: procedure rosetta_table_copy_out_p2(t okl_rap_pvt.rap_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_DATE_TABLE

Line 56: a2 := JTF_VARCHAR2_TABLE_100();

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

Line 67: a2 := JTF_VARCHAR2_TABLE_100();

63: a9 := JTF_NUMBER_TABLE();
64: else
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_NUMBER_TABLE();
67: a2 := JTF_VARCHAR2_TABLE_100();
68: a3 := JTF_NUMBER_TABLE();
69: a4 := JTF_NUMBER_TABLE();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_DATE_TABLE();

Line 195: , p5_a2 JTF_VARCHAR2_TABLE_100

191: , x_msg_count out nocopy NUMBER
192: , x_msg_data out nocopy VARCHAR2
193: , p5_a0 JTF_NUMBER_TABLE
194: , p5_a1 JTF_NUMBER_TABLE
195: , p5_a2 JTF_VARCHAR2_TABLE_100
196: , p5_a3 JTF_NUMBER_TABLE
197: , p5_a4 JTF_NUMBER_TABLE
198: , p5_a5 JTF_NUMBER_TABLE
199: , p5_a6 JTF_DATE_TABLE

Line 205: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

201: , p5_a8 JTF_DATE_TABLE
202: , p5_a9 JTF_NUMBER_TABLE
203: , p6_a0 out nocopy JTF_NUMBER_TABLE
204: , p6_a1 out nocopy JTF_NUMBER_TABLE
205: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
206: , p6_a3 out nocopy JTF_NUMBER_TABLE
207: , p6_a4 out nocopy JTF_NUMBER_TABLE
208: , p6_a5 out nocopy JTF_NUMBER_TABLE
209: , p6_a6 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_rap_tbl okl_rap_pvt.rap_tbl_type;

Line 303: , p5_a2 JTF_VARCHAR2_TABLE_100

299: , x_msg_count out nocopy NUMBER
300: , x_msg_data out nocopy VARCHAR2
301: , p5_a0 JTF_NUMBER_TABLE
302: , p5_a1 JTF_NUMBER_TABLE
303: , p5_a2 JTF_VARCHAR2_TABLE_100
304: , p5_a3 JTF_NUMBER_TABLE
305: , p5_a4 JTF_NUMBER_TABLE
306: , p5_a5 JTF_NUMBER_TABLE
307: , p5_a6 JTF_DATE_TABLE

Line 313: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

309: , p5_a8 JTF_DATE_TABLE
310: , p5_a9 JTF_NUMBER_TABLE
311: , p6_a0 out nocopy JTF_NUMBER_TABLE
312: , p6_a1 out nocopy JTF_NUMBER_TABLE
313: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
314: , p6_a3 out nocopy JTF_NUMBER_TABLE
315: , p6_a4 out nocopy JTF_NUMBER_TABLE
316: , p6_a5 out nocopy JTF_NUMBER_TABLE
317: , p6_a6 out nocopy JTF_DATE_TABLE

Line 439: , p5_a2 JTF_VARCHAR2_TABLE_100

435: , x_msg_count out nocopy NUMBER
436: , x_msg_data out nocopy VARCHAR2
437: , p5_a0 JTF_NUMBER_TABLE
438: , p5_a1 JTF_NUMBER_TABLE
439: , p5_a2 JTF_VARCHAR2_TABLE_100
440: , p5_a3 JTF_NUMBER_TABLE
441: , p5_a4 JTF_NUMBER_TABLE
442: , p5_a5 JTF_NUMBER_TABLE
443: , p5_a6 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_rap_tbl okl_rap_pvt.rap_tbl_type;

Line 522: , p5_a2 JTF_VARCHAR2_TABLE_100

518: , x_msg_count out nocopy NUMBER
519: , x_msg_data out nocopy VARCHAR2
520: , p5_a0 JTF_NUMBER_TABLE
521: , p5_a1 JTF_NUMBER_TABLE
522: , p5_a2 JTF_VARCHAR2_TABLE_100
523: , p5_a3 JTF_NUMBER_TABLE
524: , p5_a4 JTF_NUMBER_TABLE
525: , p5_a5 JTF_NUMBER_TABLE
526: , p5_a6 JTF_DATE_TABLE

Line 657: , p5_a2 JTF_VARCHAR2_TABLE_100

653: , x_msg_count out nocopy NUMBER
654: , x_msg_data out nocopy VARCHAR2
655: , p5_a0 JTF_NUMBER_TABLE
656: , p5_a1 JTF_NUMBER_TABLE
657: , p5_a2 JTF_VARCHAR2_TABLE_100
658: , p5_a3 JTF_NUMBER_TABLE
659: , p5_a4 JTF_NUMBER_TABLE
660: , p5_a5 JTF_NUMBER_TABLE
661: , p5_a6 JTF_DATE_TABLE

Line 667: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

663: , p5_a8 JTF_DATE_TABLE
664: , p5_a9 JTF_NUMBER_TABLE
665: , p6_a0 out nocopy JTF_NUMBER_TABLE
666: , p6_a1 out nocopy JTF_NUMBER_TABLE
667: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
668: , p6_a3 out nocopy JTF_NUMBER_TABLE
669: , p6_a4 out nocopy JTF_NUMBER_TABLE
670: , p6_a5 out nocopy JTF_NUMBER_TABLE
671: , p6_a6 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_rap_tbl okl_rap_pvt.rap_tbl_type;

Line 765: , p5_a2 JTF_VARCHAR2_TABLE_100

761: , x_msg_count out nocopy NUMBER
762: , x_msg_data out nocopy VARCHAR2
763: , p5_a0 JTF_NUMBER_TABLE
764: , p5_a1 JTF_NUMBER_TABLE
765: , p5_a2 JTF_VARCHAR2_TABLE_100
766: , p5_a3 JTF_NUMBER_TABLE
767: , p5_a4 JTF_NUMBER_TABLE
768: , p5_a5 JTF_NUMBER_TABLE
769: , p5_a6 JTF_DATE_TABLE

Line 775: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

771: , p5_a8 JTF_DATE_TABLE
772: , p5_a9 JTF_NUMBER_TABLE
773: , p6_a0 out nocopy JTF_NUMBER_TABLE
774: , p6_a1 out nocopy JTF_NUMBER_TABLE
775: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
776: , p6_a3 out nocopy JTF_NUMBER_TABLE
777: , p6_a4 out nocopy JTF_NUMBER_TABLE
778: , p6_a5 out nocopy JTF_NUMBER_TABLE
779: , p6_a6 out nocopy JTF_DATE_TABLE

Line 901: , p5_a2 JTF_VARCHAR2_TABLE_100

897: , x_msg_count out nocopy NUMBER
898: , x_msg_data out nocopy VARCHAR2
899: , p5_a0 JTF_NUMBER_TABLE
900: , p5_a1 JTF_NUMBER_TABLE
901: , p5_a2 JTF_VARCHAR2_TABLE_100
902: , p5_a3 JTF_NUMBER_TABLE
903: , p5_a4 JTF_NUMBER_TABLE
904: , p5_a5 JTF_NUMBER_TABLE
905: , p5_a6 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_rap_tbl okl_rap_pvt.rap_tbl_type;

Line 984: , p5_a2 JTF_VARCHAR2_TABLE_100

980: , x_msg_count out nocopy NUMBER
981: , x_msg_data out nocopy VARCHAR2
982: , p5_a0 JTF_NUMBER_TABLE
983: , p5_a1 JTF_NUMBER_TABLE
984: , p5_a2 JTF_VARCHAR2_TABLE_100
985: , p5_a3 JTF_NUMBER_TABLE
986: , p5_a4 JTF_NUMBER_TABLE
987: , p5_a5 JTF_NUMBER_TABLE
988: , p5_a6 JTF_DATE_TABLE

Line 1095: , p5_a2 JTF_VARCHAR2_TABLE_100

1091: , x_msg_count out nocopy NUMBER
1092: , x_msg_data out nocopy VARCHAR2
1093: , p5_a0 JTF_NUMBER_TABLE
1094: , p5_a1 JTF_NUMBER_TABLE
1095: , p5_a2 JTF_VARCHAR2_TABLE_100
1096: , p5_a3 JTF_NUMBER_TABLE
1097: , p5_a4 JTF_NUMBER_TABLE
1098: , p5_a5 JTF_NUMBER_TABLE
1099: , p5_a6 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_rap_tbl okl_rap_pvt.rap_tbl_type;

Line 1178: , p5_a2 JTF_VARCHAR2_TABLE_100

1174: , x_msg_count out nocopy NUMBER
1175: , x_msg_data out nocopy VARCHAR2
1176: , p5_a0 JTF_NUMBER_TABLE
1177: , p5_a1 JTF_NUMBER_TABLE
1178: , p5_a2 JTF_VARCHAR2_TABLE_100
1179: , p5_a3 JTF_NUMBER_TABLE
1180: , p5_a4 JTF_NUMBER_TABLE
1181: , p5_a5 JTF_NUMBER_TABLE
1182: , p5_a6 JTF_DATE_TABLE