APPS.FEM_FACTOR_TABLES_UTIL_PKG dependencies on DUAL

Line 277: select nvl((select 'Y' from FEM_HIERARCHIES where hierarchy_obj_id = p_hier_obj_id and dimension_id = p_dimension_id),'N') into l_valid_flag from dual;

273:
274: PROCEDURE VALIDATE_HIERARCHY (x_valid_flag OUT NOCOPY VARCHAR2,p_hier_obj_id IN NUMBER,p_dimension_id IN NUMBER) IS
275: l_valid_flag varchar2(1);
276: BEGIN
277: select nvl((select 'Y' from FEM_HIERARCHIES where hierarchy_obj_id = p_hier_obj_id and dimension_id = p_dimension_id),'N') into l_valid_flag from dual;
278: x_valid_flag := l_valid_flag;
279: END VALIDATE_HIERARCHY;
280:
281: PROCEDURE VALIDATE_GROUP (x_valid_flag OUT NOCOPY VARCHAR2,p_hier_obj_id IN NUMBER,p_group_id IN NUMBER) IS

Line 284: select nvl((select 'Y' from FEM_HIER_DIMENSION_GRPS where hierarchy_obj_id = p_hier_obj_id and dimension_group_id = p_group_id),'N') into l_valid_flag from dual;

280:
281: PROCEDURE VALIDATE_GROUP (x_valid_flag OUT NOCOPY VARCHAR2,p_hier_obj_id IN NUMBER,p_group_id IN NUMBER) IS
282: l_valid_flag varchar2(1);
283: BEGIN
284: select nvl((select 'Y' from FEM_HIER_DIMENSION_GRPS where hierarchy_obj_id = p_hier_obj_id and dimension_group_id = p_group_id),'N') into l_valid_flag from dual;
285: x_valid_flag := l_valid_flag;
286: END VALIDATE_GROUP;
287:
288: PROCEDURE VALIDATE_DIM_MEMBER(x_valid_flag OUT NOCOPY VARCHAR2,p_hier_object_id IN NUMBER,p_group_id IN NUMBER,p_dimension_id IN NUMBER,p_member_id IN NUMBER) IS

Line 307: l_main_query:= 'select nvl((' || l_query || '),''N'') from dual';

303: ' WHERE DIMENSION_GROUP_ID IN (SELECT DIMENSION_GROUP_ID FROM FEM_HIER_DIMENSION_GRPS WHERE HIERARCHY_OBJ_ID = ' || p_hier_object_id ||
304: ') AND DIMENSION_GROUP_ID = ' || p_group_id ||
305: ' AND ' || l_member_col || ' = ' || p_member_id ;
306:
307: l_main_query:= 'select nvl((' || l_query || '),''N'') from dual';
308: execute immediate l_main_query into l_valid_flag;
309:
310: x_valid_flag := l_valid_flag;
311:

Line 318: select nvl((select object_definition_id from fem_object_definition_vl where object_id = p_hier_obj_id and display_name = p_hier_name),-1) into l_hier_obj_def_id from dual;

314: PROCEDURE GET_HIER_OBJ_DEF_ID(x_hier_obj_def_id OUT NOCOPY VARCHAR2,p_hier_obj_id IN VARCHAR2,p_hier_name IN VARCHAR2) IS
315: l_hier_obj_def_id NUMBER;
316: BEGIN
317:
318: select nvl((select object_definition_id from fem_object_definition_vl where object_id = p_hier_obj_id and display_name = p_hier_name),-1) into l_hier_obj_def_id from dual;
319: x_hier_obj_def_id := l_hier_obj_def_id;
320:
321: END GET_HIER_OBJ_DEF_ID;
322: END fem_factor_tables_util_pkg;