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.IRC_IAV_BUS dependencies on IRC_AGENCY_VACANCIES

Line 419: in irc_agency_vacancies.agency_id%type

415: --
416: -- ----------------------------------------------------------------------------
417: Procedure chk_agency_id
418: (p_agency_id
419: in irc_agency_vacancies.agency_id%type
420: ) is
421: --
422: l_proc varchar2(72) := g_package||'chk_agency_id';
423: l_agency_id irc_agency_vacancies.agency_id%type;

Line 423: l_agency_id irc_agency_vacancies.agency_id%type;

419: in irc_agency_vacancies.agency_id%type
420: ) is
421: --
422: l_proc varchar2(72) := g_package||'chk_agency_id';
423: l_agency_id irc_agency_vacancies.agency_id%type;
424: cursor csr_agency_id is
425: select 1
426: from po_vendors
427: where vendor_id = p_agency_id

Line 454: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.AGENCY_ID'

450: --
451: exception
452: when app_exception.application_exception then
453: if hr_multi_message.exception_add
454: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.AGENCY_ID'
455: ) then
456: --
457: hr_utility.set_location(' Leaving:'||l_proc,60);
458: --

Line 494: (p_vacancy_id in irc_agency_vacancies.vacancy_id%type

490: --
491: -- {End Of Comments}
492: -- ----------------------------------------------------------------------------
493: Procedure chk_vacancy_id
494: (p_vacancy_id in irc_agency_vacancies.vacancy_id%type
495: ,p_start_date in irc_agency_vacancies.start_date%type
496: ) IS
497: --
498: l_proc varchar2(72) := g_package || 'chk_vacancy_id';

Line 495: ,p_start_date in irc_agency_vacancies.start_date%type

491: -- {End Of Comments}
492: -- ----------------------------------------------------------------------------
493: Procedure chk_vacancy_id
494: (p_vacancy_id in irc_agency_vacancies.vacancy_id%type
495: ,p_start_date in irc_agency_vacancies.start_date%type
496: ) IS
497: --
498: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
499: l_vacancy_id irc_agency_vacancies.vacancy_id%type;

Line 499: l_vacancy_id irc_agency_vacancies.vacancy_id%type;

495: ,p_start_date in irc_agency_vacancies.start_date%type
496: ) IS
497: --
498: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
499: l_vacancy_id irc_agency_vacancies.vacancy_id%type;
500: --
501: --
502: -- Cursor to check that the vacancy_id exists in PER_ALL_VACANCIES
503: -- and is current at the p_start_date.

Line 538: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.VACANCY_ID'

534: --
535: exception
536: when app_exception.application_exception then
537: if hr_multi_message.exception_add
538: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.VACANCY_ID'
539: ) then
540: hr_utility.set_location(' Leaving:'||l_proc, 40);
541: raise;
542: end if;

Line 574: (p_start_date in irc_agency_vacancies.start_date%type

570: --
571: -- {End Of Comments}
572: -- ----------------------------------------------------------------------------
573: Procedure chk_end_date
574: (p_start_date in irc_agency_vacancies.start_date%type
575: ,p_end_date in irc_agency_vacancies.end_date%type
576: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type
577: ,p_object_version_number in irc_agency_vacancies.object_version_number%type
578: ) IS

Line 575: ,p_end_date in irc_agency_vacancies.end_date%type

571: -- {End Of Comments}
572: -- ----------------------------------------------------------------------------
573: Procedure chk_end_date
574: (p_start_date in irc_agency_vacancies.start_date%type
575: ,p_end_date in irc_agency_vacancies.end_date%type
576: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type
577: ,p_object_version_number in irc_agency_vacancies.object_version_number%type
578: ) IS
579: --

Line 576: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type

572: -- ----------------------------------------------------------------------------
573: Procedure chk_end_date
574: (p_start_date in irc_agency_vacancies.start_date%type
575: ,p_end_date in irc_agency_vacancies.end_date%type
576: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type
577: ,p_object_version_number in irc_agency_vacancies.object_version_number%type
578: ) IS
579: --
580: l_proc varchar2(72) := g_package || 'chk_end_date';

Line 577: ,p_object_version_number in irc_agency_vacancies.object_version_number%type

573: Procedure chk_end_date
574: (p_start_date in irc_agency_vacancies.start_date%type
575: ,p_end_date in irc_agency_vacancies.end_date%type
576: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type
577: ,p_object_version_number in irc_agency_vacancies.object_version_number%type
578: ) IS
579: --
580: l_proc varchar2(72) := g_package || 'chk_end_date';
581: l_api_updating boolean;

Line 614: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.START_DATE'

610: hr_utility.set_location(' Leaving:'||l_proc,45);
611: exception
612: when app_exception.application_exception then
613: if hr_multi_message.exception_add
614: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.START_DATE'
615: ,p_associated_column2 => 'IRC_AGENCY_VACANCIES.END_DATE'
616: ) then
617: hr_utility.set_location(' Leaving:'||l_proc, 50);
618: raise;

