APPS.PER_PEA_UPD dependencies on HR_API

Line 109: When hr_api.check_integrity_violated Then

105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 10);
107: --
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: per_pea_shd.g_api_dml := false; -- Unset the api dml status
112: per_pea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: per_pea_shd.g_api_dml := false; -- Unset the api dml status
112: per_pea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: per_pea_shd.g_api_dml := false; -- Unset the api dml status
117: per_pea_shd.constraint_error

Line 114: When hr_api.parent_integrity_violated Then

110: -- A check constraint has been violated
111: per_pea_shd.g_api_dml := false; -- Unset the api dml status
112: per_pea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: per_pea_shd.g_api_dml := false; -- Unset the api dml status
117: per_pea_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.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: per_pea_shd.g_api_dml := false; -- Unset the api dml status
117: per_pea_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: per_pea_shd.g_api_dml := false; -- Unset the api dml status
122: per_pea_shd.constraint_error

Line 119: When hr_api.unique_integrity_violated Then

115: -- Parent integrity has been violated
116: per_pea_shd.g_api_dml := false; -- Unset the api dml status
117: per_pea_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: per_pea_shd.g_api_dml := false; -- Unset the api dml status
122: per_pea_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.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: per_pea_shd.g_api_dml := false; -- Unset the api dml status
122: per_pea_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: per_pea_shd.g_api_dml := false; -- Unset the api dml status
126: Raise;
127: End update_dml;

Line 354: when hr_api.cannot_find_prog_unit then

350: -- End of BEN LER Check
351:
352:
353: exception
354: when hr_api.cannot_find_prog_unit then
355: hr_api.cannot_find_prog_unit_error
356: (p_module_name => 'PER_PERSON_ANALYSES'
357: ,p_hook_type => 'AU'
358: );

Line 355: hr_api.cannot_find_prog_unit_error

351:
352:
353: exception
354: when hr_api.cannot_find_prog_unit then
355: hr_api.cannot_find_prog_unit_error
356: (p_module_name => 'PER_PERSON_ANALYSES'
357: ,p_hook_type => 'AU'
358: );
359: end;

Line 422: If (p_rec.business_group_id = hr_api.g_number) then

418: -- p_rec plsql record structure
419: -- to see if a system default is being used. If a system default
420: -- is being used then we must set to the 'current' argument value.
421: --
422: If (p_rec.business_group_id = hr_api.g_number) then
423: p_rec.business_group_id :=
424: per_pea_shd.g_old_rec.business_group_id;
425: End If;
426: If (p_rec.analysis_criteria_id = hr_api.g_number) then

Line 426: If (p_rec.analysis_criteria_id = hr_api.g_number) then

422: If (p_rec.business_group_id = hr_api.g_number) then
423: p_rec.business_group_id :=
424: per_pea_shd.g_old_rec.business_group_id;
425: End If;
426: If (p_rec.analysis_criteria_id = hr_api.g_number) then
427: p_rec.analysis_criteria_id :=
428: per_pea_shd.g_old_rec.analysis_criteria_id;
429: End If;
430: If (p_rec.person_id = hr_api.g_number) then

Line 430: If (p_rec.person_id = hr_api.g_number) then

426: If (p_rec.analysis_criteria_id = hr_api.g_number) then
427: p_rec.analysis_criteria_id :=
428: per_pea_shd.g_old_rec.analysis_criteria_id;
429: End If;
430: If (p_rec.person_id = hr_api.g_number) then
431: p_rec.person_id :=
432: per_pea_shd.g_old_rec.person_id;
433: End If;
434: If (p_rec.comments = hr_api.g_varchar2) then

Line 434: If (p_rec.comments = hr_api.g_varchar2) then

430: If (p_rec.person_id = hr_api.g_number) then
431: p_rec.person_id :=
432: per_pea_shd.g_old_rec.person_id;
433: End If;
434: If (p_rec.comments = hr_api.g_varchar2) then
435: p_rec.comments :=
436: per_pea_shd.g_old_rec.comments;
437: End If;
438: If (p_rec.date_from = hr_api.g_date) then

Line 438: If (p_rec.date_from = hr_api.g_date) then

434: If (p_rec.comments = hr_api.g_varchar2) then
435: p_rec.comments :=
436: per_pea_shd.g_old_rec.comments;
437: End If;
438: If (p_rec.date_from = hr_api.g_date) then
439: p_rec.date_from :=
440: per_pea_shd.g_old_rec.date_from;
441: End If;
442: If (p_rec.date_to = hr_api.g_date) then

