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.PER_VAC_BUS dependencies on PER_ALL_VACANCIES

Line 30: , per_all_vacancies vac

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , per_all_vacancies vac
31: where vac.vacancy_id = p_vacancy_id
32: and pbg.business_group_id = vac.business_group_id;
33: --
34: -- Declare local variables

Line 92: , per_all_vacancies vac

88: --
89: cursor csr_leg_code is
90: select pbg.legislation_code
91: from per_business_groups pbg
92: , per_all_vacancies vac
93: where vac.vacancy_id = p_vacancy_id
94: and pbg.business_group_id = vac.business_group_id;
95: --
96: -- Declare local variables

Line 388: (p_name in per_all_vacancies.name%TYPE

384: --
385: -- {End Of Comments}
386: -- ----------------------------------------------------------------------------
387: Procedure chk_name
388: (p_name in per_all_vacancies.name%TYPE
389: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
390: ) IS
391: --
392: l_proc varchar2(72) := g_package || 'chk_name';

Line 389: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE

385: -- {End Of Comments}
386: -- ----------------------------------------------------------------------------
387: Procedure chk_name
388: (p_name in per_all_vacancies.name%TYPE
389: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
390: ) IS
391: --
392: l_proc varchar2(72) := g_package || 'chk_name';
393: l_name varchar2(1);

Line 396: from per_all_vacancies

392: l_proc varchar2(72) := g_package || 'chk_name';
393: l_name varchar2(1);
394: cursor csr_name is
395: select null
396: from per_all_vacancies
397: where name = p_name
398: and business_group_id = p_business_group_id;
399: --
400: Begin

Line 429: (p_associated_column1 => 'PER_ALL_VACANCIES.NAME'

425: hr_utility.set_location(' Leaving:'||l_proc,30);
426: exception
427: when app_exception.application_exception then
428: if hr_multi_message.exception_add
429: (p_associated_column1 => 'PER_ALL_VACANCIES.NAME'
430: ) then
431: hr_utility.set_location(' Leaving:'|| l_proc, 40);
432: raise;
433: end if;

Line 463: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

459: --
460: -- {End Of Comments}
461: -- ----------------------------------------------------------------------------
462: Procedure chk_vacancy_dates
463: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
464: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
465: ,p_date_from in per_all_vacancies.date_from%TYPE
466: ,p_date_to in per_all_vacancies.date_to%TYPE
467: ) IS

Line 464: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

460: -- {End Of Comments}
461: -- ----------------------------------------------------------------------------
462: Procedure chk_vacancy_dates
463: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
464: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
465: ,p_date_from in per_all_vacancies.date_from%TYPE
466: ,p_date_to in per_all_vacancies.date_to%TYPE
467: ) IS
468: --

Line 465: ,p_date_from in per_all_vacancies.date_from%TYPE

461: -- ----------------------------------------------------------------------------
462: Procedure chk_vacancy_dates
463: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
464: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
465: ,p_date_from in per_all_vacancies.date_from%TYPE
466: ,p_date_to in per_all_vacancies.date_to%TYPE
467: ) IS
468: --
469: l_proc varchar2(72) := g_package || 'chk_vacancy_dates';

Line 466: ,p_date_to in per_all_vacancies.date_to%TYPE

462: Procedure chk_vacancy_dates
463: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
464: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
465: ,p_date_from in per_all_vacancies.date_from%TYPE
466: ,p_date_to in per_all_vacancies.date_to%TYPE
467: ) IS
468: --
469: l_proc varchar2(72) := g_package || 'chk_vacancy_dates';
470: l_api_updating boolean;

Line 493: (p_associated_column1 => 'PER_ALL_VACANCIES.DATE_FROM'

489: if (p_date_from is null)
490: then
491: fnd_message.set_name('PER','PER_289443_VAC_DATE_FROM_MND');
492: hr_multi_message.add
493: (p_associated_column1 => 'PER_ALL_VACANCIES.DATE_FROM'
494: );
495: hr_multi_message.end_validation_set();
496: end if;
497: hr_utility.set_location(l_proc,40);

Line 503: (p_associated_column1 => 'PER_ALL_VACANCIES.DATE_FROM'

499: if (p_date_from > nvl(p_date_to,hr_api.g_eot))
500: then
501: fnd_message.set_name('PER','IRC_ALL_DATE_START_END');
502: hr_multi_message.add
503: (p_associated_column1 => 'PER_ALL_VACANCIES.DATE_FROM'
504: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_TO'
505: );
506: end if;
507: end if;

Line 504: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_TO'

500: then
501: fnd_message.set_name('PER','IRC_ALL_DATE_START_END');
502: hr_multi_message.add
503: (p_associated_column1 => 'PER_ALL_VACANCIES.DATE_FROM'
504: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_TO'
505: );
506: end if;
507: end if;
508: --

Line 538: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

534: --
535: -- {End Of Comments}
536: -- ----------------------------------------------------------------------------
537: Procedure chk_status
538: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
539: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
540: ,p_status in per_all_vacancies.status%TYPE
541: ,p_effective_date in date
542: ) IS

Line 539: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

535: -- {End Of Comments}
536: -- ----------------------------------------------------------------------------
537: Procedure chk_status
538: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
539: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
540: ,p_status in per_all_vacancies.status%TYPE
541: ,p_effective_date in date
542: ) IS
543: --

Line 540: ,p_status in per_all_vacancies.status%TYPE

536: -- ----------------------------------------------------------------------------
537: Procedure chk_status
538: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
539: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
540: ,p_status in per_all_vacancies.status%TYPE
541: ,p_effective_date in date
542: ) IS
543: --
544: l_proc varchar2(72) := g_package || 'chk_status';

