APPS.XLA_DATAFIXES_PUB dependencies on XLA_TRANSACTION_ENTITIES

Line 103: FROM xla_transaction_entities

99: RETURN VARCHAR2 IS
100:
101: CURSOR c_transaction_number IS
102: SELECT transaction_number
103: FROM xla_transaction_entities
104: WHERE entity_id = p_entity_id
105: AND application_id = p_application_id;
106:
107:

Line 108: l_transaction_number xla_transaction_entities.transaction_number%TYPE;

104: WHERE entity_id = p_entity_id
105: AND application_id = p_application_id;
106:
107:
108: l_transaction_number xla_transaction_entities.transaction_number%TYPE;
109:
110: v_refcur SYS_REFCURSOR;
111: l_join_string VARCHAR2(32000);
112:

Line 115: FROM xla_transaction_entities ent

111: l_join_string VARCHAR2(32000);
112:
113: l_transaction_entity_sql VARCHAR2(32000) :=
114: 'SELECT $transaction_entity_columns$
115: FROM xla_transaction_entities ent
116: WHERE ent.application_id = :1
117: AND ent.entity_id = :2 ';
118:
119: l_trx_columns VARCHAR2(4000);

Line 300: ,xla_transaction_entities xte

296: --Bug : 8752657 - Check MO security setting
297: select count(1)
298: into l_count
299: from xla_events xe
300: ,xla_transaction_entities xte
301: where xe.application_id=p_application_id
302: and xe.event_id=p_event_id
303: and xe.entity_id=xte.entity_id
304: and xte.application_id=xe.application_id;

Line 486: xla_transaction_entities xte

482: xla_gl_ledgers_v gl,
483: xla_ae_headers xah,
484: xla_subledgers xsu,
485: xla_events xle,
486: xla_transaction_entities xte
487: WHERE opt.LEDGER_ID = xah.ledger_id
488: AND opt.APPLICATION_ID = xah.application_id
489: AND xsu.application_id = xah.application_id
490: AND xah.event_id = p_event_id -- input parameters

Line 558: FROM xla_transaction_entities

554:
555: --bug#8279661
556: CURSOR c_entity_code(p_orig_entity_id INTEGER) IS
557: SELECT entity_code
558: FROM xla_transaction_entities
559: WHERE application_id = p_application_id
560: AND entity_id = p_orig_entity_id;
561:
562: l_orig_entity_code xla_event_types_b.entity_code%TYPE;

Line 588: ,xla_transaction_entities xte

584: -- Bug :8752657 Check MO security setting
585: select count(1)
586: into l_count
587: from xla_events xe
588: ,xla_transaction_entities xte
589: where xe.application_id=p_application_id
590: and xe.event_id=p_event_id
591: and xe.entity_id=xte.entity_id
592: and xte.application_id=xe.application_id;

Line 666: xla_transaction_entities xte

662: xla_gl_ledgers_v gl,
663: xla_ae_headers xah,
664: xla_subledgers xsu,
665: xla_events xle,
666: xla_transaction_entities xte
667: WHERE opt.LEDGER_ID = xah.ledger_id
668: AND opt.APPLICATION_ID = xah.application_id
669: AND xsu.application_id = xah.application_id
670: AND xah.event_id = p_event_id -- input parameters

Line 869: UPDATE xla_transaction_entities

865: AND event_id = x_rev_event_id
866: AND rownum = 1;
867:
868: -- Bug 6964268 Begin
869: UPDATE xla_transaction_entities
870: SET (entity_code
871: , source_id_int_1
872: , source_id_char_1
873: , security_id_int_1

Line 925: FROM xla_transaction_entities

921: ,fnd_global.user_id
922: ,sysdate
923: ,fnd_global.user_id
924: ,fnd_global.user_id
925: FROM xla_transaction_entities
926: WHERE application_id = p_application_id
927: AND entity_id = l_entity_id)
928: WHERE application_id = p_application_id
929: AND entity_id = x_rev_entity_id;

Line 1045: UPDATE xla_transaction_entities

1041: p_module => l_log_module,
1042: p_level => C_LEVEL_STATEMENT);
1043: END IF;
1044:
1045: UPDATE xla_transaction_entities
1046: SET (entity_code
1047: , source_id_int_1
1048: , source_id_char_1
1049: , security_id_int_1

Line 1101: FROM xla_transaction_entities

1097: ,fnd_global.user_id
1098: ,sysdate
1099: ,fnd_global.user_id
1100: ,fnd_global.user_id
1101: FROM xla_transaction_entities
1102: WHERE application_id = p_application_id
1103: AND entity_id = l_entity_id)
1104: WHERE application_id = p_application_id
1105: AND entity_id = x_new_entity_id;