APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_CARRIERS

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

1213: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SUPPLIER_NAME',p_from_supplier_name);
1214: --}
1215: END IF;
1216:
1217: -- Update WSH_CARRIERS with the merge to vendor/vendor site
1218: UPDATE wsh_carriers
1219: SET supplier_id = p_to_id,
1220: supplier_site_id = p_to_site_id,
1221: last_update_date = sysdate,

Line 1218: UPDATE wsh_carriers

1214: --}
1215: END IF;
1216:
1217: -- Update WSH_CARRIERS with the merge to vendor/vendor site
1218: UPDATE wsh_carriers
1219: SET supplier_id = p_to_id,
1220: supplier_site_id = p_to_site_id,
1221: last_update_date = sysdate,
1222: last_updated_by = fnd_global.user_id,

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

1225: AND supplier_site_id = p_from_site_id;
1226: --
1227: IF l_debug_on THEN
1228: --{
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