[Home] [Help]
PACKAGE BODY: APPS.OKL_QUOTE_LINE_STRM_PUB_W
Source
1 package body okl_quote_line_strm_pub_w as
2 /* $Header: OKLUQLSB.pls 120.1 2005/07/18 15:56:10 viselvar 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_quote_line_strm(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_VARCHAR2_TABLE_100
29 , p5_a2 JTF_NUMBER_TABLE
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_DATE_TABLE
35 , p5_a8 JTF_NUMBER_TABLE
36 , p5_a9 JTF_DATE_TABLE
37 , p5_a10 JTF_NUMBER_TABLE
38 , p6_a0 out nocopy JTF_NUMBER_TABLE
39 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
40 , p6_a2 out nocopy JTF_NUMBER_TABLE
41 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
42 , p6_a4 out nocopy JTF_NUMBER_TABLE
43 , p6_a5 out nocopy JTF_NUMBER_TABLE
44 , p6_a6 out nocopy JTF_NUMBER_TABLE
45 , p6_a7 out nocopy JTF_DATE_TABLE
46 , p6_a8 out nocopy JTF_NUMBER_TABLE
47 , p6_a9 out nocopy JTF_DATE_TABLE
48 , p6_a10 out nocopy JTF_NUMBER_TABLE
49 )
50
51 as
52 ddp_qlsv_tbl okl_quote_line_strm_pub.qlsv_tbl_type;
53 ddx_qlsv_tbl okl_quote_line_strm_pub.qlsv_tbl_type;
54 ddindx binary_integer; indx binary_integer;
55 begin
56
57 -- copy data to the local IN or IN-OUT args, if any
58
59
60
61
62
63 okl_qls_pvt_w.rosetta_table_copy_in_p2(ddp_qlsv_tbl, p5_a0
64 , p5_a1
65 , p5_a2
66 , p5_a3
67 , p5_a4
68 , p5_a5
69 , p5_a6
70 , p5_a7
71 , p5_a8
72 , p5_a9
73 , p5_a10
74 );
75
76
77 -- here's the delegated call to the old PL/SQL routine
78 okl_quote_line_strm_pub.insert_quote_line_strm(p_api_version,
79 p_init_msg_list,
80 x_return_status,
81 x_msg_count,
82 x_msg_data,
83 ddp_qlsv_tbl,
84 ddx_qlsv_tbl);
85
86 -- copy data back from the local variables to OUT or IN-OUT args, if any
87
88
89
90
91
92
93 okl_qls_pvt_w.rosetta_table_copy_out_p2(ddx_qlsv_tbl, p6_a0
94 , p6_a1
95 , p6_a2
96 , p6_a3
97 , p6_a4
98 , p6_a5
99 , p6_a6
100 , p6_a7
101 , p6_a8
102 , p6_a9
103 , p6_a10
104 );
105 end;
106
107 procedure insert_quote_line_strm(p_api_version NUMBER
108 , p_init_msg_list VARCHAR2
109 , x_return_status out nocopy VARCHAR2
110 , x_msg_count out nocopy NUMBER
111 , x_msg_data out nocopy VARCHAR2
112 , p6_a0 out nocopy NUMBER
113 , p6_a1 out nocopy VARCHAR2
114 , p6_a2 out nocopy NUMBER
115 , p6_a3 out nocopy VARCHAR2
116 , p6_a4 out nocopy NUMBER
117 , p6_a5 out nocopy NUMBER
118 , p6_a6 out nocopy NUMBER
119 , p6_a7 out nocopy DATE
120 , p6_a8 out nocopy NUMBER
121 , p6_a9 out nocopy DATE
122 , p6_a10 out nocopy NUMBER
123 , p5_a0 NUMBER := 0-1962.0724
124 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
125 , p5_a2 NUMBER := 0-1962.0724
126 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
127 , p5_a4 NUMBER := 0-1962.0724
128 , p5_a5 NUMBER := 0-1962.0724
129 , p5_a6 NUMBER := 0-1962.0724
130 , p5_a7 DATE := fnd_api.g_miss_date
131 , p5_a8 NUMBER := 0-1962.0724
132 , p5_a9 DATE := fnd_api.g_miss_date
133 , p5_a10 NUMBER := 0-1962.0724
134 )
135
136 as
137 ddp_qlsv_rec okl_quote_line_strm_pub.qlsv_rec_type;
138 ddx_qlsv_rec okl_quote_line_strm_pub.qlsv_rec_type;
139 ddindx binary_integer; indx binary_integer;
140 begin
141
142 -- copy data to the local IN or IN-OUT args, if any
143
144
145
146
147
148 ddp_qlsv_rec.id := rosetta_g_miss_num_map(p5_a0);
149 ddp_qlsv_rec.quote_line_type_code := p5_a1;
150 ddp_qlsv_rec.sty_id := rosetta_g_miss_num_map(p5_a2);
151 ddp_qlsv_rec.invoicable_yn := p5_a3;
152 ddp_qlsv_rec.object_version_number := rosetta_g_miss_num_map(p5_a4);
153 ddp_qlsv_rec.org_id := rosetta_g_miss_num_map(p5_a5);
154 ddp_qlsv_rec.created_by := rosetta_g_miss_num_map(p5_a6);
155 ddp_qlsv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a7);
156 ddp_qlsv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a8);
157 ddp_qlsv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
158 ddp_qlsv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
159
160
161 -- here's the delegated call to the old PL/SQL routine
162 okl_quote_line_strm_pub.insert_quote_line_strm(p_api_version,
163 p_init_msg_list,
164 x_return_status,
165 x_msg_count,
166 x_msg_data,
167 ddp_qlsv_rec,
168 ddx_qlsv_rec);
169
170 -- copy data back from the local variables to OUT or IN-OUT args, if any
171
172
173
174
175
176
177 p6_a0 := rosetta_g_miss_num_map(ddx_qlsv_rec.id);
178 p6_a1 := ddx_qlsv_rec.quote_line_type_code;
179 p6_a2 := rosetta_g_miss_num_map(ddx_qlsv_rec.sty_id);
180 p6_a3 := ddx_qlsv_rec.invoicable_yn;
181 p6_a4 := rosetta_g_miss_num_map(ddx_qlsv_rec.object_version_number);
182 p6_a5 := rosetta_g_miss_num_map(ddx_qlsv_rec.org_id);
183 p6_a6 := rosetta_g_miss_num_map(ddx_qlsv_rec.created_by);
184 p6_a7 := ddx_qlsv_rec.creation_date;
185 p6_a8 := rosetta_g_miss_num_map(ddx_qlsv_rec.last_updated_by);
186 p6_a9 := ddx_qlsv_rec.last_update_date;
187 p6_a10 := rosetta_g_miss_num_map(ddx_qlsv_rec.last_update_login);
188 end;
189
190 procedure lock_quote_line_strm(p_api_version NUMBER
191 , p_init_msg_list VARCHAR2
192 , x_return_status out nocopy VARCHAR2
193 , x_msg_count out nocopy NUMBER
194 , x_msg_data out nocopy VARCHAR2
195 , p5_a0 JTF_NUMBER_TABLE
196 , p5_a1 JTF_VARCHAR2_TABLE_100
197 , p5_a2 JTF_NUMBER_TABLE
198 , p5_a3 JTF_VARCHAR2_TABLE_100
199 , p5_a4 JTF_NUMBER_TABLE
200 , p5_a5 JTF_NUMBER_TABLE
201 , p5_a6 JTF_NUMBER_TABLE
202 , p5_a7 JTF_DATE_TABLE
203 , p5_a8 JTF_NUMBER_TABLE
204 , p5_a9 JTF_DATE_TABLE
205 , p5_a10 JTF_NUMBER_TABLE
206 )
207
208 as
209 ddp_qlsv_tbl okl_quote_line_strm_pub.qlsv_tbl_type;
210 ddindx binary_integer; indx binary_integer;
211 begin
212
213 -- copy data to the local IN or IN-OUT args, if any
214
215
216
217
218
219 okl_qls_pvt_w.rosetta_table_copy_in_p2(ddp_qlsv_tbl, p5_a0
220 , p5_a1
221 , p5_a2
222 , p5_a3
223 , p5_a4
224 , p5_a5
225 , p5_a6
226 , p5_a7
227 , p5_a8
228 , p5_a9
229 , p5_a10
230 );
231
232 -- here's the delegated call to the old PL/SQL routine
233 okl_quote_line_strm_pub.lock_quote_line_strm(p_api_version,
234 p_init_msg_list,
235 x_return_status,
236 x_msg_count,
237 x_msg_data,
238 ddp_qlsv_tbl);
239
240 -- copy data back from the local variables to OUT or IN-OUT args, if any
241
242
243
244
245
246 end;
247
248 procedure lock_quote_line_strm(p_api_version NUMBER
249 , p_init_msg_list VARCHAR2
250 , x_return_status out nocopy VARCHAR2
251 , x_msg_count out nocopy NUMBER
252 , x_msg_data out nocopy VARCHAR2
253 , p5_a0 NUMBER := 0-1962.0724
254 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
255 , p5_a2 NUMBER := 0-1962.0724
256 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
257 , p5_a4 NUMBER := 0-1962.0724
258 , p5_a5 NUMBER := 0-1962.0724
259 , p5_a6 NUMBER := 0-1962.0724
260 , p5_a7 DATE := fnd_api.g_miss_date
261 , p5_a8 NUMBER := 0-1962.0724
262 , p5_a9 DATE := fnd_api.g_miss_date
263 , p5_a10 NUMBER := 0-1962.0724
264 )
265
266 as
267 ddp_qlsv_rec okl_quote_line_strm_pub.qlsv_rec_type;
268 ddindx binary_integer; indx binary_integer;
269 begin
270
271 -- copy data to the local IN or IN-OUT args, if any
272
273
274
275
276
277 ddp_qlsv_rec.id := rosetta_g_miss_num_map(p5_a0);
278 ddp_qlsv_rec.quote_line_type_code := p5_a1;
279 ddp_qlsv_rec.sty_id := rosetta_g_miss_num_map(p5_a2);
280 ddp_qlsv_rec.invoicable_yn := p5_a3;
281 ddp_qlsv_rec.object_version_number := rosetta_g_miss_num_map(p5_a4);
282 ddp_qlsv_rec.org_id := rosetta_g_miss_num_map(p5_a5);
283 ddp_qlsv_rec.created_by := rosetta_g_miss_num_map(p5_a6);
284 ddp_qlsv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a7);
285 ddp_qlsv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a8);
286 ddp_qlsv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
287 ddp_qlsv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
288
289 -- here's the delegated call to the old PL/SQL routine
290 okl_quote_line_strm_pub.lock_quote_line_strm(p_api_version,
291 p_init_msg_list,
292 x_return_status,
293 x_msg_count,
294 x_msg_data,
295 ddp_qlsv_rec);
296
297 -- copy data back from the local variables to OUT or IN-OUT args, if any
298
299
300
301
302
303 end;
304
305 procedure update_quote_line_strm(p_api_version NUMBER
306 , p_init_msg_list VARCHAR2
307 , x_return_status out nocopy VARCHAR2
308 , x_msg_count out nocopy NUMBER
309 , x_msg_data out nocopy VARCHAR2
310 , p5_a0 JTF_NUMBER_TABLE
311 , p5_a1 JTF_VARCHAR2_TABLE_100
312 , p5_a2 JTF_NUMBER_TABLE
313 , p5_a3 JTF_VARCHAR2_TABLE_100
314 , p5_a4 JTF_NUMBER_TABLE
315 , p5_a5 JTF_NUMBER_TABLE
316 , p5_a6 JTF_NUMBER_TABLE
317 , p5_a7 JTF_DATE_TABLE
318 , p5_a8 JTF_NUMBER_TABLE
319 , p5_a9 JTF_DATE_TABLE
320 , p5_a10 JTF_NUMBER_TABLE
321 , p6_a0 out nocopy JTF_NUMBER_TABLE
322 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
323 , p6_a2 out nocopy JTF_NUMBER_TABLE
324 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
325 , p6_a4 out nocopy JTF_NUMBER_TABLE
326 , p6_a5 out nocopy JTF_NUMBER_TABLE
327 , p6_a6 out nocopy JTF_NUMBER_TABLE
328 , p6_a7 out nocopy JTF_DATE_TABLE
329 , p6_a8 out nocopy JTF_NUMBER_TABLE
330 , p6_a9 out nocopy JTF_DATE_TABLE
331 , p6_a10 out nocopy JTF_NUMBER_TABLE
332 )
333
334 as
335 ddp_qlsv_tbl okl_quote_line_strm_pub.qlsv_tbl_type;
336 ddx_qlsv_tbl okl_quote_line_strm_pub.qlsv_tbl_type;
337 ddindx binary_integer; indx binary_integer;
338 begin
339
340 -- copy data to the local IN or IN-OUT args, if any
341
342
343
344
345
346 okl_qls_pvt_w.rosetta_table_copy_in_p2(ddp_qlsv_tbl, p5_a0
347 , p5_a1
348 , p5_a2
349 , p5_a3
350 , p5_a4
351 , p5_a5
352 , p5_a6
353 , p5_a7
354 , p5_a8
355 , p5_a9
356 , p5_a10
357 );
358
359
360 -- here's the delegated call to the old PL/SQL routine
361 okl_quote_line_strm_pub.update_quote_line_strm(p_api_version,
362 p_init_msg_list,
363 x_return_status,
364 x_msg_count,
365 x_msg_data,
366 ddp_qlsv_tbl,
367 ddx_qlsv_tbl);
368
369 -- copy data back from the local variables to OUT or IN-OUT args, if any
370
371
372
373
374
375
376 okl_qls_pvt_w.rosetta_table_copy_out_p2(ddx_qlsv_tbl, p6_a0
377 , p6_a1
378 , p6_a2
379 , p6_a3
380 , p6_a4
381 , p6_a5
382 , p6_a6
383 , p6_a7
384 , p6_a8
385 , p6_a9
386 , p6_a10
387 );
388 end;
389
390 procedure update_quote_line_strm(p_api_version NUMBER
391 , p_init_msg_list VARCHAR2
392 , x_return_status out nocopy VARCHAR2
393 , x_msg_count out nocopy NUMBER
394 , x_msg_data out nocopy VARCHAR2
395 , p6_a0 out nocopy NUMBER
396 , p6_a1 out nocopy VARCHAR2
397 , p6_a2 out nocopy NUMBER
398 , p6_a3 out nocopy VARCHAR2
399 , p6_a4 out nocopy NUMBER
400 , p6_a5 out nocopy NUMBER
401 , p6_a6 out nocopy NUMBER
402 , p6_a7 out nocopy DATE
403 , p6_a8 out nocopy NUMBER
404 , p6_a9 out nocopy DATE
405 , p6_a10 out nocopy NUMBER
406 , p5_a0 NUMBER := 0-1962.0724
407 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
408 , p5_a2 NUMBER := 0-1962.0724
409 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
410 , p5_a4 NUMBER := 0-1962.0724
411 , p5_a5 NUMBER := 0-1962.0724
412 , p5_a6 NUMBER := 0-1962.0724
413 , p5_a7 DATE := fnd_api.g_miss_date
414 , p5_a8 NUMBER := 0-1962.0724
415 , p5_a9 DATE := fnd_api.g_miss_date
416 , p5_a10 NUMBER := 0-1962.0724
417 )
418
419 as
420 ddp_qlsv_rec okl_quote_line_strm_pub.qlsv_rec_type;
421 ddx_qlsv_rec okl_quote_line_strm_pub.qlsv_rec_type;
422 ddindx binary_integer; indx binary_integer;
423 begin
424
425 -- copy data to the local IN or IN-OUT args, if any
426
427
428
429
430
431 ddp_qlsv_rec.id := rosetta_g_miss_num_map(p5_a0);
432 ddp_qlsv_rec.quote_line_type_code := p5_a1;
433 ddp_qlsv_rec.sty_id := rosetta_g_miss_num_map(p5_a2);
434 ddp_qlsv_rec.invoicable_yn := p5_a3;
435 ddp_qlsv_rec.object_version_number := rosetta_g_miss_num_map(p5_a4);
436 ddp_qlsv_rec.org_id := rosetta_g_miss_num_map(p5_a5);
437 ddp_qlsv_rec.created_by := rosetta_g_miss_num_map(p5_a6);
438 ddp_qlsv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a7);
439 ddp_qlsv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a8);
440 ddp_qlsv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
441 ddp_qlsv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
442
443
444 -- here's the delegated call to the old PL/SQL routine
445 okl_quote_line_strm_pub.update_quote_line_strm(p_api_version,
446 p_init_msg_list,
447 x_return_status,
448 x_msg_count,
449 x_msg_data,
450 ddp_qlsv_rec,
451 ddx_qlsv_rec);
452
453 -- copy data back from the local variables to OUT or IN-OUT args, if any
454
455
456
457
458
459
460 p6_a0 := rosetta_g_miss_num_map(ddx_qlsv_rec.id);
461 p6_a1 := ddx_qlsv_rec.quote_line_type_code;
462 p6_a2 := rosetta_g_miss_num_map(ddx_qlsv_rec.sty_id);
463 p6_a3 := ddx_qlsv_rec.invoicable_yn;
464 p6_a4 := rosetta_g_miss_num_map(ddx_qlsv_rec.object_version_number);
465 p6_a5 := rosetta_g_miss_num_map(ddx_qlsv_rec.org_id);
466 p6_a6 := rosetta_g_miss_num_map(ddx_qlsv_rec.created_by);
467 p6_a7 := ddx_qlsv_rec.creation_date;
468 p6_a8 := rosetta_g_miss_num_map(ddx_qlsv_rec.last_updated_by);
469 p6_a9 := ddx_qlsv_rec.last_update_date;
470 p6_a10 := rosetta_g_miss_num_map(ddx_qlsv_rec.last_update_login);
471 end;
472
473 procedure delete_quote_line_strm(p_api_version NUMBER
474 , p_init_msg_list VARCHAR2
475 , x_return_status out nocopy VARCHAR2
476 , x_msg_count out nocopy NUMBER
477 , x_msg_data out nocopy VARCHAR2
478 , p5_a0 JTF_NUMBER_TABLE
479 , p5_a1 JTF_VARCHAR2_TABLE_100
480 , p5_a2 JTF_NUMBER_TABLE
481 , p5_a3 JTF_VARCHAR2_TABLE_100
482 , p5_a4 JTF_NUMBER_TABLE
483 , p5_a5 JTF_NUMBER_TABLE
484 , p5_a6 JTF_NUMBER_TABLE
485 , p5_a7 JTF_DATE_TABLE
486 , p5_a8 JTF_NUMBER_TABLE
487 , p5_a9 JTF_DATE_TABLE
488 , p5_a10 JTF_NUMBER_TABLE
489 )
490
491 as
492 ddp_qlsv_tbl okl_quote_line_strm_pub.qlsv_tbl_type;
493 ddindx binary_integer; indx binary_integer;
494 begin
495
496 -- copy data to the local IN or IN-OUT args, if any
497
498
499
500
501
502 okl_qls_pvt_w.rosetta_table_copy_in_p2(ddp_qlsv_tbl, p5_a0
503 , p5_a1
504 , p5_a2
505 , p5_a3
506 , p5_a4
507 , p5_a5
508 , p5_a6
509 , p5_a7
510 , p5_a8
511 , p5_a9
512 , p5_a10
513 );
514
515 -- here's the delegated call to the old PL/SQL routine
516 okl_quote_line_strm_pub.delete_quote_line_strm(p_api_version,
517 p_init_msg_list,
518 x_return_status,
519 x_msg_count,
520 x_msg_data,
521 ddp_qlsv_tbl);
522
523 -- copy data back from the local variables to OUT or IN-OUT args, if any
524
525
526
527
528
529 end;
530
531 procedure delete_quote_line_strm(p_api_version NUMBER
532 , p_init_msg_list VARCHAR2
533 , x_return_status out nocopy VARCHAR2
534 , x_msg_count out nocopy NUMBER
535 , x_msg_data out nocopy VARCHAR2
536 , p5_a0 NUMBER := 0-1962.0724
537 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
538 , p5_a2 NUMBER := 0-1962.0724
539 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
540 , p5_a4 NUMBER := 0-1962.0724
541 , p5_a5 NUMBER := 0-1962.0724
542 , p5_a6 NUMBER := 0-1962.0724
543 , p5_a7 DATE := fnd_api.g_miss_date
544 , p5_a8 NUMBER := 0-1962.0724
545 , p5_a9 DATE := fnd_api.g_miss_date
546 , p5_a10 NUMBER := 0-1962.0724
547 )
548
549 as
550 ddp_qlsv_rec okl_quote_line_strm_pub.qlsv_rec_type;
551 ddindx binary_integer; indx binary_integer;
552 begin
553
554 -- copy data to the local IN or IN-OUT args, if any
555
556
557
558
559
560 ddp_qlsv_rec.id := rosetta_g_miss_num_map(p5_a0);
561 ddp_qlsv_rec.quote_line_type_code := p5_a1;
562 ddp_qlsv_rec.sty_id := rosetta_g_miss_num_map(p5_a2);
563 ddp_qlsv_rec.invoicable_yn := p5_a3;
564 ddp_qlsv_rec.object_version_number := rosetta_g_miss_num_map(p5_a4);
565 ddp_qlsv_rec.org_id := rosetta_g_miss_num_map(p5_a5);
566 ddp_qlsv_rec.created_by := rosetta_g_miss_num_map(p5_a6);
567 ddp_qlsv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a7);
568 ddp_qlsv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a8);
569 ddp_qlsv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
570 ddp_qlsv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
571
572 -- here's the delegated call to the old PL/SQL routine
573 okl_quote_line_strm_pub.delete_quote_line_strm(p_api_version,
574 p_init_msg_list,
575 x_return_status,
576 x_msg_count,
577 x_msg_data,
578 ddp_qlsv_rec);
579
580 -- copy data back from the local variables to OUT or IN-OUT args, if any
581
582
583
584
585
586 end;
587
588 procedure validate_quote_line_strm(p_api_version NUMBER
589 , p_init_msg_list VARCHAR2
590 , x_return_status out nocopy VARCHAR2
591 , x_msg_count out nocopy NUMBER
592 , x_msg_data out nocopy VARCHAR2
593 , p5_a0 JTF_NUMBER_TABLE
594 , p5_a1 JTF_VARCHAR2_TABLE_100
595 , p5_a2 JTF_NUMBER_TABLE
596 , p5_a3 JTF_VARCHAR2_TABLE_100
597 , p5_a4 JTF_NUMBER_TABLE
598 , p5_a5 JTF_NUMBER_TABLE
599 , p5_a6 JTF_NUMBER_TABLE
600 , p5_a7 JTF_DATE_TABLE
601 , p5_a8 JTF_NUMBER_TABLE
602 , p5_a9 JTF_DATE_TABLE
603 , p5_a10 JTF_NUMBER_TABLE
604 )
605
606 as
607 ddp_qlsv_tbl okl_quote_line_strm_pub.qlsv_tbl_type;
608 ddindx binary_integer; indx binary_integer;
609 begin
610
611 -- copy data to the local IN or IN-OUT args, if any
612
613
614
615
616
617 okl_qls_pvt_w.rosetta_table_copy_in_p2(ddp_qlsv_tbl, p5_a0
618 , p5_a1
619 , p5_a2
620 , p5_a3
621 , p5_a4
622 , p5_a5
623 , p5_a6
624 , p5_a7
625 , p5_a8
626 , p5_a9
627 , p5_a10
628 );
629
630 -- here's the delegated call to the old PL/SQL routine
631 okl_quote_line_strm_pub.validate_quote_line_strm(p_api_version,
632 p_init_msg_list,
633 x_return_status,
634 x_msg_count,
635 x_msg_data,
636 ddp_qlsv_tbl);
637
638 -- copy data back from the local variables to OUT or IN-OUT args, if any
639
640
641
642
643
644 end;
645
646 procedure validate_quote_line_strm(p_api_version NUMBER
647 , p_init_msg_list VARCHAR2
648 , x_return_status out nocopy VARCHAR2
649 , x_msg_count out nocopy NUMBER
650 , x_msg_data out nocopy VARCHAR2
651 , p5_a0 NUMBER := 0-1962.0724
652 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
653 , p5_a2 NUMBER := 0-1962.0724
654 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
655 , p5_a4 NUMBER := 0-1962.0724
656 , p5_a5 NUMBER := 0-1962.0724
657 , p5_a6 NUMBER := 0-1962.0724
658 , p5_a7 DATE := fnd_api.g_miss_date
659 , p5_a8 NUMBER := 0-1962.0724
660 , p5_a9 DATE := fnd_api.g_miss_date
661 , p5_a10 NUMBER := 0-1962.0724
662 )
663
664 as
665 ddp_qlsv_rec okl_quote_line_strm_pub.qlsv_rec_type;
666 ddindx binary_integer; indx binary_integer;
667 begin
668
669 -- copy data to the local IN or IN-OUT args, if any
670
671
672
673
674
675 ddp_qlsv_rec.id := rosetta_g_miss_num_map(p5_a0);
676 ddp_qlsv_rec.quote_line_type_code := p5_a1;
677 ddp_qlsv_rec.sty_id := rosetta_g_miss_num_map(p5_a2);
678 ddp_qlsv_rec.invoicable_yn := p5_a3;
679 ddp_qlsv_rec.object_version_number := rosetta_g_miss_num_map(p5_a4);
680 ddp_qlsv_rec.org_id := rosetta_g_miss_num_map(p5_a5);
681 ddp_qlsv_rec.created_by := rosetta_g_miss_num_map(p5_a6);
682 ddp_qlsv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a7);
683 ddp_qlsv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a8);
684 ddp_qlsv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
685 ddp_qlsv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
686
687 -- here's the delegated call to the old PL/SQL routine
688 okl_quote_line_strm_pub.validate_quote_line_strm(p_api_version,
689 p_init_msg_list,
690 x_return_status,
691 x_msg_count,
692 x_msg_data,
693 ddp_qlsv_rec);
694
695 -- copy data back from the local variables to OUT or IN-OUT args, if any
696
697
698
699
700
701 end;
702
703 end okl_quote_line_strm_pub_w;