Line 581: (p_associated_column1 => 'PER_ALL_VACANCIES.STATUS'

577: hr_utility.set_location(' Leaving:'||l_proc,40);
578: exception
579: when app_exception.application_exception then
580: if hr_multi_message.exception_add
581: (p_associated_column1 => 'PER_ALL_VACANCIES.STATUS'
582: ) then
583: hr_utility.set_location(' Leaving:'|| l_proc, 50);
584: raise;
585: end if;

Line 617: p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

613: -- {End Of Comments}
614: -- ----------------------------------------------------------------------------
615: Procedure chk_budget_measurement_type
616: (
617: p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
618: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
619: ,p_budget_measurement_type in per_all_vacancies.budget_measurement_type%TYPE
620: ,p_effective_date in date
621: ) IS

Line 618: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

614: -- ----------------------------------------------------------------------------
615: Procedure chk_budget_measurement_type
616: (
617: p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
618: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
619: ,p_budget_measurement_type in per_all_vacancies.budget_measurement_type%TYPE
620: ,p_effective_date in date
621: ) IS
622: --

Line 619: ,p_budget_measurement_type in per_all_vacancies.budget_measurement_type%TYPE

615: Procedure chk_budget_measurement_type
616: (
617: p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
618: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
619: ,p_budget_measurement_type in per_all_vacancies.budget_measurement_type%TYPE
620: ,p_effective_date in date
621: ) IS
622: --
623: l_proc varchar2(72) := g_package || 'chk_budget_measurement_type';

Line 660: (p_associated_column1 => 'PER_ALL_VACANCIES.BUDGET_MEASUREMENT_TYPE'

656: hr_utility.set_location(' Leaving:'||l_proc,50);
657: exception
658: when app_exception.application_exception then
659: if hr_multi_message.exception_add
660: (p_associated_column1 => 'PER_ALL_VACANCIES.BUDGET_MEASUREMENT_TYPE'
661: ) then
662: hr_utility.set_location(' Leaving:'|| l_proc, 60);
663: raise;
664: end if;

Line 693: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

689: --
690: -- {End Of Comments}
691: -- ----------------------------------------------------------------------------
692: Procedure chk_security_method
693: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
694: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
695: ,p_security_method in per_all_vacancies.security_method%TYPE
696: ,p_effective_date in date
697: ) IS

Line 694: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

690: -- {End Of Comments}
691: -- ----------------------------------------------------------------------------
692: Procedure chk_security_method
693: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
694: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
695: ,p_security_method in per_all_vacancies.security_method%TYPE
696: ,p_effective_date in date
697: ) IS
698: --

Line 695: ,p_security_method in per_all_vacancies.security_method%TYPE

691: -- ----------------------------------------------------------------------------
692: Procedure chk_security_method
693: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
694: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
695: ,p_security_method in per_all_vacancies.security_method%TYPE
696: ,p_effective_date in date
697: ) IS
698: --
699: l_proc varchar2(72) := g_package || 'chk_security_method';

Line 736: (p_associated_column1 => 'PER_ALL_VACANCIES.SECURITY_METHOD'

732: hr_utility.set_location(' Leaving:'||l_proc,60);
733: exception
734: when app_exception.application_exception then
735: if hr_multi_message.exception_add
736: (p_associated_column1 => 'PER_ALL_VACANCIES.SECURITY_METHOD'
737: ) then
738: hr_utility.set_location(' Leaving:'|| l_proc, 70);
739: raise;
740: end if;

Line 768: (p_requisition_id in per_all_vacancies.requisition_id%TYPE

764: --
765: -- {End Of Comments}
766: -- ----------------------------------------------------------------------------
767: Procedure chk_requisition_id
768: (p_requisition_id in per_all_vacancies.requisition_id%TYPE
769: ,p_date_from in per_all_vacancies.date_from%TYPE
770: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
771: ) IS
772: --

Line 769: ,p_date_from in per_all_vacancies.date_from%TYPE

765: -- {End Of Comments}
766: -- ----------------------------------------------------------------------------
767: Procedure chk_requisition_id
768: (p_requisition_id in per_all_vacancies.requisition_id%TYPE
769: ,p_date_from in per_all_vacancies.date_from%TYPE
770: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
771: ) IS
772: --
773: l_proc varchar2(72) := g_package || 'chk_requisition_id';

Line 770: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE

766: -- ----------------------------------------------------------------------------
767: Procedure chk_requisition_id
768: (p_requisition_id in per_all_vacancies.requisition_id%TYPE
769: ,p_date_from in per_all_vacancies.date_from%TYPE
770: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
771: ) IS
772: --
773: l_proc varchar2(72) := g_package || 'chk_requisition_id';
774: l_date_from per_all_vacancies.date_from%TYPE;

Line 774: l_date_from per_all_vacancies.date_from%TYPE;

770: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
771: ) IS
772: --
773: l_proc varchar2(72) := g_package || 'chk_requisition_id';
774: l_date_from per_all_vacancies.date_from%TYPE;
775: l_date_to per_all_vacancies.date_to%TYPE;
776: cursor csr_requisition is
777: select date_from,date_to
778: from per_requisitions

Line 775: l_date_to per_all_vacancies.date_to%TYPE;

771: ) IS
772: --
773: l_proc varchar2(72) := g_package || 'chk_requisition_id';
774: l_date_from per_all_vacancies.date_from%TYPE;
775: l_date_to per_all_vacancies.date_to%TYPE;
776: cursor csr_requisition is
777: select date_from,date_to
778: from per_requisitions
779: where requisition_id = p_requisition_id

Line 791: (p_associated_column1 => 'PER_ALL_VACANCIES.REQUISITION_ID'

787: if (csr_requisition%NOTFOUND) then
788: close csr_requisition;
789: fnd_message.set_name('PER','PER_289447_VAC_INV_REQ_ID');
790: hr_multi_message.add
791: (p_associated_column1 => 'PER_ALL_VACANCIES.REQUISITION_ID'
792: );
793: else
794: close csr_requisition;
795: hr_utility.set_location(l_proc,20);

Line 799: (p_associated_column1 => 'PER_ALL_VACANCIES.REQUISITION_ID'

795: hr_utility.set_location(l_proc,20);
796: if(p_date_from not between l_date_from and nvl(l_date_to,hr_api.g_eot)) then
797: fnd_message.set_name('PER','PER_289448_VAC_REQ_ID_INV_DATE');
798: hr_multi_message.add
799: (p_associated_column1 => 'PER_ALL_VACANCIES.REQUISITION_ID'
800: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
801: ,p_associated_column3 => 'PER_ALL_VACANCIES.DATE_TO'
802: );
803: end if;

Line 800: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'

796: if(p_date_from not between l_date_from and nvl(l_date_to,hr_api.g_eot)) then
797: fnd_message.set_name('PER','PER_289448_VAC_REQ_ID_INV_DATE');
798: hr_multi_message.add
799: (p_associated_column1 => 'PER_ALL_VACANCIES.REQUISITION_ID'
800: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
801: ,p_associated_column3 => 'PER_ALL_VACANCIES.DATE_TO'
802: );
803: end if;
804: end if;

Line 801: ,p_associated_column3 => 'PER_ALL_VACANCIES.DATE_TO'

797: fnd_message.set_name('PER','PER_289448_VAC_REQ_ID_INV_DATE');
798: hr_multi_message.add
799: (p_associated_column1 => 'PER_ALL_VACANCIES.REQUISITION_ID'
800: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
801: ,p_associated_column3 => 'PER_ALL_VACANCIES.DATE_TO'
802: );
803: end if;
804: end if;
805: --

Line 814: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

810: -- |------------------------< chk_position_id >------------------------------|
811: -- ---------------------------------------------------------------------------
812: --
813: procedure chk_position_id
814: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
815: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
816: ,p_position_id in per_all_vacancies.position_id%TYPE
817: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
818: ,p_effective_date in date

Line 815: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

811: -- ---------------------------------------------------------------------------
812: --
813: procedure chk_position_id
814: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
815: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
816: ,p_position_id in per_all_vacancies.position_id%TYPE
817: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
818: ,p_effective_date in date
819: )

Line 816: ,p_position_id in per_all_vacancies.position_id%TYPE

812: --
813: procedure chk_position_id
814: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
815: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
816: ,p_position_id in per_all_vacancies.position_id%TYPE
817: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
818: ,p_effective_date in date
819: )
820: is

