Line 580: SELECT wms_rules_s.NEXTVAL INTO l_rule_id FROM dual;
576: );
577: EXCEPTION
578: WHEN no_data_found THEN
579: IF ( l_rule_id IS NULL ) THEN 580: SELECT wms_rules_s.NEXTVAL INTO l_rule_id FROM dual; 581: END IF;
582: wms_rules_pkg.insert_row
583: (
584: X_ROWID => l_row_id