[Home] [Help]
527:
528: if(l_factor_type_code <> 'DISTRIBUTE') then
529:
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;
548: sysdate,l_user_id,l_user_id,sysdate,l_update_login,0);
549: l_level_num := l_level_num + 1;
550:
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;
570: l_level_num := l_level_num + 1;
571: end if;
572:
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;
598:
599: select lookup_code into l_force_to_hundred from fem_lookups where lookup_type = 'FEM_WEBADI_YES_NO' and meaning = p_force_to_hundred;
600:
601: if(p_distribution_dim is not null AND length(trim(p_distribution_dim)) <> 0) then
602: select dimension_id into l_dim_id from fem_dimensions_vl where dimension_name = p_distribution_dim;
603: l_hier_obj_id := null;
604: l_hier_obj_def_id := null;
605: l_level_id := null;
606: insert into fem_factor_table_dims(OBJECT_DEFINITION_ID,LEVEL_NUM,DIMENSION_ID,DIM_USAGE_CODE,FORCE_PERCENT_FLAG,HIER_OBJECT_ID,HIER_OBJ_DEF_ID,HIER_GROUP_ID,HIER_RELATION_CODE,