APPS.PO_REQAPPROVAL_INIT1 dependencies on WF_USER_ROLES

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

307: /*******************************************************************
308: < Added this function as part of Bug #: 2810150 >
309: PROCEDURE NAME: get_wf_role_for_users
310: DESCRIPTION :
311: Given a list of users, the procedure looks through the wf_user_roles
312: to get a role that has exactly same set of input list of users.
313: Referenced by : locate_notifier
314: parameters :
315: Input:

Line 330: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;

326: p_list_of_users IN VARCHAR2,
327: p_num_users IN NUMBER)
328: RETURN VARCHAR2
329: IS
330: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;
331: l_adhoc VARCHAR2(10);
332: l_progress VARCHAR2(255);
333: l_offset PLS_INTEGER;
334: l_length PLS_INTEGER;

Line 344: FROM wf_user_roles

340: IS
341: SELECT role_name
342: FROM
343: (SELECT role_name
344: FROM wf_user_roles
345: WHERE role_name IN
346: (SELECT role_name
347: FROM wf_user_roles
348: WHERE user_name IN

Line 347: FROM wf_user_roles

343: (SELECT role_name
344: FROM wf_user_roles
345: WHERE role_name IN
346: (SELECT role_name
347: FROM wf_user_roles
348: WHERE user_name IN
349: (SELECT user_name FROM po_wf_user_tmp
350: )
351: AND role_name LIKE 'ADHOC%'

Line 3735: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;

3731: l_msg_count NUMBER := 0;
3732: l_msg_data VARCHAR2(2000);
3733: /*CONERMS FPJ END*/
3734: -- local variables for role creation
3735: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;
3736: l_role_display_name VARCHAR2(100):=NULL;
3737: l_temp VARCHAR2(100);
3738: l_expiration_date DATE;
3739: l_count NUMBER;