DBA Data[Home] [Help]

APPS.BEN_CWB_WF_NTF dependencies on WF_NOTIFICATION

Line 392: FROM wf_notifications n

388:
389: BEGIN
390: SELECT n.status
391: INTO l_status
392: FROM wf_notifications n
393: WHERE n.notification_id = l_notification_id;
394: EXCEPTION
395: WHEN NO_DATA_FOUND
396: THEN

Line 398: wf_notification.getsubject (l_notification_id)

394: EXCEPTION
395: WHEN NO_DATA_FOUND
396: THEN
397: wf_core.token ('NID',
398: wf_notification.getsubject (l_notification_id)
399: );
400: wf_core.RAISE ('WFNTF_NID');
401: END;
402:

Line 405: wf_notification.CLOSE (nid => l_notification_id,

401: END;
402:
403: IF (l_status = 'OPEN')
404: THEN
405: wf_notification.CLOSE (nid => l_notification_id,
406: responder => l_from_fnd_user_name
407: );
408: END IF;
409: EXCEPTION