DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_CAL_PERIODS_HIER

Line 4050: elsif p_hier_table_name = 'FEM_CAL_PERIODS_HIER' then

4046: l_last_update_login,
4047: 1);
4048:
4049:
4050: elsif p_hier_table_name = 'FEM_CAL_PERIODS_HIER' then
4051:
4052: select rowid,
4053: parent_depth_num,
4054: parent_id,

Line 4069: from fem_cal_periods_hier

4065: t_chld_id,
4066: t_sngle_depth_flag,
4067: t_dspy_order_num,
4068: t_wt_pct
4069: from fem_cal_periods_hier
4070: where hierarchy_obj_def_id = p_src_hier_version_id;
4071:
4072: FORALL rec in t_row_id.FIRST..t_row_id.LAST
4073:

Line 4074: INSERT INTO fem_cal_periods_hier

4070: where hierarchy_obj_def_id = p_src_hier_version_id;
4071:
4072: FORALL rec in t_row_id.FIRST..t_row_id.LAST
4073:
4074: INSERT INTO fem_cal_periods_hier
4075: ( hierarchy_obj_def_id,
4076: parent_depth_num,
4077: parent_id ,
4078: child_depth_num,