APPS.FEM_WEBADI_FACT_TAB_UTILS_PVT dependencies on FEM_OBJECT_CATALOG_VL

Line 433: select decode((select 'Y' from fem_object_catalog_vl where object_name = p_rule_name),'Y','Y',NULL) into l_old_rule from dual;

429: select folder_id into l_folder_id from fem_folders_vl where folder_name = P_FOLDER_NAME;
430:
431: select lookup_code into l_object_access_code from fem_lookups where lookup_type = 'FEM_EDIT_PERMISSION_DSC' and meaning = p_object_access_code;
432:
433: select decode((select 'Y' from fem_object_catalog_vl where object_name = p_rule_name),'Y','Y',NULL) into l_old_rule from dual;
434:
435: IF(l_old_rule is NULL) THEN
436: select FEM_OBJECT_ID_SEQ.NEXTVAL into G_OBJECT_ID from dual;
437:

Line 464: select object_id into G_OBJECT_ID from fem_object_catalog_vl where object_name = p_rule_name;

460: G_ENTER_IN_DIMS := 'Y';
461:
462: ELSE
463:
464: select object_id into G_OBJECT_ID from fem_object_catalog_vl where object_name = p_rule_name;
465: select object_definition_id into G_OBJECT_DEFINITION_ID from fem_object_definition_vl where object_id = G_OBJECT_ID and display_name = p_version_name;
466: G_ENTER_IN_DIMS := 'N';
467: END IF;
468:

Line 534: select object_id into l_hier_obj_id from fem_object_catalog_vl where object_name = p_hierarchy1 and object_type_code = 'HIERARCHY';

530: -- for factor type 'MATCH' and 'MATCH_AND_DISTRIBUTE' p_match_dim1 parameter will never be null/blank/empty
531: select dimension_id into l_dim_id from fem_dimensions_vl where dimension_name = p_matching_dim1;
532:
533: if(p_hierarchy1 is not null AND length(trim(p_hierarchy1)) <> 0) then ---------------------- If p_hierarchy1 is not null then p_hier1_ver and p_level1 will also be not null
534: select object_id into l_hier_obj_id from fem_object_catalog_vl where object_name = p_hierarchy1 and object_type_code = 'HIERARCHY';
535: select object_definition_id into l_hier_obj_def_id from fem_object_definition_vl where display_name = p_hier1_ver and object_id = l_hier_obj_id;
536: select dimension_group_id into l_level_id from fem_dimension_grps_vl where dimension_group_name = p_level1;
537: select lookup_code into l_hierarchy_rel from fem_lookups where lookup_type = 'FEM_COND_HIER_RELATIONS' and meaning = p_hierarchy_rel1;
538: else

Line 555: select object_id into l_hier_obj_id from fem_object_catalog_vl where object_name = p_hierarchy2 and object_type_code = 'HIERARCHY';

551: if(p_matching_dim2 is not null AND length(trim(p_matching_dim2)) <> 0) then
552: select dimension_id into l_dim_id from fem_dimensions_vl where dimension_name = p_matching_dim2;
553:
554: if(p_hierarchy2 is not null AND length(trim(p_hierarchy2)) <> 0) then
555: select object_id into l_hier_obj_id from fem_object_catalog_vl where object_name = p_hierarchy2 and object_type_code = 'HIERARCHY';
556: select object_definition_id into l_hier_obj_def_id from fem_object_definition_vl where display_name = p_hier2_ver and object_id = l_hier_obj_id;
557: select dimension_group_id into l_level_id from fem_dimension_grps_vl where dimension_group_name = p_level2;
558: select lookup_code into l_hierarchy_rel from fem_lookups where lookup_type = 'FEM_COND_HIER_RELATIONS' and meaning = p_hierarchy_rel2;
559: else

Line 577: select object_id into l_hier_obj_id from fem_object_catalog_vl where object_name = p_hierarchy3 and object_type_code = 'HIERARCHY';

573: if(p_matching_dim3 is not null AND length(trim(p_matching_dim3)) <> 0) then
574: select dimension_id into l_dim_id from fem_dimensions_vl where dimension_name = p_matching_dim3;
575:
576: if(p_hierarchy3 is not null AND length(trim(p_hierarchy3)) <> 0) then
577: select object_id into l_hier_obj_id from fem_object_catalog_vl where object_name = p_hierarchy3 and object_type_code = 'HIERARCHY';
578: select object_definition_id into l_hier_obj_def_id from fem_object_definition_vl where display_name = p_hier3_ver and object_id = l_hier_obj_id;
579: select dimension_group_id into l_level_id from fem_dimension_grps_vl where dimension_group_name = p_level3;
580: select lookup_code into l_hierarchy_rel from fem_lookups where lookup_type = 'FEM_COND_HIER_RELATIONS' and meaning = p_hierarchy_rel3;
581: else