168: END get_org_name;
169:
170: -- Get entity Code description
171: FUNCTION get_entity_code_desc(p_entity_cd IN VARCHAR2) RETURN VARCHAR2 IS
172: l_entity_code_desc xla_entity_types_vl.name%TYPE :='';
173: BEGIN
174: SELECT name INTO l_entity_code_desc FROM xla_entity_types_vl WHERE application_id =555 AND entity_code = p_entity_cd;
175:
176: RETURN l_entity_code_desc;
170: -- Get entity Code description
171: FUNCTION get_entity_code_desc(p_entity_cd IN VARCHAR2) RETURN VARCHAR2 IS
172: l_entity_code_desc xla_entity_types_vl.name%TYPE :='';
173: BEGIN
174: SELECT name INTO l_entity_code_desc FROM xla_entity_types_vl WHERE application_id =555 AND entity_code = p_entity_cd;
175:
176: RETURN l_entity_code_desc;
177:
178: EXCEPTION
181: END get_entity_code_desc;
182:
183: -- Get event class description
184: FUNCTION get_event_class_desc(p_entity_cd IN VARCHAR2, p_event_class_cd IN VARCHAR2) RETURN VARCHAR2 IS
185: l_event_class_desc xla_entity_types_vl.name%TYPE :='';
186: BEGIN
187: SELECT name INTO l_event_class_desc FROM xla_event_classes_vl
188: WHERE application_id =555 AND entity_code = p_entity_cd AND event_class_code = p_event_class_cd;
189:
196:
197: -- Get Event Type description
198: FUNCTION get_event_type_desc(p_entity_cd IN VARCHAR2, p_event_class_cd IN VARCHAR2,p_event_type_cd IN VARCHAR2 )
199: RETURN VARCHAR2 IS
200: l_event_type_desc xla_entity_types_vl.name%TYPE :='';
201:
202: BEGIN
203: SELECT name INTO l_event_type_desc FROM xla_event_types_vl
204: WHERE application_id =555 AND entity_code = p_entity_cd AND event_class_code = p_event_class_cd AND event_type_code = p_event_type_cd;