1: package body okl_setupdsfparameters_pub_w as
2: /* $Header: OKLUSFRB.pls 120.1 2005/07/19 07:30:13 asawanka 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:
52: , p0_a13 NUMBER := 0-1962.0724
53: )
54:
55: as
56: ddp_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
57: ddx_no_data_found boolean;
58: ddx_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
59: ddindx binary_integer; indx binary_integer;
60: begin
54:
55: as
56: ddp_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
57: ddx_no_data_found boolean;
58: ddx_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
59: ddindx binary_integer; indx binary_integer;
60: begin
61:
62: -- copy data to the local IN or IN-OUT args, if any
79:
80:
81:
82: -- here's the delegated call to the old PL/SQL routine
83: okl_setupdsfparameters_pub.get_rec(ddp_fprv_rec,
84: x_return_status,
85: x_msg_data,
86: ddx_no_data_found,
87: ddx_fprv_rec);
180: , p6_a13 NUMBER := 0-1962.0724
181: )
182:
183: as
184: ddp_dsfv_rec okl_setupdsfparameters_pub.dsfv_rec_type;
185: ddp_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
186: ddx_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
187: ddindx binary_integer; indx binary_integer;
188: begin
181: )
182:
183: as
184: ddp_dsfv_rec okl_setupdsfparameters_pub.dsfv_rec_type;
185: ddp_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
186: ddx_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
187: ddindx binary_integer; indx binary_integer;
188: begin
189:
182:
183: as
184: ddp_dsfv_rec okl_setupdsfparameters_pub.dsfv_rec_type;
185: ddp_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
186: ddx_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
187: ddindx binary_integer; indx binary_integer;
188: begin
189:
190: -- copy data to the local IN or IN-OUT args, if any
242: ddp_fprv_rec.last_update_login := rosetta_g_miss_num_map(p6_a13);
243:
244:
245: -- here's the delegated call to the old PL/SQL routine
246: okl_setupdsfparameters_pub.insert_dsfparameters(p_api_version,
247: p_init_msg_list,
248: x_return_status,
249: x_msg_count,
250: x_msg_data,
343: , p6_a13 NUMBER := 0-1962.0724
344: )
345:
346: as
347: ddp_dsfv_rec okl_setupdsfparameters_pub.dsfv_rec_type;
348: ddp_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
349: ddx_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
350: ddindx binary_integer; indx binary_integer;
351: begin
344: )
345:
346: as
347: ddp_dsfv_rec okl_setupdsfparameters_pub.dsfv_rec_type;
348: ddp_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
349: ddx_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
350: ddindx binary_integer; indx binary_integer;
351: begin
352:
345:
346: as
347: ddp_dsfv_rec okl_setupdsfparameters_pub.dsfv_rec_type;
348: ddp_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
349: ddx_fprv_rec okl_setupdsfparameters_pub.fprv_rec_type;
350: ddindx binary_integer; indx binary_integer;
351: begin
352:
353: -- copy data to the local IN or IN-OUT args, if any
405: ddp_fprv_rec.last_update_login := rosetta_g_miss_num_map(p6_a13);
406:
407:
408: -- here's the delegated call to the old PL/SQL routine
409: okl_setupdsfparameters_pub.update_dsfparameters(p_api_version,
410: p_init_msg_list,
411: x_return_status,
412: x_msg_count,
413: x_msg_data,
460: , p5_a13 JTF_NUMBER_TABLE
461: )
462:
463: as
464: ddp_fprv_tbl okl_setupdsfparameters_pub.fprv_tbl_type;
465: ddindx binary_integer; indx binary_integer;
466: begin
467:
468: -- copy data to the local IN or IN-OUT args, if any
487: , p5_a13
488: );
489:
490: -- here's the delegated call to the old PL/SQL routine
491: okl_setupdsfparameters_pub.delete_dsfparameters(p_api_version,
492: p_init_msg_list,
493: x_return_status,
494: x_msg_count,
495: x_msg_data,
570: , p5_a31 NUMBER := 0-1962.0724
571: )
572:
573: as
574: ddp_dsfv_rec okl_setupdsfparameters_pub.dsfv_rec_type;
575: ddp_fprv_tbl okl_setupdsfparameters_pub.fprv_tbl_type;
576: ddx_fprv_tbl okl_setupdsfparameters_pub.fprv_tbl_type;
577: ddindx binary_integer; indx binary_integer;
578: begin
571: )
572:
573: as
574: ddp_dsfv_rec okl_setupdsfparameters_pub.dsfv_rec_type;
575: ddp_fprv_tbl okl_setupdsfparameters_pub.fprv_tbl_type;
576: ddx_fprv_tbl okl_setupdsfparameters_pub.fprv_tbl_type;
577: ddindx binary_integer; indx binary_integer;
578: begin
579:
572:
573: as
574: ddp_dsfv_rec okl_setupdsfparameters_pub.dsfv_rec_type;
575: ddp_fprv_tbl okl_setupdsfparameters_pub.fprv_tbl_type;
576: ddx_fprv_tbl okl_setupdsfparameters_pub.fprv_tbl_type;
577: ddindx binary_integer; indx binary_integer;
578: begin
579:
580: -- copy data to the local IN or IN-OUT args, if any
633: );
634:
635:
636: -- here's the delegated call to the old PL/SQL routine
637: okl_setupdsfparameters_pub.insert_dsfparameters(p_api_version,
638: p_init_msg_list,
639: x_return_status,
640: x_msg_count,
641: x_msg_data,
735: , p5_a31 NUMBER := 0-1962.0724
736: )
737:
738: as
739: ddp_dsfv_rec okl_setupdsfparameters_pub.dsfv_rec_type;
740: ddp_fprv_tbl okl_setupdsfparameters_pub.fprv_tbl_type;
741: ddx_fprv_tbl okl_setupdsfparameters_pub.fprv_tbl_type;
742: ddindx binary_integer; indx binary_integer;
743: begin
736: )
737:
738: as
739: ddp_dsfv_rec okl_setupdsfparameters_pub.dsfv_rec_type;
740: ddp_fprv_tbl okl_setupdsfparameters_pub.fprv_tbl_type;
741: ddx_fprv_tbl okl_setupdsfparameters_pub.fprv_tbl_type;
742: ddindx binary_integer; indx binary_integer;
743: begin
744:
737:
738: as
739: ddp_dsfv_rec okl_setupdsfparameters_pub.dsfv_rec_type;
740: ddp_fprv_tbl okl_setupdsfparameters_pub.fprv_tbl_type;
741: ddx_fprv_tbl okl_setupdsfparameters_pub.fprv_tbl_type;
742: ddindx binary_integer; indx binary_integer;
743: begin
744:
745: -- copy data to the local IN or IN-OUT args, if any
798: );
799:
800:
801: -- here's the delegated call to the old PL/SQL routine
802: okl_setupdsfparameters_pub.update_dsfparameters(p_api_version,
803: p_init_msg_list,
804: x_return_status,
805: x_msg_count,
806: x_msg_data,
832: , p7_a13
833: );
834: end;
835:
836: end okl_setupdsfparameters_pub_w;