APPS.IRC_IOF_INS dependencies on IRC_IOF_SHD

Line 76: (p_rec in out nocopy irc_iof_shd.g_rec_type

72: --
73: -- {end of comments}
74: -- ----------------------------------------------------------------------------
75: procedure insert_dml
76: (p_rec in out nocopy irc_iof_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 205: irc_iof_shd.constraint_error

201: exception
202: when hr_api.check_integrity_violated then
203: -- a check constraint has been violated
204: --
205: irc_iof_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
207: when hr_api.parent_integrity_violated then
208: -- parent integrity has been violated
209: --

Line 210: irc_iof_shd.constraint_error

206: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
207: when hr_api.parent_integrity_violated then
208: -- parent integrity has been violated
209: --
210: irc_iof_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
212: when hr_api.unique_integrity_violated then
213: -- unique integrity has been violated
214: --

Line 215: irc_iof_shd.constraint_error

211: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
212: when hr_api.unique_integrity_violated then
213: -- unique integrity has been violated
214: --
215: irc_iof_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
217: when others then
218: --
219: raise;

Line 260: (p_rec in out nocopy irc_iof_shd.g_rec_type

256: --
257: -- {end of comments}
258: -- ----------------------------------------------------------------------------
259: procedure pre_insert
260: (p_rec in out nocopy irc_iof_shd.g_rec_type
261: ) is
262: --
263: cursor c_sel1 is select irc_offers_s.nextval from sys.dual;
264: --

Line 348: ,p_rec in irc_iof_shd.g_rec_type

344: -- {end of comments}
345: -- ----------------------------------------------------------------------------
346: procedure post_insert
347: (p_effective_date in date
348: ,p_rec in irc_iof_shd.g_rec_type
349: ) is
350: --
351: l_proc varchar2(72) := g_package||'post_insert';
352: --

Line 481: ,p_rec in out nocopy irc_iof_shd.g_rec_type

477: -- |---------------------------------< ins >----------------------------------|
478: -- ----------------------------------------------------------------------------
479: procedure ins
480: (p_effective_date in date
481: ,p_rec in out nocopy irc_iof_shd.g_rec_type
482: ) is
483: --
484: l_proc varchar2(72) := g_package||'ins';
485: --

Line 578: l_rec irc_iof_shd.g_rec_type;

574: ,p_offer_version out nocopy number
575: ,p_object_version_number out nocopy number
576: ) is
577: --
578: l_rec irc_iof_shd.g_rec_type;
579: l_proc varchar2(72) := g_package||'ins';
580: --
581: begin
582: hr_utility.set_location('entering:'||l_proc, 5);

Line 588: irc_iof_shd.convert_args

584: -- call conversion function to turn arguments into the
585: -- p_rec structure.
586: --
587: l_rec :=
588: irc_iof_shd.convert_args
589: (null -- offer_id
590: ,null -- offer_version
591: ,p_latest_offer
592: ,p_offer_status