DBA Data[Home] [Help]

APPS.BEN_CWB_WF_NTF dependencies on WF_NOTIFICATION

Line 397: FROM wf_notifications n

393:
394: BEGIN
395: SELECT n.status
396: INTO l_status
397: FROM wf_notifications n
398: WHERE n.notification_id = l_notification_id;
399: EXCEPTION
400: WHEN NO_DATA_FOUND
401: THEN

Line 403: wf_notification.getsubject (l_notification_id)

399: EXCEPTION
400: WHEN NO_DATA_FOUND
401: THEN
402: wf_core.token ('NID',
403: wf_notification.getsubject (l_notification_id)
404: );
405: wf_core.RAISE ('WFNTF_NID');
406: END;
407:

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

406: END;
407:
408: IF (l_status = 'OPEN')
409: THEN
410: wf_notification.CLOSE (nid => l_notification_id,
411: responder => l_from_fnd_user_name
412: );
413: END IF;
414: EXCEPTION