Line 346: SELECT Decode(p_rule_rec.rule_id, NULL,cn_rules_s.NEXTVAL, p_rule_rec.rule_id)
342: WHERE rule_id = p_rule_rec.parent_rule_id and
343: org_id=p_rule_rec.org_id;
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