Send workflow notification without statring workflow

You can send workflow notifications without starting the actual workflow. Here is how
.

lv_key := TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
ln_notification_id := wf_notification.send (lv_role_name
                                           ,'WF_ITEM_NAME'
                                           ,'WF_NOTIFICATION_NAME'
                                           ,SYSDATE+3
                                           ,'WF_ENGINE.CB'
                                           ,'WF_ITEM_NAME:'||lv_key||':'||TO_CHAR(SYSDATE, 'JSS')
                                           ,NULL
                                           ,NULL );

wf_notification.setattrtext (ln_notification_id,'SUBJECT',lv_subject_txt);
wf_notification.setattrtext (ln_notification_id,'BODY',lv_body_txt);

UPDATE wf_notifications
   SET from_user       = 'System'
      ,from_role       = 'SYSADMIN'
 WHERE notification_id = ln_notification_id;

.
Note the item key synatx.

Cheers.