Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION i_ho_void_pos_shop(bigint, bigint , character varying, bigint, bigint, bigint, bigint, character varying, character varying, bigint)
- RETURNS void AS
- $BODY$
- DECLARE
- pTenantId ALIAS FOR $1;
- pSessionId ALIAS FOR $2;
- pProcessNo ALIAS FOR $3;
- pOutletId ALIAS FOR $4;
- pOuId ALIAS FOR $5;
- pWarehouseId ALIAS FOR $6;
- pUserId ALIAS FOR $7;
- pDatetime ALIAS FOR $8;
- pDateVoid ALIAS FOR $9;
- pPosId ALIAS FOR $10;
- vFlagNo character varying(1);
- vProductStatus character varying(5);
- vEmptyId bigint;
- vFlagCash character varying(1);
- vDebitType character varying(1);
- vFlagYes character varying(1);
- vEmptyValue character varying(1);
- BEGIN
- vFlagNo := 'N';
- vProductStatus := 'GOOD';
- vEmptyId := -99;
- vFlagCash := 'C';
- vDebitType := 'D';
- vFlagYes := 'Y';
- vEmptyValue := ' ';
- END;
- $BODY$
- LANGUAGE plpgsql VOLATILE
- COST 100;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement