DBA Data[Home] [Help]

APPS.OKL_RPP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_rpp_pvt_w as
2: /* $Header: OKLIRPPB.pls 120.0 2007/12/10 18:29:05 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rpp_pvt.rpp_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_VARCHAR2_TABLE_300
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE

Line 46: , a2 out nocopy JTF_VARCHAR2_TABLE_100

42: end if;
43: end rosetta_table_copy_in_p2;
44: procedure rosetta_table_copy_out_p2(t okl_rpp_pvt.rpp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_300
49: , a5 out nocopy JTF_DATE_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE

Line 51: , a7 out nocopy JTF_VARCHAR2_TABLE_100

47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_300
49: , a5 out nocopy JTF_DATE_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_100
52: , a8 out nocopy JTF_DATE_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_DATE_TABLE
55: , a11 out nocopy JTF_NUMBER_TABLE

Line 62: a2 := JTF_VARCHAR2_TABLE_100();

58: begin
59: if t is null or t.count = 0 then
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_VARCHAR2_TABLE_100();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_VARCHAR2_TABLE_300();
65: a5 := JTF_DATE_TABLE();
66: a6 := JTF_NUMBER_TABLE();

Line 67: a7 := JTF_VARCHAR2_TABLE_100();

63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_VARCHAR2_TABLE_300();
65: a5 := JTF_DATE_TABLE();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_VARCHAR2_TABLE_100();
68: a8 := JTF_DATE_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_DATE_TABLE();
71: a11 := JTF_NUMBER_TABLE();

Line 75: a2 := JTF_VARCHAR2_TABLE_100();

71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_300();
78: a5 := JTF_DATE_TABLE();
79: a6 := JTF_NUMBER_TABLE();

Line 80: a7 := JTF_VARCHAR2_TABLE_100();

76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_300();
78: a5 := JTF_DATE_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_100();
81: a8 := JTF_DATE_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_DATE_TABLE();
84: a11 := JTF_NUMBER_TABLE();

Line 217: , p5_a2 JTF_VARCHAR2_TABLE_100

213: , x_msg_count out nocopy NUMBER
214: , x_msg_data out nocopy VARCHAR2
215: , p5_a0 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_VARCHAR2_TABLE_100
218: , p5_a3 JTF_NUMBER_TABLE
219: , p5_a4 JTF_VARCHAR2_TABLE_300
220: , p5_a5 JTF_DATE_TABLE
221: , p5_a6 JTF_NUMBER_TABLE

Line 222: , p5_a7 JTF_VARCHAR2_TABLE_100

218: , p5_a3 JTF_NUMBER_TABLE
219: , p5_a4 JTF_VARCHAR2_TABLE_300
220: , p5_a5 JTF_DATE_TABLE
221: , p5_a6 JTF_NUMBER_TABLE
222: , p5_a7 JTF_VARCHAR2_TABLE_100
223: , p5_a8 JTF_DATE_TABLE
224: , p5_a9 JTF_NUMBER_TABLE
225: , p5_a10 JTF_DATE_TABLE
226: , p5_a11 JTF_NUMBER_TABLE

Line 229: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

225: , p5_a10 JTF_DATE_TABLE
226: , p5_a11 JTF_NUMBER_TABLE
227: , p6_a0 out nocopy JTF_NUMBER_TABLE
228: , p6_a1 out nocopy JTF_NUMBER_TABLE
229: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
230: , p6_a3 out nocopy JTF_NUMBER_TABLE
231: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
232: , p6_a5 out nocopy JTF_DATE_TABLE
233: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 234: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

230: , p6_a3 out nocopy JTF_NUMBER_TABLE
231: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
232: , p6_a5 out nocopy JTF_DATE_TABLE
233: , p6_a6 out nocopy JTF_NUMBER_TABLE
234: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
235: , p6_a8 out nocopy JTF_DATE_TABLE
236: , p6_a9 out nocopy JTF_NUMBER_TABLE
237: , p6_a10 out nocopy JTF_DATE_TABLE
238: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 240: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

236: , p6_a9 out nocopy JTF_NUMBER_TABLE
237: , p6_a10 out nocopy JTF_DATE_TABLE
238: , p6_a11 out nocopy JTF_NUMBER_TABLE
239: , p7_a0 in out nocopy JTF_NUMBER_TABLE
240: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
241: , p7_a2 in out nocopy JTF_NUMBER_TABLE
242: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
243: , p7_a4 in out nocopy JTF_NUMBER_TABLE
244: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 244: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

240: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
241: , p7_a2 in out nocopy JTF_NUMBER_TABLE
242: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
243: , p7_a4 in out nocopy JTF_NUMBER_TABLE
244: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
245: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
246: )
247:
248: as

Line 245: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

241: , p7_a2 in out nocopy JTF_NUMBER_TABLE
242: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
243: , p7_a4 in out nocopy JTF_NUMBER_TABLE
244: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
245: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
246: )
247:
248: as
249: ddp_rpp_tbl okl_rpp_pvt.rpp_tbl_type;

Line 333: , p5_a2 JTF_VARCHAR2_TABLE_100

329: , x_msg_count out nocopy NUMBER
330: , x_msg_data out nocopy VARCHAR2
331: , p5_a0 JTF_NUMBER_TABLE
332: , p5_a1 JTF_NUMBER_TABLE
333: , p5_a2 JTF_VARCHAR2_TABLE_100
334: , p5_a3 JTF_NUMBER_TABLE
335: , p5_a4 JTF_VARCHAR2_TABLE_300
336: , p5_a5 JTF_DATE_TABLE
337: , p5_a6 JTF_NUMBER_TABLE

Line 338: , p5_a7 JTF_VARCHAR2_TABLE_100

334: , p5_a3 JTF_NUMBER_TABLE
335: , p5_a4 JTF_VARCHAR2_TABLE_300
336: , p5_a5 JTF_DATE_TABLE
337: , p5_a6 JTF_NUMBER_TABLE
338: , p5_a7 JTF_VARCHAR2_TABLE_100
339: , p5_a8 JTF_DATE_TABLE
340: , p5_a9 JTF_NUMBER_TABLE
341: , p5_a10 JTF_DATE_TABLE
342: , p5_a11 JTF_NUMBER_TABLE

Line 345: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

341: , p5_a10 JTF_DATE_TABLE
342: , p5_a11 JTF_NUMBER_TABLE
343: , p6_a0 out nocopy JTF_NUMBER_TABLE
344: , p6_a1 out nocopy JTF_NUMBER_TABLE
345: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a3 out nocopy JTF_NUMBER_TABLE
347: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
348: , p6_a5 out nocopy JTF_DATE_TABLE
349: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 350: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

346: , p6_a3 out nocopy JTF_NUMBER_TABLE
347: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
348: , p6_a5 out nocopy JTF_DATE_TABLE
349: , p6_a6 out nocopy JTF_NUMBER_TABLE
350: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a8 out nocopy JTF_DATE_TABLE
352: , p6_a9 out nocopy JTF_NUMBER_TABLE
353: , p6_a10 out nocopy JTF_DATE_TABLE
354: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 481: , p5_a2 JTF_VARCHAR2_TABLE_100

477: , x_msg_count out nocopy NUMBER
478: , x_msg_data out nocopy VARCHAR2
479: , p5_a0 JTF_NUMBER_TABLE
480: , p5_a1 JTF_NUMBER_TABLE
481: , p5_a2 JTF_VARCHAR2_TABLE_100
482: , p5_a3 JTF_NUMBER_TABLE
483: , p5_a4 JTF_VARCHAR2_TABLE_300
484: , p5_a5 JTF_DATE_TABLE
485: , p5_a6 JTF_NUMBER_TABLE

Line 486: , p5_a7 JTF_VARCHAR2_TABLE_100

482: , p5_a3 JTF_NUMBER_TABLE
483: , p5_a4 JTF_VARCHAR2_TABLE_300
484: , p5_a5 JTF_DATE_TABLE
485: , p5_a6 JTF_NUMBER_TABLE
486: , p5_a7 JTF_VARCHAR2_TABLE_100
487: , p5_a8 JTF_DATE_TABLE
488: , p5_a9 JTF_NUMBER_TABLE
489: , p5_a10 JTF_DATE_TABLE
490: , p5_a11 JTF_NUMBER_TABLE

Line 492: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

488: , p5_a9 JTF_NUMBER_TABLE
489: , p5_a10 JTF_DATE_TABLE
490: , p5_a11 JTF_NUMBER_TABLE
491: , p6_a0 in out nocopy JTF_NUMBER_TABLE
492: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
493: , p6_a2 in out nocopy JTF_NUMBER_TABLE
494: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
495: , p6_a4 in out nocopy JTF_NUMBER_TABLE
496: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 496: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

492: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
493: , p6_a2 in out nocopy JTF_NUMBER_TABLE
494: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
495: , p6_a4 in out nocopy JTF_NUMBER_TABLE
496: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
497: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
498: )
499:
500: as

Line 497: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

493: , p6_a2 in out nocopy JTF_NUMBER_TABLE
494: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
495: , p6_a4 in out nocopy JTF_NUMBER_TABLE
496: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
497: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
498: )
499:
500: as
501: ddp_rpp_tbl okl_rpp_pvt.rpp_tbl_type;

Line 568: , p5_a2 JTF_VARCHAR2_TABLE_100

564: , x_msg_count out nocopy NUMBER
565: , x_msg_data out nocopy VARCHAR2
566: , p5_a0 JTF_NUMBER_TABLE
567: , p5_a1 JTF_NUMBER_TABLE
568: , p5_a2 JTF_VARCHAR2_TABLE_100
569: , p5_a3 JTF_NUMBER_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_300
571: , p5_a5 JTF_DATE_TABLE
572: , p5_a6 JTF_NUMBER_TABLE

Line 573: , p5_a7 JTF_VARCHAR2_TABLE_100

569: , p5_a3 JTF_NUMBER_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_300
571: , p5_a5 JTF_DATE_TABLE
572: , p5_a6 JTF_NUMBER_TABLE
573: , p5_a7 JTF_VARCHAR2_TABLE_100
574: , p5_a8 JTF_DATE_TABLE
575: , p5_a9 JTF_NUMBER_TABLE
576: , p5_a10 JTF_DATE_TABLE
577: , p5_a11 JTF_NUMBER_TABLE

Line 715: , p5_a2 JTF_VARCHAR2_TABLE_100

711: , x_msg_count out nocopy NUMBER
712: , x_msg_data out nocopy VARCHAR2
713: , p5_a0 JTF_NUMBER_TABLE
714: , p5_a1 JTF_NUMBER_TABLE
715: , p5_a2 JTF_VARCHAR2_TABLE_100
716: , p5_a3 JTF_NUMBER_TABLE
717: , p5_a4 JTF_VARCHAR2_TABLE_300
718: , p5_a5 JTF_DATE_TABLE
719: , p5_a6 JTF_NUMBER_TABLE

Line 720: , p5_a7 JTF_VARCHAR2_TABLE_100

716: , p5_a3 JTF_NUMBER_TABLE
717: , p5_a4 JTF_VARCHAR2_TABLE_300
718: , p5_a5 JTF_DATE_TABLE
719: , p5_a6 JTF_NUMBER_TABLE
720: , p5_a7 JTF_VARCHAR2_TABLE_100
721: , p5_a8 JTF_DATE_TABLE
722: , p5_a9 JTF_NUMBER_TABLE
723: , p5_a10 JTF_DATE_TABLE
724: , p5_a11 JTF_NUMBER_TABLE

Line 727: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

723: , p5_a10 JTF_DATE_TABLE
724: , p5_a11 JTF_NUMBER_TABLE
725: , p6_a0 out nocopy JTF_NUMBER_TABLE
726: , p6_a1 out nocopy JTF_NUMBER_TABLE
727: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
728: , p6_a3 out nocopy JTF_NUMBER_TABLE
729: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
730: , p6_a5 out nocopy JTF_DATE_TABLE
731: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 732: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

728: , p6_a3 out nocopy JTF_NUMBER_TABLE
729: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
730: , p6_a5 out nocopy JTF_DATE_TABLE
731: , p6_a6 out nocopy JTF_NUMBER_TABLE
732: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
733: , p6_a8 out nocopy JTF_DATE_TABLE
734: , p6_a9 out nocopy JTF_NUMBER_TABLE
735: , p6_a10 out nocopy JTF_DATE_TABLE
736: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 738: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

734: , p6_a9 out nocopy JTF_NUMBER_TABLE
735: , p6_a10 out nocopy JTF_DATE_TABLE
736: , p6_a11 out nocopy JTF_NUMBER_TABLE
737: , p7_a0 in out nocopy JTF_NUMBER_TABLE
738: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
739: , p7_a2 in out nocopy JTF_NUMBER_TABLE
740: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
741: , p7_a4 in out nocopy JTF_NUMBER_TABLE
742: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 742: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

738: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
739: , p7_a2 in out nocopy JTF_NUMBER_TABLE
740: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
741: , p7_a4 in out nocopy JTF_NUMBER_TABLE
742: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
743: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
744: )
745:
746: as

Line 743: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

739: , p7_a2 in out nocopy JTF_NUMBER_TABLE
740: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
741: , p7_a4 in out nocopy JTF_NUMBER_TABLE
742: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
743: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
744: )
745:
746: as
747: ddp_rpp_tbl okl_rpp_pvt.rpp_tbl_type;

Line 831: , p5_a2 JTF_VARCHAR2_TABLE_100

827: , x_msg_count out nocopy NUMBER
828: , x_msg_data out nocopy VARCHAR2
829: , p5_a0 JTF_NUMBER_TABLE
830: , p5_a1 JTF_NUMBER_TABLE
831: , p5_a2 JTF_VARCHAR2_TABLE_100
832: , p5_a3 JTF_NUMBER_TABLE
833: , p5_a4 JTF_VARCHAR2_TABLE_300
834: , p5_a5 JTF_DATE_TABLE
835: , p5_a6 JTF_NUMBER_TABLE

Line 836: , p5_a7 JTF_VARCHAR2_TABLE_100

832: , p5_a3 JTF_NUMBER_TABLE
833: , p5_a4 JTF_VARCHAR2_TABLE_300
834: , p5_a5 JTF_DATE_TABLE
835: , p5_a6 JTF_NUMBER_TABLE
836: , p5_a7 JTF_VARCHAR2_TABLE_100
837: , p5_a8 JTF_DATE_TABLE
838: , p5_a9 JTF_NUMBER_TABLE
839: , p5_a10 JTF_DATE_TABLE
840: , p5_a11 JTF_NUMBER_TABLE

Line 843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

839: , p5_a10 JTF_DATE_TABLE
840: , p5_a11 JTF_NUMBER_TABLE
841: , p6_a0 out nocopy JTF_NUMBER_TABLE
842: , p6_a1 out nocopy JTF_NUMBER_TABLE
843: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
844: , p6_a3 out nocopy JTF_NUMBER_TABLE
845: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
846: , p6_a5 out nocopy JTF_DATE_TABLE
847: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 848: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

844: , p6_a3 out nocopy JTF_NUMBER_TABLE
845: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
846: , p6_a5 out nocopy JTF_DATE_TABLE
847: , p6_a6 out nocopy JTF_NUMBER_TABLE
848: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
849: , p6_a8 out nocopy JTF_DATE_TABLE
850: , p6_a9 out nocopy JTF_NUMBER_TABLE
851: , p6_a10 out nocopy JTF_DATE_TABLE
852: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 979: , p5_a2 JTF_VARCHAR2_TABLE_100

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

Line 984: , p5_a7 JTF_VARCHAR2_TABLE_100

980: , p5_a3 JTF_NUMBER_TABLE
981: , p5_a4 JTF_VARCHAR2_TABLE_300
982: , p5_a5 JTF_DATE_TABLE
983: , p5_a6 JTF_NUMBER_TABLE
984: , p5_a7 JTF_VARCHAR2_TABLE_100
985: , p5_a8 JTF_DATE_TABLE
986: , p5_a9 JTF_NUMBER_TABLE
987: , p5_a10 JTF_DATE_TABLE
988: , p5_a11 JTF_NUMBER_TABLE

Line 990: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

986: , p5_a9 JTF_NUMBER_TABLE
987: , p5_a10 JTF_DATE_TABLE
988: , p5_a11 JTF_NUMBER_TABLE
989: , p6_a0 in out nocopy JTF_NUMBER_TABLE
990: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
991: , p6_a2 in out nocopy JTF_NUMBER_TABLE
992: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
993: , p6_a4 in out nocopy JTF_NUMBER_TABLE
994: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 994: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

990: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
991: , p6_a2 in out nocopy JTF_NUMBER_TABLE
992: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
993: , p6_a4 in out nocopy JTF_NUMBER_TABLE
994: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
995: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
996: )
997:
998: as

Line 995: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

991: , p6_a2 in out nocopy JTF_NUMBER_TABLE
992: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
993: , p6_a4 in out nocopy JTF_NUMBER_TABLE
994: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
995: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
996: )
997:
998: as
999: ddp_rpp_tbl okl_rpp_pvt.rpp_tbl_type;

Line 1066: , p5_a2 JTF_VARCHAR2_TABLE_100

1062: , x_msg_count out nocopy NUMBER
1063: , x_msg_data out nocopy VARCHAR2
1064: , p5_a0 JTF_NUMBER_TABLE
1065: , p5_a1 JTF_NUMBER_TABLE
1066: , p5_a2 JTF_VARCHAR2_TABLE_100
1067: , p5_a3 JTF_NUMBER_TABLE
1068: , p5_a4 JTF_VARCHAR2_TABLE_300
1069: , p5_a5 JTF_DATE_TABLE
1070: , p5_a6 JTF_NUMBER_TABLE

Line 1071: , p5_a7 JTF_VARCHAR2_TABLE_100

1067: , p5_a3 JTF_NUMBER_TABLE
1068: , p5_a4 JTF_VARCHAR2_TABLE_300
1069: , p5_a5 JTF_DATE_TABLE
1070: , p5_a6 JTF_NUMBER_TABLE
1071: , p5_a7 JTF_VARCHAR2_TABLE_100
1072: , p5_a8 JTF_DATE_TABLE
1073: , p5_a9 JTF_NUMBER_TABLE
1074: , p5_a10 JTF_DATE_TABLE
1075: , p5_a11 JTF_NUMBER_TABLE

Line 1185: , p5_a2 JTF_VARCHAR2_TABLE_100

1181: , x_msg_count out nocopy NUMBER
1182: , x_msg_data out nocopy VARCHAR2
1183: , p5_a0 JTF_NUMBER_TABLE
1184: , p5_a1 JTF_NUMBER_TABLE
1185: , p5_a2 JTF_VARCHAR2_TABLE_100
1186: , p5_a3 JTF_NUMBER_TABLE
1187: , p5_a4 JTF_VARCHAR2_TABLE_300
1188: , p5_a5 JTF_DATE_TABLE
1189: , p5_a6 JTF_NUMBER_TABLE

Line 1190: , p5_a7 JTF_VARCHAR2_TABLE_100

1186: , p5_a3 JTF_NUMBER_TABLE
1187: , p5_a4 JTF_VARCHAR2_TABLE_300
1188: , p5_a5 JTF_DATE_TABLE
1189: , p5_a6 JTF_NUMBER_TABLE
1190: , p5_a7 JTF_VARCHAR2_TABLE_100
1191: , p5_a8 JTF_DATE_TABLE
1192: , p5_a9 JTF_NUMBER_TABLE
1193: , p5_a10 JTF_DATE_TABLE
1194: , p5_a11 JTF_NUMBER_TABLE

Line 1196: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

1192: , p5_a9 JTF_NUMBER_TABLE
1193: , p5_a10 JTF_DATE_TABLE
1194: , p5_a11 JTF_NUMBER_TABLE
1195: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1196: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1197: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1198: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1199: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1200: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1200: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

1196: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1197: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1198: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1199: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1200: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1201: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1202: )
1203:
1204: as

Line 1201: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

1197: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1198: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1199: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1200: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1201: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1202: )
1203:
1204: as
1205: ddp_rpp_tbl okl_rpp_pvt.rpp_tbl_type;

Line 1272: , p5_a2 JTF_VARCHAR2_TABLE_100

1268: , x_msg_count out nocopy NUMBER
1269: , x_msg_data out nocopy VARCHAR2
1270: , p5_a0 JTF_NUMBER_TABLE
1271: , p5_a1 JTF_NUMBER_TABLE
1272: , p5_a2 JTF_VARCHAR2_TABLE_100
1273: , p5_a3 JTF_NUMBER_TABLE
1274: , p5_a4 JTF_VARCHAR2_TABLE_300
1275: , p5_a5 JTF_DATE_TABLE
1276: , p5_a6 JTF_NUMBER_TABLE

Line 1277: , p5_a7 JTF_VARCHAR2_TABLE_100

1273: , p5_a3 JTF_NUMBER_TABLE
1274: , p5_a4 JTF_VARCHAR2_TABLE_300
1275: , p5_a5 JTF_DATE_TABLE
1276: , p5_a6 JTF_NUMBER_TABLE
1277: , p5_a7 JTF_VARCHAR2_TABLE_100
1278: , p5_a8 JTF_DATE_TABLE
1279: , p5_a9 JTF_NUMBER_TABLE
1280: , p5_a10 JTF_DATE_TABLE
1281: , p5_a11 JTF_NUMBER_TABLE