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.HXC_SEEDDATA_PKG dependencies on HXC_PREF_HIERARCHIES

Line 114: := 'SELECT name Value,pref_hierarchy_id ID FROM hxc_pref_hierarchies

110: ';
111:
112:
113: l_pref_hierarchies VARCHAR2(1000)
114: := 'SELECT name Value,pref_hierarchy_id ID FROM hxc_pref_hierarchies
115: ';
116:
117:
118: l_time_entry_rules VARCHAR2(1000)

Line 166: ELSIF (p_object_type = 'HXC_PREF_HIERARCHIES') THEN

162: ELSIF (p_object_type = 'HXC_TIME_CATEGORIES') THEN
163: l_query := l_time_category;
164: ELSIF (p_object_type = 'HXC_LOCKER_TYPES') THEN
165: l_query := l_locker_types;
166: ELSIF (p_object_type = 'HXC_PREF_HIERARCHIES') THEN
167: l_query := l_pref_hierarchies;
168: ELSIF (p_object_type = 'HXC_TIME_ENTRY_RULES') THEN
169: l_query := l_time_entry_rules;
170: END IF;

Line 218: select legislation_code from hxc_pref_hierarchies

214: select legislation_code from hxc_alias_definitions
215: where alias_definition_id = p_object_id;
216:
217: cursor c_pref_hierarchies is
218: select legislation_code from hxc_pref_hierarchies
219: where pref_hierarchy_id = p_object_id;
220:
221: cursor c_approval_styles is
222: select legislation_code from hxc_approval_styles

Line 241: ELSIF (p_object_type = 'HXC_PREF_HIERARCHIES') THEN

237: ELSIF (p_object_type = 'HXC_TIME_ENTRY_RULES') THEN
238: open c_pref_hierarchies;
239: fetch c_pref_hierarchies into l_legislation_code;
240: close c_pref_hierarchies;
241: ELSIF (p_object_type = 'HXC_PREF_HIERARCHIES') THEN
242: open c_approval_styles;
243: fetch c_approval_styles into l_legislation_code;
244: close c_approval_styles;
245: ELSIF (p_object_type = 'HXC_ALIAS_DEFINITIONS') THEN