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.HR_SIT_API dependencies on HR_API

Line 351: when hr_api.cannot_find_prog_unit then

347: ,p_segment30 => l_segment30
348: ,p_concat_segments => p_concat_segments
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'CREATE_SIT'
354: ,p_hook_type => 'BP'
355: );

Line 352: hr_api.cannot_find_prog_unit_error

348: ,p_concat_segments => p_concat_segments
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'CREATE_SIT'
354: ,p_hook_type => 'BP'
355: );
356: --

Line 567: when hr_api.cannot_find_prog_unit then

563: ,p_person_analysis_id => l_person_analysis_id
564: ,p_pea_object_version_number => l_object_version_number
565: );
566: exception
567: when hr_api.cannot_find_prog_unit then
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'CREATE_SIT'
570: ,p_hook_type => 'AP'
571: );

Line 568: hr_api.cannot_find_prog_unit_error

564: ,p_pea_object_version_number => l_object_version_number
565: );
566: exception
567: when hr_api.cannot_find_prog_unit then
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'CREATE_SIT'
570: ,p_hook_type => 'AP'
571: );
572: --

Line 580: raise hr_api.validate_enabled;

576: --
577: hr_utility.set_location(l_proc, 70);
578: --
579: if p_validate then
580: raise hr_api.validate_enabled;
581: end if;
582: --
583: hr_utility.set_location(l_proc, 75);
584: --

Line 599: when hr_api.validate_enabled then

595: end if;
596: --
597: hr_utility.set_location(' Leaving:'||l_proc, 80);
598: exception
599: when hr_api.validate_enabled then
600: --
601: -- As the Validate_Enabled exception has been raised
602: -- we must rollback to the savepoint
603: --

Line 645: ,p_comments in varchar2 default hr_api.g_varchar2

