/*=====silk workshop of tobacco libraries, library materials library, rods and shipping department daily tally data manually triggered (once per shift)======*/
PROCEDURE QZ_LKRCDJ_TASK (IN_USERID IN NUMBER) IS
V_INDOCNO NUMBER;
RT_VUSERS VUSERS % ROWTYPE;
V_COUNT NUMBER;
The BEGIN
Personnel data obtained -
SELECT * INTO RT_VUSERS FROM VUSERS WHERE ID=IN_USERID;
LOOP FOR REC IN (SELECT * FROM QZ_V_LKRCDJ_STD)
- made the primary key
The SELECT SEQ_QZ_RCDJ_TASK. NEXTVAL INTO V_INDOCNO FROM DUAL;
- whether in the form existing data (according to the current time and shift)
SELECT COUNT (1) INTO V_COUNT FROM QZ_RCDJ_TASK T
WHERE TO_CHAR (T.D NTIME, '- DD YYYY - MM)=TO_CHAR (SYSDATE,' YYYY - MM - DD)
AND T.I BZ=RT_VUSERS. IBZ
AND T.I XMID=REC. ILINKNO;
IF V_COUNT=0 THEN
INSERT INTO QZ_RCDJ_TASK (INDOCNO, SBOOKNM IDOCID, SFCODE, SFNAME
IDEPT, SDEPT IXMID, ITYPE STYPE
, SITEMNM SCHECKDETAIL SCHECKMETHOD, SRESULT
, IUPPER SUPPEROP ILOWER SLOWEROP, SREMARK
, SCOPECODE ICYCLEVALUE SCYCLEUNIT STODO, DNTIME
IFUN, INUM ICUSER SCUSER, IBZ, DCUSER
, ICHECK, SCHECK, DCHECK
, SREGID SREGNM DREGT SMODID, SMODNM, DMODT
, IDOCTYPE ISTEPID SSTEPNM SSTEPSTATE, ISTEPCHARTTYPE
, SSTEPOPERID SSTEPOPERNM IDEL, SPHOTO)
VALUES (V_INDOCNO, REC. SBOOKNM, REC. IDOCID, REC. SFCODE, REC. SFNAME
, REC. IDEPT, REC. SDEPT, REC. ILINKNO, REC. ITYPE, REC. STYPE
, REC. SITEM, REC. SCHECKDETAIL, REC. SCHECKMETHOD, NULL
, REC. UPPER_NUM, REC. UPPER_OP, REC. LOWER_NUM, REC. LOWER_OP, NULL
, REC. SCOPECODE, REC. ICYCLEVALUE, REC. SCYCLEUNIT, REC. TODO, TRUNC (SYSDATE)
, 0, NULL, NULL, NULL, RT_VUSERS. IBZ, NULL
, NULL, NULL, NULL
, RT_VUSERS. ID, RT_VUSERS. NAME, SYSDATE, NULL, NULL, NULL
, NULL, NULL, NULL, NULL, NULL
, NULL, NULL, 0, NULL)
;
COMMIT;
END IF;
END LOOP;
END;
END QZ_STD_TASK;
PACKAGE TNPMQZYC. QZ_STD_TASK compiler error
Error: PLS - 00103: a symbol "V_INDOCNO" when need to be one of the following:
Language
Line: 7
Text: V_COUNT NUMBER;
Error: PLS - 00103: a symbol "QZ_STD_TASK" when need to be one of the following:
;
49:
CodePudding user response:
Excuse me, what is this?CodePudding user response:
Package, should establish two things, a header, a package body,You now this is baotou, baotou can only be defined, specific implementation, should be placed inclusions,
You mix together,