1 PACKAGE per_hu_pension_objects AUTHID CURRENT_USER AS
2 /* $Header: pehupqpp.pkh 115.3 2004/02/23 05:24:42 rajkalya noship $ */
3 --------------------------------------------------------------------------------
4 -- create_pension_objects
5 --------------------------------------------------------------------------------
6 --
7 -- Description:
8 -- This procedure is the self-service wrapper procedure to the following API:
9 --
10 -- pay_element_extra_info_api.create_element_extra_info
11 --
12 --
13 -- Pre-requisites
14 -- All 'IN' parameters to this procedure have been appropriately derived.
15 --
16 -- Post Success:
17 -- p_return_status will return value indicating success.
18 --
19 -- Post Failure:
20 -- p_return_status will return value indication failure.
21 --
22 -- Access Status:
23 -- Internal Development use only.
24 --
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_pension_objects_swi(p_validate IN NUMBER DEFAULT hr_api.g_false_num
27 ,p_element_name IN VARCHAR2
28 ,p_reporting_name IN VARCHAR2
29 ,p_element_description IN VARCHAR2
30 ,p_business_group_id IN NUMBER
31 ,p_effective_start_date IN DATE
32 ,p_standard_link_flag IN VARCHAR2
33 ,p_post_termination_rule IN VARCHAR2
34 ,p_third_party_pay_only IN VARCHAR2
35 ,p_contribution_type IN VARCHAR2
36 ,p_pension_scheme_name IN VARCHAR2
37 ,p_pension_provider IN VARCHAR2
38 ,p_pension_type IN VARCHAR2
39 ,p_pension_category IN VARCHAR2
40 ,p_pension_year_start_date IN VARCHAR2
41 ,p_employee_deduction_method IN VARCHAR2
42 ,p_employer_deduction_method IN VARCHAR2
43 ,p_scheme_number IN VARCHAR2
44 ,p_employee_supplement IN VARCHAR2
45 ,p_employer_supplement IN VARCHAR2
46 ,p_employer_reference_number IN VARCHAR2
47 ,p_scheme_prefix IN VARCHAR2
48 ,p_element_type_id OUT NOCOPY NUMBER
49 ,p_return_status OUT NOCOPY VARCHAR2);
50
51
52
53
54 --
55 PROCEDURE create_pension_objects(p_validate boolean default false
56 ,p_element_name IN VARCHAR2
57 ,p_reporting_name IN VARCHAR2
58 ,p_element_description IN VARCHAR2
59 ,p_business_group_id IN NUMBER
60 ,p_effective_start_date IN DATE
61 ,p_standard_link_flag IN VARCHAR2
62 ,p_post_termination_rule IN VARCHAR2
63 ,p_third_party_pay_only IN VARCHAR2
64 ,p_contribution_type IN VARCHAR2
65 ,p_pension_scheme_name IN VARCHAR2
66 ,p_pension_provider IN VARCHAR2
67 ,p_pension_type IN VARCHAR2
68 ,p_pension_category IN VARCHAR2
69 ,p_pension_year_start_date IN VARCHAR2
70 ,p_employee_deduction_method IN VARCHAR2
71 ,p_employer_deduction_method IN VARCHAR2
72 ,p_scheme_number IN VARCHAR2
73 ,p_employee_supplement IN VARCHAR2
74 ,p_employer_supplement IN VARCHAR2
75 ,p_employer_reference_number IN VARCHAR2
76 ,p_scheme_prefix IN VARCHAR2
77 ,p_element_type_id OUT NOCOPY NUMBER);
78
79 -------------------------------------------------------------------------------
80 -- delete_element_extra_info
81 ---------------------------------------------------------------------------------
82 --
83 -- Description:
84 -- This procedure is the self-service wrapper procedure to the following API:
85 --
86 -- pay_element_extra_info_api.delete_element_extra_info
87 --
88 -- Pre-requisites
89 -- All 'IN' parameters to this procedure have been appropriately derived.
90 --
91 -- Post Success:
92 -- p_return_status will return value indicating success.
93 --
94 -- Post Failure:
95 -- p_return_status will return value indication failure.
96 --
97 -- Access Status:
98 -- Internal Development use only.
99 --
100 -- ----------------------------------------------------------------------------
101
102 PROCEDURE delete_pension_objects_swi
103 (p_validate IN NUMBER DEFAULT hr_api.g_false_num
104 ,p_element_type_id IN NUMBER
105 ,p_effective_date IN DATE
106 ,p_object_version_number IN NUMBER
107 ,p_return_status OUT NOCOPY VARCHAR2
108 );
109
110 --
111 PROCEDURE delete_pension_objects(p_validate boolean default false
112 ,p_element_type_id NUMBER
113 ,p_effective_date DATE
114 ,p_object_version_number NUMBER
115 );
116
117 END per_hu_pension_objects;