70: -- Internal Row Handler Use Only.
71: --
72: -- {End Of Comments}
73: -- ----------------------------------------------------------------------------
74: Procedure insert_dml(p_rec in out nocopy hr_qsf_shd.g_rec_type) is
75: --
76: l_proc varchar2(72) := g_package||'insert_dml';
77: --
78: Begin
113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: hr_qsf_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: hr_qsf_shd.constraint_error
117: hr_qsf_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: hr_qsf_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: hr_qsf_shd.constraint_error
121: hr_qsf_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: hr_qsf_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: Raise;
129: End insert_dml;
164: -- Internal Row Handler Use Only.
165: --
166: -- {End Of Comments}
167: -- ----------------------------------------------------------------------------
168: Procedure pre_insert(p_rec in out nocopy hr_qsf_shd.g_rec_type) is
169: --
170: l_proc varchar2(72) := g_package||'pre_insert';
171: l_exists varchar2(1);
172: --
245: -- Internal Row Handler Use Only.
246: --
247: -- {End Of Comments}
248: -- ----------------------------------------------------------------------------
249: Procedure post_insert(p_rec in hr_qsf_shd.g_rec_type
250: ,p_effective_date in date
251: ) is
252: --
253: l_proc varchar2(72) := g_package||'post_insert';
285: -- |---------------------------------< ins >----------------------------------|
286: -- ----------------------------------------------------------------------------
287: Procedure ins
288: (
289: p_rec in out nocopy hr_qsf_shd.g_rec_type,
290: p_effective_date in date
291: ) is
292: --
293: l_proc varchar2(72) := g_package||'ins';
332: ,p_validation_detail in varchar2
333: ,p_display_sequence in number
334: ) is
335: --
336: l_rec hr_qsf_shd.g_rec_type;
337: l_proc varchar2(72) := g_package||'ins';
338: --
339: Begin
340: hr_utility.set_location('Entering:'||l_proc, 5);
342: -- Call conversion function to turn arguments into the
343: -- p_rec structure.
344: --
345: l_rec :=
346: hr_qsf_shd.convert_args
347: (
348: null,
349: p_questionnaire_template_id,
350: p_name,