DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_USER_DIM10_HIER

Line 3987: elsif p_hier_table_name = 'FEM_USER_DIM10_HIER' then

3983: l_last_update_date,
3984: l_last_update_login,
3985: 1);
3986:
3987: elsif p_hier_table_name = 'FEM_USER_DIM10_HIER' then
3988:
3989: select rowid,
3990: parent_depth_num,
3991: parent_id,

Line 4010: from fem_user_dim10_hier

4006: t_chld_value_set_id,
4007: t_sngle_depth_flag,
4008: t_dspy_order_num,
4009: t_wt_pct
4010: from fem_user_dim10_hier
4011: where hierarchy_obj_def_id = p_src_hier_version_id;
4012:
4013: FORALL rec in t_row_id.FIRST..t_row_id.LAST
4014:

Line 4015: INSERT INTO fem_user_dim10_hier

4011: where hierarchy_obj_def_id = p_src_hier_version_id;
4012:
4013: FORALL rec in t_row_id.FIRST..t_row_id.LAST
4014:
4015: INSERT INTO fem_user_dim10_hier
4016: ( hierarchy_obj_def_id,
4017: parent_depth_num,
4018: parent_id ,
4019: parent_value_set_id,