1 PACKAGE BODY HR_VIEW_ALERT_RECIPIENT AS
2 /* $Header: pervarpt.pkb 115.1 2003/05/14 15:14:33 jrstewar noship $ */
3 --
4 -- -----------------------------------------------------------------------------
5 --
6 -- Version of Get_psn_eml_addrss to accept NUMBER id
7 --
8 FUNCTION Get_all_psn_prsn_nm(p_person_id IN NUMBER)
9 RETURN VARCHAR2 IS
10 --
11 BEGIN
12 --
13 RETURN hr_bpl_alert_recipient.Get_all_psn_prsn_nm(p_person_id);
14 --
15 END Get_all_psn_prsn_nm;
16 --
17 -- -----------------------------------------------------------------------------
18 --
19 -- Version of Get_psn_eml_addrss overloaded to accept VARCHAR2
20 --
21 FUNCTION Get_all_psn_prsn_nm(p_person_id IN VARCHAR2)
22 RETURN VARCHAR2 IS
23 --
24 BEGIN
25 --
26 RETURN hr_bpl_alert_recipient.Get_all_psn_prsn_nm(TO_NUMBER(p_person_id));
27 --
28 END Get_all_psn_prsn_nm;
29 --
30 -- -----------------------------------------------------------------------------
31 --
32 -- Get's an email address for a given person_id
33 --
34 FUNCTION Get_psn_eml_addrss(p_person_id IN NUMBER)
35 RETURN VARCHAR2 IS
36 --
37 BEGIN
38 --
39 RETURN hr_bpl_alert_recipient.Get_psn_eml_addrss(p_person_id);
40 --
41 END Get_psn_eml_addrss;
42 --
43 -- -----------------------------------------------------------------------------
44 --
45 -- Overloaded version of Get_psn_eml_addrss to accept VARCHAR id
46 --
47 FUNCTION Get_psn_eml_addrss(p_person_id IN VARCHAR2)
48 RETURN VARCHAR2 IS
49 --
50 BEGIN
51 --
52 RETURN hr_bpl_alert_recipient.Get_psn_eml_addrss(TO_NUMBER(p_person_id));
53 --
54 END Get_psn_eml_addrss;
55 --
56 --
57 -- -----------------------------------------------------------------------------
58 --
59 -- Overloaded version of Get_psn_eml_addrss to accept VARCHAR id
60 --
61 FUNCTION Get_psn_sup_psn_eml_addrss(p_person_id IN VARCHAR2)
62 RETURN VARCHAR2 IS
63 --
64 BEGIN
65 --
66 RETURN hr_bpl_alert_recipient.Get_psn_sup_psn_eml_addrss(
67 TO_NUMBER(p_person_id));
68 --
69 END Get_psn_sup_psn_eml_addrss;
70 --
71 -- -----------------------------------------------------------------------------
72 --
73 -- Version of Get_psn_eml_addrss to accept NUMBER id
74 --
75 FUNCTION Get_psn_sup_psn_eml_addrss(p_person_id IN NUMBER)
76 RETURN VARCHAR2 IS
77 --
78 BEGIN
79 --
80 RETURN hr_bpl_alert_recipient.Get_psn_sup_psn_eml_addrss(p_person_id);
81 --
82 END Get_psn_sup_psn_eml_addrss;
83 --
84 -- -----------------------------------------------------------------------------
85 --
86 -- Version of Get_psn_eml_addrss to accept NUMBER id
87 --
88 FUNCTION Get_psn_prsn_nm(p_person_id IN NUMBER)
89 RETURN VARCHAR2 IS
90 --
91 BEGIN
92 --
93 RETURN hr_bpl_alert_recipient.Get_psn_prsn_nm(p_person_id);
94 --
95 END Get_psn_prsn_nm;
96 --
97 -- -----------------------------------------------------------------------------
98 --
99 -- Version of Get_psn_eml_addrss overloaded to accept VARCHAR2
100 --
101 FUNCTION Get_psn_prsn_nm(p_person_id IN VARCHAR2)
102 RETURN VARCHAR2 IS
103 --
104 BEGIN
105 --
106 RETURN hr_bpl_alert_recipient.Get_psn_prsn_nm(TO_NUMBER(p_person_id));
107 --
108 END Get_psn_prsn_nm;
109 --
110 -- -----------------------------------------------------------------------------
111 --
112 -- Get's a primary assignment supervisor name for a given person_id
113 --
114 FUNCTION Get_psn_sup_psn_nm(p_person_id IN NUMBER)
115 RETURN VARCHAR2 IS
116 --
117 BEGIN
118 --
119 RETURN hr_bpl_alert_recipient.Get_psn_sup_psn_nm(p_person_id);
120 --
121 END Get_psn_sup_psn_nm;
122 --
123 -- -----------------------------------------------------------------------------
124 --
125 -- Overloaded version of Get_psn_sup_psn_nm that accepts VARCHAR2
126 --
127 FUNCTION Get_psn_sup_psn_nm(p_person_id IN VARCHAR2)
128 RETURN VARCHAR2 IS
129 --
130 BEGIN
131 --
132 RETURN hr_bpl_alert_recipient.Get_psn_sup_psn_nm(TO_NUMBER(p_person_id));
133 --
134 END Get_psn_sup_psn_nm;
135 --
136
137
138
139
140 --
141 -- -----------------------------------------------------------------------------
142 --
143 -- Get's a language for a given person_id
144 --
145 FUNCTION Get_psn_lng(p_person_id IN NUMBER)
146 RETURN VARCHAR2 IS
147 --
148 BEGIN
149 --
150 RETURN hr_bpl_alert_recipient.Get_psn_lng(p_person_id);
151 --
152 END Get_psn_lng;
153 --
154 -- -----------------------------------------------------------------------------
155 --
156 -- Get's the primary assignment supervisor's language for a given person_id
157 --
158 FUNCTION Get_psn_sup_psn_lng(p_person_id IN NUMBER)
159 RETURN VARCHAR2 IS
160 --
161 BEGIN
162 --
163 RETURN hr_bpl_alert_recipient.Get_psn_sup_psn_lng(p_person_id);
164 --
165 END Get_psn_sup_psn_lng;
166 --
167 --
168 -- -----------------------------------------------------------------------------
169 --
170 -- Checks to see if a person has an email address
171 --
172 FUNCTION Check_person_in_scope(p_person_id IN NUMBER)
173 RETURN VARCHAR2 IS
174 --
175 BEGIN
176 --
177 RETURN hr_bpl_alert_recipient.Check_person_in_scope(p_person_id);
178 --
179 END Check_person_in_scope;
180 --
181 -- -----------------------------------------------------------------------------
182 --
183 -- Checks to see if a primary assignment supervisor person has an email address
184 -- for a given person_id. If it does return the person_id otherwise return NULL.
185 --
186 FUNCTION Check_sup_person_in_scope(p_person_id IN NUMBER)
187 RETURN VARCHAR2 IS
188 --
189 BEGIN
190 --
191 RETURN hr_bpl_alert_recipient.Check_sup_person_in_scope(p_person_id);
192 --
193 END Check_sup_person_in_scope;
194 --
195
196 --
197 -- -----------------------------------------------------------------------------
198 --
199 -- Get's an email address for a supervisor of a given assignment_id
200 --
201 FUNCTION Get_asg_sup_eml_addrss(p_assignment_id IN NUMBER)
202 RETURN VARCHAR2 IS
203 --
204 BEGIN
205 --
206 RETURN hr_bpl_alert_recipient.Get_asg_sup_eml_addrss(p_assignment_id);
207 --
208 END Get_asg_sup_eml_addrss;
209 --
210 -- -----------------------------------------------------------------------------
211 --
212 -- Get's a assignment supervisor name for a given assignment_id
213 --
214 FUNCTION Get_asg_sup_nm(p_assignment_id IN NUMBER)
215 RETURN VARCHAR2 IS
216 --
217 BEGIN
218 --
219 RETURN hr_bpl_alert_recipient.Get_asg_sup_nm(p_assignment_id);
220 --
221 END Get_asg_sup_nm;
222 --
223 -- -----------------------------------------------------------------------------
224 --
225 -- Get's the assignment supervisor's language for a given assignment_id
226 --
227 FUNCTION Get_asg_sup_lng(p_assignment_id IN NUMBER)
228 RETURN VARCHAR2 IS
229 --
230 BEGIN
231 --
232 RETURN hr_bpl_alert_recipient.Get_asg_sup_lng(p_assignment_id);
233 --
234 END Get_asg_sup_lng;
235 --
236 -- -----------------------------------------------------------------------------
237 --
238 -- Find out if we have an email address for a person's
239 -- assignment supervisor, if we have return assignment_id otherwise NULL
240 --
241 FUNCTION Check_asg_sup_in_scope(p_assignment_id IN NUMBER)
242 RETURN NUMBER IS
243 --
244 BEGIN
245 --
246 RETURN hr_bpl_alert_recipient.Check_asg_sup_in_scope(p_assignment_id);
247 --
248 END Check_asg_sup_in_scope;
249 --
250 -- -----------------------------------------------------------------------------
251 --
252 -- Get's an email address for the primary assignment supervisor of a given
253 -- assignment_id
254 --
255 FUNCTION Get_pasg_sup_eml_addrss(p_assignment_id IN NUMBER)
256 RETURN VARCHAR2 IS
257 --
258 BEGIN
259 --
260 RETURN hr_bpl_alert_recipient.Get_pasg_sup_eml_addrss(p_assignment_id);
261 --
262 END Get_pasg_sup_eml_addrss;
263 --
264 -- -----------------------------------------------------------------------------
265 --
266 -- Get's a primary assignment supervisor name for a given assignment_id
267 --
268 FUNCTION Get_pasg_sup_nm(p_assignment_id IN NUMBER)
269 RETURN VARCHAR2 IS
270 --
271 BEGIN
272 --
273 RETURN hr_bpl_alert_recipient.Get_pasg_sup_nm(p_assignment_id);
274 --
275 END Get_pasg_sup_nm;
276 --
277 -- -----------------------------------------------------------------------------
278 --
279 -- Get's the primary assignment supervisor's language for a given assignment_id
280 --
281 FUNCTION Get_pasg_sup_lng(p_assignment_id IN NUMBER)
282 RETURN VARCHAR2 IS
283 --
284 BEGIN
285 --
286 RETURN hr_bpl_alert_recipient.Get_pasg_sup_lng(p_assignment_id);
287 --
288 END Get_pasg_sup_lng;
289 --
290 -- -----------------------------------------------------------------------------
291 --
292 -- Find out if we have an email address for a person's primary
293 -- assignment supervisor, if we have assignment_id otherwise NULL
294 --
295 FUNCTION Check_pasg_sup_in_scope(p_assignment_id IN NUMBER)
296 RETURN NUMBER IS
297 --
298 BEGIN
299 --
300 RETURN hr_bpl_alert_recipient.Check_pasg_sup_in_scope(p_assignment_id);
301 --
302 END Check_pasg_sup_in_scope;
303 --
304 -- -----------------------------------------------------------------------------
305 --
306 -- Get's an email address for the person who owns an assignment for a given
307 -- assignment_id
308 --
309 FUNCTION Get_asg_psn_eml_addrss(p_assignment_id IN NUMBER)
310 RETURN VARCHAR2 IS
311 --
312 BEGIN
313 --
314 RETURN hr_bpl_alert_recipient.Get_asg_psn_eml_addrss(p_assignment_id);
315 --
316 END Get_asg_psn_eml_addrss;
317 --
318 -- -----------------------------------------------------------------------------
319 --
320 -- Get'sthe person who owns an assignment's name for a given assignment_id
321 --
322 FUNCTION Get_asg_psn_nm(p_assignment_id IN NUMBER)
323 RETURN VARCHAR2 IS
324 --
325 BEGIN
326 --
327 RETURN hr_bpl_alert_recipient.Get_asg_psn_nm(p_assignment_id);
328 --
329 END Get_asg_psn_nm;
330 --
331 -- -----------------------------------------------------------------------------
332 --
333 -- Get's the person who owns an assignment's language for a given assignment_id
334 --
335 FUNCTION Get_asg_psn_lng(p_assignment_id IN NUMBER)
336 RETURN VARCHAR2 IS
337 --
338 BEGIN
339 --
340 RETURN hr_bpl_alert_recipient.Get_asg_psn_lng(p_assignment_id);
341 --
342 END Get_asg_psn_lng;
343 --
344 -- -----------------------------------------------------------------------------
345 --
346 -- Find out if we have an email address for the person who owns an
347 -- assignment, if we have return assignment_id otherwise return NULL
348 --
349 FUNCTION Check_asg_psn_in_scope(p_assignment_id IN NUMBER)
350 RETURN NUMBER IS
351 --
352 BEGIN
353 --
354 RETURN hr_bpl_alert_recipient.Check_asg_psn_in_scope(p_assignment_id);
355 --
356 END Check_asg_psn_in_scope;
357 --
358 -- -----------------------------------------------------------------------------
359 --
360 -- Find out if the assignment has a current primary assignment supervisor
361 --
362 FUNCTION Check_pasg_sup_available(p_assignment_id IN NUMBER)
363 RETURN NUMBER IS
364 --
365 BEGIN
366 --
367 RETURN hr_bpl_alert_recipient.check_pasg_sup_available(p_assignment_id);
368 --
369 END Check_pasg_sup_available;
370 --
371 -- -----------------------------------------------------------------------------
372 --
373 -- Find out if the assignment has a current supervisor
374 --
375 FUNCTION Check_asg_sup_available(p_assignment_id IN NUMBER)
376 RETURN NUMBER IS
377 --
378 BEGIN
379 --
380 RETURN hr_bpl_alert_recipient.check_asg_sup_available(p_assignment_id);
381 --
382 END Check_asg_sup_available;
383 --
384 END HR_VIEW_ALERT_RECIPIENT;