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_OFFER_WF dependencies on WF_USERS

Line 94: l_hiring_mgr_username wf_users.name%type;

90: funmode in varchar2,
91: result out nocopy varchar2 ) is
92: --
93: l_hiring_mgr_id per_people_f.person_id%type;
94: l_hiring_mgr_username wf_users.name%type;
95: l_hiring_mgr_disp_name wf_users.display_name%type;
96: l_candidate_assignment_id per_assignments_f.assignment_id%type;
97: l_candidate_person_id per_people_f.person_id%type;
98: l_candidate_disp_name wf_users.display_name%type;

Line 95: l_hiring_mgr_disp_name wf_users.display_name%type;

91: result out nocopy varchar2 ) is
92: --
93: l_hiring_mgr_id per_people_f.person_id%type;
94: l_hiring_mgr_username wf_users.name%type;
95: l_hiring_mgr_disp_name wf_users.display_name%type;
96: l_candidate_assignment_id per_assignments_f.assignment_id%type;
97: l_candidate_person_id per_people_f.person_id%type;
98: l_candidate_disp_name wf_users.display_name%type;
99: l_candidate_appl_number per_people_f.applicant_number%type;

Line 98: l_candidate_disp_name wf_users.display_name%type;

94: l_hiring_mgr_username wf_users.name%type;
95: l_hiring_mgr_disp_name wf_users.display_name%type;
96: l_candidate_assignment_id per_assignments_f.assignment_id%type;
97: l_candidate_person_id per_people_f.person_id%type;
98: l_candidate_disp_name wf_users.display_name%type;
99: l_candidate_appl_number per_people_f.applicant_number%type;
100: l_fwd_from_username wf_users.name%type;
101: l_fwd_from_disp_name wf_users.display_name%type;
102: l_resubmit_offer_savepoint wf_process_activities.instance_label%type;

Line 100: l_fwd_from_username wf_users.name%type;

96: l_candidate_assignment_id per_assignments_f.assignment_id%type;
97: l_candidate_person_id per_people_f.person_id%type;
98: l_candidate_disp_name wf_users.display_name%type;
99: l_candidate_appl_number per_people_f.applicant_number%type;
100: l_fwd_from_username wf_users.name%type;
101: l_fwd_from_disp_name wf_users.display_name%type;
102: l_resubmit_offer_savepoint wf_process_activities.instance_label%type;
103: --
104: --

Line 101: l_fwd_from_disp_name wf_users.display_name%type;

97: l_candidate_person_id per_people_f.person_id%type;
98: l_candidate_disp_name wf_users.display_name%type;
99: l_candidate_appl_number per_people_f.applicant_number%type;
100: l_fwd_from_username wf_users.name%type;
101: l_fwd_from_disp_name wf_users.display_name%type;
102: l_resubmit_offer_savepoint wf_process_activities.instance_label%type;
103: --
104: --
105: begin

Line 260: l_fwd_from_username wf_users.name%type;

256: result out nocopy varchar2 ) is
257: --
258: l_hiring_mgr_id per_people_f.person_id%type;
259: l_fwd_from_id per_people_f.person_id%type;
260: l_fwd_from_username wf_users.name%type;
261: l_fwd_from_disp_name wf_users.display_name%type;
262: l_fwd_to_id per_people_f.person_id%type;
263: l_fwd_to_username wf_users.name%type;
264: l_fwd_to_disp_name wf_users.display_name%type;

Line 261: l_fwd_from_disp_name wf_users.display_name%type;

257: --
258: l_hiring_mgr_id per_people_f.person_id%type;
259: l_fwd_from_id per_people_f.person_id%type;
260: l_fwd_from_username wf_users.name%type;
261: l_fwd_from_disp_name wf_users.display_name%type;
262: l_fwd_to_id per_people_f.person_id%type;
263: l_fwd_to_username wf_users.name%type;
264: l_fwd_to_disp_name wf_users.display_name%type;
265:

Line 263: l_fwd_to_username wf_users.name%type;

259: l_fwd_from_id per_people_f.person_id%type;
260: l_fwd_from_username wf_users.name%type;
261: l_fwd_from_disp_name wf_users.display_name%type;
262: l_fwd_to_id per_people_f.person_id%type;
263: l_fwd_to_username wf_users.name%type;
264: l_fwd_to_disp_name wf_users.display_name%type;
265:
266: --
267: begin

Line 264: l_fwd_to_disp_name wf_users.display_name%type;

260: l_fwd_from_username wf_users.name%type;
261: l_fwd_from_disp_name wf_users.display_name%type;
262: l_fwd_to_id per_people_f.person_id%type;
263: l_fwd_to_username wf_users.name%type;
264: l_fwd_to_disp_name wf_users.display_name%type;
265:
266: --
267: begin
268: --

Line 787: l_hr_routing_username wf_users.name%type;

783: result out nocopy varchar2 ) is
784:
785: l_hiring_mgr_id per_people_f.person_id%type;
786: l_hr_routing_id per_people_f.person_id%type;
787: l_hr_routing_username wf_users.name%type;
788: l_hr_routing_disp_name wf_users.display_name%type;
789: --
790: begin
791: --

Line 788: l_hr_routing_disp_name wf_users.display_name%type;

784:
785: l_hiring_mgr_id per_people_f.person_id%type;
786: l_hr_routing_id per_people_f.person_id%type;
787: l_hr_routing_username wf_users.name%type;
788: l_hr_routing_disp_name wf_users.display_name%type;
789: --
790: begin
791: --
792: if ( funmode = 'RUN' ) then

Line 990: l_candidate_disp_name wf_users.display_name%type;

986:
987: -- 05/08/97 Change Begins
988: --
989: l_candidate_person_id per_people_f.person_id%type;
990: l_candidate_disp_name wf_users.display_name%type;
991: l_candidate_appl_number per_people_f.applicant_number%type;
992: --
993: -- 05/08/97 Change Ends
994: --