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

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

8: -- ----------------------------------------------------------------------------
9: -- |------------------------------< get_routing_details1 >--------------------|
10: -- ----------------------------------------------------------------------------
11: function get_routing_details1
12: (p_person_id in per_people_f.person_id%type)
13: return per_people_f.person_id%type is
14: begin
15: -- [CUSTOMIZE]
16: -- This function will need to be modified by the end customer.

Line 13: return per_people_f.person_id%type is

9: -- |------------------------------< get_routing_details1 >--------------------|
10: -- ----------------------------------------------------------------------------
11: function get_routing_details1
12: (p_person_id in per_people_f.person_id%type)
13: return per_people_f.person_id%type is
14: begin
15: -- [CUSTOMIZE]
16: -- This function will need to be modified by the end customer.
17: return(null);

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

20: -- ----------------------------------------------------------------------------
21: -- |------------------------------< get_routing_details2 >--------------------|
22: -- ----------------------------------------------------------------------------
23: function get_routing_details2
24: (p_person_id in per_people_f.person_id%type)
25: return per_people_f.person_id%type is
26: begin
27: -- [CUSTOMIZE]
28: -- This function will need to be modified by the end customer.

Line 25: return per_people_f.person_id%type is

21: -- |------------------------------< get_routing_details2 >--------------------|
22: -- ----------------------------------------------------------------------------
23: function get_routing_details2
24: (p_person_id in per_people_f.person_id%type)
25: return per_people_f.person_id%type is
26: begin
27: -- [CUSTOMIZE]
28: -- This function will need to be modified by the end customer.
29: return(null);

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

32: -- ----------------------------------------------------------------------------
33: -- |------------------------------< get_routing_details3 >--------------------|
34: -- ----------------------------------------------------------------------------
35: function get_routing_details3
36: (p_person_id in per_people_f.person_id%type)
37: return per_people_f.person_id%type is
38: begin
39: -- [CUSTOMIZE]
40: -- This function will need to be modified by the end customer.

Line 37: return per_people_f.person_id%type is

33: -- |------------------------------< get_routing_details3 >--------------------|
34: -- ----------------------------------------------------------------------------
35: function get_routing_details3
36: (p_person_id in per_people_f.person_id%type)
37: return per_people_f.person_id%type is
38: begin
39: -- [CUSTOMIZE]
40: -- This function will need to be modified by the end customer.
41: return(null);

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

43: -- ----------------------------------------------------------------------------
44: -- |------------------------------< get_routing_details4 >--------------------|
45: -- ----------------------------------------------------------------------------
46: function get_routing_details4
47: (p_person_id in per_people_f.person_id%type)
48: return per_people_f.person_id%type is
49: begin
50: -- [CUSTOMIZE]
51: -- This function will need to be modified by the end customer.

Line 48: return per_people_f.person_id%type is

44: -- |------------------------------< get_routing_details4 >--------------------|
45: -- ----------------------------------------------------------------------------
46: function get_routing_details4
47: (p_person_id in per_people_f.person_id%type)
48: return per_people_f.person_id%type is
49: begin
50: -- [CUSTOMIZE]
51: -- This function will need to be modified by the end customer.
52: return(null);

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

55: -- ----------------------------------------------------------------------------
56: -- |------------------------------< get_routing_details5 >--------------------|
57: -- ----------------------------------------------------------------------------
58: function get_routing_details5
59: (p_person_id in per_people_f.person_id%type)
60: return per_people_f.person_id%type is
61: begin
62: -- [CUSTOMIZE]
63: -- This function will need to be modified by the end customer.

Line 60: return per_people_f.person_id%type is

56: -- |------------------------------< get_routing_details5 >--------------------|
57: -- ----------------------------------------------------------------------------
58: function get_routing_details5
59: (p_person_id in per_people_f.person_id%type)
60: return per_people_f.person_id%type is
61: begin
62: -- [CUSTOMIZE]
63: -- This function will need to be modified by the end customer.
64: return(null);

