[Home] [Help]
714: END IF; -- IF (v_mapping_flag = 'Y')
715:
716: IF (p_type_of_third_party_merge = 'PARTIAL')
717: THEN
718: -- Populate the table XLA_PARTIAL_MERGE_TXNS based on XLA_EVENTS_GT for
719: -- this current event
720: trace( p_msg => 'Insert partial transactions'
721: , p_level => C_LEVEL_STATEMENT
722: , p_module => v_module);
719: -- this current event
720: trace( p_msg => 'Insert partial transactions'
721: , p_level => C_LEVEL_STATEMENT
722: , p_module => v_module);
723: INSERT INTO XLA_PARTIAL_MERGE_TXNS
724: ( APPLICATION_ID, MERGE_EVENT_ID, ENTITY_ID, ENTITY_CODE,
725: SOURCE_ID_INT_1, SOURCE_ID_INT_2, SOURCE_ID_INT_3,
726: SOURCE_ID_INT_4, SOURCE_ID_CHAR_1, SOURCE_ID_CHAR_2,
727: SOURCE_ID_CHAR_3, SOURCE_ID_CHAR_4, VALUATION_METHOD,
770:
771: -- Log the number of rows inserted
772: v_row_count := SQL%ROWCOUNT;
773: trace( p_msg => 'Insert ' || to_char(v_row_count)
774: || ' rows into XLA_PARTIAL_MERGE_TXNS'
775: , p_level => C_LEVEL_STATEMENT
776: , p_module => v_module);
777: IF(v_row_count = 0) THEN
778: v_message := xla_messages_pkg.get_message
2505: AND merge_event_id is null
2506: AND ae_header_id in
2507: (SELECT ael.ae_header_id
2508: FROM xla_ae_lines ael
2509: ,XLA_PARTIAL_MERGE_TXNS pmt
2510: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2511: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
2512: = nvl(p_old_site_id, -1)
2513: and nvl(ael.party_type_code , p_party_type) = p_party_type
2548: AND merge_event_id is null
2549: AND ae_header_id in
2550: (SELECT ael.ae_header_id
2551: FROM xla_ae_lines ael
2552: ,XLA_PARTIAL_MERGE_TXNS pmt
2553: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2554: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
2555: = nvl(p_old_site_id, -1)
2556: and nvl(ael.party_type_code , p_party_type) = p_party_type
3953: AND aeh.AE_HEADER_ID = ael.AE_HEADER_ID
3954: AND aeh.APPLICATION_ID = ael.APPLICATION_ID)
3955: AND EXISTS
3956: (SELECT 'X'
3957: FROM XLA_PARTIAL_MERGE_TXNS pmt
3958: WHERE pmt.APPLICATION_ID = p_application_id
3959: AND pmt.MERGE_EVENT_ID = p_event_id
3960: AND pmt.ENTITY_ID = aeh.ENTITY_ID);
3961: ELSE
4058: OR ael.PARTY_SITE_ID = p_old_site_id)
4059: AND ael.PARTY_TYPE_CODE = p_party_type
4060: AND EXISTS
4061: (SELECT 'X'
4062: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4063: WHERE ael.APPLICATION_ID = aeh.APPLICATION_ID
4064: AND ael.AE_HEADER_ID = aeh.AE_HEADER_ID
4065: AND aeh.APPLICATION_ID = p_application_id
4066: AND aeh.accounting_entry_status_code = 'F'
4073: --
4074: -- Incomplete lines from MPA / Accrual Reversal (5090223/5103972)
4075: --
4076: SELECT 'X'
4077: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4078: WHERE ael.APPLICATION_ID = aeh.APPLICATION_ID
4079: AND ael.AE_HEADER_ID = aeh.AE_HEADER_ID
4080: AND aeh.APPLICATION_ID = p_application_id
4081: AND aeh.accounting_entry_status_code = 'N'
4111: OR tb.PARTY_SITE_ID = p_old_site_id)
4112: AND tb.PARTY_TYPE_CODE = p_party_type
4113: AND EXISTS
4114: (SELECT 'X'
4115: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4116: WHERE tb.AE_HEADER_ID = aeh.AE_HEADER_ID
4117: AND aeh.APPLICATION_ID = p_application_id
4118: AND aeh.LEDGER_ID = p_array_ledger_id(i)
4119: AND aeh.accounting_entry_status_code = 'F'
4125: --
4126: -- Incomplete lines from MPA / Accrual Reversal (5090223/5103972)
4127: --
4128: SELECT 'X'
4129: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4130: WHERE tb.AE_HEADER_ID = aeh.AE_HEADER_ID
4131: AND aeh.APPLICATION_ID = p_application_id
4132: AND aeh.LEDGER_ID = p_array_ledger_id(i)
4133: AND aeh.parent_ae_header_id IS NOT NULL
4709: FROM xla_merge_seg_maps map
4710: ,gl_code_combinations gcc
4711: ,xla_ae_lines ael
4712: ,xla_ae_headers aeh
4713: ,XLA_PARTIAL_MERGE_TXNS xpmt
4714: ,XLA_LEDGER_RELATIONSHIPS_V rs
4715: ,gl_ledgers gld
4716: WHERE ael.PARTY_ID = p_old_party_id
4717: AND (p_old_site_id IS NULL