APPS.PER_BPA_UPD dependencies on HR_API

Line 114: When hr_api.check_integrity_violated Then

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: --
117: per_bpa_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 118: (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: --
117: per_bpa_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: per_bpa_shd.constraint_error

Line 119: When hr_api.parent_integrity_violated Then

115: -- A check constraint has been violated
116: --
117: per_bpa_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: per_bpa_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: per_bpa_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: per_bpa_shd.constraint_error

Line 124: When hr_api.unique_integrity_violated Then

120: -- Parent integrity has been violated
121: --
122: per_bpa_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: per_bpa_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: per_bpa_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: --
131: Raise;
132: End update_dml;

Line 328: when hr_api.cannot_find_prog_unit then

324: );
325: --
326: exception
327: --
328: when hr_api.cannot_find_prog_unit then
329: --
330: hr_api.cannot_find_prog_unit_error
331: (p_module_name => 'PER_BF_PROCESSED_ASSIGNMENTS'
332: ,p_hook_type => 'AU');

Line 330: hr_api.cannot_find_prog_unit_error

326: exception
327: --
328: when hr_api.cannot_find_prog_unit then
329: --
330: hr_api.cannot_find_prog_unit_error
331: (p_module_name => 'PER_BF_PROCESSED_ASSIGNMENTS'
332: ,p_hook_type => 'AU');
333: --
334: end;

Line 397: If (p_rec.payroll_run_id = hr_api.g_number) then

393: -- p_rec plsql record structure
394: -- to see if a system default is being used. If a system default
395: -- is being used then we must set to the 'current' argument value.
396: --
397: If (p_rec.payroll_run_id = hr_api.g_number) then
398: p_rec.payroll_run_id :=
399: per_bpa_shd.g_old_rec.payroll_run_id;
400: End If;
401: If (p_rec.assignment_id = hr_api.g_number) then

Line 401: If (p_rec.assignment_id = hr_api.g_number) then

397: If (p_rec.payroll_run_id = hr_api.g_number) then
398: p_rec.payroll_run_id :=
399: per_bpa_shd.g_old_rec.payroll_run_id;
400: End If;
401: If (p_rec.assignment_id = hr_api.g_number) then
402: p_rec.assignment_id :=
403: per_bpa_shd.g_old_rec.assignment_id;
404: End If;
405: If (p_rec.bpa_attribute_category = hr_api.g_varchar2) then

Line 405: If (p_rec.bpa_attribute_category = hr_api.g_varchar2) then

401: If (p_rec.assignment_id = hr_api.g_number) then
402: p_rec.assignment_id :=
403: per_bpa_shd.g_old_rec.assignment_id;
404: End If;
405: If (p_rec.bpa_attribute_category = hr_api.g_varchar2) then
406: p_rec.bpa_attribute_category :=
407: per_bpa_shd.g_old_rec.bpa_attribute_category;
408: End If;
409: If (p_rec.bpa_attribute1 = hr_api.g_varchar2) then

Line 409: If (p_rec.bpa_attribute1 = hr_api.g_varchar2) then

405: If (p_rec.bpa_attribute_category = hr_api.g_varchar2) then
406: p_rec.bpa_attribute_category :=
407: per_bpa_shd.g_old_rec.bpa_attribute_category;
408: End If;
409: If (p_rec.bpa_attribute1 = hr_api.g_varchar2) then
410: p_rec.bpa_attribute1:=
411: per_bpa_shd.g_old_rec.bpa_attribute1;
412: End If;
413: If (p_rec.bpa_attribute2 = hr_api.g_varchar2) then

Line 413: If (p_rec.bpa_attribute2 = hr_api.g_varchar2) then

409: If (p_rec.bpa_attribute1 = hr_api.g_varchar2) then
410: p_rec.bpa_attribute1:=
411: per_bpa_shd.g_old_rec.bpa_attribute1;
412: End If;
413: If (p_rec.bpa_attribute2 = hr_api.g_varchar2) then
414: p_rec.bpa_attribute2:=
415: per_bpa_shd.g_old_rec.bpa_attribute2;
416: End If;
417: If (p_rec.bpa_attribute3 = hr_api.g_varchar2) then

Line 417: If (p_rec.bpa_attribute3 = hr_api.g_varchar2) then

413: If (p_rec.bpa_attribute2 = hr_api.g_varchar2) then
414: p_rec.bpa_attribute2:=
415: per_bpa_shd.g_old_rec.bpa_attribute2;
416: End If;
417: If (p_rec.bpa_attribute3 = hr_api.g_varchar2) then
418: p_rec.bpa_attribute3:=
419: per_bpa_shd.g_old_rec.bpa_attribute3;
420: End If;
421: If (p_rec.bpa_attribute4 = hr_api.g_varchar2) then

Line 421: If (p_rec.bpa_attribute4 = hr_api.g_varchar2) then

417: If (p_rec.bpa_attribute3 = hr_api.g_varchar2) then
418: p_rec.bpa_attribute3:=
419: per_bpa_shd.g_old_rec.bpa_attribute3;
420: End If;
421: If (p_rec.bpa_attribute4 = hr_api.g_varchar2) then
422: p_rec.bpa_attribute4:=
423: per_bpa_shd.g_old_rec.bpa_attribute4;
424: End If;
425: If (p_rec.bpa_attribute5 = hr_api.g_varchar2) then

Line 425: If (p_rec.bpa_attribute5 = hr_api.g_varchar2) then

421: If (p_rec.bpa_attribute4 = hr_api.g_varchar2) then
422: p_rec.bpa_attribute4:=
423: per_bpa_shd.g_old_rec.bpa_attribute4;
424: End If;
425: If (p_rec.bpa_attribute5 = hr_api.g_varchar2) then
426: p_rec.bpa_attribute5:=
427: per_bpa_shd.g_old_rec.bpa_attribute5;
428: End If;
429: If (p_rec.bpa_attribute6 = hr_api.g_varchar2) then

