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 1382: l_creatby := nvl(Createuser.created_by,WFA_SEC.USER_ID);

1378: end if;
1379: --
1380: -- Evaluating the WHO columns in case they are not passed
1381:
1382: l_creatby := nvl(Createuser.created_by,WFA_SEC.USER_ID);
1383: l_creatdt := nvl(CreateUser.creation_date, SYSDATE);
1384: l_lastupdby := nvl(CreateUser.last_updated_by, WFA_SEC.USER_ID);
1385: l_lastupddt := nvl(CreateUser.last_update_date, SYSDATE);
1386: l_lastupdlog:= nvl(CreateUser.last_update_login, WFA_SEC.LOGIN_ID);

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

1380: -- Evaluating the WHO columns in case they are not passed
1381:
1382: l_creatby := nvl(Createuser.created_by,WFA_SEC.USER_ID);
1383: l_creatdt := nvl(CreateUser.creation_date, SYSDATE);
1384: l_lastupdby := nvl(CreateUser.last_updated_by, WFA_SEC.USER_ID);
1385: l_lastupddt := nvl(CreateUser.last_update_date, SYSDATE);
1386: l_lastupdlog:= nvl(CreateUser.last_update_login, WFA_SEC.LOGIN_ID);
1387:
1388:

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

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

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

1805: end if;
1806:
1807: -- Evaluating the WHO columns in case they are not passed
1808:
1809: l_creatby := nvl(CreateRole.created_by,WFA_SEC.USER_ID);
1810: l_creatdt := nvl(CreateRole.creation_date, SYSDATE);
1811: l_lastupdby := nvl(CreateRole.last_updated_by, WFA_SEC.USER_ID);
1812: l_lastupddt := nvl(CreateRole.last_update_date, SYSDATE);
1813: l_lastupdlog:= nvl(CreateRole.last_update_login, WFA_SEC.LOGIN_ID);

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

1807: -- Evaluating the WHO columns in case they are not passed
1808:
1809: l_creatby := nvl(CreateRole.created_by,WFA_SEC.USER_ID);
1810: l_creatdt := nvl(CreateRole.creation_date, SYSDATE);
1811: l_lastupdby := nvl(CreateRole.last_updated_by, WFA_SEC.USER_ID);
1812: l_lastupddt := nvl(CreateRole.last_update_date, SYSDATE);
1813: l_lastupdlog:= nvl(CreateRole.last_update_login, WFA_SEC.LOGIN_ID);
1814:
1815: if (l_origSysIDTAB.COUNT > 0) then

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

1809: l_creatby := nvl(CreateRole.created_by,WFA_SEC.USER_ID);
1810: l_creatdt := nvl(CreateRole.creation_date, SYSDATE);
1811: l_lastupdby := nvl(CreateRole.last_updated_by, WFA_SEC.USER_ID);
1812: l_lastupddt := nvl(CreateRole.last_update_date, SYSDATE);
1813: l_lastupdlog:= nvl(CreateRole.last_update_login, WFA_SEC.LOGIN_ID);
1814:
1815: if (l_origSysIDTAB.COUNT > 0) then
1816: if (l_partitionID <> 2) then
1817: WF_CORE.Token('NAME', CreateRole.role_name);

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

2317: l_effEndDate);
2318:
2319: -- Evaluate the WHO columns in case they are not passed
2320:
2321: l_creatby := nvl(CreateUserRole.created_by,WFA_SEC.USER_ID);
2322: l_creatdt := nvl(CreateUserRole.creation_date, SYSDATE);
2323: l_lastupdby := nvl(CreateUserRole.last_updated_by, WFA_SEC.USER_ID);
2324: l_lastupddt := nvl(CreateUserRole.last_update_date, SYSDATE);
2325: l_lastupdlog:= nvl(CreateUserRole.last_update_login, WFA_SEC.LOGIN_ID);

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

2319: -- Evaluate the WHO columns in case they are not passed
2320:
2321: l_creatby := nvl(CreateUserRole.created_by,WFA_SEC.USER_ID);
2322: l_creatdt := nvl(CreateUserRole.creation_date, SYSDATE);
2323: l_lastupdby := nvl(CreateUserRole.last_updated_by, WFA_SEC.USER_ID);
2324: l_lastupddt := nvl(CreateUserRole.last_update_date, SYSDATE);
2325: l_lastupdlog:= nvl(CreateUserRole.last_update_login, WFA_SEC.LOGIN_ID);
2326:
2327: -- Insert

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

2321: l_creatby := nvl(CreateUserRole.created_by,WFA_SEC.USER_ID);
2322: l_creatdt := nvl(CreateUserRole.creation_date, SYSDATE);
2323: l_lastupdby := nvl(CreateUserRole.last_updated_by, WFA_SEC.USER_ID);
2324: l_lastupddt := nvl(CreateUserRole.last_update_date, SYSDATE);
2325: l_lastupdlog:= nvl(CreateUserRole.last_update_login, WFA_SEC.LOGIN_ID);
2326:
2327: -- Insert
2328: begin
2329: insert into WF_LOCAL_USER_ROLES

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

2627: WF_CORE.Raise('WF_INVAL_USER_ROLE');
2628: end;
2629:
2630: -- Evaluating the WHO columns in case they are not passed
2631: l_lastupdby := nvl(setuserroleattr.last_updated_by, WFA_SEC.USER_ID);
2632: l_lastupddt := nvl(setuserroleattr.last_update_date, SYSDATE);
2633: l_lastupdlog:= nvl(setuserroleattr.last_update_login, WFA_SEC.LOGIN_ID);
2634:
2635: if (OverWrite and l_updateWho) then

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

