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_MAINTENANCE dependencies on WF_LOCAL_ROLES

Line 82: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;

78: and wia.item_type = wiav.item_type
79: and wia.name = wiav.name
80: and wiav.text_value = l_oldname;
81:
82: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;
83:
84: begin
85: l_newname := upper(substrb(NewName,1,320));
86: l_oldname := upper(substrb(OldName,1,320));

Line 380: from wf_local_roles partition (FND_USR) wu, fnd_user fu

376: select wu.rowid, wu.orig_system old_orig_system,
377: wu.orig_system_id old_orig_system_id,
378: decode(nvl(fu.employee_id, -1),-1,'FND_USR','PER') new_orig_system,
379: nvl(fu.employee_id, fu.user_id)
380: from wf_local_roles partition (FND_USR) wu, fnd_user fu
381: where wu.name = fu.user_name
382: and (wu.orig_system <> decode(nvl(fu.employee_id, -1),-1,'FND_USR','PER')
383: or wu.orig_system_id <> nvl(fu.employee_id, fu.user_id));
384:

Line 392: wf_local_roles partition (FND_USR) wu

388: select wu.orig_system, wu.orig_system_id,
389: wur.role_orig_system, wur.role_orig_system_id,
390: wur.partition_id, wur.rowid
391: from wf_local_user_roles wur,
392: wf_local_roles partition (FND_USR) wu
393: where wu.name = wur.user_name
394: and wur.user_orig_system in ('FND_USR','PER')
395: and (wur.user_orig_system <> wu.orig_system
396: or wur.user_orig_system_id <> wu.orig_system_id

Line 403: --fnd_usr/per records in wf_local_roles are validated. The dates will be

399: or wur.role_orig_system_id <> wu.orig_system_id)));
400:
401: --We will correct the orig_system, orig_system_id information for any
402: --incorrect fnd_usr/per user/role records. This is processed after the
403: --fnd_usr/per records in wf_local_roles are validated. The dates will be
404: --resolved in when c_userRoleAssignments are resolved.
405: cursor c_userSelfReference is
406: select wura.rowid, wur.rowid, wu.start_date, wu.expiration_date,
407: wu.orig_system, wu.orig_system_id

Line 409: wf_local_roles partition (FND_USR) wu,

405: cursor c_userSelfReference is
406: select wura.rowid, wur.rowid, wu.start_date, wu.expiration_date,
407: wu.orig_system, wu.orig_system_id
408: from wf_local_user_roles partition (FND_USR) wur,
409: wf_local_roles partition (FND_USR) wu,
410: wf_user_role_assignments partition (FND_USR) wura
411: --Equi-joins to select the proper relationships between the tables
412: where wura.partition_id = wu.partition_id
413: and wura.partition_id = wu.partition_id

Line 478: where user_name not in (select name from wf_local_roles)

474:
475: CURSOR dangling_UR_refs is
476: select rowid
477: from wf_local_user_roles
478: where user_name not in (select name from wf_local_roles)
479: or role_name not in (select name from wf_local_roles);
480:
481: CURSOR dangling_URA_refs is
482: select rowid

Line 479: or role_name not in (select name from wf_local_roles);

475: CURSOR dangling_UR_refs is
476: select rowid
477: from wf_local_user_roles
478: where user_name not in (select name from wf_local_roles)
479: or role_name not in (select name from wf_local_roles);
480:
481: CURSOR dangling_URA_refs is
482: select rowid
483: from wf_user_role_assignments

Line 484: where user_name not in (select name from wf_local_roles)

480:
481: CURSOR dangling_URA_refs is
482: select rowid
483: from wf_user_role_assignments
484: where user_name not in (select name from wf_local_roles)
485: or role_name not in (select name from wf_local_roles);
486:
487: l_modulePkg varchar2(240) := 'WF_MAINTENANCE.ValidateUserRoles';
488:

Line 485: or role_name not in (select name from wf_local_roles);

481: CURSOR dangling_URA_refs is
482: select rowid
483: from wf_user_role_assignments
484: where user_name not in (select name from wf_local_roles)
485: or role_name not in (select name from wf_local_roles);
486:
487: l_modulePkg varchar2(240) := 'WF_MAINTENANCE.ValidateUserRoles';
488:
489: begin

Line 640: --Now we will correct any invalid fnd_usr records in WF_LOCAL_ROLES. This

636: raise;
637: end;
638: end if;
639:
640: --Now we will correct any invalid fnd_usr records in WF_LOCAL_ROLES. This
641: --orig_system can have errors because we routinely have to change the
642: --orig_system, orig_system_id whenever a user is associated or dis-associated
643: --with an employee.
644: begin

Line 658: UPDATE WF_LOCAL_ROLES

654:
655: if (l_rowIDTAB.count > 0) then
656: begin
657: forall i in l_rowIDTAB.FIRST..l_rowIDTAB.LAST save exceptions
658: UPDATE WF_LOCAL_ROLES
659: SET orig_system = l_userOrigDestTAB(i),
660: orig_system_id = l_userOrigIDDestTAB(i)
661: WHERE rowid = l_rowIDTAB(i);
662: exception

Line 666: delete from wf_local_roles

662: exception
663: when others then
664: for j in 1..sql%bulk_exceptions.count loop
665: l_eIndex := sql%bulk_exceptions(j).ERROR_INDEX;
666: delete from wf_local_roles
667: where rowid = l_rowIDTAB(l_eIndex);
668: end loop;
669: end;
670: commit;

Line 959: WF_LOCAL_ROLES WAR,

955: WURA.RELATIONSHIP_ID
956: FROM
957: WF_USER_ROLE_ASSIGNMENTS WURA,
958: WF_LOCAL_USER_ROLES WUR ,
959: WF_LOCAL_ROLES WAR,
960: WF_LOCAL_ROLES WU,
961: WF_LOCAL_ROLES WR
962: WHERE WURA.PARTITION_ID = WAR.PARTITION_ID
963: AND WURA.ASSIGNING_ROLE=WAR.NAME

Line 960: WF_LOCAL_ROLES WU,

956: FROM
957: WF_USER_ROLE_ASSIGNMENTS WURA,
958: WF_LOCAL_USER_ROLES WUR ,
959: WF_LOCAL_ROLES WAR,
960: WF_LOCAL_ROLES WU,
961: WF_LOCAL_ROLES WR
962: WHERE WURA.PARTITION_ID = WAR.PARTITION_ID
963: AND WURA.ASSIGNING_ROLE=WAR.NAME
964: AND WURA.USER_NAME= WUR.USER_NAME

Line 961: WF_LOCAL_ROLES WR

957: WF_USER_ROLE_ASSIGNMENTS WURA,
958: WF_LOCAL_USER_ROLES WUR ,
959: WF_LOCAL_ROLES WAR,
960: WF_LOCAL_ROLES WU,
961: WF_LOCAL_ROLES WR
962: WHERE WURA.PARTITION_ID = WAR.PARTITION_ID
963: AND WURA.ASSIGNING_ROLE=WAR.NAME
964: AND WURA.USER_NAME= WUR.USER_NAME
965: AND WURA.ROLE_NAME=WUR.ROLE_NAME