APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_CARRIERS

Line 1224: -- Update WSH_CARRIERS with the merge to vendor/vendor site

1220: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SUPPLIER_NAME',p_from_supplier_name);
1221: --}
1222: END IF;
1223:
1224: -- Update WSH_CARRIERS with the merge to vendor/vendor site
1225: UPDATE wsh_carriers
1226: SET supplier_id = p_to_id,
1227: supplier_site_id = p_to_site_id,
1228: last_update_date = sysdate,

Line 1225: UPDATE wsh_carriers

1221: --}
1222: END IF;
1223:
1224: -- Update WSH_CARRIERS with the merge to vendor/vendor site
1225: UPDATE wsh_carriers
1226: SET supplier_id = p_to_id,
1227: supplier_site_id = p_to_site_id,
1228: last_update_date = sysdate,
1229: last_updated_by = fnd_global.user_id,

Line 1236: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_carriers. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);

1232: AND supplier_site_id = p_from_site_id;
1233: --
1234: IF l_debug_on THEN
1235: --{
1236: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_carriers. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
1237: --}
1238: END IF;
1239: --
1240: -- Update WSH_CARRIER_SITES with the merge to vendor site