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 AUTHID CURRENT_USER as
2: /* $Header: AHLWPMLS.pls 120.1.12020000.2 2012/12/14 03:35:37 shnatu ship $ */
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.12020000.2 2012/12/14 03:35:37 shnatu ship $ */
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 44: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 45: , a3 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 69: , a27 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 84: , a2 JTF_VARCHAR2_TABLE_300

80: );
81:
82: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_NUMBER_TABLE
84: , a2 JTF_VARCHAR2_TABLE_300
85: , a3 JTF_VARCHAR2_TABLE_300
86: , a4 JTF_NUMBER_TABLE
87: , a5 JTF_VARCHAR2_TABLE_100
88: , a6 JTF_NUMBER_TABLE

Line 85: , a3 JTF_VARCHAR2_TABLE_300

81:
82: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_NUMBER_TABLE
84: , a2 JTF_VARCHAR2_TABLE_300
85: , a3 JTF_VARCHAR2_TABLE_300
86: , a4 JTF_NUMBER_TABLE
87: , a5 JTF_VARCHAR2_TABLE_100
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_NUMBER_TABLE

Line 109: , a27 JTF_VARCHAR2_TABLE_300

105: , a23 JTF_NUMBER_TABLE
106: , a24 JTF_NUMBER_TABLE
107: , a25 JTF_VARCHAR2_TABLE_100
108: , a26 JTF_NUMBER_TABLE
109: , a27 JTF_VARCHAR2_TABLE_300
110: , a28 JTF_VARCHAR2_TABLE_100
111: , a29 JTF_VARCHAR2_TABLE_100
112: , a30 JTF_VARCHAR2_TABLE_100
113: , a31 JTF_NUMBER_TABLE

Line 127: , a2 out nocopy JTF_VARCHAR2_TABLE_300

123: , a41 JTF_NUMBER_TABLE
124: );
125: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_VARCHAR2_TABLE_300
128: , a3 out nocopy JTF_VARCHAR2_TABLE_300
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_VARCHAR2_TABLE_100
131: , a6 out nocopy JTF_NUMBER_TABLE

Line 128: , a3 out nocopy JTF_VARCHAR2_TABLE_300

124: );
125: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_VARCHAR2_TABLE_300
128: , a3 out nocopy JTF_VARCHAR2_TABLE_300
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_VARCHAR2_TABLE_100
131: , a6 out nocopy JTF_NUMBER_TABLE
132: , a7 out nocopy JTF_NUMBER_TABLE

Line 152: , a27 out nocopy JTF_VARCHAR2_TABLE_300

148: , a23 out nocopy JTF_NUMBER_TABLE
149: , a24 out nocopy JTF_NUMBER_TABLE
150: , a25 out nocopy JTF_VARCHAR2_TABLE_100
151: , a26 out nocopy JTF_NUMBER_TABLE
152: , a27 out nocopy JTF_VARCHAR2_TABLE_300
153: , a28 out nocopy JTF_VARCHAR2_TABLE_100
154: , a29 out nocopy JTF_VARCHAR2_TABLE_100
155: , a30 out nocopy JTF_VARCHAR2_TABLE_100
156: , a31 out nocopy JTF_NUMBER_TABLE

Line 174: , a5 JTF_VARCHAR2_TABLE_300

170: , a1 JTF_VARCHAR2_TABLE_100
171: , a2 JTF_NUMBER_TABLE
172: , a3 JTF_NUMBER_TABLE
173: , a4 JTF_NUMBER_TABLE
174: , a5 JTF_VARCHAR2_TABLE_300
175: , a6 JTF_VARCHAR2_TABLE_100
176: , a7 JTF_NUMBER_TABLE
177: , a8 JTF_NUMBER_TABLE
178: , a9 JTF_NUMBER_TABLE

Line 180: , a11 JTF_VARCHAR2_TABLE_300

176: , a7 JTF_NUMBER_TABLE
177: , a8 JTF_NUMBER_TABLE
178: , a9 JTF_NUMBER_TABLE
179: , a10 JTF_NUMBER_TABLE
180: , a11 JTF_VARCHAR2_TABLE_300
181: , a12 JTF_VARCHAR2_TABLE_100
182: , a13 JTF_NUMBER_TABLE
183: , a14 JTF_NUMBER_TABLE
184: , a15 JTF_NUMBER_TABLE

