APPS.PQH_UTILITY dependencies on PQH_RULES

Line 75: l_rule_set_id pqh_rules.rule_set_id%type;

71: p_rule_level_cd OUT nocopy varchar2) is
72: --
73: l_proc varchar2(72) := g_package||'get_message_level_cd';
74: --
75: l_rule_set_id pqh_rules.rule_set_id%type;
76: l_rule_level_cd pqh_rule_sets.rule_level_cd%type;
77: l_business_group_id hr_all_organization_units.business_group_id%type;
78: l_record_found BOOLEAN := FALSE;
79: l_no_rule_sets number(10);

Line 83: From pqh_rules a

79: l_no_rule_sets number(10);
80: --
81: Cursor csr_rule_set is
82: Select rule_set_id
83: From pqh_rules a
84: Where a.application_id = p_application_id
85: AND a.message_name = p_message_name;
86: --
87: Begin

Line 256: From pqh_rules a

252: p_message_name IN varchar2,
253: p_rule_set_id OUT nocopy number) is
254: Cursor c1 is
255: Select rule_set_id
256: From pqh_rules a
257: Where a.application_id = p_application_id
258: AND a.message_name = p_message_name;
259: --
260: l_proc varchar2(72) := g_package||'get_rule_set_id';

Line 266: -- Fetch the rule_set_id , if the message name exists in pqh_rules.

262: Begin
263: --
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: -- Fetch the rule_set_id , if the message name exists in pqh_rules.
267: --
268: Open c1;
269: --
270: Fetch c1 into p_rule_set_id;