[Home] [Help]
427:
428: BEGIN
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
502: l_force_to_hundred varchar2(10);
503:
504: BEGIN
505:
506: select lookup_code into l_factor_type_code from fem_lookups where lookup_type = 'FEM_FACTOR_TABLE_TYPES_DSC' and meaning = p_factor_type;
507:
508: if(G_ENTER_IN_DIMS = 'Y') THEN
509:
510: insert into FEM_FACTOR_TABLES(OBJECT_DEFINITION_ID,
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;
540: l_hier_obj_def_id := null;
541: l_level_id := null;
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;
561: l_hier_obj_def_id := null;
562: l_level_id := null;
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;
583: l_hier_obj_def_id := null;
584: l_level_id := null;
595: end if; --- End for factor_type check
596:
597: if(l_factor_type_code <> 'MATCH') then
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;