1 package ben_cwb_utils as
2 /* $Header: bencwbutils.pkh 120.6.12010000.2 2008/10/20 12:40:34 sgnanama ship $ */
3 FUNCTION get_task_access (
4 p_hidden_cd IN VARCHAR2,
5 p_task_access_cd IN VARCHAR2,
6 p_plan_access_cd IN VARCHAR2,
7 p_wksht_grp_cd IN VARCHAR2,
8 p_population_cd IN VARCHAR2,
9 p_status_cd IN VARCHAR2,
10 p_dist_bdgt_iss_dt IN DATE,
11 p_ss_update_start_dt IN DATE,
12 p_ss_update_end_dt IN DATE,
13 p_effective_dt IN DATE
14 )
15 RETURN VARCHAR2;
16 --
17 FUNCTION is_task_enabled
18 (p_access_cd in varchar2,
19 p_population_cd in varchar2,
20 p_status_cd in varchar2,
21 p_dist_bdgt_iss_dt in date,
22 p_wksht_grp_cd in varchar2)
23 return varchar2;
24
25 FUNCTION get_manager_name(p_emp_per_in_ler_id in number,
26 p_level in number) return varchar2;
27
28 FUNCTION get_profile(p_profile_name in varchar2)
29 return varchar2;
30
31 PROCEDURE get_site_profile (
32 p_profile_1 in varchar2 default null,
33 p_value_1 out nocopy varchar2);
34
35 PROCEDURE get_resp_profile (
36 p_resp_id in number default null,
37 p_profile_1 in varchar2 default null,
38 p_value_1 out nocopy varchar2);
39
40 PROCEDURE get_user_profile (
41 p_user_id in number default null,
42 p_profile_1 in varchar2 default null,
43 p_profile_2 in varchar2 default null,
44 p_profile_3 in varchar2 default null,
45 p_profile_4 in varchar2 default null,
46 p_profile_5 in varchar2 default null,
47 p_profile_6 in varchar2 default null,
48 p_profile_7 in varchar2 default null,
49 p_profile_8 in varchar2 default null,
50 p_profile_9 in varchar2 default null,
51 p_profile_10 in varchar2 default null,
52 p_value_1 out nocopy varchar2,
53 p_value_2 out nocopy varchar2,
54 p_value_3 out nocopy varchar2,
55 p_value_4 out nocopy varchar2,
56 p_value_5 out nocopy varchar2,
57 p_value_6 out nocopy varchar2,
58 p_value_7 out nocopy varchar2,
59 p_value_8 out nocopy varchar2,
60 p_value_9 out nocopy varchar2,
61 p_value_10 out nocopy varchar2);
62
63 FUNCTION get_bdgt_pct_of_elig_sal_decs return number;
64 FUNCTION get_alloc_pct_of_elig_sal_decs return number;
65
66 FUNCTION get_eligibility(p_plan_status in varchar2,
67 p_opt1_status in varchar2,
68 p_opt2_status in varchar2,
69 p_opt3_status in varchar2,
70 p_opt4_status in varchar2
71 )
72 return varchar2;
73
74 FUNCTION is_person_switchable(p_person_id in number,
75 p_effective_date in date)
76 return varchar2;
77
78 function add_number_with_null_check(p_orig_val in number,
79 p_new_val in number) return number;
80
81 /* ---------------------------------------------------------------------
82 Procedures/Functions Below are defined for Document Management
83 Enhancements to support Printable Documents (PDF)
84 BEGIN
85 --------------------------------------------------------------------- */
86
87 g_person_rates_rec ben_cwb_person_rates%RowType;
88 g_prior_person_rates_rec ben_cwb_person_rates%RowType;
89 g_opt1_person_rates_rec ben_cwb_person_rates%RowType;
90 g_opt2_person_rates_rec ben_cwb_person_rates%RowType;
91 g_opt3_person_rates_rec ben_cwb_person_rates%RowType;
92 g_opt4_person_rates_rec ben_cwb_person_rates%RowType;
93
94 -- Added to support worksheet manager name
95 g_ws_mgr_full_name ben_cwb_person_info.full_name%TYPE;
96 g_ws_mgr_brief_name ben_cwb_person_info.brief_name%TYPE;
97 g_ws_mgr_custom_name ben_cwb_person_info.custom_name%TYPE;
98 --
99
100 CURSOR g_cursor_asgn_txn (c_assignment_id number, c_asg_updt_eff_date varchar2) is
101 select transaction_id assignment_id,
102 attribute1 asg_updt_eff_Date,
103 attribute5 job_id,
104 attribute6 position_id,
105 attribute7 grade_id,
106 attribute8 people_group_id,
107 attribute11 asgn_flex1, attribute12 asgn_flex2, attribute13 asgn_flex3, attribute14 asgn_flex4,
108 attribute15 asgn_flex5, attribute16 asgn_flex6, attribute17 asgn_flex7, attribute18 asgn_flex8,
109 attribute19 asgn_flex9, attribute20 asgn_flex10,attribute21 asgn_flex11,attribute22 asgn_flex12,
110 attribute23 asgn_flex13,attribute24 asgn_flex14,attribute25 asgn_flex15,attribute26 asgn_flex16,
111 attribute27 asgn_flex17,attribute28 asgn_flex18,attribute29 asgn_flex19,attribute30 asgn_flex20,
112 attribute31 asgn_flex21,attribute32 asgn_flex22,attribute33 asgn_flex23,attribute34 asgn_flex24,
113 attribute35 asgn_flex25,attribute36 asgn_flex26,attribute37 asgn_flex27,attribute38 asgn_flex28,
114 attribute39 asgn_flex29,attribute40 asgn_flex30
115 From ben_transaction
116 where transaction_id = c_assignment_id
117 and transaction_type = 'CWBASG'||c_asg_updt_eff_date;
118 --
119 g_asgn_txn_rec g_cursor_asgn_txn%rowType;
120 --
121 Function get_option1_name(
122 p_group_plan_id in number,
123 p_lf_evnt_ocrd_dt in Date,
124 p_oipl_id in number,
125 p_group_per_in_ler_id in number,
126 p_pl_id in number,
127 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
128
129
130 Function get_option1_rate_ws_amt(
131 p_group_plan_id in number,
132 p_lf_evnt_ocrd_dt in Date,
133 p_oipl_id in number,
134 p_group_per_in_ler_id in number,
135 p_pl_id in number,
136 p_ws_sub_acty_typ_cd in varchar2) return number;
137
138 Function get_option1_unit(
139 p_group_plan_id in number,
140 p_lf_evnt_ocrd_dt in Date,
141 p_oipl_id in number,
142 p_group_per_in_ler_id in number,
143 p_pl_id in number,
144 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
145
146
147 Function get_option1_elg_sal(
148 p_group_plan_id in number,
149 p_lf_evnt_ocrd_dt in Date,
150 p_oipl_id in number,
151 p_group_per_in_ler_id in number,
152 p_pl_id in number,
153 p_ws_sub_acty_typ_cd in varchar2) return number;
154
155 Function get_option1_elg_per_sal(
156 p_group_plan_id in number,
157 p_lf_evnt_ocrd_dt in Date,
158 p_oipl_id in number,
159 p_group_per_in_ler_id in number,
160 p_pl_id in number,
161 p_ws_sub_acty_typ_cd in varchar2) return number;
162
163 Function get_option1_rate_reco_amt(
164 p_group_plan_id in number,
165 p_lf_evnt_ocrd_dt in Date,
166 p_oipl_id in number,
167 p_group_per_in_ler_id in number,
168 p_pl_id in number,
169 p_ws_sub_acty_typ_cd in varchar2) return number;
170
171 Function get_option1_rate_oth_sal(
172 p_group_plan_id in number,
173 p_lf_evnt_ocrd_dt in Date,
174 p_oipl_id in number,
175 p_group_per_in_ler_id in number,
176 p_pl_id in number,
177 p_ws_sub_acty_typ_cd in varchar2) return number;
178
179 Function get_option1_rate_sta_sal(
180 p_group_plan_id in number,
181 p_lf_evnt_ocrd_dt in Date,
182 p_oipl_id in number,
183 p_group_per_in_ler_id in number,
184 p_pl_id in number,
185 p_ws_sub_acty_typ_cd in varchar2) return number;
186
187 Function get_option1_rate_tot_comp(
188 p_group_plan_id in number,
189 p_lf_evnt_ocrd_dt in Date,
190 p_oipl_id in number,
191 p_group_per_in_ler_id in number,
192 p_pl_id in number,
193 p_ws_sub_acty_typ_cd in varchar2) return number;
194
195
196 Function get_option1_rate_misc1(
197 p_group_plan_id in number,
198 p_lf_evnt_ocrd_dt in Date,
199 p_oipl_id in number,
200 p_group_per_in_ler_id in number,
201 p_pl_id in number,
202 p_ws_sub_acty_typ_cd in varchar2) return number;
203
204 Function get_option1_rate_misc2(
205 p_group_plan_id in number,
206 p_lf_evnt_ocrd_dt in Date,
207 p_oipl_id in number,
208 p_group_per_in_ler_id in number,
209 p_pl_id in number,
210 p_ws_sub_acty_typ_cd in varchar2) return number;
211
212 Function get_option1_rate_misc3(
213 p_group_plan_id in number,
214 p_lf_evnt_ocrd_dt in Date,
215 p_oipl_id in number,
216 p_group_per_in_ler_id in number,
217 p_pl_id in number,
218 p_ws_sub_acty_typ_cd in varchar2) return number;
219
220
221 Function get_option2_name(
222 p_group_plan_id in number,
223 p_lf_evnt_ocrd_dt in Date,
224 p_oipl_id in number,
225 p_group_per_in_ler_id in number,
226 p_pl_id in number,
227 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
228
229 Function get_option2_rate_ws_amt(
230 p_group_plan_id in number,
231 p_lf_evnt_ocrd_dt in Date,
232 p_oipl_id in number,
233 p_group_per_in_ler_id in number,
234 p_pl_id in number,
235 p_ws_sub_acty_typ_cd in varchar2) return number;
236
237 Function get_option2_unit(
238 p_group_plan_id in number,
239 p_lf_evnt_ocrd_dt in Date,
240 p_oipl_id in number,
241 p_group_per_in_ler_id in number,
242 p_pl_id in number,
243 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
244
245
246 Function get_option2_elg_sal(
247 p_group_plan_id in number,
248 p_lf_evnt_ocrd_dt in Date,
249 p_oipl_id in number,
250 p_group_per_in_ler_id in number,
251 p_pl_id in number,
252 p_ws_sub_acty_typ_cd in varchar2) return number;
253
254 Function get_option2_elg_per_sal(
255 p_group_plan_id in number,
256 p_lf_evnt_ocrd_dt in Date,
257 p_oipl_id in number,
258 p_group_per_in_ler_id in number,
259 p_pl_id in number,
260 p_ws_sub_acty_typ_cd in varchar2) return number;
261
262 Function get_option2_rate_reco_amt(
263 p_group_plan_id in number,
264 p_lf_evnt_ocrd_dt in Date,
265 p_oipl_id in number,
266 p_group_per_in_ler_id in number,
267 p_pl_id in number,
268 p_ws_sub_acty_typ_cd in varchar2) return number;
269
270 Function get_option2_rate_oth_sal(
271 p_group_plan_id in number,
272 p_lf_evnt_ocrd_dt in Date,
273 p_oipl_id in number,
274 p_group_per_in_ler_id in number,
275 p_pl_id in number,
276 p_ws_sub_acty_typ_cd in varchar2) return number;
277
278 Function get_option2_rate_sta_sal(
279 p_group_plan_id in number,
280 p_lf_evnt_ocrd_dt in Date,
281 p_oipl_id in number,
282 p_group_per_in_ler_id in number,
283 p_pl_id in number,
284 p_ws_sub_acty_typ_cd in varchar2) return number;
285
286 Function get_option2_rate_tot_comp(
287 p_group_plan_id in number,
288 p_lf_evnt_ocrd_dt in Date,
289 p_oipl_id in number,
290 p_group_per_in_ler_id in number,
291 p_pl_id in number,
292 p_ws_sub_acty_typ_cd in varchar2) return number;
293
294
295 Function get_option2_rate_misc1(
296 p_group_plan_id in number,
297 p_lf_evnt_ocrd_dt in Date,
298 p_oipl_id in number,
299 p_group_per_in_ler_id in number,
300 p_pl_id in number,
301 p_ws_sub_acty_typ_cd in varchar2) return number;
302
303 Function get_option2_rate_misc2(
304 p_group_plan_id in number,
305 p_lf_evnt_ocrd_dt in Date,
306 p_oipl_id in number,
307 p_group_per_in_ler_id in number,
308 p_pl_id in number,
309 p_ws_sub_acty_typ_cd in varchar2) return number;
310
311 Function get_option2_rate_misc3(
312 p_group_plan_id in number,
313 p_lf_evnt_ocrd_dt in Date,
314 p_oipl_id in number,
315 p_group_per_in_ler_id in number,
316 p_pl_id in number,
317 p_ws_sub_acty_typ_cd in varchar2) return number;
318
319
320 Function get_option3_name(
321 p_group_plan_id in number,
322 p_lf_evnt_ocrd_dt in Date,
323 p_oipl_id in number,
324 p_group_per_in_ler_id in number,
325 p_pl_id in number,
326 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
327
328
329
330 Function get_option3_rate_ws_amt(
331 p_group_plan_id in number,
332 p_lf_evnt_ocrd_dt in Date,
333 p_oipl_id in number,
334 p_group_per_in_ler_id in number,
335 p_pl_id in number,
336 p_ws_sub_acty_typ_cd in varchar2) return number;
337
338 Function get_option3_unit(
339 p_group_plan_id in number,
340 p_lf_evnt_ocrd_dt in Date,
341 p_oipl_id in number,
342 p_group_per_in_ler_id in number,
343 p_pl_id in number,
344 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
345
346
347 Function get_option3_elg_sal(
348 p_group_plan_id in number,
349 p_lf_evnt_ocrd_dt in Date,
350 p_oipl_id in number,
351 p_group_per_in_ler_id in number,
352 p_pl_id in number,
353 p_ws_sub_acty_typ_cd in varchar2) return number;
354
355 Function get_option3_elg_per_sal(
356 p_group_plan_id in number,
357 p_lf_evnt_ocrd_dt in Date,
358 p_oipl_id in number,
359 p_group_per_in_ler_id in number,
360 p_pl_id in number,
361 p_ws_sub_acty_typ_cd in varchar2) return number;
362
363 Function get_option3_rate_reco_amt(
364 p_group_plan_id in number,
368 p_pl_id in number,
365 p_lf_evnt_ocrd_dt in Date,
366 p_oipl_id in number,
367 p_group_per_in_ler_id in number,
369 p_ws_sub_acty_typ_cd in varchar2) return number;
370
371 Function get_option3_rate_oth_sal(
372 p_group_plan_id in number,
373 p_lf_evnt_ocrd_dt in Date,
374 p_oipl_id in number,
375 p_group_per_in_ler_id in number,
376 p_pl_id in number,
377 p_ws_sub_acty_typ_cd in varchar2) return number;
378
379 Function get_option3_rate_sta_sal(
380 p_group_plan_id in number,
381 p_lf_evnt_ocrd_dt in Date,
382 p_oipl_id in number,
383 p_group_per_in_ler_id in number,
384 p_pl_id in number,
385 p_ws_sub_acty_typ_cd in varchar2) return number;
386
387 Function get_option3_rate_tot_comp(
388 p_group_plan_id in number,
389 p_lf_evnt_ocrd_dt in Date,
390 p_oipl_id in number,
391 p_group_per_in_ler_id in number,
392 p_pl_id in number,
393 p_ws_sub_acty_typ_cd in varchar2) return number;
394
395
396 Function get_option3_rate_misc1(
397 p_group_plan_id in number,
398 p_lf_evnt_ocrd_dt in Date,
399 p_oipl_id in number,
400 p_group_per_in_ler_id in number,
401 p_pl_id in number,
402 p_ws_sub_acty_typ_cd in varchar2) return number;
403
404 Function get_option3_rate_misc2(
405 p_group_plan_id in number,
406 p_lf_evnt_ocrd_dt in Date,
407 p_oipl_id in number,
408 p_group_per_in_ler_id in number,
409 p_pl_id in number,
410 p_ws_sub_acty_typ_cd in varchar2) return number;
411
412 Function get_option3_rate_misc3(
413 p_group_plan_id in number,
414 p_lf_evnt_ocrd_dt in Date,
415 p_oipl_id in number,
416 p_group_per_in_ler_id in number,
417 p_pl_id in number,
418 p_ws_sub_acty_typ_cd in varchar2) return number;
419
420 Function get_option4_name(
421 p_group_plan_id in number,
422 p_lf_evnt_ocrd_dt in Date,
423 p_oipl_id in number,
424 p_group_per_in_ler_id in number,
425 p_pl_id in number,
426 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
427
428
429
430 Function get_option4_rate_ws_amt(
431 p_group_plan_id in number,
432 p_lf_evnt_ocrd_dt in Date,
433 p_oipl_id in number,
434 p_group_per_in_ler_id in number,
435 p_pl_id in number,
436 p_ws_sub_acty_typ_cd in varchar2) return number;
437
438 Function get_option4_unit(
439 p_group_plan_id in number,
440 p_lf_evnt_ocrd_dt in Date,
441 p_oipl_id in number,
442 p_group_per_in_ler_id in number,
443 p_pl_id in number,
444 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
445
446
447 Function get_option4_elg_sal(
448 p_group_plan_id in number,
449 p_lf_evnt_ocrd_dt in Date,
450 p_oipl_id in number,
451 p_group_per_in_ler_id in number,
452 p_pl_id in number,
453 p_ws_sub_acty_typ_cd in varchar2) return number;
454
455 Function get_option4_elg_per_sal(
456 p_group_plan_id in number,
457 p_lf_evnt_ocrd_dt in Date,
458 p_oipl_id in number,
459 p_group_per_in_ler_id in number,
460 p_pl_id in number,
461 p_ws_sub_acty_typ_cd in varchar2) return number;
462
463 Function get_option4_rate_reco_amt(
464 p_group_plan_id in number,
465 p_lf_evnt_ocrd_dt in Date,
466 p_oipl_id in number,
467 p_group_per_in_ler_id in number,
468 p_pl_id in number,
469 p_ws_sub_acty_typ_cd in varchar2) return number;
470
471 Function get_option4_rate_oth_sal(
472 p_group_plan_id in number,
473 p_lf_evnt_ocrd_dt in Date,
474 p_oipl_id in number,
475 p_group_per_in_ler_id in number,
476 p_pl_id in number,
477 p_ws_sub_acty_typ_cd in varchar2) return number;
478
479 Function get_option4_rate_sta_sal(
480 p_group_plan_id in number,
481 p_lf_evnt_ocrd_dt in Date,
482 p_oipl_id in number,
483 p_group_per_in_ler_id in number,
484 p_pl_id in number,
485 p_ws_sub_acty_typ_cd in varchar2) return number;
486
487 Function get_option4_rate_tot_comp(
488 p_group_plan_id in number,
489 p_lf_evnt_ocrd_dt in Date,
490 p_oipl_id in number,
491 p_group_per_in_ler_id in number,
492 p_pl_id in number,
493 p_ws_sub_acty_typ_cd in varchar2) return number;
494
495
496 Function get_option4_rate_misc1(
497 p_group_plan_id in number,
498 p_lf_evnt_ocrd_dt in Date,
499 p_oipl_id in number,
500 p_group_per_in_ler_id in number,
501 p_pl_id in number,
502 p_ws_sub_acty_typ_cd in varchar2) return number;
503
504 Function get_option4_rate_misc2(
505 p_group_plan_id in number,
506 p_lf_evnt_ocrd_dt in Date,
507 p_oipl_id in number,
508 p_group_per_in_ler_id in number,
509 p_pl_id in number,
510 p_ws_sub_acty_typ_cd in varchar2) return number;
511
512 Function get_option4_rate_misc3(
513 p_group_plan_id in number,
514 p_lf_evnt_ocrd_dt in Date,
515 p_oipl_id in number,
516 p_group_per_in_ler_id in number,
517 p_pl_id in number,
518 p_ws_sub_acty_typ_cd in varchar2) return number;
519
520 FUNCTION get_plan_rate_misc3 (
521 p_group_plan_id in number,
522 p_lf_evnt_ocrd_dt in Date,
523 p_oipl_id in number,
524 p_group_per_in_ler_id in number,
525 p_pl_id in number,
529 p_group_plan_id in number,
526 p_ws_sub_acty_typ_cd in varchar2 ) return number ;
527
528 FUNCTION get_plan_rate_misc2 (
530 p_lf_evnt_ocrd_dt in Date,
531 p_oipl_id in number,
532 p_group_per_in_ler_id in number,
533 p_pl_id in number,
534 p_ws_sub_acty_typ_cd in varchar2 ) return number;
535
536 FUNCTION get_plan_rate_misc1 (
537 p_group_plan_id in number,
538 p_lf_evnt_ocrd_dt in Date,
539 p_oipl_id in number,
540 p_group_per_in_ler_id in number,
541 p_pl_id in number,
542 p_ws_sub_acty_typ_cd in varchar2 ) return number;
543 FUNCTION get_plan_rate_total_comp (
544 p_group_plan_id in number,
545 p_lf_evnt_ocrd_dt in Date,
546 p_oipl_id in number,
547 p_group_per_in_ler_id in number,
548 p_pl_id in number,
549 p_ws_sub_acty_typ_cd in varchar2 ) return number ;
550
551 FUNCTION get_plan_rate_stat_sal (
552 p_group_plan_id in number,
553 p_lf_evnt_ocrd_dt in Date,
554 p_oipl_id in number,
555 p_group_per_in_ler_id in number,
556 p_pl_id in number,
557 p_ws_sub_acty_typ_cd in varchar2 ) return number;
561 p_lf_evnt_ocrd_dt in Date,
558
559 FUNCTION get_plan_rate_other_sal (
560 p_group_plan_id in number,
562 p_oipl_id in number,
563 p_group_per_in_ler_id in number,
564 p_pl_id in number,
565 p_ws_sub_acty_typ_cd in varchar2 ) return number;
566
567
568 FUNCTION get_plan_rate_rec_amt (
569 p_group_plan_id in number,
570 p_lf_evnt_ocrd_dt in Date,
571 p_oipl_id in number,
572 p_group_per_in_ler_id in number,
573 p_pl_id in number,
574 p_ws_sub_acty_typ_cd in varchar2 ) return number;
575 FUNCTION get_plan_percent_elig_sal (
576 p_group_plan_id in number,
577 p_lf_evnt_ocrd_dt in Date,
578 p_oipl_id in number,
579 p_group_per_in_ler_id in number,
580 p_pl_id in number,
581 p_ws_sub_acty_typ_cd in varchar2 ) return number;
582
583 FUNCTION get_plan_rate_elig_sal (
584 p_group_plan_id in number,
585 p_lf_evnt_ocrd_dt in Date,
586 p_oipl_id in number,
587 p_group_per_in_ler_id in number,
588 p_pl_id in number,
589 p_ws_sub_acty_typ_cd in varchar2 ) return number;
590 FUNCTION get_plan_rate_ws_amt (
591 p_group_plan_id in number,
592 p_lf_evnt_ocrd_dt in Date,
593 p_oipl_id in number,
594 p_group_per_in_ler_id in number,
595 p_pl_id in number,
596 p_ws_sub_acty_typ_cd in varchar2 ) return number;
597 FUNCTION get_pay_rate_basis (
598 p_group_plan_id in number,
599 p_lf_evnt_ocrd_dt in Date,
600 p_oipl_id in number,
601 p_group_per_in_ler_id in number,
602 p_pl_id in number,
603 p_ws_sub_acty_typ_cd in varchar2) return Varchar2 ;
604
605 FUNCTION get_pay_rate_change_percent (
606 p_group_plan_id in number,
607 p_lf_evt_ocrd_dt in Date,
608 p_oipl_id in number,
609 p_group_per_in_ler_id in number,
610 p_pl_id in number,
611 p_ws_sub_acty_typ_cd in varchar2) return number;
612
613 FUNCTION get_pay_rate_change_amount (
614 p_group_plan_id in number,
615 p_lf_evt_ocrd_dt in Date,
616 p_oipl_id in number,
617 p_group_per_in_ler_id in number,
618 p_pl_id in number,
619 p_ws_sub_acty_typ_cd in varchar2) return number;
620
621 FUNCTION get_pay_rate (
625 p_group_per_in_ler_id in number,
622 p_group_plan_id in number,
623 p_lf_evnt_ocrd_dt in Date,
624 p_oipl_id in number,
626 p_pl_id in number,
627 p_ws_sub_acty_typ_cd in varchar2,
628 p_new_or_prior in varchar2) return number;
629
630 FUNCTION get_pay_rate_change_date (
631 p_group_plan_id in number,
632 p_lf_evnt_ocrd_dt in Date,
633 p_oipl_id in number,
634 p_group_per_in_ler_id in number,
635 p_pl_id in number,
636 p_ws_sub_acty_typ_cd in varchar2,
637 p_new_or_prior in varchar2) return varchar2;
638
639 function get_new_perf_rating (
640 p_assignment_id in number,
641 p_perf_revw_strt_dt in date,
642 p_emp_interview_typ_cd in varchar2 ) return varchar2 ;
643
644
645 FUNCTION get_new_asgn_flex(
646 p_assignment_id in number,
647 p_asg_updt_eff_date in date,
648 p_asg_flex_num in number
649 ) return varchar2 ;
650
651 FUNCTION get_new_people_group(
652 p_assignment_id in number,
653 p_asg_updt_eff_date in date) return varchar2;
654
655 FUNCTION get_new_grade (
656 p_assignment_id in number,
657 p_asg_updt_eff_date in date) return varchar2;
658
659 FUNCTION get_new_position (
660 p_assignment_id in number,
661 p_asg_updt_eff_date in date) return varchar2;
662
663 FUNCTION get_new_job (
664 p_assignment_id in number,
665 p_asg_updt_eff_date in date) return varchar2;
666 --
667 FUNCTION get_group_short_name (
668 p_plan_id in number ,
669 p_lf_evt_ocrd_dt in date ) return varchar2;
670
671
672
673 FUNCTION get_ws_mgr_full_name(p_group_per_in_ler_id in number) return varchar2;
674 FUNCTION get_ws_mgr_brief_name(p_group_per_in_ler_id in number) return varchar2;
675 FUNCTION get_ws_mgr_custom_name(p_group_per_in_ler_id in number) return varchar2;
676
677 Function get_option1_currency(
678 p_group_plan_id in number,
679 p_lf_evnt_ocrd_dt in Date,
680 p_oipl_id in number,
681 p_group_per_in_ler_id in number,
682 p_pl_id in number,
683 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
684
685 Function get_option2_currency(
686 p_group_plan_id in number,
687 p_lf_evnt_ocrd_dt in Date,
688 p_oipl_id in number,
689 p_group_per_in_ler_id in number,
690 p_pl_id in number,
691 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
692
693 Function get_option3_currency(
694 p_group_plan_id in number,
695 p_lf_evnt_ocrd_dt in Date,
696 p_oipl_id in number,
697 p_group_per_in_ler_id in number,
698 p_pl_id in number,
699 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
700
701 Function get_option4_currency(
702 p_group_plan_id in number,
703 p_lf_evnt_ocrd_dt in Date,
704 p_oipl_id in number,
705 p_group_per_in_ler_id in number,
706 p_pl_id in number,
707 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
708
709 FUNCTION get_plan_rate_start_dt (
710 p_group_plan_id in number,
711 p_lf_evnt_ocrd_dt in Date,
712 p_oipl_id in number,
713 p_group_per_in_ler_id in number,
714 p_pl_id in number,
715 p_ws_sub_acty_typ_cd in varchar2 ) return varchar2;
716
717 Function get_option1_rate_start_dt(
718 p_group_plan_id in number,
719 p_lf_evnt_ocrd_dt in Date,
720 p_oipl_id in number,
721 p_group_per_in_ler_id in number,
722 p_pl_id in number,
723 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
724
725 Function get_option2_rate_start_dt(
726 p_group_plan_id in number,
727 p_lf_evnt_ocrd_dt in Date,
728 p_oipl_id in number,
729 p_group_per_in_ler_id in number,
730 p_pl_id in number,
731 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
732
733 Function get_option3_rate_start_dt(
734 p_group_plan_id in number,
735 p_lf_evnt_ocrd_dt in Date,
736 p_oipl_id in number,
737 p_group_per_in_ler_id in number,
738 p_pl_id in number,
739 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
740
741 Function get_option4_rate_start_dt(
742 p_group_plan_id in number,
743 p_lf_evnt_ocrd_dt in Date,
744 p_oipl_id in number,
745 p_group_per_in_ler_id in number,
746 p_pl_id in number,
747 p_ws_sub_acty_typ_cd in varchar2) return varchar2;
748
749
750 --
751 /* ---------------------------------------------------------------------
752 END -- Changes for Printable document
753 --------------------------------------------------------------------- */
754 END ben_cwb_utils;