[Home] [Help]
79: --
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: Procedure dt_insert_dml
83: (p_rec in out nocopy ame_atu_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_attribute_usages t
94: where t.attribute_id = p_rec.attribute_id
95: and t.application_id = p_rec.application_id
96: and t.start_date =
97: ame_atu_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_atu_shd.get_object_version_number
137: (p_attribute_id => p_rec.attribute_id
138: ,p_application_id => p_rec.application_id
139: );
140: --
234: Exception
235: When hr_api.check_integrity_violated Then
236: -- A check constraint has been violated
237: --
238: ame_atu_shd.constraint_error
239: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
240: When hr_api.unique_integrity_violated Then
241: -- Unique integrity has been violated
242: --
239: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
240: When hr_api.unique_integrity_violated Then
241: -- Unique integrity has been violated
242: --
243: ame_atu_shd.constraint_error
244: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
245: When Others Then
246: --
247: Raise;
250: -- ----------------------------------------------------------------------------
251: -- |------------------------------< insert_dml >------------------------------|
252: -- ----------------------------------------------------------------------------
253: Procedure insert_dml
254: (p_rec in out nocopy ame_atu_shd.g_rec_type
255: ,p_effective_date in date
256: ,p_datetrack_mode in varchar2
257: ,p_validation_start_date in date
258: ,p_validation_end_date in date
313: --
314: -- {End Of Comments}
315: -- ----------------------------------------------------------------------------
316: Procedure pre_insert
317: (p_rec in out nocopy ame_atu_shd.g_rec_type
318: ,p_effective_date in date
319: ,p_datetrack_mode in varchar2
320: ,p_validation_start_date in date
321: ,p_validation_end_date in date
401: --
402: -- {End Of Comments}
403: -- ----------------------------------------------------------------------------
404: Procedure post_insert
405: (p_rec in ame_atu_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
497: -- ----------------------------------------------------------------------------
498: Procedure ins_lck
499: (p_effective_date in date
500: ,p_datetrack_mode in varchar2
501: ,p_rec in ame_atu_shd.g_rec_type
502: ,p_validation_start_date out nocopy date
503: ,p_validation_end_date out nocopy date
504: ) is
505: --
546: -- |---------------------------------< ins >----------------------------------|
547: -- ----------------------------------------------------------------------------
548: Procedure ins
549: (p_effective_date in date
550: ,p_rec in out nocopy ame_atu_shd.g_rec_type
551: ) is
552: --
553: l_proc varchar2(72) := g_package||'ins';
554: l_datetrack_mode varchar2(30) := hr_api.g_insert;
639: ,p_start_date out nocopy date
640: ,p_end_date out nocopy date
641: ) is
642: --
643: l_rec ame_atu_shd.g_rec_type;
644: l_proc varchar2(72) := g_package||'ins';
645: --
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);
649: -- Call conversion function to turn arguments into the
650: -- p_rec structure.
651: --
652: l_rec :=
653: ame_atu_shd.convert_args
654: (p_attribute_id
655: ,p_application_id
656: ,p_query_string
657: ,p_use_count