[Home] [Help]
79: --
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: Procedure dt_insert_dml
83: (p_rec in out nocopy ame_man_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_mandatory_attributes t
94: where t.attribute_id = p_rec.attribute_id
95: and t.action_type_id = p_rec.action_type_id
96: and t.start_date = ame_man_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_man_shd.get_object_version_number
136: (p_attribute_id => p_rec.attribute_id
137: ,p_action_type_id => p_rec.action_type_id
138: );
139: --
223: Exception
224: When hr_api.check_integrity_violated Then
225: -- A check constraint has been violated
226: --
227: ame_man_shd.constraint_error
228: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
229: When hr_api.unique_integrity_violated Then
230: -- Unique integrity has been violated
231: --
228: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
229: When hr_api.unique_integrity_violated Then
230: -- Unique integrity has been violated
231: --
232: ame_man_shd.constraint_error
233: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
234: When Others Then
235: --
236: Raise;
239: -- ----------------------------------------------------------------------------
240: -- |------------------------------< insert_dml >------------------------------|
241: -- ----------------------------------------------------------------------------
242: Procedure insert_dml
243: (p_rec in out nocopy ame_man_shd.g_rec_type
244: ,p_effective_date in date
245: ,p_datetrack_mode in varchar2
246: ,p_validation_start_date in date
247: ,p_validation_end_date in date
302: --
303: -- {End Of Comments}
304: -- ----------------------------------------------------------------------------
305: Procedure pre_insert
306: (p_rec in out nocopy ame_man_shd.g_rec_type
307: ,p_effective_date in date
308: ,p_datetrack_mode in varchar2
309: ,p_validation_start_date in date
310: ,p_validation_end_date in date
402: --
403: -- {End Of Comments}
404: -- ----------------------------------------------------------------------------
405: Procedure post_insert
406: (p_rec in ame_man_shd.g_rec_type
407: ,p_effective_date in date
408: ,p_datetrack_mode in varchar2
409: ,p_validation_start_date in date
410: ,p_validation_end_date in date
488: -- ----------------------------------------------------------------------------
489: Procedure ins_lck
490: (p_effective_date in date
491: ,p_datetrack_mode in varchar2
492: ,p_rec in ame_man_shd.g_rec_type
493: ,p_validation_start_date out nocopy date
494: ,p_validation_end_date out nocopy date
495: ) is
496: --
533: -- |---------------------------------< ins >----------------------------------|
534: -- ----------------------------------------------------------------------------
535: Procedure ins
536: (p_effective_date in date
537: ,p_rec in out nocopy ame_man_shd.g_rec_type
538: ) is
539: --
540: l_proc varchar2(72) := g_package||'ins';
541: l_datetrack_mode varchar2(30) := hr_api.g_insert;
616: ,p_start_date out nocopy date
617: ,p_end_date out nocopy date
618: ) is
619: --
620: l_rec ame_man_shd.g_rec_type;
621: l_proc varchar2(72) := g_package||'ins';
622: --
623: Begin
624: hr_utility.set_location('Entering:'||l_proc, 5);
626: -- Call conversion function to turn arguments into the
627: -- p_rec structure.
628: --
629: l_rec :=
630: ame_man_shd.convert_args
631: (p_attribute_id
632: ,p_action_type_id
633: ,null
634: ,null