eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_VISITS_STAGES_PVT_W dependencies on AHL_VWP_VISITS_STAGES_PVT

Line 1: package body ahl_vwp_visits_stages_pvt_w as

1: package body ahl_vwp_visits_stages_pvt_w as
2: /* $Header: AHLWSTGB.pls 120.0.12020000.2 2012/12/14 06:42:50 shnatu 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 16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE

Line 87: procedure rosetta_table_copy_out_p5(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

83: end loop;
84: end if;
85: end if;
86: end rosetta_table_copy_in_p5;
87: procedure rosetta_table_copy_out_p5(t ahl_vwp_visits_stages_pvt.visit_stages_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
88: , a1 out nocopy JTF_NUMBER_TABLE
89: , a2 out nocopy JTF_VARCHAR2_TABLE_100
90: , a3 out nocopy JTF_NUMBER_TABLE
91: , a4 out nocopy JTF_DATE_TABLE

Line 241: procedure rosetta_table_copy_in_p6(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE

237: end if;
238: end if;
239: end rosetta_table_copy_out_p5;
240:
241: procedure rosetta_table_copy_in_p6(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 JTF_NUMBER_TABLE
242: , a1 JTF_NUMBER_TABLE
243: , a2 JTF_VARCHAR2_TABLE_100
244: , a3 JTF_NUMBER_TABLE
245: , a4 JTF_NUMBER_TABLE

Line 276: procedure rosetta_table_copy_out_p6(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

272: end loop;
273: end if;
274: end if;
275: end rosetta_table_copy_in_p6;
276: procedure rosetta_table_copy_out_p6(t ahl_vwp_visits_stages_pvt.visit_stages_times_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
277: , a1 out nocopy JTF_NUMBER_TABLE
278: , a2 out nocopy JTF_VARCHAR2_TABLE_100
279: , a3 out nocopy JTF_NUMBER_TABLE
280: , a4 out nocopy JTF_NUMBER_TABLE

Line 340: procedure rosetta_table_copy_in_p7(t out nocopy ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 JTF_NUMBER_TABLE

336: end if;
337: end if;
338: end rosetta_table_copy_out_p6;
339:
340: procedure rosetta_table_copy_in_p7(t out nocopy ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 JTF_NUMBER_TABLE
341: , a1 JTF_NUMBER_TABLE
342: , a2 JTF_VARCHAR2_TABLE_100
343: , a3 JTF_VARCHAR2_TABLE_100
344: ) as

Line 365: procedure rosetta_table_copy_out_p7(t ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

361: end loop;
362: end if;
363: end if;
364: end rosetta_table_copy_in_p7;
365: procedure rosetta_table_copy_out_p7(t ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
366: , a1 out nocopy JTF_NUMBER_TABLE
367: , a2 out nocopy JTF_VARCHAR2_TABLE_100
368: , a3 out nocopy JTF_VARCHAR2_TABLE_100
369: ) as

Line 404: procedure rosetta_table_copy_in_p8(t out nocopy ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 JTF_NUMBER_TABLE

400: end if;
401: end if;
402: end rosetta_table_copy_out_p7;
403:
404: procedure rosetta_table_copy_in_p8(t out nocopy ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 JTF_NUMBER_TABLE
405: , a1 JTF_NUMBER_TABLE
406: , a2 JTF_VARCHAR2_TABLE_100
407: ) as
408: ddindx binary_integer; indx binary_integer;

Line 427: procedure rosetta_table_copy_out_p8(t ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

423: end loop;
424: end if;
425: end if;
426: end rosetta_table_copy_in_p8;
427: procedure rosetta_table_copy_out_p8(t ahl_vwp_visits_stages_pvt.stage_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
428: , a1 out nocopy JTF_NUMBER_TABLE
429: , a2 out nocopy JTF_VARCHAR2_TABLE_100
430: ) as
431: ddindx binary_integer; indx binary_integer;

Line 461: procedure rosetta_table_copy_in_p9(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 JTF_NUMBER_TABLE

457: end if;
458: end if;
459: end rosetta_table_copy_out_p8;
460:
461: procedure rosetta_table_copy_in_p9(t out nocopy ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 JTF_NUMBER_TABLE
462: , a1 JTF_NUMBER_TABLE
463: ) as
464: ddindx binary_integer; indx binary_integer;
465: begin

Line 482: procedure rosetta_table_copy_out_p9(t ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

478: end loop;
479: end if;
480: end if;
481: end rosetta_table_copy_in_p9;
482: procedure rosetta_table_copy_out_p9(t ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
483: , a1 out nocopy JTF_NUMBER_TABLE
484: ) as
485: ddindx binary_integer; indx binary_integer;
486: begin

Line 552: ddp_x_stages_tbl ahl_vwp_visits_stages_pvt.visit_stages_tbl_type;

548: , x_msg_data out nocopy VARCHAR2
549: )
550:
551: as
552: ddp_x_stages_tbl ahl_vwp_visits_stages_pvt.visit_stages_tbl_type;
553: ddp_x_stages_ovn_tbl ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type;
554: ddindx binary_integer; indx binary_integer;
555: begin
556:

Line 553: ddp_x_stages_ovn_tbl ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type;

549: )
550:
551: as
552: ddp_x_stages_tbl ahl_vwp_visits_stages_pvt.visit_stages_tbl_type;
553: ddp_x_stages_ovn_tbl ahl_vwp_visits_stages_pvt.visit_stages_ovn_tbl_type;
554: ddindx binary_integer; indx binary_integer;
555: begin
556:
557: -- copy data to the local IN or IN-OUT args, if any

Line 564: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_in_p5(ddp_x_stages_tbl, p6_a0

560:
561:
562:
563:
564: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_in_p5(ddp_x_stages_tbl, p6_a0
565: , p6_a1
566: , p6_a2
567: , p6_a3
568: , p6_a4

Line 593: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_in_p9(ddp_x_stages_ovn_tbl, p7_a0

589: , p6_a25
590: , p6_a26
591: );
592:
593: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_in_p9(ddp_x_stages_ovn_tbl, p7_a0
594: , p7_a1
595: );
596:
597:

Line 601: ahl_vwp_visits_stages_pvt.update_stages(p_api_version,

597:
598:
599:
600: -- here's the delegated call to the old PL/SQL routine
601: ahl_vwp_visits_stages_pvt.update_stages(p_api_version,
602: p_init_msg_list,
603: p_commit,
604: p_validation_level,
605: p_module_type,

Line 620: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p5(ddp_x_stages_tbl, p6_a0

616:
617:
618:
619:
620: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p5(ddp_x_stages_tbl, p6_a0
621: , p6_a1
622: , p6_a2
623: , p6_a3
624: , p6_a4

Line 649: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p9(ddp_x_stages_ovn_tbl, p7_a0

645: , p6_a25
646: , p6_a26
647: );
648:
649: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p9(ddp_x_stages_ovn_tbl, p7_a0
650: , p7_a1
651: );
652:
653:

Line 699: ddx_stages_tbl ahl_vwp_visits_stages_pvt.visit_stages_tbl_type;

695: , x_msg_data out nocopy VARCHAR2
696: )
697:
698: as
699: ddx_stages_tbl ahl_vwp_visits_stages_pvt.visit_stages_tbl_type;
700: ddindx binary_integer; indx binary_integer;
701: begin
702:
703: -- copy data to the local IN or IN-OUT args, if any

Line 718: ahl_vwp_visits_stages_pvt.get_stages_details(p_api_version,

714:
715:
716:
717: -- here's the delegated call to the old PL/SQL routine
718: ahl_vwp_visits_stages_pvt.get_stages_details(p_api_version,
719: p_init_msg_list,
720: p_commit,
721: p_validation_level,
722: p_module_type,

Line 741: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p5(ddx_stages_tbl, p8_a0

737:
738:
739:
740:
741: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p5(ddx_stages_tbl, p8_a0
742: , p8_a1
743: , p8_a2
744: , p8_a3
745: , p8_a4

Line 814: ddp_x_stages_tbl ahl_vwp_visits_stages_pvt.visit_stages_tbl_type;

810: , x_msg_data out nocopy VARCHAR2
811: )
812:
813: as
814: ddp_x_stages_tbl ahl_vwp_visits_stages_pvt.visit_stages_tbl_type;
815: ddindx binary_integer; indx binary_integer;
816: begin
817:
818: -- copy data to the local IN or IN-OUT args, if any

Line 825: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_in_p5(ddp_x_stages_tbl, p6_a0

821:
822:
823:
824:
825: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_in_p5(ddp_x_stages_tbl, p6_a0
826: , p6_a1
827: , p6_a2
828: , p6_a3
829: , p6_a4

Line 858: ahl_vwp_visits_stages_pvt.create_stages(p_api_version,

854:
855:
856:
857: -- here's the delegated call to the old PL/SQL routine
858: ahl_vwp_visits_stages_pvt.create_stages(p_api_version,
859: p_init_msg_list,
860: p_commit,
861: p_validation_level,
862: p_module_type,

Line 876: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p5(ddp_x_stages_tbl, p6_a0

872:
873:
874:
875:
876: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p5(ddp_x_stages_tbl, p6_a0
877: , p6_a1
878: , p6_a2
879: , p6_a3
880: , p6_a4

Line 948: ddp_x_stages_tbl ahl_vwp_visits_stages_pvt.visit_stages_tbl_type;

944: , x_msg_data out nocopy VARCHAR2
945: )
946:
947: as
948: ddp_x_stages_tbl ahl_vwp_visits_stages_pvt.visit_stages_tbl_type;
949: ddindx binary_integer; indx binary_integer;
950: begin
951:
952: -- copy data to the local IN or IN-OUT args, if any

Line 959: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_in_p5(ddp_x_stages_tbl, p6_a0

955:
956:
957:
958:
959: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_in_p5(ddp_x_stages_tbl, p6_a0
960: , p6_a1
961: , p6_a2
962: , p6_a3
963: , p6_a4

Line 992: ahl_vwp_visits_stages_pvt.delete_stages(p_api_version,

988:
989:
990:
991: -- here's the delegated call to the old PL/SQL routine
992: ahl_vwp_visits_stages_pvt.delete_stages(p_api_version,
993: p_init_msg_list,
994: p_commit,
995: p_validation_level,
996: p_module_type,

Line 1010: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p5(ddp_x_stages_tbl, p6_a0

1006:
1007:
1008:
1009:
1010: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_out_p5(ddp_x_stages_tbl, p6_a0
1011: , p6_a1
1012: , p6_a2
1013: , p6_a3
1014: , p6_a4

Line 1057: ddp_stage_type_assoc_tbl ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type;

1053: , x_msg_data out nocopy VARCHAR2
1054: )
1055:
1056: as
1057: ddp_stage_type_assoc_tbl ahl_vwp_visits_stages_pvt.stage_type_assoc_tbl_type;
1058: ddindx binary_integer; indx binary_integer;
1059: begin
1060:
1061: -- copy data to the local IN or IN-OUT args, if any

Line 1066: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_in_p7(ddp_stage_type_assoc_tbl, p4_a0

1062:
1063:
1064:
1065:
1066: ahl_vwp_visits_stages_pvt_w.rosetta_table_copy_in_p7(ddp_stage_type_assoc_tbl, p4_a0
1067: , p4_a1
1068: , p4_a2
1069: , p4_a3
1070: );

Line 1076: ahl_vwp_visits_stages_pvt.process_stagetyp_assoc(p_api_version,

1072:
1073:
1074:
1075: -- here's the delegated call to the old PL/SQL routine
1076: ahl_vwp_visits_stages_pvt.process_stagetyp_assoc(p_api_version,
1077: p_init_msg_list,
1078: p_commit,
1079: p_validation_level,
1080: ddp_stage_type_assoc_tbl,

Line 1104: ddp_stage_rule_rec ahl_vwp_visits_stages_pvt.stage_rule_rec_type;

1100: , x_msg_data out nocopy VARCHAR2
1101: )
1102:
1103: as
1104: ddp_stage_rule_rec ahl_vwp_visits_stages_pvt.stage_rule_rec_type;
1105: ddindx binary_integer; indx binary_integer;
1106: begin
1107:
1108: -- copy data to the local IN or IN-OUT args, if any

Line 1117: ahl_vwp_visits_stages_pvt.validate_stage_rules(ddp_stage_rule_rec,

1113:
1114:
1115:
1116: -- here's the delegated call to the old PL/SQL routine
1117: ahl_vwp_visits_stages_pvt.validate_stage_rules(ddp_stage_rule_rec,
1118: x_return_status,
1119: x_msg_count,
1120: x_msg_data);
1121:

Line 1128: end ahl_vwp_visits_stages_pvt_w;

1124:
1125:
1126: end;
1127:
1128: end ahl_vwp_visits_stages_pvt_w;