APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on WF_NOTIFICATIONS

Line 8993: l_notif_status wf_notifications.status%type;

8989: l_item_key wf_items.item_key%type;
8990: l_api_name CONSTANT VARCHAR2(30) := 'Record_Buyer_Response';
8991: l_api_version CONSTANT NUMBER := 1.0;
8992:
8993: l_notif_status wf_notifications.status%type;
8994: l_notification_id number;
8995: l_next_flag boolean:=true;
8996:
8997: cursor l_notif_status_csr(activity in varchar2) is

Line 8999: from wf_item_activity_statuses_v was, wf_notifications wfn

8995: l_next_flag boolean:=true;
8996:
8997: cursor l_notif_status_csr(activity in varchar2) is
8998: select wfn.status, wfn.notification_id
8999: from wf_item_activity_statuses_v was, wf_notifications wfn
9000: where was.item_type=l_item_type
9001: and was.item_key=l_item_key
9002: and was.activity_name=activity
9003: and was.notification_id=wfn.notification_id;

Line 9031: update wf_notifications

9027: fetch l_notif_status_csr into l_notif_status, l_notification_id;
9028: if(l_notif_status_csr%FOUND) then
9029: l_next_flag:=false;
9030: if(l_notif_status='OPEN') then
9031: update wf_notifications
9032: set status='CLOSED'
9033: where notification_id=l_notification_id;
9034: end if;
9035: end if;