DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_USER_DIM7_HIER

Line 3803: elsif p_hier_table_name = 'FEM_USER_DIM7_HIER' then

3799: l_last_updated_by,
3800: l_last_update_date,
3801: l_last_update_login,
3802: 1);
3803: elsif p_hier_table_name = 'FEM_USER_DIM7_HIER' then
3804:
3805: select rowid,
3806: parent_depth_num,
3807: parent_id,

Line 3826: from fem_user_dim7_hier

3822: t_chld_value_set_id,
3823: t_sngle_depth_flag,
3824: t_dspy_order_num,
3825: t_wt_pct
3826: from fem_user_dim7_hier
3827: where hierarchy_obj_def_id = p_src_hier_version_id;
3828:
3829: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3830:

Line 3831: INSERT INTO fem_user_dim7_hier

3827: where hierarchy_obj_def_id = p_src_hier_version_id;
3828:
3829: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3830:
3831: INSERT INTO fem_user_dim7_hier
3832: ( hierarchy_obj_def_id,
3833: parent_depth_num,
3834: parent_id ,
3835: parent_value_set_id,