DBA Data[Home] [Help]

APPS.XLA_EVENT_CLASSES_F_PKG dependencies on XLA_EVENT_CLASSES_B

Line 85: FROM xla_event_classes_b

81: IS
82:
83: CURSOR c IS
84: SELECT rowid
85: FROM xla_event_classes_b
86: WHERE application_id = x_application_id
87: AND entity_code = x_entity_code
88: AND event_class_code = x_event_class_code
89: ;

Line 105: INSERT INTO xla_event_classes_b

101: p_level => C_LEVEL_PROCEDURE);
102: END IF;
103:
104:
105: INSERT INTO xla_event_classes_b
106: (creation_date
107: ,created_by
108: ,application_id
109: ,entity_code

Line 198: FROM xla_event_classes_b

194:
195: CURSOR c IS
196: SELECT application_id
197: ,enabled_flag
198: FROM xla_event_classes_b
199: WHERE application_id = x_application_id
200: AND entity_code = x_entity_code
201: AND event_class_code = x_event_class_code
202: FOR UPDATE OF application_id NOWAIT;

Line 305: UPDATE xla_event_classes_b

301: p_module => l_log_module,
302: p_level => C_LEVEL_PROCEDURE);
303: END IF;
304:
305: UPDATE xla_event_classes_b
306: SET
307: last_update_date = x_last_update_date
308: ,enabled_flag = x_enabled_flag
309: ,last_updated_by = x_last_updated_by

Line 379: DELETE FROM xla_event_classes_b

375: IF (SQL%NOTFOUND) THEN
376: RAISE NO_DATA_FOUND;
377: END IF;
378:
379: DELETE FROM xla_event_classes_b
380: WHERE application_id = x_application_id
381: AND entity_code = x_entity_code
382: AND event_class_code = x_event_class_code;
383:

Line 420: FROM xla_event_classes_b b

416:
417: DELETE FROM xla_event_classes_tl T
418: WHERE NOT EXISTS
419: (SELECT NULL
420: FROM xla_event_classes_b b
421: WHERE b.application_id = t.application_id
422: AND b.entity_code = t.entity_code
423: AND b.event_class_code = t.event_class_code);
424: