aonestar.public

Parameters

Name	Type	Mode
folio_id	integer	IN
note	text	IN

Definition

DECLARE 
	_folio_type char(1);
	_register_id int;
	_booking_id int;
    _sqlstate TEXT;
    _detail   TEXT;
    _hint     TEXT;
    _context  TEXT;
    _msg_text TEXT;
BEGIN 
    --CALL sp_check_endday_process();
	
	SELECT folio_type, register_id, booking_id FROM folio WHERE id = $1
	INTO _folio_type, _register_id, _booking_id;

CASE _folio_type 
		WHEN 'R' THEN UPDATE registration SET note = $2 WHERE id = _register_id;
		WHEN 'B' THEN UPDATE booking SET note = $2 WHERE id = _booking_id;
		WHEN 'C' THEN UPDATE cash_sale cs SET note = $2 WHERE cs.folio_id = $1;
		ELSE 
	END CASE;

RETURN fn_result_success();
EXCEPTION  
    WHEN OTHERS THEN
    GET STACKED DIAGNOSTICS
        _sqlstate = RETURNED_SQLSTATE,
        _msg_text = MESSAGE_TEXT,
        _detail   = PG_EXCEPTION_DETAIL,
        _hint     = PG_EXCEPTION_HINT,
        _context  = PG_EXCEPTION_CONTEXT;    
    RETURN fn_handle_error(_sqlstate, _msg_text, _detail, _hint, _context, format('sp_update_folio_note(%s)', i_folio_id::text));
END;