eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AHL_VWP_MR_CST_PR_PVT_W

Source


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