1 PACKAGE ben_determine_eligibility AUTHID CURRENT_USER AS
2 /* $Header: bendetel.pkh 120.1.12010000.1 2008/07/29 12:09:55 appldev ship $ */
3 --
4 g_eligible exception;
5 g_criteria_failed exception;
6 g_skip_profile exception;
7 g_not_eligible exception;
8 g_inelg_rsn_cd varchar2(30);
9 --
10 g_rec benutils.g_batch_elig_rec;
11 --
12 g_debug boolean := hr_utility.debug_enabled;
13 --
14 type g_elig_dpnt_table is table of per_contact_relationships%rowtype
15 index by binary_integer;
16 --
17 g_elig_dpnt_rec g_elig_dpnt_table;
18 --
19 procedure determine_elig_prfls
20 (p_comp_obj_tree_row in out NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
21 ,p_par_elig_state in out NOCOPY ben_comp_obj_filter.g_par_elig_state_rec
22 ,p_per_row in out NOCOPY per_all_people_f%rowtype
23 ,p_empasg_row in out NOCOPY per_all_assignments_f%rowtype
24 ,p_benasg_row in out NOCOPY per_all_assignments_f%rowtype
25 ,p_appasg_row in out NOCOPY ben_person_object.g_cache_ass_table
26 ,p_empasgast_row in out NOCOPY per_assignment_status_types%rowtype
27 ,p_benasgast_row in out NOCOPY per_assignment_status_types%rowtype
28 ,p_pil_row in out NOCOPY ben_per_in_ler%rowtype
29 ,p_person_id in number
30 ,p_business_group_id in number
31 ,p_effective_date in date
32 ,p_lf_evt_ocrd_dt in date
33 ,p_pl_id in number
34 ,p_pgm_id in number
35 ,p_oipl_id in number
36 ,p_plip_id in number
37 ,p_ptip_id in number
38 ,p_ler_id in number
39 ,p_comp_rec in out NOCOPY ben_derive_part_and_rate_facts.g_cache_structure
40 ,p_oiplip_rec in out NOCOPY ben_derive_part_and_rate_facts.g_cache_structure
41 --
42 ,p_eligible out nocopy boolean
43 ,p_not_eligible out nocopy boolean
44 --
45 ,p_newly_elig out nocopy boolean
46 ,p_newly_inelig out nocopy boolean
47 ,p_first_elig out nocopy boolean
48 ,p_first_inelig out nocopy boolean
49 ,p_still_elig out nocopy boolean
50 ,p_still_inelig out nocopy boolean
51 );
52 ------------------------------------------------------------------------
53 END;
[Home] [Help]