110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
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
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
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
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
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
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
125: (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
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
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;
129: --
336: );
337: --
338: exception
339: --
340: when hr_api.cannot_find_prog_unit then
341: --
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'PER_BF_BALANCE_AMOUNTS'
344: ,p_hook_type => 'AU');
338: exception
339: --
340: when hr_api.cannot_find_prog_unit then
341: --
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'PER_BF_BALANCE_AMOUNTS'
344: ,p_hook_type => 'AU');
345: --
346: end;
403: -- p_rec plsql record structure
404: -- to see if a system default is being used. If a system default
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
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;
414: End If;
415: If (p_rec.business_group_id = hr_api.g_number) then
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;
418: End If;
419: If (p_rec.ytd_amount = hr_api.g_number) then
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;
422: End If;
423: If (p_rec.fytd_amount = hr_api.g_number) then
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;
426: End If;
427: If (p_rec.ptd_amount = hr_api.g_number) then
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;
430: End If;
431: If (p_rec.mtd_amount = hr_api.g_number) then
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;
434: End If;
435: If (p_rec.qtd_amount = hr_api.g_number) then
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;
438: End If;
439: If (p_rec.run_amount = hr_api.g_number) then
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;
442: End If;
443: If (p_rec.bba_attribute_category = hr_api.g_varchar2) then
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;
446: End If;
447: If (p_rec.bba_attribute1 = hr_api.g_varchar2) then
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;
450: End If;
451: If (p_rec.bba_attribute2 = hr_api.g_varchar2) then
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;
454: End If;
455: If (p_rec.bba_attribute3 = hr_api.g_varchar2) then
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;
458: End If;
459: If (p_rec.bba_attribute4 = hr_api.g_varchar2) then
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;
462: End If;
463: If (p_rec.bba_attribute5 = hr_api.g_varchar2) then
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;
466: End If;
467: If (p_rec.bba_attribute6 = hr_api.g_varchar2) then
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;
470: End If;
471: If (p_rec.bba_attribute7 = hr_api.g_varchar2) then
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;
474: End If;
475: If (p_rec.bba_attribute8 = hr_api.g_varchar2) then
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;
478: End If;
479: If (p_rec.bba_attribute9 = hr_api.g_varchar2) then
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;
482: End If;
483: If (p_rec.bba_attribute10 = hr_api.g_varchar2) then
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;
486: End If;
487: If (p_rec.bba_attribute11 = hr_api.g_varchar2) then
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;
490: End If;
491: If (p_rec.bba_attribute12 = hr_api.g_varchar2) then
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;
494: End If;
495: If (p_rec.bba_attribute13 = hr_api.g_varchar2) then
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;
498: End If;
499: If (p_rec.bba_attribute14 = hr_api.g_varchar2) then
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;
502: End If;
503: If (p_rec.bba_attribute15 = hr_api.g_varchar2) then
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;
506: End If;
507: If (p_rec.bba_attribute16 = hr_api.g_varchar2) then
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;
510: End If;
511: If (p_rec.bba_attribute17 = hr_api.g_varchar2) then
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;
514: End If;
515: If (p_rec.bba_attribute18 = hr_api.g_varchar2) then
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;
518: End If;
519: If (p_rec.bba_attribute19 = hr_api.g_varchar2) then
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;
522: End If;
523: If (p_rec.bba_attribute20 = hr_api.g_varchar2) then
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;
526: End If;
527: If (p_rec.bba_attribute21 = hr_api.g_varchar2) then
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;
530: End If;
531: If (p_rec.bba_attribute22 = hr_api.g_varchar2) then
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;
534: End If;
535: If (p_rec.bba_attribute23 = hr_api.g_varchar2) then
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;
538: End If;
539: If (p_rec.bba_attribute24 = hr_api.g_varchar2) then
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;
542: End If;
543: If (p_rec.bba_attribute25 = hr_api.g_varchar2) then
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;
546: End If;
547: If (p_rec.bba_attribute26 = hr_api.g_varchar2) then
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;
550: End If;
551: If (p_rec.bba_attribute27 = hr_api.g_varchar2) then
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;
554: End If;
555: If (p_rec.bba_attribute28 = hr_api.g_varchar2) then
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;
558: End If;
559: If (p_rec.bba_attribute29 = hr_api.g_varchar2) then
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;
562: End If;
563: If (p_rec.bba_attribute30 = hr_api.g_varchar2) then
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;
566: End If;
567: --
622: Procedure upd
623: (
624: p_effective_date in date,
625: p_balance_amount_id in number,
626: p_ytd_amount in number default hr_api.g_number,
627: p_fytd_amount in number default hr_api.g_number,
628: p_ptd_amount in number default hr_api.g_number,
629: p_mtd_amount in number default hr_api.g_number,
630: p_qtd_amount in number default hr_api.g_number,
623: (
624: p_effective_date in date,
625: p_balance_amount_id in number,
626: p_ytd_amount in number default hr_api.g_number,
627: p_fytd_amount in number default hr_api.g_number,
628: p_ptd_amount in number default hr_api.g_number,
629: p_mtd_amount in number default hr_api.g_number,
630: p_qtd_amount in number default hr_api.g_number,
631: p_run_amount in number default hr_api.g_number,
624: p_effective_date in date,
625: p_balance_amount_id in number,
626: p_ytd_amount in number default hr_api.g_number,
627: p_fytd_amount in number default hr_api.g_number,
628: p_ptd_amount in number default hr_api.g_number,
629: p_mtd_amount in number default hr_api.g_number,
630: p_qtd_amount in number default hr_api.g_number,
631: p_run_amount in number default hr_api.g_number,
632: p_object_version_number in out nocopy number,
625: p_balance_amount_id in number,
626: p_ytd_amount in number default hr_api.g_number,
627: p_fytd_amount in number default hr_api.g_number,
628: p_ptd_amount in number default hr_api.g_number,
629: p_mtd_amount in number default hr_api.g_number,
630: p_qtd_amount in number default hr_api.g_number,
631: p_run_amount in number default hr_api.g_number,
632: p_object_version_number in out nocopy number,
633: p_bba_attribute_category in varchar2 default hr_api.g_varchar2,
626: p_ytd_amount in number default hr_api.g_number,
627: p_fytd_amount in number default hr_api.g_number,
628: p_ptd_amount in number default hr_api.g_number,
629: p_mtd_amount in number default hr_api.g_number,
630: p_qtd_amount in number default hr_api.g_number,
631: p_run_amount in number default hr_api.g_number,
632: p_object_version_number in out nocopy number,
633: p_bba_attribute_category in varchar2 default hr_api.g_varchar2,
634: p_bba_attribute1 in varchar2 default hr_api.g_varchar2,
627: p_fytd_amount in number default hr_api.g_number,
628: p_ptd_amount in number default hr_api.g_number,
629: p_mtd_amount in number default hr_api.g_number,
630: p_qtd_amount in number default hr_api.g_number,
631: p_run_amount in number default hr_api.g_number,
632: p_object_version_number in out nocopy number,
633: p_bba_attribute_category in varchar2 default hr_api.g_varchar2,
634: p_bba_attribute1 in varchar2 default hr_api.g_varchar2,
635: p_bba_attribute2 in varchar2 default hr_api.g_varchar2,
629: p_mtd_amount in number default hr_api.g_number,
630: p_qtd_amount in number default hr_api.g_number,
631: p_run_amount in number default hr_api.g_number,
632: p_object_version_number in out nocopy number,
633: p_bba_attribute_category in varchar2 default hr_api.g_varchar2,
634: p_bba_attribute1 in varchar2 default hr_api.g_varchar2,
635: p_bba_attribute2 in varchar2 default hr_api.g_varchar2,
636: p_bba_attribute3 in varchar2 default hr_api.g_varchar2,
637: p_bba_attribute4 in varchar2 default hr_api.g_varchar2,
630: p_qtd_amount in number default hr_api.g_number,
631: p_run_amount in number default hr_api.g_number,
632: p_object_version_number in out nocopy number,
633: p_bba_attribute_category in varchar2 default hr_api.g_varchar2,
634: p_bba_attribute1 in varchar2 default hr_api.g_varchar2,
635: p_bba_attribute2 in varchar2 default hr_api.g_varchar2,
636: p_bba_attribute3 in varchar2 default hr_api.g_varchar2,
637: p_bba_attribute4 in varchar2 default hr_api.g_varchar2,
638: p_bba_attribute5 in varchar2 default hr_api.g_varchar2,
631: p_run_amount in number default hr_api.g_number,
632: p_object_version_number in out nocopy number,
633: p_bba_attribute_category in varchar2 default hr_api.g_varchar2,
634: p_bba_attribute1 in varchar2 default hr_api.g_varchar2,
635: p_bba_attribute2 in varchar2 default hr_api.g_varchar2,
636: p_bba_attribute3 in varchar2 default hr_api.g_varchar2,
637: p_bba_attribute4 in varchar2 default hr_api.g_varchar2,
638: p_bba_attribute5 in varchar2 default hr_api.g_varchar2,
639: p_bba_attribute6 in varchar2 default hr_api.g_varchar2,
632: p_object_version_number in out nocopy number,
633: p_bba_attribute_category in varchar2 default hr_api.g_varchar2,
634: p_bba_attribute1 in varchar2 default hr_api.g_varchar2,
635: p_bba_attribute2 in varchar2 default hr_api.g_varchar2,
636: p_bba_attribute3 in varchar2 default hr_api.g_varchar2,
637: p_bba_attribute4 in varchar2 default hr_api.g_varchar2,
638: p_bba_attribute5 in varchar2 default hr_api.g_varchar2,
639: p_bba_attribute6 in varchar2 default hr_api.g_varchar2,
640: p_bba_attribute7 in varchar2 default hr_api.g_varchar2,
633: p_bba_attribute_category in varchar2 default hr_api.g_varchar2,
634: p_bba_attribute1 in varchar2 default hr_api.g_varchar2,
635: p_bba_attribute2 in varchar2 default hr_api.g_varchar2,
636: p_bba_attribute3 in varchar2 default hr_api.g_varchar2,
637: p_bba_attribute4 in varchar2 default hr_api.g_varchar2,
638: p_bba_attribute5 in varchar2 default hr_api.g_varchar2,
639: p_bba_attribute6 in varchar2 default hr_api.g_varchar2,
640: p_bba_attribute7 in varchar2 default hr_api.g_varchar2,
641: p_bba_attribute8 in varchar2 default hr_api.g_varchar2,
634: p_bba_attribute1 in varchar2 default hr_api.g_varchar2,
635: p_bba_attribute2 in varchar2 default hr_api.g_varchar2,
636: p_bba_attribute3 in varchar2 default hr_api.g_varchar2,
637: p_bba_attribute4 in varchar2 default hr_api.g_varchar2,
638: p_bba_attribute5 in varchar2 default hr_api.g_varchar2,
639: p_bba_attribute6 in varchar2 default hr_api.g_varchar2,
640: p_bba_attribute7 in varchar2 default hr_api.g_varchar2,
641: p_bba_attribute8 in varchar2 default hr_api.g_varchar2,
642: p_bba_attribute9 in varchar2 default hr_api.g_varchar2,
635: p_bba_attribute2 in varchar2 default hr_api.g_varchar2,
636: p_bba_attribute3 in varchar2 default hr_api.g_varchar2,
637: p_bba_attribute4 in varchar2 default hr_api.g_varchar2,
638: p_bba_attribute5 in varchar2 default hr_api.g_varchar2,
639: p_bba_attribute6 in varchar2 default hr_api.g_varchar2,
640: p_bba_attribute7 in varchar2 default hr_api.g_varchar2,
641: p_bba_attribute8 in varchar2 default hr_api.g_varchar2,
642: p_bba_attribute9 in varchar2 default hr_api.g_varchar2,
643: p_bba_attribute10 in varchar2 default hr_api.g_varchar2,
636: p_bba_attribute3 in varchar2 default hr_api.g_varchar2,
637: p_bba_attribute4 in varchar2 default hr_api.g_varchar2,
638: p_bba_attribute5 in varchar2 default hr_api.g_varchar2,
639: p_bba_attribute6 in varchar2 default hr_api.g_varchar2,
640: p_bba_attribute7 in varchar2 default hr_api.g_varchar2,
641: p_bba_attribute8 in varchar2 default hr_api.g_varchar2,
642: p_bba_attribute9 in varchar2 default hr_api.g_varchar2,
643: p_bba_attribute10 in varchar2 default hr_api.g_varchar2,
644: p_bba_attribute11 in varchar2 default hr_api.g_varchar2,
637: p_bba_attribute4 in varchar2 default hr_api.g_varchar2,
638: p_bba_attribute5 in varchar2 default hr_api.g_varchar2,
639: p_bba_attribute6 in varchar2 default hr_api.g_varchar2,
640: p_bba_attribute7 in varchar2 default hr_api.g_varchar2,
641: p_bba_attribute8 in varchar2 default hr_api.g_varchar2,
642: p_bba_attribute9 in varchar2 default hr_api.g_varchar2,
643: p_bba_attribute10 in varchar2 default hr_api.g_varchar2,
644: p_bba_attribute11 in varchar2 default hr_api.g_varchar2,
645: p_bba_attribute12 in varchar2 default hr_api.g_varchar2,
638: p_bba_attribute5 in varchar2 default hr_api.g_varchar2,
639: p_bba_attribute6 in varchar2 default hr_api.g_varchar2,
640: p_bba_attribute7 in varchar2 default hr_api.g_varchar2,
641: p_bba_attribute8 in varchar2 default hr_api.g_varchar2,
642: p_bba_attribute9 in varchar2 default hr_api.g_varchar2,
643: p_bba_attribute10 in varchar2 default hr_api.g_varchar2,
644: p_bba_attribute11 in varchar2 default hr_api.g_varchar2,
645: p_bba_attribute12 in varchar2 default hr_api.g_varchar2,
646: p_bba_attribute13 in varchar2 default hr_api.g_varchar2,
639: p_bba_attribute6 in varchar2 default hr_api.g_varchar2,
640: p_bba_attribute7 in varchar2 default hr_api.g_varchar2,
641: p_bba_attribute8 in varchar2 default hr_api.g_varchar2,
642: p_bba_attribute9 in varchar2 default hr_api.g_varchar2,
643: p_bba_attribute10 in varchar2 default hr_api.g_varchar2,
644: p_bba_attribute11 in varchar2 default hr_api.g_varchar2,
645: p_bba_attribute12 in varchar2 default hr_api.g_varchar2,
646: p_bba_attribute13 in varchar2 default hr_api.g_varchar2,
647: p_bba_attribute14 in varchar2 default hr_api.g_varchar2,
640: p_bba_attribute7 in varchar2 default hr_api.g_varchar2,
641: p_bba_attribute8 in varchar2 default hr_api.g_varchar2,
642: p_bba_attribute9 in varchar2 default hr_api.g_varchar2,
643: p_bba_attribute10 in varchar2 default hr_api.g_varchar2,
644: p_bba_attribute11 in varchar2 default hr_api.g_varchar2,
645: p_bba_attribute12 in varchar2 default hr_api.g_varchar2,
646: p_bba_attribute13 in varchar2 default hr_api.g_varchar2,
647: p_bba_attribute14 in varchar2 default hr_api.g_varchar2,
648: p_bba_attribute15 in varchar2 default hr_api.g_varchar2,
641: p_bba_attribute8 in varchar2 default hr_api.g_varchar2,
642: p_bba_attribute9 in varchar2 default hr_api.g_varchar2,
643: p_bba_attribute10 in varchar2 default hr_api.g_varchar2,
644: p_bba_attribute11 in varchar2 default hr_api.g_varchar2,
645: p_bba_attribute12 in varchar2 default hr_api.g_varchar2,
646: p_bba_attribute13 in varchar2 default hr_api.g_varchar2,
647: p_bba_attribute14 in varchar2 default hr_api.g_varchar2,
648: p_bba_attribute15 in varchar2 default hr_api.g_varchar2,
649: p_bba_attribute16 in varchar2 default hr_api.g_varchar2,
642: p_bba_attribute9 in varchar2 default hr_api.g_varchar2,
643: p_bba_attribute10 in varchar2 default hr_api.g_varchar2,
644: p_bba_attribute11 in varchar2 default hr_api.g_varchar2,
645: p_bba_attribute12 in varchar2 default hr_api.g_varchar2,
646: p_bba_attribute13 in varchar2 default hr_api.g_varchar2,
647: p_bba_attribute14 in varchar2 default hr_api.g_varchar2,
648: p_bba_attribute15 in varchar2 default hr_api.g_varchar2,
649: p_bba_attribute16 in varchar2 default hr_api.g_varchar2,
650: p_bba_attribute17 in varchar2 default hr_api.g_varchar2,
643: p_bba_attribute10 in varchar2 default hr_api.g_varchar2,
644: p_bba_attribute11 in varchar2 default hr_api.g_varchar2,
645: p_bba_attribute12 in varchar2 default hr_api.g_varchar2,
646: p_bba_attribute13 in varchar2 default hr_api.g_varchar2,
647: p_bba_attribute14 in varchar2 default hr_api.g_varchar2,
648: p_bba_attribute15 in varchar2 default hr_api.g_varchar2,
649: p_bba_attribute16 in varchar2 default hr_api.g_varchar2,
650: p_bba_attribute17 in varchar2 default hr_api.g_varchar2,
651: p_bba_attribute18 in varchar2 default hr_api.g_varchar2,
644: p_bba_attribute11 in varchar2 default hr_api.g_varchar2,
645: p_bba_attribute12 in varchar2 default hr_api.g_varchar2,
646: p_bba_attribute13 in varchar2 default hr_api.g_varchar2,
647: p_bba_attribute14 in varchar2 default hr_api.g_varchar2,
648: p_bba_attribute15 in varchar2 default hr_api.g_varchar2,
649: p_bba_attribute16 in varchar2 default hr_api.g_varchar2,
650: p_bba_attribute17 in varchar2 default hr_api.g_varchar2,
651: p_bba_attribute18 in varchar2 default hr_api.g_varchar2,
652: p_bba_attribute19 in varchar2 default hr_api.g_varchar2,
645: p_bba_attribute12 in varchar2 default hr_api.g_varchar2,
646: p_bba_attribute13 in varchar2 default hr_api.g_varchar2,
647: p_bba_attribute14 in varchar2 default hr_api.g_varchar2,
648: p_bba_attribute15 in varchar2 default hr_api.g_varchar2,
649: p_bba_attribute16 in varchar2 default hr_api.g_varchar2,
650: p_bba_attribute17 in varchar2 default hr_api.g_varchar2,
651: p_bba_attribute18 in varchar2 default hr_api.g_varchar2,
652: p_bba_attribute19 in varchar2 default hr_api.g_varchar2,
653: p_bba_attribute20 in varchar2 default hr_api.g_varchar2,
646: p_bba_attribute13 in varchar2 default hr_api.g_varchar2,
647: p_bba_attribute14 in varchar2 default hr_api.g_varchar2,
648: p_bba_attribute15 in varchar2 default hr_api.g_varchar2,
649: p_bba_attribute16 in varchar2 default hr_api.g_varchar2,
650: p_bba_attribute17 in varchar2 default hr_api.g_varchar2,
651: p_bba_attribute18 in varchar2 default hr_api.g_varchar2,
652: p_bba_attribute19 in varchar2 default hr_api.g_varchar2,
653: p_bba_attribute20 in varchar2 default hr_api.g_varchar2,
654: p_bba_attribute21 in varchar2 default hr_api.g_varchar2,
647: p_bba_attribute14 in varchar2 default hr_api.g_varchar2,
648: p_bba_attribute15 in varchar2 default hr_api.g_varchar2,
649: p_bba_attribute16 in varchar2 default hr_api.g_varchar2,
650: p_bba_attribute17 in varchar2 default hr_api.g_varchar2,
651: p_bba_attribute18 in varchar2 default hr_api.g_varchar2,
652: p_bba_attribute19 in varchar2 default hr_api.g_varchar2,
653: p_bba_attribute20 in varchar2 default hr_api.g_varchar2,
654: p_bba_attribute21 in varchar2 default hr_api.g_varchar2,
655: p_bba_attribute22 in varchar2 default hr_api.g_varchar2,
648: p_bba_attribute15 in varchar2 default hr_api.g_varchar2,
649: p_bba_attribute16 in varchar2 default hr_api.g_varchar2,
650: p_bba_attribute17 in varchar2 default hr_api.g_varchar2,
651: p_bba_attribute18 in varchar2 default hr_api.g_varchar2,
652: p_bba_attribute19 in varchar2 default hr_api.g_varchar2,
653: p_bba_attribute20 in varchar2 default hr_api.g_varchar2,
654: p_bba_attribute21 in varchar2 default hr_api.g_varchar2,
655: p_bba_attribute22 in varchar2 default hr_api.g_varchar2,
656: p_bba_attribute23 in varchar2 default hr_api.g_varchar2,
649: p_bba_attribute16 in varchar2 default hr_api.g_varchar2,
650: p_bba_attribute17 in varchar2 default hr_api.g_varchar2,
651: p_bba_attribute18 in varchar2 default hr_api.g_varchar2,
652: p_bba_attribute19 in varchar2 default hr_api.g_varchar2,
653: p_bba_attribute20 in varchar2 default hr_api.g_varchar2,
654: p_bba_attribute21 in varchar2 default hr_api.g_varchar2,
655: p_bba_attribute22 in varchar2 default hr_api.g_varchar2,
656: p_bba_attribute23 in varchar2 default hr_api.g_varchar2,
657: p_bba_attribute24 in varchar2 default hr_api.g_varchar2,
650: p_bba_attribute17 in varchar2 default hr_api.g_varchar2,
651: p_bba_attribute18 in varchar2 default hr_api.g_varchar2,
652: p_bba_attribute19 in varchar2 default hr_api.g_varchar2,
653: p_bba_attribute20 in varchar2 default hr_api.g_varchar2,
654: p_bba_attribute21 in varchar2 default hr_api.g_varchar2,
655: p_bba_attribute22 in varchar2 default hr_api.g_varchar2,
656: p_bba_attribute23 in varchar2 default hr_api.g_varchar2,
657: p_bba_attribute24 in varchar2 default hr_api.g_varchar2,
658: p_bba_attribute25 in varchar2 default hr_api.g_varchar2,
651: p_bba_attribute18 in varchar2 default hr_api.g_varchar2,
652: p_bba_attribute19 in varchar2 default hr_api.g_varchar2,
653: p_bba_attribute20 in varchar2 default hr_api.g_varchar2,
654: p_bba_attribute21 in varchar2 default hr_api.g_varchar2,
655: p_bba_attribute22 in varchar2 default hr_api.g_varchar2,
656: p_bba_attribute23 in varchar2 default hr_api.g_varchar2,
657: p_bba_attribute24 in varchar2 default hr_api.g_varchar2,
658: p_bba_attribute25 in varchar2 default hr_api.g_varchar2,
659: p_bba_attribute26 in varchar2 default hr_api.g_varchar2,
652: p_bba_attribute19 in varchar2 default hr_api.g_varchar2,
653: p_bba_attribute20 in varchar2 default hr_api.g_varchar2,
654: p_bba_attribute21 in varchar2 default hr_api.g_varchar2,
655: p_bba_attribute22 in varchar2 default hr_api.g_varchar2,
656: p_bba_attribute23 in varchar2 default hr_api.g_varchar2,
657: p_bba_attribute24 in varchar2 default hr_api.g_varchar2,
658: p_bba_attribute25 in varchar2 default hr_api.g_varchar2,
659: p_bba_attribute26 in varchar2 default hr_api.g_varchar2,
660: p_bba_attribute27 in varchar2 default hr_api.g_varchar2,
653: p_bba_attribute20 in varchar2 default hr_api.g_varchar2,
654: p_bba_attribute21 in varchar2 default hr_api.g_varchar2,
655: p_bba_attribute22 in varchar2 default hr_api.g_varchar2,
656: p_bba_attribute23 in varchar2 default hr_api.g_varchar2,
657: p_bba_attribute24 in varchar2 default hr_api.g_varchar2,
658: p_bba_attribute25 in varchar2 default hr_api.g_varchar2,
659: p_bba_attribute26 in varchar2 default hr_api.g_varchar2,
660: p_bba_attribute27 in varchar2 default hr_api.g_varchar2,
661: p_bba_attribute28 in varchar2 default hr_api.g_varchar2,
654: p_bba_attribute21 in varchar2 default hr_api.g_varchar2,
655: p_bba_attribute22 in varchar2 default hr_api.g_varchar2,
656: p_bba_attribute23 in varchar2 default hr_api.g_varchar2,
657: p_bba_attribute24 in varchar2 default hr_api.g_varchar2,
658: p_bba_attribute25 in varchar2 default hr_api.g_varchar2,
659: p_bba_attribute26 in varchar2 default hr_api.g_varchar2,
660: p_bba_attribute27 in varchar2 default hr_api.g_varchar2,
661: p_bba_attribute28 in varchar2 default hr_api.g_varchar2,
662: p_bba_attribute29 in varchar2 default hr_api.g_varchar2,
655: p_bba_attribute22 in varchar2 default hr_api.g_varchar2,
656: p_bba_attribute23 in varchar2 default hr_api.g_varchar2,
657: p_bba_attribute24 in varchar2 default hr_api.g_varchar2,
658: p_bba_attribute25 in varchar2 default hr_api.g_varchar2,
659: p_bba_attribute26 in varchar2 default hr_api.g_varchar2,
660: p_bba_attribute27 in varchar2 default hr_api.g_varchar2,
661: p_bba_attribute28 in varchar2 default hr_api.g_varchar2,
662: p_bba_attribute29 in varchar2 default hr_api.g_varchar2,
663: p_bba_attribute30 in varchar2 default hr_api.g_varchar2
656: p_bba_attribute23 in varchar2 default hr_api.g_varchar2,
657: p_bba_attribute24 in varchar2 default hr_api.g_varchar2,
658: p_bba_attribute25 in varchar2 default hr_api.g_varchar2,
659: p_bba_attribute26 in varchar2 default hr_api.g_varchar2,
660: p_bba_attribute27 in varchar2 default hr_api.g_varchar2,
661: p_bba_attribute28 in varchar2 default hr_api.g_varchar2,
662: p_bba_attribute29 in varchar2 default hr_api.g_varchar2,
663: p_bba_attribute30 in varchar2 default hr_api.g_varchar2
664: ) is
657: p_bba_attribute24 in varchar2 default hr_api.g_varchar2,
658: p_bba_attribute25 in varchar2 default hr_api.g_varchar2,
659: p_bba_attribute26 in varchar2 default hr_api.g_varchar2,
660: p_bba_attribute27 in varchar2 default hr_api.g_varchar2,
661: p_bba_attribute28 in varchar2 default hr_api.g_varchar2,
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: --
658: p_bba_attribute25 in varchar2 default hr_api.g_varchar2,
659: p_bba_attribute26 in varchar2 default hr_api.g_varchar2,
660: p_bba_attribute27 in varchar2 default hr_api.g_varchar2,
661: p_bba_attribute28 in varchar2 default hr_api.g_varchar2,
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;
659: p_bba_attribute26 in varchar2 default hr_api.g_varchar2,
660: p_bba_attribute27 in varchar2 default hr_api.g_varchar2,
661: p_bba_attribute28 in varchar2 default hr_api.g_varchar2,
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';
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,
681: hr_api.g_number,
682: p_ytd_amount,
683: p_fytd_amount,
676: per_bba_shd.convert_args
677: (
678: p_balance_amount_id,
679: hr_api.g_number,
680: hr_api.g_number,
681: hr_api.g_number,
682: p_ytd_amount,
683: p_fytd_amount,
684: p_ptd_amount,
677: (
678: p_balance_amount_id,
679: hr_api.g_number,
680: hr_api.g_number,
681: hr_api.g_number,
682: p_ytd_amount,
683: p_fytd_amount,
684: p_ptd_amount,
685: p_mtd_amount,