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.WFA_SEC dependencies on WF_LOCAL_ROLES

Line 246: role_info_tbl wf_directory.wf_local_roles_tbl_type;

242: c_territory VARCHAR2(80);
243: c_language VARCHAR2(80);
244: c_date_format VARCHAR2(40);
245: l_user_id NUMBER := to_number(null);
246: role_info_tbl wf_directory.wf_local_roles_tbl_type;
247: begin
248:
249: l_result := ICX_SEC.PseudoSession (l_session_id, IncludeHeader);
250:

Line 418: from WF_LOCAL_ROLES PARTITION (POS)

414: orig_system_id,
415: FAX,
416: STATUS,
417: EXPIRATION_DATE
418: from WF_LOCAL_ROLES PARTITION (POS)
419: where ORIG_SYSTEM = prefix
420: and ORIG_SYSTEM_ID = to_number(roleid)
421: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
422:

Line 448: from WF_LOCAL_ROLES PARTITION (ENG_LIST)

444: orig_system_id,
445: FAX,
446: STATUS,
447: EXPIRATION_DATE
448: from WF_LOCAL_ROLES PARTITION (ENG_LIST)
449: where ORIG_SYSTEM = prefix
450: and ORIG_SYSTEM_ID = to_number(roleid)
451: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
452:

Line 480: from WF_LOCAL_ROLES PARTITION (FND_RESP)

476: orig_system_id,
477: FAX,
478: STATUS,
479: EXPIRATION_DATE
480: from WF_LOCAL_ROLES PARTITION (FND_RESP)
481: where ORIG_SYSTEM = prefix
482: and ORIG_SYSTEM_ID = to_number(roleid)
483: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
484: elsif (prefix = 'AMV_CHN') then

Line 509: from WF_LOCAL_ROLES PARTITION (AMV_CHN)

505: orig_system_id,
506: FAX,
507: STATUS,
508: EXPIRATION_DATE
509: from WF_LOCAL_ROLES PARTITION (AMV_CHN)
510: where ORIG_SYSTEM = prefix
511: and ORIG_SYSTEM_ID = to_number(roleid)
512: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
513:

Line 539: from WF_LOCAL_ROLES PARTITION (HZ_PARTY)

535: orig_system_id,
536: FAX,
537: STATUS,
538: EXPIRATION_DATE
539: from WF_LOCAL_ROLES PARTITION (HZ_PARTY)
540: where ORIG_SYSTEM = prefix
541: and ORIG_SYSTEM_ID = to_number(roleid)
542: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
543: else

Line 579: from WF_LOCAL_ROLES

575: orig_system_id,
576: FAX,
577: STATUS,
578: EXPIRATION_DATE
579: from WF_LOCAL_ROLES
580: where NAME = role
581: and partition_id in (1, 0, 5, 10, 13)
582: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate
583: and rownum < 2; /* Bug 2728955 */

Line 945: from WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)

941: is
942: cnt number;
943: begin
944: select count(1) into cnt
945: from WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)
946: where NAME = role_name
947: and ORIG_SYSTEM in ('WF_LOCAL_ROLES', 'WF_LOCAL_USERS')
948: and ORIG_SYSTEM_ID = 0;
949:

Line 947: and ORIG_SYSTEM in ('WF_LOCAL_ROLES', 'WF_LOCAL_USERS')

943: begin
944: select count(1) into cnt
945: from WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)
946: where NAME = role_name
947: and ORIG_SYSTEM in ('WF_LOCAL_ROLES', 'WF_LOCAL_USERS')
948: and ORIG_SYSTEM_ID = 0;
949:
950: return(cnt);
951:

Line 971: update WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)

967: NewName in varchar2
968: )
969: is
970: begin
971: update WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)
972: set NAME = NewName
973: where NAME = OldName
974: and ORIG_SYSTEM in ('WF_LOCAL_USERS', 'WF_LOCAL_ROLES')
975: and ORIG_SYSTEM_ID = 0;

Line 974: and ORIG_SYSTEM in ('WF_LOCAL_USERS', 'WF_LOCAL_ROLES')

970: begin
971: update WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)
972: set NAME = NewName
973: where NAME = OldName
974: and ORIG_SYSTEM in ('WF_LOCAL_USERS', 'WF_LOCAL_ROLES')
975: and ORIG_SYSTEM_ID = 0;
976:
977: -- Update local user roles
978: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

Line 978: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

974: and ORIG_SYSTEM in ('WF_LOCAL_USERS', 'WF_LOCAL_ROLES')
975: and ORIG_SYSTEM_ID = 0;
976:
977: -- Update local user roles
978: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
979: set USER_NAME = NewName
980: where USER_NAME = OldName
981: and USER_ORIG_SYSTEM = 'WF_LOCAL_USERS'
982: and USER_ORIG_SYSTEM_ID = 0;

Line 984: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

980: where USER_NAME = OldName
981: and USER_ORIG_SYSTEM = 'WF_LOCAL_USERS'
982: and USER_ORIG_SYSTEM_ID = 0;
983:
984: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
985: set ROLE_NAME = NewName
986: where ROLE_NAME = OldName
987: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_USERS'
988: and ROLE_ORIG_SYSTEM_ID = 0;

Line 990: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

986: where ROLE_NAME = OldName
987: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_USERS'
988: and ROLE_ORIG_SYSTEM_ID = 0;
989:
990: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
991: set ROLE_NAME = NewName
992: where ROLE_NAME = OldName
993: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
994: and ROLE_ORIG_SYSTEM_ID = 0;

Line 993: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

989:
990: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
991: set ROLE_NAME = NewName
992: where ROLE_NAME = OldName
993: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
994: and ROLE_ORIG_SYSTEM_ID = 0;
995:
996:
997: