APPS.WSH_PURGE dependencies on FTE_SHIPMENT_STATUS_HEADERS

Line 1203: FTE_DELIVERY_PROOF, FTE_SHIPMENT_STATUS_HEADERS

1199:
1200: If FTE is installed,
1201: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,
1202: FTE_MESSAGE_PARTNER, FTE_MESSAGE_CONTACT, FTE_MESSAGE_LOCATION,
1203: FTE_DELIVERY_PROOF, FTE_SHIPMENT_STATUS_HEADERS
1204:
1205: If ITM Screening is done,
1206: WSH_ITM_RESPONSE_LINES, WSH_ITM_RESPONSE_HEADERS, WSH_ITM_REQUEST_CONTROL,
1207: WSH_INBOUND_TXN_HISTORY

Line 1287: FROM fte_shipment_status_headers

1283:
1284: DELETE
1285: FROM fte_shipment_status_details
1286: WHERE transaction_id IN (SELECT transaction_id
1287: FROM fte_shipment_status_headers
1288: WHERE delivery_id = l_delivery_id);
1289:
1290: IF SQL%FOUND THEN
1291: IF l_debug_on THEN

Line 1299: FROM fte_shipment_status_headers

1295:
1296: DELETE
1297: FROM fte_shipment_status_exceptions
1298: WHERE transaction_id IN (SELECT transaction_id
1299: FROM fte_shipment_status_headers
1300: WHERE delivery_id = l_delivery_id);
1301:
1302: IF SQL%FOUND THEN
1303: IF l_debug_on THEN

Line 1311: FROM fte_shipment_status_headers

1307:
1308: DELETE
1309: FROM fte_message_partner
1310: WHERE transaction_id IN (SELECT transaction_id
1311: FROM fte_shipment_status_headers
1312: WHERE delivery_id = l_delivery_id);
1313:
1314: IF SQL%FOUND THEN
1315: IF l_debug_on THEN

Line 1323: FROM fte_shipment_status_headers

1319:
1320: DELETE
1321: FROM fte_message_address
1322: WHERE transaction_id IN (SELECT transaction_id
1323: FROM fte_shipment_status_headers
1324: WHERE delivery_id = l_delivery_id);
1325:
1326: IF SQL%FOUND THEN
1327: IF l_debug_on THEN

Line 1335: FROM fte_shipment_status_headers

1331:
1332: DELETE
1333: FROM fte_message_contact
1334: WHERE transaction_id IN (SELECT transaction_id
1335: FROM fte_shipment_status_headers
1336: WHERE delivery_id = l_delivery_id);
1337:
1338: IF SQL%FOUND THEN
1339: IF l_debug_on THEN

Line 1347: FROM fte_shipment_status_headers

1343:
1344: DELETE
1345: FROM fte_message_location
1346: WHERE transaction_id IN (SELECT transaction_id
1347: FROM fte_shipment_status_headers
1348: WHERE delivery_id = l_delivery_id);
1349:
1350: IF SQL%FOUND THEN
1351: IF l_debug_on THEN

Line 1360: FROM fte_shipment_status_headers

1356:
1357: DELETE
1358: FROM fte_delivery_proof
1359: WHERE transaction_id IN (SELECT transaction_id
1360: FROM fte_shipment_status_headers
1361: WHERE delivery_id = l_delivery_id);
1362:
1363: IF SQL%FOUND THEN
1364: IF l_debug_on THEN

Line 1371: FROM fte_shipment_status_headers

1367: END IF;
1368:
1369:
1370: DELETE
1371: FROM fte_shipment_status_headers
1372: WHERE delivery_id = l_delivery_id;
1373:
1374:
1375: IF SQL%FOUND THEN

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

1373:
1374:
1375: IF SQL%FOUND THEN
1376: IF l_debug_on THEN
1377: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_shipment_status_headers: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1378: END IF;
1379: END IF;
1380: END IF;
1381: