APPS.WSH_PURGE dependencies on WSH_DOCUMENT_INSTANCES

Line 1094: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES,WSH_TRIPS

1090: Input: Table of Record Types for Trips
1091: Output: Return Status - success or failure
1092: ==============================================================================
1093: Logic: i) Delete records from the following tables:
1094: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES,WSH_TRIPS
1095: -----------------------------------------------------------------------------*/
1096:
1097: PROCEDURE Purge_Trips( p_tbl_trip_purge_set Trip_ID_Tbl_Type,
1098: x_return_status OUT NOCOPY VARCHAR2

Line 1147: FROM wsh_document_instances

1143: END IF;
1144: END IF;
1145:
1146: DELETE
1147: FROM wsh_document_instances
1148: WHERE entity_id = l_trip_id
1149: AND entity_name = 'WSH_TRIPS';
1150:
1151: IF SQL%FOUND THEN

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

1149: AND entity_name = 'WSH_TRIPS';
1150:
1151: IF SQL%FOUND THEN
1152: IF l_debug_on THEN
1153: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_document_instances: TRIP_ID=' || l_trip_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1154: END IF;
1155: END IF;
1156:
1157: DELETE

Line 1197: WSH_EXCEPTIONS, WSH_TRANSACTIONS_HISTORY, WSH_DOCUMENT_INSTANCES,

1193: Input: Table of Record Types for Deliveries
1194: Output: Return Status - success or failure
1195: ==============================================================================
1196: Logic: i) Delete records from the following tables:
1197: WSH_EXCEPTIONS, WSH_TRANSACTIONS_HISTORY, WSH_DOCUMENT_INSTANCES,
1198: WSH_FREIGHT_COSTS
1199:
1200: If FTE is installed,
1201: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,

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_delivery_id
1274: AND entity_name = 'WSH_NEW_DELIVERIES';
1275:
1276: IF SQL%FOUND THEN

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

1274: AND entity_name = 'WSH_NEW_DELIVERIES';
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: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1279: END IF;
1280: END IF;
1281:
1282: IF (wsh_util_core.fte_is_installed='Y') THEN

Line 1565: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,

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

Line 1616: wsh_document_instances wdi

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

Line 1630: FROM wsh_document_instances

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

Line 1643: FROM wsh_document_instances

1639:
1640: DELETE
1641: FROM fte_invoice_history
1642: WHERE bol IN (SELECT sequence_number
1643: FROM wsh_document_instances
1644: WHERE entity_id = l_leg_id
1645: AND entity_name = 'WSH_DELIVERY_LEGS') ;
1646:
1647: IF SQL%FOUND THEN

Line 1656: FROM wsh_document_instances

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

Line 1669: FROM wsh_document_instances

1665:
1666: END IF;
1667:
1668: DELETE
1669: FROM wsh_document_instances
1670: WHERE entity_id = l_leg_id
1671: AND entity_name = 'WSH_DELIVERY_LEGS';
1672:
1673: IF SQL%FOUND THEN

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

1671: AND entity_name = 'WSH_DELIVERY_LEGS';
1672:
1673: IF SQL%FOUND THEN
1674: IF l_debug_on THEN
1675: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_document_instances: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1676: END IF;
1677: END IF;
1678:
1679: DELETE