APPS.FEM_HIER_UTILS_PVT dependencies on FEM_PROJECTS_HIER

Line 3248: elsif p_hier_table_name = 'FEM_PROJECTS_HIER' then

3244: l_last_update_date,
3245: l_last_update_login,
3246: 1);
3247:
3248: elsif p_hier_table_name = 'FEM_PROJECTS_HIER' then
3249:
3250: select rowid,
3251: parent_depth_num,
3252: parent_id,

Line 3271: from fem_projects_hier

3267: t_chld_value_set_id,
3268: t_sngle_depth_flag,
3269: t_dspy_order_num,
3270: t_wt_pct
3271: from fem_projects_hier
3272: where hierarchy_obj_def_id = p_src_hier_version_id;
3273:
3274: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3275:

Line 3276: INSERT INTO fem_projects_hier

3272: where hierarchy_obj_def_id = p_src_hier_version_id;
3273:
3274: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3275:
3276: INSERT INTO fem_projects_hier
3277: ( hierarchy_obj_def_id,
3278: parent_depth_num,
3279: parent_id ,
3280: parent_value_set_id,

Line 3372: elsif p_hier_table_name = 'FEM_PROJECTS_HIER' then

3368: l_last_update_date,
3369: l_last_update_login,
3370: 1);
3371:
3372: elsif p_hier_table_name = 'FEM_PROJECTS_HIER' then
3373:
3374: select rowid,
3375: parent_depth_num,
3376: parent_id,

Line 3395: from fem_projects_hier

3391: t_chld_value_set_id,
3392: t_sngle_depth_flag,
3393: t_dspy_order_num,
3394: t_wt_pct
3395: from fem_projects_hier
3396: where hierarchy_obj_def_id = p_src_hier_version_id;
3397:
3398: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3399:

Line 3400: INSERT INTO fem_projects_hier

3396: where hierarchy_obj_def_id = p_src_hier_version_id;
3397:
3398: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3399:
3400: INSERT INTO fem_projects_hier
3401: ( hierarchy_obj_def_id,
3402: parent_depth_num,
3403: parent_id ,
3404: parent_value_set_id,