APPS.HR_APPROVAL_SS dependencies on WF_LOCAL_ROLES

Line 1742: l_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;

1738: is
1739: -- local variables
1740: c_proc constant varchar2(60) := 'populatePrllApprDetails';
1741: l_users varchar2(1000) := null;
1742: l_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;
1743:
1744: begin
1745: g_debug := hr_utility.debug_enabled;
1746:

Line 1822: FROM wf_local_roles

1818: l_users varchar2(1000) := null;
1819:
1820: CURSOR c_chk_wf_role (p_role_name VARCHAR2) IS
1821: SELECT 'Y'
1822: FROM wf_local_roles
1823: WHERE name = p_role_name;
1824:
1825: CURSOR c_get_users_from_role (p_role_name VARCHAR2) IS
1826: select user_name

Line 3622: c_return_user_role_info_tbl wf_directory.wf_local_roles_tbl_type;

3618: c_return_user wf_users.name%Type;
3619: c_creator_user wf_users.name%Type;
3620: l_approvalProcessVersion varchar2(10);
3621: l_curr_approver_role wf_roles.name%type;
3622: c_return_user_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3623: l_curr_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3624: l_is_parallel varchar2(10) := null;
3625:
3626: begin

Line 3623: l_curr_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;

3619: c_creator_user wf_users.name%Type;
3620: l_approvalProcessVersion varchar2(10);
3621: l_curr_approver_role wf_roles.name%type;
3622: c_return_user_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3623: l_curr_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3624: l_is_parallel varchar2(10) := null;
3625:
3626: begin
3627: g_debug := hr_utility.debug_enabled;