Line 442: If (p_rec.date_to = hr_api.g_date) then

438: If (p_rec.date_from = hr_api.g_date) then
439: p_rec.date_from :=
440: per_pea_shd.g_old_rec.date_from;
441: End If;
442: If (p_rec.date_to = hr_api.g_date) then
443: p_rec.date_to :=
444: per_pea_shd.g_old_rec.date_to;
445: End If;
446: If (p_rec.id_flex_num = hr_api.g_number) then

Line 446: If (p_rec.id_flex_num = hr_api.g_number) then

442: If (p_rec.date_to = hr_api.g_date) then
443: p_rec.date_to :=
444: per_pea_shd.g_old_rec.date_to;
445: End If;
446: If (p_rec.id_flex_num = hr_api.g_number) then
447: p_rec.id_flex_num :=
448: per_pea_shd.g_old_rec.id_flex_num;
449: End If;
450: If (p_rec.request_id = hr_api.g_number) then

Line 450: If (p_rec.request_id = hr_api.g_number) then

446: If (p_rec.id_flex_num = hr_api.g_number) then
447: p_rec.id_flex_num :=
448: per_pea_shd.g_old_rec.id_flex_num;
449: End If;
450: If (p_rec.request_id = hr_api.g_number) then
451: p_rec.request_id :=
452: per_pea_shd.g_old_rec.request_id;
453: End If;
454: If (p_rec.program_application_id = hr_api.g_number) then

Line 454: If (p_rec.program_application_id = hr_api.g_number) then

450: If (p_rec.request_id = hr_api.g_number) then
451: p_rec.request_id :=
452: per_pea_shd.g_old_rec.request_id;
453: End If;
454: If (p_rec.program_application_id = hr_api.g_number) then
455: p_rec.program_application_id :=
456: per_pea_shd.g_old_rec.program_application_id;
457: End If;
458: If (p_rec.program_id = hr_api.g_number) then

Line 458: If (p_rec.program_id = hr_api.g_number) then

454: If (p_rec.program_application_id = hr_api.g_number) then
455: p_rec.program_application_id :=
456: per_pea_shd.g_old_rec.program_application_id;
457: End If;
458: If (p_rec.program_id = hr_api.g_number) then
459: p_rec.program_id :=
460: per_pea_shd.g_old_rec.program_id;
461: End If;
462: If (p_rec.program_update_date = hr_api.g_date) then

Line 462: If (p_rec.program_update_date = hr_api.g_date) then

458: If (p_rec.program_id = hr_api.g_number) then
459: p_rec.program_id :=
460: per_pea_shd.g_old_rec.program_id;
461: End If;
462: If (p_rec.program_update_date = hr_api.g_date) then
463: p_rec.program_update_date :=
464: per_pea_shd.g_old_rec.program_update_date;
465: End If;
466: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 466: If (p_rec.attribute_category = hr_api.g_varchar2) then

462: If (p_rec.program_update_date = hr_api.g_date) then
463: p_rec.program_update_date :=
464: per_pea_shd.g_old_rec.program_update_date;
465: End If;
466: If (p_rec.attribute_category = hr_api.g_varchar2) then
467: p_rec.attribute_category :=
468: per_pea_shd.g_old_rec.attribute_category;
469: End If;
470: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 470: If (p_rec.attribute1 = hr_api.g_varchar2) then

466: If (p_rec.attribute_category = hr_api.g_varchar2) then
467: p_rec.attribute_category :=
468: per_pea_shd.g_old_rec.attribute_category;
469: End If;
470: If (p_rec.attribute1 = hr_api.g_varchar2) then
471: p_rec.attribute1 :=
472: per_pea_shd.g_old_rec.attribute1;
473: End If;
474: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 474: If (p_rec.attribute2 = hr_api.g_varchar2) then

470: If (p_rec.attribute1 = hr_api.g_varchar2) then
471: p_rec.attribute1 :=
472: per_pea_shd.g_old_rec.attribute1;
473: End If;
474: If (p_rec.attribute2 = hr_api.g_varchar2) then
475: p_rec.attribute2 :=
476: per_pea_shd.g_old_rec.attribute2;
477: End If;
478: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 478: If (p_rec.attribute3 = hr_api.g_varchar2) then

474: If (p_rec.attribute2 = hr_api.g_varchar2) then
475: p_rec.attribute2 :=
476: per_pea_shd.g_old_rec.attribute2;
477: End If;
478: If (p_rec.attribute3 = hr_api.g_varchar2) then
479: p_rec.attribute3 :=
480: per_pea_shd.g_old_rec.attribute3;
481: End If;
482: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 482: If (p_rec.attribute4 = hr_api.g_varchar2) then

