1 PACKAGE hri_opl_recruitment AUTHID CURRENT_USER AS
2 /* $Header: hriprec.pkh 115.1 2002/12/20 17:16:44 jtitmas noship $ */
3
4 FUNCTION get_stage_status(p_assignment_id IN NUMBER,
5 p_person_id IN NUMBER,
6 p_term_reason IN VARCHAR2,
7 p_end_date IN DATE,
8 p_system_status IN VARCHAR2)
9 RETURN VARCHAR2;
10
11 FUNCTION get_stage_reason(p_assignment_id IN NUMBER,
12 p_person_id IN NUMBER,
13 p_term_reason IN VARCHAR2,
14 p_end_date IN DATE,
15 p_system_status IN VARCHAR2)
16 RETURN VARCHAR2;
17
18 FUNCTION get_stage_date(p_assignment_id IN NUMBER,
19 p_person_id IN NUMBER,
20 p_term_reason IN VARCHAR2,
21 p_end_date IN DATE,
22 p_system_status IN VARCHAR2)
23 RETURN DATE;
24
25 FUNCTION get_hire_assignment(p_assignment_id IN NUMBER,
26 p_person_id IN NUMBER,
27 p_term_reason IN VARCHAR2,
28 p_end_date IN DATE)
29 RETURN NUMBER;
30
31 FUNCTION is_pursued_apl(p_person_id IN NUMBER,
32 p_vacancy_id IN NUMBER,
33 p_effective_date IN DATE)
34 RETURN NUMBER;
35
36 FUNCTION calc_avg_days_to_hire(p_vacancy_id IN NUMBER,
37 p_date_from IN DATE)
38 RETURN NUMBER;
39
40 FUNCTION calc_avg_days_to_fill(p_vacancy_id IN NUMBER,
41 p_date_from IN DATE)
42 RETURN NUMBER;
43
44 FUNCTION calc_avg_fill_to_hire(p_vacancy_id IN NUMBER,
45 p_date_from IN DATE)
46 RETURN NUMBER;
47
48 FUNCTION calc_no_apls(p_vacancy_id IN NUMBER,
49 p_date_from IN DATE)
50 RETURN NUMBER;
51
52 END hri_opl_recruitment;