DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on PSA_XLA_AE_HEADERS_LOGS

Line 7524: DELETE from psa_xla_ae_headers_logs

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;
7526:
7527: -- =========================== FND LOG ===========================
7528: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_ae_header_logs deleted ' || SQL%ROWCOUNT || ' rows');

Line 9400: | xla_ae_headers_gt psa_xla_ae_headers_logs |

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:
9404: PROCEDURE debug_xla_insert ( xla_events IN xla_events_table ,

Line 9428: INSERT INTO psa_xla_ae_headers_logs

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
9429: VALUES xla_ae_headers(i);
9430:
9431:
9432: FORALL i IN 1 .. xla_distribution_links.count