2629:
2630: -- Evaluating the WHO columns in case they are not passed
2631: l_lastupdby := nvl(setuserroleattr.last_updated_by, WFA_SEC.USER_ID);
2632: l_lastupddt := nvl(setuserroleattr.last_update_date, SYSDATE);
2633: l_lastupdlog:= nvl(setuserroleattr.last_update_login, WFA_SEC.LOGIN_ID);
2634:
2635: if (OverWrite and l_updateWho) then
2636: update WF_LOCAL_USER_ROLES
2637: set EXPIRATION_DATE = SetUserRoleAttr.end_date,

Line 2894: l_lastupdby := WFA_SEC.USER_ID;

2890:
2891: --set the who columns
2892:
2893: l_lastupddt := SYSDATE;
2894: l_lastupdby := WFA_SEC.USER_ID;
2895: l_lastupdlog := WFA_SEC.LOGIN_ID;
2896:
2897: AssignPartition( RemoveUserRole.role_orig_system,l_partitionId,l_partitionName);
2898:

Line 2895: l_lastupdlog := WFA_SEC.LOGIN_ID;

2891: --set the who columns
2892:
2893: l_lastupddt := SYSDATE;
2894: l_lastupdby := WFA_SEC.USER_ID;
2895: l_lastupdlog := WFA_SEC.LOGIN_ID;
2896:
2897: AssignPartition( RemoveUserRole.role_orig_system,l_partitionId,l_partitionName);
2898:
2899: if (user_orig_system is null or user_orig_system_id is null) then

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

3017: l_orig_system_id number := NULL;
3018:
3019: begin
3020: -- Validate Role
3021: if (wfa_sec.DS_Count_Local_Role(AddUsersToAdHocRole2.role_name) <= 0) then
3022: wf_core.token('ROLENAME', AddUsersToAdHocRole2.role_name);
3023: wf_core.raise('WF_INVALID_ROLE');
3024: end if;
3025:

Line 3100: created_by=>WFA_SEC.user_id,

3096: role_orig_system_id=>0,
3097: start_date=>sysdate,
3098: end_date=>to_date(NULL),
3099: validateUserRole=>FALSE,
3100: created_by=>WFA_SEC.user_id,
3101: creation_date=>sysdate,
3102: last_updated_by=>WFA_SEC.user_id,
3103: last_update_date=>sysdate,
3104: last_update_login=>WFA_SEC.login_id);

Line 3102: last_updated_by=>WFA_SEC.user_id,

3098: end_date=>to_date(NULL),
3099: validateUserRole=>FALSE,
3100: created_by=>WFA_SEC.user_id,
3101: creation_date=>sysdate,
3102: last_updated_by=>WFA_SEC.user_id,
3103: last_update_date=>sysdate,
3104: last_update_login=>WFA_SEC.login_id);
3105:
3106: end if;

Line 3104: last_update_login=>WFA_SEC.login_id);

3100: created_by=>WFA_SEC.user_id,
3101: creation_date=>sysdate,
3102: last_updated_by=>WFA_SEC.user_id,
3103: last_update_date=>sysdate,
3104: last_update_login=>WFA_SEC.login_id);
3105:
3106: end if;
3107: end loop;
3108: end if;

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

3199: --
3200: -- Evaluate the WHO columns, and set default values if they are not passed
3201:
3202: l_creatdt := nvl(SetUserAttr.creation_date, SYSDATE);
3203: l_creatby := nvl(SetUserAttr.created_by, WFA_SEC.USER_ID);
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:

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

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

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

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

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

3622:
3623:
3624: -- Evaluating the WHO columns in case they are not passed
3625: l_creatdt := nvl(SetRoleAttr.creation_date, SYSDATE);
3626: l_creatby := nvl(SetRoleAttr.created_by, WFA_SEC.USER_ID);
3627: l_lastupdby := nvl(SetRoleAttr.last_updated_by, WFA_SEC.USER_ID);
3628: l_lastupddt := nvl(SetRoleAttr.last_update_date, SYSDATE);
3629: l_lastupdlog:= nvl(SetRoleAttr.last_update_login, WFA_SEC.LOGIN_ID);
3630:

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

3623:
3624: -- Evaluating the WHO columns in case they are not passed
3625: l_creatdt := nvl(SetRoleAttr.creation_date, SYSDATE);
3626: l_creatby := nvl(SetRoleAttr.created_by, WFA_SEC.USER_ID);
3627: l_lastupdby := nvl(SetRoleAttr.last_updated_by, WFA_SEC.USER_ID);
3628: l_lastupddt := nvl(SetRoleAttr.last_update_date, SYSDATE);
3629: l_lastupdlog:= nvl(SetRoleAttr.last_update_login, WFA_SEC.LOGIN_ID);
3630:
3631:

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

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

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

4292: begin
4293: l_newname := substrb(NewName,1,320);
4294: l_oldname := substrb(OldName,1,320);
4295:
4296: NumRows := wfa_sec.DS_Count_Local_Role(l_oldname);
4297:
4298: if (NumRows = 1) then
4299: wfa_sec.DS_Update_Local_Role(l_oldname,l_newname);
4300: commit;

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

4295:
4296: NumRows := wfa_sec.DS_Count_Local_Role(l_oldname);
4297:
4298: if (NumRows = 1) then
4299: wfa_sec.DS_Update_Local_Role(l_oldname,l_newname);
4300: commit;
4301:
4302: if (Propagate) then
4303: WF_MAINTENANCE.PropagateChangedName(l_oldname, l_newname);

Line 4693: wfa_sec.get_role_info3(l_isComposite,

4689:
4690: l_isComposite := CompositeName(p_role, l_origSystem, l_origSystemID);
4691:
4692: p_role:= l_name;
4693: wfa_sec.get_role_info3(l_isComposite,
4694: l_name,
4695: p_role,
4696: p_display_name,
4697: p_description,