[Home] [Help]
50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_bba_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
112: --
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: per_bba_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: per_bba_shd.constraint_error
116: per_bba_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: per_bba_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: per_bba_shd.constraint_error
120: per_bba_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: per_bba_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: Raise;
128: End update_dml;
158: -- Internal Row Handler Use Only.
159: --
160: -- {End Of Comments}
161: -- ----------------------------------------------------------------------------
162: Procedure pre_update(p_rec in per_bba_shd.g_rec_type) is
163: --
164: l_proc varchar2(72) := g_package||'pre_update';
165: --
166: Begin
201: --
202: -- {End Of Comments}
203: -- ----------------------------------------------------------------------------
204: Procedure post_update(p_effective_date in date,
205: p_rec in per_bba_shd.g_rec_type) is
206: --
207: l_proc varchar2(72) := g_package||'post_update';
208: --
209: Begin
251: p_bba_attribute28 => p_rec.bba_attribute28,
252: p_bba_attribute29 => p_rec.bba_attribute29,
253: p_bba_attribute30 => p_rec.bba_attribute30,
254: p_balance_type_id_o
255: => per_bba_shd.g_old_rec.balance_type_id,
256: p_processed_assignment_id_o
257: => per_bba_shd.g_old_rec.processed_assignment_id,
258: p_business_group_id_o
259: => per_bba_shd.g_old_rec.business_group_id,
253: p_bba_attribute30 => p_rec.bba_attribute30,
254: p_balance_type_id_o
255: => per_bba_shd.g_old_rec.balance_type_id,
256: p_processed_assignment_id_o
257: => per_bba_shd.g_old_rec.processed_assignment_id,
258: p_business_group_id_o
259: => per_bba_shd.g_old_rec.business_group_id,
260: p_ytd_amount_o
261: => per_bba_shd.g_old_rec.ytd_amount,
255: => per_bba_shd.g_old_rec.balance_type_id,
256: p_processed_assignment_id_o
257: => per_bba_shd.g_old_rec.processed_assignment_id,
258: p_business_group_id_o
259: => per_bba_shd.g_old_rec.business_group_id,
260: p_ytd_amount_o
261: => per_bba_shd.g_old_rec.ytd_amount,
262: p_fytd_amount_o
263: => per_bba_shd.g_old_rec.fytd_amount,
257: => per_bba_shd.g_old_rec.processed_assignment_id,
258: p_business_group_id_o
259: => per_bba_shd.g_old_rec.business_group_id,
260: p_ytd_amount_o
261: => per_bba_shd.g_old_rec.ytd_amount,
262: p_fytd_amount_o
263: => per_bba_shd.g_old_rec.fytd_amount,
264: p_ptd_amount_o
265: => per_bba_shd.g_old_rec.ptd_amount,
259: => per_bba_shd.g_old_rec.business_group_id,
260: p_ytd_amount_o
261: => per_bba_shd.g_old_rec.ytd_amount,
262: p_fytd_amount_o
263: => per_bba_shd.g_old_rec.fytd_amount,
264: p_ptd_amount_o
265: => per_bba_shd.g_old_rec.ptd_amount,
266: p_mtd_amount_o
267: => per_bba_shd.g_old_rec.mtd_amount,
261: => per_bba_shd.g_old_rec.ytd_amount,
262: p_fytd_amount_o
263: => per_bba_shd.g_old_rec.fytd_amount,
264: p_ptd_amount_o
265: => per_bba_shd.g_old_rec.ptd_amount,
266: p_mtd_amount_o
267: => per_bba_shd.g_old_rec.mtd_amount,
268: p_qtd_amount_o
269: => per_bba_shd.g_old_rec.qtd_amount,
263: => per_bba_shd.g_old_rec.fytd_amount,
264: p_ptd_amount_o
265: => per_bba_shd.g_old_rec.ptd_amount,
266: p_mtd_amount_o
267: => per_bba_shd.g_old_rec.mtd_amount,
268: p_qtd_amount_o
269: => per_bba_shd.g_old_rec.qtd_amount,
270: p_run_amount_o
271: => per_bba_shd.g_old_rec.run_amount,
265: => per_bba_shd.g_old_rec.ptd_amount,
266: p_mtd_amount_o
267: => per_bba_shd.g_old_rec.mtd_amount,
268: p_qtd_amount_o
269: => per_bba_shd.g_old_rec.qtd_amount,
270: p_run_amount_o
271: => per_bba_shd.g_old_rec.run_amount,
272: p_object_version_number_o
273: => per_bba_shd.g_old_rec.object_version_number,
267: => per_bba_shd.g_old_rec.mtd_amount,
268: p_qtd_amount_o
269: => per_bba_shd.g_old_rec.qtd_amount,
270: p_run_amount_o
271: => per_bba_shd.g_old_rec.run_amount,
272: p_object_version_number_o
273: => per_bba_shd.g_old_rec.object_version_number,
274: p_bba_attribute_category_o
275: => per_bba_shd.g_old_rec.bba_attribute_category,
269: => per_bba_shd.g_old_rec.qtd_amount,
270: p_run_amount_o
271: => per_bba_shd.g_old_rec.run_amount,
272: p_object_version_number_o
273: => per_bba_shd.g_old_rec.object_version_number,
274: p_bba_attribute_category_o
275: => per_bba_shd.g_old_rec.bba_attribute_category,
276: p_bba_attribute1_o
277: => per_bba_shd.g_old_rec.bba_attribute1,
271: => per_bba_shd.g_old_rec.run_amount,
272: p_object_version_number_o
273: => per_bba_shd.g_old_rec.object_version_number,
274: p_bba_attribute_category_o
275: => per_bba_shd.g_old_rec.bba_attribute_category,
276: p_bba_attribute1_o
277: => per_bba_shd.g_old_rec.bba_attribute1,
278: p_bba_attribute2_o
279: => per_bba_shd.g_old_rec.bba_attribute2,
273: => per_bba_shd.g_old_rec.object_version_number,
274: p_bba_attribute_category_o
275: => per_bba_shd.g_old_rec.bba_attribute_category,
276: p_bba_attribute1_o
277: => per_bba_shd.g_old_rec.bba_attribute1,
278: p_bba_attribute2_o
279: => per_bba_shd.g_old_rec.bba_attribute2,
280: p_bba_attribute3_o
281: => per_bba_shd.g_old_rec.bba_attribute3,
275: => per_bba_shd.g_old_rec.bba_attribute_category,
276: p_bba_attribute1_o
277: => per_bba_shd.g_old_rec.bba_attribute1,
278: p_bba_attribute2_o
279: => per_bba_shd.g_old_rec.bba_attribute2,
280: p_bba_attribute3_o
281: => per_bba_shd.g_old_rec.bba_attribute3,
282: p_bba_attribute4_o
283: => per_bba_shd.g_old_rec.bba_attribute4,
277: => per_bba_shd.g_old_rec.bba_attribute1,
278: p_bba_attribute2_o
279: => per_bba_shd.g_old_rec.bba_attribute2,
280: p_bba_attribute3_o
281: => per_bba_shd.g_old_rec.bba_attribute3,
282: p_bba_attribute4_o
283: => per_bba_shd.g_old_rec.bba_attribute4,
284: p_bba_attribute5_o
285: => per_bba_shd.g_old_rec.bba_attribute5,
279: => per_bba_shd.g_old_rec.bba_attribute2,
280: p_bba_attribute3_o
281: => per_bba_shd.g_old_rec.bba_attribute3,
282: p_bba_attribute4_o
283: => per_bba_shd.g_old_rec.bba_attribute4,
284: p_bba_attribute5_o
285: => per_bba_shd.g_old_rec.bba_attribute5,
286: p_bba_attribute6_o
287: => per_bba_shd.g_old_rec.bba_attribute6,
281: => per_bba_shd.g_old_rec.bba_attribute3,
282: p_bba_attribute4_o
283: => per_bba_shd.g_old_rec.bba_attribute4,
284: p_bba_attribute5_o
285: => per_bba_shd.g_old_rec.bba_attribute5,
286: p_bba_attribute6_o
287: => per_bba_shd.g_old_rec.bba_attribute6,
288: p_bba_attribute7_o
289: => per_bba_shd.g_old_rec.bba_attribute7,
283: => per_bba_shd.g_old_rec.bba_attribute4,
284: p_bba_attribute5_o
285: => per_bba_shd.g_old_rec.bba_attribute5,
286: p_bba_attribute6_o
287: => per_bba_shd.g_old_rec.bba_attribute6,
288: p_bba_attribute7_o
289: => per_bba_shd.g_old_rec.bba_attribute7,
290: p_bba_attribute8_o
291: => per_bba_shd.g_old_rec.bba_attribute8,
285: => per_bba_shd.g_old_rec.bba_attribute5,
286: p_bba_attribute6_o
287: => per_bba_shd.g_old_rec.bba_attribute6,
288: p_bba_attribute7_o
289: => per_bba_shd.g_old_rec.bba_attribute7,
290: p_bba_attribute8_o
291: => per_bba_shd.g_old_rec.bba_attribute8,
292: p_bba_attribute9_o
293: => per_bba_shd.g_old_rec.bba_attribute9,
287: => per_bba_shd.g_old_rec.bba_attribute6,
288: p_bba_attribute7_o
289: => per_bba_shd.g_old_rec.bba_attribute7,
290: p_bba_attribute8_o
291: => per_bba_shd.g_old_rec.bba_attribute8,
292: p_bba_attribute9_o
293: => per_bba_shd.g_old_rec.bba_attribute9,
294: p_bba_attribute10_o
295: => per_bba_shd.g_old_rec.bba_attribute10,
289: => per_bba_shd.g_old_rec.bba_attribute7,
290: p_bba_attribute8_o
291: => per_bba_shd.g_old_rec.bba_attribute8,
292: p_bba_attribute9_o
293: => per_bba_shd.g_old_rec.bba_attribute9,
294: p_bba_attribute10_o
295: => per_bba_shd.g_old_rec.bba_attribute10,
296: p_bba_attribute11_o
297: => per_bba_shd.g_old_rec.bba_attribute11,
291: => per_bba_shd.g_old_rec.bba_attribute8,
292: p_bba_attribute9_o
293: => per_bba_shd.g_old_rec.bba_attribute9,
294: p_bba_attribute10_o
295: => per_bba_shd.g_old_rec.bba_attribute10,
296: p_bba_attribute11_o
297: => per_bba_shd.g_old_rec.bba_attribute11,
298: p_bba_attribute12_o
299: => per_bba_shd.g_old_rec.bba_attribute12,
293: => per_bba_shd.g_old_rec.bba_attribute9,
294: p_bba_attribute10_o
295: => per_bba_shd.g_old_rec.bba_attribute10,
296: p_bba_attribute11_o
297: => per_bba_shd.g_old_rec.bba_attribute11,
298: p_bba_attribute12_o
299: => per_bba_shd.g_old_rec.bba_attribute12,
300: p_bba_attribute13_o
301: => per_bba_shd.g_old_rec.bba_attribute13,
295: => per_bba_shd.g_old_rec.bba_attribute10,
296: p_bba_attribute11_o
297: => per_bba_shd.g_old_rec.bba_attribute11,
298: p_bba_attribute12_o
299: => per_bba_shd.g_old_rec.bba_attribute12,
300: p_bba_attribute13_o
301: => per_bba_shd.g_old_rec.bba_attribute13,
302: p_bba_attribute14_o
303: => per_bba_shd.g_old_rec.bba_attribute14,
297: => per_bba_shd.g_old_rec.bba_attribute11,
298: p_bba_attribute12_o
299: => per_bba_shd.g_old_rec.bba_attribute12,
300: p_bba_attribute13_o
301: => per_bba_shd.g_old_rec.bba_attribute13,
302: p_bba_attribute14_o
303: => per_bba_shd.g_old_rec.bba_attribute14,
304: p_bba_attribute15_o
305: => per_bba_shd.g_old_rec.bba_attribute15,
299: => per_bba_shd.g_old_rec.bba_attribute12,
300: p_bba_attribute13_o
301: => per_bba_shd.g_old_rec.bba_attribute13,
302: p_bba_attribute14_o
303: => per_bba_shd.g_old_rec.bba_attribute14,
304: p_bba_attribute15_o
305: => per_bba_shd.g_old_rec.bba_attribute15,
306: p_bba_attribute16_o
307: => per_bba_shd.g_old_rec.bba_attribute16,
301: => per_bba_shd.g_old_rec.bba_attribute13,
302: p_bba_attribute14_o
303: => per_bba_shd.g_old_rec.bba_attribute14,
304: p_bba_attribute15_o
305: => per_bba_shd.g_old_rec.bba_attribute15,
306: p_bba_attribute16_o
307: => per_bba_shd.g_old_rec.bba_attribute16,
308: p_bba_attribute17_o
309: => per_bba_shd.g_old_rec.bba_attribute17,
303: => per_bba_shd.g_old_rec.bba_attribute14,
304: p_bba_attribute15_o
305: => per_bba_shd.g_old_rec.bba_attribute15,
306: p_bba_attribute16_o
307: => per_bba_shd.g_old_rec.bba_attribute16,
308: p_bba_attribute17_o
309: => per_bba_shd.g_old_rec.bba_attribute17,
310: p_bba_attribute18_o
311: => per_bba_shd.g_old_rec.bba_attribute18,
305: => per_bba_shd.g_old_rec.bba_attribute15,
306: p_bba_attribute16_o
307: => per_bba_shd.g_old_rec.bba_attribute16,
308: p_bba_attribute17_o
309: => per_bba_shd.g_old_rec.bba_attribute17,
310: p_bba_attribute18_o
311: => per_bba_shd.g_old_rec.bba_attribute18,
312: p_bba_attribute19_o
313: => per_bba_shd.g_old_rec.bba_attribute19,
307: => per_bba_shd.g_old_rec.bba_attribute16,
308: p_bba_attribute17_o
309: => per_bba_shd.g_old_rec.bba_attribute17,
310: p_bba_attribute18_o
311: => per_bba_shd.g_old_rec.bba_attribute18,
312: p_bba_attribute19_o
313: => per_bba_shd.g_old_rec.bba_attribute19,
314: p_bba_attribute20_o
315: => per_bba_shd.g_old_rec.bba_attribute20,
309: => per_bba_shd.g_old_rec.bba_attribute17,
310: p_bba_attribute18_o
311: => per_bba_shd.g_old_rec.bba_attribute18,
312: p_bba_attribute19_o
313: => per_bba_shd.g_old_rec.bba_attribute19,
314: p_bba_attribute20_o
315: => per_bba_shd.g_old_rec.bba_attribute20,
316: p_bba_attribute21_o
317: => per_bba_shd.g_old_rec.bba_attribute21,
311: => per_bba_shd.g_old_rec.bba_attribute18,
312: p_bba_attribute19_o
313: => per_bba_shd.g_old_rec.bba_attribute19,
314: p_bba_attribute20_o
315: => per_bba_shd.g_old_rec.bba_attribute20,
316: p_bba_attribute21_o
317: => per_bba_shd.g_old_rec.bba_attribute21,
318: p_bba_attribute22_o
319: => per_bba_shd.g_old_rec.bba_attribute22,
313: => per_bba_shd.g_old_rec.bba_attribute19,
314: p_bba_attribute20_o
315: => per_bba_shd.g_old_rec.bba_attribute20,
316: p_bba_attribute21_o
317: => per_bba_shd.g_old_rec.bba_attribute21,
318: p_bba_attribute22_o
319: => per_bba_shd.g_old_rec.bba_attribute22,
320: p_bba_attribute23_o
321: => per_bba_shd.g_old_rec.bba_attribute23,
315: => per_bba_shd.g_old_rec.bba_attribute20,
316: p_bba_attribute21_o
317: => per_bba_shd.g_old_rec.bba_attribute21,
318: p_bba_attribute22_o
319: => per_bba_shd.g_old_rec.bba_attribute22,
320: p_bba_attribute23_o
321: => per_bba_shd.g_old_rec.bba_attribute23,
322: p_bba_attribute24_o
323: => per_bba_shd.g_old_rec.bba_attribute24,
317: => per_bba_shd.g_old_rec.bba_attribute21,
318: p_bba_attribute22_o
319: => per_bba_shd.g_old_rec.bba_attribute22,
320: p_bba_attribute23_o
321: => per_bba_shd.g_old_rec.bba_attribute23,
322: p_bba_attribute24_o
323: => per_bba_shd.g_old_rec.bba_attribute24,
324: p_bba_attribute25_o
325: => per_bba_shd.g_old_rec.bba_attribute25,
319: => per_bba_shd.g_old_rec.bba_attribute22,
320: p_bba_attribute23_o
321: => per_bba_shd.g_old_rec.bba_attribute23,
322: p_bba_attribute24_o
323: => per_bba_shd.g_old_rec.bba_attribute24,
324: p_bba_attribute25_o
325: => per_bba_shd.g_old_rec.bba_attribute25,
326: p_bba_attribute26_o
327: => per_bba_shd.g_old_rec.bba_attribute26,
321: => per_bba_shd.g_old_rec.bba_attribute23,
322: p_bba_attribute24_o
323: => per_bba_shd.g_old_rec.bba_attribute24,
324: p_bba_attribute25_o
325: => per_bba_shd.g_old_rec.bba_attribute25,
326: p_bba_attribute26_o
327: => per_bba_shd.g_old_rec.bba_attribute26,
328: p_bba_attribute27_o
329: => per_bba_shd.g_old_rec.bba_attribute27,
323: => per_bba_shd.g_old_rec.bba_attribute24,
324: p_bba_attribute25_o
325: => per_bba_shd.g_old_rec.bba_attribute25,
326: p_bba_attribute26_o
327: => per_bba_shd.g_old_rec.bba_attribute26,
328: p_bba_attribute27_o
329: => per_bba_shd.g_old_rec.bba_attribute27,
330: p_bba_attribute28_o
331: => per_bba_shd.g_old_rec.bba_attribute28,
325: => per_bba_shd.g_old_rec.bba_attribute25,
326: p_bba_attribute26_o
327: => per_bba_shd.g_old_rec.bba_attribute26,
328: p_bba_attribute27_o
329: => per_bba_shd.g_old_rec.bba_attribute27,
330: p_bba_attribute28_o
331: => per_bba_shd.g_old_rec.bba_attribute28,
332: p_bba_attribute29_o
333: => per_bba_shd.g_old_rec.bba_attribute29,
327: => per_bba_shd.g_old_rec.bba_attribute26,
328: p_bba_attribute27_o
329: => per_bba_shd.g_old_rec.bba_attribute27,
330: p_bba_attribute28_o
331: => per_bba_shd.g_old_rec.bba_attribute28,
332: p_bba_attribute29_o
333: => per_bba_shd.g_old_rec.bba_attribute29,
334: p_bba_attribute30_o
335: => per_bba_shd.g_old_rec.bba_attribute30
329: => per_bba_shd.g_old_rec.bba_attribute27,
330: p_bba_attribute28_o
331: => per_bba_shd.g_old_rec.bba_attribute28,
332: p_bba_attribute29_o
333: => per_bba_shd.g_old_rec.bba_attribute29,
334: p_bba_attribute30_o
335: => per_bba_shd.g_old_rec.bba_attribute30
336: );
337: --
331: => per_bba_shd.g_old_rec.bba_attribute28,
332: p_bba_attribute29_o
333: => per_bba_shd.g_old_rec.bba_attribute29,
334: p_bba_attribute30_o
335: => per_bba_shd.g_old_rec.bba_attribute30
336: );
337: --
338: exception
339: --
390: -- Internal Row Handler Use Only.
391: --
392: -- {End Of Comments}
393: -- ----------------------------------------------------------------------------
394: Procedure convert_defs(p_rec in out nocopy per_bba_shd.g_rec_type) is
395: --
396: l_proc varchar2(72) := g_package||'convert_defs';
397: --
398: Begin
405: -- is being used then we must set to the 'current' argument value.
406: --
407: If (p_rec.balance_type_id = hr_api.g_number) then
408: p_rec.balance_type_id :=
409: per_bba_shd.g_old_rec.balance_type_id;
410: End If;
411: If (p_rec.processed_assignment_id = hr_api.g_number) then
412: p_rec.processed_assignment_id :=
413: per_bba_shd.g_old_rec.processed_assignment_id;
409: per_bba_shd.g_old_rec.balance_type_id;
410: End If;
411: If (p_rec.processed_assignment_id = hr_api.g_number) then
412: p_rec.processed_assignment_id :=
413: per_bba_shd.g_old_rec.processed_assignment_id;
414: End If;
415: If (p_rec.business_group_id = hr_api.g_number) then
416: p_rec.business_group_id :=
417: per_bba_shd.g_old_rec.business_group_id;
413: per_bba_shd.g_old_rec.processed_assignment_id;
414: End If;
415: If (p_rec.business_group_id = hr_api.g_number) then
416: p_rec.business_group_id :=
417: per_bba_shd.g_old_rec.business_group_id;
418: End If;
419: If (p_rec.ytd_amount = hr_api.g_number) then
420: p_rec.ytd_amount :=
421: per_bba_shd.g_old_rec.ytd_amount;
417: per_bba_shd.g_old_rec.business_group_id;
418: End If;
419: If (p_rec.ytd_amount = hr_api.g_number) then
420: p_rec.ytd_amount :=
421: per_bba_shd.g_old_rec.ytd_amount;
422: End If;
423: If (p_rec.fytd_amount = hr_api.g_number) then
424: p_rec.fytd_amount :=
425: per_bba_shd.g_old_rec.fytd_amount;
421: per_bba_shd.g_old_rec.ytd_amount;
422: End If;
423: If (p_rec.fytd_amount = hr_api.g_number) then
424: p_rec.fytd_amount :=
425: per_bba_shd.g_old_rec.fytd_amount;
426: End If;
427: If (p_rec.ptd_amount = hr_api.g_number) then
428: p_rec.ptd_amount :=
429: per_bba_shd.g_old_rec.ptd_amount;
425: per_bba_shd.g_old_rec.fytd_amount;
426: End If;
427: If (p_rec.ptd_amount = hr_api.g_number) then
428: p_rec.ptd_amount :=
429: per_bba_shd.g_old_rec.ptd_amount;
430: End If;
431: If (p_rec.mtd_amount = hr_api.g_number) then
432: p_rec.mtd_amount :=
433: per_bba_shd.g_old_rec.mtd_amount;
429: per_bba_shd.g_old_rec.ptd_amount;
430: End If;
431: If (p_rec.mtd_amount = hr_api.g_number) then
432: p_rec.mtd_amount :=
433: per_bba_shd.g_old_rec.mtd_amount;
434: End If;
435: If (p_rec.qtd_amount = hr_api.g_number) then
436: p_rec.qtd_amount :=
437: per_bba_shd.g_old_rec.qtd_amount;
433: per_bba_shd.g_old_rec.mtd_amount;
434: End If;
435: If (p_rec.qtd_amount = hr_api.g_number) then
436: p_rec.qtd_amount :=
437: per_bba_shd.g_old_rec.qtd_amount;
438: End If;
439: If (p_rec.run_amount = hr_api.g_number) then
440: p_rec.run_amount :=
441: per_bba_shd.g_old_rec.run_amount;
437: per_bba_shd.g_old_rec.qtd_amount;
438: End If;
439: If (p_rec.run_amount = hr_api.g_number) then
440: p_rec.run_amount :=
441: per_bba_shd.g_old_rec.run_amount;
442: End If;
443: If (p_rec.bba_attribute_category = hr_api.g_varchar2) then
444: p_rec.bba_attribute_category :=
445: per_bba_shd.g_old_rec.bba_attribute_category;
441: per_bba_shd.g_old_rec.run_amount;
442: End If;
443: If (p_rec.bba_attribute_category = hr_api.g_varchar2) then
444: p_rec.bba_attribute_category :=
445: per_bba_shd.g_old_rec.bba_attribute_category;
446: End If;
447: If (p_rec.bba_attribute1 = hr_api.g_varchar2) then
448: p_rec.bba_attribute1:=
449: per_bba_shd.g_old_rec.bba_attribute1;
445: per_bba_shd.g_old_rec.bba_attribute_category;
446: End If;
447: If (p_rec.bba_attribute1 = hr_api.g_varchar2) then
448: p_rec.bba_attribute1:=
449: per_bba_shd.g_old_rec.bba_attribute1;
450: End If;
451: If (p_rec.bba_attribute2 = hr_api.g_varchar2) then
452: p_rec.bba_attribute2:=
453: per_bba_shd.g_old_rec.bba_attribute2;
449: per_bba_shd.g_old_rec.bba_attribute1;
450: End If;
451: If (p_rec.bba_attribute2 = hr_api.g_varchar2) then
452: p_rec.bba_attribute2:=
453: per_bba_shd.g_old_rec.bba_attribute2;
454: End If;
455: If (p_rec.bba_attribute3 = hr_api.g_varchar2) then
456: p_rec.bba_attribute3:=
457: per_bba_shd.g_old_rec.bba_attribute3;
453: per_bba_shd.g_old_rec.bba_attribute2;
454: End If;
455: If (p_rec.bba_attribute3 = hr_api.g_varchar2) then
456: p_rec.bba_attribute3:=
457: per_bba_shd.g_old_rec.bba_attribute3;
458: End If;
459: If (p_rec.bba_attribute4 = hr_api.g_varchar2) then
460: p_rec.bba_attribute4:=
461: per_bba_shd.g_old_rec.bba_attribute4;
457: per_bba_shd.g_old_rec.bba_attribute3;
458: End If;
459: If (p_rec.bba_attribute4 = hr_api.g_varchar2) then
460: p_rec.bba_attribute4:=
461: per_bba_shd.g_old_rec.bba_attribute4;
462: End If;
463: If (p_rec.bba_attribute5 = hr_api.g_varchar2) then
464: p_rec.bba_attribute5:=
465: per_bba_shd.g_old_rec.bba_attribute5;
461: per_bba_shd.g_old_rec.bba_attribute4;
462: End If;
463: If (p_rec.bba_attribute5 = hr_api.g_varchar2) then
464: p_rec.bba_attribute5:=
465: per_bba_shd.g_old_rec.bba_attribute5;
466: End If;
467: If (p_rec.bba_attribute6 = hr_api.g_varchar2) then
468: p_rec.bba_attribute6:=
469: per_bba_shd.g_old_rec.bba_attribute6;
465: per_bba_shd.g_old_rec.bba_attribute5;
466: End If;
467: If (p_rec.bba_attribute6 = hr_api.g_varchar2) then
468: p_rec.bba_attribute6:=
469: per_bba_shd.g_old_rec.bba_attribute6;
470: End If;
471: If (p_rec.bba_attribute7 = hr_api.g_varchar2) then
472: p_rec.bba_attribute7:=
473: per_bba_shd.g_old_rec.bba_attribute7;
469: per_bba_shd.g_old_rec.bba_attribute6;
470: End If;
471: If (p_rec.bba_attribute7 = hr_api.g_varchar2) then
472: p_rec.bba_attribute7:=
473: per_bba_shd.g_old_rec.bba_attribute7;
474: End If;
475: If (p_rec.bba_attribute8 = hr_api.g_varchar2) then
476: p_rec.bba_attribute8:=
477: per_bba_shd.g_old_rec.bba_attribute8;
473: per_bba_shd.g_old_rec.bba_attribute7;
474: End If;
475: If (p_rec.bba_attribute8 = hr_api.g_varchar2) then
476: p_rec.bba_attribute8:=
477: per_bba_shd.g_old_rec.bba_attribute8;
478: End If;
479: If (p_rec.bba_attribute9 = hr_api.g_varchar2) then
480: p_rec.bba_attribute9:=
481: per_bba_shd.g_old_rec.bba_attribute9;
477: per_bba_shd.g_old_rec.bba_attribute8;
478: End If;
479: If (p_rec.bba_attribute9 = hr_api.g_varchar2) then
480: p_rec.bba_attribute9:=
481: per_bba_shd.g_old_rec.bba_attribute9;
482: End If;
483: If (p_rec.bba_attribute10 = hr_api.g_varchar2) then
484: p_rec.bba_attribute10:=
485: per_bba_shd.g_old_rec.bba_attribute10;
481: per_bba_shd.g_old_rec.bba_attribute9;
482: End If;
483: If (p_rec.bba_attribute10 = hr_api.g_varchar2) then
484: p_rec.bba_attribute10:=
485: per_bba_shd.g_old_rec.bba_attribute10;
486: End If;
487: If (p_rec.bba_attribute11 = hr_api.g_varchar2) then
488: p_rec.bba_attribute11:=
489: per_bba_shd.g_old_rec.bba_attribute11;
485: per_bba_shd.g_old_rec.bba_attribute10;
486: End If;
487: If (p_rec.bba_attribute11 = hr_api.g_varchar2) then
488: p_rec.bba_attribute11:=
489: per_bba_shd.g_old_rec.bba_attribute11;
490: End If;
491: If (p_rec.bba_attribute12 = hr_api.g_varchar2) then
492: p_rec.bba_attribute12:=
493: per_bba_shd.g_old_rec.bba_attribute12;
489: per_bba_shd.g_old_rec.bba_attribute11;
490: End If;
491: If (p_rec.bba_attribute12 = hr_api.g_varchar2) then
492: p_rec.bba_attribute12:=
493: per_bba_shd.g_old_rec.bba_attribute12;
494: End If;
495: If (p_rec.bba_attribute13 = hr_api.g_varchar2) then
496: p_rec.bba_attribute13:=
497: per_bba_shd.g_old_rec.bba_attribute13;
493: per_bba_shd.g_old_rec.bba_attribute12;
494: End If;
495: If (p_rec.bba_attribute13 = hr_api.g_varchar2) then
496: p_rec.bba_attribute13:=
497: per_bba_shd.g_old_rec.bba_attribute13;
498: End If;
499: If (p_rec.bba_attribute14 = hr_api.g_varchar2) then
500: p_rec.bba_attribute14:=
501: per_bba_shd.g_old_rec.bba_attribute14;
497: per_bba_shd.g_old_rec.bba_attribute13;
498: End If;
499: If (p_rec.bba_attribute14 = hr_api.g_varchar2) then
500: p_rec.bba_attribute14:=
501: per_bba_shd.g_old_rec.bba_attribute14;
502: End If;
503: If (p_rec.bba_attribute15 = hr_api.g_varchar2) then
504: p_rec.bba_attribute15:=
505: per_bba_shd.g_old_rec.bba_attribute15;
501: per_bba_shd.g_old_rec.bba_attribute14;
502: End If;
503: If (p_rec.bba_attribute15 = hr_api.g_varchar2) then
504: p_rec.bba_attribute15:=
505: per_bba_shd.g_old_rec.bba_attribute15;
506: End If;
507: If (p_rec.bba_attribute16 = hr_api.g_varchar2) then
508: p_rec.bba_attribute16:=
509: per_bba_shd.g_old_rec.bba_attribute16;
505: per_bba_shd.g_old_rec.bba_attribute15;
506: End If;
507: If (p_rec.bba_attribute16 = hr_api.g_varchar2) then
508: p_rec.bba_attribute16:=
509: per_bba_shd.g_old_rec.bba_attribute16;
510: End If;
511: If (p_rec.bba_attribute17 = hr_api.g_varchar2) then
512: p_rec.bba_attribute17:=
513: per_bba_shd.g_old_rec.bba_attribute17;
509: per_bba_shd.g_old_rec.bba_attribute16;
510: End If;
511: If (p_rec.bba_attribute17 = hr_api.g_varchar2) then
512: p_rec.bba_attribute17:=
513: per_bba_shd.g_old_rec.bba_attribute17;
514: End If;
515: If (p_rec.bba_attribute18 = hr_api.g_varchar2) then
516: p_rec.bba_attribute18:=
517: per_bba_shd.g_old_rec.bba_attribute18;
513: per_bba_shd.g_old_rec.bba_attribute17;
514: End If;
515: If (p_rec.bba_attribute18 = hr_api.g_varchar2) then
516: p_rec.bba_attribute18:=
517: per_bba_shd.g_old_rec.bba_attribute18;
518: End If;
519: If (p_rec.bba_attribute19 = hr_api.g_varchar2) then
520: p_rec.bba_attribute19:=
521: per_bba_shd.g_old_rec.bba_attribute19;
517: per_bba_shd.g_old_rec.bba_attribute18;
518: End If;
519: If (p_rec.bba_attribute19 = hr_api.g_varchar2) then
520: p_rec.bba_attribute19:=
521: per_bba_shd.g_old_rec.bba_attribute19;
522: End If;
523: If (p_rec.bba_attribute20 = hr_api.g_varchar2) then
524: p_rec.bba_attribute20:=
525: per_bba_shd.g_old_rec.bba_attribute20;
521: per_bba_shd.g_old_rec.bba_attribute19;
522: End If;
523: If (p_rec.bba_attribute20 = hr_api.g_varchar2) then
524: p_rec.bba_attribute20:=
525: per_bba_shd.g_old_rec.bba_attribute20;
526: End If;
527: If (p_rec.bba_attribute21 = hr_api.g_varchar2) then
528: p_rec.bba_attribute21:=
529: per_bba_shd.g_old_rec.bba_attribute21;
525: per_bba_shd.g_old_rec.bba_attribute20;
526: End If;
527: If (p_rec.bba_attribute21 = hr_api.g_varchar2) then
528: p_rec.bba_attribute21:=
529: per_bba_shd.g_old_rec.bba_attribute21;
530: End If;
531: If (p_rec.bba_attribute22 = hr_api.g_varchar2) then
532: p_rec.bba_attribute22:=
533: per_bba_shd.g_old_rec.bba_attribute22;
529: per_bba_shd.g_old_rec.bba_attribute21;
530: End If;
531: If (p_rec.bba_attribute22 = hr_api.g_varchar2) then
532: p_rec.bba_attribute22:=
533: per_bba_shd.g_old_rec.bba_attribute22;
534: End If;
535: If (p_rec.bba_attribute23 = hr_api.g_varchar2) then
536: p_rec.bba_attribute23:=
537: per_bba_shd.g_old_rec.bba_attribute23;
533: per_bba_shd.g_old_rec.bba_attribute22;
534: End If;
535: If (p_rec.bba_attribute23 = hr_api.g_varchar2) then
536: p_rec.bba_attribute23:=
537: per_bba_shd.g_old_rec.bba_attribute23;
538: End If;
539: If (p_rec.bba_attribute24 = hr_api.g_varchar2) then
540: p_rec.bba_attribute24:=
541: per_bba_shd.g_old_rec.bba_attribute24;
537: per_bba_shd.g_old_rec.bba_attribute23;
538: End If;
539: If (p_rec.bba_attribute24 = hr_api.g_varchar2) then
540: p_rec.bba_attribute24:=
541: per_bba_shd.g_old_rec.bba_attribute24;
542: End If;
543: If (p_rec.bba_attribute25 = hr_api.g_varchar2) then
544: p_rec.bba_attribute25:=
545: per_bba_shd.g_old_rec.bba_attribute25;
541: per_bba_shd.g_old_rec.bba_attribute24;
542: End If;
543: If (p_rec.bba_attribute25 = hr_api.g_varchar2) then
544: p_rec.bba_attribute25:=
545: per_bba_shd.g_old_rec.bba_attribute25;
546: End If;
547: If (p_rec.bba_attribute26 = hr_api.g_varchar2) then
548: p_rec.bba_attribute26:=
549: per_bba_shd.g_old_rec.bba_attribute26;
545: per_bba_shd.g_old_rec.bba_attribute25;
546: End If;
547: If (p_rec.bba_attribute26 = hr_api.g_varchar2) then
548: p_rec.bba_attribute26:=
549: per_bba_shd.g_old_rec.bba_attribute26;
550: End If;
551: If (p_rec.bba_attribute27 = hr_api.g_varchar2) then
552: p_rec.bba_attribute27:=
553: per_bba_shd.g_old_rec.bba_attribute27;
549: per_bba_shd.g_old_rec.bba_attribute26;
550: End If;
551: If (p_rec.bba_attribute27 = hr_api.g_varchar2) then
552: p_rec.bba_attribute27:=
553: per_bba_shd.g_old_rec.bba_attribute27;
554: End If;
555: If (p_rec.bba_attribute28 = hr_api.g_varchar2) then
556: p_rec.bba_attribute28:=
557: per_bba_shd.g_old_rec.bba_attribute28;
553: per_bba_shd.g_old_rec.bba_attribute27;
554: End If;
555: If (p_rec.bba_attribute28 = hr_api.g_varchar2) then
556: p_rec.bba_attribute28:=
557: per_bba_shd.g_old_rec.bba_attribute28;
558: End If;
559: If (p_rec.bba_attribute29 = hr_api.g_varchar2) then
560: p_rec.bba_attribute29:=
561: per_bba_shd.g_old_rec.bba_attribute29;
557: per_bba_shd.g_old_rec.bba_attribute28;
558: End If;
559: If (p_rec.bba_attribute29 = hr_api.g_varchar2) then
560: p_rec.bba_attribute29:=
561: per_bba_shd.g_old_rec.bba_attribute29;
562: End If;
563: If (p_rec.bba_attribute30 = hr_api.g_varchar2) then
564: p_rec.bba_attribute30:=
565: per_bba_shd.g_old_rec.bba_attribute30;
561: per_bba_shd.g_old_rec.bba_attribute29;
562: End If;
563: If (p_rec.bba_attribute30 = hr_api.g_varchar2) then
564: p_rec.bba_attribute30:=
565: per_bba_shd.g_old_rec.bba_attribute30;
566: End If;
567: --
568: hr_utility.set_location(' Leaving:'||l_proc, 10);
569: --
574: -- ----------------------------------------------------------------------------
575: Procedure upd
576: (
577: p_effective_date in date,
578: p_rec in out nocopy per_bba_shd.g_rec_type
579: ) is
580: --
581: l_proc varchar2(72) := g_package||'upd';
582: --
584: hr_utility.set_location('Entering:'||l_proc, 5);
585: --
586: -- We must lock the row which we need to update.
587: --
588: per_bba_shd.lck
589: (
590: p_rec.balance_amount_id,
591: p_rec.object_version_number
592: );
662: p_bba_attribute29 in varchar2 default hr_api.g_varchar2,
663: p_bba_attribute30 in varchar2 default hr_api.g_varchar2
664: ) is
665: --
666: l_rec per_bba_shd.g_rec_type;
667: l_proc varchar2(72) := g_package||'upd';
668: --
669: Begin
670: hr_utility.set_location('Entering:'||l_proc, 5);
672: -- Call conversion function to turn arguments into the
673: -- l_rec structure.
674: --
675: l_rec :=
676: per_bba_shd.convert_args
677: (
678: p_balance_amount_id,
679: hr_api.g_number,
680: hr_api.g_number,