[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy ame_apt_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
88: Cursor C_Sel1 Is
89: select t.creation_date
90: from ame_approver_types t
91: where t.approver_type_id = p_rec.approver_type_id
92: and t.start_date = ame_apt_shd.g_old_rec.start_date
93: and t.end_date = p_validation_start_date;
94: --
95: Cursor C_Sel2 Is
96: select created_by
126: --
127: -- Get the object version number for the insert
128: --
129: p_rec.object_version_number :=
130: ame_apt_shd.get_object_version_number
131: (p_approver_type_id => p_rec.approver_type_id
132: );
133: --
134: -- Select the 'old' created values
234: Exception
235: When hr_api.check_integrity_violated Then
236: -- A check constraint has been violated
237: --
238: ame_apt_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_apt_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_apt_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_apt_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
405: --
406: -- {End Of Comments}
407: -- ----------------------------------------------------------------------------
408: Procedure post_insert
409: (p_rec in ame_apt_shd.g_rec_type
410: ,p_effective_date in date
411: ,p_datetrack_mode in varchar2
412: ,p_validation_start_date in date
413: ,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_apt_shd.g_rec_type
495: ,p_validation_start_date out nocopy date
496: ,p_validation_end_date out nocopy date
497: ) is
498: --
520: -- |---------------------------------< ins >----------------------------------|
521: -- ----------------------------------------------------------------------------
522: Procedure ins
523: (p_effective_date in date
524: ,p_rec in out nocopy ame_apt_shd.g_rec_type
525: ) is
526: --
527: l_proc varchar2(72) := g_package||'ins';
528: l_datetrack_mode varchar2(30) := hr_api.g_insert;
613: ,p_end_date out nocopy date
614: ,p_object_version_number out nocopy number
615: ) is
616: --
617: l_rec ame_apt_shd.g_rec_type;
618: l_proc varchar2(72) := g_package||'ins';
619: --
620: Begin
621: hr_utility.set_location('Entering:'||l_proc, 5);
623: -- Call conversion function to turn arguments into the
624: -- p_rec structure.
625: --
626: l_rec :=
627: ame_apt_shd.convert_args
628: (null
629: ,p_orig_system
630: ,p_query_variable_1_label
631: ,p_query_variable_2_label