DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on PSA_XLA_EVENTS_LOGS

Line 7510: DELETE from psa_xla_events_logs

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;
7512:
7513: -- =========================== FND LOG ===========================
7514: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_events_logs deleted ' || SQL%ROWCOUNT || ' rows');

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

7510: DELETE from psa_xla_events_logs
7511: where (sysdate - creation_date) >= p_purge_days;
7512:
7513: -- =========================== FND LOG ===========================
7514: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_events_logs deleted ' || SQL%ROWCOUNT || ' rows');
7515: -- ========================= FND LOG =============================
7516:
7517: DELETE from psa_xla_ae_lines_logs
7518: where (sysdate - creation_date) >= p_purge_days;

Line 9397: | xla_events_gt psa_xla_events_logs |

9393: | to PSA tables as shown below: |
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: | |

Line 9416: INSERT INTO psa_xla_events_logs

9412:
9413: BEGIN
9414:
9415: FORALL i IN 1 .. xla_events.count
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