APPS.WSH_PURGE dependencies on FTE_INVOICE_HISTORY

Line 1694: FTE_INVOICE_LINES, FTE_INVOICE_HISTORY, FTE_INVOICE_HEADERS,

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
1696: -----------------------------------------------------------------------------*/
1697:
1698: PROCEDURE Purge_Delivery_Legs( p_tbl_del_leg_purge_set Del_Leg_ID_Tbl_Type,

Line 1766: FROM fte_invoice_history

1762: END IF;
1763: END IF;
1764:
1765: DELETE
1766: FROM fte_invoice_history
1767: WHERE bol IN (SELECT sequence_number
1768: FROM wsh_document_instances
1769: WHERE entity_id = l_leg_id
1770: AND entity_name = 'WSH_DELIVERY_LEGS') ;

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

1770: AND entity_name = 'WSH_DELIVERY_LEGS') ;
1771:
1772: IF SQL%FOUND THEN
1773: IF l_debug_on THEN
1774: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_invoice_history: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1775: END IF;
1776: END IF;
1777:
1778: DELETE