[Home] [Help]
PACKAGE BODY: APPS.OKL_QTE_PVT_W
Source
1 package body okl_qte_pvt_w as
2 /* $Header: OKLIQTEB.pls 120.2 2007/11/02 21:02:17 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 rosetta_table_copy_in_p2(t out nocopy okl_qte_pvt.qte_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_VARCHAR2_TABLE_100
24 , a2 JTF_VARCHAR2_TABLE_100
25 , a3 JTF_NUMBER_TABLE
26 , a4 JTF_NUMBER_TABLE
27 , a5 JTF_NUMBER_TABLE
28 , a6 JTF_VARCHAR2_TABLE_100
29 , a7 JTF_VARCHAR2_TABLE_100
30 , a8 JTF_VARCHAR2_TABLE_100
31 , a9 JTF_VARCHAR2_TABLE_100
32 , a10 JTF_NUMBER_TABLE
33 , a11 JTF_DATE_TABLE
34 , a12 JTF_NUMBER_TABLE
35 , a13 JTF_NUMBER_TABLE
36 , a14 JTF_NUMBER_TABLE
37 , a15 JTF_NUMBER_TABLE
38 , a16 JTF_DATE_TABLE
39 , a17 JTF_DATE_TABLE
40 , a18 JTF_DATE_TABLE
41 , a19 JTF_DATE_TABLE
42 , a20 JTF_NUMBER_TABLE
43 , a21 JTF_NUMBER_TABLE
44 , a22 JTF_NUMBER_TABLE
45 , a23 JTF_NUMBER_TABLE
46 , a24 JTF_NUMBER_TABLE
47 , a25 JTF_VARCHAR2_TABLE_100
48 , a26 JTF_VARCHAR2_TABLE_100
49 , a27 JTF_VARCHAR2_TABLE_100
50 , a28 JTF_VARCHAR2_TABLE_100
51 , a29 JTF_VARCHAR2_TABLE_100
52 , a30 JTF_VARCHAR2_TABLE_100
53 , a31 JTF_DATE_TABLE
54 , a32 JTF_DATE_TABLE
55 , a33 JTF_DATE_TABLE
56 , a34 JTF_DATE_TABLE
57 , a35 JTF_VARCHAR2_TABLE_100
58 , a36 JTF_NUMBER_TABLE
59 , a37 JTF_VARCHAR2_TABLE_100
60 , a38 JTF_VARCHAR2_TABLE_100
61 , a39 JTF_DATE_TABLE
62 , a40 JTF_NUMBER_TABLE
63 , a41 JTF_NUMBER_TABLE
64 , a42 JTF_NUMBER_TABLE
65 , a43 JTF_NUMBER_TABLE
66 , a44 JTF_NUMBER_TABLE
67 , a45 JTF_DATE_TABLE
68 , a46 JTF_VARCHAR2_TABLE_100
69 , a47 JTF_VARCHAR2_TABLE_500
70 , a48 JTF_VARCHAR2_TABLE_500
71 , a49 JTF_VARCHAR2_TABLE_500
72 , a50 JTF_VARCHAR2_TABLE_500
73 , a51 JTF_VARCHAR2_TABLE_500
74 , a52 JTF_VARCHAR2_TABLE_500
75 , a53 JTF_VARCHAR2_TABLE_500
76 , a54 JTF_VARCHAR2_TABLE_500
77 , a55 JTF_VARCHAR2_TABLE_500
78 , a56 JTF_VARCHAR2_TABLE_500
79 , a57 JTF_VARCHAR2_TABLE_500
80 , a58 JTF_VARCHAR2_TABLE_500
81 , a59 JTF_VARCHAR2_TABLE_500
82 , a60 JTF_VARCHAR2_TABLE_500
83 , a61 JTF_VARCHAR2_TABLE_500
84 , a62 JTF_NUMBER_TABLE
85 , a63 JTF_DATE_TABLE
86 , a64 JTF_NUMBER_TABLE
87 , a65 JTF_DATE_TABLE
88 , a66 JTF_NUMBER_TABLE
89 , a67 JTF_NUMBER_TABLE
90 , a68 JTF_VARCHAR2_TABLE_200
91 , a69 JTF_NUMBER_TABLE
92 , a70 JTF_NUMBER_TABLE
93 , a71 JTF_NUMBER_TABLE
94 , a72 JTF_NUMBER_TABLE
95 , a73 JTF_NUMBER_TABLE
96 , a74 JTF_VARCHAR2_TABLE_100
97 , a75 JTF_VARCHAR2_TABLE_100
98 , a76 JTF_VARCHAR2_TABLE_100
99 , a77 JTF_NUMBER_TABLE
100 , a78 JTF_DATE_TABLE
101 , a79 JTF_NUMBER_TABLE
102 , a80 JTF_VARCHAR2_TABLE_100
103 ) as
104 ddindx binary_integer; indx binary_integer;
105 begin
106 if a0 is not null and a0.count > 0 then
107 if a0.count > 0 then
108 indx := a0.first;
109 ddindx := 1;
110 while true loop
111 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
112 t(ddindx).qrs_code := a1(indx);
113 t(ddindx).qst_code := a2(indx);
114 t(ddindx).consolidated_qte_id := rosetta_g_miss_num_map(a3(indx));
115 t(ddindx).khr_id := rosetta_g_miss_num_map(a4(indx));
116 t(ddindx).art_id := rosetta_g_miss_num_map(a5(indx));
117 t(ddindx).qtp_code := a6(indx);
118 t(ddindx).trn_code := a7(indx);
119 t(ddindx).pop_code_end := a8(indx);
120 t(ddindx).pop_code_early := a9(indx);
121 t(ddindx).pdt_id := rosetta_g_miss_num_map(a10(indx));
122 t(ddindx).date_effective_from := rosetta_g_miss_date_in_map(a11(indx));
123 t(ddindx).quote_number := rosetta_g_miss_num_map(a12(indx));
124 t(ddindx).object_version_number := rosetta_g_miss_num_map(a13(indx));
125 t(ddindx).purchase_percent := rosetta_g_miss_num_map(a14(indx));
126 t(ddindx).term := rosetta_g_miss_num_map(a15(indx));
127 t(ddindx).date_restructure_start := rosetta_g_miss_date_in_map(a16(indx));
128 t(ddindx).date_due := rosetta_g_miss_date_in_map(a17(indx));
129 t(ddindx).date_approved := rosetta_g_miss_date_in_map(a18(indx));
130 t(ddindx).date_restructure_end := rosetta_g_miss_date_in_map(a19(indx));
131 t(ddindx).remaining_payments := rosetta_g_miss_num_map(a20(indx));
132 t(ddindx).rent_amount := rosetta_g_miss_num_map(a21(indx));
133 t(ddindx).yield := rosetta_g_miss_num_map(a22(indx));
134 t(ddindx).residual_amount := rosetta_g_miss_num_map(a23(indx));
135 t(ddindx).principal_paydown_amount := rosetta_g_miss_num_map(a24(indx));
136 t(ddindx).payment_frequency := a25(indx);
137 t(ddindx).early_termination_yn := a26(indx);
138 t(ddindx).partial_yn := a27(indx);
139 t(ddindx).preproceeds_yn := a28(indx);
140 t(ddindx).summary_format_yn := a29(indx);
141 t(ddindx).consolidated_yn := a30(indx);
142 t(ddindx).date_requested := rosetta_g_miss_date_in_map(a31(indx));
143 t(ddindx).date_proposal := rosetta_g_miss_date_in_map(a32(indx));
144 t(ddindx).date_effective_to := rosetta_g_miss_date_in_map(a33(indx));
145 t(ddindx).date_accepted := rosetta_g_miss_date_in_map(a34(indx));
146 t(ddindx).payment_received_yn := a35(indx);
147 t(ddindx).requested_by := rosetta_g_miss_num_map(a36(indx));
148 t(ddindx).approved_yn := a37(indx);
149 t(ddindx).accepted_yn := a38(indx);
150 t(ddindx).date_payment_received := rosetta_g_miss_date_in_map(a39(indx));
151 t(ddindx).approved_by := rosetta_g_miss_num_map(a40(indx));
152 t(ddindx).org_id := rosetta_g_miss_num_map(a41(indx));
153 t(ddindx).request_id := rosetta_g_miss_num_map(a42(indx));
154 t(ddindx).program_application_id := rosetta_g_miss_num_map(a43(indx));
155 t(ddindx).program_id := rosetta_g_miss_num_map(a44(indx));
156 t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a45(indx));
157 t(ddindx).attribute_category := a46(indx);
158 t(ddindx).attribute1 := a47(indx);
159 t(ddindx).attribute2 := a48(indx);
160 t(ddindx).attribute3 := a49(indx);
161 t(ddindx).attribute4 := a50(indx);
162 t(ddindx).attribute5 := a51(indx);
163 t(ddindx).attribute6 := a52(indx);
164 t(ddindx).attribute7 := a53(indx);
165 t(ddindx).attribute8 := a54(indx);
166 t(ddindx).attribute9 := a55(indx);
167 t(ddindx).attribute10 := a56(indx);
168 t(ddindx).attribute11 := a57(indx);
169 t(ddindx).attribute12 := a58(indx);
170 t(ddindx).attribute13 := a59(indx);
171 t(ddindx).attribute14 := a60(indx);
172 t(ddindx).attribute15 := a61(indx);
173 t(ddindx).created_by := rosetta_g_miss_num_map(a62(indx));
174 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a63(indx));
175 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a64(indx));
176 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a65(indx));
177 t(ddindx).last_update_login := rosetta_g_miss_num_map(a66(indx));
178 t(ddindx).purchase_amount := rosetta_g_miss_num_map(a67(indx));
179 t(ddindx).purchase_formula := a68(indx);
180 t(ddindx).asset_value := rosetta_g_miss_num_map(a69(indx));
181 t(ddindx).residual_value := rosetta_g_miss_num_map(a70(indx));
182 t(ddindx).unbilled_receivables := rosetta_g_miss_num_map(a71(indx));
183 t(ddindx).gain_loss := rosetta_g_miss_num_map(a72(indx));
184 t(ddindx).perdiem_amount := rosetta_g_miss_num_map(a73(indx));
185 t(ddindx).currency_code := a74(indx);
186 t(ddindx).currency_conversion_code := a75(indx);
187 t(ddindx).currency_conversion_type := a76(indx);
188 t(ddindx).currency_conversion_rate := rosetta_g_miss_num_map(a77(indx));
189 t(ddindx).currency_conversion_date := rosetta_g_miss_date_in_map(a78(indx));
190 t(ddindx).legal_entity_id := rosetta_g_miss_num_map(a79(indx));
191 t(ddindx).repo_quote_indicator_yn := a80(indx);
192 ddindx := ddindx+1;
193 if a0.last =indx
194 then exit;
195 end if;
196 indx := a0.next(indx);
197 end loop;
198 end if;
199 end if;
200 end rosetta_table_copy_in_p2;
201 procedure rosetta_table_copy_out_p2(t okl_qte_pvt.qte_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
202 , a1 out nocopy JTF_VARCHAR2_TABLE_100
203 , a2 out nocopy JTF_VARCHAR2_TABLE_100
204 , a3 out nocopy JTF_NUMBER_TABLE
205 , a4 out nocopy JTF_NUMBER_TABLE
206 , a5 out nocopy JTF_NUMBER_TABLE
207 , a6 out nocopy JTF_VARCHAR2_TABLE_100
208 , a7 out nocopy JTF_VARCHAR2_TABLE_100
209 , a8 out nocopy JTF_VARCHAR2_TABLE_100
210 , a9 out nocopy JTF_VARCHAR2_TABLE_100
211 , a10 out nocopy JTF_NUMBER_TABLE
212 , a11 out nocopy JTF_DATE_TABLE
213 , a12 out nocopy JTF_NUMBER_TABLE
214 , a13 out nocopy JTF_NUMBER_TABLE
215 , a14 out nocopy JTF_NUMBER_TABLE
216 , a15 out nocopy JTF_NUMBER_TABLE
217 , a16 out nocopy JTF_DATE_TABLE
218 , a17 out nocopy JTF_DATE_TABLE
219 , a18 out nocopy JTF_DATE_TABLE
220 , a19 out nocopy JTF_DATE_TABLE
221 , a20 out nocopy JTF_NUMBER_TABLE
222 , a21 out nocopy JTF_NUMBER_TABLE
223 , a22 out nocopy JTF_NUMBER_TABLE
224 , a23 out nocopy JTF_NUMBER_TABLE
225 , a24 out nocopy JTF_NUMBER_TABLE
226 , a25 out nocopy JTF_VARCHAR2_TABLE_100
227 , a26 out nocopy JTF_VARCHAR2_TABLE_100
228 , a27 out nocopy JTF_VARCHAR2_TABLE_100
229 , a28 out nocopy JTF_VARCHAR2_TABLE_100
230 , a29 out nocopy JTF_VARCHAR2_TABLE_100
231 , a30 out nocopy JTF_VARCHAR2_TABLE_100
232 , a31 out nocopy JTF_DATE_TABLE
233 , a32 out nocopy JTF_DATE_TABLE
234 , a33 out nocopy JTF_DATE_TABLE
235 , a34 out nocopy JTF_DATE_TABLE
236 , a35 out nocopy JTF_VARCHAR2_TABLE_100
237 , a36 out nocopy JTF_NUMBER_TABLE
238 , a37 out nocopy JTF_VARCHAR2_TABLE_100
239 , a38 out nocopy JTF_VARCHAR2_TABLE_100
240 , a39 out nocopy JTF_DATE_TABLE
241 , a40 out nocopy JTF_NUMBER_TABLE
242 , a41 out nocopy JTF_NUMBER_TABLE
243 , a42 out nocopy JTF_NUMBER_TABLE
244 , a43 out nocopy JTF_NUMBER_TABLE
245 , a44 out nocopy JTF_NUMBER_TABLE
246 , a45 out nocopy JTF_DATE_TABLE
247 , a46 out nocopy JTF_VARCHAR2_TABLE_100
248 , a47 out nocopy JTF_VARCHAR2_TABLE_500
249 , a48 out nocopy JTF_VARCHAR2_TABLE_500
250 , a49 out nocopy JTF_VARCHAR2_TABLE_500
251 , a50 out nocopy JTF_VARCHAR2_TABLE_500
252 , a51 out nocopy JTF_VARCHAR2_TABLE_500
253 , a52 out nocopy JTF_VARCHAR2_TABLE_500
254 , a53 out nocopy JTF_VARCHAR2_TABLE_500
255 , a54 out nocopy JTF_VARCHAR2_TABLE_500
256 , a55 out nocopy JTF_VARCHAR2_TABLE_500
257 , a56 out nocopy JTF_VARCHAR2_TABLE_500
258 , a57 out nocopy JTF_VARCHAR2_TABLE_500
259 , a58 out nocopy JTF_VARCHAR2_TABLE_500
260 , a59 out nocopy JTF_VARCHAR2_TABLE_500
261 , a60 out nocopy JTF_VARCHAR2_TABLE_500
262 , a61 out nocopy JTF_VARCHAR2_TABLE_500
263 , a62 out nocopy JTF_NUMBER_TABLE
264 , a63 out nocopy JTF_DATE_TABLE
265 , a64 out nocopy JTF_NUMBER_TABLE
266 , a65 out nocopy JTF_DATE_TABLE
267 , a66 out nocopy JTF_NUMBER_TABLE
268 , a67 out nocopy JTF_NUMBER_TABLE
269 , a68 out nocopy JTF_VARCHAR2_TABLE_200
270 , a69 out nocopy JTF_NUMBER_TABLE
271 , a70 out nocopy JTF_NUMBER_TABLE
272 , a71 out nocopy JTF_NUMBER_TABLE
273 , a72 out nocopy JTF_NUMBER_TABLE
274 , a73 out nocopy JTF_NUMBER_TABLE
275 , a74 out nocopy JTF_VARCHAR2_TABLE_100
276 , a75 out nocopy JTF_VARCHAR2_TABLE_100
277 , a76 out nocopy JTF_VARCHAR2_TABLE_100
278 , a77 out nocopy JTF_NUMBER_TABLE
279 , a78 out nocopy JTF_DATE_TABLE
280 , a79 out nocopy JTF_NUMBER_TABLE
281 , a80 out nocopy JTF_VARCHAR2_TABLE_100
282 ) as
283 ddindx binary_integer; indx binary_integer;
284 begin
285 if t is null or t.count = 0 then
286 a0 := JTF_NUMBER_TABLE();
287 a1 := JTF_VARCHAR2_TABLE_100();
288 a2 := JTF_VARCHAR2_TABLE_100();
289 a3 := JTF_NUMBER_TABLE();
290 a4 := JTF_NUMBER_TABLE();
291 a5 := JTF_NUMBER_TABLE();
292 a6 := JTF_VARCHAR2_TABLE_100();
293 a7 := JTF_VARCHAR2_TABLE_100();
294 a8 := JTF_VARCHAR2_TABLE_100();
295 a9 := JTF_VARCHAR2_TABLE_100();
296 a10 := JTF_NUMBER_TABLE();
297 a11 := JTF_DATE_TABLE();
298 a12 := JTF_NUMBER_TABLE();
299 a13 := JTF_NUMBER_TABLE();
300 a14 := JTF_NUMBER_TABLE();
301 a15 := JTF_NUMBER_TABLE();
302 a16 := JTF_DATE_TABLE();
303 a17 := JTF_DATE_TABLE();
304 a18 := JTF_DATE_TABLE();
305 a19 := JTF_DATE_TABLE();
306 a20 := JTF_NUMBER_TABLE();
307 a21 := JTF_NUMBER_TABLE();
308 a22 := JTF_NUMBER_TABLE();
309 a23 := JTF_NUMBER_TABLE();
310 a24 := JTF_NUMBER_TABLE();
311 a25 := JTF_VARCHAR2_TABLE_100();
312 a26 := JTF_VARCHAR2_TABLE_100();
313 a27 := JTF_VARCHAR2_TABLE_100();
314 a28 := JTF_VARCHAR2_TABLE_100();
315 a29 := JTF_VARCHAR2_TABLE_100();
316 a30 := JTF_VARCHAR2_TABLE_100();
317 a31 := JTF_DATE_TABLE();
318 a32 := JTF_DATE_TABLE();
319 a33 := JTF_DATE_TABLE();
320 a34 := JTF_DATE_TABLE();
321 a35 := JTF_VARCHAR2_TABLE_100();
322 a36 := JTF_NUMBER_TABLE();
323 a37 := JTF_VARCHAR2_TABLE_100();
324 a38 := JTF_VARCHAR2_TABLE_100();
325 a39 := JTF_DATE_TABLE();
326 a40 := JTF_NUMBER_TABLE();
327 a41 := JTF_NUMBER_TABLE();
328 a42 := JTF_NUMBER_TABLE();
329 a43 := JTF_NUMBER_TABLE();
330 a44 := JTF_NUMBER_TABLE();
331 a45 := JTF_DATE_TABLE();
332 a46 := JTF_VARCHAR2_TABLE_100();
333 a47 := JTF_VARCHAR2_TABLE_500();
334 a48 := JTF_VARCHAR2_TABLE_500();
335 a49 := JTF_VARCHAR2_TABLE_500();
336 a50 := JTF_VARCHAR2_TABLE_500();
337 a51 := JTF_VARCHAR2_TABLE_500();
338 a52 := JTF_VARCHAR2_TABLE_500();
339 a53 := JTF_VARCHAR2_TABLE_500();
340 a54 := JTF_VARCHAR2_TABLE_500();
341 a55 := JTF_VARCHAR2_TABLE_500();
342 a56 := JTF_VARCHAR2_TABLE_500();
343 a57 := JTF_VARCHAR2_TABLE_500();
344 a58 := JTF_VARCHAR2_TABLE_500();
345 a59 := JTF_VARCHAR2_TABLE_500();
346 a60 := JTF_VARCHAR2_TABLE_500();
347 a61 := JTF_VARCHAR2_TABLE_500();
348 a62 := JTF_NUMBER_TABLE();
349 a63 := JTF_DATE_TABLE();
350 a64 := JTF_NUMBER_TABLE();
351 a65 := JTF_DATE_TABLE();
352 a66 := JTF_NUMBER_TABLE();
353 a67 := JTF_NUMBER_TABLE();
354 a68 := JTF_VARCHAR2_TABLE_200();
355 a69 := JTF_NUMBER_TABLE();
356 a70 := JTF_NUMBER_TABLE();
357 a71 := JTF_NUMBER_TABLE();
358 a72 := JTF_NUMBER_TABLE();
359 a73 := JTF_NUMBER_TABLE();
360 a74 := JTF_VARCHAR2_TABLE_100();
361 a75 := JTF_VARCHAR2_TABLE_100();
362 a76 := JTF_VARCHAR2_TABLE_100();
363 a77 := JTF_NUMBER_TABLE();
364 a78 := JTF_DATE_TABLE();
365 a79 := JTF_NUMBER_TABLE();
366 a80 := JTF_VARCHAR2_TABLE_100();
367 else
368 a0 := JTF_NUMBER_TABLE();
369 a1 := JTF_VARCHAR2_TABLE_100();
370 a2 := JTF_VARCHAR2_TABLE_100();
371 a3 := JTF_NUMBER_TABLE();
372 a4 := JTF_NUMBER_TABLE();
373 a5 := JTF_NUMBER_TABLE();
374 a6 := JTF_VARCHAR2_TABLE_100();
375 a7 := JTF_VARCHAR2_TABLE_100();
376 a8 := JTF_VARCHAR2_TABLE_100();
377 a9 := JTF_VARCHAR2_TABLE_100();
378 a10 := JTF_NUMBER_TABLE();
379 a11 := JTF_DATE_TABLE();
380 a12 := JTF_NUMBER_TABLE();
381 a13 := JTF_NUMBER_TABLE();
382 a14 := JTF_NUMBER_TABLE();
383 a15 := JTF_NUMBER_TABLE();
384 a16 := JTF_DATE_TABLE();
385 a17 := JTF_DATE_TABLE();
386 a18 := JTF_DATE_TABLE();
387 a19 := JTF_DATE_TABLE();
388 a20 := JTF_NUMBER_TABLE();
389 a21 := JTF_NUMBER_TABLE();
390 a22 := JTF_NUMBER_TABLE();
391 a23 := JTF_NUMBER_TABLE();
392 a24 := JTF_NUMBER_TABLE();
393 a25 := JTF_VARCHAR2_TABLE_100();
394 a26 := JTF_VARCHAR2_TABLE_100();
395 a27 := JTF_VARCHAR2_TABLE_100();
396 a28 := JTF_VARCHAR2_TABLE_100();
397 a29 := JTF_VARCHAR2_TABLE_100();
398 a30 := JTF_VARCHAR2_TABLE_100();
399 a31 := JTF_DATE_TABLE();
400 a32 := JTF_DATE_TABLE();
401 a33 := JTF_DATE_TABLE();
402 a34 := JTF_DATE_TABLE();
403 a35 := JTF_VARCHAR2_TABLE_100();
404 a36 := JTF_NUMBER_TABLE();
405 a37 := JTF_VARCHAR2_TABLE_100();
406 a38 := JTF_VARCHAR2_TABLE_100();
407 a39 := JTF_DATE_TABLE();
408 a40 := JTF_NUMBER_TABLE();
409 a41 := JTF_NUMBER_TABLE();
410 a42 := JTF_NUMBER_TABLE();
411 a43 := JTF_NUMBER_TABLE();
412 a44 := JTF_NUMBER_TABLE();
413 a45 := JTF_DATE_TABLE();
414 a46 := JTF_VARCHAR2_TABLE_100();
415 a47 := JTF_VARCHAR2_TABLE_500();
416 a48 := JTF_VARCHAR2_TABLE_500();
417 a49 := JTF_VARCHAR2_TABLE_500();
418 a50 := JTF_VARCHAR2_TABLE_500();
419 a51 := JTF_VARCHAR2_TABLE_500();
420 a52 := JTF_VARCHAR2_TABLE_500();
421 a53 := JTF_VARCHAR2_TABLE_500();
422 a54 := JTF_VARCHAR2_TABLE_500();
423 a55 := JTF_VARCHAR2_TABLE_500();
424 a56 := JTF_VARCHAR2_TABLE_500();
425 a57 := JTF_VARCHAR2_TABLE_500();
426 a58 := JTF_VARCHAR2_TABLE_500();
427 a59 := JTF_VARCHAR2_TABLE_500();
428 a60 := JTF_VARCHAR2_TABLE_500();
429 a61 := JTF_VARCHAR2_TABLE_500();
430 a62 := JTF_NUMBER_TABLE();
431 a63 := JTF_DATE_TABLE();
432 a64 := JTF_NUMBER_TABLE();
433 a65 := JTF_DATE_TABLE();
434 a66 := JTF_NUMBER_TABLE();
435 a67 := JTF_NUMBER_TABLE();
436 a68 := JTF_VARCHAR2_TABLE_200();
437 a69 := JTF_NUMBER_TABLE();
438 a70 := JTF_NUMBER_TABLE();
439 a71 := JTF_NUMBER_TABLE();
440 a72 := JTF_NUMBER_TABLE();
441 a73 := JTF_NUMBER_TABLE();
442 a74 := JTF_VARCHAR2_TABLE_100();
443 a75 := JTF_VARCHAR2_TABLE_100();
444 a76 := JTF_VARCHAR2_TABLE_100();
445 a77 := JTF_NUMBER_TABLE();
446 a78 := JTF_DATE_TABLE();
447 a79 := JTF_NUMBER_TABLE();
448 a80 := JTF_VARCHAR2_TABLE_100();
449 if t.count > 0 then
450 a0.extend(t.count);
451 a1.extend(t.count);
452 a2.extend(t.count);
453 a3.extend(t.count);
454 a4.extend(t.count);
455 a5.extend(t.count);
456 a6.extend(t.count);
457 a7.extend(t.count);
458 a8.extend(t.count);
459 a9.extend(t.count);
460 a10.extend(t.count);
461 a11.extend(t.count);
462 a12.extend(t.count);
463 a13.extend(t.count);
464 a14.extend(t.count);
465 a15.extend(t.count);
466 a16.extend(t.count);
467 a17.extend(t.count);
468 a18.extend(t.count);
469 a19.extend(t.count);
470 a20.extend(t.count);
471 a21.extend(t.count);
472 a22.extend(t.count);
473 a23.extend(t.count);
474 a24.extend(t.count);
475 a25.extend(t.count);
476 a26.extend(t.count);
477 a27.extend(t.count);
478 a28.extend(t.count);
479 a29.extend(t.count);
480 a30.extend(t.count);
481 a31.extend(t.count);
482 a32.extend(t.count);
483 a33.extend(t.count);
484 a34.extend(t.count);
485 a35.extend(t.count);
486 a36.extend(t.count);
487 a37.extend(t.count);
488 a38.extend(t.count);
489 a39.extend(t.count);
490 a40.extend(t.count);
491 a41.extend(t.count);
492 a42.extend(t.count);
493 a43.extend(t.count);
494 a44.extend(t.count);
495 a45.extend(t.count);
496 a46.extend(t.count);
497 a47.extend(t.count);
498 a48.extend(t.count);
499 a49.extend(t.count);
500 a50.extend(t.count);
501 a51.extend(t.count);
502 a52.extend(t.count);
503 a53.extend(t.count);
504 a54.extend(t.count);
505 a55.extend(t.count);
506 a56.extend(t.count);
507 a57.extend(t.count);
508 a58.extend(t.count);
509 a59.extend(t.count);
510 a60.extend(t.count);
511 a61.extend(t.count);
512 a62.extend(t.count);
513 a63.extend(t.count);
514 a64.extend(t.count);
515 a65.extend(t.count);
516 a66.extend(t.count);
517 a67.extend(t.count);
518 a68.extend(t.count);
519 a69.extend(t.count);
520 a70.extend(t.count);
521 a71.extend(t.count);
522 a72.extend(t.count);
523 a73.extend(t.count);
524 a74.extend(t.count);
525 a75.extend(t.count);
526 a76.extend(t.count);
527 a77.extend(t.count);
528 a78.extend(t.count);
529 a79.extend(t.count);
530 a80.extend(t.count);
531 ddindx := t.first;
532 indx := 1;
533 while true loop
534 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
535 a1(indx) := t(ddindx).qrs_code;
536 a2(indx) := t(ddindx).qst_code;
537 a3(indx) := rosetta_g_miss_num_map(t(ddindx).consolidated_qte_id);
538 a4(indx) := rosetta_g_miss_num_map(t(ddindx).khr_id);
539 a5(indx) := rosetta_g_miss_num_map(t(ddindx).art_id);
540 a6(indx) := t(ddindx).qtp_code;
541 a7(indx) := t(ddindx).trn_code;
542 a8(indx) := t(ddindx).pop_code_end;
543 a9(indx) := t(ddindx).pop_code_early;
544 a10(indx) := rosetta_g_miss_num_map(t(ddindx).pdt_id);
545 a11(indx) := t(ddindx).date_effective_from;
546 a12(indx) := rosetta_g_miss_num_map(t(ddindx).quote_number);
547 a13(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
548 a14(indx) := rosetta_g_miss_num_map(t(ddindx).purchase_percent);
549 a15(indx) := rosetta_g_miss_num_map(t(ddindx).term);
550 a16(indx) := t(ddindx).date_restructure_start;
551 a17(indx) := t(ddindx).date_due;
552 a18(indx) := t(ddindx).date_approved;
553 a19(indx) := t(ddindx).date_restructure_end;
554 a20(indx) := rosetta_g_miss_num_map(t(ddindx).remaining_payments);
555 a21(indx) := rosetta_g_miss_num_map(t(ddindx).rent_amount);
556 a22(indx) := rosetta_g_miss_num_map(t(ddindx).yield);
557 a23(indx) := rosetta_g_miss_num_map(t(ddindx).residual_amount);
558 a24(indx) := rosetta_g_miss_num_map(t(ddindx).principal_paydown_amount);
559 a25(indx) := t(ddindx).payment_frequency;
560 a26(indx) := t(ddindx).early_termination_yn;
561 a27(indx) := t(ddindx).partial_yn;
562 a28(indx) := t(ddindx).preproceeds_yn;
563 a29(indx) := t(ddindx).summary_format_yn;
564 a30(indx) := t(ddindx).consolidated_yn;
565 a31(indx) := t(ddindx).date_requested;
566 a32(indx) := t(ddindx).date_proposal;
567 a33(indx) := t(ddindx).date_effective_to;
568 a34(indx) := t(ddindx).date_accepted;
569 a35(indx) := t(ddindx).payment_received_yn;
570 a36(indx) := rosetta_g_miss_num_map(t(ddindx).requested_by);
571 a37(indx) := t(ddindx).approved_yn;
572 a38(indx) := t(ddindx).accepted_yn;
573 a39(indx) := t(ddindx).date_payment_received;
574 a40(indx) := rosetta_g_miss_num_map(t(ddindx).approved_by);
575 a41(indx) := rosetta_g_miss_num_map(t(ddindx).org_id);
576 a42(indx) := rosetta_g_miss_num_map(t(ddindx).request_id);
577 a43(indx) := rosetta_g_miss_num_map(t(ddindx).program_application_id);
578 a44(indx) := rosetta_g_miss_num_map(t(ddindx).program_id);
579 a45(indx) := t(ddindx).program_update_date;
580 a46(indx) := t(ddindx).attribute_category;
581 a47(indx) := t(ddindx).attribute1;
582 a48(indx) := t(ddindx).attribute2;
583 a49(indx) := t(ddindx).attribute3;
584 a50(indx) := t(ddindx).attribute4;
585 a51(indx) := t(ddindx).attribute5;
586 a52(indx) := t(ddindx).attribute6;
587 a53(indx) := t(ddindx).attribute7;
588 a54(indx) := t(ddindx).attribute8;
589 a55(indx) := t(ddindx).attribute9;
590 a56(indx) := t(ddindx).attribute10;
591 a57(indx) := t(ddindx).attribute11;
592 a58(indx) := t(ddindx).attribute12;
593 a59(indx) := t(ddindx).attribute13;
594 a60(indx) := t(ddindx).attribute14;
595 a61(indx) := t(ddindx).attribute15;
596 a62(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
597 a63(indx) := t(ddindx).creation_date;
598 a64(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
599 a65(indx) := t(ddindx).last_update_date;
600 a66(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
601 a67(indx) := rosetta_g_miss_num_map(t(ddindx).purchase_amount);
602 a68(indx) := t(ddindx).purchase_formula;
603 a69(indx) := rosetta_g_miss_num_map(t(ddindx).asset_value);
604 a70(indx) := rosetta_g_miss_num_map(t(ddindx).residual_value);
605 a71(indx) := rosetta_g_miss_num_map(t(ddindx).unbilled_receivables);
606 a72(indx) := rosetta_g_miss_num_map(t(ddindx).gain_loss);
607 a73(indx) := rosetta_g_miss_num_map(t(ddindx).perdiem_amount);
608 a74(indx) := t(ddindx).currency_code;
609 a75(indx) := t(ddindx).currency_conversion_code;
610 a76(indx) := t(ddindx).currency_conversion_type;
611 a77(indx) := rosetta_g_miss_num_map(t(ddindx).currency_conversion_rate);
612 a78(indx) := t(ddindx).currency_conversion_date;
613 a79(indx) := rosetta_g_miss_num_map(t(ddindx).legal_entity_id);
614 a80(indx) := t(ddindx).repo_quote_indicator_yn;
615 indx := indx+1;
616 if t.last =ddindx
617 then exit;
618 end if;
619 ddindx := t.next(ddindx);
620 end loop;
621 end if;
622 end if;
623 end rosetta_table_copy_out_p2;
624
625 procedure rosetta_table_copy_in_p5(t out nocopy okl_qte_pvt.okl_trx_quotes_tl_tbl_type, a0 JTF_NUMBER_TABLE
626 , a1 JTF_VARCHAR2_TABLE_100
627 , a2 JTF_VARCHAR2_TABLE_100
628 , a3 JTF_VARCHAR2_TABLE_100
629 , a4 JTF_VARCHAR2_TABLE_2000
630 , a5 JTF_NUMBER_TABLE
631 , a6 JTF_DATE_TABLE
632 , a7 JTF_NUMBER_TABLE
633 , a8 JTF_DATE_TABLE
634 , a9 JTF_NUMBER_TABLE
635 ) as
636 ddindx binary_integer; indx binary_integer;
637 begin
638 if a0 is not null and a0.count > 0 then
639 if a0.count > 0 then
640 indx := a0.first;
641 ddindx := 1;
642 while true loop
643 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
644 t(ddindx).language := a1(indx);
645 t(ddindx).source_lang := a2(indx);
646 t(ddindx).sfwt_flag := a3(indx);
647 t(ddindx).comments := a4(indx);
648 t(ddindx).created_by := rosetta_g_miss_num_map(a5(indx));
649 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a6(indx));
650 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a7(indx));
651 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a8(indx));
652 t(ddindx).last_update_login := rosetta_g_miss_num_map(a9(indx));
653 ddindx := ddindx+1;
654 if a0.last =indx
655 then exit;
656 end if;
657 indx := a0.next(indx);
658 end loop;
659 end if;
660 end if;
661 end rosetta_table_copy_in_p5;
662 procedure rosetta_table_copy_out_p5(t okl_qte_pvt.okl_trx_quotes_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
663 , a1 out nocopy JTF_VARCHAR2_TABLE_100
664 , a2 out nocopy JTF_VARCHAR2_TABLE_100
665 , a3 out nocopy JTF_VARCHAR2_TABLE_100
666 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
667 , a5 out nocopy JTF_NUMBER_TABLE
668 , a6 out nocopy JTF_DATE_TABLE
669 , a7 out nocopy JTF_NUMBER_TABLE
670 , a8 out nocopy JTF_DATE_TABLE
671 , a9 out nocopy JTF_NUMBER_TABLE
672 ) as
673 ddindx binary_integer; indx binary_integer;
674 begin
675 if t is null or t.count = 0 then
676 a0 := JTF_NUMBER_TABLE();
677 a1 := JTF_VARCHAR2_TABLE_100();
678 a2 := JTF_VARCHAR2_TABLE_100();
679 a3 := JTF_VARCHAR2_TABLE_100();
680 a4 := JTF_VARCHAR2_TABLE_2000();
681 a5 := JTF_NUMBER_TABLE();
682 a6 := JTF_DATE_TABLE();
683 a7 := JTF_NUMBER_TABLE();
684 a8 := JTF_DATE_TABLE();
685 a9 := JTF_NUMBER_TABLE();
686 else
687 a0 := JTF_NUMBER_TABLE();
688 a1 := JTF_VARCHAR2_TABLE_100();
689 a2 := JTF_VARCHAR2_TABLE_100();
690 a3 := JTF_VARCHAR2_TABLE_100();
691 a4 := JTF_VARCHAR2_TABLE_2000();
692 a5 := JTF_NUMBER_TABLE();
693 a6 := JTF_DATE_TABLE();
694 a7 := JTF_NUMBER_TABLE();
695 a8 := JTF_DATE_TABLE();
696 a9 := JTF_NUMBER_TABLE();
697 if t.count > 0 then
698 a0.extend(t.count);
699 a1.extend(t.count);
700 a2.extend(t.count);
701 a3.extend(t.count);
702 a4.extend(t.count);
703 a5.extend(t.count);
704 a6.extend(t.count);
705 a7.extend(t.count);
706 a8.extend(t.count);
707 a9.extend(t.count);
708 ddindx := t.first;
709 indx := 1;
710 while true loop
711 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
712 a1(indx) := t(ddindx).language;
713 a2(indx) := t(ddindx).source_lang;
714 a3(indx) := t(ddindx).sfwt_flag;
715 a4(indx) := t(ddindx).comments;
716 a5(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
717 a6(indx) := t(ddindx).creation_date;
718 a7(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
719 a8(indx) := t(ddindx).last_update_date;
720 a9(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
721 indx := indx+1;
722 if t.last =ddindx
723 then exit;
724 end if;
725 ddindx := t.next(ddindx);
726 end loop;
727 end if;
728 end if;
729 end rosetta_table_copy_out_p5;
730
731 procedure rosetta_table_copy_in_p8(t out nocopy okl_qte_pvt.qtev_tbl_type, a0 JTF_NUMBER_TABLE
732 , a1 JTF_NUMBER_TABLE
733 , a2 JTF_VARCHAR2_TABLE_100
734 , a3 JTF_VARCHAR2_TABLE_100
735 , a4 JTF_VARCHAR2_TABLE_100
736 , a5 JTF_VARCHAR2_TABLE_100
737 , a6 JTF_VARCHAR2_TABLE_100
738 , a7 JTF_VARCHAR2_TABLE_100
739 , a8 JTF_VARCHAR2_TABLE_100
740 , a9 JTF_NUMBER_TABLE
741 , a10 JTF_NUMBER_TABLE
742 , a11 JTF_NUMBER_TABLE
743 , a12 JTF_NUMBER_TABLE
744 , a13 JTF_VARCHAR2_TABLE_100
745 , a14 JTF_VARCHAR2_TABLE_100
746 , a15 JTF_VARCHAR2_TABLE_100
747 , a16 JTF_DATE_TABLE
748 , a17 JTF_DATE_TABLE
749 , a18 JTF_DATE_TABLE
750 , a19 JTF_DATE_TABLE
751 , a20 JTF_VARCHAR2_TABLE_100
752 , a21 JTF_VARCHAR2_TABLE_100
753 , a22 JTF_NUMBER_TABLE
754 , a23 JTF_NUMBER_TABLE
755 , a24 JTF_NUMBER_TABLE
756 , a25 JTF_NUMBER_TABLE
757 , a26 JTF_DATE_TABLE
758 , a27 JTF_DATE_TABLE
759 , a28 JTF_NUMBER_TABLE
760 , a29 JTF_NUMBER_TABLE
761 , a30 JTF_VARCHAR2_TABLE_2000
762 , a31 JTF_DATE_TABLE
763 , a32 JTF_VARCHAR2_TABLE_100
764 , a33 JTF_NUMBER_TABLE
765 , a34 JTF_DATE_TABLE
766 , a35 JTF_NUMBER_TABLE
767 , a36 JTF_NUMBER_TABLE
768 , a37 JTF_VARCHAR2_TABLE_100
769 , a38 JTF_VARCHAR2_TABLE_100
770 , a39 JTF_VARCHAR2_TABLE_100
771 , a40 JTF_DATE_TABLE
772 , a41 JTF_VARCHAR2_TABLE_100
773 , a42 JTF_VARCHAR2_TABLE_500
774 , a43 JTF_VARCHAR2_TABLE_500
775 , a44 JTF_VARCHAR2_TABLE_500
776 , a45 JTF_VARCHAR2_TABLE_500
777 , a46 JTF_VARCHAR2_TABLE_500
778 , a47 JTF_VARCHAR2_TABLE_500
779 , a48 JTF_VARCHAR2_TABLE_500
780 , a49 JTF_VARCHAR2_TABLE_500
781 , a50 JTF_VARCHAR2_TABLE_500
782 , a51 JTF_VARCHAR2_TABLE_500
783 , a52 JTF_VARCHAR2_TABLE_500
784 , a53 JTF_VARCHAR2_TABLE_500
785 , a54 JTF_VARCHAR2_TABLE_500
786 , a55 JTF_VARCHAR2_TABLE_500
787 , a56 JTF_VARCHAR2_TABLE_500
788 , a57 JTF_DATE_TABLE
789 , a58 JTF_NUMBER_TABLE
790 , a59 JTF_NUMBER_TABLE
791 , a60 JTF_NUMBER_TABLE
792 , a61 JTF_NUMBER_TABLE
793 , a62 JTF_NUMBER_TABLE
794 , a63 JTF_DATE_TABLE
795 , a64 JTF_NUMBER_TABLE
796 , a65 JTF_DATE_TABLE
797 , a66 JTF_NUMBER_TABLE
798 , a67 JTF_DATE_TABLE
799 , a68 JTF_NUMBER_TABLE
800 , a69 JTF_NUMBER_TABLE
801 , a70 JTF_VARCHAR2_TABLE_200
802 , a71 JTF_NUMBER_TABLE
803 , a72 JTF_NUMBER_TABLE
804 , a73 JTF_NUMBER_TABLE
805 , a74 JTF_NUMBER_TABLE
806 , a75 JTF_NUMBER_TABLE
807 , a76 JTF_VARCHAR2_TABLE_100
808 , a77 JTF_VARCHAR2_TABLE_100
809 , a78 JTF_VARCHAR2_TABLE_100
810 , a79 JTF_NUMBER_TABLE
811 , a80 JTF_DATE_TABLE
812 , a81 JTF_NUMBER_TABLE
813 , a82 JTF_VARCHAR2_TABLE_100
814 ) as
815 ddindx binary_integer; indx binary_integer;
816 begin
817 if a0 is not null and a0.count > 0 then
818 if a0.count > 0 then
819 indx := a0.first;
820 ddindx := 1;
821 while true loop
822 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
823 t(ddindx).object_version_number := rosetta_g_miss_num_map(a1(indx));
824 t(ddindx).sfwt_flag := a2(indx);
825 t(ddindx).qrs_code := a3(indx);
826 t(ddindx).qst_code := a4(indx);
827 t(ddindx).qtp_code := a5(indx);
828 t(ddindx).trn_code := a6(indx);
829 t(ddindx).pop_code_end := a7(indx);
830 t(ddindx).pop_code_early := a8(indx);
831 t(ddindx).consolidated_qte_id := rosetta_g_miss_num_map(a9(indx));
832 t(ddindx).khr_id := rosetta_g_miss_num_map(a10(indx));
833 t(ddindx).art_id := rosetta_g_miss_num_map(a11(indx));
834 t(ddindx).pdt_id := rosetta_g_miss_num_map(a12(indx));
835 t(ddindx).early_termination_yn := a13(indx);
836 t(ddindx).partial_yn := a14(indx);
837 t(ddindx).preproceeds_yn := a15(indx);
838 t(ddindx).date_requested := rosetta_g_miss_date_in_map(a16(indx));
839 t(ddindx).date_proposal := rosetta_g_miss_date_in_map(a17(indx));
840 t(ddindx).date_effective_to := rosetta_g_miss_date_in_map(a18(indx));
841 t(ddindx).date_accepted := rosetta_g_miss_date_in_map(a19(indx));
842 t(ddindx).summary_format_yn := a20(indx);
843 t(ddindx).consolidated_yn := a21(indx);
844 t(ddindx).principal_paydown_amount := rosetta_g_miss_num_map(a22(indx));
845 t(ddindx).residual_amount := rosetta_g_miss_num_map(a23(indx));
846 t(ddindx).yield := rosetta_g_miss_num_map(a24(indx));
847 t(ddindx).rent_amount := rosetta_g_miss_num_map(a25(indx));
848 t(ddindx).date_restructure_end := rosetta_g_miss_date_in_map(a26(indx));
849 t(ddindx).date_restructure_start := rosetta_g_miss_date_in_map(a27(indx));
850 t(ddindx).term := rosetta_g_miss_num_map(a28(indx));
851 t(ddindx).purchase_percent := rosetta_g_miss_num_map(a29(indx));
852 t(ddindx).comments := a30(indx);
853 t(ddindx).date_due := rosetta_g_miss_date_in_map(a31(indx));
854 t(ddindx).payment_frequency := a32(indx);
855 t(ddindx).remaining_payments := rosetta_g_miss_num_map(a33(indx));
856 t(ddindx).date_effective_from := rosetta_g_miss_date_in_map(a34(indx));
857 t(ddindx).quote_number := rosetta_g_miss_num_map(a35(indx));
858 t(ddindx).requested_by := rosetta_g_miss_num_map(a36(indx));
859 t(ddindx).approved_yn := a37(indx);
860 t(ddindx).accepted_yn := a38(indx);
861 t(ddindx).payment_received_yn := a39(indx);
862 t(ddindx).date_payment_received := rosetta_g_miss_date_in_map(a40(indx));
863 t(ddindx).attribute_category := a41(indx);
864 t(ddindx).attribute1 := a42(indx);
865 t(ddindx).attribute2 := a43(indx);
866 t(ddindx).attribute3 := a44(indx);
867 t(ddindx).attribute4 := a45(indx);
868 t(ddindx).attribute5 := a46(indx);
869 t(ddindx).attribute6 := a47(indx);
870 t(ddindx).attribute7 := a48(indx);
871 t(ddindx).attribute8 := a49(indx);
872 t(ddindx).attribute9 := a50(indx);
873 t(ddindx).attribute10 := a51(indx);
874 t(ddindx).attribute11 := a52(indx);
875 t(ddindx).attribute12 := a53(indx);
876 t(ddindx).attribute13 := a54(indx);
877 t(ddindx).attribute14 := a55(indx);
878 t(ddindx).attribute15 := a56(indx);
879 t(ddindx).date_approved := rosetta_g_miss_date_in_map(a57(indx));
880 t(ddindx).approved_by := rosetta_g_miss_num_map(a58(indx));
881 t(ddindx).org_id := rosetta_g_miss_num_map(a59(indx));
882 t(ddindx).request_id := rosetta_g_miss_num_map(a60(indx));
883 t(ddindx).program_application_id := rosetta_g_miss_num_map(a61(indx));
884 t(ddindx).program_id := rosetta_g_miss_num_map(a62(indx));
885 t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a63(indx));
886 t(ddindx).created_by := rosetta_g_miss_num_map(a64(indx));
887 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a65(indx));
888 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a66(indx));
889 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a67(indx));
890 t(ddindx).last_update_login := rosetta_g_miss_num_map(a68(indx));
891 t(ddindx).purchase_amount := rosetta_g_miss_num_map(a69(indx));
892 t(ddindx).purchase_formula := a70(indx);
893 t(ddindx).asset_value := rosetta_g_miss_num_map(a71(indx));
894 t(ddindx).residual_value := rosetta_g_miss_num_map(a72(indx));
895 t(ddindx).unbilled_receivables := rosetta_g_miss_num_map(a73(indx));
896 t(ddindx).gain_loss := rosetta_g_miss_num_map(a74(indx));
897 t(ddindx).perdiem_amount := rosetta_g_miss_num_map(a75(indx));
898 t(ddindx).currency_code := a76(indx);
899 t(ddindx).currency_conversion_code := a77(indx);
900 t(ddindx).currency_conversion_type := a78(indx);
901 t(ddindx).currency_conversion_rate := rosetta_g_miss_num_map(a79(indx));
902 t(ddindx).currency_conversion_date := rosetta_g_miss_date_in_map(a80(indx));
903 t(ddindx).legal_entity_id := rosetta_g_miss_num_map(a81(indx));
904 t(ddindx).repo_quote_indicator_yn := a82(indx);
905 ddindx := ddindx+1;
906 if a0.last =indx
907 then exit;
908 end if;
909 indx := a0.next(indx);
910 end loop;
911 end if;
912 end if;
913 end rosetta_table_copy_in_p8;
914 procedure rosetta_table_copy_out_p8(t okl_qte_pvt.qtev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
915 , a1 out nocopy JTF_NUMBER_TABLE
916 , a2 out nocopy JTF_VARCHAR2_TABLE_100
917 , a3 out nocopy JTF_VARCHAR2_TABLE_100
918 , a4 out nocopy JTF_VARCHAR2_TABLE_100
919 , a5 out nocopy JTF_VARCHAR2_TABLE_100
920 , a6 out nocopy JTF_VARCHAR2_TABLE_100
921 , a7 out nocopy JTF_VARCHAR2_TABLE_100
922 , a8 out nocopy JTF_VARCHAR2_TABLE_100
923 , a9 out nocopy JTF_NUMBER_TABLE
924 , a10 out nocopy JTF_NUMBER_TABLE
925 , a11 out nocopy JTF_NUMBER_TABLE
926 , a12 out nocopy JTF_NUMBER_TABLE
927 , a13 out nocopy JTF_VARCHAR2_TABLE_100
928 , a14 out nocopy JTF_VARCHAR2_TABLE_100
929 , a15 out nocopy JTF_VARCHAR2_TABLE_100
930 , a16 out nocopy JTF_DATE_TABLE
931 , a17 out nocopy JTF_DATE_TABLE
932 , a18 out nocopy JTF_DATE_TABLE
933 , a19 out nocopy JTF_DATE_TABLE
934 , a20 out nocopy JTF_VARCHAR2_TABLE_100
935 , a21 out nocopy JTF_VARCHAR2_TABLE_100
936 , a22 out nocopy JTF_NUMBER_TABLE
937 , a23 out nocopy JTF_NUMBER_TABLE
938 , a24 out nocopy JTF_NUMBER_TABLE
939 , a25 out nocopy JTF_NUMBER_TABLE
940 , a26 out nocopy JTF_DATE_TABLE
941 , a27 out nocopy JTF_DATE_TABLE
942 , a28 out nocopy JTF_NUMBER_TABLE
943 , a29 out nocopy JTF_NUMBER_TABLE
944 , a30 out nocopy JTF_VARCHAR2_TABLE_2000
945 , a31 out nocopy JTF_DATE_TABLE
946 , a32 out nocopy JTF_VARCHAR2_TABLE_100
947 , a33 out nocopy JTF_NUMBER_TABLE
948 , a34 out nocopy JTF_DATE_TABLE
949 , a35 out nocopy JTF_NUMBER_TABLE
950 , a36 out nocopy JTF_NUMBER_TABLE
951 , a37 out nocopy JTF_VARCHAR2_TABLE_100
952 , a38 out nocopy JTF_VARCHAR2_TABLE_100
953 , a39 out nocopy JTF_VARCHAR2_TABLE_100
954 , a40 out nocopy JTF_DATE_TABLE
955 , a41 out nocopy JTF_VARCHAR2_TABLE_100
956 , a42 out nocopy JTF_VARCHAR2_TABLE_500
957 , a43 out nocopy JTF_VARCHAR2_TABLE_500
958 , a44 out nocopy JTF_VARCHAR2_TABLE_500
959 , a45 out nocopy JTF_VARCHAR2_TABLE_500
960 , a46 out nocopy JTF_VARCHAR2_TABLE_500
961 , a47 out nocopy JTF_VARCHAR2_TABLE_500
962 , a48 out nocopy JTF_VARCHAR2_TABLE_500
963 , a49 out nocopy JTF_VARCHAR2_TABLE_500
964 , a50 out nocopy JTF_VARCHAR2_TABLE_500
965 , a51 out nocopy JTF_VARCHAR2_TABLE_500
966 , a52 out nocopy JTF_VARCHAR2_TABLE_500
967 , a53 out nocopy JTF_VARCHAR2_TABLE_500
968 , a54 out nocopy JTF_VARCHAR2_TABLE_500
969 , a55 out nocopy JTF_VARCHAR2_TABLE_500
970 , a56 out nocopy JTF_VARCHAR2_TABLE_500
971 , a57 out nocopy JTF_DATE_TABLE
972 , a58 out nocopy JTF_NUMBER_TABLE
973 , a59 out nocopy JTF_NUMBER_TABLE
974 , a60 out nocopy JTF_NUMBER_TABLE
975 , a61 out nocopy JTF_NUMBER_TABLE
976 , a62 out nocopy JTF_NUMBER_TABLE
977 , a63 out nocopy JTF_DATE_TABLE
978 , a64 out nocopy JTF_NUMBER_TABLE
979 , a65 out nocopy JTF_DATE_TABLE
980 , a66 out nocopy JTF_NUMBER_TABLE
981 , a67 out nocopy JTF_DATE_TABLE
982 , a68 out nocopy JTF_NUMBER_TABLE
983 , a69 out nocopy JTF_NUMBER_TABLE
984 , a70 out nocopy JTF_VARCHAR2_TABLE_200
985 , a71 out nocopy JTF_NUMBER_TABLE
986 , a72 out nocopy JTF_NUMBER_TABLE
987 , a73 out nocopy JTF_NUMBER_TABLE
988 , a74 out nocopy JTF_NUMBER_TABLE
989 , a75 out nocopy JTF_NUMBER_TABLE
990 , a76 out nocopy JTF_VARCHAR2_TABLE_100
991 , a77 out nocopy JTF_VARCHAR2_TABLE_100
992 , a78 out nocopy JTF_VARCHAR2_TABLE_100
993 , a79 out nocopy JTF_NUMBER_TABLE
994 , a80 out nocopy JTF_DATE_TABLE
995 , a81 out nocopy JTF_NUMBER_TABLE
996 , a82 out nocopy JTF_VARCHAR2_TABLE_100
997 ) as
998 ddindx binary_integer; indx binary_integer;
999 begin
1000 if t is null or t.count = 0 then
1001 a0 := JTF_NUMBER_TABLE();
1002 a1 := JTF_NUMBER_TABLE();
1003 a2 := JTF_VARCHAR2_TABLE_100();
1004 a3 := JTF_VARCHAR2_TABLE_100();
1005 a4 := JTF_VARCHAR2_TABLE_100();
1006 a5 := JTF_VARCHAR2_TABLE_100();
1007 a6 := JTF_VARCHAR2_TABLE_100();
1008 a7 := JTF_VARCHAR2_TABLE_100();
1009 a8 := JTF_VARCHAR2_TABLE_100();
1010 a9 := JTF_NUMBER_TABLE();
1011 a10 := JTF_NUMBER_TABLE();
1012 a11 := JTF_NUMBER_TABLE();
1013 a12 := JTF_NUMBER_TABLE();
1014 a13 := JTF_VARCHAR2_TABLE_100();
1015 a14 := JTF_VARCHAR2_TABLE_100();
1016 a15 := JTF_VARCHAR2_TABLE_100();
1017 a16 := JTF_DATE_TABLE();
1018 a17 := JTF_DATE_TABLE();
1019 a18 := JTF_DATE_TABLE();
1020 a19 := JTF_DATE_TABLE();
1021 a20 := JTF_VARCHAR2_TABLE_100();
1022 a21 := JTF_VARCHAR2_TABLE_100();
1023 a22 := JTF_NUMBER_TABLE();
1024 a23 := JTF_NUMBER_TABLE();
1025 a24 := JTF_NUMBER_TABLE();
1026 a25 := JTF_NUMBER_TABLE();
1027 a26 := JTF_DATE_TABLE();
1028 a27 := JTF_DATE_TABLE();
1029 a28 := JTF_NUMBER_TABLE();
1030 a29 := JTF_NUMBER_TABLE();
1031 a30 := JTF_VARCHAR2_TABLE_2000();
1032 a31 := JTF_DATE_TABLE();
1033 a32 := JTF_VARCHAR2_TABLE_100();
1034 a33 := JTF_NUMBER_TABLE();
1035 a34 := JTF_DATE_TABLE();
1036 a35 := JTF_NUMBER_TABLE();
1037 a36 := JTF_NUMBER_TABLE();
1038 a37 := JTF_VARCHAR2_TABLE_100();
1039 a38 := JTF_VARCHAR2_TABLE_100();
1040 a39 := JTF_VARCHAR2_TABLE_100();
1041 a40 := JTF_DATE_TABLE();
1042 a41 := JTF_VARCHAR2_TABLE_100();
1043 a42 := JTF_VARCHAR2_TABLE_500();
1044 a43 := JTF_VARCHAR2_TABLE_500();
1045 a44 := JTF_VARCHAR2_TABLE_500();
1046 a45 := JTF_VARCHAR2_TABLE_500();
1047 a46 := JTF_VARCHAR2_TABLE_500();
1048 a47 := JTF_VARCHAR2_TABLE_500();
1049 a48 := JTF_VARCHAR2_TABLE_500();
1050 a49 := JTF_VARCHAR2_TABLE_500();
1051 a50 := JTF_VARCHAR2_TABLE_500();
1052 a51 := JTF_VARCHAR2_TABLE_500();
1053 a52 := JTF_VARCHAR2_TABLE_500();
1054 a53 := JTF_VARCHAR2_TABLE_500();
1055 a54 := JTF_VARCHAR2_TABLE_500();
1056 a55 := JTF_VARCHAR2_TABLE_500();
1057 a56 := JTF_VARCHAR2_TABLE_500();
1058 a57 := JTF_DATE_TABLE();
1059 a58 := JTF_NUMBER_TABLE();
1060 a59 := JTF_NUMBER_TABLE();
1061 a60 := JTF_NUMBER_TABLE();
1062 a61 := JTF_NUMBER_TABLE();
1063 a62 := JTF_NUMBER_TABLE();
1064 a63 := JTF_DATE_TABLE();
1065 a64 := JTF_NUMBER_TABLE();
1066 a65 := JTF_DATE_TABLE();
1067 a66 := JTF_NUMBER_TABLE();
1068 a67 := JTF_DATE_TABLE();
1069 a68 := JTF_NUMBER_TABLE();
1070 a69 := JTF_NUMBER_TABLE();
1071 a70 := JTF_VARCHAR2_TABLE_200();
1072 a71 := JTF_NUMBER_TABLE();
1073 a72 := JTF_NUMBER_TABLE();
1074 a73 := JTF_NUMBER_TABLE();
1075 a74 := JTF_NUMBER_TABLE();
1076 a75 := JTF_NUMBER_TABLE();
1077 a76 := JTF_VARCHAR2_TABLE_100();
1078 a77 := JTF_VARCHAR2_TABLE_100();
1079 a78 := JTF_VARCHAR2_TABLE_100();
1080 a79 := JTF_NUMBER_TABLE();
1081 a80 := JTF_DATE_TABLE();
1082 a81 := JTF_NUMBER_TABLE();
1083 a82 := JTF_VARCHAR2_TABLE_100();
1084 else
1085 a0 := JTF_NUMBER_TABLE();
1086 a1 := JTF_NUMBER_TABLE();
1087 a2 := JTF_VARCHAR2_TABLE_100();
1088 a3 := JTF_VARCHAR2_TABLE_100();
1089 a4 := JTF_VARCHAR2_TABLE_100();
1090 a5 := JTF_VARCHAR2_TABLE_100();
1091 a6 := JTF_VARCHAR2_TABLE_100();
1092 a7 := JTF_VARCHAR2_TABLE_100();
1093 a8 := JTF_VARCHAR2_TABLE_100();
1094 a9 := JTF_NUMBER_TABLE();
1095 a10 := JTF_NUMBER_TABLE();
1096 a11 := JTF_NUMBER_TABLE();
1097 a12 := JTF_NUMBER_TABLE();
1098 a13 := JTF_VARCHAR2_TABLE_100();
1099 a14 := JTF_VARCHAR2_TABLE_100();
1100 a15 := JTF_VARCHAR2_TABLE_100();
1101 a16 := JTF_DATE_TABLE();
1102 a17 := JTF_DATE_TABLE();
1103 a18 := JTF_DATE_TABLE();
1104 a19 := JTF_DATE_TABLE();
1105 a20 := JTF_VARCHAR2_TABLE_100();
1106 a21 := JTF_VARCHAR2_TABLE_100();
1107 a22 := JTF_NUMBER_TABLE();
1108 a23 := JTF_NUMBER_TABLE();
1109 a24 := JTF_NUMBER_TABLE();
1110 a25 := JTF_NUMBER_TABLE();
1111 a26 := JTF_DATE_TABLE();
1112 a27 := JTF_DATE_TABLE();
1113 a28 := JTF_NUMBER_TABLE();
1114 a29 := JTF_NUMBER_TABLE();
1115 a30 := JTF_VARCHAR2_TABLE_2000();
1116 a31 := JTF_DATE_TABLE();
1117 a32 := JTF_VARCHAR2_TABLE_100();
1118 a33 := JTF_NUMBER_TABLE();
1119 a34 := JTF_DATE_TABLE();
1120 a35 := JTF_NUMBER_TABLE();
1121 a36 := JTF_NUMBER_TABLE();
1122 a37 := JTF_VARCHAR2_TABLE_100();
1123 a38 := JTF_VARCHAR2_TABLE_100();
1124 a39 := JTF_VARCHAR2_TABLE_100();
1125 a40 := JTF_DATE_TABLE();
1126 a41 := JTF_VARCHAR2_TABLE_100();
1127 a42 := JTF_VARCHAR2_TABLE_500();
1128 a43 := JTF_VARCHAR2_TABLE_500();
1129 a44 := JTF_VARCHAR2_TABLE_500();
1130 a45 := JTF_VARCHAR2_TABLE_500();
1131 a46 := JTF_VARCHAR2_TABLE_500();
1132 a47 := JTF_VARCHAR2_TABLE_500();
1133 a48 := JTF_VARCHAR2_TABLE_500();
1134 a49 := JTF_VARCHAR2_TABLE_500();
1135 a50 := JTF_VARCHAR2_TABLE_500();
1136 a51 := JTF_VARCHAR2_TABLE_500();
1137 a52 := JTF_VARCHAR2_TABLE_500();
1138 a53 := JTF_VARCHAR2_TABLE_500();
1139 a54 := JTF_VARCHAR2_TABLE_500();
1140 a55 := JTF_VARCHAR2_TABLE_500();
1141 a56 := JTF_VARCHAR2_TABLE_500();
1142 a57 := JTF_DATE_TABLE();
1143 a58 := JTF_NUMBER_TABLE();
1144 a59 := JTF_NUMBER_TABLE();
1145 a60 := JTF_NUMBER_TABLE();
1146 a61 := JTF_NUMBER_TABLE();
1147 a62 := JTF_NUMBER_TABLE();
1148 a63 := JTF_DATE_TABLE();
1149 a64 := JTF_NUMBER_TABLE();
1150 a65 := JTF_DATE_TABLE();
1151 a66 := JTF_NUMBER_TABLE();
1152 a67 := JTF_DATE_TABLE();
1153 a68 := JTF_NUMBER_TABLE();
1154 a69 := JTF_NUMBER_TABLE();
1155 a70 := JTF_VARCHAR2_TABLE_200();
1156 a71 := JTF_NUMBER_TABLE();
1157 a72 := JTF_NUMBER_TABLE();
1158 a73 := JTF_NUMBER_TABLE();
1159 a74 := JTF_NUMBER_TABLE();
1160 a75 := JTF_NUMBER_TABLE();
1161 a76 := JTF_VARCHAR2_TABLE_100();
1162 a77 := JTF_VARCHAR2_TABLE_100();
1163 a78 := JTF_VARCHAR2_TABLE_100();
1164 a79 := JTF_NUMBER_TABLE();
1165 a80 := JTF_DATE_TABLE();
1166 a81 := JTF_NUMBER_TABLE();
1167 a82 := JTF_VARCHAR2_TABLE_100();
1168 if t.count > 0 then
1169 a0.extend(t.count);
1170 a1.extend(t.count);
1171 a2.extend(t.count);
1172 a3.extend(t.count);
1173 a4.extend(t.count);
1174 a5.extend(t.count);
1175 a6.extend(t.count);
1176 a7.extend(t.count);
1177 a8.extend(t.count);
1178 a9.extend(t.count);
1179 a10.extend(t.count);
1180 a11.extend(t.count);
1181 a12.extend(t.count);
1182 a13.extend(t.count);
1183 a14.extend(t.count);
1184 a15.extend(t.count);
1185 a16.extend(t.count);
1186 a17.extend(t.count);
1187 a18.extend(t.count);
1188 a19.extend(t.count);
1189 a20.extend(t.count);
1190 a21.extend(t.count);
1191 a22.extend(t.count);
1192 a23.extend(t.count);
1193 a24.extend(t.count);
1194 a25.extend(t.count);
1195 a26.extend(t.count);
1196 a27.extend(t.count);
1197 a28.extend(t.count);
1198 a29.extend(t.count);
1199 a30.extend(t.count);
1200 a31.extend(t.count);
1201 a32.extend(t.count);
1202 a33.extend(t.count);
1203 a34.extend(t.count);
1204 a35.extend(t.count);
1205 a36.extend(t.count);
1206 a37.extend(t.count);
1207 a38.extend(t.count);
1208 a39.extend(t.count);
1209 a40.extend(t.count);
1210 a41.extend(t.count);
1211 a42.extend(t.count);
1212 a43.extend(t.count);
1213 a44.extend(t.count);
1214 a45.extend(t.count);
1215 a46.extend(t.count);
1216 a47.extend(t.count);
1217 a48.extend(t.count);
1218 a49.extend(t.count);
1219 a50.extend(t.count);
1220 a51.extend(t.count);
1221 a52.extend(t.count);
1222 a53.extend(t.count);
1223 a54.extend(t.count);
1224 a55.extend(t.count);
1225 a56.extend(t.count);
1226 a57.extend(t.count);
1227 a58.extend(t.count);
1228 a59.extend(t.count);
1229 a60.extend(t.count);
1230 a61.extend(t.count);
1231 a62.extend(t.count);
1232 a63.extend(t.count);
1233 a64.extend(t.count);
1234 a65.extend(t.count);
1235 a66.extend(t.count);
1236 a67.extend(t.count);
1237 a68.extend(t.count);
1238 a69.extend(t.count);
1239 a70.extend(t.count);
1240 a71.extend(t.count);
1241 a72.extend(t.count);
1242 a73.extend(t.count);
1243 a74.extend(t.count);
1244 a75.extend(t.count);
1245 a76.extend(t.count);
1246 a77.extend(t.count);
1247 a78.extend(t.count);
1248 a79.extend(t.count);
1249 a80.extend(t.count);
1250 a81.extend(t.count);
1251 a82.extend(t.count);
1252 ddindx := t.first;
1253 indx := 1;
1254 while true loop
1255 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
1256 a1(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
1257 a2(indx) := t(ddindx).sfwt_flag;
1258 a3(indx) := t(ddindx).qrs_code;
1259 a4(indx) := t(ddindx).qst_code;
1260 a5(indx) := t(ddindx).qtp_code;
1261 a6(indx) := t(ddindx).trn_code;
1262 a7(indx) := t(ddindx).pop_code_end;
1263 a8(indx) := t(ddindx).pop_code_early;
1264 a9(indx) := rosetta_g_miss_num_map(t(ddindx).consolidated_qte_id);
1265 a10(indx) := rosetta_g_miss_num_map(t(ddindx).khr_id);
1266 a11(indx) := rosetta_g_miss_num_map(t(ddindx).art_id);
1267 a12(indx) := rosetta_g_miss_num_map(t(ddindx).pdt_id);
1268 a13(indx) := t(ddindx).early_termination_yn;
1269 a14(indx) := t(ddindx).partial_yn;
1270 a15(indx) := t(ddindx).preproceeds_yn;
1271 a16(indx) := t(ddindx).date_requested;
1272 a17(indx) := t(ddindx).date_proposal;
1273 a18(indx) := t(ddindx).date_effective_to;
1274 a19(indx) := t(ddindx).date_accepted;
1275 a20(indx) := t(ddindx).summary_format_yn;
1276 a21(indx) := t(ddindx).consolidated_yn;
1277 a22(indx) := rosetta_g_miss_num_map(t(ddindx).principal_paydown_amount);
1278 a23(indx) := rosetta_g_miss_num_map(t(ddindx).residual_amount);
1279 a24(indx) := rosetta_g_miss_num_map(t(ddindx).yield);
1280 a25(indx) := rosetta_g_miss_num_map(t(ddindx).rent_amount);
1281 a26(indx) := t(ddindx).date_restructure_end;
1282 a27(indx) := t(ddindx).date_restructure_start;
1283 a28(indx) := rosetta_g_miss_num_map(t(ddindx).term);
1284 a29(indx) := rosetta_g_miss_num_map(t(ddindx).purchase_percent);
1285 a30(indx) := t(ddindx).comments;
1286 a31(indx) := t(ddindx).date_due;
1287 a32(indx) := t(ddindx).payment_frequency;
1288 a33(indx) := rosetta_g_miss_num_map(t(ddindx).remaining_payments);
1289 a34(indx) := t(ddindx).date_effective_from;
1290 a35(indx) := rosetta_g_miss_num_map(t(ddindx).quote_number);
1291 a36(indx) := rosetta_g_miss_num_map(t(ddindx).requested_by);
1292 a37(indx) := t(ddindx).approved_yn;
1293 a38(indx) := t(ddindx).accepted_yn;
1294 a39(indx) := t(ddindx).payment_received_yn;
1295 a40(indx) := t(ddindx).date_payment_received;
1296 a41(indx) := t(ddindx).attribute_category;
1297 a42(indx) := t(ddindx).attribute1;
1298 a43(indx) := t(ddindx).attribute2;
1299 a44(indx) := t(ddindx).attribute3;
1300 a45(indx) := t(ddindx).attribute4;
1301 a46(indx) := t(ddindx).attribute5;
1302 a47(indx) := t(ddindx).attribute6;
1303 a48(indx) := t(ddindx).attribute7;
1304 a49(indx) := t(ddindx).attribute8;
1305 a50(indx) := t(ddindx).attribute9;
1306 a51(indx) := t(ddindx).attribute10;
1307 a52(indx) := t(ddindx).attribute11;
1308 a53(indx) := t(ddindx).attribute12;
1309 a54(indx) := t(ddindx).attribute13;
1310 a55(indx) := t(ddindx).attribute14;
1311 a56(indx) := t(ddindx).attribute15;
1312 a57(indx) := t(ddindx).date_approved;
1313 a58(indx) := rosetta_g_miss_num_map(t(ddindx).approved_by);
1314 a59(indx) := rosetta_g_miss_num_map(t(ddindx).org_id);
1315 a60(indx) := rosetta_g_miss_num_map(t(ddindx).request_id);
1316 a61(indx) := rosetta_g_miss_num_map(t(ddindx).program_application_id);
1317 a62(indx) := rosetta_g_miss_num_map(t(ddindx).program_id);
1318 a63(indx) := t(ddindx).program_update_date;
1319 a64(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
1320 a65(indx) := t(ddindx).creation_date;
1321 a66(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
1322 a67(indx) := t(ddindx).last_update_date;
1323 a68(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
1324 a69(indx) := rosetta_g_miss_num_map(t(ddindx).purchase_amount);
1325 a70(indx) := t(ddindx).purchase_formula;
1326 a71(indx) := rosetta_g_miss_num_map(t(ddindx).asset_value);
1327 a72(indx) := rosetta_g_miss_num_map(t(ddindx).residual_value);
1328 a73(indx) := rosetta_g_miss_num_map(t(ddindx).unbilled_receivables);
1329 a74(indx) := rosetta_g_miss_num_map(t(ddindx).gain_loss);
1330 a75(indx) := rosetta_g_miss_num_map(t(ddindx).perdiem_amount);
1331 a76(indx) := t(ddindx).currency_code;
1332 a77(indx) := t(ddindx).currency_conversion_code;
1333 a78(indx) := t(ddindx).currency_conversion_type;
1334 a79(indx) := rosetta_g_miss_num_map(t(ddindx).currency_conversion_rate);
1335 a80(indx) := t(ddindx).currency_conversion_date;
1336 a81(indx) := rosetta_g_miss_num_map(t(ddindx).legal_entity_id);
1337 a82(indx) := t(ddindx).repo_quote_indicator_yn;
1338 indx := indx+1;
1339 if t.last =ddindx
1340 then exit;
1341 end if;
1342 ddindx := t.next(ddindx);
1343 end loop;
1344 end if;
1345 end if;
1346 end rosetta_table_copy_out_p8;
1347
1348 procedure insert_row(p_api_version NUMBER
1349 , p_init_msg_list VARCHAR2
1350 , x_return_status out nocopy VARCHAR2
1351 , x_msg_count out nocopy NUMBER
1352 , x_msg_data out nocopy VARCHAR2
1353 , p6_a0 out nocopy NUMBER
1354 , p6_a1 out nocopy NUMBER
1355 , p6_a2 out nocopy VARCHAR2
1356 , p6_a3 out nocopy VARCHAR2
1357 , p6_a4 out nocopy VARCHAR2
1358 , p6_a5 out nocopy VARCHAR2
1359 , p6_a6 out nocopy VARCHAR2
1360 , p6_a7 out nocopy VARCHAR2
1361 , p6_a8 out nocopy VARCHAR2
1362 , p6_a9 out nocopy NUMBER
1363 , p6_a10 out nocopy NUMBER
1364 , p6_a11 out nocopy NUMBER
1365 , p6_a12 out nocopy NUMBER
1366 , p6_a13 out nocopy VARCHAR2
1367 , p6_a14 out nocopy VARCHAR2
1368 , p6_a15 out nocopy VARCHAR2
1369 , p6_a16 out nocopy DATE
1370 , p6_a17 out nocopy DATE
1371 , p6_a18 out nocopy DATE
1372 , p6_a19 out nocopy DATE
1373 , p6_a20 out nocopy VARCHAR2
1374 , p6_a21 out nocopy VARCHAR2
1375 , p6_a22 out nocopy NUMBER
1376 , p6_a23 out nocopy NUMBER
1377 , p6_a24 out nocopy NUMBER
1378 , p6_a25 out nocopy NUMBER
1379 , p6_a26 out nocopy DATE
1380 , p6_a27 out nocopy DATE
1381 , p6_a28 out nocopy NUMBER
1382 , p6_a29 out nocopy NUMBER
1383 , p6_a30 out nocopy VARCHAR2
1384 , p6_a31 out nocopy DATE
1385 , p6_a32 out nocopy VARCHAR2
1386 , p6_a33 out nocopy NUMBER
1387 , p6_a34 out nocopy DATE
1388 , p6_a35 out nocopy NUMBER
1389 , p6_a36 out nocopy NUMBER
1390 , p6_a37 out nocopy VARCHAR2
1391 , p6_a38 out nocopy VARCHAR2
1392 , p6_a39 out nocopy VARCHAR2
1393 , p6_a40 out nocopy DATE
1394 , p6_a41 out nocopy VARCHAR2
1395 , p6_a42 out nocopy VARCHAR2
1396 , p6_a43 out nocopy VARCHAR2
1397 , p6_a44 out nocopy VARCHAR2
1398 , p6_a45 out nocopy VARCHAR2
1399 , p6_a46 out nocopy VARCHAR2
1400 , p6_a47 out nocopy VARCHAR2
1401 , p6_a48 out nocopy VARCHAR2
1402 , p6_a49 out nocopy VARCHAR2
1403 , p6_a50 out nocopy VARCHAR2
1404 , p6_a51 out nocopy VARCHAR2
1405 , p6_a52 out nocopy VARCHAR2
1406 , p6_a53 out nocopy VARCHAR2
1407 , p6_a54 out nocopy VARCHAR2
1408 , p6_a55 out nocopy VARCHAR2
1409 , p6_a56 out nocopy VARCHAR2
1410 , p6_a57 out nocopy DATE
1411 , p6_a58 out nocopy NUMBER
1412 , p6_a59 out nocopy NUMBER
1413 , p6_a60 out nocopy NUMBER
1414 , p6_a61 out nocopy NUMBER
1415 , p6_a62 out nocopy NUMBER
1416 , p6_a63 out nocopy DATE
1417 , p6_a64 out nocopy NUMBER
1418 , p6_a65 out nocopy DATE
1419 , p6_a66 out nocopy NUMBER
1420 , p6_a67 out nocopy DATE
1421 , p6_a68 out nocopy NUMBER
1422 , p6_a69 out nocopy NUMBER
1423 , p6_a70 out nocopy VARCHAR2
1424 , p6_a71 out nocopy NUMBER
1425 , p6_a72 out nocopy NUMBER
1426 , p6_a73 out nocopy NUMBER
1427 , p6_a74 out nocopy NUMBER
1428 , p6_a75 out nocopy NUMBER
1429 , p6_a76 out nocopy VARCHAR2
1430 , p6_a77 out nocopy VARCHAR2
1431 , p6_a78 out nocopy VARCHAR2
1432 , p6_a79 out nocopy NUMBER
1433 , p6_a80 out nocopy DATE
1434 , p6_a81 out nocopy NUMBER
1435 , p6_a82 out nocopy VARCHAR2
1436 , p5_a0 NUMBER := 0-1962.0724
1437 , p5_a1 NUMBER := 0-1962.0724
1438 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1439 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1440 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1441 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1442 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1443 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1444 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1445 , p5_a9 NUMBER := 0-1962.0724
1446 , p5_a10 NUMBER := 0-1962.0724
1447 , p5_a11 NUMBER := 0-1962.0724
1448 , p5_a12 NUMBER := 0-1962.0724
1449 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1450 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1451 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1452 , p5_a16 DATE := fnd_api.g_miss_date
1453 , p5_a17 DATE := fnd_api.g_miss_date
1454 , p5_a18 DATE := fnd_api.g_miss_date
1455 , p5_a19 DATE := fnd_api.g_miss_date
1456 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1457 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1458 , p5_a22 NUMBER := 0-1962.0724
1459 , p5_a23 NUMBER := 0-1962.0724
1460 , p5_a24 NUMBER := 0-1962.0724
1461 , p5_a25 NUMBER := 0-1962.0724
1462 , p5_a26 DATE := fnd_api.g_miss_date
1463 , p5_a27 DATE := fnd_api.g_miss_date
1464 , p5_a28 NUMBER := 0-1962.0724
1465 , p5_a29 NUMBER := 0-1962.0724
1466 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1467 , p5_a31 DATE := fnd_api.g_miss_date
1468 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1469 , p5_a33 NUMBER := 0-1962.0724
1470 , p5_a34 DATE := fnd_api.g_miss_date
1471 , p5_a35 NUMBER := 0-1962.0724
1472 , p5_a36 NUMBER := 0-1962.0724
1473 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1474 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1475 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1476 , p5_a40 DATE := fnd_api.g_miss_date
1477 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1478 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1479 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1480 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1481 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1482 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1483 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1484 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1485 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1486 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
1487 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
1488 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1489 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1490 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1491 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1492 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
1493 , p5_a57 DATE := fnd_api.g_miss_date
1494 , p5_a58 NUMBER := 0-1962.0724
1495 , p5_a59 NUMBER := 0-1962.0724
1496 , p5_a60 NUMBER := 0-1962.0724
1497 , p5_a61 NUMBER := 0-1962.0724
1498 , p5_a62 NUMBER := 0-1962.0724
1499 , p5_a63 DATE := fnd_api.g_miss_date
1500 , p5_a64 NUMBER := 0-1962.0724
1501 , p5_a65 DATE := fnd_api.g_miss_date
1502 , p5_a66 NUMBER := 0-1962.0724
1503 , p5_a67 DATE := fnd_api.g_miss_date
1504 , p5_a68 NUMBER := 0-1962.0724
1505 , p5_a69 NUMBER := 0-1962.0724
1506 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
1507 , p5_a71 NUMBER := 0-1962.0724
1508 , p5_a72 NUMBER := 0-1962.0724
1509 , p5_a73 NUMBER := 0-1962.0724
1510 , p5_a74 NUMBER := 0-1962.0724
1511 , p5_a75 NUMBER := 0-1962.0724
1512 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
1513 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
1514 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
1515 , p5_a79 NUMBER := 0-1962.0724
1516 , p5_a80 DATE := fnd_api.g_miss_date
1517 , p5_a81 NUMBER := 0-1962.0724
1518 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
1519 )
1520
1521 as
1522 ddp_qtev_rec okl_qte_pvt.qtev_rec_type;
1523 ddx_qtev_rec okl_qte_pvt.qtev_rec_type;
1524 ddindx binary_integer; indx binary_integer;
1525 begin
1526
1527 -- copy data to the local IN or IN-OUT args, if any
1528
1529
1530
1531
1532
1533 ddp_qtev_rec.id := rosetta_g_miss_num_map(p5_a0);
1534 ddp_qtev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1535 ddp_qtev_rec.sfwt_flag := p5_a2;
1536 ddp_qtev_rec.qrs_code := p5_a3;
1537 ddp_qtev_rec.qst_code := p5_a4;
1538 ddp_qtev_rec.qtp_code := p5_a5;
1539 ddp_qtev_rec.trn_code := p5_a6;
1540 ddp_qtev_rec.pop_code_end := p5_a7;
1541 ddp_qtev_rec.pop_code_early := p5_a8;
1542 ddp_qtev_rec.consolidated_qte_id := rosetta_g_miss_num_map(p5_a9);
1543 ddp_qtev_rec.khr_id := rosetta_g_miss_num_map(p5_a10);
1544 ddp_qtev_rec.art_id := rosetta_g_miss_num_map(p5_a11);
1545 ddp_qtev_rec.pdt_id := rosetta_g_miss_num_map(p5_a12);
1546 ddp_qtev_rec.early_termination_yn := p5_a13;
1547 ddp_qtev_rec.partial_yn := p5_a14;
1548 ddp_qtev_rec.preproceeds_yn := p5_a15;
1549 ddp_qtev_rec.date_requested := rosetta_g_miss_date_in_map(p5_a16);
1550 ddp_qtev_rec.date_proposal := rosetta_g_miss_date_in_map(p5_a17);
1551 ddp_qtev_rec.date_effective_to := rosetta_g_miss_date_in_map(p5_a18);
1552 ddp_qtev_rec.date_accepted := rosetta_g_miss_date_in_map(p5_a19);
1553 ddp_qtev_rec.summary_format_yn := p5_a20;
1554 ddp_qtev_rec.consolidated_yn := p5_a21;
1555 ddp_qtev_rec.principal_paydown_amount := rosetta_g_miss_num_map(p5_a22);
1556 ddp_qtev_rec.residual_amount := rosetta_g_miss_num_map(p5_a23);
1557 ddp_qtev_rec.yield := rosetta_g_miss_num_map(p5_a24);
1558 ddp_qtev_rec.rent_amount := rosetta_g_miss_num_map(p5_a25);
1559 ddp_qtev_rec.date_restructure_end := rosetta_g_miss_date_in_map(p5_a26);
1560 ddp_qtev_rec.date_restructure_start := rosetta_g_miss_date_in_map(p5_a27);
1561 ddp_qtev_rec.term := rosetta_g_miss_num_map(p5_a28);
1562 ddp_qtev_rec.purchase_percent := rosetta_g_miss_num_map(p5_a29);
1563 ddp_qtev_rec.comments := p5_a30;
1564 ddp_qtev_rec.date_due := rosetta_g_miss_date_in_map(p5_a31);
1565 ddp_qtev_rec.payment_frequency := p5_a32;
1566 ddp_qtev_rec.remaining_payments := rosetta_g_miss_num_map(p5_a33);
1567 ddp_qtev_rec.date_effective_from := rosetta_g_miss_date_in_map(p5_a34);
1568 ddp_qtev_rec.quote_number := rosetta_g_miss_num_map(p5_a35);
1569 ddp_qtev_rec.requested_by := rosetta_g_miss_num_map(p5_a36);
1570 ddp_qtev_rec.approved_yn := p5_a37;
1571 ddp_qtev_rec.accepted_yn := p5_a38;
1572 ddp_qtev_rec.payment_received_yn := p5_a39;
1573 ddp_qtev_rec.date_payment_received := rosetta_g_miss_date_in_map(p5_a40);
1574 ddp_qtev_rec.attribute_category := p5_a41;
1575 ddp_qtev_rec.attribute1 := p5_a42;
1576 ddp_qtev_rec.attribute2 := p5_a43;
1577 ddp_qtev_rec.attribute3 := p5_a44;
1578 ddp_qtev_rec.attribute4 := p5_a45;
1579 ddp_qtev_rec.attribute5 := p5_a46;
1580 ddp_qtev_rec.attribute6 := p5_a47;
1581 ddp_qtev_rec.attribute7 := p5_a48;
1582 ddp_qtev_rec.attribute8 := p5_a49;
1583 ddp_qtev_rec.attribute9 := p5_a50;
1584 ddp_qtev_rec.attribute10 := p5_a51;
1585 ddp_qtev_rec.attribute11 := p5_a52;
1586 ddp_qtev_rec.attribute12 := p5_a53;
1587 ddp_qtev_rec.attribute13 := p5_a54;
1588 ddp_qtev_rec.attribute14 := p5_a55;
1589 ddp_qtev_rec.attribute15 := p5_a56;
1590 ddp_qtev_rec.date_approved := rosetta_g_miss_date_in_map(p5_a57);
1591 ddp_qtev_rec.approved_by := rosetta_g_miss_num_map(p5_a58);
1592 ddp_qtev_rec.org_id := rosetta_g_miss_num_map(p5_a59);
1593 ddp_qtev_rec.request_id := rosetta_g_miss_num_map(p5_a60);
1594 ddp_qtev_rec.program_application_id := rosetta_g_miss_num_map(p5_a61);
1595 ddp_qtev_rec.program_id := rosetta_g_miss_num_map(p5_a62);
1596 ddp_qtev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a63);
1597 ddp_qtev_rec.created_by := rosetta_g_miss_num_map(p5_a64);
1598 ddp_qtev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a65);
1599 ddp_qtev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a66);
1600 ddp_qtev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a67);
1601 ddp_qtev_rec.last_update_login := rosetta_g_miss_num_map(p5_a68);
1602 ddp_qtev_rec.purchase_amount := rosetta_g_miss_num_map(p5_a69);
1603 ddp_qtev_rec.purchase_formula := p5_a70;
1604 ddp_qtev_rec.asset_value := rosetta_g_miss_num_map(p5_a71);
1605 ddp_qtev_rec.residual_value := rosetta_g_miss_num_map(p5_a72);
1606 ddp_qtev_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a73);
1607 ddp_qtev_rec.gain_loss := rosetta_g_miss_num_map(p5_a74);
1608 ddp_qtev_rec.perdiem_amount := rosetta_g_miss_num_map(p5_a75);
1609 ddp_qtev_rec.currency_code := p5_a76;
1610 ddp_qtev_rec.currency_conversion_code := p5_a77;
1611 ddp_qtev_rec.currency_conversion_type := p5_a78;
1612 ddp_qtev_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a79);
1613 ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
1614 ddp_qtev_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
1615 ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
1616
1617
1618 -- here's the delegated call to the old PL/SQL routine
1619 okl_qte_pvt.insert_row(p_api_version,
1620 p_init_msg_list,
1621 x_return_status,
1622 x_msg_count,
1623 x_msg_data,
1624 ddp_qtev_rec,
1625 ddx_qtev_rec);
1626
1627 -- copy data back from the local variables to OUT or IN-OUT args, if any
1628
1629
1630
1631
1632
1633
1634 p6_a0 := rosetta_g_miss_num_map(ddx_qtev_rec.id);
1635 p6_a1 := rosetta_g_miss_num_map(ddx_qtev_rec.object_version_number);
1636 p6_a2 := ddx_qtev_rec.sfwt_flag;
1637 p6_a3 := ddx_qtev_rec.qrs_code;
1638 p6_a4 := ddx_qtev_rec.qst_code;
1639 p6_a5 := ddx_qtev_rec.qtp_code;
1640 p6_a6 := ddx_qtev_rec.trn_code;
1641 p6_a7 := ddx_qtev_rec.pop_code_end;
1642 p6_a8 := ddx_qtev_rec.pop_code_early;
1643 p6_a9 := rosetta_g_miss_num_map(ddx_qtev_rec.consolidated_qte_id);
1644 p6_a10 := rosetta_g_miss_num_map(ddx_qtev_rec.khr_id);
1645 p6_a11 := rosetta_g_miss_num_map(ddx_qtev_rec.art_id);
1646 p6_a12 := rosetta_g_miss_num_map(ddx_qtev_rec.pdt_id);
1647 p6_a13 := ddx_qtev_rec.early_termination_yn;
1648 p6_a14 := ddx_qtev_rec.partial_yn;
1649 p6_a15 := ddx_qtev_rec.preproceeds_yn;
1650 p6_a16 := ddx_qtev_rec.date_requested;
1651 p6_a17 := ddx_qtev_rec.date_proposal;
1652 p6_a18 := ddx_qtev_rec.date_effective_to;
1653 p6_a19 := ddx_qtev_rec.date_accepted;
1654 p6_a20 := ddx_qtev_rec.summary_format_yn;
1655 p6_a21 := ddx_qtev_rec.consolidated_yn;
1656 p6_a22 := rosetta_g_miss_num_map(ddx_qtev_rec.principal_paydown_amount);
1657 p6_a23 := rosetta_g_miss_num_map(ddx_qtev_rec.residual_amount);
1658 p6_a24 := rosetta_g_miss_num_map(ddx_qtev_rec.yield);
1659 p6_a25 := rosetta_g_miss_num_map(ddx_qtev_rec.rent_amount);
1660 p6_a26 := ddx_qtev_rec.date_restructure_end;
1661 p6_a27 := ddx_qtev_rec.date_restructure_start;
1662 p6_a28 := rosetta_g_miss_num_map(ddx_qtev_rec.term);
1663 p6_a29 := rosetta_g_miss_num_map(ddx_qtev_rec.purchase_percent);
1664 p6_a30 := ddx_qtev_rec.comments;
1665 p6_a31 := ddx_qtev_rec.date_due;
1666 p6_a32 := ddx_qtev_rec.payment_frequency;
1667 p6_a33 := rosetta_g_miss_num_map(ddx_qtev_rec.remaining_payments);
1668 p6_a34 := ddx_qtev_rec.date_effective_from;
1669 p6_a35 := rosetta_g_miss_num_map(ddx_qtev_rec.quote_number);
1670 p6_a36 := rosetta_g_miss_num_map(ddx_qtev_rec.requested_by);
1671 p6_a37 := ddx_qtev_rec.approved_yn;
1672 p6_a38 := ddx_qtev_rec.accepted_yn;
1673 p6_a39 := ddx_qtev_rec.payment_received_yn;
1674 p6_a40 := ddx_qtev_rec.date_payment_received;
1675 p6_a41 := ddx_qtev_rec.attribute_category;
1676 p6_a42 := ddx_qtev_rec.attribute1;
1677 p6_a43 := ddx_qtev_rec.attribute2;
1678 p6_a44 := ddx_qtev_rec.attribute3;
1679 p6_a45 := ddx_qtev_rec.attribute4;
1680 p6_a46 := ddx_qtev_rec.attribute5;
1681 p6_a47 := ddx_qtev_rec.attribute6;
1682 p6_a48 := ddx_qtev_rec.attribute7;
1683 p6_a49 := ddx_qtev_rec.attribute8;
1684 p6_a50 := ddx_qtev_rec.attribute9;
1685 p6_a51 := ddx_qtev_rec.attribute10;
1686 p6_a52 := ddx_qtev_rec.attribute11;
1687 p6_a53 := ddx_qtev_rec.attribute12;
1688 p6_a54 := ddx_qtev_rec.attribute13;
1689 p6_a55 := ddx_qtev_rec.attribute14;
1690 p6_a56 := ddx_qtev_rec.attribute15;
1691 p6_a57 := ddx_qtev_rec.date_approved;
1692 p6_a58 := rosetta_g_miss_num_map(ddx_qtev_rec.approved_by);
1693 p6_a59 := rosetta_g_miss_num_map(ddx_qtev_rec.org_id);
1694 p6_a60 := rosetta_g_miss_num_map(ddx_qtev_rec.request_id);
1695 p6_a61 := rosetta_g_miss_num_map(ddx_qtev_rec.program_application_id);
1696 p6_a62 := rosetta_g_miss_num_map(ddx_qtev_rec.program_id);
1697 p6_a63 := ddx_qtev_rec.program_update_date;
1698 p6_a64 := rosetta_g_miss_num_map(ddx_qtev_rec.created_by);
1699 p6_a65 := ddx_qtev_rec.creation_date;
1700 p6_a66 := rosetta_g_miss_num_map(ddx_qtev_rec.last_updated_by);
1701 p6_a67 := ddx_qtev_rec.last_update_date;
1702 p6_a68 := rosetta_g_miss_num_map(ddx_qtev_rec.last_update_login);
1703 p6_a69 := rosetta_g_miss_num_map(ddx_qtev_rec.purchase_amount);
1704 p6_a70 := ddx_qtev_rec.purchase_formula;
1705 p6_a71 := rosetta_g_miss_num_map(ddx_qtev_rec.asset_value);
1706 p6_a72 := rosetta_g_miss_num_map(ddx_qtev_rec.residual_value);
1707 p6_a73 := rosetta_g_miss_num_map(ddx_qtev_rec.unbilled_receivables);
1708 p6_a74 := rosetta_g_miss_num_map(ddx_qtev_rec.gain_loss);
1709 p6_a75 := rosetta_g_miss_num_map(ddx_qtev_rec.perdiem_amount);
1710 p6_a76 := ddx_qtev_rec.currency_code;
1711 p6_a77 := ddx_qtev_rec.currency_conversion_code;
1712 p6_a78 := ddx_qtev_rec.currency_conversion_type;
1713 p6_a79 := rosetta_g_miss_num_map(ddx_qtev_rec.currency_conversion_rate);
1714 p6_a80 := ddx_qtev_rec.currency_conversion_date;
1715 p6_a81 := rosetta_g_miss_num_map(ddx_qtev_rec.legal_entity_id);
1716 p6_a82 := ddx_qtev_rec.repo_quote_indicator_yn;
1717 end;
1718
1719 procedure insert_row(p_api_version NUMBER
1720 , p_init_msg_list VARCHAR2
1721 , x_return_status out nocopy VARCHAR2
1722 , x_msg_count out nocopy NUMBER
1723 , x_msg_data out nocopy VARCHAR2
1724 , p5_a0 JTF_NUMBER_TABLE
1725 , p5_a1 JTF_NUMBER_TABLE
1726 , p5_a2 JTF_VARCHAR2_TABLE_100
1727 , p5_a3 JTF_VARCHAR2_TABLE_100
1728 , p5_a4 JTF_VARCHAR2_TABLE_100
1729 , p5_a5 JTF_VARCHAR2_TABLE_100
1730 , p5_a6 JTF_VARCHAR2_TABLE_100
1731 , p5_a7 JTF_VARCHAR2_TABLE_100
1732 , p5_a8 JTF_VARCHAR2_TABLE_100
1733 , p5_a9 JTF_NUMBER_TABLE
1734 , p5_a10 JTF_NUMBER_TABLE
1735 , p5_a11 JTF_NUMBER_TABLE
1736 , p5_a12 JTF_NUMBER_TABLE
1737 , p5_a13 JTF_VARCHAR2_TABLE_100
1738 , p5_a14 JTF_VARCHAR2_TABLE_100
1739 , p5_a15 JTF_VARCHAR2_TABLE_100
1740 , p5_a16 JTF_DATE_TABLE
1741 , p5_a17 JTF_DATE_TABLE
1742 , p5_a18 JTF_DATE_TABLE
1743 , p5_a19 JTF_DATE_TABLE
1744 , p5_a20 JTF_VARCHAR2_TABLE_100
1745 , p5_a21 JTF_VARCHAR2_TABLE_100
1746 , p5_a22 JTF_NUMBER_TABLE
1747 , p5_a23 JTF_NUMBER_TABLE
1748 , p5_a24 JTF_NUMBER_TABLE
1749 , p5_a25 JTF_NUMBER_TABLE
1750 , p5_a26 JTF_DATE_TABLE
1751 , p5_a27 JTF_DATE_TABLE
1752 , p5_a28 JTF_NUMBER_TABLE
1753 , p5_a29 JTF_NUMBER_TABLE
1754 , p5_a30 JTF_VARCHAR2_TABLE_2000
1755 , p5_a31 JTF_DATE_TABLE
1756 , p5_a32 JTF_VARCHAR2_TABLE_100
1757 , p5_a33 JTF_NUMBER_TABLE
1758 , p5_a34 JTF_DATE_TABLE
1759 , p5_a35 JTF_NUMBER_TABLE
1760 , p5_a36 JTF_NUMBER_TABLE
1761 , p5_a37 JTF_VARCHAR2_TABLE_100
1762 , p5_a38 JTF_VARCHAR2_TABLE_100
1763 , p5_a39 JTF_VARCHAR2_TABLE_100
1764 , p5_a40 JTF_DATE_TABLE
1765 , p5_a41 JTF_VARCHAR2_TABLE_100
1766 , p5_a42 JTF_VARCHAR2_TABLE_500
1767 , p5_a43 JTF_VARCHAR2_TABLE_500
1768 , p5_a44 JTF_VARCHAR2_TABLE_500
1769 , p5_a45 JTF_VARCHAR2_TABLE_500
1770 , p5_a46 JTF_VARCHAR2_TABLE_500
1771 , p5_a47 JTF_VARCHAR2_TABLE_500
1772 , p5_a48 JTF_VARCHAR2_TABLE_500
1773 , p5_a49 JTF_VARCHAR2_TABLE_500
1774 , p5_a50 JTF_VARCHAR2_TABLE_500
1775 , p5_a51 JTF_VARCHAR2_TABLE_500
1776 , p5_a52 JTF_VARCHAR2_TABLE_500
1777 , p5_a53 JTF_VARCHAR2_TABLE_500
1778 , p5_a54 JTF_VARCHAR2_TABLE_500
1779 , p5_a55 JTF_VARCHAR2_TABLE_500
1780 , p5_a56 JTF_VARCHAR2_TABLE_500
1781 , p5_a57 JTF_DATE_TABLE
1782 , p5_a58 JTF_NUMBER_TABLE
1783 , p5_a59 JTF_NUMBER_TABLE
1784 , p5_a60 JTF_NUMBER_TABLE
1785 , p5_a61 JTF_NUMBER_TABLE
1786 , p5_a62 JTF_NUMBER_TABLE
1787 , p5_a63 JTF_DATE_TABLE
1788 , p5_a64 JTF_NUMBER_TABLE
1789 , p5_a65 JTF_DATE_TABLE
1790 , p5_a66 JTF_NUMBER_TABLE
1791 , p5_a67 JTF_DATE_TABLE
1792 , p5_a68 JTF_NUMBER_TABLE
1793 , p5_a69 JTF_NUMBER_TABLE
1794 , p5_a70 JTF_VARCHAR2_TABLE_200
1795 , p5_a71 JTF_NUMBER_TABLE
1796 , p5_a72 JTF_NUMBER_TABLE
1797 , p5_a73 JTF_NUMBER_TABLE
1798 , p5_a74 JTF_NUMBER_TABLE
1799 , p5_a75 JTF_NUMBER_TABLE
1800 , p5_a76 JTF_VARCHAR2_TABLE_100
1801 , p5_a77 JTF_VARCHAR2_TABLE_100
1802 , p5_a78 JTF_VARCHAR2_TABLE_100
1803 , p5_a79 JTF_NUMBER_TABLE
1804 , p5_a80 JTF_DATE_TABLE
1805 , p5_a81 JTF_NUMBER_TABLE
1806 , p5_a82 JTF_VARCHAR2_TABLE_100
1807 , p6_a0 out nocopy JTF_NUMBER_TABLE
1808 , p6_a1 out nocopy JTF_NUMBER_TABLE
1809 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1810 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1811 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1812 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1813 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1814 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1815 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1816 , p6_a9 out nocopy JTF_NUMBER_TABLE
1817 , p6_a10 out nocopy JTF_NUMBER_TABLE
1818 , p6_a11 out nocopy JTF_NUMBER_TABLE
1819 , p6_a12 out nocopy JTF_NUMBER_TABLE
1820 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1821 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1822 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1823 , p6_a16 out nocopy JTF_DATE_TABLE
1824 , p6_a17 out nocopy JTF_DATE_TABLE
1825 , p6_a18 out nocopy JTF_DATE_TABLE
1826 , p6_a19 out nocopy JTF_DATE_TABLE
1827 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1828 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1829 , p6_a22 out nocopy JTF_NUMBER_TABLE
1830 , p6_a23 out nocopy JTF_NUMBER_TABLE
1831 , p6_a24 out nocopy JTF_NUMBER_TABLE
1832 , p6_a25 out nocopy JTF_NUMBER_TABLE
1833 , p6_a26 out nocopy JTF_DATE_TABLE
1834 , p6_a27 out nocopy JTF_DATE_TABLE
1835 , p6_a28 out nocopy JTF_NUMBER_TABLE
1836 , p6_a29 out nocopy JTF_NUMBER_TABLE
1837 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1838 , p6_a31 out nocopy JTF_DATE_TABLE
1839 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
1840 , p6_a33 out nocopy JTF_NUMBER_TABLE
1841 , p6_a34 out nocopy JTF_DATE_TABLE
1842 , p6_a35 out nocopy JTF_NUMBER_TABLE
1843 , p6_a36 out nocopy JTF_NUMBER_TABLE
1844 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
1845 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1846 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1847 , p6_a40 out nocopy JTF_DATE_TABLE
1848 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1849 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
1850 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
1851 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
1852 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
1853 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
1854 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
1855 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
1856 , p6_a49 out nocopy JTF_VARCHAR2_TABLE_500
1857 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_500
1858 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_500
1859 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_500
1860 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_500
1861 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_500
1862 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_500
1863 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_500
1864 , p6_a57 out nocopy JTF_DATE_TABLE
1865 , p6_a58 out nocopy JTF_NUMBER_TABLE
1866 , p6_a59 out nocopy JTF_NUMBER_TABLE
1867 , p6_a60 out nocopy JTF_NUMBER_TABLE
1868 , p6_a61 out nocopy JTF_NUMBER_TABLE
1869 , p6_a62 out nocopy JTF_NUMBER_TABLE
1870 , p6_a63 out nocopy JTF_DATE_TABLE
1871 , p6_a64 out nocopy JTF_NUMBER_TABLE
1872 , p6_a65 out nocopy JTF_DATE_TABLE
1873 , p6_a66 out nocopy JTF_NUMBER_TABLE
1874 , p6_a67 out nocopy JTF_DATE_TABLE
1875 , p6_a68 out nocopy JTF_NUMBER_TABLE
1876 , p6_a69 out nocopy JTF_NUMBER_TABLE
1877 , p6_a70 out nocopy JTF_VARCHAR2_TABLE_200
1878 , p6_a71 out nocopy JTF_NUMBER_TABLE
1879 , p6_a72 out nocopy JTF_NUMBER_TABLE
1880 , p6_a73 out nocopy JTF_NUMBER_TABLE
1881 , p6_a74 out nocopy JTF_NUMBER_TABLE
1882 , p6_a75 out nocopy JTF_NUMBER_TABLE
1883 , p6_a76 out nocopy JTF_VARCHAR2_TABLE_100
1884 , p6_a77 out nocopy JTF_VARCHAR2_TABLE_100
1885 , p6_a78 out nocopy JTF_VARCHAR2_TABLE_100
1886 , p6_a79 out nocopy JTF_NUMBER_TABLE
1887 , p6_a80 out nocopy JTF_DATE_TABLE
1888 , p6_a81 out nocopy JTF_NUMBER_TABLE
1889 , p6_a82 out nocopy JTF_VARCHAR2_TABLE_100
1890 )
1891
1892 as
1893 ddp_qtev_tbl okl_qte_pvt.qtev_tbl_type;
1894 ddx_qtev_tbl okl_qte_pvt.qtev_tbl_type;
1895 ddindx binary_integer; indx binary_integer;
1896 begin
1897
1898 -- copy data to the local IN or IN-OUT args, if any
1899
1900
1901
1902
1903
1904 okl_qte_pvt_w.rosetta_table_copy_in_p8(ddp_qtev_tbl, p5_a0
1905 , p5_a1
1906 , p5_a2
1907 , p5_a3
1908 , p5_a4
1909 , p5_a5
1910 , p5_a6
1911 , p5_a7
1912 , p5_a8
1913 , p5_a9
1914 , p5_a10
1915 , p5_a11
1916 , p5_a12
1917 , p5_a13
1918 , p5_a14
1919 , p5_a15
1920 , p5_a16
1921 , p5_a17
1922 , p5_a18
1923 , p5_a19
1924 , p5_a20
1925 , p5_a21
1926 , p5_a22
1927 , p5_a23
1928 , p5_a24
1929 , p5_a25
1930 , p5_a26
1931 , p5_a27
1932 , p5_a28
1933 , p5_a29
1934 , p5_a30
1935 , p5_a31
1936 , p5_a32
1937 , p5_a33
1938 , p5_a34
1939 , p5_a35
1940 , p5_a36
1941 , p5_a37
1942 , p5_a38
1943 , p5_a39
1944 , p5_a40
1945 , p5_a41
1946 , p5_a42
1947 , p5_a43
1948 , p5_a44
1949 , p5_a45
1950 , p5_a46
1951 , p5_a47
1952 , p5_a48
1953 , p5_a49
1954 , p5_a50
1955 , p5_a51
1956 , p5_a52
1957 , p5_a53
1958 , p5_a54
1959 , p5_a55
1960 , p5_a56
1961 , p5_a57
1962 , p5_a58
1963 , p5_a59
1964 , p5_a60
1965 , p5_a61
1966 , p5_a62
1967 , p5_a63
1968 , p5_a64
1969 , p5_a65
1970 , p5_a66
1971 , p5_a67
1972 , p5_a68
1973 , p5_a69
1974 , p5_a70
1975 , p5_a71
1976 , p5_a72
1977 , p5_a73
1978 , p5_a74
1979 , p5_a75
1980 , p5_a76
1981 , p5_a77
1982 , p5_a78
1983 , p5_a79
1984 , p5_a80
1985 , p5_a81
1986 , p5_a82
1987 );
1988
1989
1990 -- here's the delegated call to the old PL/SQL routine
1991 okl_qte_pvt.insert_row(p_api_version,
1992 p_init_msg_list,
1993 x_return_status,
1994 x_msg_count,
1995 x_msg_data,
1996 ddp_qtev_tbl,
1997 ddx_qtev_tbl);
1998
1999 -- copy data back from the local variables to OUT or IN-OUT args, if any
2000
2001
2002
2003
2004
2005
2006 okl_qte_pvt_w.rosetta_table_copy_out_p8(ddx_qtev_tbl, p6_a0
2007 , p6_a1
2008 , p6_a2
2009 , p6_a3
2010 , p6_a4
2011 , p6_a5
2012 , p6_a6
2013 , p6_a7
2014 , p6_a8
2015 , p6_a9
2016 , p6_a10
2017 , p6_a11
2018 , p6_a12
2019 , p6_a13
2020 , p6_a14
2021 , p6_a15
2022 , p6_a16
2023 , p6_a17
2024 , p6_a18
2025 , p6_a19
2026 , p6_a20
2027 , p6_a21
2028 , p6_a22
2029 , p6_a23
2030 , p6_a24
2031 , p6_a25
2032 , p6_a26
2033 , p6_a27
2034 , p6_a28
2035 , p6_a29
2036 , p6_a30
2037 , p6_a31
2038 , p6_a32
2039 , p6_a33
2040 , p6_a34
2041 , p6_a35
2042 , p6_a36
2043 , p6_a37
2044 , p6_a38
2045 , p6_a39
2046 , p6_a40
2047 , p6_a41
2048 , p6_a42
2049 , p6_a43
2050 , p6_a44
2051 , p6_a45
2052 , p6_a46
2053 , p6_a47
2054 , p6_a48
2055 , p6_a49
2056 , p6_a50
2057 , p6_a51
2058 , p6_a52
2059 , p6_a53
2060 , p6_a54
2061 , p6_a55
2062 , p6_a56
2063 , p6_a57
2064 , p6_a58
2065 , p6_a59
2066 , p6_a60
2067 , p6_a61
2068 , p6_a62
2069 , p6_a63
2070 , p6_a64
2071 , p6_a65
2072 , p6_a66
2073 , p6_a67
2074 , p6_a68
2075 , p6_a69
2076 , p6_a70
2077 , p6_a71
2078 , p6_a72
2079 , p6_a73
2080 , p6_a74
2081 , p6_a75
2082 , p6_a76
2083 , p6_a77
2084 , p6_a78
2085 , p6_a79
2086 , p6_a80
2087 , p6_a81
2088 , p6_a82
2089 );
2090 end;
2091
2092 procedure lock_row(p_api_version NUMBER
2093 , p_init_msg_list VARCHAR2
2094 , x_return_status out nocopy VARCHAR2
2095 , x_msg_count out nocopy NUMBER
2096 , x_msg_data out nocopy VARCHAR2
2097 , p5_a0 NUMBER := 0-1962.0724
2098 , p5_a1 NUMBER := 0-1962.0724
2099 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2100 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2101 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2102 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2103 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2104 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2105 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2106 , p5_a9 NUMBER := 0-1962.0724
2107 , p5_a10 NUMBER := 0-1962.0724
2108 , p5_a11 NUMBER := 0-1962.0724
2109 , p5_a12 NUMBER := 0-1962.0724
2110 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2111 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2112 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2113 , p5_a16 DATE := fnd_api.g_miss_date
2114 , p5_a17 DATE := fnd_api.g_miss_date
2115 , p5_a18 DATE := fnd_api.g_miss_date
2116 , p5_a19 DATE := fnd_api.g_miss_date
2117 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2118 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2119 , p5_a22 NUMBER := 0-1962.0724
2120 , p5_a23 NUMBER := 0-1962.0724
2121 , p5_a24 NUMBER := 0-1962.0724
2122 , p5_a25 NUMBER := 0-1962.0724
2123 , p5_a26 DATE := fnd_api.g_miss_date
2124 , p5_a27 DATE := fnd_api.g_miss_date
2125 , p5_a28 NUMBER := 0-1962.0724
2126 , p5_a29 NUMBER := 0-1962.0724
2127 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2128 , p5_a31 DATE := fnd_api.g_miss_date
2129 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2130 , p5_a33 NUMBER := 0-1962.0724
2131 , p5_a34 DATE := fnd_api.g_miss_date
2132 , p5_a35 NUMBER := 0-1962.0724
2133 , p5_a36 NUMBER := 0-1962.0724
2134 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2135 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2136 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2137 , p5_a40 DATE := fnd_api.g_miss_date
2138 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2139 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2140 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2141 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2142 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2143 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
2144 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
2145 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2146 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2147 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
2148 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
2149 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2150 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2151 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
2152 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
2153 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
2154 , p5_a57 DATE := fnd_api.g_miss_date
2155 , p5_a58 NUMBER := 0-1962.0724
2156 , p5_a59 NUMBER := 0-1962.0724
2157 , p5_a60 NUMBER := 0-1962.0724
2158 , p5_a61 NUMBER := 0-1962.0724
2159 , p5_a62 NUMBER := 0-1962.0724
2160 , p5_a63 DATE := fnd_api.g_miss_date
2161 , p5_a64 NUMBER := 0-1962.0724
2162 , p5_a65 DATE := fnd_api.g_miss_date
2163 , p5_a66 NUMBER := 0-1962.0724
2164 , p5_a67 DATE := fnd_api.g_miss_date
2165 , p5_a68 NUMBER := 0-1962.0724
2166 , p5_a69 NUMBER := 0-1962.0724
2167 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
2168 , p5_a71 NUMBER := 0-1962.0724
2169 , p5_a72 NUMBER := 0-1962.0724
2170 , p5_a73 NUMBER := 0-1962.0724
2171 , p5_a74 NUMBER := 0-1962.0724
2172 , p5_a75 NUMBER := 0-1962.0724
2173 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
2174 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
2175 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
2176 , p5_a79 NUMBER := 0-1962.0724
2177 , p5_a80 DATE := fnd_api.g_miss_date
2178 , p5_a81 NUMBER := 0-1962.0724
2179 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
2180 )
2181
2182 as
2183 ddp_qtev_rec okl_qte_pvt.qtev_rec_type;
2184 ddindx binary_integer; indx binary_integer;
2185 begin
2186
2187 -- copy data to the local IN or IN-OUT args, if any
2188
2189
2190
2191
2192
2193 ddp_qtev_rec.id := rosetta_g_miss_num_map(p5_a0);
2194 ddp_qtev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2195 ddp_qtev_rec.sfwt_flag := p5_a2;
2196 ddp_qtev_rec.qrs_code := p5_a3;
2197 ddp_qtev_rec.qst_code := p5_a4;
2198 ddp_qtev_rec.qtp_code := p5_a5;
2199 ddp_qtev_rec.trn_code := p5_a6;
2200 ddp_qtev_rec.pop_code_end := p5_a7;
2201 ddp_qtev_rec.pop_code_early := p5_a8;
2202 ddp_qtev_rec.consolidated_qte_id := rosetta_g_miss_num_map(p5_a9);
2203 ddp_qtev_rec.khr_id := rosetta_g_miss_num_map(p5_a10);
2204 ddp_qtev_rec.art_id := rosetta_g_miss_num_map(p5_a11);
2205 ddp_qtev_rec.pdt_id := rosetta_g_miss_num_map(p5_a12);
2206 ddp_qtev_rec.early_termination_yn := p5_a13;
2207 ddp_qtev_rec.partial_yn := p5_a14;
2208 ddp_qtev_rec.preproceeds_yn := p5_a15;
2209 ddp_qtev_rec.date_requested := rosetta_g_miss_date_in_map(p5_a16);
2210 ddp_qtev_rec.date_proposal := rosetta_g_miss_date_in_map(p5_a17);
2211 ddp_qtev_rec.date_effective_to := rosetta_g_miss_date_in_map(p5_a18);
2212 ddp_qtev_rec.date_accepted := rosetta_g_miss_date_in_map(p5_a19);
2213 ddp_qtev_rec.summary_format_yn := p5_a20;
2214 ddp_qtev_rec.consolidated_yn := p5_a21;
2215 ddp_qtev_rec.principal_paydown_amount := rosetta_g_miss_num_map(p5_a22);
2216 ddp_qtev_rec.residual_amount := rosetta_g_miss_num_map(p5_a23);
2217 ddp_qtev_rec.yield := rosetta_g_miss_num_map(p5_a24);
2218 ddp_qtev_rec.rent_amount := rosetta_g_miss_num_map(p5_a25);
2219 ddp_qtev_rec.date_restructure_end := rosetta_g_miss_date_in_map(p5_a26);
2220 ddp_qtev_rec.date_restructure_start := rosetta_g_miss_date_in_map(p5_a27);
2221 ddp_qtev_rec.term := rosetta_g_miss_num_map(p5_a28);
2222 ddp_qtev_rec.purchase_percent := rosetta_g_miss_num_map(p5_a29);
2223 ddp_qtev_rec.comments := p5_a30;
2224 ddp_qtev_rec.date_due := rosetta_g_miss_date_in_map(p5_a31);
2225 ddp_qtev_rec.payment_frequency := p5_a32;
2226 ddp_qtev_rec.remaining_payments := rosetta_g_miss_num_map(p5_a33);
2227 ddp_qtev_rec.date_effective_from := rosetta_g_miss_date_in_map(p5_a34);
2228 ddp_qtev_rec.quote_number := rosetta_g_miss_num_map(p5_a35);
2229 ddp_qtev_rec.requested_by := rosetta_g_miss_num_map(p5_a36);
2230 ddp_qtev_rec.approved_yn := p5_a37;
2231 ddp_qtev_rec.accepted_yn := p5_a38;
2232 ddp_qtev_rec.payment_received_yn := p5_a39;
2233 ddp_qtev_rec.date_payment_received := rosetta_g_miss_date_in_map(p5_a40);
2234 ddp_qtev_rec.attribute_category := p5_a41;
2235 ddp_qtev_rec.attribute1 := p5_a42;
2236 ddp_qtev_rec.attribute2 := p5_a43;
2237 ddp_qtev_rec.attribute3 := p5_a44;
2238 ddp_qtev_rec.attribute4 := p5_a45;
2239 ddp_qtev_rec.attribute5 := p5_a46;
2240 ddp_qtev_rec.attribute6 := p5_a47;
2241 ddp_qtev_rec.attribute7 := p5_a48;
2242 ddp_qtev_rec.attribute8 := p5_a49;
2243 ddp_qtev_rec.attribute9 := p5_a50;
2244 ddp_qtev_rec.attribute10 := p5_a51;
2245 ddp_qtev_rec.attribute11 := p5_a52;
2246 ddp_qtev_rec.attribute12 := p5_a53;
2247 ddp_qtev_rec.attribute13 := p5_a54;
2248 ddp_qtev_rec.attribute14 := p5_a55;
2249 ddp_qtev_rec.attribute15 := p5_a56;
2250 ddp_qtev_rec.date_approved := rosetta_g_miss_date_in_map(p5_a57);
2251 ddp_qtev_rec.approved_by := rosetta_g_miss_num_map(p5_a58);
2252 ddp_qtev_rec.org_id := rosetta_g_miss_num_map(p5_a59);
2253 ddp_qtev_rec.request_id := rosetta_g_miss_num_map(p5_a60);
2254 ddp_qtev_rec.program_application_id := rosetta_g_miss_num_map(p5_a61);
2255 ddp_qtev_rec.program_id := rosetta_g_miss_num_map(p5_a62);
2256 ddp_qtev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a63);
2257 ddp_qtev_rec.created_by := rosetta_g_miss_num_map(p5_a64);
2258 ddp_qtev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a65);
2259 ddp_qtev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a66);
2260 ddp_qtev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a67);
2261 ddp_qtev_rec.last_update_login := rosetta_g_miss_num_map(p5_a68);
2262 ddp_qtev_rec.purchase_amount := rosetta_g_miss_num_map(p5_a69);
2263 ddp_qtev_rec.purchase_formula := p5_a70;
2264 ddp_qtev_rec.asset_value := rosetta_g_miss_num_map(p5_a71);
2265 ddp_qtev_rec.residual_value := rosetta_g_miss_num_map(p5_a72);
2266 ddp_qtev_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a73);
2267 ddp_qtev_rec.gain_loss := rosetta_g_miss_num_map(p5_a74);
2268 ddp_qtev_rec.perdiem_amount := rosetta_g_miss_num_map(p5_a75);
2269 ddp_qtev_rec.currency_code := p5_a76;
2270 ddp_qtev_rec.currency_conversion_code := p5_a77;
2271 ddp_qtev_rec.currency_conversion_type := p5_a78;
2272 ddp_qtev_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a79);
2273 ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
2274 ddp_qtev_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
2275 ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
2276
2277 -- here's the delegated call to the old PL/SQL routine
2278 okl_qte_pvt.lock_row(p_api_version,
2279 p_init_msg_list,
2280 x_return_status,
2281 x_msg_count,
2282 x_msg_data,
2283 ddp_qtev_rec);
2284
2285 -- copy data back from the local variables to OUT or IN-OUT args, if any
2286
2287
2288
2289
2290
2291 end;
2292
2293 procedure lock_row(p_api_version NUMBER
2294 , p_init_msg_list VARCHAR2
2295 , x_return_status out nocopy VARCHAR2
2296 , x_msg_count out nocopy NUMBER
2297 , x_msg_data out nocopy VARCHAR2
2298 , p5_a0 JTF_NUMBER_TABLE
2299 , p5_a1 JTF_NUMBER_TABLE
2300 , p5_a2 JTF_VARCHAR2_TABLE_100
2301 , p5_a3 JTF_VARCHAR2_TABLE_100
2302 , p5_a4 JTF_VARCHAR2_TABLE_100
2303 , p5_a5 JTF_VARCHAR2_TABLE_100
2304 , p5_a6 JTF_VARCHAR2_TABLE_100
2305 , p5_a7 JTF_VARCHAR2_TABLE_100
2306 , p5_a8 JTF_VARCHAR2_TABLE_100
2307 , p5_a9 JTF_NUMBER_TABLE
2308 , p5_a10 JTF_NUMBER_TABLE
2309 , p5_a11 JTF_NUMBER_TABLE
2310 , p5_a12 JTF_NUMBER_TABLE
2311 , p5_a13 JTF_VARCHAR2_TABLE_100
2312 , p5_a14 JTF_VARCHAR2_TABLE_100
2313 , p5_a15 JTF_VARCHAR2_TABLE_100
2314 , p5_a16 JTF_DATE_TABLE
2315 , p5_a17 JTF_DATE_TABLE
2316 , p5_a18 JTF_DATE_TABLE
2317 , p5_a19 JTF_DATE_TABLE
2318 , p5_a20 JTF_VARCHAR2_TABLE_100
2319 , p5_a21 JTF_VARCHAR2_TABLE_100
2320 , p5_a22 JTF_NUMBER_TABLE
2321 , p5_a23 JTF_NUMBER_TABLE
2322 , p5_a24 JTF_NUMBER_TABLE
2323 , p5_a25 JTF_NUMBER_TABLE
2324 , p5_a26 JTF_DATE_TABLE
2325 , p5_a27 JTF_DATE_TABLE
2326 , p5_a28 JTF_NUMBER_TABLE
2327 , p5_a29 JTF_NUMBER_TABLE
2328 , p5_a30 JTF_VARCHAR2_TABLE_2000
2329 , p5_a31 JTF_DATE_TABLE
2330 , p5_a32 JTF_VARCHAR2_TABLE_100
2331 , p5_a33 JTF_NUMBER_TABLE
2332 , p5_a34 JTF_DATE_TABLE
2333 , p5_a35 JTF_NUMBER_TABLE
2334 , p5_a36 JTF_NUMBER_TABLE
2335 , p5_a37 JTF_VARCHAR2_TABLE_100
2336 , p5_a38 JTF_VARCHAR2_TABLE_100
2337 , p5_a39 JTF_VARCHAR2_TABLE_100
2338 , p5_a40 JTF_DATE_TABLE
2339 , p5_a41 JTF_VARCHAR2_TABLE_100
2340 , p5_a42 JTF_VARCHAR2_TABLE_500
2341 , p5_a43 JTF_VARCHAR2_TABLE_500
2342 , p5_a44 JTF_VARCHAR2_TABLE_500
2343 , p5_a45 JTF_VARCHAR2_TABLE_500
2344 , p5_a46 JTF_VARCHAR2_TABLE_500
2345 , p5_a47 JTF_VARCHAR2_TABLE_500
2346 , p5_a48 JTF_VARCHAR2_TABLE_500
2347 , p5_a49 JTF_VARCHAR2_TABLE_500
2348 , p5_a50 JTF_VARCHAR2_TABLE_500
2349 , p5_a51 JTF_VARCHAR2_TABLE_500
2350 , p5_a52 JTF_VARCHAR2_TABLE_500
2351 , p5_a53 JTF_VARCHAR2_TABLE_500
2352 , p5_a54 JTF_VARCHAR2_TABLE_500
2353 , p5_a55 JTF_VARCHAR2_TABLE_500
2354 , p5_a56 JTF_VARCHAR2_TABLE_500
2355 , p5_a57 JTF_DATE_TABLE
2356 , p5_a58 JTF_NUMBER_TABLE
2357 , p5_a59 JTF_NUMBER_TABLE
2358 , p5_a60 JTF_NUMBER_TABLE
2359 , p5_a61 JTF_NUMBER_TABLE
2360 , p5_a62 JTF_NUMBER_TABLE
2361 , p5_a63 JTF_DATE_TABLE
2362 , p5_a64 JTF_NUMBER_TABLE
2363 , p5_a65 JTF_DATE_TABLE
2364 , p5_a66 JTF_NUMBER_TABLE
2365 , p5_a67 JTF_DATE_TABLE
2366 , p5_a68 JTF_NUMBER_TABLE
2367 , p5_a69 JTF_NUMBER_TABLE
2368 , p5_a70 JTF_VARCHAR2_TABLE_200
2369 , p5_a71 JTF_NUMBER_TABLE
2370 , p5_a72 JTF_NUMBER_TABLE
2371 , p5_a73 JTF_NUMBER_TABLE
2372 , p5_a74 JTF_NUMBER_TABLE
2373 , p5_a75 JTF_NUMBER_TABLE
2374 , p5_a76 JTF_VARCHAR2_TABLE_100
2375 , p5_a77 JTF_VARCHAR2_TABLE_100
2376 , p5_a78 JTF_VARCHAR2_TABLE_100
2377 , p5_a79 JTF_NUMBER_TABLE
2378 , p5_a80 JTF_DATE_TABLE
2379 , p5_a81 JTF_NUMBER_TABLE
2380 , p5_a82 JTF_VARCHAR2_TABLE_100
2381 )
2382
2383 as
2384 ddp_qtev_tbl okl_qte_pvt.qtev_tbl_type;
2385 ddindx binary_integer; indx binary_integer;
2386 begin
2387
2388 -- copy data to the local IN or IN-OUT args, if any
2389
2390
2391
2392
2393
2394 okl_qte_pvt_w.rosetta_table_copy_in_p8(ddp_qtev_tbl, p5_a0
2395 , p5_a1
2396 , p5_a2
2397 , p5_a3
2398 , p5_a4
2399 , p5_a5
2400 , p5_a6
2401 , p5_a7
2402 , p5_a8
2403 , p5_a9
2404 , p5_a10
2405 , p5_a11
2406 , p5_a12
2407 , p5_a13
2408 , p5_a14
2409 , p5_a15
2410 , p5_a16
2411 , p5_a17
2412 , p5_a18
2413 , p5_a19
2414 , p5_a20
2415 , p5_a21
2416 , p5_a22
2417 , p5_a23
2418 , p5_a24
2419 , p5_a25
2420 , p5_a26
2421 , p5_a27
2422 , p5_a28
2423 , p5_a29
2424 , p5_a30
2425 , p5_a31
2426 , p5_a32
2427 , p5_a33
2428 , p5_a34
2429 , p5_a35
2430 , p5_a36
2431 , p5_a37
2432 , p5_a38
2433 , p5_a39
2434 , p5_a40
2435 , p5_a41
2436 , p5_a42
2437 , p5_a43
2438 , p5_a44
2439 , p5_a45
2440 , p5_a46
2441 , p5_a47
2442 , p5_a48
2443 , p5_a49
2444 , p5_a50
2445 , p5_a51
2446 , p5_a52
2447 , p5_a53
2448 , p5_a54
2449 , p5_a55
2450 , p5_a56
2451 , p5_a57
2452 , p5_a58
2453 , p5_a59
2454 , p5_a60
2455 , p5_a61
2456 , p5_a62
2457 , p5_a63
2458 , p5_a64
2459 , p5_a65
2460 , p5_a66
2461 , p5_a67
2462 , p5_a68
2463 , p5_a69
2464 , p5_a70
2465 , p5_a71
2466 , p5_a72
2467 , p5_a73
2468 , p5_a74
2469 , p5_a75
2470 , p5_a76
2471 , p5_a77
2472 , p5_a78
2473 , p5_a79
2474 , p5_a80
2475 , p5_a81
2476 , p5_a82
2477 );
2478
2479 -- here's the delegated call to the old PL/SQL routine
2480 okl_qte_pvt.lock_row(p_api_version,
2481 p_init_msg_list,
2482 x_return_status,
2483 x_msg_count,
2484 x_msg_data,
2485 ddp_qtev_tbl);
2486
2487 -- copy data back from the local variables to OUT or IN-OUT args, if any
2488
2489
2490
2491
2492
2493 end;
2494
2495 procedure update_row(p_api_version NUMBER
2496 , p_init_msg_list VARCHAR2
2497 , x_return_status out nocopy VARCHAR2
2498 , x_msg_count out nocopy NUMBER
2499 , x_msg_data out nocopy VARCHAR2
2500 , p6_a0 out nocopy NUMBER
2501 , p6_a1 out nocopy NUMBER
2502 , p6_a2 out nocopy VARCHAR2
2503 , p6_a3 out nocopy VARCHAR2
2504 , p6_a4 out nocopy VARCHAR2
2505 , p6_a5 out nocopy VARCHAR2
2506 , p6_a6 out nocopy VARCHAR2
2507 , p6_a7 out nocopy VARCHAR2
2508 , p6_a8 out nocopy VARCHAR2
2509 , p6_a9 out nocopy NUMBER
2510 , p6_a10 out nocopy NUMBER
2511 , p6_a11 out nocopy NUMBER
2512 , p6_a12 out nocopy NUMBER
2513 , p6_a13 out nocopy VARCHAR2
2514 , p6_a14 out nocopy VARCHAR2
2515 , p6_a15 out nocopy VARCHAR2
2516 , p6_a16 out nocopy DATE
2517 , p6_a17 out nocopy DATE
2518 , p6_a18 out nocopy DATE
2519 , p6_a19 out nocopy DATE
2520 , p6_a20 out nocopy VARCHAR2
2521 , p6_a21 out nocopy VARCHAR2
2522 , p6_a22 out nocopy NUMBER
2523 , p6_a23 out nocopy NUMBER
2524 , p6_a24 out nocopy NUMBER
2525 , p6_a25 out nocopy NUMBER
2526 , p6_a26 out nocopy DATE
2527 , p6_a27 out nocopy DATE
2528 , p6_a28 out nocopy NUMBER
2529 , p6_a29 out nocopy NUMBER
2530 , p6_a30 out nocopy VARCHAR2
2531 , p6_a31 out nocopy DATE
2532 , p6_a32 out nocopy VARCHAR2
2533 , p6_a33 out nocopy NUMBER
2534 , p6_a34 out nocopy DATE
2535 , p6_a35 out nocopy NUMBER
2536 , p6_a36 out nocopy NUMBER
2537 , p6_a37 out nocopy VARCHAR2
2538 , p6_a38 out nocopy VARCHAR2
2539 , p6_a39 out nocopy VARCHAR2
2540 , p6_a40 out nocopy DATE
2541 , p6_a41 out nocopy VARCHAR2
2542 , p6_a42 out nocopy VARCHAR2
2543 , p6_a43 out nocopy VARCHAR2
2544 , p6_a44 out nocopy VARCHAR2
2545 , p6_a45 out nocopy VARCHAR2
2546 , p6_a46 out nocopy VARCHAR2
2547 , p6_a47 out nocopy VARCHAR2
2548 , p6_a48 out nocopy VARCHAR2
2549 , p6_a49 out nocopy VARCHAR2
2550 , p6_a50 out nocopy VARCHAR2
2551 , p6_a51 out nocopy VARCHAR2
2552 , p6_a52 out nocopy VARCHAR2
2553 , p6_a53 out nocopy VARCHAR2
2554 , p6_a54 out nocopy VARCHAR2
2555 , p6_a55 out nocopy VARCHAR2
2556 , p6_a56 out nocopy VARCHAR2
2557 , p6_a57 out nocopy DATE
2558 , p6_a58 out nocopy NUMBER
2559 , p6_a59 out nocopy NUMBER
2560 , p6_a60 out nocopy NUMBER
2561 , p6_a61 out nocopy NUMBER
2562 , p6_a62 out nocopy NUMBER
2563 , p6_a63 out nocopy DATE
2564 , p6_a64 out nocopy NUMBER
2565 , p6_a65 out nocopy DATE
2566 , p6_a66 out nocopy NUMBER
2567 , p6_a67 out nocopy DATE
2568 , p6_a68 out nocopy NUMBER
2569 , p6_a69 out nocopy NUMBER
2570 , p6_a70 out nocopy VARCHAR2
2571 , p6_a71 out nocopy NUMBER
2572 , p6_a72 out nocopy NUMBER
2573 , p6_a73 out nocopy NUMBER
2574 , p6_a74 out nocopy NUMBER
2575 , p6_a75 out nocopy NUMBER
2576 , p6_a76 out nocopy VARCHAR2
2577 , p6_a77 out nocopy VARCHAR2
2578 , p6_a78 out nocopy VARCHAR2
2579 , p6_a79 out nocopy NUMBER
2580 , p6_a80 out nocopy DATE
2581 , p6_a81 out nocopy NUMBER
2582 , p6_a82 out nocopy VARCHAR2
2583 , p5_a0 NUMBER := 0-1962.0724
2584 , p5_a1 NUMBER := 0-1962.0724
2585 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2586 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2587 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2588 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2589 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2590 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2591 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2592 , p5_a9 NUMBER := 0-1962.0724
2593 , p5_a10 NUMBER := 0-1962.0724
2594 , p5_a11 NUMBER := 0-1962.0724
2595 , p5_a12 NUMBER := 0-1962.0724
2596 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2597 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2598 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2599 , p5_a16 DATE := fnd_api.g_miss_date
2600 , p5_a17 DATE := fnd_api.g_miss_date
2601 , p5_a18 DATE := fnd_api.g_miss_date
2602 , p5_a19 DATE := fnd_api.g_miss_date
2603 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2604 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2605 , p5_a22 NUMBER := 0-1962.0724
2606 , p5_a23 NUMBER := 0-1962.0724
2607 , p5_a24 NUMBER := 0-1962.0724
2608 , p5_a25 NUMBER := 0-1962.0724
2609 , p5_a26 DATE := fnd_api.g_miss_date
2610 , p5_a27 DATE := fnd_api.g_miss_date
2611 , p5_a28 NUMBER := 0-1962.0724
2612 , p5_a29 NUMBER := 0-1962.0724
2613 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2614 , p5_a31 DATE := fnd_api.g_miss_date
2615 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2616 , p5_a33 NUMBER := 0-1962.0724
2617 , p5_a34 DATE := fnd_api.g_miss_date
2618 , p5_a35 NUMBER := 0-1962.0724
2619 , p5_a36 NUMBER := 0-1962.0724
2620 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2621 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2622 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2623 , p5_a40 DATE := fnd_api.g_miss_date
2624 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2625 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2626 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2627 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2628 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2629 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
2630 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
2631 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2632 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2633 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
2634 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
2635 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2636 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2637 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
2638 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
2639 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
2640 , p5_a57 DATE := fnd_api.g_miss_date
2641 , p5_a58 NUMBER := 0-1962.0724
2642 , p5_a59 NUMBER := 0-1962.0724
2643 , p5_a60 NUMBER := 0-1962.0724
2644 , p5_a61 NUMBER := 0-1962.0724
2645 , p5_a62 NUMBER := 0-1962.0724
2646 , p5_a63 DATE := fnd_api.g_miss_date
2647 , p5_a64 NUMBER := 0-1962.0724
2648 , p5_a65 DATE := fnd_api.g_miss_date
2649 , p5_a66 NUMBER := 0-1962.0724
2650 , p5_a67 DATE := fnd_api.g_miss_date
2651 , p5_a68 NUMBER := 0-1962.0724
2652 , p5_a69 NUMBER := 0-1962.0724
2653 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
2654 , p5_a71 NUMBER := 0-1962.0724
2655 , p5_a72 NUMBER := 0-1962.0724
2656 , p5_a73 NUMBER := 0-1962.0724
2657 , p5_a74 NUMBER := 0-1962.0724
2658 , p5_a75 NUMBER := 0-1962.0724
2659 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
2660 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
2661 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
2662 , p5_a79 NUMBER := 0-1962.0724
2663 , p5_a80 DATE := fnd_api.g_miss_date
2664 , p5_a81 NUMBER := 0-1962.0724
2665 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
2666 )
2667
2668 as
2669 ddp_qtev_rec okl_qte_pvt.qtev_rec_type;
2670 ddx_qtev_rec okl_qte_pvt.qtev_rec_type;
2671 ddindx binary_integer; indx binary_integer;
2672 begin
2673
2674 -- copy data to the local IN or IN-OUT args, if any
2675
2676
2677
2678
2679
2680 ddp_qtev_rec.id := rosetta_g_miss_num_map(p5_a0);
2681 ddp_qtev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2682 ddp_qtev_rec.sfwt_flag := p5_a2;
2683 ddp_qtev_rec.qrs_code := p5_a3;
2684 ddp_qtev_rec.qst_code := p5_a4;
2685 ddp_qtev_rec.qtp_code := p5_a5;
2686 ddp_qtev_rec.trn_code := p5_a6;
2687 ddp_qtev_rec.pop_code_end := p5_a7;
2688 ddp_qtev_rec.pop_code_early := p5_a8;
2689 ddp_qtev_rec.consolidated_qte_id := rosetta_g_miss_num_map(p5_a9);
2690 ddp_qtev_rec.khr_id := rosetta_g_miss_num_map(p5_a10);
2691 ddp_qtev_rec.art_id := rosetta_g_miss_num_map(p5_a11);
2692 ddp_qtev_rec.pdt_id := rosetta_g_miss_num_map(p5_a12);
2693 ddp_qtev_rec.early_termination_yn := p5_a13;
2694 ddp_qtev_rec.partial_yn := p5_a14;
2695 ddp_qtev_rec.preproceeds_yn := p5_a15;
2696 ddp_qtev_rec.date_requested := rosetta_g_miss_date_in_map(p5_a16);
2697 ddp_qtev_rec.date_proposal := rosetta_g_miss_date_in_map(p5_a17);
2698 ddp_qtev_rec.date_effective_to := rosetta_g_miss_date_in_map(p5_a18);
2699 ddp_qtev_rec.date_accepted := rosetta_g_miss_date_in_map(p5_a19);
2700 ddp_qtev_rec.summary_format_yn := p5_a20;
2701 ddp_qtev_rec.consolidated_yn := p5_a21;
2702 ddp_qtev_rec.principal_paydown_amount := rosetta_g_miss_num_map(p5_a22);
2703 ddp_qtev_rec.residual_amount := rosetta_g_miss_num_map(p5_a23);
2704 ddp_qtev_rec.yield := rosetta_g_miss_num_map(p5_a24);
2705 ddp_qtev_rec.rent_amount := rosetta_g_miss_num_map(p5_a25);
2706 ddp_qtev_rec.date_restructure_end := rosetta_g_miss_date_in_map(p5_a26);
2707 ddp_qtev_rec.date_restructure_start := rosetta_g_miss_date_in_map(p5_a27);
2708 ddp_qtev_rec.term := rosetta_g_miss_num_map(p5_a28);
2709 ddp_qtev_rec.purchase_percent := rosetta_g_miss_num_map(p5_a29);
2710 ddp_qtev_rec.comments := p5_a30;
2711 ddp_qtev_rec.date_due := rosetta_g_miss_date_in_map(p5_a31);
2712 ddp_qtev_rec.payment_frequency := p5_a32;
2713 ddp_qtev_rec.remaining_payments := rosetta_g_miss_num_map(p5_a33);
2714 ddp_qtev_rec.date_effective_from := rosetta_g_miss_date_in_map(p5_a34);
2715 ddp_qtev_rec.quote_number := rosetta_g_miss_num_map(p5_a35);
2716 ddp_qtev_rec.requested_by := rosetta_g_miss_num_map(p5_a36);
2717 ddp_qtev_rec.approved_yn := p5_a37;
2718 ddp_qtev_rec.accepted_yn := p5_a38;
2719 ddp_qtev_rec.payment_received_yn := p5_a39;
2720 ddp_qtev_rec.date_payment_received := rosetta_g_miss_date_in_map(p5_a40);
2721 ddp_qtev_rec.attribute_category := p5_a41;
2722 ddp_qtev_rec.attribute1 := p5_a42;
2723 ddp_qtev_rec.attribute2 := p5_a43;
2724 ddp_qtev_rec.attribute3 := p5_a44;
2725 ddp_qtev_rec.attribute4 := p5_a45;
2726 ddp_qtev_rec.attribute5 := p5_a46;
2727 ddp_qtev_rec.attribute6 := p5_a47;
2728 ddp_qtev_rec.attribute7 := p5_a48;
2729 ddp_qtev_rec.attribute8 := p5_a49;
2730 ddp_qtev_rec.attribute9 := p5_a50;
2731 ddp_qtev_rec.attribute10 := p5_a51;
2732 ddp_qtev_rec.attribute11 := p5_a52;
2733 ddp_qtev_rec.attribute12 := p5_a53;
2734 ddp_qtev_rec.attribute13 := p5_a54;
2735 ddp_qtev_rec.attribute14 := p5_a55;
2736 ddp_qtev_rec.attribute15 := p5_a56;
2737 ddp_qtev_rec.date_approved := rosetta_g_miss_date_in_map(p5_a57);
2738 ddp_qtev_rec.approved_by := rosetta_g_miss_num_map(p5_a58);
2739 ddp_qtev_rec.org_id := rosetta_g_miss_num_map(p5_a59);
2740 ddp_qtev_rec.request_id := rosetta_g_miss_num_map(p5_a60);
2741 ddp_qtev_rec.program_application_id := rosetta_g_miss_num_map(p5_a61);
2742 ddp_qtev_rec.program_id := rosetta_g_miss_num_map(p5_a62);
2743 ddp_qtev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a63);
2744 ddp_qtev_rec.created_by := rosetta_g_miss_num_map(p5_a64);
2745 ddp_qtev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a65);
2746 ddp_qtev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a66);
2747 ddp_qtev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a67);
2748 ddp_qtev_rec.last_update_login := rosetta_g_miss_num_map(p5_a68);
2749 ddp_qtev_rec.purchase_amount := rosetta_g_miss_num_map(p5_a69);
2750 ddp_qtev_rec.purchase_formula := p5_a70;
2751 ddp_qtev_rec.asset_value := rosetta_g_miss_num_map(p5_a71);
2752 ddp_qtev_rec.residual_value := rosetta_g_miss_num_map(p5_a72);
2753 ddp_qtev_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a73);
2754 ddp_qtev_rec.gain_loss := rosetta_g_miss_num_map(p5_a74);
2755 ddp_qtev_rec.perdiem_amount := rosetta_g_miss_num_map(p5_a75);
2756 ddp_qtev_rec.currency_code := p5_a76;
2757 ddp_qtev_rec.currency_conversion_code := p5_a77;
2758 ddp_qtev_rec.currency_conversion_type := p5_a78;
2759 ddp_qtev_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a79);
2760 ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
2761 ddp_qtev_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
2762 ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
2763
2764
2765 -- here's the delegated call to the old PL/SQL routine
2766 okl_qte_pvt.update_row(p_api_version,
2767 p_init_msg_list,
2768 x_return_status,
2769 x_msg_count,
2770 x_msg_data,
2771 ddp_qtev_rec,
2772 ddx_qtev_rec);
2773
2774 -- copy data back from the local variables to OUT or IN-OUT args, if any
2775
2776
2777
2778
2779
2780
2781 p6_a0 := rosetta_g_miss_num_map(ddx_qtev_rec.id);
2782 p6_a1 := rosetta_g_miss_num_map(ddx_qtev_rec.object_version_number);
2783 p6_a2 := ddx_qtev_rec.sfwt_flag;
2784 p6_a3 := ddx_qtev_rec.qrs_code;
2785 p6_a4 := ddx_qtev_rec.qst_code;
2786 p6_a5 := ddx_qtev_rec.qtp_code;
2787 p6_a6 := ddx_qtev_rec.trn_code;
2788 p6_a7 := ddx_qtev_rec.pop_code_end;
2789 p6_a8 := ddx_qtev_rec.pop_code_early;
2790 p6_a9 := rosetta_g_miss_num_map(ddx_qtev_rec.consolidated_qte_id);
2791 p6_a10 := rosetta_g_miss_num_map(ddx_qtev_rec.khr_id);
2792 p6_a11 := rosetta_g_miss_num_map(ddx_qtev_rec.art_id);
2793 p6_a12 := rosetta_g_miss_num_map(ddx_qtev_rec.pdt_id);
2794 p6_a13 := ddx_qtev_rec.early_termination_yn;
2795 p6_a14 := ddx_qtev_rec.partial_yn;
2796 p6_a15 := ddx_qtev_rec.preproceeds_yn;
2797 p6_a16 := ddx_qtev_rec.date_requested;
2798 p6_a17 := ddx_qtev_rec.date_proposal;
2799 p6_a18 := ddx_qtev_rec.date_effective_to;
2800 p6_a19 := ddx_qtev_rec.date_accepted;
2801 p6_a20 := ddx_qtev_rec.summary_format_yn;
2802 p6_a21 := ddx_qtev_rec.consolidated_yn;
2803 p6_a22 := rosetta_g_miss_num_map(ddx_qtev_rec.principal_paydown_amount);
2804 p6_a23 := rosetta_g_miss_num_map(ddx_qtev_rec.residual_amount);
2805 p6_a24 := rosetta_g_miss_num_map(ddx_qtev_rec.yield);
2806 p6_a25 := rosetta_g_miss_num_map(ddx_qtev_rec.rent_amount);
2807 p6_a26 := ddx_qtev_rec.date_restructure_end;
2808 p6_a27 := ddx_qtev_rec.date_restructure_start;
2809 p6_a28 := rosetta_g_miss_num_map(ddx_qtev_rec.term);
2810 p6_a29 := rosetta_g_miss_num_map(ddx_qtev_rec.purchase_percent);
2811 p6_a30 := ddx_qtev_rec.comments;
2812 p6_a31 := ddx_qtev_rec.date_due;
2813 p6_a32 := ddx_qtev_rec.payment_frequency;
2814 p6_a33 := rosetta_g_miss_num_map(ddx_qtev_rec.remaining_payments);
2815 p6_a34 := ddx_qtev_rec.date_effective_from;
2816 p6_a35 := rosetta_g_miss_num_map(ddx_qtev_rec.quote_number);
2817 p6_a36 := rosetta_g_miss_num_map(ddx_qtev_rec.requested_by);
2818 p6_a37 := ddx_qtev_rec.approved_yn;
2819 p6_a38 := ddx_qtev_rec.accepted_yn;
2820 p6_a39 := ddx_qtev_rec.payment_received_yn;
2821 p6_a40 := ddx_qtev_rec.date_payment_received;
2822 p6_a41 := ddx_qtev_rec.attribute_category;
2823 p6_a42 := ddx_qtev_rec.attribute1;
2824 p6_a43 := ddx_qtev_rec.attribute2;
2825 p6_a44 := ddx_qtev_rec.attribute3;
2826 p6_a45 := ddx_qtev_rec.attribute4;
2827 p6_a46 := ddx_qtev_rec.attribute5;
2828 p6_a47 := ddx_qtev_rec.attribute6;
2829 p6_a48 := ddx_qtev_rec.attribute7;
2830 p6_a49 := ddx_qtev_rec.attribute8;
2831 p6_a50 := ddx_qtev_rec.attribute9;
2832 p6_a51 := ddx_qtev_rec.attribute10;
2833 p6_a52 := ddx_qtev_rec.attribute11;
2834 p6_a53 := ddx_qtev_rec.attribute12;
2835 p6_a54 := ddx_qtev_rec.attribute13;
2836 p6_a55 := ddx_qtev_rec.attribute14;
2837 p6_a56 := ddx_qtev_rec.attribute15;
2838 p6_a57 := ddx_qtev_rec.date_approved;
2839 p6_a58 := rosetta_g_miss_num_map(ddx_qtev_rec.approved_by);
2840 p6_a59 := rosetta_g_miss_num_map(ddx_qtev_rec.org_id);
2841 p6_a60 := rosetta_g_miss_num_map(ddx_qtev_rec.request_id);
2842 p6_a61 := rosetta_g_miss_num_map(ddx_qtev_rec.program_application_id);
2843 p6_a62 := rosetta_g_miss_num_map(ddx_qtev_rec.program_id);
2844 p6_a63 := ddx_qtev_rec.program_update_date;
2845 p6_a64 := rosetta_g_miss_num_map(ddx_qtev_rec.created_by);
2846 p6_a65 := ddx_qtev_rec.creation_date;
2847 p6_a66 := rosetta_g_miss_num_map(ddx_qtev_rec.last_updated_by);
2848 p6_a67 := ddx_qtev_rec.last_update_date;
2849 p6_a68 := rosetta_g_miss_num_map(ddx_qtev_rec.last_update_login);
2850 p6_a69 := rosetta_g_miss_num_map(ddx_qtev_rec.purchase_amount);
2851 p6_a70 := ddx_qtev_rec.purchase_formula;
2852 p6_a71 := rosetta_g_miss_num_map(ddx_qtev_rec.asset_value);
2853 p6_a72 := rosetta_g_miss_num_map(ddx_qtev_rec.residual_value);
2854 p6_a73 := rosetta_g_miss_num_map(ddx_qtev_rec.unbilled_receivables);
2855 p6_a74 := rosetta_g_miss_num_map(ddx_qtev_rec.gain_loss);
2856 p6_a75 := rosetta_g_miss_num_map(ddx_qtev_rec.perdiem_amount);
2857 p6_a76 := ddx_qtev_rec.currency_code;
2858 p6_a77 := ddx_qtev_rec.currency_conversion_code;
2859 p6_a78 := ddx_qtev_rec.currency_conversion_type;
2860 p6_a79 := rosetta_g_miss_num_map(ddx_qtev_rec.currency_conversion_rate);
2861 p6_a80 := ddx_qtev_rec.currency_conversion_date;
2862 p6_a81 := rosetta_g_miss_num_map(ddx_qtev_rec.legal_entity_id);
2863 p6_a82 := ddx_qtev_rec.repo_quote_indicator_yn;
2864 end;
2865
2866 procedure update_row(p_api_version NUMBER
2867 , p_init_msg_list VARCHAR2
2868 , x_return_status out nocopy VARCHAR2
2869 , x_msg_count out nocopy NUMBER
2870 , x_msg_data out nocopy VARCHAR2
2871 , p5_a0 JTF_NUMBER_TABLE
2872 , p5_a1 JTF_NUMBER_TABLE
2873 , p5_a2 JTF_VARCHAR2_TABLE_100
2874 , p5_a3 JTF_VARCHAR2_TABLE_100
2875 , p5_a4 JTF_VARCHAR2_TABLE_100
2876 , p5_a5 JTF_VARCHAR2_TABLE_100
2877 , p5_a6 JTF_VARCHAR2_TABLE_100
2878 , p5_a7 JTF_VARCHAR2_TABLE_100
2879 , p5_a8 JTF_VARCHAR2_TABLE_100
2880 , p5_a9 JTF_NUMBER_TABLE
2881 , p5_a10 JTF_NUMBER_TABLE
2882 , p5_a11 JTF_NUMBER_TABLE
2883 , p5_a12 JTF_NUMBER_TABLE
2884 , p5_a13 JTF_VARCHAR2_TABLE_100
2885 , p5_a14 JTF_VARCHAR2_TABLE_100
2886 , p5_a15 JTF_VARCHAR2_TABLE_100
2887 , p5_a16 JTF_DATE_TABLE
2888 , p5_a17 JTF_DATE_TABLE
2889 , p5_a18 JTF_DATE_TABLE
2890 , p5_a19 JTF_DATE_TABLE
2891 , p5_a20 JTF_VARCHAR2_TABLE_100
2892 , p5_a21 JTF_VARCHAR2_TABLE_100
2893 , p5_a22 JTF_NUMBER_TABLE
2894 , p5_a23 JTF_NUMBER_TABLE
2895 , p5_a24 JTF_NUMBER_TABLE
2896 , p5_a25 JTF_NUMBER_TABLE
2897 , p5_a26 JTF_DATE_TABLE
2898 , p5_a27 JTF_DATE_TABLE
2899 , p5_a28 JTF_NUMBER_TABLE
2900 , p5_a29 JTF_NUMBER_TABLE
2901 , p5_a30 JTF_VARCHAR2_TABLE_2000
2902 , p5_a31 JTF_DATE_TABLE
2903 , p5_a32 JTF_VARCHAR2_TABLE_100
2904 , p5_a33 JTF_NUMBER_TABLE
2905 , p5_a34 JTF_DATE_TABLE
2906 , p5_a35 JTF_NUMBER_TABLE
2907 , p5_a36 JTF_NUMBER_TABLE
2908 , p5_a37 JTF_VARCHAR2_TABLE_100
2909 , p5_a38 JTF_VARCHAR2_TABLE_100
2910 , p5_a39 JTF_VARCHAR2_TABLE_100
2911 , p5_a40 JTF_DATE_TABLE
2912 , p5_a41 JTF_VARCHAR2_TABLE_100
2913 , p5_a42 JTF_VARCHAR2_TABLE_500
2914 , p5_a43 JTF_VARCHAR2_TABLE_500
2915 , p5_a44 JTF_VARCHAR2_TABLE_500
2916 , p5_a45 JTF_VARCHAR2_TABLE_500
2917 , p5_a46 JTF_VARCHAR2_TABLE_500
2918 , p5_a47 JTF_VARCHAR2_TABLE_500
2919 , p5_a48 JTF_VARCHAR2_TABLE_500
2920 , p5_a49 JTF_VARCHAR2_TABLE_500
2921 , p5_a50 JTF_VARCHAR2_TABLE_500
2922 , p5_a51 JTF_VARCHAR2_TABLE_500
2923 , p5_a52 JTF_VARCHAR2_TABLE_500
2924 , p5_a53 JTF_VARCHAR2_TABLE_500
2925 , p5_a54 JTF_VARCHAR2_TABLE_500
2926 , p5_a55 JTF_VARCHAR2_TABLE_500
2927 , p5_a56 JTF_VARCHAR2_TABLE_500
2928 , p5_a57 JTF_DATE_TABLE
2929 , p5_a58 JTF_NUMBER_TABLE
2930 , p5_a59 JTF_NUMBER_TABLE
2931 , p5_a60 JTF_NUMBER_TABLE
2932 , p5_a61 JTF_NUMBER_TABLE
2933 , p5_a62 JTF_NUMBER_TABLE
2934 , p5_a63 JTF_DATE_TABLE
2935 , p5_a64 JTF_NUMBER_TABLE
2936 , p5_a65 JTF_DATE_TABLE
2937 , p5_a66 JTF_NUMBER_TABLE
2938 , p5_a67 JTF_DATE_TABLE
2939 , p5_a68 JTF_NUMBER_TABLE
2940 , p5_a69 JTF_NUMBER_TABLE
2941 , p5_a70 JTF_VARCHAR2_TABLE_200
2942 , p5_a71 JTF_NUMBER_TABLE
2943 , p5_a72 JTF_NUMBER_TABLE
2944 , p5_a73 JTF_NUMBER_TABLE
2945 , p5_a74 JTF_NUMBER_TABLE
2946 , p5_a75 JTF_NUMBER_TABLE
2947 , p5_a76 JTF_VARCHAR2_TABLE_100
2948 , p5_a77 JTF_VARCHAR2_TABLE_100
2949 , p5_a78 JTF_VARCHAR2_TABLE_100
2950 , p5_a79 JTF_NUMBER_TABLE
2951 , p5_a80 JTF_DATE_TABLE
2952 , p5_a81 JTF_NUMBER_TABLE
2953 , p5_a82 JTF_VARCHAR2_TABLE_100
2954 , p6_a0 out nocopy JTF_NUMBER_TABLE
2955 , p6_a1 out nocopy JTF_NUMBER_TABLE
2956 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
2957 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2958 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2959 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2960 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2961 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2962 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2963 , p6_a9 out nocopy JTF_NUMBER_TABLE
2964 , p6_a10 out nocopy JTF_NUMBER_TABLE
2965 , p6_a11 out nocopy JTF_NUMBER_TABLE
2966 , p6_a12 out nocopy JTF_NUMBER_TABLE
2967 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2968 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2969 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
2970 , p6_a16 out nocopy JTF_DATE_TABLE
2971 , p6_a17 out nocopy JTF_DATE_TABLE
2972 , p6_a18 out nocopy JTF_DATE_TABLE
2973 , p6_a19 out nocopy JTF_DATE_TABLE
2974 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2975 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
2976 , p6_a22 out nocopy JTF_NUMBER_TABLE
2977 , p6_a23 out nocopy JTF_NUMBER_TABLE
2978 , p6_a24 out nocopy JTF_NUMBER_TABLE
2979 , p6_a25 out nocopy JTF_NUMBER_TABLE
2980 , p6_a26 out nocopy JTF_DATE_TABLE
2981 , p6_a27 out nocopy JTF_DATE_TABLE
2982 , p6_a28 out nocopy JTF_NUMBER_TABLE
2983 , p6_a29 out nocopy JTF_NUMBER_TABLE
2984 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2985 , p6_a31 out nocopy JTF_DATE_TABLE
2986 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
2987 , p6_a33 out nocopy JTF_NUMBER_TABLE
2988 , p6_a34 out nocopy JTF_DATE_TABLE
2989 , p6_a35 out nocopy JTF_NUMBER_TABLE
2990 , p6_a36 out nocopy JTF_NUMBER_TABLE
2991 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
2992 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
2993 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
2994 , p6_a40 out nocopy JTF_DATE_TABLE
2995 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
2996 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
2997 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
2998 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
2999 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
3000 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
3001 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
3002 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
3003 , p6_a49 out nocopy JTF_VARCHAR2_TABLE_500
3004 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_500
3005 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_500
3006 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_500
3007 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_500
3008 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_500
3009 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_500
3010 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_500
3011 , p6_a57 out nocopy JTF_DATE_TABLE
3012 , p6_a58 out nocopy JTF_NUMBER_TABLE
3013 , p6_a59 out nocopy JTF_NUMBER_TABLE
3014 , p6_a60 out nocopy JTF_NUMBER_TABLE
3015 , p6_a61 out nocopy JTF_NUMBER_TABLE
3016 , p6_a62 out nocopy JTF_NUMBER_TABLE
3017 , p6_a63 out nocopy JTF_DATE_TABLE
3018 , p6_a64 out nocopy JTF_NUMBER_TABLE
3019 , p6_a65 out nocopy JTF_DATE_TABLE
3020 , p6_a66 out nocopy JTF_NUMBER_TABLE
3021 , p6_a67 out nocopy JTF_DATE_TABLE
3022 , p6_a68 out nocopy JTF_NUMBER_TABLE
3023 , p6_a69 out nocopy JTF_NUMBER_TABLE
3024 , p6_a70 out nocopy JTF_VARCHAR2_TABLE_200
3025 , p6_a71 out nocopy JTF_NUMBER_TABLE
3026 , p6_a72 out nocopy JTF_NUMBER_TABLE
3027 , p6_a73 out nocopy JTF_NUMBER_TABLE
3028 , p6_a74 out nocopy JTF_NUMBER_TABLE
3029 , p6_a75 out nocopy JTF_NUMBER_TABLE
3030 , p6_a76 out nocopy JTF_VARCHAR2_TABLE_100
3031 , p6_a77 out nocopy JTF_VARCHAR2_TABLE_100
3032 , p6_a78 out nocopy JTF_VARCHAR2_TABLE_100
3033 , p6_a79 out nocopy JTF_NUMBER_TABLE
3034 , p6_a80 out nocopy JTF_DATE_TABLE
3035 , p6_a81 out nocopy JTF_NUMBER_TABLE
3036 , p6_a82 out nocopy JTF_VARCHAR2_TABLE_100
3037 )
3038
3039 as
3040 ddp_qtev_tbl okl_qte_pvt.qtev_tbl_type;
3041 ddx_qtev_tbl okl_qte_pvt.qtev_tbl_type;
3042 ddindx binary_integer; indx binary_integer;
3043 begin
3044
3045 -- copy data to the local IN or IN-OUT args, if any
3046
3047
3048
3049
3050
3051 okl_qte_pvt_w.rosetta_table_copy_in_p8(ddp_qtev_tbl, p5_a0
3052 , p5_a1
3053 , p5_a2
3054 , p5_a3
3055 , p5_a4
3056 , p5_a5
3057 , p5_a6
3058 , p5_a7
3059 , p5_a8
3060 , p5_a9
3061 , p5_a10
3062 , p5_a11
3063 , p5_a12
3064 , p5_a13
3065 , p5_a14
3066 , p5_a15
3067 , p5_a16
3068 , p5_a17
3069 , p5_a18
3070 , p5_a19
3071 , p5_a20
3072 , p5_a21
3073 , p5_a22
3074 , p5_a23
3075 , p5_a24
3076 , p5_a25
3077 , p5_a26
3078 , p5_a27
3079 , p5_a28
3080 , p5_a29
3081 , p5_a30
3082 , p5_a31
3083 , p5_a32
3084 , p5_a33
3085 , p5_a34
3086 , p5_a35
3087 , p5_a36
3088 , p5_a37
3089 , p5_a38
3090 , p5_a39
3091 , p5_a40
3092 , p5_a41
3093 , p5_a42
3094 , p5_a43
3095 , p5_a44
3096 , p5_a45
3097 , p5_a46
3098 , p5_a47
3099 , p5_a48
3100 , p5_a49
3101 , p5_a50
3102 , p5_a51
3103 , p5_a52
3104 , p5_a53
3105 , p5_a54
3106 , p5_a55
3107 , p5_a56
3108 , p5_a57
3109 , p5_a58
3110 , p5_a59
3111 , p5_a60
3112 , p5_a61
3113 , p5_a62
3114 , p5_a63
3115 , p5_a64
3116 , p5_a65
3117 , p5_a66
3118 , p5_a67
3119 , p5_a68
3120 , p5_a69
3121 , p5_a70
3122 , p5_a71
3123 , p5_a72
3124 , p5_a73
3125 , p5_a74
3126 , p5_a75
3127 , p5_a76
3128 , p5_a77
3129 , p5_a78
3130 , p5_a79
3131 , p5_a80
3132 , p5_a81
3133 , p5_a82
3134 );
3135
3136
3137 -- here's the delegated call to the old PL/SQL routine
3138 okl_qte_pvt.update_row(p_api_version,
3139 p_init_msg_list,
3140 x_return_status,
3141 x_msg_count,
3142 x_msg_data,
3143 ddp_qtev_tbl,
3144 ddx_qtev_tbl);
3145
3146 -- copy data back from the local variables to OUT or IN-OUT args, if any
3147
3148
3149
3150
3151
3152
3153 okl_qte_pvt_w.rosetta_table_copy_out_p8(ddx_qtev_tbl, p6_a0
3154 , p6_a1
3155 , p6_a2
3156 , p6_a3
3157 , p6_a4
3158 , p6_a5
3159 , p6_a6
3160 , p6_a7
3161 , p6_a8
3162 , p6_a9
3163 , p6_a10
3164 , p6_a11
3165 , p6_a12
3166 , p6_a13
3167 , p6_a14
3168 , p6_a15
3169 , p6_a16
3170 , p6_a17
3171 , p6_a18
3172 , p6_a19
3173 , p6_a20
3174 , p6_a21
3175 , p6_a22
3176 , p6_a23
3177 , p6_a24
3178 , p6_a25
3179 , p6_a26
3180 , p6_a27
3181 , p6_a28
3182 , p6_a29
3183 , p6_a30
3184 , p6_a31
3185 , p6_a32
3186 , p6_a33
3187 , p6_a34
3188 , p6_a35
3189 , p6_a36
3190 , p6_a37
3191 , p6_a38
3192 , p6_a39
3193 , p6_a40
3194 , p6_a41
3195 , p6_a42
3196 , p6_a43
3197 , p6_a44
3198 , p6_a45
3199 , p6_a46
3200 , p6_a47
3201 , p6_a48
3202 , p6_a49
3203 , p6_a50
3204 , p6_a51
3205 , p6_a52
3206 , p6_a53
3207 , p6_a54
3208 , p6_a55
3209 , p6_a56
3210 , p6_a57
3211 , p6_a58
3212 , p6_a59
3213 , p6_a60
3214 , p6_a61
3215 , p6_a62
3216 , p6_a63
3217 , p6_a64
3218 , p6_a65
3219 , p6_a66
3220 , p6_a67
3221 , p6_a68
3222 , p6_a69
3223 , p6_a70
3224 , p6_a71
3225 , p6_a72
3226 , p6_a73
3227 , p6_a74
3228 , p6_a75
3229 , p6_a76
3230 , p6_a77
3231 , p6_a78
3232 , p6_a79
3233 , p6_a80
3234 , p6_a81
3235 , p6_a82
3236 );
3237 end;
3238
3239 procedure delete_row(p_api_version NUMBER
3240 , p_init_msg_list VARCHAR2
3241 , x_return_status out nocopy VARCHAR2
3242 , x_msg_count out nocopy NUMBER
3243 , x_msg_data out nocopy VARCHAR2
3244 , p5_a0 NUMBER := 0-1962.0724
3245 , p5_a1 NUMBER := 0-1962.0724
3246 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
3247 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
3248 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
3249 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3250 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
3251 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
3252 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
3253 , p5_a9 NUMBER := 0-1962.0724
3254 , p5_a10 NUMBER := 0-1962.0724
3255 , p5_a11 NUMBER := 0-1962.0724
3256 , p5_a12 NUMBER := 0-1962.0724
3257 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
3258 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
3259 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
3260 , p5_a16 DATE := fnd_api.g_miss_date
3261 , p5_a17 DATE := fnd_api.g_miss_date
3262 , p5_a18 DATE := fnd_api.g_miss_date
3263 , p5_a19 DATE := fnd_api.g_miss_date
3264 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
3265 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3266 , p5_a22 NUMBER := 0-1962.0724
3267 , p5_a23 NUMBER := 0-1962.0724
3268 , p5_a24 NUMBER := 0-1962.0724
3269 , p5_a25 NUMBER := 0-1962.0724
3270 , p5_a26 DATE := fnd_api.g_miss_date
3271 , p5_a27 DATE := fnd_api.g_miss_date
3272 , p5_a28 NUMBER := 0-1962.0724
3273 , p5_a29 NUMBER := 0-1962.0724
3274 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
3275 , p5_a31 DATE := fnd_api.g_miss_date
3276 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
3277 , p5_a33 NUMBER := 0-1962.0724
3278 , p5_a34 DATE := fnd_api.g_miss_date
3279 , p5_a35 NUMBER := 0-1962.0724
3280 , p5_a36 NUMBER := 0-1962.0724
3281 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
3282 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
3283 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
3284 , p5_a40 DATE := fnd_api.g_miss_date
3285 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
3286 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
3287 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
3288 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
3289 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
3290 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
3291 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
3292 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
3293 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
3294 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
3295 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
3296 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
3297 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
3298 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
3299 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
3300 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
3301 , p5_a57 DATE := fnd_api.g_miss_date
3302 , p5_a58 NUMBER := 0-1962.0724
3303 , p5_a59 NUMBER := 0-1962.0724
3304 , p5_a60 NUMBER := 0-1962.0724
3305 , p5_a61 NUMBER := 0-1962.0724
3306 , p5_a62 NUMBER := 0-1962.0724
3307 , p5_a63 DATE := fnd_api.g_miss_date
3308 , p5_a64 NUMBER := 0-1962.0724
3309 , p5_a65 DATE := fnd_api.g_miss_date
3310 , p5_a66 NUMBER := 0-1962.0724
3311 , p5_a67 DATE := fnd_api.g_miss_date
3312 , p5_a68 NUMBER := 0-1962.0724
3313 , p5_a69 NUMBER := 0-1962.0724
3314 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
3315 , p5_a71 NUMBER := 0-1962.0724
3316 , p5_a72 NUMBER := 0-1962.0724
3317 , p5_a73 NUMBER := 0-1962.0724
3318 , p5_a74 NUMBER := 0-1962.0724
3319 , p5_a75 NUMBER := 0-1962.0724
3320 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
3321 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
3322 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
3323 , p5_a79 NUMBER := 0-1962.0724
3324 , p5_a80 DATE := fnd_api.g_miss_date
3325 , p5_a81 NUMBER := 0-1962.0724
3326 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
3327 )
3328
3329 as
3330 ddp_qtev_rec okl_qte_pvt.qtev_rec_type;
3331 ddindx binary_integer; indx binary_integer;
3332 begin
3333
3334 -- copy data to the local IN or IN-OUT args, if any
3335
3336
3337
3338
3339
3340 ddp_qtev_rec.id := rosetta_g_miss_num_map(p5_a0);
3341 ddp_qtev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3342 ddp_qtev_rec.sfwt_flag := p5_a2;
3343 ddp_qtev_rec.qrs_code := p5_a3;
3344 ddp_qtev_rec.qst_code := p5_a4;
3345 ddp_qtev_rec.qtp_code := p5_a5;
3346 ddp_qtev_rec.trn_code := p5_a6;
3347 ddp_qtev_rec.pop_code_end := p5_a7;
3348 ddp_qtev_rec.pop_code_early := p5_a8;
3349 ddp_qtev_rec.consolidated_qte_id := rosetta_g_miss_num_map(p5_a9);
3350 ddp_qtev_rec.khr_id := rosetta_g_miss_num_map(p5_a10);
3351 ddp_qtev_rec.art_id := rosetta_g_miss_num_map(p5_a11);
3352 ddp_qtev_rec.pdt_id := rosetta_g_miss_num_map(p5_a12);
3353 ddp_qtev_rec.early_termination_yn := p5_a13;
3354 ddp_qtev_rec.partial_yn := p5_a14;
3355 ddp_qtev_rec.preproceeds_yn := p5_a15;
3356 ddp_qtev_rec.date_requested := rosetta_g_miss_date_in_map(p5_a16);
3357 ddp_qtev_rec.date_proposal := rosetta_g_miss_date_in_map(p5_a17);
3358 ddp_qtev_rec.date_effective_to := rosetta_g_miss_date_in_map(p5_a18);
3359 ddp_qtev_rec.date_accepted := rosetta_g_miss_date_in_map(p5_a19);
3360 ddp_qtev_rec.summary_format_yn := p5_a20;
3361 ddp_qtev_rec.consolidated_yn := p5_a21;
3362 ddp_qtev_rec.principal_paydown_amount := rosetta_g_miss_num_map(p5_a22);
3363 ddp_qtev_rec.residual_amount := rosetta_g_miss_num_map(p5_a23);
3364 ddp_qtev_rec.yield := rosetta_g_miss_num_map(p5_a24);
3365 ddp_qtev_rec.rent_amount := rosetta_g_miss_num_map(p5_a25);
3366 ddp_qtev_rec.date_restructure_end := rosetta_g_miss_date_in_map(p5_a26);
3367 ddp_qtev_rec.date_restructure_start := rosetta_g_miss_date_in_map(p5_a27);
3368 ddp_qtev_rec.term := rosetta_g_miss_num_map(p5_a28);
3369 ddp_qtev_rec.purchase_percent := rosetta_g_miss_num_map(p5_a29);
3370 ddp_qtev_rec.comments := p5_a30;
3371 ddp_qtev_rec.date_due := rosetta_g_miss_date_in_map(p5_a31);
3372 ddp_qtev_rec.payment_frequency := p5_a32;
3373 ddp_qtev_rec.remaining_payments := rosetta_g_miss_num_map(p5_a33);
3374 ddp_qtev_rec.date_effective_from := rosetta_g_miss_date_in_map(p5_a34);
3375 ddp_qtev_rec.quote_number := rosetta_g_miss_num_map(p5_a35);
3376 ddp_qtev_rec.requested_by := rosetta_g_miss_num_map(p5_a36);
3377 ddp_qtev_rec.approved_yn := p5_a37;
3378 ddp_qtev_rec.accepted_yn := p5_a38;
3379 ddp_qtev_rec.payment_received_yn := p5_a39;
3380 ddp_qtev_rec.date_payment_received := rosetta_g_miss_date_in_map(p5_a40);
3381 ddp_qtev_rec.attribute_category := p5_a41;
3382 ddp_qtev_rec.attribute1 := p5_a42;
3383 ddp_qtev_rec.attribute2 := p5_a43;
3384 ddp_qtev_rec.attribute3 := p5_a44;
3385 ddp_qtev_rec.attribute4 := p5_a45;
3386 ddp_qtev_rec.attribute5 := p5_a46;
3387 ddp_qtev_rec.attribute6 := p5_a47;
3388 ddp_qtev_rec.attribute7 := p5_a48;
3389 ddp_qtev_rec.attribute8 := p5_a49;
3390 ddp_qtev_rec.attribute9 := p5_a50;
3391 ddp_qtev_rec.attribute10 := p5_a51;
3392 ddp_qtev_rec.attribute11 := p5_a52;
3393 ddp_qtev_rec.attribute12 := p5_a53;
3394 ddp_qtev_rec.attribute13 := p5_a54;
3395 ddp_qtev_rec.attribute14 := p5_a55;
3396 ddp_qtev_rec.attribute15 := p5_a56;
3397 ddp_qtev_rec.date_approved := rosetta_g_miss_date_in_map(p5_a57);
3398 ddp_qtev_rec.approved_by := rosetta_g_miss_num_map(p5_a58);
3399 ddp_qtev_rec.org_id := rosetta_g_miss_num_map(p5_a59);
3400 ddp_qtev_rec.request_id := rosetta_g_miss_num_map(p5_a60);
3401 ddp_qtev_rec.program_application_id := rosetta_g_miss_num_map(p5_a61);
3402 ddp_qtev_rec.program_id := rosetta_g_miss_num_map(p5_a62);
3403 ddp_qtev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a63);
3404 ddp_qtev_rec.created_by := rosetta_g_miss_num_map(p5_a64);
3405 ddp_qtev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a65);
3406 ddp_qtev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a66);
3407 ddp_qtev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a67);
3408 ddp_qtev_rec.last_update_login := rosetta_g_miss_num_map(p5_a68);
3409 ddp_qtev_rec.purchase_amount := rosetta_g_miss_num_map(p5_a69);
3410 ddp_qtev_rec.purchase_formula := p5_a70;
3411 ddp_qtev_rec.asset_value := rosetta_g_miss_num_map(p5_a71);
3412 ddp_qtev_rec.residual_value := rosetta_g_miss_num_map(p5_a72);
3413 ddp_qtev_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a73);
3414 ddp_qtev_rec.gain_loss := rosetta_g_miss_num_map(p5_a74);
3415 ddp_qtev_rec.perdiem_amount := rosetta_g_miss_num_map(p5_a75);
3416 ddp_qtev_rec.currency_code := p5_a76;
3417 ddp_qtev_rec.currency_conversion_code := p5_a77;
3418 ddp_qtev_rec.currency_conversion_type := p5_a78;
3419 ddp_qtev_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a79);
3420 ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
3421 ddp_qtev_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
3422 ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
3423
3424 -- here's the delegated call to the old PL/SQL routine
3425 okl_qte_pvt.delete_row(p_api_version,
3426 p_init_msg_list,
3427 x_return_status,
3428 x_msg_count,
3429 x_msg_data,
3430 ddp_qtev_rec);
3431
3432 -- copy data back from the local variables to OUT or IN-OUT args, if any
3433
3434
3435
3436
3437
3438 end;
3439
3440 procedure delete_row(p_api_version NUMBER
3441 , p_init_msg_list VARCHAR2
3442 , x_return_status out nocopy VARCHAR2
3443 , x_msg_count out nocopy NUMBER
3444 , x_msg_data out nocopy VARCHAR2
3445 , p5_a0 JTF_NUMBER_TABLE
3446 , p5_a1 JTF_NUMBER_TABLE
3447 , p5_a2 JTF_VARCHAR2_TABLE_100
3448 , p5_a3 JTF_VARCHAR2_TABLE_100
3449 , p5_a4 JTF_VARCHAR2_TABLE_100
3450 , p5_a5 JTF_VARCHAR2_TABLE_100
3451 , p5_a6 JTF_VARCHAR2_TABLE_100
3452 , p5_a7 JTF_VARCHAR2_TABLE_100
3453 , p5_a8 JTF_VARCHAR2_TABLE_100
3454 , p5_a9 JTF_NUMBER_TABLE
3455 , p5_a10 JTF_NUMBER_TABLE
3456 , p5_a11 JTF_NUMBER_TABLE
3457 , p5_a12 JTF_NUMBER_TABLE
3458 , p5_a13 JTF_VARCHAR2_TABLE_100
3459 , p5_a14 JTF_VARCHAR2_TABLE_100
3460 , p5_a15 JTF_VARCHAR2_TABLE_100
3461 , p5_a16 JTF_DATE_TABLE
3462 , p5_a17 JTF_DATE_TABLE
3463 , p5_a18 JTF_DATE_TABLE
3464 , p5_a19 JTF_DATE_TABLE
3465 , p5_a20 JTF_VARCHAR2_TABLE_100
3466 , p5_a21 JTF_VARCHAR2_TABLE_100
3467 , p5_a22 JTF_NUMBER_TABLE
3468 , p5_a23 JTF_NUMBER_TABLE
3469 , p5_a24 JTF_NUMBER_TABLE
3470 , p5_a25 JTF_NUMBER_TABLE
3471 , p5_a26 JTF_DATE_TABLE
3472 , p5_a27 JTF_DATE_TABLE
3473 , p5_a28 JTF_NUMBER_TABLE
3474 , p5_a29 JTF_NUMBER_TABLE
3475 , p5_a30 JTF_VARCHAR2_TABLE_2000
3476 , p5_a31 JTF_DATE_TABLE
3477 , p5_a32 JTF_VARCHAR2_TABLE_100
3478 , p5_a33 JTF_NUMBER_TABLE
3479 , p5_a34 JTF_DATE_TABLE
3480 , p5_a35 JTF_NUMBER_TABLE
3481 , p5_a36 JTF_NUMBER_TABLE
3482 , p5_a37 JTF_VARCHAR2_TABLE_100
3483 , p5_a38 JTF_VARCHAR2_TABLE_100
3484 , p5_a39 JTF_VARCHAR2_TABLE_100
3485 , p5_a40 JTF_DATE_TABLE
3486 , p5_a41 JTF_VARCHAR2_TABLE_100
3487 , p5_a42 JTF_VARCHAR2_TABLE_500
3488 , p5_a43 JTF_VARCHAR2_TABLE_500
3489 , p5_a44 JTF_VARCHAR2_TABLE_500
3490 , p5_a45 JTF_VARCHAR2_TABLE_500
3491 , p5_a46 JTF_VARCHAR2_TABLE_500
3492 , p5_a47 JTF_VARCHAR2_TABLE_500
3493 , p5_a48 JTF_VARCHAR2_TABLE_500
3494 , p5_a49 JTF_VARCHAR2_TABLE_500
3495 , p5_a50 JTF_VARCHAR2_TABLE_500
3496 , p5_a51 JTF_VARCHAR2_TABLE_500
3497 , p5_a52 JTF_VARCHAR2_TABLE_500
3498 , p5_a53 JTF_VARCHAR2_TABLE_500
3499 , p5_a54 JTF_VARCHAR2_TABLE_500
3500 , p5_a55 JTF_VARCHAR2_TABLE_500
3501 , p5_a56 JTF_VARCHAR2_TABLE_500
3502 , p5_a57 JTF_DATE_TABLE
3503 , p5_a58 JTF_NUMBER_TABLE
3504 , p5_a59 JTF_NUMBER_TABLE
3505 , p5_a60 JTF_NUMBER_TABLE
3506 , p5_a61 JTF_NUMBER_TABLE
3507 , p5_a62 JTF_NUMBER_TABLE
3508 , p5_a63 JTF_DATE_TABLE
3509 , p5_a64 JTF_NUMBER_TABLE
3510 , p5_a65 JTF_DATE_TABLE
3511 , p5_a66 JTF_NUMBER_TABLE
3512 , p5_a67 JTF_DATE_TABLE
3513 , p5_a68 JTF_NUMBER_TABLE
3514 , p5_a69 JTF_NUMBER_TABLE
3515 , p5_a70 JTF_VARCHAR2_TABLE_200
3516 , p5_a71 JTF_NUMBER_TABLE
3517 , p5_a72 JTF_NUMBER_TABLE
3518 , p5_a73 JTF_NUMBER_TABLE
3519 , p5_a74 JTF_NUMBER_TABLE
3520 , p5_a75 JTF_NUMBER_TABLE
3521 , p5_a76 JTF_VARCHAR2_TABLE_100
3522 , p5_a77 JTF_VARCHAR2_TABLE_100
3523 , p5_a78 JTF_VARCHAR2_TABLE_100
3524 , p5_a79 JTF_NUMBER_TABLE
3525 , p5_a80 JTF_DATE_TABLE
3526 , p5_a81 JTF_NUMBER_TABLE
3527 , p5_a82 JTF_VARCHAR2_TABLE_100
3528 )
3529
3530 as
3531 ddp_qtev_tbl okl_qte_pvt.qtev_tbl_type;
3532 ddindx binary_integer; indx binary_integer;
3533 begin
3534
3535 -- copy data to the local IN or IN-OUT args, if any
3536
3537
3538
3539
3540
3541 okl_qte_pvt_w.rosetta_table_copy_in_p8(ddp_qtev_tbl, p5_a0
3542 , p5_a1
3543 , p5_a2
3544 , p5_a3
3545 , p5_a4
3546 , p5_a5
3547 , p5_a6
3548 , p5_a7
3549 , p5_a8
3550 , p5_a9
3551 , p5_a10
3552 , p5_a11
3553 , p5_a12
3554 , p5_a13
3555 , p5_a14
3556 , p5_a15
3557 , p5_a16
3558 , p5_a17
3559 , p5_a18
3560 , p5_a19
3561 , p5_a20
3562 , p5_a21
3563 , p5_a22
3564 , p5_a23
3565 , p5_a24
3566 , p5_a25
3567 , p5_a26
3568 , p5_a27
3569 , p5_a28
3570 , p5_a29
3571 , p5_a30
3572 , p5_a31
3573 , p5_a32
3574 , p5_a33
3575 , p5_a34
3576 , p5_a35
3577 , p5_a36
3578 , p5_a37
3579 , p5_a38
3580 , p5_a39
3581 , p5_a40
3582 , p5_a41
3583 , p5_a42
3584 , p5_a43
3585 , p5_a44
3586 , p5_a45
3587 , p5_a46
3588 , p5_a47
3589 , p5_a48
3590 , p5_a49
3591 , p5_a50
3592 , p5_a51
3593 , p5_a52
3594 , p5_a53
3595 , p5_a54
3596 , p5_a55
3597 , p5_a56
3598 , p5_a57
3599 , p5_a58
3600 , p5_a59
3601 , p5_a60
3602 , p5_a61
3603 , p5_a62
3604 , p5_a63
3605 , p5_a64
3606 , p5_a65
3607 , p5_a66
3608 , p5_a67
3609 , p5_a68
3610 , p5_a69
3611 , p5_a70
3612 , p5_a71
3613 , p5_a72
3614 , p5_a73
3615 , p5_a74
3616 , p5_a75
3617 , p5_a76
3618 , p5_a77
3619 , p5_a78
3620 , p5_a79
3621 , p5_a80
3622 , p5_a81
3623 , p5_a82
3624 );
3625
3626 -- here's the delegated call to the old PL/SQL routine
3627 okl_qte_pvt.delete_row(p_api_version,
3628 p_init_msg_list,
3629 x_return_status,
3630 x_msg_count,
3631 x_msg_data,
3632 ddp_qtev_tbl);
3633
3634 -- copy data back from the local variables to OUT or IN-OUT args, if any
3635
3636
3637
3638
3639
3640 end;
3641
3642 procedure validate_row(p_api_version NUMBER
3643 , p_init_msg_list VARCHAR2
3644 , x_return_status out nocopy VARCHAR2
3645 , x_msg_count out nocopy NUMBER
3646 , x_msg_data out nocopy VARCHAR2
3647 , p5_a0 NUMBER := 0-1962.0724
3648 , p5_a1 NUMBER := 0-1962.0724
3649 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
3650 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
3651 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
3652 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3653 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
3654 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
3655 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
3656 , p5_a9 NUMBER := 0-1962.0724
3657 , p5_a10 NUMBER := 0-1962.0724
3658 , p5_a11 NUMBER := 0-1962.0724
3659 , p5_a12 NUMBER := 0-1962.0724
3660 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
3661 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
3662 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
3663 , p5_a16 DATE := fnd_api.g_miss_date
3664 , p5_a17 DATE := fnd_api.g_miss_date
3665 , p5_a18 DATE := fnd_api.g_miss_date
3666 , p5_a19 DATE := fnd_api.g_miss_date
3667 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
3668 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3669 , p5_a22 NUMBER := 0-1962.0724
3670 , p5_a23 NUMBER := 0-1962.0724
3671 , p5_a24 NUMBER := 0-1962.0724
3672 , p5_a25 NUMBER := 0-1962.0724
3673 , p5_a26 DATE := fnd_api.g_miss_date
3674 , p5_a27 DATE := fnd_api.g_miss_date
3675 , p5_a28 NUMBER := 0-1962.0724
3676 , p5_a29 NUMBER := 0-1962.0724
3677 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
3678 , p5_a31 DATE := fnd_api.g_miss_date
3679 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
3680 , p5_a33 NUMBER := 0-1962.0724
3681 , p5_a34 DATE := fnd_api.g_miss_date
3682 , p5_a35 NUMBER := 0-1962.0724
3683 , p5_a36 NUMBER := 0-1962.0724
3684 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
3685 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
3686 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
3687 , p5_a40 DATE := fnd_api.g_miss_date
3688 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
3689 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
3690 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
3691 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
3692 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
3693 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
3694 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
3695 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
3696 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
3697 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
3698 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
3699 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
3700 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
3701 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
3702 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
3703 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
3704 , p5_a57 DATE := fnd_api.g_miss_date
3705 , p5_a58 NUMBER := 0-1962.0724
3706 , p5_a59 NUMBER := 0-1962.0724
3707 , p5_a60 NUMBER := 0-1962.0724
3708 , p5_a61 NUMBER := 0-1962.0724
3709 , p5_a62 NUMBER := 0-1962.0724
3710 , p5_a63 DATE := fnd_api.g_miss_date
3711 , p5_a64 NUMBER := 0-1962.0724
3712 , p5_a65 DATE := fnd_api.g_miss_date
3713 , p5_a66 NUMBER := 0-1962.0724
3714 , p5_a67 DATE := fnd_api.g_miss_date
3715 , p5_a68 NUMBER := 0-1962.0724
3716 , p5_a69 NUMBER := 0-1962.0724
3717 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
3718 , p5_a71 NUMBER := 0-1962.0724
3719 , p5_a72 NUMBER := 0-1962.0724
3720 , p5_a73 NUMBER := 0-1962.0724
3721 , p5_a74 NUMBER := 0-1962.0724
3722 , p5_a75 NUMBER := 0-1962.0724
3723 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
3724 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
3725 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
3726 , p5_a79 NUMBER := 0-1962.0724
3727 , p5_a80 DATE := fnd_api.g_miss_date
3728 , p5_a81 NUMBER := 0-1962.0724
3729 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
3730 )
3731
3732 as
3733 ddp_qtev_rec okl_qte_pvt.qtev_rec_type;
3734 ddindx binary_integer; indx binary_integer;
3735 begin
3736
3737 -- copy data to the local IN or IN-OUT args, if any
3738
3739
3740
3741
3742
3743 ddp_qtev_rec.id := rosetta_g_miss_num_map(p5_a0);
3744 ddp_qtev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
3745 ddp_qtev_rec.sfwt_flag := p5_a2;
3746 ddp_qtev_rec.qrs_code := p5_a3;
3747 ddp_qtev_rec.qst_code := p5_a4;
3748 ddp_qtev_rec.qtp_code := p5_a5;
3749 ddp_qtev_rec.trn_code := p5_a6;
3750 ddp_qtev_rec.pop_code_end := p5_a7;
3751 ddp_qtev_rec.pop_code_early := p5_a8;
3752 ddp_qtev_rec.consolidated_qte_id := rosetta_g_miss_num_map(p5_a9);
3753 ddp_qtev_rec.khr_id := rosetta_g_miss_num_map(p5_a10);
3754 ddp_qtev_rec.art_id := rosetta_g_miss_num_map(p5_a11);
3755 ddp_qtev_rec.pdt_id := rosetta_g_miss_num_map(p5_a12);
3756 ddp_qtev_rec.early_termination_yn := p5_a13;
3757 ddp_qtev_rec.partial_yn := p5_a14;
3758 ddp_qtev_rec.preproceeds_yn := p5_a15;
3759 ddp_qtev_rec.date_requested := rosetta_g_miss_date_in_map(p5_a16);
3760 ddp_qtev_rec.date_proposal := rosetta_g_miss_date_in_map(p5_a17);
3761 ddp_qtev_rec.date_effective_to := rosetta_g_miss_date_in_map(p5_a18);
3762 ddp_qtev_rec.date_accepted := rosetta_g_miss_date_in_map(p5_a19);
3763 ddp_qtev_rec.summary_format_yn := p5_a20;
3764 ddp_qtev_rec.consolidated_yn := p5_a21;
3765 ddp_qtev_rec.principal_paydown_amount := rosetta_g_miss_num_map(p5_a22);
3766 ddp_qtev_rec.residual_amount := rosetta_g_miss_num_map(p5_a23);
3767 ddp_qtev_rec.yield := rosetta_g_miss_num_map(p5_a24);
3768 ddp_qtev_rec.rent_amount := rosetta_g_miss_num_map(p5_a25);
3769 ddp_qtev_rec.date_restructure_end := rosetta_g_miss_date_in_map(p5_a26);
3770 ddp_qtev_rec.date_restructure_start := rosetta_g_miss_date_in_map(p5_a27);
3771 ddp_qtev_rec.term := rosetta_g_miss_num_map(p5_a28);
3772 ddp_qtev_rec.purchase_percent := rosetta_g_miss_num_map(p5_a29);
3773 ddp_qtev_rec.comments := p5_a30;
3774 ddp_qtev_rec.date_due := rosetta_g_miss_date_in_map(p5_a31);
3775 ddp_qtev_rec.payment_frequency := p5_a32;
3776 ddp_qtev_rec.remaining_payments := rosetta_g_miss_num_map(p5_a33);
3777 ddp_qtev_rec.date_effective_from := rosetta_g_miss_date_in_map(p5_a34);
3778 ddp_qtev_rec.quote_number := rosetta_g_miss_num_map(p5_a35);
3779 ddp_qtev_rec.requested_by := rosetta_g_miss_num_map(p5_a36);
3780 ddp_qtev_rec.approved_yn := p5_a37;
3781 ddp_qtev_rec.accepted_yn := p5_a38;
3782 ddp_qtev_rec.payment_received_yn := p5_a39;
3783 ddp_qtev_rec.date_payment_received := rosetta_g_miss_date_in_map(p5_a40);
3784 ddp_qtev_rec.attribute_category := p5_a41;
3785 ddp_qtev_rec.attribute1 := p5_a42;
3786 ddp_qtev_rec.attribute2 := p5_a43;
3787 ddp_qtev_rec.attribute3 := p5_a44;
3788 ddp_qtev_rec.attribute4 := p5_a45;
3789 ddp_qtev_rec.attribute5 := p5_a46;
3790 ddp_qtev_rec.attribute6 := p5_a47;
3791 ddp_qtev_rec.attribute7 := p5_a48;
3792 ddp_qtev_rec.attribute8 := p5_a49;
3793 ddp_qtev_rec.attribute9 := p5_a50;
3794 ddp_qtev_rec.attribute10 := p5_a51;
3795 ddp_qtev_rec.attribute11 := p5_a52;
3796 ddp_qtev_rec.attribute12 := p5_a53;
3797 ddp_qtev_rec.attribute13 := p5_a54;
3798 ddp_qtev_rec.attribute14 := p5_a55;
3799 ddp_qtev_rec.attribute15 := p5_a56;
3800 ddp_qtev_rec.date_approved := rosetta_g_miss_date_in_map(p5_a57);
3801 ddp_qtev_rec.approved_by := rosetta_g_miss_num_map(p5_a58);
3802 ddp_qtev_rec.org_id := rosetta_g_miss_num_map(p5_a59);
3803 ddp_qtev_rec.request_id := rosetta_g_miss_num_map(p5_a60);
3804 ddp_qtev_rec.program_application_id := rosetta_g_miss_num_map(p5_a61);
3805 ddp_qtev_rec.program_id := rosetta_g_miss_num_map(p5_a62);
3806 ddp_qtev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a63);
3807 ddp_qtev_rec.created_by := rosetta_g_miss_num_map(p5_a64);
3808 ddp_qtev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a65);
3809 ddp_qtev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a66);
3810 ddp_qtev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a67);
3811 ddp_qtev_rec.last_update_login := rosetta_g_miss_num_map(p5_a68);
3812 ddp_qtev_rec.purchase_amount := rosetta_g_miss_num_map(p5_a69);
3813 ddp_qtev_rec.purchase_formula := p5_a70;
3814 ddp_qtev_rec.asset_value := rosetta_g_miss_num_map(p5_a71);
3815 ddp_qtev_rec.residual_value := rosetta_g_miss_num_map(p5_a72);
3816 ddp_qtev_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a73);
3817 ddp_qtev_rec.gain_loss := rosetta_g_miss_num_map(p5_a74);
3818 ddp_qtev_rec.perdiem_amount := rosetta_g_miss_num_map(p5_a75);
3819 ddp_qtev_rec.currency_code := p5_a76;
3820 ddp_qtev_rec.currency_conversion_code := p5_a77;
3821 ddp_qtev_rec.currency_conversion_type := p5_a78;
3822 ddp_qtev_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a79);
3823 ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
3824 ddp_qtev_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
3825 ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
3826
3827 -- here's the delegated call to the old PL/SQL routine
3828 okl_qte_pvt.validate_row(p_api_version,
3829 p_init_msg_list,
3830 x_return_status,
3831 x_msg_count,
3832 x_msg_data,
3833 ddp_qtev_rec);
3834
3835 -- copy data back from the local variables to OUT or IN-OUT args, if any
3836
3837
3838
3839
3840
3841 end;
3842
3843 procedure validate_row(p_api_version NUMBER
3844 , p_init_msg_list VARCHAR2
3845 , x_return_status out nocopy VARCHAR2
3846 , x_msg_count out nocopy NUMBER
3847 , x_msg_data out nocopy VARCHAR2
3848 , p5_a0 JTF_NUMBER_TABLE
3849 , p5_a1 JTF_NUMBER_TABLE
3850 , p5_a2 JTF_VARCHAR2_TABLE_100
3851 , p5_a3 JTF_VARCHAR2_TABLE_100
3852 , p5_a4 JTF_VARCHAR2_TABLE_100
3853 , p5_a5 JTF_VARCHAR2_TABLE_100
3854 , p5_a6 JTF_VARCHAR2_TABLE_100
3855 , p5_a7 JTF_VARCHAR2_TABLE_100
3856 , p5_a8 JTF_VARCHAR2_TABLE_100
3857 , p5_a9 JTF_NUMBER_TABLE
3858 , p5_a10 JTF_NUMBER_TABLE
3859 , p5_a11 JTF_NUMBER_TABLE
3860 , p5_a12 JTF_NUMBER_TABLE
3861 , p5_a13 JTF_VARCHAR2_TABLE_100
3862 , p5_a14 JTF_VARCHAR2_TABLE_100
3863 , p5_a15 JTF_VARCHAR2_TABLE_100
3864 , p5_a16 JTF_DATE_TABLE
3865 , p5_a17 JTF_DATE_TABLE
3866 , p5_a18 JTF_DATE_TABLE
3867 , p5_a19 JTF_DATE_TABLE
3868 , p5_a20 JTF_VARCHAR2_TABLE_100
3869 , p5_a21 JTF_VARCHAR2_TABLE_100
3870 , p5_a22 JTF_NUMBER_TABLE
3871 , p5_a23 JTF_NUMBER_TABLE
3872 , p5_a24 JTF_NUMBER_TABLE
3873 , p5_a25 JTF_NUMBER_TABLE
3874 , p5_a26 JTF_DATE_TABLE
3875 , p5_a27 JTF_DATE_TABLE
3876 , p5_a28 JTF_NUMBER_TABLE
3877 , p5_a29 JTF_NUMBER_TABLE
3878 , p5_a30 JTF_VARCHAR2_TABLE_2000
3879 , p5_a31 JTF_DATE_TABLE
3880 , p5_a32 JTF_VARCHAR2_TABLE_100
3881 , p5_a33 JTF_NUMBER_TABLE
3882 , p5_a34 JTF_DATE_TABLE
3883 , p5_a35 JTF_NUMBER_TABLE
3884 , p5_a36 JTF_NUMBER_TABLE
3885 , p5_a37 JTF_VARCHAR2_TABLE_100
3886 , p5_a38 JTF_VARCHAR2_TABLE_100
3887 , p5_a39 JTF_VARCHAR2_TABLE_100
3888 , p5_a40 JTF_DATE_TABLE
3889 , p5_a41 JTF_VARCHAR2_TABLE_100
3890 , p5_a42 JTF_VARCHAR2_TABLE_500
3891 , p5_a43 JTF_VARCHAR2_TABLE_500
3892 , p5_a44 JTF_VARCHAR2_TABLE_500
3893 , p5_a45 JTF_VARCHAR2_TABLE_500
3894 , p5_a46 JTF_VARCHAR2_TABLE_500
3895 , p5_a47 JTF_VARCHAR2_TABLE_500
3896 , p5_a48 JTF_VARCHAR2_TABLE_500
3897 , p5_a49 JTF_VARCHAR2_TABLE_500
3898 , p5_a50 JTF_VARCHAR2_TABLE_500
3899 , p5_a51 JTF_VARCHAR2_TABLE_500
3900 , p5_a52 JTF_VARCHAR2_TABLE_500
3901 , p5_a53 JTF_VARCHAR2_TABLE_500
3902 , p5_a54 JTF_VARCHAR2_TABLE_500
3903 , p5_a55 JTF_VARCHAR2_TABLE_500
3904 , p5_a56 JTF_VARCHAR2_TABLE_500
3905 , p5_a57 JTF_DATE_TABLE
3906 , p5_a58 JTF_NUMBER_TABLE
3907 , p5_a59 JTF_NUMBER_TABLE
3908 , p5_a60 JTF_NUMBER_TABLE
3909 , p5_a61 JTF_NUMBER_TABLE
3910 , p5_a62 JTF_NUMBER_TABLE
3911 , p5_a63 JTF_DATE_TABLE
3912 , p5_a64 JTF_NUMBER_TABLE
3913 , p5_a65 JTF_DATE_TABLE
3914 , p5_a66 JTF_NUMBER_TABLE
3915 , p5_a67 JTF_DATE_TABLE
3916 , p5_a68 JTF_NUMBER_TABLE
3917 , p5_a69 JTF_NUMBER_TABLE
3918 , p5_a70 JTF_VARCHAR2_TABLE_200
3919 , p5_a71 JTF_NUMBER_TABLE
3920 , p5_a72 JTF_NUMBER_TABLE
3921 , p5_a73 JTF_NUMBER_TABLE
3922 , p5_a74 JTF_NUMBER_TABLE
3923 , p5_a75 JTF_NUMBER_TABLE
3924 , p5_a76 JTF_VARCHAR2_TABLE_100
3925 , p5_a77 JTF_VARCHAR2_TABLE_100
3926 , p5_a78 JTF_VARCHAR2_TABLE_100
3927 , p5_a79 JTF_NUMBER_TABLE
3928 , p5_a80 JTF_DATE_TABLE
3929 , p5_a81 JTF_NUMBER_TABLE
3930 , p5_a82 JTF_VARCHAR2_TABLE_100
3931 )
3932
3933 as
3934 ddp_qtev_tbl okl_qte_pvt.qtev_tbl_type;
3935 ddindx binary_integer; indx binary_integer;
3936 begin
3937
3938 -- copy data to the local IN or IN-OUT args, if any
3939
3940
3941
3942
3943
3944 okl_qte_pvt_w.rosetta_table_copy_in_p8(ddp_qtev_tbl, p5_a0
3945 , p5_a1
3946 , p5_a2
3947 , p5_a3
3948 , p5_a4
3949 , p5_a5
3950 , p5_a6
3951 , p5_a7
3952 , p5_a8
3953 , p5_a9
3954 , p5_a10
3955 , p5_a11
3956 , p5_a12
3957 , p5_a13
3958 , p5_a14
3959 , p5_a15
3960 , p5_a16
3961 , p5_a17
3962 , p5_a18
3963 , p5_a19
3964 , p5_a20
3965 , p5_a21
3966 , p5_a22
3967 , p5_a23
3968 , p5_a24
3969 , p5_a25
3970 , p5_a26
3971 , p5_a27
3972 , p5_a28
3973 , p5_a29
3974 , p5_a30
3975 , p5_a31
3976 , p5_a32
3977 , p5_a33
3978 , p5_a34
3979 , p5_a35
3980 , p5_a36
3981 , p5_a37
3982 , p5_a38
3983 , p5_a39
3984 , p5_a40
3985 , p5_a41
3986 , p5_a42
3987 , p5_a43
3988 , p5_a44
3989 , p5_a45
3990 , p5_a46
3991 , p5_a47
3992 , p5_a48
3993 , p5_a49
3994 , p5_a50
3995 , p5_a51
3996 , p5_a52
3997 , p5_a53
3998 , p5_a54
3999 , p5_a55
4000 , p5_a56
4001 , p5_a57
4002 , p5_a58
4003 , p5_a59
4004 , p5_a60
4005 , p5_a61
4006 , p5_a62
4007 , p5_a63
4008 , p5_a64
4009 , p5_a65
4010 , p5_a66
4011 , p5_a67
4012 , p5_a68
4013 , p5_a69
4014 , p5_a70
4015 , p5_a71
4016 , p5_a72
4017 , p5_a73
4018 , p5_a74
4019 , p5_a75
4020 , p5_a76
4021 , p5_a77
4022 , p5_a78
4023 , p5_a79
4024 , p5_a80
4025 , p5_a81
4026 , p5_a82
4027 );
4028
4029 -- here's the delegated call to the old PL/SQL routine
4030 okl_qte_pvt.validate_row(p_api_version,
4031 p_init_msg_list,
4032 x_return_status,
4033 x_msg_count,
4034 x_msg_data,
4035 ddp_qtev_tbl);
4036
4037 -- copy data back from the local variables to OUT or IN-OUT args, if any
4038
4039
4040
4041
4042
4043 end;
4044
4045 end okl_qte_pvt_w;