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 235: role_info_tbl wf_directory.wf_local_roles_tbl_type;

231: c_territory VARCHAR2(80);
232: c_language VARCHAR2(80);
233: c_date_format VARCHAR2(40);
234: l_user_id NUMBER := to_number(null);
235: role_info_tbl wf_directory.wf_local_roles_tbl_type;
236: begin
237:
238: l_result := ICX_SEC.PseudoSession (l_session_id, IncludeHeader);
239:

Line 406: from WF_LOCAL_ROLES PARTITION (POS)

402: orig_system_id,
403: FAX,
404: STATUS,
405: EXPIRATION_DATE
406: from WF_LOCAL_ROLES PARTITION (POS)
407: where ORIG_SYSTEM = prefix
408: and ORIG_SYSTEM_ID = to_number(roleid)
409: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
410:

Line 436: from WF_LOCAL_ROLES PARTITION (ENG_LIST)

432: orig_system_id,
433: FAX,
434: STATUS,
435: EXPIRATION_DATE
436: from WF_LOCAL_ROLES PARTITION (ENG_LIST)
437: where ORIG_SYSTEM = prefix
438: and ORIG_SYSTEM_ID = to_number(roleid)
439: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
440:

Line 468: from WF_LOCAL_ROLES PARTITION (FND_RESP)

464: orig_system_id,
465: FAX,
466: STATUS,
467: EXPIRATION_DATE
468: from WF_LOCAL_ROLES PARTITION (FND_RESP)
469: where ORIG_SYSTEM = prefix
470: and ORIG_SYSTEM_ID = to_number(roleid)
471: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
472: elsif (prefix = 'AMV_CHN') then

Line 497: from WF_LOCAL_ROLES PARTITION (AMV_CHN)

493: orig_system_id,
494: FAX,
495: STATUS,
496: EXPIRATION_DATE
497: from WF_LOCAL_ROLES PARTITION (AMV_CHN)
498: where ORIG_SYSTEM = prefix
499: and ORIG_SYSTEM_ID = to_number(roleid)
500: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
501:

Line 527: from WF_LOCAL_ROLES PARTITION (HZ_PARTY)

523: orig_system_id,
524: FAX,
525: STATUS,
526: EXPIRATION_DATE
527: from WF_LOCAL_ROLES PARTITION (HZ_PARTY)
528: where ORIG_SYSTEM = prefix
529: and ORIG_SYSTEM_ID = to_number(roleid)
530: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
531: else

Line 567: from WF_LOCAL_ROLES

563: orig_system_id,
564: FAX,
565: STATUS,
566: EXPIRATION_DATE
567: from WF_LOCAL_ROLES
568: where NAME = role
569: and partition_id in (1, 0, 5, 10, 13)
570: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate
571: and rownum < 2; /* Bug 2728955 */

Line 937: from WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)

933: is
934: cnt number;
935: begin
936: select count(1) into cnt
937: from WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)
938: where NAME = role_name
939: and ORIG_SYSTEM in ('WF_LOCAL_ROLES', 'WF_LOCAL_USERS')
940: and ORIG_SYSTEM_ID = 0;
941:

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

935: begin
936: select count(1) into cnt
937: from WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)
938: where NAME = role_name
939: and ORIG_SYSTEM in ('WF_LOCAL_ROLES', 'WF_LOCAL_USERS')
940: and ORIG_SYSTEM_ID = 0;
941:
942: return(cnt);
943:

Line 963: update WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)

959: NewName in varchar2
960: )
961: is
962: begin
963: update WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)
964: set NAME = NewName
965: where NAME = OldName
966: and ORIG_SYSTEM in ('WF_LOCAL_USERS', 'WF_LOCAL_ROLES')
967: and ORIG_SYSTEM_ID = 0;

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

962: begin
963: update WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)
964: set NAME = NewName
965: where NAME = OldName
966: and ORIG_SYSTEM in ('WF_LOCAL_USERS', 'WF_LOCAL_ROLES')
967: and ORIG_SYSTEM_ID = 0;
968:
969: -- Update local user roles
970: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

Line 970: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

966: and ORIG_SYSTEM in ('WF_LOCAL_USERS', 'WF_LOCAL_ROLES')
967: and ORIG_SYSTEM_ID = 0;
968:
969: -- Update local user roles
970: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
971: set USER_NAME = NewName
972: where USER_NAME = OldName
973: and USER_ORIG_SYSTEM = 'WF_LOCAL_USERS'
974: and USER_ORIG_SYSTEM_ID = 0;

Line 976: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

972: where USER_NAME = OldName
973: and USER_ORIG_SYSTEM = 'WF_LOCAL_USERS'
974: and USER_ORIG_SYSTEM_ID = 0;
975:
976: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
977: set ROLE_NAME = NewName
978: where ROLE_NAME = OldName
979: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_USERS'
980: and ROLE_ORIG_SYSTEM_ID = 0;

Line 982: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

978: where ROLE_NAME = OldName
979: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_USERS'
980: and ROLE_ORIG_SYSTEM_ID = 0;
981:
982: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
983: set ROLE_NAME = NewName
984: where ROLE_NAME = OldName
985: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
986: and ROLE_ORIG_SYSTEM_ID = 0;

Line 985: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

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