Skip to main content

​
Overview

Deletes a payroll novelty record from tab_novedades by year, month, and period.

​
Signature

fun_delete_novedades(
    wano_nom INTEGER,
    wmes_nom INTEGER,
    wper_nom INTEGER
) RETURNS VOID

​
Parameters

​
wano_nom
INTEGER
required
Payroll year (Primary Key)
​
wmes_nom
INTEGER
required
Payroll month (Primary Key)
​
wper_nom
INTEGER
required
Payroll period (Primary Key)

​
Returns

VOID (no return value)

​
Example Usage

-- Delete a novelty
SELECT fun_delete_novedades(2024, 3, 1);

-- Delete another novelty
SELECT fun_delete_novedades(2025, 1, 2);

​
Validation Rules

  • The novelty identified by year, month, and period must exist
  • All three components of the composite key are required

​
Source

source/func/novedades/fun_delete_novedades.sql

Build docs developers (and LLMs) love

Get started for freeTalk to us