DBA Data[Home] [Help]

APPS.OKL_STRM_GEN_TEMPLATE_PUB_W dependencies on OKL_STRM_GEN_TEMPLATE_PUB

Line 1: package body okl_strm_gen_template_pub_w as

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');

Line 138: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;

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;

Line 139: ddp_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;

Line 140: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;

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

Line 141: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;

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:

Line 142: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;

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

Line 236: okl_strm_gen_template_pub.create_strm_gen_template(p_api_version,

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,

Line 401: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;

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;

Line 402: ddp_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;

Line 403: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;

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

Line 404: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;

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:

Line 405: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;

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

Line 499: okl_strm_gen_template_pub.update_strm_gen_template(p_api_version,

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,

Line 574: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_tbl_type;

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

Line 602: okl_strm_gen_template_pub.delete_tmpt_prc_params(p_api_version,

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,

Line 638: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;

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

Line 664: okl_strm_gen_template_pub.delete_pri_tmpt_lns(p_api_version,

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,

Line 700: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;

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

Line 726: okl_strm_gen_template_pub.delete_dep_tmpt_lns(p_api_version,

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,

Line 766: ddp_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;

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

Line 796: okl_strm_gen_template_pub.update_dep_strms(p_api_version,

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,

Line 858: ddx_gttv_rec okl_strm_gen_template_pub.gttv_rec_type;

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

Line 872: okl_strm_gen_template_pub.create_version_duplicate(p_api_version,

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,

Line 934: ddx_error_msgs_tbl okl_strm_gen_template_pub.error_msgs_tbl_type;

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

Line 949: okl_strm_gen_template_pub.validate_template(p_api_version,

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,

Line 988: ddx_wrn_msgs_tbl okl_strm_gen_template_pub.error_msgs_tbl_type;

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

Line 1003: okl_strm_gen_template_pub.validate_for_warnings(p_api_version,

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,

Line 1168: ddp_gtsv_rec okl_strm_gen_template_pub.gtsv_rec_type;

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;

Line 1169: ddp_gttv_rec okl_strm_gen_template_pub.gttv_rec_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;

Line 1170: ddp_gtpv_tbl okl_strm_gen_template_pub.gtpv_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;

Line 1171: ddp_pri_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_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;

Line 1172: ddp_del_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_type;

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

Line 1173: ddp_ins_dep_gtlv_tbl okl_strm_gen_template_pub.gtlv_tbl_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
1177:

Line 1174: ddx_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:
1178: -- copy data to the local IN or IN-OUT args, if any

Line 1299: okl_strm_gen_template_pub.update_pri_dep_of_sgt(p_api_version,

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,

Line 1357: end okl_strm_gen_template_pub_w;

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;