505:
506: SELECT Decode(p_ruleset_rec.ruleset_id, NULL, cn_rulesets_s.NEXTVAL,
507: p_ruleset_rec.ruleset_id)
508: INTO l_ruleset_id 509: FROM dual; 510:
511: --since this is a new ruleset, validate the effectivity before inserting
512: IF check_ruleset_dates(p_ruleset_rec.start_date,
513: p_ruleset_rec.end_date,