Insert msg forward
CALL INSERT_MESSAGE_FORWARD(
C1.USERID,
C1.DRIVER,
C1.POWER,
C1.DEVICE,
C1.NETWORK,
0,
'0',
' PAY RECEIPT'||CHR(10)||
'PAY CODE: '||C1.PAY_CODE||CHR(10)||
' HOURS: '|| STRIP(CHAR(DECIMAL(C1.HOURS,11,1)), LEADING, 0)||CHR(10)||
' PO: '||C1.PO_NUMBER||CHR(10)||
' BILL NO: '||C1.BILL_NUMBER||CHR(10)||
' USER: '||C1.USERID||CHR(10)||'',
-5,
vMSGID
);
INSERT_MESSAGE_FORWARD(
IN ENTERED_BY VARCHAR(128),
IN DRIVER VARCHAR(10),
IN POWER VARCHAR(10),
IN DEVICE VARCHAR(20),
IN NETWORK CHAR(1),
IN MACRO INT,
IN PRIORITY CHAR(1),
IN BODY CLOB(128K),
IN GMT_OFFSET INT,
OUT MESSAGE_ID INT
)