36:
37:
38: TYPE TL_FAC_INFO_TAB_TYPE IS TABLE OF TL_FAC_INFO_REC_TYPE INDEX BY BINARY_INTEGER;
39:
40: PROCEDURE Create_Facilities (p_location_ids IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
41: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
42: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_error_msg OUT NOCOPY VARCHAR2);
37:
38: TYPE TL_FAC_INFO_TAB_TYPE IS TABLE OF TL_FAC_INFO_REC_TYPE INDEX BY BINARY_INTEGER;
39:
40: PROCEDURE Create_Facilities (p_location_ids IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
41: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
42: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_error_msg OUT NOCOPY VARCHAR2);
45:
38: TYPE TL_FAC_INFO_TAB_TYPE IS TABLE OF TL_FAC_INFO_REC_TYPE INDEX BY BINARY_INTEGER;
39:
40: PROCEDURE Create_Facilities (p_location_ids IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
41: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
42: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_error_msg OUT NOCOPY VARCHAR2);
45:
46: PROCEDURE Create_Facility (p_location_id IN NUMBER,