DBA Data[Home] [Help]

APPS.OKL_VRR_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLIVRRB.pls 120.0 2005/08/03 07:54:37 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_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_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_500

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_VARCHAR2_TABLE_500
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500

Line 85: , a3 out nocopy JTF_VARCHAR2_TABLE_100

81: end rosetta_table_copy_in_p2;
82: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_VARCHAR2_TABLE_100
86: , a4 out nocopy JTF_VARCHAR2_TABLE_400
87: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
88: , a6 out nocopy JTF_VARCHAR2_TABLE_100
89: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 88: , a6 out nocopy JTF_VARCHAR2_TABLE_100

84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_VARCHAR2_TABLE_100
86: , a4 out nocopy JTF_VARCHAR2_TABLE_400
87: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
88: , a6 out nocopy JTF_VARCHAR2_TABLE_100
89: , a7 out nocopy JTF_VARCHAR2_TABLE_500
90: , a8 out nocopy JTF_VARCHAR2_TABLE_500
91: , a9 out nocopy JTF_VARCHAR2_TABLE_500
92: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 120: a3 := JTF_VARCHAR2_TABLE_100();

116: if t is null or t.count = 0 then
117: a0 := JTF_NUMBER_TABLE();
118: a1 := JTF_NUMBER_TABLE();
119: a2 := JTF_NUMBER_TABLE();
120: a3 := JTF_VARCHAR2_TABLE_100();
121: a4 := JTF_VARCHAR2_TABLE_400();
122: a5 := JTF_VARCHAR2_TABLE_2000();
123: a6 := JTF_VARCHAR2_TABLE_100();
124: a7 := JTF_VARCHAR2_TABLE_500();

Line 123: a6 := JTF_VARCHAR2_TABLE_100();

119: a2 := JTF_NUMBER_TABLE();
120: a3 := JTF_VARCHAR2_TABLE_100();
121: a4 := JTF_VARCHAR2_TABLE_400();
122: a5 := JTF_VARCHAR2_TABLE_2000();
123: a6 := JTF_VARCHAR2_TABLE_100();
124: a7 := JTF_VARCHAR2_TABLE_500();
125: a8 := JTF_VARCHAR2_TABLE_500();
126: a9 := JTF_VARCHAR2_TABLE_500();
127: a10 := JTF_VARCHAR2_TABLE_500();

Line 152: a3 := JTF_VARCHAR2_TABLE_100();

148: else
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_NUMBER_TABLE();
151: a2 := JTF_NUMBER_TABLE();
152: a3 := JTF_VARCHAR2_TABLE_100();
153: a4 := JTF_VARCHAR2_TABLE_400();
154: a5 := JTF_VARCHAR2_TABLE_2000();
155: a6 := JTF_VARCHAR2_TABLE_100();
156: a7 := JTF_VARCHAR2_TABLE_500();

Line 155: a6 := JTF_VARCHAR2_TABLE_100();

151: a2 := JTF_NUMBER_TABLE();
152: a3 := JTF_VARCHAR2_TABLE_100();
153: a4 := JTF_VARCHAR2_TABLE_400();
154: a5 := JTF_VARCHAR2_TABLE_2000();
155: a6 := JTF_VARCHAR2_TABLE_100();
156: a7 := JTF_VARCHAR2_TABLE_500();
157: a8 := JTF_VARCHAR2_TABLE_500();
158: a9 := JTF_VARCHAR2_TABLE_500();
159: a10 := JTF_VARCHAR2_TABLE_500();

Line 259: , a3 JTF_VARCHAR2_TABLE_100

255:
256: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
257: , a1 JTF_NUMBER_TABLE
258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_VARCHAR2_TABLE_100
260: , a4 JTF_VARCHAR2_TABLE_400
261: , a5 JTF_VARCHAR2_TABLE_2000
262: , a6 JTF_VARCHAR2_TABLE_100
263: , a7 JTF_VARCHAR2_TABLE_500

Line 262: , a6 JTF_VARCHAR2_TABLE_100

258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_VARCHAR2_TABLE_100
260: , a4 JTF_VARCHAR2_TABLE_400
261: , a5 JTF_VARCHAR2_TABLE_2000
262: , a6 JTF_VARCHAR2_TABLE_100
263: , a7 JTF_VARCHAR2_TABLE_500
264: , a8 JTF_VARCHAR2_TABLE_500
265: , a9 JTF_VARCHAR2_TABLE_500
266: , a10 JTF_VARCHAR2_TABLE_500