Line 615: ,p_associated_column2 => 'IRC_AGENCY_VACANCIES.END_DATE'

611: exception
612: when app_exception.application_exception then
613: if hr_multi_message.exception_add
614: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.START_DATE'
615: ,p_associated_column2 => 'IRC_AGENCY_VACANCIES.END_DATE'
616: ) then
617: hr_utility.set_location(' Leaving:'||l_proc, 50);
618: raise;
619: end if;

Line 653: (p_agency_id in irc_agency_vacancies.agency_id%type

649: --
650: -- {End Of Comments}
651: -- ----------------------------------------------------------------------------
652: Procedure chk_agency_vac_comb_id
653: (p_agency_id in irc_agency_vacancies.agency_id%type
654: ,p_vacancy_id in irc_agency_vacancies.vacancy_id%type
655: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type
656: ,p_object_version_number in irc_agency_vacancies.object_version_number%type
657: ) IS

Line 654: ,p_vacancy_id in irc_agency_vacancies.vacancy_id%type

650: -- {End Of Comments}
651: -- ----------------------------------------------------------------------------
652: Procedure chk_agency_vac_comb_id
653: (p_agency_id in irc_agency_vacancies.agency_id%type
654: ,p_vacancy_id in irc_agency_vacancies.vacancy_id%type
655: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type
656: ,p_object_version_number in irc_agency_vacancies.object_version_number%type
657: ) IS
658: --

Line 655: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type

651: -- ----------------------------------------------------------------------------
652: Procedure chk_agency_vac_comb_id
653: (p_agency_id in irc_agency_vacancies.agency_id%type
654: ,p_vacancy_id in irc_agency_vacancies.vacancy_id%type
655: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type
656: ,p_object_version_number in irc_agency_vacancies.object_version_number%type
657: ) IS
658: --
659: l_proc varchar2(72) := g_package || 'chk_agency_vacancy_combination_id';

Line 656: ,p_object_version_number in irc_agency_vacancies.object_version_number%type

652: Procedure chk_agency_vac_comb_id
653: (p_agency_id in irc_agency_vacancies.agency_id%type
654: ,p_vacancy_id in irc_agency_vacancies.vacancy_id%type
655: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type
656: ,p_object_version_number in irc_agency_vacancies.object_version_number%type
657: ) IS
658: --
659: l_proc varchar2(72) := g_package || 'chk_agency_vacancy_combination_id';
660: l_agency_vacancy_id irc_agency_vacancies.agency_vacancy_id%type;

Line 660: l_agency_vacancy_id irc_agency_vacancies.agency_vacancy_id%type;

656: ,p_object_version_number in irc_agency_vacancies.object_version_number%type
657: ) IS
658: --
659: l_proc varchar2(72) := g_package || 'chk_agency_vacancy_combination_id';
660: l_agency_vacancy_id irc_agency_vacancies.agency_vacancy_id%type;
661: --
662: --
663: --
664: --

