DBA Data[Home] [Help]

APPS.IRC_VACANCY_CONSIDERATIONS_API dependencies on IRC_VACANCY_CONSIDERATIONS

Line 1: Package Body IRC_VACANCY_CONSIDERATIONS_API as

1: Package Body IRC_VACANCY_CONSIDERATIONS_API as
2: /* $Header: irivcapi.pkb 120.2.12010000.2 2008/11/04 13:53:29 avarri ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' IRC_VACANCY_CONSIDERATIONS_API.';

2: /* $Header: irivcapi.pkb 120.2.12010000.2 2008/11/04 13:53:29 avarri ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' IRC_VACANCY_CONSIDERATIONS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |----------------------< GET_EMAIL_MESSAGE_BODY >--------------------------|
10: -- ----------------------------------------------------------------------------

Line 425: IRC_VACANCY_CONSIDERATIONS_BK1.CREATE_VACANCY_CONSIDERATION_B

421: --
422: -- Call Before Process User Hook
423: --
424: begin
425: IRC_VACANCY_CONSIDERATIONS_BK1.CREATE_VACANCY_CONSIDERATION_B
426: (
427: p_person_id => p_person_id
428: ,p_vacancy_id => p_vacancy_id
429: ,p_consideration_status => p_consideration_status

Line 463: IRC_VACANCY_CONSIDERATIONS_BK1.CREATE_VACANCY_CONSIDERATION_A

459: --
460: -- Call After Process User Hook
461: --
462: begin
463: IRC_VACANCY_CONSIDERATIONS_BK1.CREATE_VACANCY_CONSIDERATION_A
464: (p_vacancy_consideration_id => l_vacancy_consideration_id
465: ,p_person_id => p_person_id
466: ,p_vacancy_id => p_vacancy_id
467: ,p_consideration_status => p_consideration_status

Line 544: from irc_vacancy_considerations

540: l_person_id number;
541: l_vacancy_id number;
542: cursor csr_person_vac is
543: Select person_id, vacancy_id
544: from irc_vacancy_considerations
545: where vacancy_consideration_id = p_vacancy_consideration_id;
546: --
547: begin
548: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 561: IRC_VACANCY_CONSIDERATIONS_BK2.UPDATE_VACANCY_CONSIDERATION_B

557: --
558: -- Call Before Process User Hook
559: --
560: begin
561: IRC_VACANCY_CONSIDERATIONS_BK2.UPDATE_VACANCY_CONSIDERATION_B
562: (
563: p_vacancy_consideration_id => p_vacancy_consideration_id
564: ,p_party_id => p_party_id
565: ,p_consideration_status => p_consideration_status

Line 602: IRC_VACANCY_CONSIDERATIONS_BK2.UPDATE_VACANCY_CONSIDERATION_A

598: );
599: -- Call After Process User Hook
600: --
601: begin
602: IRC_VACANCY_CONSIDERATIONS_BK2.UPDATE_VACANCY_CONSIDERATION_A
603: (p_vacancy_consideration_id => p_vacancy_consideration_id
604: ,p_party_id => p_party_id
605: ,p_consideration_status => p_consideration_status
606: ,p_object_version_number => l_object_version_number

Line 679: IRC_VACANCY_CONSIDERATIONS_BK3.DELETE_VACANCY_CONSIDERATION_B

675: --
676: -- Call Before Process User Hook
677: --
678: begin
679: IRC_VACANCY_CONSIDERATIONS_BK3.DELETE_VACANCY_CONSIDERATION_B
680: (p_vacancy_consideration_id => p_vacancy_consideration_id
681: ,p_object_version_number => p_object_version_number
682: );
683: exception

Line 701: IRC_VACANCY_CONSIDERATIONS_BK3.DELETE_VACANCY_CONSIDERATION_A

697: --
698: -- Call After Process User Hook
699: --
700: begin
701: IRC_VACANCY_CONSIDERATIONS_BK3.DELETE_VACANCY_CONSIDERATION_A
702: (
703: p_vacancy_consideration_id => p_vacancy_consideration_id
704: ,p_object_version_number => p_object_version_number
705: );

Line 746: end IRC_VACANCY_CONSIDERATIONS_API;

742: hr_utility.set_location(' Leaving:'||l_proc, 90);
743: raise;
744: end DELETE_VACANCY_CONSIDERATION;
745: --
746: end IRC_VACANCY_CONSIDERATIONS_API;