Skip to main content

​
Overview

Deletes a payroll parameters record from tab_pmtros by company ID.

​
Signature

fun_delete_pmtros(
    wid_empresa INTEGER
) RETURNS VOID

​
Parameters

​
wid_empresa
INTEGER
required
Company ID to delete

​
Returns

VOID (no return value)

​
Example Usage

-- Delete payroll parameters
SELECT fun_delete_pmtros(2);

-- Delete company parameters
SELECT fun_delete_pmtros(1);

​
Validation Rules

  • Company ID must exist
  • Cannot delete parameters referenced by active payroll records

​
Source

source/func/pmtros/fun_delete_pmtros.sql

Build docs developers (and LLMs) love

Get started for freeTalk to us