1 PACKAGE hr_disc_calculations AUTHID CURRENT_USER as
2 /* $Header: hrdicalc.pkh 115.14 2002/08/22 09:21:45 jtitmas ship $ */
3
4 -----------------------------------
5 -- Package functions and procedures
6 -----------------------------------
7
8 FUNCTION vacancy_hires(p_vacancy IN VARCHAR2,
9 p_business_group IN VARCHAR2,
10 p_requisition IN VARCHAR2,
11 p_applicant_number IN VARCHAR2)
12 RETURN NUMBER;
13
14 FUNCTION vacancy_offers(p_vacancy IN VARCHAR2,
15 p_business_group IN VARCHAR2,
16 p_requisition IN VARCHAR2)
17 RETURN NUMBER;
18
19 FUNCTION rec_activity_hires(p_rec_activity IN VARCHAR2,
20 p_business_group IN VARCHAR2,
21 p_applicant_number IN VARCHAR2)
22 RETURN NUMBER;
23
24 FUNCTION rec_activity_offers(p_rec_activity IN VARCHAR2,
25 p_business_group IN VARCHAR2)
26 RETURN NUMBER;
27
28 FUNCTION rec_activity_vacancy_hires(p_rec_activity IN VARCHAR2,
29 p_vacancy IN VARCHAR2,
30 p_business_group IN VARCHAR2,
31 p_applicant_number IN VARCHAR2)
32 RETURN NUMBER;
33
34 FUNCTION rec_activity_vacancy_offers(p_rec_activity IN VARCHAR2,
35 p_vacancy IN VARCHAR2,
36 p_business_group IN VARCHAR2)
37 RETURN NUMBER;
38
39 FUNCTION hiring_cost_current_emp(p_rec_act_id IN NUMBER,
40 p_actual_cost IN NUMBER)
41 RETURN NUMBER;
42
43 FUNCTION active_vacancy(p_date_from IN DATE,
44 p_date_to IN DATE)
45 RETURN VARCHAR2;
46
47 -- Function to determine the appropriate FastFormula Id to be used
48 -- for calculating manpower actuals
49
50 FUNCTION get_manpower_formula_id
51 (p_business_group_id IN NUMBER
52 ,p_budget_measurement_code IN VARCHAR2
53 )
54 RETURN NUMBER;
55 -- Function to calculate manpower actuals for a single assignment
56
57 FUNCTION get_ff_actual_value
58 (p_budget_id IN NUMBER
59 ,p_formula_id IN NUMBER
60 ,p_grade_id IN NUMBER DEFAULT NULL
61 ,p_job_id IN NUMBER DEFAULT NULL
62 ,p_organization_id IN NUMBER DEFAULT NULL
63 ,p_position_id IN NUMBER DEFAULT NULL
64 ,p_time_period_id IN NUMBER
65 )
66 RETURN NUMBER;
67
68 -- Function to calculate the Budget Cost of a training event
69
70 FUNCTION get_event_budget_cost
71 (p_event_id IN NUMBER
72 )
73 RETURN NUMBER;
74
75 -- Function to calculate the Actual Cost of a training event
76
77 FUNCTION get_event_actual_cost
78 (p_event_id IN NUMBER
79 )
80 RETURN NUMBER;
81
82 -- Function to calculate the Total Revenue generated by a training event
83
84 FUNCTION get_event_revenue
85 (p_event_id IN NUMBER
86 )
87 RETURN NUMBER;
88
89 -- Function to convert Training Duration from one set of units to another
90
91 FUNCTION training_convert_duration
92 (p_formula_id IN NUMBER
93 ,p_from_duration IN NUMBER
94 ,p_from_duration_units IN VARCHAR2
95 ,p_to_duration_units IN VARCHAR2
96 ,p_activity_version_name IN VARCHAR2
97 ,p_event_name IN VARCHAR2
98 ,p_session_date IN DATE
99 )
100 RETURN NUMBER;
101
102 -- Function to determine the Id of a FastFormula
103
104 FUNCTION get_formula_id
105 (p_business_group_id IN NUMBER
106 ,p_formula_name IN VARCHAR2
107 )
108 RETURN NUMBER;
109
110 -- Function to get an assignment budget value for an assignment
111
112 FUNCTION get_asg_budget_value
113 ( p_budget_metric_formula_id IN NUMBER
114 , p_budget_metric IN VARCHAR2
115 , p_assignment_id IN NUMBER
116 , p_effective_date IN DATE
117 , p_session_date IN DATE )
118 RETURN NUMBER;
119
120 --cbridge, 13/09/2000, functions to support course ranking workbook OTA
121 FUNCTION get_att_int_rev_booking
122 (p_event_id IN NUMBER,
123 p_booking_id IN NUMBER )
124 RETURN NUMBER;
125
126 FUNCTION get_att_ext_rev_booking
127 (p_event_id IN NUMBER,
128 p_booking_id IN NUMBER )
129 RETURN NUMBER;
130
131 FUNCTION get_non_att_int_rev_booking
132 (p_event_id IN NUMBER,
133 p_booking_id IN NUMBER )
134 RETURN NUMBER;
135
136 FUNCTION get_non_att_ext_rev_booking
137 (p_event_id IN NUMBER,
138 p_booking_id IN NUMBER )
139 RETURN NUMBER;
140
141
142 -- cbridge, 28/06/2001 , bug enhancement 1317484
143 FUNCTION get_ff_actual_value_pqh
144 (p_budget_id IN NUMBER
145 ,p_business_group_id IN NUMBER
146 ,p_grade_id IN NUMBER DEFAULT NULL
147 ,p_job_id IN NUMBER DEFAULT NULL
148 ,p_organization_id IN NUMBER DEFAULT NULL
149 ,p_position_id IN NUMBER DEFAULT NULL
150 ,p_time_period_id IN NUMBER
151 ,p_budget_metric IN VARCHAR2
152 )
153 RETURN NUMBER;
154
155 --dsheth, 01-FEB-2001, added new function to support direct reports.
156
157 FUNCTION direct_reports
158 (p_person_id IN NUMBER
159 ,p_effective_start_date IN DATE
160 ,p_effective_end_date IN DATE)
161 RETURN NUMBER;
162
163 FUNCTION get_prev_salary_pro_amount(p_pay_proposal_id IN NUMBER)
164 RETURN NUMBER;
165
166 FUNCTION GET_ANNUAL_SALARY_AS_OF_DATE(p_effective_date date
167 , p_assignment_id number)
168 RETURN NUMBER;
169
170
171 END hr_disc_calculations;