Line 598: SELECT wms_rules_s.NEXTVAL INTO l_rule_id FROM dual;
594: );
595: EXCEPTION
596: WHEN no_data_found THEN
597: IF ( l_rule_id IS NULL ) THEN 598: SELECT wms_rules_s.NEXTVAL INTO l_rule_id FROM dual; 599: END IF;
600: wms_rules_pkg.insert_row
601: (
602: X_ROWID => l_row_id