[Home] [Help]
PACKAGE: APPS.AHL_PRD_MRSHL_PVT_W
Source
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
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 );
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
48 , a8 out nocopy JTF_NUMBER_TABLE
49 , a9 out nocopy JTF_VARCHAR2_TABLE_100
50 , a10 out nocopy JTF_VARCHAR2_TABLE_100
51 , a11 out nocopy JTF_NUMBER_TABLE
52 , a12 out nocopy JTF_NUMBER_TABLE
53 , a13 out nocopy JTF_NUMBER_TABLE
54 , a14 out nocopy JTF_VARCHAR2_TABLE_100
55 , a15 out nocopy JTF_VARCHAR2_TABLE_100
56 , a16 out nocopy JTF_DATE_TABLE
57 , a17 out nocopy JTF_NUMBER_TABLE
58 , a18 out nocopy JTF_NUMBER_TABLE
59 , a19 out nocopy JTF_DATE_TABLE
60 , a20 out nocopy JTF_NUMBER_TABLE
61 , a21 out nocopy JTF_DATE_TABLE
62 , a22 out nocopy JTF_NUMBER_TABLE
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
72 , a32 out nocopy JTF_VARCHAR2_TABLE_100
73 , a33 out nocopy JTF_VARCHAR2_TABLE_100
74 , a34 out nocopy JTF_NUMBER_TABLE
75 , a35 out nocopy JTF_VARCHAR2_TABLE_100
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
85 , a7 JTF_NUMBER_TABLE
86 , a8 JTF_NUMBER_TABLE
87 , a9 JTF_VARCHAR2_TABLE_100
88 , a10 JTF_VARCHAR2_TABLE_100
89 , a11 JTF_NUMBER_TABLE
90 , a12 JTF_NUMBER_TABLE
91 , a13 JTF_NUMBER_TABLE
92 , a14 JTF_VARCHAR2_TABLE_100
93 , a15 JTF_VARCHAR2_TABLE_100
94 , a16 JTF_DATE_TABLE
95 , a17 JTF_NUMBER_TABLE
96 , a18 JTF_DATE_TABLE
97 , a19 JTF_NUMBER_TABLE
98 , a20 JTF_NUMBER_TABLE
99 , a21 JTF_DATE_TABLE
100 , a22 JTF_NUMBER_TABLE
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
110 , a32 JTF_VARCHAR2_TABLE_100
111 , a33 JTF_NUMBER_TABLE
112 , a34 JTF_NUMBER_TABLE
113 , a35 JTF_VARCHAR2_TABLE_100
114 , a36 JTF_VARCHAR2_TABLE_100
115 , a37 JTF_VARCHAR2_TABLE_100
116 , a38 JTF_NUMBER_TABLE
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
126 , a7 out nocopy JTF_NUMBER_TABLE
127 , a8 out nocopy JTF_NUMBER_TABLE
128 , a9 out nocopy JTF_VARCHAR2_TABLE_100
129 , a10 out nocopy JTF_VARCHAR2_TABLE_100
130 , a11 out nocopy JTF_NUMBER_TABLE
131 , a12 out nocopy JTF_NUMBER_TABLE
132 , a13 out nocopy JTF_NUMBER_TABLE
133 , a14 out nocopy JTF_VARCHAR2_TABLE_100
134 , a15 out nocopy JTF_VARCHAR2_TABLE_100
135 , a16 out nocopy JTF_DATE_TABLE
136 , a17 out nocopy JTF_NUMBER_TABLE
137 , a18 out nocopy JTF_DATE_TABLE
138 , a19 out nocopy JTF_NUMBER_TABLE
139 , a20 out nocopy JTF_NUMBER_TABLE
140 , a21 out nocopy JTF_DATE_TABLE
141 , a22 out nocopy JTF_NUMBER_TABLE
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
151 , a32 out nocopy JTF_VARCHAR2_TABLE_100
152 , a33 out nocopy JTF_NUMBER_TABLE
153 , a34 out nocopy JTF_NUMBER_TABLE
154 , a35 out nocopy JTF_VARCHAR2_TABLE_100
155 , a36 out nocopy JTF_VARCHAR2_TABLE_100
156 , a37 out nocopy JTF_VARCHAR2_TABLE_100
157 , a38 out nocopy JTF_NUMBER_TABLE
158 , a39 out nocopy JTF_VARCHAR2_TABLE_100
159 );
160
161 procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
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
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
177 , a16 JTF_NUMBER_TABLE
178 , a17 JTF_NUMBER_TABLE
179 , a18 JTF_NUMBER_TABLE
180 , a19 JTF_NUMBER_TABLE
181 , a20 JTF_NUMBER_TABLE
182 , a21 JTF_NUMBER_TABLE
183 , a22 JTF_NUMBER_TABLE
184 , a23 JTF_NUMBER_TABLE
185 , a24 JTF_NUMBER_TABLE
186 , a25 JTF_NUMBER_TABLE
187 );
188 procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
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
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
204 , a16 out nocopy JTF_NUMBER_TABLE
205 , a17 out nocopy JTF_NUMBER_TABLE
206 , a18 out nocopy JTF_NUMBER_TABLE
207 , a19 out nocopy JTF_NUMBER_TABLE
208 , a20 out nocopy JTF_NUMBER_TABLE
209 , a21 out nocopy JTF_NUMBER_TABLE
210 , a22 out nocopy JTF_NUMBER_TABLE
211 , a23 out nocopy JTF_NUMBER_TABLE
212 , a24 out nocopy JTF_NUMBER_TABLE
213 , a25 out nocopy JTF_NUMBER_TABLE
214 );
215
216 procedure get_unavailable_items(p_api_version NUMBER
217 , p_init_msg_list VARCHAR2
218 , p_commit VARCHAR2
219 , p_validation_level NUMBER
220 , p_default VARCHAR2
221 , p_module_type VARCHAR2
222 , p6_a0 NUMBER
223 , p6_a1 NUMBER
224 , p6_a2 NUMBER
225 , p6_a3 VARCHAR2
226 , p6_a4 VARCHAR2
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
236 , p7_a7 out nocopy JTF_NUMBER_TABLE
237 , p7_a8 out nocopy JTF_NUMBER_TABLE
238 , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
239 , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
240 , p7_a11 out nocopy JTF_NUMBER_TABLE
241 , p7_a12 out nocopy JTF_NUMBER_TABLE
242 , p7_a13 out nocopy JTF_NUMBER_TABLE
243 , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
244 , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
245 , p7_a16 out nocopy JTF_DATE_TABLE
246 , p7_a17 out nocopy JTF_NUMBER_TABLE
247 , p7_a18 out nocopy JTF_NUMBER_TABLE
248 , p7_a19 out nocopy JTF_DATE_TABLE
249 , p7_a20 out nocopy JTF_NUMBER_TABLE
250 , p7_a21 out nocopy JTF_DATE_TABLE
251 , p7_a22 out nocopy JTF_NUMBER_TABLE
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
261 , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
262 , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
263 , p7_a34 out nocopy JTF_NUMBER_TABLE
264 , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
265 , x_return_status out nocopy VARCHAR2
266 , x_msg_count out nocopy NUMBER
267 , x_msg_data out nocopy VARCHAR2
268 );
269 procedure get_available_items(p_api_version NUMBER
270 , p_init_msg_list VARCHAR2
271 , p_commit VARCHAR2
272 , p_validation_level NUMBER
273 , p_default VARCHAR2
274 , p_module_type VARCHAR2
275 , p6_a0 NUMBER
276 , p6_a1 NUMBER
277 , p6_a2 NUMBER
278 , p6_a3 VARCHAR2
279 , p6_a4 VARCHAR2
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
289 , p7_a7 out nocopy JTF_NUMBER_TABLE
290 , p7_a8 out nocopy JTF_NUMBER_TABLE
291 , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
292 , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
293 , p7_a11 out nocopy JTF_NUMBER_TABLE
294 , p7_a12 out nocopy JTF_NUMBER_TABLE
295 , p7_a13 out nocopy JTF_NUMBER_TABLE
296 , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
297 , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
298 , p7_a16 out nocopy JTF_DATE_TABLE
299 , p7_a17 out nocopy JTF_NUMBER_TABLE
300 , p7_a18 out nocopy JTF_DATE_TABLE
301 , p7_a19 out nocopy JTF_NUMBER_TABLE
302 , p7_a20 out nocopy JTF_NUMBER_TABLE
303 , p7_a21 out nocopy JTF_DATE_TABLE
304 , p7_a22 out nocopy JTF_NUMBER_TABLE
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
314 , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
315 , p7_a33 out nocopy JTF_NUMBER_TABLE
316 , p7_a34 out nocopy JTF_NUMBER_TABLE
317 , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
318 , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
319 , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
320 , p7_a38 out nocopy JTF_NUMBER_TABLE
321 , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
322 , x_return_status out nocopy VARCHAR2
323 , x_msg_count out nocopy NUMBER
324 , x_msg_data out nocopy VARCHAR2
325 );
326 procedure get_mrshl_details(p_api_version NUMBER
327 , p_init_msg_list VARCHAR2
328 , p_commit VARCHAR2
329 , p_validation_level NUMBER
330 , p_default VARCHAR2
331 , p_module_type VARCHAR2
332 , p_unit_header_id NUMBER
333 , p_item_instance_id NUMBER
334 , p_visit_id NUMBER
335 , p9_a0 out nocopy JTF_NUMBER_TABLE
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
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
351 , p9_a16 out nocopy JTF_NUMBER_TABLE
352 , p9_a17 out nocopy JTF_NUMBER_TABLE
353 , p9_a18 out nocopy JTF_NUMBER_TABLE
354 , p9_a19 out nocopy JTF_NUMBER_TABLE
355 , p9_a20 out nocopy JTF_NUMBER_TABLE
356 , p9_a21 out nocopy JTF_NUMBER_TABLE
357 , p9_a22 out nocopy JTF_NUMBER_TABLE
358 , p9_a23 out nocopy JTF_NUMBER_TABLE
359 , p9_a24 out nocopy JTF_NUMBER_TABLE
360 , p9_a25 out nocopy JTF_NUMBER_TABLE
361 , x_return_status out nocopy VARCHAR2
362 , x_msg_count out nocopy NUMBER
363 , x_msg_data out nocopy VARCHAR2
364 );
365 end ahl_prd_mrshl_pvt_w;