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 WFA_SEC

Line 374: ** wfa_sec.get_role_info function. This function looks at each component

370: l_isComposite := CompositeName(role, l_origSystem, l_origSystemID);
371:
372: /*
373: ** First try to get the role information from the new
374: ** wfa_sec.get_role_info function. This function looks at each component
375: ** of the wf_roles view and attempts to get the information from there.
376: ** If it does not find the role then use the old method of looking at the
377: ** view.
378: */

Line 382: wfa_sec.get_role_info3(l_isComposite,

378: */
379:
380: --Get all info including expiration_date , fax and
381: --status for the role. Call get_role_info2
382: wfa_sec.get_role_info3(l_isComposite,
383: role,
384: role_info_tbl(1).name,
385: role_info_tbl(1).display_name,
386: role_info_tbl(1).description,

Line 407: 'no records found by wfa_sec.get_role_info3(), querying active roles in other partitions then.');

403:
404: if (role_info_tbl.COUNT = 0 or role_info_tbl(1).display_name is NULL) then
405: if( l_logPROC ) then
406: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,
407: 'no records found by wfa_sec.get_role_info3(), querying *active* roles in other partitions then.');
408: end if;
409:
410: if NOT (l_isComposite) then
411: if( l_logPROC ) then

Line 1524: l_creatby := nvl(Createuser.created_by,WFA_SEC.USER_ID);

1520: end if;
1521: --
1522: -- Evaluating the WHO columns in case they are not passed
1523:
1524: l_creatby := nvl(Createuser.created_by,WFA_SEC.USER_ID);
1525: l_creatdt := nvl(CreateUser.creation_date, SYSDATE);
1526: l_lastupdby := nvl(CreateUser.last_updated_by, WFA_SEC.USER_ID);
1527: l_lastupddt := nvl(CreateUser.last_update_date, SYSDATE);
1528: l_lastupdlog:= nvl(CreateUser.last_update_login, WFA_SEC.LOGIN_ID);

Line 1526: l_lastupdby := nvl(CreateUser.last_updated_by, WFA_SEC.USER_ID);

1522: -- Evaluating the WHO columns in case they are not passed
1523:
1524: l_creatby := nvl(Createuser.created_by,WFA_SEC.USER_ID);
1525: l_creatdt := nvl(CreateUser.creation_date, SYSDATE);
1526: l_lastupdby := nvl(CreateUser.last_updated_by, WFA_SEC.USER_ID);
1527: l_lastupddt := nvl(CreateUser.last_update_date, SYSDATE);
1528: l_lastupdlog:= nvl(CreateUser.last_update_login, WFA_SEC.LOGIN_ID);
1529:
1530:

Line 1528: l_lastupdlog:= nvl(CreateUser.last_update_login, WFA_SEC.LOGIN_ID);

1524: l_creatby := nvl(Createuser.created_by,WFA_SEC.USER_ID);
1525: l_creatdt := nvl(CreateUser.creation_date, SYSDATE);
1526: l_lastupdby := nvl(CreateUser.last_updated_by, WFA_SEC.USER_ID);
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: --

Line 1951: l_creatby := nvl(CreateRole.created_by,WFA_SEC.USER_ID);

1947: end if;
1948:
1949: -- Evaluating the WHO columns in case they are not passed
1950:
1951: l_creatby := nvl(CreateRole.created_by,WFA_SEC.USER_ID);
1952: l_creatdt := nvl(CreateRole.creation_date, SYSDATE);
1953: l_lastupdby := nvl(CreateRole.last_updated_by, WFA_SEC.USER_ID);
1954: l_lastupddt := nvl(CreateRole.last_update_date, SYSDATE);
1955: l_lastupdlog:= nvl(CreateRole.last_update_login, WFA_SEC.LOGIN_ID);

Line 1953: l_lastupdby := nvl(CreateRole.last_updated_by, WFA_SEC.USER_ID);

