50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy ota_ent_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: --
87: ota_ent_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --
92: ota_ent_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --
97: ota_ent_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: --
101: Raise;
138: --
139: -- {End Of Comments}
140: -- ----------------------------------------------------------------------------
141: Procedure pre_insert
142: (p_rec in out nocopy ota_ent_shd.g_rec_type
143: ,p_event_id in number
144: ) is
145: --
146: l_proc varchar2(72) := g_package||'pre_insert';
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure post_insert
189: (p_effective_date in date
190: ,p_rec in ota_ent_shd.g_rec_type
191: ) is
192: --
193: l_proc varchar2(72) := g_package||'post_insert';
194: --
225: -- |---------------------------------< ins >----------------------------------|
226: -- ----------------------------------------------------------------------------
227: Procedure ins
228: (p_effective_date in date
229: ,p_rec in out nocopy ota_ent_shd.g_rec_type
230: ,p_event_id in number
231: ) is
232: --
233: l_proc varchar2(72) := g_package||'ins';
280: ,p_title in varchar2
281: ,p_source_lang in varchar2
282: ) is
283: --
284: l_rec ota_ent_shd.g_rec_type;
285: l_proc varchar2(72) := g_package||'ins';
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);
290: -- Call conversion function to turn arguments into the
291: -- p_rec structure.
292: --
293: l_rec :=
294: ota_ent_shd.convert_args
295: (null
296: ,p_language
297: ,p_title
298: ,p_source_lang