50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy ame_itl_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by ame_approval_groups.created_by%TYPE;
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
113: ame_itl_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.parent_integrity_violated Then
116: -- Parent integrity has been violated
117: --
118: ame_itl_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.unique_integrity_violated Then
121: -- Unique integrity has been violated
122: --
123: ame_itl_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When Others Then
126: --
127: Raise;
164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure pre_insert
168: (p_rec in out nocopy ame_itl_shd.g_rec_type
169: ,p_item_class_id in number
170: ) is
171: --
172: l_proc varchar2(72) := g_package||'pre_insert';
211: --
212: -- {End Of Comments}
213: -- ----------------------------------------------------------------------------
214: Procedure post_insert
215: (p_rec in ame_itl_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'post_insert';
219: --
248: -- ----------------------------------------------------------------------------
249: -- |---------------------------------< ins >----------------------------------|
250: -- ----------------------------------------------------------------------------
251: Procedure ins
252: (p_rec in out nocopy ame_itl_shd.g_rec_type
253: ,p_item_class_id in number
254: ) is
255: --
256: l_proc varchar2(72) := g_package||'ins';
299: ,p_source_lang in varchar2
300: ,p_user_item_class_name in varchar2
301: ) is
302: --
303: l_rec ame_itl_shd.g_rec_type;
304: l_proc varchar2(72) := g_package||'ins';
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);
309: -- Call conversion function to turn arguments into the
310: -- p_rec structure.
311: --
312: l_rec :=
313: ame_itl_shd.convert_args
314: (null
315: ,p_language
316: ,p_source_lang
317: ,p_user_item_class_name