1 PACKAGE PAY_NL_LIFE_SAVINGS_TEMPLATE AS
2 /* $Header: pynllssd.pkh 120.1 2007/04/11 04:43:29 rlingama noship $ */
3
4 -- Legislation Subgroup Code for all core objects
5
6 g_template_leg_code VARCHAR2(30):= 'NL';
7 g_template_leg_subgroup VARCHAR2(30);
8
9 TYPE g_creator_rec IS RECORD(
10 type pay_retro_component_usages.creator_type%TYPE,
11 name varchar2(100),
12 id number);
13
14 TYPE g_component_rec IS RECORD(
15 name pay_retro_components.component_name%TYPE,
16 id pay_retro_components.retro_component_id%TYPE,
17 type pay_retro_components.retro_type%TYPE,
18 start_time_def_name pay_time_definitions.definition_name%TYPE,
19 end_time_def_name pay_time_definitions.definition_name%TYPE,
20 time_span_id pay_time_spans.time_span_id%TYPE);
21
22 TYPE g_component_tab is table of g_component_rec INDEX BY BINARY_INTEGER;
23
24 TYPE g_retro_ele_rec IS RECORD(
25 name pay_element_types_f.element_name%TYPE,
26 id pay_element_types_f.element_type_id%TYPE);
27
28 g_creator g_creator_rec;
29 g_component g_component_tab;
30 g_retro_ele g_retro_ele_rec;
31 g_legislation_code CONSTANT VARCHAR2(2):= 'NL';
32 g_retro_def_name CONSTANT VARCHAR2(30) := 'Standard Retropay';
33
34
35 -- ---------------------------------------------------------------------
36 -- |--------------------< Create_User_Template >------------------------|
37 -- ---------------------------------------------------------------------
38 FUNCTION Create_User_Template
39 (p_pension_category IN VARCHAR2
40 ,p_pension_provider_id IN NUMBER
41 ,p_pension_type_id IN NUMBER
42 ,p_scheme_prefix IN VARCHAR2
43 ,p_reporting_name IN VARCHAR2
44 ,p_scheme_description IN VARCHAR2
45 ,p_termination_rule IN VARCHAR2
46 ,p_er_component IN VARCHAR2
47 ,p_arrearage_flag IN VARCHAR2
48 ,p_ee_deduction_method IN VARCHAR2
49 ,p_er_deduction_method IN VARCHAR2
50 ,p_saving_scheme_type 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 -- |--------------------< Create_User_Template_Swi >--------------------|
63 -- ---------------------------------------------------------------------
64
65 FUNCTION Create_User_Template_Swi
66 ( p_pension_category IN VARCHAR2
67 ,p_pension_provider_id IN NUMBER
68 ,p_pension_type_id IN NUMBER
69 ,p_scheme_prefix IN VARCHAR2
70 ,p_reporting_name IN VARCHAR2
71 ,p_scheme_description IN VARCHAR2
72 ,p_termination_rule IN VARCHAR2
73 ,p_er_component IN VARCHAR2
74 ,p_arrearage_flag IN VARCHAR2
75 ,p_ee_deduction_method IN VARCHAR2
76 ,p_er_deduction_method IN VARCHAR2
77 ,p_saving_scheme_type IN VARCHAR2
78 ,p_zvw_std_tax_chk IN VARCHAR2
79 ,p_zvw_spl_tax_chk IN VARCHAR2
80 ,p_standard_link IN VARCHAR2
81 ,p_effective_start_date IN DATE DEFAULT NULL
82 ,p_effective_end_date IN DATE DEFAULT NULL
83 ,p_security_group_id IN NUMBER DEFAULT NULL
84 ,p_business_group_id IN NUMBER
85 )
86 RETURN NUMBER;
87
88 -- ---------------------------------------------------------------------
89 -- |------------------< Delete_User_Template >--------------------------|
90 -- ---------------------------------------------------------------------
91
92 PROCEDURE Delete_User_Template
93 (p_savings_plan_id in Number
94 ,p_business_group_id in Number
95 ,p_savings_dedn_ele_name in Varchar2
96 ,p_savings_dedn_ele_type_id in Number
97 ,p_security_group_id in Number
98 ,p_effective_date in Date
99 );
100
101 -- ---------------------------------------------------------------------
102 -- |------------------< Delete_User_Template_Swi >----------------------|
103 -- ---------------------------------------------------------------------
104
105 PROCEDURE Delete_User_Template_Swi
106 (p_savings_plan_id in Number
107 ,p_business_group_id in Number
108 ,p_savings_dedn_ele_name in Varchar2
109 ,p_savings_dedn_ele_type_id in Number
110 ,p_security_group_id in Number
111 ,p_effective_date in Date
112 );
113
114 END pay_nl_life_savings_template;