2: /* $Header: WSHFACIS.pls 115.0 2003/09/05 01:33:33 arguha noship $ */
3:
4: -- Procedure : Create_Facilities
5: -- Purpose : Create facilities using the location ids in p_location_ids.
6: PROCEDURE Create_Facilities (p_location_ids IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
7: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
8: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_error_msg OUT NOCOPY VARCHAR2);
3:
4: -- Procedure : Create_Facilities
5: -- Purpose : Create facilities using the location ids in p_location_ids.
6: PROCEDURE Create_Facilities (p_location_ids IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
7: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
8: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_error_msg OUT NOCOPY VARCHAR2);
11:
4: -- Procedure : Create_Facilities
5: -- Purpose : Create facilities using the location ids in p_location_ids.
6: PROCEDURE Create_Facilities (p_location_ids IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
7: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
8: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_error_msg OUT NOCOPY VARCHAR2);
11:
12: -- +======================================================================+