CREATE OR REPLACE TRIGGER xx
AFTER INSERT
ON wf_routing_rules
FOR EACH ROW
BEGIN
concreqid := 0;
returncode := fnd_request.set_mode (TRUE);
concreqid := fnd_request.submit_request ('FND',
'DELEGATEPROC',
'',
SYSDATE,
FALSE,
CHR (0)
);
AFTER INSERT
ON wf_routing_rules
FOR EACH ROW
BEGIN
concreqid := 0;
returncode := fnd_request.set_mode (TRUE);
concreqid := fnd_request.submit_request ('FND',
'DELEGATEPROC',
'',
SYSDATE,
FALSE,
CHR (0)
);
IF concreqid = 0
THEN
DBMS_OUTPUT.put_line ('Problem Submitting Program DELEGATEPROC');
/* Handle Error */
END IF;
END;
THEN
DBMS_OUTPUT.put_line ('Problem Submitting Program DELEGATEPROC');
/* Handle Error */
END IF;
END;
No comments:
Post a Comment