DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_USER_DIM5_HIER

Line 3681: elsif p_hier_table_name = 'FEM_USER_DIM5_HIER' then

3677: l_last_updated_by,
3678: l_last_update_date,
3679: l_last_update_login,
3680: 1);
3681: elsif p_hier_table_name = 'FEM_USER_DIM5_HIER' then
3682:
3683: select rowid,
3684: parent_depth_num,
3685: parent_id,

Line 3704: from fem_user_dim5_hier

3700: t_chld_value_set_id,
3701: t_sngle_depth_flag,
3702: t_dspy_order_num,
3703: t_wt_pct
3704: from fem_user_dim5_hier
3705: where hierarchy_obj_def_id = p_src_hier_version_id;
3706:
3707: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3708:

Line 3709: INSERT INTO fem_user_dim5_hier

3705: where hierarchy_obj_def_id = p_src_hier_version_id;
3706:
3707: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3708:
3709: INSERT INTO fem_user_dim5_hier
3710: ( hierarchy_obj_def_id,
3711: parent_depth_num,
3712: parent_id ,
3713: parent_value_set_id,