eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_DIRECTORY dependencies on WF_LOCAL_ROLES

Line 329: role_info_tbl wf_directory.wf_local_roles_tbl_type;

325: notification_preference out NOCOPY varchar2,
326: language out NOCOPY varchar2,
327: territory out NOCOPY varchar2)
328: is
329: role_info_tbl wf_directory.wf_local_roles_tbl_type;
330: begin
331: Wf_Directory.GetRoleInfo2(role, role_info_tbl);
332:
333: display_name := role_info_tbl(1).display_name;

Line 355: role_info_tbl out NOCOPY wf_directory.wf_local_roles_tbl_type)

351: -- role_info_tbl
352: --
353: procedure GetRoleInfo2(
354: role in varchar2,
355: role_info_tbl out NOCOPY wf_directory.wf_local_roles_tbl_type)
356: is
357: l_origSystem VARCHAR2(30);
358: l_origSystemID NUMBER;
359: l_isComposite BOOLEAN;

Line 445: from WF_LOCAL_ROLES R

441: R.CREATION_DATE,
442: R.CREATED_BY,
443: R.LAST_UPDATE_LOGIN
444: into role_info_tbl(1)
445: from WF_LOCAL_ROLES R
446: where R.NAME = GetRoleInfo2.role
447: and R.PARTITION_ID not in (9,8,7,6,4)
448: and nvl(R.EXPIRATION_DATE, sysdate+1) > sysdate
449: and rownum = 1;

Line 483: from WF_LOCAL_ROLES R

479: R.CREATION_DATE,
480: R.CREATED_BY,
481: R.LAST_UPDATE_LOGIN
482: into role_info_tbl(1)
483: from WF_LOCAL_ROLES R
484: where R.ORIG_SYSTEM = l_origSystem
485: and R.ORIG_SYSTEM_ID = l_origSystemID
486: and R.NAME = GetRoleInfo2.role
487: and nvl(R.EXPIRATION_DATE, sysdate+1) > sysdate

Line 651: role_info_tbl wf_directory.wf_local_roles_tbl_type;

647: orig_system out NOCOPY varchar2,
648: orig_system_id out NOCOPY number,
649: installed_flag out NOCOPY varchar2)
650: is
651: role_info_tbl wf_directory.wf_local_roles_tbl_type;
652: begin
653:
654: Wf_Directory.GetRoleInfo2(role, role_info_tbl);
655:

Line 696: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;

692: , p_nlsNumericCharacters out NOCOPY varchar2
693: , p_nlsSort out NOCOPY varchar2
694: , p_nlsCurrency out NOCOPY varchar2)
695: is
696: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
697: l_api varchar2(250) := g_plsqlName ||'GetRoleInfoMail2';
698:
699: begin
700: if( WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level ) then

Line 751: role_info_tbl wf_directory.wf_local_roles_tbl_type;

747: --
748: function GetRoleNtfPref(
749: role in varchar2) return varchar2
750: is
751: role_info_tbl wf_directory.wf_local_roles_tbl_type;
752: notification_preference varchar2(8);
753: begin
754:
755: Wf_Directory.GetRoleInfo2(role, role_info_tbl);

Line 780: role_info_tbl wf_directory.wf_local_roles_tbl_type;

776: orig_system out NOCOPY varchar2,
777: orig_system_id out NOCOPY number
778: )
779: is
780: role_info_tbl wf_directory.wf_local_roles_tbl_type;
781: begin
782: Wf_Directory.GetRoleInfo2(role, role_info_tbl);
783:
784: orig_system := role_info_tbl(1).orig_system;

Line 1094: from wf_local_roles wr, wf_local_roles_tl wrt

1090: colon pls_integer;
1091:
1092: cursor c_role (l_name in varchar2) is
1093: select substrb(nvl(wrt.display_name,wr.display_name),1,360)
1094: from wf_local_roles wr, wf_local_roles_tl wrt
1095: where wr.name = l_name
1096: and wr.orig_system = wrt.orig_system (+)
1097: and wr.orig_system_id = wrt.orig_system_id (+)
1098: and wr.name = wrt.name (+)

