abirama62

Untitled

Apr 24th, 2020
566
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE FUNCTION i_ho_void_pos_shop(bigint, bigint , character varying, bigint, bigint, bigint, bigint, character varying, character varying, bigint)
  2.   RETURNS void AS
  3. $BODY$
  4. DECLARE
  5.   pTenantId         ALIAS FOR $1;
  6.   pSessionId            ALIAS FOR $2;
  7.   pProcessNo            ALIAS FOR $3;
  8.   pOutletId         ALIAS FOR $4;
  9.   pOuId             ALIAS FOR $5;
  10.   pWarehouseId      ALIAS FOR $6;
  11.   pUserId               ALIAS FOR $7;
  12.   pDatetime         ALIAS FOR $8;
  13.   pDateVoid         ALIAS FOR $9;
  14.   pPosId            ALIAS FOR $10;
  15.  
  16.   vFlagNo               character varying(1);
  17.   vProductStatus        character varying(5);
  18.   vEmptyId          bigint;
  19.   vFlagCash         character varying(1);
  20.   vDebitType            character varying(1);
  21.   vFlagYes          character varying(1);
  22.   vEmptyValue       character varying(1);
  23.  
  24. BEGIN
  25.   vFlagNo := 'N';
  26.   vProductStatus := 'GOOD';
  27.   vEmptyId := -99;
  28.   vFlagCash := 'C';
  29.   vDebitType := 'D';
  30.   vFlagYes := 'Y';
  31.   vEmptyValue := ' ';
  32.  
  33.  
  34. END;
  35.  
  36. $BODY$
  37. LANGUAGE plpgsql VOLATILE
  38. COST 100;
  39. /
RAW Paste Data