APPS.WSH_PARTY_MERGE dependencies on WSH_CARRIERS

Line 48: FROM wsh_carriers

44: l_from_carrier_num NUMBER;
45:
46: Cursor C_Carriers(p_carrier_id NUMBER) IS
47: SELECT 1
48: FROM wsh_carriers
49: WHERE carrier_id = p_carrier_id;
50: --
51: -- R12 Vendor Merge
52: --

Line 303: FROM wsh_carriers c

299: WHERE owner_party_id = p_party_id;
300:
301: CURSOR check_party_carrier_supplier(c_party_id IN NUMBER) IS
302: SELECT 3
303: FROM wsh_carriers c
304: WHERE c.carrier_id = c_party_id
305: UNION ALL
306: SELECT 4
307: FROM hz_relationships r, po_vendors v

Line 771: UPDATE wsh_carriers

767: END IF;
768: --
769: IF NOT (p_site_merge) THEN
770: --{
771: UPDATE wsh_carriers
772: SET supplier_id = p_to_id,
773: last_update_date = sysdate,
774: last_updated_by = fnd_global.user_id,
775: last_update_login = fnd_global.login_id

Line 780: wsh_debug_sv.log(l_module_name, 'No. of rows in WSH_carriers that were updated', SQL%ROWCOUNT);

776: WHERE supplier_id = p_from_id
777: AND supplier_site_id IS NULL;
778: --
779: IF l_debug_on THEN
780: wsh_debug_sv.log(l_module_name, 'No. of rows in WSH_carriers that were updated', SQL%ROWCOUNT);
781: END IF;
782: --
783: FOR check_calendar_rec IN check_calendar
784: LOOP