APPS.FII_FDHM_PKG dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 76: DELETE FND_FLEX_VALUE_NORM_HIERARCHY

72: AND child_flex_value_low = range_low
73: AND child_flex_value_high = range_high;
74:
75: IF ( parent_value_set_id = child_value_set_id ) THEN
76: DELETE FND_FLEX_VALUE_NORM_HIERARCHY
77: WHERE flex_value_set_id = parent_value_set_id
78: AND parent_flex_value = parent
79: AND range_attribute = range_attr
80: AND child_flex_value_low = range_low

Line 109: UPDATE FND_FLEX_VALUE_NORM_HIERARCHY

105: AND child_flex_value_low = range_low
106: AND child_flex_value_high = range_high;
107:
108: IF ( parent_value_set_id = child_value_set_id ) THEN
109: UPDATE FND_FLEX_VALUE_NORM_HIERARCHY
110: SET child_flex_value_low = new_bound
111: WHERE flex_value_set_id = parent_value_set_id
112: AND parent_flex_value = parent
113: AND range_attribute = range_attr

Line 143: UPDATE FND_FLEX_VALUE_NORM_HIERARCHY

139: AND child_flex_value_low = range_low
140: AND child_flex_value_high = range_high;
141:
142: IF ( parent_value_set_id = child_value_set_id ) THEN
143: UPDATE FND_FLEX_VALUE_NORM_HIERARCHY
144: SET child_flex_value_high = new_bound
145: WHERE flex_value_set_id = parent_value_set_id
146: AND parent_flex_value = parent
147: AND range_attribute = range_attr

Line 167: DELETE FND_FLEX_VALUE_NORM_HIERARCHY

163: AND child_flex_value_low = range_low
164: AND child_flex_value_high = range_high;
165:
166: IF ( parent_value_set_id = child_value_set_id ) THEN
167: DELETE FND_FLEX_VALUE_NORM_HIERARCHY
168: WHERE flex_value_set_id = parent_value_set_id
169: AND parent_flex_value = parent
170: AND range_attribute = range_attr
171: AND child_flex_value_low = range_low

Line 216: INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY

212: 0,
213: fnd_global.login_id);
214:
215: IF ( parent_value_set_id = child_value_set_id ) THEN
216: INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY
217: ( flex_value_set_id,
218: parent_flex_value,
219: range_attribute,
220: child_flex_value_low,

Line 283: INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY

279: 0,
280: fnd_global.login_id );
281:
282: IF ( parent_value_set_id = child_value_set_id ) THEN
283: INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY
284: ( flex_value_set_id,
285: parent_flex_value,
286: range_attribute,
287: child_flex_value_low,

Line 580: FROM FND_FLEX_VALUE_NORM_HIERARCHY

576: last_updated_by,
577: creation_date,
578: created_by,
579: last_update_login
580: FROM FND_FLEX_VALUE_NORM_HIERARCHY
581: WHERE flex_value_set_id in
582: (SELECT r.flex_value_set_id1
583: FROM fii_dim_mapping_rules r
584: WHERE r.dimension_short_name = dim_short_name

Line 605: FROM FND_FLEX_VALUE_NORM_HIERARCHY,

601: last_updated_by,
602: creation_date,
603: created_by,
604: last_update_login
605: FROM FND_FLEX_VALUE_NORM_HIERARCHY,
606: (
607: SELECT r.flex_value_set_id1 vs_id
608: FROM fii_dim_mapping_rules r,
609: (SELECT distinct chart_of_accounts_id

Line 911: INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY

907: range_high IN VARCHAR2,
908: value_set_id IN NUMBER)
909: IS
910: BEGIN
911: INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY
912: ( flex_value_set_id,
913: parent_flex_value,
914: range_attribute,
915: child_flex_value_low,

Line 946: DELETE FROM FND_FLEX_VALUE_NORM_HIERARCHY

942: range_high IN VARCHAR2,
943: value_set_id IN NUMBER)
944: IS
945: BEGIN
946: DELETE FROM FND_FLEX_VALUE_NORM_HIERARCHY
947: WHERE flex_value_set_id = value_set_id
948: AND parent_flex_value=parent
949: AND range_attribute= range_attr
950: AND child_flex_value_low= range_low