Line 201: , a5 out nocopy JTF_VARCHAR2_TABLE_300

197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
198: , a2 out nocopy JTF_NUMBER_TABLE
199: , a3 out nocopy JTF_NUMBER_TABLE
200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_VARCHAR2_TABLE_300
202: , a6 out nocopy JTF_VARCHAR2_TABLE_100
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE

Line 207: , a11 out nocopy JTF_VARCHAR2_TABLE_300

203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_NUMBER_TABLE
207: , a11 out nocopy JTF_VARCHAR2_TABLE_300
208: , a12 out nocopy JTF_VARCHAR2_TABLE_100
209: , a13 out nocopy JTF_NUMBER_TABLE
210: , a14 out nocopy JTF_NUMBER_TABLE
211: , a15 out nocopy JTF_NUMBER_TABLE

Line 239: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300

235: , p6_a5 VARCHAR2
236: , p6_a6 VARCHAR2
237: , p7_a0 out nocopy JTF_NUMBER_TABLE
238: , p7_a1 out nocopy JTF_NUMBER_TABLE
239: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
240: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
241: , p7_a4 out nocopy JTF_NUMBER_TABLE
242: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
243: , p7_a6 out nocopy JTF_NUMBER_TABLE

Line 240: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

236: , p6_a6 VARCHAR2
237: , p7_a0 out nocopy JTF_NUMBER_TABLE
238: , p7_a1 out nocopy JTF_NUMBER_TABLE
239: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
240: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
241: , p7_a4 out nocopy JTF_NUMBER_TABLE
242: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
243: , p7_a6 out nocopy JTF_NUMBER_TABLE
244: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 264: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300

260: , p7_a23 out nocopy JTF_NUMBER_TABLE
261: , p7_a24 out nocopy JTF_NUMBER_TABLE
262: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
263: , p7_a26 out nocopy JTF_NUMBER_TABLE
264: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
265: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
266: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
267: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
268: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100

Line 294: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300

290: , p6_a5 VARCHAR2
291: , p6_a6 VARCHAR2
292: , p7_a0 out nocopy JTF_NUMBER_TABLE
293: , p7_a1 out nocopy JTF_NUMBER_TABLE
294: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
295: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
296: , p7_a4 out nocopy JTF_NUMBER_TABLE
297: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
298: , p7_a6 out nocopy JTF_NUMBER_TABLE

Line 295: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

291: , p6_a6 VARCHAR2
292: , p7_a0 out nocopy JTF_NUMBER_TABLE
293: , p7_a1 out nocopy JTF_NUMBER_TABLE
294: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
295: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
296: , p7_a4 out nocopy JTF_NUMBER_TABLE
297: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
298: , p7_a6 out nocopy JTF_NUMBER_TABLE
299: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 319: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300

315: , p7_a23 out nocopy JTF_NUMBER_TABLE
316: , p7_a24 out nocopy JTF_NUMBER_TABLE
317: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a26 out nocopy JTF_NUMBER_TABLE
319: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
320: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
321: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
322: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
323: , p7_a31 out nocopy JTF_NUMBER_TABLE

Line 352: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300

348: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
349: , p9_a2 out nocopy JTF_NUMBER_TABLE
350: , p9_a3 out nocopy JTF_NUMBER_TABLE
351: , p9_a4 out nocopy JTF_NUMBER_TABLE
352: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
353: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
354: , p9_a7 out nocopy JTF_NUMBER_TABLE
355: , p9_a8 out nocopy JTF_NUMBER_TABLE
356: , p9_a9 out nocopy JTF_NUMBER_TABLE

Line 358: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300

354: , p9_a7 out nocopy JTF_NUMBER_TABLE
355: , p9_a8 out nocopy JTF_NUMBER_TABLE
356: , p9_a9 out nocopy JTF_NUMBER_TABLE
357: , p9_a10 out nocopy JTF_NUMBER_TABLE
358: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
359: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
360: , p9_a13 out nocopy JTF_NUMBER_TABLE
361: , p9_a14 out nocopy JTF_NUMBER_TABLE
362: , p9_a15 out nocopy JTF_NUMBER_TABLE