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

Line 98: FROM wf_local_roles

94:
95:
96: CURSOR c_chk_wf_role (p_role_name VARCHAR2) IS
97: SELECT 'Y'
98: FROM wf_local_roles
99: WHERE name = p_role_name;
100:
101: BEGIN
102: l_task_in_chklist_id := substr(p_transaction_id,1,instr(p_transaction_id,'-')-1); -- 8861932

Line 969: l_task_done_by wf_local_roles.name%type;

965: is
966: l_alloc_id number;
967: l_proc varchar2(72);
968: -- bug 7560762
969: l_task_done_by wf_local_roles.name%type;
970: l_PERFORMER_ORIG_SYS_ID PER_ALLOCATED_TASKS.PERFORMER_ORIG_SYS_ID%type;
971:
972: cursor c_performer_orig_sys_id(p_task_done_by varchar2) is
973: SELECT ORIG_SYSTEM_ID

Line 974: FROM wf_local_roles

970: l_PERFORMER_ORIG_SYS_ID PER_ALLOCATED_TASKS.PERFORMER_ORIG_SYS_ID%type;
971:
972: cursor c_performer_orig_sys_id(p_task_done_by varchar2) is
973: SELECT ORIG_SYSTEM_ID
974: FROM wf_local_roles
975: where ORIG_SYSTEM = 'PER'
976: and name = p_task_done_by;
977: -- bug 7560762
978: --

Line 1047: l_task_done_by wf_local_roles.name%type;

1043: --
1044: l_alloc_id number;
1045: l_proc varchar2(72);
1046: -- bug 7560762
1047: l_task_done_by wf_local_roles.name%type;
1048: l_PERFORMER_ORIG_SYS_ID PER_ALLOCATED_TASKS.PERFORMER_ORIG_SYS_ID%type;
1049:
1050: cursor c_performer_orig_sys_id(p_task_done_by varchar2) is
1051: SELECT ORIG_SYSTEM_ID

Line 1052: FROM wf_local_roles

1048: l_PERFORMER_ORIG_SYS_ID PER_ALLOCATED_TASKS.PERFORMER_ORIG_SYS_ID%type;
1049:
1050: cursor c_performer_orig_sys_id(p_task_done_by varchar2) is
1051: SELECT ORIG_SYSTEM_ID
1052: FROM wf_local_roles
1053: where ORIG_SYSTEM = 'PER'
1054: and name = p_task_done_by;
1055: -- bug 7560762
1056: