[Home] [Help]
PACKAGE: APPS.AHL_PRD_MRSHL_PVT_W
Source
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
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_DATE_TABLE
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_DATE_TABLE
23 , a20 JTF_NUMBER_TABLE
24 , a21 JTF_DATE_TABLE
25 , a22 JTF_NUMBER_TABLE
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
35 , a32 JTF_VARCHAR2_TABLE_100
36 , a33 JTF_VARCHAR2_TABLE_100
37 , a34 JTF_NUMBER_TABLE
38 , a35 JTF_VARCHAR2_TABLE_100
39 , a36 JTF_VARCHAR2_TABLE_100
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
49 , a7 out nocopy JTF_NUMBER_TABLE
50 , a8 out nocopy JTF_NUMBER_TABLE
51 , a9 out nocopy JTF_VARCHAR2_TABLE_100
52 , a10 out nocopy JTF_VARCHAR2_TABLE_100
53 , a11 out nocopy JTF_NUMBER_TABLE
54 , a12 out nocopy JTF_NUMBER_TABLE
55 , a13 out nocopy JTF_NUMBER_TABLE
56 , a14 out nocopy JTF_VARCHAR2_TABLE_100
57 , a15 out nocopy JTF_VARCHAR2_TABLE_100
58 , a16 out nocopy JTF_DATE_TABLE
59 , a17 out nocopy JTF_NUMBER_TABLE
60 , a18 out nocopy JTF_NUMBER_TABLE
61 , a19 out nocopy JTF_DATE_TABLE
62 , a20 out nocopy JTF_NUMBER_TABLE
63 , a21 out nocopy JTF_DATE_TABLE
64 , a22 out nocopy JTF_NUMBER_TABLE
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
74 , a32 out nocopy JTF_VARCHAR2_TABLE_100
75 , a33 out nocopy JTF_VARCHAR2_TABLE_100
76 , a34 out nocopy JTF_NUMBER_TABLE
77 , a35 out nocopy JTF_VARCHAR2_TABLE_100
78 , a36 out nocopy JTF_VARCHAR2_TABLE_100
79 , a37 out nocopy JTF_NUMBER_TABLE
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
89 , a7 JTF_NUMBER_TABLE
90 , a8 JTF_NUMBER_TABLE
91 , a9 JTF_VARCHAR2_TABLE_100
92 , a10 JTF_VARCHAR2_TABLE_100
93 , a11 JTF_NUMBER_TABLE
94 , a12 JTF_NUMBER_TABLE
95 , a13 JTF_NUMBER_TABLE
96 , a14 JTF_VARCHAR2_TABLE_100
97 , a15 JTF_VARCHAR2_TABLE_100
98 , a16 JTF_DATE_TABLE
99 , a17 JTF_NUMBER_TABLE
100 , a18 JTF_DATE_TABLE
101 , a19 JTF_NUMBER_TABLE
102 , a20 JTF_NUMBER_TABLE
103 , a21 JTF_DATE_TABLE
104 , a22 JTF_NUMBER_TABLE
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
114 , a32 JTF_VARCHAR2_TABLE_100
115 , a33 JTF_NUMBER_TABLE
116 , a34 JTF_NUMBER_TABLE
117 , a35 JTF_VARCHAR2_TABLE_100
118 , a36 JTF_VARCHAR2_TABLE_100
119 , a37 JTF_VARCHAR2_TABLE_100
120 , a38 JTF_NUMBER_TABLE
121 , a39 JTF_VARCHAR2_TABLE_100
122 , a40 JTF_VARCHAR2_TABLE_100
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
132 , a7 out nocopy JTF_NUMBER_TABLE
133 , a8 out nocopy JTF_NUMBER_TABLE
134 , a9 out nocopy JTF_VARCHAR2_TABLE_100
135 , a10 out nocopy JTF_VARCHAR2_TABLE_100
136 , a11 out nocopy JTF_NUMBER_TABLE
137 , a12 out nocopy JTF_NUMBER_TABLE
138 , a13 out nocopy JTF_NUMBER_TABLE
139 , a14 out nocopy JTF_VARCHAR2_TABLE_100
140 , a15 out nocopy JTF_VARCHAR2_TABLE_100
141 , a16 out nocopy JTF_DATE_TABLE
142 , a17 out nocopy JTF_NUMBER_TABLE
143 , a18 out nocopy JTF_DATE_TABLE
144 , a19 out nocopy JTF_NUMBER_TABLE
145 , a20 out nocopy JTF_NUMBER_TABLE
146 , a21 out nocopy JTF_DATE_TABLE
147 , a22 out nocopy JTF_NUMBER_TABLE
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
157 , a32 out nocopy JTF_VARCHAR2_TABLE_100
158 , a33 out nocopy JTF_NUMBER_TABLE
159 , a34 out nocopy JTF_NUMBER_TABLE
160 , a35 out nocopy JTF_VARCHAR2_TABLE_100
161 , a36 out nocopy JTF_VARCHAR2_TABLE_100
162 , a37 out nocopy JTF_VARCHAR2_TABLE_100
163 , a38 out nocopy JTF_NUMBER_TABLE
164 , a39 out nocopy JTF_VARCHAR2_TABLE_100
165 , a40 out nocopy JTF_VARCHAR2_TABLE_100
166 , a41 out nocopy JTF_NUMBER_TABLE
167 );
168
169 procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
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
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
185 , a16 JTF_NUMBER_TABLE
186 , a17 JTF_NUMBER_TABLE
187 , a18 JTF_NUMBER_TABLE
188 , a19 JTF_NUMBER_TABLE
189 , a20 JTF_NUMBER_TABLE
190 , a21 JTF_NUMBER_TABLE
191 , a22 JTF_NUMBER_TABLE
192 , a23 JTF_NUMBER_TABLE
193 , a24 JTF_NUMBER_TABLE
194 , a25 JTF_NUMBER_TABLE
195 );
196 procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
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
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
212 , a16 out nocopy JTF_NUMBER_TABLE
213 , a17 out nocopy JTF_NUMBER_TABLE
214 , a18 out nocopy JTF_NUMBER_TABLE
215 , a19 out nocopy JTF_NUMBER_TABLE
216 , a20 out nocopy JTF_NUMBER_TABLE
217 , a21 out nocopy JTF_NUMBER_TABLE
218 , a22 out nocopy JTF_NUMBER_TABLE
219 , a23 out nocopy JTF_NUMBER_TABLE
220 , a24 out nocopy JTF_NUMBER_TABLE
221 , a25 out nocopy JTF_NUMBER_TABLE
222 );
223
224 procedure get_unavailable_items(p_api_version NUMBER
225 , p_init_msg_list VARCHAR2
226 , p_commit VARCHAR2
227 , p_validation_level NUMBER
228 , p_default VARCHAR2
229 , p_module_type VARCHAR2
230 , p6_a0 NUMBER
231 , p6_a1 NUMBER
232 , p6_a2 NUMBER
233 , p6_a3 VARCHAR2
234 , p6_a4 VARCHAR2
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
244 , p7_a7 out nocopy JTF_NUMBER_TABLE
245 , p7_a8 out nocopy JTF_NUMBER_TABLE
246 , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
247 , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
248 , p7_a11 out nocopy JTF_NUMBER_TABLE
249 , p7_a12 out nocopy JTF_NUMBER_TABLE
250 , p7_a13 out nocopy JTF_NUMBER_TABLE
251 , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
252 , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
253 , p7_a16 out nocopy JTF_DATE_TABLE
254 , p7_a17 out nocopy JTF_NUMBER_TABLE
255 , p7_a18 out nocopy JTF_NUMBER_TABLE
256 , p7_a19 out nocopy JTF_DATE_TABLE
257 , p7_a20 out nocopy JTF_NUMBER_TABLE
258 , p7_a21 out nocopy JTF_DATE_TABLE
259 , p7_a22 out nocopy JTF_NUMBER_TABLE
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
269 , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
270 , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
271 , p7_a34 out nocopy JTF_NUMBER_TABLE
272 , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
273 , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
274 , p7_a37 out nocopy JTF_NUMBER_TABLE
275 , x_return_status out nocopy VARCHAR2
276 , x_msg_count out nocopy NUMBER
277 , x_msg_data out nocopy VARCHAR2
278 );
279 procedure get_available_items(p_api_version NUMBER
280 , p_init_msg_list VARCHAR2
281 , p_commit VARCHAR2
282 , p_validation_level NUMBER
283 , p_default VARCHAR2
284 , p_module_type VARCHAR2
285 , p6_a0 NUMBER
286 , p6_a1 NUMBER
287 , p6_a2 NUMBER
288 , p6_a3 VARCHAR2
289 , p6_a4 VARCHAR2
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
299 , p7_a7 out nocopy JTF_NUMBER_TABLE
300 , p7_a8 out nocopy JTF_NUMBER_TABLE
301 , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
302 , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
303 , p7_a11 out nocopy JTF_NUMBER_TABLE
304 , p7_a12 out nocopy JTF_NUMBER_TABLE
305 , p7_a13 out nocopy JTF_NUMBER_TABLE
306 , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
307 , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
308 , p7_a16 out nocopy JTF_DATE_TABLE
309 , p7_a17 out nocopy JTF_NUMBER_TABLE
310 , p7_a18 out nocopy JTF_DATE_TABLE
311 , p7_a19 out nocopy JTF_NUMBER_TABLE
312 , p7_a20 out nocopy JTF_NUMBER_TABLE
313 , p7_a21 out nocopy JTF_DATE_TABLE
314 , p7_a22 out nocopy JTF_NUMBER_TABLE
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
324 , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
325 , p7_a33 out nocopy JTF_NUMBER_TABLE
326 , p7_a34 out nocopy JTF_NUMBER_TABLE
327 , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
328 , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
329 , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
330 , p7_a38 out nocopy JTF_NUMBER_TABLE
331 , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
332 , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
333 , p7_a41 out nocopy JTF_NUMBER_TABLE
334 , x_return_status out nocopy VARCHAR2
335 , x_msg_count out nocopy NUMBER
336 , x_msg_data out nocopy VARCHAR2
337 );
338 procedure get_mrshl_details(p_api_version NUMBER
339 , p_init_msg_list VARCHAR2
340 , p_commit VARCHAR2
341 , p_validation_level NUMBER
342 , p_default VARCHAR2
343 , p_module_type VARCHAR2
344 , p_unit_header_id NUMBER
345 , p_item_instance_id NUMBER
346 , p_visit_id NUMBER
347 , p9_a0 out nocopy JTF_NUMBER_TABLE
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
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
363 , p9_a16 out nocopy JTF_NUMBER_TABLE
364 , p9_a17 out nocopy JTF_NUMBER_TABLE
365 , p9_a18 out nocopy JTF_NUMBER_TABLE
366 , p9_a19 out nocopy JTF_NUMBER_TABLE
367 , p9_a20 out nocopy JTF_NUMBER_TABLE
368 , p9_a21 out nocopy JTF_NUMBER_TABLE
369 , p9_a22 out nocopy JTF_NUMBER_TABLE
370 , p9_a23 out nocopy JTF_NUMBER_TABLE
371 , p9_a24 out nocopy JTF_NUMBER_TABLE
372 , p9_a25 out nocopy JTF_NUMBER_TABLE
373 , x_return_status out nocopy VARCHAR2
374 , x_msg_count out nocopy NUMBER
375 , x_msg_data out nocopy VARCHAR2
376 );
377 end ahl_prd_mrshl_pvt_w;