[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy ame_atr_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_attributes t
91: where t.attribute_id = p_rec.attribute_id
92: and t.start_date =
93: ame_atr_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_atr_shd.get_object_version_number
132: (p_attribute_id => p_rec.attribute_id
133: );
134: --
135: -- Select the 'old' created values
228: Exception
229: When hr_api.check_integrity_violated Then
230: -- A check constraint has been violated
231: --
232: ame_atr_shd.constraint_error
233: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
234: When hr_api.unique_integrity_violated Then
235: -- Unique integrity has been violated
236: --
233: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
234: When hr_api.unique_integrity_violated Then
235: -- Unique integrity has been violated
236: --
237: ame_atr_shd.constraint_error
238: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
239: When Others Then
240: --
241: Raise;
244: -- ----------------------------------------------------------------------------
245: -- |------------------------------< insert_dml >------------------------------|
246: -- ----------------------------------------------------------------------------
247: Procedure insert_dml
248: (p_rec in out nocopy ame_atr_shd.g_rec_type
249: ,p_effective_date in date
250: ,p_datetrack_mode in varchar2
251: ,p_validation_start_date in date
252: ,p_validation_end_date in date
307: --
308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure pre_insert
311: (p_rec in out nocopy ame_atr_shd.g_rec_type
312: ,p_effective_date in date
313: ,p_datetrack_mode in varchar2
314: ,p_validation_start_date in date
315: ,p_validation_end_date in date
401: --
402: -- {End Of Comments}
403: -- ----------------------------------------------------------------------------
404: Procedure post_insert
405: (p_rec in ame_atr_shd.g_rec_type
406: ,p_effective_date in date
407: ,p_datetrack_mode in varchar2
408: ,p_validation_start_date in date
409: ,p_validation_end_date in date
497: -- ----------------------------------------------------------------------------
498: Procedure ins_lck
499: (p_effective_date in date
500: ,p_datetrack_mode in varchar2
501: ,p_rec in ame_atr_shd.g_rec_type
502: ,p_validation_start_date out nocopy date
503: ,p_validation_end_date out nocopy date
504: ) is
505: --
530: -- |---------------------------------< ins >----------------------------------|
531: -- ----------------------------------------------------------------------------
532: Procedure ins
533: (p_effective_date in date
534: ,p_rec in out nocopy ame_atr_shd.g_rec_type
535: ) is
536: --
537: l_proc varchar2(72) := g_package||'ins';
538: l_datetrack_mode varchar2(30) := hr_api.g_insert;
618: ,p_start_date out nocopy date
619: ,p_end_date out nocopy date
620: ) is
621: --
622: l_rec ame_atr_shd.g_rec_type;
623: l_proc varchar2(72) := g_package||'ins';
624: --
625: Begin
626: hr_utility.set_location('Entering:'||l_proc, 5);
628: -- Call conversion function to turn arguments into the
629: -- p_rec structure.
630: --
631: l_rec :=
632: ame_atr_shd.convert_args
633: (null
634: ,p_name
635: ,p_attribute_type
636: ,p_line_item