1: package body okl_strm_gen_template_pub_w as
2: /* $Header: OKLUTSGB.pls 120.9 2007/10/15 16:07:00 dpsingh ship $ */
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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');
134: , p6_a28 NUMBER := 0-1962.0724
135: )
136:
137: as
138: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
139: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
140: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
141: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
142: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
135: )
136:
137: as
138: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
139: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
140: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
141: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
142: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
143: ddindx binary_integer; indx binary_integer;
136:
137: as
138: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
139: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
140: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
141: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
142: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
143: ddindx binary_integer; indx binary_integer;
144: begin
137: as
138: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
139: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
140: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
141: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
142: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
143: ddindx binary_integer; indx binary_integer;
144: begin
145:
138: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
139: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
140: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
141: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
142: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
143: ddindx binary_integer; indx binary_integer;
144: begin
145:
146: -- copy data to the local IN or IN-OUT args, if any
232: );
233:
234:
235: -- here's the delegated call to the old PL/SQL routine
236: okl_strm_gen_template_pub.create_strm_gen_template(p_api_version,
237: p_init_msg_list,
238: x_return_status,
239: x_msg_count,
240: x_msg_data,
397: , p6_a28 NUMBER := 0-1962.0724
398: )
399:
400: as
401: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
402: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
403: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
404: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
405: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
398: )
399:
400: as
401: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
402: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
403: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
404: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
405: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
406: ddindx binary_integer; indx binary_integer;
399:
400: as
401: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
402: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
403: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
404: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
405: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
406: ddindx binary_integer; indx binary_integer;
407: begin
400: as
401: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
402: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
403: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
404: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
405: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
406: ddindx binary_integer; indx binary_integer;
407: begin
408:
401: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
402: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
403: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
404: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
405: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
406: ddindx binary_integer; indx binary_integer;
407: begin
408:
409: -- copy data to the local IN or IN-OUT args, if any
495: );
496:
497:
498: -- here's the delegated call to the old PL/SQL routine
499: okl_strm_gen_template_pub.update_strm_gen_template(p_api_version,
500: p_init_msg_list,
501: x_return_status,
502: x_msg_count,
503: x_msg_data,
570: , p5_a14 JTF_NUMBER_TABLE
571: )
572:
573: as
574: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
575: ddindx binary_integer; indx binary_integer;
576: begin
577:
578: -- copy data to the local IN or IN-OUT args, if any
598: , p5_a14
599: );
600:
601: -- here's the delegated call to the old PL/SQL routine
602: okl_strm_gen_template_pub.delete_tmpt_prc_params(p_api_version,
603: p_init_msg_list,
604: x_return_status,
605: x_msg_count,
606: x_msg_data,
634: , p5_a12 JTF_NUMBER_TABLE
635: )
636:
637: as
638: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
639: ddindx binary_integer; indx binary_integer;
640: begin
641:
642: -- copy data to the local IN or IN-OUT args, if any
660: , p5_a12
661: );
662:
663: -- here's the delegated call to the old PL/SQL routine
664: okl_strm_gen_template_pub.delete_pri_tmpt_lns(p_api_version,
665: p_init_msg_list,
666: x_return_status,
667: x_msg_count,
668: x_msg_data,
696: , p5_a12 JTF_NUMBER_TABLE
697: )
698:
699: as
700: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
701: ddindx binary_integer; indx binary_integer;
702: begin
703:
704: -- copy data to the local IN or IN-OUT args, if any
722: , p5_a12
723: );
724:
725: -- here's the delegated call to the old PL/SQL routine
726: okl_strm_gen_template_pub.delete_dep_tmpt_lns(p_api_version,
727: p_init_msg_list,
728: x_return_status,
729: x_msg_count,
730: x_msg_data,
762: , x_show_warn_flag out nocopy VARCHAR2
763: )
764:
765: as
766: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
767: ddindx binary_integer; indx binary_integer;
768: begin
769:
770: -- copy data to the local IN or IN-OUT args, if any
792:
793:
794:
795: -- here's the delegated call to the old PL/SQL routine
796: okl_strm_gen_template_pub.update_dep_strms(p_api_version,
797: p_init_msg_list,
798: x_return_status,
799: x_msg_count,
800: x_msg_data,
854: , p7_a28 out nocopy NUMBER
855: )
856:
857: as
858: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
859: ddindx binary_integer; indx binary_integer;
860: begin
861:
862: -- copy data to the local IN or IN-OUT args, if any
868:
869:
870:
871: -- here's the delegated call to the old PL/SQL routine
872: okl_strm_gen_template_pub.create_version_duplicate(p_api_version,
873: p_init_msg_list,
874: x_return_status,
875: x_msg_count,
876: x_msg_data,
930: , p_during_upd_flag VARCHAR2
931: )
932:
933: as
934: ddx_error_msgs_tbl okl_strm_gen_template_pub.error_msgs_tbl_type;
935: ddindx binary_integer; indx binary_integer;
936: begin
937:
938: -- copy data to the local IN or IN-OUT args, if any
945:
946:
947:
948: -- here's the delegated call to the old PL/SQL routine
949: okl_strm_gen_template_pub.validate_template(p_api_version,
950: p_init_msg_list,
951: x_return_status,
952: x_msg_count,
953: x_msg_data,
984: , x_pri_purpose_list out nocopy VARCHAR
985: )
986:
987: as
988: ddx_wrn_msgs_tbl okl_strm_gen_template_pub.error_msgs_tbl_type;
989: ddindx binary_integer; indx binary_integer;
990: begin
991:
992: -- copy data to the local IN or IN-OUT args, if any
999:
1000:
1001:
1002: -- here's the delegated call to the old PL/SQL routine
1003: okl_strm_gen_template_pub.validate_for_warnings(p_api_version,
1004: p_init_msg_list,
1005: x_return_status,
1006: x_msg_count,
1007: x_msg_data,
1164: , p6_a28 NUMBER := 0-1962.0724
1165: )
1166:
1167: as
1168: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
1169: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
1170: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
1171: ddp_pri_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1172: ddp_del_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1165: )
1166:
1167: as
1168: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
1169: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
1170: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
1171: ddp_pri_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1172: ddp_del_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1173: ddp_ins_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1166:
1167: as
1168: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
1169: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
1170: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
1171: ddp_pri_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1172: ddp_del_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1173: ddp_ins_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1174: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
1167: as
1168: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
1169: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
1170: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
1171: ddp_pri_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1172: ddp_del_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1173: ddp_ins_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1174: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
1175: ddindx binary_integer; indx binary_integer;
1168: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;
1169: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
1170: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
1171: ddp_pri_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1172: ddp_del_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1173: ddp_ins_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1174: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
1175: ddindx binary_integer; indx binary_integer;
1176: begin
1169: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
1170: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
1171: ddp_pri_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1172: ddp_del_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1173: ddp_ins_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1174: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
1175: ddindx binary_integer; indx binary_integer;
1176: begin
1177:
1170: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;
1171: ddp_pri_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1172: ddp_del_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1173: ddp_ins_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;
1174: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;
1175: ddindx binary_integer; indx binary_integer;
1176: begin
1177:
1178: -- copy data to the local IN or IN-OUT args, if any
1295:
1296:
1297:
1298: -- here's the delegated call to the old PL/SQL routine
1299: okl_strm_gen_template_pub.update_pri_dep_of_sgt(p_api_version,
1300: p_init_msg_list,
1301: x_return_status,
1302: x_msg_count,
1303: x_msg_data,
1353: p11_a28 := rosetta_g_miss_num_map(ddx_gttv_rec.last_update_login);
1354:
1355: end;
1356:
1357: end okl_strm_gen_template_pub_w;