DBA Data[Home] [Help]

APPS.HXC_RESOURCE_PERSONAL_PREF_PKG dependencies on HXC_RESOURCE_RULES

Line 57: from hxc_resource_rules hrr

53: l_top_ovn number;
54:
55: cursor c_resource_rule(l_pref_hierarchy_id in number) is
56: select '1'
57: from hxc_resource_rules hrr
58: where hrr.eligibility_criteria_id = to_char(p_login_id)
59: and hrr.eligibility_criteria_type = 'LOGIN'
60: and hrr.resource_type = 'PERSON'
61: and hrr.pref_hierarchy_id = l_pref_hierarchy_id;

Line 295: hxc_resource_rules_api.create_resource_rules

291: if c_resource_rule%notfound then
292:
293: l_object_version_number := null;
294: -- Create the rule with the name equals to resource id
295: hxc_resource_rules_api.create_resource_rules
296: (p_name => to_char(p_login_id),
297: p_business_group_id => p_business_group_id,
298: p_legislation_code => p_legislation_code,
299: p_eligibility_criteria_type => 'LOGIN',