APPS.PSA_FUNDS_CHECKER_PKG dependencies on PSA_BC_ACCOUNTING_ERRORS

Line 7409: DELETE from psa_bc_accounting_errors

7405: values g_bc_pkts_hist(i);
7406:
7407: if p_purge_days > 0 then
7408:
7409: DELETE from psa_bc_accounting_errors
7410: where (sysdate - creation_date) >= p_purge_days;
7411:
7412: -- =========================== FND LOG ===========================
7413: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_bc_accounting_errors deleted ' || SQL%ROWCOUNT || ' rows');

Line 7413: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_bc_accounting_errors deleted ' || SQL%ROWCOUNT || ' rows');

7409: DELETE from psa_bc_accounting_errors
7410: where (sysdate - creation_date) >= p_purge_days;
7411:
7412: -- =========================== FND LOG ===========================
7413: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_bc_accounting_errors deleted ' || SQL%ROWCOUNT || ' rows');
7414: -- ========================= FND LOG =============================
7415:
7416: DELETE from psa_xla_validation_lines_logs
7417: where (sysdate - creation_date) >= p_purge_days;

Line 9905: from psa_bc_accounting_errors b

9901:
9902: fnd_file.put_line(fnd_file.log,'The following are the invalid accounting errrors');
9903: fnd_file.put_line(fnd_file.log,'=============================================== ');
9904: for acc_error in ( select document_reference , encoded_message
9905: from psa_bc_accounting_errors b
9906: where event_id in (select event_id from xla_events_gt))
9907: loop
9908: fnd_file.put_line(fnd_file.log , ' document_referece ' || acc_error.document_reference);
9909: fnd_file.put_line(fnd_file.log , acc_error.encoded_message);