APPS.XLA_HIST_LEDGER_UPG_PKG dependencies on XLA_AE_SEGMENT_VALUES

Line 655: FROM xla_ae_segment_values

651:
652: IF l_ae_insert = TRUE THEN
653:
654: DELETE
655: FROM xla_ae_segment_values
656: WHERE upg_batch_id = l_upgrade_id;
657:
658: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
659: trace

Line 660: (p_msg => 'deleted rows from xla_ae_segment_values = ' || SQL%ROWCOUNT

656: WHERE upg_batch_id = l_upgrade_id;
657:
658: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
659: trace
660: (p_msg => 'deleted rows from xla_ae_segment_values = ' || SQL%ROWCOUNT
661: ,p_level => C_LEVEL_PROCEDURE
662: ,p_module => l_log_module);
663: END IF;
664: COMMIT;

Line 3599: INSERT INTO XLA_AE_SEGMENT_VALUES

3595: */
3596:
3597: IF (l_ledger_category_code = 'ALC') OR ( (l_ledger_category_code = 'SECONDARY') and (l_primary_coa = l_secondary_coa) ) THEN
3598:
3599: INSERT INTO XLA_AE_SEGMENT_VALUES
3600: ( ae_header_id
3601: , segment_type_code
3602: , segment_value
3603: , ae_lines_count

Line 3611: , xla_ae_segment_values xasv

3607: , xasv.segment_value
3608: , xasv.ae_lines_count
3609: , l_upgrade_id
3610: FROM xla_ae_headers xah
3611: , xla_ae_segment_values xasv
3612: WHERE XAH.upg_batch_id = XASV.ae_header_id
3613: AND XAH.accounting_date >= l_start_date
3614: AND XAH.accounting_date <= l_sec_alc_end_date
3615: AND XAH.ledger_id = l_secondary_alc_ledger_id;

Line 3621: (p_msg => 'Rows inserted into xla_ae_segment_values: ' || SQL%ROWCOUNT

3617:
3618:
3619: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3620: trace
3621: (p_msg => 'Rows inserted into xla_ae_segment_values: ' || SQL%ROWCOUNT
3622: ,p_level => C_LEVEL_PROCEDURE
3623: ,p_module => l_log_module);
3624:
3625: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')