APPS.WSH_PURGE dependencies on WSH_DELIVERY_LEG_DETAILS

Line 1566: WSH_DELIVERY_LEG_DETAILS, WSH_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,
1570: FTE_FAILURE_REASONS

Line 1690: FROM wsh_delivery_leg_details

1686: END IF;
1687: END IF;
1688:
1689: DELETE
1690: FROM wsh_delivery_leg_details
1691: WHERE delivery_leg_id = l_leg_id;
1692:
1693: IF SQL%FOUND THEN
1694: IF l_debug_on THEN

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

1691: WHERE delivery_leg_id = l_leg_id;
1692:
1693: IF SQL%FOUND THEN
1694: IF l_debug_on THEN
1695: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_leg_details: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1696: END IF;
1697: END IF;
1698:
1699: