APPS.WSH_PURGE dependencies on FTE_FAILURE_REASONS

Line 1570: FTE_FAILURE_REASONS

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
1571: -----------------------------------------------------------------------------*/
1572:
1573: PROCEDURE Purge_Delivery_Legs( p_tbl_del_leg_purge_set Del_Leg_ID_Tbl_Type,
1574: x_return_status OUT NOCOPY VARCHAR2

Line 1654: FROM fte_failure_reasons

1650: END IF;
1651: END IF;
1652:
1653: DELETE
1654: FROM fte_failure_reasons
1655: WHERE bol IN ( SELECT sequence_number
1656: FROM wsh_document_instances
1657: WHERE entity_id = l_leg_id
1658: AND entity_name = 'WSH_DELIVERY_LEGS') ;

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

1658: AND entity_name = 'WSH_DELIVERY_LEGS') ;
1659:
1660: IF SQL%FOUND THEN
1661: IF l_debug_on THEN
1662: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_failure_reasons: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1663: END IF;
1664: END IF;
1665:
1666: END IF;