APPS.BEN_BEC_UPD dependencies on BEN_BEC_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ben_bec_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_bec_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

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

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_bec_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_batch_elctbl_chc_info Row
68: --
69: update ben_batch_elctbl_chc_info

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

86: business_group_id = p_rec.business_group_id,
87: object_version_number = p_rec.object_version_number
88: where batch_elctbl_id = p_rec.batch_elctbl_id;
89: --
90: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: --
94: Exception

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

93: --
94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
98: ben_bec_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated

Line 98: ben_bec_shd.constraint_error

94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
98: ben_bec_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: ben_bec_shd.g_api_dml := false; -- Unset the api dml status

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

98: ben_bec_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
103: ben_bec_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated

Line 103: ben_bec_shd.constraint_error

99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
103: ben_bec_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: ben_bec_shd.g_api_dml := false; -- Unset the api dml status

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

103: ben_bec_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
108: ben_bec_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_bec_shd.g_api_dml := false; -- Unset the api dml status

Line 108: ben_bec_shd.constraint_error

104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
108: ben_bec_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;

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

107: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
108: ben_bec_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
113: End update_dml;
114: --
115: -- ----------------------------------------------------------------------------

Line 147: Procedure pre_update(p_rec in ben_bec_shd.g_rec_type) is

143: -- Internal Row Handler Use Only.
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure pre_update(p_rec in ben_bec_shd.g_rec_type) is
148: --
149: l_proc varchar2(72) := g_package||'pre_update';
150: --
151: Begin

Line 190: p_rec in ben_bec_shd.g_rec_type) is

186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure post_update(p_effective_date in date,
190: p_rec in ben_bec_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'post_update';
193: --
194: Begin

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

217: ,p_dflt_flag =>p_rec.dflt_flag
218: ,p_business_group_id =>p_rec.business_group_id
219: ,p_object_version_number =>p_rec.object_version_number
220: ,p_effective_date =>p_effective_date
221: ,p_benefit_action_id_o =>ben_bec_shd.g_old_rec.benefit_action_id
222: ,p_person_id_o =>ben_bec_shd.g_old_rec.person_id
223: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
224: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
225: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id

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

218: ,p_business_group_id =>p_rec.business_group_id
219: ,p_object_version_number =>p_rec.object_version_number
220: ,p_effective_date =>p_effective_date
221: ,p_benefit_action_id_o =>ben_bec_shd.g_old_rec.benefit_action_id
222: ,p_person_id_o =>ben_bec_shd.g_old_rec.person_id
223: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
224: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
225: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
226: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt

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

219: ,p_object_version_number =>p_rec.object_version_number
220: ,p_effective_date =>p_effective_date
221: ,p_benefit_action_id_o =>ben_bec_shd.g_old_rec.benefit_action_id
222: ,p_person_id_o =>ben_bec_shd.g_old_rec.person_id
223: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
224: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
225: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
226: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
227: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt

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

220: ,p_effective_date =>p_effective_date
221: ,p_benefit_action_id_o =>ben_bec_shd.g_old_rec.benefit_action_id
222: ,p_person_id_o =>ben_bec_shd.g_old_rec.person_id
223: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
224: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
225: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
226: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
227: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
228: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt

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

221: ,p_benefit_action_id_o =>ben_bec_shd.g_old_rec.benefit_action_id
222: ,p_person_id_o =>ben_bec_shd.g_old_rec.person_id
223: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
224: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
225: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
226: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
227: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
228: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
229: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt

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

222: ,p_person_id_o =>ben_bec_shd.g_old_rec.person_id
223: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
224: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
225: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
226: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
227: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
228: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
229: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
230: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt

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

223: ,p_pgm_id_o =>ben_bec_shd.g_old_rec.pgm_id
224: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
225: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
226: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
227: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
228: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
229: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
230: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
231: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd

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

224: ,p_pl_id_o =>ben_bec_shd.g_old_rec.pl_id
225: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
226: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
227: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
228: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
229: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
230: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
231: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
232: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd

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

225: ,p_oipl_id_o =>ben_bec_shd.g_old_rec.oipl_id
226: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
227: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
228: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
229: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
230: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
231: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
232: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
233: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag

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

226: ,p_enrt_cvg_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_cvg_strt_dt
227: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
228: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
229: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
230: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
231: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
232: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
233: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
234: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag

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

227: ,p_enrt_perd_strt_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_strt_dt
228: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
229: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
230: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
231: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
232: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
233: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
234: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag
235: ,p_business_group_id_o =>ben_bec_shd.g_old_rec.business_group_id

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

228: ,p_enrt_perd_end_dt_o =>ben_bec_shd.g_old_rec.enrt_perd_end_dt
229: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
230: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
231: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
232: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
233: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
234: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag
235: ,p_business_group_id_o =>ben_bec_shd.g_old_rec.business_group_id
236: ,p_object_version_number_o =>ben_bec_shd.g_old_rec.object_version_number);

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

