[Home] [Help]
PACKAGE: APPS.OKL_LEASE_OPPORTUNITY_PVT_W
Source
1 package okl_lease_opportunity_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLELOPS.pls 120.5 2007/03/20 22:38:01 rravikir noship $ */
3 procedure create_lease_opp(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_transaction_control VARCHAR2
6 , p3_a0 NUMBER
7 , p3_a1 NUMBER
8 , p3_a2 VARCHAR2
9 , p3_a3 VARCHAR2
10 , p3_a4 VARCHAR2
11 , p3_a5 VARCHAR2
12 , p3_a6 VARCHAR2
13 , p3_a7 VARCHAR2
14 , p3_a8 VARCHAR2
15 , p3_a9 VARCHAR2
16 , p3_a10 VARCHAR2
17 , p3_a11 VARCHAR2
18 , p3_a12 VARCHAR2
19 , p3_a13 VARCHAR2
20 , p3_a14 VARCHAR2
21 , p3_a15 VARCHAR2
22 , p3_a16 VARCHAR2
23 , p3_a17 VARCHAR2
24 , p3_a18 VARCHAR2
25 , p3_a19 VARCHAR2
26 , p3_a20 DATE
27 , p3_a21 DATE
28 , p3_a22 NUMBER
29 , p3_a23 NUMBER
30 , p3_a24 NUMBER
31 , p3_a25 NUMBER
32 , p3_a26 NUMBER
33 , p3_a27 VARCHAR2
34 , p3_a28 VARCHAR2
35 , p3_a29 NUMBER
36 , p3_a30 DATE
37 , p3_a31 NUMBER
38 , p3_a32 NUMBER
39 , p3_a33 NUMBER
40 , p3_a34 NUMBER
41 , p3_a35 NUMBER
42 , p3_a36 DATE
43 , p3_a37 DATE
44 , p3_a38 VARCHAR2
45 , p3_a39 VARCHAR2
46 , p3_a40 VARCHAR2
47 , p3_a41 NUMBER
48 , p3_a42 VARCHAR2
49 , p3_a43 VARCHAR2
50 , p3_a44 VARCHAR2
51 , p3_a45 NUMBER
52 , p3_a46 NUMBER
53 , p3_a47 NUMBER
54 , p3_a48 NUMBER
55 , p3_a49 VARCHAR2
56 , p3_a50 VARCHAR2
57 , p3_a51 VARCHAR2
58 , p3_a52 VARCHAR2
59 , p_quick_quote_id NUMBER
60 , p5_a0 out nocopy NUMBER
61 , p5_a1 out nocopy NUMBER
62 , p5_a2 out nocopy VARCHAR2
63 , p5_a3 out nocopy VARCHAR2
64 , p5_a4 out nocopy VARCHAR2
65 , p5_a5 out nocopy VARCHAR2
66 , p5_a6 out nocopy VARCHAR2
67 , p5_a7 out nocopy VARCHAR2
68 , p5_a8 out nocopy VARCHAR2
69 , p5_a9 out nocopy VARCHAR2
70 , p5_a10 out nocopy VARCHAR2
71 , p5_a11 out nocopy VARCHAR2
72 , p5_a12 out nocopy VARCHAR2
73 , p5_a13 out nocopy VARCHAR2
74 , p5_a14 out nocopy VARCHAR2
75 , p5_a15 out nocopy VARCHAR2
76 , p5_a16 out nocopy VARCHAR2
77 , p5_a17 out nocopy VARCHAR2
78 , p5_a18 out nocopy VARCHAR2
79 , p5_a19 out nocopy VARCHAR2
80 , p5_a20 out nocopy DATE
81 , p5_a21 out nocopy DATE
82 , p5_a22 out nocopy NUMBER
83 , p5_a23 out nocopy NUMBER
84 , p5_a24 out nocopy NUMBER
85 , p5_a25 out nocopy NUMBER
86 , p5_a26 out nocopy NUMBER
87 , p5_a27 out nocopy VARCHAR2
88 , p5_a28 out nocopy VARCHAR2
89 , p5_a29 out nocopy NUMBER
90 , p5_a30 out nocopy DATE
91 , p5_a31 out nocopy NUMBER
92 , p5_a32 out nocopy NUMBER
93 , p5_a33 out nocopy NUMBER
94 , p5_a34 out nocopy NUMBER
95 , p5_a35 out nocopy NUMBER
96 , p5_a36 out nocopy DATE
97 , p5_a37 out nocopy DATE
98 , p5_a38 out nocopy VARCHAR2
99 , p5_a39 out nocopy VARCHAR2
100 , p5_a40 out nocopy VARCHAR2
101 , p5_a41 out nocopy NUMBER
102 , p5_a42 out nocopy VARCHAR2
103 , p5_a43 out nocopy VARCHAR2
104 , p5_a44 out nocopy VARCHAR2
105 , p5_a45 out nocopy NUMBER
106 , p5_a46 out nocopy NUMBER
107 , p5_a47 out nocopy NUMBER
108 , p5_a48 out nocopy NUMBER
109 , p5_a49 out nocopy VARCHAR2
110 , p5_a50 out nocopy VARCHAR2
111 , p5_a51 out nocopy VARCHAR2
112 , p5_a52 out nocopy VARCHAR2
113 , x_return_status out nocopy VARCHAR2
114 , x_msg_count out nocopy NUMBER
115 , x_msg_data out nocopy VARCHAR2
116 );
117 procedure update_lease_opp(p_api_version NUMBER
118 , p_init_msg_list VARCHAR2
119 , p_transaction_control VARCHAR2
120 , p3_a0 NUMBER
121 , p3_a1 NUMBER
122 , p3_a2 VARCHAR2
123 , p3_a3 VARCHAR2
124 , p3_a4 VARCHAR2
125 , p3_a5 VARCHAR2
126 , p3_a6 VARCHAR2
127 , p3_a7 VARCHAR2
128 , p3_a8 VARCHAR2
129 , p3_a9 VARCHAR2
130 , p3_a10 VARCHAR2
131 , p3_a11 VARCHAR2
132 , p3_a12 VARCHAR2
133 , p3_a13 VARCHAR2
134 , p3_a14 VARCHAR2
135 , p3_a15 VARCHAR2
136 , p3_a16 VARCHAR2
137 , p3_a17 VARCHAR2
138 , p3_a18 VARCHAR2
139 , p3_a19 VARCHAR2
140 , p3_a20 DATE
141 , p3_a21 DATE
142 , p3_a22 NUMBER
143 , p3_a23 NUMBER
144 , p3_a24 NUMBER
145 , p3_a25 NUMBER
146 , p3_a26 NUMBER
147 , p3_a27 VARCHAR2
148 , p3_a28 VARCHAR2
149 , p3_a29 NUMBER
150 , p3_a30 DATE
151 , p3_a31 NUMBER
152 , p3_a32 NUMBER
153 , p3_a33 NUMBER
154 , p3_a34 NUMBER
155 , p3_a35 NUMBER
156 , p3_a36 DATE
157 , p3_a37 DATE
158 , p3_a38 VARCHAR2
159 , p3_a39 VARCHAR2
160 , p3_a40 VARCHAR2
161 , p3_a41 NUMBER
162 , p3_a42 VARCHAR2
163 , p3_a43 VARCHAR2
164 , p3_a44 VARCHAR2
165 , p3_a45 NUMBER
166 , p3_a46 NUMBER
167 , p3_a47 NUMBER
168 , p3_a48 NUMBER
169 , p3_a49 VARCHAR2
170 , p3_a50 VARCHAR2
171 , p3_a51 VARCHAR2
172 , p3_a52 VARCHAR2
173 , p4_a0 out nocopy NUMBER
174 , p4_a1 out nocopy NUMBER
175 , p4_a2 out nocopy VARCHAR2
176 , p4_a3 out nocopy VARCHAR2
177 , p4_a4 out nocopy VARCHAR2
178 , p4_a5 out nocopy VARCHAR2
179 , p4_a6 out nocopy VARCHAR2
180 , p4_a7 out nocopy VARCHAR2
181 , p4_a8 out nocopy VARCHAR2
182 , p4_a9 out nocopy VARCHAR2
183 , p4_a10 out nocopy VARCHAR2
184 , p4_a11 out nocopy VARCHAR2
185 , p4_a12 out nocopy VARCHAR2
186 , p4_a13 out nocopy VARCHAR2
187 , p4_a14 out nocopy VARCHAR2
188 , p4_a15 out nocopy VARCHAR2
189 , p4_a16 out nocopy VARCHAR2
190 , p4_a17 out nocopy VARCHAR2
191 , p4_a18 out nocopy VARCHAR2
192 , p4_a19 out nocopy VARCHAR2
193 , p4_a20 out nocopy DATE
194 , p4_a21 out nocopy DATE
195 , p4_a22 out nocopy NUMBER
196 , p4_a23 out nocopy NUMBER
197 , p4_a24 out nocopy NUMBER
198 , p4_a25 out nocopy NUMBER
199 , p4_a26 out nocopy NUMBER
200 , p4_a27 out nocopy VARCHAR2
201 , p4_a28 out nocopy VARCHAR2
202 , p4_a29 out nocopy NUMBER
203 , p4_a30 out nocopy DATE
204 , p4_a31 out nocopy NUMBER
205 , p4_a32 out nocopy NUMBER
206 , p4_a33 out nocopy NUMBER
207 , p4_a34 out nocopy NUMBER
208 , p4_a35 out nocopy NUMBER
209 , p4_a36 out nocopy DATE
210 , p4_a37 out nocopy DATE
211 , p4_a38 out nocopy VARCHAR2
212 , p4_a39 out nocopy VARCHAR2
213 , p4_a40 out nocopy VARCHAR2
214 , p4_a41 out nocopy NUMBER
215 , p4_a42 out nocopy VARCHAR2
216 , p4_a43 out nocopy VARCHAR2
217 , p4_a44 out nocopy VARCHAR2
218 , p4_a45 out nocopy NUMBER
219 , p4_a46 out nocopy NUMBER
220 , p4_a47 out nocopy NUMBER
221 , p4_a48 out nocopy NUMBER
222 , p4_a49 out nocopy VARCHAR2
223 , p4_a50 out nocopy VARCHAR2
224 , p4_a51 out nocopy VARCHAR2
225 , p4_a52 out nocopy VARCHAR2
226 , x_return_status out nocopy VARCHAR2
227 , x_msg_count out nocopy NUMBER
228 , x_msg_data out nocopy VARCHAR2
229 );
230 procedure defaults_for_lease_opp(p_api_version NUMBER
231 , p_init_msg_list VARCHAR2
232 , p_transaction_control VARCHAR2
233 , p3_a0 NUMBER
234 , p3_a1 NUMBER
235 , p3_a2 VARCHAR2
236 , p3_a3 VARCHAR2
237 , p3_a4 VARCHAR2
238 , p3_a5 VARCHAR2
239 , p3_a6 VARCHAR2
240 , p3_a7 VARCHAR2
241 , p3_a8 VARCHAR2
242 , p3_a9 VARCHAR2
243 , p3_a10 VARCHAR2
244 , p3_a11 VARCHAR2
245 , p3_a12 VARCHAR2
246 , p3_a13 VARCHAR2
247 , p3_a14 VARCHAR2
248 , p3_a15 VARCHAR2
249 , p3_a16 VARCHAR2
250 , p3_a17 VARCHAR2
251 , p3_a18 VARCHAR2
252 , p3_a19 VARCHAR2
253 , p3_a20 DATE
254 , p3_a21 DATE
255 , p3_a22 NUMBER
256 , p3_a23 NUMBER
257 , p3_a24 NUMBER
258 , p3_a25 NUMBER
259 , p3_a26 NUMBER
260 , p3_a27 VARCHAR2
261 , p3_a28 VARCHAR2
262 , p3_a29 NUMBER
263 , p3_a30 DATE
264 , p3_a31 NUMBER
265 , p3_a32 NUMBER
266 , p3_a33 NUMBER
267 , p3_a34 NUMBER
268 , p3_a35 NUMBER
269 , p3_a36 DATE
270 , p3_a37 DATE
271 , p3_a38 VARCHAR2
272 , p3_a39 VARCHAR2
273 , p3_a40 VARCHAR2
274 , p3_a41 NUMBER
275 , p3_a42 VARCHAR2
276 , p3_a43 VARCHAR2
277 , p3_a44 VARCHAR2
278 , p3_a45 NUMBER
279 , p3_a46 NUMBER
280 , p3_a47 NUMBER
281 , p3_a48 NUMBER
282 , p3_a49 VARCHAR2
283 , p3_a50 VARCHAR2
284 , p3_a51 VARCHAR2
285 , p3_a52 VARCHAR2
286 , p_user_id VARCHAR2
287 , x_sales_rep_name out nocopy VARCHAR2
288 , p6_a0 out nocopy NUMBER
289 , p6_a1 out nocopy NUMBER
290 , p6_a2 out nocopy VARCHAR2
291 , p6_a3 out nocopy VARCHAR2
292 , p6_a4 out nocopy VARCHAR2
293 , p6_a5 out nocopy VARCHAR2
294 , p6_a6 out nocopy VARCHAR2
295 , p6_a7 out nocopy VARCHAR2
296 , p6_a8 out nocopy VARCHAR2
297 , p6_a9 out nocopy VARCHAR2
298 , p6_a10 out nocopy VARCHAR2
299 , p6_a11 out nocopy VARCHAR2
300 , p6_a12 out nocopy VARCHAR2
301 , p6_a13 out nocopy VARCHAR2
302 , p6_a14 out nocopy VARCHAR2
303 , p6_a15 out nocopy VARCHAR2
304 , p6_a16 out nocopy VARCHAR2
305 , p6_a17 out nocopy VARCHAR2
306 , p6_a18 out nocopy VARCHAR2
307 , p6_a19 out nocopy VARCHAR2
308 , p6_a20 out nocopy DATE
309 , p6_a21 out nocopy DATE
310 , p6_a22 out nocopy NUMBER
311 , p6_a23 out nocopy NUMBER
312 , p6_a24 out nocopy NUMBER
313 , p6_a25 out nocopy NUMBER
314 , p6_a26 out nocopy NUMBER
315 , p6_a27 out nocopy VARCHAR2
316 , p6_a28 out nocopy VARCHAR2
317 , p6_a29 out nocopy NUMBER
318 , p6_a30 out nocopy DATE
319 , p6_a31 out nocopy NUMBER
320 , p6_a32 out nocopy NUMBER
321 , p6_a33 out nocopy NUMBER
322 , p6_a34 out nocopy NUMBER
323 , p6_a35 out nocopy NUMBER
324 , p6_a36 out nocopy DATE
325 , p6_a37 out nocopy DATE
326 , p6_a38 out nocopy VARCHAR2
327 , p6_a39 out nocopy VARCHAR2
328 , p6_a40 out nocopy VARCHAR2
329 , p6_a41 out nocopy NUMBER
330 , p6_a42 out nocopy VARCHAR2
331 , p6_a43 out nocopy VARCHAR2
332 , p6_a44 out nocopy VARCHAR2
333 , p6_a45 out nocopy NUMBER
334 , p6_a46 out nocopy NUMBER
335 , p6_a47 out nocopy NUMBER
336 , p6_a48 out nocopy NUMBER
337 , p6_a49 out nocopy VARCHAR2
338 , p6_a50 out nocopy VARCHAR2
339 , p6_a51 out nocopy VARCHAR2
340 , p6_a52 out nocopy VARCHAR2
341 , x_dff_name out nocopy VARCHAR2
342 , x_return_status out nocopy VARCHAR2
343 , x_msg_count out nocopy NUMBER
344 , x_msg_data out nocopy VARCHAR2
345 );
346 procedure duplicate_lease_opp(p_api_version NUMBER
347 , p_init_msg_list VARCHAR2
348 , p_transaction_control VARCHAR2
349 , p_source_leaseopp_id NUMBER
350 , p4_a0 NUMBER
351 , p4_a1 NUMBER
352 , p4_a2 VARCHAR2
353 , p4_a3 VARCHAR2
354 , p4_a4 VARCHAR2
355 , p4_a5 VARCHAR2
356 , p4_a6 VARCHAR2
357 , p4_a7 VARCHAR2
358 , p4_a8 VARCHAR2
359 , p4_a9 VARCHAR2
360 , p4_a10 VARCHAR2
361 , p4_a11 VARCHAR2
362 , p4_a12 VARCHAR2
363 , p4_a13 VARCHAR2
364 , p4_a14 VARCHAR2
365 , p4_a15 VARCHAR2
366 , p4_a16 VARCHAR2
367 , p4_a17 VARCHAR2
368 , p4_a18 VARCHAR2
369 , p4_a19 VARCHAR2
370 , p4_a20 DATE
371 , p4_a21 DATE
372 , p4_a22 NUMBER
373 , p4_a23 NUMBER
374 , p4_a24 NUMBER
375 , p4_a25 NUMBER
376 , p4_a26 NUMBER
377 , p4_a27 VARCHAR2
378 , p4_a28 VARCHAR2
379 , p4_a29 NUMBER
380 , p4_a30 DATE
381 , p4_a31 NUMBER
382 , p4_a32 NUMBER
383 , p4_a33 NUMBER
384 , p4_a34 NUMBER
385 , p4_a35 NUMBER
386 , p4_a36 DATE
387 , p4_a37 DATE
388 , p4_a38 VARCHAR2
389 , p4_a39 VARCHAR2
390 , p4_a40 VARCHAR2
391 , p4_a41 NUMBER
392 , p4_a42 VARCHAR2
393 , p4_a43 VARCHAR2
394 , p4_a44 VARCHAR2
395 , p4_a45 NUMBER
396 , p4_a46 NUMBER
397 , p4_a47 NUMBER
398 , p4_a48 NUMBER
399 , p4_a49 VARCHAR2
400 , p4_a50 VARCHAR2
401 , p4_a51 VARCHAR2
402 , p4_a52 VARCHAR2
403 , p5_a0 out nocopy NUMBER
404 , p5_a1 out nocopy NUMBER
405 , p5_a2 out nocopy VARCHAR2
406 , p5_a3 out nocopy VARCHAR2
407 , p5_a4 out nocopy VARCHAR2
408 , p5_a5 out nocopy VARCHAR2
409 , p5_a6 out nocopy VARCHAR2
410 , p5_a7 out nocopy VARCHAR2
411 , p5_a8 out nocopy VARCHAR2
412 , p5_a9 out nocopy VARCHAR2
413 , p5_a10 out nocopy VARCHAR2
414 , p5_a11 out nocopy VARCHAR2
415 , p5_a12 out nocopy VARCHAR2
416 , p5_a13 out nocopy VARCHAR2
417 , p5_a14 out nocopy VARCHAR2
418 , p5_a15 out nocopy VARCHAR2
419 , p5_a16 out nocopy VARCHAR2
420 , p5_a17 out nocopy VARCHAR2
421 , p5_a18 out nocopy VARCHAR2
422 , p5_a19 out nocopy VARCHAR2
423 , p5_a20 out nocopy DATE
424 , p5_a21 out nocopy DATE
425 , p5_a22 out nocopy NUMBER
426 , p5_a23 out nocopy NUMBER
427 , p5_a24 out nocopy NUMBER
428 , p5_a25 out nocopy NUMBER
429 , p5_a26 out nocopy NUMBER
430 , p5_a27 out nocopy VARCHAR2
431 , p5_a28 out nocopy VARCHAR2
432 , p5_a29 out nocopy NUMBER
433 , p5_a30 out nocopy DATE
434 , p5_a31 out nocopy NUMBER
435 , p5_a32 out nocopy NUMBER
436 , p5_a33 out nocopy NUMBER
437 , p5_a34 out nocopy NUMBER
438 , p5_a35 out nocopy NUMBER
439 , p5_a36 out nocopy DATE
440 , p5_a37 out nocopy DATE
441 , p5_a38 out nocopy VARCHAR2
442 , p5_a39 out nocopy VARCHAR2
443 , p5_a40 out nocopy VARCHAR2
444 , p5_a41 out nocopy NUMBER
445 , p5_a42 out nocopy VARCHAR2
446 , p5_a43 out nocopy VARCHAR2
447 , p5_a44 out nocopy VARCHAR2
448 , p5_a45 out nocopy NUMBER
449 , p5_a46 out nocopy NUMBER
450 , p5_a47 out nocopy NUMBER
451 , p5_a48 out nocopy NUMBER
452 , p5_a49 out nocopy VARCHAR2
453 , p5_a50 out nocopy VARCHAR2
454 , p5_a51 out nocopy VARCHAR2
455 , p5_a52 out nocopy VARCHAR2
456 , x_return_status out nocopy VARCHAR2
457 , x_msg_count out nocopy NUMBER
458 , x_msg_data out nocopy VARCHAR2
459 );
460 end okl_lease_opportunity_pvt_w;