aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_delete_consent_details
Parameters
Name
Type
Mode
p_id
integer
IN
Definition
DECLARE v_state TEXT; v_message TEXT; v_detail TEXT; v_hint TEXT; v_context TEXT; v_lang_code text; BEGIN SELECT lang_code INTO v_lang_code FROM public.consent_details WHERE id = p_id; IF NOT FOUND THEN RETURN fn_result_error('60307', sys_msg('60307', 'Translation not found')); END IF; IF v_lang_code = 'EN' THEN RETURN fn_result_error('60308', sys_msg('60308', 'The EN translation is the fallback language and cannot be deleted')); END IF; DELETE FROM public.consent_details WHERE id = p_id; RETURN fn_result_success(jsonb_build_object('id', p_id)); EXCEPTION WHEN OTHERS THEN GET STACKED DIAGNOSTICS v_state = RETURNED_SQLSTATE, v_message = MESSAGE_TEXT, v_detail = PG_EXCEPTION_DETAIL, v_hint = PG_EXCEPTION_HINT, v_context = PG_EXCEPTION_CONTEXT; RETURN fn_handle_error(v_state, v_message, v_detail, v_hint, v_context, 'sp_delete_consent_details', jsonb_build_object('id', p_id)); END