11: -- This function returns the Id of a person. Used for routing of notifications
12: -- within the approval process
13: --
14: function get_routing_details1
15: (p_person_id in per_people_f.person_id%type)
16: return per_people_f.person_id%type;
17: --
18: -- ----------------------------------------------------------------------------
19: -- |------------------------------< get_routing_details2 >--------------------|
12: -- within the approval process
13: --
14: function get_routing_details1
15: (p_person_id in per_people_f.person_id%type)
16: return per_people_f.person_id%type;
17: --
18: -- ----------------------------------------------------------------------------
19: -- |------------------------------< get_routing_details2 >--------------------|
20: -- ----------------------------------------------------------------------------
22: -- This function returns the Id of a person. Used for routing of notifications
23: -- within the approval process
24: --
25: function get_routing_details2
26: (p_person_id in per_people_f.person_id%type)
27: return per_people_f.person_id%type;
28: --
29: -- ----------------------------------------------------------------------------
30: -- |------------------------------< get_routing_details3 >--------------------|
23: -- within the approval process
24: --
25: function get_routing_details2
26: (p_person_id in per_people_f.person_id%type)
27: return per_people_f.person_id%type;
28: --
29: -- ----------------------------------------------------------------------------
30: -- |------------------------------< get_routing_details3 >--------------------|
31: -- ----------------------------------------------------------------------------
33: -- This function returns the Id of a person. Used for routing of notifications
34: -- within the approval process
35: --
36: function get_routing_details3
37: (p_person_id in per_people_f.person_id%type)
38: return per_people_f.person_id%type;
39: -- ----------------------------------------------------------------------------
40: -- |------------------------------< get_routing_details4 >--------------------|
41: -- ----------------------------------------------------------------------------
34: -- within the approval process
35: --
36: function get_routing_details3
37: (p_person_id in per_people_f.person_id%type)
38: return per_people_f.person_id%type;
39: -- ----------------------------------------------------------------------------
40: -- |------------------------------< get_routing_details4 >--------------------|
41: -- ----------------------------------------------------------------------------
42: --
43: -- This function returns the Id of a person. Used for routing of notifications
44: -- within the approval process
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;
49: --
50: -- ----------------------------------------------------------------------------
51: -- |------------------------------< get_routing_details5 >--------------------|
44: -- within the approval process
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;
49: --
50: -- ----------------------------------------------------------------------------
51: -- |------------------------------< get_routing_details5 >--------------------|
52: -- ----------------------------------------------------------------------------
54: -- This function returns the Id of a person. Used for routing of notifications
55: -- within the approval process
56: --
57: function get_routing_details5
58: (p_person_id in per_people_f.person_id%type)
59: return per_people_f.person_id%type;
60: --
61: -- ------------------------------------------------------------------------
62: -- |----------------------< Check_Final_Approver >-------------------------|
55: -- within the approval process
56: --
57: function get_routing_details5
58: (p_person_id in per_people_f.person_id%type)
59: return per_people_f.person_id%type;
60: --
61: -- ------------------------------------------------------------------------
62: -- |----------------------< Check_Final_Approver >-------------------------|
63: -- ------------------------------------------------------------------------
67: -- Determine if this person is the final manager in the approval chain
68: --
69: --
70: function Check_Final_Approver
71: (p_forward_to_person_id in per_people_f.person_id%type
72: ,p_person_id in per_people_f.person_id%type)
73: return varchar2;
74: --
75: -- ------------------------------------------------------------------------
68: --
69: --
70: function Check_Final_Approver
71: (p_forward_to_person_id in per_people_f.person_id%type
72: ,p_person_id in per_people_f.person_id%type)
73: return varchar2;
74: --
75: -- ------------------------------------------------------------------------
76: -- |----------------------< Check_Final_Payroll_Notifier >----------------|
82: -- notification chain
83: --
84: --
85: function Check_Final_Payroll_Notifier
86: (p_forward_to_person_id in per_people_f.person_id%type
87: ,p_person_id in per_people_f.person_id%type)
88: return varchar2;
89: -- ------------------------------------------------------------------------
90: -- |------------------------< Get_next_approver >-------------------------|
83: --
84: --
85: function Check_Final_Payroll_Notifier
86: (p_forward_to_person_id in per_people_f.person_id%type
87: ,p_person_id in per_people_f.person_id%type)
88: return varchar2;
89: -- ------------------------------------------------------------------------
90: -- |------------------------< Get_next_approver >-------------------------|
91: -- ------------------------------------------------------------------------
95: -- Get the next approver in the chain
96: --
97: --
98: function Get_Next_Approver
99: (p_person_id in per_people_f.person_id%type)
100: return per_people_f.person_id%type;
101: -- ------------------------------------------------------------------------
102: -- |------------------------< Get_next_payroll_notifier >-----------------|
103: -- ------------------------------------------------------------------------
96: --
97: --
98: function Get_Next_Approver
99: (p_person_id in per_people_f.person_id%type)
100: return per_people_f.person_id%type;
101: -- ------------------------------------------------------------------------
102: -- |------------------------< Get_next_payroll_notifier >-----------------|
103: -- ------------------------------------------------------------------------
104: --
107: -- Get the next payroll notifier in the payroll notification chain
108: --
109: --
110: function Get_Next_Payroll_Notifier
111: (p_person_id in per_people_f.person_id%type)
112: return per_people_f.person_id%type;
113: -- ------------------------------------------------------------------------
114: -- |------------------------------< get_URL1 >-----------------------------|
115: -- ------------------------------------------------------------------------
108: --
109: --
110: function Get_Next_Payroll_Notifier
111: (p_person_id in per_people_f.person_id%type)
112: return per_people_f.person_id%type;
113: -- ------------------------------------------------------------------------
114: -- |------------------------------< get_URL1 >-----------------------------|
115: -- ------------------------------------------------------------------------
116: --
339: -- This function will return true if the forward to person is in
340: -- the approval chain of the current person
341: --
342: function check_if_in_approval_chain
343: (p_forward_to_person_id in per_people_f.person_id%type
344: ,p_person_id in per_people_f.person_id%type)
345: return boolean;
346: --
347: end hr_approval_custom;
340: -- the approval chain of the current person
341: --
342: function check_if_in_approval_chain
343: (p_forward_to_person_id in per_people_f.person_id%type
344: ,p_person_id in per_people_f.person_id%type)
345: return boolean;
346: --
347: end hr_approval_custom;