declare l_business_ref flow_process_variables.prov_var_vc2%type; l_prcs_id flow_processes.prcs_id%type; begin -- retrieve process id l_prcs_id:= flow_plsql_runner_pkg.get_current_prcs_id; -- retrieve business ref l_business_ref:= flow_process_vars.get_business_ref(l_prcs_id); -- set expense status update tuto_expenses expe set expe.expe_status = 'paid' where expe.expe_id = to_number(l_business_ref); end;