APPS.OKC_DELIVERABLE_WF_PVT dependencies on WF_ROLES

Line 105: l_role_name wf_roles.name%TYPE;

101: --bug#4694703 replaced hr_employees_current_v with PER_PEOPLE_F
102: cursor C_user_email(x_employee_id NUMBER) is
103: select email_address, full_name from PER_PEOPLE_F where person_id = x_employee_id;
104:
105: l_role_name wf_roles.name%TYPE;
106: l_role_display_name wf_roles.display_name%TYPE;
107:
108: l_email per_people_f.email_address%TYPE;
109: l_full_name per_people_f.full_name%TYPE;

Line 106: l_role_display_name wf_roles.display_name%TYPE;

102: cursor C_user_email(x_employee_id NUMBER) is
103: select email_address, full_name from PER_PEOPLE_F where person_id = x_employee_id;
104:
105: l_role_name wf_roles.name%TYPE;
106: l_role_display_name wf_roles.display_name%TYPE;
107:
108: l_email per_people_f.email_address%TYPE;
109: l_full_name per_people_f.full_name%TYPE;
110:

Line 366: l_int_role_display_name wf_roles.display_name%TYPE;

362: select email_address
363: from hz_parties
364: where party_id=p_external_contact;*/
365:
366: l_int_role_display_name wf_roles.display_name%TYPE;
367: l_req_role_display_name wf_roles.display_name%TYPE;
368: l_ext_role_display_name wf_roles.display_name%TYPE;
369: l_fnd_user_id fnd_user.user_id%TYPE;
370:

Line 367: l_req_role_display_name wf_roles.display_name%TYPE;

363: from hz_parties
364: where party_id=p_external_contact;*/
365:
366: l_int_role_display_name wf_roles.display_name%TYPE;
367: l_req_role_display_name wf_roles.display_name%TYPE;
368: l_ext_role_display_name wf_roles.display_name%TYPE;
369: l_fnd_user_id fnd_user.user_id%TYPE;
370:
371: TYPE l_user_email_list IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER;

Line 368: l_ext_role_display_name wf_roles.display_name%TYPE;

364: where party_id=p_external_contact;*/
365:
366: l_int_role_display_name wf_roles.display_name%TYPE;
367: l_req_role_display_name wf_roles.display_name%TYPE;
368: l_ext_role_display_name wf_roles.display_name%TYPE;
369: l_fnd_user_id fnd_user.user_id%TYPE;
370:
371: TYPE l_user_email_list IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER;
372: l_user_tbl l_user_email_list;