APPS.WSH_CUSTOM_PUB dependencies on WSH_LOCATIONS_PKG

Line 102: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,

98: --5) For custom changes to take affect,user has to run 'Import Shipping Location' Concurrent Program.
99:
100: PROCEDURE ui_location_code (
101: p_location_type IN VARCHAR2,
102: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,

99:
100: PROCEDURE ui_location_code (
101: p_location_type IN VARCHAR2,
102: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

100: PROCEDURE ui_location_code (
101: p_location_type IN VARCHAR2,
102: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

101: p_location_type IN VARCHAR2,
102: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

102: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

Line 108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

Line 109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
113: x_use_custom_ui_location OUT NOCOPY VARCHAR2,

Line 110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
113: x_use_custom_ui_location OUT NOCOPY VARCHAR2,
114: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type

Line 111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
113: x_use_custom_ui_location OUT NOCOPY VARCHAR2,
114: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
115: ) IS

Line 112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
113: x_use_custom_ui_location OUT NOCOPY VARCHAR2,
114: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
115: ) IS
116: l_sqlcode NUMBER;

Line 114: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type

110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
113: x_use_custom_ui_location OUT NOCOPY VARCHAR2,
114: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
115: ) IS
116: l_sqlcode NUMBER;
117: l_sqlerr VARCHAR2(2000);
118: BEGIN