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 PER_PEOPLE_F

Line 93: l_hiring_mgr_id per_people_f.person_id%type;

89: actid in number,
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;

Line 97: l_candidate_person_id per_people_f.person_id%type;

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;
100: l_fwd_from_username wf_users.name%type;
101: l_fwd_from_disp_name wf_users.display_name%type;

Line 99: l_candidate_appl_number per_people_f.applicant_number%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;
103: --

Line 258: l_hiring_mgr_id per_people_f.person_id%type;

254: actid in number,
255: funmode in varchar2,
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;

Line 259: l_fwd_from_id per_people_f.person_id%type;

255: funmode in varchar2,
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;

Line 262: l_fwd_to_id per_people_f.person_id%type;

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:
266: --

Line 377: l_hiring_mgr_id per_people_f.person_id%type;

373: actid in number,
374: funmode in varchar2,
375: result out nocopy varchar2 ) is
376: --
377: l_hiring_mgr_id per_people_f.person_id%type;
378: l_fwd_to_id per_people_f.person_id%type;
379: l_candidate_assignment_id per_assignments_f.assignment_id%type;
380: --
381: begin

Line 378: l_fwd_to_id per_people_f.person_id%type;

374: funmode in varchar2,
375: result out nocopy varchar2 ) is
376: --
377: l_hiring_mgr_id per_people_f.person_id%type;
378: l_fwd_to_id per_people_f.person_id%type;
379: l_candidate_assignment_id per_assignments_f.assignment_id%type;
380: --
381: begin
382: --

Line 505: l_hiring_mgr_id per_people_f.person_id%type;

501: actid in number,
502: funmode in varchar2,
503: result out nocopy varchar2 ) is
504: --
505: l_hiring_mgr_id per_people_f.person_id%type;
506: l_fwd_from_id per_people_f.person_id%type;
507: --
508: begin
509: --

Line 506: l_fwd_from_id per_people_f.person_id%type;

502: funmode in varchar2,
503: result out nocopy varchar2 ) is
504: --
505: l_hiring_mgr_id per_people_f.person_id%type;
506: l_fwd_from_id per_people_f.person_id%type;
507: --
508: begin
509: --
510: if ( funmode = 'RUN' ) then

Line 549: l_candidate_person_id per_people_f.person_id%type;

545: funmode in varchar2,
546: result out nocopy varchar2 ) is
547: --
548: l_candidate_assignment_id per_assignments_f.assignment_id%type;
549: l_candidate_person_id per_people_f.person_id%type;
550: begin
551: --
552: if ( funmode = 'RUN' ) then
553: --

Line 627: l_candidate_person_id per_people_f.person_id%type;

623: funmode in varchar2,
624: result out nocopy varchar2 ) is
625: --
626: l_candidate_assignment_id per_assignments_f.assignment_id%type;
627: l_candidate_person_id per_people_f.person_id%type;
628: l_host varchar2(200);
629: --
630: --
631: begin

Line 706: l_candidate_person_id per_people_f.person_id%type;

702: funmode in varchar2,
703: result out nocopy varchar2 ) is
704: --
705: l_candidate_assignment_id per_assignments_f.assignment_id%type;
706: l_candidate_person_id per_people_f.person_id%type;
707: --
708: --
709: begin
710: --

Line 785: l_hiring_mgr_id per_people_f.person_id%type;

781: actid in number,
782: funmode in varchar2,
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: --

Line 786: l_hr_routing_id per_people_f.person_id%type;

782: funmode in varchar2,
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

Line 989: l_candidate_person_id per_people_f.person_id%type;

985: organization hr_organization_units.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

Line 991: l_candidate_appl_number per_people_f.applicant_number%type;

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: --
995: begin