50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy per_qat_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: --
101: per_qat_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: --
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: --
106: per_qat_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: --
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: --
111: per_qat_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: --
115: Raise;
152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure pre_insert
156: (p_rec in out nocopy per_qat_shd.g_rec_type
157: ,p_qualification_id in number
158: ) is
159: --
160: l_proc varchar2(72) := g_package||'pre_insert';
199: --
200: -- {End Of Comments}
201: -- ----------------------------------------------------------------------------
202: Procedure post_insert
203: (p_rec in per_qat_shd.g_rec_type
204: ) is
205: --
206: l_proc varchar2(72) := g_package||'post_insert';
207: --
250: -- ----------------------------------------------------------------------------
251: -- |---------------------------------< ins >----------------------------------|
252: -- ----------------------------------------------------------------------------
253: Procedure ins
254: (p_rec in out nocopy per_qat_shd.g_rec_type
255: ,p_qualification_id in number
256: ) is
257: --
258: l_proc varchar2(72) := g_package||'ins';
310: ,p_training_completed_units in varchar2
311: ,p_membership_category in varchar2
312: ) is
313: --
314: l_rec per_qat_shd.g_rec_type;
315: l_proc varchar2(72) := g_package||'ins';
316: --
317: Begin
318: hr_utility.set_location('Entering:'||l_proc, 5);
320: -- Call conversion function to turn arguments into the
321: -- p_rec structure.
322: --
323: l_rec :=
324: per_qat_shd.convert_args
325: (null
326: ,p_language
327: ,p_source_lang
328: ,p_title