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 56: (p_person_id in per_people_f.person_id%type)

52: --
53: -- This is used for routing in the Web Offers workflow, 'Offer Letter'.
54: --
55: function get_hr_routing1
56: (p_person_id in per_people_f.person_id%type)
57: return per_people_f.person_id%type is
58: begin
59: -- [CUSTOMIZE]
60: -- This function will need to be modified by the end customer.

Line 57: return per_people_f.person_id%type is

53: -- This is used for routing in the Web Offers workflow, 'Offer Letter'.
54: --
55: function get_hr_routing1
56: (p_person_id in per_people_f.person_id%type)
57: return per_people_f.person_id%type is
58: begin
59: -- [CUSTOMIZE]
60: -- This function will need to be modified by the end customer.
61: -- We return the Hr Assistant id that handles the New Hire process

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

70: --
71: -- This is used for routing in the Web Offers workflow, 'Offer Letter'.
72: --
73: function get_hr_routing2
74: (p_person_id in per_people_f.person_id%type)
75: return per_people_f.person_id%type is
76: begin
77: -- [CUSTOMIZE]
78: -- This function will need to be modified by the end customer.

Line 75: return per_people_f.person_id%type is

71: -- This is used for routing in the Web Offers workflow, 'Offer Letter'.
72: --
73: function get_hr_routing2
74: (p_person_id in per_people_f.person_id%type)
75: return per_people_f.person_id%type is
76: begin
77: -- [CUSTOMIZE]
78: -- This function will need to be modified by the end customer.
79: -- We return a specific id that handles Mailing the letter,

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

90: --
91: -- This is used for routing in the Web Offers workflow, 'Offer Letter'.
92: --
93: function get_hr_routing3
94: (p_person_id in per_people_f.person_id%type)
95: return per_people_f.person_id%type is
96: begin
97: -- [CUSTOMIZE]
98: -- This function will need to be modified by the end customer.

Line 95: return per_people_f.person_id%type is

91: -- This is used for routing in the Web Offers workflow, 'Offer Letter'.
92: --
93: function get_hr_routing3
94: (p_person_id in per_people_f.person_id%type)
95: return per_people_f.person_id%type is
96: begin
97: -- [CUSTOMIZE]
98: -- This function will need to be modified by the end customer.
99: -- We return a specific id that handles database/system errors

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

107: -- (as first_name||last_name) of the Candidate.
108: --
109: procedure get_candidate_details
110: (p_candidate_assignment_id in per_assignments_f.assignment_id%type
111: ,p_candidate_person_id out nocopy per_people_f.person_id%type
112: ,p_candidate_disp_name out nocopy varchar2
113: ,p_applicant_number out nocopy per_people_f.applicant_number%type) is
114: --
115: cursor csr_pp(l_effective_date in date) is

Line 113: ,p_applicant_number out nocopy per_people_f.applicant_number%type) is

109: procedure get_candidate_details
110: (p_candidate_assignment_id in per_assignments_f.assignment_id%type
111: ,p_candidate_person_id out nocopy per_people_f.person_id%type
112: ,p_candidate_disp_name out nocopy varchar2
113: ,p_applicant_number out nocopy per_people_f.applicant_number%type) is
114: --
115: cursor csr_pp(l_effective_date in date) is
116: select ppf.person_id
117: ,ppf.first_name||' '||ppf.last_name

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

153: -- This function returns the Id of an HR manager that the candidate may want to
154: -- contact for more information. This appears on the offer letter.
155: --
156: function get_hr_manager_details
157: (p_person_id in per_people_f.person_id%type)
158: return per_people_f.person_id%type is
159: begin
160: -- [CUSTOMIZE]
161: -- This function will need to be modified by the end customer.

Line 158: return per_people_f.person_id%type is

154: -- contact for more information. This appears on the offer letter.
155: --
156: function get_hr_manager_details
157: (p_person_id in per_people_f.person_id%type)
158: return per_people_f.person_id%type is
159: begin
160: -- [CUSTOMIZE]
161: -- This function will need to be modified by the end customer.
162: -- Presently p_person_id is returned.

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

224: -- Get VP name to get the vice president's name to display on the Offer Page.
225: -- Get signatory details to decide who needs to sign the offer letter.
226: --
227: function get_next_approver
228: (p_person_id in per_people_f.person_id%type)
229: return per_people_f.person_id%type is
230: --
231: cursor csr_pa(l_effective_date in date
232: ,l_in_person_id in per_people_f.person_id%type) is

Line 229: return per_people_f.person_id%type is

225: -- Get signatory details to decide who needs to sign the offer letter.
226: --
227: function get_next_approver
228: (p_person_id in per_people_f.person_id%type)
229: return per_people_f.person_id%type is
230: --
231: cursor csr_pa(l_effective_date in date
232: ,l_in_person_id in per_people_f.person_id%type) is
233: select ppf.person_id

Line 232: ,l_in_person_id in per_people_f.person_id%type) is

228: (p_person_id in per_people_f.person_id%type)
229: return per_people_f.person_id%type is
230: --
231: cursor csr_pa(l_effective_date in date
232: ,l_in_person_id in per_people_f.person_id%type) is
233: select ppf.person_id
234: from per_all_assignments_f paf
235: ,per_all_people_f ppf
236: where paf.person_id = l_in_person_id

Line 247: l_out_person_id per_people_f.person_id%type default null;

