DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_USER_DIM8_HIER

Line 3864: elsif p_hier_table_name = 'FEM_USER_DIM8_HIER' then

3860: l_last_updated_by,
3861: l_last_update_date,
3862: l_last_update_login,
3863: 1);
3864: elsif p_hier_table_name = 'FEM_USER_DIM8_HIER' then
3865:
3866: select rowid,
3867: parent_depth_num,
3868: parent_id,

Line 3887: from fem_user_dim8_hier

3883: t_chld_value_set_id,
3884: t_sngle_depth_flag,
3885: t_dspy_order_num,
3886: t_wt_pct
3887: from fem_user_dim8_hier
3888: where hierarchy_obj_def_id = p_src_hier_version_id;
3889:
3890: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3891:

Line 3892: INSERT INTO fem_user_dim8_hier

3888: where hierarchy_obj_def_id = p_src_hier_version_id;
3889:
3890: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3891:
3892: INSERT INTO fem_user_dim8_hier
3893: ( hierarchy_obj_def_id,
3894: parent_depth_num,
3895: parent_id ,
3896: parent_value_set_id,