APPS.IRC_AGENCY_VACANCIES_SWI dependencies on IRC_AGENCY_VACANCIES

Line 1: Package Body irc_agency_vacancies_swi As

1: Package Body irc_agency_vacancies_swi As
2: /* $Header: iriavswi.pkb 120.1.12010000.2 2008/08/05 10:48:12 ubhat ship $ */
3: --
4: -- Package variables
5: --

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

2: /* $Header: iriavswi.pkb 120.1.12010000.2 2008/08/05 10:48:12 ubhat ship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'irc_agency_vacancies_swi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_agency_vacancy >------------------------|
10: -- ----------------------------------------------------------------------------

Line 91: irc_agency_vacancies_api.create_agency_vacancy

87: );
88: --
89: -- Call API
90: --
91: irc_agency_vacancies_api.create_agency_vacancy
92: (p_validate => l_validate
93: ,p_agency_id => p_agency_id
94: ,p_vacancy_id => p_vacancy_id
95: ,p_start_date => p_start_date

Line 266: irc_agency_vacancies_api.update_agency_vacancy

262: --
263: --
264: -- Call API
265: --
266: irc_agency_vacancies_api.update_agency_vacancy
267: (p_validate => l_validate
268: ,p_agency_vacancy_id => p_agency_vacancy_id
269: ,p_agency_id => p_agency_id
270: ,p_vacancy_id => p_vacancy_id

Line 375: l_object_version_number irc_agency_vacancies.object_version_number%TYPE;

371: -- Variables for IN/OUT parameters
372: --
373: -- Other variables
374: l_proc varchar2(72) := g_package ||'delete_agency_vacancy';
375: l_object_version_number irc_agency_vacancies.object_version_number%TYPE;
376:
377: cursor get_object_version_number(p_agency_vacancy_id irc_agency_vacancies.agency_vacancy_id%TYPE) is
378: select object_version_number
379: from irc_agency_vacancies

Line 377: cursor get_object_version_number(p_agency_vacancy_id irc_agency_vacancies.agency_vacancy_id%TYPE) is

373: -- Other variables
374: l_proc varchar2(72) := g_package ||'delete_agency_vacancy';
375: l_object_version_number irc_agency_vacancies.object_version_number%TYPE;
376:
377: cursor get_object_version_number(p_agency_vacancy_id irc_agency_vacancies.agency_vacancy_id%TYPE) is
378: select object_version_number
379: from irc_agency_vacancies
380: where agency_vacancy_id = p_agency_vacancy_id;
381: Begin

Line 379: from irc_agency_vacancies

375: l_object_version_number irc_agency_vacancies.object_version_number%TYPE;
376:
377: cursor get_object_version_number(p_agency_vacancy_id irc_agency_vacancies.agency_vacancy_id%TYPE) is
378: select object_version_number
379: from irc_agency_vacancies
380: where agency_vacancy_id = p_agency_vacancy_id;
381: Begin
382: hr_utility.set_location(' Entering:' || l_proc,10);
383: --

Line 413: irc_agency_vacancies_api.delete_agency_vacancy

409: fetch get_object_version_number into l_object_version_number;
410: close get_object_version_number;
411: end if;
412: --
413: irc_agency_vacancies_api.delete_agency_vacancy
414: (p_validate => l_validate
415: ,p_agency_vacancy_id => p_agency_vacancy_id
416: ,p_object_version_number => l_object_version_number
417: );

Line 630: end irc_agency_vacancies_swi;

626:
627: --
628: end process_api;
629: --
630: end irc_agency_vacancies_swi;