229: ,p_erlst_deenrt_dt_o =>ben_bec_shd.g_old_rec.erlst_deenrt_dt
230: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
231: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
232: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
233: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
234: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag
235: ,p_business_group_id_o =>ben_bec_shd.g_old_rec.business_group_id
236: ,p_object_version_number_o =>ben_bec_shd.g_old_rec.object_version_number);
237: --

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

230: ,p_dflt_enrt_dt_o =>ben_bec_shd.g_old_rec.dflt_enrt_dt
231: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
232: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
233: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
234: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag
235: ,p_business_group_id_o =>ben_bec_shd.g_old_rec.business_group_id
236: ,p_object_version_number_o =>ben_bec_shd.g_old_rec.object_version_number);
237: --
238: exception

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

231: ,p_enrt_typ_cycl_cd_o =>ben_bec_shd.g_old_rec.enrt_typ_cycl_cd
232: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
233: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
234: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag
235: ,p_business_group_id_o =>ben_bec_shd.g_old_rec.business_group_id
236: ,p_object_version_number_o =>ben_bec_shd.g_old_rec.object_version_number);
237: --
238: exception
239: --

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

232: ,p_comp_lvl_cd_o =>ben_bec_shd.g_old_rec.comp_lvl_cd
233: ,p_mndtry_flag_o =>ben_bec_shd.g_old_rec.mndtry_flag
234: ,p_dflt_flag_o =>ben_bec_shd.g_old_rec.dflt_flag
235: ,p_business_group_id_o =>ben_bec_shd.g_old_rec.business_group_id
236: ,p_object_version_number_o =>ben_bec_shd.g_old_rec.object_version_number);
237: --
238: exception
239: --
240: when hr_api.cannot_find_prog_unit then

Line 296: Procedure convert_defs(p_rec in out nocopy ben_bec_shd.g_rec_type) is

292: -- Internal Row Handler Use Only.
293: --
294: -- {End Of Comments}
295: -- ----------------------------------------------------------------------------
296: Procedure convert_defs(p_rec in out nocopy ben_bec_shd.g_rec_type) is
297: --
298: l_proc varchar2(72) := g_package||'convert_defs';
299: --
300: Begin

Line 311: ben_bec_shd.g_old_rec.benefit_action_id;

307: -- is being used then we must set to the 'current' argument value.
308: --
309: If (p_rec.benefit_action_id = hr_api.g_number) then
310: p_rec.benefit_action_id :=
311: ben_bec_shd.g_old_rec.benefit_action_id;
312: End If;
313: If (p_rec.person_id = hr_api.g_number) then
314: p_rec.person_id :=
315: ben_bec_shd.g_old_rec.person_id;

Line 315: ben_bec_shd.g_old_rec.person_id;

311: ben_bec_shd.g_old_rec.benefit_action_id;
312: End If;
313: If (p_rec.person_id = hr_api.g_number) then
314: p_rec.person_id :=
315: ben_bec_shd.g_old_rec.person_id;
316: End If;
317: If (p_rec.pgm_id = hr_api.g_number) then
318: p_rec.pgm_id :=
319: ben_bec_shd.g_old_rec.pgm_id;

Line 319: ben_bec_shd.g_old_rec.pgm_id;

