[Home] [Help]
79: --
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: Procedure dt_insert_dml
83: (p_rec in out nocopy ame_acu_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
93: from ame_action_usages t
94: where t.action_id = p_rec.action_id
95: and t.rule_id = p_rec.rule_id
96: and t.start_date =
97: ame_acu_shd.g_old_rec.start_date
98: and t.end_date = p_validation_start_date;
99: --
100: Cursor C_Sel2 Is
101: select created_by
132: --
133: -- Get the object version number for the insert
134: --
135: p_rec.object_version_number :=
136: ame_acu_shd.get_object_version_number
137: (p_action_id => p_rec.action_id
138: ,p_rule_id => p_rec.rule_id
139: );
140: --
232: Exception
233: When hr_api.check_integrity_violated Then
234: -- A check constraint has been violated
235: --
236: ame_acu_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When hr_api.unique_integrity_violated Then
239: -- Unique integrity has been violated
240: --
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When hr_api.unique_integrity_violated Then
239: -- Unique integrity has been violated
240: --
241: ame_acu_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When Others Then
244: --
245: Raise;
248: -- ----------------------------------------------------------------------------
249: -- |------------------------------< insert_dml >------------------------------|
250: -- ----------------------------------------------------------------------------
251: Procedure insert_dml
252: (p_rec in out nocopy ame_acu_shd.g_rec_type
253: ,p_effective_date in date
254: ,p_datetrack_mode in varchar2
255: ,p_validation_start_date in date
256: ,p_validation_end_date in date
311: --
312: -- {End Of Comments}
313: -- ----------------------------------------------------------------------------
314: Procedure pre_insert
315: (p_rec in out nocopy ame_acu_shd.g_rec_type
316: ,p_effective_date in date
317: ,p_datetrack_mode in varchar2
318: ,p_validation_start_date in date
319: ,p_validation_end_date in date
404: --
405: -- {End Of Comments}
406: -- ----------------------------------------------------------------------------
407: Procedure post_insert
408: (p_rec in ame_acu_shd.g_rec_type
409: ,p_effective_date in date
410: ,p_datetrack_mode in varchar2
411: ,p_validation_start_date in date
412: ,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_acu_shd.g_rec_type
493: ,p_validation_start_date out nocopy date
494: ,p_validation_end_date out nocopy date
495: ) is
496: --
550: -- |---------------------------------< ins >----------------------------------|
551: -- ----------------------------------------------------------------------------
552: Procedure ins
553: (p_effective_date in date
554: ,p_rec in out nocopy ame_acu_shd.g_rec_type
555: ) is
556: --
557: l_proc varchar2(72) := g_package||'ins';
558: l_datetrack_mode varchar2(30) := hr_api.g_insert;
632: ,p_end_date in out nocopy date
633: ,p_object_version_number out nocopy number
634: ) is
635: --
636: l_rec ame_acu_shd.g_rec_type;
637: l_proc varchar2(72) := g_package||'ins';
638: --
639: Begin
640: hr_utility.set_location('Entering:'||l_proc, 5);
642: -- Call conversion function to turn arguments into the
643: -- p_rec structure.
644: --
645: l_rec :=
646: ame_acu_shd.convert_args
647: (p_rule_id
648: ,p_action_id
649: ,p_start_date
650: ,p_end_date