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.POS_WCAPPROVE_PVT dependencies on WF_USERS

Line 1895: FROM wf_users wfu

1891: AND attribute_name = 'NOTE';
1892:
1893: CURSOR c_responderid(p_responder VARCHAR2) IS
1894: SELECT nvl((wfu.orig_system_id), -9996)
1895: FROM wf_users wfu
1896: WHERE wfu.name = p_responder
1897: AND wfu.orig_system not in ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');
1898:
1899: l_api_name varchar2(50) := p_itemkey || ' update_approval_list_response';

Line 1908: l_orig_system wf_users.orig_system%TYPE;

1904: l_role wf_notifications.recipient_role%TYPE;
1905: l_response VARCHAR2(2000);
1906:
1907: l_approver_id NUMBER := NULL;
1908: l_orig_system wf_users.orig_system%TYPE;
1909: l_responder_user_name wf_users.name%TYPE;
1910: l_responder_disp_name wf_users.display_name%TYPE;
1911:
1912: is_notif_canceled VARCHAR2(2);

Line 1909: l_responder_user_name wf_users.name%TYPE;

1905: l_response VARCHAR2(2000);
1906:
1907: l_approver_id NUMBER := NULL;
1908: l_orig_system wf_users.orig_system%TYPE;
1909: l_responder_user_name wf_users.name%TYPE;
1910: l_responder_disp_name wf_users.display_name%TYPE;
1911:
1912: is_notif_canceled VARCHAR2(2);
1913: l_doc_string varchar2(200);

Line 1910: l_responder_disp_name wf_users.display_name%TYPE;

1906:
1907: l_approver_id NUMBER := NULL;
1908: l_orig_system wf_users.orig_system%TYPE;
1909: l_responder_user_name wf_users.name%TYPE;
1910: l_responder_disp_name wf_users.display_name%TYPE;
1911:
1912: is_notif_canceled VARCHAR2(2);
1913: l_doc_string varchar2(200);
1914: l_preparer_user_name wf_users.name%TYPE;

Line 1914: l_preparer_user_name wf_users.name%TYPE;

1910: l_responder_disp_name wf_users.display_name%TYPE;
1911:
1912: is_notif_canceled VARCHAR2(2);
1913: l_doc_string varchar2(200);
1914: l_preparer_user_name wf_users.name%TYPE;
1915: l_response_end_date date;
1916: l_responder_id number;
1917: l_progress varchar2(300);
1918: l_insertion_type VARCHAR2(30);

Line 2229: Bug 7120431 , To get the user name from wf_users we need to pass orig_system as 'PER' irresepective of

2225: end if;
2226:
2227:
2228: /*
2229: Bug 7120431 , To get the user name from wf_users we need to pass orig_system as 'PER' irresepective of
2230: whether we user Employee-Supervisor hierarchy or Positional hierarchy .
2231: So passing 'PER' while in the below call.
2232: */
2233:

Line 2377: FROM wf_users wfu

2373: p_action_code in varchar2) IS
2374:
2375: CURSOR c_responderid(l_responder VARCHAR2) IS
2376: SELECT nvl((wfu.orig_system_id), -9996)
2377: FROM wf_users wfu
2378: WHERE wfu.name = l_responder
2379: AND wfu.orig_system not in ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');
2380:
2381: