APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_CARRIER_SITES

Line 1240: -- Update WSH_CARRIER_SITES with the merge to vendor site

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
1241: --
1242: UPDATE wsh_carrier_sites
1243: SET supplier_site_id = p_to_site_id,
1244: last_update_date = sysdate,

Line 1242: UPDATE wsh_carrier_sites

1238: END IF;
1239: --
1240: -- Update WSH_CARRIER_SITES with the merge to vendor site
1241: --
1242: UPDATE wsh_carrier_sites
1243: SET supplier_site_id = p_to_site_id,
1244: last_update_date = sysdate,
1245: last_updated_by = fnd_global.user_id,
1246: last_update_login = fnd_global.login_id

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

1247: WHERE supplier_site_id = p_from_site_id;
1248: --
1249: IF l_debug_on THEN
1250: --{
1251: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_carrier_sites. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
1252: --}
1253: END IF;
1254: --
1255: WSH_PARTY_MERGE.Update_Entities_During_Merge