1 PACKAGE HR_SUIT_MATCH_UTIL_SS AUTHID CURRENT_USER AS
2 /* $Header: hrsmgutl.pkh 120.0.12010000.1 2008/07/28 03:48:21 appldev ship $ */
3
4 PROCEDURE populate_comp_temp_table (
5 p_temp_tab IN SSHR_SM_COMP_DETAILS_TAB_TYP
6 );
7
8 PROCEDURE populate_per_temp_table (
9 p_temp_tab IN SSHR_SM_COMP_DETAILS_TAB_TYP
10 );
11
12 PROCEDURE populate_workopp_temp_table (
13 p_temp_tab IN SSHR_SM_COMP_DETAILS_TAB_TYP
14 );
15
16 PROCEDURE insert_workopp_temp_table (
17 p_temp_tab IN SSHR_SM_COMP_DETAILS_TAB_TYP
18 );
19
20 FUNCTION get_ess_desired_match (
21 p_person_id in number
22 ,p_req in varchar2
23 )
24 RETURN VARCHAR2;
25
26 FUNCTION get_ess_desired_match (
27 p_person_id in number
28 ,p_enterprise_id in number default -1
29 ,p_organization_id in number default -1
30 ,p_job_id in number default -1
31 ,p_position_id in number default -1
32 ,p_vacancy_id in number default -1
33 ,p_req in varchar2
34 ,p_person_temp in number default 0
35 )
36 RETURN VARCHAR2;
37 PRAGMA RESTRICT_REFERENCES(get_ess_desired_match,WNDS,RNDS);
38
39 FUNCTION is_ess_des_meets (
40 p_person_id in number
41 ,p_meets in varchar2
42 )
43 RETURN VARCHAR2;
44
45 FUNCTION is_ess_des_meets (
46 p_person_id in number
47 ,p_enterprise_id in number default -1
48 ,p_organization_id in number default -1
49 ,p_job_id in number default -1
50 ,p_position_id in number default -1
51 ,p_vacancy_id in number default -1
52 ,p_meets in varchar2
53 ,p_person_temp in number default 0
54 )
55 RETURN VARCHAR2;
56 PRAGMA RESTRICT_REFERENCES(is_ess_des_meets,WNDS,RNDS);
57
58 FUNCTION get_bg_name(
59 p_bg_id in number
60 )
61 RETURN VARCHAR2;
62
63 FUNCTION get_application_date(
64 p_person_id in number
65 )
66 RETURN DATE;
67
68 FUNCTION get_emp_start_date(
69 p_period_of_service_id in number
70 )
71 RETURN DATE;
72
73 FUNCTION get_cwk_start_date(
74 p_person_id in number
75 )
76 RETURN DATE;
77
78
79 END HR_SUIT_MATCH_UTIL_SS;