[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy ame_aty_shd.g_rec_type
81: ,p_effective_date in date
82: ,p_datetrack_mode in varchar2
83: ,p_validation_start_date in date
84: ,p_validation_end_date in date
88: Cursor C_Sel1 Is
89: select t.creation_date
90: from ame_action_types t
91: where t.action_type_id = p_rec.action_type_id
92: and t.start_date = ame_aty_shd.g_old_rec.start_date
93: and t.end_date = p_validation_start_date;
94: --
95: Cursor C_Sel2 Is
96: select created_by
126: --
127: -- Get the object version number for the insert
128: --
129: p_rec.object_version_number :=
130: ame_aty_shd.get_object_version_number
131: (p_action_type_id => p_rec.action_type_id
132: );
133: --
134: -- Select the 'old' created values
227: Exception
228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
230: --
231: ame_aty_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.unique_integrity_violated Then
234: -- Unique integrity has been violated
235: --
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.unique_integrity_violated Then
234: -- Unique integrity has been violated
235: --
236: ame_aty_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When Others Then
239: --
240: Raise;
243: -- ----------------------------------------------------------------------------
244: -- |------------------------------< insert_dml >------------------------------|
245: -- ----------------------------------------------------------------------------
246: Procedure insert_dml
247: (p_rec in out nocopy ame_aty_shd.g_rec_type
248: ,p_effective_date in date
249: ,p_datetrack_mode in varchar2
250: ,p_validation_start_date in date
251: ,p_validation_end_date in date
306: --
307: -- {End Of Comments}
308: -- ----------------------------------------------------------------------------
309: Procedure pre_insert
310: (p_rec in out nocopy ame_aty_shd.g_rec_type
311: ,p_effective_date in date
312: ,p_datetrack_mode in varchar2
313: ,p_validation_start_date in date
314: ,p_validation_end_date in date
398: --
399: -- {End Of Comments}
400: -- ----------------------------------------------------------------------------
401: Procedure post_insert
402: (p_rec in ame_aty_shd.g_rec_type
403: ,p_effective_date in date
404: ,p_datetrack_mode in varchar2
405: ,p_validation_start_date in date
406: ,p_validation_end_date in date
492: -- ----------------------------------------------------------------------------
493: Procedure ins_lck
494: (p_effective_date in date
495: ,p_datetrack_mode in varchar2
496: ,p_rec in ame_aty_shd.g_rec_type
497: ,p_validation_start_date out nocopy date
498: ,p_validation_end_date out nocopy date
499: ) is
500: --
525: -- |---------------------------------< ins >----------------------------------|
526: -- ----------------------------------------------------------------------------
527: Procedure ins
528: (p_effective_date in date
529: ,p_rec in out nocopy ame_aty_shd.g_rec_type
530: ) is
531: --
532: l_proc varchar2(72) := g_package||'ins';
533: l_datetrack_mode varchar2(30) := hr_api.g_insert;
612: ,p_start_date out nocopy date
613: ,p_end_date out nocopy date
614: ) is
615: --
616: l_rec ame_aty_shd.g_rec_type;
617: l_proc varchar2(72) := g_package||'ins';
618: --
619: Begin
620: hr_utility.set_location('Entering:'||l_proc, 5);
622: -- Call conversion function to turn arguments into the
623: -- p_rec structure.
624: --
625: l_rec :=
626: ame_aty_shd.convert_args
627: (null
628: ,p_name
629: ,p_procedure_name
630: ,null