[Home] [Help]
79: --
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: Procedure dt_insert_dml
83: (p_rec in out nocopy ame_gcf_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_approval_group_config t
94: where t.approval_group_id = p_rec.approval_group_id
95: and t.application_id = p_rec.application_id
96: and t.start_date =
97: ame_gcf_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_gcf_shd.get_object_version_number
137: (p_approval_group_id => p_rec.approval_group_id
138: ,p_application_id => p_rec.application_id
139: );
140: --
226: Exception
227: When hr_api.check_integrity_violated Then
228: -- A check constraint has been violated
229: --
230: ame_gcf_shd.constraint_error
231: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
232: When hr_api.unique_integrity_violated Then
233: -- Unique integrity has been violated
234: --
231: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
232: When hr_api.unique_integrity_violated Then
233: -- Unique integrity has been violated
234: --
235: ame_gcf_shd.constraint_error
236: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
237: When Others Then
238: --
239: Raise;
242: -- ----------------------------------------------------------------------------
243: -- |------------------------------< insert_dml >------------------------------|
244: -- ----------------------------------------------------------------------------
245: Procedure insert_dml
246: (p_rec in out nocopy ame_gcf_shd.g_rec_type
247: ,p_effective_date in date
248: ,p_datetrack_mode in varchar2
249: ,p_validation_start_date in date
250: ,p_validation_end_date in date
369: --
370: -- {End Of Comments}
371: -- ----------------------------------------------------------------------------
372: Procedure pre_insert
373: (p_rec in out nocopy ame_gcf_shd.g_rec_type
374: ,p_effective_date in date
375: ,p_datetrack_mode in varchar2
376: ,p_validation_start_date in date
377: ,p_validation_end_date in date
476: --
477: -- {End Of Comments}
478: -- ----------------------------------------------------------------------------
479: Procedure post_insert
480: (p_rec in ame_gcf_shd.g_rec_type
481: ,p_effective_date in date
482: ,p_datetrack_mode in varchar2
483: ,p_validation_start_date in date
484: ,p_validation_end_date in date
564: -- ----------------------------------------------------------------------------
565: Procedure ins_lck
566: (p_effective_date in date
567: ,p_datetrack_mode in varchar2
568: ,p_rec in ame_gcf_shd.g_rec_type
569: ,p_validation_start_date out nocopy date
570: ,p_validation_end_date out nocopy date
571: ) is
572: --
626: -- |---------------------------------< ins >----------------------------------|
627: -- ----------------------------------------------------------------------------
628: Procedure ins
629: (p_effective_date in date
630: ,p_rec in out nocopy ame_gcf_shd.g_rec_type
631: ) is
632: --
633: l_proc varchar2(72) := g_package||'ins';
634: l_datetrack_mode varchar2(30) := hr_api.g_insert;
710: ,p_start_date out nocopy date
711: ,p_end_date out nocopy date
712: ) is
713: --
714: l_rec ame_gcf_shd.g_rec_type;
715: l_proc varchar2(72) := g_package||'ins';
716: --
717: Begin
718: hr_utility.set_location('Entering:'||l_proc, 5);
720: -- Call conversion function to turn arguments into the
721: -- p_rec structure.
722: --
723: l_rec :=
724: ame_gcf_shd.convert_args
725: (p_application_id
726: ,p_approval_group_id
727: ,p_voting_regime
728: ,p_order_number