APPS.XLA_EVENT_CLASS_GRPS_F_PKG dependencies on XLA_EVENT_CLASS_GRPS_B

Line 85: FROM xla_event_class_grps_b

81: IS
82:
83: CURSOR c IS
84: SELECT rowid
85: FROM xla_event_class_grps_b
86: WHERE application_id = x_application_id
87: AND event_class_group_code = x_event_class_group_code
88: ;
89:

Line 103: INSERT INTO xla_event_class_grps_b

99: p_module => l_log_module,
100: p_level => C_LEVEL_PROCEDURE);
101: END IF;
102:
103: INSERT INTO xla_event_class_grps_b
104: (creation_date
105: ,created_by
106: ,application_id
107: ,event_class_group_code

Line 190: FROM xla_event_class_grps_b

186:
187: CURSOR c IS
188: SELECT application_id
189: ,enabled_flag
190: FROM xla_event_class_grps_b
191: WHERE application_id = x_application_id
192: AND event_class_group_code = x_event_class_group_code
193: FOR UPDATE OF application_id NOWAIT;
194:

Line 296: UPDATE xla_event_class_grps_b

292: p_module => l_log_module,
293: p_level => C_LEVEL_PROCEDURE);
294: END IF;
295:
296: UPDATE xla_event_class_grps_b
297: SET
298: last_update_date = x_last_update_date
299: ,enabled_flag = x_enabled_flag
300: ,last_updated_by = x_last_updated_by

Line 366: DELETE FROM xla_event_class_grps_b

362: IF (SQL%NOTFOUND) THEN
363: RAISE NO_DATA_FOUND;
364: END IF;
365:
366: DELETE FROM xla_event_class_grps_b
367: WHERE application_id = x_application_id
368: AND event_class_group_code = x_event_class_group_code;
369:
370:

Line 409: FROM xla_event_class_grps_b b

405:
406: DELETE FROM xla_event_class_grps_tl T
407: WHERE NOT EXISTS
408: (SELECT NULL
409: FROM xla_event_class_grps_b b
410: WHERE b.application_id = t.application_id
411: AND b.event_class_group_code = t.event_class_group_code);
412:
413: UPDATE xla_event_class_grps_tl t