Line 338: , a3 out nocopy JTF_VARCHAR2_TABLE_100

334: end rosetta_table_copy_in_p5;
335: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
336: , a1 out nocopy JTF_NUMBER_TABLE
337: , a2 out nocopy JTF_NUMBER_TABLE
338: , a3 out nocopy JTF_VARCHAR2_TABLE_100
339: , a4 out nocopy JTF_VARCHAR2_TABLE_400
340: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
341: , a6 out nocopy JTF_VARCHAR2_TABLE_100
342: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 341: , a6 out nocopy JTF_VARCHAR2_TABLE_100

337: , a2 out nocopy JTF_NUMBER_TABLE
338: , a3 out nocopy JTF_VARCHAR2_TABLE_100
339: , a4 out nocopy JTF_VARCHAR2_TABLE_400
340: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
341: , a6 out nocopy JTF_VARCHAR2_TABLE_100
342: , a7 out nocopy JTF_VARCHAR2_TABLE_500
343: , a8 out nocopy JTF_VARCHAR2_TABLE_500
344: , a9 out nocopy JTF_VARCHAR2_TABLE_500
345: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 373: a3 := JTF_VARCHAR2_TABLE_100();

369: if t is null or t.count = 0 then
370: a0 := JTF_NUMBER_TABLE();
371: a1 := JTF_NUMBER_TABLE();
372: a2 := JTF_NUMBER_TABLE();
373: a3 := JTF_VARCHAR2_TABLE_100();
374: a4 := JTF_VARCHAR2_TABLE_400();
375: a5 := JTF_VARCHAR2_TABLE_2000();
376: a6 := JTF_VARCHAR2_TABLE_100();
377: a7 := JTF_VARCHAR2_TABLE_500();

Line 376: a6 := JTF_VARCHAR2_TABLE_100();

372: a2 := JTF_NUMBER_TABLE();
373: a3 := JTF_VARCHAR2_TABLE_100();
374: a4 := JTF_VARCHAR2_TABLE_400();
375: a5 := JTF_VARCHAR2_TABLE_2000();
376: a6 := JTF_VARCHAR2_TABLE_100();
377: a7 := JTF_VARCHAR2_TABLE_500();
378: a8 := JTF_VARCHAR2_TABLE_500();
379: a9 := JTF_VARCHAR2_TABLE_500();
380: a10 := JTF_VARCHAR2_TABLE_500();

Line 405: a3 := JTF_VARCHAR2_TABLE_100();

401: else
402: a0 := JTF_NUMBER_TABLE();
403: a1 := JTF_NUMBER_TABLE();
404: a2 := JTF_NUMBER_TABLE();
405: a3 := JTF_VARCHAR2_TABLE_100();
406: a4 := JTF_VARCHAR2_TABLE_400();
407: a5 := JTF_VARCHAR2_TABLE_2000();
408: a6 := JTF_VARCHAR2_TABLE_100();
409: a7 := JTF_VARCHAR2_TABLE_500();

Line 408: a6 := JTF_VARCHAR2_TABLE_100();

404: a2 := JTF_NUMBER_TABLE();
405: a3 := JTF_VARCHAR2_TABLE_100();
406: a4 := JTF_VARCHAR2_TABLE_400();
407: a5 := JTF_VARCHAR2_TABLE_2000();
408: a6 := JTF_VARCHAR2_TABLE_100();
409: a7 := JTF_VARCHAR2_TABLE_500();
410: a8 := JTF_VARCHAR2_TABLE_500();
411: a9 := JTF_VARCHAR2_TABLE_500();
412: a10 := JTF_VARCHAR2_TABLE_500();

Line 680: , p5_a3 JTF_VARCHAR2_TABLE_100

676: , x_msg_data out nocopy VARCHAR2
677: , p5_a0 JTF_NUMBER_TABLE
678: , p5_a1 JTF_NUMBER_TABLE
679: , p5_a2 JTF_NUMBER_TABLE
680: , p5_a3 JTF_VARCHAR2_TABLE_100
681: , p5_a4 JTF_VARCHAR2_TABLE_400
682: , p5_a5 JTF_VARCHAR2_TABLE_2000
683: , p5_a6 JTF_VARCHAR2_TABLE_100
684: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 683: , p5_a6 JTF_VARCHAR2_TABLE_100

