APPS.FEM_INTG_HIER_RULE_ENG_PKG dependencies on FEM_INTG_HIER_DEF_SEGS

Line 66: FROM fem_intg_hier_def_segs

62: CURSOR c_traversal_info is
63: SELECT display_order_num,
64: application_column_name,
65: top_parent_value
66: FROM fem_intg_hier_def_segs
67: WHERE hier_rule_obj_def_id = pv_hier_rule_obj_def_id
68: ORDER BY display_order_num;
69: v_traversal_info c_traversal_info%ROWTYPE;
70: l_rec r_hier_traversal;

Line 103: FROM fem_intg_hier_def_segs

99: IF (pv_hier_obj_id <> -1) THEN
100: BEGIN
101: SELECT nvl(hier_obj_def_id,-1)
102: INTO pv_hier_obj_def_id
103: FROM fem_intg_hier_def_segs
104: WHERE hier_rule_obj_def_id = pv_hier_rule_obj_def_id
105: AND display_order_num = 1;
106: EXCEPTION
107: WHEN NO_DATA_FOUND THEN

Line 183: fem_intg_hier_def_segs seg,

179: FROM fem_intg_hier_rules hir,
180: fem_object_definition_b b1,
181: fem_intg_dim_rules dr,
182: fem_intg_dim_rule_defs drf,
183: fem_intg_hier_def_segs seg,
184: fnd_flex_values v,
185: fem_xdim_dimensions d,
186: fem_intg_aol_valset_map m
187: WHERE hir.hier_rule_obj_id = pv_hier_rule_obj_id

Line 256: fem_intg_hier_def_segs seg,

252: FROM fem_intg_hier_rules hir,
253: fem_object_definition_b b1,
254: fem_intg_dim_rules dr,
255: fem_intg_dim_rule_defs drf,
256: fem_intg_hier_def_segs seg,
257: fnd_flex_values v,
258: fem_xdim_dimensions d,
259: fem_intg_aol_valset_map m
260: WHERE hir.hier_rule_obj_id = pv_hier_rule_obj_id

Line 2680: -- (3) Update fem_intg_hier_def_segs.hier_obj_def_id

2676: -- 2. Initaillize the requried variables - call Init()
2677: -- 3. If the hierarchy rule has never been processed before.
2678: -- (1) Create Object - FEM_Dim_Hier_Util_Pkg.New_Hier_Object
2679: -- (2) Update hierarchy_obj_id
2680: -- (3) Update fem_intg_hier_def_segs.hier_obj_def_id
2681: -- ELSIF the version has not been run before
2682: -- (1) Create Object Definition - FEM_Dim_Hier_Util_Pkg.New_Hier_Object_Def
2683: -- (2) Update fem_intg_hier_def_segs.hier_obj_def_id
2684: -- ELSE

Line 2683: -- (2) Update fem_intg_hier_def_segs.hier_obj_def_id

2679: -- (2) Update hierarchy_obj_id
2680: -- (3) Update fem_intg_hier_def_segs.hier_obj_def_id
2681: -- ELSIF the version has not been run before
2682: -- (1) Create Object Definition - FEM_Dim_Hier_Util_Pkg.New_Hier_Object_Def
2683: -- (2) Update fem_intg_hier_def_segs.hier_obj_def_id
2684: -- ELSE
2685: -- (1) Call FEM_PL_PKG.Obj_Def_Data_Edit_Lock_Exists
2686: -- 4.If (pv_dim_mapping_option_code = SINGLESEG) then
2687: -- Call Bld_Hier_Single_Segment( )

Line 2896: UPDATE fem_intg_hier_def_segs

2892: UPDATE fem_hierarchies
2893: SET value_set_id = pv_dim_vs_id
2894: WHERE hierarchy_obj_id = pv_hier_obj_id;
2895: -- Update hierarchy_obj_id
2896: UPDATE fem_intg_hier_def_segs
2897: SET hier_obj_def_id = pv_hier_obj_def_id,
2898: last_updated_by = pv_user_id,
2899: last_update_date = sysdate,
2900: last_update_login = pv_login_id

Line 2945: UPDATE fem_intg_hier_def_segs

2941: p_module => 'fem.plsql.fem_intg_hier_eng.' ||'after New_Hier_Object_Def',
2942: p_msg_text => 'pv_hier_obj_id:' || pv_hier_obj_id||
2943: ' pv_hier_obj_def_id:' || pv_hier_obj_def_id);
2944: -- Update hierarchy obj def id
2945: UPDATE fem_intg_hier_def_segs
2946: SET hier_obj_def_id = pv_hier_obj_def_id,
2947: last_updated_by = pv_user_id,
2948: last_update_date = sysdate,
2949: last_update_login = pv_login_id