Line 817: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE

813: procedure chk_position_id
814: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
815: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
816: ,p_position_id in per_all_vacancies.position_id%TYPE
817: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
818: ,p_effective_date in date
819: )
820: is
821: --

Line 825: l_position_id per_all_vacancies.position_id%TYPE;

821: --
822: l_proc varchar2(72) := g_package||'chk_position_id';
823: l_exists varchar2(1);
824: l_api_updating boolean;
825: l_position_id per_all_vacancies.position_id%TYPE;
826: l_pos_bus_group_id per_all_vacancies.business_group_id%TYPE;
827: --
828: cursor csr_valid_pos is
829: select hp.business_group_id

Line 826: l_pos_bus_group_id per_all_vacancies.business_group_id%TYPE;

822: l_proc varchar2(72) := g_package||'chk_position_id';
823: l_exists varchar2(1);
824: l_api_updating boolean;
825: l_position_id per_all_vacancies.position_id%TYPE;
826: l_pos_bus_group_id per_all_vacancies.business_group_id%TYPE;
827: --
828: cursor csr_valid_pos is
829: select hp.business_group_id
830: from hr_all_positions_f hp

Line 898: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'

894: hr_utility.set_location('Leaving'||l_proc, 80);
895: exception
896: when app_exception.application_exception then
897: if hr_multi_message.exception_add
898: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
899: ) then
900: hr_utility.set_location(' Leaving:'|| l_proc, 40);
901: raise;
902: end if;

Line 910: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

906: -------------------< chk_position_id_grade_id >-------------------------------
907: ------------------------------------------------------------------------------
908: --
909: procedure chk_position_id_grade_id
910: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
911: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
912: ,p_position_id in per_all_vacancies.position_id%TYPE
913: ,p_grade_id in per_all_vacancies.grade_id%TYPE
914: ,p_effective_date in date

Line 911: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

907: ------------------------------------------------------------------------------
908: --
909: procedure chk_position_id_grade_id
910: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
911: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
912: ,p_position_id in per_all_vacancies.position_id%TYPE
913: ,p_grade_id in per_all_vacancies.grade_id%TYPE
914: ,p_effective_date in date
915: ,p_inv_pos_grade_warning out nocopy boolean

Line 912: ,p_position_id in per_all_vacancies.position_id%TYPE

908: --
909: procedure chk_position_id_grade_id
910: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
911: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
912: ,p_position_id in per_all_vacancies.position_id%TYPE
913: ,p_grade_id in per_all_vacancies.grade_id%TYPE
914: ,p_effective_date in date
915: ,p_inv_pos_grade_warning out nocopy boolean
916: )

Line 913: ,p_grade_id in per_all_vacancies.grade_id%TYPE

909: procedure chk_position_id_grade_id
910: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
911: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
912: ,p_position_id in per_all_vacancies.position_id%TYPE
913: ,p_grade_id in per_all_vacancies.grade_id%TYPE
914: ,p_effective_date in date
915: ,p_inv_pos_grade_warning out nocopy boolean
916: )
917: as

Line 936: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'

932: begin
933: --
934: hr_utility.set_location('Entering:'|| l_proc, 1);
935: if hr_multi_message.no_exclusive_error
936: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
937: ,p_check_column2 => 'PER_ALL_VACANCIES.GRADE_ID'
938: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'
939: ) then
940: --

Line 937: ,p_check_column2 => 'PER_ALL_VACANCIES.GRADE_ID'

933: --
934: hr_utility.set_location('Entering:'|| l_proc, 1);
935: if hr_multi_message.no_exclusive_error
936: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
937: ,p_check_column2 => 'PER_ALL_VACANCIES.GRADE_ID'
938: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'
939: ) then
940: --
941: -- Only proceed with validation if :

Line 938: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'

934: hr_utility.set_location('Entering:'|| l_proc, 1);
935: if hr_multi_message.no_exclusive_error
936: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
937: ,p_check_column2 => 'PER_ALL_VACANCIES.GRADE_ID'
938: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'
939: ) then
940: --
941: -- Only proceed with validation if :
942: -- a) The current g_old_rec is current and

Line 990: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

986: -- ------------------------< chk_position_id_org_id >--------------------------
987: -- ----------------------------------------------------------------------------
988: --
989: procedure chk_position_id_org_id
990: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
991: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
992: ,p_position_id in per_all_vacancies.position_id%TYPE
993: ,p_organization_id in per_all_vacancies.organization_id%TYPE
994: ,p_effective_date in date

Line 991: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

987: -- ----------------------------------------------------------------------------
988: --
989: procedure chk_position_id_org_id
990: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
991: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
992: ,p_position_id in per_all_vacancies.position_id%TYPE
993: ,p_organization_id in per_all_vacancies.organization_id%TYPE
994: ,p_effective_date in date
995: )

Line 992: ,p_position_id in per_all_vacancies.position_id%TYPE

988: --
989: procedure chk_position_id_org_id
990: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
991: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
992: ,p_position_id in per_all_vacancies.position_id%TYPE
993: ,p_organization_id in per_all_vacancies.organization_id%TYPE
994: ,p_effective_date in date
995: )
996: as

Line 993: ,p_organization_id in per_all_vacancies.organization_id%TYPE

989: procedure chk_position_id_org_id
990: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
991: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
992: ,p_position_id in per_all_vacancies.position_id%TYPE
993: ,p_organization_id in per_all_vacancies.organization_id%TYPE
994: ,p_effective_date in date
995: )
996: as
997: l_proc varchar2(72) := g_package||'chk_position_id_org_id';

