APPS.PO_MASS_UPDATE_PO_PVT dependencies on WF_NOTIFICATION

Line 1231: l_notification_id wf_notifications.notification_id%TYPE;

1227: l_progress VARCHAR2(3) := '000';
1228: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Approver';
1229: l_doc_type po_document_types_all.type_name%TYPE;
1230: l_auth_status po_headers.authorization_status%TYPE;
1231: l_notification_id wf_notifications.notification_id%TYPE;
1232: l_msg16 VARCHAR2(240);
1233: l_msg17 VARCHAR2(240);
1234:
1235: BEGIN

Line 1370: FROM wf_notifications wfn,

1366:
1367: stmt_po := 'SELECT wfn.notification_id,
1368: poh.segment1,
1369: pdt.type_name
1370: FROM wf_notifications wfn,
1371: wf_item_activity_statuses wfa,
1372: po_headers poh,
1373: po_document_types_vl pdt
1374: WHERE wfn.notification_id = wfa.notification_id

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

1499: SAVEPOINT Mass_Update_Forward_SP;
1500:
1501: l_progress := '005';
1502:
1503: Wf_Notification.Forward(l_notification_id, p_new_username,l_msg16);
1504:
1505: IF g_debug_stmt THEN
1506:
1507: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_username',p_new_username );

Line 1571: FROM wf_notifications wfn,

1567: stmt_rel := 'SELECT wfn.notification_id,
1568: poh.segment1,
1569: por.release_num,
1570: pdt.type_name
1571: FROM wf_notifications wfn,
1572: wf_item_activity_statuses wfa,
1573: po_headers poh,
1574: po_releases por,
1575: po_document_types_vl pdt

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

1700: BEGIN
1701:
1702: SAVEPOINT Mass_Update_Forward_SP;
1703:
1704: Wf_Notification.Forward(l_notification_id, p_new_username,l_msg16);
1705:
1706: l_progress := '008';
1707:
1708: IF g_debug_stmt THEN