DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on PSA_XLA_AE_LINES_LOGS

Line 7430: DELETE from psa_xla_ae_lines_logs

7426: -- =========================== FND LOG ===========================
7427: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_events_logs deleted ' || SQL%ROWCOUNT || ' rows');
7428: -- ========================= FND LOG =============================
7429:
7430: DELETE from psa_xla_ae_lines_logs
7431: where (sysdate - creation_date) >= p_purge_days;
7432:
7433: -- =========================== FND LOG ===========================
7434: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_ae_lines_logs deleted ' || SQL%ROWCOUNT || ' rows');

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

7430: DELETE from psa_xla_ae_lines_logs
7431: where (sysdate - creation_date) >= p_purge_days;
7432:
7433: -- =========================== FND LOG ===========================
7434: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_ae_lines_logs deleted ' || SQL%ROWCOUNT || ' rows');
7435: -- ========================= FND LOG =============================
7436:
7437: DELETE from psa_xla_ae_headers_logs
7438: where (sysdate - creation_date) >= p_purge_days;

Line 9213: | xla_ae_lines_gt psa_xla_ae_lines_logs |

9209: | SLA Table PSA Table |
9210: | ======== ======== |
9211: | xla_events_gt psa_xla_events_logs |
9212: | xla_validation_lines_gt psa_xla_validation_lines_logs |
9213: | xla_ae_lines_gt psa_xla_ae_lines_logs |
9214: | xla_ae_headers_gt psa_xla_ae_headers_logs |
9215: | |
9216: +===========================================================================================*/
9217:

Line 9238: INSERT INTO psa_xla_ae_lines_logs

9234: INSERT INTO psa_xla_validation_lines_logs
9235: VALUES xla_validation_lines(i);
9236:
9237: FORALL i IN 1 .. xla_ae_lines.count
9238: INSERT INTO psa_xla_ae_lines_logs
9239: VALUES xla_ae_lines(i);
9240:
9241: FORALL i IN 1 .. xla_ae_headers.count
9242: INSERT INTO psa_xla_ae_headers_logs