Line 1016: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'

1012: begin
1013: --
1014: hr_utility.set_location('Entering:'|| l_proc, 1);
1015: if hr_multi_message.no_exclusive_error
1016: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1017: ,p_check_column2 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1018: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'
1019: ) then
1020: --

Line 1017: ,p_check_column2 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'

1013: --
1014: hr_utility.set_location('Entering:'|| l_proc, 1);
1015: if hr_multi_message.no_exclusive_error
1016: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1017: ,p_check_column2 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1018: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'
1019: ) then
1020: --
1021: -- Only proceed with validation if :

Line 1018: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'

1014: hr_utility.set_location('Entering:'|| l_proc, 1);
1015: if hr_multi_message.no_exclusive_error
1016: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1017: ,p_check_column2 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1018: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'
1019: ) then
1020: --
1021: -- Only proceed with validation if :
1022: -- a) The current g_old_rec is current and

Line 1066: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'

1062: hr_utility.set_location('Leaving'||l_proc, 4);
1063: exception
1064: when app_exception.application_exception then
1065: if hr_multi_message.exception_add
1066: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1067: ,p_associated_column2 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1068: ) then
1069: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1070: raise;

Line 1067: ,p_associated_column2 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'

1063: exception
1064: when app_exception.application_exception then
1065: if hr_multi_message.exception_add
1066: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1067: ,p_associated_column2 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1068: ) then
1069: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1070: raise;
1071: end if;

Line 1080: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

1076: -------------------------< chk_position_id_job_id >---------------------------
1077: ------------------------------------------------------------------------------
1078: --
1079: procedure chk_position_id_job_id
1080: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1081: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1082: ,p_position_id in per_all_vacancies.position_id%TYPE
1083: ,p_job_id in per_all_vacancies.job_id%TYPE
1084: ,p_effective_date in date

Line 1081: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

1077: ------------------------------------------------------------------------------
1078: --
1079: procedure chk_position_id_job_id
1080: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1081: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1082: ,p_position_id in per_all_vacancies.position_id%TYPE
1083: ,p_job_id in per_all_vacancies.job_id%TYPE
1084: ,p_effective_date in date
1085: )

Line 1082: ,p_position_id in per_all_vacancies.position_id%TYPE

1078: --
1079: procedure chk_position_id_job_id
1080: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1081: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1082: ,p_position_id in per_all_vacancies.position_id%TYPE
1083: ,p_job_id in per_all_vacancies.job_id%TYPE
1084: ,p_effective_date in date
1085: )
1086: as

Line 1083: ,p_job_id in per_all_vacancies.job_id%TYPE

1079: procedure chk_position_id_job_id
1080: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1081: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1082: ,p_position_id in per_all_vacancies.position_id%TYPE
1083: ,p_job_id in per_all_vacancies.job_id%TYPE
1084: ,p_effective_date in date
1085: )
1086: as
1087: l_proc varchar2(72) := g_package||'chk_position_id_job_id';

Line 1104: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'

1100: --
1101: begin
1102: hr_utility.set_location('Entering:'|| l_proc, 10);
1103: if hr_multi_message.no_exclusive_error
1104: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1105: ,p_check_column2 => 'PER_ALL_VACANCIES.JOB_ID'
1106: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'
1107: ) then
1108: --

Line 1105: ,p_check_column2 => 'PER_ALL_VACANCIES.JOB_ID'

1101: begin
1102: hr_utility.set_location('Entering:'|| l_proc, 10);
1103: if hr_multi_message.no_exclusive_error
1104: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1105: ,p_check_column2 => 'PER_ALL_VACANCIES.JOB_ID'
1106: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'
1107: ) then
1108: --
1109: -- Only proceed with validation if :

Line 1106: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'

1102: hr_utility.set_location('Entering:'|| l_proc, 10);
1103: if hr_multi_message.no_exclusive_error
1104: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1105: ,p_check_column2 => 'PER_ALL_VACANCIES.JOB_ID'
1106: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'
1107: ) then
1108: --
1109: -- Only proceed with validation if :
1110: -- a) The current g_old_rec is current and

Line 1162: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'

1158: hr_utility.set_location('Leaving'||l_proc, 3);
1159: exception
1160: when app_exception.application_exception then
1161: if hr_multi_message.exception_add
1162: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1163: ,p_associated_column2 => 'PER_ALL_VACANCIES.JOB_ID'
1164: ) then
1165: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1166: raise;

Line 1163: ,p_associated_column2 => 'PER_ALL_VACANCIES.JOB_ID'

1159: exception
1160: when app_exception.application_exception then
1161: if hr_multi_message.exception_add
1162: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1163: ,p_associated_column2 => 'PER_ALL_VACANCIES.JOB_ID'
1164: ) then
1165: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1166: raise;
1167: end if;

Line 1198: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

1194: --
1195: -- {End Of Comments}
1196: -- ----------------------------------------------------------------------------
1197: Procedure chk_job_id
1198: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1199: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1200: ,p_job_id in per_all_vacancies.job_id%TYPE
1201: ,p_effective_date in date
1202: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE

Line 1199: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

1195: -- {End Of Comments}
1196: -- ----------------------------------------------------------------------------
1197: Procedure chk_job_id
1198: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1199: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1200: ,p_job_id in per_all_vacancies.job_id%TYPE
1201: ,p_effective_date in date
1202: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1203: )

Line 1200: ,p_job_id in per_all_vacancies.job_id%TYPE

1196: -- ----------------------------------------------------------------------------
1197: Procedure chk_job_id
1198: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1199: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1200: ,p_job_id in per_all_vacancies.job_id%TYPE
1201: ,p_effective_date in date
1202: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1203: )
1204: IS

Line 1202: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE

1198: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1199: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1200: ,p_job_id in per_all_vacancies.job_id%TYPE
1201: ,p_effective_date in date
1202: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1203: )
1204: IS
1205: --
1206: l_proc varchar2(72) := g_package || 'chk_job_id';

Line 1208: l_date_from per_all_vacancies.date_from%TYPE;

1204: IS
1205: --
1206: l_proc varchar2(72) := g_package || 'chk_job_id';
1207: l_api_updating boolean;
1208: l_date_from per_all_vacancies.date_from%TYPE;
1209: l_date_to per_all_vacancies.date_to%TYPE;
1210: cursor csr_job is
1211: select date_from,date_to
1212: from per_jobs

