[Home] [Help]
79: --
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: Procedure dt_insert_dml
83: (p_rec in out nocopy ame_acf_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_action_type_config t
94: where t.action_type_id = p_rec.action_type_id
95: and t.application_id = p_rec.application_id
96: and t.start_date = ame_acf_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_acf_shd.get_object_version_number
136: (p_action_type_id => p_rec.action_type_id
137: ,p_application_id => p_rec.application_id
138: );
139: --
227: Exception
228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
230: --
231: ame_acf_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_acf_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_acf_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
401: --
402: -- {End Of Comments}
403: -- ----------------------------------------------------------------------------
404: Procedure pre_insert
405: (p_rec in out nocopy ame_acf_shd.g_rec_type
406: ,p_effective_date in date
407: ,p_datetrack_mode in varchar2
408: ,p_validation_start_date in date
409: ,p_validation_end_date in date
513: --
514: -- {End Of Comments}
515: -- ----------------------------------------------------------------------------
516: Procedure post_insert
517: (p_rec in ame_acf_shd.g_rec_type
518: ,p_effective_date in date
519: ,p_datetrack_mode in varchar2
520: ,p_validation_start_date in date
521: ,p_validation_end_date in date
603: -- ----------------------------------------------------------------------------
604: Procedure ins_lck
605: (p_effective_date in date
606: ,p_datetrack_mode in varchar2
607: ,p_rec in ame_acf_shd.g_rec_type
608: ,p_validation_start_date out nocopy date
609: ,p_validation_end_date out nocopy date
610: ) is
611: --
636: -- |---------------------------------< ins >----------------------------------|
637: -- ----------------------------------------------------------------------------
638: Procedure ins
639: (p_effective_date in date
640: ,p_rec in out nocopy ame_acf_shd.g_rec_type
641: ) is
642: --
643: l_proc varchar2(72) := g_package||'ins';
644: l_datetrack_mode varchar2(30) := hr_api.g_insert;
721: ,p_start_date out nocopy date
722: ,p_end_date out nocopy date
723: ) is
724: --
725: l_rec ame_acf_shd.g_rec_type;
726: l_proc varchar2(72) := g_package||'ins';
727: --
728: Begin
729: hr_utility.set_location('Entering:'||l_proc, 5);
731: -- Call conversion function to turn arguments into the
732: -- p_rec structure.
733: --
734: l_rec :=
735: ame_acf_shd.convert_args
736: (p_application_id
737: ,p_action_type_id
738: ,p_voting_regime
739: ,p_order_number