[Home] [Help]
86: INTO pv_hier_obj_id,
87: pv_hier_rule_obj_name
88: FROM fem_object_definition_b b,
89: fem_object_catalog_vl o,
90: fem_intg_hier_rules h
91: WHERE b.object_definition_id = pv_hier_rule_obj_def_id
92: AND b.object_id = o.object_id
93: AND o.object_id = h.hier_rule_obj_id;
94: EXCEPTION
119: -- case below.
120: BEGIN
121: SELECT DIM_MAPPING_OPTION_CODE
122: INTO pv_dim_mapping_option_code
123: FROM fem_intg_hier_rules h,
124: fem_intg_dim_rule_defs d
125: WHERE HIER_RULE_OBJ_ID = pv_hier_rule_obj_id
126: AND h.DIM_RULE_OBJ_DEF_ID = d.DIM_RULE_OBJ_DEF_ID;
127: EXCEPTION
175: pv_dim_rule_obj_id,
176: pv_aol_vs_id,
177: pv_flatten_hier_flag,
178: pv_sequence_enforced_flag
179: FROM fem_intg_hier_rules hir,
180: fem_object_definition_b b1,
181: fem_intg_dim_rules dr,
182: fem_intg_dim_rule_defs drf,
183: fem_intg_hier_def_segs seg,
248: v_app_col_name2,
249: v_app_col_name3,
250: v_app_col_name4,
251: v_app_col_name5
252: FROM fem_intg_hier_rules hir,
253: fem_object_definition_b b1,
254: fem_intg_dim_rules dr,
255: fem_intg_dim_rule_defs drf,
256: fem_intg_hier_def_segs seg,
878: AND m.'||pv_dim_memb_col||' NOT IN
879: (SELECT mh.parent_id
880: FROM '||pv_dim_hier_tab||' mh,
881: fem_object_definition_b odb,
882: fem_intg_hier_rules ihr
883: WHERE mh.hierarchy_obj_def_id = odb.object_definition_id
884: AND odb.object_id = ihr.hierarchy_obj_id
885: AND ihr.dim_rule_obj_def_id = '||pv_dim_rule_obj_def_id||'
886: AND mh.parent_value_set_id = '||pv_dim_vs_id||'
2881: p_module => 'fem.plsql.fem_intg_hier_eng.' ||'after New_Hier_Object',
2882: p_msg_text => 'pv_hier_obj_id:' || pv_hier_obj_id||
2883: ' pv_hier_obj_def_id:' || pv_hier_obj_def_id);
2884: -- Update hierarchy_obj_id
2885: UPDATE fem_intg_hier_rules
2886: SET hierarchy_obj_id = pv_hier_obj_id,
2887: last_updated_by = pv_user_id,
2888: last_update_date = sysdate,
2889: last_update_login = pv_login_id