3796: procedure create_wf_roles (
3797: trx_id in varchar2)
3798: IS
3799: c_user_name varchar2(100);
3800: -- l_userTable WF_DIRECTORY.UserTable;
3801:
3802: CURSOR get_user_names IS
3803: select 'X'
3804: from wf_local_user_roles role
3811: IF get_user_names%NOTFOUND
3812: THEN
3813: CLOSE get_user_names;
3814:
3815: --Bug NO:6526807 Using wf_directory.AddUsersToAdHocRole2 api instead of
3816: --wf_directory.AddUsersToAdHocRole so that the application can handle
3817: -- spaces in user name
3818:
3819: -- wf_directory.AddUsersToAdHocRole(
3812: THEN
3813: CLOSE get_user_names;
3814:
3815: --Bug NO:6526807 Using wf_directory.AddUsersToAdHocRole2 api instead of
3816: --wf_directory.AddUsersToAdHocRole so that the application can handle
3817: -- spaces in user name
3818:
3819: -- wf_directory.AddUsersToAdHocRole(
3820: -- role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => c_user_name);
3815: --Bug NO:6526807 Using wf_directory.AddUsersToAdHocRole2 api instead of
3816: --wf_directory.AddUsersToAdHocRole so that the application can handle
3817: -- spaces in user name
3818:
3819: -- wf_directory.AddUsersToAdHocRole(
3820: -- role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => c_user_name);
3821:
3822: -- l_userTable(0) := c_user_name;
3823: -- wf_directory.AddUsersToAdHocRole2(
3819: -- wf_directory.AddUsersToAdHocRole(
3820: -- role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => c_user_name);
3821:
3822: -- l_userTable(0) := c_user_name;
3823: -- wf_directory.AddUsersToAdHocRole2(
3824: -- role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => l_userTable);
3825:
3826: wf_directory.AddUsersToAdHocRole(
3827: role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => c_user_name);
3822: -- l_userTable(0) := c_user_name;
3823: -- wf_directory.AddUsersToAdHocRole2(
3824: -- role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => l_userTable);
3825:
3826: wf_directory.AddUsersToAdHocRole(
3827: role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => c_user_name);
3828:
3829: END IF;
3830: