APPS.PQH_CBR_ENGINE dependencies on PQH_RULE_ATTRIBUTES

Line 1302: from pqh_rule_attributes

1298: p_cond_matx out NOCOPY t_cond_matx) is
1299: l_proc varchar2(71) := g_package||'valid_rule_conditions';
1300: cursor csr_condition_rec is
1301: select rule_attribute_id,attribute_value,operation_code,attribute_code
1302: from pqh_rule_attributes
1303: where rule_set_id = p_rule_set_id;
1304: read_counter number := 1;
1305: write_counter number := 1;
1306: l_valid_applicability boolean;

Line 1310: -- pqh_rule_attributes stores the attribute code (which links to attribute_id of pqh_attributes)

1306: l_valid_applicability boolean;
1307: l_valid_entity boolean;
1308: begin
1309: hr_utility.set_location('inside'||l_proc,10);
1310: -- pqh_rule_attributes stores the attribute code (which links to attribute_id of pqh_attributes)
1311: -- this attribute id is linked to txn_category budget reallocation
1312: -- In this procedure we are getting conditions defined for a rule and populating
1313: -- the seeded attributes by comparing attribute_id
1314: for l_condition_rec in csr_condition_rec loop

Line 1455: select count(*) into l_rule_conditions from pqh_rule_attributes where rule_set_id = l_rule_rec.rule_set_id;

1451: for l_rule_rec in csr_rule_rec(p_rule_applicability => l_rule_applicability) loop
1452: hr_utility.set_location('finding rule '||l_rule_applicability,30);
1453: l_rule_valid := FALSE ; -- initializing the result variable
1454: select count(*) into l_rule_messages from pqh_rules where rule_set_id = l_rule_rec.rule_set_id;
1455: select count(*) into l_rule_conditions from pqh_rule_attributes where rule_set_id = l_rule_rec.rule_set_id;
1456: if l_rule_messages <> 1 or l_rule_conditions = 0 then
1457: hr_utility.set_location('Either message or condition is undefined',50);
1458: l_rule_valid := FALSE ;
1459: else