APPS.POS_REG_WF_PKG dependencies on WF_USER_ROLES

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

67: PROCEDURE NAME: get_wf_role_for_users
68: this is the same function as that in PO_REQAPPROVAL_INIT1 (private func)
69:
70: DESCRIPTION :
71: Given a list of users, the procedure looks through the wf_user_roles
72: to get a role that has exactly same set of input list of users.
73:
74: parameters :
75: Input:

Line 86: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;

82: *******************************************************************/
83:
84: FUNCTION get_wf_role_for_users(p_list_of_users in varchar2, p_num_users in number) return varchar2 IS
85: l_refcur g_refcur;
86: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;
87: l_progress varchar2(255);
88: BEGIN
89: open l_refcur for
90: --'select role_name , count(role_name)

Line 92: from wf_user_roles

88: BEGIN
89: open l_refcur for
90: --'select role_name , count(role_name)
91: 'select role_name
92: from wf_user_roles
93: where
94: role_name in
95: (
96: select role_name

Line 97: from wf_user_roles

93: where
94: role_name in
95: (
96: select role_name
97: from wf_user_roles
98: where user_name in (' || p_list_of_users || ')
99: group by role_name
100: having count(role_name) = :1
101: )

Line 142: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE := null;

138: l_user_name FND_USER.USER_NAME%TYPE := null;
139: l_num_users number := 0;
140: l_approverlist varchar2(2000):=null;
141: l_approverlist_sql varchar2(2000):=null;
142: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE := null;
143: l_role_display_name varchar2(100):=null;
144: l_expiration_date DATE;
145:
146: begin

Line 159: wf_user_roles wur

155: OPEN x_refcur FOR
156: 'SELECT DISTINCT fu.user_name
157: FROM fnd_user fu,
158: fnd_responsibility fr,
159: wf_user_roles wur
160: WHERE fr.menu_id in
161: (SELECT fme.menu_id
162: FROM fnd_menu_entries fme
163: START WITH fme.function_id = :1

Line 1245: lv_approver_role WF_USER_ROLES.ROLE_NAME%TYPE := NULL; --varchar2(320)

1241: lv_vendor_name FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;
1242: lv_osn_tp_name FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;
1243: ln_approver_id NUMBER := NULL;
1244: --lv_approver_role FND_USER.USER_NAME%TYPE := NULL; --varchar2(100)
1245: lv_approver_role WF_USER_ROLES.ROLE_NAME%TYPE := NULL; --varchar2(320)
1246: lv_approval_page_url VARCHAR2(32000) := NULL;
1247: lv_notes FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := NULL;
1248: lv_enterprise_name HZ_PARTIES.PARTY_NAME%TYPE;
1249: lv_logon_page_url VARCHAR2(32000) := NULL;