1 package ahl_vwp_mr_cst_pr_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWMCPS.pls 120.2.12020000.2 2012/12/14 09:56:21 shnatu ship $ */
3 procedure estimate_mr_cost(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , p_module_type VARCHAR2
8 , p5_a0 in out nocopy NUMBER
9 , p5_a1 in out nocopy NUMBER
10 , p5_a2 in out nocopy NUMBER
11 , p5_a3 in out nocopy NUMBER
12 , p5_a4 in out nocopy NUMBER
13 , p5_a5 in out nocopy NUMBER
14 , p5_a6 in out nocopy NUMBER
15 , p5_a7 in out nocopy VARCHAR2
16 , p5_a8 in out nocopy NUMBER
17 , p5_a9 in out nocopy NUMBER
18 , p5_a10 in out nocopy NUMBER
19 , p5_a11 in out nocopy NUMBER
20 , p5_a12 in out nocopy VARCHAR2
21 , p5_a13 in out nocopy VARCHAR2
22 , p5_a14 in out nocopy VARCHAR2
23 , p5_a15 in out nocopy VARCHAR2
24 , p5_a16 in out nocopy NUMBER
25 , p5_a17 in out nocopy VARCHAR2
26 , p5_a18 in out nocopy NUMBER
27 , p5_a19 in out nocopy NUMBER
28 , p5_a20 in out nocopy NUMBER
29 , p5_a21 in out nocopy DATE
30 , p5_a22 in out nocopy DATE
31 , p5_a23 in out nocopy DATE
32 , p5_a24 in out nocopy DATE
33 , p5_a25 in out nocopy DATE
34 , p5_a26 in out nocopy DATE
35 , p5_a27 in out nocopy VARCHAR2
36 , p5_a28 in out nocopy NUMBER
37 , p5_a29 in out nocopy VARCHAR2
38 , p5_a30 in out nocopy VARCHAR2
39 , p5_a31 in out nocopy NUMBER
40 , p5_a32 in out nocopy VARCHAR2
41 , p5_a33 in out nocopy VARCHAR2
42 , p5_a34 in out nocopy VARCHAR2
43 , p5_a35 in out nocopy NUMBER
44 , p5_a36 in out nocopy VARCHAR2
45 , p5_a37 in out nocopy NUMBER
46 , p5_a38 in out nocopy NUMBER
47 , p5_a39 in out nocopy NUMBER
48 , p5_a40 in out nocopy VARCHAR2
49 , p5_a41 in out nocopy VARCHAR2
50 , p5_a42 in out nocopy VARCHAR2
51 , p5_a43 in out nocopy DATE
52 , p5_a44 in out nocopy NUMBER
53 , p5_a45 in out nocopy DATE
54 , p5_a46 in out nocopy NUMBER
55 , p5_a47 in out nocopy DATE
56 , p5_a48 in out nocopy NUMBER
57 , p5_a49 in out nocopy VARCHAR2
58 , p5_a50 in out nocopy VARCHAR2
59 , p5_a51 in out nocopy VARCHAR2
60 , p5_a52 in out nocopy VARCHAR2
61 , p5_a53 in out nocopy VARCHAR2
62 , p5_a54 in out nocopy VARCHAR2
63 , p5_a55 in out nocopy VARCHAR2
64 , p5_a56 in out nocopy VARCHAR2
65 , p5_a57 in out nocopy VARCHAR2
66 , p5_a58 in out nocopy VARCHAR2
67 , p5_a59 in out nocopy VARCHAR2
68 , p5_a60 in out nocopy VARCHAR2
69 , p5_a61 in out nocopy VARCHAR2
70 , p5_a62 in out nocopy VARCHAR2
71 , p5_a63 in out nocopy VARCHAR2
72 , p5_a64 in out nocopy VARCHAR2
73 , x_return_status out nocopy VARCHAR2
74 , x_msg_count out nocopy NUMBER
75 , x_msg_data out nocopy VARCHAR2
76 );
77 procedure estimate_mr_price(p_api_version NUMBER
78 , p_init_msg_list VARCHAR2
79 , p_commit VARCHAR2
80 , p_validation_level NUMBER
81 , p_module_type VARCHAR2
82 , p5_a0 in out nocopy NUMBER
83 , p5_a1 in out nocopy NUMBER
84 , p5_a2 in out nocopy NUMBER
85 , p5_a3 in out nocopy NUMBER
86 , p5_a4 in out nocopy NUMBER
87 , p5_a5 in out nocopy NUMBER
88 , p5_a6 in out nocopy NUMBER
89 , p5_a7 in out nocopy VARCHAR2
90 , p5_a8 in out nocopy NUMBER
91 , p5_a9 in out nocopy NUMBER
92 , p5_a10 in out nocopy NUMBER
93 , p5_a11 in out nocopy NUMBER
94 , p5_a12 in out nocopy VARCHAR2
95 , p5_a13 in out nocopy VARCHAR2
96 , p5_a14 in out nocopy VARCHAR2
97 , p5_a15 in out nocopy VARCHAR2
98 , p5_a16 in out nocopy NUMBER
99 , p5_a17 in out nocopy VARCHAR2
100 , p5_a18 in out nocopy NUMBER
101 , p5_a19 in out nocopy NUMBER
102 , p5_a20 in out nocopy NUMBER
103 , p5_a21 in out nocopy DATE
104 , p5_a22 in out nocopy DATE
105 , p5_a23 in out nocopy DATE
106 , p5_a24 in out nocopy DATE
107 , p5_a25 in out nocopy DATE
108 , p5_a26 in out nocopy DATE
109 , p5_a27 in out nocopy VARCHAR2
110 , p5_a28 in out nocopy NUMBER
111 , p5_a29 in out nocopy VARCHAR2
112 , p5_a30 in out nocopy VARCHAR2
113 , p5_a31 in out nocopy NUMBER
114 , p5_a32 in out nocopy VARCHAR2
115 , p5_a33 in out nocopy VARCHAR2
116 , p5_a34 in out nocopy VARCHAR2
117 , p5_a35 in out nocopy NUMBER
118 , p5_a36 in out nocopy VARCHAR2
119 , p5_a37 in out nocopy NUMBER
120 , p5_a38 in out nocopy NUMBER
121 , p5_a39 in out nocopy NUMBER
122 , p5_a40 in out nocopy VARCHAR2
123 , p5_a41 in out nocopy VARCHAR2
124 , p5_a42 in out nocopy VARCHAR2
125 , p5_a43 in out nocopy DATE
126 , p5_a44 in out nocopy NUMBER
127 , p5_a45 in out nocopy DATE
128 , p5_a46 in out nocopy NUMBER
129 , p5_a47 in out nocopy DATE
130 , p5_a48 in out nocopy NUMBER
131 , p5_a49 in out nocopy VARCHAR2
132 , p5_a50 in out nocopy VARCHAR2
133 , p5_a51 in out nocopy VARCHAR2
134 , p5_a52 in out nocopy VARCHAR2
135 , p5_a53 in out nocopy VARCHAR2
136 , p5_a54 in out nocopy VARCHAR2
137 , p5_a55 in out nocopy VARCHAR2
138 , p5_a56 in out nocopy VARCHAR2
139 , p5_a57 in out nocopy VARCHAR2
140 , p5_a58 in out nocopy VARCHAR2
141 , p5_a59 in out nocopy VARCHAR2
142 , p5_a60 in out nocopy VARCHAR2
143 , p5_a61 in out nocopy VARCHAR2
144 , p5_a62 in out nocopy VARCHAR2
145 , p5_a63 in out nocopy VARCHAR2
146 , p5_a64 in out nocopy VARCHAR2
147 , x_return_status out nocopy VARCHAR2
148 , x_msg_count out nocopy NUMBER
149 , x_msg_data out nocopy VARCHAR2
150 );
151 procedure get_mr_items_no_price(p_api_version NUMBER
152 , p_init_msg_list VARCHAR2
153 , p_commit VARCHAR2
154 , p_validation_level NUMBER
155 , p_module_type VARCHAR2
156 , x_return_status out nocopy VARCHAR2
157 , x_msg_count out nocopy NUMBER
158 , x_msg_data out nocopy VARCHAR2
159 , p8_a0 NUMBER
160 , p8_a1 NUMBER
161 , p8_a2 NUMBER
162 , p8_a3 NUMBER
163 , p8_a4 NUMBER
164 , p8_a5 NUMBER
165 , p8_a6 NUMBER
166 , p8_a7 VARCHAR2
167 , p8_a8 NUMBER
168 , p8_a9 NUMBER
169 , p8_a10 NUMBER
170 , p8_a11 NUMBER
171 , p8_a12 VARCHAR2
172 , p8_a13 VARCHAR2
173 , p8_a14 VARCHAR2
174 , p8_a15 VARCHAR2
175 , p8_a16 NUMBER
176 , p8_a17 VARCHAR2
177 , p8_a18 NUMBER
178 , p8_a19 NUMBER
179 , p8_a20 NUMBER
180 , p8_a21 DATE
181 , p8_a22 DATE
182 , p8_a23 DATE
183 , p8_a24 DATE
184 , p8_a25 DATE
185 , p8_a26 DATE
186 , p8_a27 VARCHAR2
187 , p8_a28 NUMBER
188 , p8_a29 VARCHAR2
189 , p8_a30 VARCHAR2
190 , p8_a31 NUMBER
191 , p8_a32 VARCHAR2
192 , p8_a33 VARCHAR2
193 , p8_a34 VARCHAR2
194 , p8_a35 NUMBER
195 , p8_a36 VARCHAR2
196 , p8_a37 NUMBER
197 , p8_a38 NUMBER
198 , p8_a39 NUMBER
199 , p8_a40 VARCHAR2
200 , p8_a41 VARCHAR2
201 , p8_a42 VARCHAR2
202 , p8_a43 DATE
203 , p8_a44 NUMBER
204 , p8_a45 DATE
205 , p8_a46 NUMBER
206 , p8_a47 DATE
207 , p8_a48 NUMBER
208 , p8_a49 VARCHAR2
209 , p8_a50 VARCHAR2
210 , p8_a51 VARCHAR2
211 , p8_a52 VARCHAR2
212 , p8_a53 VARCHAR2
213 , p8_a54 VARCHAR2
214 , p8_a55 VARCHAR2
215 , p8_a56 VARCHAR2
216 , p8_a57 VARCHAR2
217 , p8_a58 VARCHAR2
218 , p8_a59 VARCHAR2
219 , p8_a60 VARCHAR2
220 , p8_a61 VARCHAR2
221 , p8_a62 VARCHAR2
222 , p8_a63 VARCHAR2
223 , p8_a64 VARCHAR2
224 , p9_a0 out nocopy JTF_NUMBER_TABLE
225 , p9_a1 out nocopy JTF_NUMBER_TABLE
226 , p9_a2 out nocopy JTF_NUMBER_TABLE
227 , p9_a3 out nocopy JTF_NUMBER_TABLE
228 , p9_a4 out nocopy JTF_NUMBER_TABLE
229 , p9_a5 out nocopy JTF_NUMBER_TABLE
230 , p9_a6 out nocopy JTF_NUMBER_TABLE
231 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
232 , p9_a8 out nocopy JTF_NUMBER_TABLE
233 , p9_a9 out nocopy JTF_NUMBER_TABLE
234 , p9_a10 out nocopy JTF_NUMBER_TABLE
235 , p9_a11 out nocopy JTF_NUMBER_TABLE
236 , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
237 , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
238 , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
239 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
240 , p9_a16 out nocopy JTF_NUMBER_TABLE
241 , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
242 , p9_a18 out nocopy JTF_NUMBER_TABLE
243 , p9_a19 out nocopy JTF_NUMBER_TABLE
244 , p9_a20 out nocopy JTF_NUMBER_TABLE
245 , p9_a21 out nocopy JTF_DATE_TABLE
246 , p9_a22 out nocopy JTF_DATE_TABLE
247 , p9_a23 out nocopy JTF_DATE_TABLE
248 , p9_a24 out nocopy JTF_DATE_TABLE
249 , p9_a25 out nocopy JTF_DATE_TABLE
250 , p9_a26 out nocopy JTF_DATE_TABLE
251 , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
252 , p9_a28 out nocopy JTF_NUMBER_TABLE
253 , p9_a29 out nocopy JTF_VARCHAR2_TABLE_100
254 , p9_a30 out nocopy JTF_VARCHAR2_TABLE_2000
255 , p9_a31 out nocopy JTF_NUMBER_TABLE
256 , p9_a32 out nocopy JTF_VARCHAR2_TABLE_400
257 , p9_a33 out nocopy JTF_VARCHAR2_TABLE_300
258 , p9_a34 out nocopy JTF_VARCHAR2_TABLE_300
259 , p9_a35 out nocopy JTF_NUMBER_TABLE
260 , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
261 , p9_a37 out nocopy JTF_NUMBER_TABLE
262 , p9_a38 out nocopy JTF_NUMBER_TABLE
263 , p9_a39 out nocopy JTF_NUMBER_TABLE
264 , p9_a40 out nocopy JTF_VARCHAR2_TABLE_100
265 , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100
266 , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
267 , p9_a43 out nocopy JTF_DATE_TABLE
268 , p9_a44 out nocopy JTF_NUMBER_TABLE
269 , p9_a45 out nocopy JTF_DATE_TABLE
270 , p9_a46 out nocopy JTF_NUMBER_TABLE
271 , p9_a47 out nocopy JTF_DATE_TABLE
272 , p9_a48 out nocopy JTF_NUMBER_TABLE
273 , p9_a49 out nocopy JTF_VARCHAR2_TABLE_100
274 , p9_a50 out nocopy JTF_VARCHAR2_TABLE_200
275 , p9_a51 out nocopy JTF_VARCHAR2_TABLE_200
276 , p9_a52 out nocopy JTF_VARCHAR2_TABLE_200
277 , p9_a53 out nocopy JTF_VARCHAR2_TABLE_200
278 , p9_a54 out nocopy JTF_VARCHAR2_TABLE_200
279 , p9_a55 out nocopy JTF_VARCHAR2_TABLE_200
280 , p9_a56 out nocopy JTF_VARCHAR2_TABLE_200
281 , p9_a57 out nocopy JTF_VARCHAR2_TABLE_200
282 , p9_a58 out nocopy JTF_VARCHAR2_TABLE_200
283 , p9_a59 out nocopy JTF_VARCHAR2_TABLE_200
284 , p9_a60 out nocopy JTF_VARCHAR2_TABLE_200
285 , p9_a61 out nocopy JTF_VARCHAR2_TABLE_200
286 , p9_a62 out nocopy JTF_VARCHAR2_TABLE_200
287 , p9_a63 out nocopy JTF_VARCHAR2_TABLE_200
288 , p9_a64 out nocopy JTF_VARCHAR2_TABLE_200
289 );
290 procedure get_mr_cost_details(p_api_version NUMBER
291 , p_init_msg_list VARCHAR2
292 , p_commit VARCHAR2
293 , p_validation_level NUMBER
294 , p_module_type VARCHAR2
295 , p5_a0 in out nocopy NUMBER
296 , p5_a1 in out nocopy NUMBER
297 , p5_a2 in out nocopy NUMBER
298 , p5_a3 in out nocopy NUMBER
299 , p5_a4 in out nocopy NUMBER
300 , p5_a5 in out nocopy NUMBER
301 , p5_a6 in out nocopy NUMBER
302 , p5_a7 in out nocopy VARCHAR2
303 , p5_a8 in out nocopy NUMBER
304 , p5_a9 in out nocopy NUMBER
305 , p5_a10 in out nocopy NUMBER
306 , p5_a11 in out nocopy NUMBER
307 , p5_a12 in out nocopy VARCHAR2
308 , p5_a13 in out nocopy VARCHAR2
309 , p5_a14 in out nocopy VARCHAR2
310 , p5_a15 in out nocopy VARCHAR2
311 , p5_a16 in out nocopy NUMBER
312 , p5_a17 in out nocopy VARCHAR2
313 , p5_a18 in out nocopy NUMBER
314 , p5_a19 in out nocopy NUMBER
315 , p5_a20 in out nocopy NUMBER
316 , p5_a21 in out nocopy DATE
317 , p5_a22 in out nocopy DATE
318 , p5_a23 in out nocopy DATE
319 , p5_a24 in out nocopy DATE
320 , p5_a25 in out nocopy DATE
321 , p5_a26 in out nocopy DATE
322 , p5_a27 in out nocopy VARCHAR2
323 , p5_a28 in out nocopy NUMBER
324 , p5_a29 in out nocopy VARCHAR2
325 , p5_a30 in out nocopy VARCHAR2
326 , p5_a31 in out nocopy NUMBER
327 , p5_a32 in out nocopy VARCHAR2
328 , p5_a33 in out nocopy VARCHAR2
329 , p5_a34 in out nocopy VARCHAR2
330 , p5_a35 in out nocopy NUMBER
331 , p5_a36 in out nocopy VARCHAR2
332 , p5_a37 in out nocopy NUMBER
333 , p5_a38 in out nocopy NUMBER
334 , p5_a39 in out nocopy NUMBER
335 , p5_a40 in out nocopy VARCHAR2
336 , p5_a41 in out nocopy VARCHAR2
337 , p5_a42 in out nocopy VARCHAR2
338 , p5_a43 in out nocopy DATE
339 , p5_a44 in out nocopy NUMBER
340 , p5_a45 in out nocopy DATE
341 , p5_a46 in out nocopy NUMBER
342 , p5_a47 in out nocopy DATE
343 , p5_a48 in out nocopy NUMBER
344 , p5_a49 in out nocopy VARCHAR2
345 , p5_a50 in out nocopy VARCHAR2
346 , p5_a51 in out nocopy VARCHAR2
347 , p5_a52 in out nocopy VARCHAR2
348 , p5_a53 in out nocopy VARCHAR2
349 , p5_a54 in out nocopy VARCHAR2
350 , p5_a55 in out nocopy VARCHAR2
351 , p5_a56 in out nocopy VARCHAR2
352 , p5_a57 in out nocopy VARCHAR2
353 , p5_a58 in out nocopy VARCHAR2
354 , p5_a59 in out nocopy VARCHAR2
355 , p5_a60 in out nocopy VARCHAR2
356 , p5_a61 in out nocopy VARCHAR2
357 , p5_a62 in out nocopy VARCHAR2
358 , p5_a63 in out nocopy VARCHAR2
359 , p5_a64 in out nocopy VARCHAR2
360 , x_return_status out nocopy VARCHAR2
361 , x_msg_count out nocopy NUMBER
362 , x_msg_data out nocopy VARCHAR2
363 );
364 end ahl_vwp_mr_cst_pr_pvt_w;