APPS.PO_REQAPPROVAL_INIT1 dependencies on WF_USER_ROLES

Line 239: Given a list of users, the procedure looks through the wf_user_roles

235: < Added this function as part of Bug #: 2810150 >
236: PROCEDURE NAME: get_wf_role_for_users
237:
238: DESCRIPTION :
239: Given a list of users, the procedure looks through the wf_user_roles
240: to get a role that has exactly same set of input list of users.
241:
242: Referenced by : locate_notifier
243: parameters :

Line 258: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;

254: *******************************************************************/
255:
256: FUNCTION get_wf_role_for_users(p_list_of_users IN VARCHAR2, p_num_users IN NUMBER) RETURN VARCHAR2
257: IS
258: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;
259: l_adhoc VARCHAR2(10);
260: l_progress VARCHAR2(255);
261: l_offset PLS_INTEGER;
262: l_length PLS_INTEGER;

Line 272: FROM wf_user_roles

268: CURSOR l_cur IS
269: SELECT role_name
270: FROM (
271: SELECT role_name
272: FROM wf_user_roles
273: WHERE role_name IN
274: (SELECT role_name
275: FROM wf_user_roles
276: WHERE user_name in (SELECT user_name FROM po_wf_user_tmp)

Line 275: FROM wf_user_roles

271: SELECT role_name
272: FROM wf_user_roles
273: WHERE role_name IN
274: (SELECT role_name
275: FROM wf_user_roles
276: WHERE user_name in (SELECT user_name FROM po_wf_user_tmp)
277: AND role_name like 'ADHOC%'
278: AND NVL(EXPIRATION_DATE,SYSDATE+1) > SYSDATE
279: GROUP BY role_name

Line 4391: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;

4387: l_msg_data VARCHAR2(2000);
4388: /*CONERMS FPJ END*/
4389:
4390: -- local variables for role creation
4391: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;
4392: l_role_display_name varchar2(100):=null;
4393: l_temp varchar2(100);
4394: l_expiration_date DATE;
4395: l_count number;