APPS.FEM_HIER_LOADER_PKG dependencies on FEM_OBJECT_DEFINITION_B

Line 727: from fem_object_definition_b

723: ------------------------------------------------------------------------------
724: begin
725: select object_id
726: into l_loader_object_id
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

Line 1335: from fem_object_definition_b b1

1331: ,trunc(effective_end_date)
1332: into l_max_object_definition_id
1333: ,l_max_effective_start_date
1334: ,l_max_effective_end_date
1335: from fem_object_definition_b b1
1336: where object_id = ld_hierarchy_object_id
1337: and old_approved_copy_flag = 'N'
1338: and effective_end_date = (
1339: select max(effective_end_date)

Line 1340: from fem_object_definition_b b2

1336: where object_id = ld_hierarchy_object_id
1337: and old_approved_copy_flag = 'N'
1338: and effective_end_date = (
1339: select max(effective_end_date)
1340: from fem_object_definition_b b2
1341: where b2.object_id = b1.object_id
1342: and b2.old_approved_copy_flag = b1.old_approved_copy_flag
1343: );
1344:

Line 3725: -- in FEM_OBJECT_DEFINITION_B/_TL for the designated language. Create

3721:
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:

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 3740: update fem_object_definition_b

3736: );
3737:
3738: if (l_new_max_obj_def_id is not null) then
3739:
3740: update fem_object_definition_b
3741: set effective_end_date = l_new_max_eff_end_date
3742: where object_definition_id = l_new_max_obj_def_id;
3743:
3744: l_new_max_obj_def_id := null;