1 PACKAGE BODY HR_VIEW_ALERT_TRNSLT AS
2 /* $Header: pervatsl.pkb 115.3 2003/05/27 09:43:32 jrstewar noship $ */
3 --
4 -- -----------------------------------------------------------------------------
5 --
6 -- Get's a transalted location code for a language and location_id
7 --
8 FUNCTION location(p_language IN VARCHAR2
9 ,p_location_id IN NUMBER)
10 RETURN VARCHAR2 IS
11 --
12 BEGIN
13 --
14 RETURN hr_bpl_alert_trnslt.location(p_language
15 ,p_location_id);
16 --
17 END location;
18 --
19 -- -----------------------------------------------------------------------------
20 --
21 -- Get's an Organization Name for a language and organization_id
22 --
23 FUNCTION organization(p_language IN VARCHAR2
24 ,p_organization_id IN NUMBER)
25 RETURN VARCHAR2 IS
26 --
27 BEGIN
28 --
29 RETURN hr_bpl_alert_trnslt.organization(p_language
30 ,p_organization_id);
31 --
32 END organization;
33 --
34 -- -----------------------------------------------------------------------------
35 --
36 -- Get's a job name for a job_id
37 --
38 FUNCTION job(p_job_id IN NUMBER)
39 RETURN VARCHAR2 IS
40 --
41 BEGIN
42 --
43 RETURN hr_bpl_alert_trnslt.job(p_job_id);
44 --
45 END job;
46 --
47 -- -----------------------------------------------------------------------------
48 --
49 -- Get's a position name for a job_id
50 --
51 FUNCTION position(p_position_id IN NUMBER)
52 RETURN VARCHAR2 IS
53 --
54 BEGIN
55 --
56 RETURN hr_bpl_alert_trnslt.position(p_position_id);
57 --
58 END position;
59 --
60 -- -----------------------------------------------------------------------------
61 --
62 -- Get's a grade name for a job_id
63 --
64 FUNCTION grade(p_grade_id IN NUMBER)
65 RETURN VARCHAR2 IS
66 --
67 BEGIN
68 --
69 RETURN hr_bpl_alert_trnslt.grade(p_grade_id);
70 --
71 END grade;
72 --
73 --------------------------------------------------------------------------------
74 --
75 -- Get the meaning of a lookup in the language of a particular person.
76 --
77 --
78 FUNCTION psn_lng_decode_lookup(p_lookup_type IN VARCHAR2
79 ,p_lookup_code IN VARCHAR2
80 ,p_person_id IN NUMBER)
81 RETURN fnd_lookup_values.meaning%TYPE IS
82 --
83 BEGIN
84 --
85 RETURN hr_bpl_alert_trnslt.psn_lng_decode_lookup(p_lookup_type
86 ,p_lookup_code
87 ,p_person_id);
88 --
89 END psn_lng_decode_lookup;
90 --
91 --
92 -- -----------------------------------------------------------------------------
93 --
94 -- Get's a location_code for a person and location_id
95 --
96 FUNCTION psn_lng_location(p_person_id IN NUMBER
97 ,p_location_id IN NUMBER)
98 RETURN VARCHAR2 IS
99 --
100 BEGIN
101 --
102 RETURN hr_bpl_alert_trnslt.psn_lng_location(p_person_id
103 ,p_location_id);
104 --
105 END psn_lng_location;
106 -- -----------------------------------------------------------------------------
107 --
108 -- Get's a location_code for the primary assignment supervisor of a person_id
109 -- for a given location_id
110 --
111 FUNCTION psn_sup_lng_location(p_person_id IN NUMBER
112 ,p_location_id IN NUMBER)
113 RETURN VARCHAR2 IS
114 --
115 BEGIN
116 --
117 RETURN hr_bpl_alert_trnslt.psn_sup_lng_location(p_person_id
118 ,p_location_id);
119 --
120 END psn_sup_lng_location;
121 --
122 -- -----------------------------------------------------------------------------
123 --
124 -- Get's a Organization Name for a person and organization_id
125 --
126 FUNCTION psn_lng_organization(p_person_id IN NUMBER
127 ,p_organization_id IN NUMBER)
128 RETURN VARCHAR2 IS
129 --
130 BEGIN
131 --
132 RETURN hr_bpl_alert_trnslt.psn_lng_organization(p_person_id
133 ,p_organization_id);
134 --
135 END psn_lng_organization;
136 --
137 -- -----------------------------------------------------------------------------
138 --
139 -- Get's a Organization Name for the primary assignment supervisor of
140 -- a person_id for a given organization_id
141 --
142 FUNCTION psn_sup_lng_organization(p_person_id IN NUMBER
143 ,p_organization_id IN NUMBER)
144 RETURN VARCHAR2 IS
145 --
146 BEGIN
147 --
148 RETURN hr_bpl_alert_trnslt.psn_sup_lng_organization(p_person_id
149 ,p_organization_id);
150 --
151 END psn_sup_lng_organization;
152 --
153 -- -----------------------------------------------------------------------------
154 --
155 -- Get's a Job Name for a person and job_id
156 --
157 FUNCTION psn_lng_job(p_person_id IN NUMBER
158 ,p_job_id IN NUMBER)
159 RETURN VARCHAR2 IS
160 BEGIN
161 --
162 RETURN hr_bpl_alert_trnslt.psn_lng_job(p_person_id
163 ,p_job_id);
164 --
165 END psn_lng_job;
166 --
167 -- -----------------------------------------------------------------------------
168 --
169 -- Get's a Job Name for a person and job_id
170 --
171 FUNCTION psn_sup_lng_job(p_person_id IN NUMBER
172 ,p_job_id IN NUMBER)
173 RETURN VARCHAR2 IS
174 BEGIN
175 --
176 RETURN hr_bpl_alert_trnslt.psn_sup_lng_job(p_person_id
177 ,p_job_id);
178 --
179 END psn_sup_lng_job;
180 --
181 -- -----------------------------------------------------------------------------
182 --
183 -- Get's a position Name for a person and position_id
184 --
185 --
186 FUNCTION psn_lng_position(p_person_id IN NUMBER
187 ,p_position_id IN NUMBER)
188 RETURN VARCHAR2 IS
189 BEGIN
190 --
191 RETURN hr_bpl_alert_trnslt.psn_lng_position(p_person_id
192 ,p_position_id);
193 --
194 END psn_lng_position;
195 --
196 -- -----------------------------------------------------------------------------
197 --
198 -- Get's a position Name for a person and position_id
199 --
200 --
201 FUNCTION psn_sup_lng_position(p_person_id IN NUMBER
202 ,p_position_id IN NUMBER)
203 RETURN VARCHAR2 IS
204 BEGIN
205 --
206 RETURN hr_bpl_alert_trnslt.psn_sup_lng_position(p_person_id
207 ,p_position_id);
208 --
209 END psn_sup_lng_position;
210 --
211 -- -----------------------------------------------------------------------------
212 --
213 -- Get's a grade Name for a person and grade_id
214 --
215 --
216 FUNCTION psn_lng_grade(p_person_id IN NUMBER
217 ,p_grade_id IN NUMBER)
218 RETURN VARCHAR2 IS
219 BEGIN
220 --
221 RETURN hr_bpl_alert_trnslt.psn_lng_grade(p_person_id
222 ,p_grade_id);
223 --
224 END psn_lng_grade;
225 --
226 -- -----------------------------------------------------------------------------
227 --
228 -- Get's a grade Name for a person and grade_id
229 --
230 --
231 FUNCTION psn_sup_lng_grade(p_person_id IN NUMBER
232 ,p_grade_id IN NUMBER)
233 RETURN VARCHAR2 IS
234 BEGIN
235 --
236 RETURN hr_bpl_alert_trnslt.psn_sup_lng_grade(p_person_id
237 ,p_grade_id);
238 --
239 END psn_sup_lng_grade;
240 --
241 --------------------------------------------------------------------------------
242 -- Returns Lookup Meaning for a given assignment language.
243 --
244 --
245 FUNCTION asg_lng_decode_lookup(p_lookup_type IN VARCHAR2
246 ,p_lookup_code IN VARCHAR2
247 ,p_assignment_id IN NUMBER)
248 RETURN fnd_lookup_values.meaning%TYPE IS
249 BEGIN
250 --
251 RETURN hr_bpl_alert_trnslt.asg_lng_decode_lookup(
252 p_lookup_type
253 ,p_lookup_code
254 ,p_assignment_id);
255 --
256 END asg_lng_decode_lookup;
257 --
258 -- -----------------------------------------------------------------------------
259 --
260 -- Get's a location_code for a given assignment_id and location_id
261 --
262 FUNCTION asg_lng_location(p_assignment_id IN NUMBER
263 ,p_location_id IN NUMBER)
264 RETURN VARCHAR2 IS
265 --
266 BEGIN
267 --
268 RETURN hr_bpl_alert_trnslt.asg_lng_location(p_assignment_id
269 ,p_location_id);
270 --
271 END asg_lng_location;
272 --
273 -- -----------------------------------------------------------------------------
274 --
275 -- Get's a Organization Name in the language required by for the assignment_id
276 -- and organization_id
277 --
278 FUNCTION asg_lng_organization(p_assignment_id IN NUMBER
279 ,p_organization_id IN NUMBER)
280 RETURN VARCHAR2 IS
281 --
282 BEGIN
283 --
284 RETURN hr_bpl_alert_trnslt.asg_lng_organization(p_assignment_id
285 ,p_organization_id);
286 --
287 END asg_lng_organization;
288 --
289 --------------------------------------------------------------------------------
290 -- Returns Lookup Meaning for a given language for a assignment supervisor.
291 --
292 --
293 FUNCTION asg_sup_lng_decode_lookup(p_lookup_type IN VARCHAR2
294 ,p_lookup_code IN VARCHAR2
295 ,p_assignment_id IN NUMBER)
296
297 RETURN fnd_lookup_values.meaning%TYPE IS
298 --
299 BEGIN
300 --
301 RETURN hr_bpl_alert_trnslt.asg_sup_lng_decode_lookup(p_lookup_type
302 ,p_lookup_code
303 ,p_assignment_id);
304 --
305 END asg_sup_lng_decode_lookup;
306 --
307 -- -----------------------------------------------------------------------------
308 --
309 -- Get's a location_code for the assignment supervisor of an assignment_id
310 -- for a given location_id
311 --
312 FUNCTION asg_sup_lng_location(p_assignment_id IN NUMBER
313 ,p_location_id IN NUMBER)
314 RETURN VARCHAR2 IS
315 --
316 BEGIN
317 --
318 RETURN hr_bpl_alert_trnslt.asg_sup_lng_location(p_assignment_id
319 ,p_location_id);
320 --
321 END asg_sup_lng_location;
322 --
323 -- -----------------------------------------------------------------------------
324 --
325 -- Get's a Organization Name in the language required by the assignment
326 -- supervisor for a given assignment_id and organization_id
327 --
328 FUNCTION asg_sup_lng_organization(p_assignment_id IN NUMBER
329 ,p_organization_id IN NUMBER)
330 RETURN VARCHAR2 IS
331 --
332 BEGIN
333 --
334 RETURN hr_bpl_alert_trnslt.asg_sup_lng_organization(p_assignment_id
335 ,p_organization_id);
336 --
337 END asg_sup_lng_organization;
338 --
339 -- -----------------------------------------------------------------------------
340 --
341 -- Get's a job Name in the language required by the assignment
342 -- supervisor for a given assignment_id and job_id
343 --
344 --
345 FUNCTION asg_sup_lng_job(p_assignment_id IN NUMBER
346 ,p_job_id IN NUMBER)
347 RETURN VARCHAR2 IS
348 --
349 BEGIN
350 --
351 RETURN hr_bpl_alert_trnslt.asg_sup_lng_job(p_assignment_id
352 ,p_job_id);
353 --
354 END asg_sup_lng_job;
355 --
356 -- -----------------------------------------------------------------------------
357 --
358 -- Get's a position Name in the language required by the assignment
359 -- supervisor for a given assignment_id and position_id
360 --
361 --
362 FUNCTION asg_sup_lng_position(p_assignment_id IN NUMBER
363 ,p_position_id IN NUMBER)
364 RETURN VARCHAR2 IS
365 --
366 BEGIN
367 --
368 RETURN hr_bpl_alert_trnslt.asg_sup_lng_position(p_assignment_id
369 ,p_position_id);
370 --
371 END asg_sup_lng_position;
372 --
373 -- -----------------------------------------------------------------------------
374 --
375 -- Get's a grade Name in the language required by the assignment
376 -- supervisor for a given assignment_id and grade_id
377 --
378 --
379 FUNCTION asg_sup_lng_grade(p_assignment_id IN NUMBER
380 ,p_grade_id IN NUMBER)
381 RETURN VARCHAR2 IS
382 --
383 BEGIN
384 --
385 RETURN hr_bpl_alert_trnslt.asg_sup_lng_grade(p_assignment_id
386 ,p_grade_id);
387 --
388 END asg_sup_lng_grade;
389 --
390 --
391 --------------------------------------------------------------------------------
392 -- Returns Lookup Meaning for a given language for a primary assignment
393 -- supervisor.
394 --
395 --
396 FUNCTION pasg_sup_lng_decode_lookup(p_lookup_type IN VARCHAR2
397 ,p_lookup_code IN VARCHAR2
398 ,p_assignment_id IN NUMBER)
399
400 RETURN fnd_lookup_values.meaning%TYPE IS
401 --
402 BEGIN
403 --
404 RETURN hr_bpl_alert_trnslt.pasg_sup_lng_decode_lookup(p_lookup_type
405 ,p_lookup_code
406 ,p_assignment_id);
407 --
408 END pasg_sup_lng_decode_lookup;
409 --
410 -- -----------------------------------------------------------------------------
411 --
412 -- Get's a location_code for the primary assignment supervisor of an
413 -- assignment_id for a given location_id
414 --
415 FUNCTION pasg_sup_lng_location(p_assignment_id IN NUMBER
416 ,p_location_id IN NUMBER)
417 RETURN VARCHAR2 IS
418 --
419 BEGIN
420 --
421 RETURN hr_bpl_alert_trnslt.pasg_sup_lng_location(p_assignment_id
422 ,p_location_id);
423 --
424 END pasg_sup_lng_location;
425 --
426 -- -----------------------------------------------------------------------------
427 --
428 -- Get's a Organization Name in the language required by the primary assignment
429 -- supervisor for a given assignment_id and organization_id
430 --
431 FUNCTION pasg_sup_lng_organization(p_assignment_id IN NUMBER
432 ,p_organization_id IN NUMBER)
433 RETURN VARCHAR2 IS
434 --
435 BEGIN
436 --
437 RETURN hr_bpl_alert_trnslt.pasg_sup_lng_organization(p_assignment_id
438 ,p_organization_id);
439 --
440 END pasg_sup_lng_organization;
441 --
442 -- -----------------------------------------------------------------------------
443 --
444 -- Get's a job Name in the language required by the primary assignment
445 -- job for a given assignment_id and job_id
446 --
447 FUNCTION pasg_sup_lng_job(p_assignment_id IN NUMBER
448 ,p_job_id IN NUMBER)
449 RETURN VARCHAR2 IS
450 --
451 BEGIN
452 --
453 RETURN hr_bpl_alert_trnslt.pasg_sup_lng_job(p_assignment_id
454 ,p_job_id);
455 --
456 END pasg_sup_lng_job;
457 --
458 -- -----------------------------------------------------------------------------
459 --
460 -- Get's a position Name in the language required by the primary assignment
461 -- for a given assignment_id and position_id
462 --
463 FUNCTION pasg_sup_lng_position(p_assignment_id IN NUMBER
464 ,p_position_id IN NUMBER)
465 RETURN VARCHAR2 IS
466 --
467 BEGIN
468 --
469 RETURN hr_bpl_alert_trnslt.pasg_sup_lng_position(p_assignment_id
470 ,p_position_id);
471 --
472 END pasg_sup_lng_position;
473 --
474 -- -----------------------------------------------------------------------------
475 --
476 -- Get's a grade Name in the language required by the primary assignment
477 -- for a given assignment_id and grade_id
478 --
479 FUNCTION pasg_sup_lng_grade(p_assignment_id IN NUMBER
480 ,p_grade_id IN NUMBER)
481 RETURN VARCHAR2 IS
482 --
483 BEGIN
484 --
485 RETURN hr_bpl_alert_trnslt.pasg_sup_lng_grade(p_assignment_id
486 ,p_grade_id);
487 --
488 END pasg_sup_lng_grade;
489
490 END HR_VIEW_ALERT_TRNSLT;