aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_check_folio_item
Parameters
Name
Type
Mode
item_id
integer
IN
folio_id
integer
IN
folio_seq
integer
IN
folio_item_id
integer
INOUT
Definition
DECLARE _folio_closed bool; _folio_seq int; _folio_id int; messages jsonb = $${ "30105" : "Folio item %s does not exist", "30106" : "Folio %s is already closed" }$$; BEGIN SELECT fi.folio_id, folio_seq, fi.closed FROM folio_items fi WHERE fi.item_id = $1 INTO _folio_id, _folio_seq, _folio_closed; CASE WHEN _folio_id IS NULL THEN -- Folio item does not exist PERFORM sp_raise_error('30105', messages->>'30105', $1::TEXT); WHEN _folio_closed THEN -- Folio item already closed PERFORM sp_raise_error('30106', messages->>'30106', format('%s/%s', _folio_id::text, _folio_seq::text)); ELSE END CASE; CALL sp_check_folio(_folio_id); END