[Home] [Help]
79: --
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: Procedure dt_insert_dml
83: (p_rec in out nocopy ame_cfv_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_config_vars t
94: where t.application_id = p_rec.application_id
95: and t.variable_name = p_rec.variable_name
96: and t.start_date =
97: ame_cfv_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_cfv_shd.get_object_version_number
137: (p_application_id => p_rec.application_id
138: ,p_variable_name => p_rec.variable_name
139: );
140: --
228: Exception
229: When hr_api.check_integrity_violated Then
230: -- A check constraint has been violated
231: --
232: ame_cfv_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_cfv_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_cfv_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_cfv_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
408: --
409: -- {End Of Comments}
410: -- ----------------------------------------------------------------------------
411: Procedure post_insert
412: (p_rec in ame_cfv_shd.g_rec_type
413: ,p_effective_date in date
414: ,p_datetrack_mode in varchar2
415: ,p_validation_start_date in date
416: ,p_validation_end_date in date
498: -- ----------------------------------------------------------------------------
499: Procedure ins_lck
500: (p_effective_date in date
501: ,p_datetrack_mode in varchar2
502: ,p_rec in ame_cfv_shd.g_rec_type
503: ,p_validation_start_date out nocopy date
504: ,p_validation_end_date out nocopy date
505: ) is
506: --
531: -- |---------------------------------< ins >----------------------------------|
532: -- ----------------------------------------------------------------------------
533: Procedure ins
534: (p_effective_date in date
535: ,p_rec in out nocopy ame_cfv_shd.g_rec_type
536: ) is
537: --
538: l_proc varchar2(72) := g_package||'ins';
539: l_datetrack_mode varchar2(30) := hr_api.g_insert;
615: ,p_start_date out nocopy date
616: ,p_end_date out nocopy date
617: ) is
618: --
619: l_rec ame_cfv_shd.g_rec_type;
620: l_proc varchar2(72) := g_package||'ins';
621: --
622: Begin
623: hr_utility.set_location('Entering:'||l_proc, 5);
625: -- Call conversion function to turn arguments into the
626: -- p_rec structure.
627: --
628: l_rec :=
629: ame_cfv_shd.convert_args
630: (p_application_id
631: ,p_variable_name
632: ,p_variable_value
633: ,null