Line 70: (p_forward_to_person_id in per_people_f.person_id%type

66: -- ----------------------------------------------------------------------------
67: -- |--------------------------< check_final_approver >------------------------|
68: -- ----------------------------------------------------------------------------
69: function check_final_approver
70: (p_forward_to_person_id in per_people_f.person_id%type
71: ,p_person_id in per_people_f.person_id%type)
72: return varchar2 is
73: --
74: cursor csr_pa(l_effective_date in date) is

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

67: -- |--------------------------< check_final_approver >------------------------|
68: -- ----------------------------------------------------------------------------
69: function check_final_approver
70: (p_forward_to_person_id in per_people_f.person_id%type
71: ,p_person_id in per_people_f.person_id%type)
72: return varchar2 is
73: --
74: cursor csr_pa(l_effective_date in date) is
75: SELECT paf.person_id

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

85: AND paf.effective_end_date;
86:
87:
88: --
89: l_person_id per_people_f.person_id%type := null;
90: l_employee per_people_f.person_id%type := null;
91: --
92: begin
93: -- check if the start of the chain is a valid employee

Line 90: l_employee per_people_f.person_id%type := null;

86:
87:
88: --
89: l_person_id per_people_f.person_id%type := null;
90: l_employee per_people_f.person_id%type := null;
91: --
92: begin
93: -- check if the start of the chain is a valid employee
94: begin

Line 193: (p_forward_to_person_id in per_people_f.person_id%type

189: -- ----------------------------------------------------------------------------
190: -- |--------------------------< check_final_payroll_notifier >----------------|
191: -- ----------------------------------------------------------------------------
192: function check_final_payroll_notifier
193: (p_forward_to_person_id in per_people_f.person_id%type
194: ,p_person_id in per_people_f.person_id%type)
195: return varchar2 is
196: begin
197: -- [CUSTOMIZE]

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

190: -- |--------------------------< check_final_payroll_notifier >----------------|
191: -- ----------------------------------------------------------------------------
192: function check_final_payroll_notifier
193: (p_forward_to_person_id in per_people_f.person_id%type
194: ,p_person_id in per_people_f.person_id%type)
195: return varchar2 is
196: begin
197: -- [CUSTOMIZE]
198: return('Y');

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

200: -- ----------------------------------------------------------------------------
201: -- |-----------------------------< get_next_approver >------------------------|
202: -- ----------------------------------------------------------------------------
203: function get_next_approver
204: (p_person_id in per_people_f.person_id%type)
205: return per_people_f.person_id%type is
206: --
207: cursor csr_pa(l_effective_date in date
208: ,l_in_person_id in per_people_f.person_id%type) is

Line 205: return per_people_f.person_id%type is

201: -- |-----------------------------< get_next_approver >------------------------|
202: -- ----------------------------------------------------------------------------
203: function get_next_approver
204: (p_person_id in per_people_f.person_id%type)
205: return per_people_f.person_id%type is
206: --
207: cursor csr_pa(l_effective_date in date
208: ,l_in_person_id in per_people_f.person_id%type) is
209: /*

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

204: (p_person_id in per_people_f.person_id%type)
205: return per_people_f.person_id%type is
206: --
207: cursor csr_pa(l_effective_date in date
208: ,l_in_person_id in per_people_f.person_id%type) is
209: /*
210: -- Modified the cursor to support Contingent Worker
211: -- Fix for bug#2949844
212: select ppf.person_id

Line 215: --,per_people_f ppf

211: -- Fix for bug#2949844
212: select ppf.person_id
213: from per_all_assignments_f paf
214: -- fix for bug # 1677216
215: --,per_people_f ppf
216: ,per_all_people_f ppf
217: where paf.person_id = l_in_person_id
218: and paf.primary_flag = 'Y'
219: and l_effective_date

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

245: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date;
246: --
247:
248: --
249: l_out_person_id per_people_f.person_id%type default null;
250: --
251: begin
252: -- [CUSTOMIZE]
253: -- open the candidate select cursor

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

267: -- ----------------------------------------------------------------------------
268: -- |-----------------------------< get_next_payroll_notifier >----------------|
269: -- ----------------------------------------------------------------------------
270: function get_next_payroll_notifier
271: (p_person_id in per_people_f.person_id%type)
272: return per_people_f.person_id%type is
273: begin
274: -- [CUSTOMIZE]
275: return null;

Line 272: return per_people_f.person_id%type is

268: -- |-----------------------------< get_next_payroll_notifier >----------------|
269: -- ----------------------------------------------------------------------------
270: function get_next_payroll_notifier
271: (p_person_id in per_people_f.person_id%type)
272: return per_people_f.person_id%type is
273: begin
274: -- [CUSTOMIZE]
275: return null;
276: end get_next_payroll_notifier;

Line 522: (p_forward_to_person_id in per_people_f.person_id%type

518: -- ----------------------------------------------------------------------------
519: -- |-----------------------< check_if_in_approval_chain >---------------------|
520: -- ----------------------------------------------------------------------------
521: function check_if_in_approval_chain
522: (p_forward_to_person_id in per_people_f.person_id%type
523: ,p_person_id in per_people_f.person_id%type)
524: return boolean is
525: --
526: l_in_chain boolean := false;

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

519: -- |-----------------------< check_if_in_approval_chain >---------------------|
520: -- ----------------------------------------------------------------------------
521: function check_if_in_approval_chain
522: (p_forward_to_person_id in per_people_f.person_id%type
523: ,p_person_id in per_people_f.person_id%type)
524: return boolean is
525: --
526: l_in_chain boolean := false;
527: l_current_person_id per_people_f.person_id%type := p_person_id;

Line 527: l_current_person_id per_people_f.person_id%type := p_person_id;

523: ,p_person_id in per_people_f.person_id%type)
524: return boolean is
525: --
526: l_in_chain boolean := false;
527: l_current_person_id per_people_f.person_id%type := p_person_id;
528: l_person_id per_people_f.person_id%type;
529: --
530: begin
531: --

Line 528: l_person_id per_people_f.person_id%type;

524: return boolean is
525: --
526: l_in_chain boolean := false;
527: l_current_person_id per_people_f.person_id%type := p_person_id;
528: l_person_id per_people_f.person_id%type;
529: --
530: begin
531: --
532: while l_current_person_id is not null loop