CREATE OR REPLACE FUNCTION f_deposit_remiseinfo_update(
 IN kubun           integer,    -- 区分
 IN _orderno        integer,    -- 受注No
 IN _remiseinfo        varchar,    -- ルミーズ決済情報
 IN _cardcompany        varchar,    -- カード会社
 IN _cardnumber        varchar,    -- カード番号
 IN _cardname        varchar,    -- カード名義
 IN _cardexp        varchar,    -- カード有効期限

 IN upduser         varchar,
 IN pc              varchar,

 OUT errcd          integer,
 OUT errmsg         varchar,
 OUT code           integer) AS
$BODY$
DECLARE
    cntcheck integer;
BEGIN
    --
    -- パラメータチェック
    --

    -- 処理区分
    IF kubun IS NULL OR kubun NOT IN (2) THEN
        RAISE EXCEPTION '処理区分が不正です';
    END IF;

    IF kubun = 2 THEN
        -- 入金テーブル変更
        UPDATE t_deposit SET
            remiseinfo = _remiseinfo,
            cardcompany = _cardcompany,
            cardnumber = _cardnumber,
            cardname = _cardname,
            cardexp = _cardexp,

            updusrnm = upduser,
            updpcnm = pc
            WHERE orderno = _orderno;
        errcd := 1;
        code := _orderno;
        errmsg := '完了';
        RETURN;
    END IF;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;

ALTER FUNCTION f_deposit_remiseinfo_update(IN kubun integer, IN _orderno integer, IN _remiseinfo varchar, IN _cardcompany varchar, IN _cardnumber varchar, IN _cardname varchar, IN _cardexp varchar, IN upduser varchar, IN pc varchar, OUT errcd integer, OUT errmsg varchar, OUT code integer) OWNER TO :ADMINUSER;

GRANT ALL ON FUNCTION f_deposit_remiseinfo_update(IN kubun integer, IN _orderno integer, IN _remiseinfo varchar, IN _cardcompany varchar, IN _cardnumber varchar, IN _cardname varchar, IN _cardexp varchar, IN upduser varchar, IN pc varchar, OUT errcd integer, OUT errmsg varchar, OUT code integer) TO :ONEDEPOUSER;