APPS.FEM_WEBADI_FACT_TAB_UTILS_PVT dependencies on FEM_OBJECT_DEFINITION_VL

Line 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;

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:
469: END POPULATE_RULE_DETAILS;

Line 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;

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
539: l_hier_obj_id := null;

Line 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;

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
560: l_hier_obj_id := null;

Line 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;

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
582: l_hier_obj_id := null;