1 PACKAGE PQP_NL_ABP_TEMPLATE AS
2 /* $Header: pqabpped.pkh 120.0.12000000.1 2007/01/16 03:29:29 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 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 type g_component_tab is table of g_component_rec INDEX BY BINARY_INTEGER;
21 type g_retro_ele_rec is record(
22 name pay_element_types_f.element_name%TYPE,
23 id pay_element_types_f.element_type_id%TYPE);
24 g_creator g_creator_rec;
25 g_component g_component_tab;
26 g_retro_ele g_retro_ele_rec;
27 g_legislation_code constant varchar2(2):= 'NL';
28 g_retro_def_name constant varchar2(30) := 'Standard Retropay';
29
30
31 -- ---------------------------------------------------------------------
32 -- |--------------------< Create_User_Template >------------------------|
33 -- ---------------------------------------------------------------------
34 FUNCTION Create_User_Template
35 (p_pension_category IN VARCHAR2
36 ,p_pension_provider_id IN NUMBER
37 ,p_pension_type_id IN NUMBER
38 ,p_deduction_method IN VARCHAR2
39 ,p_arrearage_flag IN VARCHAR2
40 ,p_partial_deductions_flag IN VARCHAR2 DEFAULT 'N'
41 ,p_employer_component IN VARCHAR2
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_oht_applicable IN VARCHAR2
52 ,p_absence_applicable IN VARCHAR2
53 ,p_part_time_perc_calc_choice IN VARCHAR2
54 )
55 RETURN NUMBER ;
56
57 -- ---------------------------------------------------------------------
58 -- |--------------------< Create_User_Template_Swi >--------------------|
59 -- ---------------------------------------------------------------------
60
61 FUNCTION Create_User_Template_Swi
62 (p_pension_category IN VARCHAR2
63 ,p_pension_provider_id IN NUMBER
64 ,p_pension_type_id IN NUMBER
65 ,p_deduction_method IN VARCHAR2
66 ,p_arrearage_flag IN VARCHAR2
67 ,p_partial_deductions_flag IN VARCHAR2 DEFAULT 'N'
68 ,p_employer_component IN VARCHAR2
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_standard_link IN VARCHAR2
74 ,p_effective_start_date IN DATE DEFAULT NULL
75 ,p_effective_end_date IN DATE DEFAULT NULL
76 ,p_security_group_id IN NUMBER DEFAULT NULL
77 ,p_business_group_id IN NUMBER
78 ,p_oht_applicable IN VARCHAR2
79 ,p_absence_applicable IN VARCHAR2
80 ,p_part_time_perc_calc_choice IN VARCHAR2
81 )
82 RETURN NUMBER;
83
84 -- ---------------------------------------------------------------------
85 -- |------------------< Delete_User_Template >--------------------------|
86 -- ---------------------------------------------------------------------
87
88 PROCEDURE Delete_User_Template
89 (p_business_group_id IN NUMBER
90 ,p_pension_dedn_ele_name IN VARCHAR2
91 ,p_pension_dedn_ele_type_id IN NUMBER
92 ,p_security_group_id IN NUMBER
93 ,p_effective_date IN DATE
94 );
95
96 -- ---------------------------------------------------------------------
97 -- |------------------< Delete_User_Template_Swi >----------------------|
98 -- ---------------------------------------------------------------------
99
100 PROCEDURE Delete_User_Template_Swi
101 (p_business_group_id IN NUMBER
102 ,p_pension_dedn_ele_name IN VARCHAR2
103 ,p_pension_dedn_ele_type_id IN NUMBER
104 ,p_security_group_id IN NUMBER
105 ,p_effective_date IN DATE
106 );
107
108 END pqp_nl_abp_template;