[Home] [Help]
PACKAGE: APPS.OKL_AM_CREATE_QUOTE_PVT_W
Source
1 package okl_am_create_quote_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLECQTS.pls 120.4 2007/11/02 21:03:24 rmunjulu ship $ */
3 procedure rosetta_table_copy_in_p17(t out nocopy okl_am_create_quote_pvt.assn_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_200
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_VARCHAR2_TABLE_200
8 );
9 procedure rosetta_table_copy_out_p17(t okl_am_create_quote_pvt.assn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10 , a1 out nocopy JTF_VARCHAR2_TABLE_200
11 , a2 out nocopy JTF_NUMBER_TABLE
12 , a3 out nocopy JTF_NUMBER_TABLE
13 , a4 out nocopy JTF_VARCHAR2_TABLE_200
14 );
15
16 procedure rosetta_table_copy_in_p19(t out nocopy okl_am_create_quote_pvt.achr_tbl_type, a0 JTF_VARCHAR2_TABLE_200
17 , a1 JTF_VARCHAR2_TABLE_100
18 , a2 JTF_NUMBER_TABLE
19 , a3 JTF_VARCHAR2_TABLE_200
20 , a4 JTF_DATE_TABLE
21 , a5 JTF_DATE_TABLE
22 , a6 JTF_DATE_TABLE
23 , a7 JTF_DATE_TABLE
24 , a8 JTF_VARCHAR2_TABLE_100
25 , a9 JTF_VARCHAR2_TABLE_100
26 , a10 JTF_NUMBER_TABLE
27 , a11 JTF_VARCHAR2_TABLE_400
28 );
29 procedure rosetta_table_copy_out_p19(t okl_am_create_quote_pvt.achr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
30 , a1 out nocopy JTF_VARCHAR2_TABLE_100
31 , a2 out nocopy JTF_NUMBER_TABLE
32 , a3 out nocopy JTF_VARCHAR2_TABLE_200
33 , a4 out nocopy JTF_DATE_TABLE
34 , a5 out nocopy JTF_DATE_TABLE
35 , a6 out nocopy JTF_DATE_TABLE
36 , a7 out nocopy JTF_DATE_TABLE
37 , a8 out nocopy JTF_VARCHAR2_TABLE_100
38 , a9 out nocopy JTF_VARCHAR2_TABLE_100
39 , a10 out nocopy JTF_NUMBER_TABLE
40 , a11 out nocopy JTF_VARCHAR2_TABLE_400
41 );
42
43 procedure advance_contract_search(p_api_version NUMBER
44 , p_init_msg_list VARCHAR2
45 , x_return_status out nocopy VARCHAR2
46 , x_msg_count out nocopy NUMBER
47 , x_msg_data out nocopy VARCHAR2
48 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_200
49 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
50 , p6_a2 out nocopy JTF_NUMBER_TABLE
51 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
52 , p6_a4 out nocopy JTF_DATE_TABLE
53 , p6_a5 out nocopy JTF_DATE_TABLE
54 , p6_a6 out nocopy JTF_DATE_TABLE
55 , p6_a7 out nocopy JTF_DATE_TABLE
56 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
57 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
58 , p6_a10 out nocopy JTF_NUMBER_TABLE
59 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_400
60 , p5_a0 VARCHAR2 := fnd_api.g_miss_char
61 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
62 , p5_a2 NUMBER := 0-1962.0724
63 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
64 , p5_a4 DATE := fnd_api.g_miss_date
65 , p5_a5 DATE := fnd_api.g_miss_date
66 , p5_a6 DATE := fnd_api.g_miss_date
67 , p5_a7 DATE := fnd_api.g_miss_date
68 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
69 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
70 , p5_a10 NUMBER := 0-1962.0724
71 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
72 );
73 procedure quote_effectivity(p_rule_chr_id NUMBER
74 , x_quote_eff_days out nocopy NUMBER
75 , x_quote_eff_max_days out nocopy NUMBER
76 , x_return_status out nocopy VARCHAR2
77 , p0_a0 NUMBER := 0-1962.0724
78 , p0_a1 NUMBER := 0-1962.0724
79 , p0_a2 VARCHAR2 := fnd_api.g_miss_char
80 , p0_a3 VARCHAR2 := fnd_api.g_miss_char
81 , p0_a4 VARCHAR2 := fnd_api.g_miss_char
82 , p0_a5 VARCHAR2 := fnd_api.g_miss_char
83 , p0_a6 VARCHAR2 := fnd_api.g_miss_char
84 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
85 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
86 , p0_a9 NUMBER := 0-1962.0724
87 , p0_a10 NUMBER := 0-1962.0724
88 , p0_a11 NUMBER := 0-1962.0724
89 , p0_a12 NUMBER := 0-1962.0724
90 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
91 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
92 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
93 , p0_a16 DATE := fnd_api.g_miss_date
94 , p0_a17 DATE := fnd_api.g_miss_date
95 , p0_a18 DATE := fnd_api.g_miss_date
96 , p0_a19 DATE := fnd_api.g_miss_date
97 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
98 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
99 , p0_a22 NUMBER := 0-1962.0724
100 , p0_a23 NUMBER := 0-1962.0724
101 , p0_a24 NUMBER := 0-1962.0724
102 , p0_a25 NUMBER := 0-1962.0724
103 , p0_a26 DATE := fnd_api.g_miss_date
104 , p0_a27 DATE := fnd_api.g_miss_date
105 , p0_a28 NUMBER := 0-1962.0724
106 , p0_a29 NUMBER := 0-1962.0724
107 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
108 , p0_a31 DATE := fnd_api.g_miss_date
109 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
110 , p0_a33 NUMBER := 0-1962.0724
111 , p0_a34 DATE := fnd_api.g_miss_date
112 , p0_a35 NUMBER := 0-1962.0724
113 , p0_a36 NUMBER := 0-1962.0724
114 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
115 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
116 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
117 , p0_a40 DATE := fnd_api.g_miss_date
118 , p0_a41 VARCHAR2 := fnd_api.g_miss_char
119 , p0_a42 VARCHAR2 := fnd_api.g_miss_char
120 , p0_a43 VARCHAR2 := fnd_api.g_miss_char
121 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
122 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
123 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
124 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
125 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
126 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
127 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
128 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
129 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
130 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
131 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
132 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
133 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
134 , p0_a57 DATE := fnd_api.g_miss_date
135 , p0_a58 NUMBER := 0-1962.0724
136 , p0_a59 NUMBER := 0-1962.0724
137 , p0_a60 NUMBER := 0-1962.0724
138 , p0_a61 NUMBER := 0-1962.0724
139 , p0_a62 NUMBER := 0-1962.0724
140 , p0_a63 DATE := fnd_api.g_miss_date
141 , p0_a64 NUMBER := 0-1962.0724
142 , p0_a65 DATE := fnd_api.g_miss_date
143 , p0_a66 NUMBER := 0-1962.0724
144 , p0_a67 DATE := fnd_api.g_miss_date
145 , p0_a68 NUMBER := 0-1962.0724
146 , p0_a69 NUMBER := 0-1962.0724
147 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
148 , p0_a71 NUMBER := 0-1962.0724
149 , p0_a72 NUMBER := 0-1962.0724
150 , p0_a73 NUMBER := 0-1962.0724
151 , p0_a74 NUMBER := 0-1962.0724
152 , p0_a75 NUMBER := 0-1962.0724
153 , p0_a76 VARCHAR2 := fnd_api.g_miss_char
154 , p0_a77 VARCHAR2 := fnd_api.g_miss_char
155 , p0_a78 VARCHAR2 := fnd_api.g_miss_char
156 , p0_a79 NUMBER := 0-1962.0724
157 , p0_a80 DATE := fnd_api.g_miss_date
158 , p0_a81 NUMBER := 0-1962.0724
159 , p0_a82 VARCHAR2 := fnd_api.g_miss_char
160 );
161 procedure create_terminate_quote(p_api_version NUMBER
162 , p_init_msg_list VARCHAR2
163 , x_return_status out nocopy VARCHAR2
164 , x_msg_count out nocopy NUMBER
165 , x_msg_data out nocopy VARCHAR2
166 , p6_a0 JTF_NUMBER_TABLE
167 , p6_a1 JTF_VARCHAR2_TABLE_200
168 , p6_a2 JTF_NUMBER_TABLE
169 , p6_a3 JTF_NUMBER_TABLE
170 , p6_a4 JTF_VARCHAR2_TABLE_200
171 , p7_a0 JTF_NUMBER_TABLE
172 , p7_a1 JTF_NUMBER_TABLE
173 , p7_a2 JTF_NUMBER_TABLE
174 , p7_a3 JTF_NUMBER_TABLE
175 , p7_a4 JTF_DATE_TABLE
176 , p7_a5 JTF_VARCHAR2_TABLE_100
177 , p7_a6 JTF_NUMBER_TABLE
178 , p7_a7 JTF_NUMBER_TABLE
179 , p7_a8 JTF_VARCHAR2_TABLE_600
180 , p7_a9 JTF_VARCHAR2_TABLE_100
181 , p7_a10 JTF_VARCHAR2_TABLE_100
182 , p7_a11 JTF_VARCHAR2_TABLE_200
183 , p7_a12 JTF_VARCHAR2_TABLE_100
184 , p7_a13 JTF_VARCHAR2_TABLE_100
185 , p7_a14 JTF_VARCHAR2_TABLE_200
186 , p7_a15 JTF_NUMBER_TABLE
187 , p7_a16 JTF_DATE_TABLE
188 , p7_a17 JTF_NUMBER_TABLE
189 , p7_a18 JTF_DATE_TABLE
190 , p7_a19 JTF_NUMBER_TABLE
191 , p8_a0 out nocopy NUMBER
192 , p8_a1 out nocopy NUMBER
193 , p8_a2 out nocopy VARCHAR2
194 , p8_a3 out nocopy VARCHAR2
195 , p8_a4 out nocopy VARCHAR2
196 , p8_a5 out nocopy VARCHAR2
197 , p8_a6 out nocopy VARCHAR2
198 , p8_a7 out nocopy VARCHAR2
199 , p8_a8 out nocopy VARCHAR2
200 , p8_a9 out nocopy NUMBER
201 , p8_a10 out nocopy NUMBER
202 , p8_a11 out nocopy NUMBER
203 , p8_a12 out nocopy NUMBER
204 , p8_a13 out nocopy VARCHAR2
205 , p8_a14 out nocopy VARCHAR2
206 , p8_a15 out nocopy VARCHAR2
207 , p8_a16 out nocopy DATE
208 , p8_a17 out nocopy DATE
209 , p8_a18 out nocopy DATE
210 , p8_a19 out nocopy DATE
211 , p8_a20 out nocopy VARCHAR2
212 , p8_a21 out nocopy VARCHAR2
213 , p8_a22 out nocopy NUMBER
214 , p8_a23 out nocopy NUMBER
215 , p8_a24 out nocopy NUMBER
216 , p8_a25 out nocopy NUMBER
217 , p8_a26 out nocopy DATE
218 , p8_a27 out nocopy DATE
219 , p8_a28 out nocopy NUMBER
220 , p8_a29 out nocopy NUMBER
221 , p8_a30 out nocopy VARCHAR2
222 , p8_a31 out nocopy DATE
223 , p8_a32 out nocopy VARCHAR2
224 , p8_a33 out nocopy NUMBER
225 , p8_a34 out nocopy DATE
226 , p8_a35 out nocopy NUMBER
227 , p8_a36 out nocopy NUMBER
228 , p8_a37 out nocopy VARCHAR2
229 , p8_a38 out nocopy VARCHAR2
230 , p8_a39 out nocopy VARCHAR2
231 , p8_a40 out nocopy DATE
232 , p8_a41 out nocopy VARCHAR2
233 , p8_a42 out nocopy VARCHAR2
234 , p8_a43 out nocopy VARCHAR2
235 , p8_a44 out nocopy VARCHAR2
236 , p8_a45 out nocopy VARCHAR2
237 , p8_a46 out nocopy VARCHAR2
238 , p8_a47 out nocopy VARCHAR2
239 , p8_a48 out nocopy VARCHAR2
240 , p8_a49 out nocopy VARCHAR2
241 , p8_a50 out nocopy VARCHAR2
242 , p8_a51 out nocopy VARCHAR2
243 , p8_a52 out nocopy VARCHAR2
244 , p8_a53 out nocopy VARCHAR2
245 , p8_a54 out nocopy VARCHAR2
246 , p8_a55 out nocopy VARCHAR2
247 , p8_a56 out nocopy VARCHAR2
248 , p8_a57 out nocopy DATE
249 , p8_a58 out nocopy NUMBER
250 , p8_a59 out nocopy NUMBER
251 , p8_a60 out nocopy NUMBER
252 , p8_a61 out nocopy NUMBER
253 , p8_a62 out nocopy NUMBER
254 , p8_a63 out nocopy DATE
255 , p8_a64 out nocopy NUMBER
256 , p8_a65 out nocopy DATE
257 , p8_a66 out nocopy NUMBER
258 , p8_a67 out nocopy DATE
259 , p8_a68 out nocopy NUMBER
260 , p8_a69 out nocopy NUMBER
261 , p8_a70 out nocopy VARCHAR2
262 , p8_a71 out nocopy NUMBER
263 , p8_a72 out nocopy NUMBER
264 , p8_a73 out nocopy NUMBER
265 , p8_a74 out nocopy NUMBER
266 , p8_a75 out nocopy NUMBER
267 , p8_a76 out nocopy VARCHAR2
268 , p8_a77 out nocopy VARCHAR2
269 , p8_a78 out nocopy VARCHAR2
270 , p8_a79 out nocopy NUMBER
271 , p8_a80 out nocopy DATE
272 , p8_a81 out nocopy NUMBER
273 , p8_a82 out nocopy VARCHAR2
274 , p9_a0 out nocopy JTF_NUMBER_TABLE
275 , p9_a1 out nocopy JTF_NUMBER_TABLE
276 , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
277 , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
278 , p9_a4 out nocopy JTF_NUMBER_TABLE
279 , p9_a5 out nocopy JTF_NUMBER_TABLE
280 , p9_a6 out nocopy JTF_NUMBER_TABLE
281 , p9_a7 out nocopy JTF_NUMBER_TABLE
282 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000
283 , p9_a9 out nocopy JTF_NUMBER_TABLE
284 , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
285 , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
286 , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
287 , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
288 , p9_a14 out nocopy JTF_VARCHAR2_TABLE_500
289 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_500
290 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_500
291 , p9_a17 out nocopy JTF_VARCHAR2_TABLE_500
292 , p9_a18 out nocopy JTF_VARCHAR2_TABLE_500
293 , p9_a19 out nocopy JTF_VARCHAR2_TABLE_500
294 , p9_a20 out nocopy JTF_VARCHAR2_TABLE_500
295 , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
296 , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
297 , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
298 , p9_a24 out nocopy JTF_VARCHAR2_TABLE_500
299 , p9_a25 out nocopy JTF_VARCHAR2_TABLE_500
300 , p9_a26 out nocopy JTF_VARCHAR2_TABLE_500
301 , p9_a27 out nocopy JTF_VARCHAR2_TABLE_500
302 , p9_a28 out nocopy JTF_VARCHAR2_TABLE_500
303 , p9_a29 out nocopy JTF_NUMBER_TABLE
304 , p9_a30 out nocopy JTF_NUMBER_TABLE
305 , p9_a31 out nocopy JTF_NUMBER_TABLE
306 , p9_a32 out nocopy JTF_NUMBER_TABLE
307 , p9_a33 out nocopy JTF_DATE_TABLE
308 , p9_a34 out nocopy JTF_NUMBER_TABLE
309 , p9_a35 out nocopy JTF_DATE_TABLE
310 , p9_a36 out nocopy JTF_NUMBER_TABLE
311 , p9_a37 out nocopy JTF_DATE_TABLE
312 , p9_a38 out nocopy JTF_NUMBER_TABLE
313 , p9_a39 out nocopy JTF_DATE_TABLE
314 , p9_a40 out nocopy JTF_VARCHAR2_TABLE_100
315 , p9_a41 out nocopy JTF_NUMBER_TABLE
316 , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
317 , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100
318 , p9_a44 out nocopy JTF_VARCHAR2_TABLE_200
319 , p9_a45 out nocopy JTF_NUMBER_TABLE
320 , p9_a46 out nocopy JTF_NUMBER_TABLE
321 , p9_a47 out nocopy JTF_NUMBER_TABLE
322 , p9_a48 out nocopy JTF_NUMBER_TABLE
323 , p9_a49 out nocopy JTF_NUMBER_TABLE
324 , p9_a50 out nocopy JTF_NUMBER_TABLE
325 , p9_a51 out nocopy JTF_NUMBER_TABLE
326 , p9_a52 out nocopy JTF_NUMBER_TABLE
327 , p9_a53 out nocopy JTF_VARCHAR2_TABLE_200
328 , p9_a54 out nocopy JTF_VARCHAR2_TABLE_100
329 , p9_a55 out nocopy JTF_VARCHAR2_TABLE_100
330 , p9_a56 out nocopy JTF_VARCHAR2_TABLE_100
331 , p9_a57 out nocopy JTF_NUMBER_TABLE
332 , p9_a58 out nocopy JTF_DATE_TABLE
333 , p9_a59 out nocopy JTF_DATE_TABLE
334 , p9_a60 out nocopy JTF_NUMBER_TABLE
335 , p10_a0 out nocopy JTF_NUMBER_TABLE
336 , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
337 , p10_a2 out nocopy JTF_NUMBER_TABLE
338 , p10_a3 out nocopy JTF_NUMBER_TABLE
339 , p10_a4 out nocopy JTF_VARCHAR2_TABLE_200
340 , p5_a0 NUMBER := 0-1962.0724
341 , p5_a1 NUMBER := 0-1962.0724
342 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
343 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
344 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
345 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
346 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
347 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
348 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
349 , p5_a9 NUMBER := 0-1962.0724
350 , p5_a10 NUMBER := 0-1962.0724
351 , p5_a11 NUMBER := 0-1962.0724
352 , p5_a12 NUMBER := 0-1962.0724
353 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
354 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
355 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
356 , p5_a16 DATE := fnd_api.g_miss_date
357 , p5_a17 DATE := fnd_api.g_miss_date
358 , p5_a18 DATE := fnd_api.g_miss_date
359 , p5_a19 DATE := fnd_api.g_miss_date
360 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
361 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
362 , p5_a22 NUMBER := 0-1962.0724
363 , p5_a23 NUMBER := 0-1962.0724
364 , p5_a24 NUMBER := 0-1962.0724
365 , p5_a25 NUMBER := 0-1962.0724
366 , p5_a26 DATE := fnd_api.g_miss_date
367 , p5_a27 DATE := fnd_api.g_miss_date
368 , p5_a28 NUMBER := 0-1962.0724
369 , p5_a29 NUMBER := 0-1962.0724
370 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
371 , p5_a31 DATE := fnd_api.g_miss_date
372 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
373 , p5_a33 NUMBER := 0-1962.0724
374 , p5_a34 DATE := fnd_api.g_miss_date
375 , p5_a35 NUMBER := 0-1962.0724
376 , p5_a36 NUMBER := 0-1962.0724
377 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
378 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
379 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
380 , p5_a40 DATE := fnd_api.g_miss_date
381 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
382 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
383 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
384 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
385 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
386 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
387 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
388 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
389 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
390 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
391 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
392 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
393 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
394 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
395 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
396 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
397 , p5_a57 DATE := fnd_api.g_miss_date
398 , p5_a58 NUMBER := 0-1962.0724
399 , p5_a59 NUMBER := 0-1962.0724
400 , p5_a60 NUMBER := 0-1962.0724
401 , p5_a61 NUMBER := 0-1962.0724
402 , p5_a62 NUMBER := 0-1962.0724
403 , p5_a63 DATE := fnd_api.g_miss_date
404 , p5_a64 NUMBER := 0-1962.0724
405 , p5_a65 DATE := fnd_api.g_miss_date
406 , p5_a66 NUMBER := 0-1962.0724
407 , p5_a67 DATE := fnd_api.g_miss_date
408 , p5_a68 NUMBER := 0-1962.0724
409 , p5_a69 NUMBER := 0-1962.0724
410 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
411 , p5_a71 NUMBER := 0-1962.0724
412 , p5_a72 NUMBER := 0-1962.0724
413 , p5_a73 NUMBER := 0-1962.0724
414 , p5_a74 NUMBER := 0-1962.0724
415 , p5_a75 NUMBER := 0-1962.0724
416 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
417 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
418 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
419 , p5_a79 NUMBER := 0-1962.0724
420 , p5_a80 DATE := fnd_api.g_miss_date
421 , p5_a81 NUMBER := 0-1962.0724
422 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
423 );
424 procedure get_net_gain_loss(p_chr_id NUMBER
425 , x_return_status out nocopy VARCHAR2
426 , x_net_gain_loss out nocopy NUMBER
427 , p0_a0 NUMBER := 0-1962.0724
428 , p0_a1 NUMBER := 0-1962.0724
429 , p0_a2 VARCHAR2 := fnd_api.g_miss_char
430 , p0_a3 VARCHAR2 := fnd_api.g_miss_char
431 , p0_a4 VARCHAR2 := fnd_api.g_miss_char
432 , p0_a5 VARCHAR2 := fnd_api.g_miss_char
433 , p0_a6 VARCHAR2 := fnd_api.g_miss_char
434 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
435 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
436 , p0_a9 NUMBER := 0-1962.0724
437 , p0_a10 NUMBER := 0-1962.0724
438 , p0_a11 NUMBER := 0-1962.0724
439 , p0_a12 NUMBER := 0-1962.0724
440 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
441 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
442 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
443 , p0_a16 DATE := fnd_api.g_miss_date
444 , p0_a17 DATE := fnd_api.g_miss_date
445 , p0_a18 DATE := fnd_api.g_miss_date
446 , p0_a19 DATE := fnd_api.g_miss_date
447 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
448 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
449 , p0_a22 NUMBER := 0-1962.0724
450 , p0_a23 NUMBER := 0-1962.0724
451 , p0_a24 NUMBER := 0-1962.0724
452 , p0_a25 NUMBER := 0-1962.0724
453 , p0_a26 DATE := fnd_api.g_miss_date
454 , p0_a27 DATE := fnd_api.g_miss_date
455 , p0_a28 NUMBER := 0-1962.0724
456 , p0_a29 NUMBER := 0-1962.0724
457 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
458 , p0_a31 DATE := fnd_api.g_miss_date
459 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
460 , p0_a33 NUMBER := 0-1962.0724
461 , p0_a34 DATE := fnd_api.g_miss_date
462 , p0_a35 NUMBER := 0-1962.0724
463 , p0_a36 NUMBER := 0-1962.0724
464 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
465 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
466 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
467 , p0_a40 DATE := fnd_api.g_miss_date
468 , p0_a41 VARCHAR2 := fnd_api.g_miss_char
469 , p0_a42 VARCHAR2 := fnd_api.g_miss_char
470 , p0_a43 VARCHAR2 := fnd_api.g_miss_char
471 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
472 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
473 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
474 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
475 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
476 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
477 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
478 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
479 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
480 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
481 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
482 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
483 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
484 , p0_a57 DATE := fnd_api.g_miss_date
485 , p0_a58 NUMBER := 0-1962.0724
486 , p0_a59 NUMBER := 0-1962.0724
487 , p0_a60 NUMBER := 0-1962.0724
488 , p0_a61 NUMBER := 0-1962.0724
489 , p0_a62 NUMBER := 0-1962.0724
490 , p0_a63 DATE := fnd_api.g_miss_date
491 , p0_a64 NUMBER := 0-1962.0724
492 , p0_a65 DATE := fnd_api.g_miss_date
493 , p0_a66 NUMBER := 0-1962.0724
494 , p0_a67 DATE := fnd_api.g_miss_date
495 , p0_a68 NUMBER := 0-1962.0724
496 , p0_a69 NUMBER := 0-1962.0724
497 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
498 , p0_a71 NUMBER := 0-1962.0724
499 , p0_a72 NUMBER := 0-1962.0724
500 , p0_a73 NUMBER := 0-1962.0724
501 , p0_a74 NUMBER := 0-1962.0724
502 , p0_a75 NUMBER := 0-1962.0724
503 , p0_a76 VARCHAR2 := fnd_api.g_miss_char
504 , p0_a77 VARCHAR2 := fnd_api.g_miss_char
505 , p0_a78 VARCHAR2 := fnd_api.g_miss_char
506 , p0_a79 NUMBER := 0-1962.0724
507 , p0_a80 DATE := fnd_api.g_miss_date
508 , p0_a81 NUMBER := 0-1962.0724
509 , p0_a82 VARCHAR2 := fnd_api.g_miss_char
510 );
511 end okl_am_create_quote_pvt_w;