[Home] [Help]
PACKAGE: APPS.PQP_PENSION_PROVIDERS
Source
1 package pqp_pension_providers AUTHID CURRENT_USER as
2 /* $Header: pqppenpr.pkh 120.2 2005/06/08 09:28:28 sashriva noship $ */
3
4 --
5 -- ----------------------------------------------------------------------------
6 -- |---------------------< create_pension_provider_swi >-----------------------|
7 -- ----------------------------------------------------------------------------
8 --
9
10 procedure create_pension_provider_swi
11 (p_pension_provider_name in varchar2
12 ,p_business_group_id in number
13 ,p_legislation_code in varchar2
14 ,p_security_profile_id in number
15 ,p_effective_start_date in date
16 ,p_internal_external_flag in varchar2
17 ,p_type in varchar2
18 ,p_location_id in out nocopy number
19 ,p_create_new_location_flag in varchar2
20 ,p_org_information_context in varchar2
21 ,p_org_classification in varchar2
22 ,p_organization_id out nocopy number
23 ,p_org_information_id out nocopy number
24 ,p_location_code in varchar2
25 ,p_language_code in varchar2
26 ,p_country_code in varchar2
27 ,p_address_line_1 in varchar2 default null
28 ,p_address_line_2 in varchar2 default null
29 ,p_address_line_3 in varchar2 default null
30 ,p_postal_code in varchar2 default null
31 ,p_region_1 in varchar2 default null
32 ,p_region_2 in varchar2 default null
33 ,p_region_3 in varchar2 default null
34 ,p_style in varchar2 default null
35 ,p_tax_name in varchar2 default null
36 ,p_town_or_city in varchar2 default null
37 ,p_location_extra_info_id out nocopy number
38 ,p_information_type in varchar2 default null
39 ,p_lei_information_category in varchar2 default null
40 ,p_lei_information1 in varchar2 default null
41 ,p_lei_information2 in varchar2 default null
42 ,p_lei_information3 in varchar2 default null
43 ,p_lei_information4 in varchar2 default null
44 ,p_lei_information5 in varchar2 default null
45 ,p_lei_information6 in varchar2 default null
46 ,p_lei_information7 in varchar2 default null
47 ,p_lei_information8 in varchar2 default null
48 ,p_lei_information9 in varchar2 default null
49 ,p_lei_information10 in varchar2 default null
50 ,p_lei_information11 in varchar2 default null
51 ,p_lei_information12 in varchar2 default null
52 ,p_lei_information13 in varchar2 default null
53 ,p_lei_information14 in varchar2 default null
54 ,p_lei_information15 in varchar2 default null
55 ,p_lei_information16 in varchar2 default null
56 ,p_lei_information17 in varchar2 default null
57 ,p_lei_information18 in varchar2 default null
58 ,p_lei_information19 in varchar2 default null
59 ,p_lei_information20 in varchar2 default null
60 ,p_lei_information21 in varchar2 default null
61 ,p_lei_information22 in varchar2 default null
62 ,p_lei_information23 in varchar2 default null
63 ,p_lei_information24 in varchar2 default null
64 ,p_lei_information25 in varchar2 default null
65 ,p_lei_information26 in varchar2 default null
66 ,p_lei_information27 in varchar2 default null
67 ,p_lei_information28 in varchar2 default null
68 ,p_lei_information29 in varchar2 default null
69 ,p_lei_information30 in varchar2 default null
70
71 );
72
73 --
74 -- ----------------------------------------------------------------------------
75 -- |---------------------< update_pension_provider_swi >-----------------------|
76 -- ----------------------------------------------------------------------------
77 --
78 Procedure update_pension_provider_swi
79 (p_organization_id in number
80 ,p_business_group_id in number
81 ,p_provider_name in varchar2
82 ,p_location_id in number
83 ,p_date_from in date
84 ,p_date_to in date );
85
86
87 -- ----------------------------------------------------------------------------
88 -- |-------------------< add_pension_types_swi >-------------------------------|
89 -- ----------------------------------------------------------------------------
90
91 procedure add_pension_types_swi
92 (p_organization_id in number
93 ,p_business_group_id in number
94 ,p_legislation_code in varchar2
95 ,p_org_information_context in varchar2
96 ,p_pension_type_id in number
97 ,p_org_information_id out nocopy number
98 );
99
100 -- ----------------------------------------------------------------------------
101 -- |-------------------< create_third_party_paymnt_swi >----------------------|
102 -- ----------------------------------------------------------------------------
103
104 procedure create_third_party_paymnt_swi
105 (p_organization_id in number
106 ,p_org_information_id out nocopy number
107 );
108
109 --
110 -- ----------------------------------------------------------------------------
111 -- |-------------------< assign_pension_type_to_org_swi >----------------------|
112 -- ----------------------------------------------------------------------------
113 --
114 Procedure assign_pension_type_to_org_swi
115 ( p_transaction_mode in varchar2
116 ,p_organization_id in number
117 ,p_business_group_id in number
118 ,p_legislation_code in varchar2
119 ,p_pension_provider_id in number
120 ,p_pension_type_id in number
121 ,p_registration_number in varchar2
122 ,p_start_date date
123 ,p_end_date date
124 ,p_org_information_id in out nocopy number
125 );
126
127 --
128 -- ----------------------------------------------------------------------------
129 -- |-------------------< delete_pension_types_swi >----------------------------|
130 -- ----------------------------------------------------------------------------
131 --
132 Procedure delete_pension_types_swi
133 (p_organization_id in number
134 ,p_business_group_id in number
135 ,p_legislation_code in varchar2
136 ,p_pension_type_id in number
137 ,p_org_information_id in number
138 );
139
140 --
141 -- ----------------------------------------------------------------------------
142 -- |-------------------< delete_third_party_paymnt_swi >-----------------------|
143 -- ----------------------------------------------------------------------------
144 --
145 Procedure delete_third_party_paymnt_swi
146 (p_organization_id in number
147 );
148
149 --
150 -- ----------------------------------------------------------------------------
151 -- |---------------------< delete_pension_provider_swi>------------------------|
152 -- ----------------------------------------------------------------------------
153 --
154 procedure delete_pension_provider_swi
155 (p_organization_id in number
156 ,p_effective_date in date
157 ,p_business_group_id in number);
158
159 --
160 -- ----------------------------------------------------------------------------
161 -- |-------------------< delete_assigned_providers_swi>------------------------|
162 -- ----------------------------------------------------------------------------
163 --
164 procedure delete_assigned_providers_swi
165 (p_organization_id in number
166 ,p_org_information_id in number);
167
168 --
169 -- ----------------------------------------------------------------------------
170 -- |-------------------< delete_assigned_providers>---------------------------|
171 -- ----------------------------------------------------------------------------
172 --
173 procedure delete_assigned_providers
174 (p_organization_id in number
175 ,p_org_information_id in number);
176
177
178 -- ----------------------------------------------------------------------------
179 -- |-------------------< add_provider_ref_number_swi >------------------------|
180 -- ----------------------------------------------------------------------------
181
182 procedure add_provider_ref_number_swi
183 (p_organization_id in number
184 ,p_business_group_id in number
185 ,p_legislation_code in varchar2
186 ,p_org_information_context in varchar2
187 ,p_provider_reference_number in varchar2
188 ,p_org_information_id out nocopy number);
189
190 end pqp_pension_providers;
191