1 PACKAGE pqp_gb_stakeholder_template AS
2 /* $Header: pqgbstht.pkh 120.1 2005/05/30 00:12:29 rvishwan noship $ */
3
4
5
6 g_proc VARCHAR2(31) := 'pqp_gb_stakeholder_template.';
7 -- Legislation Subgroup Code for all template elements.
8 g_template_leg_code VARCHAR2(30) := 'GB';
9 g_template_leg_subgroup VARCHAR2(30);
10
11 FUNCTION create_user_template
12 (p_frm_sd_scheme_name IN VARCHAR2 -- 'Stakeholder'
13 ,p_frm_sd_contribution_method IN VARCHAR2 -- Ex Rule Eme Cntrbn
14 ,p_frm_sd_employee_contribution IN NUMBER
15 ,p_frm_be_element_name IN VARCHAR2
16 ,p_frm_be_reporting_name IN VARCHAR2
17 -- ,p_frm_be_classification -- Always 'Voluntary Deductions'
18 ,p_frm_be_description IN VARCHAR2 DEFAULT NULL
19 ,p_frm_ae_employer_contribution IN VARCHAR2 DEFAULT 'N' --Ex Rule
20 ,p_frm_ae_type IN VARCHAR2 DEFAULT NULL
21 ,p_frm_ae_rate IN NUMBER DEFAULT NULL
22 ,p_frm_ctl_effective_start_date IN DATE DEFAULT NULL
23 ,p_frm_ctl_effective_end_date IN DATE DEFAULT NULL
24 ,p_frm_ctl_business_group_id IN NUMBER
25 )
26 RETURN NUMBER ; -- Base Element Core Object ID
27 --
28 PROCEDURE delete_user_template
29 (p_frm_ctl_business_group_id IN NUMBER
30 ,p_frm_ctl_element_type_id IN NUMBER
31 ,p_frm_be_element_name IN VARCHAR2
32 ,p_frm_ctl_effective_start_date IN DATE
33 );
34
35 --
36 END pqp_gb_stakeholder_template;