DBA Data[Home] [Help]

PACKAGE: APPS.PAY_CONTRIBUTION_HISTORY_API

Source


1 Package pay_Contribution_History_api AUTHID CURRENT_USER as
2 /* $Header: pyconapi.pkh 115.1 99/09/30 13:47:38 porting ship  $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_Contribution_History >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 --   Name                           Reqd Type     Description
16 --   p_validate                     Yes  boolean  Commit or Rollback.
17 --   p_person_id                    Yes  number
18 --   p_date_from                    Yes  date
19 --   p_date_to                      Yes  date
20 --   p_contr_type                   Yes  varchar2
21 --   p_business_group_id            Yes  number    Business Group of Record
22 --   p_legislation_code             Yes  varchar2
23 --   p_amt_contr                    No   number
24 --   p_max_contr_allowed            No   number
25 --   p_includable_comp              No   number
26 --   p_tax_unit_id                  No   number
27 --   p_source_system                No   varchar2
28 --   p_contr_information_category   No   varchar2
29 --   p_contr_information1           No   varchar2
30 --   p_contr_information2           No   varchar2
31 --   p_contr_information3           No   varchar2
32 --   p_contr_information4           No   varchar2
33 --   p_contr_information5           No   varchar2
34 --   p_contr_information6           No   varchar2
35 --   p_contr_information7           No   varchar2
36 --   p_contr_information8           No   varchar2
37 --   p_contr_information9           No   varchar2
38 --   p_contr_information10          No   varchar2
39 --   p_contr_information11          No   varchar2
40 --   p_contr_information12          No   varchar2
41 --   p_contr_information13          No   varchar2
42 --   p_contr_information14          No   varchar2
43 --   p_contr_information15          No   varchar2
44 --   p_contr_information16          No   varchar2
45 --   p_contr_information17          No   varchar2
46 --   p_contr_information18          No   varchar2
47 --   p_contr_information19          No   varchar2
48 --   p_contr_information20          No   varchar2
49 --   p_contr_information21          No   varchar2
50 --   p_contr_information22          No   varchar2
51 --   p_contr_information23          No   varchar2
52 --   p_contr_information24          No   varchar2
53 --   p_contr_information25          No   varchar2
54 --   p_contr_information26          No   varchar2
55 --   p_contr_information27          No   varchar2
56 --   p_contr_information28          No   varchar2
57 --   p_contr_information29          No   varchar2
58 --   p_contr_information30          No   varchar2
59 --
60 -- Post Success:
61 --
62 -- Out Parameters:
63 --   Name                                Type     Description
64 --   p_contr_history_id             Yes  number    PK of record
65 --   p_object_version_number        Yes  number    OVN of record
66 --
67 -- Post Failure:
68 --
69 -- Access Status:
70 --   Public.
71 --
72 -- {End Of Comments}
73 --
74 procedure create_Contribution_History
75 (
76    p_validate                       in boolean    default false
77   ,p_contr_history_id               out number
78   ,p_person_id                      in  number    default null
79   ,p_date_from                      in  date      default null
80   ,p_date_to                        in  date      default null
81   ,p_contr_type                     in  varchar2  default null
82   ,p_business_group_id              in  number    default null
83   ,p_legislation_code               in  varchar2  default null
84   ,p_amt_contr                      in  number    default null
85   ,p_max_contr_allowed              in  number    default null
86   ,p_includable_comp                in  number    default null
87   ,p_tax_unit_id                    in  number    default null
88   ,p_source_system                  in  varchar2  default null
89   ,p_contr_information_category     in  varchar2  default null
90   ,p_contr_information1             in  varchar2  default null
91   ,p_contr_information2             in  varchar2  default null
92   ,p_contr_information3             in  varchar2  default null
93   ,p_contr_information4             in  varchar2  default null
94   ,p_contr_information5             in  varchar2  default null
95   ,p_contr_information6             in  varchar2  default null
96   ,p_contr_information7             in  varchar2  default null
97   ,p_contr_information8             in  varchar2  default null
98   ,p_contr_information9             in  varchar2  default null
99   ,p_contr_information10            in  varchar2  default null
100   ,p_contr_information11            in  varchar2  default null
101   ,p_contr_information12            in  varchar2  default null
102   ,p_contr_information13            in  varchar2  default null
103   ,p_contr_information14            in  varchar2  default null
104   ,p_contr_information15            in  varchar2  default null
105   ,p_contr_information16            in  varchar2  default null
106   ,p_contr_information17            in  varchar2  default null
107   ,p_contr_information18            in  varchar2  default null
108   ,p_contr_information19            in  varchar2  default null
109   ,p_contr_information20            in  varchar2  default null
110   ,p_contr_information21            in  varchar2  default null
111   ,p_contr_information22            in  varchar2  default null
112   ,p_contr_information23            in  varchar2  default null
113   ,p_contr_information24            in  varchar2  default null
114   ,p_contr_information25            in  varchar2  default null
115   ,p_contr_information26            in  varchar2  default null
116   ,p_contr_information27            in  varchar2  default null
117   ,p_contr_information28            in  varchar2  default null
118   ,p_contr_information29            in  varchar2  default null
119   ,p_contr_information30            in  varchar2  default null
120   ,p_object_version_number          out number
121  );
122 -- ----------------------------------------------------------------------------
123 -- |------------------------< update_Contribution_History >------------------------|
124 -- ----------------------------------------------------------------------------
125 -- {Start Of Comments}
126 --
127 -- Description:
128 --
129 -- Prerequisites:
130 --
131 --
132 -- In Parameters:
133 --   Name                           Reqd Type     Description
134 --   p_validate                     Yes  boolean  Commit or Rollback.
135 --   p_contr_history_id             Yes  number    PK of record
136 --   p_person_id                    Yes  number
137 --   p_date_from                    Yes  date
138 --   p_date_to                      Yes  date
139 --   p_contr_type                   Yes  varchar2
140 --   p_business_group_id            Yes  number    Business Group of Record
141 --   p_legislation_code             Yes  varchar2
142 --   p_amt_contr                    No   number
143 --   p_max_contr_allowed            No   number
144 --   p_includable_comp              No   number
145 --   p_tax_unit_id                  No   number
146 --   p_source_system                No   varchar2
147 --   p_contr_information_category   No   varchar2
148 --   p_contr_information1           No   varchar2
149 --   p_contr_information2           No   varchar2
150 --   p_contr_information3           No   varchar2
151 --   p_contr_information4           No   varchar2
152 --   p_contr_information5           No   varchar2
153 --   p_contr_information6           No   varchar2
154 --   p_contr_information7           No   varchar2
155 --   p_contr_information8           No   varchar2
156 --   p_contr_information9           No   varchar2
157 --   p_contr_information10          No   varchar2
158 --   p_contr_information11          No   varchar2
159 --   p_contr_information12          No   varchar2
160 --   p_contr_information13          No   varchar2
161 --   p_contr_information14          No   varchar2
162 --   p_contr_information15          No   varchar2
163 --   p_contr_information16          No   varchar2
164 --   p_contr_information17          No   varchar2
165 --   p_contr_information18          No   varchar2
166 --   p_contr_information19          No   varchar2
167 --   p_contr_information20          No   varchar2
168 --   p_contr_information21          No   varchar2
169 --   p_contr_information22          No   varchar2
170 --   p_contr_information23          No   varchar2
171 --   p_contr_information24          No   varchar2
172 --   p_contr_information25          No   varchar2
173 --   p_contr_information26          No   varchar2
174 --   p_contr_information27          No   varchar2
175 --   p_contr_information28          No   varchar2
176 --   p_contr_information29          No   varchar2
177 --   p_contr_information30          No   varchar2
178 --
179 -- Post Success:
180 --
181 --   Name                           Type     Description
182 --   p_object_version_number        Yes  number    OVN of record
183 --
184 -- Post Failure:
185 --
186 -- Access Status:
187 --   Public.
188 --
189 -- {End Of Comments}
190 --
191 procedure update_Contribution_History
192   (
193    p_validate                       in boolean    default false
194   ,p_contr_history_id               in  number
195   ,p_person_id                      in  number    default hr_api.g_number
196   ,p_date_from                      in  date      default hr_api.g_date
197   ,p_date_to                        in  date      default hr_api.g_date
198   ,p_contr_type                     in  varchar2  default hr_api.g_varchar2
199   ,p_business_group_id              in  number    default hr_api.g_number
200   ,p_legislation_code               in  varchar2  default hr_api.g_varchar2
201   ,p_amt_contr                      in  number    default hr_api.g_number
202   ,p_max_contr_allowed              in  number    default hr_api.g_number
203   ,p_includable_comp                in  number    default hr_api.g_number
204   ,p_tax_unit_id                    in  number    default hr_api.g_number
205   ,p_source_system                  in  varchar2  default hr_api.g_varchar2
206   ,p_contr_information_category     in  varchar2  default hr_api.g_varchar2
207   ,p_contr_information1             in  varchar2  default hr_api.g_varchar2
208   ,p_contr_information2             in  varchar2  default hr_api.g_varchar2
209   ,p_contr_information3             in  varchar2  default hr_api.g_varchar2
210   ,p_contr_information4             in  varchar2  default hr_api.g_varchar2
211   ,p_contr_information5             in  varchar2  default hr_api.g_varchar2
212   ,p_contr_information6             in  varchar2  default hr_api.g_varchar2
213   ,p_contr_information7             in  varchar2  default hr_api.g_varchar2
214   ,p_contr_information8             in  varchar2  default hr_api.g_varchar2
215   ,p_contr_information9             in  varchar2  default hr_api.g_varchar2
216   ,p_contr_information10            in  varchar2  default hr_api.g_varchar2
217   ,p_contr_information11            in  varchar2  default hr_api.g_varchar2
218   ,p_contr_information12            in  varchar2  default hr_api.g_varchar2
219   ,p_contr_information13            in  varchar2  default hr_api.g_varchar2
220   ,p_contr_information14            in  varchar2  default hr_api.g_varchar2
221   ,p_contr_information15            in  varchar2  default hr_api.g_varchar2
222   ,p_contr_information16            in  varchar2  default hr_api.g_varchar2
223   ,p_contr_information17            in  varchar2  default hr_api.g_varchar2
224   ,p_contr_information18            in  varchar2  default hr_api.g_varchar2
225   ,p_contr_information19            in  varchar2  default hr_api.g_varchar2
226   ,p_contr_information20            in  varchar2  default hr_api.g_varchar2
227   ,p_contr_information21            in  varchar2  default hr_api.g_varchar2
228   ,p_contr_information22            in  varchar2  default hr_api.g_varchar2
229   ,p_contr_information23            in  varchar2  default hr_api.g_varchar2
230   ,p_contr_information24            in  varchar2  default hr_api.g_varchar2
231   ,p_contr_information25            in  varchar2  default hr_api.g_varchar2
232   ,p_contr_information26            in  varchar2  default hr_api.g_varchar2
233   ,p_contr_information27            in  varchar2  default hr_api.g_varchar2
234   ,p_contr_information28            in  varchar2  default hr_api.g_varchar2
235   ,p_contr_information29            in  varchar2  default hr_api.g_varchar2
236   ,p_contr_information30            in  varchar2  default hr_api.g_varchar2
237   ,p_object_version_number          in out number
238   );
239 --
240 -- ----------------------------------------------------------------------------
241 -- |------------------------< delete_Contribution_History >------------------------|
242 -- ----------------------------------------------------------------------------
243 -- {Start Of Comments}
244 --
245 -- Description:
246 --
247 -- Prerequisites:
248 --
249 --
250 -- In Parameters:
251 --   Name                           Reqd Type     Description
252 --   p_validate                     Yes  boolean  Commit or Rollback.
253 --   p_contr_history_id             Yes  number    PK of record
254 --
255 -- Post Success:
256 --
257 --   Name                           Type     Description
258 --   p_object_version_number        Yes  number    OVN of record
259 --
260 -- Post Failure:
261 --
262 -- Access Status:
263 --   Public.
264 --
265 -- {End Of Comments}
266 --
267 procedure delete_Contribution_History
268   (
269    p_validate                       in boolean        default false
270   ,p_contr_history_id               in  number
271   ,p_object_version_number          in out number
272   );
273 --
274 -- ----------------------------------------------------------------------------
275 -- |----------------------------------< lck >---------------------------------|
276 -- ----------------------------------------------------------------------------
277 -- {Start Of Comments}
278 --
279 -- Description:
280 --
281 -- Prerequisites:
282 --
283 --
284 -- In Parameters:
285 --   Name                           Reqd Type     Description
286 --   p_contr_history_id                 Yes  number   PK of record
287 --   p_object_version_number        Yes  number   OVN of record
288 --
289 -- Post Success:
290 --
291 --   Name                           Type     Description
292 --
293 -- Post Failure:
294 --
295 -- Access Status:
296 --   Public.
297 --
298 -- {End Of Comments}
299 --
300 procedure lck
301   (
302     p_contr_history_id                 in number
303    ,p_object_version_number        in number
304   );
305 --
306 end pay_Contribution_History_api;