1 PACKAGE pqp_gb_pension_scheme_template
2 /* $Header: pqpgbped.pkh 120.1 2006/03/28 10:09:34 anshghos noship $ */
3 AS
4
5
6 -- Global Constants
7
8 g_template_leg_code VARCHAR2 (30) := 'GB';
9 g_template_name pay_element_templates.template_name%TYPE
10 := 'GB Pensions';
11
12
13 ------------------------------------------------------------------------
14 FUNCTION create_user_template (
15 p_pension_scheme_name IN VARCHAR2
16 ,p_pension_year_start_dt IN DATE
17 ,p_pension_category IN VARCHAR2
18 ,p_pension_provider_id IN NUMBER
19 ,p_pension_type_id IN NUMBER
20 ,p_emp_deduction_method IN VARCHAR2
21 ,p_ele_base_name IN VARCHAR2
22 ,p_effective_start_date IN DATE
23 ,p_ele_reporting_name IN VARCHAR2
24 ,p_ele_classification_id IN NUMBER
25 ,p_business_group_id IN NUMBER
26 ,p_eer_deduction_method IN VARCHAR2 DEFAULT NULL
27 ,p_scon_number IN VARCHAR2 DEFAULT NULL
28 ,p_econ_number IN VARCHAR2 DEFAULT NULL
29 ,p_additional_contribution IN VARCHAR2 DEFAULT NULL
30 ,p_added_years IN VARCHAR2 DEFAULT NULL
31 ,p_family_widower IN VARCHAR2 DEFAULT NULL
32 ,p_fwc_added_years IN VARCHAR2 DEFAULT NULL
33 ,p_scheme_reference_no IN VARCHAR2 DEFAULT NULL
34 ,p_employer_reference_no IN VARCHAR2 DEFAULT NULL
35 ,p_associated_ocp_ele_id IN NUMBER DEFAULT NULL
36 ,p_ele_description IN VARCHAR2 DEFAULT NULL
37 ,p_pension_scheme_type IN VARCHAR2 DEFAULT NULL
38 ,p_pensionable_sal_bal_id IN NUMBER DEFAULT NULL
39 ,p_third_party_only_flag IN VARCHAR2 DEFAULT NULL
40 ,p_iterative_processing IN VARCHAR2 DEFAULT 'N'
41 ,p_arrearage_allowed IN VARCHAR2 DEFAULT 'N'
42 ,p_partial_deduction IN VARCHAR2 DEFAULT 'N'
43 ,p_termination_rule IN VARCHAR2 DEFAULT 'L'
44 ,p_standard_link IN VARCHAR2 DEFAULT 'N'
45 )
46 RETURN NUMBER;
47
48 FUNCTION create_user_template_swi (
49 p_pension_scheme_name IN VARCHAR2
50 ,p_pension_year_start_dt IN DATE
51 ,p_pension_category IN VARCHAR2
52 ,p_pension_provider_id IN NUMBER
53 ,p_pension_type_id IN NUMBER
54 ,p_emp_deduction_method IN VARCHAR2
55 ,p_ele_base_name IN VARCHAR2
56 ,p_effective_start_date IN DATE
57 ,p_ele_reporting_name IN VARCHAR2
58 ,p_ele_classification_id IN NUMBER
59 ,p_business_group_id IN NUMBER
60 ,p_eer_deduction_method IN VARCHAR2 DEFAULT NULL
61 ,p_scon_number IN VARCHAR2 DEFAULT NULL
62 ,p_econ_number IN VARCHAR2 DEFAULT NULL
63 ,p_additional_contribution IN VARCHAR2 DEFAULT NULL
64 ,p_added_years IN VARCHAR2 DEFAULT NULL
65 ,p_family_widower IN VARCHAR2 DEFAULT NULL
66 ,p_fwc_added_years IN VARCHAR2 DEFAULT NULL
67 ,p_scheme_reference_no IN VARCHAR2 DEFAULT NULL
68 ,p_employer_reference_no IN VARCHAR2 DEFAULT NULL
69 ,p_associated_ocp_ele_id IN NUMBER DEFAULT NULL
70 ,p_ele_description IN VARCHAR2 DEFAULT NULL
71 ,p_pension_scheme_type IN VARCHAR2 DEFAULT NULL
72 ,p_pensionable_sal_bal_id IN NUMBER DEFAULT NULL
73 ,p_third_party_only_flag IN VARCHAR2 DEFAULT NULL
74 ,p_iterative_processing IN VARCHAR2 DEFAULT 'N'
75 ,p_arrearage_allowed IN VARCHAR2 DEFAULT 'N'
76 ,p_partial_deduction IN VARCHAR2 DEFAULT 'N'
77 ,p_termination_rule IN VARCHAR2 DEFAULT 'L'
78 ,p_standard_link IN VARCHAR2 DEFAULT 'N'
79 )
80 RETURN NUMBER;
81
82
83 --
84 PROCEDURE delete_user_template (
85 p_business_group_id IN NUMBER
86 ,p_ele_base_name IN VARCHAR2
87 ,p_element_type_id IN NUMBER
88 ,p_effective_date IN DATE
89 );
90
91
92 --
93
94 PROCEDURE delete_user_template_swi (
95 p_business_group_id IN NUMBER
96 ,p_ele_base_name IN VARCHAR2
97 ,p_element_type_id IN NUMBER
98 ,p_effective_date IN DATE
99 );
100 --
101
102 END pqp_gb_pension_scheme_template;