71: --
72: -- {End Of Comments}
73: -- ----------------------------------------------------------------------------
74: Procedure insert_dml
75: (p_rec in out nocopy hr_ort_shd.g_rec_type
76: ) is
77: --
78: l_proc varchar2(72) := g_package||'insert_dml';
79: --
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: --
108: hr_ort_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: --
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: --
113: hr_ort_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: --
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: --
118: hr_ort_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: --
122: Raise;
159: --
160: -- {End Of Comments}
161: -- ----------------------------------------------------------------------------
162: Procedure pre_insert
163: (p_rec in out nocopy hr_ort_shd.g_rec_type
164: ,p_organization_id in number
165: ) is
166: --
167: l_proc varchar2(72) := g_package||'pre_insert';
206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure post_insert
210: (p_rec in hr_ort_shd.g_rec_type
211: ) is
212: --
213: l_proc varchar2(72) := g_package||'post_insert';
214: --
243: -- ----------------------------------------------------------------------------
244: -- |---------------------------------< ins >----------------------------------|
245: -- ----------------------------------------------------------------------------
246: Procedure ins
247: (p_rec in out nocopy hr_ort_shd.g_rec_type
248: ,p_organization_id in number
249: ) is
250: --
251: l_proc varchar2(72) := g_package||'ins';
288: ,p_source_lang in varchar2
289: ,p_name in varchar2
290: ) is
291: --
292: l_rec hr_ort_shd.g_rec_type;
293: l_proc varchar2(72) := g_package||'ins';
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);
298: -- Call conversion function to turn arguments into the
299: -- p_rec structure.
300: --
301: l_rec :=
302: hr_ort_shd.convert_args
303: (null
304: ,p_language
305: ,p_source_lang
306: ,p_name