APPS.PSA_FUNDS_CHECKER_PKG dependencies on PSA_BC_ACCOUNTING_ERRORS

Line 7496: DELETE from psa_bc_accounting_errors

7492: -- =========================== FND LOG ===========================
7493: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_accounting_errors deleted ' || SQL%ROWCOUNT || ' rows');
7494: -- ========================= FND LOG =============================
7495:
7496: DELETE from psa_bc_accounting_errors
7497: where (sysdate - creation_date) >= p_purge_days;
7498:
7499: -- =========================== FND LOG ===========================
7500: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_bc_accounting_errors deleted ' || SQL%ROWCOUNT || ' rows');

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

7496: DELETE from psa_bc_accounting_errors
7497: where (sysdate - creation_date) >= p_purge_days;
7498:
7499: -- =========================== FND LOG ===========================
7500: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_bc_accounting_errors deleted ' || SQL%ROWCOUNT || ' rows');
7501: -- ========================= FND LOG =============================
7502:
7503: DELETE from psa_xla_validation_lines_logs
7504: where (sysdate - creation_date) >= p_purge_days;

Line 10191: from psa_bc_accounting_errors b

10187:
10188: fnd_file.put_line(fnd_file.log,'The following are the invalid accounting errrors');
10189: fnd_file.put_line(fnd_file.log,'=============================================== ');
10190: for acc_error in ( select document_reference , encoded_message
10191: from psa_bc_accounting_errors b
10192: where event_id in (select event_id from xla_events_gt))
10193: loop
10194: fnd_file.put_line(fnd_file.log , ' document_referece ' || acc_error.document_reference);
10195: fnd_file.put_line(fnd_file.log , acc_error.encoded_message);