APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_CARRIER_SITES

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

1229: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_carriers. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
1230: --}
1231: END IF;
1232: --
1233: -- Update WSH_CARRIER_SITES with the merge to vendor site
1234: --
1235: UPDATE wsh_carrier_sites
1236: SET supplier_site_id = p_to_site_id,
1237: last_update_date = sysdate,

Line 1235: UPDATE wsh_carrier_sites

1231: END IF;
1232: --
1233: -- Update WSH_CARRIER_SITES with the merge to vendor site
1234: --
1235: UPDATE wsh_carrier_sites
1236: SET supplier_site_id = p_to_site_id,
1237: last_update_date = sysdate,
1238: last_updated_by = fnd_global.user_id,
1239: last_update_login = fnd_global.login_id

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

1240: WHERE supplier_site_id = p_from_site_id;
1241: --
1242: IF l_debug_on THEN
1243: --{
1244: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_carrier_sites. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
1245: --}
1246: END IF;
1247: --
1248: WSH_PARTY_MERGE.Update_Entities_During_Merge