APPS.GL_JAHE_PKG dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 15: FROM fnd_flex_value_norm_hierarchy

11: IS
12: parent VARCHAR2(60);
13: CURSOR find_parent_cursor (child VARCHAR2, vsid NUMBER) IS
14: SELECT parent_flex_value
15: FROM fnd_flex_value_norm_hierarchy
16: WHERE flex_value_set_id = vsid
17: AND range_attribute = 'P'
18: AND child BETWEEN child_flex_value_low
19: AND child_flex_value_high;

Line 80: DELETE FND_FLEX_VALUE_NORM_HIERARCHY

76:
77: /* If range is a single valued range, the row can be removed from the
78: norm hierarchy table. */
79: IF ( range_size = 1 ) THEN
80: DELETE FND_FLEX_VALUE_NORM_HIERARCHY
81: WHERE flex_value_set_id = value_set_id
82: AND parent_flex_value = parent
83: AND range_attribute = range_attr
84: AND child_flex_value_low = range_low

Line 101: UPDATE FND_FLEX_VALUE_NORM_HIERARCHY

97: AND flex_value <= range_high
98: ORDER BY flex_value;
99:
100: IF ( new_bound IS NOT NULL ) THEN
101: UPDATE FND_FLEX_VALUE_NORM_HIERARCHY
102: SET child_flex_value_low = new_bound
103: WHERE flex_value_set_id = value_set_id
104: AND parent_flex_value = parent
105: AND range_attribute = range_attr

Line 123: UPDATE FND_FLEX_VALUE_NORM_HIERARCHY

119: AND flex_value < child
120: ORDER BY flex_value;
121:
122: IF ( new_bound IS NOT NULL ) THEN
123: UPDATE FND_FLEX_VALUE_NORM_HIERARCHY
124: SET child_flex_value_high = new_bound
125: WHERE flex_value_set_id = value_set_id
126: AND parent_flex_value = parent
127: AND range_attribute = range_attr

Line 136: DELETE FND_FLEX_VALUE_NORM_HIERARCHY

132: /* If the value to be removed falls somewhere between the upper and
133: lower boundaries, the original range has to be removed and 2 new ranges
134: will be created to exclude the value to be removed. */
135:
136: DELETE FND_FLEX_VALUE_NORM_HIERARCHY
137: WHERE flex_value_set_id = value_set_id
138: AND parent_flex_value = parent
139: AND range_attribute = range_attr
140: AND child_flex_value_low = range_low

Line 158: INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY

154:
155: IF ( new_bound IS NOT NULL ) THEN
156: /* If no 'lower' flex value can be found, no new lower range
157: will be created. */
158: INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY
159: ( flex_value_set_id,
160: parent_flex_value,
161: range_attribute,
162: child_flex_value_low,

Line 197: INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY

193:
194: IF ( new_bound IS NOT NULL ) THEN
195: /* If no 'lower' flex value can be found, no new lower range
196: will be created. */
197: INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY
198: ( flex_value_set_id,
199: parent_flex_value,
200: range_attribute,
201: child_flex_value_low,