DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_ENGINE_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 669: ,xla_distribution_links xdl2 -- reversal of original entry

665:
666: SELECT distinct xeh3.ae_header_id, xeh3.ledger_id, xeh3.entity_id
667: BULK COLLECT INTO l_array_LR_incomplete_mpa, l_array_LR_ledger_id, l_array_LR_entity_id
668: FROM xla_ae_headers xeh1 -- reversal of original entry
669: ,xla_distribution_links xdl2 -- reversal of original entry
670: ,xla_ae_headers xeh3 -- incomplete MPA entries
671: ,xla_ae_headers xeh4 -- original entries
672: --------------------------------------------------------------
673: -- Find the original/parent

Line 724: DELETE xla_distribution_links WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(m);

720: DELETE xla_ae_lines WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(k);
721: FORALL l in 1..l_array_LR_incomplete_mpa.COUNT
722: DELETE xla_ae_headers WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(l);
723: FORALL m in 1..l_array_LR_incomplete_mpa.COUNT
724: DELETE xla_distribution_links WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(m);
725:
726: END LOOP;
727:
728:

Line 739: ,xla_distribution_links xdl2 -- reversal of original entry

735: ------------------------------------------------------------------------------------
736: SELECT distinct xeh3.ae_header_id, xeh3.ledger_id, xeh3.entity_id
737: BULK COLLECT INTO l_array_TR_incomplete_mpa, l_array_TR_ledger_id, l_array_TR_entity_id
738: FROM xla_ae_headers xeh1 -- reversal of original entry
739: ,xla_distribution_links xdl2 -- reversal of original entry
740: ,xla_ae_headers xeh3 -- incomplete MPA entries
741: ,xla_ae_headers xeh4 -- original entries
742: --------------------------------------------------------------
743: -- Find the original/parent

Line 794: DELETE xla_distribution_links WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(m);

790: DELETE xla_ae_lines WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(k);
791: FORALL l in 1..l_array_TR_incomplete_mpa.COUNT
792: DELETE xla_ae_headers WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(l);
793: FORALL m in 1..l_array_TR_incomplete_mpa.COUNT
794: DELETE xla_distribution_links WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(m);
795:
796: END LOOP;
797:
798: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN