APPS.IRC_RTM_INS dependencies on IRC_RTM_SHD

Line 70: (p_rec in out nocopy irc_rtm_shd.g_rec_type

66: --
67: -- {End Of Comments}
68: -- ----------------------------------------------------------------------------
69: Procedure insert_dml
70: (p_rec in out nocopy irc_rtm_shd.g_rec_type
71: ) is
72: --
73: l_proc varchar2(72) := g_package||'insert_dml';
74: --

Line 117: irc_rtm_shd.constraint_error

113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: irc_rtm_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --

Line 122: irc_rtm_shd.constraint_error

118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: irc_rtm_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --

Line 127: irc_rtm_shd.constraint_error

123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: irc_rtm_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: --
131: Raise;

Line 172: (p_rec in out nocopy irc_rtm_shd.g_rec_type

168: --
169: -- {End Of Comments}
170: -- ----------------------------------------------------------------------------
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

Line 245: (p_rec in irc_rtm_shd.g_rec_type

241: --
242: -- {End Of Comments}
243: -- ----------------------------------------------------------------------------
244: Procedure post_insert
245: (p_rec in irc_rtm_shd.g_rec_type
246: ) is
247: --
248: l_proc varchar2(72) := g_package||'post_insert';
249: --

Line 292: (p_rec in out nocopy irc_rtm_shd.g_rec_type

288: -- ----------------------------------------------------------------------------
289: -- |---------------------------------< ins >----------------------------------|
290: -- ----------------------------------------------------------------------------
291: Procedure ins
292: (p_rec in out nocopy irc_rtm_shd.g_rec_type
293: ) is
294: --
295: l_proc varchar2(72) := g_package||'ins';
296: --

Line 344: l_rec irc_rtm_shd.g_rec_type;

340: ,p_rec_team_member_id out nocopy number
341: ,p_interview_security in varchar2 default 'SELF'
342: ) is
343: --
344: l_rec irc_rtm_shd.g_rec_type;
345: l_proc varchar2(72) := g_package||'ins';
346: --
347: Begin
348: hr_utility.set_location('Entering:'||l_proc, 5);

Line 354: irc_rtm_shd.convert_args

350: -- Call conversion function to turn arguments into the
351: -- p_rec structure.
352: --
353: l_rec :=
354: irc_rtm_shd.convert_args
355: (null
356: ,p_person_id
357: ,null
358: ,p_vacancy_id