APPS.BEN_BEC_DEL dependencies on BEN_BEC_SHD

Line 51: Procedure delete_dml(p_rec in ben_bec_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ben_bec_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: ben_bec_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ben_bec_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_batch_elctbl_chc_info row.
61: --
62: delete from ben_batch_elctbl_chc_info

Line 65: ben_bec_shd.g_api_dml := false; -- Unset the api dml status

61: --
62: delete from ben_batch_elctbl_chc_info
63: where batch_elctbl_id = p_rec.batch_elctbl_id;
64: --
65: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

Line 72: ben_bec_shd.g_api_dml := false; -- Unset the api dml status

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
73: ben_bec_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_bec_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_bec_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
73: ben_bec_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

Line 76: ben_bec_shd.g_api_dml := false; -- Unset the api dml status

72: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
73: ben_bec_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in ben_bec_shd.g_rec_type) is

108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in ben_bec_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 155: p_effective_date in date,p_rec in ben_bec_shd.g_rec_type) is

151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(
155: p_effective_date in date,p_rec in ben_bec_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin

Line 169: ,p_benefit_action_id_o =>ben_bec_shd.g_old_rec.benefit_action_id

165: begin
166: --
167: ben_bec_rkd.after_delete
168: (p_batch_elctbl_id =>p_rec.batch_elctbl_id
169: ,p_benefit_action_id_o =>ben_bec_shd.g_old_rec.benefit_action_id
170: ,p_person_id_o =>ben_bec_shd.g_old_rec.person_id
171: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
172: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
173: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id

Line 170: ,p_person_id_o =>ben_bec_shd.g_old_rec.person_id

166: --
167: ben_bec_rkd.after_delete
168: (p_batch_elctbl_id =>p_rec.batch_elctbl_id
169: ,p_benefit_action_id_o =>ben_bec_shd.g_old_rec.benefit_action_id
170: ,p_person_id_o =>ben_bec_shd.g_old_rec.person_id
171: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
172: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
173: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
174: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt

Line 171: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id

167: ben_bec_rkd.after_delete
168: (p_batch_elctbl_id =>p_rec.batch_elctbl_id
169: ,p_benefit_action_id_o =>ben_bec_shd.g_old_rec.benefit_action_id
170: ,p_person_id_o =>ben_bec_shd.g_old_rec.person_id
171: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
172: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
173: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
174: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
175: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt

Line 172: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id

168: (p_batch_elctbl_id =>p_rec.batch_elctbl_id
169: ,p_benefit_action_id_o =>ben_bec_shd.g_old_rec.benefit_action_id
170: ,p_person_id_o =>ben_bec_shd.g_old_rec.person_id
171: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
172: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
173: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
174: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
175: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
176: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt

Line 173: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id

169: ,p_benefit_action_id_o =>ben_bec_shd.g_old_rec.benefit_action_id
170: ,p_person_id_o =>ben_bec_shd.g_old_rec.person_id
171: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
172: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
173: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
174: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
175: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
176: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
177: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt

Line 174: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt

170: ,p_person_id_o =>ben_bec_shd.g_old_rec.person_id
171: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
172: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
173: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
174: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
175: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
176: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
177: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
178: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt

Line 175: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt

171: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
172: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
173: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
174: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
175: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
176: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
177: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
178: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
179: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd

Line 176: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt

172: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
173: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
174: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
175: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
176: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
177: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
178: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
179: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
180: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd

Line 177: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt

173: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
174: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
175: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
176: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
177: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
178: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
179: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
180: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
181: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag

Line 178: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt

174: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
175: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
176: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
177: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
178: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
179: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
180: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
181: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
182: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag

Line 179: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd

175: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
176: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
177: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
178: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
179: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
180: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
181: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
182: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag
183: ,p_business_group_id_o =>ben_bec_shd.g_old_rec.business_group_id

Line 180: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd

176: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
177: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
178: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
179: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
180: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
181: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
182: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag
183: ,p_business_group_id_o =>ben_bec_shd.g_old_rec.business_group_id
184: ,p_object_version_number_o =>ben_bec_shd.g_old_rec.object_version_number);

Line 181: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag

177: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
178: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
179: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
180: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
181: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
182: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag
183: ,p_business_group_id_o =>ben_bec_shd.g_old_rec.business_group_id
184: ,p_object_version_number_o =>ben_bec_shd.g_old_rec.object_version_number);
185: --

Line 182: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag

178: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
179: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
180: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
181: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
182: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag
183: ,p_business_group_id_o =>ben_bec_shd.g_old_rec.business_group_id
184: ,p_object_version_number_o =>ben_bec_shd.g_old_rec.object_version_number);
185: --
186: exception

Line 183: ,p_business_group_id_o =>ben_bec_shd.g_old_rec.business_group_id

179: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
180: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
181: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
182: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag
183: ,p_business_group_id_o =>ben_bec_shd.g_old_rec.business_group_id
184: ,p_object_version_number_o =>ben_bec_shd.g_old_rec.object_version_number);
185: --
186: exception
187: --

Line 184: ,p_object_version_number_o =>ben_bec_shd.g_old_rec.object_version_number);

180: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
181: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
182: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag
183: ,p_business_group_id_o =>ben_bec_shd.g_old_rec.business_group_id
184: ,p_object_version_number_o =>ben_bec_shd.g_old_rec.object_version_number);
185: --
186: exception
187: --
188: when hr_api.cannot_find_prog_unit then

Line 208: p_rec in ben_bec_shd.g_rec_type

204: -- ----------------------------------------------------------------------------
205: Procedure del
206: (
207: p_effective_date in date,
208: p_rec in ben_bec_shd.g_rec_type
209: ) is
210: --
211: l_proc varchar2(72) := g_package||'del';
212: --

Line 218: ben_bec_shd.lck

214: hr_utility.set_location('Entering:'||l_proc, 5);
215: --
216: -- We must lock the row which we need to delete.
217: --
218: ben_bec_shd.lck
219: (
220: p_rec.batch_elctbl_id,
221: p_rec.object_version_number
222: );

Line 252: l_rec ben_bec_shd.g_rec_type;

248: p_batch_elctbl_id in number,
249: p_object_version_number in number
250: ) is
251: --
252: l_rec ben_bec_shd.g_rec_type;
253: l_proc varchar2(72) := g_package||'del';
254: --
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);