APPS.AHL_VWP_VISIT_CST_PR_PVT_W dependencies on AHL_VWP_VISIT_CST_PR_PVT

Line 1: package body ahl_vwp_visit_cst_pr_pvt_w as

1: package body ahl_vwp_visit_cst_pr_pvt_w as
2: /* $Header: AHLWVCPB.pls 120.1 2006/05/04 07:17 anraj noship $ */
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_p1(t out nocopy ahl_vwp_visit_cst_pr_pvt.cost_price_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_p1(t out nocopy ahl_vwp_visit_cst_pr_pvt.cost_price_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE

Line 153: procedure rosetta_table_copy_out_p1(t ahl_vwp_visit_cst_pr_pvt.cost_price_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

149: end loop;
150: end if;
151: end if;
152: end rosetta_table_copy_in_p1;
153: procedure rosetta_table_copy_out_p1(t ahl_vwp_visit_cst_pr_pvt.cost_price_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_NUMBER_TABLE
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE

Line 543: ddp_x_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;

539: , x_msg_data out nocopy VARCHAR2
540: )
541:
542: as
543: ddp_x_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;
544: ddindx binary_integer; indx binary_integer;
545: begin
546:
547: -- copy data to the local IN or IN-OUT args, if any

Line 618: ahl_vwp_visit_cst_pr_pvt.get_visit_cost_details(p_api_version,

614:
615:
616:
617: -- here's the delegated call to the old PL/SQL routine
618: ahl_vwp_visit_cst_pr_pvt.get_visit_cost_details(p_api_version,
619: p_init_msg_list,
620: p_commit,
621: p_validation_level,
622: p_module_type,

Line 770: ddp_x_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;

766: , x_msg_data out nocopy VARCHAR2
767: )
768:
769: as
770: ddp_x_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;
771: ddindx binary_integer; indx binary_integer;
772: begin
773:
774: -- copy data to the local IN or IN-OUT args, if any

Line 845: ahl_vwp_visit_cst_pr_pvt.estimate_visit_cost(p_api_version,

841:
842:
843:
844: -- here's the delegated call to the old PL/SQL routine
845: ahl_vwp_visit_cst_pr_pvt.estimate_visit_cost(p_api_version,
846: p_init_msg_list,
847: p_commit,
848: p_validation_level,
849: p_module_type,

Line 997: ddp_x_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;

993: , x_msg_data out nocopy VARCHAR2
994: )
995:
996: as
997: ddp_x_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;
998: ddindx binary_integer; indx binary_integer;
999: begin
1000:
1001: -- copy data to the local IN or IN-OUT args, if any

Line 1072: ahl_vwp_visit_cst_pr_pvt.estimate_visit_price(p_api_version,

1068:
1069:
1070:
1071: -- here's the delegated call to the old PL/SQL routine
1072: ahl_vwp_visit_cst_pr_pvt.estimate_visit_price(p_api_version,
1073: p_init_msg_list,
1074: p_commit,
1075: p_validation_level,
1076: p_module_type,

Line 1224: ddp_x_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;

1220: , x_msg_data out nocopy VARCHAR2
1221: )
1222:
1223: as
1224: ddp_x_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;
1225: ddindx binary_integer; indx binary_integer;
1226: begin
1227:
1228: -- copy data to the local IN or IN-OUT args, if any

Line 1299: ahl_vwp_visit_cst_pr_pvt.create_cost_snapshot(p_api_version,

1295:
1296:
1297:
1298: -- here's the delegated call to the old PL/SQL routine
1299: ahl_vwp_visit_cst_pr_pvt.create_cost_snapshot(p_api_version,
1300: p_init_msg_list,
1301: p_commit,
1302: p_validation_level,
1303: p_module_type,

Line 1451: ddp_x_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;

1447: , x_msg_data out nocopy VARCHAR2
1448: )
1449:
1450: as
1451: ddp_x_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;
1452: ddindx binary_integer; indx binary_integer;
1453: begin
1454:
1455: -- copy data to the local IN or IN-OUT args, if any

Line 1526: ahl_vwp_visit_cst_pr_pvt.update_visit_cost_details(p_api_version,

1522:
1523:
1524:
1525: -- here's the delegated call to the old PL/SQL routine
1526: ahl_vwp_visit_cst_pr_pvt.update_visit_cost_details(p_api_version,
1527: p_init_msg_list,
1528: p_commit,
1529: p_validation_level,
1530: p_module_type,

Line 1738: ddp_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;

1734: , p9_a59 out nocopy JTF_VARCHAR2_TABLE_200
1735: )
1736:
1737: as
1738: ddp_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;
1739: ddx_cost_price_tbl ahl_vwp_visit_cst_pr_pvt.cost_price_tbl_type;
1740: ddindx binary_integer; indx binary_integer;
1741: begin
1742:

Line 1739: ddx_cost_price_tbl ahl_vwp_visit_cst_pr_pvt.cost_price_tbl_type;

1735: )
1736:
1737: as
1738: ddp_cost_price_rec ahl_vwp_visit_cst_pr_pvt.cost_price_rec_type;
1739: ddx_cost_price_tbl ahl_vwp_visit_cst_pr_pvt.cost_price_tbl_type;
1740: ddindx binary_integer; indx binary_integer;
1741: begin
1742:
1743: -- copy data to the local IN or IN-OUT args, if any

Line 1815: ahl_vwp_visit_cst_pr_pvt.get_visit_items_no_price(p_api_version,

1811: ddp_cost_price_rec.attribute15 := p8_a59;
1812:
1813:
1814: -- here's the delegated call to the old PL/SQL routine
1815: ahl_vwp_visit_cst_pr_pvt.get_visit_items_no_price(p_api_version,
1816: p_init_msg_list,
1817: p_commit,
1818: p_validation_level,
1819: p_module_type,

Line 1836: ahl_vwp_visit_cst_pr_pvt_w.rosetta_table_copy_out_p1(ddx_cost_price_tbl, p9_a0

1832:
1833:
1834:
1835:
1836: ahl_vwp_visit_cst_pr_pvt_w.rosetta_table_copy_out_p1(ddx_cost_price_tbl, p9_a0
1837: , p9_a1
1838: , p9_a2
1839: , p9_a3
1840: , p9_a4

Line 1899: end ahl_vwp_visit_cst_pr_pvt_w;

1895: , p9_a59
1896: );
1897: end;
1898:
1899: end ahl_vwp_visit_cst_pr_pvt_w;