[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy ame_aca_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_calling_apps t
91: where t.application_id = p_rec.application_id
92: and t.start_date =
93: ame_aca_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_aca_shd.get_object_version_number
132: (p_application_id => p_rec.application_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_aca_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_aca_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_aca_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_aca_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_aca_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_aca_shd.g_rec_type
494: ,p_validation_start_date out nocopy date
495: ,p_validation_end_date out nocopy date
496: ) is
497: --
522: -- |---------------------------------< ins >----------------------------------|
523: -- ----------------------------------------------------------------------------
524: Procedure ins
525: (p_effective_date in date
526: ,p_rec in out nocopy ame_aca_shd.g_rec_type
527: ) is
528: --
529: l_proc varchar2(72) := g_package||'ins';
530: l_datetrack_mode varchar2(30) := hr_api.g_insert;
608: ,p_start_date out nocopy date
609: ,p_end_date out nocopy date
610: ) is
611: --
612: l_rec ame_aca_shd.g_rec_type;
613: l_proc varchar2(72) := g_package||'ins';
614: --
615: Begin
616: hr_utility.set_location('Entering:'||l_proc, 5);
618: -- Call conversion function to turn arguments into the
619: -- p_rec structure.
620: --
621: l_rec :=
622: ame_aca_shd.convert_args
623: (p_fnd_application_id
624: ,p_application_name
625: ,p_transaction_type_id
626: ,null