[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy ben_esw_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 ben_elig_scre_wtg_f t
92: where t.elig_scre_wtg_id = p_rec.elig_scre_wtg_id
93: and t.effective_start_date =
94: ben_esw_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 ben_elig_scre_wtg_f.created_by%TYPE;
198: Exception
199: When hr_api.check_integrity_violated Then
200: -- A check constraint has been violated
201: --
202: ben_esw_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.unique_integrity_violated Then
205: -- Unique integrity has been violated
206: --
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.unique_integrity_violated Then
205: -- Unique integrity has been violated
206: --
207: ben_esw_shd.constraint_error
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When Others Then
210: --
211: Raise;
214: -- ----------------------------------------------------------------------------
215: -- |------------------------------< insert_dml >------------------------------|
216: -- ----------------------------------------------------------------------------
217: Procedure insert_dml
218: (p_rec in out nocopy ben_esw_shd.g_rec_type
219: ,p_effective_date in date
220: ,p_datetrack_mode in varchar2
221: ,p_validation_start_date in date
222: ,p_validation_end_date in date
277: --
278: -- {End Of Comments}
279: -- ----------------------------------------------------------------------------
280: Procedure pre_insert
281: (p_rec in out nocopy ben_esw_shd.g_rec_type
282: ,p_effective_date in date
283: ,p_datetrack_mode in varchar2
284: ,p_validation_start_date in date
285: ,p_validation_end_date in date
369: --
370: -- {End Of Comments}
371: -- ----------------------------------------------------------------------------
372: Procedure post_insert
373: (p_rec in ben_esw_shd.g_rec_type
374: ,p_effective_date in date
375: ,p_datetrack_mode in varchar2
376: ,p_validation_start_date in date
377: ,p_validation_end_date in date
469: -- ----------------------------------------------------------------------------
470: Procedure ins_lck
471: (p_effective_date in date
472: ,p_datetrack_mode in varchar2
473: ,p_rec in ben_esw_shd.g_rec_type
474: ,p_validation_start_date out nocopy date
475: ,p_validation_end_date out nocopy date
476: ) is
477: --
509: -- |---------------------------------< ins >----------------------------------|
510: -- ----------------------------------------------------------------------------
511: Procedure ins
512: (p_effective_date in date
513: ,p_rec in out nocopy ben_esw_shd.g_rec_type
514: ) is
515: --
516: l_proc varchar2(72) := g_package||'ins';
517: l_datetrack_mode varchar2(30) := hr_api.g_insert;
599: ,p_effective_start_date out nocopy date
600: ,p_effective_end_date out nocopy date
601: ) is
602: --
603: l_rec ben_esw_shd.g_rec_type;
604: l_proc varchar2(72) := g_package||'ins';
605: --
606: Begin
607: hr_utility.set_location('Entering:'||l_proc, 5);
609: -- Call conversion function to turn arguments into the
610: -- p_rec structure.
611: --
612: l_rec :=
613: ben_esw_shd.convert_args
614: (null
615: ,p_elig_per_id
616: ,p_elig_per_opt_id
617: ,p_elig_rslt_id