Line 429: If (p_rec.bpa_attribute6 = hr_api.g_varchar2) then

425: If (p_rec.bpa_attribute5 = hr_api.g_varchar2) then
426: p_rec.bpa_attribute5:=
427: per_bpa_shd.g_old_rec.bpa_attribute5;
428: End If;
429: If (p_rec.bpa_attribute6 = hr_api.g_varchar2) then
430: p_rec.bpa_attribute6:=
431: per_bpa_shd.g_old_rec.bpa_attribute6;
432: End If;
433: If (p_rec.bpa_attribute7 = hr_api.g_varchar2) then

Line 433: If (p_rec.bpa_attribute7 = hr_api.g_varchar2) then

429: If (p_rec.bpa_attribute6 = hr_api.g_varchar2) then
430: p_rec.bpa_attribute6:=
431: per_bpa_shd.g_old_rec.bpa_attribute6;
432: End If;
433: If (p_rec.bpa_attribute7 = hr_api.g_varchar2) then
434: p_rec.bpa_attribute7:=
435: per_bpa_shd.g_old_rec.bpa_attribute7;
436: End If;
437: If (p_rec.bpa_attribute8 = hr_api.g_varchar2) then

Line 437: If (p_rec.bpa_attribute8 = hr_api.g_varchar2) then

433: If (p_rec.bpa_attribute7 = hr_api.g_varchar2) then
434: p_rec.bpa_attribute7:=
435: per_bpa_shd.g_old_rec.bpa_attribute7;
436: End If;
437: If (p_rec.bpa_attribute8 = hr_api.g_varchar2) then
438: p_rec.bpa_attribute8:=
439: per_bpa_shd.g_old_rec.bpa_attribute8;
440: End If;
441: If (p_rec.bpa_attribute9 = hr_api.g_varchar2) then

Line 441: If (p_rec.bpa_attribute9 = hr_api.g_varchar2) then

437: If (p_rec.bpa_attribute8 = hr_api.g_varchar2) then
438: p_rec.bpa_attribute8:=
439: per_bpa_shd.g_old_rec.bpa_attribute8;
440: End If;
441: If (p_rec.bpa_attribute9 = hr_api.g_varchar2) then
442: p_rec.bpa_attribute9:=
443: per_bpa_shd.g_old_rec.bpa_attribute9;
444: End If;
445: If (p_rec.bpa_attribute10 = hr_api.g_varchar2) then

Line 445: If (p_rec.bpa_attribute10 = hr_api.g_varchar2) then

441: If (p_rec.bpa_attribute9 = hr_api.g_varchar2) then
442: p_rec.bpa_attribute9:=
443: per_bpa_shd.g_old_rec.bpa_attribute9;
444: End If;
445: If (p_rec.bpa_attribute10 = hr_api.g_varchar2) then
446: p_rec.bpa_attribute10:=
447: per_bpa_shd.g_old_rec.bpa_attribute10;
448: End If;
449: If (p_rec.bpa_attribute11 = hr_api.g_varchar2) then

Line 449: If (p_rec.bpa_attribute11 = hr_api.g_varchar2) then

445: If (p_rec.bpa_attribute10 = hr_api.g_varchar2) then
446: p_rec.bpa_attribute10:=
447: per_bpa_shd.g_old_rec.bpa_attribute10;
448: End If;
449: If (p_rec.bpa_attribute11 = hr_api.g_varchar2) then
450: p_rec.bpa_attribute11:=
451: per_bpa_shd.g_old_rec.bpa_attribute11;
452: End If;
453: If (p_rec.bpa_attribute12 = hr_api.g_varchar2) then

Line 453: If (p_rec.bpa_attribute12 = hr_api.g_varchar2) then

449: If (p_rec.bpa_attribute11 = hr_api.g_varchar2) then
450: p_rec.bpa_attribute11:=
451: per_bpa_shd.g_old_rec.bpa_attribute11;
452: End If;
453: If (p_rec.bpa_attribute12 = hr_api.g_varchar2) then
454: p_rec.bpa_attribute12:=
455: per_bpa_shd.g_old_rec.bpa_attribute12;
456: End If;
457: If (p_rec.bpa_attribute13 = hr_api.g_varchar2) then

Line 457: If (p_rec.bpa_attribute13 = hr_api.g_varchar2) then

453: If (p_rec.bpa_attribute12 = hr_api.g_varchar2) then
454: p_rec.bpa_attribute12:=
455: per_bpa_shd.g_old_rec.bpa_attribute12;
456: End If;
457: If (p_rec.bpa_attribute13 = hr_api.g_varchar2) then
458: p_rec.bpa_attribute13:=
459: per_bpa_shd.g_old_rec.bpa_attribute13;
460: End If;
461: If (p_rec.bpa_attribute14 = hr_api.g_varchar2) then

Line 461: If (p_rec.bpa_attribute14 = hr_api.g_varchar2) then

457: If (p_rec.bpa_attribute13 = hr_api.g_varchar2) then
458: p_rec.bpa_attribute13:=
459: per_bpa_shd.g_old_rec.bpa_attribute13;
460: End If;
461: If (p_rec.bpa_attribute14 = hr_api.g_varchar2) then
462: p_rec.bpa_attribute14:=
463: per_bpa_shd.g_old_rec.bpa_attribute14;
464: End If;
465: If (p_rec.bpa_attribute15 = hr_api.g_varchar2) then

Line 465: If (p_rec.bpa_attribute15 = hr_api.g_varchar2) then