679: , p5_a2 JTF_NUMBER_TABLE
680: , p5_a3 JTF_VARCHAR2_TABLE_100
681: , p5_a4 JTF_VARCHAR2_TABLE_400
682: , p5_a5 JTF_VARCHAR2_TABLE_2000
683: , p5_a6 JTF_VARCHAR2_TABLE_100
684: , p5_a7 JTF_VARCHAR2_TABLE_500
685: , p5_a8 JTF_VARCHAR2_TABLE_500
686: , p5_a9 JTF_VARCHAR2_TABLE_500
687: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 711: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

707: , p5_a30 JTF_NUMBER_TABLE
708: , p6_a0 out nocopy JTF_NUMBER_TABLE
709: , p6_a1 out nocopy JTF_NUMBER_TABLE
710: , p6_a2 out nocopy JTF_NUMBER_TABLE
711: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
712: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
713: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
714: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
715: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 714: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

710: , p6_a2 out nocopy JTF_NUMBER_TABLE
711: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
712: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
713: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
714: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
715: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
716: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
717: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
718: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 740: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

736: , p6_a28 out nocopy JTF_NUMBER_TABLE
737: , p6_a29 out nocopy JTF_DATE_TABLE
738: , p6_a30 out nocopy JTF_NUMBER_TABLE
739: , p7_a0 in out nocopy JTF_NUMBER_TABLE
740: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p7_a2 in out nocopy JTF_NUMBER_TABLE
742: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
743: , p7_a4 in out nocopy JTF_NUMBER_TABLE
744: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 744: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 745: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

741: , p7_a2 in out nocopy JTF_NUMBER_TABLE
742: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
743: , p7_a4 in out nocopy JTF_NUMBER_TABLE
744: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
746: )
747:
748: as
749: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

Line 872: , p5_a3 JTF_VARCHAR2_TABLE_100

868: , x_msg_data out nocopy VARCHAR2
869: , p5_a0 JTF_NUMBER_TABLE
870: , p5_a1 JTF_NUMBER_TABLE
871: , p5_a2 JTF_NUMBER_TABLE
872: , p5_a3 JTF_VARCHAR2_TABLE_100
873: , p5_a4 JTF_VARCHAR2_TABLE_400
874: , p5_a5 JTF_VARCHAR2_TABLE_2000
875: , p5_a6 JTF_VARCHAR2_TABLE_100
876: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 875: , p5_a6 JTF_VARCHAR2_TABLE_100

871: , p5_a2 JTF_NUMBER_TABLE
872: , p5_a3 JTF_VARCHAR2_TABLE_100
873: , p5_a4 JTF_VARCHAR2_TABLE_400
874: , p5_a5 JTF_VARCHAR2_TABLE_2000
875: , p5_a6 JTF_VARCHAR2_TABLE_100
876: , p5_a7 JTF_VARCHAR2_TABLE_500
877: , p5_a8 JTF_VARCHAR2_TABLE_500
878: , p5_a9 JTF_VARCHAR2_TABLE_500
879: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 903: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

899: , p5_a30 JTF_NUMBER_TABLE
900: , p6_a0 out nocopy JTF_NUMBER_TABLE
901: , p6_a1 out nocopy JTF_NUMBER_TABLE
902: , p6_a2 out nocopy JTF_NUMBER_TABLE
903: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
904: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
905: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
906: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
907: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 906: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

902: , p6_a2 out nocopy JTF_NUMBER_TABLE
903: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
904: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
905: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
906: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
907: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
908: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
909: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
910: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 1134: , p5_a3 JTF_VARCHAR2_TABLE_100

1130: , x_msg_data out nocopy VARCHAR2
1131: , p5_a0 JTF_NUMBER_TABLE
1132: , p5_a1 JTF_NUMBER_TABLE
1133: , p5_a2 JTF_NUMBER_TABLE
1134: , p5_a3 JTF_VARCHAR2_TABLE_100
1135: , p5_a4 JTF_VARCHAR2_TABLE_400
1136: , p5_a5 JTF_VARCHAR2_TABLE_2000
1137: , p5_a6 JTF_VARCHAR2_TABLE_100
1138: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1137: , p5_a6 JTF_VARCHAR2_TABLE_100

