Priority Developer Portal

Insert Initial BPM Status

The final step in creating a BPM flow chart is to write a query that will insert the initial status into the XXXX_MYDOCSTATS table:

:INITSTAT = 'Initial Stat';
:STATUSTYPE = 'PRIV_MYBPM'
INSERT INTO XXXX_MYDOCSTATS
(MYDOCSTAT,STATDES,INITSTATFLAG,CHANGEFLAG)
VALUES(-1,:INITSTAT,'Y','Y');

INSERT INTO DOCSTATUSES (ORIGSTATUSID,TYPE,STATDES, NEWDOCFLAG)
VALUES(-1, :STATUSTYPE, :INITSTAT,'Y');