1: package body okl_pdt_opt_vals_pub_w as
2: /* $Header: OKLUPOVB.pls 115.7 2002/12/24 04:15:20 sgorantl 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:
48: , p5_a10 NUMBER := 0-1962.0724
49: )
50:
51: as
52: ddp_povv_rec okl_pdt_opt_vals_pub.povv_rec_type;
53: ddx_povv_rec okl_pdt_opt_vals_pub.povv_rec_type;
54: ddindx binary_integer; indx binary_integer;
55: begin
56:
49: )
50:
51: as
52: ddp_povv_rec okl_pdt_opt_vals_pub.povv_rec_type;
53: ddx_povv_rec okl_pdt_opt_vals_pub.povv_rec_type;
54: ddindx binary_integer; indx binary_integer;
55: begin
56:
57: -- copy data to the local IN or IN-OUT args, if any
73: ddp_povv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
74:
75:
76: -- here's the delegated call to the old PL/SQL routine
77: okl_pdt_opt_vals_pub.insert_pdt_opt_vals(p_api_version,
78: p_init_msg_list,
79: x_return_status,
80: x_msg_count,
81: x_msg_data,
131: , p6_a10 out nocopy JTF_NUMBER_TABLE
132: )
133:
134: as
135: ddp_povv_tbl okl_pdt_opt_vals_pub.povv_tbl_type;
136: ddx_povv_tbl okl_pdt_opt_vals_pub.povv_tbl_type;
137: ddindx binary_integer; indx binary_integer;
138: begin
139:
132: )
133:
134: as
135: ddp_povv_tbl okl_pdt_opt_vals_pub.povv_tbl_type;
136: ddx_povv_tbl okl_pdt_opt_vals_pub.povv_tbl_type;
137: ddindx binary_integer; indx binary_integer;
138: begin
139:
140: -- copy data to the local IN or IN-OUT args, if any
157: );
158:
159:
160: -- here's the delegated call to the old PL/SQL routine
161: okl_pdt_opt_vals_pub.insert_pdt_opt_vals(p_api_version,
162: p_init_msg_list,
163: x_return_status,
164: x_msg_count,
165: x_msg_data,
205: , p5_a10 NUMBER := 0-1962.0724
206: )
207:
208: as
209: ddp_povv_rec okl_pdt_opt_vals_pub.povv_rec_type;
210: ddindx binary_integer; indx binary_integer;
211: begin
212:
213: -- copy data to the local IN or IN-OUT args, if any
228: ddp_povv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
229: ddp_povv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
230:
231: -- here's the delegated call to the old PL/SQL routine
232: okl_pdt_opt_vals_pub.lock_pdt_opt_vals(p_api_version,
233: p_init_msg_list,
234: x_return_status,
235: x_msg_count,
236: x_msg_data,
262: , p5_a10 JTF_NUMBER_TABLE
263: )
264:
265: as
266: ddp_povv_tbl okl_pdt_opt_vals_pub.povv_tbl_type;
267: ddindx binary_integer; indx binary_integer;
268: begin
269:
270: -- copy data to the local IN or IN-OUT args, if any
286: , p5_a10
287: );
288:
289: -- here's the delegated call to the old PL/SQL routine
290: okl_pdt_opt_vals_pub.lock_pdt_opt_vals(p_api_version,
291: p_init_msg_list,
292: x_return_status,
293: x_msg_count,
294: x_msg_data,
331: , p5_a10 NUMBER := 0-1962.0724
332: )
333:
334: as
335: ddp_povv_rec okl_pdt_opt_vals_pub.povv_rec_type;
336: ddx_povv_rec okl_pdt_opt_vals_pub.povv_rec_type;
337: ddindx binary_integer; indx binary_integer;
338: begin
339:
332: )
333:
334: as
335: ddp_povv_rec okl_pdt_opt_vals_pub.povv_rec_type;
336: ddx_povv_rec okl_pdt_opt_vals_pub.povv_rec_type;
337: ddindx binary_integer; indx binary_integer;
338: begin
339:
340: -- copy data to the local IN or IN-OUT args, if any
356: ddp_povv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
357:
358:
359: -- here's the delegated call to the old PL/SQL routine
360: okl_pdt_opt_vals_pub.update_pdt_opt_vals(p_api_version,
361: p_init_msg_list,
362: x_return_status,
363: x_msg_count,
364: x_msg_data,
414: , p6_a10 out nocopy JTF_NUMBER_TABLE
415: )
416:
417: as
418: ddp_povv_tbl okl_pdt_opt_vals_pub.povv_tbl_type;
419: ddx_povv_tbl okl_pdt_opt_vals_pub.povv_tbl_type;
420: ddindx binary_integer; indx binary_integer;
421: begin
422:
415: )
416:
417: as
418: ddp_povv_tbl okl_pdt_opt_vals_pub.povv_tbl_type;
419: ddx_povv_tbl okl_pdt_opt_vals_pub.povv_tbl_type;
420: ddindx binary_integer; indx binary_integer;
421: begin
422:
423: -- copy data to the local IN or IN-OUT args, if any
440: );
441:
442:
443: -- here's the delegated call to the old PL/SQL routine
444: okl_pdt_opt_vals_pub.update_pdt_opt_vals(p_api_version,
445: p_init_msg_list,
446: x_return_status,
447: x_msg_count,
448: x_msg_data,
488: , p5_a10 NUMBER := 0-1962.0724
489: )
490:
491: as
492: ddp_povv_rec okl_pdt_opt_vals_pub.povv_rec_type;
493: ddindx binary_integer; indx binary_integer;
494: begin
495:
496: -- copy data to the local IN or IN-OUT args, if any
511: ddp_povv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
512: ddp_povv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
513:
514: -- here's the delegated call to the old PL/SQL routine
515: okl_pdt_opt_vals_pub.delete_pdt_opt_vals(p_api_version,
516: p_init_msg_list,
517: x_return_status,
518: x_msg_count,
519: x_msg_data,
545: , p5_a10 JTF_NUMBER_TABLE
546: )
547:
548: as
549: ddp_povv_tbl okl_pdt_opt_vals_pub.povv_tbl_type;
550: ddindx binary_integer; indx binary_integer;
551: begin
552:
553: -- copy data to the local IN or IN-OUT args, if any
569: , p5_a10
570: );
571:
572: -- here's the delegated call to the old PL/SQL routine
573: okl_pdt_opt_vals_pub.delete_pdt_opt_vals(p_api_version,
574: p_init_msg_list,
575: x_return_status,
576: x_msg_count,
577: x_msg_data,
603: , p5_a10 NUMBER := 0-1962.0724
604: )
605:
606: as
607: ddp_povv_rec okl_pdt_opt_vals_pub.povv_rec_type;
608: ddindx binary_integer; indx binary_integer;
609: begin
610:
611: -- copy data to the local IN or IN-OUT args, if any
626: ddp_povv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
627: ddp_povv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
628:
629: -- here's the delegated call to the old PL/SQL routine
630: okl_pdt_opt_vals_pub.validate_pdt_opt_vals(p_api_version,
631: p_init_msg_list,
632: x_return_status,
633: x_msg_count,
634: x_msg_data,
660: , p5_a10 JTF_NUMBER_TABLE
661: )
662:
663: as
664: ddp_povv_tbl okl_pdt_opt_vals_pub.povv_tbl_type;
665: ddindx binary_integer; indx binary_integer;
666: begin
667:
668: -- copy data to the local IN or IN-OUT args, if any
684: , p5_a10
685: );
686:
687: -- here's the delegated call to the old PL/SQL routine
688: okl_pdt_opt_vals_pub.validate_pdt_opt_vals(p_api_version,
689: p_init_msg_list,
690: x_return_status,
691: x_msg_count,
692: x_msg_data,
699:
700:
701: end;
702:
703: end okl_pdt_opt_vals_pub_w;