APPS.IRC_RTM_INS dependencies on IRC_RTM_INS

Line 1: Package Body irc_rtm_ins as

1: Package Body irc_rtm_ins as
2: /* $Header: irrtmrhi.pkb 120.3 2008/01/22 10:17:45 mkjayara noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' irc_rtm_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' irc_rtm_ins.'; -- Global package name
9: --
10: -- The following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 22: irc_rtm_ins.g_rec_team_member_id_i := p_rec_team_member_id;

18: (p_rec_team_member_id in number) is
19: l_proc varchar2(72):=g_package||'set_base_key_value';
20: begin
21: hr_utility.set_location('Entering'||l_proc,10);
22: irc_rtm_ins.g_rec_team_member_id_i := p_rec_team_member_id;
23: hr_utility.set_location('Leaving'||l_proc,20);
24: end set_base_key_value;
25: --
26: -- ----------------------------------------------------------------------------

Line 178: where rec_team_member_id = irc_rtm_ins.g_rec_team_member_id_i;

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: --
182: Begin

Line 185: If (irc_rtm_ins.g_rec_team_member_id_i is not null) Then

181: --
182: Begin
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: If (irc_rtm_ins.g_rec_team_member_id_i is not null) Then
186:
187: open c2;
188: fetch c2 into l_exists;
189: if c2%found then

Line 200: irc_rtm_ins.g_rec_team_member_id_i;

196: --
197: -- Use registered key values and clear globals
198: --
199: p_rec.rec_team_member_id :=
200: irc_rtm_ins.g_rec_team_member_id_i;
201: irc_rtm_ins.g_rec_team_member_id_i := null;
202: --
203: else
204: open c1;

Line 201: irc_rtm_ins.g_rec_team_member_id_i := null;

197: -- Use registered key values and clear globals
198: --
199: p_rec.rec_team_member_id :=
200: irc_rtm_ins.g_rec_team_member_id_i;
201: irc_rtm_ins.g_rec_team_member_id_i := null;
202: --
203: else
204: open c1;
205: fetch c1 into p_rec.rec_team_member_id;

Line 311: irc_rtm_ins.pre_insert(p_rec);

307: hr_multi_message.end_validation_set;
308: --
309: -- Call the supporting pre-insert operation
310: --
311: irc_rtm_ins.pre_insert(p_rec);
312: --
313: -- Insert the row
314: --
315: irc_rtm_ins.insert_dml(p_rec);

Line 315: irc_rtm_ins.insert_dml(p_rec);

311: irc_rtm_ins.pre_insert(p_rec);
312: --
313: -- Insert the row
314: --
315: irc_rtm_ins.insert_dml(p_rec);
316: --
317: -- Call the supporting post-insert operation
318: --
319: irc_rtm_ins.post_insert

Line 319: irc_rtm_ins.post_insert

315: irc_rtm_ins.insert_dml(p_rec);
316: --
317: -- Call the supporting post-insert operation
318: --
319: irc_rtm_ins.post_insert
320: (p_rec
321: );
322: --
323: -- Call to raise any errors on multi-message list

Line 371: irc_rtm_ins.ins

367: --
368: -- Having converted the arguments into the irc_rtm_rec
369: -- plsql record structure we call the corresponding record business process.
370: --
371: irc_rtm_ins.ins
372: (l_rec
373: );
374: --
375: -- The OUT argument's values must be set.

Line 383: end irc_rtm_ins;

379: --
380: hr_utility.set_location(' Leaving:'||l_proc, 10);
381: End ins;
382: --
383: end irc_rtm_ins;