461: If (p_rec.bpa_attribute14 = hr_api.g_varchar2) then
462: p_rec.bpa_attribute14:=
463: per_bpa_shd.g_old_rec.bpa_attribute14;
464: End If;
465: If (p_rec.bpa_attribute15 = hr_api.g_varchar2) then
466: p_rec.bpa_attribute15:=
467: per_bpa_shd.g_old_rec.bpa_attribute15;
468: End If;
469: If (p_rec.bpa_attribute16 = hr_api.g_varchar2) then

Line 469: If (p_rec.bpa_attribute16 = hr_api.g_varchar2) then

465: If (p_rec.bpa_attribute15 = hr_api.g_varchar2) then
466: p_rec.bpa_attribute15:=
467: per_bpa_shd.g_old_rec.bpa_attribute15;
468: End If;
469: If (p_rec.bpa_attribute16 = hr_api.g_varchar2) then
470: p_rec.bpa_attribute16:=
471: per_bpa_shd.g_old_rec.bpa_attribute16;
472: End If;
473: If (p_rec.bpa_attribute17 = hr_api.g_varchar2) then

Line 473: If (p_rec.bpa_attribute17 = hr_api.g_varchar2) then

469: If (p_rec.bpa_attribute16 = hr_api.g_varchar2) then
470: p_rec.bpa_attribute16:=
471: per_bpa_shd.g_old_rec.bpa_attribute16;
472: End If;
473: If (p_rec.bpa_attribute17 = hr_api.g_varchar2) then
474: p_rec.bpa_attribute17:=
475: per_bpa_shd.g_old_rec.bpa_attribute17;
476: End If;
477: If (p_rec.bpa_attribute18 = hr_api.g_varchar2) then

Line 477: If (p_rec.bpa_attribute18 = hr_api.g_varchar2) then

473: If (p_rec.bpa_attribute17 = hr_api.g_varchar2) then
474: p_rec.bpa_attribute17:=
475: per_bpa_shd.g_old_rec.bpa_attribute17;
476: End If;
477: If (p_rec.bpa_attribute18 = hr_api.g_varchar2) then
478: p_rec.bpa_attribute18:=
479: per_bpa_shd.g_old_rec.bpa_attribute18;
480: End If;
481: If (p_rec.bpa_attribute19 = hr_api.g_varchar2) then

Line 481: If (p_rec.bpa_attribute19 = hr_api.g_varchar2) then

477: If (p_rec.bpa_attribute18 = hr_api.g_varchar2) then
478: p_rec.bpa_attribute18:=
479: per_bpa_shd.g_old_rec.bpa_attribute18;
480: End If;
481: If (p_rec.bpa_attribute19 = hr_api.g_varchar2) then
482: p_rec.bpa_attribute19:=
483: per_bpa_shd.g_old_rec.bpa_attribute19;
484: End If;
485: If (p_rec.bpa_attribute20 = hr_api.g_varchar2) then

Line 485: If (p_rec.bpa_attribute20 = hr_api.g_varchar2) then

481: If (p_rec.bpa_attribute19 = hr_api.g_varchar2) then
482: p_rec.bpa_attribute19:=
483: per_bpa_shd.g_old_rec.bpa_attribute19;
484: End If;
485: If (p_rec.bpa_attribute20 = hr_api.g_varchar2) then
486: p_rec.bpa_attribute20:=
487: per_bpa_shd.g_old_rec.bpa_attribute20;
488: End If;
489: If (p_rec.bpa_attribute21 = hr_api.g_varchar2) then

Line 489: If (p_rec.bpa_attribute21 = hr_api.g_varchar2) then

485: If (p_rec.bpa_attribute20 = hr_api.g_varchar2) then
486: p_rec.bpa_attribute20:=
487: per_bpa_shd.g_old_rec.bpa_attribute20;
488: End If;
489: If (p_rec.bpa_attribute21 = hr_api.g_varchar2) then
490: p_rec.bpa_attribute21:=
491: per_bpa_shd.g_old_rec.bpa_attribute21;
492: End If;
493: If (p_rec.bpa_attribute22 = hr_api.g_varchar2) then

Line 493: If (p_rec.bpa_attribute22 = hr_api.g_varchar2) then

489: If (p_rec.bpa_attribute21 = hr_api.g_varchar2) then
490: p_rec.bpa_attribute21:=
491: per_bpa_shd.g_old_rec.bpa_attribute21;
492: End If;
493: If (p_rec.bpa_attribute22 = hr_api.g_varchar2) then
494: p_rec.bpa_attribute22:=
495: per_bpa_shd.g_old_rec.bpa_attribute22;
496: End If;
497: If (p_rec.bpa_attribute23 = hr_api.g_varchar2) then

Line 497: If (p_rec.bpa_attribute23 = hr_api.g_varchar2) then

493: If (p_rec.bpa_attribute22 = hr_api.g_varchar2) then
494: p_rec.bpa_attribute22:=
495: per_bpa_shd.g_old_rec.bpa_attribute22;
496: End If;
497: If (p_rec.bpa_attribute23 = hr_api.g_varchar2) then
498: p_rec.bpa_attribute23:=
499: per_bpa_shd.g_old_rec.bpa_attribute23;
500: End If;
501: If (p_rec.bpa_attribute24 = hr_api.g_varchar2) then

Line 501: If (p_rec.bpa_attribute24 = hr_api.g_varchar2) then

497: If (p_rec.bpa_attribute23 = hr_api.g_varchar2) then
498: p_rec.bpa_attribute23:=
499: per_bpa_shd.g_old_rec.bpa_attribute23;
500: End If;
501: If (p_rec.bpa_attribute24 = hr_api.g_varchar2) then
502: p_rec.bpa_attribute24:=
503: per_bpa_shd.g_old_rec.bpa_attribute24;
504: End If;
505: If (p_rec.bpa_attribute25 = hr_api.g_varchar2) then

Line 505: If (p_rec.bpa_attribute25 = hr_api.g_varchar2) then

