APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_EVENTS

Line 549: FROM XLA_EVENTS

545: , p_level => C_LEVEL_STATEMENT
546: , p_module => v_module);
547: SELECT max(EVENT_NUMBER)
548: INTO v_max_event_number
549: FROM XLA_EVENTS
550: WHERE ENTITY_ID = v_entity_id;
551:
552: IF(v_max_event_number is null) THEN
553: v_max_event_number :=0;

Line 615: INSERT INTO XLA_EVENTS

611: -- ledger
612: trace( p_msg => 'Create the Third Party Merge event'
613: , p_level => C_LEVEL_STATEMENT
614: , p_module => v_module);
615: INSERT INTO XLA_EVENTS
616: ( EVENT_ID, APPLICATION_ID, ENTITY_ID, EVENT_NUMBER,
617: EVENT_TYPE_CODE, EVENT_DATE, EVENT_STATUS_CODE,
618: PROCESS_STATUS_CODE, CREATION_DATE, CREATED_BY,
619: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,

Line 626: ( XLA_EVENTS_S.nextval,

622: REFERENCE_NUM_4, REFERENCE_CHAR_1, REFERENCE_CHAR_2,
623: MERGE_EVENT_SET_ID, ON_HOLD_FLAG,
624: TRANSACTION_DATE)
625: VALUES
626: ( XLA_EVENTS_S.nextval,
627: p_application_id,
628: v_entity_id,
629: v_max_event_number + 1,
630: p_type_of_third_party_merge||'_MERGE',

Line 711: -- Populate the table XLA_PARTIAL_MERGE_TXNS based on XLA_EVENTS_GT for

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);

Line 747: FROM XLA_EVENTS_GT gt,

743: sysdate,
744: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
745: XLA_ENVIRONMENT_PKG.g_prog_id,
746: XLA_ENVIRONMENT_PKG.g_req_id
747: FROM XLA_EVENTS_GT gt,
748: XLA_TRANSACTION_ENTITIES ent
749: WHERE gt.APPLICATION_ID = p_application_id
750: AND gt.LEDGER_ID = v_ledger_id
751: AND ent.APPLICATION_ID = gt.APPLICATION_ID

Line 854: UPDATE XLA_EVENTS

850: -- Populate the merge event set ID to the first event
851: trace( p_msg => 'Populate the merge event set ID to the first event'
852: , p_level => C_LEVEL_STATEMENT
853: , p_module => v_module);
854: UPDATE XLA_EVENTS
855: SET MERGE_EVENT_SET_ID = TO_CHAR(v_merge_event_set_id)
856: WHERE EVENT_ID = v_merge_event_set_id;
857:
858: END IF; -- IF (v_event_count = 1)

Line 5172: FROM xla_events evt,

5168: evt.reference_char_2 mapping_flag,
5169: ent.entity_id,
5170: ent.source_application_id,
5171: ent.ledger_id
5172: FROM xla_events evt,
5173: xla_third_parties_v p1,
5174: xla_third_parties_v p2,
5175: xla_third_party_sites_v s1,
5176: xla_third_party_sites_v s2,

Line 5342: FROM XLA_EVENTS

5338: -- Validate the passed merge event set ID
5339: BEGIN
5340: SELECT 'X'
5341: INTO v_dummy
5342: FROM XLA_EVENTS
5343: WHERE EVENT_ID = p_merge_event_set_id
5344: AND EVENT_TYPE_CODE IN ('PARTIAL_MERGE', 'FULL_MERGE');
5345: EXCEPTION
5346: WHEN NO_DATA_FOUND THEN

Line 5362: FROM XLA_EVENTS

5358: -- Validate the passed event ID
5359: BEGIN
5360: SELECT 'X'
5361: INTO v_dummy
5362: FROM XLA_EVENTS
5363: WHERE EVENT_ID = p_event_id
5364: AND EVENT_TYPE_CODE IN ('PARTIAL_MERGE', 'FULL_MERGE');
5365: EXCEPTION
5366: WHEN NO_DATA_FOUND THEN

Line 5737: UPDATE XLA_EVENTS

5733: trace( p_msg => 'Update the current event status'
5734: , p_level => C_LEVEL_STATEMENT
5735: , p_module => v_module);
5736:
5737: UPDATE XLA_EVENTS
5738: SET EVENT_STATUS_CODE = DECODE(p_accounting_mode
5739: , 'F', 'P', EVENT_STATUS_CODE),
5740: PROCESS_STATUS_CODE = p_accounting_mode
5741: WHERE EVENT_ID = v_event_id;

Line 5896: (SELECT event_id FROM xla_events

5892:
5893: /* no accounting error here
5894: DELETE FROM xla_accounting_errors
5895: WHERE event_id IN
5896: (SELECT event_id FROM xla_events
5897: WHERE application_id = g_application_id
5898: AND request_id = g_report_request_id);
5899: */
5900: