DBA Data[Home] [Help]

APPS.FEM_HIER_UTILS_PVT dependencies on FEM_GEOGRAPHY_HIER

Line 3059: elsif p_hier_table_name = 'FEM_GEOGRAPHY_HIER' then

3055: l_last_update_date,
3056: l_last_update_login,
3057: 1);
3058:
3059: elsif p_hier_table_name = 'FEM_GEOGRAPHY_HIER' then
3060:
3061: select rowid,
3062: parent_depth_num,
3063: parent_id,

Line 3082: from fem_geography_hier

3078: t_chld_value_set_id,
3079: t_sngle_depth_flag,
3080: t_dspy_order_num,
3081: t_wt_pct
3082: from fem_geography_hier
3083: where hierarchy_obj_def_id = p_src_hier_version_id;
3084:
3085: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3086:

Line 3087: INSERT INTO fem_geography_hier

3083: where hierarchy_obj_def_id = p_src_hier_version_id;
3084:
3085: FORALL rec in t_row_id.FIRST..t_row_id.LAST
3086:
3087: INSERT INTO fem_geography_hier
3088: ( hierarchy_obj_def_id,
3089: parent_depth_num,
3090: parent_id ,
3091: parent_value_set_id,