[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy hr_cle_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 hr_de_soc_ins_contr_lvls_f t
92: where t.soc_ins_contr_lvls_id = p_rec.soc_ins_contr_lvls_id
93: and t.effective_start_date =
94: hr_cle_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 hr_de_soc_ins_contr_lvls_f.created_by%TYPE;
282: Exception
283: When hr_api.check_integrity_violated Then
284: -- A check constraint has been violated
285: --
286: hr_cle_shd.constraint_error
287: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
288: When hr_api.unique_integrity_violated Then
289: -- Unique integrity has been violated
290: --
287: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
288: When hr_api.unique_integrity_violated Then
289: -- Unique integrity has been violated
290: --
291: hr_cle_shd.constraint_error
292: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
293: When Others Then
294: --
295: Raise;
298: -- ----------------------------------------------------------------------------
299: -- |------------------------------< insert_dml >------------------------------|
300: -- ----------------------------------------------------------------------------
301: Procedure insert_dml
302: (p_rec in out nocopy hr_cle_shd.g_rec_type
303: ,p_effective_date in date
304: ,p_datetrack_mode in varchar2
305: ,p_validation_start_date in date
306: ,p_validation_end_date in date
361: --
362: -- {End Of Comments}
363: -- ----------------------------------------------------------------------------
364: Procedure pre_insert
365: (p_rec in out nocopy hr_cle_shd.g_rec_type
366: ,p_effective_date in date
367: ,p_datetrack_mode in varchar2
368: ,p_validation_start_date in date
369: ,p_validation_end_date in date
453: --
454: -- {End Of Comments}
455: -- ----------------------------------------------------------------------------
456: Procedure post_insert
457: (p_rec in hr_cle_shd.g_rec_type
458: ,p_effective_date in date
459: ,p_datetrack_mode in varchar2
460: ,p_validation_start_date in date
461: ,p_validation_end_date in date
635: -- ----------------------------------------------------------------------------
636: Procedure ins_lck
637: (p_effective_date in date
638: ,p_datetrack_mode in varchar2
639: ,p_rec in hr_cle_shd.g_rec_type
640: ,p_validation_start_date out nocopy date
641: ,p_validation_end_date out nocopy date
642: ) is
643: --
675: -- |---------------------------------< ins >----------------------------------|
676: -- ----------------------------------------------------------------------------
677: Procedure ins
678: (p_effective_date in date
679: ,p_rec in out nocopy hr_cle_shd.g_rec_type
680: ) is
681: --
682: l_proc varchar2(72) := g_package||'ins';
683: l_datetrack_mode varchar2(30) := hr_api.g_insert;
800: ,p_effective_start_date out nocopy date
801: ,p_effective_end_date out nocopy date
802: ) is
803: --
804: l_rec hr_cle_shd.g_rec_type;
805: l_proc varchar2(72) := g_package||'ins';
806: --
807: Begin
808: hr_utility.set_location('Entering:'||l_proc, 5);
810: -- Call conversion function to turn arguments into the
811: -- p_rec structure.
812: --
813: l_rec :=
814: hr_cle_shd.convert_args
815: (null
816: ,p_organization_id
817: ,p_normal_percentage
818: ,p_normal_amount