1: Package Body IRC_VACANCY_CONSIDERATIONS_API as
2: /* $Header: irivcapi.pkb 120.7.12020000.3 2012/08/21 11:37:45 sbaswa ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: irivcapi.pkb 120.7.12020000.3 2012/08/21 11:37:45 sbaswa ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' IRC_VACANCY_CONSIDERATIONS_API.';
7: --
8: -- -------------------------------------------------------------------------
9: -- |----------------------< Remove_Html_Tags >-----------------------------|
10: -- -------------------------------------------------------------------------
495: --
496: -- Call Before Process User Hook
497: --
498: begin
499: IRC_VACANCY_CONSIDERATIONS_BK1.CREATE_VACANCY_CONSIDERATION_B
500: (
501: p_person_id => p_person_id
502: ,p_vacancy_id => p_vacancy_id
503: ,p_consideration_status => p_consideration_status
533: --
534: -- Call After Process User Hook
535: --
536: begin
537: IRC_VACANCY_CONSIDERATIONS_BK1.CREATE_VACANCY_CONSIDERATION_A
538: (p_vacancy_consideration_id => l_vacancy_consideration_id
539: ,p_person_id => p_person_id
540: ,p_vacancy_id => p_vacancy_id
541: ,p_consideration_status => p_consideration_status
614: l_person_id number;
615: l_vacancy_id number;
616: cursor csr_person_vac is
617: Select person_id, vacancy_id
618: from irc_vacancy_considerations
619: where vacancy_consideration_id = p_vacancy_consideration_id;
620: --
621: begin
622: hr_utility.set_location('Entering:'|| l_proc, 10);
631: --
632: -- Call Before Process User Hook
633: --
634: begin
635: IRC_VACANCY_CONSIDERATIONS_BK2.UPDATE_VACANCY_CONSIDERATION_B
636: (
637: p_vacancy_consideration_id => p_vacancy_consideration_id
638: ,p_party_id => p_party_id
639: ,p_consideration_status => p_consideration_status
672: );
673: -- Call After Process User Hook
674: --
675: begin
676: IRC_VACANCY_CONSIDERATIONS_BK2.UPDATE_VACANCY_CONSIDERATION_A
677: (p_vacancy_consideration_id => p_vacancy_consideration_id
678: ,p_party_id => p_party_id
679: ,p_consideration_status => p_consideration_status
680: ,p_object_version_number => l_object_version_number
749: --
750: -- Call Before Process User Hook
751: --
752: begin
753: IRC_VACANCY_CONSIDERATIONS_BK3.DELETE_VACANCY_CONSIDERATION_B
754: (p_vacancy_consideration_id => p_vacancy_consideration_id
755: ,p_object_version_number => p_object_version_number
756: );
757: exception
771: --
772: -- Call After Process User Hook
773: --
774: begin
775: IRC_VACANCY_CONSIDERATIONS_BK3.DELETE_VACANCY_CONSIDERATION_A
776: (
777: p_vacancy_consideration_id => p_vacancy_consideration_id
778: ,p_object_version_number => p_object_version_number
779: );
816: hr_utility.set_location(' Leaving:'||l_proc, 90);
817: raise;
818: end DELETE_VACANCY_CONSIDERATION;
819: --
820: end IRC_VACANCY_CONSIDERATIONS_API;