APPS.IRC_IAV_INS dependencies on IRC_IAV_SHD

Line 76: (p_rec in out nocopy irc_iav_shd.g_rec_type

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

Line 179: irc_iav_shd.constraint_error

175: Exception
176: When hr_api.check_integrity_violated Then
177: -- A check constraint has been violated
178: --
179: irc_iav_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.parent_integrity_violated Then
182: -- Parent integrity has been violated
183: --

Line 184: irc_iav_shd.constraint_error

180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.parent_integrity_violated Then
182: -- Parent integrity has been violated
183: --
184: irc_iav_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: --

Line 189: irc_iav_shd.constraint_error

185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: --
189: irc_iav_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When Others Then
192: --
193: Raise;

Line 234: (p_rec in out nocopy irc_iav_shd.g_rec_type

230: --
231: -- {End Of Comments}
232: -- ----------------------------------------------------------------------------
233: Procedure pre_insert
234: (p_rec in out nocopy irc_iav_shd.g_rec_type
235: ) is
236: --
237: Cursor C_Sel1 is select irc_agency_vacancies_s.nextval from sys.dual;
238: --

Line 321: (p_rec in irc_iav_shd.g_rec_type

317: --
318: -- {End Of Comments}
319: -- ----------------------------------------------------------------------------
320: Procedure post_insert
321: (p_rec in irc_iav_shd.g_rec_type
322: ) is
323: --
324: l_proc varchar2(72) := g_package||'post_insert';
325: --

Line 428: (p_rec in out nocopy irc_iav_shd.g_rec_type

424: -- ----------------------------------------------------------------------------
425: -- |---------------------------------< ins >----------------------------------|
426: -- ----------------------------------------------------------------------------
427: Procedure ins
428: (p_rec in out nocopy irc_iav_shd.g_rec_type
429: ) is
430: --
431: l_proc varchar2(72) := g_package||'ins';
432: --

Line 510: l_rec irc_iav_shd.g_rec_type;

506: ,p_agency_vacancy_id out nocopy number
507: ,p_object_version_number out nocopy number
508: ) is
509: --
510: l_rec irc_iav_shd.g_rec_type;
511: l_proc varchar2(72) := g_package||'ins';
512: --
513: Begin
514: hr_utility.set_location('Entering:'||l_proc, 5);

Line 520: irc_iav_shd.convert_args

516: -- Call conversion function to turn arguments into the
517: -- p_rec structure.
518: --
519: l_rec :=
520: irc_iav_shd.convert_args
521: (null
522: ,p_agency_id
523: ,p_vacancy_id
524: ,p_start_date