APPS.XLA_JE_VALIDATION_PKG dependencies on XLA_AE_SEGMENT_VALUES

Line 8997: DELETE FROM xla_ae_segment_values

8993: END IF;
8994:
8995: -- 4262811. Added c_caller_mpa_program
8996: IF (g_caller in (C_CALLER_MPA_PROGRAM, C_CALLER_THIRD_PARTY_MERGE)) THEN
8997: DELETE FROM xla_ae_segment_values
8998: WHERE ae_header_id in (SELECT /*+ UNNEST NO_SEMIJOIN */ ae_header_id -- 4752774
8999: FROM xla_ae_headers_gt
9000: WHERE ledger_id = g_ledger_id
9001: AND accounting_date <= NVL(g_end_date, accounting_date)); -- 4262811

Line 9005: DELETE FROM xla_ae_segment_values

9001: AND accounting_date <= NVL(g_end_date, accounting_date)); -- 4262811
9002: ELSIF g_caller = C_CALLER_ACCT_PROGRAM THEN
9003: NULL; -- bug 4883830
9004: ELSE
9005: DELETE FROM xla_ae_segment_values
9006: WHERE ae_header_id = g_ae_header_id;
9007: END IF;
9008:
9009: INSERT INTO xla_ae_segment_values

Line 9009: INSERT INTO xla_ae_segment_values

9005: DELETE FROM xla_ae_segment_values
9006: WHERE ae_header_id = g_ae_header_id;
9007: END IF;
9008:
9009: INSERT INTO xla_ae_segment_values
9010: (ae_header_id, segment_type_code, segment_value, ae_lines_count)
9011: SELECT ae_header_id, C_BAL_SEGMENT, bal_seg_value, count(*)
9012: FROM xla_validation_lines_gt
9013: WHERE bal_seg_value IS NOT NULL

Line 9032: trace(p_msg => '# xla_ae_segment_values inserted = '||SQL%ROWCOUNT,

9028: WHERE natural_account_seg_value IS NOT NULL
9029: GROUP BY ae_header_id, natural_account_seg_value;
9030:
9031: IF (C_LEVEL_EVENT >= g_log_level) THEN
9032: trace(p_msg => '# xla_ae_segment_values inserted = '||SQL%ROWCOUNT,
9033: p_module => l_log_module,
9034: p_level => C_LEVEL_EVENT);
9035: END IF;
9036: