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 511: DELETE FROM PO_INTERFACE_ERRORS WHERE

507: -- Purge Error records from prior submission (if any)
508: -- Begin Changes by jaramana on January 7, 2008 for the Requisition ER 6034236
509: IF (l_old_intf_header_id IS NOT NULL AND l_curr_status = G_OSP_SUB_FAILED_STATUS) THEN
510: -- PO Submission had failed earlier
511: DELETE FROM PO_INTERFACE_ERRORS WHERE
512: INTERFACE_HEADER_ID = l_old_intf_header_id;
513: DELETE FROM PO_HEADERS_INTERFACE WHERE
514: INTERFACE_HEADER_ID = l_old_intf_header_id;
515: DELETE FROM PO_LINES_INTERFACE WHERE

Line 522: DELETE FROM po_interface_errors

518: INTERFACE_HEADER_ID = l_old_intf_header_id;
519: ELSIF (l_curr_status = G_OSP_REQ_SUB_FAILED_STATUS) THEN
520: -- Requisition Submission had failed earlier
521: -- Delete from the Errors table first so that the subquery can use po_requisitions_interface_all
522: DELETE FROM po_interface_errors
523: WHERE INTERFACE_TRANSACTION_ID in
524: (SELECT transaction_id
525: FROM po_requisitions_interface_all
526: WHERE INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME