aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_selfcheckin_release_expired
Parameters
Name
Type
Mode
i_timeout
interval
IN (DEFAULT NULL)
Definition
DECLARE v_timeout interval := COALESCE(i_timeout, fn_sys_param('SELFCHECKIN','HOLD_TIMEOUT','15 minutes')::interval); v_count int := 0; v_room int; BEGIN FOR v_room IN SELECT o.room_id FROM out_of_order o JOIN ooo_reason r ON r.id = o.reason_id WHERE r.ref_code = 'SELFCHK' AND o.create_time < now() - v_timeout LOOP PERFORM sp_selfcheckin_release_room(v_room, NULL, i_match_user := false); v_count := v_count + 1; END LOOP; RETURN v_count; END