Line 1209: l_date_to per_all_vacancies.date_to%TYPE;

1205: --
1206: l_proc varchar2(72) := g_package || 'chk_job_id';
1207: l_api_updating boolean;
1208: l_date_from per_all_vacancies.date_from%TYPE;
1209: l_date_to per_all_vacancies.date_to%TYPE;
1210: cursor csr_job is
1211: select date_from,date_to
1212: from per_jobs
1213: where job_id = p_job_id

Line 1240: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'

1236: if (csr_job%notfound) then
1237: close csr_job;
1238: fnd_message.set_name('PER','PER_289451_VAC_INV_JOB_ID');
1239: hr_multi_message.add
1240: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1241: );
1242: else
1243: close csr_job;
1244: hr_utility.set_location(l_proc,40);

Line 1249: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'

1245: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1246: then
1247: fnd_message.set_name('PER','PER_289452_VAC_JOB_ID_INV_DATE');
1248: hr_multi_message.add
1249: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1250: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
1251: );
1252: end if;
1253: end if;

Line 1250: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'

1246: then
1247: fnd_message.set_name('PER','PER_289452_VAC_JOB_ID_INV_DATE');
1248: hr_multi_message.add
1249: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1250: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
1251: );
1252: end if;
1253: end if;
1254: end if;

Line 1265: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

1261: -- |----------------------< chk_job_id_grade_id >----------------------------|
1262: -- ---------------------------------------------------------------------------
1263: --
1264: procedure chk_job_id_grade_id
1265: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1266: ,p_job_id in per_all_vacancies.job_id%TYPE
1267: ,p_grade_id in per_all_vacancies.grade_id%TYPE
1268: ,p_effective_date in date
1269: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1266: ,p_job_id in per_all_vacancies.job_id%TYPE

1262: -- ---------------------------------------------------------------------------
1263: --
1264: procedure chk_job_id_grade_id
1265: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1266: ,p_job_id in per_all_vacancies.job_id%TYPE
1267: ,p_grade_id in per_all_vacancies.grade_id%TYPE
1268: ,p_effective_date in date
1269: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1270: ,p_inv_job_grade_warning out nocopy boolean

Line 1267: ,p_grade_id in per_all_vacancies.grade_id%TYPE

1263: --
1264: procedure chk_job_id_grade_id
1265: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1266: ,p_job_id in per_all_vacancies.job_id%TYPE
1267: ,p_grade_id in per_all_vacancies.grade_id%TYPE
1268: ,p_effective_date in date
1269: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1270: ,p_inv_job_grade_warning out nocopy boolean
1271: )

Line 1291: (p_check_column1 => 'PER_ALL_VACANCIES.JOB_ID'

1287: --
1288: begin
1289: hr_utility.set_location('Entering:'|| l_proc, 10);
1290: if hr_multi_message.no_exclusive_error
1291: (p_check_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1292: ,p_check_column2 => 'PER_ALL_VACANCIES.GRADE_ID'
1293: ) then
1294: --
1295: -- Check if the vacancy is being updated.

Line 1292: ,p_check_column2 => 'PER_ALL_VACANCIES.GRADE_ID'

1288: begin
1289: hr_utility.set_location('Entering:'|| l_proc, 10);
1290: if hr_multi_message.no_exclusive_error
1291: (p_check_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1292: ,p_check_column2 => 'PER_ALL_VACANCIES.GRADE_ID'
1293: ) then
1294: --
1295: -- Check if the vacancy is being updated.
1296: --

Line 1343: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'

1339: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1340: exception
1341: when app_exception.application_exception then
1342: if hr_multi_message.exception_add
1343: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1344: ,p_associated_column2 => 'PER_ALL_VACANCIES.GRADE_ID'
1345: ) then
1346: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1347: raise;

Line 1344: ,p_associated_column2 => 'PER_ALL_VACANCIES.GRADE_ID'

1340: exception
1341: when app_exception.application_exception then
1342: if hr_multi_message.exception_add
1343: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1344: ,p_associated_column2 => 'PER_ALL_VACANCIES.GRADE_ID'
1345: ) then
1346: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1347: raise;
1348: end if;

Line 1378: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

1374: --
1375: -- {End Of Comments}
1376: -- ----------------------------------------------------------------------------
1377: Procedure chk_grade_id
1378: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1379: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1380: ,p_grade_id in per_all_vacancies.grade_id%TYPE
1381: ,p_effective_date in date
1382: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE

Line 1379: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

1375: -- {End Of Comments}
1376: -- ----------------------------------------------------------------------------
1377: Procedure chk_grade_id
1378: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1379: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1380: ,p_grade_id in per_all_vacancies.grade_id%TYPE
1381: ,p_effective_date in date
1382: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1383: )

Line 1380: ,p_grade_id in per_all_vacancies.grade_id%TYPE

1376: -- ----------------------------------------------------------------------------
1377: Procedure chk_grade_id
1378: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1379: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1380: ,p_grade_id in per_all_vacancies.grade_id%TYPE
1381: ,p_effective_date in date
1382: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1383: )
1384: IS

Line 1382: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE

1378: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1379: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1380: ,p_grade_id in per_all_vacancies.grade_id%TYPE
1381: ,p_effective_date in date
1382: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1383: )
1384: IS
1385: --
1386: l_proc varchar2(72) := g_package || 'chk_grade_id';

Line 1388: l_date_from per_all_vacancies.date_from%TYPE;

1384: IS
1385: --
1386: l_proc varchar2(72) := g_package || 'chk_grade_id';
1387: l_api_updating boolean;
1388: l_date_from per_all_vacancies.date_from%TYPE;
1389: l_date_to per_all_vacancies.date_to%TYPE;
1390: cursor csr_grade is
1391: select date_from,date_to
1392: from per_grades

Line 1389: l_date_to per_all_vacancies.date_to%TYPE;

1385: --
1386: l_proc varchar2(72) := g_package || 'chk_grade_id';
1387: l_api_updating boolean;
1388: l_date_from per_all_vacancies.date_from%TYPE;
1389: l_date_to per_all_vacancies.date_to%TYPE;
1390: cursor csr_grade is
1391: select date_from,date_to
1392: from per_grades
1393: where grade_id = p_grade_id

