DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_ENGINE_PKG dependencies on XLA_DISTRIBUTION_LINKS

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

670:
671: SELECT distinct xeh3.ae_header_id, xeh3.ledger_id, xeh3.entity_id
672: BULK COLLECT INTO l_array_LR_incomplete_mpa, l_array_LR_ledger_id, l_array_LR_entity_id
673: FROM xla_ae_headers xeh1 -- reversal of original entry
674: ,xla_distribution_links xdl2 -- reversal of original entry
675: ,xla_ae_headers xeh3 -- incomplete MPA entries
676: ,xla_ae_headers xeh4 -- original entries
677: --------------------------------------------------------------
678: -- Find the original/parent

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

725: DELETE xla_ae_lines WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(k);
726: FORALL l in 1..l_array_LR_incomplete_mpa.COUNT
727: DELETE xla_ae_headers WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(l);
728: FORALL m in 1..l_array_LR_incomplete_mpa.COUNT
729: DELETE xla_distribution_links WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(m);
730:
731: END LOOP;
732:
733:

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

740: ------------------------------------------------------------------------------------
741: SELECT distinct xeh3.ae_header_id, xeh3.ledger_id, xeh3.entity_id
742: BULK COLLECT INTO l_array_TR_incomplete_mpa, l_array_TR_ledger_id, l_array_TR_entity_id
743: FROM xla_ae_headers xeh1 -- reversal of original entry
744: ,xla_distribution_links xdl2 -- reversal of original entry
745: ,xla_ae_headers xeh3 -- incomplete MPA entries
746: ,xla_ae_headers xeh4 -- original entries
747: --------------------------------------------------------------
748: -- Find the original/parent

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

795: DELETE xla_ae_lines WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(k);
796: FORALL l in 1..l_array_TR_incomplete_mpa.COUNT
797: DELETE xla_ae_headers WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(l);
798: FORALL m in 1..l_array_TR_incomplete_mpa.COUNT
799: DELETE xla_distribution_links WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(m);
800:
801: END LOOP;
802:
803: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN