APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on WF_NOTIFICATIONS

Line 9380: l_notif_status wf_notifications.status%type;

9376: l_item_key wf_items.item_key%type;
9377: l_api_name CONSTANT VARCHAR2(30) := 'Record_Buyer_Response';
9378: l_api_version CONSTANT NUMBER := 1.0;
9379:
9380: l_notif_status wf_notifications.status%type;
9381: l_notification_id number;
9382: l_next_flag boolean:=true;
9383:
9384: cursor l_notif_status_csr(activity in varchar2) is

Line 9386: from wf_item_activity_statuses_v was, wf_notifications wfn

9382: l_next_flag boolean:=true;
9383:
9384: cursor l_notif_status_csr(activity in varchar2) is
9385: select wfn.status, wfn.notification_id
9386: from wf_item_activity_statuses_v was, wf_notifications wfn
9387: where was.item_type=l_item_type
9388: and was.item_key=l_item_key
9389: and was.activity_name=activity
9390: and was.notification_id=wfn.notification_id;

Line 9418: update wf_notifications

9414: fetch l_notif_status_csr into l_notif_status, l_notification_id;
9415: if(l_notif_status_csr%FOUND) then
9416: l_next_flag:=false;
9417: if(l_notif_status='OPEN') then
9418: update wf_notifications
9419: set status='CLOSED'
9420: where notification_id=l_notification_id;
9421: end if;
9422: end if;