DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_ACTIVITIES_HIER

Line 4211: elsif p_hier_table_name = 'FEM_ACTIVITIES_HIER' then

4207: l_last_update_date,
4208: l_last_update_login,
4209: 1);
4210:
4211: elsif p_hier_table_name = 'FEM_ACTIVITIES_HIER' then
4212:
4213: SELECT rowid,
4214: parent_depth_num,
4215: parent_id,

Line 4230: FROM fem_activities_hier

4226: t_chld_id,
4227: t_sngle_depth_flag,
4228: t_dspy_order_num,
4229: t_wt_pct
4230: FROM fem_activities_hier
4231: WHERE hierarchy_obj_def_id = p_src_hier_version_id;
4232:
4233: FORALL rec IN t_row_id.FIRST..t_row_id.LAST
4234:

Line 4235: INSERT INTO fem_activities_hier

4231: WHERE hierarchy_obj_def_id = p_src_hier_version_id;
4232:
4233: FORALL rec IN t_row_id.FIRST..t_row_id.LAST
4234:
4235: INSERT INTO fem_activities_hier
4236: ( hierarchy_obj_def_id,
4237: parent_depth_num,
4238: parent_id ,
4239: child_depth_num,