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

Line 28: -- hxc_pref_hierarchies and PER_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- hxc_pref_hierarchies and PER_BUSINESS_GROUPS
29: -- so that the security_group_id for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is

Line 35: , hxc_pref_hierarchies hph

31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is
33: select pbg.security_group_id
34: from per_business_groups pbg
35: , hxc_pref_hierarchies hph
36: -- , EDIT_HERE table_name(s) 333
37: where hph.pref_hierarchy_id = p_pref_hierarchy_id;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --

Line 100: -- hxc_pref_hierarchies and PER_BUSINESS_GROUPS

96: --
97: -- Declare cursor
98: --
99: -- EDIT_HERE In the following cursor statement add join(s) between
100: -- hxc_pref_hierarchies and PER_BUSINESS_GROUPS
101: -- so that the legislation_code for
102: -- the current business group context can be derived.
103: -- Remove this comment when the edit has been completed.
104: cursor csr_leg_code is

Line 107: , hxc_pref_hierarchies hph

103: -- Remove this comment when the edit has been completed.
104: cursor csr_leg_code is
105: select pbg.legislation_code
106: from per_business_groups pbg
107: , hxc_pref_hierarchies hph
108: -- , EDIT_HERE table_name(s) 333
109: where hph.pref_hierarchy_id = p_pref_hierarchy_id;
110: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
111: --

Line 453: p_name in hxc_pref_hierarchies.name%TYPE,

449: -- {End Of Comments}
450: -- ----------------------------------------------------------------------------
451: Procedure chk_name
452: (
453: p_name in hxc_pref_hierarchies.name%TYPE,
454: p_business_group_id in hxc_pref_hierarchies.business_group_id%TYPE,
455: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE
456: ,
457: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE

Line 454: p_business_group_id in hxc_pref_hierarchies.business_group_id%TYPE,

450: -- ----------------------------------------------------------------------------
451: Procedure chk_name
452: (
453: p_name in hxc_pref_hierarchies.name%TYPE,
454: p_business_group_id in hxc_pref_hierarchies.business_group_id%TYPE,
455: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE
456: ,
457: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE
458: ) IS

Line 455: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE

451: Procedure chk_name
452: (
453: p_name in hxc_pref_hierarchies.name%TYPE,
454: p_business_group_id in hxc_pref_hierarchies.business_group_id%TYPE,
455: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE
456: ,
457: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE
458: ) IS
459: --

Line 457: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE

453: p_name in hxc_pref_hierarchies.name%TYPE,
454: p_business_group_id in hxc_pref_hierarchies.business_group_id%TYPE,
455: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE
456: ,
457: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE
458: ) IS
459: --
460: l_proc varchar2(72);
461: --

Line 469: FROM hxc_pref_hierarchies hph

