54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy ben_lpe_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) is
68: t.creation_date
69: from ben_ler_chg_pl_nip_enrt_f t
70: where t.ler_chg_pl_nip_enrt_id = p_rec.ler_chg_pl_nip_enrt_id
71: and t.effective_start_date =
72: ben_lpe_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_ler_chg_pl_nip_enrt_f.created_by%TYPE;
125: l_last_updated_by := fnd_global.user_id;
126: l_last_update_login := fnd_global.login_id;
127: End If;
128: --
129: ben_lpe_shd.g_api_dml := true; -- Set the api dml status
130: --
131: -- Insert the row into: ben_ler_chg_pl_nip_enrt_f
132: --
133: insert into ben_ler_chg_pl_nip_enrt_f
240: l_last_updated_by,
241: l_last_update_login
242: );
243: --
244: ben_lpe_shd.g_api_dml := false; -- Unset the api dml status
245: hr_utility.set_location(' Leaving:'||l_proc, 15);
246: --
247: Exception
248: When hr_api.check_integrity_violated Then
246: --
247: Exception
248: When hr_api.check_integrity_violated Then
249: -- A check constraint has been violated
250: ben_lpe_shd.g_api_dml := false; -- Unset the api dml status
251: ben_lpe_shd.constraint_error
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
253: When hr_api.unique_integrity_violated Then
254: -- Unique integrity has been violated
247: Exception
248: When hr_api.check_integrity_violated Then
249: -- A check constraint has been violated
250: ben_lpe_shd.g_api_dml := false; -- Unset the api dml status
251: ben_lpe_shd.constraint_error
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
253: When hr_api.unique_integrity_violated Then
254: -- Unique integrity has been violated
255: ben_lpe_shd.g_api_dml := false; -- Unset the api dml status
251: ben_lpe_shd.constraint_error
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
253: When hr_api.unique_integrity_violated Then
254: -- Unique integrity has been violated
255: ben_lpe_shd.g_api_dml := false; -- Unset the api dml status
256: ben_lpe_shd.constraint_error
257: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
258: When Others Then
259: ben_lpe_shd.g_api_dml := false; -- Unset the api dml status
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
253: When hr_api.unique_integrity_violated Then
254: -- Unique integrity has been violated
255: ben_lpe_shd.g_api_dml := false; -- Unset the api dml status
256: ben_lpe_shd.constraint_error
257: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
258: When Others Then
259: ben_lpe_shd.g_api_dml := false; -- Unset the api dml status
260: Raise;
255: ben_lpe_shd.g_api_dml := false; -- Unset the api dml status
256: ben_lpe_shd.constraint_error
257: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
258: When Others Then
259: ben_lpe_shd.g_api_dml := false; -- Unset the api dml status
260: Raise;
261: End dt_insert_dml;
262: --
263: -- ----------------------------------------------------------------------------
263: -- ----------------------------------------------------------------------------
264: -- |------------------------------< insert_dml >------------------------------|
265: -- ----------------------------------------------------------------------------
266: Procedure insert_dml
267: (p_rec in out nocopy ben_lpe_shd.g_rec_type,
268: p_effective_date in date,
269: p_datetrack_mode in varchar2,
270: p_validation_start_date in date,
271: p_validation_end_date in date) is
323: --
324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure pre_insert
327: (p_rec in out nocopy ben_lpe_shd.g_rec_type,
328: p_effective_date in date,
329: p_datetrack_mode in varchar2,
330: p_validation_start_date in date,
331: p_validation_end_date in date) is
379: --
380: -- {End Of Comments}
381: -- ----------------------------------------------------------------------------
382: Procedure post_insert
383: (p_rec in ben_lpe_shd.g_rec_type,
384: p_effective_date in date,
385: p_datetrack_mode in varchar2,
386: p_validation_start_date in date,
387: p_validation_end_date in date) is
506: -- ----------------------------------------------------------------------------
507: Procedure ins_lck
508: (p_effective_date in date,
509: p_datetrack_mode in varchar2,
510: p_rec in ben_lpe_shd.g_rec_type,
511: p_validation_start_date out nocopy date,
512: p_validation_end_date out nocopy date) is
513: --
514: l_proc varchar2(72) := g_package||'ins_lck';
547: -- |---------------------------------< ins >----------------------------------|
548: -- ----------------------------------------------------------------------------
549: Procedure ins
550: (
551: p_rec in out nocopy ben_lpe_shd.g_rec_type,
552: p_effective_date in date
553: ) is
554: --
555: l_proc varchar2(72) := g_package||'ins';
661: p_object_version_number out nocopy number,
662: p_effective_date in date
663: ) is
664: --
665: l_rec ben_lpe_shd.g_rec_type;
666: l_proc varchar2(72) := g_package||'ins';
667: --
668: Begin
669: hr_utility.set_location('Entering:'||l_proc, 5);
671: -- Call conversion function to turn arguments into the
672: -- p_rec structure.
673: --
674: l_rec :=
675: ben_lpe_shd.convert_args
676: (
677: null,
678: null,
679: null,