------------------------------------------
-- Description: API to close Workflow Notification in oracle EBS R12
--   nid - Notification Id
--   resp - Respond Required?  0 - No, 1 - Yes
--   responder - User or role close this notification
-- Created By: Hassan @ Oraask.com
-- Creation Date: 21-MAR-2023
------------------------------------------

DECLARE
L_RESPONDER FND_USER.USER_NAME%TYPE := 'SYYADMIN';

CURSOR NOTIFICATIONS_CUR
IS
--
--Modify the below query as per your requirement
--
SELECT ITEM_KEY, NOTIFICATION_ID, RECIPIENT_ROLE
FROM WF_NOTIFICATIONS
WHERE MESSAGE_TYPE LIKE '%HRSSA%'
AND STATUS = 'OPEN'
AND NOTIFICATION_ID = NVL ( :P_NOTIFICATION_ID, NOTIFICATION_ID);
BEGIN
--
FOR NOTIFICATIONS_REC IN NOTIFICATIONS_CUR
LOOP
BEGIN
--
WF_NOTIFICATION.CLOSE (NID => NOTIFICATIONS_REC.NOTIFICATION_ID, RESPONDER => L_RESPONDER);

DBMS_OUTPUT.PUT_LINE ('Closing Notification ID: ' || NOTIFICATIONS_REC.NOTIFICATION_ID);
--
END;
END LOOP;

--
COMMIT;
--
END;