94: AND entity_code = p_entity_code
95: AND event_class_code = p_event_class_code;
96:
97: BEGIN
98: xla_utility_pkg.trace('> xla_event_classes_pkg.class_details_exist' , 10);
99:
100: xla_utility_pkg.trace('event = '||p_event, 20);
101: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
102: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
96:
97: BEGIN
98: xla_utility_pkg.trace('> xla_event_classes_pkg.class_details_exist' , 10);
99:
100: xla_utility_pkg.trace('event = '||p_event, 20);
101: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
102: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
103: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
104:
97: BEGIN
98: xla_utility_pkg.trace('> xla_event_classes_pkg.class_details_exist' , 10);
99:
100: xla_utility_pkg.trace('event = '||p_event, 20);
101: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
102: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
103: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
104:
105: IF p_event = 'DELETE' THEN
98: xla_utility_pkg.trace('> xla_event_classes_pkg.class_details_exist' , 10);
99:
100: xla_utility_pkg.trace('event = '||p_event, 20);
101: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
102: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
103: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
104:
105: IF p_event = 'DELETE' THEN
106:
99:
100: xla_utility_pkg.trace('event = '||p_event, 20);
101: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
102: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
103: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
104:
105: IF p_event = 'DELETE' THEN
106:
107: OPEN check_event_types;
199: END IF;
200:
201: END IF;
202:
203: xla_utility_pkg.trace('< xla_event_classes_pkg.class_details_exist' , 10);
204: RETURN l_return;
205:
206: EXCEPTION
207: WHEN xla_exceptions_pkg.application_exception THEN
240: AND entity_code = p_entity_code
241: AND event_class_code = p_event_class_code;
242: BEGIN
243:
244: xla_utility_pkg.trace('> xla_event_classes_pkg.delete_class_details' , 10);
245:
246: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
247: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
248: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
242: BEGIN
243:
244: xla_utility_pkg.trace('> xla_event_classes_pkg.delete_class_details' , 10);
245:
246: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
247: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
248: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
249:
250: l_application_id := p_application_id;
243:
244: xla_utility_pkg.trace('> xla_event_classes_pkg.delete_class_details' , 10);
245:
246: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
247: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
248: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
249:
250: l_application_id := p_application_id;
251: l_event_class_code := p_event_class_code;
244: xla_utility_pkg.trace('> xla_event_classes_pkg.delete_class_details' , 10);
245:
246: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
247: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
248: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
249:
250: l_application_id := p_application_id;
251: l_event_class_code := p_event_class_code;
252:
294: ,x_entity_code => p_entity_code
295: ,x_event_class_code => p_event_class_code
296: ,x_event_type_code => p_event_class_code||'_ALL');
297:
298: xla_utility_pkg.trace('< xla_event_classes_pkg.delete_class_details' , 10);
299:
300: EXCEPTION
301: WHEN xla_exceptions_pkg.application_exception THEN
302: RAISE;
323: IS
324:
325: BEGIN
326:
327: xla_utility_pkg.trace('> xla_event_classes_pkg.create_default_event_type' , 10);
328:
329: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
330: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
331:
325: BEGIN
326:
327: xla_utility_pkg.trace('> xla_event_classes_pkg.create_default_event_type' , 10);
328:
329: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
330: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
331:
332: xla_utility_pkg.trace('< xla_event_classes_pkg.create_default_event_type' , 10);
333:
326:
327: xla_utility_pkg.trace('> xla_event_classes_pkg.create_default_event_type' , 10);
328:
329: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
330: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
331:
332: xla_utility_pkg.trace('< xla_event_classes_pkg.create_default_event_type' , 10);
333:
334: EXCEPTION
328:
329: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
330: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
331:
332: xla_utility_pkg.trace('< xla_event_classes_pkg.create_default_event_type' , 10);
333:
334: EXCEPTION
335: WHEN xla_exceptions_pkg.application_exception THEN
336: RAISE;
387: l_locked_aad c_locked_aads%rowtype;
388:
389: BEGIN
390:
391: xla_utility_pkg.trace('> xla_event_classes_pkg.uncompile_definitions' , 10);
392:
393: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
394: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
395:
389: BEGIN
390:
391: xla_utility_pkg.trace('> xla_event_classes_pkg.uncompile_definitions' , 10);
392:
393: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
394: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
395:
396: OPEN c_locked_aads;
397: FETCH c_locked_aads INTO l_locked_aad;
390:
391: xla_utility_pkg.trace('> xla_event_classes_pkg.uncompile_definitions' , 10);
392:
393: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
394: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
395:
396: OPEN c_locked_aads;
397: FETCH c_locked_aads INTO l_locked_aad;
398: IF (c_locked_aads%FOUND) THEN
459: x_event_class_name := l_event_class_name;
460: x_event_type_name := l_event_type_name;
461: x_locking_status_flag := l_locking_status_flag;
462:
463: xla_utility_pkg.trace('< xla_event_classes_pkg.uncompile_definitions' , 10);
464:
465: return l_return;
466:
467: EXCEPTION
508: AND event_class_code = p_event_class_code
509: AND locking_status_flag = 'Y';
510: BEGIN
511:
512: xla_utility_pkg.trace('> xla_event_classes_pkg.event_class_is_locked' , 10);
513:
514: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
515: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
516:
510: BEGIN
511:
512: xla_utility_pkg.trace('> xla_event_classes_pkg.event_class_is_locked' , 10);
513:
514: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
515: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
516:
517: OPEN c_frozen_assignment_exist;
518: FETCH c_frozen_assignment_exist
511:
512: xla_utility_pkg.trace('> xla_event_classes_pkg.event_class_is_locked' , 10);
513:
514: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
515: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
516:
517: OPEN c_frozen_assignment_exist;
518: FETCH c_frozen_assignment_exist
519: INTO l_exist;
523: l_return := FALSE;
524: END IF;
525: CLOSE c_frozen_assignment_exist;
526:
527: xla_utility_pkg.trace('< xla_event_classes_pkg.event_class_is_locked' , 10);
528:
529: return l_return;
530:
531: EXCEPTION