APPS.FEM_HIER_UTILS_PVT dependencies on FEM_HIER_VALUE_SETS

Line 2262: from fem_hier_value_sets

2258:
2259: cursor l_hier_value_sets_csr (p_hierarchy_obj_id in NUMBER)
2260: is
2261: select *
2262: from fem_hier_value_sets
2263: where hierarchy_obj_id = p_hierarchy_obj_id;
2264:
2265: cursor l_hier_details_csr (p_hierarchy_obj_id in NUMBER)
2266: is

Line 2401: INSERT INTO fem_hier_value_sets

2397: end loop;
2398:
2399: for l_hier_value_sets_rec in l_hier_value_sets_csr (p_hierarchy_obj_id => p_src_hier_obj_id) loop
2400:
2401: INSERT INTO fem_hier_value_sets
2402: (hierarchy_obj_id,
2403: value_set_id,
2404: creation_date,
2405: created_by,

Line 4945: DELETE FROM fem_hier_value_sets

4941:
4942: DELETE FROM fem_hier_dimension_grps
4943: WHERE hierarchy_obj_id = p_hier_obj_id;
4944:
4945: DELETE FROM fem_hier_value_sets
4946: WHERE hierarchy_obj_id = p_hier_obj_id;
4947:
4948: DELETE FROM fem_hierarchies
4949: WHERE hierarchy_obj_id = p_hier_obj_id;

Line 7229: ' FROM FEM_HIER_VALUE_SETS HVS ' ||

7225: ' H.SINGLE_DEPTH_FLAG = ''Y'' AND ' ||
7226: ' EXISTS ' ||
7227: ' ( ' ||
7228: ' SELECT HVS.VALUE_SET_ID ' ||
7229: ' FROM FEM_HIER_VALUE_SETS HVS ' ||
7230: ' WHERE PARENT_VALUE_SET_ID = HVS.VALUE_SET_ID AND ' ||
7231: ' HVS.HIERARCHY_OBJ_ID = :2 ' ||
7232: ' ) AND ' ||
7233: ' H.CHILD_ID = DIM.' || l_member_col || ' AND ' ||

Line 7440: ' FEM_HIER_VALUE_SETS VS '||

7436: 'WHERE CO.COST_OBJECT_ID = :1 AND ' ||
7437: ' EXISTS (SELECT 1 ' ||
7438: ' FROM '||l_hierarchy_table_name||' H2, '||
7439: ' FEM_OBJECT_DEFINITION_VL OD, '||
7440: ' FEM_HIER_VALUE_SETS VS '||
7441: ' WHERE (H2.PARENT_ID = CO.COST_OBJECT_ID) AND '||
7442: ' H2.HIERARCHY_OBJ_ID = OD.OBJECT_ID AND '||
7443: ' OD.EFFECTIVE_START_DATE BETWEEN H2.EFFECTIVE_START_DATE AND H2.EFFECTIVE_END_DATE '||
7444: ' AND OD.OBJECT_DEFINITION_ID = :2 AND '||