1133: , p5_a2 JTF_NUMBER_TABLE
1134: , p5_a3 JTF_VARCHAR2_TABLE_100
1135: , p5_a4 JTF_VARCHAR2_TABLE_400
1136: , p5_a5 JTF_VARCHAR2_TABLE_2000
1137: , p5_a6 JTF_VARCHAR2_TABLE_100
1138: , p5_a7 JTF_VARCHAR2_TABLE_500
1139: , p5_a8 JTF_VARCHAR2_TABLE_500
1140: , p5_a9 JTF_VARCHAR2_TABLE_500
1141: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 1163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

1159: , p5_a28 JTF_NUMBER_TABLE
1160: , p5_a29 JTF_DATE_TABLE
1161: , p5_a30 JTF_NUMBER_TABLE
1162: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1166: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1167: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1167: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

1163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1166: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1167: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1168: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1169: )
1170:
1171: as

Line 1168: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

1164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1166: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1167: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1168: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1169: )
1170:
1171: as
1172: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

Line 1259: , p5_a3 JTF_VARCHAR2_TABLE_100

1255: , x_msg_data out nocopy VARCHAR2
1256: , p5_a0 JTF_NUMBER_TABLE
1257: , p5_a1 JTF_NUMBER_TABLE
1258: , p5_a2 JTF_NUMBER_TABLE
1259: , p5_a3 JTF_VARCHAR2_TABLE_100
1260: , p5_a4 JTF_VARCHAR2_TABLE_400
1261: , p5_a5 JTF_VARCHAR2_TABLE_2000
1262: , p5_a6 JTF_VARCHAR2_TABLE_100
1263: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1262: , p5_a6 JTF_VARCHAR2_TABLE_100

1258: , p5_a2 JTF_NUMBER_TABLE
1259: , p5_a3 JTF_VARCHAR2_TABLE_100
1260: , p5_a4 JTF_VARCHAR2_TABLE_400
1261: , p5_a5 JTF_VARCHAR2_TABLE_2000
1262: , p5_a6 JTF_VARCHAR2_TABLE_100
1263: , p5_a7 JTF_VARCHAR2_TABLE_500
1264: , p5_a8 JTF_VARCHAR2_TABLE_500
1265: , p5_a9 JTF_VARCHAR2_TABLE_500
1266: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 1520: , p5_a3 JTF_VARCHAR2_TABLE_100

1516: , x_msg_data out nocopy VARCHAR2
1517: , p5_a0 JTF_NUMBER_TABLE
1518: , p5_a1 JTF_NUMBER_TABLE
1519: , p5_a2 JTF_NUMBER_TABLE
1520: , p5_a3 JTF_VARCHAR2_TABLE_100
1521: , p5_a4 JTF_VARCHAR2_TABLE_400
1522: , p5_a5 JTF_VARCHAR2_TABLE_2000
1523: , p5_a6 JTF_VARCHAR2_TABLE_100
1524: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1523: , p5_a6 JTF_VARCHAR2_TABLE_100

1519: , p5_a2 JTF_NUMBER_TABLE
1520: , p5_a3 JTF_VARCHAR2_TABLE_100
1521: , p5_a4 JTF_VARCHAR2_TABLE_400
1522: , p5_a5 JTF_VARCHAR2_TABLE_2000
1523: , p5_a6 JTF_VARCHAR2_TABLE_100
1524: , p5_a7 JTF_VARCHAR2_TABLE_500
1525: , p5_a8 JTF_VARCHAR2_TABLE_500
1526: , p5_a9 JTF_VARCHAR2_TABLE_500
1527: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 1551: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

1547: , p5_a30 JTF_NUMBER_TABLE
1548: , p6_a0 out nocopy JTF_NUMBER_TABLE
1549: , p6_a1 out nocopy JTF_NUMBER_TABLE
1550: , p6_a2 out nocopy JTF_NUMBER_TABLE
1551: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1552: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
1553: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1554: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 1554: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

1550: , p6_a2 out nocopy JTF_NUMBER_TABLE
1551: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1552: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
1553: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1554: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1556: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1557: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
1558: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 1580: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

