50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_bpr_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
111: --
112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: per_bpr_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: per_bpr_shd.constraint_error
115: per_bpr_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: per_bpr_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: per_bpr_shd.constraint_error
119: per_bpr_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: per_bpr_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: Raise;
127: End update_dml;
157: -- Internal Row Handler Use Only.
158: --
159: -- {End Of Comments}
160: -- ----------------------------------------------------------------------------
161: Procedure pre_update(p_rec in per_bpr_shd.g_rec_type) is
162: --
163: l_proc varchar2(72) := g_package||'pre_update';
164: --
165: Begin
200: --
201: -- {End Of Comments}
202: -- ----------------------------------------------------------------------------
203: Procedure post_update(p_effective_date in date,
204: p_rec in per_bpr_shd.g_rec_type) is
205: --
206: l_proc varchar2(72) := g_package||'post_update';
207: --
208: Begin
248: p_bpr_attribute28 => p_rec.bpr_attribute28,
249: p_bpr_attribute29 => p_rec.bpr_attribute29,
250: p_bpr_attribute30 => p_rec.bpr_attribute30,
251: p_payroll_id_o
252: => per_bpr_shd.g_old_rec.payroll_id,
253: p_business_group_id_o
254: => per_bpr_shd.g_old_rec.business_group_id,
255: p_payroll_identifier_o
256: => per_bpr_shd.g_old_rec.payroll_identifier,
250: p_bpr_attribute30 => p_rec.bpr_attribute30,
251: p_payroll_id_o
252: => per_bpr_shd.g_old_rec.payroll_id,
253: p_business_group_id_o
254: => per_bpr_shd.g_old_rec.business_group_id,
255: p_payroll_identifier_o
256: => per_bpr_shd.g_old_rec.payroll_identifier,
257: p_period_start_date_o
258: => per_bpr_shd.g_old_rec.period_start_date,
252: => per_bpr_shd.g_old_rec.payroll_id,
253: p_business_group_id_o
254: => per_bpr_shd.g_old_rec.business_group_id,
255: p_payroll_identifier_o
256: => per_bpr_shd.g_old_rec.payroll_identifier,
257: p_period_start_date_o
258: => per_bpr_shd.g_old_rec.period_start_date,
259: p_period_end_date_o
260: => per_bpr_shd.g_old_rec.period_end_date,
254: => per_bpr_shd.g_old_rec.business_group_id,
255: p_payroll_identifier_o
256: => per_bpr_shd.g_old_rec.payroll_identifier,
257: p_period_start_date_o
258: => per_bpr_shd.g_old_rec.period_start_date,
259: p_period_end_date_o
260: => per_bpr_shd.g_old_rec.period_end_date,
261: p_processing_date_o
262: => per_bpr_shd.g_old_rec.processing_date,
256: => per_bpr_shd.g_old_rec.payroll_identifier,
257: p_period_start_date_o
258: => per_bpr_shd.g_old_rec.period_start_date,
259: p_period_end_date_o
260: => per_bpr_shd.g_old_rec.period_end_date,
261: p_processing_date_o
262: => per_bpr_shd.g_old_rec.processing_date,
263: p_object_version_number_o
264: => per_bpr_shd.g_old_rec.object_version_number,
258: => per_bpr_shd.g_old_rec.period_start_date,
259: p_period_end_date_o
260: => per_bpr_shd.g_old_rec.period_end_date,
261: p_processing_date_o
262: => per_bpr_shd.g_old_rec.processing_date,
263: p_object_version_number_o
264: => per_bpr_shd.g_old_rec.object_version_number,
265: p_bpr_attribute_category_o
266: => per_bpr_shd.g_old_rec.bpr_attribute_category,
260: => per_bpr_shd.g_old_rec.period_end_date,
261: p_processing_date_o
262: => per_bpr_shd.g_old_rec.processing_date,
263: p_object_version_number_o
264: => per_bpr_shd.g_old_rec.object_version_number,
265: p_bpr_attribute_category_o
266: => per_bpr_shd.g_old_rec.bpr_attribute_category,
267: p_bpr_attribute1_o
268: => per_bpr_shd.g_old_rec.bpr_attribute1,
262: => per_bpr_shd.g_old_rec.processing_date,
263: p_object_version_number_o
264: => per_bpr_shd.g_old_rec.object_version_number,
265: p_bpr_attribute_category_o
266: => per_bpr_shd.g_old_rec.bpr_attribute_category,
267: p_bpr_attribute1_o
268: => per_bpr_shd.g_old_rec.bpr_attribute1,
269: p_bpr_attribute2_o
270: => per_bpr_shd.g_old_rec.bpr_attribute2,
264: => per_bpr_shd.g_old_rec.object_version_number,
265: p_bpr_attribute_category_o
266: => per_bpr_shd.g_old_rec.bpr_attribute_category,
267: p_bpr_attribute1_o
268: => per_bpr_shd.g_old_rec.bpr_attribute1,
269: p_bpr_attribute2_o
270: => per_bpr_shd.g_old_rec.bpr_attribute2,
271: p_bpr_attribute3_o
272: => per_bpr_shd.g_old_rec.bpr_attribute3,
266: => per_bpr_shd.g_old_rec.bpr_attribute_category,
267: p_bpr_attribute1_o
268: => per_bpr_shd.g_old_rec.bpr_attribute1,
269: p_bpr_attribute2_o
270: => per_bpr_shd.g_old_rec.bpr_attribute2,
271: p_bpr_attribute3_o
272: => per_bpr_shd.g_old_rec.bpr_attribute3,
273: p_bpr_attribute4_o
274: => per_bpr_shd.g_old_rec.bpr_attribute4,
268: => per_bpr_shd.g_old_rec.bpr_attribute1,
269: p_bpr_attribute2_o
270: => per_bpr_shd.g_old_rec.bpr_attribute2,
271: p_bpr_attribute3_o
272: => per_bpr_shd.g_old_rec.bpr_attribute3,
273: p_bpr_attribute4_o
274: => per_bpr_shd.g_old_rec.bpr_attribute4,
275: p_bpr_attribute5_o
276: => per_bpr_shd.g_old_rec.bpr_attribute5,
270: => per_bpr_shd.g_old_rec.bpr_attribute2,
271: p_bpr_attribute3_o
272: => per_bpr_shd.g_old_rec.bpr_attribute3,
273: p_bpr_attribute4_o
274: => per_bpr_shd.g_old_rec.bpr_attribute4,
275: p_bpr_attribute5_o
276: => per_bpr_shd.g_old_rec.bpr_attribute5,
277: p_bpr_attribute6_o
278: => per_bpr_shd.g_old_rec.bpr_attribute6,
272: => per_bpr_shd.g_old_rec.bpr_attribute3,
273: p_bpr_attribute4_o
274: => per_bpr_shd.g_old_rec.bpr_attribute4,
275: p_bpr_attribute5_o
276: => per_bpr_shd.g_old_rec.bpr_attribute5,
277: p_bpr_attribute6_o
278: => per_bpr_shd.g_old_rec.bpr_attribute6,
279: p_bpr_attribute7_o
280: => per_bpr_shd.g_old_rec.bpr_attribute7,
274: => per_bpr_shd.g_old_rec.bpr_attribute4,
275: p_bpr_attribute5_o
276: => per_bpr_shd.g_old_rec.bpr_attribute5,
277: p_bpr_attribute6_o
278: => per_bpr_shd.g_old_rec.bpr_attribute6,
279: p_bpr_attribute7_o
280: => per_bpr_shd.g_old_rec.bpr_attribute7,
281: p_bpr_attribute8_o
282: => per_bpr_shd.g_old_rec.bpr_attribute8,
276: => per_bpr_shd.g_old_rec.bpr_attribute5,
277: p_bpr_attribute6_o
278: => per_bpr_shd.g_old_rec.bpr_attribute6,
279: p_bpr_attribute7_o
280: => per_bpr_shd.g_old_rec.bpr_attribute7,
281: p_bpr_attribute8_o
282: => per_bpr_shd.g_old_rec.bpr_attribute8,
283: p_bpr_attribute9_o
284: => per_bpr_shd.g_old_rec.bpr_attribute9,
278: => per_bpr_shd.g_old_rec.bpr_attribute6,
279: p_bpr_attribute7_o
280: => per_bpr_shd.g_old_rec.bpr_attribute7,
281: p_bpr_attribute8_o
282: => per_bpr_shd.g_old_rec.bpr_attribute8,
283: p_bpr_attribute9_o
284: => per_bpr_shd.g_old_rec.bpr_attribute9,
285: p_bpr_attribute10_o
286: => per_bpr_shd.g_old_rec.bpr_attribute10,
280: => per_bpr_shd.g_old_rec.bpr_attribute7,
281: p_bpr_attribute8_o
282: => per_bpr_shd.g_old_rec.bpr_attribute8,
283: p_bpr_attribute9_o
284: => per_bpr_shd.g_old_rec.bpr_attribute9,
285: p_bpr_attribute10_o
286: => per_bpr_shd.g_old_rec.bpr_attribute10,
287: p_bpr_attribute11_o
288: => per_bpr_shd.g_old_rec.bpr_attribute11,
282: => per_bpr_shd.g_old_rec.bpr_attribute8,
283: p_bpr_attribute9_o
284: => per_bpr_shd.g_old_rec.bpr_attribute9,
285: p_bpr_attribute10_o
286: => per_bpr_shd.g_old_rec.bpr_attribute10,
287: p_bpr_attribute11_o
288: => per_bpr_shd.g_old_rec.bpr_attribute11,
289: p_bpr_attribute12_o
290: => per_bpr_shd.g_old_rec.bpr_attribute12,
284: => per_bpr_shd.g_old_rec.bpr_attribute9,
285: p_bpr_attribute10_o
286: => per_bpr_shd.g_old_rec.bpr_attribute10,
287: p_bpr_attribute11_o
288: => per_bpr_shd.g_old_rec.bpr_attribute11,
289: p_bpr_attribute12_o
290: => per_bpr_shd.g_old_rec.bpr_attribute12,
291: p_bpr_attribute13_o
292: => per_bpr_shd.g_old_rec.bpr_attribute13,
286: => per_bpr_shd.g_old_rec.bpr_attribute10,
287: p_bpr_attribute11_o
288: => per_bpr_shd.g_old_rec.bpr_attribute11,
289: p_bpr_attribute12_o
290: => per_bpr_shd.g_old_rec.bpr_attribute12,
291: p_bpr_attribute13_o
292: => per_bpr_shd.g_old_rec.bpr_attribute13,
293: p_bpr_attribute14_o
294: => per_bpr_shd.g_old_rec.bpr_attribute14,
288: => per_bpr_shd.g_old_rec.bpr_attribute11,
289: p_bpr_attribute12_o
290: => per_bpr_shd.g_old_rec.bpr_attribute12,
291: p_bpr_attribute13_o
292: => per_bpr_shd.g_old_rec.bpr_attribute13,
293: p_bpr_attribute14_o
294: => per_bpr_shd.g_old_rec.bpr_attribute14,
295: p_bpr_attribute15_o
296: => per_bpr_shd.g_old_rec.bpr_attribute15,
290: => per_bpr_shd.g_old_rec.bpr_attribute12,
291: p_bpr_attribute13_o
292: => per_bpr_shd.g_old_rec.bpr_attribute13,
293: p_bpr_attribute14_o
294: => per_bpr_shd.g_old_rec.bpr_attribute14,
295: p_bpr_attribute15_o
296: => per_bpr_shd.g_old_rec.bpr_attribute15,
297: p_bpr_attribute16_o
298: => per_bpr_shd.g_old_rec.bpr_attribute16,
292: => per_bpr_shd.g_old_rec.bpr_attribute13,
293: p_bpr_attribute14_o
294: => per_bpr_shd.g_old_rec.bpr_attribute14,
295: p_bpr_attribute15_o
296: => per_bpr_shd.g_old_rec.bpr_attribute15,
297: p_bpr_attribute16_o
298: => per_bpr_shd.g_old_rec.bpr_attribute16,
299: p_bpr_attribute17_o
300: => per_bpr_shd.g_old_rec.bpr_attribute17,
294: => per_bpr_shd.g_old_rec.bpr_attribute14,
295: p_bpr_attribute15_o
296: => per_bpr_shd.g_old_rec.bpr_attribute15,
297: p_bpr_attribute16_o
298: => per_bpr_shd.g_old_rec.bpr_attribute16,
299: p_bpr_attribute17_o
300: => per_bpr_shd.g_old_rec.bpr_attribute17,
301: p_bpr_attribute18_o
302: => per_bpr_shd.g_old_rec.bpr_attribute18,
296: => per_bpr_shd.g_old_rec.bpr_attribute15,
297: p_bpr_attribute16_o
298: => per_bpr_shd.g_old_rec.bpr_attribute16,
299: p_bpr_attribute17_o
300: => per_bpr_shd.g_old_rec.bpr_attribute17,
301: p_bpr_attribute18_o
302: => per_bpr_shd.g_old_rec.bpr_attribute18,
303: p_bpr_attribute19_o
304: => per_bpr_shd.g_old_rec.bpr_attribute19,
298: => per_bpr_shd.g_old_rec.bpr_attribute16,
299: p_bpr_attribute17_o
300: => per_bpr_shd.g_old_rec.bpr_attribute17,
301: p_bpr_attribute18_o
302: => per_bpr_shd.g_old_rec.bpr_attribute18,
303: p_bpr_attribute19_o
304: => per_bpr_shd.g_old_rec.bpr_attribute19,
305: p_bpr_attribute20_o
306: => per_bpr_shd.g_old_rec.bpr_attribute20,
300: => per_bpr_shd.g_old_rec.bpr_attribute17,
301: p_bpr_attribute18_o
302: => per_bpr_shd.g_old_rec.bpr_attribute18,
303: p_bpr_attribute19_o
304: => per_bpr_shd.g_old_rec.bpr_attribute19,
305: p_bpr_attribute20_o
306: => per_bpr_shd.g_old_rec.bpr_attribute20,
307: p_bpr_attribute21_o
308: => per_bpr_shd.g_old_rec.bpr_attribute21,
302: => per_bpr_shd.g_old_rec.bpr_attribute18,
303: p_bpr_attribute19_o
304: => per_bpr_shd.g_old_rec.bpr_attribute19,
305: p_bpr_attribute20_o
306: => per_bpr_shd.g_old_rec.bpr_attribute20,
307: p_bpr_attribute21_o
308: => per_bpr_shd.g_old_rec.bpr_attribute21,
309: p_bpr_attribute22_o
310: => per_bpr_shd.g_old_rec.bpr_attribute22,
304: => per_bpr_shd.g_old_rec.bpr_attribute19,
305: p_bpr_attribute20_o
306: => per_bpr_shd.g_old_rec.bpr_attribute20,
307: p_bpr_attribute21_o
308: => per_bpr_shd.g_old_rec.bpr_attribute21,
309: p_bpr_attribute22_o
310: => per_bpr_shd.g_old_rec.bpr_attribute22,
311: p_bpr_attribute23_o
312: => per_bpr_shd.g_old_rec.bpr_attribute23,
306: => per_bpr_shd.g_old_rec.bpr_attribute20,
307: p_bpr_attribute21_o
308: => per_bpr_shd.g_old_rec.bpr_attribute21,
309: p_bpr_attribute22_o
310: => per_bpr_shd.g_old_rec.bpr_attribute22,
311: p_bpr_attribute23_o
312: => per_bpr_shd.g_old_rec.bpr_attribute23,
313: p_bpr_attribute24_o
314: => per_bpr_shd.g_old_rec.bpr_attribute24,
308: => per_bpr_shd.g_old_rec.bpr_attribute21,
309: p_bpr_attribute22_o
310: => per_bpr_shd.g_old_rec.bpr_attribute22,
311: p_bpr_attribute23_o
312: => per_bpr_shd.g_old_rec.bpr_attribute23,
313: p_bpr_attribute24_o
314: => per_bpr_shd.g_old_rec.bpr_attribute24,
315: p_bpr_attribute25_o
316: => per_bpr_shd.g_old_rec.bpr_attribute25,
310: => per_bpr_shd.g_old_rec.bpr_attribute22,
311: p_bpr_attribute23_o
312: => per_bpr_shd.g_old_rec.bpr_attribute23,
313: p_bpr_attribute24_o
314: => per_bpr_shd.g_old_rec.bpr_attribute24,
315: p_bpr_attribute25_o
316: => per_bpr_shd.g_old_rec.bpr_attribute25,
317: p_bpr_attribute26_o
318: => per_bpr_shd.g_old_rec.bpr_attribute26,
312: => per_bpr_shd.g_old_rec.bpr_attribute23,
313: p_bpr_attribute24_o
314: => per_bpr_shd.g_old_rec.bpr_attribute24,
315: p_bpr_attribute25_o
316: => per_bpr_shd.g_old_rec.bpr_attribute25,
317: p_bpr_attribute26_o
318: => per_bpr_shd.g_old_rec.bpr_attribute26,
319: p_bpr_attribute27_o
320: => per_bpr_shd.g_old_rec.bpr_attribute27,
314: => per_bpr_shd.g_old_rec.bpr_attribute24,
315: p_bpr_attribute25_o
316: => per_bpr_shd.g_old_rec.bpr_attribute25,
317: p_bpr_attribute26_o
318: => per_bpr_shd.g_old_rec.bpr_attribute26,
319: p_bpr_attribute27_o
320: => per_bpr_shd.g_old_rec.bpr_attribute27,
321: p_bpr_attribute28_o
322: => per_bpr_shd.g_old_rec.bpr_attribute28,
316: => per_bpr_shd.g_old_rec.bpr_attribute25,
317: p_bpr_attribute26_o
318: => per_bpr_shd.g_old_rec.bpr_attribute26,
319: p_bpr_attribute27_o
320: => per_bpr_shd.g_old_rec.bpr_attribute27,
321: p_bpr_attribute28_o
322: => per_bpr_shd.g_old_rec.bpr_attribute28,
323: p_bpr_attribute29_o
324: => per_bpr_shd.g_old_rec.bpr_attribute29,
318: => per_bpr_shd.g_old_rec.bpr_attribute26,
319: p_bpr_attribute27_o
320: => per_bpr_shd.g_old_rec.bpr_attribute27,
321: p_bpr_attribute28_o
322: => per_bpr_shd.g_old_rec.bpr_attribute28,
323: p_bpr_attribute29_o
324: => per_bpr_shd.g_old_rec.bpr_attribute29,
325: p_bpr_attribute30_o
326: => per_bpr_shd.g_old_rec.bpr_attribute30
320: => per_bpr_shd.g_old_rec.bpr_attribute27,
321: p_bpr_attribute28_o
322: => per_bpr_shd.g_old_rec.bpr_attribute28,
323: p_bpr_attribute29_o
324: => per_bpr_shd.g_old_rec.bpr_attribute29,
325: p_bpr_attribute30_o
326: => per_bpr_shd.g_old_rec.bpr_attribute30
327: );
328: --
322: => per_bpr_shd.g_old_rec.bpr_attribute28,
323: p_bpr_attribute29_o
324: => per_bpr_shd.g_old_rec.bpr_attribute29,
325: p_bpr_attribute30_o
326: => per_bpr_shd.g_old_rec.bpr_attribute30
327: );
328: --
329: exception
330: --
381: -- Internal Row Handler Use Only.
382: --
383: -- {End Of Comments}
384: -- ----------------------------------------------------------------------------
385: Procedure convert_defs(p_rec in out nocopy per_bpr_shd.g_rec_type) is
386: --
387: l_proc varchar2(72) := g_package||'convert_defs';
388: --
389: Begin
396: -- is being used then we must set to the 'current' argument value.
397: --
398: If (p_rec.payroll_id = hr_api.g_number) then
399: p_rec.payroll_id :=
400: per_bpr_shd.g_old_rec.payroll_id;
401: End If;
402: If (p_rec.business_group_id = hr_api.g_number) then
403: p_rec.business_group_id :=
404: per_bpr_shd.g_old_rec.business_group_id;
400: per_bpr_shd.g_old_rec.payroll_id;
401: End If;
402: If (p_rec.business_group_id = hr_api.g_number) then
403: p_rec.business_group_id :=
404: per_bpr_shd.g_old_rec.business_group_id;
405: End If;
406: If (p_rec.payroll_identifier = hr_api.g_varchar2) then
407: p_rec.payroll_identifier :=
408: per_bpr_shd.g_old_rec.payroll_identifier;
404: per_bpr_shd.g_old_rec.business_group_id;
405: End If;
406: If (p_rec.payroll_identifier = hr_api.g_varchar2) then
407: p_rec.payroll_identifier :=
408: per_bpr_shd.g_old_rec.payroll_identifier;
409: End If;
410: If (p_rec.period_start_date = hr_api.g_date) then
411: p_rec.period_start_date :=
412: per_bpr_shd.g_old_rec.period_start_date;
408: per_bpr_shd.g_old_rec.payroll_identifier;
409: End If;
410: If (p_rec.period_start_date = hr_api.g_date) then
411: p_rec.period_start_date :=
412: per_bpr_shd.g_old_rec.period_start_date;
413: End If;
414: If (p_rec.period_end_date = hr_api.g_date) then
415: p_rec.period_end_date :=
416: per_bpr_shd.g_old_rec.period_end_date;
412: per_bpr_shd.g_old_rec.period_start_date;
413: End If;
414: If (p_rec.period_end_date = hr_api.g_date) then
415: p_rec.period_end_date :=
416: per_bpr_shd.g_old_rec.period_end_date;
417: End If;
418: If (p_rec.processing_date = hr_api.g_date) then
419: p_rec.processing_date :=
420: per_bpr_shd.g_old_rec.processing_date;
416: per_bpr_shd.g_old_rec.period_end_date;
417: End If;
418: If (p_rec.processing_date = hr_api.g_date) then
419: p_rec.processing_date :=
420: per_bpr_shd.g_old_rec.processing_date;
421: End If;
422: If (p_rec.bpr_attribute_category = hr_api.g_varchar2) then
423: p_rec.bpr_attribute_category :=
424: per_bpr_shd.g_old_rec.bpr_attribute_category;
420: per_bpr_shd.g_old_rec.processing_date;
421: End If;
422: If (p_rec.bpr_attribute_category = hr_api.g_varchar2) then
423: p_rec.bpr_attribute_category :=
424: per_bpr_shd.g_old_rec.bpr_attribute_category;
425: End If;
426: If (p_rec.bpr_attribute1 = hr_api.g_varchar2) then
427: p_rec.bpr_attribute1:=
428: per_bpr_shd.g_old_rec.bpr_attribute1;
424: per_bpr_shd.g_old_rec.bpr_attribute_category;
425: End If;
426: If (p_rec.bpr_attribute1 = hr_api.g_varchar2) then
427: p_rec.bpr_attribute1:=
428: per_bpr_shd.g_old_rec.bpr_attribute1;
429: End If;
430: If (p_rec.bpr_attribute2 = hr_api.g_varchar2) then
431: p_rec.bpr_attribute2:=
432: per_bpr_shd.g_old_rec.bpr_attribute2;
428: per_bpr_shd.g_old_rec.bpr_attribute1;
429: End If;
430: If (p_rec.bpr_attribute2 = hr_api.g_varchar2) then
431: p_rec.bpr_attribute2:=
432: per_bpr_shd.g_old_rec.bpr_attribute2;
433: End If;
434: If (p_rec.bpr_attribute3 = hr_api.g_varchar2) then
435: p_rec.bpr_attribute3:=
436: per_bpr_shd.g_old_rec.bpr_attribute3;
432: per_bpr_shd.g_old_rec.bpr_attribute2;
433: End If;
434: If (p_rec.bpr_attribute3 = hr_api.g_varchar2) then
435: p_rec.bpr_attribute3:=
436: per_bpr_shd.g_old_rec.bpr_attribute3;
437: End If;
438: If (p_rec.bpr_attribute4 = hr_api.g_varchar2) then
439: p_rec.bpr_attribute4:=
440: per_bpr_shd.g_old_rec.bpr_attribute4;
436: per_bpr_shd.g_old_rec.bpr_attribute3;
437: End If;
438: If (p_rec.bpr_attribute4 = hr_api.g_varchar2) then
439: p_rec.bpr_attribute4:=
440: per_bpr_shd.g_old_rec.bpr_attribute4;
441: End If;
442: If (p_rec.bpr_attribute5 = hr_api.g_varchar2) then
443: p_rec.bpr_attribute5:=
444: per_bpr_shd.g_old_rec.bpr_attribute5;
440: per_bpr_shd.g_old_rec.bpr_attribute4;
441: End If;
442: If (p_rec.bpr_attribute5 = hr_api.g_varchar2) then
443: p_rec.bpr_attribute5:=
444: per_bpr_shd.g_old_rec.bpr_attribute5;
445: End If;
446: If (p_rec.bpr_attribute6 = hr_api.g_varchar2) then
447: p_rec.bpr_attribute6:=
448: per_bpr_shd.g_old_rec.bpr_attribute6;
444: per_bpr_shd.g_old_rec.bpr_attribute5;
445: End If;
446: If (p_rec.bpr_attribute6 = hr_api.g_varchar2) then
447: p_rec.bpr_attribute6:=
448: per_bpr_shd.g_old_rec.bpr_attribute6;
449: End If;
450: If (p_rec.bpr_attribute7 = hr_api.g_varchar2) then
451: p_rec.bpr_attribute7:=
452: per_bpr_shd.g_old_rec.bpr_attribute7;
448: per_bpr_shd.g_old_rec.bpr_attribute6;
449: End If;
450: If (p_rec.bpr_attribute7 = hr_api.g_varchar2) then
451: p_rec.bpr_attribute7:=
452: per_bpr_shd.g_old_rec.bpr_attribute7;
453: End If;
454: If (p_rec.bpr_attribute8 = hr_api.g_varchar2) then
455: p_rec.bpr_attribute8:=
456: per_bpr_shd.g_old_rec.bpr_attribute8;
452: per_bpr_shd.g_old_rec.bpr_attribute7;
453: End If;
454: If (p_rec.bpr_attribute8 = hr_api.g_varchar2) then
455: p_rec.bpr_attribute8:=
456: per_bpr_shd.g_old_rec.bpr_attribute8;
457: End If;
458: If (p_rec.bpr_attribute9 = hr_api.g_varchar2) then
459: p_rec.bpr_attribute9:=
460: per_bpr_shd.g_old_rec.bpr_attribute9;
456: per_bpr_shd.g_old_rec.bpr_attribute8;
457: End If;
458: If (p_rec.bpr_attribute9 = hr_api.g_varchar2) then
459: p_rec.bpr_attribute9:=
460: per_bpr_shd.g_old_rec.bpr_attribute9;
461: End If;
462: If (p_rec.bpr_attribute10 = hr_api.g_varchar2) then
463: p_rec.bpr_attribute10:=
464: per_bpr_shd.g_old_rec.bpr_attribute10;
460: per_bpr_shd.g_old_rec.bpr_attribute9;
461: End If;
462: If (p_rec.bpr_attribute10 = hr_api.g_varchar2) then
463: p_rec.bpr_attribute10:=
464: per_bpr_shd.g_old_rec.bpr_attribute10;
465: End If;
466: If (p_rec.bpr_attribute11 = hr_api.g_varchar2) then
467: p_rec.bpr_attribute11:=
468: per_bpr_shd.g_old_rec.bpr_attribute11;
464: per_bpr_shd.g_old_rec.bpr_attribute10;
465: End If;
466: If (p_rec.bpr_attribute11 = hr_api.g_varchar2) then
467: p_rec.bpr_attribute11:=
468: per_bpr_shd.g_old_rec.bpr_attribute11;
469: End If;
470: If (p_rec.bpr_attribute12 = hr_api.g_varchar2) then
471: p_rec.bpr_attribute12:=
472: per_bpr_shd.g_old_rec.bpr_attribute12;
468: per_bpr_shd.g_old_rec.bpr_attribute11;
469: End If;
470: If (p_rec.bpr_attribute12 = hr_api.g_varchar2) then
471: p_rec.bpr_attribute12:=
472: per_bpr_shd.g_old_rec.bpr_attribute12;
473: End If;
474: If (p_rec.bpr_attribute13 = hr_api.g_varchar2) then
475: p_rec.bpr_attribute13:=
476: per_bpr_shd.g_old_rec.bpr_attribute13;
472: per_bpr_shd.g_old_rec.bpr_attribute12;
473: End If;
474: If (p_rec.bpr_attribute13 = hr_api.g_varchar2) then
475: p_rec.bpr_attribute13:=
476: per_bpr_shd.g_old_rec.bpr_attribute13;
477: End If;
478: If (p_rec.bpr_attribute14 = hr_api.g_varchar2) then
479: p_rec.bpr_attribute14:=
480: per_bpr_shd.g_old_rec.bpr_attribute14;
476: per_bpr_shd.g_old_rec.bpr_attribute13;
477: End If;
478: If (p_rec.bpr_attribute14 = hr_api.g_varchar2) then
479: p_rec.bpr_attribute14:=
480: per_bpr_shd.g_old_rec.bpr_attribute14;
481: End If;
482: If (p_rec.bpr_attribute15 = hr_api.g_varchar2) then
483: p_rec.bpr_attribute15:=
484: per_bpr_shd.g_old_rec.bpr_attribute15;
480: per_bpr_shd.g_old_rec.bpr_attribute14;
481: End If;
482: If (p_rec.bpr_attribute15 = hr_api.g_varchar2) then
483: p_rec.bpr_attribute15:=
484: per_bpr_shd.g_old_rec.bpr_attribute15;
485: End If;
486: If (p_rec.bpr_attribute16 = hr_api.g_varchar2) then
487: p_rec.bpr_attribute16:=
488: per_bpr_shd.g_old_rec.bpr_attribute16;
484: per_bpr_shd.g_old_rec.bpr_attribute15;
485: End If;
486: If (p_rec.bpr_attribute16 = hr_api.g_varchar2) then
487: p_rec.bpr_attribute16:=
488: per_bpr_shd.g_old_rec.bpr_attribute16;
489: End If;
490: If (p_rec.bpr_attribute17 = hr_api.g_varchar2) then
491: p_rec.bpr_attribute17:=
492: per_bpr_shd.g_old_rec.bpr_attribute17;
488: per_bpr_shd.g_old_rec.bpr_attribute16;
489: End If;
490: If (p_rec.bpr_attribute17 = hr_api.g_varchar2) then
491: p_rec.bpr_attribute17:=
492: per_bpr_shd.g_old_rec.bpr_attribute17;
493: End If;
494: If (p_rec.bpr_attribute18 = hr_api.g_varchar2) then
495: p_rec.bpr_attribute18:=
496: per_bpr_shd.g_old_rec.bpr_attribute18;
492: per_bpr_shd.g_old_rec.bpr_attribute17;
493: End If;
494: If (p_rec.bpr_attribute18 = hr_api.g_varchar2) then
495: p_rec.bpr_attribute18:=
496: per_bpr_shd.g_old_rec.bpr_attribute18;
497: End If;
498: If (p_rec.bpr_attribute19 = hr_api.g_varchar2) then
499: p_rec.bpr_attribute19:=
500: per_bpr_shd.g_old_rec.bpr_attribute19;
496: per_bpr_shd.g_old_rec.bpr_attribute18;
497: End If;
498: If (p_rec.bpr_attribute19 = hr_api.g_varchar2) then
499: p_rec.bpr_attribute19:=
500: per_bpr_shd.g_old_rec.bpr_attribute19;
501: End If;
502: If (p_rec.bpr_attribute20 = hr_api.g_varchar2) then
503: p_rec.bpr_attribute20:=
504: per_bpr_shd.g_old_rec.bpr_attribute20;
500: per_bpr_shd.g_old_rec.bpr_attribute19;
501: End If;
502: If (p_rec.bpr_attribute20 = hr_api.g_varchar2) then
503: p_rec.bpr_attribute20:=
504: per_bpr_shd.g_old_rec.bpr_attribute20;
505: End If;
506: If (p_rec.bpr_attribute21 = hr_api.g_varchar2) then
507: p_rec.bpr_attribute21:=
508: per_bpr_shd.g_old_rec.bpr_attribute21;
504: per_bpr_shd.g_old_rec.bpr_attribute20;
505: End If;
506: If (p_rec.bpr_attribute21 = hr_api.g_varchar2) then
507: p_rec.bpr_attribute21:=
508: per_bpr_shd.g_old_rec.bpr_attribute21;
509: End If;
510: If (p_rec.bpr_attribute22 = hr_api.g_varchar2) then
511: p_rec.bpr_attribute22:=
512: per_bpr_shd.g_old_rec.bpr_attribute22;
508: per_bpr_shd.g_old_rec.bpr_attribute21;
509: End If;
510: If (p_rec.bpr_attribute22 = hr_api.g_varchar2) then
511: p_rec.bpr_attribute22:=
512: per_bpr_shd.g_old_rec.bpr_attribute22;
513: End If;
514: If (p_rec.bpr_attribute23 = hr_api.g_varchar2) then
515: p_rec.bpr_attribute23:=
516: per_bpr_shd.g_old_rec.bpr_attribute23;
512: per_bpr_shd.g_old_rec.bpr_attribute22;
513: End If;
514: If (p_rec.bpr_attribute23 = hr_api.g_varchar2) then
515: p_rec.bpr_attribute23:=
516: per_bpr_shd.g_old_rec.bpr_attribute23;
517: End If;
518: If (p_rec.bpr_attribute24 = hr_api.g_varchar2) then
519: p_rec.bpr_attribute24:=
520: per_bpr_shd.g_old_rec.bpr_attribute24;
516: per_bpr_shd.g_old_rec.bpr_attribute23;
517: End If;
518: If (p_rec.bpr_attribute24 = hr_api.g_varchar2) then
519: p_rec.bpr_attribute24:=
520: per_bpr_shd.g_old_rec.bpr_attribute24;
521: End If;
522: If (p_rec.bpr_attribute25 = hr_api.g_varchar2) then
523: p_rec.bpr_attribute25:=
524: per_bpr_shd.g_old_rec.bpr_attribute25;
520: per_bpr_shd.g_old_rec.bpr_attribute24;
521: End If;
522: If (p_rec.bpr_attribute25 = hr_api.g_varchar2) then
523: p_rec.bpr_attribute25:=
524: per_bpr_shd.g_old_rec.bpr_attribute25;
525: End If;
526: If (p_rec.bpr_attribute26 = hr_api.g_varchar2) then
527: p_rec.bpr_attribute26:=
528: per_bpr_shd.g_old_rec.bpr_attribute26;
524: per_bpr_shd.g_old_rec.bpr_attribute25;
525: End If;
526: If (p_rec.bpr_attribute26 = hr_api.g_varchar2) then
527: p_rec.bpr_attribute26:=
528: per_bpr_shd.g_old_rec.bpr_attribute26;
529: End If;
530: If (p_rec.bpr_attribute27 = hr_api.g_varchar2) then
531: p_rec.bpr_attribute27:=
532: per_bpr_shd.g_old_rec.bpr_attribute27;
528: per_bpr_shd.g_old_rec.bpr_attribute26;
529: End If;
530: If (p_rec.bpr_attribute27 = hr_api.g_varchar2) then
531: p_rec.bpr_attribute27:=
532: per_bpr_shd.g_old_rec.bpr_attribute27;
533: End If;
534: If (p_rec.bpr_attribute28 = hr_api.g_varchar2) then
535: p_rec.bpr_attribute28:=
536: per_bpr_shd.g_old_rec.bpr_attribute28;
532: per_bpr_shd.g_old_rec.bpr_attribute27;
533: End If;
534: If (p_rec.bpr_attribute28 = hr_api.g_varchar2) then
535: p_rec.bpr_attribute28:=
536: per_bpr_shd.g_old_rec.bpr_attribute28;
537: End If;
538: If (p_rec.bpr_attribute29 = hr_api.g_varchar2) then
539: p_rec.bpr_attribute29:=
540: per_bpr_shd.g_old_rec.bpr_attribute29;
536: per_bpr_shd.g_old_rec.bpr_attribute28;
537: End If;
538: If (p_rec.bpr_attribute29 = hr_api.g_varchar2) then
539: p_rec.bpr_attribute29:=
540: per_bpr_shd.g_old_rec.bpr_attribute29;
541: End If;
542: If (p_rec.bpr_attribute30 = hr_api.g_varchar2) then
543: p_rec.bpr_attribute30:=
544: per_bpr_shd.g_old_rec.bpr_attribute30;
540: per_bpr_shd.g_old_rec.bpr_attribute29;
541: End If;
542: If (p_rec.bpr_attribute30 = hr_api.g_varchar2) then
543: p_rec.bpr_attribute30:=
544: per_bpr_shd.g_old_rec.bpr_attribute30;
545: End If;
546:
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 10);
554: -- ----------------------------------------------------------------------------
555: Procedure upd
556: (
557: p_effective_date in date,
558: p_rec in out nocopy per_bpr_shd.g_rec_type
559: ) is
560: --
561: l_proc varchar2(72) := g_package||'upd';
562: --
564: hr_utility.set_location('Entering:'||l_proc, 5);
565: --
566: -- We must lock the row which we need to update.
567: --
568: per_bpr_shd.lck
569: (
570: p_rec.payroll_run_id,
571: p_rec.object_version_number
572: );
640: p_bpr_attribute29 in varchar2 default hr_api.g_varchar2,
641: p_bpr_attribute30 in varchar2 default hr_api.g_varchar2
642: ) is
643: --
644: l_rec per_bpr_shd.g_rec_type;
645: l_proc varchar2(72) := g_package||'upd';
646: --
647: Begin
648: hr_utility.set_location('Entering:'||l_proc, 5);
650: -- Call conversion function to turn arguments into the
651: -- l_rec structure.
652: --
653: l_rec :=
654: per_bpr_shd.convert_args
655: (
656: p_payroll_run_id,
657: hr_api.g_number,
658: hr_api.g_number,