1 PACKAGE PQP_NL_PGGM_TEMPLATE AS
2 /* $Header: pqpggped.pkh 120.0.12000000.1 2007/01/16 04:19:28 appldev 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_standard_link IN VARCHAR2
47 ,p_effective_start_date IN DATE DEFAULT NULL
48 ,p_effective_end_date IN DATE DEFAULT NULL
49 ,p_security_group_id IN NUMBER DEFAULT NULL
50 ,p_business_group_id IN NUMBER
51 ,p_basis_rounding IN VARCHAR2
52 ,p_contrib_rounding IN VARCHAR2
53 ,p_link_dedn_elements IN VARCHAR2
54 ,p_link_retro_elements IN VARCHAR2
55 )
56 RETURN NUMBER ;
57
58 -- ---------------------------------------------------------------------
59 -- |--------------------< Create_User_Template_Swi >--------------------|
60 -- ---------------------------------------------------------------------
61
62 FUNCTION Create_User_Template_Swi
63 (p_pension_category IN VARCHAR2
64 ,p_pension_provider_id IN NUMBER
65 ,p_pension_type_id IN NUMBER
66 ,p_scheme_prefix IN VARCHAR2
67 ,p_reporting_name IN VARCHAR2
68 ,p_scheme_description IN VARCHAR2
69 ,p_termination_rule IN VARCHAR2
70 ,p_standard_link IN VARCHAR2
71 ,p_effective_start_date IN DATE DEFAULT NULL
72 ,p_effective_end_date IN DATE DEFAULT NULL
73 ,p_security_group_id IN NUMBER DEFAULT NULL
74 ,p_business_group_id IN NUMBER
75 ,p_basis_rounding IN VARCHAR2
76 ,p_contrib_rounding IN VARCHAR2
77 ,p_link_dedn_elements IN VARCHAR2
78 ,p_link_retro_elements IN VARCHAR2
79 )
80 RETURN NUMBER;
81
82 -- ---------------------------------------------------------------------
83 -- |------------------< Delete_User_Template >--------------------------|
84 -- ---------------------------------------------------------------------
85
86 PROCEDURE Delete_User_Template
87 (p_business_group_id IN NUMBER
88 ,p_pension_dedn_ele_name IN VARCHAR2
89 ,p_pension_dedn_ele_type_id IN NUMBER
90 ,p_security_group_id IN NUMBER
91 ,p_effective_date IN DATE
92 );
93
94 -- ---------------------------------------------------------------------
95 -- |------------------< Delete_User_Template_Swi >----------------------|
96 -- ---------------------------------------------------------------------
97
98 PROCEDURE Delete_User_Template_Swi
99 (p_business_group_id IN NUMBER
100 ,p_pension_dedn_ele_name IN VARCHAR2
101 ,p_pension_dedn_ele_type_id IN NUMBER
102 ,p_security_group_id IN NUMBER
103 ,p_effective_date IN DATE
104 );
105
106 END pqp_nl_pggm_template;