[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pay_evc_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
90: t.creation_date
91: from pay_event_value_changes_f t
92: where t.event_value_change_id = p_rec.event_value_change_id
93: and t.effective_start_date =
94: pay_evc_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pay_event_value_changes_f.created_by%TYPE;
202: Exception
203: When hr_api.check_integrity_violated Then
204: -- A check constraint has been violated
205: --
206: pay_evc_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When hr_api.unique_integrity_violated Then
209: -- Unique integrity has been violated
210: --
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When hr_api.unique_integrity_violated Then
209: -- Unique integrity has been violated
210: --
211: pay_evc_shd.constraint_error
212: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
213: When Others Then
214: --
215: Raise;
266: -- ----------------------------------------------------------------------------
267: -- |------------------------------< insert_dml >------------------------------|
268: -- ----------------------------------------------------------------------------
269: Procedure insert_dml
270: (p_rec in out nocopy pay_evc_shd.g_rec_type
271: ,p_effective_date in date
272: ,p_datetrack_mode in varchar2
273: ,p_validation_start_date in date
274: ,p_validation_end_date in date
329: --
330: -- {End Of Comments}
331: -- ----------------------------------------------------------------------------
332: Procedure pre_insert
333: (p_rec in out nocopy pay_evc_shd.g_rec_type
334: ,p_effective_date in date
335: ,p_datetrack_mode in varchar2
336: ,p_validation_start_date in date
337: ,p_validation_end_date in date
421: --
422: -- {End Of Comments}
423: -- ----------------------------------------------------------------------------
424: Procedure post_insert
425: (p_rec in pay_evc_shd.g_rec_type
426: ,p_effective_date in date
427: ,p_datetrack_mode in varchar2
428: ,p_validation_start_date in date
429: ,p_validation_end_date in date
529: -- ----------------------------------------------------------------------------
530: Procedure ins_lck
531: (p_effective_date in date
532: ,p_datetrack_mode in varchar2
533: ,p_rec in pay_evc_shd.g_rec_type
534: ,p_validation_start_date out nocopy date
535: ,p_validation_end_date out nocopy date
536: ) is
537: --
572: -- |---------------------------------< ins >----------------------------------|
573: -- ----------------------------------------------------------------------------
574: Procedure ins
575: (p_effective_date in date
576: ,p_rec in out nocopy pay_evc_shd.g_rec_type
577: ) is
578: --
579: l_proc varchar2(72) := g_package||'ins';
580: l_datetrack_mode varchar2(30) := hr_api.g_insert;
663: ,p_effective_start_date out nocopy date
664: ,p_effective_end_date out nocopy date
665: ) is
666: --
667: l_rec pay_evc_shd.g_rec_type;
668: l_proc varchar2(72) := g_package||'ins';
669: --
670: Begin
671: hr_utility.set_location('Entering:'||l_proc, 5);
673: -- Call conversion function to turn arguments into the
674: -- p_rec structure.
675: --
676: l_rec :=
677: pay_evc_shd.convert_args
678: (null
679: ,null
680: ,null
681: ,p_event_qualifier_id