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 819: from wf_local_roles

815:
816: if not l_is_composite then
817: select partition_id, orig_system
818: into GetRolePartitionInfo.partition_id, GetRolePartitionInfo.orig_system
819: from wf_local_roles
820: where name = GetRolePartitionInfo.role
821: and nvl(expiration_date, sysdate+1) > sysdate
822: and rownum = 1;
823: else

Line 826: from wf_local_roles

822: and rownum = 1;
823: else
824: select partition_id, orig_system
825: into GetRolePartitionInfo.partition_id, GetRolePartitionInfo.orig_system
826: from wf_local_roles
827: where name = GetRolePartitionInfo.role
828: and orig_system =l_orig_system
829: and orig_system_id = l_orig_system_id
830: and nvl(expiration_date, sysdate+1) > sysdate

Line 1236: from wf_local_roles wr, wf_local_roles_tl wrt

1232: colon pls_integer;
1233:
1234: cursor c_role (l_name in varchar2) is
1235: select substrb(nvl(wrt.display_name,wr.display_name),1,360)
1236: from wf_local_roles wr, wf_local_roles_tl wrt
1237: where wr.name = l_name
1238: and wr.orig_system = wrt.orig_system (+)
1239: and wr.orig_system_id = wrt.orig_system_id (+)
1240: and wr.name = wrt.name (+)

Line 1248: from wf_local_roles wr, wf_local_roles_tl wrt

1244:
1245: cursor corig_role (l_name in varchar2, l_origSys in varchar2,
1246: l_origSysID in number) is
1247: select substrb(nvl(wrt.display_name,wr.display_name),1,360)
1248: from wf_local_roles wr, wf_local_roles_tl wrt
1249: where wr.orig_system = l_origSys
1250: and wr.orig_system_id = l_origSysID
1251: and wr.name = l_name
1252: and wr.orig_system = wrt.orig_system (+)

Line 1335: orig_system=>'WF_LOCAL_ROLES',

