[Home] [Help]
707: END IF; -- IF (v_mapping_flag = 'Y')
708:
709: IF (p_type_of_third_party_merge = 'PARTIAL')
710: THEN
711: -- Populate the table XLA_PARTIAL_MERGE_TXNS based on XLA_EVENTS_GT for
712: -- this current event
713: trace( p_msg => 'Insert partial transactions'
714: , p_level => C_LEVEL_STATEMENT
715: , p_module => v_module);
712: -- this current event
713: trace( p_msg => 'Insert partial transactions'
714: , p_level => C_LEVEL_STATEMENT
715: , p_module => v_module);
716: INSERT INTO XLA_PARTIAL_MERGE_TXNS
717: ( APPLICATION_ID, MERGE_EVENT_ID, ENTITY_ID, ENTITY_CODE,
718: SOURCE_ID_INT_1, SOURCE_ID_INT_2, SOURCE_ID_INT_3,
719: SOURCE_ID_INT_4, SOURCE_ID_CHAR_1, SOURCE_ID_CHAR_2,
720: SOURCE_ID_CHAR_3, SOURCE_ID_CHAR_4, VALUATION_METHOD,
763:
764: -- Log the number of rows inserted
765: v_row_count := SQL%ROWCOUNT;
766: trace( p_msg => 'Insert ' || to_char(v_row_count)
767: || ' rows into XLA_PARTIAL_MERGE_TXNS'
768: , p_level => C_LEVEL_STATEMENT
769: , p_module => v_module);
770: IF(v_row_count = 0) THEN
771: v_message := xla_messages_pkg.get_message
2487: AND merge_event_id is null
2488: AND ae_header_id in
2489: (SELECT ael.ae_header_id
2490: FROM xla_ae_lines ael
2491: ,XLA_PARTIAL_MERGE_TXNS pmt
2492: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2493: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
2494: = nvl(p_old_site_id, -1)
2495: and nvl(ael.party_type_code , p_party_type) = p_party_type
2530: AND merge_event_id is null
2531: AND ae_header_id in
2532: (SELECT ael.ae_header_id
2533: FROM xla_ae_lines ael
2534: ,XLA_PARTIAL_MERGE_TXNS pmt
2535: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2536: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
2537: = nvl(p_old_site_id, -1)
2538: and nvl(ael.party_type_code , p_party_type) = p_party_type
3908: AND aeh.AE_HEADER_ID = ael.AE_HEADER_ID
3909: AND aeh.APPLICATION_ID = ael.APPLICATION_ID)
3910: AND EXISTS
3911: (SELECT 'X'
3912: FROM XLA_PARTIAL_MERGE_TXNS pmt
3913: WHERE pmt.APPLICATION_ID = p_application_id
3914: AND pmt.MERGE_EVENT_ID = p_event_id
3915: AND pmt.ENTITY_ID = aeh.ENTITY_ID);
3916: ELSE
4013: OR ael.PARTY_SITE_ID = p_old_site_id)
4014: AND ael.PARTY_TYPE_CODE = p_party_type
4015: AND EXISTS
4016: (SELECT 'X'
4017: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4018: WHERE ael.APPLICATION_ID = aeh.APPLICATION_ID
4019: AND ael.AE_HEADER_ID = aeh.AE_HEADER_ID
4020: AND aeh.APPLICATION_ID = p_application_id
4021: AND aeh.accounting_entry_status_code = 'F'
4028: --
4029: -- Incomplete lines from MPA / Accrual Reversal (5090223/5103972)
4030: --
4031: SELECT 'X'
4032: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4033: WHERE ael.APPLICATION_ID = aeh.APPLICATION_ID
4034: AND ael.AE_HEADER_ID = aeh.AE_HEADER_ID
4035: AND aeh.APPLICATION_ID = p_application_id
4036: AND aeh.accounting_entry_status_code = 'N'
4066: OR tb.PARTY_SITE_ID = p_old_site_id)
4067: AND tb.PARTY_TYPE_CODE = p_party_type
4068: AND EXISTS
4069: (SELECT 'X'
4070: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4071: WHERE tb.AE_HEADER_ID = aeh.AE_HEADER_ID
4072: AND aeh.APPLICATION_ID = p_application_id
4073: AND aeh.LEDGER_ID = p_array_ledger_id(i)
4074: AND aeh.accounting_entry_status_code = 'F'
4080: --
4081: -- Incomplete lines from MPA / Accrual Reversal (5090223/5103972)
4082: --
4083: SELECT 'X'
4084: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4085: WHERE tb.AE_HEADER_ID = aeh.AE_HEADER_ID
4086: AND aeh.APPLICATION_ID = p_application_id
4087: AND aeh.LEDGER_ID = p_array_ledger_id(i)
4088: AND aeh.parent_ae_header_id IS NOT NULL
4664: FROM xla_merge_seg_maps map
4665: ,gl_code_combinations gcc
4666: ,xla_ae_lines ael
4667: ,xla_ae_headers aeh
4668: ,XLA_PARTIAL_MERGE_TXNS xpmt
4669: ,XLA_LEDGER_RELATIONSHIPS_V rs
4670: ,gl_ledgers gld
4671: WHERE ael.PARTY_ID = p_old_party_id
4672: AND (p_old_site_id IS NULL