eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CUSTOM_PUB dependencies on WSH_LOCATIONS

Line 108: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,

104: --5) For custom changes to take affect,user has to run 'Import Shipping Location' Concurrent Program.
105:
106: PROCEDURE ui_location_code (
107: p_location_type IN VARCHAR2,
108: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
109: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
110: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
112: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 109: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,

105:
106: PROCEDURE ui_location_code (
107: p_location_type IN VARCHAR2,
108: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
109: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
110: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
112: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
113: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 110: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

106: PROCEDURE ui_location_code (
107: p_location_type IN VARCHAR2,
108: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
109: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
110: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
112: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
113: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
114: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 111: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

107: p_location_type IN VARCHAR2,
108: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
109: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
110: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
112: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
113: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
114: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
115: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 112: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

108: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
109: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
110: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
112: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
113: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
114: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
115: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
116: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 113: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

109: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
110: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
112: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
113: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
114: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
115: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
116: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
117: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

Line 114: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

110: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
112: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
113: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
114: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
115: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
116: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
117: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
118: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

Line 115: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

111: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
112: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
113: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
114: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
115: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
116: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
117: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
118: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
119: x_use_custom_ui_location OUT NOCOPY VARCHAR2,

Line 116: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

112: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
113: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
114: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
115: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
116: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
117: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
118: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
119: x_use_custom_ui_location OUT NOCOPY VARCHAR2,
120: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type

Line 117: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

113: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
114: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
115: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
116: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
117: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
118: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
119: x_use_custom_ui_location OUT NOCOPY VARCHAR2,
120: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
121: ) IS

Line 118: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

114: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
115: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
116: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
117: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
118: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
119: x_use_custom_ui_location OUT NOCOPY VARCHAR2,
120: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
121: ) IS
122: l_sqlcode NUMBER;

Line 120: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type

116: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
117: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
118: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
119: x_use_custom_ui_location OUT NOCOPY VARCHAR2,
120: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
121: ) IS
122: l_sqlcode NUMBER;
123: l_sqlerr VARCHAR2(2000);
124: BEGIN

Line 1673: FROM wsh_locations w1

1669: l_rate_query := l_rate_query|| ' ) , xmlelement("ns2:ShipmentServiceOptions",xmlelement("ns2:SaturdayPickupIndicator",:b11)
1670: ,xmlelement("ns2:SaturdayDeliveryIndicator",:b12 ) )';
1671:
1672: l_rate_query := l_rate_query ||'))))
1673: FROM wsh_locations w1
1674: , wsh_locations w2
1675: WHERE w1.source_location_id = :b13
1676: AND w2.source_location_id = :b14 ';
1677:

Line 1674: , wsh_locations w2

1670: ,xmlelement("ns2:SaturdayDeliveryIndicator",:b12 ) )';
1671:
1672: l_rate_query := l_rate_query ||'))))
1673: FROM wsh_locations w1
1674: , wsh_locations w2
1675: WHERE w1.source_location_id = :b13
1676: AND w2.source_location_id = :b14 ';
1677:
1678:

Line 2761: FROM wsh_locations wl

2757: )
2758: )
2759: )
2760: )
2761: FROM wsh_locations wl
2762: , wsh_locations w2
2763: WHERE wl.source_location_id = p_request_in.ship_from_location_id
2764: AND w2.source_location_id = p_request_in.ship_to_location_id;
2765:

Line 2762: , wsh_locations w2

2758: )
2759: )
2760: )
2761: FROM wsh_locations wl
2762: , wsh_locations w2
2763: WHERE wl.source_location_id = p_request_in.ship_from_location_id
2764: AND w2.source_location_id = p_request_in.ship_to_location_id;
2765:
2766: BEGIN