APPS.WSH_PURGE dependencies on WSH_DOCUMENT_INSTANCES

Line 1219: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES,WSH_TRIPS

1215: Input: Table of Record Types for Trips
1216: Output: Return Status - success or failure
1217: ==============================================================================
1218: Logic: i) Delete records from the following tables:
1219: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES,WSH_TRIPS
1220: -----------------------------------------------------------------------------*/
1221:
1222: PROCEDURE Purge_Trips( p_tbl_trip_purge_set Trip_ID_Tbl_Type,
1223: x_return_status OUT NOCOPY VARCHAR2

Line 1272: FROM wsh_document_instances

1268: END IF;
1269: END IF;
1270:
1271: DELETE
1272: FROM wsh_document_instances
1273: WHERE entity_id = l_trip_id
1274: AND entity_name = 'WSH_TRIPS';
1275:
1276: IF SQL%FOUND THEN

Line 1278: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_document_instances: TRIP_ID=' || l_trip_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1274: AND entity_name = 'WSH_TRIPS';
1275:
1276: IF SQL%FOUND THEN
1277: IF l_debug_on THEN
1278: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_document_instances: TRIP_ID=' || l_trip_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1279: END IF;
1280: END IF;
1281:
1282: DELETE

Line 1322: WSH_EXCEPTIONS, WSH_TRANSACTIONS_HISTORY, WSH_DOCUMENT_INSTANCES,

1318: Input: Table of Record Types for Deliveries
1319: Output: Return Status - success or failure
1320: ==============================================================================
1321: Logic: i) Delete records from the following tables:
1322: WSH_EXCEPTIONS, WSH_TRANSACTIONS_HISTORY, WSH_DOCUMENT_INSTANCES,
1323: WSH_FREIGHT_COSTS
1324:
1325: If FTE is installed,
1326: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,

Line 1397: FROM wsh_document_instances

1393: END IF;
1394: END IF;
1395:
1396: DELETE
1397: FROM wsh_document_instances
1398: WHERE entity_id = l_delivery_id
1399: AND entity_name = 'WSH_NEW_DELIVERIES';
1400:
1401: IF SQL%FOUND THEN

Line 1403: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_document_instances: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1399: AND entity_name = 'WSH_NEW_DELIVERIES';
1400:
1401: IF SQL%FOUND THEN
1402: IF l_debug_on THEN
1403: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_document_instances: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1404: END IF;
1405: END IF;
1406:
1407: IF (wsh_util_core.fte_is_installed='Y') THEN

Line 1690: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,

1686: Input: Table of Record Types for Delivery Legs
1687: Output: Return Status - success or failure
1688: ==============================================================================
1689: Logic: i) Delete records from the following tables:
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,

Line 1741: wsh_document_instances wdi

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
1745: ) ;

Line 1755: FROM wsh_document_instances

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') ;
1758:
1759: IF SQL%FOUND THEN

Line 1768: FROM wsh_document_instances

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') ;
1771:
1772: IF SQL%FOUND THEN

Line 1781: FROM wsh_document_instances

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') ;
1784:
1785: IF SQL%FOUND THEN

Line 1794: FROM wsh_document_instances

1790:
1791: END IF;
1792:
1793: DELETE
1794: FROM wsh_document_instances
1795: WHERE entity_id = l_leg_id
1796: AND entity_name = 'WSH_DELIVERY_LEGS';
1797:
1798: IF SQL%FOUND THEN

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

1796: AND entity_name = 'WSH_DELIVERY_LEGS';
1797:
1798: IF SQL%FOUND THEN
1799: IF l_debug_on THEN
1800: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_document_instances: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1801: END IF;
1802: END IF;
1803:
1804: DELETE