1 Package pqp_nl_savings_template As
2 /* $Header: pqpnlsad.pkh 120.1.12000000.1 2007/01/16 04:24:44 appldev noship $ */
3
4 -- Legislation Subgroup Code for all core objects
5 g_template_leg_code VARCHAR2(30):= 'NL';
6 g_template_leg_subgroup VARCHAR2(30);
7
8 TYPE g_creator_rec IS RECORD(
9 type pay_retro_component_usages.creator_type%TYPE,
10 name varchar2(100),
11 id number);
12
13 TYPE g_component_rec IS RECORD(
14 name pay_retro_components.component_name%TYPE,
15 id pay_retro_components.retro_component_id%TYPE,
16 type pay_retro_components.retro_type%TYPE,
17 start_time_def_name pay_time_definitions.definition_name%TYPE,
18 end_time_def_name pay_time_definitions.definition_name%TYPE,
19 time_span_id pay_time_spans.time_span_id%TYPE);
20
21 TYPE g_component_tab is table of g_component_rec INDEX BY BINARY_INTEGER;
22
23 TYPE g_retro_ele_rec IS RECORD(
24 name pay_element_types_f.element_name%TYPE,
25 id pay_element_types_f.element_type_id%TYPE);
26
27 g_creator g_creator_rec;
28 g_component g_component_tab;
29 g_retro_ele g_retro_ele_rec;
30 g_legislation_code CONSTANT VARCHAR2(2):= 'NL';
31 g_retro_def_name CONSTANT VARCHAR2(30) := 'Standard Retropay';
32
33 -- ---------------------------------------------------------------------
34 -- |------------------< Create_User_Template_Swi >----------------------|
35 -- ---------------------------------------------------------------------
36 function Create_User_Template_Swi
37 (p_pension_category In Varchar2
38 ,p_eligibility_model In Varchar2
39 ,p_pension_provider_id In Number
40 ,p_pension_type_id In Number
41 ,p_pension_plan_id In Number Default Null
42 ,p_deduction_method In Varchar2
43 ,p_saving_scheme_type In Varchar2
44 ,p_arrearage_flag In Varchar2
45 ,p_partial_deductions_flag In Varchar2 Default 'N'
46 ,p_employer_component In Varchar2
47 ,p_scheme_prefix In Varchar2
48 ,p_reporting_name In Varchar2
49 ,p_scheme_description In Varchar2
50 ,p_termination_rule In Varchar2
51 ,p_zvw_std_tax_chk IN VARCHAR2
52 ,p_zvw_spl_tax_chk IN VARCHAR2
53 ,p_standard_link In Varchar2
54 ,p_effective_start_date In Date Default Null
55 ,p_effective_end_date In Date Default Null
56 ,p_security_group_id In Number Default Null
57 ,p_business_group_id In Number
58 )
59 return Number;
60
61 -- ---------------------------------------------------------------------
62 -- |--------------------< Delete_User_Template_Swi >--------------------|
63 -- ---------------------------------------------------------------------
64 procedure Delete_User_Template_Swi
65 (p_savings_plan_id In Number Default Null
66 ,p_business_group_id In Number
67 ,p_savings_dedn_ele_name In Varchar2
68 ,p_savings_dedn_ele_type_id In Number
69 ,p_security_group_id In Number
70 ,p_effective_date In Date
71 );
72
73 --
74
75 end pqp_nl_savings_template;