641: procedure update_sit
642: (p_validate in boolean default false
643: ,p_person_analysis_id in number
644: ,p_pea_object_version_number in out nocopy number
645: ,p_comments in varchar2 default hr_api.g_varchar2
646: ,p_date_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date
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_from in date default hr_api.g_date

642: (p_validate in boolean default false
643: ,p_person_analysis_id in number
644: ,p_pea_object_version_number in out nocopy number
645: ,p_comments in varchar2 default hr_api.g_varchar2
646: ,p_date_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date
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_date_to in date default hr_api.g_date

643: ,p_person_analysis_id in number
644: ,p_pea_object_version_number in out nocopy number
645: ,p_comments in varchar2 default hr_api.g_varchar2
646: ,p_date_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date
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_pea_object_version_number in out nocopy number
645: ,p_comments in varchar2 default hr_api.g_varchar2
646: ,p_date_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date
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_comments in varchar2 default hr_api.g_varchar2
646: ,p_date_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date
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_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date
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_date_to in date default hr_api.g_date
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_segment1 in varchar2 default hr_api.g_varchar2

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_segment1 in varchar2 default hr_api.g_varchar2
674: ,p_segment2 in varchar2 default hr_api.g_varchar2

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_segment1 in varchar2 default hr_api.g_varchar2
674: ,p_segment2 in varchar2 default hr_api.g_varchar2
675: ,p_segment3 in varchar2 default hr_api.g_varchar2

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_segment1 in varchar2 default hr_api.g_varchar2
674: ,p_segment2 in varchar2 default hr_api.g_varchar2
675: ,p_segment3 in varchar2 default hr_api.g_varchar2
676: ,p_segment4 in varchar2 default hr_api.g_varchar2

Line 673: ,p_segment1 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_segment1 in varchar2 default hr_api.g_varchar2
674: ,p_segment2 in varchar2 default hr_api.g_varchar2
675: ,p_segment3 in varchar2 default hr_api.g_varchar2
676: ,p_segment4 in varchar2 default hr_api.g_varchar2
677: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 674: ,p_segment2 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_segment1 in varchar2 default hr_api.g_varchar2
674: ,p_segment2 in varchar2 default hr_api.g_varchar2
675: ,p_segment3 in varchar2 default hr_api.g_varchar2
676: ,p_segment4 in varchar2 default hr_api.g_varchar2
677: ,p_segment5 in varchar2 default hr_api.g_varchar2
678: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 675: ,p_segment3 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_segment1 in varchar2 default hr_api.g_varchar2
674: ,p_segment2 in varchar2 default hr_api.g_varchar2
675: ,p_segment3 in varchar2 default hr_api.g_varchar2
676: ,p_segment4 in varchar2 default hr_api.g_varchar2
677: ,p_segment5 in varchar2 default hr_api.g_varchar2
678: ,p_segment6 in varchar2 default hr_api.g_varchar2
679: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 676: ,p_segment4 in varchar2 default hr_api.g_varchar2

672: ,p_attribute20 in varchar2 default hr_api.g_varchar2
673: ,p_segment1 in varchar2 default hr_api.g_varchar2
674: ,p_segment2 in varchar2 default hr_api.g_varchar2
675: ,p_segment3 in varchar2 default hr_api.g_varchar2
676: ,p_segment4 in varchar2 default hr_api.g_varchar2
677: ,p_segment5 in varchar2 default hr_api.g_varchar2
678: ,p_segment6 in varchar2 default hr_api.g_varchar2
679: ,p_segment7 in varchar2 default hr_api.g_varchar2
680: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 677: ,p_segment5 in varchar2 default hr_api.g_varchar2

673: ,p_segment1 in varchar2 default hr_api.g_varchar2
674: ,p_segment2 in varchar2 default hr_api.g_varchar2
675: ,p_segment3 in varchar2 default hr_api.g_varchar2
676: ,p_segment4 in varchar2 default hr_api.g_varchar2
677: ,p_segment5 in varchar2 default hr_api.g_varchar2
678: ,p_segment6 in varchar2 default hr_api.g_varchar2
679: ,p_segment7 in varchar2 default hr_api.g_varchar2
680: ,p_segment8 in varchar2 default hr_api.g_varchar2
681: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 678: ,p_segment6 in varchar2 default hr_api.g_varchar2

674: ,p_segment2 in varchar2 default hr_api.g_varchar2
675: ,p_segment3 in varchar2 default hr_api.g_varchar2
676: ,p_segment4 in varchar2 default hr_api.g_varchar2
677: ,p_segment5 in varchar2 default hr_api.g_varchar2
678: ,p_segment6 in varchar2 default hr_api.g_varchar2
679: ,p_segment7 in varchar2 default hr_api.g_varchar2
680: ,p_segment8 in varchar2 default hr_api.g_varchar2
681: ,p_segment9 in varchar2 default hr_api.g_varchar2
682: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 679: ,p_segment7 in varchar2 default hr_api.g_varchar2

675: ,p_segment3 in varchar2 default hr_api.g_varchar2
676: ,p_segment4 in varchar2 default hr_api.g_varchar2
677: ,p_segment5 in varchar2 default hr_api.g_varchar2
678: ,p_segment6 in varchar2 default hr_api.g_varchar2
679: ,p_segment7 in varchar2 default hr_api.g_varchar2
680: ,p_segment8 in varchar2 default hr_api.g_varchar2
681: ,p_segment9 in varchar2 default hr_api.g_varchar2
682: ,p_segment10 in varchar2 default hr_api.g_varchar2
683: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 680: ,p_segment8 in varchar2 default hr_api.g_varchar2

676: ,p_segment4 in varchar2 default hr_api.g_varchar2
677: ,p_segment5 in varchar2 default hr_api.g_varchar2
678: ,p_segment6 in varchar2 default hr_api.g_varchar2
679: ,p_segment7 in varchar2 default hr_api.g_varchar2
680: ,p_segment8 in varchar2 default hr_api.g_varchar2
681: ,p_segment9 in varchar2 default hr_api.g_varchar2
682: ,p_segment10 in varchar2 default hr_api.g_varchar2
683: ,p_segment11 in varchar2 default hr_api.g_varchar2
684: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 681: ,p_segment9 in varchar2 default hr_api.g_varchar2

677: ,p_segment5 in varchar2 default hr_api.g_varchar2
678: ,p_segment6 in varchar2 default hr_api.g_varchar2
679: ,p_segment7 in varchar2 default hr_api.g_varchar2
680: ,p_segment8 in varchar2 default hr_api.g_varchar2
681: ,p_segment9 in varchar2 default hr_api.g_varchar2
682: ,p_segment10 in varchar2 default hr_api.g_varchar2
683: ,p_segment11 in varchar2 default hr_api.g_varchar2
684: ,p_segment12 in varchar2 default hr_api.g_varchar2
685: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 682: ,p_segment10 in varchar2 default hr_api.g_varchar2

678: ,p_segment6 in varchar2 default hr_api.g_varchar2
679: ,p_segment7 in varchar2 default hr_api.g_varchar2
680: ,p_segment8 in varchar2 default hr_api.g_varchar2
681: ,p_segment9 in varchar2 default hr_api.g_varchar2
682: ,p_segment10 in varchar2 default hr_api.g_varchar2
683: ,p_segment11 in varchar2 default hr_api.g_varchar2
684: ,p_segment12 in varchar2 default hr_api.g_varchar2
685: ,p_segment13 in varchar2 default hr_api.g_varchar2
686: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 683: ,p_segment11 in varchar2 default hr_api.g_varchar2

679: ,p_segment7 in varchar2 default hr_api.g_varchar2
680: ,p_segment8 in varchar2 default hr_api.g_varchar2
681: ,p_segment9 in varchar2 default hr_api.g_varchar2
682: ,p_segment10 in varchar2 default hr_api.g_varchar2
683: ,p_segment11 in varchar2 default hr_api.g_varchar2
684: ,p_segment12 in varchar2 default hr_api.g_varchar2
685: ,p_segment13 in varchar2 default hr_api.g_varchar2
686: ,p_segment14 in varchar2 default hr_api.g_varchar2
687: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 684: ,p_segment12 in varchar2 default hr_api.g_varchar2

680: ,p_segment8 in varchar2 default hr_api.g_varchar2
681: ,p_segment9 in varchar2 default hr_api.g_varchar2
682: ,p_segment10 in varchar2 default hr_api.g_varchar2
683: ,p_segment11 in varchar2 default hr_api.g_varchar2
684: ,p_segment12 in varchar2 default hr_api.g_varchar2
685: ,p_segment13 in varchar2 default hr_api.g_varchar2
686: ,p_segment14 in varchar2 default hr_api.g_varchar2
687: ,p_segment15 in varchar2 default hr_api.g_varchar2
688: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 685: ,p_segment13 in varchar2 default hr_api.g_varchar2

681: ,p_segment9 in varchar2 default hr_api.g_varchar2
682: ,p_segment10 in varchar2 default hr_api.g_varchar2
683: ,p_segment11 in varchar2 default hr_api.g_varchar2
684: ,p_segment12 in varchar2 default hr_api.g_varchar2
685: ,p_segment13 in varchar2 default hr_api.g_varchar2
686: ,p_segment14 in varchar2 default hr_api.g_varchar2
687: ,p_segment15 in varchar2 default hr_api.g_varchar2
688: ,p_segment16 in varchar2 default hr_api.g_varchar2
689: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 686: ,p_segment14 in varchar2 default hr_api.g_varchar2

682: ,p_segment10 in varchar2 default hr_api.g_varchar2
683: ,p_segment11 in varchar2 default hr_api.g_varchar2
684: ,p_segment12 in varchar2 default hr_api.g_varchar2
685: ,p_segment13 in varchar2 default hr_api.g_varchar2
686: ,p_segment14 in varchar2 default hr_api.g_varchar2
687: ,p_segment15 in varchar2 default hr_api.g_varchar2
688: ,p_segment16 in varchar2 default hr_api.g_varchar2
689: ,p_segment17 in varchar2 default hr_api.g_varchar2
690: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 687: ,p_segment15 in varchar2 default hr_api.g_varchar2

683: ,p_segment11 in varchar2 default hr_api.g_varchar2
684: ,p_segment12 in varchar2 default hr_api.g_varchar2
685: ,p_segment13 in varchar2 default hr_api.g_varchar2
686: ,p_segment14 in varchar2 default hr_api.g_varchar2
687: ,p_segment15 in varchar2 default hr_api.g_varchar2
688: ,p_segment16 in varchar2 default hr_api.g_varchar2
689: ,p_segment17 in varchar2 default hr_api.g_varchar2
690: ,p_segment18 in varchar2 default hr_api.g_varchar2
691: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 688: ,p_segment16 in varchar2 default hr_api.g_varchar2

684: ,p_segment12 in varchar2 default hr_api.g_varchar2
685: ,p_segment13 in varchar2 default hr_api.g_varchar2
686: ,p_segment14 in varchar2 default hr_api.g_varchar2
687: ,p_segment15 in varchar2 default hr_api.g_varchar2
688: ,p_segment16 in varchar2 default hr_api.g_varchar2
689: ,p_segment17 in varchar2 default hr_api.g_varchar2
690: ,p_segment18 in varchar2 default hr_api.g_varchar2
691: ,p_segment19 in varchar2 default hr_api.g_varchar2
692: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 689: ,p_segment17 in varchar2 default hr_api.g_varchar2

685: ,p_segment13 in varchar2 default hr_api.g_varchar2
686: ,p_segment14 in varchar2 default hr_api.g_varchar2
687: ,p_segment15 in varchar2 default hr_api.g_varchar2
688: ,p_segment16 in varchar2 default hr_api.g_varchar2
689: ,p_segment17 in varchar2 default hr_api.g_varchar2
690: ,p_segment18 in varchar2 default hr_api.g_varchar2
691: ,p_segment19 in varchar2 default hr_api.g_varchar2
692: ,p_segment20 in varchar2 default hr_api.g_varchar2
693: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 690: ,p_segment18 in varchar2 default hr_api.g_varchar2

686: ,p_segment14 in varchar2 default hr_api.g_varchar2
687: ,p_segment15 in varchar2 default hr_api.g_varchar2
688: ,p_segment16 in varchar2 default hr_api.g_varchar2
689: ,p_segment17 in varchar2 default hr_api.g_varchar2
690: ,p_segment18 in varchar2 default hr_api.g_varchar2
691: ,p_segment19 in varchar2 default hr_api.g_varchar2
692: ,p_segment20 in varchar2 default hr_api.g_varchar2
693: ,p_segment21 in varchar2 default hr_api.g_varchar2
694: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 691: ,p_segment19 in varchar2 default hr_api.g_varchar2

687: ,p_segment15 in varchar2 default hr_api.g_varchar2
688: ,p_segment16 in varchar2 default hr_api.g_varchar2
689: ,p_segment17 in varchar2 default hr_api.g_varchar2
690: ,p_segment18 in varchar2 default hr_api.g_varchar2
691: ,p_segment19 in varchar2 default hr_api.g_varchar2
692: ,p_segment20 in varchar2 default hr_api.g_varchar2
693: ,p_segment21 in varchar2 default hr_api.g_varchar2
694: ,p_segment22 in varchar2 default hr_api.g_varchar2
695: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 692: ,p_segment20 in varchar2 default hr_api.g_varchar2

688: ,p_segment16 in varchar2 default hr_api.g_varchar2
689: ,p_segment17 in varchar2 default hr_api.g_varchar2
690: ,p_segment18 in varchar2 default hr_api.g_varchar2
691: ,p_segment19 in varchar2 default hr_api.g_varchar2
692: ,p_segment20 in varchar2 default hr_api.g_varchar2
693: ,p_segment21 in varchar2 default hr_api.g_varchar2
694: ,p_segment22 in varchar2 default hr_api.g_varchar2
695: ,p_segment23 in varchar2 default hr_api.g_varchar2
696: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 693: ,p_segment21 in varchar2 default hr_api.g_varchar2

689: ,p_segment17 in varchar2 default hr_api.g_varchar2
690: ,p_segment18 in varchar2 default hr_api.g_varchar2
691: ,p_segment19 in varchar2 default hr_api.g_varchar2
692: ,p_segment20 in varchar2 default hr_api.g_varchar2
693: ,p_segment21 in varchar2 default hr_api.g_varchar2
694: ,p_segment22 in varchar2 default hr_api.g_varchar2
695: ,p_segment23 in varchar2 default hr_api.g_varchar2
696: ,p_segment24 in varchar2 default hr_api.g_varchar2
697: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 694: ,p_segment22 in varchar2 default hr_api.g_varchar2

690: ,p_segment18 in varchar2 default hr_api.g_varchar2
691: ,p_segment19 in varchar2 default hr_api.g_varchar2
692: ,p_segment20 in varchar2 default hr_api.g_varchar2
693: ,p_segment21 in varchar2 default hr_api.g_varchar2
694: ,p_segment22 in varchar2 default hr_api.g_varchar2
695: ,p_segment23 in varchar2 default hr_api.g_varchar2
696: ,p_segment24 in varchar2 default hr_api.g_varchar2
697: ,p_segment25 in varchar2 default hr_api.g_varchar2
698: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 695: ,p_segment23 in varchar2 default hr_api.g_varchar2

691: ,p_segment19 in varchar2 default hr_api.g_varchar2
692: ,p_segment20 in varchar2 default hr_api.g_varchar2
693: ,p_segment21 in varchar2 default hr_api.g_varchar2
694: ,p_segment22 in varchar2 default hr_api.g_varchar2
695: ,p_segment23 in varchar2 default hr_api.g_varchar2
696: ,p_segment24 in varchar2 default hr_api.g_varchar2
697: ,p_segment25 in varchar2 default hr_api.g_varchar2
698: ,p_segment26 in varchar2 default hr_api.g_varchar2
699: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 696: ,p_segment24 in varchar2 default hr_api.g_varchar2

692: ,p_segment20 in varchar2 default hr_api.g_varchar2
693: ,p_segment21 in varchar2 default hr_api.g_varchar2
694: ,p_segment22 in varchar2 default hr_api.g_varchar2
695: ,p_segment23 in varchar2 default hr_api.g_varchar2
696: ,p_segment24 in varchar2 default hr_api.g_varchar2
697: ,p_segment25 in varchar2 default hr_api.g_varchar2
698: ,p_segment26 in varchar2 default hr_api.g_varchar2
699: ,p_segment27 in varchar2 default hr_api.g_varchar2
700: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 697: ,p_segment25 in varchar2 default hr_api.g_varchar2

693: ,p_segment21 in varchar2 default hr_api.g_varchar2
694: ,p_segment22 in varchar2 default hr_api.g_varchar2
695: ,p_segment23 in varchar2 default hr_api.g_varchar2
696: ,p_segment24 in varchar2 default hr_api.g_varchar2
697: ,p_segment25 in varchar2 default hr_api.g_varchar2
698: ,p_segment26 in varchar2 default hr_api.g_varchar2
699: ,p_segment27 in varchar2 default hr_api.g_varchar2
700: ,p_segment28 in varchar2 default hr_api.g_varchar2
701: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 698: ,p_segment26 in varchar2 default hr_api.g_varchar2

694: ,p_segment22 in varchar2 default hr_api.g_varchar2
695: ,p_segment23 in varchar2 default hr_api.g_varchar2
696: ,p_segment24 in varchar2 default hr_api.g_varchar2
697: ,p_segment25 in varchar2 default hr_api.g_varchar2
698: ,p_segment26 in varchar2 default hr_api.g_varchar2
699: ,p_segment27 in varchar2 default hr_api.g_varchar2
700: ,p_segment28 in varchar2 default hr_api.g_varchar2
701: ,p_segment29 in varchar2 default hr_api.g_varchar2
702: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 699: ,p_segment27 in varchar2 default hr_api.g_varchar2

695: ,p_segment23 in varchar2 default hr_api.g_varchar2
696: ,p_segment24 in varchar2 default hr_api.g_varchar2
697: ,p_segment25 in varchar2 default hr_api.g_varchar2
698: ,p_segment26 in varchar2 default hr_api.g_varchar2
699: ,p_segment27 in varchar2 default hr_api.g_varchar2
700: ,p_segment28 in varchar2 default hr_api.g_varchar2
701: ,p_segment29 in varchar2 default hr_api.g_varchar2
702: ,p_segment30 in varchar2 default hr_api.g_varchar2
703: ,p_concat_segments in varchar2 default hr_api.g_varchar2

Line 700: ,p_segment28 in varchar2 default hr_api.g_varchar2

696: ,p_segment24 in varchar2 default hr_api.g_varchar2
697: ,p_segment25 in varchar2 default hr_api.g_varchar2
698: ,p_segment26 in varchar2 default hr_api.g_varchar2
699: ,p_segment27 in varchar2 default hr_api.g_varchar2
700: ,p_segment28 in varchar2 default hr_api.g_varchar2
701: ,p_segment29 in varchar2 default hr_api.g_varchar2
702: ,p_segment30 in varchar2 default hr_api.g_varchar2
703: ,p_concat_segments in varchar2 default hr_api.g_varchar2
704: ,p_analysis_criteria_id in out nocopy number

Line 701: ,p_segment29 in varchar2 default hr_api.g_varchar2

697: ,p_segment25 in varchar2 default hr_api.g_varchar2
698: ,p_segment26 in varchar2 default hr_api.g_varchar2
699: ,p_segment27 in varchar2 default hr_api.g_varchar2
700: ,p_segment28 in varchar2 default hr_api.g_varchar2
701: ,p_segment29 in varchar2 default hr_api.g_varchar2
702: ,p_segment30 in varchar2 default hr_api.g_varchar2
703: ,p_concat_segments in varchar2 default hr_api.g_varchar2
704: ,p_analysis_criteria_id in out nocopy number
705: ) is

Line 702: ,p_segment30 in varchar2 default hr_api.g_varchar2

698: ,p_segment26 in varchar2 default hr_api.g_varchar2
699: ,p_segment27 in varchar2 default hr_api.g_varchar2
700: ,p_segment28 in varchar2 default hr_api.g_varchar2
701: ,p_segment29 in varchar2 default hr_api.g_varchar2
702: ,p_segment30 in varchar2 default hr_api.g_varchar2
703: ,p_concat_segments in varchar2 default hr_api.g_varchar2
704: ,p_analysis_criteria_id in out nocopy number
705: ) is
706: --

