DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_CUSTOMERS_HIER

Line 2935: elsif p_hier_table_name = 'FEM_CUSTOMERS_HIER' then

2931: l_last_update_date,
2932: l_last_update_login,
2933: 1);
2934:
2935: elsif p_hier_table_name = 'FEM_CUSTOMERS_HIER' then
2936:
2937: select rowid,
2938: parent_depth_num,
2939: parent_id,

Line 2958: from fem_customers_hier

2954: t_chld_value_set_id,
2955: t_sngle_depth_flag,
2956: t_dspy_order_num,
2957: t_wt_pct
2958: from fem_customers_hier
2959: where hierarchy_obj_def_id = p_src_hier_version_id;
2960:
2961: FORALL rec in t_row_id.FIRST..t_row_id.LAST
2962:

Line 2963: INSERT INTO fem_customers_hier

2959: where hierarchy_obj_def_id = p_src_hier_version_id;
2960:
2961: FORALL rec in t_row_id.FIRST..t_row_id.LAST
2962:
2963: INSERT INTO fem_customers_hier
2964: ( hierarchy_obj_def_id,
2965: parent_depth_num,
2966: parent_id ,
2967: parent_value_set_id,