81: IS
82:
83: CURSOR c IS
84: SELECT rowid
85: FROM xla_entity_types_b
86: WHERE application_id = x_application_id
87: AND entity_code = x_entity_code
88: ;
89:
100: p_level => C_LEVEL_PROCEDURE);
101: END IF;
102:
103:
104: INSERT INTO xla_entity_types_b
105: (creation_date
106: ,created_by
107: ,application_id
108: ,entity_code
191: CURSOR c IS
192: SELECT application_id
193: ,enabled_flag
194: ,enable_gapless_events_flag
195: FROM xla_entity_types_b
196: WHERE application_id = x_application_id
197: AND entity_code = x_entity_code
198: FOR UPDATE OF application_id NOWAIT;
199:
296: p_module => l_log_module,
297: p_level => C_LEVEL_PROCEDURE);
298: END IF;
299:
300: UPDATE xla_entity_types_b
301: SET
302: last_update_date = x_last_update_date
303: ,enabled_flag = x_enabled_flag
304: ,enable_gapless_events_flag = x_enable_gapless_events_flag
365: IF (SQL%NOTFOUND) THEN
366: RAISE NO_DATA_FOUND;
367: END IF;
368:
369: DELETE FROM xla_entity_types_b
370: WHERE application_id = x_application_id
371: AND entity_code = x_entity_code;
372:
373:
405:
406: DELETE FROM xla_entity_types_tl T
407: WHERE NOT EXISTS
408: (SELECT NULL
409: FROM xla_entity_types_b b
410: WHERE b.application_id = t.application_id
411: AND b.entity_code = t.entity_code);
412:
413: UPDATE xla_entity_types_tl t