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.HR_APPROVAL_WF dependencies on WF_USERS

Line 84: l_approval_routing_username wf_users.name%type;

80: ,p_item_key in varchar2
81: ,p_approval_routing_id in per_people_f.person_id%type
82: ,p_router_index in number) is
83: --
84: l_approval_routing_username wf_users.name%type;
85: l_approval_routing_disp_name wf_users.display_name%type;
86: --
87: begin
88: --

Line 85: l_approval_routing_disp_name wf_users.display_name%type;

81: ,p_approval_routing_id in per_people_f.person_id%type
82: ,p_router_index in number) is
83: --
84: l_approval_routing_username wf_users.name%type;
85: l_approval_routing_disp_name wf_users.display_name%type;
86: --
87: begin
88: --
89: wf_directory.GetUserName(p_orig_system => 'PER'

Line 203: l_creator_username wf_users.name%type;

199: -- -------------------------------------------------------------------------
200: l_proc_name varchar2(61) := g_package||'initialise_item_attributes';
201: l_person_id per_people_f.person_id%type;
202: l_creator_person_id per_people_f.person_id%type;
203: l_creator_username wf_users.name%type;
204: l_creator_disp_name wf_users.display_name%type;
205: l_candidate_assignment_id per_assignments_f.assignment_id%type;
206: l_candidate_person_id per_people_f.person_id%type;
207: l_candidate_disp_name wf_users.display_name%type;

Line 204: l_creator_disp_name wf_users.display_name%type;

200: l_proc_name varchar2(61) := g_package||'initialise_item_attributes';
201: l_person_id per_people_f.person_id%type;
202: l_creator_person_id per_people_f.person_id%type;
203: l_creator_username wf_users.name%type;
204: l_creator_disp_name wf_users.display_name%type;
205: l_candidate_assignment_id per_assignments_f.assignment_id%type;
206: l_candidate_person_id per_people_f.person_id%type;
207: l_candidate_disp_name wf_users.display_name%type;
208: l_candidate_appl_number per_people_f.applicant_number%type;

Line 207: l_candidate_disp_name wf_users.display_name%type;

203: l_creator_username wf_users.name%type;
204: l_creator_disp_name wf_users.display_name%type;
205: l_candidate_assignment_id per_assignments_f.assignment_id%type;
206: l_candidate_person_id per_people_f.person_id%type;
207: l_candidate_disp_name wf_users.display_name%type;
208: l_candidate_appl_number per_people_f.applicant_number%type;
209: l_fwd_from_username wf_users.name%type;
210: l_fwd_from_disp_name wf_users.display_name%type;
211: l_url_index number default 1;

Line 209: l_fwd_from_username wf_users.name%type;

205: l_candidate_assignment_id per_assignments_f.assignment_id%type;
206: l_candidate_person_id per_people_f.person_id%type;
207: l_candidate_disp_name wf_users.display_name%type;
208: l_candidate_appl_number per_people_f.applicant_number%type;
209: l_fwd_from_username wf_users.name%type;
210: l_fwd_from_disp_name wf_users.display_name%type;
211: l_url_index number default 1;
212: l_max_urls number default 20;
213: --

Line 210: l_fwd_from_disp_name wf_users.display_name%type;

206: l_candidate_person_id per_people_f.person_id%type;
207: l_candidate_disp_name wf_users.display_name%type;
208: l_candidate_appl_number per_people_f.applicant_number%type;
209: l_fwd_from_username wf_users.name%type;
210: l_fwd_from_disp_name wf_users.display_name%type;
211: l_url_index number default 1;
212: l_max_urls number default 20;
213: --
214: begin

Line 1678: l_forward_from_username wf_users.name%type;

1674: -- local variables
1675: -- -------------------------------------------------------------------------
1676: l_creator_person_id per_people_f.person_id%type;
1677: l_forward_from_person_id per_people_f.person_id%type;
1678: l_forward_from_username wf_users.name%type;
1679: l_forward_from_disp_name wf_users.display_name%type;
1680: l_forward_to_person_id per_people_f.person_id%type;
1681: l_forward_to_username wf_users.name%type;
1682: l_forward_to_disp_name wf_users.display_name%type;

Line 1679: l_forward_from_disp_name wf_users.display_name%type;

1675: -- -------------------------------------------------------------------------
1676: l_creator_person_id per_people_f.person_id%type;
1677: l_forward_from_person_id per_people_f.person_id%type;
1678: l_forward_from_username wf_users.name%type;
1679: l_forward_from_disp_name wf_users.display_name%type;
1680: l_forward_to_person_id per_people_f.person_id%type;
1681: l_forward_to_username wf_users.name%type;
1682: l_forward_to_disp_name wf_users.display_name%type;
1683: l_proc_name varchar2(61) := g_package||'get_next_approver';

Line 1681: l_forward_to_username wf_users.name%type;

1677: l_forward_from_person_id per_people_f.person_id%type;
1678: l_forward_from_username wf_users.name%type;
1679: l_forward_from_disp_name wf_users.display_name%type;
1680: l_forward_to_person_id per_people_f.person_id%type;
1681: l_forward_to_username wf_users.name%type;
1682: l_forward_to_disp_name wf_users.display_name%type;
1683: l_proc_name varchar2(61) := g_package||'get_next_approver';
1684: l_current_forward_to_id per_people_f.person_id%type;
1685: l_current_forward_from_id per_people_f.person_id%type;

Line 1682: l_forward_to_disp_name wf_users.display_name%type;

1678: l_forward_from_username wf_users.name%type;
1679: l_forward_from_disp_name wf_users.display_name%type;
1680: l_forward_to_person_id per_people_f.person_id%type;
1681: l_forward_to_username wf_users.name%type;
1682: l_forward_to_disp_name wf_users.display_name%type;
1683: l_proc_name varchar2(61) := g_package||'get_next_approver';
1684: l_current_forward_to_id per_people_f.person_id%type;
1685: l_current_forward_from_id per_people_f.person_id%type;
1686: --