Skip to main content

​
Overview

Deletes a payroll concept record from tab_conceptos by ID.

​
Signature

fun_delete_conceptos(
    wid_concepto INTEGER
) RETURNS BOOLEAN

​
Parameters

​
wid_concepto
INTEGER
required
Concept ID to delete

​
Returns

  • TRUE - Concept deleted successfully
  • FALSE - Delete failed

​
Example Usage

-- Delete a concept
SELECT fun_delete_conceptos(4);

-- Delete concept with ID 2
SELECT fun_delete_conceptos(2);

​
Validation Rules

  • Concept ID must exist
  • Cannot delete concepts referenced by payroll novelties

​
Error Handling

SQL StateDescription
02000Concept ID does not exist
23502Attempted to use NULL value
22003Number is too large
22P02Invalid data format
othersUnknown error

​
Source

source/func/conceptos/fun_delete_conceptos.sql

Build docs developers (and LLMs) love

Get started for freeTalk to us