APPS.XLA_JE_VALIDATION_PKG dependencies on XLA_AE_SEGMENT_VALUES

Line 9678: DELETE FROM xla_ae_segment_values

9674: END IF;
9675:
9676: -- 4262811. Added c_caller_mpa_program
9677: IF (g_caller in (C_CALLER_MPA_PROGRAM, C_CALLER_THIRD_PARTY_MERGE)) THEN
9678: DELETE FROM xla_ae_segment_values
9679: WHERE ae_header_id in (SELECT /*+ UNNEST NO_SEMIJOIN cardinality(XLA_AE_HEADERS_GT,1)*/ ae_header_id -- 4752774 bug9174950
9680: FROM xla_ae_headers_gt
9681: WHERE ledger_id = g_ledger_id
9682: AND accounting_date <= NVL(g_end_date, accounting_date)); -- 4262811

Line 9686: DELETE FROM xla_ae_segment_values

9682: AND accounting_date <= NVL(g_end_date, accounting_date)); -- 4262811
9683: ELSIF g_caller = C_CALLER_ACCT_PROGRAM THEN
9684: NULL; -- bug 4883830
9685: ELSE
9686: DELETE FROM xla_ae_segment_values
9687: WHERE ae_header_id = g_ae_header_id;
9688: END IF;
9689:
9690: INSERT INTO xla_ae_segment_values

Line 9690: INSERT INTO xla_ae_segment_values

9686: DELETE FROM xla_ae_segment_values
9687: WHERE ae_header_id = g_ae_header_id;
9688: END IF;
9689:
9690: INSERT INTO xla_ae_segment_values
9691: (ae_header_id, segment_type_code, segment_value, ae_lines_count)
9692: SELECT ae_header_id, C_BAL_SEGMENT, bal_seg_value, count(*)
9693: FROM xla_validation_lines_gt
9694: WHERE bal_seg_value IS NOT NULL

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

9709: WHERE natural_account_seg_value IS NOT NULL
9710: GROUP BY ae_header_id, natural_account_seg_value;
9711:
9712: IF (C_LEVEL_EVENT >= g_log_level) THEN
9713: trace(p_msg => '# xla_ae_segment_values inserted = '||SQL%ROWCOUNT,
9714: p_module => l_log_module,
9715: p_level => C_LEVEL_EVENT);
9716: END IF;
9717: