44: --
45: CURSOR check_event_types
46: IS
47: SELECT 'x'
48: FROM xla_event_types_vl
49: WHERE application_id = p_application_id
50: AND entity_code = p_entity_code
51: AND event_class_code = p_event_class_code
52: AND event_type_code <> p_event_class_code||'_ALL';
53:
54: CURSOR check_enabled_event_types
55: IS
56: SELECT 'x'
57: FROM xla_event_types_vl
58: WHERE application_id = p_application_id
59: AND entity_code = p_entity_code
60: AND event_class_code = p_event_class_code
61: AND event_type_code <> p_event_class_code||'_ALL'