DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_USER_DIM6_HIER

Line 3742: elsif p_hier_table_name = 'FEM_USER_DIM6_HIER' then

3738: l_last_updated_by,
3739: l_last_update_date,
3740: l_last_update_login,
3741: 1);
3742: elsif p_hier_table_name = 'FEM_USER_DIM6_HIER' then
3743:
3744: select rowid,
3745: parent_depth_num,
3746: parent_id,

Line 3765: from fem_user_dim6_hier

3761: t_chld_value_set_id,
3762: t_sngle_depth_flag,
3763: t_dspy_order_num,
3764: t_wt_pct
3765: from fem_user_dim6_hier
3766: where hierarchy_obj_def_id = p_src_hier_version_id;
3767:
3768: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3769:

Line 3770: INSERT INTO fem_user_dim6_hier

3766: where hierarchy_obj_def_id = p_src_hier_version_id;
3767:
3768: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3769:
3770: INSERT INTO fem_user_dim6_hier
3771: ( hierarchy_obj_def_id,
3772: parent_depth_num,
3773: parent_id ,
3774: parent_value_set_id,