DBA Data[Home] [Help]

APPS.GMF_SUBLED_REP_PKG dependencies on XLA_ENTITY_TYPES_VL

Line 172: l_entity_code_desc xla_entity_types_vl.name%TYPE :='';

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;

Line 174: SELECT name INTO l_entity_code_desc FROM xla_entity_types_vl WHERE application_id =555 AND entity_code = p_entity_cd;

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

Line 185: l_event_class_desc xla_entity_types_vl.name%TYPE :='';

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:

Line 200: l_event_type_desc xla_entity_types_vl.name%TYPE :='';

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;