aonestar.public

Parameters

Name	Type	Mode
user_name	text	IN
trn_id	integer	IN
i_reference	text	IN
i_remark	text	IN
i_description	text	IN (DEFAULT NULL)
i_dept_id	integer	IN (DEFAULT NULL)

Definition

DECLARE
    _result json;
    _sqlstate TEXT;
    _detail   TEXT;
    _hint     TEXT;
    _context  TEXT;
    _msg_text  TEXT;
    msg_group TEXT = '304';
    messages  jsonb = $${
        "30103" : "Guest account checked out", 
        "30106" : "Folio closed",     
        "30107" : "Folio locked", 
        "30108" : "Department not assign to any folio",  
        "90001" : "End-day process in progress"
    }$$;
BEGIN 
    CALL sp_check_transaction(trn_id, 'update', TRUE); 

    user_name = coalesce(user_name, fn_current_user());

    UPDATE transactions 
    SET --dept_id     = COALESCE(i_dept_id, dept_id),
        description = COALESCE(i_description, description),
        reference   = COALESCE(i_reference, reference),
        remark      = COALESCE(i_remark, remark)
    WHERE id = $2;

    PERFORM sp_log_trans(trn_id, 'Update', 'Update transaction', user_name);

    RETURN fn_result_success(fn_get_transaction_js(trn_id, true));

EXCEPTION 
    WHEN OTHERS THEN
    GET STACKED DIAGNOSTICS
        _msg_text = MESSAGE_TEXT,
        _sqlstate = RETURNED_SQLSTATE,
        _detail   = PG_EXCEPTION_DETAIL,
        _hint     = PG_EXCEPTION_HINT,
        _context  = PG_EXCEPTION_CONTEXT;  
    RETURN fn_handle_error(_sqlstate, _msg_text, _detail, _hint, _context, format('sp_split_transaction(%L, %L, %L, %L,%L)', $1,$2,$3,$4,$5));  
END;

sp_update_transaction

Parameters

Definition