Line 668: from irc_agency_vacancies

664: --
665: --
666: cursor csr_agency_vacancy_id is
667: select agency_vacancy_id
668: from irc_agency_vacancies
669: where agency_id = p_agency_id
670: and vacancy_id = p_vacancy_id;
671: --
672: cursor csr_agency_vacancy_upd is

Line 674: from irc_agency_vacancies

670: and vacancy_id = p_vacancy_id;
671: --
672: cursor csr_agency_vacancy_upd is
673: select agency_vacancy_id
674: from irc_agency_vacancies
675: where agency_id = p_agency_id
676: and vacancy_id = p_vacancy_id
677: and agency_vacancy_id <> p_agency_vacancy_id;
678: --

Line 732: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.AGENCY_ID'

728: --
729: exception
730: when app_exception.application_exception then
731: if hr_multi_message.exception_add
732: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.AGENCY_ID'
733: ,p_associated_column2 => 'IRC_AGENCY_VACANCIES.VACANCY_ID'
734: ) then
735: hr_utility.set_location(' Leaving:'||l_proc, 60);
736: raise;

Line 733: ,p_associated_column2 => 'IRC_AGENCY_VACANCIES.VACANCY_ID'

729: exception
730: when app_exception.application_exception then
731: if hr_multi_message.exception_add
732: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.AGENCY_ID'
733: ,p_associated_column2 => 'IRC_AGENCY_VACANCIES.VACANCY_ID'
734: ) then
735: hr_utility.set_location(' Leaving:'||l_proc, 60);
736: raise;
737: end if;

Line 771: irc_agency_vacancies.manage_applicants_allowed%type

767: -- {End Of Comments}
768: -- ----------------------------------------------------------------------------
769: Procedure chk_manage_appl_allowed
770: (p_manage_applicants_allowed in
771: irc_agency_vacancies.manage_applicants_allowed%type
772: ,p_start_date in irc_agency_vacancies.start_date%type
773: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type
774: ,p_object_version_number in irc_agency_vacancies.object_version_number%type
775: ) IS

Line 772: ,p_start_date in irc_agency_vacancies.start_date%type

768: -- ----------------------------------------------------------------------------
769: Procedure chk_manage_appl_allowed
770: (p_manage_applicants_allowed in
771: irc_agency_vacancies.manage_applicants_allowed%type
772: ,p_start_date in irc_agency_vacancies.start_date%type
773: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type
774: ,p_object_version_number in irc_agency_vacancies.object_version_number%type
775: ) IS
776: --

Line 773: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type

769: Procedure chk_manage_appl_allowed
770: (p_manage_applicants_allowed in
771: irc_agency_vacancies.manage_applicants_allowed%type
772: ,p_start_date in irc_agency_vacancies.start_date%type
773: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type
774: ,p_object_version_number in irc_agency_vacancies.object_version_number%type
775: ) IS
776: --
777: l_proc varchar2(72) := g_package || 'chk_manage_appl_allowed';

Line 774: ,p_object_version_number in irc_agency_vacancies.object_version_number%type

770: (p_manage_applicants_allowed in
771: irc_agency_vacancies.manage_applicants_allowed%type
772: ,p_start_date in irc_agency_vacancies.start_date%type
773: ,p_agency_vacancy_id in irc_agency_vacancies.agency_vacancy_id%type
774: ,p_object_version_number in irc_agency_vacancies.object_version_number%type
775: ) IS
776: --
777: l_proc varchar2(72) := g_package || 'chk_manage_appl_allowed';
778: l_var boolean;

Line 815: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.MANAGE_APPLICANTS_ALLOWED'

811: hr_utility.set_location(' Leaving:'||l_proc,45);
812: exception
813: when app_exception.application_exception then
814: if hr_multi_message.exception_add
815: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.MANAGE_APPLICANTS_ALLOWED'
816: ) then
817: hr_utility.set_location(' Leaving:'||l_proc, 50);
818: raise;
819: end if;