501: If (p_rec.bpa_attribute24 = hr_api.g_varchar2) then
502: p_rec.bpa_attribute24:=
503: per_bpa_shd.g_old_rec.bpa_attribute24;
504: End If;
505: If (p_rec.bpa_attribute25 = hr_api.g_varchar2) then
506: p_rec.bpa_attribute25:=
507: per_bpa_shd.g_old_rec.bpa_attribute25;
508: End If;
509: If (p_rec.bpa_attribute26 = hr_api.g_varchar2) then

Line 509: If (p_rec.bpa_attribute26 = hr_api.g_varchar2) then

505: If (p_rec.bpa_attribute25 = hr_api.g_varchar2) then
506: p_rec.bpa_attribute25:=
507: per_bpa_shd.g_old_rec.bpa_attribute25;
508: End If;
509: If (p_rec.bpa_attribute26 = hr_api.g_varchar2) then
510: p_rec.bpa_attribute26:=
511: per_bpa_shd.g_old_rec.bpa_attribute26;
512: End If;
513: If (p_rec.bpa_attribute27 = hr_api.g_varchar2) then

Line 513: If (p_rec.bpa_attribute27 = hr_api.g_varchar2) then

509: If (p_rec.bpa_attribute26 = hr_api.g_varchar2) then
510: p_rec.bpa_attribute26:=
511: per_bpa_shd.g_old_rec.bpa_attribute26;
512: End If;
513: If (p_rec.bpa_attribute27 = hr_api.g_varchar2) then
514: p_rec.bpa_attribute27:=
515: per_bpa_shd.g_old_rec.bpa_attribute27;
516: End If;
517: If (p_rec.bpa_attribute28 = hr_api.g_varchar2) then

Line 517: If (p_rec.bpa_attribute28 = hr_api.g_varchar2) then

513: If (p_rec.bpa_attribute27 = hr_api.g_varchar2) then
514: p_rec.bpa_attribute27:=
515: per_bpa_shd.g_old_rec.bpa_attribute27;
516: End If;
517: If (p_rec.bpa_attribute28 = hr_api.g_varchar2) then
518: p_rec.bpa_attribute28:=
519: per_bpa_shd.g_old_rec.bpa_attribute28;
520: End If;
521: If (p_rec.bpa_attribute29 = hr_api.g_varchar2) then

Line 521: If (p_rec.bpa_attribute29 = hr_api.g_varchar2) then

517: If (p_rec.bpa_attribute28 = hr_api.g_varchar2) then
518: p_rec.bpa_attribute28:=
519: per_bpa_shd.g_old_rec.bpa_attribute28;
520: End If;
521: If (p_rec.bpa_attribute29 = hr_api.g_varchar2) then
522: p_rec.bpa_attribute29:=
523: per_bpa_shd.g_old_rec.bpa_attribute29;
524: End If;
525: If (p_rec.bpa_attribute30 = hr_api.g_varchar2) then

Line 525: If (p_rec.bpa_attribute30 = hr_api.g_varchar2) then

521: If (p_rec.bpa_attribute29 = hr_api.g_varchar2) then
522: p_rec.bpa_attribute29:=
523: per_bpa_shd.g_old_rec.bpa_attribute29;
524: End If;
525: If (p_rec.bpa_attribute30 = hr_api.g_varchar2) then
526: p_rec.bpa_attribute30:=
527: per_bpa_shd.g_old_rec.bpa_attribute30;
528: End If;
529: --

Line 589: p_bpa_attribute_category in varchar2 default hr_api.g_varchar2,

