1 Package ben_eval_comm_ler_elig_profl AUTHID CURRENT_USER as
2 /* $Header: beeligcl.pkh 120.4.12020000.1 2012/07/24 07:48:13 usaraswa noship $ */
3
4 procedure create_eligibility_object
5 (p_eligibility_profile_id in number,
6 p_mndtry_flag in varchar2,
7 p_TABLE_NAME in varchar2,
8 p_COLUMN_NAME in varchar2,
9 p_col_value in number,
10 p_effective_start_date out nocopy date,
11 p_effective_end_date out nocopy date,
12 p_business_group_id in number,
13 p_effective_date in date,
14 p_object_version_number out nocopy number ,
15 p_elig_obj_elig_prfl_id out nocopy number,
16 p_elig_obj_id out nocopy number,
17 p_result out nocopy varchar2);
18
19 procedure delete_eligibility_object(
20 p_validate in boolean default false,
21 p_col_value in varchar2,
22 p_TABLE_NAME varchar2,
23 p_COLUMN_NAME varchar2,
24 p_effective_start_date out nocopy date,
25 p_effective_end_date out nocopy date,
26 p_eligibility_profile_id in varchar2,
27 p_effective_date in date,
28 p_datetrack_mode in varchar2,
29 p_elig_obj_elig_prf_id in number,
30 p_elig_obj_id in number,
31 p_result out nocopy varchar);
32
33 procedure update_eligibility_object
34 (p_validate in boolean default false
35 ,p_elig_obj_elig_prfl_id in number
36 ,p_effective_start_date out nocopy date
37 ,p_effective_end_date out nocopy date
38 ,p_elig_obj_id in number default hr_api.g_number
39 ,p_elig_prfl_id in number default hr_api.g_number
40 ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
41 ,p_object_version_number in out nocopy number
42 ,p_effective_date in date
43 ,p_datetrack_mode in varchar2
44 );
45
46
47 procedure check_eligible
48 (p_person_id in number
49 ,p_effective_date in date
50 ,p_lf_evt_ocrd_dt in date default null
51 ,p_business_group_id in number
52 ,p_per_in_ler_id in number default null
53 ,p_ler_id in number default null
54 ,p_source in varchar2
55 ,p_col_value in number
56 ,p_elig_flag out nocopy varchar2
57 );
58 --
59 end ben_eval_comm_ler_elig_profl;
[Home] [Help]