1: package body okl_setup_trxparams_pub_w as
2: /* $Header: OKLUTXRB.pls 115.0 2004/07/02 02:38:45 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:
54: , p5_a13 NUMBER := 0-1962.0724
55: )
56:
57: as
58: ddp_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
59: ddx_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
60: ddindx binary_integer; indx binary_integer;
61: begin
62:
55: )
56:
57: as
58: ddp_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
59: ddx_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
60: ddindx binary_integer; indx binary_integer;
61: begin
62:
63: -- copy data to the local IN or IN-OUT args, if any
82: ddp_sxpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
83:
84:
85: -- here's the delegated call to the old PL/SQL routine
86: okl_setup_trxparams_pub.create_trx_parm(p_api_version,
87: p_init_msg_list,
88: x_return_status,
89: x_msg_count,
90: x_msg_data,
149: , p5_a13 NUMBER := 0-1962.0724
150: )
151:
152: as
153: ddp_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
154: ddx_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
155: ddindx binary_integer; indx binary_integer;
156: begin
157:
150: )
151:
152: as
153: ddp_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
154: ddx_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
155: ddindx binary_integer; indx binary_integer;
156: begin
157:
158: -- copy data to the local IN or IN-OUT args, if any
177: ddp_sxpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
178:
179:
180: -- here's the delegated call to the old PL/SQL routine
181: okl_setup_trxparams_pub.update_trx_parm(p_api_version,
182: p_init_msg_list,
183: x_return_status,
184: x_msg_count,
185: x_msg_data,
244: , p6_a13 out nocopy JTF_NUMBER_TABLE
245: )
246:
247: as
248: ddp_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
249: ddx_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
250: ddindx binary_integer; indx binary_integer;
251: begin
252:
245: )
246:
247: as
248: ddp_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
249: ddx_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
250: ddindx binary_integer; indx binary_integer;
251: begin
252:
253: -- copy data to the local IN or IN-OUT args, if any
273: );
274:
275:
276: -- here's the delegated call to the old PL/SQL routine
277: okl_setup_trxparams_pub.create_trx_parm(p_api_version,
278: p_init_msg_list,
279: x_return_status,
280: x_msg_count,
281: x_msg_data,
341: , p6_a13 out nocopy JTF_NUMBER_TABLE
342: )
343:
344: as
345: ddp_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
346: ddx_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
347: ddindx binary_integer; indx binary_integer;
348: begin
349:
342: )
343:
344: as
345: ddp_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
346: ddx_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
347: ddindx binary_integer; indx binary_integer;
348: begin
349:
350: -- copy data to the local IN or IN-OUT args, if any
370: );
371:
372:
373: -- here's the delegated call to the old PL/SQL routine
374: okl_setup_trxparams_pub.update_trx_parm(p_api_version,
375: p_init_msg_list,
376: x_return_status,
377: x_msg_count,
378: x_msg_data,
438: , p5_a13 NUMBER := 0-1962.0724
439: )
440:
441: as
442: ddp_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
443: ddx_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
444: ddindx binary_integer; indx binary_integer;
445: begin
446:
439: )
440:
441: as
442: ddp_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
443: ddx_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
444: ddindx binary_integer; indx binary_integer;
445: begin
446:
447: -- copy data to the local IN or IN-OUT args, if any
466: ddp_sxpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
467:
468:
469: -- here's the delegated call to the old PL/SQL routine
470: okl_setup_trxparams_pub.delete_trx_parm(p_api_version,
471: p_init_msg_list,
472: x_return_status,
473: x_msg_count,
474: x_msg_data,
533: , p6_a13 out nocopy JTF_NUMBER_TABLE
534: )
535:
536: as
537: ddp_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
538: ddx_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
539: ddindx binary_integer; indx binary_integer;
540: begin
541:
534: )
535:
536: as
537: ddp_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
538: ddx_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
539: ddindx binary_integer; indx binary_integer;
540: begin
541:
542: -- copy data to the local IN or IN-OUT args, if any
562: );
563:
564:
565: -- here's the delegated call to the old PL/SQL routine
566: okl_setup_trxparams_pub.delete_trx_parm(p_api_version,
567: p_init_msg_list,
568: x_return_status,
569: x_msg_count,
570: x_msg_data,
630: , p5_a13 NUMBER := 0-1962.0724
631: )
632:
633: as
634: ddp_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
635: ddx_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
636: ddindx binary_integer; indx binary_integer;
637: begin
638:
631: )
632:
633: as
634: ddp_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
635: ddx_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
636: ddindx binary_integer; indx binary_integer;
637: begin
638:
639: -- copy data to the local IN or IN-OUT args, if any
658: ddp_sxpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
659:
660:
661: -- here's the delegated call to the old PL/SQL routine
662: okl_setup_trxparams_pub.create_trx_asset_parm(p_api_version,
663: p_init_msg_list,
664: x_return_status,
665: x_msg_count,
666: x_msg_data,
725: , p5_a13 NUMBER := 0-1962.0724
726: )
727:
728: as
729: ddp_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
730: ddx_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
731: ddindx binary_integer; indx binary_integer;
732: begin
733:
726: )
727:
728: as
729: ddp_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
730: ddx_sxpv_rec okl_setup_trxparams_pub.sxpv_rec_type;
731: ddindx binary_integer; indx binary_integer;
732: begin
733:
734: -- copy data to the local IN or IN-OUT args, if any
753: ddp_sxpv_rec.last_update_login := rosetta_g_miss_num_map(p5_a13);
754:
755:
756: -- here's the delegated call to the old PL/SQL routine
757: okl_setup_trxparams_pub.update_trx_asset_parm(p_api_version,
758: p_init_msg_list,
759: x_return_status,
760: x_msg_count,
761: x_msg_data,
820: , p6_a13 out nocopy JTF_NUMBER_TABLE
821: )
822:
823: as
824: ddp_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
825: ddx_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
826: ddindx binary_integer; indx binary_integer;
827: begin
828:
821: )
822:
823: as
824: ddp_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
825: ddx_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
826: ddindx binary_integer; indx binary_integer;
827: begin
828:
829: -- copy data to the local IN or IN-OUT args, if any
849: );
850:
851:
852: -- here's the delegated call to the old PL/SQL routine
853: okl_setup_trxparams_pub.create_trx_asset_parm(p_api_version,
854: p_init_msg_list,
855: x_return_status,
856: x_msg_count,
857: x_msg_data,
917: , p6_a13 out nocopy JTF_NUMBER_TABLE
918: )
919:
920: as
921: ddp_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
922: ddx_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
923: ddindx binary_integer; indx binary_integer;
924: begin
925:
918: )
919:
920: as
921: ddp_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
922: ddx_sxpv_tbl okl_setup_trxparams_pub.sxpv_tbl_type;
923: ddindx binary_integer; indx binary_integer;
924: begin
925:
926: -- copy data to the local IN or IN-OUT args, if any
946: );
947:
948:
949: -- here's the delegated call to the old PL/SQL routine
950: okl_setup_trxparams_pub.update_trx_asset_parm(p_api_version,
951: p_init_msg_list,
952: x_return_status,
953: x_msg_count,
954: x_msg_data,
978: , p6_a13
979: );
980: end;
981:
982: end okl_setup_trxparams_pub_w;