psp_assy_check_emp.prc

ceshi de bu yao xiazai

CREATE OR REPLACE PROCEDURE PSP_ASSY_CHECK_EMP(DATA IN VARCHAR2,LINE IN VARCHAR2,W_STATION IN VARCHAR2,
RES OUT VARCHAR2) IS
C_EMP VARCHAR2(25);
E_COUNT INTEGER;
BEGIN
   IF DATA NOT IN ('RESETLED','CLEARKP') THEN
     /*IF  DATA='MB_ASSY' THEN 
	     DELETE FROM SFISM4.R_GROUP_INSTEAD_T WHERE LINE_NAME=LINE AND GROUP_NAME=W_STATION;
		  RES:='ち传Θ