DBA Data[Home] [Help]

PACKAGE: APPS.PAY_ELEMENT_LINK_SWI

Source


1 Package pay_element_link_swi AUTHID CURRENT_USER As
2 /* $Header: pypelswi.pkh 115.0 2002/12/31 02:14:47 ndorai noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |--------------------------< create_element_link >-------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 --  This procedure is the self-service wrapper procedure to the following
10 --  API: pay_element_link_api.create_element_link
11 --
12 -- Pre-requisites
13 --  All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 --  p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 --  p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 --  Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_element_link
27   (p_validate                     in     number    default hr_api.g_false_num
28   ,p_effective_date               in     date
29   ,p_element_type_id              in     number
30   ,p_business_group_id            in     number
31   ,p_costable_type                in     varchar2
32   ,p_payroll_id                   in     number    default null
33   ,p_job_id                       in     number    default null
34   ,p_position_id                  in     number    default null
35   ,p_people_group_id              in     number    default null
36   ,p_cost_allocation_keyflex_id   in     number    default null
37   ,p_organization_id              in     number    default null
38   ,p_location_id                  in     number    default null
39   ,p_grade_id                     in     number    default null
40   ,p_balancing_keyflex_id         in     number    default null
41   ,p_element_set_id               in     number    default null
42   ,p_pay_basis_id                 in     number    default null
43   ,p_link_to_all_payrolls_flag    in     varchar2  default null
44   ,p_standard_link_flag           in     varchar2  default null
45   ,p_transfer_to_gl_flag          in     varchar2  default null
46   ,p_comments                     in     varchar2  default null
47   ,p_employment_category          in     varchar2  default null
48   ,p_qualifying_age               in     number    default null
49   ,p_qualifying_length_of_service in     number    default null
50   ,p_qualifying_units             in     varchar2  default null
51   ,p_attribute_category           in     varchar2  default null
52   ,p_attribute1                   in     varchar2  default null
53   ,p_attribute2                   in     varchar2  default null
54   ,p_attribute3                   in     varchar2  default null
55   ,p_attribute4                   in     varchar2  default null
56   ,p_attribute5                   in     varchar2  default null
57   ,p_attribute6                   in     varchar2  default null
58   ,p_attribute7                   in     varchar2  default null
59   ,p_attribute8                   in     varchar2  default null
60   ,p_attribute9                   in     varchar2  default null
61   ,p_attribute10                  in     varchar2  default null
62   ,p_attribute11                  in     varchar2  default null
63   ,p_attribute12                  in     varchar2  default null
64   ,p_attribute13                  in     varchar2  default null
65   ,p_attribute14                  in     varchar2  default null
66   ,p_attribute15                  in     varchar2  default null
67   ,p_attribute16                  in     varchar2  default null
68   ,p_attribute17                  in     varchar2  default null
69   ,p_attribute18                  in     varchar2  default null
70   ,p_attribute19                  in     varchar2  default null
71   ,p_attribute20                  in     varchar2  default null
72   ,p_cost_segment1                in     varchar2  default null
73   ,p_cost_segment2                in     varchar2  default null
74   ,p_cost_segment3                in     varchar2  default null
75   ,p_cost_segment4                in     varchar2  default null
76   ,p_cost_segment5                in     varchar2  default null
77   ,p_cost_segment6                in     varchar2  default null
78   ,p_cost_segment7                in     varchar2  default null
79   ,p_cost_segment8                in     varchar2  default null
80   ,p_cost_segment9                in     varchar2  default null
81   ,p_cost_segment10               in     varchar2  default null
82   ,p_cost_segment11               in     varchar2  default null
83   ,p_cost_segment12               in     varchar2  default null
84   ,p_cost_segment13               in     varchar2  default null
85   ,p_cost_segment14               in     varchar2  default null
86   ,p_cost_segment15               in     varchar2  default null
87   ,p_cost_segment16               in     varchar2  default null
88   ,p_cost_segment17               in     varchar2  default null
89   ,p_cost_segment18               in     varchar2  default null
90   ,p_cost_segment19               in     varchar2  default null
91   ,p_cost_segment20               in     varchar2  default null
92   ,p_cost_segment21               in     varchar2  default null
93   ,p_cost_segment22               in     varchar2  default null
94   ,p_cost_segment23               in     varchar2  default null
95   ,p_cost_segment24               in     varchar2  default null
96   ,p_cost_segment25               in     varchar2  default null
97   ,p_cost_segment26               in     varchar2  default null
98   ,p_cost_segment27               in     varchar2  default null
99   ,p_cost_segment28               in     varchar2  default null
100   ,p_cost_segment29               in     varchar2  default null
101   ,p_cost_segment30               in     varchar2  default null
102   ,p_balance_segment1             in     varchar2  default null
103   ,p_balance_segment2             in     varchar2  default null
104   ,p_balance_segment3             in     varchar2  default null
105   ,p_balance_segment4             in     varchar2  default null
106   ,p_balance_segment5             in     varchar2  default null
107   ,p_balance_segment6             in     varchar2  default null
108   ,p_balance_segment7             in     varchar2  default null
109   ,p_balance_segment8             in     varchar2  default null
110   ,p_balance_segment9             in     varchar2  default null
111   ,p_balance_segment10            in     varchar2  default null
112   ,p_balance_segment11            in     varchar2  default null
113   ,p_balance_segment12            in     varchar2  default null
114   ,p_balance_segment13            in     varchar2  default null
115   ,p_balance_segment14            in     varchar2  default null
116   ,p_balance_segment15            in     varchar2  default null
117   ,p_balance_segment16            in     varchar2  default null
118   ,p_balance_segment17            in     varchar2  default null
119   ,p_balance_segment18            in     varchar2  default null
120   ,p_balance_segment19            in     varchar2  default null
121   ,p_balance_segment20            in     varchar2  default null
122   ,p_balance_segment21            in     varchar2  default null
123   ,p_balance_segment22            in     varchar2  default null
124   ,p_balance_segment23            in     varchar2  default null
125   ,p_balance_segment24            in     varchar2  default null
126   ,p_balance_segment25            in     varchar2  default null
127   ,p_balance_segment26            in     varchar2  default null
128   ,p_balance_segment27            in     varchar2  default null
129   ,p_balance_segment28            in     varchar2  default null
130   ,p_balance_segment29            in     varchar2  default null
131   ,p_balance_segment30            in     varchar2  default null
135   ,p_comment_id                      out nocopy number
132   ,p_cost_concat_segments         in     varchar2
133   ,p_balance_concat_segments      in     varchar2
134   ,p_element_link_id                 out nocopy number
136   ,p_object_version_number           out nocopy number
137   ,p_effective_start_date            out nocopy date
138   ,p_effective_end_date              out nocopy date
139   ,p_return_status                   out nocopy varchar2
140   );
141 -- ----------------------------------------------------------------------------
142 -- |--------------------------< delete_element_link >-------------------------|
143 -- ----------------------------------------------------------------------------
144 -- {Start of comments}
145 --
146 -- Description:
147 --  This procedure is the self-service wrapper procedure to the following
148 --  API: pay_element_link_api.delete_element_link
149 --
150 -- Pre-requisites
151 --  All 'IN' parameters to this procedure have been appropriately derived.
152 --
153 -- Post Success:
154 --  p_return_status will return value indicating success.
155 --
156 -- Post Failure:
157 --  p_return_status will return value indication failure.
158 --
159 -- Access Status:
160 --  Internal Development use only.
161 --
162 -- {End of comments}
163 -- ----------------------------------------------------------------------------
164 PROCEDURE delete_element_link
165   (p_validate                     in     number    default hr_api.g_false_num
166   ,p_effective_date               in     date
167   ,p_element_link_id              in     number
168   ,p_datetrack_delete_mode        in     varchar2
169   ,p_object_version_number        in out nocopy number
170   ,p_effective_start_date            out nocopy date
171   ,p_effective_end_date              out nocopy date
172   ,p_return_status                   out nocopy varchar2
173   );
174 -- ----------------------------------------------------------------------------
175 -- |--------------------------< update_element_link >-------------------------|
176 -- ----------------------------------------------------------------------------
177 -- {Start of comments}
178 --
179 -- Description:
180 --  This procedure is the self-service wrapper procedure to the following
181 --  API: pay_element_link_api.update_element_link
182 --
183 -- Pre-requisites
184 --  All 'IN' parameters to this procedure have been appropriately derived.
185 --
186 -- Post Success:
187 --  p_return_status will return value indicating success.
188 --
189 -- Post Failure:
190 --  p_return_status will return value indication failure.
191 --
192 -- Access Status:
193 --  Internal Development use only.
194 --
195 -- {End of comments}
196 -- ----------------------------------------------------------------------------
197 PROCEDURE update_element_link
198   (p_validate                     in     number    default hr_api.g_false_num
199   ,p_effective_date               in     date
200   ,p_element_link_id              in     number
201   ,p_datetrack_mode               in     varchar2
202   ,p_costable_type                in     varchar2  default hr_api.g_varchar2
203   ,p_element_set_id               in     number    default hr_api.g_number
204   ,p_multiply_value_flag          in     varchar2  default hr_api.g_varchar2
205   ,p_standard_link_flag           in     varchar2  default hr_api.g_varchar2
206   ,p_transfer_to_gl_flag          in     varchar2  default hr_api.g_varchar2
207   ,p_comments                     in     varchar2  default hr_api.g_varchar2
208   ,p_comment_id                   in     varchar2  default hr_api.g_varchar2
209   ,p_employment_category          in     varchar2  default hr_api.g_varchar2
210   ,p_qualifying_age               in     number    default hr_api.g_number
211   ,p_qualifying_length_of_service in     number    default hr_api.g_number
212   ,p_qualifying_units             in     varchar2  default hr_api.g_varchar2
213   ,p_attribute_category           in     varchar2  default hr_api.g_varchar2
214   ,p_attribute1                   in     varchar2  default hr_api.g_varchar2
215   ,p_attribute2                   in     varchar2  default hr_api.g_varchar2
216   ,p_attribute3                   in     varchar2  default hr_api.g_varchar2
217   ,p_attribute4                   in     varchar2  default hr_api.g_varchar2
218   ,p_attribute5                   in     varchar2  default hr_api.g_varchar2
219   ,p_attribute6                   in     varchar2  default hr_api.g_varchar2
220   ,p_attribute7                   in     varchar2  default hr_api.g_varchar2
221   ,p_attribute8                   in     varchar2  default hr_api.g_varchar2
222   ,p_attribute9                   in     varchar2  default hr_api.g_varchar2
223   ,p_attribute10                  in     varchar2  default hr_api.g_varchar2
224   ,p_attribute11                  in     varchar2  default hr_api.g_varchar2
225   ,p_attribute12                  in     varchar2  default hr_api.g_varchar2
226   ,p_attribute13                  in     varchar2  default hr_api.g_varchar2
227   ,p_attribute14                  in     varchar2  default hr_api.g_varchar2
228   ,p_attribute15                  in     varchar2  default hr_api.g_varchar2
229   ,p_attribute16                  in     varchar2  default hr_api.g_varchar2
230   ,p_attribute17                  in     varchar2  default hr_api.g_varchar2
231   ,p_attribute18                  in     varchar2  default hr_api.g_varchar2
232   ,p_attribute19                  in     varchar2  default hr_api.g_varchar2
233   ,p_attribute20                  in     varchar2  default hr_api.g_varchar2
234   ,p_cost_segment1                in     varchar2  default hr_api.g_varchar2
235   ,p_cost_segment2                in     varchar2  default hr_api.g_varchar2
236   ,p_cost_segment3                in     varchar2  default hr_api.g_varchar2
237   ,p_cost_segment4                in     varchar2  default hr_api.g_varchar2
238   ,p_cost_segment5                in     varchar2  default hr_api.g_varchar2
239   ,p_cost_segment6                in     varchar2  default hr_api.g_varchar2
240   ,p_cost_segment7                in     varchar2  default hr_api.g_varchar2
241   ,p_cost_segment8                in     varchar2  default hr_api.g_varchar2
242   ,p_cost_segment9                in     varchar2  default hr_api.g_varchar2
243   ,p_cost_segment10               in     varchar2  default hr_api.g_varchar2
244   ,p_cost_segment11               in     varchar2  default hr_api.g_varchar2
245   ,p_cost_segment12               in     varchar2  default hr_api.g_varchar2
246   ,p_cost_segment13               in     varchar2  default hr_api.g_varchar2
247   ,p_cost_segment14               in     varchar2  default hr_api.g_varchar2
248   ,p_cost_segment15               in     varchar2  default hr_api.g_varchar2
249   ,p_cost_segment16               in     varchar2  default hr_api.g_varchar2
250   ,p_cost_segment17               in     varchar2  default hr_api.g_varchar2
251   ,p_cost_segment18               in     varchar2  default hr_api.g_varchar2
252   ,p_cost_segment19               in     varchar2  default hr_api.g_varchar2
253   ,p_cost_segment20               in     varchar2  default hr_api.g_varchar2
254   ,p_cost_segment21               in     varchar2  default hr_api.g_varchar2
255   ,p_cost_segment22               in     varchar2  default hr_api.g_varchar2
256   ,p_cost_segment23               in     varchar2  default hr_api.g_varchar2
257   ,p_cost_segment24               in     varchar2  default hr_api.g_varchar2
258   ,p_cost_segment25               in     varchar2  default hr_api.g_varchar2
259   ,p_cost_segment26               in     varchar2  default hr_api.g_varchar2
260   ,p_cost_segment27               in     varchar2  default hr_api.g_varchar2
261   ,p_cost_segment28               in     varchar2  default hr_api.g_varchar2
262   ,p_cost_segment29               in     varchar2  default hr_api.g_varchar2
263   ,p_cost_segment30               in     varchar2  default hr_api.g_varchar2
264   ,p_balance_segment1             in     varchar2  default hr_api.g_varchar2
265   ,p_balance_segment2             in     varchar2  default hr_api.g_varchar2
266   ,p_balance_segment3             in     varchar2  default hr_api.g_varchar2
267   ,p_balance_segment4             in     varchar2  default hr_api.g_varchar2
268   ,p_balance_segment5             in     varchar2  default hr_api.g_varchar2
269   ,p_balance_segment6             in     varchar2  default hr_api.g_varchar2
270   ,p_balance_segment7             in     varchar2  default hr_api.g_varchar2
271   ,p_balance_segment8             in     varchar2  default hr_api.g_varchar2
272   ,p_balance_segment9             in     varchar2  default hr_api.g_varchar2
273   ,p_balance_segment10            in     varchar2  default hr_api.g_varchar2
274   ,p_balance_segment11            in     varchar2  default hr_api.g_varchar2
275   ,p_balance_segment12            in     varchar2  default hr_api.g_varchar2
276   ,p_balance_segment13            in     varchar2  default hr_api.g_varchar2
277   ,p_balance_segment14            in     varchar2  default hr_api.g_varchar2
278   ,p_balance_segment15            in     varchar2  default hr_api.g_varchar2
279   ,p_balance_segment16            in     varchar2  default hr_api.g_varchar2
280   ,p_balance_segment17            in     varchar2  default hr_api.g_varchar2
281   ,p_balance_segment18            in     varchar2  default hr_api.g_varchar2
282   ,p_balance_segment19            in     varchar2  default hr_api.g_varchar2
283   ,p_balance_segment20            in     varchar2  default hr_api.g_varchar2
284   ,p_balance_segment21            in     varchar2  default hr_api.g_varchar2
285   ,p_balance_segment22            in     varchar2  default hr_api.g_varchar2
286   ,p_balance_segment23            in     varchar2  default hr_api.g_varchar2
287   ,p_balance_segment24            in     varchar2  default hr_api.g_varchar2
288   ,p_balance_segment25            in     varchar2  default hr_api.g_varchar2
289   ,p_balance_segment26            in     varchar2  default hr_api.g_varchar2
290   ,p_balance_segment27            in     varchar2  default hr_api.g_varchar2
291   ,p_balance_segment28            in     varchar2  default hr_api.g_varchar2
292   ,p_balance_segment29            in     varchar2  default hr_api.g_varchar2
293   ,p_balance_segment30            in     varchar2  default hr_api.g_varchar2
294   ,p_cost_concat_segments_in      in     varchar2  default hr_api.g_varchar2
295   ,p_balance_concat_segments_in   in     varchar2  default hr_api.g_varchar2
296   ,p_object_version_number        in out nocopy number
297   ,p_cost_allocation_keyflex_id      out nocopy number
298   ,p_balancing_keyflex_id            out nocopy number
299   ,p_cost_concat_segments_out        out nocopy varchar2
300   ,p_balance_concat_segments_out     out nocopy varchar2
301   ,p_effective_start_date            out nocopy date
302   ,p_effective_end_date              out nocopy date
303   ,p_return_status                   out nocopy varchar2
304   );
305 end pay_element_link_swi;