APPS.IRC_APL_PROFILE_ACCESS_API dependencies on IRC_APL_PROFILE_ACCESS

Line 1: Package Body irc_apl_profile_access_api as

1: Package Body irc_apl_profile_access_api as
2: /* $Header: irapaapi.pkb 120.0.12000000.1 2007/03/23 12:08:48 vboggava noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: irapaapi.pkb 120.0.12000000.1 2007/03/23 12:08:48 vboggava noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'irc_apl_profile_access_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_apl_profile_access >-------------------|
10: -- ----------------------------------------------------------------------------

Line 34: l_apl_profile_access_id irc_apl_profile_access.apl_profile_access_id%TYPE;

30: and bginfo.org_information11 = 'Y')
31: and per.person_id = irc_utilities_pkg.get_recruitment_person_id(p_person_id);
32: --
33: -- out variables
34: l_apl_profile_access_id irc_apl_profile_access.apl_profile_access_id%TYPE;
35: l_object_version_number irc_apl_profile_access.object_version_number%TYPE;
36: l_proc varchar2(72) := g_package||'create_apl_profile_access';
37: l_cursor_ret_val number(6);
38:

Line 35: l_object_version_number irc_apl_profile_access.object_version_number%TYPE;

31: and per.person_id = irc_utilities_pkg.get_recruitment_person_id(p_person_id);
32: --
33: -- out variables
34: l_apl_profile_access_id irc_apl_profile_access.apl_profile_access_id%TYPE;
35: l_object_version_number irc_apl_profile_access.object_version_number%TYPE;
36: l_proc varchar2(72) := g_package||'create_apl_profile_access';
37: l_cursor_ret_val number(6);
38:
39: begin

Line 146: l_apl_profile_access_id irc_apl_profile_access.apl_profile_access_id%TYPE;

142: --
143: -- Declare cursors and local variables
144: --
145: -- out variables
146: l_apl_profile_access_id irc_apl_profile_access.apl_profile_access_id%TYPE;
147: l_object_version_number irc_apl_profile_access.object_version_number%TYPE;
148: l_proc varchar2(72) := g_package||'update_apl_profile_access';
149:
150: begin

Line 147: l_object_version_number irc_apl_profile_access.object_version_number%TYPE;

143: -- Declare cursors and local variables
144: --
145: -- out variables
146: l_apl_profile_access_id irc_apl_profile_access.apl_profile_access_id%TYPE;
147: l_object_version_number irc_apl_profile_access.object_version_number%TYPE;
148: l_proc varchar2(72) := g_package||'update_apl_profile_access';
149:
150: begin
151: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 171: irc_apl_profile_access_bk2.update_apl_profile_access_b

167: --
168: -- Call Before Process User Hook
169: --
170: begin
171: irc_apl_profile_access_bk2.update_apl_profile_access_b
172: (p_person_id => p_person_id
173: ,p_apl_profile_access_id => l_apl_profile_access_id
174: ,p_object_version_number => l_object_version_number
175: );

Line 201: irc_apl_profile_access_bk2.update_apl_profile_access_a

197: --
198: -- Call After Process User Hook
199: --
200: begin
201: irc_apl_profile_access_bk2.update_apl_profile_access_a
202: (p_person_id => p_person_id
203: ,p_apl_profile_access_id => l_apl_profile_access_id
204: ,p_object_version_number => l_object_version_number
205: );

Line 285: irc_apl_profile_access_bk3.delete_apl_profile_access_b

281: --
282: -- Call Before Process User Hook
283: --
284: begin
285: irc_apl_profile_access_bk3.delete_apl_profile_access_b
286: (p_person_id => p_person_id
287: ,p_apl_profile_access_id => p_apl_profile_access_id
288: ,p_object_version_number => p_object_version_number
289: );

Line 308: irc_apl_profile_access_bk3.delete_apl_profile_access_a

304: --
305: -- Call After Process User Hook
306: --
307: begin
308: irc_apl_profile_access_bk3.delete_apl_profile_access_a
309: (p_person_id => p_person_id
310: ,p_apl_profile_access_id => p_apl_profile_access_id
311: ,p_object_version_number => p_object_version_number
312: );

Line 347: end irc_apl_profile_access_api;

343: hr_utility.set_location(' Leaving:'||l_proc, 90);
344: raise;
345: end delete_apl_profile_access;
346: --
347: end irc_apl_profile_access_api;