72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy per_cnf_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: per_cnf_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: per_cnf_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: per_cnf_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: --
123: Raise;
160: --
161: -- {End Of Comments}
162: -- ----------------------------------------------------------------------------
163: Procedure pre_insert
164: (p_rec in out nocopy per_cnf_shd.g_rec_type
165: ) is
166: --
167:
168: --
252: -- {End Of Comments}
253: -- ----------------------------------------------------------------------------
254: Procedure post_insert
255: (p_effective_date in date
256: ,p_rec in per_cnf_shd.g_rec_type
257: ) is
258: --
259: l_proc varchar2(72) := g_package||'post_insert';
260: --
291: -- |---------------------------------< ins >----------------------------------|
292: -- ----------------------------------------------------------------------------
293: Procedure ins
294: (p_effective_date in date
295: ,p_rec in out nocopy per_cnf_shd.g_rec_type
296: ) is
297: --
298: l_proc varchar2(72) := g_package||'ins';
299: --
341: ,p_configuration_status in varchar2 default null
342: ,p_object_version_number out nocopy number
343: ) is
344: --
345: l_rec per_cnf_shd.g_rec_type;
346: l_proc varchar2(72) := g_package||'ins';
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
351: -- Call conversion function to turn arguments into the
352: -- p_rec structure.
353: --
354: l_rec :=
355: per_cnf_shd.convert_args
356: (p_configuration_code
357: ,p_configuration_type
358: ,p_configuration_status
359: ,null