315: ben_bec_shd.g_old_rec.person_id;
316: End If;
317: If (p_rec.pgm_id = hr_api.g_number) then
318: p_rec.pgm_id :=
319: ben_bec_shd.g_old_rec.pgm_id;
320: End If;
321: If (p_rec.pl_id = hr_api.g_number) then
322: p_rec.pl_id :=
323: ben_bec_shd.g_old_rec.pl_id;

Line 323: ben_bec_shd.g_old_rec.pl_id;

319: ben_bec_shd.g_old_rec.pgm_id;
320: End If;
321: If (p_rec.pl_id = hr_api.g_number) then
322: p_rec.pl_id :=
323: ben_bec_shd.g_old_rec.pl_id;
324: End If;
325: If (p_rec.oipl_id = hr_api.g_number) then
326: p_rec.oipl_id :=
327: ben_bec_shd.g_old_rec.oipl_id;

Line 327: ben_bec_shd.g_old_rec.oipl_id;

323: ben_bec_shd.g_old_rec.pl_id;
324: End If;
325: If (p_rec.oipl_id = hr_api.g_number) then
326: p_rec.oipl_id :=
327: ben_bec_shd.g_old_rec.oipl_id;
328: End If;
329: If (p_rec.enrt_cvg_strt_dt = hr_api.g_date) then
330: p_rec.enrt_cvg_strt_dt :=
331: ben_bec_shd.g_old_rec.enrt_cvg_strt_dt;

Line 331: ben_bec_shd.g_old_rec.enrt_cvg_strt_dt;

327: ben_bec_shd.g_old_rec.oipl_id;
328: End If;
329: If (p_rec.enrt_cvg_strt_dt = hr_api.g_date) then
330: p_rec.enrt_cvg_strt_dt :=
331: ben_bec_shd.g_old_rec.enrt_cvg_strt_dt;
332: End If;
333: If (p_rec.enrt_perd_strt_dt = hr_api.g_date) then
334: p_rec.enrt_perd_strt_dt :=
335: ben_bec_shd.g_old_rec.enrt_perd_strt_dt;

Line 335: ben_bec_shd.g_old_rec.enrt_perd_strt_dt;

331: ben_bec_shd.g_old_rec.enrt_cvg_strt_dt;
332: End If;
333: If (p_rec.enrt_perd_strt_dt = hr_api.g_date) then
334: p_rec.enrt_perd_strt_dt :=
335: ben_bec_shd.g_old_rec.enrt_perd_strt_dt;
336: End If;
337: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then
338: p_rec.enrt_perd_end_dt :=
339: ben_bec_shd.g_old_rec.enrt_perd_end_dt;

Line 339: ben_bec_shd.g_old_rec.enrt_perd_end_dt;

335: ben_bec_shd.g_old_rec.enrt_perd_strt_dt;
336: End If;
337: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then
338: p_rec.enrt_perd_end_dt :=
339: ben_bec_shd.g_old_rec.enrt_perd_end_dt;
340: End If;
341: If (p_rec.erlst_deenrt_dt = hr_api.g_date) then
342: p_rec.erlst_deenrt_dt :=
343: ben_bec_shd.g_old_rec.erlst_deenrt_dt;

Line 343: ben_bec_shd.g_old_rec.erlst_deenrt_dt;

339: ben_bec_shd.g_old_rec.enrt_perd_end_dt;
340: End If;
341: If (p_rec.erlst_deenrt_dt = hr_api.g_date) then
342: p_rec.erlst_deenrt_dt :=
343: ben_bec_shd.g_old_rec.erlst_deenrt_dt;
344: End If;
345: If (p_rec.dflt_enrt_dt = hr_api.g_date) then
346: p_rec.dflt_enrt_dt :=
347: ben_bec_shd.g_old_rec.dflt_enrt_dt;

Line 347: ben_bec_shd.g_old_rec.dflt_enrt_dt;

343: ben_bec_shd.g_old_rec.erlst_deenrt_dt;
344: End If;
345: If (p_rec.dflt_enrt_dt = hr_api.g_date) then
346: p_rec.dflt_enrt_dt :=
347: ben_bec_shd.g_old_rec.dflt_enrt_dt;
348: End If;
349: If (p_rec.enrt_typ_cycl_cd = hr_api.g_varchar2) then
350: p_rec.enrt_typ_cycl_cd :=
351: ben_bec_shd.g_old_rec.enrt_typ_cycl_cd;