Line 1106: from wf_local_roles wr, wf_local_roles_tl wrt

1102:
1103: cursor corig_role (l_name in varchar2, l_origSys in varchar2,
1104: l_origSysID in number) is
1105: select substrb(nvl(wrt.display_name,wr.display_name),1,360)
1106: from wf_local_roles wr, wf_local_roles_tl wrt
1107: where wr.orig_system = l_origSys
1108: and wr.orig_system_id = l_origSysID
1109: and wr.name = l_name
1110: and wr.orig_system = wrt.orig_system (+)

Line 1193: orig_system=>'WF_LOCAL_ROLES',

1189: --
1190: -- Update Status
1191: --
1192: SetRoleAttr(role_name=>SetAdHocRoleStatus.role_name,
1193: orig_system=>'WF_LOCAL_ROLES',
1194: orig_system_id=>0,
1195: display_name=>NULL,
1196: notification_preference=>NULL,
1197: language=>NULL,

Line 1367: from WF_LOCAL_ROLES

1363: --on the stage tables, we are just performing the check.
1364: if (instr(CreateUser.name, ':') < 1) then
1365: select count(*)
1366: into l_count
1367: from WF_LOCAL_ROLES
1368: where NAME = CreateUser.name
1369: and PARTITION_ID = l_partitionID
1370: and ORIG_SYSTEM = l_origSys
1371: and ORIG_SYSTEM_ID <> CreateUser.orig_system_id;

Line 1389: -- Insert WF_LOCAL_ROLES with USER_FLAG = 'Y'

1385: l_lastupddt := nvl(CreateUser.last_update_date, SYSDATE);
1386: l_lastupdlog:= nvl(CreateUser.last_update_login, WFA_SEC.LOGIN_ID);
1387:
1388:
1389: -- Insert WF_LOCAL_ROLES with USER_FLAG = 'Y'
1390: --
1391: insert into WF_LOCAL_ROLES
1392: (name,
1393: display_name,

Line 1391: insert into WF_LOCAL_ROLES

1387:
1388:
1389: -- Insert WF_LOCAL_ROLES with USER_FLAG = 'Y'
1390: --
1391: insert into WF_LOCAL_ROLES
1392: (name,
1393: display_name,
1394: description,
1395: notification_preference,

Line 1447: insert into WF_LOCAL_ROLES_TL

1443: --If MLS language support is enabled for this orig_system
1444: --then sync the data to _TL table aswell.
1445: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE) AND
1446: (userenv('LANG') <> 'US')) then
1447: insert into WF_LOCAL_ROLES_TL
1448: ( NAME,
1449: ORIG_SYSTEM,
1450: ORIG_SYSTEM_ID,
1451: PARTITION_ID,

Line 1798: from WF_LOCAL_ROLES

1794: if (instr(CreateRole.role_name, ':') < 1) then
1795:
1796: select ORIG_SYSTEM_ID
1797: bulk collect into l_origSysIDTAB
1798: from WF_LOCAL_ROLES
1799: where NAME = CreateRole.role_name
1800: and PARTITION_ID = l_partitionID
1801: and ORIG_SYSTEM = CreateRole.orig_system
1802: and ORIG_SYSTEM_ID <> CreateRole.orig_system_id

Line 1843: -- Insert WF_LOCAL_ROLES with USER_FLAG = 'N'

1839: owner_tag=>CreateRole.owner_tag);
1840: end if;
1841: else
1842: --
1843: -- Insert WF_LOCAL_ROLES with USER_FLAG = 'N'
1844: --
1845:
1846: insert into WF_LOCAL_ROLES
1847: (name,

Line 1846: insert into WF_LOCAL_ROLES

1842: --
1843: -- Insert WF_LOCAL_ROLES with USER_FLAG = 'N'
1844: --
1845:
1846: insert into WF_LOCAL_ROLES
1847: (name,
1848: display_name,
1849: description,
1850: notification_preference,

Line 1902: insert into WF_LOCAL_ROLES_TL

1898: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE ) AND
1899: (userenv('LANG') <> 'US')) then
1900: --If the orig_system is MLS enabled then sync the dat into
1901: --the _TL table aswell.
1902: insert into WF_LOCAL_ROLES_TL
1903: ( NAME,
1904: ORIG_SYSTEM,
1905: ORIG_SYSTEM_ID,
1906: PARTITION_ID,

Line 2089: orig_system=>'WF_LOCAL_ROLES',

2085: end if;
2086:
2087: CreateRole( role_name=>CreateAdHocRole2.role_name,
2088: role_display_name=>CreateAdHocRole2.role_display_name,
2089: orig_system=>'WF_LOCAL_ROLES',
2090: orig_system_id=>0,
2091: language=>CreateAdHocRole2.language,
2092: territory=>CreateAdHocRole2.territory,
2093: role_description=>CreateAdHocRole2.role_description,

Line 2206: FROM WF_LOCAL_ROLES

2202: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID,
2203: START_DATE, EXPIRATION_DATE,PARTITION_ID
2204: INTO l_uorigSys, l_uorigSysID,
2205: l_userStartDate, l_userExpDate, l_upartID
2206: FROM WF_LOCAL_ROLES
2207: WHERE NAME = CreateUserRole.USER_NAME
2208: AND ROWNUM < 2;
2209: exception
2210: when NO_DATA_FOUND then

Line 2223: FROM WF_LOCAL_ROLES

2219: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID,
2220: START_DATE, EXPIRATION_DATE, PARTITION_ID
2221: INTO l_rorigSys, l_rorigSysID,
2222: l_roleStartDate, l_roleExpDate,l_rpartID
2223: FROM WF_LOCAL_ROLES
2224: WHERE NAME = CreateUserRole.ROLE_NAME
2225: AND ROWNUM < 2;
2226: exception
2227: when NO_DATA_FOUND then

Line 2256: FROM WF_LOCAL_ROLES

2252: AssignPartition(l_uorigSys,l_upartID, l_partitionName);
2253: end if;
2254: SELECT start_date, expiration_date
2255: into l_userStartDate, l_userExpDate
2256: FROM WF_LOCAL_ROLES
2257: WHERE NAME = CreateUserRole.user_name
2258: AND ORIG_SYSTEM = l_uorigSys
2259: AND ORIG_SYSTEM_ID = l_uorigSysID
2260: AND PARTITION_ID = l_upartID;

Line 2276: FROM WF_LOCAL_ROLES

2272: end if;
2273:
2274: SELECT start_date, expiration_date
2275: INTO l_roleStartDate, l_roleExpDate
2276: FROM WF_LOCAL_ROLES
2277: WHERE NAME = CreateUserRole.role_name
2278: AND ORIG_SYSTEM = l_rorigSys
2279: AND ORIG_SYSTEM_ID = l_rorigSysID
2280: AND PARTITION_ID = l_rpartID;

Line 2571: FROM WF_LOCAL_ROLES

2567: --Checking the user.
2568: begin
2569: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID
2570: INTO l_uorigSys, l_uorigSysID
2571: FROM WF_LOCAL_ROLES
2572: WHERE NAME = SetUserRoleAttr.user_name
2573: and rownum < 2;
2574:
2575: exception

Line 2591: FROM WF_LOCAL_ROLES

2587: --Checking the role.
2588: begin
2589: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID, PARTITION_ID
2590: INTO l_rorigSys, l_rorigSysID,l_partitionID
2591: FROM WF_LOCAL_ROLES
2592: WHERE NAME = SetUserRoleAttr.role_name
2593: AND rownum < 2;
2594:
2595: if (l_porigSys is NULL or l_porigSysID is NULL) then

Line 3073: -- from WF_LOCAL_ROLES.

3069: -- Check Duplicate
3070: -- for local table, check user name and role name are sufficient
3071: -- there will not be index on orig system and orig system id
3072: -- orig systems and orig system ids are identical among the users
3073: -- from WF_LOCAL_ROLES.
3074: --
3075:
3076: --
3077: -- Commenting out this check and catching a dup user/role exception

Line 3082: -- and ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

3078: -- select count(1) into d1
3079: -- from WF_LOCAL_USER_ROLES
3080: -- where USER_NAME = role_users(userIND)
3081: -- and ROLE_NAME = AddUsersToAdHocRole2.role_name
3082: -- and ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
3083: -- and ROLE_ORIG_SYSTEM_ID = 0;
3084:
3085: -- if (d1 > 0) then
3086: -- wf_core.token('USERNAME', role_users(userIND));

Line 3095: role_orig_system=>'WF_LOCAL_ROLES',

3091: CreateUserRole(user_name=>role_users(userIND),
3092: role_name=>AddUsersToAdHocRole2.role_name,
3093: user_orig_system=>l_orig_system,
3094: user_orig_system_id=>l_orig_system_id,
3095: role_orig_system=>'WF_LOCAL_ROLES',
3096: role_orig_system_id=>0,
3097: start_date=>sysdate,
3098: end_date=>to_date(NULL),
3099: validateUserRole=>FALSE,

Line 3188: FROM WF_LOCAL_ROLES

3184:
3185: begin
3186: SELECT START_DATE, EXPIRATION_DATE
3187: INTO l_oldStartDate, l_oldEndDate
3188: FROM WF_LOCAL_ROLES
3189: WHERE NAME = SetUserAttr.user_name
3190: AND ORIG_SYSTEM = SetUserAttr.orig_system
3191: AND ORIG_SYSTEM_ID = SetUserAttr.orig_system_id
3192: AND PARTITION_ID = l_partitionID;

Line 3208: -- Update WF_LOCAL_ROLES where user_flag = 'Y'

3204: l_lastupddt := nvl(SetUserAttr.last_update_date, SYSDATE);
3205: l_lastupdby := nvl(SetUserAttr.last_updated_by, WFA_SEC.USER_ID);
3206: l_lastupdlog := nvl(SetUserAttr.last_update_login, WFA_SEC.LOGIN_ID);
3207:
3208: -- Update WF_LOCAL_ROLES where user_flag = 'Y'
3209: --
3210: if (OverWrite) then
3211:
3212: if ((userenv('LANG') = 'US') OR

Line 3214: update WF_LOCAL_ROLES

3210: if (OverWrite) then
3211:
3212: if ((userenv('LANG') = 'US') OR
3213: (isMLSEnabled(SetUserAttr.orig_system) = FALSE)) then
3214: update WF_LOCAL_ROLES
3215: set NOTIFICATION_PREFERENCE = nvl(SetUserAttr.notification_preference,
3216: NOTIFICATION_PREFERENCE),
3217: LANGUAGE = nvl(SetUserAttr.language, LANGUAGE),
3218: TERRITORY = nvl(SetUserAttr.territory, TERRITORY),

Line 3245: update WF_LOCAL_ROLES

3241: and USER_FLAG = 'Y';
3242:
3243: else
3244:
3245: update WF_LOCAL_ROLES
3246: set NOTIFICATION_PREFERENCE = nvl(SetUserAttr.notification_preference,
3247: NOTIFICATION_PREFERENCE),
3248: LANGUAGE = nvl(SetUserAttr.language, LANGUAGE),
3249: TERRITORY = nvl(SetUserAttr.territory, TERRITORY),

Line 3272: update WF_LOCAL_ROLES_TL

3268: and USER_FLAG = 'Y';
3269:
3270:
3271: --Update the _TL table
3272: update WF_LOCAL_ROLES_TL
3273: set DISPLAY_NAME = nvl(SetUserAttr.display_name, DISPLAY_NAME),
3274: DESCRIPTION = SetUserAttr.description,
3275: -- <7298384> always keep CREATED_BY and CREATION_DATE in update
3276: -- CREATED_BY = nvl(SetUserAttr.created_by, created_by),

Line 3290: insert into WF_LOCAL_ROLES_TL (NAME,

3286:
3287: if (sql%rowcount = 0) then
3288: --No record exist for this lang in _TL table
3289: --so insert a record
3290: insert into WF_LOCAL_ROLES_TL (NAME,
3291: DISPLAY_NAME,
3292: DESCRIPTION,
3293: ORIG_SYSTEM,
3294: ORIG_SYSTEM_ID,

Line 3316: from WF_LOCAL_ROLES wu

3312: l_creatdt,
3313: l_lastupdby,
3314: l_lastupddt,
3315: l_lastupdlog
3316: from WF_LOCAL_ROLES wu
3317: where wu.NAME = SetUserAttr.user_name
3318: and wu.ORIG_SYSTEM = SetUserAttr.orig_system
3319: and wu.ORIG_SYSTEM_ID = SetUserAttr.orig_system_id
3320: and wu.PARTITION_ID = l_partitionID

Line 3330: update WF_LOCAL_ROLES

3326: end if;
3327: else
3328: if ((userenv('LANG') = 'US') OR
3329: (isMLSEnabled(SetUserAttr.orig_system) = FALSE)) then
3330: update WF_LOCAL_ROLES
3331: set NOTIFICATION_PREFERENCE = nvl(SetUserAttr.notification_preference,
3332: NOTIFICATION_PREFERENCE),
3333: LANGUAGE = nvl(SetUserAttr.language, LANGUAGE),
3334: TERRITORY = nvl(SetUserAttr.territory, TERRITORY),

Line 3360: update WF_LOCAL_ROLES

3356: and ORIG_SYSTEM_ID = SetUserAttr.orig_system_id
3357: and PARTITION_ID = l_partitionID
3358: and USER_FLAG = 'Y';
3359: else
3360: update WF_LOCAL_ROLES
3361: set NOTIFICATION_PREFERENCE = nvl(SetUserAttr.notification_preference,
3362: NOTIFICATION_PREFERENCE),
3363: LANGUAGE = nvl(SetUserAttr.language, LANGUAGE),
3364: TERRITORY = nvl(SetUserAttr.territory, TERRITORY),

Line 3388: update WF_LOCAL_ROLES_TL

3384: and PARTITION_ID = l_partitionID
3385: and USER_FLAG = 'Y';
3386:
3387: --then lets update the _TL table
3388: update WF_LOCAL_ROLES_TL
3389: set DISPLAY_NAME = nvl(SetUserAttr.display_name, DISPLAY_NAME),
3390: DESCRIPTION = SetUserAttr.description
3391: -- <7298384> no overwrite mode, so keeping previous values
3392: -- CREATED_BY = nvl(SetUserAttr.created_by, CREATED_BY),

Line 3410: insert into WF_LOCAL_ROLES_TL (NAME,

3406: --The issue is that if the passed values or param
3407: --are null we would be inserting 'US' language
3408: --display name and description
3409:
3410: insert into WF_LOCAL_ROLES_TL (NAME,
3411: DISPLAY_NAME,
3412: DESCRIPTION,
3413: ORIG_SYSTEM,
3414: ORIG_SYSTEM_ID,

Line 3436: from WF_LOCAL_ROLES

3432: l_creatdt,
3433: l_lastupdby,
3434: l_lastupddt,
3435: l_lastupdlog
3436: from WF_LOCAL_ROLES
3437: where NAME = SetUserAttr.user_name
3438: and ORIG_SYSTEM = SetUserAttr.orig_system
3439: and ORIG_SYSTEM_ID = SetUserAttr.orig_system_id
3440: and PARTITION_ID = l_partitionID

Line 3611: FROM WF_LOCAL_ROLES

3607:
3608: begin
3609: SELECT START_DATE, EXPIRATION_DATE
3610: INTO l_oldStartDate, l_oldEndDate
3611: FROM WF_LOCAL_ROLES
3612: WHERE NAME = SetRoleAttr.role_name
3613: AND ORIG_SYSTEM = SetRoleAttr.orig_system
3614: AND ORIG_SYSTEM_ID = SetRoleAttr.orig_system_id
3615: AND PARTITION_ID = l_partitionID;

Line 3632: -- Update WF_LOCAL_ROLES

3628: l_lastupddt := nvl(SetRoleAttr.last_update_date, SYSDATE);
3629: l_lastupdlog:= nvl(SetRoleAttr.last_update_login, WFA_SEC.LOGIN_ID);
3630:
3631:
3632: -- Update WF_LOCAL_ROLES
3633: --
3634: if (OverWrite) then
3635: --Update the description field and display name field
3636: --in the base table only if the session language is 'US'

Line 3641: update WF_LOCAL_ROLES

3637: --Else update theses values for the _TL table and keep the
3638: --base table values same
3639: if ((userenv('LANG') = 'US') OR
3640: (isMLSEnabled(SetRoleAttr.orig_system) = FALSE)) then
3641: update WF_LOCAL_ROLES
3642: set NOTIFICATION_PREFERENCE = nvl(SetRoleAttr.notification_preference,
3643: NOTIFICATION_PREFERENCE),
3644: LANGUAGE = nvl(SetRoleAttr.language, LANGUAGE),
3645: TERRITORY = nvl(SetRoleAttr.territory, TERRITORY),

Line 3681: update WF_LOCAL_ROLES

3677: WF_CORE.Raise('WF_INVALID_ROLE');
3678: end if;
3679:
3680: else
3681: update WF_LOCAL_ROLES
3682: set NOTIFICATION_PREFERENCE = nvl(SetRoleAttr.notification_preference,
3683: NOTIFICATION_PREFERENCE),
3684: LANGUAGE = nvl(SetRoleAttr.language, LANGUAGE),
3685: TERRITORY = nvl(SetRoleAttr.territory, TERRITORY),

Line 3718: update WF_LOCAL_ROLES_TL

3714: end if;
3715:
3716: --Update the _TL table for the display_name and
3717: --description
3718: update WF_LOCAL_ROLES_TL
3719: set DISPLAY_NAME = nvl(SetRoleAttr.display_name,
3720: DISPLAY_NAME),
3721: DESCRIPTION = SetRoleAttr.description,
3722: OWNER_TAG = nvl(SetRoleAttr.owner_tag,

Line 3746: insert into WF_LOCAL_ROLES_TL (NAME,

3742: --are null we would be inserting 'US' language
3743: --display name as its non-nullable was max we can do is to
3744: --add a 'NON_TRANSLATED' string or something to recognize.
3745:
3746: insert into WF_LOCAL_ROLES_TL (NAME,
3747: DISPLAY_NAME,
3748: DESCRIPTION,
3749: ORIG_SYSTEM,
3750: ORIG_SYSTEM_ID,

Line 3772: from WF_LOCAL_ROLES

3768: l_creatdt,
3769: l_lastupdby,
3770: l_lastupddt,
3771: l_lastupdlog
3772: from WF_LOCAL_ROLES
3773: where NAME = role_name
3774: and ORIG_SYSTEM = SetRoleAttr.orig_system
3775: and ORIG_SYSTEM_ID = SetRoleAttr.orig_system_id
3776: and PARTITION_ID = l_partitionID);

Line 3787: update WF_LOCAL_ROLES

3783: end if;
3784: else --(NOT overWrite)
3785: if ((userenv('LANG') = 'US') OR
3786: (wf_directory.isMLSEnabled(SetRoleAttr.orig_system) = FALSE)) then
3787: update WF_LOCAL_ROLES
3788: set NOTIFICATION_PREFERENCE = nvl(SetRoleAttr.notification_preference,
3789: NOTIFICATION_PREFERENCE),
3790: LANGUAGE = nvl(SetRoleAttr.language, LANGUAGE),
3791: TERRITORY = nvl(SetRoleAttr.territory, TERRITORY),

Line 3829: update WF_LOCAL_ROLES

3825: WF_CORE.Raise('WF_INVALID_ROLE');
3826: end if;
3827:
3828: else
3829: update WF_LOCAL_ROLES
3830: set NOTIFICATION_PREFERENCE = nvl(SetRoleAttr.notification_preference,
3831: NOTIFICATION_PREFERENCE),
3832: LANGUAGE = nvl(SetRoleAttr.language, LANGUAGE),
3833: TERRITORY = nvl(SetRoleAttr.territory, TERRITORY),

Line 3868: update WF_LOCAL_ROLES_TL

3864: end if;
3865:
3866: --Update the _TL table for the display_name and
3867: --description
3868: update WF_LOCAL_ROLES_TL
3869: set DISPLAY_NAME = nvl(SetRoleAttr.display_name,
3870: DISPLAY_NAME),
3871: DESCRIPTION = nvl(SetRoleAttr.description,DESCRIPTION),
3872: OWNER_TAG = nvl(SetRoleAttr.owner_tag,

Line 3895: insert into WF_LOCAL_ROLES_TL (NAME,

3891: --The issue is that if the passed values or param
3892: --are null we would be inserting 'US' language
3893: --display name as its non-nullable
3894:
3895: insert into WF_LOCAL_ROLES_TL (NAME,
3896: DISPLAY_NAME,
3897: DESCRIPTION,
3898: ORIG_SYSTEM,
3899: ORIG_SYSTEM_ID,

Line 3921: from WF_LOCAL_ROLES

3917: l_creatdt,
3918: l_lastupdby,
3919: l_lastupddt,
3920: l_lastupdlog
3921: from WF_LOCAL_ROLES
3922: where NAME = SetRoleAttr.role_name
3923: and ORIG_SYSTEM = SetRoleAttr.orig_system
3924: and ORIG_SYSTEM_ID = SetRoleAttr.orig_system_id
3925: and PARTITION_ID = l_partitionID);

Line 4072: orig_system=>'WF_LOCAL_ROLES',

4068: --
4069: -- Update Expiration Date
4070: --
4071: SetRoleAttr(role_name=>SetAdHocRoleExpiration.role_name,
4072: orig_system=>'WF_LOCAL_ROLES',
4073: orig_system_id=>0,
4074: display_name=>NULL,
4075: notification_preference=>NULL,
4076: language=>NULL,

Line 4169: orig_system=>'WF_LOCAL_ROLES',

4165: --
4166: -- Update the role
4167: --
4168: SetRoleAttr(role_name=>SetAdHocRoleAttr.role_name,
4169: orig_system=>'WF_LOCAL_ROLES',
4170: orig_system_id=>0,
4171: display_name=>SetAdHocRoleAttr.display_name,
4172: notification_preference=>SetAdHocRoleAttr.notification_preference,
4173: language=>SetAdHocRoleAttr.language,

Line 4210: and UR.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

4206: -- Delete all users
4207: begin
4208: delete from WF_LOCAL_USER_ROLES UR
4209: where UR.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4210: and UR.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4211: and UR.ROLE_ORIG_SYSTEM_ID = 0
4212: and UR.PARTITION_ID = 0;
4213:
4214: --delete from WF_USER_ROLE_ASSIGNMENTS as well

Line 4217: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

4213:
4214: --delete from WF_USER_ROLE_ASSIGNMENTS as well
4215: delete from WF_USER_ROLE_ASSIGNMENTS URA
4216: where URA.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4217: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4218: and URA.ROLE_ORIG_SYSTEM_ID = 0
4219: and URA.PARTITION_ID = 0;
4220: end;
4221: else

Line 4243: and UR.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

4239: -- Delete
4240: delete from WF_LOCAL_USER_ROLES UR
4241: where UR.USER_NAME = user
4242: and UR.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4243: and UR.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4244: and UR.ROLE_ORIG_SYSTEM_ID = 0
4245: and UR.PARTITION_ID = 0;
4246: if (sql%rowcount = 0) then
4247: wf_core.token('USERNAME', user);

Line 4255: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

4251: -- Delete from wf_user_role_Assignments as well
4252: delete from WF_USER_ROLE_ASSIGNMENTS URA
4253: where URA.USER_NAME = user
4254: and URA.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4255: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4256: and URA.ROLE_ORIG_SYSTEM_ID = 0
4257: and URA.PARTITION_ID = 0;
4258: exit when (c1 = 0);
4259:

Line 4274: -- Change a User's Name in the WF_LOCAL_ROLES table.

4270:
4271:
4272: --
4273: -- ChangeLocalUserName
4274: -- Change a User's Name in the WF_LOCAL_ROLES table.
4275: -- IN
4276: -- OldName
4277: -- NewName
4278: -- Propagate - call WF_MAINTENANCE.PropagateChangedName

Line 4504: WHERE ORIG_SYSTEM = 'WF_LOCAL_ROLES';

4500: begin
4501: SELECT Partition_ID, orig_system
4502: INTO g_localPartitionID, g_localPartitionName
4503: FROM WF_DIRECTORY_PARTITIONS
4504: WHERE ORIG_SYSTEM = 'WF_LOCAL_ROLES';
4505:
4506: exception
4507: when NO_DATA_FOUND then
4508: g_localPartitionID := 0;

Line 4509: g_localPartitionName := 'WF_LOCAL_ROLES';

4505:
4506: exception
4507: when NO_DATA_FOUND then
4508: g_localPartitionID := 0;
4509: g_localPartitionName := 'WF_LOCAL_ROLES';
4510:
4511: end;
4512: end if;
4513:

Line 4641: * not currently stored in wf_local_roles table.

4637: * Fetches role information when the e-mail address is given.
4638: * Added other parameters for full NLS support -phase 1-, bug 7578908
4639: *
4640: * In phase 1, we only use constant default values for NLS parameters
4641: * not currently stored in wf_local_roles table.
4642: */
4643: procedure GetInfoFromMail2( p_emailid in varchar2
4644: , p_role out NOCOPY varchar2,
4645: p_display_name out NOCOPY varchar2,

Line 4851: delete from wf_local_roles

4847: WF_CORE.Raise('WFDS_ROLE_ACTIVE');
4848: exception
4849: when no_data_found then
4850:
4851: delete from wf_local_roles
4852: where name=p_name
4853: and orig_system=p_origSystem
4854: and orig_system_id=p_origSystemId
4855: and partition_id =l_partitionID

Line 4948: where exists (select null from wf_local_roles

4944: -- check whether the role is end-dated
4945:
4946: select 1 into l_count
4947: from SYS.DUAL
4948: where exists (select null from wf_local_roles
4949: where name=p_rolename)
4950: and ( exists (select null from wf_user_roles
4951: where role_name=p_rolename
4952: )

Line 4996: where exists (select null from wf_local_roles

4992: begin
4993: --check whether user is truly end dated
4994: select 1 into l_count
4995: from SYS.DUAL
4996: where exists (select null from wf_local_roles
4997: where name=p_username)
4998: and ( exists (select null from wf_user_roles
4999: where user_name=p_username
5000: )

Line 5040: where exists (select null from wf_local_roles

5036: --check whether user/role is truly end dated
5037:
5038: select 1 into l_count
5039: from SYS.DUAL
5040: where exists (select null from wf_local_roles
5041: where name=p_rolename or name=p_username)
5042: and ( exists (select null from wf_user_roles
5043: where role_name=p_rolename
5044: and user_name=p_username