Line 703: ,p_concat_segments in varchar2 default hr_api.g_varchar2

699: ,p_segment27 in varchar2 default hr_api.g_varchar2
700: ,p_segment28 in varchar2 default hr_api.g_varchar2
701: ,p_segment29 in varchar2 default hr_api.g_varchar2
702: ,p_segment30 in varchar2 default hr_api.g_varchar2
703: ,p_concat_segments in varchar2 default hr_api.g_varchar2
704: ,p_analysis_criteria_id in out nocopy number
705: ) is
706: --
707: --

Line 921: when hr_api.cannot_find_prog_unit then

917: ,p_segment30 => l_segment30
918: ,p_concat_segments => p_concat_segments
919: );
920: exception
921: when hr_api.cannot_find_prog_unit then
922: hr_api.cannot_find_prog_unit_error
923: (p_module_name => 'UPDATE_SIT'
924: ,p_hook_type => 'BP'
925: );

Line 922: hr_api.cannot_find_prog_unit_error

918: ,p_concat_segments => p_concat_segments
919: );
920: exception
921: when hr_api.cannot_find_prog_unit then
922: hr_api.cannot_find_prog_unit_error
923: (p_module_name => 'UPDATE_SIT'
924: ,p_hook_type => 'BP'
925: );
926: --

