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.OKC_DELIVERABLE_WF_PVT dependencies on WF_ROLES

Line 120: l_role_name wf_roles.name%TYPE;

116: --bug#4694703 replaced hr_employees_current_v with PER_PEOPLE_F
117: cursor C_user_email(x_employee_id NUMBER) is
118: select email_address, full_name from PER_PEOPLE_F where person_id = x_employee_id;
119:
120: l_role_name wf_roles.name%TYPE;
121: l_role_display_name wf_roles.display_name%TYPE;
122:
123: l_email per_people_f.email_address%TYPE;
124: l_full_name per_people_f.full_name%TYPE;

Line 121: l_role_display_name wf_roles.display_name%TYPE;

117: cursor C_user_email(x_employee_id NUMBER) is
118: select email_address, full_name from PER_PEOPLE_F where person_id = x_employee_id;
119:
120: l_role_name wf_roles.name%TYPE;
121: l_role_display_name wf_roles.display_name%TYPE;
122:
123: l_email per_people_f.email_address%TYPE;
124: l_full_name per_people_f.full_name%TYPE;
125:

Line 406: l_int_role_display_name wf_roles.display_name%TYPE;

402:
403: l_ext_contact_name PER_ALL_PEOPLE_F.full_name%TYPE;
404: l_int_contact_name PER_ALL_PEOPLE_F.full_name%TYPE;
405:
406: l_int_role_display_name wf_roles.display_name%TYPE;
407: l_req_role_display_name wf_roles.display_name%TYPE;
408: l_ext_role_display_name wf_roles.display_name%TYPE;
409: l_fnd_user_id fnd_user.user_id%TYPE;
410:

Line 407: l_req_role_display_name wf_roles.display_name%TYPE;

403: l_ext_contact_name PER_ALL_PEOPLE_F.full_name%TYPE;
404: l_int_contact_name PER_ALL_PEOPLE_F.full_name%TYPE;
405:
406: l_int_role_display_name wf_roles.display_name%TYPE;
407: l_req_role_display_name wf_roles.display_name%TYPE;
408: l_ext_role_display_name wf_roles.display_name%TYPE;
409: l_fnd_user_id fnd_user.user_id%TYPE;
410:
411: TYPE l_user_email_list IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER;

Line 408: l_ext_role_display_name wf_roles.display_name%TYPE;

404: l_int_contact_name PER_ALL_PEOPLE_F.full_name%TYPE;
405:
406: l_int_role_display_name wf_roles.display_name%TYPE;
407: l_req_role_display_name wf_roles.display_name%TYPE;
408: l_ext_role_display_name wf_roles.display_name%TYPE;
409: l_fnd_user_id fnd_user.user_id%TYPE;
410:
411: TYPE l_user_email_list IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER;
412: l_user_tbl l_user_email_list;