aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_clear_intf_rate_state
Parameters
Name
Type
Mode
p_interface_code
text
IN
p_property_id
uuid
IN
Definition
DECLARE v_deleted int; BEGIN DELETE FROM public.intf_rate_state WHERE interface_code = p_interface_code AND property_id = p_property_id; GET DIAGNOSTICS v_deleted = ROW_COUNT; RAISE NOTICE 'Cleared rate state for %, property %, rows=%', p_interface_code, p_property_id, v_deleted; PERFORM public.sp_system_notify( 'SYNC RATE STATE DAILY CLEAR', format( 'CLAER : Property=%s IntfCode:=%s rows=%s', p_property_id, p_interface_code, v_deleted ), icon := '🧹' ); END;