APPS.WSH_PURGE dependencies on FTE_INVOICE_HEADERS

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

510: FROM
511: wsh_purge_set_v inner ';
512: --check whether FTE is installed
513: IF (wsh_util_core.fte_is_installed='Y') THEN
514: trip_sql := trip_sql || ',fte_invoice_headers fih ' ;
515: END IF;
516:
517: trip_sql := trip_sql || '
518: WHERE inner.trip_id = outer.trip_id

Line 1569: FTE_INVOICE_LINES, FTE_INVOICE_HISTORY, FTE_INVOICE_HEADERS,

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

Line 1615: FROM fte_invoice_headers fih,

1611:
1612: DELETE
1613: FROM fte_invoice_lines
1614: WHERE invoice_header_id IN ( SELECT fih.invoice_header_id
1615: FROM fte_invoice_headers fih,
1616: wsh_document_instances wdi
1617: WHERE wdi.entity_id = l_leg_id
1618: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
1619: AND wdi.sequence_number = fih.bol

Line 1628: FROM fte_invoice_headers

1624: END IF;
1625: END IF;
1626:
1627: DELETE
1628: FROM fte_invoice_headers
1629: WHERE bol IN (SELECT sequence_number
1630: FROM wsh_document_instances
1631: WHERE entity_id = l_leg_id
1632: AND entity_name = 'WSH_DELIVERY_LEGS') ;

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

1632: AND entity_name = 'WSH_DELIVERY_LEGS') ;
1633:
1634: IF SQL%FOUND THEN
1635: IF l_debug_on THEN
1636: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_invoice_headers: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1637: END IF;
1638: END IF;
1639:
1640: DELETE