[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy ben_vep_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date
68: t.creation_date
69: from BEN_VRBL_RT_ELIG_PRFL_f t
70: where t.vrbl_rt_elig_prfl_id = p_rec.vrbl_rt_elig_prfl_id
71: and t.effective_start_date =
72: ben_vep_shd.g_old_rec.effective_start_date
73: and t.effective_end_date = (p_validation_start_date - 1);
74: --
75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by BEN_VRBL_RT_ELIG_PRFL_f.created_by%TYPE;
126: l_last_updated_by := fnd_global.user_id;
127: l_last_update_login := fnd_global.login_id;
128: End If;
129: --
130: ben_vep_shd.g_api_dml := true; -- Set the api dml status
131: --
132: -- Insert the row into: BEN_VRBL_RT_ELIG_PRFL_f
133: --
134: insert into BEN_VRBL_RT_ELIG_PRFL_f
223: ,l_last_updated_by
224: ,l_last_update_login
225: );
226: --
227: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
228: hr_utility.set_location(' Leaving:'||l_proc, 15);
229: --
230: Exception
231: When hr_api.check_integrity_violated Then
229: --
230: Exception
231: When hr_api.check_integrity_violated Then
232: -- A check constraint has been violated
233: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
234: ben_vep_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
230: Exception
231: When hr_api.check_integrity_violated Then
232: -- A check constraint has been violated
233: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
234: ben_vep_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
234: ben_vep_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
239: ben_vep_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When Others Then
242: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
239: ben_vep_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When Others Then
242: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
243: Raise;
238: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
239: ben_vep_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When Others Then
242: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
243: Raise;
244: End dt_insert_dml;
245: --
246: -- ----------------------------------------------------------------------------
246: -- ----------------------------------------------------------------------------
247: -- |------------------------------< insert_dml >------------------------------|
248: -- ----------------------------------------------------------------------------
249: Procedure insert_dml
250: (p_rec in out nocopy ben_vep_shd.g_rec_type
251: ,p_effective_date in date
252: ,p_datetrack_mode in varchar2
253: ,p_validation_start_date in date
254: ,p_validation_end_date in date
309: --
310: -- {End Of Comments}
311: -- ----------------------------------------------------------------------------
312: Procedure pre_insert
313: (p_rec in out nocopy ben_vep_shd.g_rec_type
314: ,p_effective_date in date
315: ,p_datetrack_mode in varchar2
316: ,p_validation_start_date in date
317: ,p_validation_end_date in date
367: --
368: -- {End Of Comments}
369: -- ----------------------------------------------------------------------------
370: Procedure post_insert
371: (p_rec in ben_vep_shd.g_rec_type
372: ,p_effective_date in date
373: ,p_datetrack_mode in varchar2
374: ,p_validation_start_date in date
375: ,p_validation_end_date in date
519: -- ----------------------------------------------------------------------------
520: Procedure ins_lck
521: (p_effective_date in date
522: ,p_datetrack_mode in varchar2
523: ,p_rec in ben_vep_shd.g_rec_type
524: ,p_validation_start_date out nocopy date
525: ,p_validation_end_date out nocopy date
526: ) is
527: --
565: -- |---------------------------------< ins >----------------------------------|
566: -- ----------------------------------------------------------------------------
567: Procedure ins
568: (p_effective_date in date
569: ,p_rec in out nocopy ben_vep_shd.g_rec_type
570: ) is
571: --
572: l_proc varchar2(72) := g_package||'ins';
573: l_datetrack_mode varchar2(30) := hr_api.g_insert;
675: ,p_effective_start_date out nocopy date
676: ,p_effective_end_date out nocopy date
677: ) is
678: --
679: l_rec ben_vep_shd.g_rec_type;
680: l_proc varchar2(72) := g_package||'ins';
681: --
682: Begin
683: hr_utility.set_location('Entering:'||l_proc, 5);
685: -- Call conversion function to turn arguments into the
686: -- p_rec structure.
687: --
688: l_rec :=
689: ben_vep_shd.convert_args
690: (null
691: ,null
692: ,null
693: ,p_business_group_id