72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy irc_iss_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: --
109: irc_iss_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --
114: irc_iss_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: irc_iss_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: --
123: Raise;
161: --
162: -- {End Of Comments}
163: -- ----------------------------------------------------------------------------
164: Procedure pre_insert
165: (p_rec in out nocopy irc_iss_shd.g_rec_type
166: ) is
167: --
168: Cursor C_Sel1 is select irc_saved_search_criteria_s.nextval from sys.dual;
169: --
249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure post_insert
253: (p_rec in irc_iss_shd.g_rec_type
254: ) is
255: --
256: l_proc varchar2(72) := g_package||'post_insert';
257: --
286: -- ----------------------------------------------------------------------------
287: -- |---------------------------------< ins >----------------------------------|
288: -- ----------------------------------------------------------------------------
289: Procedure ins
290: (p_rec in out nocopy irc_iss_shd.g_rec_type
291: ) is
292: --
293: l_proc varchar2(72) := g_package||'ins';
294: --
338: ,p_saved_search_criteria_id out nocopy number
339: ,p_object_version_number out nocopy number
340: ) is
341: --
342: l_rec irc_iss_shd.g_rec_type;
343: l_proc varchar2(72) := g_package||'ins';
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
348: -- Call conversion function to turn arguments into the
349: -- p_rec structure.
350: --
351: l_rec :=
352: irc_iss_shd.convert_args
353: (null
354: ,p_search_criteria
355: ,p_vacancy_id
356: ,null