eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_FDHM_PKG dependencies on FII_DIM_NORM_HIERARCHY

Line 14: FROM fii_dim_norm_hierarchy

10: IS
11: parent VARCHAR2(60);
12: CURSOR find_parent_cursor (child VARCHAR2, vsid NUMBER) IS
13: SELECT parent_flex_value
14: FROM fii_dim_norm_hierarchy
15: WHERE parent_flex_value_set_id = vsid
16: AND child BETWEEN child_flex_value_low
17: AND child_flex_value_high
18: AND parent_flex_value_set_id = child_flex_value_set_id;

Line 67: DELETE FROM FII_DIM_NORM_HIERARCHY

63:
64: /* If range is a single valued range, the row can be removed from the
65: norm hierarchy table. */
66: IF ( range_size = 1 ) THEN
67: DELETE FROM FII_DIM_NORM_HIERARCHY
68: WHERE parent_flex_value_set_id = parent_value_set_id
69: AND child_flex_value_set_id = child_value_set_id
70: AND parent_flex_value = parent
71: AND range_attribute = range_attr

Line 99: UPDATE FII_DIM_NORM_HIERARCHY

95: AND flex_value <= range_high
96: ORDER BY flex_value;
97:
98: IF ( new_bound IS NOT NULL ) THEN
99: UPDATE FII_DIM_NORM_HIERARCHY
100: SET child_flex_value_low = new_bound
101: WHERE parent_flex_value_set_id = parent_value_set_id
102: AND child_flex_value_set_id = child_value_set_id
103: AND parent_flex_value = parent

Line 133: UPDATE FII_DIM_NORM_HIERARCHY

129: AND flex_value < child
130: ORDER BY flex_value;
131:
132: IF ( new_bound IS NOT NULL ) THEN
133: UPDATE FII_DIM_NORM_HIERARCHY
134: SET child_flex_value_high = new_bound
135: WHERE parent_flex_value_set_id = parent_value_set_id
136: AND child_flex_value_set_id = child_value_set_id
137: AND parent_flex_value = parent

Line 158: DELETE FROM FII_DIM_NORM_HIERARCHY

154: /* If the value to be removed falls somewhere between the upper and
155: lower boundaries, the original range has to be removed and 2 new ranges
156: will be created to exclude the value to be removed. */
157:
158: DELETE FROM FII_DIM_NORM_HIERARCHY
159: WHERE parent_flex_value_set_id = parent_value_set_id
160: AND child_flex_value_set_id = child_value_set_id
161: AND parent_flex_value = parent
162: AND range_attribute = range_attr

Line 190: INSERT INTO FII_DIM_NORM_HIERARCHY

186:
187: IF ( new_bound IS NOT NULL ) THEN
188: /* If no 'lower' flex value can be found, no new lower range
189: will be created. */
190: INSERT INTO FII_DIM_NORM_HIERARCHY
191: ( parent_flex_value_set_id,
192: child_flex_value_set_id,
193: parent_flex_value,
194: range_attribute,

Line 257: INSERT INTO FII_DIM_NORM_HIERARCHY

253:
254: IF ( new_bound IS NOT NULL ) THEN
255: /* If no 'lower' flex value can be found, no new lower range
256: will be created. */
257: INSERT INTO FII_DIM_NORM_HIERARCHY
258: ( parent_flex_value_set_id,
259: child_flex_value_set_id,
260: parent_flex_value,
261: range_attribute,

Line 556: INSERT INTO FII_DIM_NORM_HIERARCHY

552:
553: PROCEDURE insert_dim_value_sets (dim_short_name VARCHAR2, source_lgr_group_id NUMBER)
554: IS
555: BEGIN
556: INSERT INTO FII_DIM_NORM_HIERARCHY
557: (parent_flex_value_set_id,
558: child_flex_value_set_id,
559: parent_flex_value,
560: range_attribute,

Line 884: DELETE FROM fii_dim_norm_hierarchy

880: PROCEDURE delete_dim_value_sets(dim_short_name VARCHAR2,
881: source_lgr_group_id NUMBER)
882: IS
883: BEGIN
884: DELETE FROM fii_dim_norm_hierarchy
885: WHERE parent_flex_value_set_id = child_flex_value_set_id
886: AND ( child_flex_value_set_id in
887: (SELECT r.flex_value_set_id1
888: FROM fii_dim_mapping_rules r