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_CUSTOM dependencies on PER_PEOPLE_F

Line 63: (p_person_id in per_people_f.person_id%type)

59: -- Called from workflow/offer letter generation.
60: --
61: -- ----------------------------------------------------------------------------
62: function get_hr_routing1
63: (p_person_id in per_people_f.person_id%type)
64: return per_people_f.person_id%type;
65: -- ----------------------------------------------------------------------------
66: -- |-----------------------------< get_hr_routing2 >--------------------------|
67: -- ----------------------------------------------------------------------------

Line 64: return per_people_f.person_id%type;

60: --
61: -- ----------------------------------------------------------------------------
62: function get_hr_routing1
63: (p_person_id in per_people_f.person_id%type)
64: return per_people_f.person_id%type;
65: -- ----------------------------------------------------------------------------
66: -- |-----------------------------< get_hr_routing2 >--------------------------|
67: -- ----------------------------------------------------------------------------
68: --

Line 91: (p_person_id in per_people_f.person_id%type)

87: -- Called from workflow/offer letter generation.
88: --
89: -- ----------------------------------------------------------------------------
90: function get_hr_routing2
91: (p_person_id in per_people_f.person_id%type)
92: return per_people_f.person_id%type;
93: -- ----------------------------------------------------------------------------
94: -- |-----------------------------< get_hr_routing3 >--------------------------|
95: -- ----------------------------------------------------------------------------

Line 92: return per_people_f.person_id%type;

88: --
89: -- ----------------------------------------------------------------------------
90: function get_hr_routing2
91: (p_person_id in per_people_f.person_id%type)
92: return per_people_f.person_id%type;
93: -- ----------------------------------------------------------------------------
94: -- |-----------------------------< get_hr_routing3 >--------------------------|
95: -- ----------------------------------------------------------------------------
96: --

Line 119: (p_person_id in per_people_f.person_id%type)

115: -- Called from workflow/offer letter generation.
116: --
117: -- ----------------------------------------------------------------------------
118: function get_hr_routing3
119: (p_person_id in per_people_f.person_id%type)
120: return per_people_f.person_id%type;
121: -- ----------------------------------------------------------------------------
122: -- |---------------------------< get_candidate_details >----------------------|
123: -- ----------------------------------------------------------------------------

Line 120: return per_people_f.person_id%type;

116: --
117: -- ----------------------------------------------------------------------------
118: function get_hr_routing3
119: (p_person_id in per_people_f.person_id%type)
120: return per_people_f.person_id%type;
121: -- ----------------------------------------------------------------------------
122: -- |---------------------------< get_candidate_details >----------------------|
123: -- ----------------------------------------------------------------------------
124: --

Line 156: ,p_candidate_person_id out nocopy per_people_f.person_id%type

152: --
153: -- ----------------------------------------------------------------------------
154: procedure get_candidate_details
155: (p_candidate_assignment_id in per_assignments_f.assignment_id%type
156: ,p_candidate_person_id out nocopy per_people_f.person_id%type
157: ,p_candidate_disp_name out nocopy varchar2
158: ,p_applicant_number out nocopy per_people_f.applicant_number%type);
159: -- ----------------------------------------------------------------------------
160: -- |-------------------------< get_hr_manager_details >-----------------------|

Line 158: ,p_applicant_number out nocopy per_people_f.applicant_number%type);

154: procedure get_candidate_details
155: (p_candidate_assignment_id in per_assignments_f.assignment_id%type
156: ,p_candidate_person_id out nocopy per_people_f.person_id%type
157: ,p_candidate_disp_name out nocopy varchar2
158: ,p_applicant_number out nocopy per_people_f.applicant_number%type);
159: -- ----------------------------------------------------------------------------
160: -- |-------------------------< get_hr_manager_details >-----------------------|
161: -- ----------------------------------------------------------------------------
162: --

Line 186: (p_person_id in per_people_f.person_id%type)

182: -- Called from offer letter generation.
183: --
184: -- ----------------------------------------------------------------------------
185: function get_hr_manager_details
186: (p_person_id in per_people_f.person_id%type)
187: return per_people_f.person_id%type;
188: -- ----------------------------------------------------------------------------
189: -- |---------------------< set_training_admin_person >------------------------|
190: -- ----------------------------------------------------------------------------

Line 187: return per_people_f.person_id%type;

183: --
184: -- ----------------------------------------------------------------------------
185: function get_hr_manager_details
186: (p_person_id in per_people_f.person_id%type)
187: return per_people_f.person_id%type;
188: -- ----------------------------------------------------------------------------
189: -- |---------------------< set_training_admin_person >------------------------|
190: -- ----------------------------------------------------------------------------
191: --

