10:
11: PROCEDURE check_unique_bc_option_name(X_bc_option_name VARCHAR2 ) IS
12: dummy NUMBER;
13: BEGIN 14: select 1 into dummy from dual 15: where not exists
16: (select 1 from gl_bc_options
17: where bc_option_name = X_bc_option_name);
18: EXCEPTION
Line 30: FROM dual;
26: next_id NUMBER;
27: BEGIN
28: SELECT gl_bc_options_s.nextval
29: INTO next_id 30: FROM dual; 31:
32: RETURN (next_id);
33: END get_unique_id;
34: