2246: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Hierarchy' ;
2247: l_api_version CONSTANT NUMBER := 1.0;
2248:
2249: l_hier_dim_groups_rec FEM_HIER_DIMENSION_GRPS%rowtype;
2250: l_object_catalog_details_rec FEM_OBJECT_CATALOG_VL%rowtype;
2251: l_hier_details_rec FEM_HIERARCHIES%rowtype;
2252:
2253: cursor l_hier_dim_groups_csr (p_hierarchy_obj_id in NUMBER)
2254: is
2270:
2271: cursor l_object_catalog_details_csr (p_object_id in NUMBER)
2272: is
2273: select *
2274: from fem_object_catalog_vl
2275: where object_id = p_object_id;
2276:
2277: begin
2278:
5093: IS
5094: SELECT 'Y' FROM dual
5095: WHERE EXISTs
5096: (SELECT 1
5097: FROM fem_object_catalog_vl obj,
5098: fem_object_definition_vl ver
5099: WHERE obj.object_id = ver.object_id
5100: AND ver.object_definition_id <> p_version_id
5101: AND ver.object_id = p_object_id);