APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on RA_INTERFACE_ERRORS_ALL

Line 5561: FROM ra_interface_errors_all

5557: l_term_name VARCHAR2(25);
5558:
5559: CURSOR int_errors(x_interface_line_id NUMBER, x_org_id number) IS
5560: SELECT message_text,invalid_value
5561: FROM ra_interface_errors_all
5562: WHERE org_id = x_org_id
5563: AND interface_line_id = x_interface_line_id;
5564:
5565: PRAGMA AUTONOMOUS_TRANSACTION;

Line 5909: FROM ra_interface_errors_all

5905:
5906: IF (l_interface_line_id IS NOT NULL) THEN
5907: SELECT Count(*)
5908: INTO l_error_count
5909: FROM ra_interface_errors_all
5910: WHERE interface_line_id = l_interface_line_id
5911: AND org_id = l_emd_transactions_info.org_id;
5912:
5913: print_log('l_error_count'||l_error_count);

Line 5936: DELETE FROM ra_interface_errors_all

5932:
5933: DELETE FROM ra_interface_lines_all
5934: WHERE interface_line_id =l_interface_line_id;
5935:
5936: DELETE FROM ra_interface_errors_all
5937: WHERE interface_line_id =l_interface_line_id;
5938: COMMIT;
5939: END IF;
5940: EXCEPTION