DBA Data[Home] [Help]

APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_TRANSACTION_ENTITIES

Line 504: FROM XLA_TRANSACTION_ENTITIES

500: v_dummy := 'N';
501: BEGIN
502: SELECT ENTITY_ID
503: INTO v_entity_id
504: FROM XLA_TRANSACTION_ENTITIES
505: WHERE APPLICATION_ID = p_application_id
506: AND LEDGER_ID = v_ledger_id
507: AND ENTITY_CODE = 'THIRD_PARTY_MERGE';
508: EXCEPTION

Line 521: INSERT INTO XLA_TRANSACTION_ENTITIES

517: -- so create one.
518: trace( p_msg => 'Create a Third Party Merge transaction entity'
519: , p_level => C_LEVEL_STATEMENT
520: , p_module => v_module);
521: INSERT INTO XLA_TRANSACTION_ENTITIES
522: ( ENTITY_ID, APPLICATION_ID, LEDGER_ID, ENTITY_CODE,
523: SOURCE_APPLICATION_ID, CREATION_DATE, CREATED_BY,
524: LAST_UPDATE_DATE, LAST_UPDATED_BY,
525: LAST_UPDATE_LOGIN)

Line 527: (XLA_TRANSACTION_ENTITIES_S.nextval,

523: SOURCE_APPLICATION_ID, CREATION_DATE, CREATED_BY,
524: LAST_UPDATE_DATE, LAST_UPDATED_BY,
525: LAST_UPDATE_LOGIN)
526: VALUES
527: (XLA_TRANSACTION_ENTITIES_S.nextval,
528: p_application_id,
529: v_ledger_id,
530: 'THIRD_PARTY_MERGE',
531: NVL(p_source_application_id, p_application_id),

Line 748: XLA_TRANSACTION_ENTITIES ent

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
752: AND ent.LEDGER_ID = gt.LEDGER_ID

Line 5177: xla_transaction_entities ent,

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,
5177: xla_transaction_entities ent,
5178: xla_ledger_options lgopt,
5179: xla_launch_options lnopt
5180: WHERE (p_event_id IS NULL OR evt.EVENT_ID = p_event_id)
5181: AND ( p_merge_event_set_id IS NULL