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
19: WHEN NO_DATA_FOUND THEN
20: fnd_message.set_name('SQLGL','GL_DUPLICATE_BC_GROUP');
24:
25: FUNCTION get_unique_id RETURN NUMBER IS
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);