DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on PSA_XLA_VALIDATION_LINES_LOGS

Line 7503: DELETE from psa_xla_validation_lines_logs

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;
7505:
7506: -- =========================== FND LOG ===========================
7507: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_validation_lines_logs deleted ' || SQL%ROWCOUNT || ' rows');

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

7503: DELETE from psa_xla_validation_lines_logs
7504: where (sysdate - creation_date) >= p_purge_days;
7505:
7506: -- =========================== FND LOG ===========================
7507: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_validation_lines_logs deleted ' || SQL%ROWCOUNT || ' rows');
7508: -- ========================= FND LOG =============================
7509:
7510: DELETE from psa_xla_events_logs
7511: where (sysdate - creation_date) >= p_purge_days;

Line 9398: | xla_validation_lines_gt psa_xla_validation_lines_logs |

9394: | |
9395: | SLA Table PSA Table |
9396: | ======== ======== |
9397: | xla_events_gt psa_xla_events_logs |
9398: | xla_validation_lines_gt psa_xla_validation_lines_logs |
9399: | xla_ae_lines_gt psa_xla_ae_lines_logs |
9400: | xla_ae_headers_gt psa_xla_ae_headers_logs |
9401: | |
9402: +===========================================================================================*/

Line 9420: INSERT INTO psa_xla_validation_lines_logs

9416: INSERT INTO psa_xla_events_logs
9417: VALUES xla_events(i);
9418:
9419: FORALL i IN 1 .. xla_validation_lines.count
9420: INSERT INTO psa_xla_validation_lines_logs
9421: VALUES xla_validation_lines(i);
9422:
9423: FORALL i IN 1 .. xla_ae_lines.count
9424: INSERT INTO psa_xla_ae_lines_logs