DBA Data[Home] [Help]

APPS.HR_APPROVAL_CUSTOM dependencies on PER_PEOPLE_F

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

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

Line 16: return per_people_f.person_id%type;

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

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

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

Line 27: return per_people_f.person_id%type;

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

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

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

Line 38: return per_people_f.person_id%type;

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

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

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

Line 48: return per_people_f.person_id%type;

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

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

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

Line 59: return per_people_f.person_id%type;

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

Line 71: (p_forward_to_person_id in per_people_f.person_id%type

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

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

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

Line 86: (p_forward_to_person_id in per_people_f.person_id%type

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

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

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

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

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

Line 100: return per_people_f.person_id%type;

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

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

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

Line 112: return per_people_f.person_id%type;

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

Line 343: (p_forward_to_person_id in per_people_f.person_id%type

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;

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

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;