Line 270: (p_person_id in per_people_f.person_id%type)

266: -- Called from workflow.
267: --
268: -- ----------------------------------------------------------------------------
269: function get_next_approver
270: (p_person_id in per_people_f.person_id%type)
271: return per_people_f.person_id%type;
272: -- ------------------------------------------------------------------------
273: -- |---------------------< get_url_string >----------------------------------|
274: -- ------------------------------------------------------------------------

Line 271: return per_people_f.person_id%type;

267: --
268: -- ----------------------------------------------------------------------------
269: function get_next_approver
270: (p_person_id in per_people_f.person_id%type)
271: return per_people_f.person_id%type;
272: -- ------------------------------------------------------------------------
273: -- |---------------------< get_url_string >----------------------------------|
274: -- ------------------------------------------------------------------------
275: --

Line 355: ,p_fwd_to_mgr_id in per_people_f.person_id%type

351: --
352: -- ----------------------------------------------------------------------------
353: function check_final_approver
354: (p_candidate_assignment_id in per_assignments_f.assignment_id%type
355: ,p_fwd_to_mgr_id in per_people_f.person_id%type
356: ,p_person_id in per_people_f.person_id%type)
357: return varchar2;
358: -- ----------------------------------------------------------------------------
359: -- |-----------------------< check_if_in_approval_chain >---------------------|

Line 356: ,p_person_id in per_people_f.person_id%type)

352: -- ----------------------------------------------------------------------------
353: function check_final_approver
354: (p_candidate_assignment_id in per_assignments_f.assignment_id%type
355: ,p_fwd_to_mgr_id in per_people_f.person_id%type
356: ,p_person_id in per_people_f.person_id%type)
357: return varchar2;
358: -- ----------------------------------------------------------------------------
359: -- |-----------------------< check_if_in_approval_chain >---------------------|
360: -- ----------------------------------------------------------------------------

Line 388: (p_person_id in per_people_f.person_id%type

384: -- Called from workflow.
385: --
386: -- ----------------------------------------------------------------------------
387: function check_if_in_approval_chain
388: (p_person_id in per_people_f.person_id%type
389: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type)
390: return boolean;
391: -- ----------------------------------------------------------------------------
392: -- |--------------------------< get_signatories_details >---------------------|

Line 421: (p_person_id in per_people_f.person_id%type

417: -- Called from offer letter generation.
418: --
419: -- ----------------------------------------------------------------------------
420: procedure get_signatories_details
421: (p_person_id in per_people_f.person_id%type
422: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type
423: ,p_signatory_id1 out nocopy per_people_f.person_id%type
424: ,p_position_title1 out nocopy varchar2
425: ,p_signatory_id2 out nocopy per_people_f.person_id%type

Line 423: ,p_signatory_id1 out nocopy per_people_f.person_id%type

419: -- ----------------------------------------------------------------------------
420: procedure get_signatories_details
421: (p_person_id in per_people_f.person_id%type
422: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type
423: ,p_signatory_id1 out nocopy per_people_f.person_id%type
424: ,p_position_title1 out nocopy varchar2
425: ,p_signatory_id2 out nocopy per_people_f.person_id%type
426: ,p_position_title2 out nocopy varchar2
427: ,p_signatory_id3 out nocopy per_people_f.person_id%type

Line 425: ,p_signatory_id2 out nocopy per_people_f.person_id%type

421: (p_person_id in per_people_f.person_id%type
422: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type
423: ,p_signatory_id1 out nocopy per_people_f.person_id%type
424: ,p_position_title1 out nocopy varchar2
425: ,p_signatory_id2 out nocopy per_people_f.person_id%type
426: ,p_position_title2 out nocopy varchar2
427: ,p_signatory_id3 out nocopy per_people_f.person_id%type
428: ,p_position_title3 out nocopy varchar2);
429: --

Line 427: ,p_signatory_id3 out nocopy per_people_f.person_id%type

423: ,p_signatory_id1 out nocopy per_people_f.person_id%type
424: ,p_position_title1 out nocopy varchar2
425: ,p_signatory_id2 out nocopy per_people_f.person_id%type
426: ,p_position_title2 out nocopy varchar2
427: ,p_signatory_id3 out nocopy per_people_f.person_id%type
428: ,p_position_title3 out nocopy varchar2);
429: --
430: -- ----------------------------------------------------------------------------
431: -- |--------------------------< set_status_to_offer >-------------------------|