APPS.IRC_RTM_INS dependencies on IRC_REC_TEAM_MEMBERS

Line 81: -- Insert the row into: irc_rec_team_members

77: p_rec.object_version_number := 1; -- Initialise the object version
78: --
79: --
80: --
81: -- Insert the row into: irc_rec_team_members
82: --
83: insert into irc_rec_team_members
84: (rec_team_member_id
85: ,person_id

Line 83: insert into irc_rec_team_members

79: --
80: --
81: -- Insert the row into: irc_rec_team_members
82: --
83: insert into irc_rec_team_members
84: (rec_team_member_id
85: ,person_id
86: ,party_id
87: ,vacancy_id

Line 175: cursor c1 is select irc_rec_team_members_s.nextval from sys.dual;

171: Procedure pre_insert
172: (p_rec in out nocopy irc_rtm_shd.g_rec_type
173: ) is
174: --
175: cursor c1 is select irc_rec_team_members_s.nextval from sys.dual;
176: cursor c2 is
177: select null from irc_rec_team_members
178: where rec_team_member_id = irc_rtm_ins.g_rec_team_member_id_i;
179: l_proc varchar2(72) := g_package||'pre_insert';

Line 177: select null from irc_rec_team_members

173: ) is
174: --
175: cursor c1 is select irc_rec_team_members_s.nextval from sys.dual;
176: cursor c2 is
177: select null from irc_rec_team_members
178: where rec_team_member_id = irc_rtm_ins.g_rec_team_member_id_i;
179: l_proc varchar2(72) := g_package||'pre_insert';
180: l_exists varchar2(1);
181: --

Line 192: fnd_message.set_token('TABLE_NAME','irc_rec_team_members');

188: fetch c2 into l_exists;
189: if c2%found then
190: close c2;
191: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
192: fnd_message.set_token('TABLE_NAME','irc_rec_team_members');
193: fnd_message.raise_error;
194: end if;
195: close c2;
196: --

Line 280: (p_module_name => 'IRC_REC_TEAM_MEMBERS'

276: --
277: when hr_api.cannot_find_prog_unit then
278: --
279: hr_api.cannot_find_prog_unit_error
280: (p_module_name => 'IRC_REC_TEAM_MEMBERS'
281: ,p_hook_type => 'AI');
282: --
283: end;
284: --