APPS.IRC_IPD_INS dependencies on IRC_IPD_SHD

Line 76: (p_rec in out nocopy irc_ipd_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy irc_ipd_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 213: irc_ipd_shd.constraint_error

209: Exception
210: When hr_api.check_integrity_violated Then
211: -- A check constraint has been violated
212: --
213: irc_ipd_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When hr_api.parent_integrity_violated Then
216: -- Parent integrity has been violated
217: --

Line 218: irc_ipd_shd.constraint_error

214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When hr_api.parent_integrity_violated Then
216: -- Parent integrity has been violated
217: --
218: irc_ipd_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: --

Line 223: irc_ipd_shd.constraint_error

219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: --
223: irc_ipd_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When Others Then
226: --
227: Raise;

Line 268: (p_rec in out nocopy irc_ipd_shd.g_rec_type

264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Procedure pre_insert
268: (p_rec in out nocopy irc_ipd_shd.g_rec_type
269: ) is
270: --
271: Cursor C_Sel1 is select irc_pending_data_s.nextval from sys.dual;
272: --

Line 355: (p_rec in irc_ipd_shd.g_rec_type

351: --
352: -- {End Of Comments}
353: -- ----------------------------------------------------------------------------
354: Procedure post_insert
355: (p_rec in irc_ipd_shd.g_rec_type
356: ) is
357: --
358: l_proc varchar2(72) := g_package||'post_insert';
359: --

Line 492: (p_rec in out nocopy irc_ipd_shd.g_rec_type

488: -- ----------------------------------------------------------------------------
489: -- |---------------------------------< ins >----------------------------------|
490: -- ----------------------------------------------------------------------------
491: Procedure ins
492: (p_rec in out nocopy irc_ipd_shd.g_rec_type
493: ) is
494: --
495: l_proc varchar2(72) := g_package||'ins';
496: --

Line 590: l_rec irc_ipd_shd.g_rec_type;

586: ,p_security_group_key in varchar2 default null
587: ,p_pending_data_id out nocopy number
588: ) is
589: --
590: l_rec irc_ipd_shd.g_rec_type;
591: l_proc varchar2(72) := g_package||'ins';
592: --
593: Begin
594: hr_utility.set_location('Entering:'||l_proc, 5);

Line 600: irc_ipd_shd.convert_args

596: -- Call conversion function to turn arguments into the
597: -- p_rec structure.
598: --
599: l_rec :=
600: irc_ipd_shd.convert_args
601: (null
602: ,p_email_address
603: ,p_vacancy_id
604: ,p_last_name