DBA Data[Home] [Help]

APPS.XLA_UPGRADE_PUB dependencies on XLA_TRANSACTION_ENTITIES

Line 71: xla_transaction_entities.entity_id%type

67: -- declaring global pl/sql types
68: -------------------------------------------------------------------------------
69:
70: TYPE t_entity_id IS TABLE OF
71: xla_transaction_entities.entity_id%type
72: INDEX BY BINARY_INTEGER;
73: TYPE t_error_flag IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
74: TYPE t_event_id IS TABLE OF
75: xla_events.event_id%type

Line 95: TYPE T_ARRAY_LEDGER_ID IS TABLE OF XLA_TRANSACTION_ENTITIES.LEDGER_ID%TYPE

91: INDEX BY BINARY_INTEGER;
92: TYPE t_error_id IS TABLE OF
93: xla_upg_errors.upg_error_id%type
94: INDEX BY BINARY_INTEGER;
95: TYPE T_ARRAY_LEDGER_ID IS TABLE OF XLA_TRANSACTION_ENTITIES.LEDGER_ID%TYPE
96: INDEX BY BINARY_INTEGER ; -- bug:8717476
97:
98: -------------------------------------------------------------------------------
99: -- declaring global constants

Line 725: update xla_transaction_entities_upg

721: LIMIT g_batch_size;
722: EXIT when l_entity_id.COUNT = 0;
723:
724: FORALL i IN l_entity_id.FIRST..l_entity_id.LAST
725: update xla_transaction_entities_upg
726: set upg_valid_flag = null
727: where entity_id = l_entity_id(i);
728:
729: COMMIT;