DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_USER_DIM9_HIER

Line 3925: elsif p_hier_table_name = 'FEM_USER_DIM9_HIER' then

3921: l_last_updated_by,
3922: l_last_update_date,
3923: l_last_update_login,
3924: 1);
3925: elsif p_hier_table_name = 'FEM_USER_DIM9_HIER' then
3926:
3927: select rowid,
3928: parent_depth_num,
3929: parent_id,

Line 3948: from fem_user_dim9_hier

3944: t_chld_value_set_id,
3945: t_sngle_depth_flag,
3946: t_dspy_order_num,
3947: t_wt_pct
3948: from fem_user_dim9_hier
3949: where hierarchy_obj_def_id = p_src_hier_version_id;
3950:
3951: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3952:

Line 3953: INSERT INTO fem_user_dim9_hier

3949: where hierarchy_obj_def_id = p_src_hier_version_id;
3950:
3951: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3952:
3953: INSERT INTO fem_user_dim9_hier
3954: ( hierarchy_obj_def_id,
3955: parent_depth_num,
3956: parent_id ,
3957: parent_value_set_id,