478: If (p_rec.attribute3 = hr_api.g_varchar2) then
479: p_rec.attribute3 :=
480: per_pea_shd.g_old_rec.attribute3;
481: End If;
482: If (p_rec.attribute4 = hr_api.g_varchar2) then
483: p_rec.attribute4 :=
484: per_pea_shd.g_old_rec.attribute4;
485: End If;
486: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 486: If (p_rec.attribute5 = hr_api.g_varchar2) then

482: If (p_rec.attribute4 = hr_api.g_varchar2) then
483: p_rec.attribute4 :=
484: per_pea_shd.g_old_rec.attribute4;
485: End If;
486: If (p_rec.attribute5 = hr_api.g_varchar2) then
487: p_rec.attribute5 :=
488: per_pea_shd.g_old_rec.attribute5;
489: End If;
490: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 490: If (p_rec.attribute6 = hr_api.g_varchar2) then

486: If (p_rec.attribute5 = hr_api.g_varchar2) then
487: p_rec.attribute5 :=
488: per_pea_shd.g_old_rec.attribute5;
489: End If;
490: If (p_rec.attribute6 = hr_api.g_varchar2) then
491: p_rec.attribute6 :=
492: per_pea_shd.g_old_rec.attribute6;
493: End If;
494: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 494: If (p_rec.attribute7 = hr_api.g_varchar2) then

490: If (p_rec.attribute6 = hr_api.g_varchar2) then
491: p_rec.attribute6 :=
492: per_pea_shd.g_old_rec.attribute6;
493: End If;
494: If (p_rec.attribute7 = hr_api.g_varchar2) then
495: p_rec.attribute7 :=
496: per_pea_shd.g_old_rec.attribute7;
497: End If;
498: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 498: If (p_rec.attribute8 = hr_api.g_varchar2) then

494: If (p_rec.attribute7 = hr_api.g_varchar2) then
495: p_rec.attribute7 :=
496: per_pea_shd.g_old_rec.attribute7;
497: End If;
498: If (p_rec.attribute8 = hr_api.g_varchar2) then
499: p_rec.attribute8 :=
500: per_pea_shd.g_old_rec.attribute8;
501: End If;
502: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 502: If (p_rec.attribute9 = hr_api.g_varchar2) then

498: If (p_rec.attribute8 = hr_api.g_varchar2) then
499: p_rec.attribute8 :=
500: per_pea_shd.g_old_rec.attribute8;
501: End If;
502: If (p_rec.attribute9 = hr_api.g_varchar2) then
503: p_rec.attribute9 :=
504: per_pea_shd.g_old_rec.attribute9;
505: End If;
506: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 506: If (p_rec.attribute10 = hr_api.g_varchar2) then

502: If (p_rec.attribute9 = hr_api.g_varchar2) then
503: p_rec.attribute9 :=
504: per_pea_shd.g_old_rec.attribute9;
505: End If;
506: If (p_rec.attribute10 = hr_api.g_varchar2) then
507: p_rec.attribute10 :=
508: per_pea_shd.g_old_rec.attribute10;
509: End If;
510: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 510: If (p_rec.attribute11 = hr_api.g_varchar2) then

506: If (p_rec.attribute10 = hr_api.g_varchar2) then
507: p_rec.attribute10 :=
508: per_pea_shd.g_old_rec.attribute10;
509: End If;
510: If (p_rec.attribute11 = hr_api.g_varchar2) then
511: p_rec.attribute11 :=
512: per_pea_shd.g_old_rec.attribute11;
513: End If;
514: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 514: If (p_rec.attribute12 = hr_api.g_varchar2) then

510: If (p_rec.attribute11 = hr_api.g_varchar2) then
511: p_rec.attribute11 :=
512: per_pea_shd.g_old_rec.attribute11;
513: End If;
514: If (p_rec.attribute12 = hr_api.g_varchar2) then
515: p_rec.attribute12 :=
516: per_pea_shd.g_old_rec.attribute12;
517: End If;
518: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 518: If (p_rec.attribute13 = hr_api.g_varchar2) then

514: If (p_rec.attribute12 = hr_api.g_varchar2) then
515: p_rec.attribute12 :=
516: per_pea_shd.g_old_rec.attribute12;
517: End If;
518: If (p_rec.attribute13 = hr_api.g_varchar2) then
519: p_rec.attribute13 :=
520: per_pea_shd.g_old_rec.attribute13;
521: End If;
522: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 522: If (p_rec.attribute14 = hr_api.g_varchar2) then

