[Home] [Help]
PACKAGE: APPS.PQH_PSF_BUS
Source
1 package PQH_PSF_BUS AUTHID CURRENT_USER as
2 /* $Header: pqpsfbus.pkh 120.1.12010000.1 2008/07/28 13:04:29 appldev ship $ */
3 --
4 -- ---------------------------------------------------------------------------
5 -- |-----------------< POSITION_CONTROL_ENABLED >---------------------|
6 -- ---------------------------------------------------------------------------
7 --
8 function POSITION_CONTROL_ENABLED(P_ORGANIZATION_ID NUMBER default null,
9 p_effective_date in date default sysdate,
10 p_assignment_id number default null) RETURN VARCHAR2;
11 --
12 -- ---------------------------------------------------------------------------
13 -- |-----------------< hr_psf_bus_insert_validate >---------------------|
14 -- ---------------------------------------------------------------------------
15 --
16 procedure hr_psf_bus_insert_validate(p_rec in hr_psf_shd.g_rec_type
17 ,p_effective_date in date
18 -- ,p_datetrack_mode in varchar2
19 );
20 --
21 -- ---------------------------------------------------------------------------
22 -- |-----------------< hr_psf_bus_update_validate >---------------------|
23 -- ---------------------------------------------------------------------------
24 --
25 procedure hr_psf_bus_update_validate(p_rec in hr_psf_shd.g_rec_type
26 ,p_effective_date in date
27 ,p_validation_start_date in date
28 ,p_validation_end_date in date
29 ,p_datetrack_mode in varchar2
30 );
31 --
32 -- ---------------------------------------------------------------------------
33 -- |-----------------< per_asg_bus_insert_validate >--------------------|
34 -- ---------------------------------------------------------------------------
35 --
36 PROCEDURE per_asg_bus_insert_validate(p_rec per_asg_shd.g_rec_type, p_effective_date date );
37 --
38 -- ---------------------------------------------------------------------------
39 -- |-----------------< per_asg_bus_update_validate >--------------------|
40 -- ---------------------------------------------------------------------------
41 --
42 PROCEDURE per_asg_bus_update_validate(p_rec per_asg_shd.g_rec_type
43 ,p_effective_date in date
44 ,p_validation_start_date in date
45 ,p_validation_end_date in date
46 ,p_datetrack_mode in varchar2
47 );
48 --
49 -- ---------------------------------------------------------------------------
50 -- |-----------------< per_asg_bus_delete_validate >--------------------|
51 -- ---------------------------------------------------------------------------
52 --
53 PROCEDURE per_asg_bus_delete_validate(p_rec per_asg_shd.g_rec_type
54 ,p_effective_date in date
55 ,p_validation_start_date in date
56 ,p_validation_end_date in date
57 ,p_datetrack_mode in varchar2 );
58 --
59 -- ---------------------------------------------------------------------------
60 -- |----------------------< per_abv_insert_validate >-------------------|
61 -- ---------------------------------------------------------------------------
62 --
63 PROCEDURE per_abv_insert_validate(
64 p_assignment_id number,
65 p_value number,
66 p_unit varchar2,
67 p_effective_date date);
68 --
69 -- ---------------------------------------------------------------------------
70 -- |----------------------< per_abv_update_validate >-------------------|
71 -- ---------------------------------------------------------------------------
72 --
73 PROCEDURE per_abv_update_validate(
74 p_abv_id number,
75 p_assignment_id number,
76 p_value number,
77 p_unit varchar2,
78 p_effective_date date,
79 p_validation_start_date date,
80 p_validation_end_date date,
81 p_datetrack_mode varchar2);
82 --
83 -- ---------------------------------------------------------------------------
84 -- |----------------------< funded_status >-----------------------------|
85 -- ---------------------------------------------------------------------------
86 -- Description:
87 -- Retrieves the funded_status of the position.
88 --
89 function funded_status
90 (p_position_id in number) return varchar2;
91 --
92 --
93 -- ---------------------------------------------------------------------------
94 -- |----------------------< sum_assignment_fte >------------------------|
95 -- ---------------------------------------------------------------------------
96 -- Description:
97 -- Retrieves the funded_status of the position.
98 --
99 function sum_assignment_fte
100 (p_position_id in number, p_effective_date in date) return number;
101 --
102 --
103 -- ---------------------------------------------------------------------------
104 -- |----------------------< sum_assignment_fte >------------------------|
105 -- ---------------------------------------------------------------------------
106 -- Description:
107 -- Retrieves the funded_status of the position.
108 --
109 function sum_assignment_fte
110 (p_position_id in number, p_effective_date in date, p_assignment_id in number) return number;
111 --
112 --
113 -- ---------------------------------------------------------------------------
114 -- |--------------------< default_assignment_fte >----------------------|
115 -- ---------------------------------------------------------------------------
116 -- Description:
117 -- Retrieves the sum_assignment_fte of the position.
118 --
119 function default_assignment_fte
120 (p_organization_id in number) return number;
121 --
122 --
123 -- ---------------------------------------------------------------------------
124 -- |----------------------< assignment_fte >----------------------------|
125 -- ---------------------------------------------------------------------------
126 -- Description:
127 -- Retrieves the funded_status of the position.
128 --
129 function assignment_fte
130 (p_assignment_id in number) return number;
131 --
132 --
133 -- ---------------------------------------------------------------------------
134 -- |------------------------< future approved actions >-----------------|
135 -- ---------------------------------------------------------------------------
136 -- Description:
137 -- Retrieves the future approved actions of the position.
138 --
139 function future_approved_actions
140 (p_position_id in number) return varchar2;
141 --
142 --
143 -- ---------------------------------------------------------------------------
144 -- |------------------------< open_status >-----------------------------|
145 -- ---------------------------------------------------------------------------
146 -- Description:
147 -- Retrieves the funded_status of the position.
148 --
149 function open_status
150 (p_position_id in number, p_effective_date in date) return varchar2;
151 --
152 -- ---------------------------------------------------------------------------
153 -- |-----------------------< overlap_period >-----------------------------|
154 -- ---------------------------------------------------------------------------
155 -- Description:
156 -- Retrieves the overlap_period of the position.
157 --
158 procedure overlap_period
159 (p_position_id in number, p_overlap_period out nocopy number,
160 p_start_date out nocopy date, p_end_date out nocopy date);
161 --
162 --
163 -- ---------------------------------------------------------------------------
164 -- |----------------------< reserved_status >-----------------------------|
165 -- ---------------------------------------------------------------------------
166 -- Description:
167 -- Retrieves the reserved_status of the position.
168 --
169 procedure reserved_status
170 (p_position_id in number, p_reserved_status out nocopy varchar2,
171 p_start_date out nocopy date, p_end_date out nocopy date, p_person_id out nocopy number, p_fte_reserved out nocopy number);
172 --
173 --
174 -- ---------------------------------------------------------------------------
175 -- |----------------------< review_status >-----------------------------|
176 -- ---------------------------------------------------------------------------
177 -- Description:
178 -- Retrieves the funded_status of the position.
179 --
180 function review_status
181 (p_position_id in number) return varchar2;
182 --
183 --
184 -- ---------------------------------------------------------------------------
185 -- |----------------------< vacancy_status >----------------------------|
186 -- ---------------------------------------------------------------------------
187 -- Description:
188 -- Retrieves the funded_status of the position.
189 --
190 function vacancy_status
191 (p_position_id in number, p_effective_date in date) return varchar2;
192 --
193 function permit_extended_pay(p_position_id varchar2) return boolean;
194 --
195 function permit_extended_pay_poi(p_rec in pe_poi_shd.g_rec_type) return boolean;
196 --
197 function chk_seasonal_dates( p_position_id number, p_seasonal_flag varchar2, p_assignment_start_date date)
198 return boolean;
199 --
200 function chk_seasonal(p_position_id number) return boolean;
201 --
202 function chk_seasonal_poi(p_position_id number) return boolean;
203 --
204 function chk_overlap_poi(p_position_id number) return boolean;
205 --
206 function pos_assignments_exists(p_position_id number) return boolean;
207 --
208 function chk_overlap(p_position_id number) return boolean;
209 --
210 function chk_amendment_info(
211 amendment_date date,
212 amendment_recommendation varchar2,
213 amendment_ref_number varchar2) return boolean;
214 --
215 --
216 function no_assignments(p_position_id number) return number;
217 --
218 function no_assignments(p_position_id number, p_effective_date date) return number;
219 --
220 function max_persons(p_position_id number) return number;
221 --
222 function proposed_date_for_layoff(p_position_id number) return date;
223 --
224 function fte_capacity(p_position_id number) return number;
225 --
226 function position_type(p_position_id number) return varchar2;
227 --
228 function grade(p_position_id number) return number;
229 --
230 function work_period_type_cd(p_position_id number) return varchar2;
231 --
232 function chk_work_pay_term_dates(p_work_period_type_cd hr_all_positions_f.work_period_type_cd%type
233 ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type
234 ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
235 ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
236 ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type
237 ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type
238 ,p_term_start_month_cd hr_all_positions_f.term_start_month_cd%type
239 ) return boolean;
240 --
241 function chk_position_job_grade(p_position_grade_id number, p_job_id number) return boolean;
242 --
243 function chk_overlap_dates
244 (p_position_id in number, p_overlap_period number, p_assignment_start_date date) return boolean;
245 --
246 function chk_reserved(p_position_id number) return boolean;
247 --
248 function position_min_asg_dt(p_position_id number) return date;
249 --
250 function position_max_asg_dt(p_position_id number) return date;
251 --
252 function chk_earliest_hire_date(p_position_id number, p_earliest_hire_date date)
253 return boolean;
254 --
255 function chk_prop_date_for_layoff(p_position_id number, p_proposed_date_for_layoff date)
256 return boolean;
257 --
258 function GET_SYSTEM_SHARED_TYPE(p_availability_status_id number)
259 return varchar2;
260 --
261 function budgeted_fte (p_position_id in number,
262 p_effective_date in date) return number;
263
264 function get_budgeted_fte( p_position_id in number default null
265 ,p_job_id in number default null
266 ,p_grade_id in number default null
267 ,p_organization_id in number default null
268 ,p_budget_entity in varchar2
269 ,p_start_date in date default sysdate
270 ,p_end_date in date default sysdate
271 ,p_unit_of_measure in varchar2
272 ,p_business_group_id in number
273 ,p_budgeted_fte_date out nocopy date
274 ) return number;
275
276 function budgeted_fte( p_position_id in number default null
277 ,p_job_id in number default null
278 ,p_grade_id in number default null
279 ,p_organization_id in number default null
280 ,p_budget_entity in varchar2
281 ,p_effective_date in date default sysdate
282 ,p_unit_of_measure in varchar2
283 ,p_business_group_id in number
284 ) return number;
285 --
286 function person_fte
287 (p_person_id in number,
288 p_position_id in number,
289 p_effective_date in date,
290 p_ex_assignment_id number) return number;
291 --
292 function assignment_fte(
293 p_assignment_id number,
294 p_effective_date date) return number;
295 --
296 function available_fte(
297 p_person_id number,
298 p_position_id number,
299 p_effective_date date) return number;
300 --
301 --
302 --
303 function budgeted_money (
304 p_position_id in number,
305 p_effective_date in date) return number;
306 --
307 --
308 --
309 function get_pos_actuals_commitment(
310 p_position_id in number,
311 p_effective_date in date,
312 p_ex_assignment_id in number default -1
313 ) return number;
314 --
315 --
316 function get_asg_actuals_commitment(
317 p_assignment_id in number,
318 p_effective_date in date) return number;
319 --
320 function chk_pos_budget(
321 p_position_id in number,
322 p_effective_date in date) return boolean;
323 --
324 function chk_pos_budget(
325 p_position_id in number,
326 p_effective_date in date,
327 p_ex_assignment_id number) return boolean;
328 --
329 --
330 --
331 function nonreserved_asg_fte(
332 p_position_id number,
333 p_effective_date date,
334 p_ex_position_extra_info_id number default -1,
335 p_ex_person_id number default -1 ) return number;
336 --
337 function pos_reserved_fte(
338 p_position_id number,
339 p_effective_date date,
340 p_ex_position_extra_info_id number default -1)
341 return number;
342 --
343 function poei_reserved_fte(
344 p_position_extra_info_id number) return number;
345 --
346 function person_asg_fte(
347 p_person_id in number,
348 p_position_id in number,
349 p_effective_date in date,
350 p_ex_assignment_id number default -1) return number;
351 --
352 procedure pqh_poei_validate(
353 p_position_id number,
354 p_position_extra_info_id number,
355 p_person_id number,
356 p_start_date date,
357 p_end_date date,
358 p_poei_fte number);
359 --
360 function position_fte(
361 p_position_id number,
362 p_effective_date date) return number;
363 --
364 function chk_reserved_fte(
365 p_assignment_id number,
366 p_person_id number,
367 p_position_id number,
368 p_position_type varchar2,
369 p_effective_date date,
370 p_default_asg_fte number default null)
371 return boolean;
372 --
373 function chk_future_reserved_fte(
374 p_assignment_id number,
375 p_person_id number,
376 p_position_id number,
377 p_position_type varchar2,
378 p_validation_start_date date,
379 p_validation_end_date date,
380 p_default_asg_fte number default null)
381 return date;
382 --
383 procedure chk_pos_fte_sum_asg_fte(
384 p_assignment_id number,
385 p_position_id number,
386 p_effective_date date,
387 p_default_asg_fte number default null,
388 p_position_type out nocopy varchar2,
389 p_organization_id out nocopy number,
390 p_budgeted_fte out nocopy number,
391 p_realloc_fte out nocopy number,
392 p_position_fte out nocopy number,
393 p_total_asg_fte out nocopy number);
394 --
395 procedure chk_future_pos_asg_fte(
396 p_assignment_id number,
397 p_position_id number,
398 p_validation_start_date date,
399 p_validation_end_date date,
400 p_default_asg_fte number default null);
401 --
402 --
403 procedure CHK_ABV_FTE_GT_POS_BGT_FTE
404 (p_assignment_id number,
405 p_position_id number,
406 p_effective_date date,
407 p_default_asg_fte number default null,
408 p_bgt_lt_abv_fte out nocopy boolean
409 );
410 --
411 function get_position_fte(p_position_id number, p_effective_date date)
412 return number;
413 --
414 procedure reserved_error(p_assignment_id number, p_person_id number,
415 p_position_id number, p_effective_start_date date,
416 p_organization_id number,
417 p_default_asg_fte number default 0);
418 --
419 function get_pc_topnode (p_business_group_id in number default null,
420 p_effective_date in date default null) return number ;
421 --
422 function get_pc_str_version (p_business_group_id in number default null,
423 p_effective_date in date default null) return number ;
424 --
425 procedure chk_position_budget(
426 p_assignment_id in number,
427 p_element_type_id in number default null,
428 p_input_value_id in number default null,
429 p_effective_date in date,
430 p_called_from in varchar2, /* valid values 'ASG' or 'SAL' */
431 p_old_position_id in number default null,
432 p_new_position_id in number default null
433 );
434 --
435 end PQH_PSF_BUS;