1949: -- Evaluating the WHO columns in case they are not passed
1950:
1951: l_creatby := nvl(CreateRole.created_by,WFA_SEC.USER_ID);
1952: l_creatdt := nvl(CreateRole.creation_date, SYSDATE);
1953: l_lastupdby := nvl(CreateRole.last_updated_by, WFA_SEC.USER_ID);
1954: l_lastupddt := nvl(CreateRole.last_update_date, SYSDATE);
1955: l_lastupdlog:= nvl(CreateRole.last_update_login, WFA_SEC.LOGIN_ID);
1956:
1957: if (l_origSysIDTAB.COUNT > 0) then

Line 1955: l_lastupdlog:= nvl(CreateRole.last_update_login, WFA_SEC.LOGIN_ID);

1951: l_creatby := nvl(CreateRole.created_by,WFA_SEC.USER_ID);
1952: l_creatdt := nvl(CreateRole.creation_date, SYSDATE);
1953: l_lastupdby := nvl(CreateRole.last_updated_by, WFA_SEC.USER_ID);
1954: l_lastupddt := nvl(CreateRole.last_update_date, SYSDATE);
1955: l_lastupdlog:= nvl(CreateRole.last_update_login, WFA_SEC.LOGIN_ID);
1956:
1957: if (l_origSysIDTAB.COUNT > 0) then
1958: if (l_partitionID <> 2) then
1959: WF_CORE.Token('NAME', CreateRole.role_name);

Line 2463: l_creatby := nvl(CreateUserRole.created_by,WFA_SEC.USER_ID);

2459: l_effEndDate);
2460:
2461: -- Evaluate the WHO columns in case they are not passed
2462:
2463: l_creatby := nvl(CreateUserRole.created_by,WFA_SEC.USER_ID);
2464: l_creatdt := nvl(CreateUserRole.creation_date, SYSDATE);
2465: l_lastupdby := nvl(CreateUserRole.last_updated_by, WFA_SEC.USER_ID);
2466: l_lastupddt := nvl(CreateUserRole.last_update_date, SYSDATE);
2467: l_lastupdlog:= nvl(CreateUserRole.last_update_login, WFA_SEC.LOGIN_ID);

Line 2465: l_lastupdby := nvl(CreateUserRole.last_updated_by, WFA_SEC.USER_ID);

2461: -- Evaluate the WHO columns in case they are not passed
2462:
2463: l_creatby := nvl(CreateUserRole.created_by,WFA_SEC.USER_ID);
2464: l_creatdt := nvl(CreateUserRole.creation_date, SYSDATE);
2465: l_lastupdby := nvl(CreateUserRole.last_updated_by, WFA_SEC.USER_ID);
2466: l_lastupddt := nvl(CreateUserRole.last_update_date, SYSDATE);
2467: l_lastupdlog:= nvl(CreateUserRole.last_update_login, WFA_SEC.LOGIN_ID);
2468:
2469: -- Insert

Line 2467: l_lastupdlog:= nvl(CreateUserRole.last_update_login, WFA_SEC.LOGIN_ID);

2463: l_creatby := nvl(CreateUserRole.created_by,WFA_SEC.USER_ID);
2464: l_creatdt := nvl(CreateUserRole.creation_date, SYSDATE);
2465: l_lastupdby := nvl(CreateUserRole.last_updated_by, WFA_SEC.USER_ID);
2466: l_lastupddt := nvl(CreateUserRole.last_update_date, SYSDATE);
2467: l_lastupdlog:= nvl(CreateUserRole.last_update_login, WFA_SEC.LOGIN_ID);
2468:
2469: -- Insert
2470: begin
2471: insert into WF_LOCAL_USER_ROLES

Line 2779: l_lastupdby := nvl(setuserroleattr.last_updated_by, WFA_SEC.USER_ID);

2775: WF_CORE.Raise('WF_INVAL_USER_ROLE');
2776: end;
2777:
2778: -- Evaluating the WHO columns in case they are not passed
2779: l_lastupdby := nvl(setuserroleattr.last_updated_by, WFA_SEC.USER_ID);
2780: l_lastupddt := nvl(setuserroleattr.last_update_date, SYSDATE);
2781: l_lastupdlog:= nvl(setuserroleattr.last_update_login, WFA_SEC.LOGIN_ID);
2782:
2783: if (OverWrite and l_updateWho) then