1331: --
1332: -- Update Status
1333: --
1334: SetRoleAttr(role_name=>SetAdHocRoleStatus.role_name,
1335: orig_system=>'WF_LOCAL_ROLES',
1336: orig_system_id=>0,
1337: display_name=>NULL,
1338: notification_preference=>NULL,
1339: language=>NULL,

Line 1509: from WF_LOCAL_ROLES

1505: --on the stage tables, we are just performing the check.
1506: if (instr(CreateUser.name, ':') < 1) then
1507: select count(*)
1508: into l_count
1509: from WF_LOCAL_ROLES
1510: where NAME = CreateUser.name
1511: and PARTITION_ID = l_partitionID
1512: and ORIG_SYSTEM = l_origSys
1513: and ORIG_SYSTEM_ID <> CreateUser.orig_system_id;

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

1527: l_lastupddt := nvl(CreateUser.last_update_date, SYSDATE);
1528: l_lastupdlog:= nvl(CreateUser.last_update_login, WFA_SEC.LOGIN_ID);
1529:
1530:
1531: -- Insert WF_LOCAL_ROLES with USER_FLAG = 'Y'
1532: --
1533: insert into WF_LOCAL_ROLES
1534: (name,
1535: display_name,

Line 1533: insert into WF_LOCAL_ROLES

1529:
1530:
1531: -- Insert WF_LOCAL_ROLES with USER_FLAG = 'Y'
1532: --
1533: insert into WF_LOCAL_ROLES
1534: (name,
1535: display_name,
1536: description,
1537: notification_preference,

Line 1589: insert into WF_LOCAL_ROLES_TL

1585: --If MLS language support is enabled for this orig_system
1586: --then sync the data to _TL table aswell.
1587: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE) AND
1588: (userenv('LANG') <> 'US')) then
1589: insert into WF_LOCAL_ROLES_TL
1590: ( NAME,
1591: ORIG_SYSTEM,
1592: ORIG_SYSTEM_ID,
1593: PARTITION_ID,

Line 1940: from WF_LOCAL_ROLES

1936: if (instr(CreateRole.role_name, ':') < 1) then
1937:
1938: select ORIG_SYSTEM_ID
1939: bulk collect into l_origSysIDTAB
1940: from WF_LOCAL_ROLES
1941: where NAME = CreateRole.role_name
1942: and PARTITION_ID = l_partitionID
1943: and ORIG_SYSTEM = CreateRole.orig_system
1944: and ORIG_SYSTEM_ID <> CreateRole.orig_system_id

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

1981: owner_tag=>CreateRole.owner_tag);
1982: end if;
1983: else
1984: --
1985: -- Insert WF_LOCAL_ROLES with USER_FLAG = 'N'
1986: --
1987:
1988: insert into WF_LOCAL_ROLES
1989: (name,

Line 1988: insert into WF_LOCAL_ROLES

1984: --
1985: -- Insert WF_LOCAL_ROLES with USER_FLAG = 'N'
1986: --
1987:
1988: insert into WF_LOCAL_ROLES
1989: (name,
1990: display_name,
1991: description,
1992: notification_preference,

Line 2044: insert into WF_LOCAL_ROLES_TL

2040: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE ) AND
2041: (userenv('LANG') <> 'US')) then
2042: --If the orig_system is MLS enabled then sync the dat into
2043: --the _TL table aswell.
2044: insert into WF_LOCAL_ROLES_TL
2045: ( NAME,
2046: ORIG_SYSTEM,
2047: ORIG_SYSTEM_ID,
2048: PARTITION_ID,

Line 2231: orig_system=>'WF_LOCAL_ROLES',

2227: end if;
2228:
2229: CreateRole( role_name=>CreateAdHocRole2.role_name,
2230: role_display_name=>CreateAdHocRole2.role_display_name,
2231: orig_system=>'WF_LOCAL_ROLES',
2232: orig_system_id=>0,
2233: language=>CreateAdHocRole2.language,
2234: territory=>CreateAdHocRole2.territory,
2235: role_description=>CreateAdHocRole2.role_description,

Line 2348: FROM WF_LOCAL_ROLES

2344: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID,
2345: START_DATE, EXPIRATION_DATE,PARTITION_ID
2346: INTO l_uorigSys, l_uorigSysID,
2347: l_userStartDate, l_userExpDate, l_upartID
2348: FROM WF_LOCAL_ROLES
2349: WHERE NAME = CreateUserRole.USER_NAME
2350: AND ROWNUM < 2;
2351: exception
2352: when NO_DATA_FOUND then

Line 2365: FROM WF_LOCAL_ROLES

2361: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID,
2362: START_DATE, EXPIRATION_DATE, PARTITION_ID
2363: INTO l_rorigSys, l_rorigSysID,
2364: l_roleStartDate, l_roleExpDate,l_rpartID
2365: FROM WF_LOCAL_ROLES
2366: WHERE NAME = CreateUserRole.ROLE_NAME
2367: AND ROWNUM < 2;
2368: exception
2369: when NO_DATA_FOUND then

Line 2398: FROM WF_LOCAL_ROLES

2394: AssignPartition(l_uorigSys,l_upartID, l_partitionName);
2395: end if;
2396: SELECT start_date, expiration_date
2397: into l_userStartDate, l_userExpDate
2398: FROM WF_LOCAL_ROLES
2399: WHERE NAME = CreateUserRole.user_name
2400: AND ORIG_SYSTEM = l_uorigSys
2401: AND ORIG_SYSTEM_ID = l_uorigSysID
2402: AND PARTITION_ID = l_upartID;

Line 2418: FROM WF_LOCAL_ROLES

2414: end if;
2415:
2416: SELECT start_date, expiration_date
2417: INTO l_roleStartDate, l_roleExpDate
2418: FROM WF_LOCAL_ROLES
2419: WHERE NAME = CreateUserRole.role_name
2420: AND ORIG_SYSTEM = l_rorigSys
2421: AND ORIG_SYSTEM_ID = l_rorigSysID
2422: AND PARTITION_ID = l_rpartID;

Line 2713: FROM WF_LOCAL_ROLES

2709: --Checking the user.
2710: begin
2711: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID
2712: INTO l_uorigSys, l_uorigSysID
2713: FROM WF_LOCAL_ROLES
2714: WHERE NAME = SetUserRoleAttr.user_name
2715: and rownum < 2;
2716:
2717: exception

Line 2733: FROM WF_LOCAL_ROLES

2729: --Checking the role.
2730: begin
2731: SELECT ORIG_SYSTEM, ORIG_SYSTEM_ID, PARTITION_ID
2732: INTO l_rorigSys, l_rorigSysID,l_partitionID
2733: FROM WF_LOCAL_ROLES
2734: WHERE NAME = SetUserRoleAttr.role_name
2735: AND rownum < 2;
2736:
2737: if (l_porigSys is NULL or l_porigSysID is NULL) then

Line 3221: -- from WF_LOCAL_ROLES.

3217: -- Check Duplicate
3218: -- for local table, check user name and role name are sufficient
3219: -- there will not be index on orig system and orig system id
3220: -- orig systems and orig system ids are identical among the users
3221: -- from WF_LOCAL_ROLES.
3222: --
3223:
3224: --
3225: -- Commenting out this check and catching a dup user/role exception

Line 3230: -- and ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

3226: -- select count(1) into d1
3227: -- from WF_LOCAL_USER_ROLES
3228: -- where USER_NAME = role_users(userIND)
3229: -- and ROLE_NAME = AddUsersToAdHocRole2.role_name
3230: -- and ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
3231: -- and ROLE_ORIG_SYSTEM_ID = 0;
3232:
3233: -- if (d1 > 0) then
3234: -- wf_core.token('USERNAME', role_users(userIND));

Line 3243: role_orig_system=>'WF_LOCAL_ROLES',

3239: CreateUserRole(user_name=>role_users(userIND),
3240: role_name=>AddUsersToAdHocRole2.role_name,
3241: user_orig_system=>l_orig_system,
3242: user_orig_system_id=>l_orig_system_id,
3243: role_orig_system=>'WF_LOCAL_ROLES',
3244: role_orig_system_id=>0,
3245: start_date=>sysdate,
3246: end_date=>to_date(NULL),
3247: validateUserRole=>FALSE,

Line 3336: FROM WF_LOCAL_ROLES

3332:
3333: begin
3334: SELECT START_DATE, EXPIRATION_DATE
3335: INTO l_oldStartDate, l_oldEndDate
3336: FROM WF_LOCAL_ROLES
3337: WHERE NAME = SetUserAttr.user_name
3338: AND ORIG_SYSTEM = SetUserAttr.orig_system
3339: AND ORIG_SYSTEM_ID = SetUserAttr.orig_system_id
3340: AND PARTITION_ID = l_partitionID;

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

3352: l_lastupddt := nvl(SetUserAttr.last_update_date, SYSDATE);
3353: l_lastupdby := nvl(SetUserAttr.last_updated_by, WFA_SEC.USER_ID);
3354: l_lastupdlog := nvl(SetUserAttr.last_update_login, WFA_SEC.LOGIN_ID);
3355:
3356: -- Update WF_LOCAL_ROLES where user_flag = 'Y'
3357: --
3358: if (OverWrite) then
3359:
3360: if ((userenv('LANG') = 'US') OR

Line 3362: update WF_LOCAL_ROLES

3358: if (OverWrite) then
3359:
3360: if ((userenv('LANG') = 'US') OR
3361: (isMLSEnabled(SetUserAttr.orig_system) = FALSE)) then
3362: update WF_LOCAL_ROLES
3363: set NOTIFICATION_PREFERENCE = nvl(SetUserAttr.notification_preference,
3364: NOTIFICATION_PREFERENCE),
3365: LANGUAGE = nvl(SetUserAttr.language, LANGUAGE),
3366: TERRITORY = nvl(SetUserAttr.territory, TERRITORY),

Line 3393: update WF_LOCAL_ROLES

3389: and USER_FLAG = 'Y';
3390:
3391: else
3392:
3393: update WF_LOCAL_ROLES
3394: set NOTIFICATION_PREFERENCE = nvl(SetUserAttr.notification_preference,
3395: NOTIFICATION_PREFERENCE),
3396: LANGUAGE = nvl(SetUserAttr.language, LANGUAGE),
3397: TERRITORY = nvl(SetUserAttr.territory, TERRITORY),

Line 3420: update WF_LOCAL_ROLES_TL

3416: and USER_FLAG = 'Y';
3417:
3418:
3419: --Update the _TL table
3420: update WF_LOCAL_ROLES_TL
3421: set DISPLAY_NAME = nvl(SetUserAttr.display_name, DISPLAY_NAME),
3422: DESCRIPTION = SetUserAttr.description,
3423: -- <7298384> always keep CREATED_BY and CREATION_DATE in update
3424: -- CREATED_BY = nvl(SetUserAttr.created_by, created_by),

Line 3438: insert into WF_LOCAL_ROLES_TL (NAME,

3434:
3435: if (sql%rowcount = 0) then
3436: --No record exist for this lang in _TL table
3437: --so insert a record
3438: insert into WF_LOCAL_ROLES_TL (NAME,
3439: DISPLAY_NAME,
3440: DESCRIPTION,
3441: ORIG_SYSTEM,
3442: ORIG_SYSTEM_ID,

Line 3464: from WF_LOCAL_ROLES wu

3460: l_creatdt,
3461: l_lastupdby,
3462: l_lastupddt,
3463: l_lastupdlog
3464: from WF_LOCAL_ROLES wu
3465: where wu.NAME = SetUserAttr.user_name
3466: and wu.ORIG_SYSTEM = SetUserAttr.orig_system
3467: and wu.ORIG_SYSTEM_ID = SetUserAttr.orig_system_id
3468: and wu.PARTITION_ID = l_partitionID

Line 3478: update WF_LOCAL_ROLES

3474: end if;
3475: else
3476: if ((userenv('LANG') = 'US') OR
3477: (isMLSEnabled(SetUserAttr.orig_system) = FALSE)) then
3478: update WF_LOCAL_ROLES
3479: set NOTIFICATION_PREFERENCE = nvl(SetUserAttr.notification_preference,
3480: NOTIFICATION_PREFERENCE),
3481: LANGUAGE = nvl(SetUserAttr.language, LANGUAGE),
3482: TERRITORY = nvl(SetUserAttr.territory, TERRITORY),

Line 3508: update WF_LOCAL_ROLES

3504: and ORIG_SYSTEM_ID = SetUserAttr.orig_system_id
3505: and PARTITION_ID = l_partitionID
3506: and USER_FLAG = 'Y';
3507: else
3508: update WF_LOCAL_ROLES
3509: set NOTIFICATION_PREFERENCE = nvl(SetUserAttr.notification_preference,
3510: NOTIFICATION_PREFERENCE),
3511: LANGUAGE = nvl(SetUserAttr.language, LANGUAGE),
3512: TERRITORY = nvl(SetUserAttr.territory, TERRITORY),

Line 3536: update WF_LOCAL_ROLES_TL

3532: and PARTITION_ID = l_partitionID
3533: and USER_FLAG = 'Y';
3534:
3535: --then lets update the _TL table
3536: update WF_LOCAL_ROLES_TL
3537: set DISPLAY_NAME = nvl(SetUserAttr.display_name, DISPLAY_NAME),
3538: DESCRIPTION = SetUserAttr.description
3539: -- <7298384> no overwrite mode, so keeping previous values
3540: -- CREATED_BY = nvl(SetUserAttr.created_by, CREATED_BY),

Line 3558: insert into WF_LOCAL_ROLES_TL (NAME,

3554: --The issue is that if the passed values or param
3555: --are null we would be inserting 'US' language
3556: --display name and description
3557:
3558: insert into WF_LOCAL_ROLES_TL (NAME,
3559: DISPLAY_NAME,
3560: DESCRIPTION,
3561: ORIG_SYSTEM,
3562: ORIG_SYSTEM_ID,

Line 3584: from WF_LOCAL_ROLES

3580: l_creatdt,
3581: l_lastupdby,
3582: l_lastupddt,
3583: l_lastupdlog
3584: from WF_LOCAL_ROLES
3585: where NAME = SetUserAttr.user_name
3586: and ORIG_SYSTEM = SetUserAttr.orig_system
3587: and ORIG_SYSTEM_ID = SetUserAttr.orig_system_id
3588: and PARTITION_ID = l_partitionID

Line 3759: FROM WF_LOCAL_ROLES

3755:
3756: begin
3757: SELECT START_DATE, EXPIRATION_DATE
3758: INTO l_oldStartDate, l_oldEndDate
3759: FROM WF_LOCAL_ROLES
3760: WHERE NAME = SetRoleAttr.role_name
3761: AND ORIG_SYSTEM = SetRoleAttr.orig_system
3762: AND ORIG_SYSTEM_ID = SetRoleAttr.orig_system_id
3763: AND PARTITION_ID = l_partitionID;

Line 3780: -- Update WF_LOCAL_ROLES

3776: l_lastupddt := nvl(SetRoleAttr.last_update_date, SYSDATE);
3777: l_lastupdlog:= nvl(SetRoleAttr.last_update_login, WFA_SEC.LOGIN_ID);
3778:
3779:
3780: -- Update WF_LOCAL_ROLES
3781: --
3782: if (OverWrite) then
3783: --Update the description field and display name field
3784: --in the base table only if the session language is 'US'

Line 3789: update WF_LOCAL_ROLES

3785: --Else update theses values for the _TL table and keep the
3786: --base table values same
3787: if ((userenv('LANG') = 'US') OR
3788: (isMLSEnabled(SetRoleAttr.orig_system) = FALSE)) then
3789: update WF_LOCAL_ROLES
3790: set NOTIFICATION_PREFERENCE = nvl(SetRoleAttr.notification_preference,
3791: NOTIFICATION_PREFERENCE),
3792: LANGUAGE = nvl(SetRoleAttr.language, LANGUAGE),
3793: 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 3866: update WF_LOCAL_ROLES_TL

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

Line 3894: insert into WF_LOCAL_ROLES_TL (NAME,

3890: --are null we would be inserting 'US' language
3891: --display name as its non-nullable was max we can do is to
3892: --add a 'NON_TRANSLATED' string or something to recognize.
3893:
3894: insert into WF_LOCAL_ROLES_TL (NAME,
3895: DISPLAY_NAME,
3896: DESCRIPTION,
3897: ORIG_SYSTEM,
3898: ORIG_SYSTEM_ID,

Line 3920: from WF_LOCAL_ROLES

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

Line 3935: update WF_LOCAL_ROLES

3931: end if;
3932: else --(NOT overWrite)
3933: if ((userenv('LANG') = 'US') OR
3934: (wf_directory.isMLSEnabled(SetRoleAttr.orig_system) = FALSE)) then
3935: update WF_LOCAL_ROLES
3936: set NOTIFICATION_PREFERENCE = nvl(SetRoleAttr.notification_preference,
3937: NOTIFICATION_PREFERENCE),
3938: LANGUAGE = nvl(SetRoleAttr.language, LANGUAGE),
3939: TERRITORY = nvl(SetRoleAttr.territory, TERRITORY),

Line 3977: update WF_LOCAL_ROLES

3973: WF_CORE.Raise('WF_INVALID_ROLE');
3974: end if;
3975:
3976: else
3977: update WF_LOCAL_ROLES
3978: set NOTIFICATION_PREFERENCE = nvl(SetRoleAttr.notification_preference,
3979: NOTIFICATION_PREFERENCE),
3980: LANGUAGE = nvl(SetRoleAttr.language, LANGUAGE),
3981: TERRITORY = nvl(SetRoleAttr.territory, TERRITORY),

Line 4016: update WF_LOCAL_ROLES_TL

4012: end if;
4013:
4014: --Update the _TL table for the display_name and
4015: --description
4016: update WF_LOCAL_ROLES_TL
4017: set DISPLAY_NAME = nvl(SetRoleAttr.display_name,
4018: DISPLAY_NAME),
4019: DESCRIPTION = nvl(SetRoleAttr.description,DESCRIPTION),
4020: OWNER_TAG = nvl(SetRoleAttr.owner_tag,

Line 4043: insert into WF_LOCAL_ROLES_TL (NAME,

4039: --The issue is that if the passed values or param
4040: --are null we would be inserting 'US' language
4041: --display name as its non-nullable
4042:
4043: insert into WF_LOCAL_ROLES_TL (NAME,
4044: DISPLAY_NAME,
4045: DESCRIPTION,
4046: ORIG_SYSTEM,
4047: ORIG_SYSTEM_ID,

Line 4069: from WF_LOCAL_ROLES

4065: l_creatdt,
4066: l_lastupdby,
4067: l_lastupddt,
4068: l_lastupdlog
4069: from WF_LOCAL_ROLES
4070: where NAME = SetRoleAttr.role_name
4071: and ORIG_SYSTEM = SetRoleAttr.orig_system
4072: and ORIG_SYSTEM_ID = SetRoleAttr.orig_system_id
4073: and PARTITION_ID = l_partitionID);

Line 4220: orig_system=>'WF_LOCAL_ROLES',

4216: --
4217: -- Update Expiration Date
4218: --
4219: SetRoleAttr(role_name=>SetAdHocRoleExpiration.role_name,
4220: orig_system=>'WF_LOCAL_ROLES',
4221: orig_system_id=>0,
4222: display_name=>NULL,
4223: notification_preference=>NULL,
4224: language=>NULL,

Line 4317: orig_system=>'WF_LOCAL_ROLES',

4313: --
4314: -- Update the role
4315: --
4316: SetRoleAttr(role_name=>SetAdHocRoleAttr.role_name,
4317: orig_system=>'WF_LOCAL_ROLES',
4318: orig_system_id=>0,
4319: display_name=>SetAdHocRoleAttr.display_name,
4320: notification_preference=>SetAdHocRoleAttr.notification_preference,
4321: language=>SetAdHocRoleAttr.language,

Line 4358: and UR.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

4354: -- Delete all users
4355: begin
4356: delete from WF_LOCAL_USER_ROLES UR
4357: where UR.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4358: and UR.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4359: and UR.ROLE_ORIG_SYSTEM_ID = 0
4360: and UR.PARTITION_ID = 0;
4361:
4362: --delete from WF_USER_ROLE_ASSIGNMENTS as well

Line 4365: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

4361:
4362: --delete from WF_USER_ROLE_ASSIGNMENTS as well
4363: delete from WF_USER_ROLE_ASSIGNMENTS URA
4364: where URA.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4365: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4366: and URA.ROLE_ORIG_SYSTEM_ID = 0
4367: and URA.PARTITION_ID = 0;
4368: end;
4369: else

Line 4391: and UR.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

4387: -- Delete
4388: delete from WF_LOCAL_USER_ROLES UR
4389: where UR.USER_NAME = user
4390: and UR.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4391: and UR.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4392: and UR.ROLE_ORIG_SYSTEM_ID = 0
4393: and UR.PARTITION_ID = 0;
4394: if (sql%rowcount = 0) then
4395: wf_core.token('USERNAME', user);

Line 4403: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

4399: -- Delete from wf_user_role_Assignments as well
4400: delete from WF_USER_ROLE_ASSIGNMENTS URA
4401: where URA.USER_NAME = user
4402: and URA.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4403: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4404: and URA.ROLE_ORIG_SYSTEM_ID = 0
4405: and URA.PARTITION_ID = 0;
4406: exit when (c1 = 0);
4407:

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

4418:
4419:
4420: --
4421: -- ChangeLocalUserName
4422: -- Change a User's Name in the WF_LOCAL_ROLES table.
4423: -- IN
4424: -- OldName
4425: -- NewName
4426: -- Propagate - call WF_MAINTENANCE.PropagateChangedName

Line 4654: WHERE ORIG_SYSTEM = 'WF_LOCAL_ROLES';

4650: begin
4651: SELECT Partition_ID, orig_system
4652: INTO g_localPartitionID, g_localPartitionName
4653: FROM WF_DIRECTORY_PARTITIONS
4654: WHERE ORIG_SYSTEM = 'WF_LOCAL_ROLES';
4655:
4656: exception
4657: when NO_DATA_FOUND then
4658: g_localPartitionID := 0;

Line 4659: g_localPartitionName := 'WF_LOCAL_ROLES';

4655:
4656: exception
4657: when NO_DATA_FOUND then
4658: g_localPartitionID := 0;
4659: g_localPartitionName := 'WF_LOCAL_ROLES';
4660:
4661: end;
4662: end if;
4663:

Line 4778: * not currently stored in wf_local_roles table.

4774: * Fetches role information when the e-mail address is given.
4775: * Added other parameters for full NLS support -phase 1-, bug 7578908
4776: *
4777: * In phase 1, we only use constant default values for NLS parameters
4778: * not currently stored in wf_local_roles table.
4779: */
4780: procedure GetInfoFromMail2( p_emailid in varchar2
4781: , p_role out NOCOPY varchar2,
4782: p_display_name out NOCOPY varchar2,

Line 4988: delete from wf_local_roles

4984: WF_CORE.Raise('WFDS_ROLE_ACTIVE');
4985: exception
4986: when no_data_found then
4987:
4988: delete from wf_local_roles
4989: where name=p_name
4990: and orig_system=p_origSystem
4991: and orig_system_id=p_origSystemId
4992: and partition_id =l_partitionID

Line 5085: where exists (select null from wf_local_roles

5081: -- check whether the role is end-dated
5082:
5083: select 1 into l_count
5084: from SYS.DUAL
5085: where exists (select null from wf_local_roles
5086: where name=p_rolename)
5087: and ( exists (select null from wf_user_roles
5088: where role_name=p_rolename
5089: )

Line 5133: where exists (select null from wf_local_roles

5129: begin
5130: --check whether user is truly end dated
5131: select 1 into l_count
5132: from SYS.DUAL
5133: where exists (select null from wf_local_roles
5134: where name=p_username)
5135: and ( exists (select null from wf_user_roles
5136: where user_name=p_username
5137: )

Line 5177: where exists (select null from wf_local_roles

5173: --check whether user/role is truly end dated
5174:
5175: select 1 into l_count
5176: from SYS.DUAL
5177: where exists (select null from wf_local_roles
5178: where name=p_rolename or name=p_username)
5179: and ( exists (select null from wf_user_roles
5180: where role_name=p_rolename
5181: and user_name=p_username