[Home] [Help]
727: from fem_object_definition_b
728: where object_definition_id = l_loader_obj_def_id
729: and object_id in (
730: select object_id
731: from fem_object_catalog_b
732: where object_type_code = 'HIERARCHY_LOADER'
733: );
734: exception
735: when no_data_found then
749: -- can read a rule, then they can execute a rule.
750: ------------------------------------------------------------------------------
751: select count(*)
752: into l_count
753: from fem_object_catalog_b o
754: ,fem_user_folders u
755: where o.object_id = l_loader_object_id
756: and u.folder_id = o.folder_id
757: and u.user_id = l_user_id;
760:
761: select f.folder_name
762: into l_loader_folder_name
763: from fem_folders_vl f
764: ,fem_object_catalog_b o
765: where o.object_id = l_loader_object_id
766: and f.folder_id = o.folder_id;
767:
768: FEM_ENGINES_PKG.user_message (
3372:
3373: --BEGIN:multi_thread_final_insert
3374: ------------------------------------------------------------------------------
3375: -- STEP 10: If HIERARCHY_OBJECT_NAME does not exist, then insert the
3376: -- necessary rows in FEM_OBJECT_CATALOG_B/_TL, FEM_HIERARCHIES,
3377: -- FEM_HIER_DIMENSION_GRPS, and FEM_HIER_VALUE_SETS
3378: ------------------------------------------------------------------------------
3379:
3380: if (ld_load_type = g_new_hier) then
3383: -- DEF LOV
3384: --
3385: -- If the hierarchy has a single value set defined, we must get the
3386: -- VALUE_SET_ID for FEM_HIERARCHIES. This must be done before any
3387: -- inserts are made in FEM_OBJECT_CATALOG_B/_TL, as we can have an
3388: -- exception when trying to get the VALUE_SET_ID.
3389: if ( (l_value_set_required_flag = 'Y')
3390: and (ld_multi_value_set_flag = 'N') ) then
3391:
3446:
3447: end if;
3448:
3449: ------------------------------------------------------------------------------
3450: -- STEP 10.2: Insert into FEM_OBJECT_CATALOG_B/_TL
3451: ------------------------------------------------------------------------------
3452: FEM_ENGINES_PKG.tech_message (
3453: p_severity => g_log_level_1
3454: ,p_module => G_BLOCK||'.'||l_api_name
3451: ------------------------------------------------------------------------------
3452: FEM_ENGINES_PKG.tech_message (
3453: p_severity => g_log_level_1
3454: ,p_module => G_BLOCK||'.'||l_api_name
3455: ,p_msg_text => 'Step 10.2: Insert into FEM_OBJECT_CATALOG_B/_TL'
3456: );
3457:
3458: select fem_object_id_seq.nextval
3459: into ld_hierarchy_object_id