1 package ben_manage_life_events as
2 /* $Header: benmngle.pkh 120.7.12010000.1 2008/07/29 12:27:00 appldev ship $ */
3 /*
4 +==============================================================================+
5 | Copyright (c) 1997 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +==============================================================================+
9
10 Name
11 Manage Life Events
12 Purpose
13 This package is used to check validity of parameters passed in via SRS
14 or via a PL/SQL function or procedure.
15 History
16 Date Who Version What?
17 ---- --- ------- -----
18 14 Dec 97 G Perry 110.0 Created.
19 04 Jan 98 G Perry 110.1 Added extra parameters to
20 main process_life_events
21 call.
22 05 Jan 98 G Perry 110.2 Altered parameters so they
23 are in a more logical order.
24 Added exception g_record_error.
25 13 Jan 98 G Perry 110.3 Added globals g_person_id and
26 changed l_validate to
27 g_validate. Added in two
28 new parameters to handle
29 person_selection_rule_id
30 and
31 comp_selection_rule_id
32 14 Jan 98 G Perry 110.4 Cached comp object names
33 structure added and boolean
34 to notify when a person has
35 changed.
36 15 Jan 98 G Perry 110.5 Changed cache comp object
37 from ptyp to pltyp to tie
38 in with altered domain
39 lookup code.
40 15 Jan 98 G Perry 110.6 Changed p_validate to a
41 varchar2 from a boolean due
42 to SRS.
43 15 Jan 98 lmcdonal 110.7 Added g_elig_for_pgm,
44 g_elig_for_pl,
45 g_pl_nip.
46 16 Jan 98 G Perry 110.8 Added retcode and errbuf
47 which are needed by SRS.
48 19 Jan 98 lmcdonal 110.9 created globals for person,
49 assignment and
50 life event name.
51 21 Jan 98 G Perry 110.10 Created globals
52 g_last_person_failed
53 g_last_plan_failed
54 g_last_prog_failed
55 to handle propergation of comp
56 object failures.
57 24 Jan 98 G Perry 110.11 Changed g_validate to false.
58 27 Jan 98 G Perry 110.12 Added g_ler_id as global.
59 27 Jan 98 G Perry 110.13 g_validate change didn't get
60 made before.
61 06 Mar 98 G Perry 110.14 Added restart procedure. Added
62 benefit_action_id parameter to
63 process procedure. removed proc
64 commit_all_data. Added build_comp
65 object_list so the list of
66 objects is available for
67 what-if functionality.
68 Added data structures for
69 caching person related data and
70 comp object related data. Removed
71 globals that were no longer needed.
72 16 Mar 98 G Perry 110.15 Added prtn_eff_strt_dt_rl and
73 prtn_eff_strt_dt_rl into object
74 cache structure for pl,pgm,oipl.
75 08 Apr 98 G Perry 110.16 Added new global structures and
76 made several functions and
77 procedures public.
78 11 Apr 98 G Perry 110.17 Added cache structure for
79 reporting.
80 20 Apr 98 G Perry 110.18 Added g_life_event_after
81 exception.
82 04 Jun 98 G Perry 110.19 Added fte_value and total_fte_
83 value
84 to person_rec structure.
85 05 Jun 98 jcarpent 110.20 Added global for g_last_pgm_id.
86 24 Aug 98 G Perry 110.22 Added extra globals to
87 structure for bendenrr.pkb.
88 23 Sep 98 G Perry 115.6 Made private procedures public
89 for Prasad.
90 07 Oct 98 G Perry 115.7 Fixed a few schema changes and
91 editted cache record structure.
92 15 Oct 98 G Perry 115.8 Added new columns to oipl rec.
93 20 Oct 98 jcarpent 115.9 Added new columns to pl+pgm recs
94 20 Oct 98 jcarpent 115.10 Added new columns to pgm cache
95 21 Oct 98 jcarpent 115.11 Added alws_unrstrctd_enrt_flag.
96 Allow flush_global_structs access
97 24 Oct 98 G Perry 115.12 Added elig_apls_flag to all cache
98 structures.
99 26 Oct 98 G Perry 115.13 Added hourly_salaried_code to
100 person cache.
101 30 Oct 98 G Perry 115.14 Changed parameter name for
102 build_comp_object_list from
103 p_cache_single_object to
104 p_mode, this was for unrestricted
105 enrollment needs.
106 31 Oct 98 G Perry 115.15 Added p_lf_evt_ocrd_dt param.
107 31 Dec 98 G Perry 115.16 Added people_group_id to cache.
108 18 Jan 99 G Perry 115.17 LED V ED
109 08 Feb 99 G Perry 115.18 Added in new columns to cache
110 min_per_effective_start_date and
111 min_ass_effective_start_date
112 18 Feb 99 G Perry 115.19 Support for canonical dates.
113 15 Mar 99 G Perry 115.20 Changed order of process
114 procedure per bug 1529
115 16 Mar 99 mhoyes 115.21 Added p_popl_enrt_typ_cycl_id to
116 evaluate_life_events.
117 06-May-99 bbulusu 115.24 Added original_date_of_hire to
118 the g_cache_person_object record.
119 14-May-99 P Bodla 115.25 Added p_lf_evt_ocrd_dt to
120 procedure calls.
121 evaluate_life_events
122 process_life_events
123 02-Jun-99 bbulusu 115.26 Added 3 columns to g_cache_person
124 03-Jun-99 stee 115.27 Added 3 columns to
125 g_cache_person_prtn.
126 18-Jun-99 G Perry 115.28 Removed derived_factor cache
127 This is now handled in the
128 ben_seeddata_object package.
129 23-Jun-99 G Perry 115.29 Removed plan, option and program
130 cache.
131 01-JUL-99 pbodla 115.30 Changes related with << Life Event Collision >>
132 added g_bckdt_per_in_ler_id
133 20-JUL-99 Gperry 115.31 genutils -> benutils package
134 rename.
135 27-JUL-99 mhoyes 115.32 - Fixed genutil problems.
136 10-AUG-99 Gperry 115.33 Removed cache structures that
137 are no longer required.
138 15-SEP-99 Gperry 115.34 Added audit_log_flag as param
139 for concurrent program call.
140 04-OCT-99 Stee 115.35 Added ptip_id to
141 g_cache_person_prtn_object.
142 03-NOV-99 mhoyes 115.36 - Added eligibility transition
143 states to g_cache_proc_objects_rec.
144 03-FEB-00 mhoyes 115.40 - Rolled back to pre-filtering.
145 10-FEB-00 mhoyes 115.41 - Added clear_init_benmngle_caches.
146 26-FEB-00 mhoyes 115.42 - Added new type g_par_elig_state_rec
147 to store parent eligibility state
148 information.
149 - Added parent comp object IDs to
150 g_cache_proc_objects_rec.
151 27-FEB-00 stee 115.43 - Added new parameter,
152 p_cbr_tmprl_evt_flag.
153 28-FEB-00 stee 115.44 - Added p_cbr_tmprl_evt_flag
154 parameter to all relevant
155 procedures.
156 04-MAR-00 mhoyes 115.45 - Added elig_tran_state and
157 trk_inelig_per_flag to comp
158 object cache.
159 - Removed first_inelig and
160 still_inelig attributes.
161 06-MAR-00 gperry 115.46 Changed procedure process_life
162 _events to use nocopy references
163 so we can use local variables to
164 find the number of errors.
165 07-MAR-00 mhoyes 115.47 - Removed build_comp_object_list.
166 09-MAR-00 gperry 115.48 Added flag_bit_val for
167 performance and binary globals.
168 31-MAR-00 gperry 115.49 Added oiplip support.
169 12-MAY-00 mhoyes 115.50 - Moved type g_par_elig_state_rec
170 to ben_comp_obj_filter.
171 26-JUN-00 stee 115.51 - Default p_derivable_factors to
172 a code.
173 03-Jul-00 mhoyes 115.52 - Added opt_id to g_cache_proc_objects_rec.
174 05-sep-00 pbodla 115.53 - Bug 5422 : Allow different enrollment periods
175 for programs for a scheduled enrollment.
176 p_popl_enrt_typ_cycl_id is removed.
177 18-Sep-00 pbodla 115.54 - Healthnet changes : PB : Added parameter
178 p_lmt_prpnip_by_org_typ_id to
179 Comp objects are now selected based on person's
180 organization id if p_lmt_prpnip_by_org_typ_id is
181 Y.
182 22-Sep-00 gperry 115.55 Added back param
183 p_popl_enrt_typ_cycl_id as
184 otherwise multithread fails.
185 WWBUG 1412825.
186 05-Jan-01 kmahendr 115.56 Added g_ler_id
187 01-Jul-01 kmahendr 115.57 Added g_enrt_rt_tbl and g_pil_popl_tbl
188 25-Sep-01 kmahendr 115.58 Added procedure process_recalculate as
189 wrapper to procedure process
190 30-Nov-01 mhoyes 115.59 - Made p_benefit_action_id in/out on
191 process.
192 06-Dec-01 mhoyes 115.60 - Fixed concurrent manager problem
193 with new CAGR OUT NOCOPY parameter on process.
194 Added new routine inner_process.
195 19-Dec-01 pbodla 115.61 - Added cwb_process wrapper.
196 07-Jan-02 rpillay 115.62 - Added Set Verify Off.
197 08-jan-02 ikasire 115.63 Bug 2172031 cwb_change of order in parameters
198 10-jan-02 ikasire 115.64 Bug 2172028 adding new procedure for
199 rebuilding the hierarchy when a
200 manager is changed from the view person
201 life events form.
202 Made the procedure popu_epe_heir as
203 a public procedure
204 12-Feb-02 mhoyes 115.65 - Added write_bft_statistics and
205 init_bft_statistics.
206 11-Mar-02 mhoyes 115.66 - Dependent eligibility tuning.
207 26-Jun-02 pbodla 115.67 - ABSENCES - Added procedure abse_process
208 23-Aug-02 mhoyes 115.68 - Added elig_flag, must_enrl_anthr_pl_id
209 and prtn_strt_dt to g_cache_proc_objects_rec.
210 10-Dec-02 pabodla 115.69 - CWBITEM:
211 mmudigon 1) Change in parameters for
212 rebuild_heirarchy
213 2) new proc popu_pel_heir
214 3) Commented proc popu_epe_heir
215 29-Jan-03 kmahendr 115.70 - Added a wrapper for Personnel Action Mode
216 30-Jan-03 pbodla 115.71 - Added a wrapper for Grade/step
217 progression participation process.
218 17-Mar-03 vsethi 115.73 - Bug 2650247 added inelg_rsn_cd to record type
219 g_cache_proc_objects_rec
220 27-Apr-03 mmudigon 115.74 - Absences July FP enhancements.
221 Additional param
222 p_abs_historical_mode
223 01-Aug-03 rpgupta 115.75 - 2940151 Grade/ step
224 added some parameters to grade_step_process
225 26-Sep-03 stee 115.76 - 2894200: Added g_derivable_factors.
226 22-Dec-03 Indrasen 115.77 CWBGLOBAL New Procedure
227 21-Jan-04 ikasire 115.78 Added p_trace_plans_flag to CWBGLOBAL
228 procedure
232 06-Oct-04 abparekh 115.81 GSP Rate Sync changes
229 07-Apr-04 pbodla 115.79 FONM :Added globals to support FONM
230 functionality.
231 28-Sep-04 hmani 115.80 IREC Main Line FP of 115.77.15102.3
233 22-sep-05 ssarkar 115.82 Bug 4621751 irec2 -- offer assignment
234 03-Jan-06 nhunur 115.83 cwb - changes for person type param.
235 08-Feb-06 abparekh 115.84 Bug 4875181 - Added p_run_rollup_only to cwb_global_process
236 22-May-06 pbodla 115.25 Bug 5232223 - Added code to handle the trk inelig flag
237 If trk inelig flag is set to N at group plan level
238 then do not create cwb per in ler and all associated data.
239 20-Sep-06 abparekh 115.86 Bug 5550359 : Added p_validate to PROCESS_LIFE_EVENTS
240 and EVALUATE_LIFE_EVENTS
241 05-Apr-07 rtagarra 115.87 Bug 6000303 : Defer Deenroll ENH.Added g_defer_deenrol_flag
242 g_defer_enr_exists_in_pgm,g_defer_enr_exists_in_pl.
243 16-May-07 rtagarra 115.88 -- DO --
244 */
245 --------------------------------------------------------------------------------
246 --
247 g_record_error exception;
248 g_life_event_after exception;
249 -- Bug 5232223
250 g_cwb_trk_ineligible exception;
251 g_cached_objects boolean:= false;
252 g_elig_for_pgm_flag varchar2(1);
253 g_elig_for_pl_flag varchar2(1);
254 g_trk_inelig_flag varchar2(1);
255 g_pl_nip varchar2(1);
256 g_last_pgm_id number := null;
257 g_modified_mode varchar2(1);
258 -- added g_ler_id for unrestricted enhancement
259 g_ler_id number;
260 g_derivable_factors varchar2(30) := 'ASC';
261 fonm varchar2(30) ;
262 g_fonm_cvg_strt_dt date ;
263 g_fonm_rt_strt_dt date ;
264 --
265 -- PB :Backed out per in ler id required for life event collision and restoration
266 --
267 g_bckdt_per_in_ler_id number := null;
268 --
269 g_output_string varchar2(1000);
270 g_rec ben_type.g_report_rec;
271 --
272 g_defer_deenrol_flag varchar2(1);
273 -- iRec
274 -- This global variable would store assignment record for an applicant's assignment
275 -- being processed by BENMNGLE for mode = I : iRecruitment. The variable is exclusively
276 -- for BENMNGLE processing in iRec mode for a single Applicant. If BENMNGLE is modified
277 -- to process multiple applicants in single run, then this variable may not be valid to use.
278 g_irec_ass_rec per_all_assignments_f%rowtype;
279 g_irec_old_ass_rec per_all_assignments_f%rowtype; -- irec2
280 g_irec_off_ass_id number ;-- Note:g_irec_off_ass_id is to hold irc_offers.offer_assignment_id%type data. -- irec2
281 --
282
283 --
284 type g_cache_proc_objects_rec is record
285 (pl_id ben_pl_f.pl_id%type
286 ,pgm_id ben_pgm_f.pgm_id%type
287 ,oipl_id ben_oipl_f.oipl_id%type
288 ,ptip_id ben_ptip_f.ptip_id%type
289 ,plip_id ben_plip_f.plip_id%type
290 ,pl_nip varchar2(1)
291 ,elig_tran_state varchar2(100)
292 ,trk_inelig_per_flag varchar2(1)
293 ,par_pgm_id number
294 ,par_ptip_id number
295 ,par_plip_id number
296 ,par_pl_id number
297 ,par_opt_id number
298 ,flag_bit_val binary_integer
299 ,oiplip_flag_bit_val binary_integer
300 ,oiplip_id number
301 ,elig_per_id number
302 ,elig_per_opt_id number
303 ,elig_flag varchar2(1)
304 ,must_enrl_anthr_pl_id number
305 ,prtn_strt_dt date
306 ,inelg_rsn_cd varchar2(30) -- 2650247
307 );
308 --
309 -- Binary flag values for the cwflag bit val
310 --
311 g_age_flag number := 1;
312 g_age_rt_flag number := 2;
313 g_los_flag number := 4;
314 g_los_rt_flag number := 8;
315 g_cmp_flag number := 16;
316 g_cmp_rt_flag number := 32;
317 g_pft_flag number := 64;
318 g_pft_rt_flag number := 128;
319 g_hrw_flag number := 256;
320 g_hrw_rt_flag number := 512;
321 g_cal_flag number := 1024;
322 g_cal_rt_flag number := 2048;
323 --
324 type g_cache_proc_object_table is table of g_cache_proc_objects_rec
325 index by binary_integer;
326 --
327 -- Variable to hold table structure
328 --
329 g_cache_proc_object g_cache_proc_object_table;
330 --
331 type g_cache_comp_objects_rec is record
332 (pgm hr_lookups.meaning%type,
333 pltyp hr_lookups.meaning%type,
334 ptip hr_lookups.meaning%type,
335 pl hr_lookups.meaning%type,
336 plip hr_lookups.meaning%type,
337 oipl hr_lookups.meaning%type);
338 --
339 -- Variable to hold cached comp objects structure
340 --
341 g_cache_comp_objects g_cache_comp_objects_rec;
342 --
343 type g_cache_person_process_object is record
344 (person_id ben_person_actions.person_id%type,
345 person_action_id ben_person_actions.person_action_id%type,
346 object_version_number ben_person_actions.object_version_number%type,
347 ler_id ben_person_actions.ler_id%type);
348 --
349 type g_cache_person_process_rec is table of g_cache_person_process_object
350 index by binary_integer;
351 --
352 g_cache_person_process g_cache_person_process_rec;
353 --
357 pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
354 type g_cache_person_prtn_object is record
355 (pl_id ben_prtt_enrt_rslt_f.pl_id%type,
356 oipl_id ben_prtt_enrt_rslt_f.oipl_id%type,
358 ptip_id ben_prtt_enrt_rslt_f.ptip_id%type,
359 enrt_cvg_strt_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type,
360 enrt_cvg_thru_dt ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type);
361 -- enrld_cvrd_flag ben_prtt_enrt_rslt_f.enrld_cvrd_flag%type);
362 --
363 type g_cache_person_prtn_rec is table of g_cache_person_prtn_object
364 index by binary_integer;
365 --
366 g_cache_person_prtn g_cache_person_prtn_rec;
367 --
368 type g_enrt_rt_object is record
369 (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
370 acty_base_rt_id ben_enrt_rt.acty_base_rt_id%type,
371 prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type);
372
373 type g_enrt_rt_rec is table of g_enrt_rt_object
374 index by binary_integer;
375
376 g_enrt_rt_tbl g_enrt_rt_rec;
377 --
378 type g_pil_popl_object is record
379 (pgm_id ben_pil_elctbl_chc_popl.pgm_id%type,
380 pl_id ben_pil_elctbl_chc_popl.pl_id%type,
381 elcns_made_dt ben_pil_elctbl_chc_popl.elcns_made_dt%type);
382
383 type g_pil_popl_rec is table of g_pil_popl_object
384 index by binary_integer;
385
386 g_pil_popl_tbl g_pil_popl_rec;
387 ---------------------------------------------------------------------
388 procedure clear_init_benmngle_caches
389 (p_business_group_id in number
390 ,p_effective_date in date
391 ,p_threads in number default null
392 ,p_chunk_size in number default null
393 ,p_max_errors in number default null
394 ,p_benefit_action_id in number default null
395 ,p_thread_id in number default null
396 );
397
398 --
399 -- CWB wrapper header for benmngle process
400 --
401 procedure cwb_process
402 (errbuf out nocopy varchar2
403 ,retcode out nocopy number
404 ,p_benefit_action_id in number default null
405 ,p_effective_date in varchar2
406 ,p_mode in varchar2 default 'W'
407 ,p_derivable_factors in varchar2 default 'ASC'
408 ,p_validate in varchar2 default 'N'
409 ,p_person_id in number default null
410 ,p_pgm_id in number default null
411 ,p_business_group_id in number
412 ,p_pl_id in number default null
413 ,p_popl_enrt_typ_cycl_id in number default null
414 ,p_lf_evt_ocrd_dt in varchar2 default null
415 ,p_person_type_id in number default null
416 ,p_no_programs in varchar2 default 'N'
417 ,p_no_plans in varchar2 default 'N'
418 ,p_comp_selection_rule_id in number default null
419 ,p_person_selection_rule_id in number default null
420 ,p_ler_id in number default null
421 ,p_organization_id in number default null
422 ,p_benfts_grp_id in number default null
423 ,p_location_id in number default null
424 ,p_pstl_zip_rng_id in number default null
425 ,p_rptg_grp_id in number default null
426 ,p_pl_typ_id in number default null
427 ,p_opt_id in number default null
428 ,p_eligy_prfl_id in number default null
429 ,p_vrbl_rt_prfl_id in number default null
430 ,p_legal_entity_id in number default null
431 ,p_payroll_id in number default null
432 ,p_commit_data in varchar2 default 'Y'
433 ,p_audit_log_flag in varchar2 default 'N'
434 ,p_lmt_prpnip_by_org_flag in varchar2 default 'N'
435 ,p_cbr_tmprl_evt_flag in varchar2 default 'N'
436 ,p_cwb_person_type in varchar2 default null
437 );
438 --
439 --
440 -- CWBGLOBAL wrapper header for benmngle process
441 --
442 procedure cwb_global_process
443 (errbuf out nocopy varchar2
444 ,retcode out nocopy number
445 ,p_benefit_action_id in number default null
446 ,p_effective_date in varchar2
447 ,p_mode in varchar2 default 'W'
448 ,p_derivable_factors in varchar2 default 'ASC'
449 ,p_validate in varchar2 default 'N'
450 ,p_person_id in number default null
451 ,p_pgm_id in number default null
452 ,p_business_group_id in number
453 ,p_pl_id in number default null
454 ,p_popl_enrt_typ_cycl_id in number default null
455 ,p_lf_evt_ocrd_dt in varchar2 default null
456 ,p_person_type_id in number default null
457 ,p_no_programs in varchar2 default 'N'
458 ,p_no_plans in varchar2 default 'N'
459 ,p_comp_selection_rule_id in number default null
460 ,p_person_selection_rule_id in number default null
461 ,p_ler_id in number default null
462 ,p_organization_id in number default null
463 ,p_benfts_grp_id in number default null
464 ,p_location_id in number default null
465 ,p_pstl_zip_rng_id in number default null
469 ,p_eligy_prfl_id in number default null
466 ,p_rptg_grp_id in number default null
467 ,p_pl_typ_id in number default null
468 ,p_opt_id in number default null
470 ,p_vrbl_rt_prfl_id in number default null
471 ,p_legal_entity_id in number default null
472 ,p_payroll_id in number default null
473 ,p_commit_data in varchar2 default 'Y'
474 ,p_audit_log_flag in varchar2 default 'N'
475 ,p_lmt_prpnip_by_org_flag in varchar2 default 'N'
476 ,p_cbr_tmprl_evt_flag in varchar2 default 'N'
477 ,p_trace_plans_flag in varchar2 default 'N'
478 ,p_cwb_person_type in varchar2 default null
479 ,p_run_rollup_only in varchar2 default 'N'
480 );
481 --
482 -- Added process so that more IN OUT and OUT parameters can be added
483 -- to benmngle for PLSQL calls. Concurrent manager still calls process because
484 -- it must have only errbuf and retcode as OUT parameters.
485 --
486 procedure internal_process
487 (errbuf out nocopy varchar2
488 ,retcode out nocopy number
489 ,p_benefit_action_id in out nocopy number
490 ,p_effective_date in varchar2
491 ,p_mode in varchar2
492 ,p_derivable_factors in varchar2 default 'ASC'
493 ,p_validate in varchar2 default 'N'
494 ,p_person_id in number default null
495 ,p_person_type_id in number default null
496 ,p_pgm_id in number default null
497 ,p_business_group_id in number
498 ,p_pl_id in number default null
499 ,p_popl_enrt_typ_cycl_id in number default null
500 ,p_lf_evt_ocrd_dt in varchar2 default null
501 ,p_no_programs in varchar2 default 'N'
502 ,p_no_plans in varchar2 default 'N'
503 ,p_comp_selection_rule_id in number default null
504 ,p_person_selection_rule_id in number default null
505 ,p_ler_id in number default null
506 ,p_organization_id in number default null
507 ,p_benfts_grp_id in number default null
508 ,p_location_id in number default null
509 ,p_pstl_zip_rng_id in number default null
510 ,p_rptg_grp_id in number default null
511 ,p_pl_typ_id in number default null
512 ,p_opt_id in number default null
513 ,p_eligy_prfl_id in number default null
514 ,p_vrbl_rt_prfl_id in number default null
515 ,p_legal_entity_id in number default null
516 ,p_payroll_id in number default null
517 ,p_commit_data in varchar2 default 'Y'
518 ,p_audit_log_flag in varchar2 default 'N'
519 ,p_lmt_prpnip_by_org_flag in varchar2 default 'N'
520 ,p_cbr_tmprl_evt_flag in varchar2 default 'N'
521 -- GRADE/STEP : Added for grade/step benmngle
522 ,p_org_heirarchy_id in number default null
523 ,p_org_starting_node_id in number default null
524 ,p_grade_ladder_id in number default null
525 ,p_asg_events_to_all_sel_dt in varchar2 default null
526 ,p_rate_id in number default null -- pay scale
527 ,p_per_sel_dt_cd in varchar2 default null -- business rule
528 ,p_per_sel_dt_from in date default null -- business rule date from
529 ,p_per_sel_dt_to in date default null -- business rule date to
530 ,p_year_from in number default null -- business rule year from
531 ,p_year_to in number default null -- business rule year to
532 ,p_cagr_id in number default null -- Coll agreement id
533 ,p_qual_type in number default null
534 ,p_qual_status in varchar2 default null
535 -- 2940151
536 ,p_per_sel_freq_cd in varchar2 default null
537 ,p_concat_segs in varchar2 default null
538 -- end 2940151
539 ,p_abs_historical_mode in varchar2 default 'N'
540 ,p_gsp_eval_elig_flag in varchar2 default null -- GSP Rate Sync : Evaluate Eligibility
541 ,p_lf_evt_oper_cd in varchar2 default null -- GSP Rate Sync : Life Event Operation code
542 ,p_cwb_person_type in varchar2 default null
543 );
544 -----------------------------------------------------------------------
545 procedure process
546 (errbuf out nocopy varchar2
547 ,retcode out nocopy number
548 ,p_benefit_action_id in number
549 ,p_effective_date in varchar2
550 ,p_mode in varchar2
551 ,p_derivable_factors in varchar2 default 'ASC'
552 ,p_validate in varchar2 default 'N'
553 ,p_person_id in number default null
554 ,p_person_type_id in number default null
555 ,p_pgm_id in number default null
556 ,p_business_group_id in number
557 ,p_pl_id in number default null
558 ,p_popl_enrt_typ_cycl_id in number default null
559 ,p_lf_evt_ocrd_dt in varchar2 default null
563 ,p_person_selection_rule_id in number default null
560 ,p_no_programs in varchar2 default 'N'
561 ,p_no_plans in varchar2 default 'N'
562 ,p_comp_selection_rule_id in number default null
564 ,p_ler_id in number default null
565 ,p_organization_id in number default null
566 ,p_benfts_grp_id in number default null
567 ,p_location_id in number default null
568 ,p_pstl_zip_rng_id in number default null
569 ,p_rptg_grp_id in number default null
570 ,p_pl_typ_id in number default null
571 ,p_opt_id in number default null
572 ,p_eligy_prfl_id in number default null
573 ,p_vrbl_rt_prfl_id in number default null
574 ,p_legal_entity_id in number default null
575 ,p_payroll_id in number default null
576 ,p_commit_data in varchar2 default 'Y'
577 ,p_audit_log_flag in varchar2 default 'N'
578 ,p_lmt_prpnip_by_org_flag in varchar2 default 'N'
579 ,p_cbr_tmprl_evt_flag in varchar2 default 'N'
580 -- GRADE/STEP : Added for grade/step benmngle
581 ,p_org_heirarchy_id in number default null
582 ,p_org_starting_node_id in number default null
583 ,p_grade_ladder_id in number default null
584 ,p_asg_events_to_all_sel_dt in varchar2 default null
585 ,p_rate_id in number default null -- pay scale
586 ,p_per_sel_dt_cd in varchar2 default null -- business rule
587 ,p_per_sel_dt_from in date default null -- business rule date from
588 ,p_per_sel_dt_to in date default null -- business rule date to
589 ,p_year_from in number default null -- business rule year from
590 ,p_year_to in number default null -- business rule year to
591 ,p_cagr_id in number default null -- Coll agreement id
592 ,p_qual_type in number default null
593 ,p_qual_status in varchar2 default null
594 -- 2940151
595 ,p_per_sel_freq_cd in varchar2 default null
596 ,p_concat_segs in varchar2 default null
597 -- end 2940151
598 ,p_abs_historical_mode in varchar2 default 'N'
599 ,p_gsp_eval_elig_flag in varchar2 default null -- GSP Rate Sync : Evaluate Eligibility
600 ,p_lf_evt_oper_cd in varchar2 default null -- GSP Rate Sync : Life Event Operation code
601 ,p_cwb_person_type in varchar2 default null
602 );
603 --
604 procedure restart
605 (errbuf out nocopy varchar2,
606 retcode out nocopy number,
607 p_benefit_action_id in number);
608 -----------------------------------------------------------------------
609 procedure person_header
610 (p_person_id in number default null,
611 p_business_group_id in number,
612 p_effective_date in date);
613 -----------------------------------------------------------------------
614 procedure evaluate_life_events
615 (p_person_id in number default null,
616 p_business_group_id in number,
617 p_mode in varchar2,
618 p_ler_id in out nocopy number,
619 -- PB : 5422 :
620 -- p_popl_enrt_typ_cycl_id in number,
621 p_lf_evt_ocrd_dt in date,
622 p_effective_date in date,
623 p_validate in varchar2 default 'N', /* Bug 5550359 */
624 p_gsp_eval_elig_flag in varchar2 default null, /* GSP Rate Sync */
625 p_lf_evt_oper_cd in varchar2 default null); /* GSP Rate Sync */
626 -----------------------------------------------------------------------
627 procedure process_comp_objects
628 (p_person_id in number default null
629 ,p_person_action_id in number
630 ,p_object_version_number in out nocopy number
631 ,p_business_group_id in number
632 ,p_mode in varchar2
633 ,p_ler_id in number default null
634 ,p_derivable_factors in varchar2 default 'ASC'
635 ,p_cbr_tmprl_evt_flag in varchar2 default 'N'
636 ,p_person_count in out nocopy number
637 -- PB : 5422 :
638 ,p_lf_evt_ocrd_dt in date default null
639 -- ,p_popl_enrt_typ_cycl_id in number
640 ,p_effective_date in date
641 ,p_gsp_eval_elig_flag in varchar2 default null /* GSP Rate Sync */
642 ,p_lf_evt_oper_cd in varchar2 default null /* GSP Rate Sync */
643 );
644 -----------------------------------------------------------------------
645 procedure flush_global_structures;
646 -----------------------------------------------------------------------
647 procedure process_life_events
648 (p_person_id in number default null,
649 p_person_action_id in number default null,
650 p_object_version_number in out nocopy number,
651 p_business_group_id in number,
652 p_mode in varchar2,
653 p_ler_id in number default null,
654 p_person_selection_rule_id in number default null,
655 p_comp_selection_rule_id in number default null,
656 -- PB : 5422 :
660 p_person_count in out nocopy number,
657 -- p_popl_enrt_typ_cycl_id in number default null,
658 p_derivable_factors in varchar2 default 'ASC',
659 p_cbr_tmprl_evt_flag in varchar2 default 'N',
661 p_error_person_count in out nocopy number,
662 p_lf_evt_ocrd_dt in date,
663 p_effective_date in date,
664 p_validate in varchar2 default 'N', /* Bug 5550359 */
665 p_gsp_eval_elig_flag in varchar2 default null, /* GSP Rate Sync */
666 p_lf_evt_oper_cd in varchar2 default null ); /* GSP Rate Sync */
667 -----------------------------------------------------------------------
668 procedure do_multithread
669 (errbuf out nocopy varchar2,
670 retcode out nocopy number,
671 p_validate in varchar2,
672 p_benefit_action_id in number,
673 p_effective_date in varchar2,
674 p_pgm_id in number,
675 p_business_group_id in number,
676 p_pl_id in number,
677 -- PB : 5422 :
678 p_popl_enrt_typ_cycl_id in number,
679 p_no_programs in varchar2,
680 p_no_plans in varchar2,
681 p_rptg_grp_id in number,
682 p_pl_typ_id in number,
683 p_opt_id in number,
684 p_eligy_prfl_id in number,
685 p_vrbl_rt_prfl_id in number,
686 p_mode in varchar2,
687 p_person_selection_rule_id in number,
688 p_comp_selection_rule_id in number,
689 p_derivable_factors in varchar2,
690 p_thread_id in number,
691 p_lf_evt_ocrd_dt in varchar2,
692 p_cbr_tmprl_evt_flag in varchar2,
693 p_lmt_prpnip_by_org_flag in varchar2,
694 p_gsp_eval_elig_flag in varchar2 default null, /* GSP Rate Sync */
695 p_lf_evt_oper_cd in varchar2 default null ); /* GSP Rate Sync */
696 -----------------------------------------------------------------------
697 procedure cache_person_information
698 (p_person_id in number,
699 p_business_group_id in number,
700 p_effective_date in date);
701 -----------------------------------------------------------------------
702 /*procedure rebuild_heirarchy
703 (p_elig_per_elctbl_chc_id in number);*/
704 procedure rebuild_heirarchy
705 (p_pil_elctbl_chc_popl_id in number);
706 -----------------------------------------------------------------------
707 --procedure popu_epe_heir ;
708 procedure popu_pel_heir ;
709 -----------------------------------------------------------------------
710 procedure process_recalculate
711 (errbuf out nocopy varchar2,
712 retcode out nocopy number,
713 p_benefit_action_id in number default null,
714 p_effective_date in varchar2,
715 p_mode in varchar2,
716 p_derivable_factors in varchar2 default 'ASC',
717 p_validate in varchar2 default 'N',
718 p_person_id in number default null,
719 p_person_type_id in number default null,
720 p_pgm_id in number default null,
721 p_business_group_id in number,
722 p_pl_id in number default null,
723 p_popl_enrt_typ_cycl_id in number default null,
724 p_lf_evt_ocrd_dt in varchar2 default null,
725 p_no_programs in varchar2 default 'N',
726 p_no_plans in varchar2 default 'N',
727 p_comp_selection_rule_id in number default null,
728 p_person_selection_rule_id in number default null,
729 p_ler_id in number default null,
730 p_organization_id in number default null,
731 p_benfts_grp_id in number default null,
732 p_location_id in number default null,
733 p_pstl_zip_rng_id in number default null,
734 p_rptg_grp_id in number default null,
735 p_pl_typ_id in number default null,
736 p_opt_id in number default null,
737 p_eligy_prfl_id in number default null,
738 p_vrbl_rt_prfl_id in number default null,
739 p_legal_entity_id in number default null,
740 p_payroll_id in number default null,
741 p_commit_data in varchar2 default 'Y',
742 p_audit_log_flag in varchar2 default 'N',
743 p_lmt_prpnip_by_org_flag in varchar2 default 'N',
744 p_cbr_tmprl_evt_flag in varchar2 default 'N');
745 -----------------------------------------------------------------------
746 procedure init_bft_statistics
747 (p_business_group_id in number
748 );
749 -----------------------------------------------------------------------
750 procedure write_bft_statistics
751 (p_business_group_id in number
752 ,p_benefit_action_id in number
753 );
754 -----------------------------------------------------------------------
755 --
756 -- ABSENCES wrapper header for benmngle process
757 --
758 procedure abse_process
759 (errbuf out nocopy varchar2
760 ,retcode out nocopy number
761 ,p_benefit_action_id in number default null
762 ,p_effective_date in varchar2
763 ,p_mode in varchar2 default 'M'
764 ,p_derivable_factors in varchar2 default 'ASC'
765 ,p_validate in varchar2 default 'N'
766 ,p_person_id in number default null
767 ,p_pgm_id in number default null
768 ,p_business_group_id in number
769 ,p_pl_id in number default null
770 ,p_popl_enrt_typ_cycl_id in number default null
771 ,p_lf_evt_ocrd_dt in varchar2 default null
772 ,p_person_type_id in number default null
773 ,p_no_programs in varchar2 default 'N'
774 ,p_no_plans in varchar2 default 'N'
775 ,p_comp_selection_rule_id in number default null
776 ,p_person_selection_rule_id in number default null
777 ,p_ler_id in number default null
778 ,p_organization_id in number default null
779 ,p_benfts_grp_id in number default null
780 ,p_location_id in number default null
781 ,p_pstl_zip_rng_id in number default null
782 ,p_rptg_grp_id in number default null
783 ,p_pl_typ_id in number default null
784 ,p_opt_id in number default null
785 ,p_eligy_prfl_id in number default null
786 ,p_vrbl_rt_prfl_id in number default null
787 ,p_legal_entity_id in number default null
788 ,p_payroll_id in number default null
789 ,p_commit_data in varchar2 default 'Y'
790 ,p_audit_log_flag in varchar2 default 'N'
791 ,p_lmt_prpnip_by_org_flag in varchar2 default 'N'
792 ,p_abs_historical_mode in varchar2 default 'N'
793 ,p_cbr_tmprl_evt_flag in varchar2 default 'N'
794 );
795 --
796 -----------------------------------------------------------------------
797 --
798 -- iRecruitment wrapper header for benmngle process
799 --
800 procedure irec_process
801 (errbuf out nocopy varchar2,
802 retcode out nocopy number,
803 p_effective_date in varchar2,
804 p_mode in varchar2 default 'I',
805 p_derivable_factors in varchar2 default 'ASC',
806 p_validate in varchar2 default 'N',
807 p_person_id in number default null,
808 p_pgm_id in number default null,
809 p_business_group_id in number,
810 p_pl_id in number default null,
811 p_popl_enrt_typ_cycl_id in number default null,
812 p_lf_evt_ocrd_dt in varchar2 default null,
813 p_person_type_id in number default null,
814 p_no_programs in varchar2 default 'N',
815 p_no_plans in varchar2 default 'N',
816 p_comp_selection_rule_id in number default null,
817 p_person_selection_rule_id in number default null,
818 p_ler_id in number default null,
819 p_organization_id in number default null,
820 p_benfts_grp_id in number default null,
821 p_location_id in number default null,
822 p_pstl_zip_rng_id in number default null,
823 p_rptg_grp_id in number default null,
824 p_pl_typ_id in number default null,
825 p_opt_id in number default null,
826 p_eligy_prfl_id in number default null,
827 p_vrbl_rt_prfl_id in number default null,
828 p_legal_entity_id in number default null,
829 p_payroll_id in number default null,
830 p_commit_data in varchar2 default 'Y',
831 p_audit_log_flag in varchar2 default 'N',
832 p_lmt_prpnip_by_org_flag in varchar2 default 'N',
833 p_abs_historical_mode in varchar2 default 'N',
834 p_cbr_tmprl_evt_flag in varchar2 default 'N',
835 p_assignment_id in number default null,
836 p_offer_assignment_rec in per_all_assignments_f%rowtype) ; ----bug 4621751 irec2
837 --
838
839 procedure Personnel_action_process
840 (errbuf out nocopy varchar2,
841 retcode out nocopy number,
842 p_benefit_action_id in number default null,
843 p_effective_date in varchar2,
844 p_mode in varchar2,
845 p_derivable_factors in varchar2 default 'ASC',
846 p_validate in varchar2 default 'N',
847 p_person_id in number default null,
848 p_person_type_id in number default null,
849 p_pgm_id in number default null,
850 p_business_group_id in number,
851 p_pl_id in number default null,
852 p_popl_enrt_typ_cycl_id in number default null,
853 p_lf_evt_ocrd_dt in varchar2 default null,
854 p_no_programs in varchar2 default 'N',
855 p_no_plans in varchar2 default 'N',
856 p_comp_selection_rule_id in number default null,
857 p_person_selection_rule_id in number default null,
858 p_ler_id in number default null,
859 p_organization_id in number default null,
860 p_benfts_grp_id in number default null,
861 p_location_id in number default null,
862 p_pstl_zip_rng_id in number default null,
863 p_rptg_grp_id in number default null,
864 p_pl_typ_id in number default null,
865 p_opt_id in number default null,
866 p_eligy_prfl_id in number default null,
867 p_vrbl_rt_prfl_id in number default null,
868 p_legal_entity_id in number default null,
869 p_payroll_id in number default null,
870 p_commit_data in varchar2 default 'Y',
871 p_audit_log_flag in varchar2 default 'N',
872 p_lmt_prpnip_by_org_flag in varchar2 default 'N',
873 p_cbr_tmprl_evt_flag in varchar2 default 'N');
874 --
875 -- GRADE/STEP : wrapper header for G mode Operation Code = Progression
876 --
877 procedure grade_step_process
878 (errbuf out nocopy varchar2
879 ,retcode out nocopy number
880 ,p_benefit_action_id in number default null
881 ,p_effective_date in varchar2
882 ,p_mode in varchar2 default 'G'
883 ,p_derivable_factors in varchar2 default 'ASC'
884 ,p_validate in varchar2 default 'N'
885 ,p_person_id in number default null
886 ,p_pgm_id in number default null
890 ,p_lf_evt_ocrd_dt in varchar2 default null
887 ,p_business_group_id in number
888 ,p_pl_id in number default null
889 ,p_popl_enrt_typ_cycl_id in number default null
891 ,p_person_type_id in number default null
892 ,p_no_programs in varchar2 default 'N'
893 ,p_no_plans in varchar2 default 'N'
894 ,p_comp_selection_rule_id in number default null
895 ,p_person_selection_rule_id in number default null
896 ,p_ler_id in number default null
897 ,p_organization_id in number default null
898 ,p_benfts_grp_id in number default null
899 ,p_location_id in number default null
900 ,p_pstl_zip_rng_id in number default null
901 ,p_rptg_grp_id in number default null
902 ,p_pl_typ_id in number default null
903 ,p_opt_id in number default null
904 ,p_eligy_prfl_id in number default null
905 ,p_vrbl_rt_prfl_id in number default null
906 ,p_legal_entity_id in number default null
907 ,p_payroll_id in number default null
908 -- GRADE/STEP : Added for grade/step benmngle
909 ,p_org_heirarchy_id in number default null
910 ,p_org_starting_node_id in number default null
911 ,p_grade_ladder_id in number default null
912 ,p_asg_events_to_all_sel_dt in varchar2 default null
913 ,p_rate_id in number default null -- pay scale
914 ,p_per_sel_dt_cd in varchar2 default null -- business rule
915 ,p_per_sel_dt_from in varchar2 default null -- business rule date from
916 ,p_per_sel_dt_to in varchar2 default null -- business rule date to
917 ,p_per_sel_freq_cd in varchar2 default null -- 2940151
918 ,p_year_from in number default null -- business rule year from
919 ,p_year_to in number default null -- business rule year to
920 ,p_cagr_id in number default null -- Coll agreement id
921 ,p_qual_type in number default null
922 ,p_qual_status in varchar2 default null
923 -- 2940151
924 ,p_id_flex_num in number default null
925 ,p_concat_segs in varchar2 default null
926 -- end 2940151
927 -- GRADE/STEP : End
928 ,p_commit_data in varchar2 default 'Y'
929 ,p_audit_log_flag in varchar2 default 'N'
930 ,p_lmt_prpnip_by_org_flag in varchar2 default 'N'
931 ,p_cbr_tmprl_evt_flag in varchar2 default 'N'
932 );
933 --
934 --
935 -- GRADE/STEP : wrapper header for G mode Operation Code = Rate Synchronization
936 -- GSP Rate Sync
937 procedure grade_step_rate_sync_process
938 (errbuf out nocopy varchar2
939 ,retcode out nocopy number
940 ,p_benefit_action_id in number default null
941 ,p_effective_date in varchar2
942 ,p_mode in varchar2 default 'G'
943 ,p_derivable_factors in varchar2 default 'ASC'
944 ,p_validate in varchar2 default 'N'
945 ,p_person_id in number default null
946 ,p_pgm_id in number default null
947 ,p_business_group_id in varchar2
948 ,p_person_type_id in number default null
949 ,p_comp_selection_rule_id in number default null
950 ,p_person_selection_rule_id in number default null
951 ,p_organization_id in number default null
952 ,p_benfts_grp_id in number default null
953 ,p_location_id in number default null
954 ,p_pstl_zip_rng_id in number default null
955 ,p_rptg_grp_id in number default null
956 ,p_legal_entity_id in number default null
957 ,p_payroll_id in number default null
958 ,p_org_heirarchy_id in number default null
959 ,p_org_starting_node_id in number default null
960 ,p_grade_ladder_id in number default null
961 ,p_rate_id in number default null -- pay scale
962 ,p_per_sel_dt_cd in varchar2 default null -- business rule
963 ,p_per_sel_dt_from in varchar2 default null -- business rule date from
964 ,p_per_sel_dt_to in varchar2 default null -- business rule date to
965 ,p_per_sel_freq_cd in varchar2 default null -- 2940151
966 ,p_year_from in number default null -- business rule year from
967 ,p_year_to in number default null -- business rule year to
968 ,p_cagr_id in number default null -- Coll agreement id
969 ,p_qual_type in number default null
970 ,p_qual_status in varchar2 default null
971 ,p_id_flex_num in number default null
972 ,p_concat_segs in varchar2 default null
973 ,p_commit_data in varchar2 default 'Y'
974 ,p_gsp_eval_elig_flag in varchar2 default 'N' -- Evaluate Eligibility
975 ,p_audit_log_flag in varchar2 default 'N'
976 ,p_lmt_prpnip_by_org_flag in varchar2 default 'N'
977 );
978 end ben_manage_life_events;
[Home] [Help]