DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_USER_DIM1_HIER

Line 3434: elsif p_hier_table_name = 'FEM_USER_DIM1_HIER' then

3430: l_last_update_date,
3431: l_last_update_login,
3432: 1);
3433:
3434: elsif p_hier_table_name = 'FEM_USER_DIM1_HIER' then
3435:
3436: select rowid,
3437: parent_depth_num,
3438: parent_id,

Line 3457: from fem_user_dim1_hier

3453: t_chld_value_set_id,
3454: t_sngle_depth_flag,
3455: t_dspy_order_num,
3456: t_wt_pct
3457: from fem_user_dim1_hier
3458: where hierarchy_obj_def_id = p_src_hier_version_id;
3459:
3460: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3461:

Line 3462: INSERT INTO fem_user_dim1_hier

3458: where hierarchy_obj_def_id = p_src_hier_version_id;
3459:
3460: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3461:
3462: INSERT INTO fem_user_dim1_hier
3463: ( hierarchy_obj_def_id,
3464: parent_depth_num,
3465: parent_id ,
3466: parent_value_set_id,