APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_EVENTS

Line 554: FROM XLA_EVENTS

550: , p_module => v_module);
551:
552: SELECT max(EVENT_NUMBER)
553: INTO v_max_event_number
554: FROM XLA_EVENTS
555: WHERE ENTITY_ID = v_entity_id;
556:
557: IF(v_max_event_number is null) THEN
558: v_max_event_number :=0;

Line 620: INSERT INTO XLA_EVENTS

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

Line 631: ( XLA_EVENTS_S.nextval,

627: REFERENCE_NUM_4, REFERENCE_CHAR_1, REFERENCE_CHAR_2,
628: MERGE_EVENT_SET_ID, ON_HOLD_FLAG,
629: TRANSACTION_DATE)
630: VALUES
631: ( XLA_EVENTS_S.nextval,
632: p_application_id,
633: v_entity_id,
634: XLA_EVENTS_S.nextval , -- v_max_event_number + 1 commented for bug 9439643
635: p_type_of_third_party_merge||'_MERGE',

Line 634: XLA_EVENTS_S.nextval , -- v_max_event_number + 1 commented for bug 9439643

630: VALUES
631: ( XLA_EVENTS_S.nextval,
632: p_application_id,
633: v_entity_id,
634: XLA_EVENTS_S.nextval , -- v_max_event_number + 1 commented for bug 9439643
635: p_type_of_third_party_merge||'_MERGE',
636: p_third_party_merge_date,
637: 'U',
638: 'U',

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

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

Line 754: FROM XLA_EVENTS_GT gt,

750: sysdate,
751: XLA_ENVIRONMENT_PKG.g_prog_appl_id,
752: XLA_ENVIRONMENT_PKG.g_prog_id,
753: XLA_ENVIRONMENT_PKG.g_req_id
754: FROM XLA_EVENTS_GT gt,
755: XLA_TRANSACTION_ENTITIES ent
756: WHERE gt.APPLICATION_ID = p_application_id
757: AND gt.LEDGER_ID = v_ledger_id
758: AND ent.APPLICATION_ID = gt.APPLICATION_ID

Line 861: UPDATE XLA_EVENTS

857: -- Populate the merge event set ID to the first event
858: trace( p_msg => 'Populate the merge event set ID to the first event'
859: , p_level => C_LEVEL_STATEMENT
860: , p_module => v_module);
861: UPDATE XLA_EVENTS
862: SET MERGE_EVENT_SET_ID = TO_CHAR(v_merge_event_set_id)
863: WHERE EVENT_ID = v_merge_event_set_id;
864:
865: END IF; -- IF (v_event_count = 1)

Line 5219: FROM xla_events evt,

5215: evt.reference_char_2 mapping_flag,
5216: ent.entity_id,
5217: ent.source_application_id,
5218: ent.ledger_id
5219: FROM xla_events evt,
5220: xla_third_parties_v p1,
5221: xla_third_parties_v p2,
5222: xla_third_party_sites_v s1,
5223: xla_third_party_sites_v s2,

Line 5405: FROM XLA_EVENTS

5401: -- Validate the passed merge event set ID
5402: BEGIN
5403: SELECT 'X'
5404: INTO v_dummy
5405: FROM XLA_EVENTS
5406: WHERE EVENT_ID = p_merge_event_set_id
5407: AND EVENT_TYPE_CODE IN ('PARTIAL_MERGE', 'FULL_MERGE');
5408: EXCEPTION
5409: WHEN NO_DATA_FOUND THEN

Line 5425: FROM XLA_EVENTS

5421: -- Validate the passed event ID
5422: BEGIN
5423: SELECT 'X'
5424: INTO v_dummy
5425: FROM XLA_EVENTS
5426: WHERE EVENT_ID = p_event_id
5427: AND EVENT_TYPE_CODE IN ('PARTIAL_MERGE', 'FULL_MERGE');
5428: EXCEPTION
5429: WHEN NO_DATA_FOUND THEN

Line 5463: FROM xla_events evt,

5459: evt.reference_char_2 mapping_flag,
5460: ent.entity_id,
5461: ent.source_application_id,
5462: ent.ledger_id
5463: FROM xla_events evt,
5464: xla_third_parties_v p1,
5465: xla_third_parties_v p2,
5466: xla_third_party_sites_v s1,
5467: xla_third_party_sites_v s2,

Line 5918: from xla_events xe,

5914: , p_module => v_module);
5915:
5916: select ledger_id
5917: into v_ledger_id
5918: from xla_events xe,
5919: xla_transaction_entities xte
5920: where xe.entity_id = xte.entity_id
5921: and xe.application_id = xte.application_id
5922: and xe.event_id = v_event_id

Line 5963: UPDATE XLA_EVENTS

5959: process_status_code = 'F'.If accounting_mode is DRAFT, then event_status_code = 'U' and
5960: process_status_code = 'D'. */
5961:
5962:
5963: UPDATE XLA_EVENTS
5964: SET EVENT_STATUS_CODE = DECODE(nvl(p_accounting_mode,v_acctg_mode_code)
5965: , 'F', 'P', EVENT_STATUS_CODE),
5966: PROCESS_STATUS_CODE = nvl(p_accounting_mode,v_acctg_mode_code) --Added by krsankar for RCA bug 8396757
5967: WHERE EVENT_ID = v_event_id;

Line 6134: (SELECT event_id FROM xla_events

6130:
6131: /* no accounting error here
6132: DELETE FROM xla_accounting_errors
6133: WHERE event_id IN
6134: (SELECT event_id FROM xla_events
6135: WHERE application_id = g_application_id
6136: AND request_id = g_report_request_id);
6137: */
6138: