73: --
74: -- {End Of Comments}
75: -- ----------------------------------------------------------------------------
76: Procedure insert_dml
77: (p_rec in out nocopy per_rcf_shd.g_rec_type
78: ) is
79: --
80: l_proc varchar2(72) := g_package||'insert_dml';
81: --
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: per_rcf_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: per_rcf_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: per_rcf_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: Raise;
171: --
172: -- {End Of Comments}
173: -- ----------------------------------------------------------------------------
174: Procedure pre_insert
175: (p_rec in out nocopy per_rcf_shd.g_rec_type
176: ) is
177: --
178: Cursor C_Sel1 is select per_recruitment_activity_for_s.nextval from sys.dual;
179: --
258: --
259: -- {End Of Comments}
260: -- ----------------------------------------------------------------------------
261: Procedure post_insert
262: (p_rec in per_rcf_shd.g_rec_type
263: ) is
264: --
265: l_proc varchar2(72) := g_package||'post_insert';
266: --
305: -- ----------------------------------------------------------------------------
306: -- |---------------------------------< ins >----------------------------------|
307: -- ----------------------------------------------------------------------------
308: Procedure ins
309: (p_rec in out nocopy per_rcf_shd.g_rec_type
310: ) is
311: --
312: l_proc varchar2(72) := g_package||'ins';
313: --
358: ,p_rec_activity_for_id out nocopy number
359: ,p_object_version_number out nocopy number
360: ) is
361: --
362: l_rec per_rcf_shd.g_rec_type;
363: l_proc varchar2(72) := g_package||'ins';
364: --
365: Begin
366: hr_utility.set_location('Entering:'||l_proc, 5);
368: -- Call conversion function to turn arguments into the
369: -- p_rec structure.
370: --
371: l_rec :=
372: per_rcf_shd.convert_args
373: (null
374: ,p_business_group_id
375: ,p_vacancy_id
376: ,p_rec_activity_id