APPS.WSH_PURGE dependencies on WSH_DELIVERY_LEG_DETAILS

Line 1691: WSH_DELIVERY_LEG_DETAILS, WSH_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,
1695: FTE_FAILURE_REASONS

Line 1815: FROM wsh_delivery_leg_details

1811: END IF;
1812: END IF;
1813:
1814: DELETE
1815: FROM wsh_delivery_leg_details
1816: WHERE delivery_leg_id = l_leg_id;
1817:
1818: IF SQL%FOUND THEN
1819: IF l_debug_on THEN

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

1816: WHERE delivery_leg_id = l_leg_id;
1817:
1818: IF SQL%FOUND THEN
1819: IF l_debug_on THEN
1820: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_leg_details: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1821: END IF;
1822: END IF;
1823:
1824: