authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_clear_my_lock_record_by_id
Parameters
Name
Type
Mode
i_prop_id
integer
IN
i_user_name
text
IN
Definition
declare v_sql text; v_result boolean; v_prop_code text; begin -- === Create by T.Supol 2025-07-24 v_prop_code := (select p.code from property p where id is not distinct from i_prop_id); if v_prop_code is null then return false; end if; if upper(v_prop_code) = 'NEWSOFT' then return true; end if; v_sql := format( $sql$ select result from dblink(%L, %L) as t(result boolean) $sql$, fn_prop_connection(i_prop_id), format('SELECT * FROM sp_unlock_all_register_record_lock_by_user_name(%L)', i_user_name) ); execute v_sql into v_result; return v_result; end;