APPS.WSH_PURGE dependencies on FTE_INVOICE_HEADERS

Line 532: trip_sql := trip_sql || ',fte_invoice_headers fih ' ;

528: FROM
529: wsh_purge_set_v inner ';
530: --check whether FTE is installed
531: IF (wsh_util_core.fte_is_installed='Y') THEN
532: trip_sql := trip_sql || ',fte_invoice_headers fih ' ;
533: END IF;
534:
535: trip_sql :=trip_sql ||'WHERE ';
536:

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 1740: FROM fte_invoice_headers fih,

1736:
1737: DELETE
1738: FROM fte_invoice_lines
1739: WHERE invoice_header_id IN ( SELECT fih.invoice_header_id
1740: FROM fte_invoice_headers fih,
1741: wsh_document_instances wdi
1742: WHERE wdi.entity_id = l_leg_id
1743: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
1744: AND wdi.sequence_number = fih.bol

Line 1753: FROM fte_invoice_headers

1749: END IF;
1750: END IF;
1751:
1752: DELETE
1753: FROM fte_invoice_headers
1754: WHERE bol IN (SELECT sequence_number
1755: FROM wsh_document_instances
1756: WHERE entity_id = l_leg_id
1757: AND entity_name = 'WSH_DELIVERY_LEGS') ;

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

1757: AND entity_name = 'WSH_DELIVERY_LEGS') ;
1758:
1759: IF SQL%FOUND THEN
1760: IF l_debug_on THEN
1761: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_invoice_headers: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1762: END IF;
1763: END IF;
1764:
1765: DELETE