Line 1129: when hr_api.cannot_find_prog_unit then

1125: ,p_concat_segments => p_concat_segments
1126: ,p_analysis_criteria_id => l_analysis_criteria_id
1127: );
1128: exception
1129: when hr_api.cannot_find_prog_unit then
1130: hr_api.cannot_find_prog_unit_error
1131: (p_module_name => 'UPDATE_SIT'
1132: ,p_hook_type => 'AP'
1133: );

Line 1130: hr_api.cannot_find_prog_unit_error

1126: ,p_analysis_criteria_id => l_analysis_criteria_id
1127: );
1128: exception
1129: when hr_api.cannot_find_prog_unit then
1130: hr_api.cannot_find_prog_unit_error
1131: (p_module_name => 'UPDATE_SIT'
1132: ,p_hook_type => 'AP'
1133: );
1134: --

Line 1140: raise hr_api.validate_enabled;

1136: --
1137: end;
1138: --
1139: if p_validate then
1140: raise hr_api.validate_enabled;
1141: end if;
1142: --
1143: hr_utility.set_location(l_proc, 95);
1144: --

Line 1159: when hr_api.validate_enabled then

1155: hr_utility.set_location(' Leaving:'||l_proc, 100);
1156: --
1157: exception
1158: --
1159: when hr_api.validate_enabled then
1160: --
1161: -- As the Validate_Enabled exception has been raised
1162: -- we must rollback to the savepoint
1163: --