518: If (p_rec.attribute13 = hr_api.g_varchar2) then
519: p_rec.attribute13 :=
520: per_pea_shd.g_old_rec.attribute13;
521: End If;
522: If (p_rec.attribute14 = hr_api.g_varchar2) then
523: p_rec.attribute14 :=
524: per_pea_shd.g_old_rec.attribute14;
525: End If;
526: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 526: If (p_rec.attribute15 = hr_api.g_varchar2) then

522: If (p_rec.attribute14 = hr_api.g_varchar2) then
523: p_rec.attribute14 :=
524: per_pea_shd.g_old_rec.attribute14;
525: End If;
526: If (p_rec.attribute15 = hr_api.g_varchar2) then
527: p_rec.attribute15 :=
528: per_pea_shd.g_old_rec.attribute15;
529: End If;
530: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 530: If (p_rec.attribute16 = hr_api.g_varchar2) then

526: If (p_rec.attribute15 = hr_api.g_varchar2) then
527: p_rec.attribute15 :=
528: per_pea_shd.g_old_rec.attribute15;
529: End If;
530: If (p_rec.attribute16 = hr_api.g_varchar2) then
531: p_rec.attribute16 :=
532: per_pea_shd.g_old_rec.attribute16;
533: End If;
534: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 534: If (p_rec.attribute17 = hr_api.g_varchar2) then

530: If (p_rec.attribute16 = hr_api.g_varchar2) then
531: p_rec.attribute16 :=
532: per_pea_shd.g_old_rec.attribute16;
533: End If;
534: If (p_rec.attribute17 = hr_api.g_varchar2) then
535: p_rec.attribute17 :=
536: per_pea_shd.g_old_rec.attribute17;
537: End If;
538: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 538: If (p_rec.attribute18 = hr_api.g_varchar2) then

534: If (p_rec.attribute17 = hr_api.g_varchar2) then
535: p_rec.attribute17 :=
536: per_pea_shd.g_old_rec.attribute17;
537: End If;
538: If (p_rec.attribute18 = hr_api.g_varchar2) then
539: p_rec.attribute18 :=
540: per_pea_shd.g_old_rec.attribute18;
541: End If;
542: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 542: If (p_rec.attribute19 = hr_api.g_varchar2) then

538: If (p_rec.attribute18 = hr_api.g_varchar2) then
539: p_rec.attribute18 :=
540: per_pea_shd.g_old_rec.attribute18;
541: End If;
542: If (p_rec.attribute19 = hr_api.g_varchar2) then
543: p_rec.attribute19 :=
544: per_pea_shd.g_old_rec.attribute19;
545: End If;
546: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 546: If (p_rec.attribute20 = hr_api.g_varchar2) then

542: If (p_rec.attribute19 = hr_api.g_varchar2) then
543: p_rec.attribute19 :=
544: per_pea_shd.g_old_rec.attribute19;
545: End If;
546: If (p_rec.attribute20 = hr_api.g_varchar2) then
547: p_rec.attribute20 :=
548: per_pea_shd.g_old_rec.attribute20;
549: End If;
550: --

Line 623: Raise HR_Api.Validate_Enabled;

619: --
620: -- If we are validating then raise the Validate_Enabled exception
621: --
622: If p_validate then
623: Raise HR_Api.Validate_Enabled;
624: End If;
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 10);
627: Exception

Line 628: When HR_Api.Validate_Enabled Then

624: End If;
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 10);
627: Exception
628: When HR_Api.Validate_Enabled Then
629: --
630: -- As the Validate_Enabled exception has been raised
631: -- we must rollback to the savepoint
632: --

Line 643: p_analysis_criteria_id in number default hr_api.g_number,