585: Procedure upd
586: (p_effective_date in date,
587: p_processed_assignment_id in number,
588: p_object_version_number in out nocopy number,
589: p_bpa_attribute_category in varchar2 default hr_api.g_varchar2,
590: p_bpa_attribute1 in varchar2 default hr_api.g_varchar2,
591: p_bpa_attribute2 in varchar2 default hr_api.g_varchar2,
592: p_bpa_attribute3 in varchar2 default hr_api.g_varchar2,
593: p_bpa_attribute4 in varchar2 default hr_api.g_varchar2,

Line 590: p_bpa_attribute1 in varchar2 default hr_api.g_varchar2,

586: (p_effective_date in date,
587: p_processed_assignment_id in number,
588: p_object_version_number in out nocopy number,
589: p_bpa_attribute_category in varchar2 default hr_api.g_varchar2,
590: p_bpa_attribute1 in varchar2 default hr_api.g_varchar2,
591: p_bpa_attribute2 in varchar2 default hr_api.g_varchar2,
592: p_bpa_attribute3 in varchar2 default hr_api.g_varchar2,
593: p_bpa_attribute4 in varchar2 default hr_api.g_varchar2,
594: p_bpa_attribute5 in varchar2 default hr_api.g_varchar2,

Line 591: p_bpa_attribute2 in varchar2 default hr_api.g_varchar2,

587: p_processed_assignment_id in number,
588: p_object_version_number in out nocopy number,
589: p_bpa_attribute_category in varchar2 default hr_api.g_varchar2,
590: p_bpa_attribute1 in varchar2 default hr_api.g_varchar2,
591: p_bpa_attribute2 in varchar2 default hr_api.g_varchar2,
592: p_bpa_attribute3 in varchar2 default hr_api.g_varchar2,
593: p_bpa_attribute4 in varchar2 default hr_api.g_varchar2,
594: p_bpa_attribute5 in varchar2 default hr_api.g_varchar2,
595: p_bpa_attribute6 in varchar2 default hr_api.g_varchar2,

Line 592: p_bpa_attribute3 in varchar2 default hr_api.g_varchar2,

588: p_object_version_number in out nocopy number,
589: p_bpa_attribute_category in varchar2 default hr_api.g_varchar2,
590: p_bpa_attribute1 in varchar2 default hr_api.g_varchar2,
591: p_bpa_attribute2 in varchar2 default hr_api.g_varchar2,
592: p_bpa_attribute3 in varchar2 default hr_api.g_varchar2,
593: p_bpa_attribute4 in varchar2 default hr_api.g_varchar2,
594: p_bpa_attribute5 in varchar2 default hr_api.g_varchar2,
595: p_bpa_attribute6 in varchar2 default hr_api.g_varchar2,
596: p_bpa_attribute7 in varchar2 default hr_api.g_varchar2,

Line 593: p_bpa_attribute4 in varchar2 default hr_api.g_varchar2,

589: p_bpa_attribute_category in varchar2 default hr_api.g_varchar2,
590: p_bpa_attribute1 in varchar2 default hr_api.g_varchar2,
591: p_bpa_attribute2 in varchar2 default hr_api.g_varchar2,
592: p_bpa_attribute3 in varchar2 default hr_api.g_varchar2,
593: p_bpa_attribute4 in varchar2 default hr_api.g_varchar2,
594: p_bpa_attribute5 in varchar2 default hr_api.g_varchar2,
595: p_bpa_attribute6 in varchar2 default hr_api.g_varchar2,
596: p_bpa_attribute7 in varchar2 default hr_api.g_varchar2,
597: p_bpa_attribute8 in varchar2 default hr_api.g_varchar2,

Line 594: p_bpa_attribute5 in varchar2 default hr_api.g_varchar2,

590: p_bpa_attribute1 in varchar2 default hr_api.g_varchar2,
591: p_bpa_attribute2 in varchar2 default hr_api.g_varchar2,
592: p_bpa_attribute3 in varchar2 default hr_api.g_varchar2,
593: p_bpa_attribute4 in varchar2 default hr_api.g_varchar2,
594: p_bpa_attribute5 in varchar2 default hr_api.g_varchar2,
595: p_bpa_attribute6 in varchar2 default hr_api.g_varchar2,
596: p_bpa_attribute7 in varchar2 default hr_api.g_varchar2,
597: p_bpa_attribute8 in varchar2 default hr_api.g_varchar2,
598: p_bpa_attribute9 in varchar2 default hr_api.g_varchar2,

Line 595: p_bpa_attribute6 in varchar2 default hr_api.g_varchar2,

591: p_bpa_attribute2 in varchar2 default hr_api.g_varchar2,
592: p_bpa_attribute3 in varchar2 default hr_api.g_varchar2,
593: p_bpa_attribute4 in varchar2 default hr_api.g_varchar2,
594: p_bpa_attribute5 in varchar2 default hr_api.g_varchar2,
595: p_bpa_attribute6 in varchar2 default hr_api.g_varchar2,
596: p_bpa_attribute7 in varchar2 default hr_api.g_varchar2,
597: p_bpa_attribute8 in varchar2 default hr_api.g_varchar2,
598: p_bpa_attribute9 in varchar2 default hr_api.g_varchar2,
599: p_bpa_attribute10 in varchar2 default hr_api.g_varchar2,

Line 596: p_bpa_attribute7 in varchar2 default hr_api.g_varchar2,

592: p_bpa_attribute3 in varchar2 default hr_api.g_varchar2,
593: p_bpa_attribute4 in varchar2 default hr_api.g_varchar2,
594: p_bpa_attribute5 in varchar2 default hr_api.g_varchar2,
595: p_bpa_attribute6 in varchar2 default hr_api.g_varchar2,
596: p_bpa_attribute7 in varchar2 default hr_api.g_varchar2,
597: p_bpa_attribute8 in varchar2 default hr_api.g_varchar2,
598: p_bpa_attribute9 in varchar2 default hr_api.g_varchar2,
599: p_bpa_attribute10 in varchar2 default hr_api.g_varchar2,
600: p_bpa_attribute11 in varchar2 default hr_api.g_varchar2,

Line 597: p_bpa_attribute8 in varchar2 default hr_api.g_varchar2,

593: p_bpa_attribute4 in varchar2 default hr_api.g_varchar2,
594: p_bpa_attribute5 in varchar2 default hr_api.g_varchar2,
595: p_bpa_attribute6 in varchar2 default hr_api.g_varchar2,
596: p_bpa_attribute7 in varchar2 default hr_api.g_varchar2,
597: p_bpa_attribute8 in varchar2 default hr_api.g_varchar2,
598: p_bpa_attribute9 in varchar2 default hr_api.g_varchar2,
599: p_bpa_attribute10 in varchar2 default hr_api.g_varchar2,
600: p_bpa_attribute11 in varchar2 default hr_api.g_varchar2,
601: p_bpa_attribute12 in varchar2 default hr_api.g_varchar2,

Line 598: p_bpa_attribute9 in varchar2 default hr_api.g_varchar2,

594: p_bpa_attribute5 in varchar2 default hr_api.g_varchar2,
595: p_bpa_attribute6 in varchar2 default hr_api.g_varchar2,
596: p_bpa_attribute7 in varchar2 default hr_api.g_varchar2,
597: p_bpa_attribute8 in varchar2 default hr_api.g_varchar2,
598: p_bpa_attribute9 in varchar2 default hr_api.g_varchar2,
599: p_bpa_attribute10 in varchar2 default hr_api.g_varchar2,
600: p_bpa_attribute11 in varchar2 default hr_api.g_varchar2,
601: p_bpa_attribute12 in varchar2 default hr_api.g_varchar2,
602: p_bpa_attribute13 in varchar2 default hr_api.g_varchar2,

Line 599: p_bpa_attribute10 in varchar2 default hr_api.g_varchar2,

595: p_bpa_attribute6 in varchar2 default hr_api.g_varchar2,
596: p_bpa_attribute7 in varchar2 default hr_api.g_varchar2,
597: p_bpa_attribute8 in varchar2 default hr_api.g_varchar2,
598: p_bpa_attribute9 in varchar2 default hr_api.g_varchar2,
599: p_bpa_attribute10 in varchar2 default hr_api.g_varchar2,
600: p_bpa_attribute11 in varchar2 default hr_api.g_varchar2,
601: p_bpa_attribute12 in varchar2 default hr_api.g_varchar2,
602: p_bpa_attribute13 in varchar2 default hr_api.g_varchar2,
603: p_bpa_attribute14 in varchar2 default hr_api.g_varchar2,

Line 600: p_bpa_attribute11 in varchar2 default hr_api.g_varchar2,

596: p_bpa_attribute7 in varchar2 default hr_api.g_varchar2,
597: p_bpa_attribute8 in varchar2 default hr_api.g_varchar2,
598: p_bpa_attribute9 in varchar2 default hr_api.g_varchar2,
599: p_bpa_attribute10 in varchar2 default hr_api.g_varchar2,
600: p_bpa_attribute11 in varchar2 default hr_api.g_varchar2,
601: p_bpa_attribute12 in varchar2 default hr_api.g_varchar2,
602: p_bpa_attribute13 in varchar2 default hr_api.g_varchar2,
603: p_bpa_attribute14 in varchar2 default hr_api.g_varchar2,
604: p_bpa_attribute15 in varchar2 default hr_api.g_varchar2,

Line 601: p_bpa_attribute12 in varchar2 default hr_api.g_varchar2,

597: p_bpa_attribute8 in varchar2 default hr_api.g_varchar2,
598: p_bpa_attribute9 in varchar2 default hr_api.g_varchar2,
599: p_bpa_attribute10 in varchar2 default hr_api.g_varchar2,
600: p_bpa_attribute11 in varchar2 default hr_api.g_varchar2,
601: p_bpa_attribute12 in varchar2 default hr_api.g_varchar2,
602: p_bpa_attribute13 in varchar2 default hr_api.g_varchar2,
603: p_bpa_attribute14 in varchar2 default hr_api.g_varchar2,
604: p_bpa_attribute15 in varchar2 default hr_api.g_varchar2,
605: p_bpa_attribute16 in varchar2 default hr_api.g_varchar2,

Line 602: p_bpa_attribute13 in varchar2 default hr_api.g_varchar2,

598: p_bpa_attribute9 in varchar2 default hr_api.g_varchar2,
599: p_bpa_attribute10 in varchar2 default hr_api.g_varchar2,
600: p_bpa_attribute11 in varchar2 default hr_api.g_varchar2,
601: p_bpa_attribute12 in varchar2 default hr_api.g_varchar2,
602: p_bpa_attribute13 in varchar2 default hr_api.g_varchar2,
603: p_bpa_attribute14 in varchar2 default hr_api.g_varchar2,
604: p_bpa_attribute15 in varchar2 default hr_api.g_varchar2,
605: p_bpa_attribute16 in varchar2 default hr_api.g_varchar2,
606: p_bpa_attribute17 in varchar2 default hr_api.g_varchar2,

Line 603: p_bpa_attribute14 in varchar2 default hr_api.g_varchar2,

599: p_bpa_attribute10 in varchar2 default hr_api.g_varchar2,
600: p_bpa_attribute11 in varchar2 default hr_api.g_varchar2,
601: p_bpa_attribute12 in varchar2 default hr_api.g_varchar2,
602: p_bpa_attribute13 in varchar2 default hr_api.g_varchar2,
603: p_bpa_attribute14 in varchar2 default hr_api.g_varchar2,
604: p_bpa_attribute15 in varchar2 default hr_api.g_varchar2,
605: p_bpa_attribute16 in varchar2 default hr_api.g_varchar2,
606: p_bpa_attribute17 in varchar2 default hr_api.g_varchar2,
607: p_bpa_attribute18 in varchar2 default hr_api.g_varchar2,

Line 604: p_bpa_attribute15 in varchar2 default hr_api.g_varchar2,

600: p_bpa_attribute11 in varchar2 default hr_api.g_varchar2,
601: p_bpa_attribute12 in varchar2 default hr_api.g_varchar2,
602: p_bpa_attribute13 in varchar2 default hr_api.g_varchar2,
603: p_bpa_attribute14 in varchar2 default hr_api.g_varchar2,
604: p_bpa_attribute15 in varchar2 default hr_api.g_varchar2,
605: p_bpa_attribute16 in varchar2 default hr_api.g_varchar2,
606: p_bpa_attribute17 in varchar2 default hr_api.g_varchar2,
607: p_bpa_attribute18 in varchar2 default hr_api.g_varchar2,
608: p_bpa_attribute19 in varchar2 default hr_api.g_varchar2,

Line 605: p_bpa_attribute16 in varchar2 default hr_api.g_varchar2,

601: p_bpa_attribute12 in varchar2 default hr_api.g_varchar2,
602: p_bpa_attribute13 in varchar2 default hr_api.g_varchar2,
603: p_bpa_attribute14 in varchar2 default hr_api.g_varchar2,
604: p_bpa_attribute15 in varchar2 default hr_api.g_varchar2,
605: p_bpa_attribute16 in varchar2 default hr_api.g_varchar2,
606: p_bpa_attribute17 in varchar2 default hr_api.g_varchar2,
607: p_bpa_attribute18 in varchar2 default hr_api.g_varchar2,
608: p_bpa_attribute19 in varchar2 default hr_api.g_varchar2,
609: p_bpa_attribute20 in varchar2 default hr_api.g_varchar2,

Line 606: p_bpa_attribute17 in varchar2 default hr_api.g_varchar2,

602: p_bpa_attribute13 in varchar2 default hr_api.g_varchar2,
603: p_bpa_attribute14 in varchar2 default hr_api.g_varchar2,
604: p_bpa_attribute15 in varchar2 default hr_api.g_varchar2,
605: p_bpa_attribute16 in varchar2 default hr_api.g_varchar2,
606: p_bpa_attribute17 in varchar2 default hr_api.g_varchar2,
607: p_bpa_attribute18 in varchar2 default hr_api.g_varchar2,
608: p_bpa_attribute19 in varchar2 default hr_api.g_varchar2,
609: p_bpa_attribute20 in varchar2 default hr_api.g_varchar2,
610: p_bpa_attribute21 in varchar2 default hr_api.g_varchar2,

Line 607: p_bpa_attribute18 in varchar2 default hr_api.g_varchar2,

603: p_bpa_attribute14 in varchar2 default hr_api.g_varchar2,
604: p_bpa_attribute15 in varchar2 default hr_api.g_varchar2,
605: p_bpa_attribute16 in varchar2 default hr_api.g_varchar2,
606: p_bpa_attribute17 in varchar2 default hr_api.g_varchar2,
607: p_bpa_attribute18 in varchar2 default hr_api.g_varchar2,
608: p_bpa_attribute19 in varchar2 default hr_api.g_varchar2,
609: p_bpa_attribute20 in varchar2 default hr_api.g_varchar2,
610: p_bpa_attribute21 in varchar2 default hr_api.g_varchar2,
611: p_bpa_attribute22 in varchar2 default hr_api.g_varchar2,

Line 608: p_bpa_attribute19 in varchar2 default hr_api.g_varchar2,

604: p_bpa_attribute15 in varchar2 default hr_api.g_varchar2,
605: p_bpa_attribute16 in varchar2 default hr_api.g_varchar2,
606: p_bpa_attribute17 in varchar2 default hr_api.g_varchar2,
607: p_bpa_attribute18 in varchar2 default hr_api.g_varchar2,
608: p_bpa_attribute19 in varchar2 default hr_api.g_varchar2,
609: p_bpa_attribute20 in varchar2 default hr_api.g_varchar2,
610: p_bpa_attribute21 in varchar2 default hr_api.g_varchar2,
611: p_bpa_attribute22 in varchar2 default hr_api.g_varchar2,
612: p_bpa_attribute23 in varchar2 default hr_api.g_varchar2,

Line 609: p_bpa_attribute20 in varchar2 default hr_api.g_varchar2,

605: p_bpa_attribute16 in varchar2 default hr_api.g_varchar2,
606: p_bpa_attribute17 in varchar2 default hr_api.g_varchar2,
607: p_bpa_attribute18 in varchar2 default hr_api.g_varchar2,
608: p_bpa_attribute19 in varchar2 default hr_api.g_varchar2,
609: p_bpa_attribute20 in varchar2 default hr_api.g_varchar2,
610: p_bpa_attribute21 in varchar2 default hr_api.g_varchar2,
611: p_bpa_attribute22 in varchar2 default hr_api.g_varchar2,
612: p_bpa_attribute23 in varchar2 default hr_api.g_varchar2,
613: p_bpa_attribute24 in varchar2 default hr_api.g_varchar2,

Line 610: p_bpa_attribute21 in varchar2 default hr_api.g_varchar2,

606: p_bpa_attribute17 in varchar2 default hr_api.g_varchar2,
607: p_bpa_attribute18 in varchar2 default hr_api.g_varchar2,
608: p_bpa_attribute19 in varchar2 default hr_api.g_varchar2,
609: p_bpa_attribute20 in varchar2 default hr_api.g_varchar2,
610: p_bpa_attribute21 in varchar2 default hr_api.g_varchar2,
611: p_bpa_attribute22 in varchar2 default hr_api.g_varchar2,
612: p_bpa_attribute23 in varchar2 default hr_api.g_varchar2,
613: p_bpa_attribute24 in varchar2 default hr_api.g_varchar2,
614: p_bpa_attribute25 in varchar2 default hr_api.g_varchar2,

Line 611: p_bpa_attribute22 in varchar2 default hr_api.g_varchar2,

607: p_bpa_attribute18 in varchar2 default hr_api.g_varchar2,
608: p_bpa_attribute19 in varchar2 default hr_api.g_varchar2,
609: p_bpa_attribute20 in varchar2 default hr_api.g_varchar2,
610: p_bpa_attribute21 in varchar2 default hr_api.g_varchar2,
611: p_bpa_attribute22 in varchar2 default hr_api.g_varchar2,
612: p_bpa_attribute23 in varchar2 default hr_api.g_varchar2,
613: p_bpa_attribute24 in varchar2 default hr_api.g_varchar2,
614: p_bpa_attribute25 in varchar2 default hr_api.g_varchar2,
615: p_bpa_attribute26 in varchar2 default hr_api.g_varchar2,

Line 612: p_bpa_attribute23 in varchar2 default hr_api.g_varchar2,

608: p_bpa_attribute19 in varchar2 default hr_api.g_varchar2,
609: p_bpa_attribute20 in varchar2 default hr_api.g_varchar2,
610: p_bpa_attribute21 in varchar2 default hr_api.g_varchar2,
611: p_bpa_attribute22 in varchar2 default hr_api.g_varchar2,
612: p_bpa_attribute23 in varchar2 default hr_api.g_varchar2,
613: p_bpa_attribute24 in varchar2 default hr_api.g_varchar2,
614: p_bpa_attribute25 in varchar2 default hr_api.g_varchar2,
615: p_bpa_attribute26 in varchar2 default hr_api.g_varchar2,
616: p_bpa_attribute27 in varchar2 default hr_api.g_varchar2,

Line 613: p_bpa_attribute24 in varchar2 default hr_api.g_varchar2,

609: p_bpa_attribute20 in varchar2 default hr_api.g_varchar2,
610: p_bpa_attribute21 in varchar2 default hr_api.g_varchar2,
611: p_bpa_attribute22 in varchar2 default hr_api.g_varchar2,
612: p_bpa_attribute23 in varchar2 default hr_api.g_varchar2,
613: p_bpa_attribute24 in varchar2 default hr_api.g_varchar2,
614: p_bpa_attribute25 in varchar2 default hr_api.g_varchar2,
615: p_bpa_attribute26 in varchar2 default hr_api.g_varchar2,
616: p_bpa_attribute27 in varchar2 default hr_api.g_varchar2,
617: p_bpa_attribute28 in varchar2 default hr_api.g_varchar2,

Line 614: p_bpa_attribute25 in varchar2 default hr_api.g_varchar2,

610: p_bpa_attribute21 in varchar2 default hr_api.g_varchar2,
611: p_bpa_attribute22 in varchar2 default hr_api.g_varchar2,
612: p_bpa_attribute23 in varchar2 default hr_api.g_varchar2,
613: p_bpa_attribute24 in varchar2 default hr_api.g_varchar2,
614: p_bpa_attribute25 in varchar2 default hr_api.g_varchar2,
615: p_bpa_attribute26 in varchar2 default hr_api.g_varchar2,
616: p_bpa_attribute27 in varchar2 default hr_api.g_varchar2,
617: p_bpa_attribute28 in varchar2 default hr_api.g_varchar2,
618: p_bpa_attribute29 in varchar2 default hr_api.g_varchar2,

Line 615: p_bpa_attribute26 in varchar2 default hr_api.g_varchar2,

611: p_bpa_attribute22 in varchar2 default hr_api.g_varchar2,
612: p_bpa_attribute23 in varchar2 default hr_api.g_varchar2,
613: p_bpa_attribute24 in varchar2 default hr_api.g_varchar2,
614: p_bpa_attribute25 in varchar2 default hr_api.g_varchar2,
615: p_bpa_attribute26 in varchar2 default hr_api.g_varchar2,
616: p_bpa_attribute27 in varchar2 default hr_api.g_varchar2,
617: p_bpa_attribute28 in varchar2 default hr_api.g_varchar2,
618: p_bpa_attribute29 in varchar2 default hr_api.g_varchar2,
619: p_bpa_attribute30 in varchar2 default hr_api.g_varchar2

Line 616: p_bpa_attribute27 in varchar2 default hr_api.g_varchar2,

612: p_bpa_attribute23 in varchar2 default hr_api.g_varchar2,
613: p_bpa_attribute24 in varchar2 default hr_api.g_varchar2,
614: p_bpa_attribute25 in varchar2 default hr_api.g_varchar2,
615: p_bpa_attribute26 in varchar2 default hr_api.g_varchar2,
616: p_bpa_attribute27 in varchar2 default hr_api.g_varchar2,
617: p_bpa_attribute28 in varchar2 default hr_api.g_varchar2,
618: p_bpa_attribute29 in varchar2 default hr_api.g_varchar2,
619: p_bpa_attribute30 in varchar2 default hr_api.g_varchar2
620: ) is

Line 617: p_bpa_attribute28 in varchar2 default hr_api.g_varchar2,

613: p_bpa_attribute24 in varchar2 default hr_api.g_varchar2,
614: p_bpa_attribute25 in varchar2 default hr_api.g_varchar2,
615: p_bpa_attribute26 in varchar2 default hr_api.g_varchar2,
616: p_bpa_attribute27 in varchar2 default hr_api.g_varchar2,
617: p_bpa_attribute28 in varchar2 default hr_api.g_varchar2,
618: p_bpa_attribute29 in varchar2 default hr_api.g_varchar2,
619: p_bpa_attribute30 in varchar2 default hr_api.g_varchar2
620: ) is
621: --

