DBA Data[Home] [Help]

APPS.WSH_PARTY_MERGE dependencies on WSH_PICKING_RULES

Line 1565: -- merge. Also updates Wsh_Picking_Rules tables during party merge.

1561: --
1562: -- COMMENT :
1563: -- To update locations in Wsh_Delivery_Details, Wsh_New_Deliveries,
1564: -- Wsh_Trip_Stops tables for Unshipped delivery lines during party
1565: -- merge. Also updates Wsh_Picking_Rules tables during party merge.
1566: -- ============================================================================
1567: PROCEDURE merge_location(
1568: p_entity_name IN VARCHAR2,
1569: p_from_id IN NUMBER,

Line 2761: UPDATE WSH_PICKING_RULES WPR

2757: WSH_DEBUG_SV.log(l_module_name, 'Before WPR Update', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));
2758: END IF;
2759: --
2760:
2761: UPDATE WSH_PICKING_RULES WPR
2762: SET ship_to_location_id = l_to_location_id,
2763: last_update_date = SYSDATE,
2764: last_updated_by = fnd_global.user_id,
2765: last_update_login = fnd_global.conc_login_id,