APPS.WSH_PURGE dependencies on FTE_FAILURE_REASONS

Line 1695: FTE_FAILURE_REASONS

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,
1699: x_return_status OUT NOCOPY VARCHAR2

Line 1779: FROM fte_failure_reasons

1775: END IF;
1776: END IF;
1777:
1778: DELETE
1779: FROM fte_failure_reasons
1780: WHERE bol IN ( SELECT sequence_number
1781: FROM wsh_document_instances
1782: WHERE entity_id = l_leg_id
1783: AND entity_name = 'WSH_DELIVERY_LEGS') ;

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

1783: AND entity_name = 'WSH_DELIVERY_LEGS') ;
1784:
1785: IF SQL%FOUND THEN
1786: IF l_debug_on THEN
1787: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_failure_reasons: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1788: END IF;
1789: END IF;
1790:
1791: END IF;