243: and l_effective_date
244: between ppf.effective_start_date
245: and ppf.effective_end_date;
246: --
247: l_out_person_id per_people_f.person_id%type default null;
248: --
249: begin
250: -- [CUSTOMIZE]
251: -- open the candidate select cursor

Line 326: l_current_person_id per_people_f.person_id%type;

322: and pa.primary_flag = 'Y'
323: and pa.person_id = p_person_id;
324: --
325: l_in_chain boolean := false;
326: l_current_person_id per_people_f.person_id%type;
327: l_current_job per_jobs.name%type;
328: l_person_id per_people_f.person_id%type;
329: l_vp_name varchar(200);
330: l_found_it boolean default FALSE;

Line 328: l_person_id per_people_f.person_id%type;

324: --
325: l_in_chain boolean := false;
326: l_current_person_id per_people_f.person_id%type;
327: l_current_job per_jobs.name%type;
328: l_person_id per_people_f.person_id%type;
329: l_vp_name varchar(200);
330: l_found_it boolean default FALSE;
331: l_supervisors varchar2(32000);
332: l_dead_loop exception;

Line 401: ,p_fwd_to_mgr_id in per_people_f.person_id%type

397: -- to HR for printing/mailing.
398: --
399: function check_final_approver
400: (p_candidate_assignment_id in per_assignments_f.assignment_id%type
401: ,p_fwd_to_mgr_id in per_people_f.person_id%type
402: ,p_person_id in per_people_f.person_id%type)
403: return varchar2 is
404: --
405: cursor csr_pa(l_effective_date in date) is

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

398: --
399: function check_final_approver
400: (p_candidate_assignment_id in per_assignments_f.assignment_id%type
401: ,p_fwd_to_mgr_id in per_people_f.person_id%type
402: ,p_person_id in per_people_f.person_id%type)
403: return varchar2 is
404: --
405: cursor csr_pa(l_effective_date in date) is
406: select paf.person_id

Line 419: l_person_id per_people_f.person_id%type := null;

415: and l_effective_date
416: between paf.effective_start_date
417: and paf.effective_end_date;
418: --
419: l_person_id per_people_f.person_id%type := null;
420: --
421: begin
422: --
423: --

Line 450: (p_person_id in per_people_f.person_id%type

446: -- the offer information or not. It allows specific HR employee's to see the
447: -- data in update mode. It is used on the web pages.
448: --
449: function check_if_in_approval_chain
450: (p_person_id in per_people_f.person_id%type
451: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type)
452: return boolean is
453: --
454: --1754123 begin

Line 472: l_current_person_id per_people_f.person_id%type;

468: --1754123 end
469:
470: --
471: l_in_chain boolean := false;
472: l_current_person_id per_people_f.person_id%type;
473: l_person_id per_people_f.person_id%type;
474: --
475: begin
476: -- Oracle internal only:

Line 473: l_person_id per_people_f.person_id%type;

469:
470: --
471: l_in_chain boolean := false;
472: l_current_person_id per_people_f.person_id%type;
473: l_person_id per_people_f.person_id%type;
474: --
475: begin
476: -- Oracle internal only:
477: -- These are HR reps.

Line 512: (p_person_id in per_people_f.person_id%type

508: -- This function determines who should sign the offer letter. It's used when
509: -- generating the offer letter.
510: --
511: procedure get_signatories_details
512: (p_person_id in per_people_f.person_id%type
513: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type
514: ,p_signatory_id1 out nocopy per_people_f.person_id%type
515: ,p_position_title1 out nocopy varchar2
516: ,p_signatory_id2 out nocopy per_people_f.person_id%type

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

510: --
511: procedure get_signatories_details
512: (p_person_id in per_people_f.person_id%type
513: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type
514: ,p_signatory_id1 out nocopy per_people_f.person_id%type
515: ,p_position_title1 out nocopy varchar2
516: ,p_signatory_id2 out nocopy per_people_f.person_id%type
517: ,p_position_title2 out nocopy varchar2
518: ,p_signatory_id3 out nocopy per_people_f.person_id%type

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

512: (p_person_id in per_people_f.person_id%type
513: ,p_candidate_assignment_id in per_assignments_f.assignment_id%type
514: ,p_signatory_id1 out nocopy per_people_f.person_id%type
515: ,p_position_title1 out nocopy varchar2
516: ,p_signatory_id2 out nocopy per_people_f.person_id%type
517: ,p_position_title2 out nocopy varchar2
518: ,p_signatory_id3 out nocopy per_people_f.person_id%type
519: ,p_position_title3 out nocopy varchar2) is
520: --

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

514: ,p_signatory_id1 out nocopy per_people_f.person_id%type
515: ,p_position_title1 out nocopy varchar2
516: ,p_signatory_id2 out nocopy per_people_f.person_id%type
517: ,p_position_title2 out nocopy varchar2
518: ,p_signatory_id3 out nocopy per_people_f.person_id%type
519: ,p_position_title3 out nocopy varchar2) is
520: --
521: l_fwd_to_mgr_id per_people_f.person_id%type := p_person_id;
522: --

Line 521: l_fwd_to_mgr_id per_people_f.person_id%type := p_person_id;

517: ,p_position_title2 out nocopy varchar2
518: ,p_signatory_id3 out nocopy per_people_f.person_id%type
519: ,p_position_title3 out nocopy varchar2) is
520: --
521: l_fwd_to_mgr_id per_people_f.person_id%type := p_person_id;
522: --
523: begin
524: -- find the final approver
525: loop