[Home] [Help]
89: --
90: -- {End Of Comments}
91: -- ----------------------------------------------------------------------------
92: Procedure dt_insert_dml
93: (p_rec in out nocopy ben_elp_shd.g_rec_type,
94: p_effective_date in date,
95: p_datetrack_mode in varchar2,
96: p_validation_start_date in date,
97: p_validation_end_date in date) is
103: t.creation_date
104: from ben_eligy_prfl_f t
105: where t.eligy_prfl_id = p_rec.eligy_prfl_id
106: and t.effective_start_date =
107: ben_elp_shd.g_old_rec.effective_start_date
108: and t.effective_end_date = (p_validation_start_date - 1);
109: --
110: l_proc varchar2(72) := g_package||'dt_insert_dml';
111: l_created_by ben_eligy_prfl_f.created_by%TYPE;
160: l_last_updated_by := fnd_global.user_id;
161: l_last_update_login := fnd_global.login_id;
162: End If;
163: --
164: ben_elp_shd.g_api_dml := true; -- Set the api dml status
165: --
166: -- Insert the row into: ben_eligy_prfl_f
167: --
168: insert into ben_eligy_prfl_f
389: l_last_updated_by,
390: l_last_update_login
391: );
392: --
393: ben_elp_shd.g_api_dml := false; -- Unset the api dml status
394: hr_utility.set_location(' Leaving:'||l_proc, 15);
395: --
396: Exception
397: When hr_api.check_integrity_violated Then
395: --
396: Exception
397: When hr_api.check_integrity_violated Then
398: -- A check constraint has been violated
399: ben_elp_shd.g_api_dml := false; -- Unset the api dml status
400: ben_elp_shd.constraint_error
401: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
402: When hr_api.unique_integrity_violated Then
403: -- Unique integrity has been violated
396: Exception
397: When hr_api.check_integrity_violated Then
398: -- A check constraint has been violated
399: ben_elp_shd.g_api_dml := false; -- Unset the api dml status
400: ben_elp_shd.constraint_error
401: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
402: When hr_api.unique_integrity_violated Then
403: -- Unique integrity has been violated
404: ben_elp_shd.g_api_dml := false; -- Unset the api dml status
400: ben_elp_shd.constraint_error
401: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
402: When hr_api.unique_integrity_violated Then
403: -- Unique integrity has been violated
404: ben_elp_shd.g_api_dml := false; -- Unset the api dml status
405: ben_elp_shd.constraint_error
406: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
407: When Others Then
408: ben_elp_shd.g_api_dml := false; -- Unset the api dml status
401: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
402: When hr_api.unique_integrity_violated Then
403: -- Unique integrity has been violated
404: ben_elp_shd.g_api_dml := false; -- Unset the api dml status
405: ben_elp_shd.constraint_error
406: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
407: When Others Then
408: ben_elp_shd.g_api_dml := false; -- Unset the api dml status
409: Raise;
404: ben_elp_shd.g_api_dml := false; -- Unset the api dml status
405: ben_elp_shd.constraint_error
406: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
407: When Others Then
408: ben_elp_shd.g_api_dml := false; -- Unset the api dml status
409: Raise;
410: End dt_insert_dml;
411: --
412: -- ----------------------------------------------------------------------------
412: -- ----------------------------------------------------------------------------
413: -- |------------------------------< insert_dml >------------------------------|
414: -- ----------------------------------------------------------------------------
415: Procedure insert_dml
416: (p_rec in out nocopy ben_elp_shd.g_rec_type,
417: p_effective_date in date,
418: p_datetrack_mode in varchar2,
419: p_validation_start_date in date,
420: p_validation_end_date in date) is
472: --
473: -- {End Of Comments}
474: -- ----------------------------------------------------------------------------
475: Procedure pre_insert
476: (p_rec in out nocopy ben_elp_shd.g_rec_type,
477: p_effective_date in date,
478: p_datetrack_mode in varchar2,
479: p_validation_start_date in date,
480: p_validation_end_date in date) is
557: --
558: -- {End Of Comments}
559: -- ----------------------------------------------------------------------------
560: Procedure post_insert
561: (p_rec in ben_elp_shd.g_rec_type,
562: p_effective_date in date,
563: p_datetrack_mode in varchar2,
564: p_validation_start_date in date,
565: p_validation_end_date in date) is
738: -- ----------------------------------------------------------------------------
739: Procedure ins_lck
740: (p_effective_date in date,
741: p_datetrack_mode in varchar2,
742: p_rec in ben_elp_shd.g_rec_type,
743: p_validation_start_date out nocopy date,
744: p_validation_end_date out nocopy date) is
745: --
746: l_proc varchar2(72) := g_package||'ins_lck';
776: -- |---------------------------------< ins >----------------------------------|
777: -- ----------------------------------------------------------------------------
778: Procedure ins
779: (
780: p_rec in out nocopy ben_elp_shd.g_rec_type,
781: p_effective_date in date
782: ) is
783: --
784: l_proc varchar2(72) := g_package||'ins';
947: p_object_version_number out nocopy number,
948: p_effective_date in date
949: ) is
950: --
951: l_rec ben_elp_shd.g_rec_type;
952: l_proc varchar2(72) := g_package||'ins';
953: --
954: Begin
955: hr_utility.set_location('Entering:'||l_proc, 5);
957: -- Call conversion function to turn arguments into the
958: -- p_rec structure.
959: --
960: l_rec :=
961: ben_elp_shd.convert_args
962: (
963: null,
964: null,
965: null,