Oracle APEX PL/SQL API Supplement - Get Build Option component ID by name

get_build_option_id.sql

create or replace function get_build_option_id( 
	p_build_option_name      IN varchar2,
    p_PRIMARY_APPLICATION_ID IN number := 10000
) return number
IS
  l_build_option_id number;
BEGIN
	select build_option_id  into l_build_option_id
	from APEX_APPLICATION_BUILD_OPTIONS
	where application_id = p_PRIMARY_APPLICATION_ID
	and build_option_name = p_build_option_name
	;
	dbms_output.put_line('Found option '||p_build_option_name||' with ID: '||to_char(l_build_option_id));	
	return l_build_option_id;
END;
/

declare
	x_build_opt_id number;
begin
	x_build_opt_id := get_build_option_id('CLONE_DM');
	dbms_output.put_line('    Ok, got it! this id is:   '||x_build_opt_id);
end;
/