[Home] [Help]
4191: procedure create_wf_roles (
4192: trx_id in varchar2)
4193: IS
4194: c_user_name varchar2(100);
4195: -- l_userTable WF_DIRECTORY.UserTable;
4196:
4197: CURSOR get_user_names IS
4198: select 'X'
4199: from WF_USER_ROLE_ASSIGNMENTS role
4206: IF get_user_names%NOTFOUND
4207: THEN
4208: CLOSE get_user_names;
4209:
4210: --Bug NO:6526807 Using wf_directory.AddUsersToAdHocRole2 api instead of
4211: --wf_directory.AddUsersToAdHocRole so that the application can handle
4212: -- spaces in user name
4213:
4214: -- wf_directory.AddUsersToAdHocRole(
4207: THEN
4208: CLOSE get_user_names;
4209:
4210: --Bug NO:6526807 Using wf_directory.AddUsersToAdHocRole2 api instead of
4211: --wf_directory.AddUsersToAdHocRole so that the application can handle
4212: -- spaces in user name
4213:
4214: -- wf_directory.AddUsersToAdHocRole(
4215: -- role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => c_user_name);
4210: --Bug NO:6526807 Using wf_directory.AddUsersToAdHocRole2 api instead of
4211: --wf_directory.AddUsersToAdHocRole so that the application can handle
4212: -- spaces in user name
4213:
4214: -- wf_directory.AddUsersToAdHocRole(
4215: -- role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => c_user_name);
4216:
4217: -- l_userTable(0) := c_user_name;
4218: -- wf_directory.AddUsersToAdHocRole2(
4214: -- wf_directory.AddUsersToAdHocRole(
4215: -- role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => c_user_name);
4216:
4217: -- l_userTable(0) := c_user_name;
4218: -- wf_directory.AddUsersToAdHocRole2(
4219: -- role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => l_userTable);
4220:
4221: wf_directory.AddUsersToAdHocRole(
4222: role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => c_user_name);
4217: -- l_userTable(0) := c_user_name;
4218: -- wf_directory.AddUsersToAdHocRole2(
4219: -- role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => l_userTable);
4220:
4221: wf_directory.AddUsersToAdHocRole(
4222: role_name => 'FUN_ADHOC_RECI_'||trx_id, role_users => c_user_name);
4223:
4224: END IF;
4225: