1 Package pqp_aat_api as
2 /* $Header: pqaatapi.pkh 120.6.12010000.1 2008/07/28 11:07:01 appldev ship $ */
3 /*#
4 * This package contains APIs for assignment attributes.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Assignment Attribute
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_assignment_attribute >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates an assignment attribute record for an employee including
17 * contract types and details of work patterns.
18 *
19 * This package is used to create assignment attributes. These attributes
20 * include contract type and details of work patterns that are mainly used by
21 * public sector. Note: even though there are columns for vehicle information,
22 * these are not used anymore as the new api's pqp_vehicle_repository_api and
23 * pqp_vehicle_allocation_api are used for vehicle repository and allocations
24 * respectively.
25 *
26 * <p><b>Licensing</b><br>
27 * This API is licensed for use with Human Resources.
28 *
29 * <p><b>Prerequisites</b><br>
30 * The employee must have an assignment on the effective date.
31 *
32 * <p><b>Post Success</b><br>
33 * The assignment attributes will be successfully inserted into the database.
34 *
35 * <p><b>Post Failure</b><br>
36 * The assignment attributes will not be created and an error will be raised.
37 * @param p_validate If true, then validation alone will be performed and the
38 * database will remain unchanged. If false and all validation checks pass,
39 * then the database will be modified.
40 * @param p_effective_date Determines when the DateTrack operation comes into
41 * force.
42 * @param p_business_group_id {@rep:casecolumn
43 * PQP_ASSIGNMENT_ATTRIBUTES_F.BUSINESS_GROUP_ID}
44 * @param p_effective_start_date If p_validate is false, then set to the
45 * earliest effective start date for the created assignment attribute. If
46 * p_validate is true, then set to null.
47 * @param p_effective_end_date If p_validate is false, then set to the
48 * effective end date for the created assignment attribute. If p_validate is
49 * true, then set to null.
50 * @param p_assignment_id Identifies the assignment for which you create the
51 * assignment attribute record.
52 * @param p_contract_type {@rep:casecolumn
53 * PQP_ASSIGNMENT_ATTRIBUTES_F.CONTRACT_TYPE}
54 * @param p_work_pattern {@rep:casecolumn
55 * PQP_ASSIGNMENT_ATTRIBUTES_F.WORK_PATTERN}
56 * @param p_start_day {@rep:casecolumn PQP_ASSIGNMENT_ATTRIBUTES_F.START_DAY}
57 * @param p_primary_company_car {@rep:casecolumn
58 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIMARY_COMPANY_CAR}
59 * @param p_primary_car_fuel_benefit {@rep:casecolumn
60 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIMARY_CAR_FUEL_BENEFIT}
61 * @param p_primary_capital_contribution {@rep:casecolumn
62 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIMARY_CAPITAL_CONTRIBUTION}
63 * @param p_primary_class_1a {@rep:casecolumn
64 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIMARY_CLASS_1A}
65 * @param p_secondary_company_car {@rep:casecolumn
66 * PQP_ASSIGNMENT_ATTRIBUTES_F.SECONDARY_COMPANY_CAR}
67 * @param p_secondary_car_fuel_benefit {@rep:casecolumn
68 * PQP_ASSIGNMENT_ATTRIBUTES_F.SECONDARY_CAR_FUEL_BENEFIT}
69 * @param p_secondary_capital_contributi {@rep:casecolumn
70 * PQP_ASSIGNMENT_ATTRIBUTES_F.SECONDARY_CAPITAL_CONTRIBUTION}
71 * @param p_secondary_class_1a {@rep:casecolumn
72 * PQP_ASSIGNMENT_ATTRIBUTES_F.SECONDARY_CLASS_1A}
73 * @param p_company_car_calc_method {@rep:casecolumn
74 * PQP_ASSIGNMENT_ATTRIBUTES_F.COMPANY_CAR_CALC_METHOD}
75 * @param p_company_car_rates_table_id {@rep:casecolumn
76 * PQP_ASSIGNMENT_ATTRIBUTES_F.COMPANY_CAR_RATES_TABLE_ID}
77 * @param p_company_car_secondary_table {@rep:casecolumn
78 * PQP_ASSIGNMENT_ATTRIBUTES_F.COMPANY_CAR_SECONDARY_TABLE_ID}
79 * @param p_private_car {@rep:casecolumn
80 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIVATE_CAR}
81 * @param p_private_car_calc_method {@rep:casecolumn
82 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIVATE_CAR_CALC_METHOD}
83 * @param p_private_car_rates_table_id {@rep:casecolumn
84 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIVATE_CAR_RATES_TABLE_ID}
85 * @param p_private_car_essential_table {@rep:casecolumn
86 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIVATE_CAR_ESSENTIAL_TABLE_ID}
87 * @param p_primary_private_contribution {@rep:casecolumn
88 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIMARY_PRIVATE_CONTRIBUTION}
89 * @param p_secondary_private_contributi {@rep:casecolumn
90 * PQP_ASSIGNMENT_ATTRIBUTES_F.SECONDARY_PRIVATE_CONTRIBUTION}
91 * @param p_tp_is_teacher {@rep:casecolumn
92 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_IS_TEACHER}
93 * @param p_tp_safeguarded_grade {@rep:casecolumn
94 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_SAFEGUARDED_GRADE}
95 * @param p_tp_safeguarded_grade_id {@rep:casecolumn
96 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_SAFEGUARDED_GRADE_ID}
97 * @param p_tp_safeguarded_rate_type {@rep:casecolumn
98 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_SAFEGUARDED_RATE_TYPE}
99 * @param p_tp_safeguarded_rate_id {@rep:casecolumn
100 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_SAFEGUARDED_RATE_ID}
101 * @param p_tp_spinal_point_id {@rep:casecolumn
102 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_SAFEGUARDED_SPINAL_POINT_ID}
103 * @param p_tp_elected_pension {@rep:casecolumn
104 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_ELECTED_PENSION}
105 * @param p_tp_fast_track {@rep:casecolumn
106 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_FAST_TRACK}
107 * @param p_aat_attribute_category {@rep:casecolumn
108 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE_CATEGORY}
109 * @param p_aat_attribute1 {@rep:casecolumn
110 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE1}
111 * @param p_aat_attribute2 {@rep:casecolumn
112 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE2}
113 * @param p_aat_attribute3 {@rep:casecolumn
114 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE3}
115 * @param p_aat_attribute4 {@rep:casecolumn
116 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE4}
117 * @param p_aat_attribute5 {@rep:casecolumn
118 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE5}
119 * @param p_aat_attribute6 {@rep:casecolumn
120 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE6}
121 * @param p_aat_attribute7 {@rep:casecolumn
122 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE7}
123 * @param p_aat_attribute8 {@rep:casecolumn
124 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE8}
125 * @param p_aat_attribute9 {@rep:casecolumn
126 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE9}
127 * @param p_aat_attribute10 {@rep:casecolumn
128 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE10}
129 * @param p_aat_attribute11 {@rep:casecolumn
130 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE11}
131 * @param p_aat_attribute12 {@rep:casecolumn
132 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE12}
133 * @param p_aat_attribute13 {@rep:casecolumn
134 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE13}
135 * @param p_aat_attribute14 {@rep:casecolumn
136 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE14}
137 * @param p_aat_attribute15 {@rep:casecolumn
138 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE15}
139 * @param p_aat_attribute16 {@rep:casecolumn
140 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE16}
141 * @param p_aat_attribute17 {@rep:casecolumn
142 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE17}
143 * @param p_aat_attribute18 {@rep:casecolumn
144 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE18}
145 * @param p_aat_attribute19 {@rep:casecolumn
146 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE19}
147 * @param p_aat_attribute20 {@rep:casecolumn
148 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE20}
149 * @param p_aat_information_category {@rep:casecolumn
150 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION_CATEGORY}
151 * @param p_aat_information1 {@rep:casecolumn
152 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION1}
153 * @param p_aat_information2 {@rep:casecolumn
154 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION2}
155 * @param p_aat_information3 {@rep:casecolumn
156 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION3}
157 * @param p_aat_information4 {@rep:casecolumn
158 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION4}
159 * @param p_aat_information5 {@rep:casecolumn
160 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION5}
161 * @param p_aat_information6 {@rep:casecolumn
162 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION6}
163 * @param p_aat_information7 {@rep:casecolumn
164 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION7}
165 * @param p_aat_information8 {@rep:casecolumn
166 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION8}
167 * @param p_aat_information9 {@rep:casecolumn
168 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION9}
169 * @param p_aat_information10 {@rep:casecolumn
170 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION10}
171 * @param p_aat_information11 {@rep:casecolumn
172 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION11}
173 * @param p_aat_information12 {@rep:casecolumn
174 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION12}
175 * @param p_aat_information13 {@rep:casecolumn
176 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION13}
177 * @param p_aat_information14 {@rep:casecolumn
178 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION14}
179 * @param p_aat_information15 {@rep:casecolumn
180 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION15}
181 * @param p_aat_information16 {@rep:casecolumn
182 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION16}
183 * @param p_aat_information17 {@rep:casecolumn
184 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION17}
185 * @param p_aat_information18 {@rep:casecolumn
186 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION18}
187 * @param p_aat_information19 {@rep:casecolumn
188 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION19}
189 * @param p_aat_information20 {@rep:casecolumn
190 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION20}
191 * @param p_lgps_process_flag {@rep:casecolumn
192 * PQP_ASSIGNMENT_ATTRIBUTES_F.LGPS_PROCESS_FLAG}
193 * @param p_lgps_exclusion_type {@rep:casecolumn
194 * PQP_ASSIGNMENT_ATTRIBUTES_F.LGPS_EXCLUSION_TYPE}
195 * @param p_lgps_pensionable_pay {@rep:casecolumn
196 * PQP_ASSIGNMENT_ATTRIBUTES_F.LGPS_PENSIONABLE_PAY}
197 * @param p_lgps_trans_arrang_flag {@rep:casecolumn
198 * PQP_ASSIGNMENT_ATTRIBUTES_F.LGPS_TRANS_ARRANG_FLAG}
199 * @param p_lgps_membership_number {@rep:casecolumn
200 * PQP_ASSIGNMENT_ATTRIBUTES_F.LGPS_MEMBERSHIP_NUMBER}
201 * @param p_assignment_attribute_id If p_validate is false, then this uniquely
202 * identifies the assignment attribute row created. If p_validate is true, then
203 * set to null.
204 * @param p_object_version_number If p_validate is false, then set to the
205 * version number of the created assignment attribute. If p_validate is true,
206 * then the value will be null.
207 * @param p_tp_headteacher_grp_code {@rep:casecolumn
208 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_HEADTEACHER_GRP_CODE}
209 * @rep:displayname Create Assignment Attribute
210 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
211 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
212 * @rep:scope public
213 * @rep:lifecycle active
214 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
215 */
216 --
217 -- {End Of Comments}
218 --
219 procedure create_assignment_attribute
220 (p_validate in boolean default false
221 ,p_effective_date in date
222 ,p_business_group_id in number
223 ,p_effective_start_date out nocopy date
224 ,p_effective_end_date out nocopy date
225 ,p_assignment_id in number
226 ,p_contract_type in varchar2 default null
227 ,p_work_pattern in varchar2 default null
228 ,p_start_day in varchar2 default null
229 ,p_primary_company_car in number default null
230 ,p_primary_car_fuel_benefit in varchar2 default null
231 ,p_primary_capital_contribution in number default null
232 ,p_primary_class_1a in varchar2 default null
233 ,p_secondary_company_car in number default null
234 ,p_secondary_car_fuel_benefit in varchar2 default null
235 ,p_secondary_capital_contributi in number default null
236 ,p_secondary_class_1a in varchar2 default null
237 ,p_company_car_calc_method in varchar2 default null
238 ,p_company_car_rates_table_id in number default null
239 ,p_company_car_secondary_table in number default null
240 ,p_private_car in number default null
241 ,p_private_car_calc_method in varchar2 default null
242 ,p_private_car_rates_table_id in number default null
243 ,p_private_car_essential_table in number default null
244 ,p_primary_private_contribution in number default null
245 ,p_secondary_private_contributi in number default null
246 ,p_tp_is_teacher in varchar2 default null
247 --added for head Teacher seconded location for salary scale calculation
248 ,p_tp_headteacher_grp_code in number default null
249 ,p_tp_safeguarded_grade in varchar2 default null
250 ,p_tp_safeguarded_grade_id in number default null
251 ,p_tp_safeguarded_rate_type in varchar2 default null
252 ,p_tp_safeguarded_rate_id in number default null
253 ,p_tp_spinal_point_id in number default null
254 ,p_tp_elected_pension in varchar2 default null
255 ,p_tp_fast_track in varchar2 default null
256 ,p_aat_attribute_category in varchar2 default null
257 ,p_aat_attribute1 in varchar2 default null
258 ,p_aat_attribute2 in varchar2 default null
259 ,p_aat_attribute3 in varchar2 default null
260 ,p_aat_attribute4 in varchar2 default null
261 ,p_aat_attribute5 in varchar2 default null
262 ,p_aat_attribute6 in varchar2 default null
263 ,p_aat_attribute7 in varchar2 default null
264 ,p_aat_attribute8 in varchar2 default null
265 ,p_aat_attribute9 in varchar2 default null
266 ,p_aat_attribute10 in varchar2 default null
267 ,p_aat_attribute11 in varchar2 default null
268 ,p_aat_attribute12 in varchar2 default null
269 ,p_aat_attribute13 in varchar2 default null
270 ,p_aat_attribute14 in varchar2 default null
271 ,p_aat_attribute15 in varchar2 default null
272 ,p_aat_attribute16 in varchar2 default null
273 ,p_aat_attribute17 in varchar2 default null
274 ,p_aat_attribute18 in varchar2 default null
275 ,p_aat_attribute19 in varchar2 default null
276 ,p_aat_attribute20 in varchar2 default null
277 ,p_aat_information_category in varchar2 default null
278 ,p_aat_information1 in varchar2 default null
279 ,p_aat_information2 in varchar2 default null
280 ,p_aat_information3 in varchar2 default null
281 ,p_aat_information4 in varchar2 default null
282 ,p_aat_information5 in varchar2 default null
283 ,p_aat_information6 in varchar2 default null
284 ,p_aat_information7 in varchar2 default null
285 ,p_aat_information8 in varchar2 default null
286 ,p_aat_information9 in varchar2 default null
287 ,p_aat_information10 in varchar2 default null
288 ,p_aat_information11 in varchar2 default null
289 ,p_aat_information12 in varchar2 default null
290 ,p_aat_information13 in varchar2 default null
291 ,p_aat_information14 in varchar2 default null
292 ,p_aat_information15 in varchar2 default null
293 ,p_aat_information16 in varchar2 default null
294 ,p_aat_information17 in varchar2 default null
295 ,p_aat_information18 in varchar2 default null
296 ,p_aat_information19 in varchar2 default null
297 ,p_aat_information20 in varchar2 default null
298 ,p_lgps_process_flag in varchar2 default null
299 ,p_lgps_exclusion_type in varchar2 default null
300 ,p_lgps_pensionable_pay in varchar2 default null
301 ,p_lgps_trans_arrang_flag in varchar2 default null
302 ,p_lgps_membership_number in varchar2 default null
303 ,p_assignment_attribute_id out nocopy number
304 ,p_object_version_number out nocopy number
305 );
306 --
307 -- ----------------------------------------------------------------------------
308 -- |-----------------------< update_assignment_attribute >--------------------|
309 -- ----------------------------------------------------------------------------
310 --
311 -- {Start Of Comments}
312 /*#
313 * This API updates an assignment attribute record for an employee including
314 * contract types and details of work patterns.
315 *
316 * This package is used to update assignment attributes. These attributes
317 * include contract type and details of work patterns that are mainly used by
318 * public sector. Note: even though there are columns for vehicle information,
319 * these are not used anymore as the new api's pqp_vehicle_repository_api and
320 * pqp_vehicle_allocation_api are used for vehicle repository and allocations
321 * respectively.
322 *
323 * <p><b>Licensing</b><br>
324 * This API is licensed for use with Human Resources.
325 *
326 * <p><b>Prerequisites</b><br>
327 * The employee must have an assignment attribute on the effective date.
328 *
329 * <p><b>Post Success</b><br>
330 * The assignment attributes will be successfully updated in the database.
331 *
332 * <p><b>Post Failure</b><br>
333 * The assignment attributes will not be updated and an error will be raised.
334 * @param p_validate If true, then validation alone will be performed and the
335 * database will remain unchanged. If false and all validation checks pass,
336 * then the database will be modified.
337 * @param p_effective_date Determines when the DateTrack operation comes into
338 * force
339 * @param p_datetrack_mode Indicates which DateTrack mode to use when updating
340 * the record. You must set to either UPDATE, CORRECTION, UPDATE_OVERRIDE or
341 * UPDATE_CHANGE_INSERT. Modes available for use with a particular record
342 * depend on the dates of previous record changes and the effective date of
343 * this change.
344 * @param p_assignment_attribute_id {@rep:casecolumn
345 * PQP_ASSIGNMENT_ATTRIBUTES_F.ASSIGNMENT_ATTRIBUTE_ID}
346 * @param p_business_group_id {@rep:casecolumn
347 * PQP_ASSIGNMENT_ATTRIBUTES_F.BUSINESS_GROUP_ID}
348 * @param p_effective_start_date If p_validate is false, then set to the
349 * effective start date on the updated assignment attribute row which now
350 * exists as of the effective date. If p_validate is true, then set to null.
351 * @param p_effective_end_date If p_validate is false, then set to the
352 * effective end date on the updated assignment attribute row which now exists
353 * as of the effective date. If p_validate is true, then set to null.
354 * @param p_assignment_id Identifies the assignment record to modify.
355 * @param p_contract_type {@rep:casecolumn
356 * PQP_ASSIGNMENT_ATTRIBUTES_F.CONTRACT_TYPE}
357 * @param p_work_pattern {@rep:casecolumn
358 * PQP_ASSIGNMENT_ATTRIBUTES_F.WORK_PATTERN}
359 * @param p_start_day {@rep:casecolumn PQP_ASSIGNMENT_ATTRIBUTES_F.START_DAY}
360 * @param p_primary_company_car {@rep:casecolumn
361 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIMARY_COMPANY_CAR}
362 * @param p_primary_car_fuel_benefit {@rep:casecolumn
363 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIMARY_CAR_FUEL_BENEFIT}
364 * @param p_primary_capital_contribution {@rep:casecolumn
365 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIMARY_CAPITAL_CONTRIBUTION}
366 * @param p_primary_class_1a {@rep:casecolumn
367 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIMARY_CLASS_1A}
368 * @param p_secondary_company_car {@rep:casecolumn
369 * PQP_ASSIGNMENT_ATTRIBUTES_F.SECONDARY_COMPANY_CAR}
370 * @param p_secondary_car_fuel_benefit Indictates whether the secondary company
371 * car is provided with fuel benefit
372 * @param p_secondary_capital_contributi {@rep:casecolumn
373 * PQP_ASSIGNMENT_ATTRIBUTES_F.SECONDARY_CAPITAL_CONTRIBUTION}
374 * @param p_secondary_class_1a {@rep:casecolumn
375 * PQP_ASSIGNMENT_ATTRIBUTES_F.SECONDARY_CLASS_1A}
376 * @param p_company_car_calc_method {@rep:casecolumn
377 * PQP_ASSIGNMENT_ATTRIBUTES_F.COMPANY_CAR_CALC_METHOD}
378 * @param p_company_car_rates_table_id {@rep:casecolumn
379 * PQP_ASSIGNMENT_ATTRIBUTES_F.COMPANY_CAR_RATES_TABLE_ID}
380 * @param p_company_car_secondary_table {@rep:casecolumn
381 * PQP_ASSIGNMENT_ATTRIBUTES_F.COMPANY_CAR_SECONDARY_TABLE_ID}
382 * @param p_private_car {@rep:casecolumn
383 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIVATE_CAR}
384 * @param p_private_car_calc_method {@rep:casecolumn
385 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIVATE_CAR_CALC_METHOD}
386 * @param p_private_car_rates_table_id {@rep:casecolumn
387 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIVATE_CAR_RATES_TABLE_ID}
388 * @param p_private_car_essential_table {@rep:casecolumn
389 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIVATE_CAR_ESSENTIAL_TABLE_ID}
390 * @param p_primary_private_contribution {@rep:casecolumn
391 * PQP_ASSIGNMENT_ATTRIBUTES_F.PRIMARY_PRIVATE_CONTRIBUTION}
392 * @param p_secondary_private_contributi {@rep:casecolumn
393 * PQP_ASSIGNMENT_ATTRIBUTES_F.SECONDARY_PRIVATE_CONTRIBUTION}
394 * @param p_tp_is_teacher {@rep:casecolumn
395 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_IS_TEACHER}
396 * @param p_tp_safeguarded_grade {@rep:casecolumn
397 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_SAFEGUARDED_GRADE}
398 * @param p_tp_safeguarded_grade_id {@rep:casecolumn
399 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_SAFEGUARDED_GRADE_ID}
400 * @param p_tp_safeguarded_rate_type {@rep:casecolumn
401 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_SAFEGUARDED_RATE_TYPE}
402 * @param p_tp_safeguarded_rate_id {@rep:casecolumn
403 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_SAFEGUARDED_RATE_ID}
404 * @param p_tp_spinal_point_id {@rep:casecolumn
405 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_SAFEGUARDED_SPINAL_POINT_ID}
406 * @param p_tp_elected_pension {@rep:casecolumn
407 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_ELECTED_PENSION}
408 * @param p_tp_fast_track {@rep:casecolumn
409 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_FAST_TRACK}
410 * @param p_aat_attribute_category {@rep:casecolumn
411 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE_CATEGORY}
412 * @param p_aat_attribute1 {@rep:casecolumn
413 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE1}
414 * @param p_aat_attribute2 {@rep:casecolumn
415 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE2}
416 * @param p_aat_attribute3 {@rep:casecolumn
417 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE3}
418 * @param p_aat_attribute4 {@rep:casecolumn
419 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE4}
420 * @param p_aat_attribute5 {@rep:casecolumn
421 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE5}
422 * @param p_aat_attribute6 {@rep:casecolumn
423 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE6}
424 * @param p_aat_attribute7 {@rep:casecolumn
425 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE7}
426 * @param p_aat_attribute8 {@rep:casecolumn
427 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE8}
428 * @param p_aat_attribute9 {@rep:casecolumn
429 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE9}
430 * @param p_aat_attribute10 {@rep:casecolumn
431 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE10}
432 * @param p_aat_attribute11 {@rep:casecolumn
433 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE11}
434 * @param p_aat_attribute12 {@rep:casecolumn
435 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE12}
436 * @param p_aat_attribute13 {@rep:casecolumn
437 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE13}
438 * @param p_aat_attribute14 {@rep:casecolumn
439 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE14}
440 * @param p_aat_attribute15 {@rep:casecolumn
441 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE15}
442 * @param p_aat_attribute16 {@rep:casecolumn
443 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE16}
444 * @param p_aat_attribute17 {@rep:casecolumn
445 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE17}
446 * @param p_aat_attribute18 {@rep:casecolumn
447 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE18}
448 * @param p_aat_attribute19 {@rep:casecolumn
449 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE19}
450 * @param p_aat_attribute20 {@rep:casecolumn
451 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_ATTRIBUTE20}
452 * @param p_aat_information_category {@rep:casecolumn
453 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION_CATEGORY}
454 * @param p_aat_information1 {@rep:casecolumn
455 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION1}
456 * @param p_aat_information2 {@rep:casecolumn
457 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION2}
458 * @param p_aat_information3 {@rep:casecolumn
459 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION3}
460 * @param p_aat_information4 {@rep:casecolumn
461 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION4}
462 * @param p_aat_information5 {@rep:casecolumn
463 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION5}
464 * @param p_aat_information6 {@rep:casecolumn
465 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION6}
466 * @param p_aat_information7 {@rep:casecolumn
467 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION7}
468 * @param p_aat_information8 {@rep:casecolumn
469 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION8}
470 * @param p_aat_information9 {@rep:casecolumn
471 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION9}
472 * @param p_aat_information10 {@rep:casecolumn
473 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION10}
474 * @param p_aat_information11 {@rep:casecolumn
475 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION11}
476 * @param p_aat_information12 {@rep:casecolumn
477 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION12}
478 * @param p_aat_information13 {@rep:casecolumn
479 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION13}
480 * @param p_aat_information14 {@rep:casecolumn
481 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION14}
482 * @param p_aat_information15 {@rep:casecolumn
483 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION15}
484 * @param p_aat_information16 {@rep:casecolumn
485 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION16}
486 * @param p_aat_information17 {@rep:casecolumn
487 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION17}
488 * @param p_aat_information18 {@rep:casecolumn
489 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION18}
490 * @param p_aat_information19 {@rep:casecolumn
491 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION19}
492 * @param p_aat_information20 {@rep:casecolumn
493 * PQP_ASSIGNMENT_ATTRIBUTES_F.AAT_INFORMATION20}
494 * @param p_lgps_process_flag {@rep:casecolumn
495 * PQP_ASSIGNMENT_ATTRIBUTES_F.LGPS_PROCESS_FLAG}
496 * @param p_lgps_exclusion_type {@rep:casecolumn
497 * PQP_ASSIGNMENT_ATTRIBUTES_F.LGPS_EXCLUSION_TYPE}
498 * @param p_lgps_pensionable_pay {@rep:casecolumn
499 * PQP_ASSIGNMENT_ATTRIBUTES_F.LGPS_PENSIONABLE_PAY}
500 * @param p_lgps_trans_arrang_flag {@rep:casecolumn
501 * PQP_ASSIGNMENT_ATTRIBUTES_F.LGPS_TRANS_ARRANG_FLAG}
502 * @param p_lgps_membership_number {@rep:casecolumn
503 * PQP_ASSIGNMENT_ATTRIBUTES_F.LGPS_MEMBERSHIP_NUMBER}
504 * @param p_object_version_number Pass in the current version number of the
505 * assignment attribute to be updated. When the API completes, if p_validate is
506 * false then it will be set to the new version number of the updated
507 * assignment attribute. If p_validate is true then it will be set to the same
508 * value which was passed in.
509 * @param p_tp_headteacher_grp_code {@rep:casecolumn
510 * PQP_ASSIGNMENT_ATTRIBUTES_F.TP_HEADTEACHER_GRP_CODE}
511 * @rep:displayname Update Assignment Attribute
512 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
513 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
514 * @rep:scope public
515 * @rep:lifecycle active
516 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
517 */
518 --
519 -- {End Of Comments}
520 --
521 procedure update_assignment_attribute
522 (p_validate in boolean default false
523 ,p_effective_date in date
524 ,p_datetrack_mode in varchar2
525 ,p_assignment_attribute_id in number
526 ,p_business_group_id in number
527 ,p_effective_start_date out nocopy date
528 ,p_effective_end_date out nocopy date
529 ,p_assignment_id in number default hr_api.g_number
530 ,p_contract_type in varchar2 default hr_api.g_varchar2
531 ,p_work_pattern in varchar2 default hr_api.g_varchar2
532 ,p_start_day in varchar2 default hr_api.g_varchar2
533 ,p_primary_company_car in number default hr_api.g_number
534 ,p_primary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
535 ,p_primary_capital_contribution in number default hr_api.g_number
536 ,p_primary_class_1a in varchar2 default hr_api.g_varchar2
537 ,p_secondary_company_car in number default hr_api.g_number
538 ,p_secondary_car_fuel_benefit in varchar2 default hr_api.g_varchar2
539 ,p_secondary_capital_contributi in number default hr_api.g_number
540 ,p_secondary_class_1a in varchar2 default hr_api.g_varchar2
541 ,p_company_car_calc_method in varchar2 default hr_api.g_varchar2
542 ,p_company_car_rates_table_id in number default hr_api.g_number
543 ,p_company_car_secondary_table in number default hr_api.g_number
544 ,p_private_car in number default hr_api.g_number
545 ,p_private_car_calc_method in varchar2 default hr_api.g_varchar2
546 ,p_private_car_rates_table_id in number default hr_api.g_number
547 ,p_private_car_essential_table in number default hr_api.g_number
548 ,p_primary_private_contribution in number default hr_api.g_number
549 ,p_secondary_private_contributi in number default hr_api.g_number
550 ,p_tp_is_teacher in varchar2 default hr_api.g_varchar2
551 ,p_tp_headteacher_grp_code in number default hr_api.g_number --added for head Teacher seconded location for salary scale calculation
552 ,p_tp_safeguarded_grade in varchar2 default hr_api.g_varchar2
553 ,p_tp_safeguarded_grade_id in number default hr_api.g_number
554 ,p_tp_safeguarded_rate_type in varchar2 default hr_api.g_varchar2
555 ,p_tp_safeguarded_rate_id in number default hr_api.g_number
556 ,p_tp_spinal_point_id in number default hr_api.g_number
557 ,p_tp_elected_pension in varchar2 default hr_api.g_varchar2
558 ,p_tp_fast_track in varchar2 default hr_api.g_varchar2
559 ,p_aat_attribute_category in varchar2 default hr_api.g_varchar2
560 ,p_aat_attribute1 in varchar2 default hr_api.g_varchar2
561 ,p_aat_attribute2 in varchar2 default hr_api.g_varchar2
562 ,p_aat_attribute3 in varchar2 default hr_api.g_varchar2
563 ,p_aat_attribute4 in varchar2 default hr_api.g_varchar2
564 ,p_aat_attribute5 in varchar2 default hr_api.g_varchar2
565 ,p_aat_attribute6 in varchar2 default hr_api.g_varchar2
566 ,p_aat_attribute7 in varchar2 default hr_api.g_varchar2
567 ,p_aat_attribute8 in varchar2 default hr_api.g_varchar2
568 ,p_aat_attribute9 in varchar2 default hr_api.g_varchar2
569 ,p_aat_attribute10 in varchar2 default hr_api.g_varchar2
570 ,p_aat_attribute11 in varchar2 default hr_api.g_varchar2
571 ,p_aat_attribute12 in varchar2 default hr_api.g_varchar2
572 ,p_aat_attribute13 in varchar2 default hr_api.g_varchar2
573 ,p_aat_attribute14 in varchar2 default hr_api.g_varchar2
574 ,p_aat_attribute15 in varchar2 default hr_api.g_varchar2
575 ,p_aat_attribute16 in varchar2 default hr_api.g_varchar2
576 ,p_aat_attribute17 in varchar2 default hr_api.g_varchar2
577 ,p_aat_attribute18 in varchar2 default hr_api.g_varchar2
578 ,p_aat_attribute19 in varchar2 default hr_api.g_varchar2
579 ,p_aat_attribute20 in varchar2 default hr_api.g_varchar2
580 ,p_aat_information_category in varchar2 default hr_api.g_varchar2
581 ,p_aat_information1 in varchar2 default hr_api.g_varchar2
582 ,p_aat_information2 in varchar2 default hr_api.g_varchar2
583 ,p_aat_information3 in varchar2 default hr_api.g_varchar2
584 ,p_aat_information4 in varchar2 default hr_api.g_varchar2
585 ,p_aat_information5 in varchar2 default hr_api.g_varchar2
586 ,p_aat_information6 in varchar2 default hr_api.g_varchar2
587 ,p_aat_information7 in varchar2 default hr_api.g_varchar2
588 ,p_aat_information8 in varchar2 default hr_api.g_varchar2
589 ,p_aat_information9 in varchar2 default hr_api.g_varchar2
590 ,p_aat_information10 in varchar2 default hr_api.g_varchar2
591 ,p_aat_information11 in varchar2 default hr_api.g_varchar2
592 ,p_aat_information12 in varchar2 default hr_api.g_varchar2
593 ,p_aat_information13 in varchar2 default hr_api.g_varchar2
594 ,p_aat_information14 in varchar2 default hr_api.g_varchar2
595 ,p_aat_information15 in varchar2 default hr_api.g_varchar2
596 ,p_aat_information16 in varchar2 default hr_api.g_varchar2
597 ,p_aat_information17 in varchar2 default hr_api.g_varchar2
598 ,p_aat_information18 in varchar2 default hr_api.g_varchar2
599 ,p_aat_information19 in varchar2 default hr_api.g_varchar2
600 ,p_aat_information20 in varchar2 default hr_api.g_varchar2
601 ,p_lgps_process_flag in varchar2 default hr_api.g_varchar2
602 ,p_lgps_exclusion_type in varchar2 default hr_api.g_varchar2
603 ,p_lgps_pensionable_pay in varchar2 default hr_api.g_varchar2
604 ,p_lgps_trans_arrang_flag in varchar2 default hr_api.g_varchar2
605 ,p_lgps_membership_number in varchar2 default hr_api.g_varchar2
606 ,p_object_version_number in out nocopy number
607 );
608 --
609 -- ----------------------------------------------------------------------------
610 -- |-----------------------< delete_assignment_attribute >--------------------|
611 -- ----------------------------------------------------------------------------
612 --
613 -- {Start Of Comments}
614 /*#
615 * This API deletes an assignment attribute like the contract types and details
616 * of work patterns.
617 *
618 * Assignment attributes are deleted for the employee assignment.
619 *
620 * <p><b>Licensing</b><br>
621 * This API is licensed for use with Human Resources.
622 *
623 * <p><b>Prerequisites</b><br>
624 * The employee must have an assignment attribute on the effective date.
625 *
626 * <p><b>Post Success</b><br>
627 * The assignment attributes will be successfully deleted from the database.
628 *
632 * database will remain unchanged. If false and all validation checks pass,
629 * <p><b>Post Failure</b><br>
630 * The assignment attributes will not be deleted and an error will be raised.
631 * @param p_validate If true, then validation alone will be performed and the
633 * then the database will be modified.
634 * @param p_effective_date Determines when the DateTrack operation comes into
635 * force.
636 * @param p_datetrack_mode Indicates which DateTrack mode to use when deleting
637 * the record. You must set to either ZAP, DELETE, FUTURE_CHANGE or
638 * DELETE_NEXT_CHANGE. Modes available for use with a particular record depend
639 * on the dates of previous record changes and the effective date of this
640 * change.
641 * @param p_business_group_id {@rep:casecolumn
642 * PQP_ASSIGNMENT_ATTRIBUTES_F.BUSINESS_GROUP_ID}
643 * @param p_assignment_attribute_id {@rep:casecolumn
644 * PQP_ASSIGNMENT_ATTRIBUTES_F.ASSIGNMENT_ATTRIBUTE_ID}
645 * @param p_effective_start_date If p_validate is false, then set to the
646 * effective start date for the deleted assignment attribute row which now
647 * exists as of the effective date. If p_validate is true or all row instances
648 * have been deleted then set to null.
649 * @param p_effective_end_date If p_validate is false, then set to the
650 * effective end date for the deleted assignment attribute row which now exists
651 * as of the effective date. If p_validate is true or all row instances have
652 * been deleted then set to null.
653 * @param p_object_version_number Current version number of the assignment
654 * attribute to be deleted.
655 * @rep:displayname Delete Assignment Attribute
656 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
657 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
658 * @rep:scope public
659 * @rep:lifecycle active
660 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
661 */
662 --
663 -- {End Of Comments}
664 --
665 procedure delete_assignment_attribute
666 (p_validate in boolean default false
667 ,p_effective_date in date
668 ,p_datetrack_mode in varchar2
669 ,p_business_group_id in number
670 ,p_assignment_attribute_id in number
671 ,p_effective_start_date out nocopy date
672 ,p_effective_end_date out nocopy date
673 ,p_object_version_number in out nocopy number
674 );
675 --
676 end pqp_aat_api;
[Home] [Help]