close_payroll_period

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

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

const { data, error } = await supabase.rpc('close_payroll_period', { p_assignment_ids, p_company_id, p_expected_entry_count, p_expected_hours, p_payments, p_period_end, p_period_start, p_prepared_by, p_total_centavos });

Arguments

Argument	Type	Required
p_assignment_ids	uuid[]	yes
p_company_id	uuid	yes
p_expected_entry_count	integer	yes
p_expected_hours	numeric	yes
p_payments	jsonb	yes
p_period_end	date	yes
p_period_start	date	yes
p_prepared_by	uuid	yes
p_total_centavos	bigint	yes

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