1 package pqp_gb_pensions_template AUTHID CURRENT_USER as
2 /* $Header: pqgbpatp.pkh 120.1 2005/05/30 00:12:13 rvishwan noship $ */
3
4
5 -- Legislation Subgroup Code for all template elements.
6 g_template_leg_code VARCHAR2(30) := 'GB';
7 g_template_leg_subgroup VARCHAR2(30);
8 ------------------------------------------------------------------------
9 FUNCTION create_user_template
10 (p_ele_name in varchar2
11 ,p_ele_reporting_name in varchar2
12 ,p_ele_description in varchar2 default NULL
13 ,p_ele_classification in varchar2
14 ,p_sch_type in varchar2
15 ,p_emp_cont_method in varchar2
16 ,p_emp_contribution in number default NULL
17 ,p_adl_contribution in varchar2
18 ,p_eer_contribution in varchar2
19 ,p_eer_type in varchar2
20 ,p_eer_rate in number default NULL
21 ,p_ept_contribution in varchar2
22 ,p_byb_added_years in varchar2
23 ,p_fmwd_benefit in varchar2
24 ,p_avc_percentage in varchar2
25 ,p_avc_per_provider in varchar2
26 ,p_avc_fixed_rate in varchar2
27 ,p_avc_fxdrt_provider in varchar2
28 ,p_life_assurance in varchar2
29 ,p_life_asr_provider in varchar2
30 ,p_ele_eff_start_date in date default NULL
31 ,p_ele_eff_end_date in date default NULL
32 ,p_bg_id in number
33 )
34 RETURN NUMBER ;
35 --
36 PROCEDURE delete_user_template
37 (p_business_group_id in number
38 ,p_ele_type_id in number
39 ,p_ele_name in varchar2
40 ,p_effective_date in date
41 );
42
43 --
44 END pqp_gb_pensions_template ;