1 Package pay_element_class_swi As
2 /* $Header: pypecswi.pkh 120.0 2006/01/25 16:09 ndorai noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------------< delete_row >------------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pay_element_class_pkg.delete_row
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 delete_row
27 (x_classification_id in number
28 ,p_return_status out nocopy varchar2
29 );
30 -- ----------------------------------------------------------------------------
31 -- |------------------------------< insert_row >------------------------------|
32 -- ----------------------------------------------------------------------------
33 -- {Start of comments}
34 --
35 -- Description:
36 -- This procedure is the self-service wrapper procedure to the following
37 -- API: pay_element_class_pkg.insert_row
38 --
39 -- Pre-requisites
40 -- All 'IN' parameters to this procedure have been appropriately derived.
41 --
42 -- Post Success:
43 -- p_return_status will return value indicating success.
44 --
45 -- Post Failure:
46 -- p_return_status will return value indication failure.
47 --
48 -- Access Status:
49 -- Internal Development use only.
50 --
51 -- {End of comments}
52 -- ----------------------------------------------------------------------------
53 PROCEDURE insert_row
54 (x_rowid in out nocopy varchar2
55 ,x_classification_id in number
56 ,x_business_group_id in number
57 ,x_legislation_code in varchar2
58 ,x_legislation_subgroup in varchar2
59 ,x_costable_flag in varchar2
60 ,x_default_high_priority in number
61 ,x_default_low_priority in number
62 ,x_default_priority in number
63 ,x_distributable_over_flag in varchar2
64 ,x_non_payments_flag in varchar2
65 ,x_costing_debit_or_credit in varchar2
66 ,x_parent_classification_id in number
67 ,x_create_by_default_flag in varchar2
68 ,x_balance_initialization_flag in varchar2
69 ,x_object_version_number in number
70 ,x_classification_name in varchar2
71 ,x_description in varchar2
72 ,x_creation_date in date
73 ,x_created_by in number
74 ,x_last_update_date in date
75 ,x_last_updated_by in number
76 ,x_last_update_login in number
77 ,x_freq_rule_enabled in varchar2 default hr_api.g_varchar2
78 ,p_return_status out nocopy varchar2
79 );
80 -- ----------------------------------------------------------------------------
81 -- |-------------------------------< lock_row >-------------------------------|
82 -- ----------------------------------------------------------------------------
83 -- {Start of comments}
84 --
85 -- Description:
86 -- This procedure is the self-service wrapper procedure to the following
87 -- API: pay_element_class_pkg.lock_row
88 --
89 -- Pre-requisites
90 -- All 'IN' parameters to this procedure have been appropriately derived.
91 --
92 -- Post Success:
93 -- p_return_status will return value indicating success.
94 --
95 -- Post Failure:
96 -- p_return_status will return value indication failure.
97 --
98 -- Access Status:
99 -- Internal Development use only.
100 --
101 -- {End of comments}
102 -- ----------------------------------------------------------------------------
103 PROCEDURE lock_row
104 (x_classification_id in number
105 ,x_business_group_id in number
106 ,x_legislation_code in varchar2
107 ,x_legislation_subgroup in varchar2
108 ,x_costable_flag in varchar2
109 ,x_default_high_priority in number
110 ,x_default_low_priority in number
111 ,x_default_priority in number
112 ,x_distributable_over_flag in varchar2
113 ,x_non_payments_flag in varchar2
114 ,x_costing_debit_or_credit in varchar2
115 ,x_parent_classification_id in number
116 ,x_create_by_default_flag in varchar2
117 ,x_balance_initialization_flag in varchar2
118 ,x_object_version_number in number
119 ,x_classification_name in varchar2
120 ,x_description in varchar2
121 ,x_freq_rule_enabled in varchar2 default hr_api.g_varchar2
122 ,p_return_status out nocopy varchar2
123 );
124 -- ----------------------------------------------------------------------------
125 -- |------------------------< set_translation_globals >-----------------------|
126 -- ----------------------------------------------------------------------------
127 -- {Start of comments}
128 --
129 -- Description:
130 -- This procedure is the self-service wrapper procedure to the following
131 -- API: pay_element_class_pkg.set_translation_globals
132 --
133 -- Pre-requisites
134 -- All 'IN' parameters to this procedure have been appropriately derived.
135 --
136 -- Post Success:
137 -- p_return_status will return value indicating success.
138 --
139 -- Post Failure:
140 -- p_return_status will return value indication failure.
141 --
142 -- Access Status:
143 -- Internal Development use only.
144 --
145 -- {End of comments}
146 -- ----------------------------------------------------------------------------
147 PROCEDURE set_translation_globals
148 (p_business_group_id in number
149 ,p_legislation_code in varchar2
150 ,p_return_status out nocopy varchar2
151 );
152 -- ----------------------------------------------------------------------------
153 -- |-----------------------------< translate_row >----------------------------|
154 -- ----------------------------------------------------------------------------
155 -- {Start of comments}
156 --
157 -- Description:
158 -- This procedure is the self-service wrapper procedure to the following
159 -- API: pay_element_class_pkg.translate_row
160 --
161 -- Pre-requisites
162 -- All 'IN' parameters to this procedure have been appropriately derived.
163 --
164 -- Post Success:
168 -- p_return_status will return value indication failure.
165 -- p_return_status will return value indicating success.
166 --
167 -- Post Failure:
169 --
170 -- Access Status:
171 -- Internal Development use only.
172 --
173 -- {End of comments}
174 -- ----------------------------------------------------------------------------
175 PROCEDURE translate_row
176 (x_e_classification_name in varchar2
177 ,x_e_legislation_code in varchar2
178 ,x_classification_name in varchar2
179 ,x_description in varchar2
180 ,x_owner in varchar2
181 ,p_return_status out nocopy varchar2
182 );
183 -- ----------------------------------------------------------------------------
184 -- |------------------------------< update_row >------------------------------|
185 -- ----------------------------------------------------------------------------
186 -- {Start of comments}
187 --
188 -- Description:
189 -- This procedure is the self-service wrapper procedure to the following
190 -- API: pay_element_class_pkg.update_row
191 --
192 -- Pre-requisites
193 -- All 'IN' parameters to this procedure have been appropriately derived.
197 --
194 --
195 -- Post Success:
196 -- p_return_status will return value indicating success.
198 -- Post Failure:
199 -- p_return_status will return value indication failure.
200 --
201 -- Access Status:
202 -- Internal Development use only.
203 --
204 -- {End of comments}
205 -- ----------------------------------------------------------------------------
206 PROCEDURE update_row
207 (x_classification_id in number
208 ,x_business_group_id in number
209 ,x_legislation_code in varchar2
210 ,x_legislation_subgroup in varchar2
211 ,x_costable_flag in varchar2
212 ,x_default_high_priority in number
213 ,x_default_low_priority in number
214 ,x_default_priority in number
215 ,x_distributable_over_flag in varchar2
216 ,x_non_payments_flag in varchar2
217 ,x_costing_debit_or_credit in varchar2
218 ,x_parent_classification_id in number
219 ,x_create_by_default_flag in varchar2
220 ,x_balance_initialization_flag in varchar2
221 ,x_object_version_number in number
222 ,x_classification_name in varchar2
223 ,x_description in varchar2
224 ,x_last_update_date in date
225 ,x_last_updated_by in number
226 ,x_last_update_login in number
227 ,x_mesg_flg out nocopy number
228 ,x_freq_rule_enabled in varchar2 default hr_api.g_varchar2
229 ,p_return_status out nocopy varchar2
230 );
231 -- ----------------------------------------------------------------------------
232 -- |-------------------------< validate_translation >-------------------------|
233 -- ----------------------------------------------------------------------------
234 -- {Start of comments}
235 --
236 -- Description:
237 -- This procedure is the self-service wrapper procedure to the following
238 -- API: pay_element_class_pkg.validate_translation
239 --
240 -- Pre-requisites
241 -- All 'IN' parameters to this procedure have been appropriately derived.
242 --
243 -- Post Success:
244 -- p_return_status will return value indicating success.
245 --
246 -- Post Failure:
247 -- p_return_status will return value indication failure.
248 --
249 -- Access Status:
250 -- Internal Development use only.
251 --
252 -- {End of comments}
253 -- ----------------------------------------------------------------------------
254 PROCEDURE validate_translation
255 (classification_id in number
256 ,language in varchar2
257 ,classification_name in varchar2
258 ,description in varchar2
259 ,p_business_group_id in number default hr_api.g_number
260 ,p_legislation_code in varchar2 default hr_api.g_varchar2
261 ,p_return_status out nocopy varchar2
262 );
263 end pay_element_class_swi;