APPS.PO_MASS_UPDATE_PO_PVT dependencies on WF_NOTIFICATION

Line 1304: l_notification_id wf_notifications.notification_id%TYPE;

1300: l_progress VARCHAR2(3) := '000';
1301: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Approver';
1302: l_doc_type po_document_types_all.type_name%TYPE;
1303: l_auth_status po_headers.authorization_status%TYPE;
1304: l_notification_id wf_notifications.notification_id%TYPE;
1305: l_msg16 VARCHAR2(240);
1306: l_msg17 VARCHAR2(240);
1307:
1308: BEGIN

Line 1443: FROM wf_notifications wfn,

1439:
1440: stmt_po := 'SELECT wfn.notification_id,
1441: poh.segment1,
1442: pdt.type_name
1443: FROM wf_notifications wfn,
1444: wf_item_activity_statuses wfa,
1445: po_headers poh,
1446: po_document_types_vl pdt
1447: WHERE wfn.notification_id = wfa.notification_id

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

1572: SAVEPOINT Mass_Update_Forward_SP;
1573:
1574: l_progress := '005';
1575:
1576: Wf_Notification.Forward(l_notification_id, p_new_username,l_msg16);
1577:
1578: IF g_debug_stmt THEN
1579:
1580: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_username',p_new_username );

Line 1644: FROM wf_notifications wfn,

1640: stmt_rel := 'SELECT wfn.notification_id,
1641: poh.segment1,
1642: por.release_num,
1643: pdt.type_name
1644: FROM wf_notifications wfn,
1645: wf_item_activity_statuses wfa,
1646: po_headers poh,
1647: po_releases por,
1648: po_document_types_vl pdt

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

1773: BEGIN
1774:
1775: SAVEPOINT Mass_Update_Forward_SP;
1776:
1777: Wf_Notification.Forward(l_notification_id, p_new_username,l_msg16);
1778:
1779: l_progress := '008';
1780:
1781: IF g_debug_stmt THEN