Line 351: ben_bec_shd.g_old_rec.enrt_typ_cycl_cd;

347: ben_bec_shd.g_old_rec.dflt_enrt_dt;
348: End If;
349: If (p_rec.enrt_typ_cycl_cd = hr_api.g_varchar2) then
350: p_rec.enrt_typ_cycl_cd :=
351: ben_bec_shd.g_old_rec.enrt_typ_cycl_cd;
352: End If;
353: If (p_rec.comp_lvl_cd = hr_api.g_varchar2) then
354: p_rec.comp_lvl_cd :=
355: ben_bec_shd.g_old_rec.comp_lvl_cd;

Line 355: ben_bec_shd.g_old_rec.comp_lvl_cd;

351: ben_bec_shd.g_old_rec.enrt_typ_cycl_cd;
352: End If;
353: If (p_rec.comp_lvl_cd = hr_api.g_varchar2) then
354: p_rec.comp_lvl_cd :=
355: ben_bec_shd.g_old_rec.comp_lvl_cd;
356: End If;
357: If (p_rec.mndtry_flag = hr_api.g_varchar2) then
358: p_rec.mndtry_flag :=
359: ben_bec_shd.g_old_rec.mndtry_flag;

Line 359: ben_bec_shd.g_old_rec.mndtry_flag;

355: ben_bec_shd.g_old_rec.comp_lvl_cd;
356: End If;
357: If (p_rec.mndtry_flag = hr_api.g_varchar2) then
358: p_rec.mndtry_flag :=
359: ben_bec_shd.g_old_rec.mndtry_flag;
360: End If;
361: If (p_rec.dflt_flag = hr_api.g_varchar2) then
362: p_rec.dflt_flag :=
363: ben_bec_shd.g_old_rec.dflt_flag;

Line 363: ben_bec_shd.g_old_rec.dflt_flag;

359: ben_bec_shd.g_old_rec.mndtry_flag;
360: End If;
361: If (p_rec.dflt_flag = hr_api.g_varchar2) then
362: p_rec.dflt_flag :=
363: ben_bec_shd.g_old_rec.dflt_flag;
364: End If;
365: If (p_rec.business_group_id = hr_api.g_number) then
366: p_rec.business_group_id :=
367: ben_bec_shd.g_old_rec.business_group_id;

Line 367: ben_bec_shd.g_old_rec.business_group_id;

363: ben_bec_shd.g_old_rec.dflt_flag;
364: End If;
365: If (p_rec.business_group_id = hr_api.g_number) then
366: p_rec.business_group_id :=
367: ben_bec_shd.g_old_rec.business_group_id;
368: End If;
369: --
370: hr_utility.set_location(' Leaving:'||l_proc, 10);
371: --

Line 380: p_rec in out nocopy ben_bec_shd.g_rec_type

376: -- ----------------------------------------------------------------------------
377: Procedure upd
378: (
379: p_effective_date in date,
380: p_rec in out nocopy ben_bec_shd.g_rec_type
381: ) is
382: --
383: l_proc varchar2(72) := g_package||'upd';
384: --

Line 390: ben_bec_shd.lck

386: hr_utility.set_location('Entering:'||l_proc, 5);
387: --
388: -- We must lock the row which we need to update.
389: --
390: ben_bec_shd.lck
391: (
392: p_rec.batch_elctbl_id,
393: p_rec.object_version_number
394: );

Line 444: l_rec ben_bec_shd.g_rec_type;

440: p_business_group_id in number default hr_api.g_number,
441: p_object_version_number in out nocopy number
442: ) is
443: --
444: l_rec ben_bec_shd.g_rec_type;
445: l_proc varchar2(72) := g_package||'upd';
446: --
447: Begin
448: hr_utility.set_location('Entering:'||l_proc, 5);

Line 454: ben_bec_shd.convert_args

450: -- Call conversion function to turn arguments into the
451: -- l_rec structure.
452: --
453: l_rec :=
454: ben_bec_shd.convert_args
455: (
456: p_batch_elctbl_id,
457: p_benefit_action_id,
458: p_person_id,