APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_TRANSACTION_ENTITIES

Line 506: FROM XLA_TRANSACTION_ENTITIES

502: v_dummy := 'N';
503: BEGIN
504: SELECT ENTITY_ID
505: INTO v_entity_id
506: FROM XLA_TRANSACTION_ENTITIES
507: WHERE APPLICATION_ID = p_application_id
508: AND LEDGER_ID = v_ledger_id
509: AND ENTITY_CODE = 'THIRD_PARTY_MERGE'
510: AND ROWNUM = 1;--added debug 9593919

Line 524: INSERT INTO XLA_TRANSACTION_ENTITIES

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

Line 530: (XLA_TRANSACTION_ENTITIES_S.nextval,

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

Line 755: XLA_TRANSACTION_ENTITIES ent

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

Line 5224: xla_transaction_entities ent,

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,
5224: xla_transaction_entities ent,
5225: xla_ledger_options lgopt,
5226: xla_launch_options lnopt
5227: WHERE
5228: */ -- 14773226

Line 5468: xla_transaction_entities ent,

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,
5468: xla_transaction_entities ent,
5469: xla_ledger_options lgopt,
5470: xla_launch_options lnopt
5471: WHERE ';
5472: IF P_EVENT_ID IS NOT NULL THEN

Line 5919: xla_transaction_entities xte

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
5923: and xe.application_id = p_application_id;