465: SELECT 'error'
466: FROM sys.dual
467: WHERE EXISTS (
468: SELECT 'x'
469: FROM hxc_pref_hierarchies hph
470: WHERE upper(hph.name) = upper(p_name)
471: AND hph.object_version_number <> NVL(p_object_version_number, -1)
472: AND (business_group_id = p_business_group_id or business_group_id is null)
473: AND level = 1

Line 609: from hxc_pref_hierarchies hph

605:
606: --Performance Fix
607: /*cursor csr_top (p_preference_id number) is
608: select parent_pref_hierarchy_id
609: from hxc_pref_hierarchies hph
610: where pref_hierarchy_id = p_preference_id;*/
611:
612: cursor csr_top (p_preference_id number) is
613: select top_level_parent_id --Performance Fix

Line 614: from hxc_pref_hierarchies hph

610: where pref_hierarchy_id = p_preference_id;*/
611:
612: cursor csr_top (p_preference_id number) is
613: select top_level_parent_id --Performance Fix
614: from hxc_pref_hierarchies hph
615: where pref_hierarchy_id = p_preference_id;
616:
617: l_parent_id number;
618: l_temp_parent_id number;

Line 662: from hxc_pref_hierarchies hph

658:
659: --Performance Fix
660: /*cursor csr_top (p_preference_id number) is
661: select parent_pref_hierarchy_id ,name
662: from hxc_pref_hierarchies hph
663: where pref_hierarchy_id = p_preference_id;*/
664:
665: cursor csr_top (p_preference_id number) is
666: select hph.name

Line 667: from hxc_pref_hierarchies hph

663: where pref_hierarchy_id = p_preference_id;*/
664:
665: cursor csr_top (p_preference_id number) is
666: select hph.name
667: from hxc_pref_hierarchies hph
668: ,hxc_pref_hierarchies hph1
669: where hph.pref_hierarchy_id = hph1.top_level_parent_id --Performance Fix
670: and hph1.pref_hierarchy_id = p_preference_id;
671:

Line 668: ,hxc_pref_hierarchies hph1

664:
665: cursor csr_top (p_preference_id number) is
666: select hph.name
667: from hxc_pref_hierarchies hph
668: ,hxc_pref_hierarchies hph1
669: where hph.pref_hierarchy_id = hph1.top_level_parent_id --Performance Fix
670: and hph1.pref_hierarchy_id = p_preference_id;
671:
672: l_parent_id number;

Line 733: p_pref_code in hxc_pref_hierarchies.attribute_category%TYPE,

729: -- {End Of Comments}
730: -- ----------------------------------------------------------------------------
731: Procedure chk_pref_code
732: (
733: p_pref_code in hxc_pref_hierarchies.attribute_category%TYPE,
734: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE,
735: p_pref_hierarchy_id in hxc_pref_hierarchies.pref_hierarchy_id%TYPE,
736: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE
737: ) IS

Line 734: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE,

730: -- ----------------------------------------------------------------------------
731: Procedure chk_pref_code
732: (
733: p_pref_code in hxc_pref_hierarchies.attribute_category%TYPE,
734: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE,
735: p_pref_hierarchy_id in hxc_pref_hierarchies.pref_hierarchy_id%TYPE,
736: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE
737: ) IS
738: --

Line 735: p_pref_hierarchy_id in hxc_pref_hierarchies.pref_hierarchy_id%TYPE,

731: Procedure chk_pref_code
732: (
733: p_pref_code in hxc_pref_hierarchies.attribute_category%TYPE,
734: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE,
735: p_pref_hierarchy_id in hxc_pref_hierarchies.pref_hierarchy_id%TYPE,
736: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE
737: ) IS
738: --
739: l_proc varchar2(72);

Line 736: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE

732: (
733: p_pref_code in hxc_pref_hierarchies.attribute_category%TYPE,
734: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE,
735: p_pref_hierarchy_id in hxc_pref_hierarchies.pref_hierarchy_id%TYPE,
736: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE
737: ) IS
738: --
739: l_proc varchar2(72);
740: --

Line 749: FROM hxc_pref_hierarchies hph

745: SELECT 'error'
746: FROM sys.dual
747: WHERE EXISTS (
748: SELECT 'x'
749: FROM hxc_pref_hierarchies hph
750: WHERE hph.attribute_category = p_pref_code
751: and hph.pref_hierarchy_id <> p_pref_hierarchy_id
752: START WITH hph.parent_pref_hierarchy_id = hxc_hph_bus.get_top_level_id(p_parent_pref_hierarchy_id)
753: CONNECT BY PRIOR hph.pref_hierarchy_id = hph.parent_pref_hierarchy_id);

Line 760: FROM hxc_pref_hierarchies hph

756: SELECT 'error'
757: FROM sys.dual
758: WHERE EXISTS (
759: SELECT 'x'
760: FROM hxc_pref_hierarchies hph
761: WHERE hph.attribute_category is not null
762: and hph.pref_hierarchy_id = p_parent_pref_hierarchy_id);
763:
764: --

Line 845: p_name in hxc_pref_hierarchies.name%TYPE,

841: -- {End Of Comments}
842: -- ----------------------------------------------------------------------------
843: Procedure chk_top_node
844: (
845: p_name in hxc_pref_hierarchies.name%TYPE,
846: p_business_group_id in hxc_pref_hierarchies.business_group_id%TYPE,
847: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE
848: ) IS
849: --

Line 846: p_business_group_id in hxc_pref_hierarchies.business_group_id%TYPE,

842: -- ----------------------------------------------------------------------------
843: Procedure chk_top_node
844: (
845: p_name in hxc_pref_hierarchies.name%TYPE,
846: p_business_group_id in hxc_pref_hierarchies.business_group_id%TYPE,
847: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE
848: ) IS
849: --
850: l_proc varchar2(72);

Line 847: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE

843: Procedure chk_top_node
844: (
845: p_name in hxc_pref_hierarchies.name%TYPE,
846: p_business_group_id in hxc_pref_hierarchies.business_group_id%TYPE,
847: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE
848: ) IS
849: --
850: l_proc varchar2(72);
851: --

Line 859: FROM hxc_pref_hierarchies hph

855: SELECT 'error'
856: FROM sys.dual
857: WHERE EXISTS (
858: SELECT 'x'
859: FROM hxc_pref_hierarchies hph
860: WHERE hph.name = p_name
861: AND (business_group_id = p_business_group_id or business_group_id is null)
862: AND hph.object_version_number <> NVL(p_object_version_number, -1)
863: AND hph.parent_pref_hierarchy_id is null);

Line 923: p_pref_definition_id in hxc_pref_hierarchies.pref_definition_id%TYPE,

919: -- {End Of Comments}
920: -- ----------------------------------------------------------------------------
921: Procedure chk_preference
922: (
923: p_pref_definition_id in hxc_pref_hierarchies.pref_definition_id%TYPE,
924: p_bg_id NUMBER,
925: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE
926: ,
927: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE

Line 925: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE

921: Procedure chk_preference
922: (
923: p_pref_definition_id in hxc_pref_hierarchies.pref_definition_id%TYPE,
924: p_bg_id NUMBER,
925: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE
926: ,
927: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE
928: ) IS
929: --

Line 927: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE

923: p_pref_definition_id in hxc_pref_hierarchies.pref_definition_id%TYPE,
924: p_bg_id NUMBER,
925: p_parent_pref_hierarchy_id in hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE
926: ,
927: p_object_version_number in hxc_pref_hierarchies.object_version_number%TYPE
928: ) IS
929: --
930: l_proc varchar2(72);
931: --

Line 940: FROM hxc_pref_hierarchies hph

936: SELECT 'error'
937: FROM sys.dual
938: WHERE EXISTS (
939: SELECT 'x'
940: FROM hxc_pref_hierarchies hph
941: WHERE hph.pref_definition_id = p_pref_definition_id
942: AND NVL(hph.business_group_id,-1) = NVL(p_bg_id,-1)
943: AND level = 2
944: AND hph.object_version_number <> NVL(p_object_version_number, -1)