[Home] [Help]
76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy ben_eps_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) is
90: t.creation_date
91: from ben_elig_pstn_prte_f t
92: where t.elig_pstn_prte_id = p_rec.elig_pstn_prte_id
93: and t.effective_start_date =
94: ben_eps_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_pstn_prte_f.created_by%TYPE;
147: l_last_updated_by := fnd_global.user_id;
148: l_last_update_login := fnd_global.login_id;
149: End If;
150: --
151: ben_eps_shd.g_api_dml := true; -- Set the api dml status
152: --
153: -- Insert the row into: ben_elig_pstn_prte_f
154: --
155: insert into ben_elig_pstn_prte_f
250: p_rec.criteria_score,
251: p_rec.criteria_weight
252: );
253: --
254: ben_eps_shd.g_api_dml := false; -- Unset the api dml status
255: hr_utility.set_location(' Leaving:'||l_proc, 15);
256: --
257: Exception
258: When hr_api.check_integrity_violated Then
256: --
257: Exception
258: When hr_api.check_integrity_violated Then
259: -- A check constraint has been violated
260: ben_eps_shd.g_api_dml := false; -- Unset the api dml status
261: ben_eps_shd.constraint_error
262: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
263: When hr_api.unique_integrity_violated Then
264: -- Unique integrity has been violated
257: Exception
258: When hr_api.check_integrity_violated Then
259: -- A check constraint has been violated
260: ben_eps_shd.g_api_dml := false; -- Unset the api dml status
261: ben_eps_shd.constraint_error
262: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
263: When hr_api.unique_integrity_violated Then
264: -- Unique integrity has been violated
265: ben_eps_shd.g_api_dml := false; -- Unset the api dml status
261: ben_eps_shd.constraint_error
262: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
263: When hr_api.unique_integrity_violated Then
264: -- Unique integrity has been violated
265: ben_eps_shd.g_api_dml := false; -- Unset the api dml status
266: ben_eps_shd.constraint_error
267: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
268: When Others Then
269: ben_eps_shd.g_api_dml := false; -- Unset the api dml status
262: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
263: When hr_api.unique_integrity_violated Then
264: -- Unique integrity has been violated
265: ben_eps_shd.g_api_dml := false; -- Unset the api dml status
266: ben_eps_shd.constraint_error
267: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
268: When Others Then
269: ben_eps_shd.g_api_dml := false; -- Unset the api dml status
270: Raise;
265: ben_eps_shd.g_api_dml := false; -- Unset the api dml status
266: ben_eps_shd.constraint_error
267: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
268: When Others Then
269: ben_eps_shd.g_api_dml := false; -- Unset the api dml status
270: Raise;
271: End dt_insert_dml;
272: --
273: -- ----------------------------------------------------------------------------
273: -- ----------------------------------------------------------------------------
274: -- |------------------------------< insert_dml >------------------------------|
275: -- ----------------------------------------------------------------------------
276: Procedure insert_dml
277: (p_rec in out nocopy ben_eps_shd.g_rec_type,
278: p_effective_date in date,
279: p_datetrack_mode in varchar2,
280: p_validation_start_date in date,
281: p_validation_end_date in date) is
333: --
334: -- {End Of Comments}
335: -- ----------------------------------------------------------------------------
336: Procedure pre_insert
337: (p_rec in out nocopy ben_eps_shd.g_rec_type,
338: p_effective_date in date,
339: p_datetrack_mode in varchar2,
340: p_validation_start_date in date,
341: p_validation_end_date in date) is
423: --
424: -- {End Of Comments}
425: -- ----------------------------------------------------------------------------
426: Procedure post_insert
427: (p_rec in ben_eps_shd.g_rec_type,
428: p_effective_date in date,
429: p_datetrack_mode in varchar2,
430: p_validation_start_date in date,
431: p_validation_end_date in date) is
544: -- ----------------------------------------------------------------------------
545: Procedure ins_lck
546: (p_effective_date in date,
547: p_datetrack_mode in varchar2,
548: p_rec in ben_eps_shd.g_rec_type,
549: p_validation_start_date out nocopy date,
550: p_validation_end_date out nocopy date) is
551: --
552: l_proc varchar2(72) := g_package||'ins_lck';
582: -- |---------------------------------< ins >----------------------------------|
583: -- ----------------------------------------------------------------------------
584: Procedure ins
585: (
586: p_rec in out nocopy ben_eps_shd.g_rec_type,
587: p_effective_date in date
588: ) is
589: --
590: l_proc varchar2(72) := g_package||'ins';
690: p_criteria_score in number default null,
691: p_criteria_weight in number default null
692: ) is
693: --
694: l_rec ben_eps_shd.g_rec_type;
695: l_proc varchar2(72) := g_package||'ins';
696: --
697: Begin
698: hr_utility.set_location('Entering:'||l_proc, 5);
700: -- Call conversion function to turn arguments into the
701: -- p_rec structure.
702: --
703: l_rec :=
704: ben_eps_shd.convert_args
705: (
706: null,
707: null,
708: null,