Line 1766: select qp_patterns_s.nextval into l_pattern_id from dual;
1762: and pattern_type = p_pattern_type
1763: and rownum = 1;
1764: exception
1765: when no_data_found then 1766: select qp_patterns_s.nextval into l_pattern_id from dual; 1767: l_pattern_to_be_created := 'Y';
1768:
1769: when others then
1770: raise;