APPS.JAI_AP_MATCH_TAX_PKG dependencies on JAI_AP_MATCH_ERS_T

Line 295: FROM JAI_AP_MATCH_ERS_T temp

291: ,apla.expenditure_type
292: ,apla.expenditure_organization_id
293: ,apla.expenditure_item_date
294: /* End 5763527 */
295: FROM JAI_AP_MATCH_ERS_T temp
296: ,ap_invoice_lines_all apla -- 5763527
297: WHERE temp.invoice_id NOT IN
298: (SELECT invoice_id
299: FROM JAI_AP_MATCH_ERS_T

Line 299: FROM JAI_AP_MATCH_ERS_T

295: FROM JAI_AP_MATCH_ERS_T temp
296: ,ap_invoice_lines_all apla -- 5763527
297: WHERE temp.invoice_id NOT IN
298: (SELECT invoice_id
299: FROM JAI_AP_MATCH_ERS_T
300: WHERE error_flag = 'Y'
301: )
302: AND ( (v_org_id is null and mo_global.check_access(temp.org_id)='Y' )
303: OR ( (v_org_id is not null) and (temp.org_id = v_org_id) )

Line 355: DELETE JAI_AP_MATCH_ERS_T

351:
352: IF v_error_invoice <> 'Y' THEN
353:
354: -- not an error invoice, do the invoice level processing.
355: DELETE JAI_AP_MATCH_ERS_T
356: WHERE invoice_id = v_prev_invoice_id;
357:
358: COMMIT;
359: -- get the invoice number for writing onto the log file.

Line 432: UPDATE JAI_AP_MATCH_ERS_T

428:
429: ROLLBACK;
430:
431: -- update the record for error
432: UPDATE JAI_AP_MATCH_ERS_T
433: SET error_flag = 'Y',
434: processing_time = SYSDATE,
435: error_message = v_errbuf
436: WHERE ROWID = v_rowid;

Line 466: DELETE JAI_AP_MATCH_ERS_T

462: -- do the processing for the last invoice that was picked up and processed by the cursor if it has not hit any error yet.
463:
464: IF ( v_prev_invoice_id IS NOT NULL AND v_error_invoice <> 'Y') THEN
465:
466: DELETE JAI_AP_MATCH_ERS_T
467: WHERE invoice_id = v_prev_invoice_id;
468:
469: COMMIT;
470: -- get the invoice number for writing onto the log file.

Line 494: UPDATE JAI_AP_MATCH_ERS_T

490: -- rollback for all the lines of the invoice which have already been processed.
491: ROLLBACK;
492:
493: -- update the record for error
494: UPDATE JAI_AP_MATCH_ERS_T
495: SET error_flag = 'Y',
496: processing_time = SYSDATE,
497: error_message = p_errbuf
498: WHERE ROWID = v_rowid;