psp_hr_check_emp.prc

来自「ceshi de bu yao xiazai」· PRC 代码 · 共 33 行

CREATE OR REPLACE PROCEDURE       PSP_HR_CHECK_EMP(LINE IN VARCHAR2,W_STATION IN VARCHAR2,DATA IN VARCHAR2,RES OUT VARCHAR2) IS
C_EMP VARCHAR2(25);
COUNT0  NUMBER(2);
COUNT1  NUMBER(2);
COUNT2  NUMBER(2);
COUNT3  NUMBER(2);
COUNT4  NUMBER(2);
COUNT5  NUMBER(2);
COUNT6  NUMBER(2);
C_DEPART VARCHAR2(25);
C_CLASS VARCHAR2(25);
CLASSNO VARCHAR2(5);
CDATE   VARCHAR2(8);
TEMP_CDATE   VARCHAR2(8);
C_RANK   VARCHAR2(25);
C_STATUS VARCHAR2(25);
TEMP     VARCHAR2(25);
WDATE    VARCHAR2(25);
SCDATE   VARCHAR2(8);
SCTIME   VARCHAR2(12);
SCHM     VARCHAR2(4);
SCHM1     VARCHAR2(4);
CLASSNAME VARCHAR2(25);
CLASSNAME1 VARCHAR2(25);
CNAME     VARCHAR2(25);
CNAME2    VARCHAR2(25);
TEMP_EMP   VARCHAR2(25);
SNUM     NUMBER(5);
MAXT      VARCHAR2(8);
MINT      VARCHAR2(8);
BEGIN
   IF W_STATION='PACKING1' THEN
      RES:='ぃ