[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy ame_gpi_shd.g_rec_type
81: ,p_effective_date in date
82: ,p_datetrack_mode in varchar2
83: ,p_validation_start_date in date
84: ,p_validation_end_date in date
89: select t.creation_date
90: from ame_approval_group_items t
91: where t.approval_group_item_id = p_rec.approval_group_item_id
92: and t.start_date =
93: ame_gpi_shd.g_old_rec.start_date
94: and t.end_date = p_validation_start_date;
95: --
96: Cursor C_Sel2 Is
97: select created_by
127: --
128: -- Get the object version number for the insert
129: --
130: p_rec.object_version_number :=
131: ame_gpi_shd.get_object_version_number
132: (p_approval_group_item_id => p_rec.approval_group_item_id
133: );
134: --
135: -- Select the 'old' created values
224: Exception
225: When hr_api.check_integrity_violated Then
226: -- A check constraint has been violated
227: --
228: ame_gpi_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_gpi_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_gpi_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_gpi_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
397: --
398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: Procedure post_insert
401: (p_rec in ame_gpi_shd.g_rec_type
402: ,p_effective_date in date
403: ,p_datetrack_mode in varchar2
404: ,p_validation_start_date in date
405: ,p_validation_end_date in date
489: -- ----------------------------------------------------------------------------
490: Procedure ins_lck
491: (p_effective_date in date
492: ,p_datetrack_mode in varchar2
493: ,p_rec in ame_gpi_shd.g_rec_type
494: ,p_validation_start_date out nocopy date
495: ,p_validation_end_date out nocopy date
496: ) is
497: --
539: -- |---------------------------------< ins >----------------------------------|
540: -- ----------------------------------------------------------------------------
541: Procedure ins
542: (p_effective_date in date
543: ,p_rec in out nocopy ame_gpi_shd.g_rec_type
544: ) is
545: --
546: l_proc varchar2(72) := g_package||'ins';
547: l_datetrack_mode varchar2(30) := hr_api.g_insert;
625: ,p_start_date out nocopy date
626: ,p_end_date out nocopy date
627: ) is
628: --
629: l_rec ame_gpi_shd.g_rec_type;
630: l_proc varchar2(72) := g_package||'ins';
631: --
632: Begin
633: hr_utility.set_location('Entering:'||l_proc, 5);
635: -- Call conversion function to turn arguments into the
636: -- p_rec structure.
637: --
638: l_rec :=
639: ame_gpi_shd.convert_args
640: (null
641: ,p_approval_group_id
642: ,p_parameter_name
643: ,p_parameter