APPS.AHL_PRD_MRSHL_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 5: , a2 JTF_VARCHAR2_TABLE_300

1: package ahl_prd_mrshl_pvt_w as
2: /* $Header: AHLWPMLS.pls 120.1 2008/02/20 05:05:36 sikumar noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_300

2: /* $Header: AHLWPMLS.pls 120.1 2008/02/20 05:05:36 sikumar noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 30: , a27 JTF_VARCHAR2_TABLE_300

26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100

Line 42: , a2 out nocopy JTF_VARCHAR2_TABLE_300

38: , a35 JTF_VARCHAR2_TABLE_100
39: );
40: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_300
43: , a3 out nocopy JTF_VARCHAR2_TABLE_300
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_VARCHAR2_TABLE_100
46: , a6 out nocopy JTF_NUMBER_TABLE

Line 43: , a3 out nocopy JTF_VARCHAR2_TABLE_300

39: );
40: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_300
43: , a3 out nocopy JTF_VARCHAR2_TABLE_300
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_VARCHAR2_TABLE_100
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_NUMBER_TABLE

Line 67: , a27 out nocopy JTF_VARCHAR2_TABLE_300

63: , a23 out nocopy JTF_NUMBER_TABLE
64: , a24 out nocopy JTF_NUMBER_TABLE
65: , a25 out nocopy JTF_VARCHAR2_TABLE_100
66: , a26 out nocopy JTF_NUMBER_TABLE
67: , a27 out nocopy JTF_VARCHAR2_TABLE_300
68: , a28 out nocopy JTF_VARCHAR2_TABLE_100
69: , a29 out nocopy JTF_VARCHAR2_TABLE_100
70: , a30 out nocopy JTF_VARCHAR2_TABLE_100
71: , a31 out nocopy JTF_VARCHAR2_TABLE_100

Line 80: , a2 JTF_VARCHAR2_TABLE_300

76: );
77:
78: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE
79: , a1 JTF_NUMBER_TABLE
80: , a2 JTF_VARCHAR2_TABLE_300
81: , a3 JTF_VARCHAR2_TABLE_300
82: , a4 JTF_NUMBER_TABLE
83: , a5 JTF_VARCHAR2_TABLE_100
84: , a6 JTF_NUMBER_TABLE

Line 81: , a3 JTF_VARCHAR2_TABLE_300

77:
78: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE
79: , a1 JTF_NUMBER_TABLE
80: , a2 JTF_VARCHAR2_TABLE_300
81: , a3 JTF_VARCHAR2_TABLE_300
82: , a4 JTF_NUMBER_TABLE
83: , a5 JTF_VARCHAR2_TABLE_100
84: , a6 JTF_NUMBER_TABLE
85: , a7 JTF_NUMBER_TABLE

Line 105: , a27 JTF_VARCHAR2_TABLE_300

101: , a23 JTF_NUMBER_TABLE
102: , a24 JTF_NUMBER_TABLE
103: , a25 JTF_VARCHAR2_TABLE_100
104: , a26 JTF_NUMBER_TABLE
105: , a27 JTF_VARCHAR2_TABLE_300
106: , a28 JTF_VARCHAR2_TABLE_100
107: , a29 JTF_VARCHAR2_TABLE_100
108: , a30 JTF_VARCHAR2_TABLE_100
109: , a31 JTF_NUMBER_TABLE

Line 121: , a2 out nocopy JTF_VARCHAR2_TABLE_300

117: , a39 JTF_VARCHAR2_TABLE_100
118: );
119: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_VARCHAR2_TABLE_300
122: , a3 out nocopy JTF_VARCHAR2_TABLE_300
123: , a4 out nocopy JTF_NUMBER_TABLE
124: , a5 out nocopy JTF_VARCHAR2_TABLE_100
125: , a6 out nocopy JTF_NUMBER_TABLE

Line 122: , a3 out nocopy JTF_VARCHAR2_TABLE_300

118: );
119: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_VARCHAR2_TABLE_300
122: , a3 out nocopy JTF_VARCHAR2_TABLE_300
123: , a4 out nocopy JTF_NUMBER_TABLE
124: , a5 out nocopy JTF_VARCHAR2_TABLE_100
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_NUMBER_TABLE

Line 146: , a27 out nocopy JTF_VARCHAR2_TABLE_300

142: , a23 out nocopy JTF_NUMBER_TABLE
143: , a24 out nocopy JTF_NUMBER_TABLE
144: , a25 out nocopy JTF_VARCHAR2_TABLE_100
145: , a26 out nocopy JTF_NUMBER_TABLE
146: , a27 out nocopy JTF_VARCHAR2_TABLE_300
147: , a28 out nocopy JTF_VARCHAR2_TABLE_100
148: , a29 out nocopy JTF_VARCHAR2_TABLE_100
149: , a30 out nocopy JTF_VARCHAR2_TABLE_100
150: , a31 out nocopy JTF_NUMBER_TABLE

Line 166: , a5 JTF_VARCHAR2_TABLE_300

162: , a1 JTF_VARCHAR2_TABLE_100
163: , a2 JTF_NUMBER_TABLE
164: , a3 JTF_NUMBER_TABLE
165: , a4 JTF_NUMBER_TABLE
166: , a5 JTF_VARCHAR2_TABLE_300
167: , a6 JTF_VARCHAR2_TABLE_100
168: , a7 JTF_NUMBER_TABLE
169: , a8 JTF_NUMBER_TABLE
170: , a9 JTF_NUMBER_TABLE

Line 172: , a11 JTF_VARCHAR2_TABLE_300

168: , a7 JTF_NUMBER_TABLE
169: , a8 JTF_NUMBER_TABLE
170: , a9 JTF_NUMBER_TABLE
171: , a10 JTF_NUMBER_TABLE
172: , a11 JTF_VARCHAR2_TABLE_300
173: , a12 JTF_VARCHAR2_TABLE_100
174: , a13 JTF_NUMBER_TABLE
175: , a14 JTF_NUMBER_TABLE
176: , a15 JTF_NUMBER_TABLE

Line 193: , a5 out nocopy JTF_VARCHAR2_TABLE_300

189: , a1 out nocopy JTF_VARCHAR2_TABLE_100
190: , a2 out nocopy JTF_NUMBER_TABLE
191: , a3 out nocopy JTF_NUMBER_TABLE
192: , a4 out nocopy JTF_NUMBER_TABLE
193: , a5 out nocopy JTF_VARCHAR2_TABLE_300
194: , a6 out nocopy JTF_VARCHAR2_TABLE_100
195: , a7 out nocopy JTF_NUMBER_TABLE
196: , a8 out nocopy JTF_NUMBER_TABLE
197: , a9 out nocopy JTF_NUMBER_TABLE

Line 199: , a11 out nocopy JTF_VARCHAR2_TABLE_300

195: , a7 out nocopy JTF_NUMBER_TABLE
196: , a8 out nocopy JTF_NUMBER_TABLE
197: , a9 out nocopy JTF_NUMBER_TABLE
198: , a10 out nocopy JTF_NUMBER_TABLE
199: , a11 out nocopy JTF_VARCHAR2_TABLE_300
200: , a12 out nocopy JTF_VARCHAR2_TABLE_100
201: , a13 out nocopy JTF_NUMBER_TABLE
202: , a14 out nocopy JTF_NUMBER_TABLE
203: , a15 out nocopy JTF_NUMBER_TABLE

Line 231: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300

227: , p6_a5 VARCHAR2
228: , p6_a6 VARCHAR2
229: , p7_a0 out nocopy JTF_NUMBER_TABLE
230: , p7_a1 out nocopy JTF_NUMBER_TABLE
231: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
232: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
233: , p7_a4 out nocopy JTF_NUMBER_TABLE
234: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
235: , p7_a6 out nocopy JTF_NUMBER_TABLE

Line 232: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

228: , p6_a6 VARCHAR2
229: , p7_a0 out nocopy JTF_NUMBER_TABLE
230: , p7_a1 out nocopy JTF_NUMBER_TABLE
231: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
232: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
233: , p7_a4 out nocopy JTF_NUMBER_TABLE
234: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
235: , p7_a6 out nocopy JTF_NUMBER_TABLE
236: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 256: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300

252: , p7_a23 out nocopy JTF_NUMBER_TABLE
253: , p7_a24 out nocopy JTF_NUMBER_TABLE
254: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
255: , p7_a26 out nocopy JTF_NUMBER_TABLE
256: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
257: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
258: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
259: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
260: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100

Line 284: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300

280: , p6_a5 VARCHAR2
281: , p6_a6 VARCHAR2
282: , p7_a0 out nocopy JTF_NUMBER_TABLE
283: , p7_a1 out nocopy JTF_NUMBER_TABLE
284: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
285: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
286: , p7_a4 out nocopy JTF_NUMBER_TABLE
287: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
288: , p7_a6 out nocopy JTF_NUMBER_TABLE

Line 285: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

281: , p6_a6 VARCHAR2
282: , p7_a0 out nocopy JTF_NUMBER_TABLE
283: , p7_a1 out nocopy JTF_NUMBER_TABLE
284: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
285: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
286: , p7_a4 out nocopy JTF_NUMBER_TABLE
287: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
288: , p7_a6 out nocopy JTF_NUMBER_TABLE
289: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 309: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300

305: , p7_a23 out nocopy JTF_NUMBER_TABLE
306: , p7_a24 out nocopy JTF_NUMBER_TABLE
307: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a26 out nocopy JTF_NUMBER_TABLE
309: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
310: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
311: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
312: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
313: , p7_a31 out nocopy JTF_NUMBER_TABLE

Line 340: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300

336: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
337: , p9_a2 out nocopy JTF_NUMBER_TABLE
338: , p9_a3 out nocopy JTF_NUMBER_TABLE
339: , p9_a4 out nocopy JTF_NUMBER_TABLE
340: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
341: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
342: , p9_a7 out nocopy JTF_NUMBER_TABLE
343: , p9_a8 out nocopy JTF_NUMBER_TABLE
344: , p9_a9 out nocopy JTF_NUMBER_TABLE

Line 346: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300

342: , p9_a7 out nocopy JTF_NUMBER_TABLE
343: , p9_a8 out nocopy JTF_NUMBER_TABLE
344: , p9_a9 out nocopy JTF_NUMBER_TABLE
345: , p9_a10 out nocopy JTF_NUMBER_TABLE
346: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
347: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
348: , p9_a13 out nocopy JTF_NUMBER_TABLE
349: , p9_a14 out nocopy JTF_NUMBER_TABLE
350: , p9_a15 out nocopy JTF_NUMBER_TABLE