72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy irc_ipc_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: irc_ipc_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: irc_posting_contents
88: --
89: insert into irc_posting_contents
236: ,p_rec.manager_email
237: ,p_rec.manager_work_telephone
238: );
239: --
240: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 10);
243: Exception
244: When hr_api.check_integrity_violated Then
242: hr_utility.set_location(' Leaving:'||l_proc, 10);
243: Exception
244: When hr_api.check_integrity_violated Then
245: -- A check constraint has been violated
246: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
247: --
248: irc_ipc_shd.constraint_error
249: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250: When hr_api.parent_integrity_violated Then
244: When hr_api.check_integrity_violated Then
245: -- A check constraint has been violated
246: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
247: --
248: irc_ipc_shd.constraint_error
249: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250: When hr_api.parent_integrity_violated Then
251: -- Parent integrity has been violated
252: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
248: irc_ipc_shd.constraint_error
249: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250: When hr_api.parent_integrity_violated Then
251: -- Parent integrity has been violated
252: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
253: --
254: irc_ipc_shd.constraint_error
255: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256: When hr_api.unique_integrity_violated Then
250: When hr_api.parent_integrity_violated Then
251: -- Parent integrity has been violated
252: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
253: --
254: irc_ipc_shd.constraint_error
255: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256: When hr_api.unique_integrity_violated Then
257: -- Unique integrity has been violated
258: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
254: irc_ipc_shd.constraint_error
255: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256: When hr_api.unique_integrity_violated Then
257: -- Unique integrity has been violated
258: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
259: --
260: irc_ipc_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When Others Then
256: When hr_api.unique_integrity_violated Then
257: -- Unique integrity has been violated
258: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
259: --
260: irc_ipc_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When Others Then
263: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
264: --
259: --
260: irc_ipc_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When Others Then
263: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
264: --
265: Raise;
266: End insert_dml;
267: --
302: --
303: -- {End Of Comments}
304: -- ----------------------------------------------------------------------------
305: Procedure pre_insert
306: (p_rec in out nocopy irc_ipc_shd.g_rec_type
307: ) is
308: --
309: Cursor C_Sel1 is select irc_posting_contents_s.nextval from sys.dual;
310: --
389: --
390: -- {End Of Comments}
391: -- ----------------------------------------------------------------------------
392: Procedure post_insert
393: (p_rec in irc_ipc_shd.g_rec_type
394: ) is
395: --
396: l_proc varchar2(72) := g_package||'post_insert';
397: --
564: -- ----------------------------------------------------------------------------
565: -- |---------------------------------< ins >----------------------------------|
566: -- ----------------------------------------------------------------------------
567: Procedure ins
568: (p_rec in out nocopy irc_ipc_shd.g_rec_type
569: ) is
570: --
571: l_proc varchar2(72) := g_package||'ins';
572: --
674: ,p_posting_content_id out nocopy number
675: ,p_object_version_number out nocopy number
676: ) is
677: --
678: l_rec irc_ipc_shd.g_rec_type;
679: l_proc varchar2(72) := g_package||'ins';
680: --
681: Begin
682: hr_utility.set_location('Entering:'||l_proc, 5);
684: -- Call conversion function to turn arguments into the
685: -- p_rec structure.
686: --
687: l_rec :=
688: irc_ipc_shd.convert_args
689: (null
690: ,p_display_manager_info
691: ,p_display_recruiter_info
692: ,p_attribute_category