APPS.WSH_PURGE dependencies on FTE_SHIPMENT_STATUS_HEADERS

Line 1328: FTE_DELIVERY_PROOF, FTE_SHIPMENT_STATUS_HEADERS

1324:
1325: If FTE is installed,
1326: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,
1327: FTE_MESSAGE_PARTNER, FTE_MESSAGE_CONTACT, FTE_MESSAGE_LOCATION,
1328: FTE_DELIVERY_PROOF, FTE_SHIPMENT_STATUS_HEADERS
1329:
1330: If ITM Screening is done,
1331: WSH_ITM_RESPONSE_LINES, WSH_ITM_RESPONSE_HEADERS, WSH_ITM_REQUEST_CONTROL,
1332: WSH_INBOUND_TXN_HISTORY

Line 1412: FROM fte_shipment_status_headers

1408:
1409: DELETE
1410: FROM fte_shipment_status_details
1411: WHERE transaction_id IN (SELECT transaction_id
1412: FROM fte_shipment_status_headers
1413: WHERE delivery_id = l_delivery_id);
1414:
1415: IF SQL%FOUND THEN
1416: IF l_debug_on THEN

Line 1424: FROM fte_shipment_status_headers

1420:
1421: DELETE
1422: FROM fte_shipment_status_exceptions
1423: WHERE transaction_id IN (SELECT transaction_id
1424: FROM fte_shipment_status_headers
1425: WHERE delivery_id = l_delivery_id);
1426:
1427: IF SQL%FOUND THEN
1428: IF l_debug_on THEN

Line 1436: FROM fte_shipment_status_headers

1432:
1433: DELETE
1434: FROM fte_message_partner
1435: WHERE transaction_id IN (SELECT transaction_id
1436: FROM fte_shipment_status_headers
1437: WHERE delivery_id = l_delivery_id);
1438:
1439: IF SQL%FOUND THEN
1440: IF l_debug_on THEN

Line 1448: FROM fte_shipment_status_headers

1444:
1445: DELETE
1446: FROM fte_message_address
1447: WHERE transaction_id IN (SELECT transaction_id
1448: FROM fte_shipment_status_headers
1449: WHERE delivery_id = l_delivery_id);
1450:
1451: IF SQL%FOUND THEN
1452: IF l_debug_on THEN

Line 1460: FROM fte_shipment_status_headers

1456:
1457: DELETE
1458: FROM fte_message_contact
1459: WHERE transaction_id IN (SELECT transaction_id
1460: FROM fte_shipment_status_headers
1461: WHERE delivery_id = l_delivery_id);
1462:
1463: IF SQL%FOUND THEN
1464: IF l_debug_on THEN

Line 1472: FROM fte_shipment_status_headers

1468:
1469: DELETE
1470: FROM fte_message_location
1471: WHERE transaction_id IN (SELECT transaction_id
1472: FROM fte_shipment_status_headers
1473: WHERE delivery_id = l_delivery_id);
1474:
1475: IF SQL%FOUND THEN
1476: IF l_debug_on THEN

Line 1485: FROM fte_shipment_status_headers

1481:
1482: DELETE
1483: FROM fte_delivery_proof
1484: WHERE transaction_id IN (SELECT transaction_id
1485: FROM fte_shipment_status_headers
1486: WHERE delivery_id = l_delivery_id);
1487:
1488: IF SQL%FOUND THEN
1489: IF l_debug_on THEN

Line 1496: FROM fte_shipment_status_headers

1492: END IF;
1493:
1494:
1495: DELETE
1496: FROM fte_shipment_status_headers
1497: WHERE delivery_id = l_delivery_id;
1498:
1499:
1500: IF SQL%FOUND THEN

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

1498:
1499:
1500: IF SQL%FOUND THEN
1501: IF l_debug_on THEN
1502: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_shipment_status_headers: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1503: END IF;
1504: END IF;
1505: END IF;
1506: