109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 10);
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
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
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
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
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
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
124: (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
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
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;
128: --
327: );
328: --
329: exception
330: --
331: when hr_api.cannot_find_prog_unit then
332: --
333: hr_api.cannot_find_prog_unit_error
334: (p_module_name => 'PER_BF_PAYROLL_RUNS'
335: ,p_hook_type => 'AU');
329: exception
330: --
331: when hr_api.cannot_find_prog_unit then
332: --
333: hr_api.cannot_find_prog_unit_error
334: (p_module_name => 'PER_BF_PAYROLL_RUNS'
335: ,p_hook_type => 'AU');
336: --
337: end;
394: -- p_rec plsql record structure
395: -- to see if a system default is being used. If a system default
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
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;
405: End If;
406: If (p_rec.payroll_identifier = hr_api.g_varchar2) then
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;
409: End If;
410: If (p_rec.period_start_date = hr_api.g_date) then
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;
413: End If;
414: If (p_rec.period_end_date = hr_api.g_date) then
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;
417: End If;
418: If (p_rec.processing_date = hr_api.g_date) then
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;
421: End If;
422: If (p_rec.bpr_attribute_category = hr_api.g_varchar2) then
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;
425: End If;
426: If (p_rec.bpr_attribute1 = hr_api.g_varchar2) then
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;
429: End If;
430: If (p_rec.bpr_attribute2 = hr_api.g_varchar2) then
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;
433: End If;
434: If (p_rec.bpr_attribute3 = hr_api.g_varchar2) then
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;
437: End If;
438: If (p_rec.bpr_attribute4 = hr_api.g_varchar2) then
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;
441: End If;
442: If (p_rec.bpr_attribute5 = hr_api.g_varchar2) then
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;
445: End If;
446: If (p_rec.bpr_attribute6 = hr_api.g_varchar2) then
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;
449: End If;
450: If (p_rec.bpr_attribute7 = hr_api.g_varchar2) then
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;
453: End If;
454: If (p_rec.bpr_attribute8 = hr_api.g_varchar2) then
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;
457: End If;
458: If (p_rec.bpr_attribute9 = hr_api.g_varchar2) then
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;
461: End If;
462: If (p_rec.bpr_attribute10 = hr_api.g_varchar2) then
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;
465: End If;
466: If (p_rec.bpr_attribute11 = hr_api.g_varchar2) then
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;
469: End If;
470: If (p_rec.bpr_attribute12 = hr_api.g_varchar2) then
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;
473: End If;
474: If (p_rec.bpr_attribute13 = hr_api.g_varchar2) then
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;
477: End If;
478: If (p_rec.bpr_attribute14 = hr_api.g_varchar2) then
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;
481: End If;
482: If (p_rec.bpr_attribute15 = hr_api.g_varchar2) then
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;
485: End If;
486: If (p_rec.bpr_attribute16 = hr_api.g_varchar2) then
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;
489: End If;
490: If (p_rec.bpr_attribute17 = hr_api.g_varchar2) then
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;
493: End If;
494: If (p_rec.bpr_attribute18 = hr_api.g_varchar2) then
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;
497: End If;
498: If (p_rec.bpr_attribute19 = hr_api.g_varchar2) then
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;
501: End If;
502: If (p_rec.bpr_attribute20 = hr_api.g_varchar2) then
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;
505: End If;
506: If (p_rec.bpr_attribute21 = hr_api.g_varchar2) then
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;
509: End If;
510: If (p_rec.bpr_attribute22 = hr_api.g_varchar2) then
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;
513: End If;
514: If (p_rec.bpr_attribute23 = hr_api.g_varchar2) then
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;
517: End If;
518: If (p_rec.bpr_attribute24 = hr_api.g_varchar2) then
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;
521: End If;
522: If (p_rec.bpr_attribute25 = hr_api.g_varchar2) then
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;
525: End If;
526: If (p_rec.bpr_attribute26 = hr_api.g_varchar2) then
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;
529: End If;
530: If (p_rec.bpr_attribute27 = hr_api.g_varchar2) then
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;
533: End If;
534: If (p_rec.bpr_attribute28 = hr_api.g_varchar2) then
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;
537: End If;
538: If (p_rec.bpr_attribute29 = hr_api.g_varchar2) then
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;
541: End If;
542: If (p_rec.bpr_attribute30 = hr_api.g_varchar2) then
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;
545: End If;
546:
602: Procedure upd
603: (
604: p_effective_date in date,
605: p_payroll_run_id in number,
606: p_payroll_identifier in varchar2 default hr_api.g_varchar2,
607: p_period_start_date in date default hr_api.g_date,
608: p_period_end_date in date default hr_api.g_date,
609: p_processing_date in date default hr_api.g_date,
610: p_object_version_number in out nocopy number,
603: (
604: p_effective_date in date,
605: p_payroll_run_id in number,
606: p_payroll_identifier in varchar2 default hr_api.g_varchar2,
607: p_period_start_date in date default hr_api.g_date,
608: p_period_end_date in date default hr_api.g_date,
609: p_processing_date in date default hr_api.g_date,
610: p_object_version_number in out nocopy number,
611: p_bpr_attribute_category in varchar2 default hr_api.g_varchar2,
604: p_effective_date in date,
605: p_payroll_run_id in number,
606: p_payroll_identifier in varchar2 default hr_api.g_varchar2,
607: p_period_start_date in date default hr_api.g_date,
608: p_period_end_date in date default hr_api.g_date,
609: p_processing_date in date default hr_api.g_date,
610: p_object_version_number in out nocopy number,
611: p_bpr_attribute_category in varchar2 default hr_api.g_varchar2,
612: p_bpr_attribute1 in varchar2 default hr_api.g_varchar2,
605: p_payroll_run_id in number,
606: p_payroll_identifier in varchar2 default hr_api.g_varchar2,
607: p_period_start_date in date default hr_api.g_date,
608: p_period_end_date in date default hr_api.g_date,
609: p_processing_date in date default hr_api.g_date,
610: p_object_version_number in out nocopy number,
611: p_bpr_attribute_category in varchar2 default hr_api.g_varchar2,
612: p_bpr_attribute1 in varchar2 default hr_api.g_varchar2,
613: p_bpr_attribute2 in varchar2 default hr_api.g_varchar2,
607: p_period_start_date in date default hr_api.g_date,
608: p_period_end_date in date default hr_api.g_date,
609: p_processing_date in date default hr_api.g_date,
610: p_object_version_number in out nocopy number,
611: p_bpr_attribute_category in varchar2 default hr_api.g_varchar2,
612: p_bpr_attribute1 in varchar2 default hr_api.g_varchar2,
613: p_bpr_attribute2 in varchar2 default hr_api.g_varchar2,
614: p_bpr_attribute3 in varchar2 default hr_api.g_varchar2,
615: p_bpr_attribute4 in varchar2 default hr_api.g_varchar2,
608: p_period_end_date in date default hr_api.g_date,
609: p_processing_date in date default hr_api.g_date,
610: p_object_version_number in out nocopy number,
611: p_bpr_attribute_category in varchar2 default hr_api.g_varchar2,
612: p_bpr_attribute1 in varchar2 default hr_api.g_varchar2,
613: p_bpr_attribute2 in varchar2 default hr_api.g_varchar2,
614: p_bpr_attribute3 in varchar2 default hr_api.g_varchar2,
615: p_bpr_attribute4 in varchar2 default hr_api.g_varchar2,
616: p_bpr_attribute5 in varchar2 default hr_api.g_varchar2,
609: p_processing_date in date default hr_api.g_date,
610: p_object_version_number in out nocopy number,
611: p_bpr_attribute_category in varchar2 default hr_api.g_varchar2,
612: p_bpr_attribute1 in varchar2 default hr_api.g_varchar2,
613: p_bpr_attribute2 in varchar2 default hr_api.g_varchar2,
614: p_bpr_attribute3 in varchar2 default hr_api.g_varchar2,
615: p_bpr_attribute4 in varchar2 default hr_api.g_varchar2,
616: p_bpr_attribute5 in varchar2 default hr_api.g_varchar2,
617: p_bpr_attribute6 in varchar2 default hr_api.g_varchar2,
610: p_object_version_number in out nocopy number,
611: p_bpr_attribute_category in varchar2 default hr_api.g_varchar2,
612: p_bpr_attribute1 in varchar2 default hr_api.g_varchar2,
613: p_bpr_attribute2 in varchar2 default hr_api.g_varchar2,
614: p_bpr_attribute3 in varchar2 default hr_api.g_varchar2,
615: p_bpr_attribute4 in varchar2 default hr_api.g_varchar2,
616: p_bpr_attribute5 in varchar2 default hr_api.g_varchar2,
617: p_bpr_attribute6 in varchar2 default hr_api.g_varchar2,
618: p_bpr_attribute7 in varchar2 default hr_api.g_varchar2,
611: p_bpr_attribute_category in varchar2 default hr_api.g_varchar2,
612: p_bpr_attribute1 in varchar2 default hr_api.g_varchar2,
613: p_bpr_attribute2 in varchar2 default hr_api.g_varchar2,
614: p_bpr_attribute3 in varchar2 default hr_api.g_varchar2,
615: p_bpr_attribute4 in varchar2 default hr_api.g_varchar2,
616: p_bpr_attribute5 in varchar2 default hr_api.g_varchar2,
617: p_bpr_attribute6 in varchar2 default hr_api.g_varchar2,
618: p_bpr_attribute7 in varchar2 default hr_api.g_varchar2,
619: p_bpr_attribute8 in varchar2 default hr_api.g_varchar2,
612: p_bpr_attribute1 in varchar2 default hr_api.g_varchar2,
613: p_bpr_attribute2 in varchar2 default hr_api.g_varchar2,
614: p_bpr_attribute3 in varchar2 default hr_api.g_varchar2,
615: p_bpr_attribute4 in varchar2 default hr_api.g_varchar2,
616: p_bpr_attribute5 in varchar2 default hr_api.g_varchar2,
617: p_bpr_attribute6 in varchar2 default hr_api.g_varchar2,
618: p_bpr_attribute7 in varchar2 default hr_api.g_varchar2,
619: p_bpr_attribute8 in varchar2 default hr_api.g_varchar2,
620: p_bpr_attribute9 in varchar2 default hr_api.g_varchar2,
613: p_bpr_attribute2 in varchar2 default hr_api.g_varchar2,
614: p_bpr_attribute3 in varchar2 default hr_api.g_varchar2,
615: p_bpr_attribute4 in varchar2 default hr_api.g_varchar2,
616: p_bpr_attribute5 in varchar2 default hr_api.g_varchar2,
617: p_bpr_attribute6 in varchar2 default hr_api.g_varchar2,
618: p_bpr_attribute7 in varchar2 default hr_api.g_varchar2,
619: p_bpr_attribute8 in varchar2 default hr_api.g_varchar2,
620: p_bpr_attribute9 in varchar2 default hr_api.g_varchar2,
621: p_bpr_attribute10 in varchar2 default hr_api.g_varchar2,
614: p_bpr_attribute3 in varchar2 default hr_api.g_varchar2,
615: p_bpr_attribute4 in varchar2 default hr_api.g_varchar2,
616: p_bpr_attribute5 in varchar2 default hr_api.g_varchar2,
617: p_bpr_attribute6 in varchar2 default hr_api.g_varchar2,
618: p_bpr_attribute7 in varchar2 default hr_api.g_varchar2,
619: p_bpr_attribute8 in varchar2 default hr_api.g_varchar2,
620: p_bpr_attribute9 in varchar2 default hr_api.g_varchar2,
621: p_bpr_attribute10 in varchar2 default hr_api.g_varchar2,
622: p_bpr_attribute11 in varchar2 default hr_api.g_varchar2,
615: p_bpr_attribute4 in varchar2 default hr_api.g_varchar2,
616: p_bpr_attribute5 in varchar2 default hr_api.g_varchar2,
617: p_bpr_attribute6 in varchar2 default hr_api.g_varchar2,
618: p_bpr_attribute7 in varchar2 default hr_api.g_varchar2,
619: p_bpr_attribute8 in varchar2 default hr_api.g_varchar2,
620: p_bpr_attribute9 in varchar2 default hr_api.g_varchar2,
621: p_bpr_attribute10 in varchar2 default hr_api.g_varchar2,
622: p_bpr_attribute11 in varchar2 default hr_api.g_varchar2,
623: p_bpr_attribute12 in varchar2 default hr_api.g_varchar2,
616: p_bpr_attribute5 in varchar2 default hr_api.g_varchar2,
617: p_bpr_attribute6 in varchar2 default hr_api.g_varchar2,
618: p_bpr_attribute7 in varchar2 default hr_api.g_varchar2,
619: p_bpr_attribute8 in varchar2 default hr_api.g_varchar2,
620: p_bpr_attribute9 in varchar2 default hr_api.g_varchar2,
621: p_bpr_attribute10 in varchar2 default hr_api.g_varchar2,
622: p_bpr_attribute11 in varchar2 default hr_api.g_varchar2,
623: p_bpr_attribute12 in varchar2 default hr_api.g_varchar2,
624: p_bpr_attribute13 in varchar2 default hr_api.g_varchar2,
617: p_bpr_attribute6 in varchar2 default hr_api.g_varchar2,
618: p_bpr_attribute7 in varchar2 default hr_api.g_varchar2,
619: p_bpr_attribute8 in varchar2 default hr_api.g_varchar2,
620: p_bpr_attribute9 in varchar2 default hr_api.g_varchar2,
621: p_bpr_attribute10 in varchar2 default hr_api.g_varchar2,
622: p_bpr_attribute11 in varchar2 default hr_api.g_varchar2,
623: p_bpr_attribute12 in varchar2 default hr_api.g_varchar2,
624: p_bpr_attribute13 in varchar2 default hr_api.g_varchar2,
625: p_bpr_attribute14 in varchar2 default hr_api.g_varchar2,
618: p_bpr_attribute7 in varchar2 default hr_api.g_varchar2,
619: p_bpr_attribute8 in varchar2 default hr_api.g_varchar2,
620: p_bpr_attribute9 in varchar2 default hr_api.g_varchar2,
621: p_bpr_attribute10 in varchar2 default hr_api.g_varchar2,
622: p_bpr_attribute11 in varchar2 default hr_api.g_varchar2,
623: p_bpr_attribute12 in varchar2 default hr_api.g_varchar2,
624: p_bpr_attribute13 in varchar2 default hr_api.g_varchar2,
625: p_bpr_attribute14 in varchar2 default hr_api.g_varchar2,
626: p_bpr_attribute15 in varchar2 default hr_api.g_varchar2,
619: p_bpr_attribute8 in varchar2 default hr_api.g_varchar2,
620: p_bpr_attribute9 in varchar2 default hr_api.g_varchar2,
621: p_bpr_attribute10 in varchar2 default hr_api.g_varchar2,
622: p_bpr_attribute11 in varchar2 default hr_api.g_varchar2,
623: p_bpr_attribute12 in varchar2 default hr_api.g_varchar2,
624: p_bpr_attribute13 in varchar2 default hr_api.g_varchar2,
625: p_bpr_attribute14 in varchar2 default hr_api.g_varchar2,
626: p_bpr_attribute15 in varchar2 default hr_api.g_varchar2,
627: p_bpr_attribute16 in varchar2 default hr_api.g_varchar2,
620: p_bpr_attribute9 in varchar2 default hr_api.g_varchar2,
621: p_bpr_attribute10 in varchar2 default hr_api.g_varchar2,
622: p_bpr_attribute11 in varchar2 default hr_api.g_varchar2,
623: p_bpr_attribute12 in varchar2 default hr_api.g_varchar2,
624: p_bpr_attribute13 in varchar2 default hr_api.g_varchar2,
625: p_bpr_attribute14 in varchar2 default hr_api.g_varchar2,
626: p_bpr_attribute15 in varchar2 default hr_api.g_varchar2,
627: p_bpr_attribute16 in varchar2 default hr_api.g_varchar2,
628: p_bpr_attribute17 in varchar2 default hr_api.g_varchar2,
621: p_bpr_attribute10 in varchar2 default hr_api.g_varchar2,
622: p_bpr_attribute11 in varchar2 default hr_api.g_varchar2,
623: p_bpr_attribute12 in varchar2 default hr_api.g_varchar2,
624: p_bpr_attribute13 in varchar2 default hr_api.g_varchar2,
625: p_bpr_attribute14 in varchar2 default hr_api.g_varchar2,
626: p_bpr_attribute15 in varchar2 default hr_api.g_varchar2,
627: p_bpr_attribute16 in varchar2 default hr_api.g_varchar2,
628: p_bpr_attribute17 in varchar2 default hr_api.g_varchar2,
629: p_bpr_attribute18 in varchar2 default hr_api.g_varchar2,
622: p_bpr_attribute11 in varchar2 default hr_api.g_varchar2,
623: p_bpr_attribute12 in varchar2 default hr_api.g_varchar2,
624: p_bpr_attribute13 in varchar2 default hr_api.g_varchar2,
625: p_bpr_attribute14 in varchar2 default hr_api.g_varchar2,
626: p_bpr_attribute15 in varchar2 default hr_api.g_varchar2,
627: p_bpr_attribute16 in varchar2 default hr_api.g_varchar2,
628: p_bpr_attribute17 in varchar2 default hr_api.g_varchar2,
629: p_bpr_attribute18 in varchar2 default hr_api.g_varchar2,
630: p_bpr_attribute19 in varchar2 default hr_api.g_varchar2,
623: p_bpr_attribute12 in varchar2 default hr_api.g_varchar2,
624: p_bpr_attribute13 in varchar2 default hr_api.g_varchar2,
625: p_bpr_attribute14 in varchar2 default hr_api.g_varchar2,
626: p_bpr_attribute15 in varchar2 default hr_api.g_varchar2,
627: p_bpr_attribute16 in varchar2 default hr_api.g_varchar2,
628: p_bpr_attribute17 in varchar2 default hr_api.g_varchar2,
629: p_bpr_attribute18 in varchar2 default hr_api.g_varchar2,
630: p_bpr_attribute19 in varchar2 default hr_api.g_varchar2,
631: p_bpr_attribute20 in varchar2 default hr_api.g_varchar2,
624: p_bpr_attribute13 in varchar2 default hr_api.g_varchar2,
625: p_bpr_attribute14 in varchar2 default hr_api.g_varchar2,
626: p_bpr_attribute15 in varchar2 default hr_api.g_varchar2,
627: p_bpr_attribute16 in varchar2 default hr_api.g_varchar2,
628: p_bpr_attribute17 in varchar2 default hr_api.g_varchar2,
629: p_bpr_attribute18 in varchar2 default hr_api.g_varchar2,
630: p_bpr_attribute19 in varchar2 default hr_api.g_varchar2,
631: p_bpr_attribute20 in varchar2 default hr_api.g_varchar2,
632: p_bpr_attribute21 in varchar2 default hr_api.g_varchar2,
625: p_bpr_attribute14 in varchar2 default hr_api.g_varchar2,
626: p_bpr_attribute15 in varchar2 default hr_api.g_varchar2,
627: p_bpr_attribute16 in varchar2 default hr_api.g_varchar2,
628: p_bpr_attribute17 in varchar2 default hr_api.g_varchar2,
629: p_bpr_attribute18 in varchar2 default hr_api.g_varchar2,
630: p_bpr_attribute19 in varchar2 default hr_api.g_varchar2,
631: p_bpr_attribute20 in varchar2 default hr_api.g_varchar2,
632: p_bpr_attribute21 in varchar2 default hr_api.g_varchar2,
633: p_bpr_attribute22 in varchar2 default hr_api.g_varchar2,
626: p_bpr_attribute15 in varchar2 default hr_api.g_varchar2,
627: p_bpr_attribute16 in varchar2 default hr_api.g_varchar2,
628: p_bpr_attribute17 in varchar2 default hr_api.g_varchar2,
629: p_bpr_attribute18 in varchar2 default hr_api.g_varchar2,
630: p_bpr_attribute19 in varchar2 default hr_api.g_varchar2,
631: p_bpr_attribute20 in varchar2 default hr_api.g_varchar2,
632: p_bpr_attribute21 in varchar2 default hr_api.g_varchar2,
633: p_bpr_attribute22 in varchar2 default hr_api.g_varchar2,
634: p_bpr_attribute23 in varchar2 default hr_api.g_varchar2,
627: p_bpr_attribute16 in varchar2 default hr_api.g_varchar2,
628: p_bpr_attribute17 in varchar2 default hr_api.g_varchar2,
629: p_bpr_attribute18 in varchar2 default hr_api.g_varchar2,
630: p_bpr_attribute19 in varchar2 default hr_api.g_varchar2,
631: p_bpr_attribute20 in varchar2 default hr_api.g_varchar2,
632: p_bpr_attribute21 in varchar2 default hr_api.g_varchar2,
633: p_bpr_attribute22 in varchar2 default hr_api.g_varchar2,
634: p_bpr_attribute23 in varchar2 default hr_api.g_varchar2,
635: p_bpr_attribute24 in varchar2 default hr_api.g_varchar2,
628: p_bpr_attribute17 in varchar2 default hr_api.g_varchar2,
629: p_bpr_attribute18 in varchar2 default hr_api.g_varchar2,
630: p_bpr_attribute19 in varchar2 default hr_api.g_varchar2,
631: p_bpr_attribute20 in varchar2 default hr_api.g_varchar2,
632: p_bpr_attribute21 in varchar2 default hr_api.g_varchar2,
633: p_bpr_attribute22 in varchar2 default hr_api.g_varchar2,
634: p_bpr_attribute23 in varchar2 default hr_api.g_varchar2,
635: p_bpr_attribute24 in varchar2 default hr_api.g_varchar2,
636: p_bpr_attribute25 in varchar2 default hr_api.g_varchar2,
629: p_bpr_attribute18 in varchar2 default hr_api.g_varchar2,
630: p_bpr_attribute19 in varchar2 default hr_api.g_varchar2,
631: p_bpr_attribute20 in varchar2 default hr_api.g_varchar2,
632: p_bpr_attribute21 in varchar2 default hr_api.g_varchar2,
633: p_bpr_attribute22 in varchar2 default hr_api.g_varchar2,
634: p_bpr_attribute23 in varchar2 default hr_api.g_varchar2,
635: p_bpr_attribute24 in varchar2 default hr_api.g_varchar2,
636: p_bpr_attribute25 in varchar2 default hr_api.g_varchar2,
637: p_bpr_attribute26 in varchar2 default hr_api.g_varchar2,
630: p_bpr_attribute19 in varchar2 default hr_api.g_varchar2,
631: p_bpr_attribute20 in varchar2 default hr_api.g_varchar2,
632: p_bpr_attribute21 in varchar2 default hr_api.g_varchar2,
633: p_bpr_attribute22 in varchar2 default hr_api.g_varchar2,
634: p_bpr_attribute23 in varchar2 default hr_api.g_varchar2,
635: p_bpr_attribute24 in varchar2 default hr_api.g_varchar2,
636: p_bpr_attribute25 in varchar2 default hr_api.g_varchar2,
637: p_bpr_attribute26 in varchar2 default hr_api.g_varchar2,
638: p_bpr_attribute27 in varchar2 default hr_api.g_varchar2,
631: p_bpr_attribute20 in varchar2 default hr_api.g_varchar2,
632: p_bpr_attribute21 in varchar2 default hr_api.g_varchar2,
633: p_bpr_attribute22 in varchar2 default hr_api.g_varchar2,
634: p_bpr_attribute23 in varchar2 default hr_api.g_varchar2,
635: p_bpr_attribute24 in varchar2 default hr_api.g_varchar2,
636: p_bpr_attribute25 in varchar2 default hr_api.g_varchar2,
637: p_bpr_attribute26 in varchar2 default hr_api.g_varchar2,
638: p_bpr_attribute27 in varchar2 default hr_api.g_varchar2,
639: p_bpr_attribute28 in varchar2 default hr_api.g_varchar2,
632: p_bpr_attribute21 in varchar2 default hr_api.g_varchar2,
633: p_bpr_attribute22 in varchar2 default hr_api.g_varchar2,
634: p_bpr_attribute23 in varchar2 default hr_api.g_varchar2,
635: p_bpr_attribute24 in varchar2 default hr_api.g_varchar2,
636: p_bpr_attribute25 in varchar2 default hr_api.g_varchar2,
637: p_bpr_attribute26 in varchar2 default hr_api.g_varchar2,
638: p_bpr_attribute27 in varchar2 default hr_api.g_varchar2,
639: p_bpr_attribute28 in varchar2 default hr_api.g_varchar2,
640: p_bpr_attribute29 in varchar2 default hr_api.g_varchar2,
633: p_bpr_attribute22 in varchar2 default hr_api.g_varchar2,
634: p_bpr_attribute23 in varchar2 default hr_api.g_varchar2,
635: p_bpr_attribute24 in varchar2 default hr_api.g_varchar2,
636: p_bpr_attribute25 in varchar2 default hr_api.g_varchar2,
637: p_bpr_attribute26 in varchar2 default hr_api.g_varchar2,
638: p_bpr_attribute27 in varchar2 default hr_api.g_varchar2,
639: p_bpr_attribute28 in varchar2 default hr_api.g_varchar2,
640: p_bpr_attribute29 in varchar2 default hr_api.g_varchar2,
641: p_bpr_attribute30 in varchar2 default hr_api.g_varchar2
634: p_bpr_attribute23 in varchar2 default hr_api.g_varchar2,
635: p_bpr_attribute24 in varchar2 default hr_api.g_varchar2,
636: p_bpr_attribute25 in varchar2 default hr_api.g_varchar2,
637: p_bpr_attribute26 in varchar2 default hr_api.g_varchar2,
638: p_bpr_attribute27 in varchar2 default hr_api.g_varchar2,
639: p_bpr_attribute28 in varchar2 default hr_api.g_varchar2,
640: p_bpr_attribute29 in varchar2 default hr_api.g_varchar2,
641: p_bpr_attribute30 in varchar2 default hr_api.g_varchar2
642: ) is
635: p_bpr_attribute24 in varchar2 default hr_api.g_varchar2,
636: p_bpr_attribute25 in varchar2 default hr_api.g_varchar2,
637: p_bpr_attribute26 in varchar2 default hr_api.g_varchar2,
638: p_bpr_attribute27 in varchar2 default hr_api.g_varchar2,
639: p_bpr_attribute28 in varchar2 default hr_api.g_varchar2,
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: --
636: p_bpr_attribute25 in varchar2 default hr_api.g_varchar2,
637: p_bpr_attribute26 in varchar2 default hr_api.g_varchar2,
638: p_bpr_attribute27 in varchar2 default hr_api.g_varchar2,
639: p_bpr_attribute28 in varchar2 default hr_api.g_varchar2,
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;
637: p_bpr_attribute26 in varchar2 default hr_api.g_varchar2,
638: p_bpr_attribute27 in varchar2 default hr_api.g_varchar2,
639: p_bpr_attribute28 in varchar2 default hr_api.g_varchar2,
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';
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,
659: p_payroll_identifier,
660: p_period_start_date,
661: p_period_end_date,
654: per_bpr_shd.convert_args
655: (
656: p_payroll_run_id,
657: hr_api.g_number,
658: hr_api.g_number,
659: p_payroll_identifier,
660: p_period_start_date,
661: p_period_end_date,
662: p_processing_date,