APPS.FEM_HIER_LOADER_PKG dependencies on FEM_HIER_DEFINITIONS

Line 3726: -- the necessary rows in FEM_OBJECT_DEFINITION_B/_TL and FEM_HIER_DEFINITIONS

3722:
3723: ------------------------------------------------------------------------------
3724: -- STEP 11: For each HIERARCHY_OBJ_DEF_DISPLAY_NAME check to see if it exists
3725: -- in FEM_OBJECT_DEFINITION_B/_TL for the designated language. Create
3726: -- the necessary rows in FEM_OBJECT_DEFINITION_B/_TL and FEM_HIER_DEFINITIONS
3727: -- it does not exist.
3728: ------------------------------------------------------------------------------
3729:
3730: if (ld_load_type in (g_new_hier, g_new_hier_def)) then

Line 3775: insert into fem_hier_definitions (

3771: ,x_last_update_login => l_login_id
3772: ,x_object_version_number => g_object_version_number
3773: );
3774:
3775: insert into fem_hier_definitions (
3776: hierarchy_obj_def_id
3777: ,flattened_rows_completion_code
3778: ,creation_date
3779: ,created_by

Line 3822: update fem_hier_definitions

3818: -- Also update the Hierarchy Definition to 'PENDING' if the hierarchy
3819: -- will be flattened after loading completes.
3820: if (ld_flattened_rows_flag = 'Y') then
3821:
3822: update fem_hier_definitions
3823: set flattened_rows_completion_code = 'PENDING'
3824: ,last_updated_by = l_user_id
3825: ,last_update_date = sysdate
3826: ,last_update_login = l_login_id