eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_APPROVAL_LIST_WF1S dependencies on WF_USERS

Line 1827: FROM wf_users wfu

1823: removal of end_date column
1824:
1825: CURSOR c_responder(p_notification_id number) IS
1826: SELECT nvl((wfu.orig_system_id), -9996)
1827: FROM wf_users wfu
1828: WHERE wfu.name = wf_notification.responder(p_notification_id)
1829: AND wfu.orig_system not in ('POS', 'ENG_LIST', 'CUST_CONT');
1830: */
1831:

Line 1835: FROM wf_users wfu

1831:
1832: /* bug 1817306 new cursor c_responderid is defined to replace c_responder */
1833: CURSOR c_responderid(p_responder VARCHAR2) IS
1834: SELECT nvl((wfu.orig_system_id), -9996)
1835: FROM wf_users wfu
1836: WHERE wfu.name = p_responder
1837: AND wfu.orig_system not in ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');
1838:
1839: l_progress VARCHAR2(100) := '000';

Line 2064: its orig_system_id from wf_users. If no matched rows found from

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
2065: wf_users then we will use l_recipient_role value from wf_notification
2066: to find its orig_system_id from wf_users instead.
2067: */
2068:

Line 2065: wf_users then we will use l_recipient_role value from wf_notification

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
2065: wf_users then we will use l_recipient_role value from wf_notification
2066: to find its orig_system_id from wf_users instead.
2067: */
2068:
2069: OPEN c_responderid(l_responder);

Line 2066: to find its orig_system_id from wf_users instead.

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
2065: wf_users then we will use l_recipient_role value from wf_notification
2066: to find its orig_system_id from wf_users instead.
2067: */
2068:
2069: OPEN c_responderid(l_responder);
2070: FETCH c_responderid INTO l_responder_id;

Line 2381: FROM wf_users wfu

2377:
2378: /* bug 1817306 new cursor c_responderid is defined to replace c_responder */
2379: CURSOR c_responderid(p_responder VARCHAR2) IS
2380: SELECT nvl((wfu.orig_system_id), -9996)
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;

Line 2392: l_orig_system wf_users.orig_system%TYPE;

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;
2395:
2396: l_org_id number;

Line 2393: l_responder_user_name wf_users.name%TYPE;

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;
2395:
2396: l_org_id number;
2397: is_notif_canceled VARCHAR2(2);

Line 2394: l_responder_disp_name wf_users.display_name%TYPE;

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;
2395:
2396: l_org_id number;
2397: is_notif_canceled VARCHAR2(2);
2398: l_doc_string varchar2(200);

Line 2399: l_preparer_user_name wf_users.name%TYPE;

2395:
2396: l_org_id number;
2397: is_notif_canceled VARCHAR2(2);
2398: l_doc_string varchar2(200);
2399: l_preparer_user_name wf_users.name%TYPE;
2400:
2401: BEGIN
2402:
2403: l_progress := 'Update_App_List_Resp_Success: 001- at beginning of function';

Line 2547: its orig_system_id from wf_users. If no matched rows found from

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
2548: wf_users then we will use l_recipient_role value from wf_notification
2549: to find its orig_system_id from wf_users instead.
2550: */
2551:

Line 2548: wf_users then we will use l_recipient_role value from wf_notification

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
2548: wf_users then we will use l_recipient_role value from wf_notification
2549: to find its orig_system_id from wf_users instead.
2550: */
2551:
2552: OPEN c_responderid(l_responder);

Line 2549: to find its orig_system_id from wf_users instead.

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
2548: wf_users then we will use l_recipient_role value from wf_notification
2549: to find its orig_system_id from wf_users instead.
2550: */
2551:
2552: OPEN c_responderid(l_responder);
2553: FETCH c_responderid INTO responderId;

Line 2692: l_preparer_user_name wf_users.name%TYPE;

2688: E_UPDATE_RESPONSE_FAIL EXCEPTION;
2689: l_end_date DATE; -- notification end date
2690: l_note VARCHAR2(4000);
2691: l_doc_string varchar2(200);
2692: l_preparer_user_name wf_users.name%TYPE;
2693:
2694: doc_manager_exception exception;
2695:
2696: BEGIN