1 PACKAGE GHR_BEN_VALIDATION AUTHID CURRENT_USER AS
2 /* $Header: ghbenval.pkh 120.4 2011/10/14 07:00:04 vmididho ship $ */
3 --
4 PROCEDURE validate_create_element(
5 p_effective_date in date
6 ,p_assignment_id in number default null
7 ,p_validation_start_date in date
8 ,p_validation_end_date in date
9 ,p_element_entry_id in number
10 ,p_effective_start_date in date
11 ,p_effective_end_date in date
12 ,p_element_link_id in number default null
13 ,p_element_type_id in number default null
14 );
15
16 PROCEDURE validate_update_element(
17 p_effective_date in date
18 ,P_ASSIGNMENT_ID_O in number default null
19 ,p_validation_start_date in date
20 ,p_validation_end_date in date
21 ,p_element_entry_id in number
22 ,p_effective_start_date in date
23 ,p_effective_end_date in date
24 ,P_ELEMENT_LINK_ID_O in number default null
25 ,P_ELEMENT_TYPE_ID_O in number default null
26 );
27
28 PROCEDURE validate_benefits(
29 p_effective_date in date
30 , p_which_eit in varchar2
31 , p_pa_request_id in number default null
32 , p_first_noa_code in varchar2 default null
33 , p_noa_family_code in varchar2 default null
34 , p_passed_element in varchar2 default null
35 , p_health_plan in varchar2 default null
36 , p_enrollment_option in varchar2 default null
37 , p_date_fehb_elig in date default null
38 , p_date_temp_elig in date default null
39 , p_temps_total_cost in varchar2 default null
40 , p_pre_tax_waiver in varchar2 default null
41 , p_tsp_scd in varchar2 default null
42 , p_tsp_amount in number default null
43 , p_tsp_rate in number default null
44 , p_tsp_status in varchar2 default null
45 , p_tsp_status_date in date default null
46 , p_agency_contrib_date in date default null
47 , p_emp_contrib_date in date default null
48 , p_tenure in varchar2 default null
49 , p_retirement_plan in varchar2 default null
50 , p_fegli_elig_exp_date in date default null
51 , p_fers_elig_exp_date in date default null
52 , p_annuitant_indicator in varchar2 default null
53 , p_assignment_id in number default null
54 --Bug # 12973371 Added TSP Roth amount and rate
55 , p_tsp_roth_401k_amt in number default null
56 , p_tsp_roth_401k_rate in number default null);
57
58 PROCEDURE validate_create_personei(
59 p_person_extra_info_id number,
60 p_information_type in varchar2,
61 p_person_id in number
62 );
63
64 END GHR_BEN_VALIDATION;