eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_FR_EMP_STAT_SITUATION_API dependencies on HR_API

Line 493: raise hr_api.validate_enabled;

489: --
490: -- Set all output arguments
491: --
492: IF p_validate = TRUE THEN
493: raise hr_api.validate_enabled;
494: END IF;
495: p_emp_stat_situation_id := l_emp_stat_situation_id;
496: p_object_version_number := l_object_version_number;
497: hr_utility.set_location(' Leaving:'||l_proc, 40);

Line 499: when hr_api.validate_enabled then

495: p_emp_stat_situation_id := l_emp_stat_situation_id;
496: p_object_version_number := l_object_version_number;
497: hr_utility.set_location(' Leaving:'||l_proc, 40);
498: EXCEPTION
499: when hr_api.validate_enabled then
500: --
501: -- As the Validate_Enabled exception has been raised
502: -- we must rollback to the savepoint
503: --

Line 517: ,P_STATUTORY_SITUATION_ID IN NUMBER default hr_api.g_number

513: procedure UPDATE_EMP_STAT_SITUATION
514: (p_validate IN boolean default false
515: ,p_effective_date IN date
516: ,P_EMP_STAT_SITUATION_ID IN NUMBER
517: ,P_STATUTORY_SITUATION_ID IN NUMBER default hr_api.g_number
518: ,P_PERSON_ID IN NUMBER default hr_api.g_number
519: ,P_PROVISIONAL_START_DATE IN DATE default hr_api.g_date
520: ,P_PROVISIONAL_END_DATE IN DATE default hr_api.g_date
521: ,P_ACTUAL_START_DATE IN DATE default hr_api.g_date

Line 518: ,P_PERSON_ID IN NUMBER default hr_api.g_number

514: (p_validate IN boolean default false
515: ,p_effective_date IN date
516: ,P_EMP_STAT_SITUATION_ID IN NUMBER
517: ,P_STATUTORY_SITUATION_ID IN NUMBER default hr_api.g_number
518: ,P_PERSON_ID IN NUMBER default hr_api.g_number
519: ,P_PROVISIONAL_START_DATE IN DATE default hr_api.g_date
520: ,P_PROVISIONAL_END_DATE IN DATE default hr_api.g_date
521: ,P_ACTUAL_START_DATE IN DATE default hr_api.g_date
522: ,P_ACTUAL_END_DATE IN DATE default hr_api.g_date

Line 519: ,P_PROVISIONAL_START_DATE IN DATE default hr_api.g_date

515: ,p_effective_date IN date
516: ,P_EMP_STAT_SITUATION_ID IN NUMBER
517: ,P_STATUTORY_SITUATION_ID IN NUMBER default hr_api.g_number
518: ,P_PERSON_ID IN NUMBER default hr_api.g_number
519: ,P_PROVISIONAL_START_DATE IN DATE default hr_api.g_date
520: ,P_PROVISIONAL_END_DATE IN DATE default hr_api.g_date
521: ,P_ACTUAL_START_DATE IN DATE default hr_api.g_date
522: ,P_ACTUAL_END_DATE IN DATE default hr_api.g_date
523: ,P_APPROVAL_FLAG IN VARCHAR2 default hr_api.g_varchar2

Line 520: ,P_PROVISIONAL_END_DATE IN DATE default hr_api.g_date

516: ,P_EMP_STAT_SITUATION_ID IN NUMBER
517: ,P_STATUTORY_SITUATION_ID IN NUMBER default hr_api.g_number
518: ,P_PERSON_ID IN NUMBER default hr_api.g_number
519: ,P_PROVISIONAL_START_DATE IN DATE default hr_api.g_date
520: ,P_PROVISIONAL_END_DATE IN DATE default hr_api.g_date
521: ,P_ACTUAL_START_DATE IN DATE default hr_api.g_date
522: ,P_ACTUAL_END_DATE IN DATE default hr_api.g_date
523: ,P_APPROVAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
524: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2

Line 521: ,P_ACTUAL_START_DATE IN DATE default hr_api.g_date

517: ,P_STATUTORY_SITUATION_ID IN NUMBER default hr_api.g_number
518: ,P_PERSON_ID IN NUMBER default hr_api.g_number
519: ,P_PROVISIONAL_START_DATE IN DATE default hr_api.g_date
520: ,P_PROVISIONAL_END_DATE IN DATE default hr_api.g_date
521: ,P_ACTUAL_START_DATE IN DATE default hr_api.g_date
522: ,P_ACTUAL_END_DATE IN DATE default hr_api.g_date
523: ,P_APPROVAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
524: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
525: ,P_CONTACT_PERSON_ID IN NUMBER default hr_api.g_number

Line 522: ,P_ACTUAL_END_DATE IN DATE default hr_api.g_date

518: ,P_PERSON_ID IN NUMBER default hr_api.g_number
519: ,P_PROVISIONAL_START_DATE IN DATE default hr_api.g_date
520: ,P_PROVISIONAL_END_DATE IN DATE default hr_api.g_date
521: ,P_ACTUAL_START_DATE IN DATE default hr_api.g_date
522: ,P_ACTUAL_END_DATE IN DATE default hr_api.g_date
523: ,P_APPROVAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
524: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
525: ,P_CONTACT_PERSON_ID IN NUMBER default hr_api.g_number
526: ,P_CONTACT_RELATIONSHIP IN VARCHAR2 default hr_api.g_varchar2

Line 523: ,P_APPROVAL_FLAG IN VARCHAR2 default hr_api.g_varchar2

519: ,P_PROVISIONAL_START_DATE IN DATE default hr_api.g_date
520: ,P_PROVISIONAL_END_DATE IN DATE default hr_api.g_date
521: ,P_ACTUAL_START_DATE IN DATE default hr_api.g_date
522: ,P_ACTUAL_END_DATE IN DATE default hr_api.g_date
523: ,P_APPROVAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
524: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
525: ,P_CONTACT_PERSON_ID IN NUMBER default hr_api.g_number
526: ,P_CONTACT_RELATIONSHIP IN VARCHAR2 default hr_api.g_varchar2
527: ,P_EXTERNAL_ORGANIZATION_ID IN NUMBER default hr_api.g_number

Line 524: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2

520: ,P_PROVISIONAL_END_DATE IN DATE default hr_api.g_date
521: ,P_ACTUAL_START_DATE IN DATE default hr_api.g_date
522: ,P_ACTUAL_END_DATE IN DATE default hr_api.g_date
523: ,P_APPROVAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
524: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
525: ,P_CONTACT_PERSON_ID IN NUMBER default hr_api.g_number
526: ,P_CONTACT_RELATIONSHIP IN VARCHAR2 default hr_api.g_varchar2
527: ,P_EXTERNAL_ORGANIZATION_ID IN NUMBER default hr_api.g_number
528: ,P_RENEWAL_FLAG IN VARCHAR2 default hr_api.g_varchar2

Line 525: ,P_CONTACT_PERSON_ID IN NUMBER default hr_api.g_number

521: ,P_ACTUAL_START_DATE IN DATE default hr_api.g_date
522: ,P_ACTUAL_END_DATE IN DATE default hr_api.g_date
523: ,P_APPROVAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
524: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
525: ,P_CONTACT_PERSON_ID IN NUMBER default hr_api.g_number
526: ,P_CONTACT_RELATIONSHIP IN VARCHAR2 default hr_api.g_varchar2
527: ,P_EXTERNAL_ORGANIZATION_ID IN NUMBER default hr_api.g_number
528: ,P_RENEWAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
529: ,P_RENEW_STAT_SITUATION_ID IN NUMBER default hr_api.g_number

Line 526: ,P_CONTACT_RELATIONSHIP IN VARCHAR2 default hr_api.g_varchar2

522: ,P_ACTUAL_END_DATE IN DATE default hr_api.g_date
523: ,P_APPROVAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
524: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
525: ,P_CONTACT_PERSON_ID IN NUMBER default hr_api.g_number
526: ,P_CONTACT_RELATIONSHIP IN VARCHAR2 default hr_api.g_varchar2
527: ,P_EXTERNAL_ORGANIZATION_ID IN NUMBER default hr_api.g_number
528: ,P_RENEWAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
529: ,P_RENEW_STAT_SITUATION_ID IN NUMBER default hr_api.g_number
530: ,P_SECONDED_CAREER_ID IN NUMBER default hr_api.g_number

Line 527: ,P_EXTERNAL_ORGANIZATION_ID IN NUMBER default hr_api.g_number

523: ,P_APPROVAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
524: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
525: ,P_CONTACT_PERSON_ID IN NUMBER default hr_api.g_number
526: ,P_CONTACT_RELATIONSHIP IN VARCHAR2 default hr_api.g_varchar2
527: ,P_EXTERNAL_ORGANIZATION_ID IN NUMBER default hr_api.g_number
528: ,P_RENEWAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
529: ,P_RENEW_STAT_SITUATION_ID IN NUMBER default hr_api.g_number
530: ,P_SECONDED_CAREER_ID IN NUMBER default hr_api.g_number
531: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

Line 528: ,P_RENEWAL_FLAG IN VARCHAR2 default hr_api.g_varchar2

524: ,P_COMMENTS IN VARCHAR2 default hr_api.g_varchar2
525: ,P_CONTACT_PERSON_ID IN NUMBER default hr_api.g_number
526: ,P_CONTACT_RELATIONSHIP IN VARCHAR2 default hr_api.g_varchar2
527: ,P_EXTERNAL_ORGANIZATION_ID IN NUMBER default hr_api.g_number
528: ,P_RENEWAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
529: ,P_RENEW_STAT_SITUATION_ID IN NUMBER default hr_api.g_number
530: ,P_SECONDED_CAREER_ID IN NUMBER default hr_api.g_number
531: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2

Line 529: ,P_RENEW_STAT_SITUATION_ID IN NUMBER default hr_api.g_number

525: ,P_CONTACT_PERSON_ID IN NUMBER default hr_api.g_number
526: ,P_CONTACT_RELATIONSHIP IN VARCHAR2 default hr_api.g_varchar2
527: ,P_EXTERNAL_ORGANIZATION_ID IN NUMBER default hr_api.g_number
528: ,P_RENEWAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
529: ,P_RENEW_STAT_SITUATION_ID IN NUMBER default hr_api.g_number
530: ,P_SECONDED_CAREER_ID IN NUMBER default hr_api.g_number
531: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2

Line 530: ,P_SECONDED_CAREER_ID IN NUMBER default hr_api.g_number

526: ,P_CONTACT_RELATIONSHIP IN VARCHAR2 default hr_api.g_varchar2
527: ,P_EXTERNAL_ORGANIZATION_ID IN NUMBER default hr_api.g_number
528: ,P_RENEWAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
529: ,P_RENEW_STAT_SITUATION_ID IN NUMBER default hr_api.g_number
530: ,P_SECONDED_CAREER_ID IN NUMBER default hr_api.g_number
531: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2

Line 531: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2

527: ,P_EXTERNAL_ORGANIZATION_ID IN NUMBER default hr_api.g_number
528: ,P_RENEWAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
529: ,P_RENEW_STAT_SITUATION_ID IN NUMBER default hr_api.g_number
530: ,P_SECONDED_CAREER_ID IN NUMBER default hr_api.g_number
531: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
535: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2

Line 532: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2

528: ,P_RENEWAL_FLAG IN VARCHAR2 default hr_api.g_varchar2
529: ,P_RENEW_STAT_SITUATION_ID IN NUMBER default hr_api.g_number
530: ,P_SECONDED_CAREER_ID IN NUMBER default hr_api.g_number
531: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
535: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
536: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2

Line 533: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2

529: ,P_RENEW_STAT_SITUATION_ID IN NUMBER default hr_api.g_number
530: ,P_SECONDED_CAREER_ID IN NUMBER default hr_api.g_number
531: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
535: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
536: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
537: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2

Line 534: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2

530: ,P_SECONDED_CAREER_ID IN NUMBER default hr_api.g_number
531: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
535: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
536: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
537: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
538: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2

Line 535: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2

531: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
535: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
536: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
537: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
538: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
539: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2

Line 536: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2

532: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
535: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
536: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
537: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
538: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
539: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
540: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2

Line 537: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2

533: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
535: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
536: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
537: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
538: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
539: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
540: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
541: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2

Line 538: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2

534: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
535: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
536: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
537: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
538: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
539: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
540: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
541: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
542: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2

Line 539: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2

535: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
536: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
537: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
538: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
539: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
540: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
541: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
542: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2

Line 540: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2

536: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
537: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
538: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
539: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
540: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
541: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
542: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2

Line 541: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2

537: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
538: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
539: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
540: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
541: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
542: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2

Line 542: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2

538: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
539: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
540: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
541: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
542: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2

Line 543: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2

539: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
540: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
541: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
542: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2

Line 544: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2

540: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
541: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
542: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2

Line 545: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2

541: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
542: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2

Line 546: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2

542: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2

Line 547: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2

543: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2

Line 548: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2

544: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2

Line 549: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2

545: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2

Line 550: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2

546: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2

Line 551: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2

547: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2

Line 552: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2

548: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2

Line 553: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2

549: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2

Line 554: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2

550: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2

Line 555: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2

551: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2

Line 556: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2

552: ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2

Line 557: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2

553: ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
561: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2

Line 558: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2

554: ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
561: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
562: ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER

Line 559: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2

555: ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
561: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
562: ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
563: ) IS

Line 560: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2

556: ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
561: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
562: ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
563: ) IS
564: l_emp_stat_situation_id NUMBER(15);

