DBA Data[Home] [Help]

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.5.12020000.2 2012/12/11 05:59:40 prakkum ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_pvt.visit_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_pvt.visit_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ahl_vwp_visits_pvt_w as
2: /* $Header: AHLWVSTB.pls 120.5.12020000.2 2012/12/11 05:59:40 prakkum ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_pvt.visit_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

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

218: end loop;
219: end if;
220: end if;
221: end rosetta_table_copy_in_p3;
222: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
223: , a1 out nocopy JTF_VARCHAR2_TABLE_100
224: , a2 out nocopy JTF_NUMBER_TABLE
225: , a3 out nocopy JTF_NUMBER_TABLE
226: , a4 out nocopy JTF_DATE_TABLE

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

742: end if;
743: end if;
744: end rosetta_table_copy_out_p3;
745:
746: procedure rosetta_table_copy_in_p4(t out nocopy ahl_vwp_visits_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE
747: , a1 JTF_VARCHAR2_TABLE_100
748: , a2 JTF_VARCHAR2_TABLE_100
749: , a3 JTF_VARCHAR2_TABLE_100
750: , a4 JTF_VARCHAR2_TABLE_100

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

775: end loop;
776: end if;
777: end if;
778: end rosetta_table_copy_in_p4;
779: procedure rosetta_table_copy_out_p4(t ahl_vwp_visits_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
780: , a1 out nocopy JTF_VARCHAR2_TABLE_100
781: , a2 out nocopy JTF_VARCHAR2_TABLE_100
782: , a3 out nocopy JTF_VARCHAR2_TABLE_100
783: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 950: ddp_x_visit_tbl ahl_vwp_visits_pvt.visit_tbl_type;

946: , x_msg_data out nocopy VARCHAR2
947: )
948:
949: as
950: ddp_x_visit_tbl ahl_vwp_visits_pvt.visit_tbl_type;
951: ddindx binary_integer; indx binary_integer;
952: begin
953:
954: -- copy data to the local IN or IN-OUT args, if any

Line 960: ahl_vwp_visits_pvt_w.rosetta_table_copy_in_p3(ddp_x_visit_tbl, p5_a0

956:
957:
958:
959:
960: ahl_vwp_visits_pvt_w.rosetta_table_copy_in_p3(ddp_x_visit_tbl, p5_a0
961: , p5_a1
962: , p5_a2
963: , p5_a3
964: , p5_a4

Line 1067: ahl_vwp_visits_pvt.process_visit(p_api_version,

1063:
1064:
1065:
1066: -- here's the delegated call to the old PL/SQL routine
1067: ahl_vwp_visits_pvt.process_visit(p_api_version,
1068: p_init_msg_list,
1069: p_commit,
1070: p_validation_level,
1071: p_module_type,

Line 1083: ahl_vwp_visits_pvt_w.rosetta_table_copy_out_p3(ddp_x_visit_tbl, p5_a0

1079:
1080:
1081:
1082:
1083: ahl_vwp_visits_pvt_w.rosetta_table_copy_out_p3(ddp_x_visit_tbl, p5_a0
1084: , p5_a1
1085: , p5_a2
1086: , p5_a3
1087: , p5_a4

Line 1303: ddx_visit_rec ahl_vwp_visits_pvt.visit_rec_type;

1299: , x_msg_data out nocopy VARCHAR2
1300: )
1301:
1302: as
1303: ddx_visit_rec ahl_vwp_visits_pvt.visit_rec_type;
1304: ddindx binary_integer; indx binary_integer;
1305: begin
1306:
1307: -- copy data to the local IN or IN-OUT args, if any

Line 1319: ahl_vwp_visits_pvt.get_visit_details(p_api_version,

1315:
1316:
1317:
1318: -- here's the delegated call to the old PL/SQL routine
1319: ahl_vwp_visits_pvt.get_visit_details(p_api_version,
1320: p_init_msg_list,
1321: p_commit,
1322: p_validation_level,
1323: p_module_type,

Line 1555: ddp_visit_rec ahl_vwp_visits_pvt.visit_rec_type;

1551: , x_msg_data out nocopy VARCHAR2
1552: )
1553:
1554: as
1555: ddp_visit_rec ahl_vwp_visits_pvt.visit_rec_type;
1556: ddindx binary_integer; indx binary_integer;
1557: begin
1558:
1559: -- copy data to the local IN or IN-OUT args, if any

Line 1671: ahl_vwp_visits_pvt.validate_component_visit(p_api_version,

1667:
1668:
1669:
1670: -- here's the delegated call to the old PL/SQL routine
1671: ahl_vwp_visits_pvt.validate_component_visit(p_api_version,
1672: p_init_msg_list,
1673: p_commit,
1674: p_validation_level,
1675: p_module_type,

Line 1804: ddp_x_visit_rec ahl_vwp_visits_pvt.visit_rec_type;

1800: , x_msg_data out nocopy VARCHAR2
1801: )
1802:
1803: as
1804: ddp_x_visit_rec ahl_vwp_visits_pvt.visit_rec_type;
1805: ddindx binary_integer; indx binary_integer;
1806: begin
1807:
1808: -- copy data to the local IN or IN-OUT args, if any

Line 1920: ahl_vwp_visits_pvt.create_visit(p_api_version,

1916:
1917:
1918:
1919: -- here's the delegated call to the old PL/SQL routine
1920: ahl_vwp_visits_pvt.create_visit(p_api_version,
1921: p_init_msg_list,
1922: p_commit,
1923: p_validation_level,
1924: p_module_type,

Line 2154: ddp_x_visit_rec ahl_vwp_visits_pvt.visit_rec_type;

2150: , x_msg_data out nocopy VARCHAR2
2151: )
2152:
2153: as
2154: ddp_x_visit_rec ahl_vwp_visits_pvt.visit_rec_type;
2155: ddindx binary_integer; indx binary_integer;
2156: begin
2157:
2158: -- copy data to the local IN or IN-OUT args, if any

Line 2270: ahl_vwp_visits_pvt.update_visit(p_api_version,

2266:
2267:
2268:
2269: -- here's the delegated call to the old PL/SQL routine
2270: ahl_vwp_visits_pvt.update_visit(p_api_version,
2271: p_init_msg_list,
2272: p_commit,
2273: p_validation_level,
2274: p_module_type,

Line 2392: end ahl_vwp_visits_pvt_w;

2388:
2389:
2390: end;
2391:
2392: end ahl_vwp_visits_pvt_w;