1576: , p6_a28 out nocopy JTF_NUMBER_TABLE
1577: , p6_a29 out nocopy JTF_DATE_TABLE
1578: , p6_a30 out nocopy JTF_NUMBER_TABLE
1579: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1580: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1581: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1582: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1583: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1584: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1584: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

1580: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1581: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1582: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1583: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1584: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1585: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1586: )
1587:
1588: as

Line 1585: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

1581: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1582: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1583: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1584: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1585: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1586: )
1587:
1588: as
1589: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

Line 1712: , p5_a3 JTF_VARCHAR2_TABLE_100

1708: , x_msg_data out nocopy VARCHAR2
1709: , p5_a0 JTF_NUMBER_TABLE
1710: , p5_a1 JTF_NUMBER_TABLE
1711: , p5_a2 JTF_NUMBER_TABLE
1712: , p5_a3 JTF_VARCHAR2_TABLE_100
1713: , p5_a4 JTF_VARCHAR2_TABLE_400
1714: , p5_a5 JTF_VARCHAR2_TABLE_2000
1715: , p5_a6 JTF_VARCHAR2_TABLE_100
1716: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1715: , p5_a6 JTF_VARCHAR2_TABLE_100

1711: , p5_a2 JTF_NUMBER_TABLE
1712: , p5_a3 JTF_VARCHAR2_TABLE_100
1713: , p5_a4 JTF_VARCHAR2_TABLE_400
1714: , p5_a5 JTF_VARCHAR2_TABLE_2000
1715: , p5_a6 JTF_VARCHAR2_TABLE_100
1716: , p5_a7 JTF_VARCHAR2_TABLE_500
1717: , p5_a8 JTF_VARCHAR2_TABLE_500
1718: , p5_a9 JTF_VARCHAR2_TABLE_500
1719: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 1743: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

1739: , p5_a30 JTF_NUMBER_TABLE
1740: , p6_a0 out nocopy JTF_NUMBER_TABLE
1741: , p6_a1 out nocopy JTF_NUMBER_TABLE
1742: , p6_a2 out nocopy JTF_NUMBER_TABLE
1743: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1744: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
1745: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1746: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1747: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 1746: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

1742: , p6_a2 out nocopy JTF_NUMBER_TABLE
1743: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1744: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
1745: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1746: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1747: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1748: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1749: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
1750: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 1974: , p5_a3 JTF_VARCHAR2_TABLE_100

1970: , x_msg_data out nocopy VARCHAR2
1971: , p5_a0 JTF_NUMBER_TABLE
1972: , p5_a1 JTF_NUMBER_TABLE
1973: , p5_a2 JTF_NUMBER_TABLE
1974: , p5_a3 JTF_VARCHAR2_TABLE_100
1975: , p5_a4 JTF_VARCHAR2_TABLE_400
1976: , p5_a5 JTF_VARCHAR2_TABLE_2000
1977: , p5_a6 JTF_VARCHAR2_TABLE_100
1978: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 1977: , p5_a6 JTF_VARCHAR2_TABLE_100

1973: , p5_a2 JTF_NUMBER_TABLE
1974: , p5_a3 JTF_VARCHAR2_TABLE_100
1975: , p5_a4 JTF_VARCHAR2_TABLE_400
1976: , p5_a5 JTF_VARCHAR2_TABLE_2000
1977: , p5_a6 JTF_VARCHAR2_TABLE_100
1978: , p5_a7 JTF_VARCHAR2_TABLE_500
1979: , p5_a8 JTF_VARCHAR2_TABLE_500
1980: , p5_a9 JTF_VARCHAR2_TABLE_500
1981: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 2003: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

1999: , p5_a28 JTF_NUMBER_TABLE
2000: , p5_a29 JTF_DATE_TABLE
2001: , p5_a30 JTF_NUMBER_TABLE
2002: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2003: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2004: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2005: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2006: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2007: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 2007: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

2003: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2004: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2005: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2006: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2007: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2008: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2009: )
2010:
2011: as

Line 2008: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

2004: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2005: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2006: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2007: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2008: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2009: )
2010:
2011: as
2012: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

Line 2099: , p5_a3 JTF_VARCHAR2_TABLE_100

