APPS.AHL_VWP_VISITS_PVT_W dependencies on AHL_VWP_VISITS_PVT

Line 1: package body ahl_vwp_visits_pvt_w as

1: package body ahl_vwp_visits_pvt_w as
2: /* $Header: AHLWVSTB.pls 120.2 2007/12/18 09:57:23 sowsubra 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_p3(t out nocopy ahl_vwp_visits_pvt.visit_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_p3(t out nocopy ahl_vwp_visits_pvt.visit_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE

Line 189: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

185: end loop;
186: end if;
187: end if;
188: end rosetta_table_copy_in_p3;
189: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
190: , a1 out nocopy JTF_VARCHAR2_TABLE_100
191: , a2 out nocopy JTF_NUMBER_TABLE
192: , a3 out nocopy JTF_NUMBER_TABLE
193: , a4 out nocopy JTF_DATE_TABLE

Line 598: procedure rosetta_table_copy_in_p4(t out nocopy ahl_vwp_visits_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE

594: end if;
595: end if;
596: end rosetta_table_copy_out_p3;
597:
598: procedure rosetta_table_copy_in_p4(t out nocopy ahl_vwp_visits_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE
599: , a1 JTF_VARCHAR2_TABLE_100
600: , a2 JTF_VARCHAR2_TABLE_100
601: , a3 JTF_VARCHAR2_TABLE_100
602: , a4 JTF_VARCHAR2_TABLE_100

Line 631: procedure rosetta_table_copy_out_p4(t ahl_vwp_visits_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

627: end loop;
628: end if;
629: end if;
630: end rosetta_table_copy_in_p4;
631: procedure rosetta_table_copy_out_p4(t ahl_vwp_visits_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
632: , a1 out nocopy JTF_VARCHAR2_TABLE_100
633: , a2 out nocopy JTF_VARCHAR2_TABLE_100
634: , a3 out nocopy JTF_VARCHAR2_TABLE_100
635: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 779: ddp_x_visit_tbl ahl_vwp_visits_pvt.visit_tbl_type;

775: , x_msg_data out nocopy VARCHAR2
776: )
777:
778: as
779: ddp_x_visit_tbl ahl_vwp_visits_pvt.visit_tbl_type;
780: ddindx binary_integer; indx binary_integer;
781: begin
782:
783: -- copy data to the local IN or IN-OUT args, if any

Line 789: ahl_vwp_visits_pvt_w.rosetta_table_copy_in_p3(ddp_x_visit_tbl, p5_a0

785:
786:
787:
788:
789: ahl_vwp_visits_pvt_w.rosetta_table_copy_in_p3(ddp_x_visit_tbl, p5_a0
790: , p5_a1
791: , p5_a2
792: , p5_a3
793: , p5_a4

Line 873: ahl_vwp_visits_pvt.process_visit(p_api_version,

869:
870:
871:
872: -- here's the delegated call to the old PL/SQL routine
873: ahl_vwp_visits_pvt.process_visit(p_api_version,
874: p_init_msg_list,
875: p_commit,
876: p_validation_level,
877: p_module_type,

Line 889: ahl_vwp_visits_pvt_w.rosetta_table_copy_out_p3(ddp_x_visit_tbl, p5_a0

885:
886:
887:
888:
889: ahl_vwp_visits_pvt_w.rosetta_table_copy_out_p3(ddp_x_visit_tbl, p5_a0
890: , p5_a1
891: , p5_a2
892: , p5_a3
893: , p5_a4

Line 1063: ddx_visit_rec ahl_vwp_visits_pvt.visit_rec_type;

1059: , x_msg_data out nocopy VARCHAR2
1060: )
1061:
1062: as
1063: ddx_visit_rec ahl_vwp_visits_pvt.visit_rec_type;
1064: ddindx binary_integer; indx binary_integer;
1065: begin
1066:
1067: -- copy data to the local IN or IN-OUT args, if any

Line 1079: ahl_vwp_visits_pvt.get_visit_details(p_api_version,

1075:
1076:
1077:
1078: -- here's the delegated call to the old PL/SQL routine
1079: ahl_vwp_visits_pvt.get_visit_details(p_api_version,
1080: p_init_msg_list,
1081: p_commit,
1082: p_validation_level,
1083: p_module_type,

Line 1180: end ahl_vwp_visits_pvt_w;

1176:
1177:
1178: end;
1179:
1180: end ahl_vwp_visits_pvt_w;