[Home] [Help]
79: --
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: Procedure dt_insert_dml
83: (p_rec in out nocopy ame_cnu_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_condition_usages t
94: where t.condition_id = p_rec.condition_id
95: and t.rule_id = p_rec.rule_id
96: and t.start_date =
97: ame_cnu_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_cnu_shd.get_object_version_number
137: (p_condition_id => p_rec.condition_id
138: ,p_rule_id => p_rec.rule_id
139: );
140: --
236: Exception
237: When hr_api.check_integrity_violated Then
238: -- A check constraint has been violated
239: --
240: ame_cnu_shd.constraint_error
241: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
242: When hr_api.unique_integrity_violated Then
243: -- Unique integrity has been violated
244: --
241: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
242: When hr_api.unique_integrity_violated Then
243: -- Unique integrity has been violated
244: --
245: ame_cnu_shd.constraint_error
246: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
247: When Others Then
248: --
249: Raise;
252: -- ----------------------------------------------------------------------------
253: -- |------------------------------< insert_dml >------------------------------|
254: -- ----------------------------------------------------------------------------
255: Procedure insert_dml
256: (p_rec in out nocopy ame_cnu_shd.g_rec_type
257: ,p_effective_date in date
258: ,p_datetrack_mode in varchar2
259: ,p_validation_start_date in date
260: ,p_validation_end_date in date
315: --
316: -- {End Of Comments}
317: -- ----------------------------------------------------------------------------
318: Procedure pre_insert
319: (p_rec in out nocopy ame_cnu_shd.g_rec_type
320: ,p_effective_date in date
321: ,p_datetrack_mode in varchar2
322: ,p_validation_start_date in date
323: ,p_validation_end_date in date
408: --
409: -- {End Of Comments}
410: -- ----------------------------------------------------------------------------
411: Procedure post_insert
412: (p_rec in ame_cnu_shd.g_rec_type
413: ,p_effective_date in date
414: ,p_datetrack_mode in varchar2
415: ,p_validation_start_date in date
416: ,p_validation_end_date in date
494: -- ----------------------------------------------------------------------------
495: Procedure ins_lck
496: (p_effective_date in date
497: ,p_datetrack_mode in varchar2
498: ,p_rec in ame_cnu_shd.g_rec_type
499: ,p_validation_start_date out nocopy date
500: ,p_validation_end_date out nocopy date
501: ) is
502: --
555: -- |---------------------------------< ins >----------------------------------|
556: -- ----------------------------------------------------------------------------
557: Procedure ins
558: (p_effective_date in date
559: ,p_rec in out nocopy ame_cnu_shd.g_rec_type
560: ) is
561: --
562: l_proc varchar2(72) := g_package||'ins';
563: l_datetrack_mode varchar2(30) := hr_api.g_insert;
638: ,p_end_date in out nocopy date
639: ,p_object_version_number out nocopy number
640: ) is
641: --
642: l_rec ame_cnu_shd.g_rec_type;
643: l_proc varchar2(72) := g_package||'ins';
644: --
645: Begin
646: hr_utility.set_location('Entering:'||l_proc, 5);
648: -- Call conversion function to turn arguments into the
649: -- p_rec structure.
650: --
651: l_rec :=
652: ame_cnu_shd.convert_args
653: (p_rule_id
654: ,p_condition_id
655: ,p_start_date
656: ,p_end_date