1 PACKAGE IRC_UTILITIES_PKG AS
2 /* $Header: irutil.pkh 120.2.12010000.5 2008/10/30 07:35:18 uuddavol ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< SET_SAVEPOINT >-----------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- Wrapper to be called from java code. This sets a savepoint that can be rolled
11 -- back to.
12 --
13 -- Prerequisites:
14 --
15 -- In Parameters:
16 --
17 -- Post Success:
18 --
19 -- Post Failure:
20 --
21 -- Developer Implementation Notes:
22 --
23 -- {End Of Comments}
24
25 PROCEDURE SET_SAVEPOINT;
26
27
28 --
29 -- ----------------------------------------------------------------------------
30 -- |----------------------< ROLLBACK_TO_SAVEPOINT >-------------------------|
31 -- ----------------------------------------------------------------------------
32 -- {Start Of Comments}
33 --
34 -- Description:
35 -- Wrapper to be called from java code. This rolls back to the savepoint. Used
36 -- after an api_validate.
37 --
38 -- Prerequisites:
39 --
40 -- In Parameters:
41 --
42 -- Post Success:
43 --
44 -- Post Failure:
45 --
46 -- Developer Implementation Notes:
47 --
48 -- {End Of Comments}
49
50 PROCEDURE ROLLBACK_TO_SAVEPOINT;
51
52 -- -------------------------------------------------------------------
53 -- |--------------------< get_home_page_function >-------------------|
54 -- -------------------------------------------------------------------
55 -- {Start Of Comments}
56 --
57 -- Description:
58 -- Wrapper to be called from java code. This rerturns the function for the passed
59 -- in responsibility_id.
60 --
61 -- Prerequisites:
62 --
63 -- In Parameters:
64 --
65 -- Post Success:
66 --
67 -- Post Failure:
68 --
69 -- Developer Implementation Notes:
70 --
71 -- {End Of Comments}
72
73 procedure GET_HOME_PAGE_FUNCTION(p_responsibility_id in varchar2
74 ,p_function out nocopy varchar2);
75
76 function removeTags(p_in varchar2) return varchar2;
77 function removeTags(p_in clob) return varchar2;
78
79 -- ----------------------------------------------------------------------------
80 -- |-----------------------< GET_CURRENT_EMPLOYER >--------------------------|
81 -- ----------------------------------------------------------------------------
82 -- {Start Of Comments}
83 --
84 -- Description:
85 -- This functions returns a person's current employer.
86 --
87 -- Prerequisites:
88 -- This is a public function, mainly called by VO's representing search results
89 -- in the iRecruitment web module.
90 --
91 -- In Parameters:
92 -- A Person ID, and an effective date.
93 -- Post Success:
94 -- Returned varchar of current employer name.
95 -- Post Failure:
96 -- No explicit error catching occurs. An empty string returns if no row found.
97 --
98 -- Developer Implementation Notes:
99 --
100 -- {End Of Comments}
101
102 FUNCTION GET_CURRENT_EMPLOYER (p_person_id per_all_people_f.person_id%TYPE default null,
103 p_eff_date date default trunc(sysdate))
104 RETURN VARCHAR2;
105
106 FUNCTION GET_CURRENT_EMPLOYER_PTY (p_party_id number,
107 p_eff_date date default trunc(sysdate))
108 RETURN VARCHAR2;
109
110
111 -- ----------------------------------------------------------------------------
112 -- |-------------------------< GET_MAX_QUAL_TYPE >--------------------------|
113 -- ----------------------------------------------------------------------------
114 -- {Start Of Comments}
115 --
116 -- Description:
117 -- This functions returns the highest ranking qualification that a person
118 -- posesses.
119 --
120 -- Prerequisites:
121 -- This is a public function, mainly called by VO's representing search results
122 -- in the iRecruitment web module.
123 --
124 -- In Parameters:
125 -- A Person ID
126 -- Post Success:
127 -- Returned varchar of highest ranked qualification.
128 -- Post Failure:
129 -- No explicit error catching occurs. An empty string returns if no row found.
130 --
131 -- Developer Implementation Notes:
132 --
133 -- {End Of Comments}
134
135 FUNCTION GET_MAX_QUAL_TYPE (p_person_id per_all_people_f.person_id%TYPE default null)
136 RETURN VARCHAR2;
137 FUNCTION GET_MAX_QUAL_TYPE_PTY (p_party_id NUMBER)
138 RETURN VARCHAR2;
139 -- ----------------------------------------------------------------------------
140 -- |-----------------------< GET_EMP_UPT_FOR_PERSON >------------------------|
141 -- ----------------------------------------------------------------------------
142 -- {Start Of Comments}
143 --
144 -- Description:
145 -- This functions returns a person's User Person Type if they are an employee.
146 --
147 -- Prerequisites:
148 -- This is a public function, mainly called by VO's representing search results
149 -- in the iRecruitment web module.
150 --
151 -- In Parameters:
152 -- A Person ID, and an effective date.
153 -- Post Success:
154 -- Returned varchar of employee user person type.
155 -- Post Failure:
156 -- No explicit error catching occurs. An empty string returns if no row found.
157 --
158 -- Developer Implementation Notes:
159 --
160 -- {End Of Comments}
161
162 FUNCTION GET_EMP_UPT_FOR_PERSON (p_person_id per_all_people_f.person_id%TYPE default null,
163 p_eff_date date default trunc(sysdate))
164 RETURN VARCHAR2;
165 --
166 FUNCTION GET_EMP_UPT_FOR_PARTY (p_party_id number,
167 p_eff_date date default trunc(sysdate))
168 RETURN VARCHAR2;
169
170 -- ----------------------------------------------------------------------------
171 -- |-----------------------< GET_APL_UPT_FOR_PERSON >------------------------|
172 -- ----------------------------------------------------------------------------
173 -- {Start Of Comments}
174 --
175 -- Description:
176 -- This functions returns a person's User Person Type if they are an applicant.
177 -- If they are also an employee and not in the person viewing's security profile,
178 -- an empty string will be returned.
179 --
180 -- Prerequisites:
181 -- This is a public function, mainly called by VO's representing search results
182 -- in the iRecruitment web module.
183 --
184 -- In Parameters:
185 -- A Person ID, and an effective date.
186 -- Post Success:
187 -- Returned varchar of applicant user person type.
188 -- Post Failure:
189 -- No explicit error catching occurs. An empty string returns if no row found.
190 --
191 -- Developer Implementation Notes:
192 --
193 -- {End Of Comments}
194
195 FUNCTION GET_APL_UPT_FOR_PERSON (
196 p_person_id per_all_people_f.person_id%TYPE default null,
197 p_eff_date date default trunc(sysdate))
198 RETURN VARCHAR2;
199 --
200 FUNCTION GET_APL_UPT_FOR_PARTY (
201 p_party_id number,
202 p_eff_date date default trunc(sysdate))
203 RETURN VARCHAR2;
204
205
206 -- ----------------------------------------------------------------------------
207 -- |-----------------------< GET_EMP_SPT_FOR_PERSON >------------------------|
208 -- ----------------------------------------------------------------------------
209 -- {Start Of Comments}
210 --
211 -- Description:
212 -- This functions returns a person's Employee System Person Type
213 --
214 -- Prerequisites:
215 -- This is a public function, mainly called by VO's
216 -- in the iRecruitment web module.
217 --
218 -- In Parameters:
219 -- A Person ID, and an effective date.
220 -- Post Success:
221 -- Returned varchar of employee system person type.
222 -- Post Failure:
223 -- No explicit error catching occurs. An empty string returns if no row found.
224 --
225 -- Developer Implementation Notes:
226 --
227 -- {End Of Comments}
228
229 FUNCTION GET_EMP_SPT_FOR_PERSON (
230 p_person_id per_all_people_f.person_id%TYPE default null,
231 p_eff_date date default trunc(sysdate))
232 RETURN VARCHAR2;
233
234 --
235 -- -------------------------------------------------------------------------
236 -- |----------------------< get_recruitment_person_id >--------------------|
237 -- -------------------------------------------------------------------------
238 -- {Start Of Comments}
239 --
240 -- Description:
241 -- This functions returns the recruitment person id. It first checks if
242 -- the party has a person with a notification preference. If it doesn't
243 -- find a record it then checks if a person exists in the default
244 -- business group for the party. If not, the person with the earliest
245 -- start date is returned.
246 --
247 -- Prerequisites:
248 --
249 -- In Parameters:
250 -- A Person ID,
251 -- Post Success:
252 -- Returned person ID
253 -- Post Failure:
254 -- No explicit error catching occurs. A null returns if no row found.
255 --
256 -- Developer Implementation Notes:
257 --
258 -- {End Of Comments}
259 --
260 --
261 FUNCTION GET_RECRUITMENT_PERSON_ID
262 (p_person_id IN per_all_people_f.person_id%TYPE,
263 p_effective_date IN per_all_people_f.effective_start_date%TYPE default trunc(sysdate))
264 RETURN per_all_people_f.person_id%TYPE;
265
266 -- ----------------------------------------------------------------------------
267 -- |-----------------------< IS_OPEN_PARTY >-------------------------|
268 -- ----------------------------------------------------------------------------
269
270 FUNCTION IS_OPEN_PARTY (p_party_id number
271 ,p_eff_date date )
272 RETURN VARCHAR2;
273
274 -- ----------------------------------------------------------------------------
275 -- |-----------------------< is_internal_person >-------------------------|
276 -- ----------------------------------------------------------------------------
277
278 FUNCTION is_internal_person (p_person_id number
279 ,p_eff_date date)
280 RETURN VARCHAR2;
281 -- ----------------------------------------------------------------------------
282 -- |-----------------------< is_internal_email >-------------------------|
283 -- ----------------------------------------------------------------------------
284
285 FUNCTION is_internal_email (p_email_address varchar2
286 ,p_eff_date date)
287 RETURN VARCHAR2;
288
289 -- ----------------------------------------------------------------------------
290 -- |-----------------------< is_internal_person >-------------------------|
291 -- ----------------------------------------------------------------------------
292 FUNCTION is_internal_person (p_user_name varchar2
293 ,p_eff_date date )
294 RETURN VARCHAR2;
295
296 -- ----------------------------------------------------------------------------
297 -- |-----------------------< is_function_allowed >-------------------------|
298 -- ----------------------------------------------------------------------------
299 --
300 -- TEST
301 -- Test if function is accessible under current responsibility.
302 -- IN
303 -- function_name - function to test
304 -- p_test_maint_availability- 'Y' (default) means check if available for
305 -- current value of profile APPS_MAINTENANCE_MODE
306 -- 'N' means the caller is checking so it's
307 -- unnecessary to check.
308 -- RETURNS
309 -- TRUE if function is accessible
310 FUNCTION is_function_allowed(p_function_name varchar2
311 ,p_test_maint_availability in varchar2 default 'Y')
312 RETURN VARCHAR2;
313
314
315 -- ----------------------------------------------------------------------------
316 -- |-----------------------< GET_LAST_QUAL_PTY >----------------------------|
317 -- ----------------------------------------------------------------------------
318 -- {Start Of Comments}
319 --
320 -- Description:
321 -- This functions returns a person's latest qualifications associated to esablishment.
322 --
323 -- Prerequisites:
324 -- This is a public function, mainly called by VO's representing search results
325 -- in the iRecruitment web module.
326 --
327 -- In Parameters:
328 -- A Party ID.
329 -- Effective Date.
330 -- Post Success:
331 -- Returned varchar of latest qualification title.
332 -- Post Failure:
333 -- No explicit error catching occurs. An empty string returns if no row found.
334 --
335 -- Developer Implementation Notes:
336 -- Added GET_LAST_QUAL_PTY by deenath to fix Bug #4726469
337 --
338 -- {End Of Comments}
339 FUNCTION GET_LAST_QUAL_PTY(p_party_id NUMBER,
340 p_eff_date DATE DEFAULT TRUNC(SYSDATE))
341 RETURN VARCHAR2;
342
343 -- ----------------------------------------------------------------------------
344 -- |-----------------------< irc_applicant_tracking >-----------------------|
345 -- ----------------------------------------------------------------------------
346 procedure irc_applicant_tracking(
347 p_person_id in number
348 ,p_apl_profile_access_id in number
349 ,p_object_version_number out nocopy number
350 );
351
352 -- ----------------------------------------------------------------------------
353 -- |-----------------------< irc_mark_appl_considered >---------------------|
354 -- ----------------------------------------------------------------------------
355 procedure irc_mark_appl_considered(
356 p_effective_date in date
357 ,p_assignment_id in number
358 ,p_attempt_id in number
359 ,p_assignment_details_id in number
360 ,p_qualified in varchar2
361 ,p_considered in varchar2
362 ,p_update_mode in varchar2
363 ,p_details_version out nocopy number
364 ,p_effective_start_date out nocopy date
365 ,p_effective_end_date out nocopy date
366 ,p_object_version_number out nocopy number
367 );
368
369 -- ----------------------------------------------------------------------------
370 -- |-----------------------< irc_mark_appl_considered >---------------------|
371 -- ----------------------------------------------------------------------------
372 procedure irc_mark_appl_considered(
373 p_assignment_id in number
374 );
375
376 -- ----------------------------------------------------------------------------
377 -- |-----------------------< getAMETxnDetailsForOffer >---------------------|
378 -- ----------------------------------------------------------------------------
379 function getAMETxnDetailsForOffer (p_offerId in varchar2)
380 return varchar2;
381
382 END IRC_UTILITIES_PKG;