APPS.WSH_PURGE dependencies on WSH_DELIVERY_LEG_ACTIVITIES

Line 1565: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,

1561: Input: Table of Record Types for Delivery Legs
1562: Output: Return Status - success or failure
1563: ==============================================================================
1564: Logic: i) Delete records from the following tables:
1565: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,
1566: WSH_DELIVERY_LEG_DETAILS, WSH_DELIVERY_LEGS
1567:
1568: If FTE is installed,
1569: FTE_INVOICE_LINES, FTE_INVOICE_HISTORY, FTE_INVOICE_HEADERS,

Line 1680: FROM wsh_delivery_leg_activities

1676: END IF;
1677: END IF;
1678:
1679: DELETE
1680: FROM wsh_delivery_leg_activities
1681: WHERE delivery_leg_id = l_leg_id ;
1682:
1683: IF SQL%FOUND THEN
1684: IF l_debug_on THEN

Line 1685: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_leg_activities: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1681: WHERE delivery_leg_id = l_leg_id ;
1682:
1683: IF SQL%FOUND THEN
1684: IF l_debug_on THEN
1685: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_leg_activities: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1686: END IF;
1687: END IF;
1688:
1689: DELETE