Line 2781: l_lastupdlog:= nvl(setuserroleattr.last_update_login, WFA_SEC.LOGIN_ID);

2777:
2778: -- Evaluating the WHO columns in case they are not passed
2779: l_lastupdby := nvl(setuserroleattr.last_updated_by, WFA_SEC.USER_ID);
2780: l_lastupddt := nvl(setuserroleattr.last_update_date, SYSDATE);
2781: l_lastupdlog:= nvl(setuserroleattr.last_update_login, WFA_SEC.LOGIN_ID);
2782:
2783: if (OverWrite and l_updateWho) then
2784: update WF_LOCAL_USER_ROLES
2785: set EXPIRATION_DATE = SetUserRoleAttr.end_date,

Line 3042: l_lastupdby := WFA_SEC.USER_ID;

3038:
3039: --set the who columns
3040:
3041: l_lastupddt := SYSDATE;
3042: l_lastupdby := WFA_SEC.USER_ID;
3043: l_lastupdlog := WFA_SEC.LOGIN_ID;
3044:
3045: AssignPartition( RemoveUserRole.role_orig_system,l_partitionId,l_partitionName);
3046:

Line 3043: l_lastupdlog := WFA_SEC.LOGIN_ID;

3039: --set the who columns
3040:
3041: l_lastupddt := SYSDATE;
3042: l_lastupdby := WFA_SEC.USER_ID;
3043: l_lastupdlog := WFA_SEC.LOGIN_ID;
3044:
3045: AssignPartition( RemoveUserRole.role_orig_system,l_partitionId,l_partitionName);
3046:
3047: if (user_orig_system is null or user_orig_system_id is null) then

Line 3169: if (wfa_sec.DS_Count_Local_Role(AddUsersToAdHocRole2.role_name) <= 0) then

3165: l_orig_system_id number := NULL;
3166:
3167: begin
3168: -- Validate Role
3169: if (wfa_sec.DS_Count_Local_Role(AddUsersToAdHocRole2.role_name) <= 0) then
3170: wf_core.token('ROLENAME', AddUsersToAdHocRole2.role_name);
3171: wf_core.raise('WF_INVALID_ROLE');
3172: end if;
3173:

Line 3248: created_by=>WFA_SEC.user_id,

3244: role_orig_system_id=>0,
3245: start_date=>sysdate,
3246: end_date=>to_date(NULL),
3247: validateUserRole=>FALSE,
3248: created_by=>WFA_SEC.user_id,
3249: creation_date=>sysdate,
3250: last_updated_by=>WFA_SEC.user_id,
3251: last_update_date=>sysdate,
3252: last_update_login=>WFA_SEC.login_id);

Line 3250: last_updated_by=>WFA_SEC.user_id,

3246: end_date=>to_date(NULL),
3247: validateUserRole=>FALSE,
3248: created_by=>WFA_SEC.user_id,
3249: creation_date=>sysdate,
3250: last_updated_by=>WFA_SEC.user_id,
3251: last_update_date=>sysdate,
3252: last_update_login=>WFA_SEC.login_id);
3253:
3254: end if;

Line 3252: last_update_login=>WFA_SEC.login_id);

3248: created_by=>WFA_SEC.user_id,
3249: creation_date=>sysdate,
3250: last_updated_by=>WFA_SEC.user_id,
3251: last_update_date=>sysdate,
3252: last_update_login=>WFA_SEC.login_id);
3253:
3254: end if;
3255: end loop;
3256: end if;

Line 3351: l_creatby := nvl(SetUserAttr.created_by, WFA_SEC.USER_ID);

3347: --
3348: -- Evaluate the WHO columns, and set default values if they are not passed
3349:
3350: l_creatdt := nvl(SetUserAttr.creation_date, SYSDATE);
3351: l_creatby := nvl(SetUserAttr.created_by, WFA_SEC.USER_ID);
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:

