Overview
Updates all fields of an existing payroll concept intab_conceptos.
Signature
Parameters
Concept ID to update
New concept name (minimum 5 characters)
New operation indicator
New payment period: ‘Q’ or ‘M’
New net payment indicator
New percentage value
New fixed value
New legal indicator
Returns
TRUE- Concept updated successfullyFALSE- Update failed
Example Usage
Validation Rules
- Concept ID must exist
- Concept name must be at least 5 characters
- Payment period must be ‘Q’ or ‘M’
- Percentage value must be between 0 and 100
Error Handling
| SQL State | Description |
|---|---|
| 23503 | Foreign key does not exist |
| 23505 | Unique constraint violation |
| 23514 | Value violates table constraints |
| 22001 | Value exceeds allowed length |
| 22P02 | Invalid data type |
| others | Unknown error |
Source
source/func/conceptos/fun_update_conceptos.sql