Line 1262: when hr_api.cannot_find_prog_unit then

1258: (p_person_analysis_id => p_person_analysis_id
1259: ,p_pea_object_version_number => p_pea_object_version_number
1260: );
1261: exception
1262: when hr_api.cannot_find_prog_unit then
1263: hr_api.cannot_find_prog_unit_error
1264: (p_module_name => 'DELETE_SIT'
1265: ,p_hook_type => 'BP'
1266: );

Line 1263: hr_api.cannot_find_prog_unit_error

1259: ,p_pea_object_version_number => p_pea_object_version_number
1260: );
1261: exception
1262: when hr_api.cannot_find_prog_unit then
1263: hr_api.cannot_find_prog_unit_error
1264: (p_module_name => 'DELETE_SIT'
1265: ,p_hook_type => 'BP'
1266: );
1267: --

Line 1288: when hr_api.cannot_find_prog_unit then

1284: (p_person_analysis_id => p_person_analysis_id
1285: ,p_pea_object_version_number => p_pea_object_version_number
1286: );
1287: exception
1288: when hr_api.cannot_find_prog_unit then
1289: hr_api.cannot_find_prog_unit_error
1290: (p_module_name => 'DELETE_SIT'
1291: ,p_hook_type => 'AP'
1292: );

Line 1289: hr_api.cannot_find_prog_unit_error

1285: ,p_pea_object_version_number => p_pea_object_version_number
1286: );
1287: exception
1288: when hr_api.cannot_find_prog_unit then
1289: hr_api.cannot_find_prog_unit_error
1290: (p_module_name => 'DELETE_SIT'
1291: ,p_hook_type => 'AP'
1292: );
1293: --

Line 1302: raise hr_api.validate_enabled;

1298: --
1299: -- If in validate mode, raise the API validation exception
1300: --
1301: if p_validate then
1302: raise hr_api.validate_enabled;
1303: end if;
1304: --
1305: EXCEPTION
1306: WHEN hr_api.validate_enabled THEN

Line 1306: WHEN hr_api.validate_enabled THEN

1302: raise hr_api.validate_enabled;
1303: end if;
1304: --
1305: EXCEPTION
1306: WHEN hr_api.validate_enabled THEN
1307: --
1308: -- As the Validate_Enabled exception has been raised
1309: -- we must rollback to the savepoint
1310: --