APPS.PO_APPROVAL_LIST_WF1S dependencies on WF_NOTIFICATIONS

Line 1806: FROM WF_NOTIFICATIONS

1802: -- PO_REQ_APPROVE, PO_REQ_REMINDER2 then PO_REQ_REMINDER1.
1803:
1804: CURSOR c_canceled_notif (notif_id number) IS
1805: SELECT '1'
1806: FROM WF_NOTIFICATIONS
1807: WHERE notification_id = notif_id
1808: AND status = 'CANCELED';
1809:
1810: CURSOR c_response(p_group_id number) IS

Line 1822: /* Bug 1578061: remove the join to wf_notifications. This forces the

1818: FROM wf_notification_attr_resp_v
1819: WHERE group_id = p_group_id
1820: AND attribute_name = 'NOTE';
1821:
1822: /* Bug 1578061: remove the join to wf_notifications. This forces the
1823: removal of end_date column
1824:
1825: CURSOR c_responder(p_notification_id number) IS
1826: SELECT nvl((wfu.orig_system_id), -9996)

Line 2060: FROM wf_notifications wfn

2056:
2057: /* Bug 1257763 */
2058: SELECT wfn.responder, wfn.recipient_role, wfn.end_date
2059: INTO l_responder, l_recipient_role, l_end_date
2060: FROM wf_notifications wfn
2061: WHERE wfn.notification_id = l_group_id;
2062:
2063: /* csheu bug #1287135 use reponder value in wf_notification to find
2064: its orig_system_id from wf_users. If no matched rows found from

Line 2362: FROM WF_NOTIFICATIONS

2358: ORDER BY activity_end_date DESC;
2359:
2360: CURSOR c_canceled_notif (notif_id number) IS
2361: SELECT '1'
2362: FROM WF_NOTIFICATIONS
2363: WHERE notification_id = notif_id
2364: AND status = 'CANCELED';
2365:
2366: CURSOR c_response(p_group_id number) IS

Line 2385: l_responder wf_notifications.responder%TYPE;

2381: FROM wf_users wfu
2382: WHERE wfu.name = p_responder
2383: AND wfu.orig_system not in ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');
2384:
2385: l_responder wf_notifications.responder%TYPE;
2386: l_recipient_role wf_notifications.recipient_role%TYPE;
2387:
2388: l_progress VARCHAR2(100) := '000';
2389: l_group_id NUMBER;

Line 2386: l_recipient_role wf_notifications.recipient_role%TYPE;

2382: WHERE wfu.name = p_responder
2383: AND wfu.orig_system not in ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');
2384:
2385: l_responder wf_notifications.responder%TYPE;
2386: l_recipient_role wf_notifications.recipient_role%TYPE;
2387:
2388: l_progress VARCHAR2(100) := '000';
2389: l_group_id NUMBER;
2390: l_role wf_notifications.recipient_role%TYPE;

Line 2390: l_role wf_notifications.recipient_role%TYPE;

2386: l_recipient_role wf_notifications.recipient_role%TYPE;
2387:
2388: l_progress VARCHAR2(100) := '000';
2389: l_group_id NUMBER;
2390: l_role wf_notifications.recipient_role%TYPE;
2391: l_approver_id NUMBER := NULL;
2392: l_orig_system wf_users.orig_system%TYPE;
2393: l_responder_user_name wf_users.name%TYPE;
2394: l_responder_disp_name wf_users.display_name%TYPE;

Line 2543: FROM wf_notifications wfn

2539:
2540: /* Bug 1257763 */
2541: SELECT wfn.responder, wfn.recipient_role, wfn.end_date
2542: INTO l_responder, l_recipient_role, responseEndDate
2543: FROM wf_notifications wfn
2544: WHERE wfn.notification_id = l_group_id;
2545:
2546: /* csheu bug #1287135 use reponder value in wf_notification to find
2547: its orig_system_id from wf_users. If no matched rows found from