APPS.PO_MASS_UPDATE_REQ_PVT dependencies on WF_NOTIFICATION

Line 755: l_notification_id wf_notifications.notification_id%TYPE;

751: l_progress VARCHAR2(3) := '000';
752: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Approver';
753: l_doc_type po_document_types_all.type_name%TYPE;
754: l_auth_status po_headers.authorization_status%TYPE;
755: l_notification_id wf_notifications.notification_id%TYPE;
756: l_msg16 VARCHAR2(240);
757: l_msg17 VARCHAR2(240);
758:
759: BEGIN

Line 887: FROM wf_notifications wfn,

883:
884: stmt_req := 'SELECT wfn.notification_id,
885: por.segment1,
886: pdt.type_name
887: FROM wf_notifications wfn,
888: wf_item_activity_statuses wfa,
889: po_requisition_headers por,
890: po_document_types_vl pdt
891: WHERE wfn.notification_id = wfa.notification_id

Line 999: Wf_Notification.Forward(l_notification_id, p_new_username,l_msg16);

995: SAVEPOINT Update_Req_Forward_SP;
996:
997: l_progress := '005';
998:
999: Wf_Notification.Forward(l_notification_id, p_new_username,l_msg16);
1000:
1001: IF g_debug_stmt THEN
1002:
1003: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_username',p_new_username );