DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_CHANNELS_HIER

Line 2811: elsif p_hier_table_name = 'FEM_CHANNELS_HIER' then

2807: l_last_update_date,
2808: l_last_update_login,
2809: 1);
2810:
2811: elsif p_hier_table_name = 'FEM_CHANNELS_HIER' then
2812:
2813: select rowid,
2814: parent_depth_num,
2815: parent_id,

Line 2834: from fem_channels_hier

2830: t_chld_value_set_id,
2831: t_sngle_depth_flag,
2832: t_dspy_order_num,
2833: t_wt_pct
2834: from fem_channels_hier
2835: where hierarchy_obj_def_id = p_src_hier_version_id;
2836:
2837: FORALL rec in t_row_id.FIRST..t_row_id.LAST
2838:

Line 2839: INSERT INTO fem_channels_hier

2835: where hierarchy_obj_def_id = p_src_hier_version_id;
2836:
2837: FORALL rec in t_row_id.FIRST..t_row_id.LAST
2838:
2839: INSERT INTO fem_channels_hier
2840: ( hierarchy_obj_def_id,
2841: parent_depth_num,
2842: parent_id ,
2843: parent_value_set_id,