Line 1422: (p_associated_column1 => 'PER_ALL_VACANCIES.GRADE_ID'

1418: then
1419: close csr_grade;
1420: fnd_message.set_name('PER','PER_289453_VAC_INV_GRD_ID');
1421: hr_multi_message.add
1422: (p_associated_column1 => 'PER_ALL_VACANCIES.GRADE_ID'
1423: );
1424: else
1425: close csr_grade;
1426: hr_utility.set_location(l_proc,50);

Line 1431: (p_associated_column1 => 'PER_ALL_VACANCIES.GRADE_ID'

1427: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1428: then
1429: fnd_message.set_name('PER','PER_289454_VAC_GRD_ID_INV_DATE');
1430: hr_multi_message.add
1431: (p_associated_column1 => 'PER_ALL_VACANCIES.GRADE_ID'
1432: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
1433: );
1434: end if;
1435: end if;

Line 1432: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'

1428: then
1429: fnd_message.set_name('PER','PER_289454_VAC_GRD_ID_INV_DATE');
1430: hr_multi_message.add
1431: (p_associated_column1 => 'PER_ALL_VACANCIES.GRADE_ID'
1432: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
1433: );
1434: end if;
1435: end if;
1436: end if;

Line 1468: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

1464: --
1465: -- {End Of Comments}
1466: -- ----------------------------------------------------------------------------
1467: Procedure chk_organization_id
1468: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1469: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1470: ,p_organization_id in per_all_vacancies.organization_id%TYPE
1471: ,p_effective_date in date
1472: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE

Line 1469: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

1465: -- {End Of Comments}
1466: -- ----------------------------------------------------------------------------
1467: Procedure chk_organization_id
1468: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1469: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1470: ,p_organization_id in per_all_vacancies.organization_id%TYPE
1471: ,p_effective_date in date
1472: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1473: )

Line 1470: ,p_organization_id in per_all_vacancies.organization_id%TYPE

1466: -- ----------------------------------------------------------------------------
1467: Procedure chk_organization_id
1468: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1469: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1470: ,p_organization_id in per_all_vacancies.organization_id%TYPE
1471: ,p_effective_date in date
1472: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1473: )
1474: IS

Line 1472: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE

1468: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1469: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1470: ,p_organization_id in per_all_vacancies.organization_id%TYPE
1471: ,p_effective_date in date
1472: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1473: )
1474: IS
1475: --
1476: l_proc varchar2(72) := g_package || 'chk_organization_id';

Line 1478: l_date_from per_all_vacancies.date_from%TYPE;

1474: IS
1475: --
1476: l_proc varchar2(72) := g_package || 'chk_organization_id';
1477: l_api_updating boolean;
1478: l_date_from per_all_vacancies.date_from%TYPE;
1479: l_date_to per_all_vacancies.date_to%TYPE;
1480: cursor csr_organization is
1481: select date_from,date_to
1482: from hr_all_organization_units

Line 1479: l_date_to per_all_vacancies.date_to%TYPE;

1475: --
1476: l_proc varchar2(72) := g_package || 'chk_organization_id';
1477: l_api_updating boolean;
1478: l_date_from per_all_vacancies.date_from%TYPE;
1479: l_date_to per_all_vacancies.date_to%TYPE;
1480: cursor csr_organization is
1481: select date_from,date_to
1482: from hr_all_organization_units
1483: where organization_id = p_organization_id

Line 1511: (p_associated_column1 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'

1507: then
1508: close csr_organization;
1509: fnd_message.set_name('PER','PER_289455_VAC_INV_ORG_ID');
1510: hr_multi_message.add
1511: (p_associated_column1 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1512: );
1513: else
1514: close csr_organization;
1515: hr_utility.set_location(l_proc,40);

Line 1520: (p_associated_column1 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'

1516: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1517: then
1518: fnd_message.set_name('PER','PER_289456_VAC_ORG_ID_INV_DATE');
1519: hr_multi_message.add
1520: (p_associated_column1 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1521: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
1522: );
1523: end if;
1524: end if;

Line 1521: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'

1517: then
1518: fnd_message.set_name('PER','PER_289456_VAC_ORG_ID_INV_DATE');
1519: hr_multi_message.add
1520: (p_associated_column1 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1521: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
1522: );
1523: end if;
1524: end if;
1525: end if;

Line 1555: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

1551: --
1552: -- {End Of Comments}
1553: -- ----------------------------------------------------------------------------
1554: Procedure chk_people_group_id
1555: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1556: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1557: ,p_people_group_id in per_all_vacancies.people_group_id%TYPE
1558: ,p_effective_date in date
1559: )

Line 1556: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

1552: -- {End Of Comments}
1553: -- ----------------------------------------------------------------------------
1554: Procedure chk_people_group_id
1555: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1556: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1557: ,p_people_group_id in per_all_vacancies.people_group_id%TYPE
1558: ,p_effective_date in date
1559: )
1560: IS

Line 1557: ,p_people_group_id in per_all_vacancies.people_group_id%TYPE

1553: -- ----------------------------------------------------------------------------
1554: Procedure chk_people_group_id
1555: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1556: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1557: ,p_people_group_id in per_all_vacancies.people_group_id%TYPE
1558: ,p_effective_date in date
1559: )
1560: IS
1561: --

Line 1597: (p_associated_column1 => 'PER_ALL_VACANCIES.PEOPLE_GROUP_ID'

1593: then
1594: close csr_peoplegrp;
1595: fnd_message.set_name('PER','PER_289457_VAC_INV_GRP_ID');
1596: hr_multi_message.add
1597: (p_associated_column1 => 'PER_ALL_VACANCIES.PEOPLE_GROUP_ID'
1598: );
1599: else
1600: close csr_peoplegrp;
1601: hr_utility.set_location(l_proc,30);

Line 1606: (p_associated_column1 => 'PER_ALL_VACANCIES.PEOPLE_GROUP_ID'

1602: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1603: then
1604: fnd_message.set_name('PER','PER_289458_VAC_GRP_ID_INV_DATE');
1605: hr_multi_message.add
1606: (p_associated_column1 => 'PER_ALL_VACANCIES.PEOPLE_GROUP_ID'
1607: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
1608: );
1609: end if;
1610: end if;

Line 1607: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'

1603: then
1604: fnd_message.set_name('PER','PER_289458_VAC_GRP_ID_INV_DATE');
1605: hr_multi_message.add
1606: (p_associated_column1 => 'PER_ALL_VACANCIES.PEOPLE_GROUP_ID'
1607: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
1608: );
1609: end if;
1610: end if;
1611: end if;

Line 1640: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

1636: --
1637: -- {End Of Comments}
1638: -- ----------------------------------------------------------------------------
1639: Procedure chk_location_id
1640: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1641: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1642: ,p_location_id in per_all_vacancies.location_id%TYPE
1643: )
1644: IS

Line 1641: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

1637: -- {End Of Comments}
1638: -- ----------------------------------------------------------------------------
1639: Procedure chk_location_id
1640: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1641: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1642: ,p_location_id in per_all_vacancies.location_id%TYPE
1643: )
1644: IS
1645: --

