DBA Data[Home] [Help]

APPS.IRC_REC_TEAM_MEMBERS_SWI dependencies on IRC_REC_TEAM_MEMBERS

Line 1: Package Body irc_rec_team_members_swi As

1: Package Body irc_rec_team_members_swi As
2: /* $Header: irrtmswi.pkb 120.3.12010000.2 2008/09/05 10:10:34 pvelugul ship $ */
3: --
4: -- Package variables
5: --

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

2: /* $Header: irrtmswi.pkb 120.3.12010000.2 2008/09/05 10:10:34 pvelugul ship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'irc_rec_team_members_swi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_rec_team_member >------------------------|
10: -- ----------------------------------------------------------------------------

Line 62: irc_rec_team_members_api.create_rec_team_member

58: );
59: --
60: -- Call API
61: --
62: irc_rec_team_members_api.create_rec_team_member
63: (p_validate => l_validate
64: ,p_rec_team_member_id => l_rec_team_member_id
65: ,p_person_id => p_person_id
66: ,p_vacancy_id => p_vacancy_id

Line 141: l_object_version_number irc_rec_team_members.object_version_number%TYPE;

137: -- Variables for IN/OUT parameters
138: --
139: -- Other variables
140: l_proc varchar2(72) := g_package ||'delete_rec_team_member';
141: l_object_version_number irc_rec_team_members.object_version_number%TYPE;
142:
143: cursor get_object_version_number(p_rec_team_member_id irc_rec_team_members.rec_team_member_id%TYPE) is
144: select object_version_number
145: from irc_rec_team_members

Line 143: cursor get_object_version_number(p_rec_team_member_id irc_rec_team_members.rec_team_member_id%TYPE) is

139: -- Other variables
140: l_proc varchar2(72) := g_package ||'delete_rec_team_member';
141: l_object_version_number irc_rec_team_members.object_version_number%TYPE;
142:
143: cursor get_object_version_number(p_rec_team_member_id irc_rec_team_members.rec_team_member_id%TYPE) is
144: select object_version_number
145: from irc_rec_team_members
146: where rec_team_member_id = p_rec_team_member_id;
147:

Line 145: from irc_rec_team_members

141: l_object_version_number irc_rec_team_members.object_version_number%TYPE;
142:
143: cursor get_object_version_number(p_rec_team_member_id irc_rec_team_members.rec_team_member_id%TYPE) is
144: select object_version_number
145: from irc_rec_team_members
146: where rec_team_member_id = p_rec_team_member_id;
147:
148: Begin
149: hr_utility.set_location(' Entering:' || l_proc,10);

Line 180: irc_rec_team_members_api.delete_rec_team_member

176: fetch get_object_version_number into l_object_version_number;
177: close get_object_version_number;
178: end if;
179: --
180: irc_rec_team_members_api.delete_rec_team_member
181: (p_validate => l_validate
182: ,p_rec_team_member_id => p_rec_team_member_id
183: ,p_object_version_number => l_object_version_number
184: );

Line 285: irc_rec_team_members_api.update_rec_team_member

281: --
282: --
283: -- Call API
284: --
285: irc_rec_team_members_api.update_rec_team_member
286: (p_validate => l_validate
287: ,p_rec_team_member_id => p_rec_team_member_id
288: ,p_person_id => p_person_id
289: ,p_object_version_number => p_object_version_number

Line 456: end irc_rec_team_members_swi;

452: ('Exiting :'|| l_proc || ': return status :'|| l_return_status || ':',40);
453:
454: end process_api;
455: --
456: end irc_rec_team_members_swi;