344:
345: --Fetch rule_id into l_rule_id
346: SELECT Decode(p_rule_rec.rule_id, NULL,cn_rules_s.NEXTVAL, p_rule_rec.rule_id)
347: INTO l_rule_id 348: FROM dual; 349:
350: --Since this is a new rule, validate the rule name before inserting
351: IF validate_rule_name(p_rule_rec.ruleset_id,
352: p_rule_rec.parent_rule_id,