13: , p_owner VARCHAR2
14: , p_custom_mode VARCHAR2 ) IS
15:
16: l_resource_rule_id hxc_resource_rules.resource_rule_id%TYPE;
17: l_pref_hierarchy_id hxc_pref_hierarchies.pref_hierarchy_id%TYPE;
18: l_ovn hxc_pref_hierarchies.object_version_number%TYPE := NULL;
19: l_owner VARCHAR2(6);
20:
21: FUNCTION get_pref_id ( p_name VARCHAR2 ) RETURN NUMBER IS
14: , p_custom_mode VARCHAR2 ) IS
15:
16: l_resource_rule_id hxc_resource_rules.resource_rule_id%TYPE;
17: l_pref_hierarchy_id hxc_pref_hierarchies.pref_hierarchy_id%TYPE;
18: l_ovn hxc_pref_hierarchies.object_version_number%TYPE := NULL;
19: l_owner VARCHAR2(6);
20:
21: FUNCTION get_pref_id ( p_name VARCHAR2 ) RETURN NUMBER IS
22:
19: l_owner VARCHAR2(6);
20:
21: FUNCTION get_pref_id ( p_name VARCHAR2 ) RETURN NUMBER IS
22:
23: l_pref_id hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE;
24:
25: CURSOR csr_get_pref_id IS
26: SELECT pref_hierarchy_id
27: FROM hxc_pref_hierarchies
23: l_pref_id hxc_pref_hierarchies.parent_pref_hierarchy_id%TYPE;
24:
25: CURSOR csr_get_pref_id IS
26: SELECT pref_hierarchy_id
27: FROM hxc_pref_hierarchies
28: WHERE name = p_name
29: AND parent_pref_hierarchy_id is null;
30:
31: BEGIN