639: -- ----------------------------------------------------------------------------
640: Procedure upd
641: (
642: p_person_analysis_id in number,
643: p_analysis_criteria_id in number default hr_api.g_number,
644: p_comments in varchar2 default hr_api.g_varchar2,
645: p_date_from in date default hr_api.g_date,
646: p_date_to in date default hr_api.g_date,
647: p_id_flex_num in number default hr_api.g_number,

Line 644: p_comments in varchar2 default hr_api.g_varchar2,

640: Procedure upd
641: (
642: p_person_analysis_id in number,
643: p_analysis_criteria_id in number default hr_api.g_number,
644: p_comments in varchar2 default hr_api.g_varchar2,
645: p_date_from in date default hr_api.g_date,
646: p_date_to in date default hr_api.g_date,
647: p_id_flex_num in number default hr_api.g_number,
648: p_request_id in number default hr_api.g_number,

Line 645: p_date_from in date default hr_api.g_date,

641: (
642: p_person_analysis_id in number,
643: p_analysis_criteria_id in number default hr_api.g_number,
644: p_comments in varchar2 default hr_api.g_varchar2,
645: p_date_from in date default hr_api.g_date,
646: p_date_to in date default hr_api.g_date,
647: p_id_flex_num in number default hr_api.g_number,
648: p_request_id in number default hr_api.g_number,
649: p_program_application_id in number default hr_api.g_number,

Line 646: p_date_to in date default hr_api.g_date,

642: p_person_analysis_id in number,
643: p_analysis_criteria_id in number default hr_api.g_number,
644: p_comments in varchar2 default hr_api.g_varchar2,
645: p_date_from in date default hr_api.g_date,
646: p_date_to in date default hr_api.g_date,
647: p_id_flex_num in number default hr_api.g_number,
648: p_request_id in number default hr_api.g_number,
649: p_program_application_id in number default hr_api.g_number,
650: p_program_id in number default hr_api.g_number,

Line 647: p_id_flex_num in number default hr_api.g_number,

643: p_analysis_criteria_id in number default hr_api.g_number,
644: p_comments in varchar2 default hr_api.g_varchar2,
645: p_date_from in date default hr_api.g_date,
646: p_date_to in date default hr_api.g_date,
647: p_id_flex_num in number default hr_api.g_number,
648: p_request_id in number default hr_api.g_number,
649: p_program_application_id in number default hr_api.g_number,
650: p_program_id in number default hr_api.g_number,
651: p_program_update_date in date default hr_api.g_date,

Line 648: p_request_id in number default hr_api.g_number,

644: p_comments in varchar2 default hr_api.g_varchar2,
645: p_date_from in date default hr_api.g_date,
646: p_date_to in date default hr_api.g_date,
647: p_id_flex_num in number default hr_api.g_number,
648: p_request_id in number default hr_api.g_number,
649: p_program_application_id in number default hr_api.g_number,
650: p_program_id in number default hr_api.g_number,
651: p_program_update_date in date default hr_api.g_date,
652: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 649: p_program_application_id in number default hr_api.g_number,

645: p_date_from in date default hr_api.g_date,
646: p_date_to in date default hr_api.g_date,
647: p_id_flex_num in number default hr_api.g_number,
648: p_request_id in number default hr_api.g_number,
649: p_program_application_id in number default hr_api.g_number,
650: p_program_id in number default hr_api.g_number,
651: p_program_update_date in date default hr_api.g_date,
652: p_attribute_category in varchar2 default hr_api.g_varchar2,
653: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 650: p_program_id in number default hr_api.g_number,

646: p_date_to in date default hr_api.g_date,
647: p_id_flex_num in number default hr_api.g_number,
648: p_request_id in number default hr_api.g_number,
649: p_program_application_id in number default hr_api.g_number,
650: p_program_id in number default hr_api.g_number,
651: p_program_update_date in date default hr_api.g_date,
652: p_attribute_category in varchar2 default hr_api.g_varchar2,
653: p_attribute1 in varchar2 default hr_api.g_varchar2,
654: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 651: p_program_update_date in date default hr_api.g_date,

647: p_id_flex_num in number default hr_api.g_number,
648: p_request_id in number default hr_api.g_number,
649: p_program_application_id in number default hr_api.g_number,
650: p_program_id in number default hr_api.g_number,
651: p_program_update_date in date default hr_api.g_date,
652: p_attribute_category in varchar2 default hr_api.g_varchar2,
653: p_attribute1 in varchar2 default hr_api.g_varchar2,
654: p_attribute2 in varchar2 default hr_api.g_varchar2,
655: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 652: p_attribute_category in varchar2 default hr_api.g_varchar2,

648: p_request_id in number default hr_api.g_number,
649: p_program_application_id in number default hr_api.g_number,
650: p_program_id in number default hr_api.g_number,
651: p_program_update_date in date default hr_api.g_date,
652: p_attribute_category in varchar2 default hr_api.g_varchar2,
653: p_attribute1 in varchar2 default hr_api.g_varchar2,
654: p_attribute2 in varchar2 default hr_api.g_varchar2,
655: p_attribute3 in varchar2 default hr_api.g_varchar2,
656: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 653: p_attribute1 in varchar2 default hr_api.g_varchar2,

649: p_program_application_id in number default hr_api.g_number,
650: p_program_id in number default hr_api.g_number,
651: p_program_update_date in date default hr_api.g_date,
652: p_attribute_category in varchar2 default hr_api.g_varchar2,
653: p_attribute1 in varchar2 default hr_api.g_varchar2,
654: p_attribute2 in varchar2 default hr_api.g_varchar2,
655: p_attribute3 in varchar2 default hr_api.g_varchar2,
656: p_attribute4 in varchar2 default hr_api.g_varchar2,
657: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 654: p_attribute2 in varchar2 default hr_api.g_varchar2,

650: p_program_id in number default hr_api.g_number,
651: p_program_update_date in date default hr_api.g_date,
652: p_attribute_category in varchar2 default hr_api.g_varchar2,
653: p_attribute1 in varchar2 default hr_api.g_varchar2,
654: p_attribute2 in varchar2 default hr_api.g_varchar2,
655: p_attribute3 in varchar2 default hr_api.g_varchar2,
656: p_attribute4 in varchar2 default hr_api.g_varchar2,
657: p_attribute5 in varchar2 default hr_api.g_varchar2,
658: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 655: p_attribute3 in varchar2 default hr_api.g_varchar2,

651: p_program_update_date in date default hr_api.g_date,
652: p_attribute_category in varchar2 default hr_api.g_varchar2,
653: p_attribute1 in varchar2 default hr_api.g_varchar2,
654: p_attribute2 in varchar2 default hr_api.g_varchar2,
655: p_attribute3 in varchar2 default hr_api.g_varchar2,
656: p_attribute4 in varchar2 default hr_api.g_varchar2,
657: p_attribute5 in varchar2 default hr_api.g_varchar2,
658: p_attribute6 in varchar2 default hr_api.g_varchar2,
659: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 656: p_attribute4 in varchar2 default hr_api.g_varchar2,

652: p_attribute_category in varchar2 default hr_api.g_varchar2,
653: p_attribute1 in varchar2 default hr_api.g_varchar2,
654: p_attribute2 in varchar2 default hr_api.g_varchar2,
655: p_attribute3 in varchar2 default hr_api.g_varchar2,
656: p_attribute4 in varchar2 default hr_api.g_varchar2,
657: p_attribute5 in varchar2 default hr_api.g_varchar2,
658: p_attribute6 in varchar2 default hr_api.g_varchar2,
659: p_attribute7 in varchar2 default hr_api.g_varchar2,
660: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 657: p_attribute5 in varchar2 default hr_api.g_varchar2,

653: p_attribute1 in varchar2 default hr_api.g_varchar2,
654: p_attribute2 in varchar2 default hr_api.g_varchar2,
655: p_attribute3 in varchar2 default hr_api.g_varchar2,
656: p_attribute4 in varchar2 default hr_api.g_varchar2,
657: p_attribute5 in varchar2 default hr_api.g_varchar2,
658: p_attribute6 in varchar2 default hr_api.g_varchar2,
659: p_attribute7 in varchar2 default hr_api.g_varchar2,
660: p_attribute8 in varchar2 default hr_api.g_varchar2,
661: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 658: p_attribute6 in varchar2 default hr_api.g_varchar2,

654: p_attribute2 in varchar2 default hr_api.g_varchar2,
655: p_attribute3 in varchar2 default hr_api.g_varchar2,
656: p_attribute4 in varchar2 default hr_api.g_varchar2,
657: p_attribute5 in varchar2 default hr_api.g_varchar2,
658: p_attribute6 in varchar2 default hr_api.g_varchar2,
659: p_attribute7 in varchar2 default hr_api.g_varchar2,
660: p_attribute8 in varchar2 default hr_api.g_varchar2,
661: p_attribute9 in varchar2 default hr_api.g_varchar2,
662: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 659: p_attribute7 in varchar2 default hr_api.g_varchar2,

655: p_attribute3 in varchar2 default hr_api.g_varchar2,
656: p_attribute4 in varchar2 default hr_api.g_varchar2,
657: p_attribute5 in varchar2 default hr_api.g_varchar2,
658: p_attribute6 in varchar2 default hr_api.g_varchar2,
659: p_attribute7 in varchar2 default hr_api.g_varchar2,
660: p_attribute8 in varchar2 default hr_api.g_varchar2,
661: p_attribute9 in varchar2 default hr_api.g_varchar2,
662: p_attribute10 in varchar2 default hr_api.g_varchar2,
663: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 660: p_attribute8 in varchar2 default hr_api.g_varchar2,

656: p_attribute4 in varchar2 default hr_api.g_varchar2,
657: p_attribute5 in varchar2 default hr_api.g_varchar2,
658: p_attribute6 in varchar2 default hr_api.g_varchar2,
659: p_attribute7 in varchar2 default hr_api.g_varchar2,
660: p_attribute8 in varchar2 default hr_api.g_varchar2,
661: p_attribute9 in varchar2 default hr_api.g_varchar2,
662: p_attribute10 in varchar2 default hr_api.g_varchar2,
663: p_attribute11 in varchar2 default hr_api.g_varchar2,
664: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 661: p_attribute9 in varchar2 default hr_api.g_varchar2,

657: p_attribute5 in varchar2 default hr_api.g_varchar2,
658: p_attribute6 in varchar2 default hr_api.g_varchar2,
659: p_attribute7 in varchar2 default hr_api.g_varchar2,
660: p_attribute8 in varchar2 default hr_api.g_varchar2,
661: p_attribute9 in varchar2 default hr_api.g_varchar2,
662: p_attribute10 in varchar2 default hr_api.g_varchar2,
663: p_attribute11 in varchar2 default hr_api.g_varchar2,
664: p_attribute12 in varchar2 default hr_api.g_varchar2,
665: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 662: p_attribute10 in varchar2 default hr_api.g_varchar2,

658: p_attribute6 in varchar2 default hr_api.g_varchar2,
659: p_attribute7 in varchar2 default hr_api.g_varchar2,
660: p_attribute8 in varchar2 default hr_api.g_varchar2,
661: p_attribute9 in varchar2 default hr_api.g_varchar2,
662: p_attribute10 in varchar2 default hr_api.g_varchar2,
663: p_attribute11 in varchar2 default hr_api.g_varchar2,
664: p_attribute12 in varchar2 default hr_api.g_varchar2,
665: p_attribute13 in varchar2 default hr_api.g_varchar2,
666: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 663: p_attribute11 in varchar2 default hr_api.g_varchar2,

659: p_attribute7 in varchar2 default hr_api.g_varchar2,
660: p_attribute8 in varchar2 default hr_api.g_varchar2,
661: p_attribute9 in varchar2 default hr_api.g_varchar2,
662: p_attribute10 in varchar2 default hr_api.g_varchar2,
663: p_attribute11 in varchar2 default hr_api.g_varchar2,
664: p_attribute12 in varchar2 default hr_api.g_varchar2,
665: p_attribute13 in varchar2 default hr_api.g_varchar2,
666: p_attribute14 in varchar2 default hr_api.g_varchar2,
667: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 664: p_attribute12 in varchar2 default hr_api.g_varchar2,

660: p_attribute8 in varchar2 default hr_api.g_varchar2,
661: p_attribute9 in varchar2 default hr_api.g_varchar2,
662: p_attribute10 in varchar2 default hr_api.g_varchar2,
663: p_attribute11 in varchar2 default hr_api.g_varchar2,
664: p_attribute12 in varchar2 default hr_api.g_varchar2,
665: p_attribute13 in varchar2 default hr_api.g_varchar2,
666: p_attribute14 in varchar2 default hr_api.g_varchar2,
667: p_attribute15 in varchar2 default hr_api.g_varchar2,
668: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 665: p_attribute13 in varchar2 default hr_api.g_varchar2,

661: p_attribute9 in varchar2 default hr_api.g_varchar2,
662: p_attribute10 in varchar2 default hr_api.g_varchar2,
663: p_attribute11 in varchar2 default hr_api.g_varchar2,
664: p_attribute12 in varchar2 default hr_api.g_varchar2,
665: p_attribute13 in varchar2 default hr_api.g_varchar2,
666: p_attribute14 in varchar2 default hr_api.g_varchar2,
667: p_attribute15 in varchar2 default hr_api.g_varchar2,
668: p_attribute16 in varchar2 default hr_api.g_varchar2,
669: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 666: p_attribute14 in varchar2 default hr_api.g_varchar2,

662: p_attribute10 in varchar2 default hr_api.g_varchar2,
663: p_attribute11 in varchar2 default hr_api.g_varchar2,
664: p_attribute12 in varchar2 default hr_api.g_varchar2,
665: p_attribute13 in varchar2 default hr_api.g_varchar2,
666: p_attribute14 in varchar2 default hr_api.g_varchar2,
667: p_attribute15 in varchar2 default hr_api.g_varchar2,
668: p_attribute16 in varchar2 default hr_api.g_varchar2,
669: p_attribute17 in varchar2 default hr_api.g_varchar2,
670: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 667: p_attribute15 in varchar2 default hr_api.g_varchar2,

663: p_attribute11 in varchar2 default hr_api.g_varchar2,
664: p_attribute12 in varchar2 default hr_api.g_varchar2,
665: p_attribute13 in varchar2 default hr_api.g_varchar2,
666: p_attribute14 in varchar2 default hr_api.g_varchar2,
667: p_attribute15 in varchar2 default hr_api.g_varchar2,
668: p_attribute16 in varchar2 default hr_api.g_varchar2,
669: p_attribute17 in varchar2 default hr_api.g_varchar2,
670: p_attribute18 in varchar2 default hr_api.g_varchar2,
671: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 668: p_attribute16 in varchar2 default hr_api.g_varchar2,

664: p_attribute12 in varchar2 default hr_api.g_varchar2,
665: p_attribute13 in varchar2 default hr_api.g_varchar2,
666: p_attribute14 in varchar2 default hr_api.g_varchar2,
667: p_attribute15 in varchar2 default hr_api.g_varchar2,
668: p_attribute16 in varchar2 default hr_api.g_varchar2,
669: p_attribute17 in varchar2 default hr_api.g_varchar2,
670: p_attribute18 in varchar2 default hr_api.g_varchar2,
671: p_attribute19 in varchar2 default hr_api.g_varchar2,
672: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 669: p_attribute17 in varchar2 default hr_api.g_varchar2,

665: p_attribute13 in varchar2 default hr_api.g_varchar2,
666: p_attribute14 in varchar2 default hr_api.g_varchar2,
667: p_attribute15 in varchar2 default hr_api.g_varchar2,
668: p_attribute16 in varchar2 default hr_api.g_varchar2,
669: p_attribute17 in varchar2 default hr_api.g_varchar2,
670: p_attribute18 in varchar2 default hr_api.g_varchar2,
671: p_attribute19 in varchar2 default hr_api.g_varchar2,
672: p_attribute20 in varchar2 default hr_api.g_varchar2,
673: p_object_version_number in out nocopy number,

Line 670: p_attribute18 in varchar2 default hr_api.g_varchar2,

666: p_attribute14 in varchar2 default hr_api.g_varchar2,
667: p_attribute15 in varchar2 default hr_api.g_varchar2,
668: p_attribute16 in varchar2 default hr_api.g_varchar2,
669: p_attribute17 in varchar2 default hr_api.g_varchar2,
670: p_attribute18 in varchar2 default hr_api.g_varchar2,
671: p_attribute19 in varchar2 default hr_api.g_varchar2,
672: p_attribute20 in varchar2 default hr_api.g_varchar2,
673: p_object_version_number in out nocopy number,
674: p_validate in boolean default false

Line 671: p_attribute19 in varchar2 default hr_api.g_varchar2,

667: p_attribute15 in varchar2 default hr_api.g_varchar2,
668: p_attribute16 in varchar2 default hr_api.g_varchar2,
669: p_attribute17 in varchar2 default hr_api.g_varchar2,
670: p_attribute18 in varchar2 default hr_api.g_varchar2,
671: p_attribute19 in varchar2 default hr_api.g_varchar2,
672: p_attribute20 in varchar2 default hr_api.g_varchar2,
673: p_object_version_number in out nocopy number,
674: p_validate in boolean default false
675: ) is

Line 672: p_attribute20 in varchar2 default hr_api.g_varchar2,

668: p_attribute16 in varchar2 default hr_api.g_varchar2,
669: p_attribute17 in varchar2 default hr_api.g_varchar2,
670: p_attribute18 in varchar2 default hr_api.g_varchar2,
671: p_attribute19 in varchar2 default hr_api.g_varchar2,
672: p_attribute20 in varchar2 default hr_api.g_varchar2,
673: p_object_version_number in out nocopy number,
674: p_validate in boolean default false
675: ) is
676: --

Line 690: hr_api.g_number,

686: l_rec :=
687: per_pea_shd.convert_args
688: (
689: p_person_analysis_id,
690: hr_api.g_number,
691: p_analysis_criteria_id,
692: hr_api.g_number,
693: p_comments,
694: p_date_from,

Line 692: hr_api.g_number,

688: (
689: p_person_analysis_id,
690: hr_api.g_number,
691: p_analysis_criteria_id,
692: hr_api.g_number,
693: p_comments,
694: p_date_from,
695: p_date_to,
696: p_id_flex_num,