Line 1642: ,p_location_id in per_all_vacancies.location_id%TYPE

1638: -- ----------------------------------------------------------------------------
1639: Procedure chk_location_id
1640: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1641: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1642: ,p_location_id in per_all_vacancies.location_id%TYPE
1643: )
1644: IS
1645: --
1646: l_proc varchar2(72) := g_package || 'chk_location_id';

Line 1687: (p_associated_column1 => 'PER_ALL_VACANCIES.LOCATION_ID'

1683: hr_utility.set_location(' Leaving:'||l_proc,40);
1684: exception
1685: when app_exception.application_exception then
1686: if hr_multi_message.exception_add
1687: (p_associated_column1 => 'PER_ALL_VACANCIES.LOCATION_ID'
1688: ) then
1689: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1690: raise;
1691: end if;

Line 1721: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

1717: --
1718: -- {End Of Comments}
1719: -- ----------------------------------------------------------------------------
1720: Procedure chk_recruiter_id
1721: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1722: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1723: ,p_recruiter_id in per_all_vacancies.recruiter_id%TYPE
1724: ,p_effective_date in date
1725: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE

Line 1722: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

1718: -- {End Of Comments}
1719: -- ----------------------------------------------------------------------------
1720: Procedure chk_recruiter_id
1721: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1722: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1723: ,p_recruiter_id in per_all_vacancies.recruiter_id%TYPE
1724: ,p_effective_date in date
1725: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1726: )

Line 1723: ,p_recruiter_id in per_all_vacancies.recruiter_id%TYPE

1719: -- ----------------------------------------------------------------------------
1720: Procedure chk_recruiter_id
1721: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1722: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1723: ,p_recruiter_id in per_all_vacancies.recruiter_id%TYPE
1724: ,p_effective_date in date
1725: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1726: )
1727: IS

Line 1725: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE

1721: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1722: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1723: ,p_recruiter_id in per_all_vacancies.recruiter_id%TYPE
1724: ,p_effective_date in date
1725: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1726: )
1727: IS
1728: --
1729: l_proc varchar2(72) := g_package || 'chk_recruiter_id';

Line 1773: (p_associated_column1 => 'PER_ALL_VACANCIES.RECRUITER_ID'

1769: then
1770: close csr_recruiter1;
1771: fnd_message.set_name('PER','PER_289460_VAC_INV_REC_ID');
1772: hr_multi_message.add
1773: (p_associated_column1 => 'PER_ALL_VACANCIES.RECRUITER_ID'
1774: );
1775: else
1776: close csr_recruiter1;
1777: --

Line 1787: (p_associated_column1 => 'PER_ALL_VACANCIES.RECRUITER_ID'

1783: then
1784: close csr_recruiter2;
1785: fnd_message.set_name('PER','PER_289461_VAC_REC_ID_INV_DATE');
1786: hr_multi_message.add
1787: (p_associated_column1 => 'PER_ALL_VACANCIES.RECRUITER_ID'
1788: );
1789: else
1790: close csr_recruiter2;
1791: end if;

Line 1823: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

1819: --
1820: -- {End Of Comments}
1821: -- ----------------------------------------------------------------------------
1822: Procedure chk_number_of_openings
1823: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1824: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1825: ,p_num_open in per_all_vacancies.number_of_openings%TYPE
1826: )
1827: IS

Line 1824: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

1820: -- {End Of Comments}
1821: -- ----------------------------------------------------------------------------
1822: Procedure chk_number_of_openings
1823: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1824: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1825: ,p_num_open in per_all_vacancies.number_of_openings%TYPE
1826: )
1827: IS
1828: --

Line 1825: ,p_num_open in per_all_vacancies.number_of_openings%TYPE

1821: -- ----------------------------------------------------------------------------
1822: Procedure chk_number_of_openings
1823: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1824: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1825: ,p_num_open in per_all_vacancies.number_of_openings%TYPE
1826: )
1827: IS
1828: --
1829: l_proc varchar2(72) := g_package || 'chk_number_of_openings';

Line 1846: (p_associated_column1 => 'PER_ALL_VACANCIES.NUMBER_OF_OPENINGS'

1842: hr_utility.set_location(' Leaving:'||l_proc,40);
1843: exception
1844: when app_exception.application_exception then
1845: if hr_multi_message.exception_add
1846: (p_associated_column1 => 'PER_ALL_VACANCIES.NUMBER_OF_OPENINGS'
1847: ) then
1848: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1849: raise;
1850: end if;

Line 1879: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

1875: --
1876: -- {End Of Comments}
1877: -- ----------------------------------------------------------------------------
1878: Procedure chk_budget_measurement_value
1879: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1880: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1881: ,p_bud_mea_val in per_all_vacancies.budget_measurement_value%TYPE
1882: )
1883: IS

Line 1880: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

1876: -- {End Of Comments}
1877: -- ----------------------------------------------------------------------------
1878: Procedure chk_budget_measurement_value
1879: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1880: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1881: ,p_bud_mea_val in per_all_vacancies.budget_measurement_value%TYPE
1882: )
1883: IS
1884: --

Line 1881: ,p_bud_mea_val in per_all_vacancies.budget_measurement_value%TYPE

1877: -- ----------------------------------------------------------------------------
1878: Procedure chk_budget_measurement_value
1879: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1880: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1881: ,p_bud_mea_val in per_all_vacancies.budget_measurement_value%TYPE
1882: )
1883: IS
1884: --
1885: l_proc varchar2(72) := g_package || 'chk_budget_measurement_value';

Line 1903: (p_associated_column1 => 'PER_ALL_VACANCIES.BUDGET_MEASUREMENT_VALUE'

1899: hr_utility.set_location(' Leaving:'||l_proc,30);
1900: exception
1901: when app_exception.application_exception then
1902: if hr_multi_message.exception_add
1903: (p_associated_column1 => 'PER_ALL_VACANCIES.BUDGET_MEASUREMENT_VALUE'
1904: ) then
1905: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1906: raise;
1907: end if;

Line 1937: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

1933: --
1934: -- {End Of Comments}
1935: -- ----------------------------------------------------------------------------
1936: Procedure chk_manager_id
1937: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1938: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1939: ,p_manager_id in per_all_vacancies.manager_id%TYPE
1940: ,p_effective_date in date
1941: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE

Line 1938: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

1934: -- {End Of Comments}
1935: -- ----------------------------------------------------------------------------
1936: Procedure chk_manager_id
1937: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1938: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1939: ,p_manager_id in per_all_vacancies.manager_id%TYPE
1940: ,p_effective_date in date
1941: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1942: )

