APPS.WSH_PURGE dependencies on WSH_DELIVERY_LEG_ACTIVITIES

Line 1690: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,

1686: Input: Table of Record Types for Delivery Legs
1687: Output: Return Status - success or failure
1688: ==============================================================================
1689: Logic: i) Delete records from the following tables:
1690: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,
1691: WSH_DELIVERY_LEG_DETAILS, WSH_DELIVERY_LEGS
1692:
1693: If FTE is installed,
1694: FTE_INVOICE_LINES, FTE_INVOICE_HISTORY, FTE_INVOICE_HEADERS,

Line 1805: FROM wsh_delivery_leg_activities

1801: END IF;
1802: END IF;
1803:
1804: DELETE
1805: FROM wsh_delivery_leg_activities
1806: WHERE delivery_leg_id = l_leg_id ;
1807:
1808: IF SQL%FOUND THEN
1809: IF l_debug_on THEN

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

1806: WHERE delivery_leg_id = l_leg_id ;
1807:
1808: IF SQL%FOUND THEN
1809: IF l_debug_on THEN
1810: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_leg_activities: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1811: END IF;
1812: END IF;
1813:
1814: DELETE