Line 618: p_bpa_attribute29 in varchar2 default hr_api.g_varchar2,

614: p_bpa_attribute25 in varchar2 default hr_api.g_varchar2,
615: p_bpa_attribute26 in varchar2 default hr_api.g_varchar2,
616: p_bpa_attribute27 in varchar2 default hr_api.g_varchar2,
617: p_bpa_attribute28 in varchar2 default hr_api.g_varchar2,
618: p_bpa_attribute29 in varchar2 default hr_api.g_varchar2,
619: p_bpa_attribute30 in varchar2 default hr_api.g_varchar2
620: ) is
621: --
622: l_rec per_bpa_shd.g_rec_type;

Line 619: p_bpa_attribute30 in varchar2 default hr_api.g_varchar2

615: p_bpa_attribute26 in varchar2 default hr_api.g_varchar2,
616: p_bpa_attribute27 in varchar2 default hr_api.g_varchar2,
617: p_bpa_attribute28 in varchar2 default hr_api.g_varchar2,
618: p_bpa_attribute29 in varchar2 default hr_api.g_varchar2,
619: p_bpa_attribute30 in varchar2 default hr_api.g_varchar2
620: ) is
621: --
622: l_rec per_bpa_shd.g_rec_type;
623: l_proc varchar2(72) := g_package||'upd';

Line 634: hr_api.g_number,

630: --
631: l_rec :=
632: per_bpa_shd.convert_args
633: (p_processed_assignment_id,
634: hr_api.g_number,
635: hr_api.g_number,
636: p_object_version_number,
637: p_bpa_attribute_category,
638: p_bpa_attribute1,

Line 635: hr_api.g_number,

631: l_rec :=
632: per_bpa_shd.convert_args
633: (p_processed_assignment_id,
634: hr_api.g_number,
635: hr_api.g_number,
636: p_object_version_number,
637: p_bpa_attribute_category,
638: p_bpa_attribute1,
639: p_bpa_attribute2,