DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on PSA_XLA_AE_LINES_LOGS

Line 7517: DELETE from psa_xla_ae_lines_logs

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;
7519:
7520: -- =========================== FND LOG ===========================
7521: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_ae_lines_logs deleted ' || SQL%ROWCOUNT || ' rows');

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

7517: DELETE from psa_xla_ae_lines_logs
7518: where (sysdate - creation_date) >= p_purge_days;
7519:
7520: -- =========================== FND LOG ===========================
7521: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_ae_lines_logs deleted ' || SQL%ROWCOUNT || ' rows');
7522: -- ========================= FND LOG =============================
7523:
7524: DELETE from psa_xla_ae_headers_logs
7525: where (sysdate - creation_date) >= p_purge_days;

Line 9399: | xla_ae_lines_gt psa_xla_ae_lines_logs |

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: +===========================================================================================*/
9403:

Line 9424: INSERT INTO psa_xla_ae_lines_logs

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
9425: VALUES xla_ae_lines(i);
9426:
9427: FORALL i IN 1 .. xla_ae_headers.count
9428: INSERT INTO psa_xla_ae_headers_logs