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.FND_FLEX_HIERARCHY_COMPILER dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 10: -- FND_FLEX_VALUE_NORM_HIERARCHY

6: -- Compiler Example
7: -- ======================================================================
8: -- North America Country, State, City Hierarchy.
9: --
10: -- FND_FLEX_VALUE_NORM_HIERARCHY
11: -- ===========================================
12: -- PARENT CHILD_LOW CHILD_HIGH RANGE
13: -- ---------- ---------- ----------- ----------
14: -- CA LA LA C

Line 65: (parent_flex_value fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE,

61: -- ======================================================================
62: -- Package Globals.
63: -- ======================================================================
64: TYPE hierarchy_record IS RECORD
65: (parent_flex_value fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE,
66: child_flex_value_low fnd_flex_value_norm_hierarchy.child_flex_value_low%TYPE,
67: child_flex_value_high fnd_flex_value_norm_hierarchy.child_flex_value_high%TYPE,
68: range_attribute fnd_flex_value_norm_hierarchy.range_attribute%TYPE);
69:

Line 66: child_flex_value_low fnd_flex_value_norm_hierarchy.child_flex_value_low%TYPE,

62: -- Package Globals.
63: -- ======================================================================
64: TYPE hierarchy_record IS RECORD
65: (parent_flex_value fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE,
66: child_flex_value_low fnd_flex_value_norm_hierarchy.child_flex_value_low%TYPE,
67: child_flex_value_high fnd_flex_value_norm_hierarchy.child_flex_value_high%TYPE,
68: range_attribute fnd_flex_value_norm_hierarchy.range_attribute%TYPE);
69:
70: TYPE hierarchy_array IS TABLE OF hierarchy_record INDEX BY BINARY_INTEGER;

Line 67: child_flex_value_high fnd_flex_value_norm_hierarchy.child_flex_value_high%TYPE,

63: -- ======================================================================
64: TYPE hierarchy_record IS RECORD
65: (parent_flex_value fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE,
66: child_flex_value_low fnd_flex_value_norm_hierarchy.child_flex_value_low%TYPE,
67: child_flex_value_high fnd_flex_value_norm_hierarchy.child_flex_value_high%TYPE,
68: range_attribute fnd_flex_value_norm_hierarchy.range_attribute%TYPE);
69:
70: TYPE hierarchy_array IS TABLE OF hierarchy_record INDEX BY BINARY_INTEGER;
71:

Line 68: range_attribute fnd_flex_value_norm_hierarchy.range_attribute%TYPE);

64: TYPE hierarchy_record IS RECORD
65: (parent_flex_value fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE,
66: child_flex_value_low fnd_flex_value_norm_hierarchy.child_flex_value_low%TYPE,
67: child_flex_value_high fnd_flex_value_norm_hierarchy.child_flex_value_high%TYPE,
68: range_attribute fnd_flex_value_norm_hierarchy.range_attribute%TYPE);
69:
70: TYPE hierarchy_array IS TABLE OF hierarchy_record INDEX BY BINARY_INTEGER;
71:
72: TYPE varchar2_array IS TABLE OF fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE INDEX BY BINARY_INTEGER;

Line 72: TYPE varchar2_array IS TABLE OF fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE INDEX BY BINARY_INTEGER;

68: range_attribute fnd_flex_value_norm_hierarchy.range_attribute%TYPE);
69:
70: TYPE hierarchy_array IS TABLE OF hierarchy_record INDEX BY BINARY_INTEGER;
71:
72: TYPE varchar2_array IS TABLE OF fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE INDEX BY BINARY_INTEGER;
73:
74: --
75: -- Cycle Checker
76: --

Line 154: PROCEDURE add_to_parent_path(p_parent_flex_value IN fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE)

150: -- PROCEDURE : add_to_parent_path
151: -- ======================================================================
152: -- Adds a parent value to the end of the parent path array.
153: --
154: PROCEDURE add_to_parent_path(p_parent_flex_value IN fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE)
155: IS
156: BEGIN
157: g_parent_path_values(g_parent_path_value_count) := p_parent_flex_value;
158: g_parent_path_value_count := g_parent_path_value_count + 1;

Line 177: FUNCTION exists_in_parent_path(p_parent_flex_value IN fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE)

173: -- FUNCTION : exists_in_parent_path
174: -- ======================================================================
175: -- Checks if a parent value exists in the parent path array.
176: --
177: FUNCTION exists_in_parent_path(p_parent_flex_value IN fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE)
178: RETURN BOOLEAN
179: IS
180: l_exists BOOLEAN;
181: BEGIN

Line 485: FROM fnd_flex_value_norm_hierarchy

481: parent_flex_value,
482: child_flex_value_low,
483: child_flex_value_high,
484: range_attribute
485: FROM fnd_flex_value_norm_hierarchy
486: WHERE flex_value_set_id = g_vset.flex_value_set_id
487: AND parent_flex_value >= p_child_flex_value_low
488: AND parent_flex_value <= p_child_flex_value_high
489: ORDER BY range_attribute, parent_flex_value,

Line 575: FROM fnd_flex_value_norm_hierarchy

571: parent_flex_value,
572: child_flex_value_low,
573: child_flex_value_high,
574: range_attribute
575: FROM fnd_flex_value_norm_hierarchy
576: WHERE flex_value_set_id = g_vset.flex_value_set_id
577: ORDER BY range_attribute, parent_flex_value,
578: child_flex_value_low, child_flex_value_high;
579:

Line 715: FROM fnd_flex_value_norm_hierarchy

711: parent_flex_value,
712: child_flex_value_low,
713: child_flex_value_high,
714: range_attribute
715: FROM fnd_flex_value_norm_hierarchy
716: WHERE flex_value_set_id = g_vset.flex_value_set_id
717: AND parent_flex_value >= p_child_flex_value_low
718: AND parent_flex_value <= p_child_flex_value_high
719: ORDER BY range_attribute, parent_flex_value,

Line 803: FROM fnd_flex_value_norm_hierarchy

799: parent_flex_value,
800: child_flex_value_low,
801: child_flex_value_high,
802: range_attribute
803: FROM fnd_flex_value_norm_hierarchy
804: WHERE flex_value_set_id = g_vset.flex_value_set_id
805: ORDER BY range_attribute, parent_flex_value,
806: child_flex_value_low, child_flex_value_high;
807:

Line 1504: ' FROM fnd_flex_value_norm_hierarchy h ' ||

1500: ' v.flex_value_set_id ' ||
1501: ' FROM fnd_flex_value_sets v ' ||
1502: ' WHERE EXISTS ' ||
1503: ' (SELECT null ' ||
1504: ' FROM fnd_flex_value_norm_hierarchy h ' ||
1505: ' WHERE h.flex_value_set_id = v.flex_value_set_id)');
1506:
1507:
1508: OPEN l_value_set_id_cur FOR l_value_set_id_sql;