Line 561: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2

557: ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
561: ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
562: ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
563: ) IS
564: l_emp_stat_situation_id NUMBER(15);
565: l_object_version_number NUMBER(9);

Line 655: raise hr_api.validate_enabled;

651: --
652: -- Set all output arguments
653: --
654: IF p_validate = TRUE THEN
655: raise hr_api.validate_enabled;
656: END IF;
657: p_object_version_number := l_object_version_number;
658: hr_utility.set_location(' Leaving:'||l_proc, 40);
659: EXCEPTION

Line 660: when hr_api.validate_enabled then

656: END IF;
657: p_object_version_number := l_object_version_number;
658: hr_utility.set_location(' Leaving:'||l_proc, 40);
659: EXCEPTION
660: when hr_api.validate_enabled then
661: --
662: -- As the Validate_Enabled exception has been raised
663: -- we must rollback to the savepoint
664: --

Line 685: raise hr_api.validate_enabled;

681: savepoint delete_emp_stat_situation;
682: pqh_psu_del.del(p_emp_stat_situation_id => p_emp_stat_situation_id,
683: p_object_version_number => p_object_version_number);
684: IF p_validate = TRUE THEN
685: raise hr_api.validate_enabled;
686: END IF;
687: hr_utility.set_location(' Leaving:'||l_proc, 40);
688: EXCEPTION
689: when hr_api.validate_enabled then

