Skip to main content

close_and_lock_payroll_batch

PostgREST stored procedure — POST /rest/v1/rpc/close_and_lock_payroll_batch.

Call it through the Supabase client (RLS and the service role are enforced by the function):

const { data, error } = await supabase.rpc('close_and_lock_payroll_batch', { p_actor, p_assignment_ids, p_batch_id, p_company_id, p_expected_entry_count, p_expected_hours });

Arguments

ArgumentTypeRequired
p_actoruuidyes
p_assignment_idsuuid[]yes
p_batch_iduuidyes
p_company_iduuidyes
p_expected_entry_countintegeryes
p_expected_hoursnumericyes

Generated from specs/supabase.json. The function's behaviour is defined by its SQL migration; this page documents its call signature only.