69: --
70: -- {End Of Comments}
71: -- ----------------------------------------------------------------------------
72: Procedure dt_insert_dml
73: (p_rec in out nocopy ben_eou_shd.g_rec_type,
74: p_effective_date in date,
75: p_datetrack_mode in varchar2,
76: p_validation_start_date in date,
77: p_validation_end_date in date) is
83: t.creation_date
84: from ben_elig_org_unit_prte_f t
85: where t.elig_org_unit_prte_id = p_rec.elig_org_unit_prte_id
86: and t.effective_start_date =
87: ben_eou_shd.g_old_rec.effective_start_date
88: and t.effective_end_date = (p_validation_start_date - 1);
89: --
90: l_proc varchar2(72) := g_package||'dt_insert_dml';
91: l_created_by ben_elig_org_unit_prte_f.created_by%TYPE;
140: l_last_updated_by := fnd_global.user_id;
141: l_last_update_login := fnd_global.login_id;
142: End If;
143: --
144: ben_eou_shd.g_api_dml := true; -- Set the api dml status
145: --
146: -- Insert the row into: ben_elig_org_unit_prte_f
147: --
148: insert into ben_elig_org_unit_prte_f
243: p_Rec.criteria_score,
244: p_rec.criteria_weight
245: );
246: --
247: ben_eou_shd.g_api_dml := false; -- Unset the api dml status
248: hr_utility.set_location(' Leaving:'||l_proc, 15);
249: --
250: Exception
251: When hr_api.check_integrity_violated Then
249: --
250: Exception
251: When hr_api.check_integrity_violated Then
252: -- A check constraint has been violated
253: ben_eou_shd.g_api_dml := false; -- Unset the api dml status
254: ben_eou_shd.constraint_error
255: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256: When hr_api.unique_integrity_violated Then
257: -- Unique integrity has been violated
250: Exception
251: When hr_api.check_integrity_violated Then
252: -- A check constraint has been violated
253: ben_eou_shd.g_api_dml := false; -- Unset the api dml status
254: ben_eou_shd.constraint_error
255: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256: When hr_api.unique_integrity_violated Then
257: -- Unique integrity has been violated
258: ben_eou_shd.g_api_dml := false; -- Unset the api dml status
254: ben_eou_shd.constraint_error
255: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256: When hr_api.unique_integrity_violated Then
257: -- Unique integrity has been violated
258: ben_eou_shd.g_api_dml := false; -- Unset the api dml status
259: ben_eou_shd.constraint_error
260: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
261: When Others Then
262: ben_eou_shd.g_api_dml := false; -- Unset the api dml status
255: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256: When hr_api.unique_integrity_violated Then
257: -- Unique integrity has been violated
258: ben_eou_shd.g_api_dml := false; -- Unset the api dml status
259: ben_eou_shd.constraint_error
260: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
261: When Others Then
262: ben_eou_shd.g_api_dml := false; -- Unset the api dml status
263: Raise;
258: ben_eou_shd.g_api_dml := false; -- Unset the api dml status
259: ben_eou_shd.constraint_error
260: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
261: When Others Then
262: ben_eou_shd.g_api_dml := false; -- Unset the api dml status
263: Raise;
264: End dt_insert_dml;
265: --
266: -- ----------------------------------------------------------------------------
266: -- ----------------------------------------------------------------------------
267: -- |------------------------------< insert_dml >------------------------------|
268: -- ----------------------------------------------------------------------------
269: Procedure insert_dml
270: (p_rec in out nocopy ben_eou_shd.g_rec_type,
271: p_effective_date in date,
272: p_datetrack_mode in varchar2,
273: p_validation_start_date in date,
274: p_validation_end_date in date) is
326: --
327: -- {End Of Comments}
328: -- ----------------------------------------------------------------------------
329: Procedure pre_insert
330: (p_rec in out nocopy ben_eou_shd.g_rec_type,
331: p_effective_date in date,
332: p_datetrack_mode in varchar2,
333: p_validation_start_date in date,
334: p_validation_end_date in date) is
413: --
414: -- {End Of Comments}
415: -- ----------------------------------------------------------------------------
416: Procedure post_insert
417: (p_rec in ben_eou_shd.g_rec_type,
418: p_effective_date in date,
419: p_datetrack_mode in varchar2,
420: p_validation_start_date in date,
421: p_validation_end_date in date) is
534: -- ----------------------------------------------------------------------------
535: Procedure ins_lck
536: (p_effective_date in date,
537: p_datetrack_mode in varchar2,
538: p_rec in ben_eou_shd.g_rec_type,
539: p_validation_start_date out nocopy date,
540: p_validation_end_date out nocopy date) is
541: --
542: l_proc varchar2(72) := g_package||'ins_lck';
575: -- |---------------------------------< ins >----------------------------------|
576: -- ----------------------------------------------------------------------------
577: Procedure ins
578: (
579: p_rec in out nocopy ben_eou_shd.g_rec_type,
580: p_effective_date in date
581: ) is
582: --
583: l_proc varchar2(72) := g_package||'ins';
683: p_criteria_score in number default null,
684: p_criteria_weight in number default null
685: ) is
686: --
687: l_rec ben_eou_shd.g_rec_type;
688: l_proc varchar2(72) := g_package||'ins';
689: --
690: Begin
691: hr_utility.set_location('Entering:'||l_proc, 5);
693: -- Call conversion function to turn arguments into the
694: -- p_rec structure.
695: --
696: l_rec :=
697: ben_eou_shd.convert_args
698: (
699: null,
700: null,
701: null,