Line 3353: l_lastupdby := nvl(SetUserAttr.last_updated_by, WFA_SEC.USER_ID);

3349:
3350: l_creatdt := nvl(SetUserAttr.creation_date, SYSDATE);
3351: l_creatby := nvl(SetUserAttr.created_by, WFA_SEC.USER_ID);
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: --

Line 3354: l_lastupdlog := nvl(SetUserAttr.last_update_login, WFA_SEC.LOGIN_ID);

3350: l_creatdt := nvl(SetUserAttr.creation_date, SYSDATE);
3351: l_creatby := nvl(SetUserAttr.created_by, WFA_SEC.USER_ID);
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

Line 3774: l_creatby := nvl(SetRoleAttr.created_by, WFA_SEC.USER_ID);

3770:
3771:
3772: -- Evaluating the WHO columns in case they are not passed
3773: l_creatdt := nvl(SetRoleAttr.creation_date, SYSDATE);
3774: l_creatby := nvl(SetRoleAttr.created_by, WFA_SEC.USER_ID);
3775: l_lastupdby := nvl(SetRoleAttr.last_updated_by, WFA_SEC.USER_ID);
3776: l_lastupddt := nvl(SetRoleAttr.last_update_date, SYSDATE);
3777: l_lastupdlog:= nvl(SetRoleAttr.last_update_login, WFA_SEC.LOGIN_ID);
3778:

Line 3775: l_lastupdby := nvl(SetRoleAttr.last_updated_by, WFA_SEC.USER_ID);

3771:
3772: -- Evaluating the WHO columns in case they are not passed
3773: l_creatdt := nvl(SetRoleAttr.creation_date, SYSDATE);
3774: l_creatby := nvl(SetRoleAttr.created_by, WFA_SEC.USER_ID);
3775: l_lastupdby := nvl(SetRoleAttr.last_updated_by, WFA_SEC.USER_ID);
3776: l_lastupddt := nvl(SetRoleAttr.last_update_date, SYSDATE);
3777: l_lastupdlog:= nvl(SetRoleAttr.last_update_login, WFA_SEC.LOGIN_ID);
3778:
3779:

Line 3777: l_lastupdlog:= nvl(SetRoleAttr.last_update_login, WFA_SEC.LOGIN_ID);

3773: l_creatdt := nvl(SetRoleAttr.creation_date, SYSDATE);
3774: l_creatby := nvl(SetRoleAttr.created_by, WFA_SEC.USER_ID);
3775: l_lastupdby := nvl(SetRoleAttr.last_updated_by, WFA_SEC.USER_ID);
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: --

Line 4444: NumRows := wfa_sec.DS_Count_Local_Role(l_oldname);

4440: begin
4441: l_newname := substrb(NewName,1,320);
4442: l_oldname := substrb(OldName,1,320);
4443:
4444: NumRows := wfa_sec.DS_Count_Local_Role(l_oldname);
4445:
4446: if (NumRows = 1) then
4447: wfa_sec.DS_Update_Local_Role(l_oldname,l_newname);
4448: commit;

Line 4447: wfa_sec.DS_Update_Local_Role(l_oldname,l_newname);

4443:
4444: NumRows := wfa_sec.DS_Count_Local_Role(l_oldname);
4445:
4446: if (NumRows = 1) then
4447: wfa_sec.DS_Update_Local_Role(l_oldname,l_newname);
4448: commit;
4449:
4450: if (Propagate) then
4451: WF_MAINTENANCE.PropagateChangedName(l_oldname, l_newname);

Line 4830: wfa_sec.get_role_info3(l_isComposite,

4826:
4827: l_isComposite := CompositeName(p_role, l_origSystem, l_origSystemID);
4828:
4829: p_role:= l_name;
4830: wfa_sec.get_role_info3(l_isComposite,
4831: l_name,
4832: p_role,
4833: p_display_name,
4834: p_description,