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_LOAD_PKG dependencies on HXC_PREF_HIERARCHIES

Line 333: l_level_one hxc_pref_hierarchies.name%TYPE := NULL;

329: , p_pref_node VARCHAR2
330: , p_pref_level NUMBER
331: , p_count NUMBER ) RETURN VARCHAR2 IS
332:
333: l_level_one hxc_pref_hierarchies.name%TYPE := NULL;
334: l_level_two hxc_pref_hierarchies.name%TYPE := NULL;
335: l_level_three hxc_pref_hierarchies.name%TYPE := NULL;
336: l_level_four hxc_pref_hierarchies.name%TYPE := NULL;
337: l_level_five hxc_pref_hierarchies.name%TYPE := NULL;

Line 334: l_level_two hxc_pref_hierarchies.name%TYPE := NULL;

330: , p_pref_level NUMBER
331: , p_count NUMBER ) RETURN VARCHAR2 IS
332:
333: l_level_one hxc_pref_hierarchies.name%TYPE := NULL;
334: l_level_two hxc_pref_hierarchies.name%TYPE := NULL;
335: l_level_three hxc_pref_hierarchies.name%TYPE := NULL;
336: l_level_four hxc_pref_hierarchies.name%TYPE := NULL;
337: l_level_five hxc_pref_hierarchies.name%TYPE := NULL;
338:

Line 335: l_level_three hxc_pref_hierarchies.name%TYPE := NULL;

331: , p_count NUMBER ) RETURN VARCHAR2 IS
332:
333: l_level_one hxc_pref_hierarchies.name%TYPE := NULL;
334: l_level_two hxc_pref_hierarchies.name%TYPE := NULL;
335: l_level_three hxc_pref_hierarchies.name%TYPE := NULL;
336: l_level_four hxc_pref_hierarchies.name%TYPE := NULL;
337: l_level_five hxc_pref_hierarchies.name%TYPE := NULL;
338:
339: l_full_name VARCHAR2(500);

Line 336: l_level_four hxc_pref_hierarchies.name%TYPE := NULL;

332:
333: l_level_one hxc_pref_hierarchies.name%TYPE := NULL;
334: l_level_two hxc_pref_hierarchies.name%TYPE := NULL;
335: l_level_three hxc_pref_hierarchies.name%TYPE := NULL;
336: l_level_four hxc_pref_hierarchies.name%TYPE := NULL;
337: l_level_five hxc_pref_hierarchies.name%TYPE := NULL;
338:
339: l_full_name VARCHAR2(500);
340:

Line 337: l_level_five hxc_pref_hierarchies.name%TYPE := NULL;

333: l_level_one hxc_pref_hierarchies.name%TYPE := NULL;
334: l_level_two hxc_pref_hierarchies.name%TYPE := NULL;
335: l_level_three hxc_pref_hierarchies.name%TYPE := NULL;
336: l_level_four hxc_pref_hierarchies.name%TYPE := NULL;
337: l_level_five hxc_pref_hierarchies.name%TYPE := NULL;
338:
339: l_full_name VARCHAR2(500);
340:
341: l_last_level NUMBER(1) := 1;

Line 347: from hxc_pref_hierarchies

343: CURSOR get_pref_hierarchy ( p_top_node VARCHAR2 ) IS
344: SELECT name
345: , level
346: , rownum cnt
347: from hxc_pref_hierarchies
348: start with name = p_top_node
349: connect by prior pref_hierarchy_id = parent_pref_hierarchy_id;
350:
351: BEGIN

Line 587: FROM hxc_pref_hierarchies

583: l_mode varchar2(50) := null;
584:
585: cursor c_top_node(l_name varchar2) is
586: SELECT pref_hierarchy_id,object_version_number
587: FROM hxc_pref_hierarchies
588: WHERE parent_pref_hierarchy_id is null
589: AND name = l_name;
590:
591: cursor c_child_nodes(l_parent_pref_hierarchy_id number,l_name varchar2) is

Line 593: FROM hxc_pref_hierarchies

589: AND name = l_name;
590:
591: cursor c_child_nodes(l_parent_pref_hierarchy_id number,l_name varchar2) is
592: SELECT pref_hierarchy_id,object_version_number
593: FROM hxc_pref_hierarchies
594: WHERE parent_pref_hierarchy_id = l_parent_pref_hierarchy_id
595: AND name = l_name;
596:
597: --