APPS.IRC_AGENCY_VACANCIES_API dependencies on IRC_AGENCY_VACANCIES

Line 1: Package Body IRC_AGENCY_VACANCIES_API as

1: Package Body IRC_AGENCY_VACANCIES_API as
2: /* $Header: iriavapi.pkb 120.0 2005/07/26 15:04:40 mbocutt noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := 'IRC_AGENCY_VACANCIES_API';

2: /* $Header: iriavapi.pkb 120.0 2005/07/26 15:04:40 mbocutt noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'IRC_AGENCY_VACANCIES_API';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< CREATE_AGENCY_VACANCY >- -------------------|
10: -- ----------------------------------------------------------------------------

Line 57: l_agency_vacancy_id irc_agency_vacancies.agency_vacancy_id%type;

53: ) is
54: --
55: -- Declare cursors and local variables
56: --
57: l_agency_vacancy_id irc_agency_vacancies.agency_vacancy_id%type;
58: l_object_version_number irc_agency_vacancies.object_version_number%type;
59: l_start_date irc_agency_vacancies.start_date%type;
60: l_end_date irc_agency_vacancies.end_date%type;
61: l_proc varchar2(72) := g_package||'.CREATE_AGENCY_VACANCY';

Line 58: l_object_version_number irc_agency_vacancies.object_version_number%type;

54: --
55: -- Declare cursors and local variables
56: --
57: l_agency_vacancy_id irc_agency_vacancies.agency_vacancy_id%type;
58: l_object_version_number irc_agency_vacancies.object_version_number%type;
59: l_start_date irc_agency_vacancies.start_date%type;
60: l_end_date irc_agency_vacancies.end_date%type;
61: l_proc varchar2(72) := g_package||'.CREATE_AGENCY_VACANCY';
62: --

Line 59: l_start_date irc_agency_vacancies.start_date%type;

55: -- Declare cursors and local variables
56: --
57: l_agency_vacancy_id irc_agency_vacancies.agency_vacancy_id%type;
58: l_object_version_number irc_agency_vacancies.object_version_number%type;
59: l_start_date irc_agency_vacancies.start_date%type;
60: l_end_date irc_agency_vacancies.end_date%type;
61: l_proc varchar2(72) := g_package||'.CREATE_AGENCY_VACANCY';
62: --
63: begin

Line 60: l_end_date irc_agency_vacancies.end_date%type;

56: --
57: l_agency_vacancy_id irc_agency_vacancies.agency_vacancy_id%type;
58: l_object_version_number irc_agency_vacancies.object_version_number%type;
59: l_start_date irc_agency_vacancies.start_date%type;
60: l_end_date irc_agency_vacancies.end_date%type;
61: l_proc varchar2(72) := g_package||'.CREATE_AGENCY_VACANCY';
62: --
63: begin
64: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 78: IRC_AGENCY_VACANCIES_BK1.CREATE_AGENCY_VACANCY_b

74: --
75: -- Call Before Process User Hook
76: --
77: begin
78: IRC_AGENCY_VACANCIES_BK1.CREATE_AGENCY_VACANCY_b
79: (p_agency_vacancy_id => p_agency_vacancy_id
80: ,p_agency_id => p_agency_id
81: ,p_vacancy_id => p_vacancy_id
82: ,p_start_date => l_start_date

Line 174: IRC_AGENCY_VACANCIES_BK1.CREATE_AGENCY_VACANCY_a

170: --
171: -- Call After Process User Hook
172: --
173: begin
174: IRC_AGENCY_VACANCIES_BK1.CREATE_AGENCY_VACANCY_a
175: (p_agency_vacancy_id => l_agency_vacancy_id
176: ,p_agency_id => p_agency_id
177: ,p_vacancy_id => p_vacancy_id
178: ,p_start_date => l_start_date

Line 314: l_object_version_number irc_agency_vacancies.object_version_number%type

310: ) is
311: --
312: -- Declare cursors and local variables
313: --
314: l_object_version_number irc_agency_vacancies.object_version_number%type
315: := p_object_version_number;
316: l_start_date irc_agency_vacancies.start_date%type;
317: l_end_date irc_agency_vacancies.end_date%type;
318: l_proc varchar2(72) := g_package||'UPDATE_AGENCY_VACANCY';

Line 316: l_start_date irc_agency_vacancies.start_date%type;

312: -- Declare cursors and local variables
313: --
314: l_object_version_number irc_agency_vacancies.object_version_number%type
315: := p_object_version_number;
316: l_start_date irc_agency_vacancies.start_date%type;
317: l_end_date irc_agency_vacancies.end_date%type;
318: l_proc varchar2(72) := g_package||'UPDATE_AGENCY_VACANCY';
319: --
320: begin

Line 317: l_end_date irc_agency_vacancies.end_date%type;

313: --
314: l_object_version_number irc_agency_vacancies.object_version_number%type
315: := p_object_version_number;
316: l_start_date irc_agency_vacancies.start_date%type;
317: l_end_date irc_agency_vacancies.end_date%type;
318: l_proc varchar2(72) := g_package||'UPDATE_AGENCY_VACANCY';
319: --
320: begin
321: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 335: IRC_AGENCY_VACANCIES_BK2.UPDATE_AGENCY_VACANCY_b

331: --
332: -- Call Before Process User Hook
333: --
334: begin
335: IRC_AGENCY_VACANCIES_BK2.UPDATE_AGENCY_VACANCY_b
336: (p_agency_vacancy_id => p_agency_vacancy_id
337: ,p_agency_id => p_agency_id
338: ,p_vacancy_id => p_vacancy_id
339: ,p_start_date => l_start_date

Line 436: IRC_AGENCY_VACANCIES_BK2.UPDATE_AGENCY_VACANCY_a

432: --
433: -- Call After Process User Hook
434: --
435: begin
436: IRC_AGENCY_VACANCIES_BK2.UPDATE_AGENCY_VACANCY_a
437: (p_agency_vacancy_id => p_agency_vacancy_id
438: ,p_agency_id => p_agency_id
439: ,p_vacancy_id => p_vacancy_id
440: ,p_start_date => l_start_date

Line 548: IRC_AGENCY_VACANCIES_BK3.DELETE_AGENCY_VACANCY_b

544: --
545: -- Call Before Process User Hook
546: --
547: begin
548: IRC_AGENCY_VACANCIES_BK3.DELETE_AGENCY_VACANCY_b
549: (p_agency_vacancy_id => p_agency_vacancy_id
550: ,p_object_version_number => p_object_version_number
551: );
552: exception

Line 571: IRC_AGENCY_VACANCIES_BK3.DELETE_AGENCY_VACANCY_a

567: --
568: -- Call After Process User Hook
569: --
570: begin
571: IRC_AGENCY_VACANCIES_BK3.DELETE_AGENCY_VACANCY_a
572: (p_agency_vacancy_id => p_agency_vacancy_id
573: ,p_object_version_number => p_object_version_number
574: );
575: exception

Line 609: end IRC_AGENCY_VACANCIES_API;

605: hr_utility.set_location(' Leaving:'||l_proc, 90);
606: raise;
607: end delete_agency_vacancy;
608: --
609: end IRC_AGENCY_VACANCIES_API;