2095: , x_msg_data out nocopy VARCHAR2
2096: , p5_a0 JTF_NUMBER_TABLE
2097: , p5_a1 JTF_NUMBER_TABLE
2098: , p5_a2 JTF_NUMBER_TABLE
2099: , p5_a3 JTF_VARCHAR2_TABLE_100
2100: , p5_a4 JTF_VARCHAR2_TABLE_400
2101: , p5_a5 JTF_VARCHAR2_TABLE_2000
2102: , p5_a6 JTF_VARCHAR2_TABLE_100
2103: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 2102: , p5_a6 JTF_VARCHAR2_TABLE_100

2098: , p5_a2 JTF_NUMBER_TABLE
2099: , p5_a3 JTF_VARCHAR2_TABLE_100
2100: , p5_a4 JTF_VARCHAR2_TABLE_400
2101: , p5_a5 JTF_VARCHAR2_TABLE_2000
2102: , p5_a6 JTF_VARCHAR2_TABLE_100
2103: , p5_a7 JTF_VARCHAR2_TABLE_500
2104: , p5_a8 JTF_VARCHAR2_TABLE_500
2105: , p5_a9 JTF_VARCHAR2_TABLE_500
2106: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 2294: , p5_a3 JTF_VARCHAR2_TABLE_100

2290: , x_msg_data out nocopy VARCHAR2
2291: , p5_a0 JTF_NUMBER_TABLE
2292: , p5_a1 JTF_NUMBER_TABLE
2293: , p5_a2 JTF_NUMBER_TABLE
2294: , p5_a3 JTF_VARCHAR2_TABLE_100
2295: , p5_a4 JTF_VARCHAR2_TABLE_400
2296: , p5_a5 JTF_VARCHAR2_TABLE_2000
2297: , p5_a6 JTF_VARCHAR2_TABLE_100
2298: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 2297: , p5_a6 JTF_VARCHAR2_TABLE_100

2293: , p5_a2 JTF_NUMBER_TABLE
2294: , p5_a3 JTF_VARCHAR2_TABLE_100
2295: , p5_a4 JTF_VARCHAR2_TABLE_400
2296: , p5_a5 JTF_VARCHAR2_TABLE_2000
2297: , p5_a6 JTF_VARCHAR2_TABLE_100
2298: , p5_a7 JTF_VARCHAR2_TABLE_500
2299: , p5_a8 JTF_VARCHAR2_TABLE_500
2300: , p5_a9 JTF_VARCHAR2_TABLE_500
2301: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 2323: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

2319: , p5_a28 JTF_NUMBER_TABLE
2320: , p5_a29 JTF_DATE_TABLE
2321: , p5_a30 JTF_NUMBER_TABLE
2322: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2323: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2324: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2325: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2326: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2327: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 2327: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

2323: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2324: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2325: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2326: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2327: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2328: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2329: )
2330:
2331: as

Line 2328: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

2324: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2325: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2326: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2327: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2328: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2329: )
2330:
2331: as
2332: ddp_vrrv_tbl okl_vrr_pvt.vrrv_tbl_type;

Line 2419: , p5_a3 JTF_VARCHAR2_TABLE_100

2415: , x_msg_data out nocopy VARCHAR2
2416: , p5_a0 JTF_NUMBER_TABLE
2417: , p5_a1 JTF_NUMBER_TABLE
2418: , p5_a2 JTF_NUMBER_TABLE
2419: , p5_a3 JTF_VARCHAR2_TABLE_100
2420: , p5_a4 JTF_VARCHAR2_TABLE_400
2421: , p5_a5 JTF_VARCHAR2_TABLE_2000
2422: , p5_a6 JTF_VARCHAR2_TABLE_100
2423: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 2422: , p5_a6 JTF_VARCHAR2_TABLE_100

2418: , p5_a2 JTF_NUMBER_TABLE
2419: , p5_a3 JTF_VARCHAR2_TABLE_100
2420: , p5_a4 JTF_VARCHAR2_TABLE_400
2421: , p5_a5 JTF_VARCHAR2_TABLE_2000
2422: , p5_a6 JTF_VARCHAR2_TABLE_100
2423: , p5_a7 JTF_VARCHAR2_TABLE_500
2424: , p5_a8 JTF_VARCHAR2_TABLE_500
2425: , p5_a9 JTF_VARCHAR2_TABLE_500
2426: , p5_a10 JTF_VARCHAR2_TABLE_500