[Home] [Help]
72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure dt_insert_dml
76: (p_rec in out nocopy ben_ejp_shd.g_rec_type,
77: p_effective_date in date,
78: p_datetrack_mode in varchar2,
79: p_validation_start_date in date,
80: p_validation_end_date in date) is
86: t.creation_date
87: from ben_elig_job_prte_f t
88: where t.elig_job_prte_id = p_rec.elig_job_prte_id
89: and t.effective_start_date =
90: ben_ejp_shd.g_old_rec.effective_start_date
91: and t.effective_end_date = (p_validation_start_date - 1);
92: --
93: l_proc varchar2(72) := g_package||'dt_insert_dml';
94: l_created_by ben_elig_job_prte_f.created_by%TYPE;
143: l_last_updated_by := fnd_global.user_id;
144: l_last_update_login := fnd_global.login_id;
145: End If;
146: --
147: ben_ejp_shd.g_api_dml := true; -- Set the api dml status
148: --
149: -- Insert the row into: ben_elig_job_prte_f
150: --
151: insert into ben_elig_job_prte_f
247: p_rec.criteria_weight
248:
249: );
250: --
251: ben_ejp_shd.g_api_dml := false; -- Unset the api dml status
252: hr_utility.set_location(' Leaving:'||l_proc, 15);
253: --
254: Exception
255: When hr_api.check_integrity_violated Then
253: --
254: Exception
255: When hr_api.check_integrity_violated Then
256: -- A check constraint has been violated
257: ben_ejp_shd.g_api_dml := false; -- Unset the api dml status
258: ben_ejp_shd.constraint_error
259: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
260: When hr_api.unique_integrity_violated Then
261: -- Unique integrity has been violated
254: Exception
255: When hr_api.check_integrity_violated Then
256: -- A check constraint has been violated
257: ben_ejp_shd.g_api_dml := false; -- Unset the api dml status
258: ben_ejp_shd.constraint_error
259: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
260: When hr_api.unique_integrity_violated Then
261: -- Unique integrity has been violated
262: ben_ejp_shd.g_api_dml := false; -- Unset the api dml status
258: ben_ejp_shd.constraint_error
259: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
260: When hr_api.unique_integrity_violated Then
261: -- Unique integrity has been violated
262: ben_ejp_shd.g_api_dml := false; -- Unset the api dml status
263: ben_ejp_shd.constraint_error
264: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
265: When Others Then
266: ben_ejp_shd.g_api_dml := false; -- Unset the api dml status
259: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
260: When hr_api.unique_integrity_violated Then
261: -- Unique integrity has been violated
262: ben_ejp_shd.g_api_dml := false; -- Unset the api dml status
263: ben_ejp_shd.constraint_error
264: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
265: When Others Then
266: ben_ejp_shd.g_api_dml := false; -- Unset the api dml status
267: Raise;
262: ben_ejp_shd.g_api_dml := false; -- Unset the api dml status
263: ben_ejp_shd.constraint_error
264: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
265: When Others Then
266: ben_ejp_shd.g_api_dml := false; -- Unset the api dml status
267: Raise;
268: End dt_insert_dml;
269: --
270: -- ----------------------------------------------------------------------------
270: -- ----------------------------------------------------------------------------
271: -- |------------------------------< insert_dml >------------------------------|
272: -- ----------------------------------------------------------------------------
273: Procedure insert_dml
274: (p_rec in out nocopy ben_ejp_shd.g_rec_type,
275: p_effective_date in date,
276: p_datetrack_mode in varchar2,
277: p_validation_start_date in date,
278: p_validation_end_date in date) is
330: --
331: -- {End Of Comments}
332: -- ----------------------------------------------------------------------------
333: Procedure pre_insert
334: (p_rec in out nocopy ben_ejp_shd.g_rec_type,
335: p_effective_date in date,
336: p_datetrack_mode in varchar2,
337: p_validation_start_date in date,
338: p_validation_end_date in date) is
419: --
420: -- {End Of Comments}
421: -- ----------------------------------------------------------------------------
422: Procedure post_insert
423: (p_rec in ben_ejp_shd.g_rec_type,
424: p_effective_date in date,
425: p_datetrack_mode in varchar2,
426: p_validation_start_date in date,
427: p_validation_end_date in date) is
541: -- ----------------------------------------------------------------------------
542: Procedure ins_lck
543: (p_effective_date in date,
544: p_datetrack_mode in varchar2,
545: p_rec in ben_ejp_shd.g_rec_type,
546: p_validation_start_date out nocopy date,
547: p_validation_end_date out nocopy date) is
548: --
549: l_proc varchar2(72) := g_package||'ins_lck';
582: -- |---------------------------------< ins >----------------------------------|
583: -- ----------------------------------------------------------------------------
584: Procedure ins
585: (
586: p_rec in out nocopy ben_ejp_shd.g_rec_type,
587: p_effective_date in date
588: ) is
589: --
590: l_proc varchar2(72) := g_package||'ins';
691: p_criteria_weight in number default null
692:
693: ) is
694: --
695: l_rec ben_ejp_shd.g_rec_type;
696: l_proc varchar2(72) := g_package||'ins';
697: --
698: Begin
699: hr_utility.set_location('Entering:'||l_proc, 5);
701: -- Call conversion function to turn arguments into the
702: -- p_rec structure.
703: --
704: l_rec :=
705: ben_ejp_shd.convert_args
706: (
707: null,
708: null,
709: null,