99: AND event_class_code = p_event_class_code
100: AND event_type_code = p_event_class_code||'_ALL';
101:
102: BEGIN
103: xla_utility_pkg.trace('> xla_event_types_pkg.type_details_exist' , 10);
104:
105: xla_utility_pkg.trace('event = '||p_event, 20);
106: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
107: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
101:
102: BEGIN
103: xla_utility_pkg.trace('> xla_event_types_pkg.type_details_exist' , 10);
104:
105: xla_utility_pkg.trace('event = '||p_event, 20);
106: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
107: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
108: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
109: xla_utility_pkg.trace('event_type_code = '||p_event_type_code , 20);
102: BEGIN
103: xla_utility_pkg.trace('> xla_event_types_pkg.type_details_exist' , 10);
104:
105: xla_utility_pkg.trace('event = '||p_event, 20);
106: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
107: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
108: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
109: xla_utility_pkg.trace('event_type_code = '||p_event_type_code , 20);
110:
103: xla_utility_pkg.trace('> xla_event_types_pkg.type_details_exist' , 10);
104:
105: xla_utility_pkg.trace('event = '||p_event, 20);
106: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
107: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
108: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
109: xla_utility_pkg.trace('event_type_code = '||p_event_type_code , 20);
110:
111: IF p_event in ('DELETE','DISABLE') THEN
104:
105: xla_utility_pkg.trace('event = '||p_event, 20);
106: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
107: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
108: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
109: xla_utility_pkg.trace('event_type_code = '||p_event_type_code , 20);
110:
111: IF p_event in ('DELETE','DISABLE') THEN
112:
105: xla_utility_pkg.trace('event = '||p_event, 20);
106: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
107: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
108: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
109: xla_utility_pkg.trace('event_type_code = '||p_event_type_code , 20);
110:
111: IF p_event in ('DELETE','DISABLE') THEN
112:
113: IF p_accounting_flag = 'Y' THEN
274: END IF;
275:
276: END IF;
277:
278: xla_utility_pkg.trace('< xla_event_types_pkg.type_details_exist' , 10);
279: p_message := l_message;
280: RETURN l_return;
281:
282: EXCEPTION