1 PACKAGE IRC_SKILLS_MATCHING_PKG AS
2 /* $Header: irsklpkg.pkh 120.0 2005/07/26 15:18:39 mbocutt noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< SKILLS_MATCH >------------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This is the main function to return a percentage value that a given person
11 -- matches the lists of skills. (If the get_percent_flag is true, if false then
12 -- processing stops as soon as it is known whether or not the person will pass
13 -- to some extent.)
14 --
15 -- Prerequisites:
16 -- This is a public function, but will mainly be called by local functions.
17 --
18 -- In Parameters:
19 -- String of comma-delimeted ID's representing skills and the corresponding levels.
20 -- A person id.
21 -- Post Success:
22 -- A return percentage. Should all essential skills not be matched a '-1'
23 -- figure will be returned
24 --
25 -- Post Failure:
26 -- If inputs are of inconsistent lengths than a suitable error will occur.
27 --
28 -- Developer Implementation Notes:
29 -- Add additional where clause to VO to restrict to parties where this function does not return -1.
30 --
31 -- {End Of Comments}
32
33 FUNCTION SKILLS_MATCH ( p_esse_sk_list_str VARCHAR2,
34 p_esse_sk_mins_str VARCHAR2,
35 p_esse_sk_maxs_str VARCHAR2,
36 p_pref_sk_list_str VARCHAR2,
37 p_pref_sk_mins_str VARCHAR2,
38 p_pref_sk_maxs_str VARCHAR2,
39 p_person_id number,
40 p_get_percent_flag BOOLEAN) RETURN VARCHAR2;
41
42
43
44 -- ----------------------------------------------------------------------------
45 -- |----------------------< SKILLS_MATCH_PERCENT >--------------------------|
46 -- ----------------------------------------------------------------------------
47 -- {Start Of Comments}
48 --
49 -- Description:
50 -- Wrapper to be called from java code. This takes all the input parameters and
51 -- calls the main skills_match requesting an exact percentage.
52 --
53 -- Prerequisites:
54 -- This is a public function, mainly called by VO's representing search results
55 -- in the iRecruitment web module.
56 --
57 -- In Parameters:
58 -- As main skills_match.
59 -- Post Success:
60 -- A return percentage. Should all essential skills not be matched a '-1'
61 -- figure will be returned
62 --
63 -- Post Failure:
64 -- If inputs are of inconsistent lengths than a suitable error will occur.
65 --
66 -- Developer Implementation Notes:
67 -- Usually used in select part of VO to get the exact match figure.
68 --
69 -- {End Of Comments}
70
71 FUNCTION SKILLS_MATCH_PERCENT ( p_esse_sk_list_str VARCHAR2,
72 p_esse_sk_mins_str VARCHAR2,
73 p_esse_sk_maxs_str VARCHAR2,
74 p_pref_sk_list_str VARCHAR2,
75 p_pref_sk_mins_str VARCHAR2,
76 p_pref_sk_maxs_str VARCHAR2,
77 p_person_id number) RETURN VARCHAR2;
78
79
80 -- ----------------------------------------------------------------------------
81 -- |------------------------< SKILLS_MATCH_TEST >---------------------------|
82 -- ----------------------------------------------------------------------------
83 -- {Start Of Comments}
84 --
85 -- Description:
86 -- Wrapper to be called from java code. This takes all the input parameters and
87 -- calls the main skills_match requesting processing only until a decision
88 -- on whether person has required skills has been reached. An exact percentage is
89 -- not returned, just a boolean on whether the person has the skills.
90 --
91 -- Prerequisites:
92 -- This is a public function, mainly called by VO's representing search results
93 -- in the iRecruitment web module.
94 --
95 -- In Parameters:
96 -- As main skills_match. Except only essential comma-delimited lists are required.
97 -- Post Success:
98 -- A return boolean.
99 --
100 -- Post Failure:
101 -- If inputs are of inconsistent lengths than a suitable error will occur.
102 --
103 -- Developer Implementation Notes:
104 -- Usually used in where clause part of VO to limit to those parties who have passed
105 --
106 -- {End Of Comments}
107
108 FUNCTION SKILLS_MATCH_TEST ( p_esse_sk_list_str VARCHAR2,
109 p_esse_sk_mins_str VARCHAR2,
110 p_esse_sk_maxs_str VARCHAR2,
111 p_person_id number) RETURN BOOLEAN;
112
113
114
115 -- ----------------------------------------------------------------------------
116 -- |-----------------------< VACANCY_MATCH_PERCENT >--------------------------|
117 -- ----------------------------------------------------------------------------
118 -- {Start Of Comments}
119 --
120 -- Description:
121 -- This is a function to return a percentage value, representing how well a given person
122 -- matches the lists of skills required for a given vacancy.
123 --
124 -- Prerequisites:
125 -- This is a public function, mainly called by VO's representing search results
126 -- in the iRecruitment web module.
127 --
128 -- In Parameters:
129 -- A person id, a vacancy id and an effective date
130 -- This will in turn call the above SKILLS_MATCH_PERCENT
131 -- Post Success:
132 -- A return percentage. Should all essential skills not be matched a '-1'
133 -- figure will be returned
134 --
135 -- Post Failure:
136 -- If inputs are of inconsistent lengths than a suitable error will occur.
137 --
138 -- Developer Implementation Notes:
139 -- Add additional where clause to VO to restrict to parties where this function does not return -1.
140 --
141 -- {End Of Comments}
142
143 FUNCTION VACANCY_MATCH_PERCENT (
144 p_person_id number,
145 p_vacancy_id varchar2,
146 p_eff_date date default sysdate) RETURN VARCHAR2;
147
148
149
150
151 -- ----------------------------------------------------------------------------
152 -- |-----------------------< GET_SKILLS_FOR_SCOPE >--------------------------|
153 -- ----------------------------------------------------------------------------
154 -- {Start Of Comments}
155 --
156 -- Description:
157 -- This functions gets a list of skills required for a given scope(s).
158 -- Exact level details are also included.
159 --
160 -- Prerequisites:
161 -- This is a public function, mainly called by VO's representing search results
162 -- in the iRecruitment web module.
163 --
164 -- In Parameters:
165 -- An ID representing any/all of the following: Org,Business Group, Job or Postion.
166 -- An effective date.
167 -- Post Success:
168 -- Format of return is
169 --"comp_id,mandatory,min-level_id,max-level_id>comp_id,mandatory,min-level_id,max-level_id>..."
170 -- i.e. one long string, commas between items, '>' between sets
171 --
172 -- Post Failure:
173 -- No explicit error catching occurs.
174 --
175 -- Developer Implementation Notes:
176 --
177 -- {End Of Comments}
178
179 FUNCTION GET_SKILLS_FOR_SCOPE (
180 p_org_id number default 0,
181 p_bgp_id number default 0,
182 p_job_id number default 0,
183 p_pos_id number default 0,
184 p_eff_date date default sysdate) RETURN VARCHAR2;
185
186
187 -- ----------------------------------------------------------------------------
188 -- |-----------------------< GET_SKILLS_FOR_VAC >--------------------------|
189 -- ----------------------------------------------------------------------------
190 -- {Start Of Comments}
191 --
192 -- Description:
193 -- This functions gets a list of skills required for a given vacancy.
194 -- Exact rating level details are also included.
195 --
196 -- Prerequisites:
197 -- This is a public function, mainly called by VO's representing search results
198 -- in the iRecruitment web module.
199 --
200 -- In Parameters:
201 -- An ID representing a vacancy.
202 -- An effective date.
203 -- Post Success:
204 -- Format of return is
205 -- "comp_id,mandatory,min-level_id,max-level_id>comp_id,mandatory,min-level_id,max-level_id>... "
206 -- i.e. one long string, commas between items, '>' between sets
207 --
208 -- Post Failure:
209 -- No explicit error catching occurs.
210 --
211 -- Developer Implementation Notes:
212 --
213 -- {End Of Comments}
214
215 FUNCTION GET_SKILLS_FOR_VAC (
216 p_vacancy_id varchar2 default 0,
217 p_eff_date date default sysdate) RETURN VARCHAR2;
218
219 END IRC_SKILLS_MATCHING_PKG;