1 Package hr_pay_scale_value_api AUTHID CURRENT_USER as
2 /* $Header: pypsrapi.pkh 120.2 2010/03/04 11:52:05 sidsaxen ship $ */
3 /*#
4 * This package contains APIs that will maintain rate values for pay scale
5 * points.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Scale Rate Value
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |--------------------------< create_pay_scale_value >----------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a rate value for a defined point on a pay scale.
18 *
19 * You can assign a rate (such as an amount for overtime) to an employee based
20 * on their pay scale point. You can define a rate as a specific value or a
21 * range of values.
22 *
23 * <p><b>Licensing</b><br>
24 * This API is licensed for use with Human Resources.
25 *
26 * <p><b>Prerequisites</b><br>
27 * A valid pay scale and point must exist as of the start date of the pay scale
28 * rate value.
29 *
30 * <p><b>Post Success</b><br>
31 * A pay scale rate value will be created.
32 *
33 * <p><b>Post Failure</b><br>
34 * A pay scale rate value will not be created and an error will be raised.
35 * @param p_validate If true, then validation alone will be performed and the
36 * database will remain unchanged. If false and all validation checks pass,
37 * then the database will be modified.
38 * @param p_effective_date Determines when the DateTrack operation comes into
39 * force
40 * @param p_rate_id If p_validate is false, uniquely identifies the pay scale
41 * rate value created. If p_validate is true, set to null.
42 * @param p_currency_code For pay rates that have the unit of 'MONEY', this
43 * parameter must be set to a value from the column
44 * FND_CURRENCIES.CURRENCY_CODE.
45 * @param p_spinal_point_id The pay scale point for which the rate value is
46 * created.
47 * @param p_value The actual rate value that applies to this pay scale point.
48 * @param p_grade_rule_id If p_validate is false, uniquely identifies the pay
49 * scale rate value created. If p_validate is true, set to null.
50 * @param p_object_version_number If p_validate is false, then set to the
51 * version number of the created pay scale rate value. If p_validate is true,
52 * then the value will be null.
53 * @param p_effective_start_date If p_validate is false, then set to the
54 * earliest effective start date for the created pay scale rate value. If
55 * p_validate is true, then set to null.
56 * @param p_effective_end_date If p_validate is false, then set to the
57 * effective end date for the created pay scale rate value. If p_validate is
58 * true, then set to null.
59 * @rep:displayname Create Pay Scale Rate Value
60 * @rep:category BUSINESS_ENTITY HR_PAY_SCALE
61 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
62 * @rep:scope public
63 * @rep:lifecycle active
64 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
65 */
66 --
67 -- {End Of Comments}
68 --
69 procedure create_pay_scale_value
70 (p_validate in boolean default false
71 ,p_effective_date in date
72 ,p_rate_id in number
73 ,p_currency_code in varchar2
74 ,p_spinal_point_id in number
75 ,p_value in varchar2 default null
76 ,p_grade_rule_id out nocopy number
77 ,p_object_version_number out nocopy number
78 ,p_effective_start_date out nocopy date
79 ,p_effective_end_date out nocopy date
80 );
81 --
82 -- ----------------------------------------------------------------------------
83 -- |--------------------------< update_pay_scale_value >----------------------|
84 -- ----------------------------------------------------------------------------
85 --
86 -- {Start Of Comments}
87 /*#
88 * This API updates a rate value for a defined point on a pay scale.
89 *
90 * You can assign a rate (such as an amount for overtime) to an employee based
91 * on their pay scale point. You can define a rate as a specific value or a
92 * range of values.
93 *
94 * <p><b>Licensing</b><br>
95 * This API is licensed for use with Human Resources.
96 *
97 * <p><b>Prerequisites</b><br>
98 * The pay scale rate value must exist on the effective date of the update.
99 *
100 * <p><b>Post Success</b><br>
101 * The pay scale rate value will be updated.
102 *
103 * <p><b>Post Failure</b><br>
104 * The pay scale rate value will not be updated and an error will be raised.
105 * @param p_validate If true, then validation alone will be performed and the
106 * database will remain unchanged. If false and all validation checks pass,
107 * then the database will be modified.
108 * @param p_effective_date Determines when the DateTrack operation comes into
109 * force
110 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
111 * updating the record. You must set to either UPDATE, CORRECTION,
112 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
113 * particular record depend on the dates of previous record changes and the
114 * effective date of this change.
115 * @param p_grade_rule_id Uniquely identifies the pay scale rate value to be
116 * updated.
117 * @param p_object_version_number Pass in the current version number of the pay
118 * scale rate value to be updated. When the API completes if p_validate is
119 * false, will be set to the new version number of the updated pay scale rate
120 * value. If p_validate is true will be set to the same value which was passed
121 * in.
122 * @param p_currency_code For pay rates that have the unit of 'MONEY', this
123 * parameter must be set to a value from the column
124 * FND_CURRENCIES.CURRENCY_CODE.
125 * @param p_maximum Cannot be set for pay scale rate values. Do not pass in.
126 * @param p_mid_value Cannot be set for pay scale rate values. Do not pass in.
127 * @param p_minimum Cannot be set for pay scale rate values. Do not pass in.
128 * @param p_value The actual rate value that applies to this pay scale point.
129 * @param p_effective_start_date If p_validate is false, then set to the
130 * effective start date on the updated pay scale rate value row which now
131 * exists as of the effective date. If p_validate is true, then set to null.
132 * @param p_effective_end_date If p_validate is false, then set to the
133 * effective end date on the updated pay scale rate value row which now exists
134 * as of the effective date. If p_validate is true, then set to null.
135 * @param p_called_from Pass in the calling program name. The valid values are
136 * API, FORM and GSPW.
137 * @rep:displayname Update Pay Scale Rate Value
138 * @rep:category BUSINESS_ENTITY HR_PAY_SCALE
139 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
140 * @rep:scope public
141 * @rep:lifecycle active
142 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
143 */
144 --
145 -- {End Of Comments}
146 --
147 procedure update_pay_scale_value
148 (p_validate in boolean default false
149 ,p_effective_date in date
150 ,p_datetrack_update_mode in varchar2
151 ,p_grade_rule_id in number
152 ,p_object_version_number in out nocopy number
153 ,p_currency_code in varchar2
154 ,p_maximum in varchar2 default null
155 ,p_mid_value in varchar2 default null
156 ,p_minimum in varchar2 default null
157 ,p_value in varchar2 default null
158 ,p_effective_start_date out nocopy date
159 ,p_effective_end_date out nocopy date
160 ,p_called_from in varchar2 --added for bug 9328526
161 );
162
163 -- Start changes for bug 9328526
164 -- Overloaded procedure update_pay_scale_value
165 --
166 -- ----------------------------------------------------------------------------
167 -- |--------------------------< update_pay_scale_value >----------------------|
168 -- ----------------------------------------------------------------------------
169 --
170 procedure update_pay_scale_value
171 (p_validate in boolean default false
172 ,p_effective_date in date
173 ,p_datetrack_update_mode in varchar2
174 ,p_grade_rule_id in number
175 ,p_object_version_number in out nocopy number
176 ,p_currency_code in varchar2
177 ,p_maximum in varchar2 default null
178 ,p_mid_value in varchar2 default null
179 ,p_minimum in varchar2 default null
180 ,p_value in varchar2 default null
181 ,p_effective_start_date out nocopy date
182 ,p_effective_end_date out nocopy date
183 );
184 -- End changes for bug 9328526
185
186 --
187 -- ----------------------------------------------------------------------------
188 -- |--------------------------< delete_pay_scale_value >----------------------|
189 -- ----------------------------------------------------------------------------
190 --
191 -- {Start Of Comments}
192 /*#
193 * This API deletes a rate value for a defined point on a pay scale.
194 *
195 * You can assign a rate (such as an amount for overtime) to an employee based
196 * on their pay scale point. You can define a rate as a specific value or a
197 * range of values.
198 *
199 * <p><b>Licensing</b><br>
200 * This API is licensed for use with Human Resources.
201 *
202 * <p><b>Prerequisites</b><br>
203 * The pay scale rate value must exist on the effective date of the delete.
204 *
205 * <p><b>Post Success</b><br>
206 * The pay scale rate value will be deleted.
207 *
208 * <p><b>Post Failure</b><br>
209 * The pay scale rate value will not be deleted and an error will be raised.
210 * @param p_validate If true, then validation alone will be performed and the
211 * database will remain unchanged. If false and all validation checks pass,
212 * then the database will be modified.
213 * @param p_effective_date Determines when the DateTrack operation comes into
214 * force
215 * @param p_datetrack_delete_mode Indicates which DateTrack mode to use when
216 * deleting the record. You must set to either ZAP, DELETE, FUTURE_CHANGE or
217 * DELETE_NEXT_CHANGE. Modes available for use with a particular record depend
218 * on the dates of previous record changes and the effective date of this
219 * change.
220 * @param p_grade_rule_id Uniquely identifies the pay scale rate value to be
221 * deleted.
222 * @param p_object_version_number Current version number of the pay scale rate
223 * value to be deleted.
224 * @param p_effective_start_date If p_validate is false, then set to the
225 * effective start date for the deleted pay scale rate value row which now
226 * exists as of the effective date. If p_validate is true or all row instances
227 * have been deleted then set to null.
228 * @param p_effective_end_date If p_validate is false, then set to the
229 * effective end date for the deleted pay scale rate value row which now exists
230 * as of the effective date. If p_validate is true or all row instances have
231 * been deleted then set to null.
232 * @param p_called_from Pass in the calling program name. The valid values are
233 * API, FORM and GSPW.
234 * @rep:displayname Delete Pay Scale Rate Value
235 * @rep:category BUSINESS_ENTITY HR_PAY_SCALE
236 * @rep:scope public
237 * @rep:lifecycle active
238 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
239 */
240 --
241 -- {End Of Comments}
242 --
243 procedure delete_pay_scale_value
244 (p_validate in boolean default false
245 ,p_effective_date in date
246 ,p_datetrack_delete_mode in varchar2
247 ,p_grade_rule_id in number
248 ,p_object_version_number in out nocopy number
249 ,p_effective_start_date out nocopy date
250 ,p_effective_end_date out nocopy date
251 ,p_called_from in varchar2 --added for bug 9328526
252 );
253
254 -- Start changes for bug 9328526
255 -- Overloaded procedure delete_pay_scale_value
256 --
257 -- ----------------------------------------------------------------------------
258 -- |--------------------------< delete_pay_scale_value >----------------------|
259 -- ----------------------------------------------------------------------------
260 --
261 procedure delete_pay_scale_value
262 (p_validate in boolean default false
263 ,p_effective_date in date
264 ,p_datetrack_delete_mode in varchar2
265 ,p_grade_rule_id in number
266 ,p_object_version_number in out nocopy number
267 ,p_effective_start_date out nocopy date
268 ,p_effective_end_date out nocopy date
269 );
270 -- End changes for bug 9328526
271
272 end hr_pay_scale_value_api;
[Home] [Help]