1 PACKAGE hri_oltp_disc_rctmnt AUTHID CURRENT_USER AS
2 /* $Header: hriodrec.pkh 115.0 2002/08/22 09:22:06 jtitmas noship $ */
3
4 FUNCTION get_vacancy_hire_count(p_vacancy IN VARCHAR2,
5 p_business_group IN VARCHAR2,
6 p_requisition IN VARCHAR2,
7 p_applicant_number IN VARCHAR2)
8 RETURN NUMBER;
9
10 FUNCTION get_vacancy_offer_count(p_vacancy IN VARCHAR2,
11 p_business_group IN VARCHAR2,
12 p_requisition IN VARCHAR2)
13 RETURN NUMBER;
14
15 FUNCTION get_rec_act_hire_count(p_rec_activity IN VARCHAR2,
16 p_business_group IN VARCHAR2,
17 p_applicant_number IN VARCHAR2)
18 RETURN NUMBER;
19
20 FUNCTION get_rec_act_offer_count(p_rec_activity IN VARCHAR2,
21 p_business_group IN VARCHAR2)
22 RETURN NUMBER;
23
24 FUNCTION get_rec_act_vac_hire_count(p_rec_activity IN VARCHAR2,
25 p_vacancy IN VARCHAR2,
26 p_business_group IN VARCHAR2,
27 p_applicant_number IN VARCHAR2)
28 RETURN NUMBER;
29
30 FUNCTION get_rec_act_vac_offer_count(p_rec_activity IN VARCHAR2,
31 p_vacancy IN VARCHAR2,
32 p_business_group IN VARCHAR2)
33 RETURN NUMBER;
34
35 FUNCTION get_hiring_cost_current_emp(p_rec_act_id IN NUMBER,
36 p_actual_cost IN NUMBER)
37 RETURN NUMBER;
38
39 FUNCTION check_active_vacancy(p_date_from IN DATE,
40 p_date_to IN DATE)
41 RETURN VARCHAR2;
42
43 END hri_oltp_disc_rctmnt;