APPS.HXC_PREFERENCE_EVALUATION dependencies on HXC_PREF_HIERARCHIES

Line 25: edit_allowed hxc_pref_hierarchies.edit_allowed%TYPE);

21: end_date DATE,
22: code hxc_pref_definitions.code%TYPE,
23: rule_evaluation_order NUMBER,
24: pref_ref NUMBER,
25: edit_allowed hxc_pref_hierarchies.edit_allowed%TYPE);
26:
27: TYPE t_hierarchy_list_row IS RECORD
28: (
29: pref_hierarchy_id NUMBER,

Line 126: From hxc_pref_hierarchies

122: --Added By Mithun
123: l_resp_id NUMBER;
124: CURSOR c_get_last_updated_date(p_pref_hierarchy_id IN number) IS
125: Select last_update_date
126: From hxc_pref_hierarchies
127: Where pref_hierarchy_id = p_pref_hierarchy_id;
128:
129: -- CURSORs to find the hierarchies a resource is eligible for ...
130: -- To support new criteria add new CURSORs or add to existing CURSOR.

Line 359: FROM hxc_pref_hierarchies

355: ,displayed
356: ,name
357: ,top_level_parent_id --Performance Fix
358: ,code
359: FROM hxc_pref_hierarchies
360: WHERE top_level_parent_id = p_hierarchy_id;
361: -- pref_definition_id is not null
362: -- START WITH pref_hierarchy_id = p_hierarchy_id
363: -- CONNECT BY prior pref_hierarchy_id = parent_pref_hierarchy_id;

Line 1447: From hxc_pref_hierarchies

1443: l_use_cache boolean := FALSE;
1444:
1445: CURSOR c_get_last_updated_date(p_pref_hierarchy_id IN number) IS
1446: Select last_update_date
1447: From hxc_pref_hierarchies
1448: Where pref_hierarchy_id = p_pref_hierarchy_id;
1449:
1450: --Performance Fix
1451: TYPE t_pref_encountered IS TABLE OF

Line 1724: -- This can be removed if necessary by denormalization onto the hxc_pref_hierarchies base table

1720: --------------------------------------------------------------------------
1721:
1722: -- Cursor to RETURN the preference nodes in a hierarchy. Note that this is based on a
1723: -- hierchical query.
1724: -- This can be removed if necessary by denormalization onto the hxc_pref_hierarchies base table
1725: -- About 30% of preference evaluatuation time is spent in this query. Denormalization seems
1726: -- to be appropriate at some point.
1727:
1728: CURSOR c_pref_nodes(p_hierarchy_id IN NUMBER)

Line 1767: FROM hxc_pref_hierarchies

1763: ,displayed
1764: ,name
1765: ,top_level_parent_id --Performance Fix
1766: ,code
1767: FROM hxc_pref_hierarchies
1768: WHERE top_level_parent_id = p_hierarchy_id;
1769: --pref_definition_id is not null
1770: --START WITH pref_hierarchy_id = p_hierarchy_id
1771: --CONNECT BY prior pref_hierarchy_id = parent_pref_hierarchy_id;

Line 2646: FROM hxc_pref_hierarchies hph,

2642: p_attributen NUMBER,
2643: p_value VARCHAR2)
2644: IS
2645: SELECT count(*)
2646: FROM hxc_pref_hierarchies hph,
2647: hxc_pref_definitions hpd
2648: WHERE hph.pref_definition_id = hpd.pref_definition_id
2649: AND hpd.code = p_preference_code
2650: AND decode (p_attributen, 1, hph.attribute1, 2, hph.attribute2, 3, hph.attribute3,