DBA Data[Home] [Help]

PACKAGE: APPS.IRC_SKILLS_MATCHING_PKG

Source


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;