[Home] [Help]
PACKAGE BODY: APPS.OKL_AM_TERMNT_QUOTE_PUB_W
Source
1 package body okl_am_termnt_quote_pub_w as
2 /* $Header: OKLUTNQB.pls 120.5 2007/11/02 21:07:28 rmunjulu ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure terminate_quote(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , x_return_status out nocopy VARCHAR2
25 , x_msg_count out nocopy NUMBER
26 , x_msg_data out nocopy VARCHAR2
27 , p6_a0 out nocopy NUMBER
28 , p6_a1 out nocopy NUMBER
29 , p6_a2 out nocopy VARCHAR2
30 , p6_a3 out nocopy VARCHAR2
31 , p6_a4 out nocopy VARCHAR2
32 , p6_a5 out nocopy VARCHAR2
33 , p6_a6 out nocopy VARCHAR2
34 , p6_a7 out nocopy VARCHAR2
35 , p6_a8 out nocopy VARCHAR2
36 , p6_a9 out nocopy NUMBER
37 , p6_a10 out nocopy NUMBER
38 , p6_a11 out nocopy NUMBER
39 , p6_a12 out nocopy NUMBER
40 , p6_a13 out nocopy VARCHAR2
41 , p6_a14 out nocopy VARCHAR2
42 , p6_a15 out nocopy VARCHAR2
43 , p6_a16 out nocopy DATE
44 , p6_a17 out nocopy DATE
45 , p6_a18 out nocopy DATE
46 , p6_a19 out nocopy DATE
47 , p6_a20 out nocopy VARCHAR2
48 , p6_a21 out nocopy VARCHAR2
49 , p6_a22 out nocopy NUMBER
50 , p6_a23 out nocopy NUMBER
51 , p6_a24 out nocopy NUMBER
52 , p6_a25 out nocopy NUMBER
53 , p6_a26 out nocopy DATE
54 , p6_a27 out nocopy DATE
55 , p6_a28 out nocopy NUMBER
56 , p6_a29 out nocopy NUMBER
57 , p6_a30 out nocopy VARCHAR2
58 , p6_a31 out nocopy DATE
59 , p6_a32 out nocopy VARCHAR2
60 , p6_a33 out nocopy NUMBER
61 , p6_a34 out nocopy DATE
62 , p6_a35 out nocopy NUMBER
63 , p6_a36 out nocopy NUMBER
64 , p6_a37 out nocopy VARCHAR2
65 , p6_a38 out nocopy VARCHAR2
66 , p6_a39 out nocopy VARCHAR2
67 , p6_a40 out nocopy DATE
68 , p6_a41 out nocopy VARCHAR2
69 , p6_a42 out nocopy VARCHAR2
70 , p6_a43 out nocopy VARCHAR2
71 , p6_a44 out nocopy VARCHAR2
72 , p6_a45 out nocopy VARCHAR2
73 , p6_a46 out nocopy VARCHAR2
74 , p6_a47 out nocopy VARCHAR2
75 , p6_a48 out nocopy VARCHAR2
76 , p6_a49 out nocopy VARCHAR2
77 , p6_a50 out nocopy VARCHAR2
78 , p6_a51 out nocopy VARCHAR2
79 , p6_a52 out nocopy VARCHAR2
80 , p6_a53 out nocopy VARCHAR2
81 , p6_a54 out nocopy VARCHAR2
82 , p6_a55 out nocopy VARCHAR2
83 , p6_a56 out nocopy VARCHAR2
84 , p6_a57 out nocopy DATE
85 , p6_a58 out nocopy NUMBER
86 , p6_a59 out nocopy NUMBER
87 , p6_a60 out nocopy NUMBER
88 , p6_a61 out nocopy NUMBER
89 , p6_a62 out nocopy NUMBER
90 , p6_a63 out nocopy DATE
91 , p6_a64 out nocopy NUMBER
92 , p6_a65 out nocopy DATE
93 , p6_a66 out nocopy NUMBER
94 , p6_a67 out nocopy DATE
95 , p6_a68 out nocopy NUMBER
96 , p6_a69 out nocopy NUMBER
97 , p6_a70 out nocopy VARCHAR2
98 , p6_a71 out nocopy NUMBER
99 , p6_a72 out nocopy NUMBER
100 , p6_a73 out nocopy NUMBER
101 , p6_a74 out nocopy NUMBER
102 , p6_a75 out nocopy NUMBER
103 , p6_a76 out nocopy VARCHAR2
104 , p6_a77 out nocopy VARCHAR2
105 , p6_a78 out nocopy VARCHAR2
106 , p6_a79 out nocopy NUMBER
107 , p6_a80 out nocopy DATE
108 , p6_a81 out nocopy NUMBER
109 , p6_a82 out nocopy VARCHAR2
110 , x_err_msg out nocopy VARCHAR2
111 , p_acceptance_source VARCHAR2
112 , p5_a0 NUMBER := 0-1962.0724
113 , p5_a1 NUMBER := 0-1962.0724
114 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
115 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
116 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
117 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
118 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
119 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
120 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
121 , p5_a9 NUMBER := 0-1962.0724
122 , p5_a10 NUMBER := 0-1962.0724
123 , p5_a11 NUMBER := 0-1962.0724
124 , p5_a12 NUMBER := 0-1962.0724
125 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
126 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
127 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
128 , p5_a16 DATE := fnd_api.g_miss_date
129 , p5_a17 DATE := fnd_api.g_miss_date
130 , p5_a18 DATE := fnd_api.g_miss_date
131 , p5_a19 DATE := fnd_api.g_miss_date
132 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
133 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
134 , p5_a22 NUMBER := 0-1962.0724
135 , p5_a23 NUMBER := 0-1962.0724
136 , p5_a24 NUMBER := 0-1962.0724
137 , p5_a25 NUMBER := 0-1962.0724
138 , p5_a26 DATE := fnd_api.g_miss_date
139 , p5_a27 DATE := fnd_api.g_miss_date
140 , p5_a28 NUMBER := 0-1962.0724
141 , p5_a29 NUMBER := 0-1962.0724
142 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
143 , p5_a31 DATE := fnd_api.g_miss_date
144 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
145 , p5_a33 NUMBER := 0-1962.0724
146 , p5_a34 DATE := fnd_api.g_miss_date
147 , p5_a35 NUMBER := 0-1962.0724
148 , p5_a36 NUMBER := 0-1962.0724
149 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
150 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
151 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
152 , p5_a40 DATE := fnd_api.g_miss_date
153 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
154 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
155 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
156 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
157 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
158 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
159 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
160 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
161 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
162 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
163 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
164 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
165 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
166 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
167 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
168 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
169 , p5_a57 DATE := fnd_api.g_miss_date
170 , p5_a58 NUMBER := 0-1962.0724
171 , p5_a59 NUMBER := 0-1962.0724
172 , p5_a60 NUMBER := 0-1962.0724
173 , p5_a61 NUMBER := 0-1962.0724
174 , p5_a62 NUMBER := 0-1962.0724
175 , p5_a63 DATE := fnd_api.g_miss_date
176 , p5_a64 NUMBER := 0-1962.0724
177 , p5_a65 DATE := fnd_api.g_miss_date
178 , p5_a66 NUMBER := 0-1962.0724
179 , p5_a67 DATE := fnd_api.g_miss_date
180 , p5_a68 NUMBER := 0-1962.0724
181 , p5_a69 NUMBER := 0-1962.0724
182 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
183 , p5_a71 NUMBER := 0-1962.0724
184 , p5_a72 NUMBER := 0-1962.0724
185 , p5_a73 NUMBER := 0-1962.0724
186 , p5_a74 NUMBER := 0-1962.0724
187 , p5_a75 NUMBER := 0-1962.0724
188 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
189 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
190 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
191 , p5_a79 NUMBER := 0-1962.0724
192 , p5_a80 DATE := fnd_api.g_miss_date
193 , p5_a81 NUMBER := 0-1962.0724
194 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
195 )
196
197 as
198 ddp_term_rec okl_am_termnt_quote_pub.term_rec_type;
199 ddx_term_rec okl_am_termnt_quote_pub.term_rec_type;
200 ddindx binary_integer; indx binary_integer;
201 begin
202
203 -- copy data to the local IN or IN-OUT args, if any
204
205
206
207
208
209 ddp_term_rec.id := rosetta_g_miss_num_map(p5_a0);
210 ddp_term_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
211 ddp_term_rec.sfwt_flag := p5_a2;
212 ddp_term_rec.qrs_code := p5_a3;
213 ddp_term_rec.qst_code := p5_a4;
214 ddp_term_rec.qtp_code := p5_a5;
215 ddp_term_rec.trn_code := p5_a6;
216 ddp_term_rec.pop_code_end := p5_a7;
217 ddp_term_rec.pop_code_early := p5_a8;
218 ddp_term_rec.consolidated_qte_id := rosetta_g_miss_num_map(p5_a9);
219 ddp_term_rec.khr_id := rosetta_g_miss_num_map(p5_a10);
220 ddp_term_rec.art_id := rosetta_g_miss_num_map(p5_a11);
221 ddp_term_rec.pdt_id := rosetta_g_miss_num_map(p5_a12);
222 ddp_term_rec.early_termination_yn := p5_a13;
223 ddp_term_rec.partial_yn := p5_a14;
224 ddp_term_rec.preproceeds_yn := p5_a15;
225 ddp_term_rec.date_requested := rosetta_g_miss_date_in_map(p5_a16);
226 ddp_term_rec.date_proposal := rosetta_g_miss_date_in_map(p5_a17);
227 ddp_term_rec.date_effective_to := rosetta_g_miss_date_in_map(p5_a18);
228 ddp_term_rec.date_accepted := rosetta_g_miss_date_in_map(p5_a19);
229 ddp_term_rec.summary_format_yn := p5_a20;
230 ddp_term_rec.consolidated_yn := p5_a21;
231 ddp_term_rec.principal_paydown_amount := rosetta_g_miss_num_map(p5_a22);
232 ddp_term_rec.residual_amount := rosetta_g_miss_num_map(p5_a23);
233 ddp_term_rec.yield := rosetta_g_miss_num_map(p5_a24);
234 ddp_term_rec.rent_amount := rosetta_g_miss_num_map(p5_a25);
235 ddp_term_rec.date_restructure_end := rosetta_g_miss_date_in_map(p5_a26);
236 ddp_term_rec.date_restructure_start := rosetta_g_miss_date_in_map(p5_a27);
237 ddp_term_rec.term := rosetta_g_miss_num_map(p5_a28);
238 ddp_term_rec.purchase_percent := rosetta_g_miss_num_map(p5_a29);
239 ddp_term_rec.comments := p5_a30;
240 ddp_term_rec.date_due := rosetta_g_miss_date_in_map(p5_a31);
241 ddp_term_rec.payment_frequency := p5_a32;
242 ddp_term_rec.remaining_payments := rosetta_g_miss_num_map(p5_a33);
243 ddp_term_rec.date_effective_from := rosetta_g_miss_date_in_map(p5_a34);
244 ddp_term_rec.quote_number := rosetta_g_miss_num_map(p5_a35);
245 ddp_term_rec.requested_by := rosetta_g_miss_num_map(p5_a36);
246 ddp_term_rec.approved_yn := p5_a37;
247 ddp_term_rec.accepted_yn := p5_a38;
248 ddp_term_rec.payment_received_yn := p5_a39;
249 ddp_term_rec.date_payment_received := rosetta_g_miss_date_in_map(p5_a40);
250 ddp_term_rec.attribute_category := p5_a41;
251 ddp_term_rec.attribute1 := p5_a42;
252 ddp_term_rec.attribute2 := p5_a43;
253 ddp_term_rec.attribute3 := p5_a44;
254 ddp_term_rec.attribute4 := p5_a45;
255 ddp_term_rec.attribute5 := p5_a46;
256 ddp_term_rec.attribute6 := p5_a47;
257 ddp_term_rec.attribute7 := p5_a48;
258 ddp_term_rec.attribute8 := p5_a49;
259 ddp_term_rec.attribute9 := p5_a50;
260 ddp_term_rec.attribute10 := p5_a51;
261 ddp_term_rec.attribute11 := p5_a52;
262 ddp_term_rec.attribute12 := p5_a53;
263 ddp_term_rec.attribute13 := p5_a54;
264 ddp_term_rec.attribute14 := p5_a55;
265 ddp_term_rec.attribute15 := p5_a56;
266 ddp_term_rec.date_approved := rosetta_g_miss_date_in_map(p5_a57);
267 ddp_term_rec.approved_by := rosetta_g_miss_num_map(p5_a58);
268 ddp_term_rec.org_id := rosetta_g_miss_num_map(p5_a59);
269 ddp_term_rec.request_id := rosetta_g_miss_num_map(p5_a60);
270 ddp_term_rec.program_application_id := rosetta_g_miss_num_map(p5_a61);
271 ddp_term_rec.program_id := rosetta_g_miss_num_map(p5_a62);
272 ddp_term_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a63);
273 ddp_term_rec.created_by := rosetta_g_miss_num_map(p5_a64);
274 ddp_term_rec.creation_date := rosetta_g_miss_date_in_map(p5_a65);
275 ddp_term_rec.last_updated_by := rosetta_g_miss_num_map(p5_a66);
276 ddp_term_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a67);
277 ddp_term_rec.last_update_login := rosetta_g_miss_num_map(p5_a68);
278 ddp_term_rec.purchase_amount := rosetta_g_miss_num_map(p5_a69);
279 ddp_term_rec.purchase_formula := p5_a70;
280 ddp_term_rec.asset_value := rosetta_g_miss_num_map(p5_a71);
281 ddp_term_rec.residual_value := rosetta_g_miss_num_map(p5_a72);
282 ddp_term_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a73);
283 ddp_term_rec.gain_loss := rosetta_g_miss_num_map(p5_a74);
284 ddp_term_rec.perdiem_amount := rosetta_g_miss_num_map(p5_a75);
285 ddp_term_rec.currency_code := p5_a76;
286 ddp_term_rec.currency_conversion_code := p5_a77;
287 ddp_term_rec.currency_conversion_type := p5_a78;
288 ddp_term_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a79);
289 ddp_term_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
290 ddp_term_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
291 ddp_term_rec.repo_quote_indicator_yn := p5_a82;
292
293
294
295
296 -- here's the delegated call to the old PL/SQL routine
297 okl_am_termnt_quote_pub.terminate_quote(p_api_version,
298 p_init_msg_list,
299 x_return_status,
300 x_msg_count,
301 x_msg_data,
302 ddp_term_rec,
303 ddx_term_rec,
304 x_err_msg,
305 p_acceptance_source);
306
307 -- copy data back from the local variables to OUT or IN-OUT args, if any
308
309
310
311
312
313
314 p6_a0 := rosetta_g_miss_num_map(ddx_term_rec.id);
315 p6_a1 := rosetta_g_miss_num_map(ddx_term_rec.object_version_number);
316 p6_a2 := ddx_term_rec.sfwt_flag;
317 p6_a3 := ddx_term_rec.qrs_code;
318 p6_a4 := ddx_term_rec.qst_code;
319 p6_a5 := ddx_term_rec.qtp_code;
320 p6_a6 := ddx_term_rec.trn_code;
321 p6_a7 := ddx_term_rec.pop_code_end;
322 p6_a8 := ddx_term_rec.pop_code_early;
323 p6_a9 := rosetta_g_miss_num_map(ddx_term_rec.consolidated_qte_id);
324 p6_a10 := rosetta_g_miss_num_map(ddx_term_rec.khr_id);
325 p6_a11 := rosetta_g_miss_num_map(ddx_term_rec.art_id);
326 p6_a12 := rosetta_g_miss_num_map(ddx_term_rec.pdt_id);
327 p6_a13 := ddx_term_rec.early_termination_yn;
328 p6_a14 := ddx_term_rec.partial_yn;
329 p6_a15 := ddx_term_rec.preproceeds_yn;
330 p6_a16 := ddx_term_rec.date_requested;
331 p6_a17 := ddx_term_rec.date_proposal;
332 p6_a18 := ddx_term_rec.date_effective_to;
333 p6_a19 := ddx_term_rec.date_accepted;
334 p6_a20 := ddx_term_rec.summary_format_yn;
335 p6_a21 := ddx_term_rec.consolidated_yn;
336 p6_a22 := rosetta_g_miss_num_map(ddx_term_rec.principal_paydown_amount);
337 p6_a23 := rosetta_g_miss_num_map(ddx_term_rec.residual_amount);
338 p6_a24 := rosetta_g_miss_num_map(ddx_term_rec.yield);
339 p6_a25 := rosetta_g_miss_num_map(ddx_term_rec.rent_amount);
340 p6_a26 := ddx_term_rec.date_restructure_end;
341 p6_a27 := ddx_term_rec.date_restructure_start;
342 p6_a28 := rosetta_g_miss_num_map(ddx_term_rec.term);
343 p6_a29 := rosetta_g_miss_num_map(ddx_term_rec.purchase_percent);
344 p6_a30 := ddx_term_rec.comments;
345 p6_a31 := ddx_term_rec.date_due;
346 p6_a32 := ddx_term_rec.payment_frequency;
347 p6_a33 := rosetta_g_miss_num_map(ddx_term_rec.remaining_payments);
348 p6_a34 := ddx_term_rec.date_effective_from;
349 p6_a35 := rosetta_g_miss_num_map(ddx_term_rec.quote_number);
350 p6_a36 := rosetta_g_miss_num_map(ddx_term_rec.requested_by);
351 p6_a37 := ddx_term_rec.approved_yn;
352 p6_a38 := ddx_term_rec.accepted_yn;
353 p6_a39 := ddx_term_rec.payment_received_yn;
354 p6_a40 := ddx_term_rec.date_payment_received;
355 p6_a41 := ddx_term_rec.attribute_category;
356 p6_a42 := ddx_term_rec.attribute1;
357 p6_a43 := ddx_term_rec.attribute2;
358 p6_a44 := ddx_term_rec.attribute3;
359 p6_a45 := ddx_term_rec.attribute4;
360 p6_a46 := ddx_term_rec.attribute5;
361 p6_a47 := ddx_term_rec.attribute6;
362 p6_a48 := ddx_term_rec.attribute7;
363 p6_a49 := ddx_term_rec.attribute8;
364 p6_a50 := ddx_term_rec.attribute9;
365 p6_a51 := ddx_term_rec.attribute10;
366 p6_a52 := ddx_term_rec.attribute11;
367 p6_a53 := ddx_term_rec.attribute12;
368 p6_a54 := ddx_term_rec.attribute13;
369 p6_a55 := ddx_term_rec.attribute14;
370 p6_a56 := ddx_term_rec.attribute15;
371 p6_a57 := ddx_term_rec.date_approved;
372 p6_a58 := rosetta_g_miss_num_map(ddx_term_rec.approved_by);
373 p6_a59 := rosetta_g_miss_num_map(ddx_term_rec.org_id);
374 p6_a60 := rosetta_g_miss_num_map(ddx_term_rec.request_id);
375 p6_a61 := rosetta_g_miss_num_map(ddx_term_rec.program_application_id);
376 p6_a62 := rosetta_g_miss_num_map(ddx_term_rec.program_id);
377 p6_a63 := ddx_term_rec.program_update_date;
378 p6_a64 := rosetta_g_miss_num_map(ddx_term_rec.created_by);
379 p6_a65 := ddx_term_rec.creation_date;
380 p6_a66 := rosetta_g_miss_num_map(ddx_term_rec.last_updated_by);
381 p6_a67 := ddx_term_rec.last_update_date;
382 p6_a68 := rosetta_g_miss_num_map(ddx_term_rec.last_update_login);
383 p6_a69 := rosetta_g_miss_num_map(ddx_term_rec.purchase_amount);
384 p6_a70 := ddx_term_rec.purchase_formula;
385 p6_a71 := rosetta_g_miss_num_map(ddx_term_rec.asset_value);
386 p6_a72 := rosetta_g_miss_num_map(ddx_term_rec.residual_value);
387 p6_a73 := rosetta_g_miss_num_map(ddx_term_rec.unbilled_receivables);
388 p6_a74 := rosetta_g_miss_num_map(ddx_term_rec.gain_loss);
389 p6_a75 := rosetta_g_miss_num_map(ddx_term_rec.perdiem_amount);
390 p6_a76 := ddx_term_rec.currency_code;
391 p6_a77 := ddx_term_rec.currency_conversion_code;
392 p6_a78 := ddx_term_rec.currency_conversion_type;
393 p6_a79 := rosetta_g_miss_num_map(ddx_term_rec.currency_conversion_rate);
394 p6_a80 := ddx_term_rec.currency_conversion_date;
395 p6_a81 := rosetta_g_miss_num_map(ddx_term_rec.legal_entity_id);
396 p6_a82 := ddx_term_rec.repo_quote_indicator_yn;
397
398
399 end;
400
401 procedure terminate_quote(p_api_version NUMBER
402 , p_init_msg_list VARCHAR2
403 , x_return_status out nocopy VARCHAR2
404 , x_msg_count out nocopy NUMBER
405 , x_msg_data out nocopy VARCHAR2
406 , p5_a0 JTF_NUMBER_TABLE
407 , p5_a1 JTF_NUMBER_TABLE
408 , p5_a2 JTF_VARCHAR2_TABLE_100
409 , p5_a3 JTF_VARCHAR2_TABLE_100
410 , p5_a4 JTF_VARCHAR2_TABLE_100
411 , p5_a5 JTF_VARCHAR2_TABLE_100
412 , p5_a6 JTF_VARCHAR2_TABLE_100
413 , p5_a7 JTF_VARCHAR2_TABLE_100
414 , p5_a8 JTF_VARCHAR2_TABLE_100
415 , p5_a9 JTF_NUMBER_TABLE
416 , p5_a10 JTF_NUMBER_TABLE
417 , p5_a11 JTF_NUMBER_TABLE
418 , p5_a12 JTF_NUMBER_TABLE
419 , p5_a13 JTF_VARCHAR2_TABLE_100
420 , p5_a14 JTF_VARCHAR2_TABLE_100
421 , p5_a15 JTF_VARCHAR2_TABLE_100
422 , p5_a16 JTF_DATE_TABLE
423 , p5_a17 JTF_DATE_TABLE
424 , p5_a18 JTF_DATE_TABLE
425 , p5_a19 JTF_DATE_TABLE
426 , p5_a20 JTF_VARCHAR2_TABLE_100
427 , p5_a21 JTF_VARCHAR2_TABLE_100
428 , p5_a22 JTF_NUMBER_TABLE
429 , p5_a23 JTF_NUMBER_TABLE
430 , p5_a24 JTF_NUMBER_TABLE
431 , p5_a25 JTF_NUMBER_TABLE
432 , p5_a26 JTF_DATE_TABLE
433 , p5_a27 JTF_DATE_TABLE
434 , p5_a28 JTF_NUMBER_TABLE
435 , p5_a29 JTF_NUMBER_TABLE
436 , p5_a30 JTF_VARCHAR2_TABLE_2000
437 , p5_a31 JTF_DATE_TABLE
438 , p5_a32 JTF_VARCHAR2_TABLE_100
439 , p5_a33 JTF_NUMBER_TABLE
440 , p5_a34 JTF_DATE_TABLE
441 , p5_a35 JTF_NUMBER_TABLE
442 , p5_a36 JTF_NUMBER_TABLE
443 , p5_a37 JTF_VARCHAR2_TABLE_100
444 , p5_a38 JTF_VARCHAR2_TABLE_100
445 , p5_a39 JTF_VARCHAR2_TABLE_100
446 , p5_a40 JTF_DATE_TABLE
447 , p5_a41 JTF_VARCHAR2_TABLE_100
448 , p5_a42 JTF_VARCHAR2_TABLE_500
449 , p5_a43 JTF_VARCHAR2_TABLE_500
450 , p5_a44 JTF_VARCHAR2_TABLE_500
451 , p5_a45 JTF_VARCHAR2_TABLE_500
452 , p5_a46 JTF_VARCHAR2_TABLE_500
453 , p5_a47 JTF_VARCHAR2_TABLE_500
454 , p5_a48 JTF_VARCHAR2_TABLE_500
455 , p5_a49 JTF_VARCHAR2_TABLE_500
456 , p5_a50 JTF_VARCHAR2_TABLE_500
457 , p5_a51 JTF_VARCHAR2_TABLE_500
458 , p5_a52 JTF_VARCHAR2_TABLE_500
459 , p5_a53 JTF_VARCHAR2_TABLE_500
460 , p5_a54 JTF_VARCHAR2_TABLE_500
461 , p5_a55 JTF_VARCHAR2_TABLE_500
462 , p5_a56 JTF_VARCHAR2_TABLE_500
463 , p5_a57 JTF_DATE_TABLE
464 , p5_a58 JTF_NUMBER_TABLE
465 , p5_a59 JTF_NUMBER_TABLE
466 , p5_a60 JTF_NUMBER_TABLE
467 , p5_a61 JTF_NUMBER_TABLE
468 , p5_a62 JTF_NUMBER_TABLE
469 , p5_a63 JTF_DATE_TABLE
470 , p5_a64 JTF_NUMBER_TABLE
471 , p5_a65 JTF_DATE_TABLE
472 , p5_a66 JTF_NUMBER_TABLE
473 , p5_a67 JTF_DATE_TABLE
474 , p5_a68 JTF_NUMBER_TABLE
475 , p5_a69 JTF_NUMBER_TABLE
476 , p5_a70 JTF_VARCHAR2_TABLE_200
477 , p5_a71 JTF_NUMBER_TABLE
478 , p5_a72 JTF_NUMBER_TABLE
479 , p5_a73 JTF_NUMBER_TABLE
480 , p5_a74 JTF_NUMBER_TABLE
481 , p5_a75 JTF_NUMBER_TABLE
482 , p5_a76 JTF_VARCHAR2_TABLE_100
483 , p5_a77 JTF_VARCHAR2_TABLE_100
484 , p5_a78 JTF_VARCHAR2_TABLE_100
485 , p5_a79 JTF_NUMBER_TABLE
486 , p5_a80 JTF_DATE_TABLE
487 , p5_a81 JTF_NUMBER_TABLE
488 , p5_a82 JTF_VARCHAR2_TABLE_100
489 , p6_a0 out nocopy JTF_NUMBER_TABLE
490 , p6_a1 out nocopy JTF_NUMBER_TABLE
491 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
492 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
493 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
494 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
495 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
496 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
497 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
498 , p6_a9 out nocopy JTF_NUMBER_TABLE
499 , p6_a10 out nocopy JTF_NUMBER_TABLE
500 , p6_a11 out nocopy JTF_NUMBER_TABLE
501 , p6_a12 out nocopy JTF_NUMBER_TABLE
502 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
503 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
504 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
505 , p6_a16 out nocopy JTF_DATE_TABLE
506 , p6_a17 out nocopy JTF_DATE_TABLE
507 , p6_a18 out nocopy JTF_DATE_TABLE
508 , p6_a19 out nocopy JTF_DATE_TABLE
509 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
510 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
511 , p6_a22 out nocopy JTF_NUMBER_TABLE
512 , p6_a23 out nocopy JTF_NUMBER_TABLE
513 , p6_a24 out nocopy JTF_NUMBER_TABLE
514 , p6_a25 out nocopy JTF_NUMBER_TABLE
515 , p6_a26 out nocopy JTF_DATE_TABLE
516 , p6_a27 out nocopy JTF_DATE_TABLE
517 , p6_a28 out nocopy JTF_NUMBER_TABLE
518 , p6_a29 out nocopy JTF_NUMBER_TABLE
519 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_2000
520 , p6_a31 out nocopy JTF_DATE_TABLE
521 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
522 , p6_a33 out nocopy JTF_NUMBER_TABLE
523 , p6_a34 out nocopy JTF_DATE_TABLE
524 , p6_a35 out nocopy JTF_NUMBER_TABLE
525 , p6_a36 out nocopy JTF_NUMBER_TABLE
526 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
527 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
528 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
529 , p6_a40 out nocopy JTF_DATE_TABLE
530 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
531 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
532 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
533 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
534 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
535 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
536 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
537 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
538 , p6_a49 out nocopy JTF_VARCHAR2_TABLE_500
539 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_500
540 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_500
541 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_500
542 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_500
543 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_500
544 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_500
545 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_500
546 , p6_a57 out nocopy JTF_DATE_TABLE
547 , p6_a58 out nocopy JTF_NUMBER_TABLE
548 , p6_a59 out nocopy JTF_NUMBER_TABLE
549 , p6_a60 out nocopy JTF_NUMBER_TABLE
550 , p6_a61 out nocopy JTF_NUMBER_TABLE
551 , p6_a62 out nocopy JTF_NUMBER_TABLE
552 , p6_a63 out nocopy JTF_DATE_TABLE
553 , p6_a64 out nocopy JTF_NUMBER_TABLE
554 , p6_a65 out nocopy JTF_DATE_TABLE
555 , p6_a66 out nocopy JTF_NUMBER_TABLE
556 , p6_a67 out nocopy JTF_DATE_TABLE
557 , p6_a68 out nocopy JTF_NUMBER_TABLE
558 , p6_a69 out nocopy JTF_NUMBER_TABLE
559 , p6_a70 out nocopy JTF_VARCHAR2_TABLE_200
560 , p6_a71 out nocopy JTF_NUMBER_TABLE
561 , p6_a72 out nocopy JTF_NUMBER_TABLE
562 , p6_a73 out nocopy JTF_NUMBER_TABLE
563 , p6_a74 out nocopy JTF_NUMBER_TABLE
564 , p6_a75 out nocopy JTF_NUMBER_TABLE
565 , p6_a76 out nocopy JTF_VARCHAR2_TABLE_100
566 , p6_a77 out nocopy JTF_VARCHAR2_TABLE_100
567 , p6_a78 out nocopy JTF_VARCHAR2_TABLE_100
568 , p6_a79 out nocopy JTF_NUMBER_TABLE
569 , p6_a80 out nocopy JTF_DATE_TABLE
570 , p6_a81 out nocopy JTF_NUMBER_TABLE
571 , p6_a82 out nocopy JTF_VARCHAR2_TABLE_100
572 , x_err_msg out nocopy VARCHAR2
573 , p_acceptance_source VARCHAR2
574 )
575
576 as
577 ddp_term_tbl okl_am_termnt_quote_pub.term_tbl_type;
578 ddx_term_tbl okl_am_termnt_quote_pub.term_tbl_type;
579 ddindx binary_integer; indx binary_integer;
580 begin
581
582 -- copy data to the local IN or IN-OUT args, if any
583
584
585
586
587
588 okl_qte_pvt_w.rosetta_table_copy_in_p8(ddp_term_tbl, p5_a0
589 , p5_a1
590 , p5_a2
591 , p5_a3
592 , p5_a4
593 , p5_a5
594 , p5_a6
595 , p5_a7
596 , p5_a8
597 , p5_a9
598 , p5_a10
599 , p5_a11
600 , p5_a12
601 , p5_a13
602 , p5_a14
603 , p5_a15
604 , p5_a16
605 , p5_a17
606 , p5_a18
607 , p5_a19
608 , p5_a20
609 , p5_a21
610 , p5_a22
611 , p5_a23
612 , p5_a24
613 , p5_a25
614 , p5_a26
615 , p5_a27
616 , p5_a28
617 , p5_a29
618 , p5_a30
619 , p5_a31
620 , p5_a32
621 , p5_a33
622 , p5_a34
623 , p5_a35
624 , p5_a36
625 , p5_a37
626 , p5_a38
627 , p5_a39
628 , p5_a40
629 , p5_a41
630 , p5_a42
631 , p5_a43
632 , p5_a44
633 , p5_a45
634 , p5_a46
635 , p5_a47
636 , p5_a48
637 , p5_a49
638 , p5_a50
639 , p5_a51
640 , p5_a52
641 , p5_a53
642 , p5_a54
643 , p5_a55
644 , p5_a56
645 , p5_a57
646 , p5_a58
647 , p5_a59
648 , p5_a60
649 , p5_a61
650 , p5_a62
651 , p5_a63
652 , p5_a64
653 , p5_a65
654 , p5_a66
655 , p5_a67
656 , p5_a68
657 , p5_a69
658 , p5_a70
659 , p5_a71
660 , p5_a72
661 , p5_a73
662 , p5_a74
663 , p5_a75
664 , p5_a76
665 , p5_a77
666 , p5_a78
667 , p5_a79
668 , p5_a80
669 , p5_a81
670 , p5_a82
671 );
672
673
674
675
676 -- here's the delegated call to the old PL/SQL routine
677 okl_am_termnt_quote_pub.terminate_quote(p_api_version,
678 p_init_msg_list,
679 x_return_status,
680 x_msg_count,
681 x_msg_data,
682 ddp_term_tbl,
683 ddx_term_tbl,
684 x_err_msg,
685 p_acceptance_source);
686
687 -- copy data back from the local variables to OUT or IN-OUT args, if any
688
689
690
691
692
693
694 okl_qte_pvt_w.rosetta_table_copy_out_p8(ddx_term_tbl, p6_a0
695 , p6_a1
696 , p6_a2
697 , p6_a3
698 , p6_a4
699 , p6_a5
700 , p6_a6
701 , p6_a7
702 , p6_a8
703 , p6_a9
704 , p6_a10
705 , p6_a11
706 , p6_a12
707 , p6_a13
708 , p6_a14
709 , p6_a15
710 , p6_a16
711 , p6_a17
712 , p6_a18
713 , p6_a19
714 , p6_a20
715 , p6_a21
716 , p6_a22
717 , p6_a23
718 , p6_a24
719 , p6_a25
720 , p6_a26
721 , p6_a27
722 , p6_a28
723 , p6_a29
724 , p6_a30
725 , p6_a31
726 , p6_a32
727 , p6_a33
728 , p6_a34
729 , p6_a35
730 , p6_a36
731 , p6_a37
732 , p6_a38
733 , p6_a39
734 , p6_a40
735 , p6_a41
736 , p6_a42
737 , p6_a43
738 , p6_a44
739 , p6_a45
740 , p6_a46
741 , p6_a47
742 , p6_a48
743 , p6_a49
744 , p6_a50
745 , p6_a51
746 , p6_a52
747 , p6_a53
748 , p6_a54
749 , p6_a55
750 , p6_a56
751 , p6_a57
752 , p6_a58
753 , p6_a59
754 , p6_a60
755 , p6_a61
756 , p6_a62
757 , p6_a63
758 , p6_a64
759 , p6_a65
760 , p6_a66
761 , p6_a67
762 , p6_a68
763 , p6_a69
764 , p6_a70
765 , p6_a71
766 , p6_a72
767 , p6_a73
768 , p6_a74
769 , p6_a75
770 , p6_a76
771 , p6_a77
772 , p6_a78
773 , p6_a79
774 , p6_a80
775 , p6_a81
776 , p6_a82
777 );
778
779
780 end;
781
782 procedure submit_for_approval(p_api_version NUMBER
783 , p_init_msg_list VARCHAR2
784 , x_return_status out nocopy VARCHAR2
785 , x_msg_count out nocopy NUMBER
786 , x_msg_data out nocopy VARCHAR2
787 , p6_a0 out nocopy NUMBER
788 , p6_a1 out nocopy NUMBER
789 , p6_a2 out nocopy VARCHAR2
790 , p6_a3 out nocopy VARCHAR2
791 , p6_a4 out nocopy VARCHAR2
792 , p6_a5 out nocopy VARCHAR2
793 , p6_a6 out nocopy VARCHAR2
794 , p6_a7 out nocopy VARCHAR2
795 , p6_a8 out nocopy VARCHAR2
796 , p6_a9 out nocopy NUMBER
797 , p6_a10 out nocopy NUMBER
798 , p6_a11 out nocopy NUMBER
799 , p6_a12 out nocopy NUMBER
800 , p6_a13 out nocopy VARCHAR2
801 , p6_a14 out nocopy VARCHAR2
802 , p6_a15 out nocopy VARCHAR2
803 , p6_a16 out nocopy DATE
804 , p6_a17 out nocopy DATE
805 , p6_a18 out nocopy DATE
806 , p6_a19 out nocopy DATE
807 , p6_a20 out nocopy VARCHAR2
808 , p6_a21 out nocopy VARCHAR2
809 , p6_a22 out nocopy NUMBER
810 , p6_a23 out nocopy NUMBER
811 , p6_a24 out nocopy NUMBER
812 , p6_a25 out nocopy NUMBER
813 , p6_a26 out nocopy DATE
814 , p6_a27 out nocopy DATE
815 , p6_a28 out nocopy NUMBER
816 , p6_a29 out nocopy NUMBER
817 , p6_a30 out nocopy VARCHAR2
818 , p6_a31 out nocopy DATE
819 , p6_a32 out nocopy VARCHAR2
820 , p6_a33 out nocopy NUMBER
821 , p6_a34 out nocopy DATE
822 , p6_a35 out nocopy NUMBER
823 , p6_a36 out nocopy NUMBER
824 , p6_a37 out nocopy VARCHAR2
825 , p6_a38 out nocopy VARCHAR2
826 , p6_a39 out nocopy VARCHAR2
827 , p6_a40 out nocopy DATE
828 , p6_a41 out nocopy VARCHAR2
829 , p6_a42 out nocopy VARCHAR2
830 , p6_a43 out nocopy VARCHAR2
831 , p6_a44 out nocopy VARCHAR2
832 , p6_a45 out nocopy VARCHAR2
833 , p6_a46 out nocopy VARCHAR2
834 , p6_a47 out nocopy VARCHAR2
835 , p6_a48 out nocopy VARCHAR2
836 , p6_a49 out nocopy VARCHAR2
837 , p6_a50 out nocopy VARCHAR2
838 , p6_a51 out nocopy VARCHAR2
839 , p6_a52 out nocopy VARCHAR2
840 , p6_a53 out nocopy VARCHAR2
841 , p6_a54 out nocopy VARCHAR2
842 , p6_a55 out nocopy VARCHAR2
843 , p6_a56 out nocopy VARCHAR2
844 , p6_a57 out nocopy DATE
845 , p6_a58 out nocopy NUMBER
846 , p6_a59 out nocopy NUMBER
847 , p6_a60 out nocopy NUMBER
848 , p6_a61 out nocopy NUMBER
849 , p6_a62 out nocopy NUMBER
850 , p6_a63 out nocopy DATE
851 , p6_a64 out nocopy NUMBER
852 , p6_a65 out nocopy DATE
853 , p6_a66 out nocopy NUMBER
854 , p6_a67 out nocopy DATE
855 , p6_a68 out nocopy NUMBER
856 , p6_a69 out nocopy NUMBER
857 , p6_a70 out nocopy VARCHAR2
858 , p6_a71 out nocopy NUMBER
859 , p6_a72 out nocopy NUMBER
860 , p6_a73 out nocopy NUMBER
861 , p6_a74 out nocopy NUMBER
862 , p6_a75 out nocopy NUMBER
863 , p6_a76 out nocopy VARCHAR2
864 , p6_a77 out nocopy VARCHAR2
865 , p6_a78 out nocopy VARCHAR2
866 , p6_a79 out nocopy NUMBER
867 , p6_a80 out nocopy DATE
868 , p6_a81 out nocopy NUMBER
869 , p6_a82 out nocopy VARCHAR2
870 , p5_a0 NUMBER := 0-1962.0724
871 , p5_a1 NUMBER := 0-1962.0724
872 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
873 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
874 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
875 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
876 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
877 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
878 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
879 , p5_a9 NUMBER := 0-1962.0724
880 , p5_a10 NUMBER := 0-1962.0724
881 , p5_a11 NUMBER := 0-1962.0724
882 , p5_a12 NUMBER := 0-1962.0724
883 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
884 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
885 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
886 , p5_a16 DATE := fnd_api.g_miss_date
887 , p5_a17 DATE := fnd_api.g_miss_date
888 , p5_a18 DATE := fnd_api.g_miss_date
889 , p5_a19 DATE := fnd_api.g_miss_date
890 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
891 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
892 , p5_a22 NUMBER := 0-1962.0724
893 , p5_a23 NUMBER := 0-1962.0724
894 , p5_a24 NUMBER := 0-1962.0724
895 , p5_a25 NUMBER := 0-1962.0724
896 , p5_a26 DATE := fnd_api.g_miss_date
897 , p5_a27 DATE := fnd_api.g_miss_date
898 , p5_a28 NUMBER := 0-1962.0724
899 , p5_a29 NUMBER := 0-1962.0724
900 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
901 , p5_a31 DATE := fnd_api.g_miss_date
902 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
903 , p5_a33 NUMBER := 0-1962.0724
904 , p5_a34 DATE := fnd_api.g_miss_date
905 , p5_a35 NUMBER := 0-1962.0724
906 , p5_a36 NUMBER := 0-1962.0724
907 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
908 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
909 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
910 , p5_a40 DATE := fnd_api.g_miss_date
911 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
912 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
913 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
914 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
915 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
916 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
917 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
918 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
919 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
920 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
921 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
922 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
923 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
924 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
925 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
926 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
927 , p5_a57 DATE := fnd_api.g_miss_date
928 , p5_a58 NUMBER := 0-1962.0724
929 , p5_a59 NUMBER := 0-1962.0724
930 , p5_a60 NUMBER := 0-1962.0724
931 , p5_a61 NUMBER := 0-1962.0724
932 , p5_a62 NUMBER := 0-1962.0724
933 , p5_a63 DATE := fnd_api.g_miss_date
934 , p5_a64 NUMBER := 0-1962.0724
935 , p5_a65 DATE := fnd_api.g_miss_date
936 , p5_a66 NUMBER := 0-1962.0724
937 , p5_a67 DATE := fnd_api.g_miss_date
938 , p5_a68 NUMBER := 0-1962.0724
939 , p5_a69 NUMBER := 0-1962.0724
940 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
941 , p5_a71 NUMBER := 0-1962.0724
942 , p5_a72 NUMBER := 0-1962.0724
943 , p5_a73 NUMBER := 0-1962.0724
944 , p5_a74 NUMBER := 0-1962.0724
945 , p5_a75 NUMBER := 0-1962.0724
946 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
947 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
948 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
949 , p5_a79 NUMBER := 0-1962.0724
950 , p5_a80 DATE := fnd_api.g_miss_date
951 , p5_a81 NUMBER := 0-1962.0724
952 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
953 )
954
955 as
956 ddp_term_rec okl_am_termnt_quote_pub.term_rec_type;
957 ddx_term_rec okl_am_termnt_quote_pub.term_rec_type;
958 ddindx binary_integer; indx binary_integer;
959 begin
960
961 -- copy data to the local IN or IN-OUT args, if any
962
963
964
965
966
967 ddp_term_rec.id := rosetta_g_miss_num_map(p5_a0);
968 ddp_term_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
969 ddp_term_rec.sfwt_flag := p5_a2;
970 ddp_term_rec.qrs_code := p5_a3;
971 ddp_term_rec.qst_code := p5_a4;
972 ddp_term_rec.qtp_code := p5_a5;
973 ddp_term_rec.trn_code := p5_a6;
974 ddp_term_rec.pop_code_end := p5_a7;
975 ddp_term_rec.pop_code_early := p5_a8;
976 ddp_term_rec.consolidated_qte_id := rosetta_g_miss_num_map(p5_a9);
977 ddp_term_rec.khr_id := rosetta_g_miss_num_map(p5_a10);
978 ddp_term_rec.art_id := rosetta_g_miss_num_map(p5_a11);
979 ddp_term_rec.pdt_id := rosetta_g_miss_num_map(p5_a12);
980 ddp_term_rec.early_termination_yn := p5_a13;
981 ddp_term_rec.partial_yn := p5_a14;
982 ddp_term_rec.preproceeds_yn := p5_a15;
983 ddp_term_rec.date_requested := rosetta_g_miss_date_in_map(p5_a16);
984 ddp_term_rec.date_proposal := rosetta_g_miss_date_in_map(p5_a17);
985 ddp_term_rec.date_effective_to := rosetta_g_miss_date_in_map(p5_a18);
986 ddp_term_rec.date_accepted := rosetta_g_miss_date_in_map(p5_a19);
987 ddp_term_rec.summary_format_yn := p5_a20;
988 ddp_term_rec.consolidated_yn := p5_a21;
989 ddp_term_rec.principal_paydown_amount := rosetta_g_miss_num_map(p5_a22);
990 ddp_term_rec.residual_amount := rosetta_g_miss_num_map(p5_a23);
991 ddp_term_rec.yield := rosetta_g_miss_num_map(p5_a24);
992 ddp_term_rec.rent_amount := rosetta_g_miss_num_map(p5_a25);
993 ddp_term_rec.date_restructure_end := rosetta_g_miss_date_in_map(p5_a26);
994 ddp_term_rec.date_restructure_start := rosetta_g_miss_date_in_map(p5_a27);
995 ddp_term_rec.term := rosetta_g_miss_num_map(p5_a28);
996 ddp_term_rec.purchase_percent := rosetta_g_miss_num_map(p5_a29);
997 ddp_term_rec.comments := p5_a30;
998 ddp_term_rec.date_due := rosetta_g_miss_date_in_map(p5_a31);
999 ddp_term_rec.payment_frequency := p5_a32;
1000 ddp_term_rec.remaining_payments := rosetta_g_miss_num_map(p5_a33);
1001 ddp_term_rec.date_effective_from := rosetta_g_miss_date_in_map(p5_a34);
1002 ddp_term_rec.quote_number := rosetta_g_miss_num_map(p5_a35);
1003 ddp_term_rec.requested_by := rosetta_g_miss_num_map(p5_a36);
1004 ddp_term_rec.approved_yn := p5_a37;
1005 ddp_term_rec.accepted_yn := p5_a38;
1006 ddp_term_rec.payment_received_yn := p5_a39;
1007 ddp_term_rec.date_payment_received := rosetta_g_miss_date_in_map(p5_a40);
1008 ddp_term_rec.attribute_category := p5_a41;
1009 ddp_term_rec.attribute1 := p5_a42;
1010 ddp_term_rec.attribute2 := p5_a43;
1011 ddp_term_rec.attribute3 := p5_a44;
1012 ddp_term_rec.attribute4 := p5_a45;
1013 ddp_term_rec.attribute5 := p5_a46;
1014 ddp_term_rec.attribute6 := p5_a47;
1015 ddp_term_rec.attribute7 := p5_a48;
1016 ddp_term_rec.attribute8 := p5_a49;
1017 ddp_term_rec.attribute9 := p5_a50;
1018 ddp_term_rec.attribute10 := p5_a51;
1019 ddp_term_rec.attribute11 := p5_a52;
1020 ddp_term_rec.attribute12 := p5_a53;
1021 ddp_term_rec.attribute13 := p5_a54;
1022 ddp_term_rec.attribute14 := p5_a55;
1023 ddp_term_rec.attribute15 := p5_a56;
1024 ddp_term_rec.date_approved := rosetta_g_miss_date_in_map(p5_a57);
1025 ddp_term_rec.approved_by := rosetta_g_miss_num_map(p5_a58);
1026 ddp_term_rec.org_id := rosetta_g_miss_num_map(p5_a59);
1027 ddp_term_rec.request_id := rosetta_g_miss_num_map(p5_a60);
1028 ddp_term_rec.program_application_id := rosetta_g_miss_num_map(p5_a61);
1029 ddp_term_rec.program_id := rosetta_g_miss_num_map(p5_a62);
1030 ddp_term_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a63);
1031 ddp_term_rec.created_by := rosetta_g_miss_num_map(p5_a64);
1032 ddp_term_rec.creation_date := rosetta_g_miss_date_in_map(p5_a65);
1033 ddp_term_rec.last_updated_by := rosetta_g_miss_num_map(p5_a66);
1034 ddp_term_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a67);
1035 ddp_term_rec.last_update_login := rosetta_g_miss_num_map(p5_a68);
1036 ddp_term_rec.purchase_amount := rosetta_g_miss_num_map(p5_a69);
1037 ddp_term_rec.purchase_formula := p5_a70;
1038 ddp_term_rec.asset_value := rosetta_g_miss_num_map(p5_a71);
1039 ddp_term_rec.residual_value := rosetta_g_miss_num_map(p5_a72);
1040 ddp_term_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a73);
1041 ddp_term_rec.gain_loss := rosetta_g_miss_num_map(p5_a74);
1042 ddp_term_rec.perdiem_amount := rosetta_g_miss_num_map(p5_a75);
1043 ddp_term_rec.currency_code := p5_a76;
1044 ddp_term_rec.currency_conversion_code := p5_a77;
1045 ddp_term_rec.currency_conversion_type := p5_a78;
1046 ddp_term_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a79);
1047 ddp_term_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
1048 ddp_term_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
1049 ddp_term_rec.repo_quote_indicator_yn := p5_a82;
1050
1051
1052 -- here's the delegated call to the old PL/SQL routine
1053 okl_am_termnt_quote_pub.submit_for_approval(p_api_version,
1054 p_init_msg_list,
1055 x_return_status,
1056 x_msg_count,
1057 x_msg_data,
1058 ddp_term_rec,
1059 ddx_term_rec);
1060
1061 -- copy data back from the local variables to OUT or IN-OUT args, if any
1062
1063
1064
1065
1066
1067
1068 p6_a0 := rosetta_g_miss_num_map(ddx_term_rec.id);
1069 p6_a1 := rosetta_g_miss_num_map(ddx_term_rec.object_version_number);
1070 p6_a2 := ddx_term_rec.sfwt_flag;
1071 p6_a3 := ddx_term_rec.qrs_code;
1072 p6_a4 := ddx_term_rec.qst_code;
1073 p6_a5 := ddx_term_rec.qtp_code;
1074 p6_a6 := ddx_term_rec.trn_code;
1075 p6_a7 := ddx_term_rec.pop_code_end;
1076 p6_a8 := ddx_term_rec.pop_code_early;
1077 p6_a9 := rosetta_g_miss_num_map(ddx_term_rec.consolidated_qte_id);
1078 p6_a10 := rosetta_g_miss_num_map(ddx_term_rec.khr_id);
1079 p6_a11 := rosetta_g_miss_num_map(ddx_term_rec.art_id);
1080 p6_a12 := rosetta_g_miss_num_map(ddx_term_rec.pdt_id);
1081 p6_a13 := ddx_term_rec.early_termination_yn;
1082 p6_a14 := ddx_term_rec.partial_yn;
1083 p6_a15 := ddx_term_rec.preproceeds_yn;
1084 p6_a16 := ddx_term_rec.date_requested;
1085 p6_a17 := ddx_term_rec.date_proposal;
1086 p6_a18 := ddx_term_rec.date_effective_to;
1087 p6_a19 := ddx_term_rec.date_accepted;
1088 p6_a20 := ddx_term_rec.summary_format_yn;
1089 p6_a21 := ddx_term_rec.consolidated_yn;
1090 p6_a22 := rosetta_g_miss_num_map(ddx_term_rec.principal_paydown_amount);
1091 p6_a23 := rosetta_g_miss_num_map(ddx_term_rec.residual_amount);
1092 p6_a24 := rosetta_g_miss_num_map(ddx_term_rec.yield);
1093 p6_a25 := rosetta_g_miss_num_map(ddx_term_rec.rent_amount);
1094 p6_a26 := ddx_term_rec.date_restructure_end;
1095 p6_a27 := ddx_term_rec.date_restructure_start;
1096 p6_a28 := rosetta_g_miss_num_map(ddx_term_rec.term);
1097 p6_a29 := rosetta_g_miss_num_map(ddx_term_rec.purchase_percent);
1098 p6_a30 := ddx_term_rec.comments;
1099 p6_a31 := ddx_term_rec.date_due;
1100 p6_a32 := ddx_term_rec.payment_frequency;
1101 p6_a33 := rosetta_g_miss_num_map(ddx_term_rec.remaining_payments);
1102 p6_a34 := ddx_term_rec.date_effective_from;
1103 p6_a35 := rosetta_g_miss_num_map(ddx_term_rec.quote_number);
1104 p6_a36 := rosetta_g_miss_num_map(ddx_term_rec.requested_by);
1105 p6_a37 := ddx_term_rec.approved_yn;
1106 p6_a38 := ddx_term_rec.accepted_yn;
1107 p6_a39 := ddx_term_rec.payment_received_yn;
1108 p6_a40 := ddx_term_rec.date_payment_received;
1109 p6_a41 := ddx_term_rec.attribute_category;
1110 p6_a42 := ddx_term_rec.attribute1;
1111 p6_a43 := ddx_term_rec.attribute2;
1112 p6_a44 := ddx_term_rec.attribute3;
1113 p6_a45 := ddx_term_rec.attribute4;
1114 p6_a46 := ddx_term_rec.attribute5;
1115 p6_a47 := ddx_term_rec.attribute6;
1116 p6_a48 := ddx_term_rec.attribute7;
1117 p6_a49 := ddx_term_rec.attribute8;
1118 p6_a50 := ddx_term_rec.attribute9;
1119 p6_a51 := ddx_term_rec.attribute10;
1120 p6_a52 := ddx_term_rec.attribute11;
1121 p6_a53 := ddx_term_rec.attribute12;
1122 p6_a54 := ddx_term_rec.attribute13;
1123 p6_a55 := ddx_term_rec.attribute14;
1124 p6_a56 := ddx_term_rec.attribute15;
1125 p6_a57 := ddx_term_rec.date_approved;
1126 p6_a58 := rosetta_g_miss_num_map(ddx_term_rec.approved_by);
1127 p6_a59 := rosetta_g_miss_num_map(ddx_term_rec.org_id);
1128 p6_a60 := rosetta_g_miss_num_map(ddx_term_rec.request_id);
1129 p6_a61 := rosetta_g_miss_num_map(ddx_term_rec.program_application_id);
1130 p6_a62 := rosetta_g_miss_num_map(ddx_term_rec.program_id);
1131 p6_a63 := ddx_term_rec.program_update_date;
1132 p6_a64 := rosetta_g_miss_num_map(ddx_term_rec.created_by);
1133 p6_a65 := ddx_term_rec.creation_date;
1134 p6_a66 := rosetta_g_miss_num_map(ddx_term_rec.last_updated_by);
1135 p6_a67 := ddx_term_rec.last_update_date;
1136 p6_a68 := rosetta_g_miss_num_map(ddx_term_rec.last_update_login);
1137 p6_a69 := rosetta_g_miss_num_map(ddx_term_rec.purchase_amount);
1138 p6_a70 := ddx_term_rec.purchase_formula;
1139 p6_a71 := rosetta_g_miss_num_map(ddx_term_rec.asset_value);
1140 p6_a72 := rosetta_g_miss_num_map(ddx_term_rec.residual_value);
1141 p6_a73 := rosetta_g_miss_num_map(ddx_term_rec.unbilled_receivables);
1142 p6_a74 := rosetta_g_miss_num_map(ddx_term_rec.gain_loss);
1143 p6_a75 := rosetta_g_miss_num_map(ddx_term_rec.perdiem_amount);
1144 p6_a76 := ddx_term_rec.currency_code;
1145 p6_a77 := ddx_term_rec.currency_conversion_code;
1146 p6_a78 := ddx_term_rec.currency_conversion_type;
1147 p6_a79 := rosetta_g_miss_num_map(ddx_term_rec.currency_conversion_rate);
1148 p6_a80 := ddx_term_rec.currency_conversion_date;
1149 p6_a81 := rosetta_g_miss_num_map(ddx_term_rec.legal_entity_id);
1150 p6_a82 := ddx_term_rec.repo_quote_indicator_yn;
1151 end;
1152
1153 procedure quote_line_dtls(p_api_version NUMBER
1154 , p_init_msg_list VARCHAR2
1155 , x_return_status out nocopy VARCHAR2
1156 , x_msg_count out nocopy NUMBER
1157 , x_msg_data out nocopy VARCHAR2
1158 , p5_a0 in out nocopy JTF_VARCHAR2_TABLE_100
1159 , p5_a1 in out nocopy JTF_NUMBER_TABLE
1160 , p5_a2 in out nocopy JTF_NUMBER_TABLE
1161 , p5_a3 in out nocopy JTF_NUMBER_TABLE
1162 , p5_a4 in out nocopy JTF_NUMBER_TABLE
1163 , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1164 , p5_a6 in out nocopy JTF_NUMBER_TABLE
1165 , p5_a7 in out nocopy JTF_NUMBER_TABLE
1166 , p5_a8 in out nocopy JTF_NUMBER_TABLE
1167 )
1168
1169 as
1170 ddp_qld_tbl okl_am_termnt_quote_pub.qte_ln_dtl_tbl;
1171 ddindx binary_integer; indx binary_integer;
1172 begin
1173
1174 -- copy data to the local IN or IN-OUT args, if any
1175
1176
1177
1178
1179
1180 okl_am_termnt_quote_pvt_w.rosetta_table_copy_in_p11(ddp_qld_tbl, p5_a0
1181 , p5_a1
1182 , p5_a2
1183 , p5_a3
1184 , p5_a4
1185 , p5_a5
1186 , p5_a6
1187 , p5_a7
1188 , p5_a8
1189 );
1190
1191 -- here's the delegated call to the old PL/SQL routine
1192 okl_am_termnt_quote_pub.quote_line_dtls(p_api_version,
1193 p_init_msg_list,
1194 x_return_status,
1195 x_msg_count,
1196 x_msg_data,
1197 ddp_qld_tbl);
1198
1199 -- copy data back from the local variables to OUT or IN-OUT args, if any
1200
1201
1202
1203
1204
1205 okl_am_termnt_quote_pvt_w.rosetta_table_copy_out_p11(ddp_qld_tbl, p5_a0
1206 , p5_a1
1207 , p5_a2
1208 , p5_a3
1209 , p5_a4
1210 , p5_a5
1211 , p5_a6
1212 , p5_a7
1213 , p5_a8
1214 );
1215 end;
1216
1217 procedure create_quote_line(p_api_version NUMBER
1218 , p_init_msg_list VARCHAR2
1219 , x_return_status out nocopy VARCHAR2
1220 , x_msg_count out nocopy NUMBER
1221 , x_msg_data out nocopy VARCHAR2
1222 , p6_a0 out nocopy NUMBER
1223 , p6_a1 out nocopy NUMBER
1224 , p6_a2 out nocopy VARCHAR2
1225 , p6_a3 out nocopy VARCHAR2
1226 , p6_a4 out nocopy NUMBER
1227 , p6_a5 out nocopy NUMBER
1228 , p6_a6 out nocopy NUMBER
1229 , p6_a7 out nocopy NUMBER
1230 , p6_a8 out nocopy VARCHAR2
1231 , p6_a9 out nocopy NUMBER
1232 , p6_a10 out nocopy VARCHAR2
1233 , p6_a11 out nocopy VARCHAR2
1234 , p6_a12 out nocopy VARCHAR2
1235 , p6_a13 out nocopy VARCHAR2
1236 , p6_a14 out nocopy VARCHAR2
1237 , p6_a15 out nocopy VARCHAR2
1238 , p6_a16 out nocopy VARCHAR2
1239 , p6_a17 out nocopy VARCHAR2
1240 , p6_a18 out nocopy VARCHAR2
1241 , p6_a19 out nocopy VARCHAR2
1242 , p6_a20 out nocopy VARCHAR2
1243 , p6_a21 out nocopy VARCHAR2
1244 , p6_a22 out nocopy VARCHAR2
1245 , p6_a23 out nocopy VARCHAR2
1246 , p6_a24 out nocopy VARCHAR2
1247 , p6_a25 out nocopy VARCHAR2
1248 , p6_a26 out nocopy VARCHAR2
1249 , p6_a27 out nocopy VARCHAR2
1250 , p6_a28 out nocopy VARCHAR2
1251 , p6_a29 out nocopy NUMBER
1252 , p6_a30 out nocopy NUMBER
1253 , p6_a31 out nocopy NUMBER
1254 , p6_a32 out nocopy NUMBER
1255 , p6_a33 out nocopy DATE
1256 , p6_a34 out nocopy NUMBER
1257 , p6_a35 out nocopy DATE
1258 , p6_a36 out nocopy NUMBER
1259 , p6_a37 out nocopy DATE
1260 , p6_a38 out nocopy NUMBER
1261 , p6_a39 out nocopy DATE
1262 , p6_a40 out nocopy VARCHAR2
1263 , p6_a41 out nocopy NUMBER
1264 , p6_a42 out nocopy VARCHAR2
1265 , p6_a43 out nocopy VARCHAR2
1266 , p6_a44 out nocopy VARCHAR2
1267 , p6_a45 out nocopy NUMBER
1268 , p6_a46 out nocopy NUMBER
1269 , p6_a47 out nocopy NUMBER
1270 , p6_a48 out nocopy NUMBER
1271 , p6_a49 out nocopy NUMBER
1272 , p6_a50 out nocopy NUMBER
1273 , p6_a51 out nocopy NUMBER
1274 , p6_a52 out nocopy NUMBER
1275 , p6_a53 out nocopy VARCHAR2
1276 , p6_a54 out nocopy VARCHAR2
1277 , p6_a55 out nocopy VARCHAR2
1278 , p6_a56 out nocopy VARCHAR2
1279 , p6_a57 out nocopy NUMBER
1280 , p6_a58 out nocopy DATE
1281 , p6_a59 out nocopy DATE
1282 , p6_a60 out nocopy NUMBER
1283 , p5_a0 NUMBER := 0-1962.0724
1284 , p5_a1 NUMBER := 0-1962.0724
1285 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1286 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1287 , p5_a4 NUMBER := 0-1962.0724
1288 , p5_a5 NUMBER := 0-1962.0724
1289 , p5_a6 NUMBER := 0-1962.0724
1290 , p5_a7 NUMBER := 0-1962.0724
1291 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1292 , p5_a9 NUMBER := 0-1962.0724
1293 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1294 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1295 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1296 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1297 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1298 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1299 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1300 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1301 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1302 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1303 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1304 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1305 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1306 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1307 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1308 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1309 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1310 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1311 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1312 , p5_a29 NUMBER := 0-1962.0724
1313 , p5_a30 NUMBER := 0-1962.0724
1314 , p5_a31 NUMBER := 0-1962.0724
1315 , p5_a32 NUMBER := 0-1962.0724
1316 , p5_a33 DATE := fnd_api.g_miss_date
1317 , p5_a34 NUMBER := 0-1962.0724
1318 , p5_a35 DATE := fnd_api.g_miss_date
1319 , p5_a36 NUMBER := 0-1962.0724
1320 , p5_a37 DATE := fnd_api.g_miss_date
1321 , p5_a38 NUMBER := 0-1962.0724
1322 , p5_a39 DATE := fnd_api.g_miss_date
1323 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1324 , p5_a41 NUMBER := 0-1962.0724
1325 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1326 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1327 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1328 , p5_a45 NUMBER := 0-1962.0724
1329 , p5_a46 NUMBER := 0-1962.0724
1330 , p5_a47 NUMBER := 0-1962.0724
1331 , p5_a48 NUMBER := 0-1962.0724
1332 , p5_a49 NUMBER := 0-1962.0724
1333 , p5_a50 NUMBER := 0-1962.0724
1334 , p5_a51 NUMBER := 0-1962.0724
1335 , p5_a52 NUMBER := 0-1962.0724
1336 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1337 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1338 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1339 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
1340 , p5_a57 NUMBER := 0-1962.0724
1341 , p5_a58 DATE := fnd_api.g_miss_date
1342 , p5_a59 DATE := fnd_api.g_miss_date
1343 , p5_a60 NUMBER := 0-1962.0724
1344 )
1345
1346 as
1347 ddp_tqlv_rec okl_am_termnt_quote_pub.tqlv_rec_type;
1348 ddx_tqlv_rec okl_am_termnt_quote_pub.tqlv_rec_type;
1349 ddindx binary_integer; indx binary_integer;
1350 begin
1351
1352 -- copy data to the local IN or IN-OUT args, if any
1353
1354
1355
1356
1357
1358 ddp_tqlv_rec.id := rosetta_g_miss_num_map(p5_a0);
1359 ddp_tqlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1360 ddp_tqlv_rec.sfwt_flag := p5_a2;
1361 ddp_tqlv_rec.qlt_code := p5_a3;
1362 ddp_tqlv_rec.kle_id := rosetta_g_miss_num_map(p5_a4);
1363 ddp_tqlv_rec.sty_id := rosetta_g_miss_num_map(p5_a5);
1364 ddp_tqlv_rec.qte_id := rosetta_g_miss_num_map(p5_a6);
1365 ddp_tqlv_rec.line_number := rosetta_g_miss_num_map(p5_a7);
1366 ddp_tqlv_rec.description := p5_a8;
1367 ddp_tqlv_rec.amount := rosetta_g_miss_num_map(p5_a9);
1368 ddp_tqlv_rec.modified_yn := p5_a10;
1369 ddp_tqlv_rec.taxed_yn := p5_a11;
1370 ddp_tqlv_rec.defaulted_yn := p5_a12;
1371 ddp_tqlv_rec.attribute_category := p5_a13;
1372 ddp_tqlv_rec.attribute1 := p5_a14;
1373 ddp_tqlv_rec.attribute2 := p5_a15;
1374 ddp_tqlv_rec.attribute3 := p5_a16;
1375 ddp_tqlv_rec.attribute4 := p5_a17;
1376 ddp_tqlv_rec.attribute5 := p5_a18;
1377 ddp_tqlv_rec.attribute6 := p5_a19;
1378 ddp_tqlv_rec.attribute7 := p5_a20;
1379 ddp_tqlv_rec.attribute8 := p5_a21;
1380 ddp_tqlv_rec.attribute9 := p5_a22;
1381 ddp_tqlv_rec.attribute10 := p5_a23;
1382 ddp_tqlv_rec.attribute11 := p5_a24;
1383 ddp_tqlv_rec.attribute12 := p5_a25;
1384 ddp_tqlv_rec.attribute13 := p5_a26;
1385 ddp_tqlv_rec.attribute14 := p5_a27;
1386 ddp_tqlv_rec.attribute15 := p5_a28;
1387 ddp_tqlv_rec.org_id := rosetta_g_miss_num_map(p5_a29);
1388 ddp_tqlv_rec.request_id := rosetta_g_miss_num_map(p5_a30);
1389 ddp_tqlv_rec.program_application_id := rosetta_g_miss_num_map(p5_a31);
1390 ddp_tqlv_rec.program_id := rosetta_g_miss_num_map(p5_a32);
1391 ddp_tqlv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a33);
1392 ddp_tqlv_rec.created_by := rosetta_g_miss_num_map(p5_a34);
1393 ddp_tqlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a35);
1394 ddp_tqlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a36);
1395 ddp_tqlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a37);
1396 ddp_tqlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a38);
1397 ddp_tqlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a39);
1398 ddp_tqlv_rec.period := p5_a40;
1399 ddp_tqlv_rec.number_of_periods := rosetta_g_miss_num_map(p5_a41);
1400 ddp_tqlv_rec.lock_level_step := p5_a42;
1401 ddp_tqlv_rec.advance_or_arrears := p5_a43;
1402 ddp_tqlv_rec.yield_name := p5_a44;
1403 ddp_tqlv_rec.yield_value := rosetta_g_miss_num_map(p5_a45);
1404 ddp_tqlv_rec.implicit_interest_rate := rosetta_g_miss_num_map(p5_a46);
1405 ddp_tqlv_rec.asset_value := rosetta_g_miss_num_map(p5_a47);
1406 ddp_tqlv_rec.residual_value := rosetta_g_miss_num_map(p5_a48);
1407 ddp_tqlv_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a49);
1408 ddp_tqlv_rec.asset_quantity := rosetta_g_miss_num_map(p5_a50);
1409 ddp_tqlv_rec.quote_quantity := rosetta_g_miss_num_map(p5_a51);
1410 ddp_tqlv_rec.split_kle_id := rosetta_g_miss_num_map(p5_a52);
1411 ddp_tqlv_rec.split_kle_name := p5_a53;
1412 ddp_tqlv_rec.currency_code := p5_a54;
1413 ddp_tqlv_rec.currency_conversion_code := p5_a55;
1414 ddp_tqlv_rec.currency_conversion_type := p5_a56;
1415 ddp_tqlv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a57);
1416 ddp_tqlv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a58);
1417 ddp_tqlv_rec.due_date := rosetta_g_miss_date_in_map(p5_a59);
1418 ddp_tqlv_rec.try_id := rosetta_g_miss_num_map(p5_a60);
1419
1420
1421 -- here's the delegated call to the old PL/SQL routine
1422 okl_am_termnt_quote_pub.create_quote_line(p_api_version,
1423 p_init_msg_list,
1424 x_return_status,
1425 x_msg_count,
1426 x_msg_data,
1427 ddp_tqlv_rec,
1428 ddx_tqlv_rec);
1429
1430 -- copy data back from the local variables to OUT or IN-OUT args, if any
1431
1432
1433
1434
1435
1436
1437 p6_a0 := rosetta_g_miss_num_map(ddx_tqlv_rec.id);
1438 p6_a1 := rosetta_g_miss_num_map(ddx_tqlv_rec.object_version_number);
1439 p6_a2 := ddx_tqlv_rec.sfwt_flag;
1440 p6_a3 := ddx_tqlv_rec.qlt_code;
1441 p6_a4 := rosetta_g_miss_num_map(ddx_tqlv_rec.kle_id);
1442 p6_a5 := rosetta_g_miss_num_map(ddx_tqlv_rec.sty_id);
1443 p6_a6 := rosetta_g_miss_num_map(ddx_tqlv_rec.qte_id);
1444 p6_a7 := rosetta_g_miss_num_map(ddx_tqlv_rec.line_number);
1445 p6_a8 := ddx_tqlv_rec.description;
1446 p6_a9 := rosetta_g_miss_num_map(ddx_tqlv_rec.amount);
1447 p6_a10 := ddx_tqlv_rec.modified_yn;
1448 p6_a11 := ddx_tqlv_rec.taxed_yn;
1449 p6_a12 := ddx_tqlv_rec.defaulted_yn;
1450 p6_a13 := ddx_tqlv_rec.attribute_category;
1451 p6_a14 := ddx_tqlv_rec.attribute1;
1452 p6_a15 := ddx_tqlv_rec.attribute2;
1453 p6_a16 := ddx_tqlv_rec.attribute3;
1454 p6_a17 := ddx_tqlv_rec.attribute4;
1455 p6_a18 := ddx_tqlv_rec.attribute5;
1456 p6_a19 := ddx_tqlv_rec.attribute6;
1457 p6_a20 := ddx_tqlv_rec.attribute7;
1458 p6_a21 := ddx_tqlv_rec.attribute8;
1459 p6_a22 := ddx_tqlv_rec.attribute9;
1460 p6_a23 := ddx_tqlv_rec.attribute10;
1461 p6_a24 := ddx_tqlv_rec.attribute11;
1462 p6_a25 := ddx_tqlv_rec.attribute12;
1463 p6_a26 := ddx_tqlv_rec.attribute13;
1464 p6_a27 := ddx_tqlv_rec.attribute14;
1465 p6_a28 := ddx_tqlv_rec.attribute15;
1466 p6_a29 := rosetta_g_miss_num_map(ddx_tqlv_rec.org_id);
1467 p6_a30 := rosetta_g_miss_num_map(ddx_tqlv_rec.request_id);
1468 p6_a31 := rosetta_g_miss_num_map(ddx_tqlv_rec.program_application_id);
1469 p6_a32 := rosetta_g_miss_num_map(ddx_tqlv_rec.program_id);
1470 p6_a33 := ddx_tqlv_rec.program_update_date;
1471 p6_a34 := rosetta_g_miss_num_map(ddx_tqlv_rec.created_by);
1472 p6_a35 := ddx_tqlv_rec.creation_date;
1473 p6_a36 := rosetta_g_miss_num_map(ddx_tqlv_rec.last_updated_by);
1474 p6_a37 := ddx_tqlv_rec.last_update_date;
1475 p6_a38 := rosetta_g_miss_num_map(ddx_tqlv_rec.last_update_login);
1476 p6_a39 := ddx_tqlv_rec.start_date;
1477 p6_a40 := ddx_tqlv_rec.period;
1478 p6_a41 := rosetta_g_miss_num_map(ddx_tqlv_rec.number_of_periods);
1479 p6_a42 := ddx_tqlv_rec.lock_level_step;
1480 p6_a43 := ddx_tqlv_rec.advance_or_arrears;
1481 p6_a44 := ddx_tqlv_rec.yield_name;
1482 p6_a45 := rosetta_g_miss_num_map(ddx_tqlv_rec.yield_value);
1483 p6_a46 := rosetta_g_miss_num_map(ddx_tqlv_rec.implicit_interest_rate);
1484 p6_a47 := rosetta_g_miss_num_map(ddx_tqlv_rec.asset_value);
1485 p6_a48 := rosetta_g_miss_num_map(ddx_tqlv_rec.residual_value);
1486 p6_a49 := rosetta_g_miss_num_map(ddx_tqlv_rec.unbilled_receivables);
1487 p6_a50 := rosetta_g_miss_num_map(ddx_tqlv_rec.asset_quantity);
1488 p6_a51 := rosetta_g_miss_num_map(ddx_tqlv_rec.quote_quantity);
1489 p6_a52 := rosetta_g_miss_num_map(ddx_tqlv_rec.split_kle_id);
1490 p6_a53 := ddx_tqlv_rec.split_kle_name;
1491 p6_a54 := ddx_tqlv_rec.currency_code;
1492 p6_a55 := ddx_tqlv_rec.currency_conversion_code;
1493 p6_a56 := ddx_tqlv_rec.currency_conversion_type;
1494 p6_a57 := rosetta_g_miss_num_map(ddx_tqlv_rec.currency_conversion_rate);
1495 p6_a58 := ddx_tqlv_rec.currency_conversion_date;
1496 p6_a59 := ddx_tqlv_rec.due_date;
1497 p6_a60 := rosetta_g_miss_num_map(ddx_tqlv_rec.try_id);
1498 end;
1499
1500 procedure create_quote_line(p_api_version NUMBER
1501 , p_init_msg_list VARCHAR2
1502 , x_return_status out nocopy VARCHAR2
1503 , x_msg_count out nocopy NUMBER
1504 , x_msg_data out nocopy VARCHAR2
1505 , p5_a0 JTF_NUMBER_TABLE
1506 , p5_a1 JTF_NUMBER_TABLE
1507 , p5_a2 JTF_VARCHAR2_TABLE_100
1508 , p5_a3 JTF_VARCHAR2_TABLE_100
1509 , p5_a4 JTF_NUMBER_TABLE
1510 , p5_a5 JTF_NUMBER_TABLE
1511 , p5_a6 JTF_NUMBER_TABLE
1512 , p5_a7 JTF_NUMBER_TABLE
1513 , p5_a8 JTF_VARCHAR2_TABLE_2000
1514 , p5_a9 JTF_NUMBER_TABLE
1515 , p5_a10 JTF_VARCHAR2_TABLE_100
1516 , p5_a11 JTF_VARCHAR2_TABLE_100
1517 , p5_a12 JTF_VARCHAR2_TABLE_100
1518 , p5_a13 JTF_VARCHAR2_TABLE_100
1519 , p5_a14 JTF_VARCHAR2_TABLE_500
1520 , p5_a15 JTF_VARCHAR2_TABLE_500
1521 , p5_a16 JTF_VARCHAR2_TABLE_500
1522 , p5_a17 JTF_VARCHAR2_TABLE_500
1523 , p5_a18 JTF_VARCHAR2_TABLE_500
1524 , p5_a19 JTF_VARCHAR2_TABLE_500
1525 , p5_a20 JTF_VARCHAR2_TABLE_500
1526 , p5_a21 JTF_VARCHAR2_TABLE_500
1527 , p5_a22 JTF_VARCHAR2_TABLE_500
1528 , p5_a23 JTF_VARCHAR2_TABLE_500
1529 , p5_a24 JTF_VARCHAR2_TABLE_500
1530 , p5_a25 JTF_VARCHAR2_TABLE_500
1531 , p5_a26 JTF_VARCHAR2_TABLE_500
1532 , p5_a27 JTF_VARCHAR2_TABLE_500
1533 , p5_a28 JTF_VARCHAR2_TABLE_500
1534 , p5_a29 JTF_NUMBER_TABLE
1535 , p5_a30 JTF_NUMBER_TABLE
1536 , p5_a31 JTF_NUMBER_TABLE
1537 , p5_a32 JTF_NUMBER_TABLE
1538 , p5_a33 JTF_DATE_TABLE
1539 , p5_a34 JTF_NUMBER_TABLE
1540 , p5_a35 JTF_DATE_TABLE
1541 , p5_a36 JTF_NUMBER_TABLE
1542 , p5_a37 JTF_DATE_TABLE
1543 , p5_a38 JTF_NUMBER_TABLE
1544 , p5_a39 JTF_DATE_TABLE
1545 , p5_a40 JTF_VARCHAR2_TABLE_100
1546 , p5_a41 JTF_NUMBER_TABLE
1547 , p5_a42 JTF_VARCHAR2_TABLE_100
1548 , p5_a43 JTF_VARCHAR2_TABLE_100
1549 , p5_a44 JTF_VARCHAR2_TABLE_200
1550 , p5_a45 JTF_NUMBER_TABLE
1551 , p5_a46 JTF_NUMBER_TABLE
1552 , p5_a47 JTF_NUMBER_TABLE
1553 , p5_a48 JTF_NUMBER_TABLE
1554 , p5_a49 JTF_NUMBER_TABLE
1555 , p5_a50 JTF_NUMBER_TABLE
1556 , p5_a51 JTF_NUMBER_TABLE
1557 , p5_a52 JTF_NUMBER_TABLE
1558 , p5_a53 JTF_VARCHAR2_TABLE_200
1559 , p5_a54 JTF_VARCHAR2_TABLE_100
1560 , p5_a55 JTF_VARCHAR2_TABLE_100
1561 , p5_a56 JTF_VARCHAR2_TABLE_100
1562 , p5_a57 JTF_NUMBER_TABLE
1563 , p5_a58 JTF_DATE_TABLE
1564 , p5_a59 JTF_DATE_TABLE
1565 , p5_a60 JTF_NUMBER_TABLE
1566 , p6_a0 out nocopy JTF_NUMBER_TABLE
1567 , p6_a1 out nocopy JTF_NUMBER_TABLE
1568 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1569 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1570 , p6_a4 out nocopy JTF_NUMBER_TABLE
1571 , p6_a5 out nocopy JTF_NUMBER_TABLE
1572 , p6_a6 out nocopy JTF_NUMBER_TABLE
1573 , p6_a7 out nocopy JTF_NUMBER_TABLE
1574 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
1575 , p6_a9 out nocopy JTF_NUMBER_TABLE
1576 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1577 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1578 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1579 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1580 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1581 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1582 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1583 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1584 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1585 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1586 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1587 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1588 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1589 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1590 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1591 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1592 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1593 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1594 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1595 , p6_a29 out nocopy JTF_NUMBER_TABLE
1596 , p6_a30 out nocopy JTF_NUMBER_TABLE
1597 , p6_a31 out nocopy JTF_NUMBER_TABLE
1598 , p6_a32 out nocopy JTF_NUMBER_TABLE
1599 , p6_a33 out nocopy JTF_DATE_TABLE
1600 , p6_a34 out nocopy JTF_NUMBER_TABLE
1601 , p6_a35 out nocopy JTF_DATE_TABLE
1602 , p6_a36 out nocopy JTF_NUMBER_TABLE
1603 , p6_a37 out nocopy JTF_DATE_TABLE
1604 , p6_a38 out nocopy JTF_NUMBER_TABLE
1605 , p6_a39 out nocopy JTF_DATE_TABLE
1606 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1607 , p6_a41 out nocopy JTF_NUMBER_TABLE
1608 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1609 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1610 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_200
1611 , p6_a45 out nocopy JTF_NUMBER_TABLE
1612 , p6_a46 out nocopy JTF_NUMBER_TABLE
1613 , p6_a47 out nocopy JTF_NUMBER_TABLE
1614 , p6_a48 out nocopy JTF_NUMBER_TABLE
1615 , p6_a49 out nocopy JTF_NUMBER_TABLE
1616 , p6_a50 out nocopy JTF_NUMBER_TABLE
1617 , p6_a51 out nocopy JTF_NUMBER_TABLE
1618 , p6_a52 out nocopy JTF_NUMBER_TABLE
1619 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_200
1620 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
1621 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
1622 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
1623 , p6_a57 out nocopy JTF_NUMBER_TABLE
1624 , p6_a58 out nocopy JTF_DATE_TABLE
1625 , p6_a59 out nocopy JTF_DATE_TABLE
1626 , p6_a60 out nocopy JTF_NUMBER_TABLE
1627 )
1628
1629 as
1630 ddp_tqlv_tbl okl_am_termnt_quote_pub.tqlv_tbl_type;
1631 ddx_tqlv_tbl okl_am_termnt_quote_pub.tqlv_tbl_type;
1632 ddindx binary_integer; indx binary_integer;
1633 begin
1634
1635 -- copy data to the local IN or IN-OUT args, if any
1636
1637
1638
1639
1640
1641 okl_tql_pvt_w.rosetta_table_copy_in_p8(ddp_tqlv_tbl, p5_a0
1642 , p5_a1
1643 , p5_a2
1644 , p5_a3
1645 , p5_a4
1646 , p5_a5
1647 , p5_a6
1648 , p5_a7
1649 , p5_a8
1650 , p5_a9
1651 , p5_a10
1652 , p5_a11
1653 , p5_a12
1654 , p5_a13
1655 , p5_a14
1656 , p5_a15
1657 , p5_a16
1658 , p5_a17
1659 , p5_a18
1660 , p5_a19
1661 , p5_a20
1662 , p5_a21
1663 , p5_a22
1664 , p5_a23
1665 , p5_a24
1666 , p5_a25
1667 , p5_a26
1668 , p5_a27
1669 , p5_a28
1670 , p5_a29
1671 , p5_a30
1672 , p5_a31
1673 , p5_a32
1674 , p5_a33
1675 , p5_a34
1676 , p5_a35
1677 , p5_a36
1678 , p5_a37
1679 , p5_a38
1680 , p5_a39
1681 , p5_a40
1682 , p5_a41
1683 , p5_a42
1684 , p5_a43
1685 , p5_a44
1686 , p5_a45
1687 , p5_a46
1688 , p5_a47
1689 , p5_a48
1690 , p5_a49
1691 , p5_a50
1692 , p5_a51
1693 , p5_a52
1694 , p5_a53
1695 , p5_a54
1696 , p5_a55
1697 , p5_a56
1698 , p5_a57
1699 , p5_a58
1700 , p5_a59
1701 , p5_a60
1702 );
1703
1704
1705 -- here's the delegated call to the old PL/SQL routine
1706 okl_am_termnt_quote_pub.create_quote_line(p_api_version,
1707 p_init_msg_list,
1708 x_return_status,
1709 x_msg_count,
1710 x_msg_data,
1711 ddp_tqlv_tbl,
1712 ddx_tqlv_tbl);
1713
1714 -- copy data back from the local variables to OUT or IN-OUT args, if any
1715
1716
1717
1718
1719
1720
1721 okl_tql_pvt_w.rosetta_table_copy_out_p8(ddx_tqlv_tbl, p6_a0
1722 , p6_a1
1723 , p6_a2
1724 , p6_a3
1725 , p6_a4
1726 , p6_a5
1727 , p6_a6
1728 , p6_a7
1729 , p6_a8
1730 , p6_a9
1731 , p6_a10
1732 , p6_a11
1733 , p6_a12
1734 , p6_a13
1735 , p6_a14
1736 , p6_a15
1737 , p6_a16
1738 , p6_a17
1739 , p6_a18
1740 , p6_a19
1741 , p6_a20
1742 , p6_a21
1743 , p6_a22
1744 , p6_a23
1745 , p6_a24
1746 , p6_a25
1747 , p6_a26
1748 , p6_a27
1749 , p6_a28
1750 , p6_a29
1751 , p6_a30
1752 , p6_a31
1753 , p6_a32
1754 , p6_a33
1755 , p6_a34
1756 , p6_a35
1757 , p6_a36
1758 , p6_a37
1759 , p6_a38
1760 , p6_a39
1761 , p6_a40
1762 , p6_a41
1763 , p6_a42
1764 , p6_a43
1765 , p6_a44
1766 , p6_a45
1767 , p6_a46
1768 , p6_a47
1769 , p6_a48
1770 , p6_a49
1771 , p6_a50
1772 , p6_a51
1773 , p6_a52
1774 , p6_a53
1775 , p6_a54
1776 , p6_a55
1777 , p6_a56
1778 , p6_a57
1779 , p6_a58
1780 , p6_a59
1781 , p6_a60
1782 );
1783 end;
1784
1785 procedure update_quote_line(p_api_version NUMBER
1786 , p_init_msg_list VARCHAR2
1787 , x_return_status out nocopy VARCHAR2
1788 , x_msg_count out nocopy NUMBER
1789 , x_msg_data out nocopy VARCHAR2
1790 , p6_a0 out nocopy NUMBER
1791 , p6_a1 out nocopy NUMBER
1792 , p6_a2 out nocopy VARCHAR2
1793 , p6_a3 out nocopy VARCHAR2
1794 , p6_a4 out nocopy NUMBER
1795 , p6_a5 out nocopy NUMBER
1796 , p6_a6 out nocopy NUMBER
1797 , p6_a7 out nocopy NUMBER
1798 , p6_a8 out nocopy VARCHAR2
1799 , p6_a9 out nocopy NUMBER
1800 , p6_a10 out nocopy VARCHAR2
1801 , p6_a11 out nocopy VARCHAR2
1802 , p6_a12 out nocopy VARCHAR2
1803 , p6_a13 out nocopy VARCHAR2
1804 , p6_a14 out nocopy VARCHAR2
1805 , p6_a15 out nocopy VARCHAR2
1806 , p6_a16 out nocopy VARCHAR2
1807 , p6_a17 out nocopy VARCHAR2
1808 , p6_a18 out nocopy VARCHAR2
1809 , p6_a19 out nocopy VARCHAR2
1810 , p6_a20 out nocopy VARCHAR2
1811 , p6_a21 out nocopy VARCHAR2
1812 , p6_a22 out nocopy VARCHAR2
1813 , p6_a23 out nocopy VARCHAR2
1814 , p6_a24 out nocopy VARCHAR2
1815 , p6_a25 out nocopy VARCHAR2
1816 , p6_a26 out nocopy VARCHAR2
1817 , p6_a27 out nocopy VARCHAR2
1818 , p6_a28 out nocopy VARCHAR2
1819 , p6_a29 out nocopy NUMBER
1820 , p6_a30 out nocopy NUMBER
1821 , p6_a31 out nocopy NUMBER
1822 , p6_a32 out nocopy NUMBER
1823 , p6_a33 out nocopy DATE
1824 , p6_a34 out nocopy NUMBER
1825 , p6_a35 out nocopy DATE
1826 , p6_a36 out nocopy NUMBER
1827 , p6_a37 out nocopy DATE
1828 , p6_a38 out nocopy NUMBER
1829 , p6_a39 out nocopy DATE
1830 , p6_a40 out nocopy VARCHAR2
1831 , p6_a41 out nocopy NUMBER
1832 , p6_a42 out nocopy VARCHAR2
1833 , p6_a43 out nocopy VARCHAR2
1834 , p6_a44 out nocopy VARCHAR2
1835 , p6_a45 out nocopy NUMBER
1836 , p6_a46 out nocopy NUMBER
1837 , p6_a47 out nocopy NUMBER
1838 , p6_a48 out nocopy NUMBER
1839 , p6_a49 out nocopy NUMBER
1840 , p6_a50 out nocopy NUMBER
1841 , p6_a51 out nocopy NUMBER
1842 , p6_a52 out nocopy NUMBER
1843 , p6_a53 out nocopy VARCHAR2
1844 , p6_a54 out nocopy VARCHAR2
1845 , p6_a55 out nocopy VARCHAR2
1846 , p6_a56 out nocopy VARCHAR2
1847 , p6_a57 out nocopy NUMBER
1848 , p6_a58 out nocopy DATE
1849 , p6_a59 out nocopy DATE
1850 , p6_a60 out nocopy NUMBER
1851 , p5_a0 NUMBER := 0-1962.0724
1852 , p5_a1 NUMBER := 0-1962.0724
1853 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1854 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1855 , p5_a4 NUMBER := 0-1962.0724
1856 , p5_a5 NUMBER := 0-1962.0724
1857 , p5_a6 NUMBER := 0-1962.0724
1858 , p5_a7 NUMBER := 0-1962.0724
1859 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1860 , p5_a9 NUMBER := 0-1962.0724
1861 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1862 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1863 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1864 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1865 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1866 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1867 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1868 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1869 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1870 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1871 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1872 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1873 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1874 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1875 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1876 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1877 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1878 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1879 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1880 , p5_a29 NUMBER := 0-1962.0724
1881 , p5_a30 NUMBER := 0-1962.0724
1882 , p5_a31 NUMBER := 0-1962.0724
1883 , p5_a32 NUMBER := 0-1962.0724
1884 , p5_a33 DATE := fnd_api.g_miss_date
1885 , p5_a34 NUMBER := 0-1962.0724
1886 , p5_a35 DATE := fnd_api.g_miss_date
1887 , p5_a36 NUMBER := 0-1962.0724
1888 , p5_a37 DATE := fnd_api.g_miss_date
1889 , p5_a38 NUMBER := 0-1962.0724
1890 , p5_a39 DATE := fnd_api.g_miss_date
1891 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1892 , p5_a41 NUMBER := 0-1962.0724
1893 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1894 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1895 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1896 , p5_a45 NUMBER := 0-1962.0724
1897 , p5_a46 NUMBER := 0-1962.0724
1898 , p5_a47 NUMBER := 0-1962.0724
1899 , p5_a48 NUMBER := 0-1962.0724
1900 , p5_a49 NUMBER := 0-1962.0724
1901 , p5_a50 NUMBER := 0-1962.0724
1902 , p5_a51 NUMBER := 0-1962.0724
1903 , p5_a52 NUMBER := 0-1962.0724
1904 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1905 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1906 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1907 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
1908 , p5_a57 NUMBER := 0-1962.0724
1909 , p5_a58 DATE := fnd_api.g_miss_date
1910 , p5_a59 DATE := fnd_api.g_miss_date
1911 , p5_a60 NUMBER := 0-1962.0724
1912 )
1913
1914 as
1915 ddp_tqlv_rec okl_am_termnt_quote_pub.tqlv_rec_type;
1916 ddx_tqlv_rec okl_am_termnt_quote_pub.tqlv_rec_type;
1917 ddindx binary_integer; indx binary_integer;
1918 begin
1919
1920 -- copy data to the local IN or IN-OUT args, if any
1921
1922
1923
1924
1925
1926 ddp_tqlv_rec.id := rosetta_g_miss_num_map(p5_a0);
1927 ddp_tqlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1928 ddp_tqlv_rec.sfwt_flag := p5_a2;
1929 ddp_tqlv_rec.qlt_code := p5_a3;
1930 ddp_tqlv_rec.kle_id := rosetta_g_miss_num_map(p5_a4);
1931 ddp_tqlv_rec.sty_id := rosetta_g_miss_num_map(p5_a5);
1932 ddp_tqlv_rec.qte_id := rosetta_g_miss_num_map(p5_a6);
1933 ddp_tqlv_rec.line_number := rosetta_g_miss_num_map(p5_a7);
1934 ddp_tqlv_rec.description := p5_a8;
1935 ddp_tqlv_rec.amount := rosetta_g_miss_num_map(p5_a9);
1936 ddp_tqlv_rec.modified_yn := p5_a10;
1937 ddp_tqlv_rec.taxed_yn := p5_a11;
1938 ddp_tqlv_rec.defaulted_yn := p5_a12;
1939 ddp_tqlv_rec.attribute_category := p5_a13;
1940 ddp_tqlv_rec.attribute1 := p5_a14;
1941 ddp_tqlv_rec.attribute2 := p5_a15;
1942 ddp_tqlv_rec.attribute3 := p5_a16;
1943 ddp_tqlv_rec.attribute4 := p5_a17;
1944 ddp_tqlv_rec.attribute5 := p5_a18;
1945 ddp_tqlv_rec.attribute6 := p5_a19;
1946 ddp_tqlv_rec.attribute7 := p5_a20;
1947 ddp_tqlv_rec.attribute8 := p5_a21;
1948 ddp_tqlv_rec.attribute9 := p5_a22;
1949 ddp_tqlv_rec.attribute10 := p5_a23;
1950 ddp_tqlv_rec.attribute11 := p5_a24;
1951 ddp_tqlv_rec.attribute12 := p5_a25;
1952 ddp_tqlv_rec.attribute13 := p5_a26;
1953 ddp_tqlv_rec.attribute14 := p5_a27;
1954 ddp_tqlv_rec.attribute15 := p5_a28;
1955 ddp_tqlv_rec.org_id := rosetta_g_miss_num_map(p5_a29);
1956 ddp_tqlv_rec.request_id := rosetta_g_miss_num_map(p5_a30);
1957 ddp_tqlv_rec.program_application_id := rosetta_g_miss_num_map(p5_a31);
1958 ddp_tqlv_rec.program_id := rosetta_g_miss_num_map(p5_a32);
1959 ddp_tqlv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a33);
1960 ddp_tqlv_rec.created_by := rosetta_g_miss_num_map(p5_a34);
1961 ddp_tqlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a35);
1962 ddp_tqlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a36);
1963 ddp_tqlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a37);
1964 ddp_tqlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a38);
1965 ddp_tqlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a39);
1966 ddp_tqlv_rec.period := p5_a40;
1967 ddp_tqlv_rec.number_of_periods := rosetta_g_miss_num_map(p5_a41);
1968 ddp_tqlv_rec.lock_level_step := p5_a42;
1969 ddp_tqlv_rec.advance_or_arrears := p5_a43;
1970 ddp_tqlv_rec.yield_name := p5_a44;
1971 ddp_tqlv_rec.yield_value := rosetta_g_miss_num_map(p5_a45);
1972 ddp_tqlv_rec.implicit_interest_rate := rosetta_g_miss_num_map(p5_a46);
1973 ddp_tqlv_rec.asset_value := rosetta_g_miss_num_map(p5_a47);
1974 ddp_tqlv_rec.residual_value := rosetta_g_miss_num_map(p5_a48);
1975 ddp_tqlv_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a49);
1976 ddp_tqlv_rec.asset_quantity := rosetta_g_miss_num_map(p5_a50);
1977 ddp_tqlv_rec.quote_quantity := rosetta_g_miss_num_map(p5_a51);
1978 ddp_tqlv_rec.split_kle_id := rosetta_g_miss_num_map(p5_a52);
1979 ddp_tqlv_rec.split_kle_name := p5_a53;
1980 ddp_tqlv_rec.currency_code := p5_a54;
1981 ddp_tqlv_rec.currency_conversion_code := p5_a55;
1982 ddp_tqlv_rec.currency_conversion_type := p5_a56;
1983 ddp_tqlv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a57);
1984 ddp_tqlv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a58);
1985 ddp_tqlv_rec.due_date := rosetta_g_miss_date_in_map(p5_a59);
1986 ddp_tqlv_rec.try_id := rosetta_g_miss_num_map(p5_a60);
1987
1988
1989 -- here's the delegated call to the old PL/SQL routine
1990 okl_am_termnt_quote_pub.update_quote_line(p_api_version,
1991 p_init_msg_list,
1992 x_return_status,
1993 x_msg_count,
1994 x_msg_data,
1995 ddp_tqlv_rec,
1996 ddx_tqlv_rec);
1997
1998 -- copy data back from the local variables to OUT or IN-OUT args, if any
1999
2000
2001
2002
2003
2004
2005 p6_a0 := rosetta_g_miss_num_map(ddx_tqlv_rec.id);
2006 p6_a1 := rosetta_g_miss_num_map(ddx_tqlv_rec.object_version_number);
2007 p6_a2 := ddx_tqlv_rec.sfwt_flag;
2008 p6_a3 := ddx_tqlv_rec.qlt_code;
2009 p6_a4 := rosetta_g_miss_num_map(ddx_tqlv_rec.kle_id);
2010 p6_a5 := rosetta_g_miss_num_map(ddx_tqlv_rec.sty_id);
2011 p6_a6 := rosetta_g_miss_num_map(ddx_tqlv_rec.qte_id);
2012 p6_a7 := rosetta_g_miss_num_map(ddx_tqlv_rec.line_number);
2013 p6_a8 := ddx_tqlv_rec.description;
2014 p6_a9 := rosetta_g_miss_num_map(ddx_tqlv_rec.amount);
2015 p6_a10 := ddx_tqlv_rec.modified_yn;
2016 p6_a11 := ddx_tqlv_rec.taxed_yn;
2017 p6_a12 := ddx_tqlv_rec.defaulted_yn;
2018 p6_a13 := ddx_tqlv_rec.attribute_category;
2019 p6_a14 := ddx_tqlv_rec.attribute1;
2020 p6_a15 := ddx_tqlv_rec.attribute2;
2021 p6_a16 := ddx_tqlv_rec.attribute3;
2022 p6_a17 := ddx_tqlv_rec.attribute4;
2023 p6_a18 := ddx_tqlv_rec.attribute5;
2024 p6_a19 := ddx_tqlv_rec.attribute6;
2025 p6_a20 := ddx_tqlv_rec.attribute7;
2026 p6_a21 := ddx_tqlv_rec.attribute8;
2027 p6_a22 := ddx_tqlv_rec.attribute9;
2028 p6_a23 := ddx_tqlv_rec.attribute10;
2029 p6_a24 := ddx_tqlv_rec.attribute11;
2030 p6_a25 := ddx_tqlv_rec.attribute12;
2031 p6_a26 := ddx_tqlv_rec.attribute13;
2032 p6_a27 := ddx_tqlv_rec.attribute14;
2033 p6_a28 := ddx_tqlv_rec.attribute15;
2034 p6_a29 := rosetta_g_miss_num_map(ddx_tqlv_rec.org_id);
2035 p6_a30 := rosetta_g_miss_num_map(ddx_tqlv_rec.request_id);
2036 p6_a31 := rosetta_g_miss_num_map(ddx_tqlv_rec.program_application_id);
2037 p6_a32 := rosetta_g_miss_num_map(ddx_tqlv_rec.program_id);
2038 p6_a33 := ddx_tqlv_rec.program_update_date;
2039 p6_a34 := rosetta_g_miss_num_map(ddx_tqlv_rec.created_by);
2040 p6_a35 := ddx_tqlv_rec.creation_date;
2041 p6_a36 := rosetta_g_miss_num_map(ddx_tqlv_rec.last_updated_by);
2042 p6_a37 := ddx_tqlv_rec.last_update_date;
2043 p6_a38 := rosetta_g_miss_num_map(ddx_tqlv_rec.last_update_login);
2044 p6_a39 := ddx_tqlv_rec.start_date;
2045 p6_a40 := ddx_tqlv_rec.period;
2046 p6_a41 := rosetta_g_miss_num_map(ddx_tqlv_rec.number_of_periods);
2047 p6_a42 := ddx_tqlv_rec.lock_level_step;
2048 p6_a43 := ddx_tqlv_rec.advance_or_arrears;
2049 p6_a44 := ddx_tqlv_rec.yield_name;
2050 p6_a45 := rosetta_g_miss_num_map(ddx_tqlv_rec.yield_value);
2051 p6_a46 := rosetta_g_miss_num_map(ddx_tqlv_rec.implicit_interest_rate);
2052 p6_a47 := rosetta_g_miss_num_map(ddx_tqlv_rec.asset_value);
2053 p6_a48 := rosetta_g_miss_num_map(ddx_tqlv_rec.residual_value);
2054 p6_a49 := rosetta_g_miss_num_map(ddx_tqlv_rec.unbilled_receivables);
2055 p6_a50 := rosetta_g_miss_num_map(ddx_tqlv_rec.asset_quantity);
2056 p6_a51 := rosetta_g_miss_num_map(ddx_tqlv_rec.quote_quantity);
2057 p6_a52 := rosetta_g_miss_num_map(ddx_tqlv_rec.split_kle_id);
2058 p6_a53 := ddx_tqlv_rec.split_kle_name;
2059 p6_a54 := ddx_tqlv_rec.currency_code;
2060 p6_a55 := ddx_tqlv_rec.currency_conversion_code;
2061 p6_a56 := ddx_tqlv_rec.currency_conversion_type;
2062 p6_a57 := rosetta_g_miss_num_map(ddx_tqlv_rec.currency_conversion_rate);
2063 p6_a58 := ddx_tqlv_rec.currency_conversion_date;
2064 p6_a59 := ddx_tqlv_rec.due_date;
2065 p6_a60 := rosetta_g_miss_num_map(ddx_tqlv_rec.try_id);
2066 end;
2067
2068 procedure update_quote_line(p_api_version NUMBER
2069 , p_init_msg_list VARCHAR2
2070 , x_return_status out nocopy VARCHAR2
2071 , x_msg_count out nocopy NUMBER
2072 , x_msg_data out nocopy VARCHAR2
2073 , p5_a0 JTF_NUMBER_TABLE
2074 , p5_a1 JTF_NUMBER_TABLE
2075 , p5_a2 JTF_VARCHAR2_TABLE_100
2076 , p5_a3 JTF_VARCHAR2_TABLE_100
2077 , p5_a4 JTF_NUMBER_TABLE
2078 , p5_a5 JTF_NUMBER_TABLE
2079 , p5_a6 JTF_NUMBER_TABLE
2080 , p5_a7 JTF_NUMBER_TABLE
2081 , p5_a8 JTF_VARCHAR2_TABLE_2000
2082 , p5_a9 JTF_NUMBER_TABLE
2083 , p5_a10 JTF_VARCHAR2_TABLE_100
2084 , p5_a11 JTF_VARCHAR2_TABLE_100
2085 , p5_a12 JTF_VARCHAR2_TABLE_100
2086 , p5_a13 JTF_VARCHAR2_TABLE_100
2087 , p5_a14 JTF_VARCHAR2_TABLE_500
2088 , p5_a15 JTF_VARCHAR2_TABLE_500
2089 , p5_a16 JTF_VARCHAR2_TABLE_500
2090 , p5_a17 JTF_VARCHAR2_TABLE_500
2091 , p5_a18 JTF_VARCHAR2_TABLE_500
2092 , p5_a19 JTF_VARCHAR2_TABLE_500
2093 , p5_a20 JTF_VARCHAR2_TABLE_500
2094 , p5_a21 JTF_VARCHAR2_TABLE_500
2095 , p5_a22 JTF_VARCHAR2_TABLE_500
2096 , p5_a23 JTF_VARCHAR2_TABLE_500
2097 , p5_a24 JTF_VARCHAR2_TABLE_500
2098 , p5_a25 JTF_VARCHAR2_TABLE_500
2099 , p5_a26 JTF_VARCHAR2_TABLE_500
2100 , p5_a27 JTF_VARCHAR2_TABLE_500
2101 , p5_a28 JTF_VARCHAR2_TABLE_500
2102 , p5_a29 JTF_NUMBER_TABLE
2103 , p5_a30 JTF_NUMBER_TABLE
2104 , p5_a31 JTF_NUMBER_TABLE
2105 , p5_a32 JTF_NUMBER_TABLE
2106 , p5_a33 JTF_DATE_TABLE
2107 , p5_a34 JTF_NUMBER_TABLE
2108 , p5_a35 JTF_DATE_TABLE
2109 , p5_a36 JTF_NUMBER_TABLE
2110 , p5_a37 JTF_DATE_TABLE
2111 , p5_a38 JTF_NUMBER_TABLE
2112 , p5_a39 JTF_DATE_TABLE
2113 , p5_a40 JTF_VARCHAR2_TABLE_100
2114 , p5_a41 JTF_NUMBER_TABLE
2115 , p5_a42 JTF_VARCHAR2_TABLE_100
2116 , p5_a43 JTF_VARCHAR2_TABLE_100
2117 , p5_a44 JTF_VARCHAR2_TABLE_200
2118 , p5_a45 JTF_NUMBER_TABLE
2119 , p5_a46 JTF_NUMBER_TABLE
2120 , p5_a47 JTF_NUMBER_TABLE
2121 , p5_a48 JTF_NUMBER_TABLE
2122 , p5_a49 JTF_NUMBER_TABLE
2123 , p5_a50 JTF_NUMBER_TABLE
2124 , p5_a51 JTF_NUMBER_TABLE
2125 , p5_a52 JTF_NUMBER_TABLE
2126 , p5_a53 JTF_VARCHAR2_TABLE_200
2127 , p5_a54 JTF_VARCHAR2_TABLE_100
2128 , p5_a55 JTF_VARCHAR2_TABLE_100
2129 , p5_a56 JTF_VARCHAR2_TABLE_100
2130 , p5_a57 JTF_NUMBER_TABLE
2131 , p5_a58 JTF_DATE_TABLE
2132 , p5_a59 JTF_DATE_TABLE
2133 , p5_a60 JTF_NUMBER_TABLE
2134 , p6_a0 out nocopy JTF_NUMBER_TABLE
2135 , p6_a1 out nocopy JTF_NUMBER_TABLE
2136 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
2137 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2138 , p6_a4 out nocopy JTF_NUMBER_TABLE
2139 , p6_a5 out nocopy JTF_NUMBER_TABLE
2140 , p6_a6 out nocopy JTF_NUMBER_TABLE
2141 , p6_a7 out nocopy JTF_NUMBER_TABLE
2142 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
2143 , p6_a9 out nocopy JTF_NUMBER_TABLE
2144 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2145 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
2146 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2147 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2148 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
2149 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
2150 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
2151 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
2152 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
2153 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
2154 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
2155 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
2156 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
2157 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
2158 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
2159 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
2160 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
2161 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
2162 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
2163 , p6_a29 out nocopy JTF_NUMBER_TABLE
2164 , p6_a30 out nocopy JTF_NUMBER_TABLE
2165 , p6_a31 out nocopy JTF_NUMBER_TABLE
2166 , p6_a32 out nocopy JTF_NUMBER_TABLE
2167 , p6_a33 out nocopy JTF_DATE_TABLE
2168 , p6_a34 out nocopy JTF_NUMBER_TABLE
2169 , p6_a35 out nocopy JTF_DATE_TABLE
2170 , p6_a36 out nocopy JTF_NUMBER_TABLE
2171 , p6_a37 out nocopy JTF_DATE_TABLE
2172 , p6_a38 out nocopy JTF_NUMBER_TABLE
2173 , p6_a39 out nocopy JTF_DATE_TABLE
2174 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
2175 , p6_a41 out nocopy JTF_NUMBER_TABLE
2176 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
2177 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
2178 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_200
2179 , p6_a45 out nocopy JTF_NUMBER_TABLE
2180 , p6_a46 out nocopy JTF_NUMBER_TABLE
2181 , p6_a47 out nocopy JTF_NUMBER_TABLE
2182 , p6_a48 out nocopy JTF_NUMBER_TABLE
2183 , p6_a49 out nocopy JTF_NUMBER_TABLE
2184 , p6_a50 out nocopy JTF_NUMBER_TABLE
2185 , p6_a51 out nocopy JTF_NUMBER_TABLE
2186 , p6_a52 out nocopy JTF_NUMBER_TABLE
2187 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_200
2188 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
2189 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
2190 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
2191 , p6_a57 out nocopy JTF_NUMBER_TABLE
2192 , p6_a58 out nocopy JTF_DATE_TABLE
2193 , p6_a59 out nocopy JTF_DATE_TABLE
2194 , p6_a60 out nocopy JTF_NUMBER_TABLE
2195 )
2196
2197 as
2198 ddp_tqlv_tbl okl_am_termnt_quote_pub.tqlv_tbl_type;
2199 ddx_tqlv_tbl okl_am_termnt_quote_pub.tqlv_tbl_type;
2200 ddindx binary_integer; indx binary_integer;
2201 begin
2202
2203 -- copy data to the local IN or IN-OUT args, if any
2204
2205
2206
2207
2208
2209 okl_tql_pvt_w.rosetta_table_copy_in_p8(ddp_tqlv_tbl, p5_a0
2210 , p5_a1
2211 , p5_a2
2212 , p5_a3
2213 , p5_a4
2214 , p5_a5
2215 , p5_a6
2216 , p5_a7
2217 , p5_a8
2218 , p5_a9
2219 , p5_a10
2220 , p5_a11
2221 , p5_a12
2222 , p5_a13
2223 , p5_a14
2224 , p5_a15
2225 , p5_a16
2226 , p5_a17
2227 , p5_a18
2228 , p5_a19
2229 , p5_a20
2230 , p5_a21
2231 , p5_a22
2232 , p5_a23
2233 , p5_a24
2234 , p5_a25
2235 , p5_a26
2236 , p5_a27
2237 , p5_a28
2238 , p5_a29
2239 , p5_a30
2240 , p5_a31
2241 , p5_a32
2242 , p5_a33
2243 , p5_a34
2244 , p5_a35
2245 , p5_a36
2246 , p5_a37
2247 , p5_a38
2248 , p5_a39
2249 , p5_a40
2250 , p5_a41
2251 , p5_a42
2252 , p5_a43
2253 , p5_a44
2254 , p5_a45
2255 , p5_a46
2256 , p5_a47
2257 , p5_a48
2258 , p5_a49
2259 , p5_a50
2260 , p5_a51
2261 , p5_a52
2262 , p5_a53
2263 , p5_a54
2264 , p5_a55
2265 , p5_a56
2266 , p5_a57
2267 , p5_a58
2268 , p5_a59
2269 , p5_a60
2270 );
2271
2272
2273 -- here's the delegated call to the old PL/SQL routine
2274 okl_am_termnt_quote_pub.update_quote_line(p_api_version,
2275 p_init_msg_list,
2276 x_return_status,
2277 x_msg_count,
2278 x_msg_data,
2279 ddp_tqlv_tbl,
2280 ddx_tqlv_tbl);
2281
2282 -- copy data back from the local variables to OUT or IN-OUT args, if any
2283
2284
2285
2286
2287
2288
2289 okl_tql_pvt_w.rosetta_table_copy_out_p8(ddx_tqlv_tbl, p6_a0
2290 , p6_a1
2291 , p6_a2
2292 , p6_a3
2293 , p6_a4
2294 , p6_a5
2295 , p6_a6
2296 , p6_a7
2297 , p6_a8
2298 , p6_a9
2299 , p6_a10
2300 , p6_a11
2301 , p6_a12
2302 , p6_a13
2303 , p6_a14
2304 , p6_a15
2305 , p6_a16
2306 , p6_a17
2307 , p6_a18
2308 , p6_a19
2309 , p6_a20
2310 , p6_a21
2311 , p6_a22
2312 , p6_a23
2313 , p6_a24
2314 , p6_a25
2315 , p6_a26
2316 , p6_a27
2317 , p6_a28
2318 , p6_a29
2319 , p6_a30
2320 , p6_a31
2321 , p6_a32
2322 , p6_a33
2323 , p6_a34
2324 , p6_a35
2325 , p6_a36
2326 , p6_a37
2327 , p6_a38
2328 , p6_a39
2329 , p6_a40
2330 , p6_a41
2331 , p6_a42
2332 , p6_a43
2333 , p6_a44
2334 , p6_a45
2335 , p6_a46
2336 , p6_a47
2337 , p6_a48
2338 , p6_a49
2339 , p6_a50
2340 , p6_a51
2341 , p6_a52
2342 , p6_a53
2343 , p6_a54
2344 , p6_a55
2345 , p6_a56
2346 , p6_a57
2347 , p6_a58
2348 , p6_a59
2349 , p6_a60
2350 );
2351 end;
2352
2353 procedure delete_quote_line(p_api_version NUMBER
2354 , p_init_msg_list VARCHAR2
2355 , x_return_status out nocopy VARCHAR2
2356 , x_msg_count out nocopy NUMBER
2357 , x_msg_data out nocopy VARCHAR2
2358 , p5_a0 NUMBER := 0-1962.0724
2359 , p5_a1 NUMBER := 0-1962.0724
2360 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2361 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2362 , p5_a4 NUMBER := 0-1962.0724
2363 , p5_a5 NUMBER := 0-1962.0724
2364 , p5_a6 NUMBER := 0-1962.0724
2365 , p5_a7 NUMBER := 0-1962.0724
2366 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2367 , p5_a9 NUMBER := 0-1962.0724
2368 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2369 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2370 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2371 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2372 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2373 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2374 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2375 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2376 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2377 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2378 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2379 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2380 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2381 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2382 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2383 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2384 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2385 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2386 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2387 , p5_a29 NUMBER := 0-1962.0724
2388 , p5_a30 NUMBER := 0-1962.0724
2389 , p5_a31 NUMBER := 0-1962.0724
2390 , p5_a32 NUMBER := 0-1962.0724
2391 , p5_a33 DATE := fnd_api.g_miss_date
2392 , p5_a34 NUMBER := 0-1962.0724
2393 , p5_a35 DATE := fnd_api.g_miss_date
2394 , p5_a36 NUMBER := 0-1962.0724
2395 , p5_a37 DATE := fnd_api.g_miss_date
2396 , p5_a38 NUMBER := 0-1962.0724
2397 , p5_a39 DATE := fnd_api.g_miss_date
2398 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2399 , p5_a41 NUMBER := 0-1962.0724
2400 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2401 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2402 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2403 , p5_a45 NUMBER := 0-1962.0724
2404 , p5_a46 NUMBER := 0-1962.0724
2405 , p5_a47 NUMBER := 0-1962.0724
2406 , p5_a48 NUMBER := 0-1962.0724
2407 , p5_a49 NUMBER := 0-1962.0724
2408 , p5_a50 NUMBER := 0-1962.0724
2409 , p5_a51 NUMBER := 0-1962.0724
2410 , p5_a52 NUMBER := 0-1962.0724
2411 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2412 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
2413 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
2414 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
2415 , p5_a57 NUMBER := 0-1962.0724
2416 , p5_a58 DATE := fnd_api.g_miss_date
2417 , p5_a59 DATE := fnd_api.g_miss_date
2418 , p5_a60 NUMBER := 0-1962.0724
2419 )
2420
2421 as
2422 ddp_tqlv_rec okl_am_termnt_quote_pub.tqlv_rec_type;
2423 ddindx binary_integer; indx binary_integer;
2424 begin
2425
2426 -- copy data to the local IN or IN-OUT args, if any
2427
2428
2429
2430
2431
2432 ddp_tqlv_rec.id := rosetta_g_miss_num_map(p5_a0);
2433 ddp_tqlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2434 ddp_tqlv_rec.sfwt_flag := p5_a2;
2435 ddp_tqlv_rec.qlt_code := p5_a3;
2436 ddp_tqlv_rec.kle_id := rosetta_g_miss_num_map(p5_a4);
2437 ddp_tqlv_rec.sty_id := rosetta_g_miss_num_map(p5_a5);
2438 ddp_tqlv_rec.qte_id := rosetta_g_miss_num_map(p5_a6);
2439 ddp_tqlv_rec.line_number := rosetta_g_miss_num_map(p5_a7);
2440 ddp_tqlv_rec.description := p5_a8;
2441 ddp_tqlv_rec.amount := rosetta_g_miss_num_map(p5_a9);
2442 ddp_tqlv_rec.modified_yn := p5_a10;
2443 ddp_tqlv_rec.taxed_yn := p5_a11;
2444 ddp_tqlv_rec.defaulted_yn := p5_a12;
2445 ddp_tqlv_rec.attribute_category := p5_a13;
2446 ddp_tqlv_rec.attribute1 := p5_a14;
2447 ddp_tqlv_rec.attribute2 := p5_a15;
2448 ddp_tqlv_rec.attribute3 := p5_a16;
2449 ddp_tqlv_rec.attribute4 := p5_a17;
2450 ddp_tqlv_rec.attribute5 := p5_a18;
2451 ddp_tqlv_rec.attribute6 := p5_a19;
2452 ddp_tqlv_rec.attribute7 := p5_a20;
2453 ddp_tqlv_rec.attribute8 := p5_a21;
2454 ddp_tqlv_rec.attribute9 := p5_a22;
2455 ddp_tqlv_rec.attribute10 := p5_a23;
2456 ddp_tqlv_rec.attribute11 := p5_a24;
2457 ddp_tqlv_rec.attribute12 := p5_a25;
2458 ddp_tqlv_rec.attribute13 := p5_a26;
2459 ddp_tqlv_rec.attribute14 := p5_a27;
2460 ddp_tqlv_rec.attribute15 := p5_a28;
2461 ddp_tqlv_rec.org_id := rosetta_g_miss_num_map(p5_a29);
2462 ddp_tqlv_rec.request_id := rosetta_g_miss_num_map(p5_a30);
2463 ddp_tqlv_rec.program_application_id := rosetta_g_miss_num_map(p5_a31);
2464 ddp_tqlv_rec.program_id := rosetta_g_miss_num_map(p5_a32);
2465 ddp_tqlv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a33);
2466 ddp_tqlv_rec.created_by := rosetta_g_miss_num_map(p5_a34);
2467 ddp_tqlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a35);
2468 ddp_tqlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a36);
2469 ddp_tqlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a37);
2470 ddp_tqlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a38);
2471 ddp_tqlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a39);
2472 ddp_tqlv_rec.period := p5_a40;
2473 ddp_tqlv_rec.number_of_periods := rosetta_g_miss_num_map(p5_a41);
2474 ddp_tqlv_rec.lock_level_step := p5_a42;
2475 ddp_tqlv_rec.advance_or_arrears := p5_a43;
2476 ddp_tqlv_rec.yield_name := p5_a44;
2477 ddp_tqlv_rec.yield_value := rosetta_g_miss_num_map(p5_a45);
2478 ddp_tqlv_rec.implicit_interest_rate := rosetta_g_miss_num_map(p5_a46);
2479 ddp_tqlv_rec.asset_value := rosetta_g_miss_num_map(p5_a47);
2480 ddp_tqlv_rec.residual_value := rosetta_g_miss_num_map(p5_a48);
2481 ddp_tqlv_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a49);
2482 ddp_tqlv_rec.asset_quantity := rosetta_g_miss_num_map(p5_a50);
2483 ddp_tqlv_rec.quote_quantity := rosetta_g_miss_num_map(p5_a51);
2484 ddp_tqlv_rec.split_kle_id := rosetta_g_miss_num_map(p5_a52);
2485 ddp_tqlv_rec.split_kle_name := p5_a53;
2486 ddp_tqlv_rec.currency_code := p5_a54;
2487 ddp_tqlv_rec.currency_conversion_code := p5_a55;
2488 ddp_tqlv_rec.currency_conversion_type := p5_a56;
2489 ddp_tqlv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a57);
2490 ddp_tqlv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a58);
2491 ddp_tqlv_rec.due_date := rosetta_g_miss_date_in_map(p5_a59);
2492 ddp_tqlv_rec.try_id := rosetta_g_miss_num_map(p5_a60);
2493
2494 -- here's the delegated call to the old PL/SQL routine
2495 okl_am_termnt_quote_pub.delete_quote_line(p_api_version,
2496 p_init_msg_list,
2497 x_return_status,
2498 x_msg_count,
2499 x_msg_data,
2500 ddp_tqlv_rec);
2501
2502 -- copy data back from the local variables to OUT or IN-OUT args, if any
2503
2504
2505
2506
2507
2508 end;
2509
2510 procedure delete_quote_line(p_api_version NUMBER
2511 , p_init_msg_list VARCHAR2
2512 , x_return_status out nocopy VARCHAR2
2513 , x_msg_count out nocopy NUMBER
2514 , x_msg_data out nocopy VARCHAR2
2515 , p5_a0 JTF_NUMBER_TABLE
2516 , p5_a1 JTF_NUMBER_TABLE
2517 , p5_a2 JTF_VARCHAR2_TABLE_100
2518 , p5_a3 JTF_VARCHAR2_TABLE_100
2519 , p5_a4 JTF_NUMBER_TABLE
2520 , p5_a5 JTF_NUMBER_TABLE
2521 , p5_a6 JTF_NUMBER_TABLE
2522 , p5_a7 JTF_NUMBER_TABLE
2523 , p5_a8 JTF_VARCHAR2_TABLE_2000
2524 , p5_a9 JTF_NUMBER_TABLE
2525 , p5_a10 JTF_VARCHAR2_TABLE_100
2526 , p5_a11 JTF_VARCHAR2_TABLE_100
2527 , p5_a12 JTF_VARCHAR2_TABLE_100
2528 , p5_a13 JTF_VARCHAR2_TABLE_100
2529 , p5_a14 JTF_VARCHAR2_TABLE_500
2530 , p5_a15 JTF_VARCHAR2_TABLE_500
2531 , p5_a16 JTF_VARCHAR2_TABLE_500
2532 , p5_a17 JTF_VARCHAR2_TABLE_500
2533 , p5_a18 JTF_VARCHAR2_TABLE_500
2534 , p5_a19 JTF_VARCHAR2_TABLE_500
2535 , p5_a20 JTF_VARCHAR2_TABLE_500
2536 , p5_a21 JTF_VARCHAR2_TABLE_500
2537 , p5_a22 JTF_VARCHAR2_TABLE_500
2538 , p5_a23 JTF_VARCHAR2_TABLE_500
2539 , p5_a24 JTF_VARCHAR2_TABLE_500
2540 , p5_a25 JTF_VARCHAR2_TABLE_500
2541 , p5_a26 JTF_VARCHAR2_TABLE_500
2542 , p5_a27 JTF_VARCHAR2_TABLE_500
2543 , p5_a28 JTF_VARCHAR2_TABLE_500
2544 , p5_a29 JTF_NUMBER_TABLE
2545 , p5_a30 JTF_NUMBER_TABLE
2546 , p5_a31 JTF_NUMBER_TABLE
2547 , p5_a32 JTF_NUMBER_TABLE
2548 , p5_a33 JTF_DATE_TABLE
2549 , p5_a34 JTF_NUMBER_TABLE
2550 , p5_a35 JTF_DATE_TABLE
2551 , p5_a36 JTF_NUMBER_TABLE
2552 , p5_a37 JTF_DATE_TABLE
2553 , p5_a38 JTF_NUMBER_TABLE
2554 , p5_a39 JTF_DATE_TABLE
2555 , p5_a40 JTF_VARCHAR2_TABLE_100
2556 , p5_a41 JTF_NUMBER_TABLE
2557 , p5_a42 JTF_VARCHAR2_TABLE_100
2558 , p5_a43 JTF_VARCHAR2_TABLE_100
2559 , p5_a44 JTF_VARCHAR2_TABLE_200
2560 , p5_a45 JTF_NUMBER_TABLE
2561 , p5_a46 JTF_NUMBER_TABLE
2562 , p5_a47 JTF_NUMBER_TABLE
2563 , p5_a48 JTF_NUMBER_TABLE
2564 , p5_a49 JTF_NUMBER_TABLE
2565 , p5_a50 JTF_NUMBER_TABLE
2566 , p5_a51 JTF_NUMBER_TABLE
2567 , p5_a52 JTF_NUMBER_TABLE
2568 , p5_a53 JTF_VARCHAR2_TABLE_200
2569 , p5_a54 JTF_VARCHAR2_TABLE_100
2570 , p5_a55 JTF_VARCHAR2_TABLE_100
2571 , p5_a56 JTF_VARCHAR2_TABLE_100
2572 , p5_a57 JTF_NUMBER_TABLE
2573 , p5_a58 JTF_DATE_TABLE
2574 , p5_a59 JTF_DATE_TABLE
2575 , p5_a60 JTF_NUMBER_TABLE
2576 )
2577
2578 as
2579 ddp_tqlv_tbl okl_am_termnt_quote_pub.tqlv_tbl_type;
2580 ddindx binary_integer; indx binary_integer;
2581 begin
2582
2583 -- copy data to the local IN or IN-OUT args, if any
2584
2585
2586
2587
2588
2589 okl_tql_pvt_w.rosetta_table_copy_in_p8(ddp_tqlv_tbl, p5_a0
2590 , p5_a1
2591 , p5_a2
2592 , p5_a3
2593 , p5_a4
2594 , p5_a5
2595 , p5_a6
2596 , p5_a7
2597 , p5_a8
2598 , p5_a9
2599 , p5_a10
2600 , p5_a11
2601 , p5_a12
2602 , p5_a13
2603 , p5_a14
2604 , p5_a15
2605 , p5_a16
2606 , p5_a17
2607 , p5_a18
2608 , p5_a19
2609 , p5_a20
2610 , p5_a21
2611 , p5_a22
2612 , p5_a23
2613 , p5_a24
2614 , p5_a25
2615 , p5_a26
2616 , p5_a27
2617 , p5_a28
2618 , p5_a29
2619 , p5_a30
2620 , p5_a31
2621 , p5_a32
2622 , p5_a33
2623 , p5_a34
2624 , p5_a35
2625 , p5_a36
2626 , p5_a37
2627 , p5_a38
2628 , p5_a39
2629 , p5_a40
2630 , p5_a41
2631 , p5_a42
2632 , p5_a43
2633 , p5_a44
2634 , p5_a45
2635 , p5_a46
2636 , p5_a47
2637 , p5_a48
2638 , p5_a49
2639 , p5_a50
2640 , p5_a51
2641 , p5_a52
2642 , p5_a53
2643 , p5_a54
2644 , p5_a55
2645 , p5_a56
2646 , p5_a57
2647 , p5_a58
2648 , p5_a59
2649 , p5_a60
2650 );
2651
2652 -- here's the delegated call to the old PL/SQL routine
2653 okl_am_termnt_quote_pub.delete_quote_line(p_api_version,
2654 p_init_msg_list,
2655 x_return_status,
2656 x_msg_count,
2657 x_msg_data,
2658 ddp_tqlv_tbl);
2659
2660 -- copy data back from the local variables to OUT or IN-OUT args, if any
2661
2662
2663
2664
2665
2666 end;
2667
2668 end okl_am_termnt_quote_pub_w;