APPS.POS_SUPPLIER_USER_REG_PKG dependencies on WF_USER_ROLES

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

595: PROCEDURE NAME: get_wf_role_for_users
596: this is the same function as that in PO_REQAPPROVAL_INIT1 (private func)
597:
598: DESCRIPTION :
599: Given a list of users, the procedure looks through the wf_user_roles
600: to get a role that has exactly same set of input list of users.
601:
602: parameters :
603: Input:

Line 614: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;

610: *******************************************************************/
611:
612: FUNCTION get_wf_role_for_users(p_list_of_users IN VARCHAR2, p_num_users IN NUMBER) RETURN VARCHAR2 IS
613: l_refcur g_refcur;
614: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;
615: l_progress VARCHAR2(255);
616:
617: cursor l_role_cur is
618: SELECT final.role_name

Line 621: wf_user_roles wur, wf_user_roles final

617: cursor l_role_cur is
618: SELECT final.role_name
619: FROM fnd_user fu,
620: fnd_responsibility fr,
621: wf_user_roles wur, wf_user_roles final
622: WHERE fr.menu_id in
623: (SELECT fme.menu_id
624: FROM fnd_menu_entries fme, (SELECT function_id FROM fnd_form_functions WHERE function_name = 'POS_REG_APPROVE_EXT_USERS') func
625: START WITH fme.function_id = func.function_id

Line 675: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE := NULL;

671: l_user_name FND_USER.USER_NAME%TYPE := NULL;
672: l_num_users NUMBER := 0;
673: l_approverlist VARCHAR2(2000):=NULL;
674: l_approverlist_sql VARCHAR2(2000):=NULL;
675: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE := NULL;
676: l_role_display_name VARCHAR2(100):=NULL;
677: l_expiration_date DATE;
678:
679: BEGIN

Line 692: wf_user_roles wur

688: OPEN x_refcur FOR
689: 'SELECT DISTINCT fu.user_name
690: FROM fnd_user fu,
691: fnd_responsibility fr,
692: wf_user_roles wur
693: WHERE fr.menu_id in
694: (SELECT fme.menu_id
695: FROM fnd_menu_entries fme
696: START WITH fme.function_id = :1

Line 1026: lv_approver_role WF_USER_ROLES.ROLE_NAME%TYPE;

1022: l_itemkey wf_items.item_key%TYPE;
1023: l_local_user_name wf_local_users.name%TYPE;
1024: l_process wf_process_activities.process_name%TYPE;
1025: is_osn VARCHAR2(1);
1026: lv_approver_role WF_USER_ROLES.ROLE_NAME%TYPE;
1027: BEGIN
1028:
1029: l_itemtype := 'POSREGV2';
1030: is_osn := is_osnrequest(p_registration_id);