APPS.POS_WCAPPROVE_PVT dependencies on WF_USERS

Line 1896: FROM wf_users wfu

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

Line 1909: l_orig_system wf_users.orig_system%TYPE;

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

Line 1910: l_responder_user_name wf_users.name%TYPE;

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

Line 1911: l_responder_disp_name wf_users.display_name%TYPE;

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

Line 1915: l_preparer_user_name wf_users.name%TYPE;

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

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

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

Line 2378: FROM wf_users wfu

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