[Home] [Help]
79: --
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: Procedure dt_insert_dml
83: (p_rec in out nocopy ame_stv_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_string_values t
94: where t.condition_id = p_rec.condition_id
95: and t.string_value = p_rec.string_value
96: and t.start_date =
97: ame_stv_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_stv_shd.get_object_version_number
137: (p_condition_id => p_rec.condition_id
138: ,p_string_value => p_rec.string_value
139: );
140: --
224: Exception
225: When hr_api.check_integrity_violated Then
226: -- A check constraint has been violated
227: --
228: ame_stv_shd.constraint_error
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated
232: --
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated
232: --
233: ame_stv_shd.constraint_error
234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When Others Then
236: --
237: Raise;
240: -- ----------------------------------------------------------------------------
241: -- |------------------------------< insert_dml >------------------------------|
242: -- ----------------------------------------------------------------------------
243: Procedure insert_dml
244: (p_rec in out nocopy ame_stv_shd.g_rec_type
245: ,p_effective_date in date
246: ,p_datetrack_mode in varchar2
247: ,p_validation_start_date in date
248: ,p_validation_end_date in date
303: --
304: -- {End Of Comments}
305: -- ----------------------------------------------------------------------------
306: Procedure pre_insert
307: (p_rec in out nocopy ame_stv_shd.g_rec_type
308: ,p_effective_date in date
309: ,p_datetrack_mode in varchar2
310: ,p_validation_start_date in date
311: ,p_validation_end_date in date
404: --
405: -- {End Of Comments}
406: -- ----------------------------------------------------------------------------
407: Procedure post_insert
408: (p_rec in ame_stv_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
490: -- ----------------------------------------------------------------------------
491: Procedure ins_lck
492: (p_effective_date in date
493: ,p_datetrack_mode in varchar2
494: ,p_rec in ame_stv_shd.g_rec_type
495: ,p_validation_start_date out nocopy date
496: ,p_validation_end_date out nocopy date
497: ) is
498: --
543: -- |---------------------------------< ins >----------------------------------|
544: -- ----------------------------------------------------------------------------
545: Procedure ins
546: (p_effective_date in date
547: ,p_rec in out nocopy ame_stv_shd.g_rec_type
548: ) is
549: --
550: l_proc varchar2(72) := g_package||'ins';
551: l_datetrack_mode varchar2(30) := hr_api.g_insert;
626: ,p_start_date out nocopy date
627: ,p_end_date out nocopy date
628: ) is
629: --
630: l_rec ame_stv_shd.g_rec_type;
631: l_proc varchar2(72) := g_package||'ins';
632: --
633: Begin
634: hr_utility.set_location('Entering:'||l_proc, 5);
636: -- Call conversion function to turn arguments into the
637: -- p_rec structure.
638: --
639: l_rec :=
640: ame_stv_shd.convert_args
641: (p_condition_id
642: ,p_string_value
643: ,null
644: ,null