[Home] [Help]
79: --
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: Procedure dt_insert_dml
83: (p_rec in out nocopy ame_itu_shd.g_rec_type
84: ,p_effective_date in date
85: ,p_datetrack_mode in varchar2
86: ,p_validation_start_date in date
87: ,p_validation_end_date in date
92: select t.creation_date
93: from ame_item_class_usages t
94: where t.item_class_id = p_rec.item_class_id
95: and t.application_id = p_rec.application_id
96: and t.start_date = ame_itu_shd.g_old_rec.start_date
97: and t.end_date = p_validation_start_date;
98: --
99: Cursor C_Sel2 Is
100: select created_by
131: --
132: -- Get the object version number for the insert
133: --
134: p_rec.object_version_number :=
135: ame_itu_shd.get_object_version_number
136: (p_item_class_id => p_rec.item_class_id
137: ,p_application_id => p_rec.application_id
138: );
139: --
229: Exception
230: When hr_api.check_integrity_violated Then
231: -- A check constraint has been violated
232: --
233: ame_itu_shd.constraint_error
234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When hr_api.unique_integrity_violated Then
236: -- Unique integrity has been violated
237: --
234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When hr_api.unique_integrity_violated Then
236: -- Unique integrity has been violated
237: --
238: ame_itu_shd.constraint_error
239: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
240: When Others Then
241: --
242: Raise;
245: -- ----------------------------------------------------------------------------
246: -- |------------------------------< insert_dml >------------------------------|
247: -- ----------------------------------------------------------------------------
248: Procedure insert_dml
249: (p_rec in out nocopy ame_itu_shd.g_rec_type
250: ,p_effective_date in date
251: ,p_datetrack_mode in varchar2
252: ,p_validation_start_date in date
253: ,p_validation_end_date in date
308: --
309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: Procedure pre_insert
312: (p_rec in out nocopy ame_itu_shd.g_rec_type
313: ,p_effective_date in date
314: ,p_datetrack_mode in varchar2
315: ,p_validation_start_date in date
316: ,p_validation_end_date in date
410: --
411: -- {End Of Comments}
412: -- ----------------------------------------------------------------------------
413: Procedure post_insert
414: (p_rec in ame_itu_shd.g_rec_type
415: ,p_effective_date in date
416: ,p_datetrack_mode in varchar2
417: ,p_validation_start_date in date
418: ,p_validation_end_date in date
490: -- ----------------------------------------------------------------------------
491: Procedure ins_lck
492: (p_effective_date in date
493: ,p_datetrack_mode in varchar2
494: ,p_rec in ame_itu_shd.g_rec_type
495: ,p_validation_start_date out nocopy date
496: ,p_validation_end_date out nocopy date
497: ) is
498: --
523: -- |---------------------------------< ins >----------------------------------|
524: -- ----------------------------------------------------------------------------
525: Procedure ins
526: (p_effective_date in date
527: ,p_rec in out nocopy ame_itu_shd.g_rec_type
528: ) is
529: --
530: l_proc varchar2(72) := g_package||'ins';
531: l_datetrack_mode varchar2(30) := hr_api.g_insert;
609: ,p_start_date out nocopy date
610: ,p_end_date out nocopy date
611: ) is
612: --
613: l_rec ame_itu_shd.g_rec_type;
614: l_proc varchar2(72) := g_package||'ins';
615: --
616: Begin
617: hr_utility.set_location('Entering:'||l_proc, 5);
619: -- Call conversion function to turn arguments into the
620: -- p_rec structure.
621: --
622: l_rec :=
623: ame_itu_shd.convert_args
624: (p_application_id
625: ,p_item_class_id
626: ,p_item_id_query
627: ,p_item_class_order_number