Line 689: when hr_api.validate_enabled then

685: raise hr_api.validate_enabled;
686: END IF;
687: hr_utility.set_location(' Leaving:'||l_proc, 40);
688: EXCEPTION
689: when hr_api.validate_enabled then
690: --
691: -- As the Validate_Enabled exception has been raised
692: -- we must rollback to the savepoint
693: --

Line 758: raise hr_api.validate_enabled;

754: ,p_renewal_flag => 'Y'
755: ,p_renew_stat_situation_id => lr_currec.emp_stat_situation_id
756: ,p_object_version_number => l_new_sit_ovn);
757: IF p_validate = TRUE THEN
758: raise hr_api.validate_enabled;
759: END IF;
760: hr_utility.set_location(' Leaving:'||l_proc, 40);
761: EXCEPTION
762: when hr_api.validate_enabled then

Line 762: when hr_api.validate_enabled then

758: raise hr_api.validate_enabled;
759: END IF;
760: hr_utility.set_location(' Leaving:'||l_proc, 40);
761: EXCEPTION
762: when hr_api.validate_enabled then
763: --
764: -- As the Validate_Enabled exception has been raised
765: -- we must rollback to the savepoint
766: --

Line 838: raise hr_api.validate_enabled;

834: ,p_approval_flag => 'Y'
835: ,p_comments => p_comments
836: ,p_object_version_number => l_new_sit_ovn);
837: IF p_validate = TRUE THEN
838: raise hr_api.validate_enabled;
839: END IF;
840: hr_utility.set_location(' Leaving:'||l_proc, 40);
841: EXCEPTION
842: when hr_api.validate_enabled then

Line 842: when hr_api.validate_enabled then

838: raise hr_api.validate_enabled;
839: END IF;
840: hr_utility.set_location(' Leaving:'||l_proc, 40);
841: EXCEPTION
842: when hr_api.validate_enabled then
843: --
844: -- As the Validate_Enabled exception has been raised
845: -- we must rollback to the savepoint
846: --