DBA Data[Home] [Help]

APPS.XLA_UPG_VERIFICATION_PUB dependencies on XLA_TRANSACTION_ENTITIES_UPG

Line 270: from xla_transaction_entities_upg xen

266: ,-9999
267: , 'A'
268: ,'XLA_UPG_APP_NOT_DEFINED'
269: ,entity_id from(select entity_id
270: from xla_transaction_entities_upg xen
271: where NOT EXISTS (SELECT 1
272: FROM XLA_SUBLEDGERS XS
273: WHERE xen.application_id
274: = xs.application_id)));

Line 286: UPDATE xla_transaction_entities_upg

282: LIMIT g_batch_size;
283: EXIT WHEN l_entity_id.count = 0;
284:
285: FORALL i IN l_entity_id.FIRST..l_entity_id.LAST
286: UPDATE xla_transaction_entities_upg
287: set upg_valid_flag = 'A'
288: where entity_id = l_entity_id(i);
289:
290: -- finding out how many rows got inserted/updated.

Line 423: from xla_transaction_entities_upg xen

419: ,-9999
420: ,'N'
421: ,'XLA_UPG_ENCODE_INVALID'
422: ,entity_id
423: from xla_transaction_entities_upg xen
424: where not exists (select 1 from xla_entity_types_b xent
425: where xen.entity_code = xent.entity_code
426: and xen.application_id = xent.application_id)
427: and xen.application_id = p_application_id

Line 443: UPDATE xla_transaction_entities_upg

439: LIMIT g_batch_size;
440: EXIT when l_entity_id.COUNT = 0;
441:
442: FORALL i IN l_entity_id.FIRST..l_entity_id.LAST
443: UPDATE xla_transaction_entities_upg
444: set upg_valid_flag = 'D'
445: where entity_id = l_entity_id(i);
446:
447: -- finding out how many rows got inserted/updated.

Line 619: , xla_transaction_entities_upg xen

615: ELSE 'N' END event_error7-- Event Class Code is Invalid
616: ,CASE when xalb.accounting_class_code IS NULL THEN 'Y'
617: ELSE 'N' END event_error8
618: from xla_events xe
619: , xla_transaction_entities_upg xen
620: , xla_event_types_b xevt
621: , xla_acct_line_types_b xalb
622: , xla_entity_types_b xent
623: where xen.entity_id(+) = xe.entity_id