[Home] [Help]
PACKAGE BODY: APPS.OKL_TXL_QUOTE_LINES_PUB_W
Source
1 package body okl_txl_quote_lines_pub_w as
2 /* $Header: OKLUTQLB.pls 120.2 2005/08/19 01:34:04 rmunjulu noship $ */
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 insert_txl_quote_lines(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , x_return_status out nocopy VARCHAR2
25 , x_msg_count out nocopy NUMBER
26 , x_msg_data out nocopy VARCHAR2
27 , p5_a0 JTF_NUMBER_TABLE
28 , p5_a1 JTF_NUMBER_TABLE
29 , p5_a2 JTF_VARCHAR2_TABLE_100
30 , p5_a3 JTF_VARCHAR2_TABLE_100
31 , p5_a4 JTF_NUMBER_TABLE
32 , p5_a5 JTF_NUMBER_TABLE
33 , p5_a6 JTF_NUMBER_TABLE
34 , p5_a7 JTF_NUMBER_TABLE
35 , p5_a8 JTF_VARCHAR2_TABLE_2000
36 , p5_a9 JTF_NUMBER_TABLE
37 , p5_a10 JTF_VARCHAR2_TABLE_100
38 , p5_a11 JTF_VARCHAR2_TABLE_100
39 , p5_a12 JTF_VARCHAR2_TABLE_100
40 , p5_a13 JTF_VARCHAR2_TABLE_100
41 , p5_a14 JTF_VARCHAR2_TABLE_500
42 , p5_a15 JTF_VARCHAR2_TABLE_500
43 , p5_a16 JTF_VARCHAR2_TABLE_500
44 , p5_a17 JTF_VARCHAR2_TABLE_500
45 , p5_a18 JTF_VARCHAR2_TABLE_500
46 , p5_a19 JTF_VARCHAR2_TABLE_500
47 , p5_a20 JTF_VARCHAR2_TABLE_500
48 , p5_a21 JTF_VARCHAR2_TABLE_500
49 , p5_a22 JTF_VARCHAR2_TABLE_500
50 , p5_a23 JTF_VARCHAR2_TABLE_500
51 , p5_a24 JTF_VARCHAR2_TABLE_500
52 , p5_a25 JTF_VARCHAR2_TABLE_500
53 , p5_a26 JTF_VARCHAR2_TABLE_500
54 , p5_a27 JTF_VARCHAR2_TABLE_500
55 , p5_a28 JTF_VARCHAR2_TABLE_500
56 , p5_a29 JTF_NUMBER_TABLE
57 , p5_a30 JTF_NUMBER_TABLE
58 , p5_a31 JTF_NUMBER_TABLE
59 , p5_a32 JTF_NUMBER_TABLE
60 , p5_a33 JTF_DATE_TABLE
61 , p5_a34 JTF_NUMBER_TABLE
62 , p5_a35 JTF_DATE_TABLE
63 , p5_a36 JTF_NUMBER_TABLE
64 , p5_a37 JTF_DATE_TABLE
65 , p5_a38 JTF_NUMBER_TABLE
66 , p5_a39 JTF_DATE_TABLE
67 , p5_a40 JTF_VARCHAR2_TABLE_100
68 , p5_a41 JTF_NUMBER_TABLE
69 , p5_a42 JTF_VARCHAR2_TABLE_100
70 , p5_a43 JTF_VARCHAR2_TABLE_100
71 , p5_a44 JTF_VARCHAR2_TABLE_200
72 , p5_a45 JTF_NUMBER_TABLE
73 , p5_a46 JTF_NUMBER_TABLE
74 , p5_a47 JTF_NUMBER_TABLE
75 , p5_a48 JTF_NUMBER_TABLE
76 , p5_a49 JTF_NUMBER_TABLE
77 , p5_a50 JTF_NUMBER_TABLE
78 , p5_a51 JTF_NUMBER_TABLE
79 , p5_a52 JTF_NUMBER_TABLE
80 , p5_a53 JTF_VARCHAR2_TABLE_200
81 , p5_a54 JTF_VARCHAR2_TABLE_100
82 , p5_a55 JTF_VARCHAR2_TABLE_100
83 , p5_a56 JTF_VARCHAR2_TABLE_100
84 , p5_a57 JTF_NUMBER_TABLE
85 , p5_a58 JTF_DATE_TABLE
86 , p5_a59 JTF_DATE_TABLE
87 , p5_a60 JTF_NUMBER_TABLE
88 , p6_a0 out nocopy JTF_NUMBER_TABLE
89 , p6_a1 out nocopy JTF_NUMBER_TABLE
90 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
91 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
92 , p6_a4 out nocopy JTF_NUMBER_TABLE
93 , p6_a5 out nocopy JTF_NUMBER_TABLE
94 , p6_a6 out nocopy JTF_NUMBER_TABLE
95 , p6_a7 out nocopy JTF_NUMBER_TABLE
96 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
97 , p6_a9 out nocopy JTF_NUMBER_TABLE
98 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
99 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
100 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
101 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
102 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
103 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
104 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
105 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
106 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
107 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
108 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
109 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
110 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
111 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
112 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
113 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
114 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
115 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
116 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
117 , p6_a29 out nocopy JTF_NUMBER_TABLE
118 , p6_a30 out nocopy JTF_NUMBER_TABLE
119 , p6_a31 out nocopy JTF_NUMBER_TABLE
120 , p6_a32 out nocopy JTF_NUMBER_TABLE
121 , p6_a33 out nocopy JTF_DATE_TABLE
122 , p6_a34 out nocopy JTF_NUMBER_TABLE
123 , p6_a35 out nocopy JTF_DATE_TABLE
124 , p6_a36 out nocopy JTF_NUMBER_TABLE
125 , p6_a37 out nocopy JTF_DATE_TABLE
126 , p6_a38 out nocopy JTF_NUMBER_TABLE
127 , p6_a39 out nocopy JTF_DATE_TABLE
128 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
129 , p6_a41 out nocopy JTF_NUMBER_TABLE
130 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
131 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
132 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_200
133 , p6_a45 out nocopy JTF_NUMBER_TABLE
134 , p6_a46 out nocopy JTF_NUMBER_TABLE
135 , p6_a47 out nocopy JTF_NUMBER_TABLE
136 , p6_a48 out nocopy JTF_NUMBER_TABLE
137 , p6_a49 out nocopy JTF_NUMBER_TABLE
138 , p6_a50 out nocopy JTF_NUMBER_TABLE
139 , p6_a51 out nocopy JTF_NUMBER_TABLE
140 , p6_a52 out nocopy JTF_NUMBER_TABLE
141 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_200
142 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
143 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
144 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
145 , p6_a57 out nocopy JTF_NUMBER_TABLE
146 , p6_a58 out nocopy JTF_DATE_TABLE
147 , p6_a59 out nocopy JTF_DATE_TABLE
148 , p6_a60 out nocopy JTF_NUMBER_TABLE
149 )
150
151 as
152 ddp_tqlv_tbl okl_txl_quote_lines_pub.tqlv_tbl_type;
153 ddx_tqlv_tbl okl_txl_quote_lines_pub.tqlv_tbl_type;
154 ddindx binary_integer; indx binary_integer;
155 begin
156
157 -- copy data to the local IN or IN-OUT args, if any
158
159
160
161
162
163 okl_tql_pvt_w.rosetta_table_copy_in_p8(ddp_tqlv_tbl, p5_a0
164 , p5_a1
165 , p5_a2
166 , p5_a3
167 , p5_a4
168 , p5_a5
169 , p5_a6
170 , p5_a7
171 , p5_a8
172 , p5_a9
173 , p5_a10
174 , p5_a11
175 , p5_a12
176 , p5_a13
177 , p5_a14
178 , p5_a15
179 , p5_a16
180 , p5_a17
181 , p5_a18
182 , p5_a19
183 , p5_a20
184 , p5_a21
185 , p5_a22
186 , p5_a23
187 , p5_a24
188 , p5_a25
189 , p5_a26
190 , p5_a27
191 , p5_a28
192 , p5_a29
193 , p5_a30
194 , p5_a31
195 , p5_a32
196 , p5_a33
197 , p5_a34
198 , p5_a35
199 , p5_a36
200 , p5_a37
201 , p5_a38
202 , p5_a39
203 , p5_a40
204 , p5_a41
205 , p5_a42
206 , p5_a43
207 , p5_a44
208 , p5_a45
209 , p5_a46
210 , p5_a47
211 , p5_a48
212 , p5_a49
213 , p5_a50
214 , p5_a51
215 , p5_a52
216 , p5_a53
217 , p5_a54
218 , p5_a55
219 , p5_a56
220 , p5_a57
221 , p5_a58
222 , p5_a59
223 , p5_a60
224 );
225
226
227 -- here's the delegated call to the old PL/SQL routine
228 okl_txl_quote_lines_pub.insert_txl_quote_lines(p_api_version,
229 p_init_msg_list,
230 x_return_status,
231 x_msg_count,
232 x_msg_data,
233 ddp_tqlv_tbl,
234 ddx_tqlv_tbl);
235
236 -- copy data back from the local variables to OUT or IN-OUT args, if any
237
238
239
240
241
242
243 okl_tql_pvt_w.rosetta_table_copy_out_p8(ddx_tqlv_tbl, p6_a0
244 , p6_a1
245 , p6_a2
246 , p6_a3
247 , p6_a4
248 , p6_a5
249 , p6_a6
250 , p6_a7
251 , p6_a8
252 , p6_a9
253 , p6_a10
254 , p6_a11
255 , p6_a12
256 , p6_a13
257 , p6_a14
258 , p6_a15
259 , p6_a16
260 , p6_a17
261 , p6_a18
262 , p6_a19
263 , p6_a20
264 , p6_a21
265 , p6_a22
266 , p6_a23
267 , p6_a24
268 , p6_a25
269 , p6_a26
270 , p6_a27
271 , p6_a28
272 , p6_a29
273 , p6_a30
274 , p6_a31
275 , p6_a32
276 , p6_a33
277 , p6_a34
278 , p6_a35
279 , p6_a36
280 , p6_a37
281 , p6_a38
282 , p6_a39
283 , p6_a40
284 , p6_a41
285 , p6_a42
286 , p6_a43
287 , p6_a44
288 , p6_a45
289 , p6_a46
290 , p6_a47
291 , p6_a48
292 , p6_a49
293 , p6_a50
294 , p6_a51
295 , p6_a52
296 , p6_a53
297 , p6_a54
298 , p6_a55
299 , p6_a56
300 , p6_a57
301 , p6_a58
302 , p6_a59
303 , p6_a60
304 );
305 end;
306
307 procedure insert_txl_quote_lines(p_api_version NUMBER
308 , p_init_msg_list VARCHAR2
309 , x_return_status out nocopy VARCHAR2
310 , x_msg_count out nocopy NUMBER
311 , x_msg_data out nocopy VARCHAR2
312 , p6_a0 out nocopy NUMBER
313 , p6_a1 out nocopy NUMBER
314 , p6_a2 out nocopy VARCHAR2
315 , p6_a3 out nocopy VARCHAR2
316 , p6_a4 out nocopy NUMBER
317 , p6_a5 out nocopy NUMBER
318 , p6_a6 out nocopy NUMBER
319 , p6_a7 out nocopy NUMBER
320 , p6_a8 out nocopy VARCHAR2
321 , p6_a9 out nocopy NUMBER
322 , p6_a10 out nocopy VARCHAR2
323 , p6_a11 out nocopy VARCHAR2
324 , p6_a12 out nocopy VARCHAR2
325 , p6_a13 out nocopy VARCHAR2
326 , p6_a14 out nocopy VARCHAR2
327 , p6_a15 out nocopy VARCHAR2
328 , p6_a16 out nocopy VARCHAR2
329 , p6_a17 out nocopy VARCHAR2
330 , p6_a18 out nocopy VARCHAR2
331 , p6_a19 out nocopy VARCHAR2
332 , p6_a20 out nocopy VARCHAR2
333 , p6_a21 out nocopy VARCHAR2
334 , p6_a22 out nocopy VARCHAR2
335 , p6_a23 out nocopy VARCHAR2
336 , p6_a24 out nocopy VARCHAR2
337 , p6_a25 out nocopy VARCHAR2
338 , p6_a26 out nocopy VARCHAR2
339 , p6_a27 out nocopy VARCHAR2
340 , p6_a28 out nocopy VARCHAR2
341 , p6_a29 out nocopy NUMBER
342 , p6_a30 out nocopy NUMBER
343 , p6_a31 out nocopy NUMBER
344 , p6_a32 out nocopy NUMBER
345 , p6_a33 out nocopy DATE
346 , p6_a34 out nocopy NUMBER
347 , p6_a35 out nocopy DATE
348 , p6_a36 out nocopy NUMBER
349 , p6_a37 out nocopy DATE
350 , p6_a38 out nocopy NUMBER
351 , p6_a39 out nocopy DATE
352 , p6_a40 out nocopy VARCHAR2
353 , p6_a41 out nocopy NUMBER
354 , p6_a42 out nocopy VARCHAR2
355 , p6_a43 out nocopy VARCHAR2
356 , p6_a44 out nocopy VARCHAR2
357 , p6_a45 out nocopy NUMBER
358 , p6_a46 out nocopy NUMBER
359 , p6_a47 out nocopy NUMBER
360 , p6_a48 out nocopy NUMBER
361 , p6_a49 out nocopy NUMBER
362 , p6_a50 out nocopy NUMBER
363 , p6_a51 out nocopy NUMBER
364 , p6_a52 out nocopy NUMBER
365 , p6_a53 out nocopy VARCHAR2
366 , p6_a54 out nocopy VARCHAR2
367 , p6_a55 out nocopy VARCHAR2
368 , p6_a56 out nocopy VARCHAR2
369 , p6_a57 out nocopy NUMBER
370 , p6_a58 out nocopy DATE
371 , p6_a59 out nocopy DATE
372 , p6_a60 out nocopy NUMBER
373 , p5_a0 NUMBER := 0-1962.0724
374 , p5_a1 NUMBER := 0-1962.0724
375 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
376 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
377 , p5_a4 NUMBER := 0-1962.0724
378 , p5_a5 NUMBER := 0-1962.0724
379 , p5_a6 NUMBER := 0-1962.0724
380 , p5_a7 NUMBER := 0-1962.0724
381 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
382 , p5_a9 NUMBER := 0-1962.0724
383 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
384 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
385 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
386 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
387 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
388 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
389 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
390 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
391 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
392 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
393 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
394 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
395 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
396 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
397 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
398 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
399 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
400 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
401 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
402 , p5_a29 NUMBER := 0-1962.0724
403 , p5_a30 NUMBER := 0-1962.0724
404 , p5_a31 NUMBER := 0-1962.0724
405 , p5_a32 NUMBER := 0-1962.0724
406 , p5_a33 DATE := fnd_api.g_miss_date
407 , p5_a34 NUMBER := 0-1962.0724
408 , p5_a35 DATE := fnd_api.g_miss_date
409 , p5_a36 NUMBER := 0-1962.0724
410 , p5_a37 DATE := fnd_api.g_miss_date
411 , p5_a38 NUMBER := 0-1962.0724
412 , p5_a39 DATE := fnd_api.g_miss_date
413 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
414 , p5_a41 NUMBER := 0-1962.0724
415 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
416 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
417 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
418 , p5_a45 NUMBER := 0-1962.0724
419 , p5_a46 NUMBER := 0-1962.0724
420 , p5_a47 NUMBER := 0-1962.0724
421 , p5_a48 NUMBER := 0-1962.0724
422 , p5_a49 NUMBER := 0-1962.0724
423 , p5_a50 NUMBER := 0-1962.0724
424 , p5_a51 NUMBER := 0-1962.0724
425 , p5_a52 NUMBER := 0-1962.0724
426 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
427 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
428 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
429 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
430 , p5_a57 NUMBER := 0-1962.0724
431 , p5_a58 DATE := fnd_api.g_miss_date
432 , p5_a59 DATE := fnd_api.g_miss_date
433 , p5_a60 NUMBER := 0-1962.0724
434 )
435
436 as
437 ddp_tqlv_rec okl_txl_quote_lines_pub.tqlv_rec_type;
438 ddx_tqlv_rec okl_txl_quote_lines_pub.tqlv_rec_type;
439 ddindx binary_integer; indx binary_integer;
440 begin
441
442 -- copy data to the local IN or IN-OUT args, if any
443
444
445
446
447
448 ddp_tqlv_rec.id := rosetta_g_miss_num_map(p5_a0);
449 ddp_tqlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
450 ddp_tqlv_rec.sfwt_flag := p5_a2;
451 ddp_tqlv_rec.qlt_code := p5_a3;
452 ddp_tqlv_rec.kle_id := rosetta_g_miss_num_map(p5_a4);
453 ddp_tqlv_rec.sty_id := rosetta_g_miss_num_map(p5_a5);
454 ddp_tqlv_rec.qte_id := rosetta_g_miss_num_map(p5_a6);
455 ddp_tqlv_rec.line_number := rosetta_g_miss_num_map(p5_a7);
456 ddp_tqlv_rec.description := p5_a8;
457 ddp_tqlv_rec.amount := rosetta_g_miss_num_map(p5_a9);
458 ddp_tqlv_rec.modified_yn := p5_a10;
459 ddp_tqlv_rec.taxed_yn := p5_a11;
460 ddp_tqlv_rec.defaulted_yn := p5_a12;
461 ddp_tqlv_rec.attribute_category := p5_a13;
462 ddp_tqlv_rec.attribute1 := p5_a14;
463 ddp_tqlv_rec.attribute2 := p5_a15;
464 ddp_tqlv_rec.attribute3 := p5_a16;
465 ddp_tqlv_rec.attribute4 := p5_a17;
466 ddp_tqlv_rec.attribute5 := p5_a18;
467 ddp_tqlv_rec.attribute6 := p5_a19;
468 ddp_tqlv_rec.attribute7 := p5_a20;
469 ddp_tqlv_rec.attribute8 := p5_a21;
470 ddp_tqlv_rec.attribute9 := p5_a22;
471 ddp_tqlv_rec.attribute10 := p5_a23;
472 ddp_tqlv_rec.attribute11 := p5_a24;
473 ddp_tqlv_rec.attribute12 := p5_a25;
474 ddp_tqlv_rec.attribute13 := p5_a26;
475 ddp_tqlv_rec.attribute14 := p5_a27;
476 ddp_tqlv_rec.attribute15 := p5_a28;
477 ddp_tqlv_rec.org_id := rosetta_g_miss_num_map(p5_a29);
478 ddp_tqlv_rec.request_id := rosetta_g_miss_num_map(p5_a30);
479 ddp_tqlv_rec.program_application_id := rosetta_g_miss_num_map(p5_a31);
480 ddp_tqlv_rec.program_id := rosetta_g_miss_num_map(p5_a32);
481 ddp_tqlv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a33);
482 ddp_tqlv_rec.created_by := rosetta_g_miss_num_map(p5_a34);
483 ddp_tqlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a35);
484 ddp_tqlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a36);
485 ddp_tqlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a37);
486 ddp_tqlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a38);
487 ddp_tqlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a39);
488 ddp_tqlv_rec.period := p5_a40;
489 ddp_tqlv_rec.number_of_periods := rosetta_g_miss_num_map(p5_a41);
490 ddp_tqlv_rec.lock_level_step := p5_a42;
491 ddp_tqlv_rec.advance_or_arrears := p5_a43;
492 ddp_tqlv_rec.yield_name := p5_a44;
493 ddp_tqlv_rec.yield_value := rosetta_g_miss_num_map(p5_a45);
494 ddp_tqlv_rec.implicit_interest_rate := rosetta_g_miss_num_map(p5_a46);
495 ddp_tqlv_rec.asset_value := rosetta_g_miss_num_map(p5_a47);
496 ddp_tqlv_rec.residual_value := rosetta_g_miss_num_map(p5_a48);
497 ddp_tqlv_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a49);
498 ddp_tqlv_rec.asset_quantity := rosetta_g_miss_num_map(p5_a50);
499 ddp_tqlv_rec.quote_quantity := rosetta_g_miss_num_map(p5_a51);
500 ddp_tqlv_rec.split_kle_id := rosetta_g_miss_num_map(p5_a52);
501 ddp_tqlv_rec.split_kle_name := p5_a53;
502 ddp_tqlv_rec.currency_code := p5_a54;
503 ddp_tqlv_rec.currency_conversion_code := p5_a55;
504 ddp_tqlv_rec.currency_conversion_type := p5_a56;
505 ddp_tqlv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a57);
506 ddp_tqlv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a58);
507 ddp_tqlv_rec.due_date := rosetta_g_miss_date_in_map(p5_a59);
508 ddp_tqlv_rec.try_id := rosetta_g_miss_num_map(p5_a60);
509
510
511 -- here's the delegated call to the old PL/SQL routine
512 okl_txl_quote_lines_pub.insert_txl_quote_lines(p_api_version,
513 p_init_msg_list,
514 x_return_status,
515 x_msg_count,
516 x_msg_data,
517 ddp_tqlv_rec,
518 ddx_tqlv_rec);
519
520 -- copy data back from the local variables to OUT or IN-OUT args, if any
521
522
523
524
525
526
527 p6_a0 := rosetta_g_miss_num_map(ddx_tqlv_rec.id);
528 p6_a1 := rosetta_g_miss_num_map(ddx_tqlv_rec.object_version_number);
529 p6_a2 := ddx_tqlv_rec.sfwt_flag;
530 p6_a3 := ddx_tqlv_rec.qlt_code;
531 p6_a4 := rosetta_g_miss_num_map(ddx_tqlv_rec.kle_id);
532 p6_a5 := rosetta_g_miss_num_map(ddx_tqlv_rec.sty_id);
533 p6_a6 := rosetta_g_miss_num_map(ddx_tqlv_rec.qte_id);
534 p6_a7 := rosetta_g_miss_num_map(ddx_tqlv_rec.line_number);
535 p6_a8 := ddx_tqlv_rec.description;
536 p6_a9 := rosetta_g_miss_num_map(ddx_tqlv_rec.amount);
537 p6_a10 := ddx_tqlv_rec.modified_yn;
538 p6_a11 := ddx_tqlv_rec.taxed_yn;
539 p6_a12 := ddx_tqlv_rec.defaulted_yn;
540 p6_a13 := ddx_tqlv_rec.attribute_category;
541 p6_a14 := ddx_tqlv_rec.attribute1;
542 p6_a15 := ddx_tqlv_rec.attribute2;
543 p6_a16 := ddx_tqlv_rec.attribute3;
544 p6_a17 := ddx_tqlv_rec.attribute4;
545 p6_a18 := ddx_tqlv_rec.attribute5;
546 p6_a19 := ddx_tqlv_rec.attribute6;
547 p6_a20 := ddx_tqlv_rec.attribute7;
548 p6_a21 := ddx_tqlv_rec.attribute8;
549 p6_a22 := ddx_tqlv_rec.attribute9;
550 p6_a23 := ddx_tqlv_rec.attribute10;
551 p6_a24 := ddx_tqlv_rec.attribute11;
552 p6_a25 := ddx_tqlv_rec.attribute12;
553 p6_a26 := ddx_tqlv_rec.attribute13;
554 p6_a27 := ddx_tqlv_rec.attribute14;
555 p6_a28 := ddx_tqlv_rec.attribute15;
556 p6_a29 := rosetta_g_miss_num_map(ddx_tqlv_rec.org_id);
557 p6_a30 := rosetta_g_miss_num_map(ddx_tqlv_rec.request_id);
558 p6_a31 := rosetta_g_miss_num_map(ddx_tqlv_rec.program_application_id);
559 p6_a32 := rosetta_g_miss_num_map(ddx_tqlv_rec.program_id);
560 p6_a33 := ddx_tqlv_rec.program_update_date;
561 p6_a34 := rosetta_g_miss_num_map(ddx_tqlv_rec.created_by);
562 p6_a35 := ddx_tqlv_rec.creation_date;
563 p6_a36 := rosetta_g_miss_num_map(ddx_tqlv_rec.last_updated_by);
564 p6_a37 := ddx_tqlv_rec.last_update_date;
565 p6_a38 := rosetta_g_miss_num_map(ddx_tqlv_rec.last_update_login);
566 p6_a39 := ddx_tqlv_rec.start_date;
567 p6_a40 := ddx_tqlv_rec.period;
568 p6_a41 := rosetta_g_miss_num_map(ddx_tqlv_rec.number_of_periods);
569 p6_a42 := ddx_tqlv_rec.lock_level_step;
570 p6_a43 := ddx_tqlv_rec.advance_or_arrears;
571 p6_a44 := ddx_tqlv_rec.yield_name;
572 p6_a45 := rosetta_g_miss_num_map(ddx_tqlv_rec.yield_value);
573 p6_a46 := rosetta_g_miss_num_map(ddx_tqlv_rec.implicit_interest_rate);
574 p6_a47 := rosetta_g_miss_num_map(ddx_tqlv_rec.asset_value);
575 p6_a48 := rosetta_g_miss_num_map(ddx_tqlv_rec.residual_value);
576 p6_a49 := rosetta_g_miss_num_map(ddx_tqlv_rec.unbilled_receivables);
577 p6_a50 := rosetta_g_miss_num_map(ddx_tqlv_rec.asset_quantity);
578 p6_a51 := rosetta_g_miss_num_map(ddx_tqlv_rec.quote_quantity);
579 p6_a52 := rosetta_g_miss_num_map(ddx_tqlv_rec.split_kle_id);
580 p6_a53 := ddx_tqlv_rec.split_kle_name;
581 p6_a54 := ddx_tqlv_rec.currency_code;
582 p6_a55 := ddx_tqlv_rec.currency_conversion_code;
583 p6_a56 := ddx_tqlv_rec.currency_conversion_type;
584 p6_a57 := rosetta_g_miss_num_map(ddx_tqlv_rec.currency_conversion_rate);
585 p6_a58 := ddx_tqlv_rec.currency_conversion_date;
586 p6_a59 := ddx_tqlv_rec.due_date;
587 p6_a60 := rosetta_g_miss_num_map(ddx_tqlv_rec.try_id);
588 end;
589
590 procedure lock_txl_quote_lines(p_api_version NUMBER
591 , p_init_msg_list VARCHAR2
592 , x_return_status out nocopy VARCHAR2
593 , x_msg_count out nocopy NUMBER
594 , x_msg_data out nocopy VARCHAR2
595 , p5_a0 JTF_NUMBER_TABLE
596 , p5_a1 JTF_NUMBER_TABLE
597 , p5_a2 JTF_VARCHAR2_TABLE_100
598 , p5_a3 JTF_VARCHAR2_TABLE_100
599 , p5_a4 JTF_NUMBER_TABLE
600 , p5_a5 JTF_NUMBER_TABLE
601 , p5_a6 JTF_NUMBER_TABLE
602 , p5_a7 JTF_NUMBER_TABLE
603 , p5_a8 JTF_VARCHAR2_TABLE_2000
604 , p5_a9 JTF_NUMBER_TABLE
605 , p5_a10 JTF_VARCHAR2_TABLE_100
606 , p5_a11 JTF_VARCHAR2_TABLE_100
607 , p5_a12 JTF_VARCHAR2_TABLE_100
608 , p5_a13 JTF_VARCHAR2_TABLE_100
609 , p5_a14 JTF_VARCHAR2_TABLE_500
610 , p5_a15 JTF_VARCHAR2_TABLE_500
611 , p5_a16 JTF_VARCHAR2_TABLE_500
612 , p5_a17 JTF_VARCHAR2_TABLE_500
613 , p5_a18 JTF_VARCHAR2_TABLE_500
614 , p5_a19 JTF_VARCHAR2_TABLE_500
615 , p5_a20 JTF_VARCHAR2_TABLE_500
616 , p5_a21 JTF_VARCHAR2_TABLE_500
617 , p5_a22 JTF_VARCHAR2_TABLE_500
618 , p5_a23 JTF_VARCHAR2_TABLE_500
619 , p5_a24 JTF_VARCHAR2_TABLE_500
620 , p5_a25 JTF_VARCHAR2_TABLE_500
621 , p5_a26 JTF_VARCHAR2_TABLE_500
622 , p5_a27 JTF_VARCHAR2_TABLE_500
623 , p5_a28 JTF_VARCHAR2_TABLE_500
624 , p5_a29 JTF_NUMBER_TABLE
625 , p5_a30 JTF_NUMBER_TABLE
626 , p5_a31 JTF_NUMBER_TABLE
627 , p5_a32 JTF_NUMBER_TABLE
628 , p5_a33 JTF_DATE_TABLE
629 , p5_a34 JTF_NUMBER_TABLE
630 , p5_a35 JTF_DATE_TABLE
631 , p5_a36 JTF_NUMBER_TABLE
632 , p5_a37 JTF_DATE_TABLE
633 , p5_a38 JTF_NUMBER_TABLE
634 , p5_a39 JTF_DATE_TABLE
635 , p5_a40 JTF_VARCHAR2_TABLE_100
636 , p5_a41 JTF_NUMBER_TABLE
637 , p5_a42 JTF_VARCHAR2_TABLE_100
638 , p5_a43 JTF_VARCHAR2_TABLE_100
639 , p5_a44 JTF_VARCHAR2_TABLE_200
640 , p5_a45 JTF_NUMBER_TABLE
641 , p5_a46 JTF_NUMBER_TABLE
642 , p5_a47 JTF_NUMBER_TABLE
643 , p5_a48 JTF_NUMBER_TABLE
644 , p5_a49 JTF_NUMBER_TABLE
645 , p5_a50 JTF_NUMBER_TABLE
646 , p5_a51 JTF_NUMBER_TABLE
647 , p5_a52 JTF_NUMBER_TABLE
648 , p5_a53 JTF_VARCHAR2_TABLE_200
649 , p5_a54 JTF_VARCHAR2_TABLE_100
650 , p5_a55 JTF_VARCHAR2_TABLE_100
651 , p5_a56 JTF_VARCHAR2_TABLE_100
652 , p5_a57 JTF_NUMBER_TABLE
653 , p5_a58 JTF_DATE_TABLE
654 , p5_a59 JTF_DATE_TABLE
655 , p5_a60 JTF_NUMBER_TABLE
656 )
657
658 as
659 ddp_tqlv_tbl okl_txl_quote_lines_pub.tqlv_tbl_type;
660 ddindx binary_integer; indx binary_integer;
661 begin
662
663 -- copy data to the local IN or IN-OUT args, if any
664
665
666
667
668
669 okl_tql_pvt_w.rosetta_table_copy_in_p8(ddp_tqlv_tbl, p5_a0
670 , p5_a1
671 , p5_a2
672 , p5_a3
673 , p5_a4
674 , p5_a5
675 , p5_a6
676 , p5_a7
677 , p5_a8
678 , p5_a9
679 , p5_a10
680 , p5_a11
681 , p5_a12
682 , p5_a13
683 , p5_a14
684 , p5_a15
685 , p5_a16
686 , p5_a17
687 , p5_a18
688 , p5_a19
689 , p5_a20
690 , p5_a21
691 , p5_a22
692 , p5_a23
693 , p5_a24
694 , p5_a25
695 , p5_a26
696 , p5_a27
697 , p5_a28
698 , p5_a29
699 , p5_a30
700 , p5_a31
701 , p5_a32
702 , p5_a33
703 , p5_a34
704 , p5_a35
705 , p5_a36
706 , p5_a37
707 , p5_a38
708 , p5_a39
709 , p5_a40
710 , p5_a41
711 , p5_a42
712 , p5_a43
713 , p5_a44
714 , p5_a45
715 , p5_a46
716 , p5_a47
717 , p5_a48
718 , p5_a49
719 , p5_a50
720 , p5_a51
721 , p5_a52
722 , p5_a53
723 , p5_a54
724 , p5_a55
725 , p5_a56
726 , p5_a57
727 , p5_a58
728 , p5_a59
729 , p5_a60
730 );
731
732 -- here's the delegated call to the old PL/SQL routine
733 okl_txl_quote_lines_pub.lock_txl_quote_lines(p_api_version,
734 p_init_msg_list,
735 x_return_status,
736 x_msg_count,
737 x_msg_data,
738 ddp_tqlv_tbl);
739
740 -- copy data back from the local variables to OUT or IN-OUT args, if any
741
742
743
744
745
746 end;
747
748 procedure lock_txl_quote_lines(p_api_version NUMBER
749 , p_init_msg_list VARCHAR2
750 , x_return_status out nocopy VARCHAR2
751 , x_msg_count out nocopy NUMBER
752 , x_msg_data out nocopy VARCHAR2
753 , p5_a0 NUMBER := 0-1962.0724
754 , p5_a1 NUMBER := 0-1962.0724
755 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
756 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
757 , p5_a4 NUMBER := 0-1962.0724
758 , p5_a5 NUMBER := 0-1962.0724
759 , p5_a6 NUMBER := 0-1962.0724
760 , p5_a7 NUMBER := 0-1962.0724
761 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
762 , p5_a9 NUMBER := 0-1962.0724
763 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
764 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
765 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
766 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
767 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
768 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
769 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
770 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
771 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
772 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
773 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
774 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
775 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
776 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
777 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
778 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
779 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
780 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
781 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
782 , p5_a29 NUMBER := 0-1962.0724
783 , p5_a30 NUMBER := 0-1962.0724
784 , p5_a31 NUMBER := 0-1962.0724
785 , p5_a32 NUMBER := 0-1962.0724
786 , p5_a33 DATE := fnd_api.g_miss_date
787 , p5_a34 NUMBER := 0-1962.0724
788 , p5_a35 DATE := fnd_api.g_miss_date
789 , p5_a36 NUMBER := 0-1962.0724
790 , p5_a37 DATE := fnd_api.g_miss_date
791 , p5_a38 NUMBER := 0-1962.0724
792 , p5_a39 DATE := fnd_api.g_miss_date
793 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
794 , p5_a41 NUMBER := 0-1962.0724
795 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
796 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
797 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
798 , p5_a45 NUMBER := 0-1962.0724
799 , p5_a46 NUMBER := 0-1962.0724
800 , p5_a47 NUMBER := 0-1962.0724
801 , p5_a48 NUMBER := 0-1962.0724
802 , p5_a49 NUMBER := 0-1962.0724
803 , p5_a50 NUMBER := 0-1962.0724
804 , p5_a51 NUMBER := 0-1962.0724
805 , p5_a52 NUMBER := 0-1962.0724
806 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
807 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
808 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
809 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
810 , p5_a57 NUMBER := 0-1962.0724
811 , p5_a58 DATE := fnd_api.g_miss_date
812 , p5_a59 DATE := fnd_api.g_miss_date
813 , p5_a60 NUMBER := 0-1962.0724
814 )
815
816 as
817 ddp_tqlv_rec okl_txl_quote_lines_pub.tqlv_rec_type;
818 ddindx binary_integer; indx binary_integer;
819 begin
820
821 -- copy data to the local IN or IN-OUT args, if any
822
823
824
825
826
827 ddp_tqlv_rec.id := rosetta_g_miss_num_map(p5_a0);
828 ddp_tqlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
829 ddp_tqlv_rec.sfwt_flag := p5_a2;
830 ddp_tqlv_rec.qlt_code := p5_a3;
831 ddp_tqlv_rec.kle_id := rosetta_g_miss_num_map(p5_a4);
832 ddp_tqlv_rec.sty_id := rosetta_g_miss_num_map(p5_a5);
833 ddp_tqlv_rec.qte_id := rosetta_g_miss_num_map(p5_a6);
834 ddp_tqlv_rec.line_number := rosetta_g_miss_num_map(p5_a7);
835 ddp_tqlv_rec.description := p5_a8;
836 ddp_tqlv_rec.amount := rosetta_g_miss_num_map(p5_a9);
837 ddp_tqlv_rec.modified_yn := p5_a10;
838 ddp_tqlv_rec.taxed_yn := p5_a11;
839 ddp_tqlv_rec.defaulted_yn := p5_a12;
840 ddp_tqlv_rec.attribute_category := p5_a13;
841 ddp_tqlv_rec.attribute1 := p5_a14;
842 ddp_tqlv_rec.attribute2 := p5_a15;
843 ddp_tqlv_rec.attribute3 := p5_a16;
844 ddp_tqlv_rec.attribute4 := p5_a17;
845 ddp_tqlv_rec.attribute5 := p5_a18;
846 ddp_tqlv_rec.attribute6 := p5_a19;
847 ddp_tqlv_rec.attribute7 := p5_a20;
848 ddp_tqlv_rec.attribute8 := p5_a21;
849 ddp_tqlv_rec.attribute9 := p5_a22;
850 ddp_tqlv_rec.attribute10 := p5_a23;
851 ddp_tqlv_rec.attribute11 := p5_a24;
852 ddp_tqlv_rec.attribute12 := p5_a25;
853 ddp_tqlv_rec.attribute13 := p5_a26;
854 ddp_tqlv_rec.attribute14 := p5_a27;
855 ddp_tqlv_rec.attribute15 := p5_a28;
856 ddp_tqlv_rec.org_id := rosetta_g_miss_num_map(p5_a29);
857 ddp_tqlv_rec.request_id := rosetta_g_miss_num_map(p5_a30);
858 ddp_tqlv_rec.program_application_id := rosetta_g_miss_num_map(p5_a31);
859 ddp_tqlv_rec.program_id := rosetta_g_miss_num_map(p5_a32);
860 ddp_tqlv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a33);
861 ddp_tqlv_rec.created_by := rosetta_g_miss_num_map(p5_a34);
862 ddp_tqlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a35);
863 ddp_tqlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a36);
864 ddp_tqlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a37);
865 ddp_tqlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a38);
866 ddp_tqlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a39);
867 ddp_tqlv_rec.period := p5_a40;
868 ddp_tqlv_rec.number_of_periods := rosetta_g_miss_num_map(p5_a41);
869 ddp_tqlv_rec.lock_level_step := p5_a42;
870 ddp_tqlv_rec.advance_or_arrears := p5_a43;
871 ddp_tqlv_rec.yield_name := p5_a44;
872 ddp_tqlv_rec.yield_value := rosetta_g_miss_num_map(p5_a45);
873 ddp_tqlv_rec.implicit_interest_rate := rosetta_g_miss_num_map(p5_a46);
874 ddp_tqlv_rec.asset_value := rosetta_g_miss_num_map(p5_a47);
875 ddp_tqlv_rec.residual_value := rosetta_g_miss_num_map(p5_a48);
876 ddp_tqlv_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a49);
877 ddp_tqlv_rec.asset_quantity := rosetta_g_miss_num_map(p5_a50);
878 ddp_tqlv_rec.quote_quantity := rosetta_g_miss_num_map(p5_a51);
879 ddp_tqlv_rec.split_kle_id := rosetta_g_miss_num_map(p5_a52);
880 ddp_tqlv_rec.split_kle_name := p5_a53;
881 ddp_tqlv_rec.currency_code := p5_a54;
882 ddp_tqlv_rec.currency_conversion_code := p5_a55;
883 ddp_tqlv_rec.currency_conversion_type := p5_a56;
884 ddp_tqlv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a57);
885 ddp_tqlv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a58);
886 ddp_tqlv_rec.due_date := rosetta_g_miss_date_in_map(p5_a59);
887 ddp_tqlv_rec.try_id := rosetta_g_miss_num_map(p5_a60);
888
889 -- here's the delegated call to the old PL/SQL routine
890 okl_txl_quote_lines_pub.lock_txl_quote_lines(p_api_version,
891 p_init_msg_list,
892 x_return_status,
893 x_msg_count,
894 x_msg_data,
895 ddp_tqlv_rec);
896
897 -- copy data back from the local variables to OUT or IN-OUT args, if any
898
899
900
901
902
903 end;
904
905 procedure update_txl_quote_lines(p_api_version NUMBER
906 , p_init_msg_list VARCHAR2
907 , x_return_status out nocopy VARCHAR2
908 , x_msg_count out nocopy NUMBER
909 , x_msg_data out nocopy VARCHAR2
910 , p5_a0 JTF_NUMBER_TABLE
911 , p5_a1 JTF_NUMBER_TABLE
912 , p5_a2 JTF_VARCHAR2_TABLE_100
913 , p5_a3 JTF_VARCHAR2_TABLE_100
914 , p5_a4 JTF_NUMBER_TABLE
915 , p5_a5 JTF_NUMBER_TABLE
916 , p5_a6 JTF_NUMBER_TABLE
917 , p5_a7 JTF_NUMBER_TABLE
918 , p5_a8 JTF_VARCHAR2_TABLE_2000
919 , p5_a9 JTF_NUMBER_TABLE
920 , p5_a10 JTF_VARCHAR2_TABLE_100
921 , p5_a11 JTF_VARCHAR2_TABLE_100
922 , p5_a12 JTF_VARCHAR2_TABLE_100
923 , p5_a13 JTF_VARCHAR2_TABLE_100
924 , p5_a14 JTF_VARCHAR2_TABLE_500
925 , p5_a15 JTF_VARCHAR2_TABLE_500
926 , p5_a16 JTF_VARCHAR2_TABLE_500
927 , p5_a17 JTF_VARCHAR2_TABLE_500
928 , p5_a18 JTF_VARCHAR2_TABLE_500
929 , p5_a19 JTF_VARCHAR2_TABLE_500
930 , p5_a20 JTF_VARCHAR2_TABLE_500
931 , p5_a21 JTF_VARCHAR2_TABLE_500
932 , p5_a22 JTF_VARCHAR2_TABLE_500
933 , p5_a23 JTF_VARCHAR2_TABLE_500
934 , p5_a24 JTF_VARCHAR2_TABLE_500
935 , p5_a25 JTF_VARCHAR2_TABLE_500
936 , p5_a26 JTF_VARCHAR2_TABLE_500
937 , p5_a27 JTF_VARCHAR2_TABLE_500
938 , p5_a28 JTF_VARCHAR2_TABLE_500
939 , p5_a29 JTF_NUMBER_TABLE
940 , p5_a30 JTF_NUMBER_TABLE
941 , p5_a31 JTF_NUMBER_TABLE
942 , p5_a32 JTF_NUMBER_TABLE
943 , p5_a33 JTF_DATE_TABLE
944 , p5_a34 JTF_NUMBER_TABLE
945 , p5_a35 JTF_DATE_TABLE
946 , p5_a36 JTF_NUMBER_TABLE
947 , p5_a37 JTF_DATE_TABLE
948 , p5_a38 JTF_NUMBER_TABLE
949 , p5_a39 JTF_DATE_TABLE
950 , p5_a40 JTF_VARCHAR2_TABLE_100
951 , p5_a41 JTF_NUMBER_TABLE
952 , p5_a42 JTF_VARCHAR2_TABLE_100
953 , p5_a43 JTF_VARCHAR2_TABLE_100
954 , p5_a44 JTF_VARCHAR2_TABLE_200
955 , p5_a45 JTF_NUMBER_TABLE
956 , p5_a46 JTF_NUMBER_TABLE
957 , p5_a47 JTF_NUMBER_TABLE
958 , p5_a48 JTF_NUMBER_TABLE
959 , p5_a49 JTF_NUMBER_TABLE
960 , p5_a50 JTF_NUMBER_TABLE
961 , p5_a51 JTF_NUMBER_TABLE
962 , p5_a52 JTF_NUMBER_TABLE
963 , p5_a53 JTF_VARCHAR2_TABLE_200
964 , p5_a54 JTF_VARCHAR2_TABLE_100
965 , p5_a55 JTF_VARCHAR2_TABLE_100
966 , p5_a56 JTF_VARCHAR2_TABLE_100
967 , p5_a57 JTF_NUMBER_TABLE
968 , p5_a58 JTF_DATE_TABLE
969 , p5_a59 JTF_DATE_TABLE
970 , p5_a60 JTF_NUMBER_TABLE
971 , p6_a0 out nocopy JTF_NUMBER_TABLE
972 , p6_a1 out nocopy JTF_NUMBER_TABLE
973 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
974 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
975 , p6_a4 out nocopy JTF_NUMBER_TABLE
976 , p6_a5 out nocopy JTF_NUMBER_TABLE
977 , p6_a6 out nocopy JTF_NUMBER_TABLE
978 , p6_a7 out nocopy JTF_NUMBER_TABLE
979 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
980 , p6_a9 out nocopy JTF_NUMBER_TABLE
981 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
982 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
983 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
984 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
985 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
986 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
987 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
988 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
989 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
990 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
991 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
992 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
993 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
994 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
995 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
996 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
997 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
998 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
999 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1000 , p6_a29 out nocopy JTF_NUMBER_TABLE
1001 , p6_a30 out nocopy JTF_NUMBER_TABLE
1002 , p6_a31 out nocopy JTF_NUMBER_TABLE
1003 , p6_a32 out nocopy JTF_NUMBER_TABLE
1004 , p6_a33 out nocopy JTF_DATE_TABLE
1005 , p6_a34 out nocopy JTF_NUMBER_TABLE
1006 , p6_a35 out nocopy JTF_DATE_TABLE
1007 , p6_a36 out nocopy JTF_NUMBER_TABLE
1008 , p6_a37 out nocopy JTF_DATE_TABLE
1009 , p6_a38 out nocopy JTF_NUMBER_TABLE
1010 , p6_a39 out nocopy JTF_DATE_TABLE
1011 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1012 , p6_a41 out nocopy JTF_NUMBER_TABLE
1013 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1014 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1015 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_200
1016 , p6_a45 out nocopy JTF_NUMBER_TABLE
1017 , p6_a46 out nocopy JTF_NUMBER_TABLE
1018 , p6_a47 out nocopy JTF_NUMBER_TABLE
1019 , p6_a48 out nocopy JTF_NUMBER_TABLE
1020 , p6_a49 out nocopy JTF_NUMBER_TABLE
1021 , p6_a50 out nocopy JTF_NUMBER_TABLE
1022 , p6_a51 out nocopy JTF_NUMBER_TABLE
1023 , p6_a52 out nocopy JTF_NUMBER_TABLE
1024 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_200
1025 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
1026 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
1027 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
1028 , p6_a57 out nocopy JTF_NUMBER_TABLE
1029 , p6_a58 out nocopy JTF_DATE_TABLE
1030 , p6_a59 out nocopy JTF_DATE_TABLE
1031 , p6_a60 out nocopy JTF_NUMBER_TABLE
1032 )
1033
1034 as
1035 ddp_tqlv_tbl okl_txl_quote_lines_pub.tqlv_tbl_type;
1036 ddx_tqlv_tbl okl_txl_quote_lines_pub.tqlv_tbl_type;
1037 ddindx binary_integer; indx binary_integer;
1038 begin
1039
1040 -- copy data to the local IN or IN-OUT args, if any
1041
1042
1043
1044
1045
1046 okl_tql_pvt_w.rosetta_table_copy_in_p8(ddp_tqlv_tbl, p5_a0
1047 , p5_a1
1048 , p5_a2
1049 , p5_a3
1050 , p5_a4
1051 , p5_a5
1052 , p5_a6
1053 , p5_a7
1054 , p5_a8
1055 , p5_a9
1056 , p5_a10
1057 , p5_a11
1058 , p5_a12
1059 , p5_a13
1060 , p5_a14
1061 , p5_a15
1062 , p5_a16
1063 , p5_a17
1064 , p5_a18
1065 , p5_a19
1066 , p5_a20
1067 , p5_a21
1068 , p5_a22
1069 , p5_a23
1070 , p5_a24
1071 , p5_a25
1072 , p5_a26
1073 , p5_a27
1074 , p5_a28
1075 , p5_a29
1076 , p5_a30
1077 , p5_a31
1078 , p5_a32
1079 , p5_a33
1080 , p5_a34
1081 , p5_a35
1082 , p5_a36
1083 , p5_a37
1084 , p5_a38
1085 , p5_a39
1086 , p5_a40
1087 , p5_a41
1088 , p5_a42
1089 , p5_a43
1090 , p5_a44
1091 , p5_a45
1092 , p5_a46
1093 , p5_a47
1094 , p5_a48
1095 , p5_a49
1096 , p5_a50
1097 , p5_a51
1098 , p5_a52
1099 , p5_a53
1100 , p5_a54
1101 , p5_a55
1102 , p5_a56
1103 , p5_a57
1104 , p5_a58
1105 , p5_a59
1106 , p5_a60
1107 );
1108
1109
1110 -- here's the delegated call to the old PL/SQL routine
1111 okl_txl_quote_lines_pub.update_txl_quote_lines(p_api_version,
1112 p_init_msg_list,
1113 x_return_status,
1114 x_msg_count,
1115 x_msg_data,
1116 ddp_tqlv_tbl,
1117 ddx_tqlv_tbl);
1118
1119 -- copy data back from the local variables to OUT or IN-OUT args, if any
1120
1121
1122
1123
1124
1125
1126 okl_tql_pvt_w.rosetta_table_copy_out_p8(ddx_tqlv_tbl, p6_a0
1127 , p6_a1
1128 , p6_a2
1129 , p6_a3
1130 , p6_a4
1131 , p6_a5
1132 , p6_a6
1133 , p6_a7
1134 , p6_a8
1135 , p6_a9
1136 , p6_a10
1137 , p6_a11
1138 , p6_a12
1139 , p6_a13
1140 , p6_a14
1141 , p6_a15
1142 , p6_a16
1143 , p6_a17
1144 , p6_a18
1145 , p6_a19
1146 , p6_a20
1147 , p6_a21
1148 , p6_a22
1149 , p6_a23
1150 , p6_a24
1151 , p6_a25
1152 , p6_a26
1153 , p6_a27
1154 , p6_a28
1155 , p6_a29
1156 , p6_a30
1157 , p6_a31
1158 , p6_a32
1159 , p6_a33
1160 , p6_a34
1161 , p6_a35
1162 , p6_a36
1163 , p6_a37
1164 , p6_a38
1165 , p6_a39
1166 , p6_a40
1167 , p6_a41
1168 , p6_a42
1169 , p6_a43
1170 , p6_a44
1171 , p6_a45
1172 , p6_a46
1173 , p6_a47
1174 , p6_a48
1175 , p6_a49
1176 , p6_a50
1177 , p6_a51
1178 , p6_a52
1179 , p6_a53
1180 , p6_a54
1181 , p6_a55
1182 , p6_a56
1183 , p6_a57
1184 , p6_a58
1185 , p6_a59
1186 , p6_a60
1187 );
1188 end;
1189
1190 procedure update_txl_quote_lines(p_api_version NUMBER
1191 , p_init_msg_list VARCHAR2
1192 , x_return_status out nocopy VARCHAR2
1193 , x_msg_count out nocopy NUMBER
1194 , x_msg_data out nocopy VARCHAR2
1195 , p6_a0 out nocopy NUMBER
1196 , p6_a1 out nocopy NUMBER
1197 , p6_a2 out nocopy VARCHAR2
1198 , p6_a3 out nocopy VARCHAR2
1199 , p6_a4 out nocopy NUMBER
1200 , p6_a5 out nocopy NUMBER
1201 , p6_a6 out nocopy NUMBER
1202 , p6_a7 out nocopy NUMBER
1203 , p6_a8 out nocopy VARCHAR2
1204 , p6_a9 out nocopy NUMBER
1205 , p6_a10 out nocopy VARCHAR2
1206 , p6_a11 out nocopy VARCHAR2
1207 , p6_a12 out nocopy VARCHAR2
1208 , p6_a13 out nocopy VARCHAR2
1209 , p6_a14 out nocopy VARCHAR2
1210 , p6_a15 out nocopy VARCHAR2
1211 , p6_a16 out nocopy VARCHAR2
1212 , p6_a17 out nocopy VARCHAR2
1213 , p6_a18 out nocopy VARCHAR2
1214 , p6_a19 out nocopy VARCHAR2
1215 , p6_a20 out nocopy VARCHAR2
1216 , p6_a21 out nocopy VARCHAR2
1217 , p6_a22 out nocopy VARCHAR2
1218 , p6_a23 out nocopy VARCHAR2
1219 , p6_a24 out nocopy VARCHAR2
1220 , p6_a25 out nocopy VARCHAR2
1221 , p6_a26 out nocopy VARCHAR2
1222 , p6_a27 out nocopy VARCHAR2
1223 , p6_a28 out nocopy VARCHAR2
1224 , p6_a29 out nocopy NUMBER
1225 , p6_a30 out nocopy NUMBER
1226 , p6_a31 out nocopy NUMBER
1227 , p6_a32 out nocopy NUMBER
1228 , p6_a33 out nocopy DATE
1229 , p6_a34 out nocopy NUMBER
1230 , p6_a35 out nocopy DATE
1231 , p6_a36 out nocopy NUMBER
1232 , p6_a37 out nocopy DATE
1233 , p6_a38 out nocopy NUMBER
1234 , p6_a39 out nocopy DATE
1235 , p6_a40 out nocopy VARCHAR2
1236 , p6_a41 out nocopy NUMBER
1237 , p6_a42 out nocopy VARCHAR2
1238 , p6_a43 out nocopy VARCHAR2
1239 , p6_a44 out nocopy VARCHAR2
1240 , p6_a45 out nocopy NUMBER
1241 , p6_a46 out nocopy NUMBER
1242 , p6_a47 out nocopy NUMBER
1243 , p6_a48 out nocopy NUMBER
1244 , p6_a49 out nocopy NUMBER
1245 , p6_a50 out nocopy NUMBER
1246 , p6_a51 out nocopy NUMBER
1247 , p6_a52 out nocopy NUMBER
1248 , p6_a53 out nocopy VARCHAR2
1249 , p6_a54 out nocopy VARCHAR2
1250 , p6_a55 out nocopy VARCHAR2
1251 , p6_a56 out nocopy VARCHAR2
1252 , p6_a57 out nocopy NUMBER
1253 , p6_a58 out nocopy DATE
1254 , p6_a59 out nocopy DATE
1255 , p6_a60 out nocopy NUMBER
1256 , p5_a0 NUMBER := 0-1962.0724
1257 , p5_a1 NUMBER := 0-1962.0724
1258 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1259 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1260 , p5_a4 NUMBER := 0-1962.0724
1261 , p5_a5 NUMBER := 0-1962.0724
1262 , p5_a6 NUMBER := 0-1962.0724
1263 , p5_a7 NUMBER := 0-1962.0724
1264 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1265 , p5_a9 NUMBER := 0-1962.0724
1266 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1267 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1268 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1269 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1270 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1271 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1272 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1273 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1274 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1275 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1276 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1277 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1278 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1279 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1280 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1281 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1282 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1283 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1284 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1285 , p5_a29 NUMBER := 0-1962.0724
1286 , p5_a30 NUMBER := 0-1962.0724
1287 , p5_a31 NUMBER := 0-1962.0724
1288 , p5_a32 NUMBER := 0-1962.0724
1289 , p5_a33 DATE := fnd_api.g_miss_date
1290 , p5_a34 NUMBER := 0-1962.0724
1291 , p5_a35 DATE := fnd_api.g_miss_date
1292 , p5_a36 NUMBER := 0-1962.0724
1293 , p5_a37 DATE := fnd_api.g_miss_date
1294 , p5_a38 NUMBER := 0-1962.0724
1295 , p5_a39 DATE := fnd_api.g_miss_date
1296 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1297 , p5_a41 NUMBER := 0-1962.0724
1298 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1299 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1300 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1301 , p5_a45 NUMBER := 0-1962.0724
1302 , p5_a46 NUMBER := 0-1962.0724
1303 , p5_a47 NUMBER := 0-1962.0724
1304 , p5_a48 NUMBER := 0-1962.0724
1305 , p5_a49 NUMBER := 0-1962.0724
1306 , p5_a50 NUMBER := 0-1962.0724
1307 , p5_a51 NUMBER := 0-1962.0724
1308 , p5_a52 NUMBER := 0-1962.0724
1309 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1310 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1311 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1312 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
1313 , p5_a57 NUMBER := 0-1962.0724
1314 , p5_a58 DATE := fnd_api.g_miss_date
1315 , p5_a59 DATE := fnd_api.g_miss_date
1316 , p5_a60 NUMBER := 0-1962.0724
1317 )
1318
1319 as
1320 ddp_tqlv_rec okl_txl_quote_lines_pub.tqlv_rec_type;
1321 ddx_tqlv_rec okl_txl_quote_lines_pub.tqlv_rec_type;
1322 ddindx binary_integer; indx binary_integer;
1323 begin
1324
1325 -- copy data to the local IN or IN-OUT args, if any
1326
1327
1328
1329
1330
1331 ddp_tqlv_rec.id := rosetta_g_miss_num_map(p5_a0);
1332 ddp_tqlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1333 ddp_tqlv_rec.sfwt_flag := p5_a2;
1334 ddp_tqlv_rec.qlt_code := p5_a3;
1335 ddp_tqlv_rec.kle_id := rosetta_g_miss_num_map(p5_a4);
1336 ddp_tqlv_rec.sty_id := rosetta_g_miss_num_map(p5_a5);
1337 ddp_tqlv_rec.qte_id := rosetta_g_miss_num_map(p5_a6);
1338 ddp_tqlv_rec.line_number := rosetta_g_miss_num_map(p5_a7);
1339 ddp_tqlv_rec.description := p5_a8;
1340 ddp_tqlv_rec.amount := rosetta_g_miss_num_map(p5_a9);
1341 ddp_tqlv_rec.modified_yn := p5_a10;
1342 ddp_tqlv_rec.taxed_yn := p5_a11;
1343 ddp_tqlv_rec.defaulted_yn := p5_a12;
1344 ddp_tqlv_rec.attribute_category := p5_a13;
1345 ddp_tqlv_rec.attribute1 := p5_a14;
1346 ddp_tqlv_rec.attribute2 := p5_a15;
1347 ddp_tqlv_rec.attribute3 := p5_a16;
1348 ddp_tqlv_rec.attribute4 := p5_a17;
1349 ddp_tqlv_rec.attribute5 := p5_a18;
1350 ddp_tqlv_rec.attribute6 := p5_a19;
1351 ddp_tqlv_rec.attribute7 := p5_a20;
1352 ddp_tqlv_rec.attribute8 := p5_a21;
1353 ddp_tqlv_rec.attribute9 := p5_a22;
1354 ddp_tqlv_rec.attribute10 := p5_a23;
1355 ddp_tqlv_rec.attribute11 := p5_a24;
1356 ddp_tqlv_rec.attribute12 := p5_a25;
1357 ddp_tqlv_rec.attribute13 := p5_a26;
1358 ddp_tqlv_rec.attribute14 := p5_a27;
1359 ddp_tqlv_rec.attribute15 := p5_a28;
1360 ddp_tqlv_rec.org_id := rosetta_g_miss_num_map(p5_a29);
1361 ddp_tqlv_rec.request_id := rosetta_g_miss_num_map(p5_a30);
1362 ddp_tqlv_rec.program_application_id := rosetta_g_miss_num_map(p5_a31);
1363 ddp_tqlv_rec.program_id := rosetta_g_miss_num_map(p5_a32);
1364 ddp_tqlv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a33);
1365 ddp_tqlv_rec.created_by := rosetta_g_miss_num_map(p5_a34);
1366 ddp_tqlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a35);
1367 ddp_tqlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a36);
1368 ddp_tqlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a37);
1369 ddp_tqlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a38);
1370 ddp_tqlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a39);
1371 ddp_tqlv_rec.period := p5_a40;
1372 ddp_tqlv_rec.number_of_periods := rosetta_g_miss_num_map(p5_a41);
1373 ddp_tqlv_rec.lock_level_step := p5_a42;
1374 ddp_tqlv_rec.advance_or_arrears := p5_a43;
1375 ddp_tqlv_rec.yield_name := p5_a44;
1376 ddp_tqlv_rec.yield_value := rosetta_g_miss_num_map(p5_a45);
1377 ddp_tqlv_rec.implicit_interest_rate := rosetta_g_miss_num_map(p5_a46);
1378 ddp_tqlv_rec.asset_value := rosetta_g_miss_num_map(p5_a47);
1379 ddp_tqlv_rec.residual_value := rosetta_g_miss_num_map(p5_a48);
1380 ddp_tqlv_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a49);
1381 ddp_tqlv_rec.asset_quantity := rosetta_g_miss_num_map(p5_a50);
1382 ddp_tqlv_rec.quote_quantity := rosetta_g_miss_num_map(p5_a51);
1383 ddp_tqlv_rec.split_kle_id := rosetta_g_miss_num_map(p5_a52);
1384 ddp_tqlv_rec.split_kle_name := p5_a53;
1385 ddp_tqlv_rec.currency_code := p5_a54;
1386 ddp_tqlv_rec.currency_conversion_code := p5_a55;
1387 ddp_tqlv_rec.currency_conversion_type := p5_a56;
1388 ddp_tqlv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a57);
1389 ddp_tqlv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a58);
1390 ddp_tqlv_rec.due_date := rosetta_g_miss_date_in_map(p5_a59);
1391 ddp_tqlv_rec.try_id := rosetta_g_miss_num_map(p5_a60);
1392
1393
1394 -- here's the delegated call to the old PL/SQL routine
1395 okl_txl_quote_lines_pub.update_txl_quote_lines(p_api_version,
1396 p_init_msg_list,
1397 x_return_status,
1398 x_msg_count,
1399 x_msg_data,
1400 ddp_tqlv_rec,
1401 ddx_tqlv_rec);
1402
1403 -- copy data back from the local variables to OUT or IN-OUT args, if any
1404
1405
1406
1407
1408
1409
1410 p6_a0 := rosetta_g_miss_num_map(ddx_tqlv_rec.id);
1411 p6_a1 := rosetta_g_miss_num_map(ddx_tqlv_rec.object_version_number);
1412 p6_a2 := ddx_tqlv_rec.sfwt_flag;
1413 p6_a3 := ddx_tqlv_rec.qlt_code;
1414 p6_a4 := rosetta_g_miss_num_map(ddx_tqlv_rec.kle_id);
1415 p6_a5 := rosetta_g_miss_num_map(ddx_tqlv_rec.sty_id);
1416 p6_a6 := rosetta_g_miss_num_map(ddx_tqlv_rec.qte_id);
1417 p6_a7 := rosetta_g_miss_num_map(ddx_tqlv_rec.line_number);
1418 p6_a8 := ddx_tqlv_rec.description;
1419 p6_a9 := rosetta_g_miss_num_map(ddx_tqlv_rec.amount);
1420 p6_a10 := ddx_tqlv_rec.modified_yn;
1421 p6_a11 := ddx_tqlv_rec.taxed_yn;
1422 p6_a12 := ddx_tqlv_rec.defaulted_yn;
1423 p6_a13 := ddx_tqlv_rec.attribute_category;
1424 p6_a14 := ddx_tqlv_rec.attribute1;
1425 p6_a15 := ddx_tqlv_rec.attribute2;
1426 p6_a16 := ddx_tqlv_rec.attribute3;
1427 p6_a17 := ddx_tqlv_rec.attribute4;
1428 p6_a18 := ddx_tqlv_rec.attribute5;
1429 p6_a19 := ddx_tqlv_rec.attribute6;
1430 p6_a20 := ddx_tqlv_rec.attribute7;
1431 p6_a21 := ddx_tqlv_rec.attribute8;
1432 p6_a22 := ddx_tqlv_rec.attribute9;
1433 p6_a23 := ddx_tqlv_rec.attribute10;
1434 p6_a24 := ddx_tqlv_rec.attribute11;
1435 p6_a25 := ddx_tqlv_rec.attribute12;
1436 p6_a26 := ddx_tqlv_rec.attribute13;
1437 p6_a27 := ddx_tqlv_rec.attribute14;
1438 p6_a28 := ddx_tqlv_rec.attribute15;
1439 p6_a29 := rosetta_g_miss_num_map(ddx_tqlv_rec.org_id);
1440 p6_a30 := rosetta_g_miss_num_map(ddx_tqlv_rec.request_id);
1441 p6_a31 := rosetta_g_miss_num_map(ddx_tqlv_rec.program_application_id);
1442 p6_a32 := rosetta_g_miss_num_map(ddx_tqlv_rec.program_id);
1443 p6_a33 := ddx_tqlv_rec.program_update_date;
1444 p6_a34 := rosetta_g_miss_num_map(ddx_tqlv_rec.created_by);
1445 p6_a35 := ddx_tqlv_rec.creation_date;
1446 p6_a36 := rosetta_g_miss_num_map(ddx_tqlv_rec.last_updated_by);
1447 p6_a37 := ddx_tqlv_rec.last_update_date;
1448 p6_a38 := rosetta_g_miss_num_map(ddx_tqlv_rec.last_update_login);
1449 p6_a39 := ddx_tqlv_rec.start_date;
1450 p6_a40 := ddx_tqlv_rec.period;
1451 p6_a41 := rosetta_g_miss_num_map(ddx_tqlv_rec.number_of_periods);
1452 p6_a42 := ddx_tqlv_rec.lock_level_step;
1453 p6_a43 := ddx_tqlv_rec.advance_or_arrears;
1454 p6_a44 := ddx_tqlv_rec.yield_name;
1455 p6_a45 := rosetta_g_miss_num_map(ddx_tqlv_rec.yield_value);
1456 p6_a46 := rosetta_g_miss_num_map(ddx_tqlv_rec.implicit_interest_rate);
1457 p6_a47 := rosetta_g_miss_num_map(ddx_tqlv_rec.asset_value);
1458 p6_a48 := rosetta_g_miss_num_map(ddx_tqlv_rec.residual_value);
1459 p6_a49 := rosetta_g_miss_num_map(ddx_tqlv_rec.unbilled_receivables);
1460 p6_a50 := rosetta_g_miss_num_map(ddx_tqlv_rec.asset_quantity);
1461 p6_a51 := rosetta_g_miss_num_map(ddx_tqlv_rec.quote_quantity);
1462 p6_a52 := rosetta_g_miss_num_map(ddx_tqlv_rec.split_kle_id);
1463 p6_a53 := ddx_tqlv_rec.split_kle_name;
1464 p6_a54 := ddx_tqlv_rec.currency_code;
1465 p6_a55 := ddx_tqlv_rec.currency_conversion_code;
1466 p6_a56 := ddx_tqlv_rec.currency_conversion_type;
1467 p6_a57 := rosetta_g_miss_num_map(ddx_tqlv_rec.currency_conversion_rate);
1468 p6_a58 := ddx_tqlv_rec.currency_conversion_date;
1469 p6_a59 := ddx_tqlv_rec.due_date;
1470 p6_a60 := rosetta_g_miss_num_map(ddx_tqlv_rec.try_id);
1471 end;
1472
1473 procedure delete_txl_quote_lines(p_api_version NUMBER
1474 , p_init_msg_list VARCHAR2
1475 , x_return_status out nocopy VARCHAR2
1476 , x_msg_count out nocopy NUMBER
1477 , x_msg_data out nocopy VARCHAR2
1478 , p5_a0 JTF_NUMBER_TABLE
1479 , p5_a1 JTF_NUMBER_TABLE
1480 , p5_a2 JTF_VARCHAR2_TABLE_100
1481 , p5_a3 JTF_VARCHAR2_TABLE_100
1482 , p5_a4 JTF_NUMBER_TABLE
1483 , p5_a5 JTF_NUMBER_TABLE
1484 , p5_a6 JTF_NUMBER_TABLE
1485 , p5_a7 JTF_NUMBER_TABLE
1486 , p5_a8 JTF_VARCHAR2_TABLE_2000
1487 , p5_a9 JTF_NUMBER_TABLE
1488 , p5_a10 JTF_VARCHAR2_TABLE_100
1489 , p5_a11 JTF_VARCHAR2_TABLE_100
1490 , p5_a12 JTF_VARCHAR2_TABLE_100
1491 , p5_a13 JTF_VARCHAR2_TABLE_100
1492 , p5_a14 JTF_VARCHAR2_TABLE_500
1493 , p5_a15 JTF_VARCHAR2_TABLE_500
1494 , p5_a16 JTF_VARCHAR2_TABLE_500
1495 , p5_a17 JTF_VARCHAR2_TABLE_500
1496 , p5_a18 JTF_VARCHAR2_TABLE_500
1497 , p5_a19 JTF_VARCHAR2_TABLE_500
1498 , p5_a20 JTF_VARCHAR2_TABLE_500
1499 , p5_a21 JTF_VARCHAR2_TABLE_500
1500 , p5_a22 JTF_VARCHAR2_TABLE_500
1501 , p5_a23 JTF_VARCHAR2_TABLE_500
1502 , p5_a24 JTF_VARCHAR2_TABLE_500
1503 , p5_a25 JTF_VARCHAR2_TABLE_500
1504 , p5_a26 JTF_VARCHAR2_TABLE_500
1505 , p5_a27 JTF_VARCHAR2_TABLE_500
1506 , p5_a28 JTF_VARCHAR2_TABLE_500
1507 , p5_a29 JTF_NUMBER_TABLE
1508 , p5_a30 JTF_NUMBER_TABLE
1509 , p5_a31 JTF_NUMBER_TABLE
1510 , p5_a32 JTF_NUMBER_TABLE
1511 , p5_a33 JTF_DATE_TABLE
1512 , p5_a34 JTF_NUMBER_TABLE
1513 , p5_a35 JTF_DATE_TABLE
1514 , p5_a36 JTF_NUMBER_TABLE
1515 , p5_a37 JTF_DATE_TABLE
1516 , p5_a38 JTF_NUMBER_TABLE
1517 , p5_a39 JTF_DATE_TABLE
1518 , p5_a40 JTF_VARCHAR2_TABLE_100
1519 , p5_a41 JTF_NUMBER_TABLE
1520 , p5_a42 JTF_VARCHAR2_TABLE_100
1521 , p5_a43 JTF_VARCHAR2_TABLE_100
1522 , p5_a44 JTF_VARCHAR2_TABLE_200
1523 , p5_a45 JTF_NUMBER_TABLE
1524 , p5_a46 JTF_NUMBER_TABLE
1525 , p5_a47 JTF_NUMBER_TABLE
1526 , p5_a48 JTF_NUMBER_TABLE
1527 , p5_a49 JTF_NUMBER_TABLE
1528 , p5_a50 JTF_NUMBER_TABLE
1529 , p5_a51 JTF_NUMBER_TABLE
1530 , p5_a52 JTF_NUMBER_TABLE
1531 , p5_a53 JTF_VARCHAR2_TABLE_200
1532 , p5_a54 JTF_VARCHAR2_TABLE_100
1533 , p5_a55 JTF_VARCHAR2_TABLE_100
1534 , p5_a56 JTF_VARCHAR2_TABLE_100
1535 , p5_a57 JTF_NUMBER_TABLE
1536 , p5_a58 JTF_DATE_TABLE
1537 , p5_a59 JTF_DATE_TABLE
1538 , p5_a60 JTF_NUMBER_TABLE
1539 )
1540
1541 as
1542 ddp_tqlv_tbl okl_txl_quote_lines_pub.tqlv_tbl_type;
1543 ddindx binary_integer; indx binary_integer;
1544 begin
1545
1546 -- copy data to the local IN or IN-OUT args, if any
1547
1548
1549
1550
1551
1552 okl_tql_pvt_w.rosetta_table_copy_in_p8(ddp_tqlv_tbl, p5_a0
1553 , p5_a1
1554 , p5_a2
1555 , p5_a3
1556 , p5_a4
1557 , p5_a5
1558 , p5_a6
1559 , p5_a7
1560 , p5_a8
1561 , p5_a9
1562 , p5_a10
1563 , p5_a11
1564 , p5_a12
1565 , p5_a13
1566 , p5_a14
1567 , p5_a15
1568 , p5_a16
1569 , p5_a17
1570 , p5_a18
1571 , p5_a19
1572 , p5_a20
1573 , p5_a21
1574 , p5_a22
1575 , p5_a23
1576 , p5_a24
1577 , p5_a25
1578 , p5_a26
1579 , p5_a27
1580 , p5_a28
1581 , p5_a29
1582 , p5_a30
1583 , p5_a31
1584 , p5_a32
1585 , p5_a33
1586 , p5_a34
1587 , p5_a35
1588 , p5_a36
1589 , p5_a37
1590 , p5_a38
1591 , p5_a39
1592 , p5_a40
1593 , p5_a41
1594 , p5_a42
1595 , p5_a43
1596 , p5_a44
1597 , p5_a45
1598 , p5_a46
1599 , p5_a47
1600 , p5_a48
1601 , p5_a49
1602 , p5_a50
1603 , p5_a51
1604 , p5_a52
1605 , p5_a53
1606 , p5_a54
1607 , p5_a55
1608 , p5_a56
1609 , p5_a57
1610 , p5_a58
1611 , p5_a59
1612 , p5_a60
1613 );
1614
1615 -- here's the delegated call to the old PL/SQL routine
1616 okl_txl_quote_lines_pub.delete_txl_quote_lines(p_api_version,
1617 p_init_msg_list,
1618 x_return_status,
1619 x_msg_count,
1620 x_msg_data,
1621 ddp_tqlv_tbl);
1622
1623 -- copy data back from the local variables to OUT or IN-OUT args, if any
1624
1625
1626
1627
1628
1629 end;
1630
1631 procedure delete_txl_quote_lines(p_api_version NUMBER
1632 , p_init_msg_list VARCHAR2
1633 , x_return_status out nocopy VARCHAR2
1634 , x_msg_count out nocopy NUMBER
1635 , x_msg_data out nocopy VARCHAR2
1636 , p5_a0 NUMBER := 0-1962.0724
1637 , p5_a1 NUMBER := 0-1962.0724
1638 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1639 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1640 , p5_a4 NUMBER := 0-1962.0724
1641 , p5_a5 NUMBER := 0-1962.0724
1642 , p5_a6 NUMBER := 0-1962.0724
1643 , p5_a7 NUMBER := 0-1962.0724
1644 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1645 , p5_a9 NUMBER := 0-1962.0724
1646 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1647 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1648 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1649 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1650 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1651 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1652 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1653 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1654 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1655 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1656 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1657 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1658 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1659 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1660 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1661 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1662 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1663 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1664 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1665 , p5_a29 NUMBER := 0-1962.0724
1666 , p5_a30 NUMBER := 0-1962.0724
1667 , p5_a31 NUMBER := 0-1962.0724
1668 , p5_a32 NUMBER := 0-1962.0724
1669 , p5_a33 DATE := fnd_api.g_miss_date
1670 , p5_a34 NUMBER := 0-1962.0724
1671 , p5_a35 DATE := fnd_api.g_miss_date
1672 , p5_a36 NUMBER := 0-1962.0724
1673 , p5_a37 DATE := fnd_api.g_miss_date
1674 , p5_a38 NUMBER := 0-1962.0724
1675 , p5_a39 DATE := fnd_api.g_miss_date
1676 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1677 , p5_a41 NUMBER := 0-1962.0724
1678 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1679 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1680 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1681 , p5_a45 NUMBER := 0-1962.0724
1682 , p5_a46 NUMBER := 0-1962.0724
1683 , p5_a47 NUMBER := 0-1962.0724
1684 , p5_a48 NUMBER := 0-1962.0724
1685 , p5_a49 NUMBER := 0-1962.0724
1686 , p5_a50 NUMBER := 0-1962.0724
1687 , p5_a51 NUMBER := 0-1962.0724
1688 , p5_a52 NUMBER := 0-1962.0724
1689 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1690 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1691 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1692 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
1693 , p5_a57 NUMBER := 0-1962.0724
1694 , p5_a58 DATE := fnd_api.g_miss_date
1695 , p5_a59 DATE := fnd_api.g_miss_date
1696 , p5_a60 NUMBER := 0-1962.0724
1697 )
1698
1699 as
1700 ddp_tqlv_rec okl_txl_quote_lines_pub.tqlv_rec_type;
1701 ddindx binary_integer; indx binary_integer;
1702 begin
1703
1704 -- copy data to the local IN or IN-OUT args, if any
1705
1706
1707
1708
1709
1710 ddp_tqlv_rec.id := rosetta_g_miss_num_map(p5_a0);
1711 ddp_tqlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1712 ddp_tqlv_rec.sfwt_flag := p5_a2;
1713 ddp_tqlv_rec.qlt_code := p5_a3;
1714 ddp_tqlv_rec.kle_id := rosetta_g_miss_num_map(p5_a4);
1715 ddp_tqlv_rec.sty_id := rosetta_g_miss_num_map(p5_a5);
1716 ddp_tqlv_rec.qte_id := rosetta_g_miss_num_map(p5_a6);
1717 ddp_tqlv_rec.line_number := rosetta_g_miss_num_map(p5_a7);
1718 ddp_tqlv_rec.description := p5_a8;
1719 ddp_tqlv_rec.amount := rosetta_g_miss_num_map(p5_a9);
1720 ddp_tqlv_rec.modified_yn := p5_a10;
1721 ddp_tqlv_rec.taxed_yn := p5_a11;
1722 ddp_tqlv_rec.defaulted_yn := p5_a12;
1723 ddp_tqlv_rec.attribute_category := p5_a13;
1724 ddp_tqlv_rec.attribute1 := p5_a14;
1725 ddp_tqlv_rec.attribute2 := p5_a15;
1726 ddp_tqlv_rec.attribute3 := p5_a16;
1727 ddp_tqlv_rec.attribute4 := p5_a17;
1728 ddp_tqlv_rec.attribute5 := p5_a18;
1729 ddp_tqlv_rec.attribute6 := p5_a19;
1730 ddp_tqlv_rec.attribute7 := p5_a20;
1731 ddp_tqlv_rec.attribute8 := p5_a21;
1732 ddp_tqlv_rec.attribute9 := p5_a22;
1733 ddp_tqlv_rec.attribute10 := p5_a23;
1734 ddp_tqlv_rec.attribute11 := p5_a24;
1735 ddp_tqlv_rec.attribute12 := p5_a25;
1736 ddp_tqlv_rec.attribute13 := p5_a26;
1737 ddp_tqlv_rec.attribute14 := p5_a27;
1738 ddp_tqlv_rec.attribute15 := p5_a28;
1739 ddp_tqlv_rec.org_id := rosetta_g_miss_num_map(p5_a29);
1740 ddp_tqlv_rec.request_id := rosetta_g_miss_num_map(p5_a30);
1741 ddp_tqlv_rec.program_application_id := rosetta_g_miss_num_map(p5_a31);
1742 ddp_tqlv_rec.program_id := rosetta_g_miss_num_map(p5_a32);
1743 ddp_tqlv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a33);
1744 ddp_tqlv_rec.created_by := rosetta_g_miss_num_map(p5_a34);
1745 ddp_tqlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a35);
1746 ddp_tqlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a36);
1747 ddp_tqlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a37);
1748 ddp_tqlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a38);
1749 ddp_tqlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a39);
1750 ddp_tqlv_rec.period := p5_a40;
1751 ddp_tqlv_rec.number_of_periods := rosetta_g_miss_num_map(p5_a41);
1752 ddp_tqlv_rec.lock_level_step := p5_a42;
1753 ddp_tqlv_rec.advance_or_arrears := p5_a43;
1754 ddp_tqlv_rec.yield_name := p5_a44;
1755 ddp_tqlv_rec.yield_value := rosetta_g_miss_num_map(p5_a45);
1756 ddp_tqlv_rec.implicit_interest_rate := rosetta_g_miss_num_map(p5_a46);
1757 ddp_tqlv_rec.asset_value := rosetta_g_miss_num_map(p5_a47);
1758 ddp_tqlv_rec.residual_value := rosetta_g_miss_num_map(p5_a48);
1759 ddp_tqlv_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a49);
1760 ddp_tqlv_rec.asset_quantity := rosetta_g_miss_num_map(p5_a50);
1761 ddp_tqlv_rec.quote_quantity := rosetta_g_miss_num_map(p5_a51);
1762 ddp_tqlv_rec.split_kle_id := rosetta_g_miss_num_map(p5_a52);
1763 ddp_tqlv_rec.split_kle_name := p5_a53;
1764 ddp_tqlv_rec.currency_code := p5_a54;
1765 ddp_tqlv_rec.currency_conversion_code := p5_a55;
1766 ddp_tqlv_rec.currency_conversion_type := p5_a56;
1767 ddp_tqlv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a57);
1768 ddp_tqlv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a58);
1769 ddp_tqlv_rec.due_date := rosetta_g_miss_date_in_map(p5_a59);
1770 ddp_tqlv_rec.try_id := rosetta_g_miss_num_map(p5_a60);
1771
1772 -- here's the delegated call to the old PL/SQL routine
1773 okl_txl_quote_lines_pub.delete_txl_quote_lines(p_api_version,
1774 p_init_msg_list,
1775 x_return_status,
1776 x_msg_count,
1777 x_msg_data,
1778 ddp_tqlv_rec);
1779
1780 -- copy data back from the local variables to OUT or IN-OUT args, if any
1781
1782
1783
1784
1785
1786 end;
1787
1788 procedure validate_txl_quote_lines(p_api_version NUMBER
1789 , p_init_msg_list VARCHAR2
1790 , x_return_status out nocopy VARCHAR2
1791 , x_msg_count out nocopy NUMBER
1792 , x_msg_data out nocopy VARCHAR2
1793 , p5_a0 JTF_NUMBER_TABLE
1794 , p5_a1 JTF_NUMBER_TABLE
1795 , p5_a2 JTF_VARCHAR2_TABLE_100
1796 , p5_a3 JTF_VARCHAR2_TABLE_100
1797 , p5_a4 JTF_NUMBER_TABLE
1798 , p5_a5 JTF_NUMBER_TABLE
1799 , p5_a6 JTF_NUMBER_TABLE
1800 , p5_a7 JTF_NUMBER_TABLE
1801 , p5_a8 JTF_VARCHAR2_TABLE_2000
1802 , p5_a9 JTF_NUMBER_TABLE
1803 , p5_a10 JTF_VARCHAR2_TABLE_100
1804 , p5_a11 JTF_VARCHAR2_TABLE_100
1805 , p5_a12 JTF_VARCHAR2_TABLE_100
1806 , p5_a13 JTF_VARCHAR2_TABLE_100
1807 , p5_a14 JTF_VARCHAR2_TABLE_500
1808 , p5_a15 JTF_VARCHAR2_TABLE_500
1809 , p5_a16 JTF_VARCHAR2_TABLE_500
1810 , p5_a17 JTF_VARCHAR2_TABLE_500
1811 , p5_a18 JTF_VARCHAR2_TABLE_500
1812 , p5_a19 JTF_VARCHAR2_TABLE_500
1813 , p5_a20 JTF_VARCHAR2_TABLE_500
1814 , p5_a21 JTF_VARCHAR2_TABLE_500
1815 , p5_a22 JTF_VARCHAR2_TABLE_500
1816 , p5_a23 JTF_VARCHAR2_TABLE_500
1817 , p5_a24 JTF_VARCHAR2_TABLE_500
1818 , p5_a25 JTF_VARCHAR2_TABLE_500
1819 , p5_a26 JTF_VARCHAR2_TABLE_500
1820 , p5_a27 JTF_VARCHAR2_TABLE_500
1821 , p5_a28 JTF_VARCHAR2_TABLE_500
1822 , p5_a29 JTF_NUMBER_TABLE
1823 , p5_a30 JTF_NUMBER_TABLE
1824 , p5_a31 JTF_NUMBER_TABLE
1825 , p5_a32 JTF_NUMBER_TABLE
1826 , p5_a33 JTF_DATE_TABLE
1827 , p5_a34 JTF_NUMBER_TABLE
1828 , p5_a35 JTF_DATE_TABLE
1829 , p5_a36 JTF_NUMBER_TABLE
1830 , p5_a37 JTF_DATE_TABLE
1831 , p5_a38 JTF_NUMBER_TABLE
1832 , p5_a39 JTF_DATE_TABLE
1833 , p5_a40 JTF_VARCHAR2_TABLE_100
1834 , p5_a41 JTF_NUMBER_TABLE
1835 , p5_a42 JTF_VARCHAR2_TABLE_100
1836 , p5_a43 JTF_VARCHAR2_TABLE_100
1837 , p5_a44 JTF_VARCHAR2_TABLE_200
1838 , p5_a45 JTF_NUMBER_TABLE
1839 , p5_a46 JTF_NUMBER_TABLE
1840 , p5_a47 JTF_NUMBER_TABLE
1841 , p5_a48 JTF_NUMBER_TABLE
1842 , p5_a49 JTF_NUMBER_TABLE
1843 , p5_a50 JTF_NUMBER_TABLE
1844 , p5_a51 JTF_NUMBER_TABLE
1845 , p5_a52 JTF_NUMBER_TABLE
1846 , p5_a53 JTF_VARCHAR2_TABLE_200
1847 , p5_a54 JTF_VARCHAR2_TABLE_100
1848 , p5_a55 JTF_VARCHAR2_TABLE_100
1849 , p5_a56 JTF_VARCHAR2_TABLE_100
1850 , p5_a57 JTF_NUMBER_TABLE
1851 , p5_a58 JTF_DATE_TABLE
1852 , p5_a59 JTF_DATE_TABLE
1853 , p5_a60 JTF_NUMBER_TABLE
1854 )
1855
1856 as
1857 ddp_tqlv_tbl okl_txl_quote_lines_pub.tqlv_tbl_type;
1858 ddindx binary_integer; indx binary_integer;
1859 begin
1860
1861 -- copy data to the local IN or IN-OUT args, if any
1862
1863
1864
1865
1866
1867 okl_tql_pvt_w.rosetta_table_copy_in_p8(ddp_tqlv_tbl, p5_a0
1868 , p5_a1
1869 , p5_a2
1870 , p5_a3
1871 , p5_a4
1872 , p5_a5
1873 , p5_a6
1874 , p5_a7
1875 , p5_a8
1876 , p5_a9
1877 , p5_a10
1878 , p5_a11
1879 , p5_a12
1880 , p5_a13
1881 , p5_a14
1882 , p5_a15
1883 , p5_a16
1884 , p5_a17
1885 , p5_a18
1886 , p5_a19
1887 , p5_a20
1888 , p5_a21
1889 , p5_a22
1890 , p5_a23
1891 , p5_a24
1892 , p5_a25
1893 , p5_a26
1894 , p5_a27
1895 , p5_a28
1896 , p5_a29
1897 , p5_a30
1898 , p5_a31
1899 , p5_a32
1900 , p5_a33
1901 , p5_a34
1902 , p5_a35
1903 , p5_a36
1904 , p5_a37
1905 , p5_a38
1906 , p5_a39
1907 , p5_a40
1908 , p5_a41
1909 , p5_a42
1910 , p5_a43
1911 , p5_a44
1912 , p5_a45
1913 , p5_a46
1914 , p5_a47
1915 , p5_a48
1916 , p5_a49
1917 , p5_a50
1918 , p5_a51
1919 , p5_a52
1920 , p5_a53
1921 , p5_a54
1922 , p5_a55
1923 , p5_a56
1924 , p5_a57
1925 , p5_a58
1926 , p5_a59
1927 , p5_a60
1928 );
1929
1930 -- here's the delegated call to the old PL/SQL routine
1931 okl_txl_quote_lines_pub.validate_txl_quote_lines(p_api_version,
1932 p_init_msg_list,
1933 x_return_status,
1934 x_msg_count,
1935 x_msg_data,
1936 ddp_tqlv_tbl);
1937
1938 -- copy data back from the local variables to OUT or IN-OUT args, if any
1939
1940
1941
1942
1943
1944 end;
1945
1946 procedure validate_txl_quote_lines(p_api_version NUMBER
1947 , p_init_msg_list VARCHAR2
1948 , x_return_status out nocopy VARCHAR2
1949 , x_msg_count out nocopy NUMBER
1950 , x_msg_data out nocopy VARCHAR2
1951 , p5_a0 NUMBER := 0-1962.0724
1952 , p5_a1 NUMBER := 0-1962.0724
1953 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1954 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1955 , p5_a4 NUMBER := 0-1962.0724
1956 , p5_a5 NUMBER := 0-1962.0724
1957 , p5_a6 NUMBER := 0-1962.0724
1958 , p5_a7 NUMBER := 0-1962.0724
1959 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1960 , p5_a9 NUMBER := 0-1962.0724
1961 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1962 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1963 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1964 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1965 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1966 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1967 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1968 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1969 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1970 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1971 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1972 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1973 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1974 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1975 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1976 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1977 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1978 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1979 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1980 , p5_a29 NUMBER := 0-1962.0724
1981 , p5_a30 NUMBER := 0-1962.0724
1982 , p5_a31 NUMBER := 0-1962.0724
1983 , p5_a32 NUMBER := 0-1962.0724
1984 , p5_a33 DATE := fnd_api.g_miss_date
1985 , p5_a34 NUMBER := 0-1962.0724
1986 , p5_a35 DATE := fnd_api.g_miss_date
1987 , p5_a36 NUMBER := 0-1962.0724
1988 , p5_a37 DATE := fnd_api.g_miss_date
1989 , p5_a38 NUMBER := 0-1962.0724
1990 , p5_a39 DATE := fnd_api.g_miss_date
1991 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1992 , p5_a41 NUMBER := 0-1962.0724
1993 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1994 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1995 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1996 , p5_a45 NUMBER := 0-1962.0724
1997 , p5_a46 NUMBER := 0-1962.0724
1998 , p5_a47 NUMBER := 0-1962.0724
1999 , p5_a48 NUMBER := 0-1962.0724
2000 , p5_a49 NUMBER := 0-1962.0724
2001 , p5_a50 NUMBER := 0-1962.0724
2002 , p5_a51 NUMBER := 0-1962.0724
2003 , p5_a52 NUMBER := 0-1962.0724
2004 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2005 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
2006 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
2007 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
2008 , p5_a57 NUMBER := 0-1962.0724
2009 , p5_a58 DATE := fnd_api.g_miss_date
2010 , p5_a59 DATE := fnd_api.g_miss_date
2011 , p5_a60 NUMBER := 0-1962.0724
2012 )
2013
2014 as
2015 ddp_tqlv_rec okl_txl_quote_lines_pub.tqlv_rec_type;
2016 ddindx binary_integer; indx binary_integer;
2017 begin
2018
2019 -- copy data to the local IN or IN-OUT args, if any
2020
2021
2022
2023
2024
2025 ddp_tqlv_rec.id := rosetta_g_miss_num_map(p5_a0);
2026 ddp_tqlv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2027 ddp_tqlv_rec.sfwt_flag := p5_a2;
2028 ddp_tqlv_rec.qlt_code := p5_a3;
2029 ddp_tqlv_rec.kle_id := rosetta_g_miss_num_map(p5_a4);
2030 ddp_tqlv_rec.sty_id := rosetta_g_miss_num_map(p5_a5);
2031 ddp_tqlv_rec.qte_id := rosetta_g_miss_num_map(p5_a6);
2032 ddp_tqlv_rec.line_number := rosetta_g_miss_num_map(p5_a7);
2033 ddp_tqlv_rec.description := p5_a8;
2034 ddp_tqlv_rec.amount := rosetta_g_miss_num_map(p5_a9);
2035 ddp_tqlv_rec.modified_yn := p5_a10;
2036 ddp_tqlv_rec.taxed_yn := p5_a11;
2037 ddp_tqlv_rec.defaulted_yn := p5_a12;
2038 ddp_tqlv_rec.attribute_category := p5_a13;
2039 ddp_tqlv_rec.attribute1 := p5_a14;
2040 ddp_tqlv_rec.attribute2 := p5_a15;
2041 ddp_tqlv_rec.attribute3 := p5_a16;
2042 ddp_tqlv_rec.attribute4 := p5_a17;
2043 ddp_tqlv_rec.attribute5 := p5_a18;
2044 ddp_tqlv_rec.attribute6 := p5_a19;
2045 ddp_tqlv_rec.attribute7 := p5_a20;
2046 ddp_tqlv_rec.attribute8 := p5_a21;
2047 ddp_tqlv_rec.attribute9 := p5_a22;
2048 ddp_tqlv_rec.attribute10 := p5_a23;
2049 ddp_tqlv_rec.attribute11 := p5_a24;
2050 ddp_tqlv_rec.attribute12 := p5_a25;
2051 ddp_tqlv_rec.attribute13 := p5_a26;
2052 ddp_tqlv_rec.attribute14 := p5_a27;
2053 ddp_tqlv_rec.attribute15 := p5_a28;
2054 ddp_tqlv_rec.org_id := rosetta_g_miss_num_map(p5_a29);
2055 ddp_tqlv_rec.request_id := rosetta_g_miss_num_map(p5_a30);
2056 ddp_tqlv_rec.program_application_id := rosetta_g_miss_num_map(p5_a31);
2057 ddp_tqlv_rec.program_id := rosetta_g_miss_num_map(p5_a32);
2058 ddp_tqlv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a33);
2059 ddp_tqlv_rec.created_by := rosetta_g_miss_num_map(p5_a34);
2060 ddp_tqlv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a35);
2061 ddp_tqlv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a36);
2062 ddp_tqlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a37);
2063 ddp_tqlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a38);
2064 ddp_tqlv_rec.start_date := rosetta_g_miss_date_in_map(p5_a39);
2065 ddp_tqlv_rec.period := p5_a40;
2066 ddp_tqlv_rec.number_of_periods := rosetta_g_miss_num_map(p5_a41);
2067 ddp_tqlv_rec.lock_level_step := p5_a42;
2068 ddp_tqlv_rec.advance_or_arrears := p5_a43;
2069 ddp_tqlv_rec.yield_name := p5_a44;
2070 ddp_tqlv_rec.yield_value := rosetta_g_miss_num_map(p5_a45);
2071 ddp_tqlv_rec.implicit_interest_rate := rosetta_g_miss_num_map(p5_a46);
2072 ddp_tqlv_rec.asset_value := rosetta_g_miss_num_map(p5_a47);
2073 ddp_tqlv_rec.residual_value := rosetta_g_miss_num_map(p5_a48);
2074 ddp_tqlv_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a49);
2075 ddp_tqlv_rec.asset_quantity := rosetta_g_miss_num_map(p5_a50);
2076 ddp_tqlv_rec.quote_quantity := rosetta_g_miss_num_map(p5_a51);
2077 ddp_tqlv_rec.split_kle_id := rosetta_g_miss_num_map(p5_a52);
2078 ddp_tqlv_rec.split_kle_name := p5_a53;
2079 ddp_tqlv_rec.currency_code := p5_a54;
2080 ddp_tqlv_rec.currency_conversion_code := p5_a55;
2081 ddp_tqlv_rec.currency_conversion_type := p5_a56;
2082 ddp_tqlv_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a57);
2083 ddp_tqlv_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a58);
2084 ddp_tqlv_rec.due_date := rosetta_g_miss_date_in_map(p5_a59);
2085 ddp_tqlv_rec.try_id := rosetta_g_miss_num_map(p5_a60);
2086
2087 -- here's the delegated call to the old PL/SQL routine
2088 okl_txl_quote_lines_pub.validate_txl_quote_lines(p_api_version,
2089 p_init_msg_list,
2090 x_return_status,
2091 x_msg_count,
2092 x_msg_data,
2093 ddp_tqlv_rec);
2094
2095 -- copy data back from the local variables to OUT or IN-OUT args, if any
2096
2097
2098
2099
2100
2101 end;
2102
2103 end okl_txl_quote_lines_pub_w;