APPS.HXC_HRR_UPLOAD_PKG dependencies on HXC_RESOURCE_RULES

Line 16: l_resource_rule_id hxc_resource_rules.resource_rule_id%TYPE;

12: , p_end_date VARCHAR
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:

Line 52: FROM hxc_resource_rules

48: , DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
49: INTO l_resource_rule_id
50: , l_ovn
51: , l_owner
52: FROM hxc_resource_rules
53: WHERE name = P_NAME;
54:
55: IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
56: THEN

Line 58: hxc_resource_rules_api.update_resource_rules (

54:
55: IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
56: THEN
57:
58: hxc_resource_rules_api.update_resource_rules (
59: p_effective_date => sysdate
60: , p_name => p_name
61: , p_business_group_id => null
62: , p_legislation_code => p_legislation_code

Line 76: hxc_resource_rules_api.create_resource_rules (

72: END IF;
73:
74: EXCEPTION WHEN NO_DATA_FOUND
75: THEN
76: hxc_resource_rules_api.create_resource_rules (
77: p_effective_date => sysdate
78: , p_name => p_name
79: , p_business_group_id => null
80: , p_legislation_code => p_legislation_code