eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_OSP_PO_PVT dependencies on PO_INTERFACE_ERRORS

Line 503: DELETE FROM PO_INTERFACE_ERRORS WHERE

499: -- Purge Error records from prior submission (if any)
500: -- Begin Changes by jaramana on January 7, 2008 for the Requisition ER 6034236
501: IF (l_old_intf_header_id IS NOT NULL AND l_curr_status = G_OSP_SUB_FAILED_STATUS) THEN
502: -- PO Submission had failed earlier
503: DELETE FROM PO_INTERFACE_ERRORS WHERE
504: INTERFACE_HEADER_ID = l_old_intf_header_id;
505: DELETE FROM PO_HEADERS_INTERFACE WHERE
506: INTERFACE_HEADER_ID = l_old_intf_header_id;
507: DELETE FROM PO_LINES_INTERFACE WHERE

Line 514: DELETE FROM po_interface_errors

510: INTERFACE_HEADER_ID = l_old_intf_header_id;
511: ELSIF (l_curr_status = G_OSP_REQ_SUB_FAILED_STATUS) THEN
512: -- Requisition Submission had failed earlier
513: -- Delete from the Errors table first so that the subquery can use po_requisitions_interface_all
514: DELETE FROM po_interface_errors
515: WHERE INTERFACE_TRANSACTION_ID in
516: (SELECT transaction_id
517: FROM po_requisitions_interface_all
518: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME