[Home] [Help]
139: --
140: -- {End Of Comments}
141: -- ----------------------------------------------------------------------------
142: Procedure dt_insert_dml
143: (p_rec in out nocopy ame_con_shd.g_rec_type
144: ,p_effective_date in date
145: ,p_datetrack_mode in varchar2
146: ,p_validation_start_date in date
147: ,p_validation_end_date in date
152: select t.creation_date
153: from ame_conditions t
154: where t.condition_id = p_rec.condition_id
155: and t.start_date =
156: ame_con_shd.g_old_rec.start_date
157: and t.end_date = p_validation_start_date;
158: --
159: Cursor C_Sel2 Is
160: select created_by
190: --
191: -- Get the object version number for the insert
192: --
193: p_rec.object_version_number :=
194: ame_con_shd.get_object_version_number
195: (p_condition_id => p_rec.condition_id
196: );
197: --
198: -- Select the 'old' created values
295: Exception
296: When hr_api.check_integrity_violated Then
297: -- A check constraint has been violated
298: --
299: ame_con_shd.constraint_error
300: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
301: When hr_api.unique_integrity_violated Then
302: -- Unique integrity has been violated
303: --
300: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
301: When hr_api.unique_integrity_violated Then
302: -- Unique integrity has been violated
303: --
304: ame_con_shd.constraint_error
305: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
306: When Others Then
307: --
308: Raise;
311: -- ----------------------------------------------------------------------------
312: -- |------------------------------< insert_dml >------------------------------|
313: -- ----------------------------------------------------------------------------
314: Procedure insert_dml
315: (p_rec in out nocopy ame_con_shd.g_rec_type
316: ,p_effective_date in date
317: ,p_datetrack_mode in varchar2
318: ,p_validation_start_date in date
319: ,p_validation_end_date in date
374: --
375: -- {End Of Comments}
376: -- ----------------------------------------------------------------------------
377: Procedure pre_insert
378: (p_rec in out nocopy ame_con_shd.g_rec_type
379: ,p_effective_date in date
380: ,p_datetrack_mode in varchar2
381: ,p_validation_start_date in date
382: ,p_validation_end_date in date
471: --
472: -- {End Of Comments}
473: -- ----------------------------------------------------------------------------
474: Procedure post_insert
475: (p_rec in ame_con_shd.g_rec_type
476: ,p_effective_date in date
477: ,p_datetrack_mode in varchar2
478: ,p_validation_start_date in date
479: ,p_validation_end_date in date
571: -- ----------------------------------------------------------------------------
572: Procedure ins_lck
573: (p_effective_date in date
574: ,p_datetrack_mode in varchar2
575: ,p_rec in ame_con_shd.g_rec_type
576: ,p_validation_start_date out nocopy date
577: ,p_validation_end_date out nocopy date
578: ) is
579: --
604: -- |---------------------------------< ins >----------------------------------|
605: -- ----------------------------------------------------------------------------
606: Procedure ins
607: (p_effective_date in date
608: ,p_rec in out nocopy ame_con_shd.g_rec_type
609: ) is
610: --
611: l_proc varchar2(72) := g_package||'ins';
612: l_datetrack_mode varchar2(30) := hr_api.g_insert;
700: ,p_start_date out nocopy date
701: ,p_end_date out nocopy date
702: ) is
703: --
704: l_rec ame_con_shd.g_rec_type;
705: l_proc varchar2(72) := g_package||'ins';
706: --
707: Begin
708: hr_utility.set_location('Entering:'||l_proc, 5);
710: -- Call conversion function to turn arguments into the
711: -- p_rec structure.
712: --
713: l_rec :=
714: ame_con_shd.convert_args
715: (null
716: ,p_condition_type
717: ,p_attribute_id
718: ,p_parameter_one