Line 1939: ,p_manager_id in per_all_vacancies.manager_id%TYPE

1935: -- ----------------------------------------------------------------------------
1936: Procedure chk_manager_id
1937: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1938: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1939: ,p_manager_id in per_all_vacancies.manager_id%TYPE
1940: ,p_effective_date in date
1941: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1942: )
1943: IS

Line 1941: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE

1937: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1938: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
1939: ,p_manager_id in per_all_vacancies.manager_id%TYPE
1940: ,p_effective_date in date
1941: ,p_business_group_id in per_all_vacancies.business_group_id%TYPE
1942: )
1943: IS
1944: --
1945: l_proc varchar2(72) := g_package || 'chk_manager_id';

Line 1988: (p_associated_column1 => 'PER_ALL_VACANCIES.MANAGER_ID'

1984: then
1985: close csr_manager1;
1986: fnd_message.set_name('PER','PER_289464_VAC_INV_MGR_ID');
1987: hr_multi_message.add
1988: (p_associated_column1 => 'PER_ALL_VACANCIES.MANAGER_ID'
1989: );
1990: else
1991: close csr_manager1;
1992: --

Line 2001: (p_associated_column1 => 'PER_ALL_VACANCIES.MANAGER_ID'

1997: then
1998: close csr_manager2;
1999: fnd_message.set_name('PER','PER_289465_VAC_MGR_ID_INV_DATE');
2000: hr_multi_message.add
2001: (p_associated_column1 => 'PER_ALL_VACANCIES.MANAGER_ID'
2002: );
2003: else
2004: close csr_manager2;
2005: end if;

Line 2038: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

2034: --
2035: -- {End Of Comments}
2036: -- ----------------------------------------------------------------------------
2037: Procedure chk_manager_assignment_id
2038: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
2039: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
2040: ,p_manager_id in per_all_vacancies.manager_id%TYPE
2041: ,p_effective_date in date
2042: )

Line 2039: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

2035: -- {End Of Comments}
2036: -- ----------------------------------------------------------------------------
2037: Procedure chk_manager_assignment_id
2038: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
2039: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
2040: ,p_manager_id in per_all_vacancies.manager_id%TYPE
2041: ,p_effective_date in date
2042: )
2043: IS

Line 2040: ,p_manager_id in per_all_vacancies.manager_id%TYPE

2036: -- ----------------------------------------------------------------------------
2037: Procedure chk_manager_assignment_id
2038: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
2039: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
2040: ,p_manager_id in per_all_vacancies.manager_id%TYPE
2041: ,p_effective_date in date
2042: )
2043: IS
2044: --

Line 2088: (p_associated_column1 => 'PER_ALL_VACANCIES.MANAGER_ID'

2084: then
2085: close csr_manager;
2086: fnd_message.set_name('PER','IRC_VAC_MGR_EQUAL_APPL');
2087: hr_multi_message.add
2088: (p_associated_column1 => 'PER_ALL_VACANCIES.MANAGER_ID'
2089: );
2090: else
2091: close csr_manager;
2092: end if;

Line 2125: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

2121: --
2122: -- {End Of Comments}
2123: -- ----------------------------------------------------------------------------
2124: Procedure chk_primary_posting_id
2125: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
2126: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
2127: ,p_primary_posting_id in per_all_vacancies. primary_posting_id %TYPE
2128: )
2129: IS

Line 2126: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

2122: -- {End Of Comments}
2123: -- ----------------------------------------------------------------------------
2124: Procedure chk_primary_posting_id
2125: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
2126: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
2127: ,p_primary_posting_id in per_all_vacancies. primary_posting_id %TYPE
2128: )
2129: IS
2130: --

Line 2127: ,p_primary_posting_id in per_all_vacancies. primary_posting_id %TYPE

2123: -- ----------------------------------------------------------------------------
2124: Procedure chk_primary_posting_id
2125: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
2126: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
2127: ,p_primary_posting_id in per_all_vacancies. primary_posting_id %TYPE
2128: )
2129: IS
2130: --
2131: l_proc varchar2(72) := g_package || 'chk_primary_posting_id ';

Line 2165: (p_associated_column1 => 'PER_ALL_VACANCIES.PRIMARY_POSTING_ID'

2161: then
2162: close csr_posting_contents;
2163: fnd_message.set_name('PER','PER_449565_VAC_INV_POSTING_ID');
2164: hr_multi_message.add
2165: (p_associated_column1 => 'PER_ALL_VACANCIES.PRIMARY_POSTING_ID'
2166: );
2167: else
2168: close csr_posting_contents;
2169: end if;

Line 2201: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE

2197: --
2198: -- {End Of Comments}
2199: -- ----------------------------------------------------------------------------
2200: Procedure chk_assessment_id
2201: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
2202: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
2203: ,p_assessment_id in per_all_vacancies.assessment_id%TYPE
2204: )
2205: IS

Line 2202: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE

2198: -- {End Of Comments}
2199: -- ----------------------------------------------------------------------------
2200: Procedure chk_assessment_id
2201: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
2202: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
2203: ,p_assessment_id in per_all_vacancies.assessment_id%TYPE
2204: )
2205: IS
2206: --

Line 2203: ,p_assessment_id in per_all_vacancies.assessment_id%TYPE

2199: -- ----------------------------------------------------------------------------
2200: Procedure chk_assessment_id
2201: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
2202: ,p_object_version_number in per_all_vacancies.object_version_number%TYPE
2203: ,p_assessment_id in per_all_vacancies.assessment_id%TYPE
2204: )
2205: IS
2206: --
2207: l_proc varchar2(72) := g_package || 'chk_assessment_id ';

Line 2242: (p_associated_column1 => 'PER_ALL_VACANCIES.ASSESSMENT_ID'

2238: then
2239: close csr_assessments;
2240: fnd_message.set_name('PER','PER_449566_VAC_INV_ASSESS_ID');
2241: hr_multi_message.add
2242: (p_associated_column1 => 'PER_ALL_VACANCIES.ASSESSMENT_ID'
2243: );
2244: else
2245: close csr_assessments;
2246: end if;