2993: l_last_update_date,
2994: l_last_update_login,
2995: 1);
2996:
2997: elsif p_hier_table_name = 'FEM_ENTITIES_HIER' then
2998:
2999: select rowid,
3000: parent_depth_num,
3001: parent_id,
3016: t_chld_value_set_id,
3017: t_sngle_depth_flag,
3018: t_dspy_order_num,
3019: t_wt_pct
3020: from fem_entities_hier
3021: where hierarchy_obj_def_id = p_src_hier_version_id;
3022:
3023: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3024:
3021: where hierarchy_obj_def_id = p_src_hier_version_id;
3022:
3023: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3024:
3025: INSERT INTO fem_entities_hier
3026: ( hierarchy_obj_def_id,
3027: parent_depth_num,
3028: parent_id ,
3029: parent_value_set_id,