APPS.PQH_RULE_SETS_API dependencies on PQH_RULE_ATTRIBUTES

Line 391: --Declare cursor for pqh_rule_attributes.

387: --
388: l_proc varchar2(72) := g_package||'delete_RULE_SET';
389: l_object_version_number pqh_rule_sets.object_version_number%TYPE;
390: --
391: --Declare cursor for pqh_rule_attributes.
392: --
393: cursor c1 is
394: select rule_attribute_id, object_version_number
395: from pqh_rule_attributes where rule_set_id = p_rule_set_id;

Line 395: from pqh_rule_attributes where rule_set_id = p_rule_set_id;

391: --Declare cursor for pqh_rule_attributes.
392: --
393: cursor c1 is
394: select rule_attribute_id, object_version_number
395: from pqh_rule_attributes where rule_set_id = p_rule_set_id;
396:
397: begin
398: --
399: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 439: --Delete from pqh_rule_attributes

435: p_rule_set_id => p_rule_set_id
436: ,p_object_version_number => l_object_version_number
437: );
438: --
439: --Delete from pqh_rule_attributes
440: --
441: for rule_att in c1 loop
442: pqh_rla_del.del(p_rule_attribute_id => rule_att.rule_attribute_id
443: ,p_object_version_number => rule_att.object_version_number);