APPS.IRC_SAVED_SEARCH_CRITERIA_API dependencies on IRC_SAVED_SEARCH_CRITERIA

Line 1: Package Body irc_saved_search_criteria_api as

1: Package Body irc_saved_search_criteria_api as
2: /* $Header: irissapi.pkb 120.0.12000000.1 2007/03/23 11:17:59 vboggava noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: irissapi.pkb 120.0.12000000.1 2007/03/23 11:17:59 vboggava noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'irc_saved_search_criteria_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_search_criteria >-------------------|
10: -- ----------------------------------------------------------------------------

Line 28: l_saved_search_criteria_id irc_saved_search_criteria.saved_search_criteria_id%TYPE;

24: and bginfo.organization_id = vac.business_group_id
25: and vac.vacancy_id = p_vacancy_id;
26: --
27: -- out variables
28: l_saved_search_criteria_id irc_saved_search_criteria.saved_search_criteria_id%TYPE;
29: l_object_version_number irc_saved_search_criteria.object_version_number%TYPE;
30: l_proc varchar2(72) := g_package||'create_search_criteria';
31: l_cursor_ret_val varchar2(10) := 'N';
32:

Line 29: l_object_version_number irc_saved_search_criteria.object_version_number%TYPE;

25: and vac.vacancy_id = p_vacancy_id;
26: --
27: -- out variables
28: l_saved_search_criteria_id irc_saved_search_criteria.saved_search_criteria_id%TYPE;
29: l_object_version_number irc_saved_search_criteria.object_version_number%TYPE;
30: l_proc varchar2(72) := g_package||'create_search_criteria';
31: l_cursor_ret_val varchar2(10) := 'N';
32:
33: begin

Line 147: l_saved_search_criteria_id irc_saved_search_criteria.saved_search_criteria_id%TYPE;

143: --
144: -- Declare cursors and local variables
145: --
146: -- out variables
147: l_saved_search_criteria_id irc_saved_search_criteria.saved_search_criteria_id%TYPE;
148: l_object_version_number irc_saved_search_criteria.object_version_number%TYPE;
149: l_proc varchar2(72) := g_package||'update_search_criteria';
150:
151: begin

Line 148: l_object_version_number irc_saved_search_criteria.object_version_number%TYPE;

144: -- Declare cursors and local variables
145: --
146: -- out variables
147: l_saved_search_criteria_id irc_saved_search_criteria.saved_search_criteria_id%TYPE;
148: l_object_version_number irc_saved_search_criteria.object_version_number%TYPE;
149: l_proc varchar2(72) := g_package||'update_search_criteria';
150:
151: begin
152: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 172: irc_saved_search_criteria_bk2.update_search_criteria_b

168: --
169: -- Call Before Process User Hook
170: --
171: begin
172: irc_saved_search_criteria_bk2.update_search_criteria_b
173: (p_vacancy_id => p_vacancy_id
174: ,p_saved_search_criteria_id => l_saved_search_criteria_id
175: ,p_object_version_number => l_object_version_number
176: );

Line 202: irc_saved_search_criteria_bk2.update_search_criteria_a

198: --
199: -- Call After Process User Hook
200: --
201: begin
202: irc_saved_search_criteria_bk2.update_search_criteria_a
203: (p_vacancy_id => p_vacancy_id
204: ,p_saved_search_criteria_id => l_saved_search_criteria_id
205: ,p_object_version_number => l_object_version_number
206: );

Line 286: irc_saved_search_criteria_bk3.delete_search_criteria_b

282: --
283: -- Call Before Process User Hook
284: --
285: begin
286: irc_saved_search_criteria_bk3.delete_search_criteria_b
287: (p_vacancy_id => p_vacancy_id
288: ,p_saved_search_criteria_id => p_saved_search_criteria_id
289: ,p_object_version_number => p_object_version_number
290: );

Line 309: irc_saved_search_criteria_bk3.delete_search_criteria_a

305: --
306: -- Call After Process User Hook
307: --
308: begin
309: irc_saved_search_criteria_bk3.delete_search_criteria_a
310: (p_vacancy_id => p_vacancy_id
311: ,p_saved_search_criteria_id => p_saved_search_criteria_id
312: ,p_object_version_number => p_object_version_number
313: );

Line 348: end irc_saved_search_criteria_api;

344: hr_utility.set_location(' Leaving:'||l_proc, 90);
345: raise;
346: end delete_search_criteria;
347: --
348: end irc_saved_search_criteria_api;