56: AND entity_code = p_entity_code
57: AND enabled_flag = 'Y';
58:
59: BEGIN
60: xla_utility_pkg.trace('> xla_entity_types_pkg.event_classes_exist' , 10);
61:
62: xla_utility_pkg.trace('event = '||p_event, 20);
63: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
64: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
58:
59: BEGIN
60: xla_utility_pkg.trace('> xla_entity_types_pkg.event_classes_exist' , 10);
61:
62: xla_utility_pkg.trace('event = '||p_event, 20);
63: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
64: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
65:
66: IF p_event = 'DELETE' THEN
59: BEGIN
60: xla_utility_pkg.trace('> xla_entity_types_pkg.event_classes_exist' , 10);
61:
62: xla_utility_pkg.trace('event = '||p_event, 20);
63: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
64: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
65:
66: IF p_event = 'DELETE' THEN
67:
60: xla_utility_pkg.trace('> xla_entity_types_pkg.event_classes_exist' , 10);
61:
62: xla_utility_pkg.trace('event = '||p_event, 20);
63: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
64: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
65:
66: IF p_event = 'DELETE' THEN
67:
68: OPEN check_event_classes;
86: END IF;
87:
88: END IF;
89:
90: xla_utility_pkg.trace('< xla_entity_types_pkg.event_classes_exist' , 10);
91: RETURN FALSE;
92:
93: EXCEPTION
94: WHEN xla_exceptions_pkg.application_exception THEN
115: IS
116:
117: BEGIN
118:
119: xla_utility_pkg.trace('> xla_entity_types_pkg.delete_entity_details' , 10);
120:
121: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
122: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
123:
117: BEGIN
118:
119: xla_utility_pkg.trace('> xla_entity_types_pkg.delete_entity_details' , 10);
120:
121: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
122: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
123:
124: DELETE
125: FROM xla_entity_id_mappings
118:
119: xla_utility_pkg.trace('> xla_entity_types_pkg.delete_entity_details' , 10);
120:
121: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
122: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
123:
124: DELETE
125: FROM xla_entity_id_mappings
126: WHERE application_id = p_application_id
125: FROM xla_entity_id_mappings
126: WHERE application_id = p_application_id
127: AND entity_code = p_entity_code;
128:
129: xla_utility_pkg.trace('< xla_entity_types_pkg.delete_entity_details' , 10);
130:
131: EXCEPTION
132: WHEN xla_exceptions_pkg.application_exception THEN
133: RAISE;
183: l_locked_aad c_locked_aads%rowtype;
184:
185: BEGIN
186:
187: xla_utility_pkg.trace('> xla_entity_types_pkg.uncompile_definitions' , 10);
188:
189: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
190: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
191:
185: BEGIN
186:
187: xla_utility_pkg.trace('> xla_entity_types_pkg.uncompile_definitions' , 10);
188:
189: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
190: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
191:
192: OPEN c_locked_aads;
193: FETCH c_locked_aads INTO l_locked_aad;
186:
187: xla_utility_pkg.trace('> xla_entity_types_pkg.uncompile_definitions' , 10);
188:
189: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
190: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
191:
192: OPEN c_locked_aads;
193: FETCH c_locked_aads INTO l_locked_aad;
194: IF (c_locked_aads%FOUND) THEN
257: x_event_class_name := l_event_class_name;
258: x_event_type_name := l_event_type_name;
259: x_locking_status_flag := l_locking_status_flag;
260:
261: xla_utility_pkg.trace('< xla_entity_types_pkg.uncompile_definitions' , 10);
262:
263: return l_return;
264:
265: EXCEPTION