APPS.BEN_BLI_UPD dependencies on BEN_BLI_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ben_bli_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_bli_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: ben_bli_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_bli_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_batch_ler_info Row
68: --
69: update ben_batch_ler_info

Line 93: ben_bli_shd.g_api_dml := false; -- Unset the api dml status

89: business_group_id = p_rec.business_group_id,
90: object_version_number = p_rec.object_version_number
91: where batch_ler_id = p_rec.batch_ler_id;
92: --
93: ben_bli_shd.g_api_dml := false; -- Unset the api dml status
94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 10);
96: --
97: Exception

Line 100: ben_bli_shd.g_api_dml := false; -- Unset the api dml status

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

Line 101: ben_bli_shd.constraint_error

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

Line 105: ben_bli_shd.g_api_dml := false; -- Unset the api dml status

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

Line 106: ben_bli_shd.constraint_error

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

Line 110: ben_bli_shd.g_api_dml := false; -- Unset the api dml status

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

Line 111: ben_bli_shd.constraint_error

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

Line 114: ben_bli_shd.g_api_dml := false; -- Unset the api dml status

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

Line 150: Procedure pre_update(p_rec in ben_bli_shd.g_rec_type) is

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

Line 193: p_rec in ben_bli_shd.g_rec_type) is

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

Line 227: ,p_benefit_action_id_o =>ben_bli_shd.g_old_rec.benefit_action_id

223: ,p_per_in_ler_id =>p_rec.per_in_ler_id
224: ,p_business_group_id =>p_rec.business_group_id
225: ,p_object_version_number =>p_rec.object_version_number
226: ,p_effective_date =>p_effective_date
227: ,p_benefit_action_id_o =>ben_bli_shd.g_old_rec.benefit_action_id
228: ,p_person_id_o =>ben_bli_shd.g_old_rec.person_id
229: ,p_ler_id_o =>ben_bli_shd.g_old_rec.ler_id
230: ,p_lf_evt_ocrd_dt_o =>ben_bli_shd.g_old_rec.lf_evt_ocrd_dt
231: ,p_replcd_flag_o =>ben_bli_shd.g_old_rec.replcd_flag

Line 228: ,p_person_id_o =>ben_bli_shd.g_old_rec.person_id

224: ,p_business_group_id =>p_rec.business_group_id
225: ,p_object_version_number =>p_rec.object_version_number
226: ,p_effective_date =>p_effective_date
227: ,p_benefit_action_id_o =>ben_bli_shd.g_old_rec.benefit_action_id
228: ,p_person_id_o =>ben_bli_shd.g_old_rec.person_id
229: ,p_ler_id_o =>ben_bli_shd.g_old_rec.ler_id
230: ,p_lf_evt_ocrd_dt_o =>ben_bli_shd.g_old_rec.lf_evt_ocrd_dt
231: ,p_replcd_flag_o =>ben_bli_shd.g_old_rec.replcd_flag
232: ,p_crtd_flag_o =>ben_bli_shd.g_old_rec.crtd_flag

Line 229: ,p_ler_id_o =>ben_bli_shd.g_old_rec.ler_id

225: ,p_object_version_number =>p_rec.object_version_number
226: ,p_effective_date =>p_effective_date
227: ,p_benefit_action_id_o =>ben_bli_shd.g_old_rec.benefit_action_id
228: ,p_person_id_o =>ben_bli_shd.g_old_rec.person_id
229: ,p_ler_id_o =>ben_bli_shd.g_old_rec.ler_id
230: ,p_lf_evt_ocrd_dt_o =>ben_bli_shd.g_old_rec.lf_evt_ocrd_dt
231: ,p_replcd_flag_o =>ben_bli_shd.g_old_rec.replcd_flag
232: ,p_crtd_flag_o =>ben_bli_shd.g_old_rec.crtd_flag
233: ,p_tmprl_flag_o =>ben_bli_shd.g_old_rec.tmprl_flag

Line 230: ,p_lf_evt_ocrd_dt_o =>ben_bli_shd.g_old_rec.lf_evt_ocrd_dt

226: ,p_effective_date =>p_effective_date
227: ,p_benefit_action_id_o =>ben_bli_shd.g_old_rec.benefit_action_id
228: ,p_person_id_o =>ben_bli_shd.g_old_rec.person_id
229: ,p_ler_id_o =>ben_bli_shd.g_old_rec.ler_id
230: ,p_lf_evt_ocrd_dt_o =>ben_bli_shd.g_old_rec.lf_evt_ocrd_dt
231: ,p_replcd_flag_o =>ben_bli_shd.g_old_rec.replcd_flag
232: ,p_crtd_flag_o =>ben_bli_shd.g_old_rec.crtd_flag
233: ,p_tmprl_flag_o =>ben_bli_shd.g_old_rec.tmprl_flag
234: ,p_dltd_flag_o =>ben_bli_shd.g_old_rec.dltd_flag

Line 231: ,p_replcd_flag_o =>ben_bli_shd.g_old_rec.replcd_flag

227: ,p_benefit_action_id_o =>ben_bli_shd.g_old_rec.benefit_action_id
228: ,p_person_id_o =>ben_bli_shd.g_old_rec.person_id
229: ,p_ler_id_o =>ben_bli_shd.g_old_rec.ler_id
230: ,p_lf_evt_ocrd_dt_o =>ben_bli_shd.g_old_rec.lf_evt_ocrd_dt
231: ,p_replcd_flag_o =>ben_bli_shd.g_old_rec.replcd_flag
232: ,p_crtd_flag_o =>ben_bli_shd.g_old_rec.crtd_flag
233: ,p_tmprl_flag_o =>ben_bli_shd.g_old_rec.tmprl_flag
234: ,p_dltd_flag_o =>ben_bli_shd.g_old_rec.dltd_flag
235: ,p_open_and_clsd_flag_o =>ben_bli_shd.g_old_rec.open_and_clsd_flag

Line 232: ,p_crtd_flag_o =>ben_bli_shd.g_old_rec.crtd_flag

228: ,p_person_id_o =>ben_bli_shd.g_old_rec.person_id
229: ,p_ler_id_o =>ben_bli_shd.g_old_rec.ler_id
230: ,p_lf_evt_ocrd_dt_o =>ben_bli_shd.g_old_rec.lf_evt_ocrd_dt
231: ,p_replcd_flag_o =>ben_bli_shd.g_old_rec.replcd_flag
232: ,p_crtd_flag_o =>ben_bli_shd.g_old_rec.crtd_flag
233: ,p_tmprl_flag_o =>ben_bli_shd.g_old_rec.tmprl_flag
234: ,p_dltd_flag_o =>ben_bli_shd.g_old_rec.dltd_flag
235: ,p_open_and_clsd_flag_o =>ben_bli_shd.g_old_rec.open_and_clsd_flag
236: ,p_clsd_flag_o =>ben_bli_shd.g_old_rec.clsd_flag

Line 233: ,p_tmprl_flag_o =>ben_bli_shd.g_old_rec.tmprl_flag

229: ,p_ler_id_o =>ben_bli_shd.g_old_rec.ler_id
230: ,p_lf_evt_ocrd_dt_o =>ben_bli_shd.g_old_rec.lf_evt_ocrd_dt
231: ,p_replcd_flag_o =>ben_bli_shd.g_old_rec.replcd_flag
232: ,p_crtd_flag_o =>ben_bli_shd.g_old_rec.crtd_flag
233: ,p_tmprl_flag_o =>ben_bli_shd.g_old_rec.tmprl_flag
234: ,p_dltd_flag_o =>ben_bli_shd.g_old_rec.dltd_flag
235: ,p_open_and_clsd_flag_o =>ben_bli_shd.g_old_rec.open_and_clsd_flag
236: ,p_clsd_flag_o =>ben_bli_shd.g_old_rec.clsd_flag
237: ,p_not_crtd_flag_o =>ben_bli_shd.g_old_rec.not_crtd_flag

Line 234: ,p_dltd_flag_o =>ben_bli_shd.g_old_rec.dltd_flag

230: ,p_lf_evt_ocrd_dt_o =>ben_bli_shd.g_old_rec.lf_evt_ocrd_dt
231: ,p_replcd_flag_o =>ben_bli_shd.g_old_rec.replcd_flag
232: ,p_crtd_flag_o =>ben_bli_shd.g_old_rec.crtd_flag
233: ,p_tmprl_flag_o =>ben_bli_shd.g_old_rec.tmprl_flag
234: ,p_dltd_flag_o =>ben_bli_shd.g_old_rec.dltd_flag
235: ,p_open_and_clsd_flag_o =>ben_bli_shd.g_old_rec.open_and_clsd_flag
236: ,p_clsd_flag_o =>ben_bli_shd.g_old_rec.clsd_flag
237: ,p_not_crtd_flag_o =>ben_bli_shd.g_old_rec.not_crtd_flag
238: ,p_stl_actv_flag_o =>ben_bli_shd.g_old_rec.stl_actv_flag

Line 235: ,p_open_and_clsd_flag_o =>ben_bli_shd.g_old_rec.open_and_clsd_flag

231: ,p_replcd_flag_o =>ben_bli_shd.g_old_rec.replcd_flag
232: ,p_crtd_flag_o =>ben_bli_shd.g_old_rec.crtd_flag
233: ,p_tmprl_flag_o =>ben_bli_shd.g_old_rec.tmprl_flag
234: ,p_dltd_flag_o =>ben_bli_shd.g_old_rec.dltd_flag
235: ,p_open_and_clsd_flag_o =>ben_bli_shd.g_old_rec.open_and_clsd_flag
236: ,p_clsd_flag_o =>ben_bli_shd.g_old_rec.clsd_flag
237: ,p_not_crtd_flag_o =>ben_bli_shd.g_old_rec.not_crtd_flag
238: ,p_stl_actv_flag_o =>ben_bli_shd.g_old_rec.stl_actv_flag
239: ,p_clpsd_flag_o =>ben_bli_shd.g_old_rec.clpsd_flag

Line 236: ,p_clsd_flag_o =>ben_bli_shd.g_old_rec.clsd_flag

232: ,p_crtd_flag_o =>ben_bli_shd.g_old_rec.crtd_flag
233: ,p_tmprl_flag_o =>ben_bli_shd.g_old_rec.tmprl_flag
234: ,p_dltd_flag_o =>ben_bli_shd.g_old_rec.dltd_flag
235: ,p_open_and_clsd_flag_o =>ben_bli_shd.g_old_rec.open_and_clsd_flag
236: ,p_clsd_flag_o =>ben_bli_shd.g_old_rec.clsd_flag
237: ,p_not_crtd_flag_o =>ben_bli_shd.g_old_rec.not_crtd_flag
238: ,p_stl_actv_flag_o =>ben_bli_shd.g_old_rec.stl_actv_flag
239: ,p_clpsd_flag_o =>ben_bli_shd.g_old_rec.clpsd_flag
240: ,p_clsn_flag_o =>ben_bli_shd.g_old_rec.clsn_flag

Line 237: ,p_not_crtd_flag_o =>ben_bli_shd.g_old_rec.not_crtd_flag

233: ,p_tmprl_flag_o =>ben_bli_shd.g_old_rec.tmprl_flag
234: ,p_dltd_flag_o =>ben_bli_shd.g_old_rec.dltd_flag
235: ,p_open_and_clsd_flag_o =>ben_bli_shd.g_old_rec.open_and_clsd_flag
236: ,p_clsd_flag_o =>ben_bli_shd.g_old_rec.clsd_flag
237: ,p_not_crtd_flag_o =>ben_bli_shd.g_old_rec.not_crtd_flag
238: ,p_stl_actv_flag_o =>ben_bli_shd.g_old_rec.stl_actv_flag
239: ,p_clpsd_flag_o =>ben_bli_shd.g_old_rec.clpsd_flag
240: ,p_clsn_flag_o =>ben_bli_shd.g_old_rec.clsn_flag
241: ,p_no_effect_flag_o =>ben_bli_shd.g_old_rec.no_effect_flag

Line 238: ,p_stl_actv_flag_o =>ben_bli_shd.g_old_rec.stl_actv_flag

234: ,p_dltd_flag_o =>ben_bli_shd.g_old_rec.dltd_flag
235: ,p_open_and_clsd_flag_o =>ben_bli_shd.g_old_rec.open_and_clsd_flag
236: ,p_clsd_flag_o =>ben_bli_shd.g_old_rec.clsd_flag
237: ,p_not_crtd_flag_o =>ben_bli_shd.g_old_rec.not_crtd_flag
238: ,p_stl_actv_flag_o =>ben_bli_shd.g_old_rec.stl_actv_flag
239: ,p_clpsd_flag_o =>ben_bli_shd.g_old_rec.clpsd_flag
240: ,p_clsn_flag_o =>ben_bli_shd.g_old_rec.clsn_flag
241: ,p_no_effect_flag_o =>ben_bli_shd.g_old_rec.no_effect_flag
242: ,p_cvrge_rt_prem_flag_o =>ben_bli_shd.g_old_rec.cvrge_rt_prem_flag

Line 239: ,p_clpsd_flag_o =>ben_bli_shd.g_old_rec.clpsd_flag

235: ,p_open_and_clsd_flag_o =>ben_bli_shd.g_old_rec.open_and_clsd_flag
236: ,p_clsd_flag_o =>ben_bli_shd.g_old_rec.clsd_flag
237: ,p_not_crtd_flag_o =>ben_bli_shd.g_old_rec.not_crtd_flag
238: ,p_stl_actv_flag_o =>ben_bli_shd.g_old_rec.stl_actv_flag
239: ,p_clpsd_flag_o =>ben_bli_shd.g_old_rec.clpsd_flag
240: ,p_clsn_flag_o =>ben_bli_shd.g_old_rec.clsn_flag
241: ,p_no_effect_flag_o =>ben_bli_shd.g_old_rec.no_effect_flag
242: ,p_cvrge_rt_prem_flag_o =>ben_bli_shd.g_old_rec.cvrge_rt_prem_flag
243: ,p_per_in_ler_id_o =>ben_bli_shd.g_old_rec.per_in_ler_id

Line 240: ,p_clsn_flag_o =>ben_bli_shd.g_old_rec.clsn_flag

236: ,p_clsd_flag_o =>ben_bli_shd.g_old_rec.clsd_flag
237: ,p_not_crtd_flag_o =>ben_bli_shd.g_old_rec.not_crtd_flag
238: ,p_stl_actv_flag_o =>ben_bli_shd.g_old_rec.stl_actv_flag
239: ,p_clpsd_flag_o =>ben_bli_shd.g_old_rec.clpsd_flag
240: ,p_clsn_flag_o =>ben_bli_shd.g_old_rec.clsn_flag
241: ,p_no_effect_flag_o =>ben_bli_shd.g_old_rec.no_effect_flag
242: ,p_cvrge_rt_prem_flag_o =>ben_bli_shd.g_old_rec.cvrge_rt_prem_flag
243: ,p_per_in_ler_id_o =>ben_bli_shd.g_old_rec.per_in_ler_id
244: ,p_business_group_id_o =>ben_bli_shd.g_old_rec.business_group_id

Line 241: ,p_no_effect_flag_o =>ben_bli_shd.g_old_rec.no_effect_flag

237: ,p_not_crtd_flag_o =>ben_bli_shd.g_old_rec.not_crtd_flag
238: ,p_stl_actv_flag_o =>ben_bli_shd.g_old_rec.stl_actv_flag
239: ,p_clpsd_flag_o =>ben_bli_shd.g_old_rec.clpsd_flag
240: ,p_clsn_flag_o =>ben_bli_shd.g_old_rec.clsn_flag
241: ,p_no_effect_flag_o =>ben_bli_shd.g_old_rec.no_effect_flag
242: ,p_cvrge_rt_prem_flag_o =>ben_bli_shd.g_old_rec.cvrge_rt_prem_flag
243: ,p_per_in_ler_id_o =>ben_bli_shd.g_old_rec.per_in_ler_id
244: ,p_business_group_id_o =>ben_bli_shd.g_old_rec.business_group_id
245: ,p_object_version_number_o =>ben_bli_shd.g_old_rec.object_version_number);

Line 242: ,p_cvrge_rt_prem_flag_o =>ben_bli_shd.g_old_rec.cvrge_rt_prem_flag

238: ,p_stl_actv_flag_o =>ben_bli_shd.g_old_rec.stl_actv_flag
239: ,p_clpsd_flag_o =>ben_bli_shd.g_old_rec.clpsd_flag
240: ,p_clsn_flag_o =>ben_bli_shd.g_old_rec.clsn_flag
241: ,p_no_effect_flag_o =>ben_bli_shd.g_old_rec.no_effect_flag
242: ,p_cvrge_rt_prem_flag_o =>ben_bli_shd.g_old_rec.cvrge_rt_prem_flag
243: ,p_per_in_ler_id_o =>ben_bli_shd.g_old_rec.per_in_ler_id
244: ,p_business_group_id_o =>ben_bli_shd.g_old_rec.business_group_id
245: ,p_object_version_number_o =>ben_bli_shd.g_old_rec.object_version_number);
246: --

Line 243: ,p_per_in_ler_id_o =>ben_bli_shd.g_old_rec.per_in_ler_id

239: ,p_clpsd_flag_o =>ben_bli_shd.g_old_rec.clpsd_flag
240: ,p_clsn_flag_o =>ben_bli_shd.g_old_rec.clsn_flag
241: ,p_no_effect_flag_o =>ben_bli_shd.g_old_rec.no_effect_flag
242: ,p_cvrge_rt_prem_flag_o =>ben_bli_shd.g_old_rec.cvrge_rt_prem_flag
243: ,p_per_in_ler_id_o =>ben_bli_shd.g_old_rec.per_in_ler_id
244: ,p_business_group_id_o =>ben_bli_shd.g_old_rec.business_group_id
245: ,p_object_version_number_o =>ben_bli_shd.g_old_rec.object_version_number);
246: --
247: exception

Line 244: ,p_business_group_id_o =>ben_bli_shd.g_old_rec.business_group_id

240: ,p_clsn_flag_o =>ben_bli_shd.g_old_rec.clsn_flag
241: ,p_no_effect_flag_o =>ben_bli_shd.g_old_rec.no_effect_flag
242: ,p_cvrge_rt_prem_flag_o =>ben_bli_shd.g_old_rec.cvrge_rt_prem_flag
243: ,p_per_in_ler_id_o =>ben_bli_shd.g_old_rec.per_in_ler_id
244: ,p_business_group_id_o =>ben_bli_shd.g_old_rec.business_group_id
245: ,p_object_version_number_o =>ben_bli_shd.g_old_rec.object_version_number);
246: --
247: exception
248: --

Line 245: ,p_object_version_number_o =>ben_bli_shd.g_old_rec.object_version_number);

241: ,p_no_effect_flag_o =>ben_bli_shd.g_old_rec.no_effect_flag
242: ,p_cvrge_rt_prem_flag_o =>ben_bli_shd.g_old_rec.cvrge_rt_prem_flag
243: ,p_per_in_ler_id_o =>ben_bli_shd.g_old_rec.per_in_ler_id
244: ,p_business_group_id_o =>ben_bli_shd.g_old_rec.business_group_id
245: ,p_object_version_number_o =>ben_bli_shd.g_old_rec.object_version_number);
246: --
247: exception
248: --
249: when hr_api.cannot_find_prog_unit then

Line 306: Procedure convert_defs(p_rec in out nocopy ben_bli_shd.g_rec_type) is

302: -- Internal Row Handler Use Only.
303: --
304: -- {End Of Comments}
305: -- ----------------------------------------------------------------------------
306: Procedure convert_defs(p_rec in out nocopy ben_bli_shd.g_rec_type) is
307: --
308: l_proc varchar2(72) := g_package||'convert_defs';
309: --
310: Begin

Line 321: ben_bli_shd.g_old_rec.benefit_action_id;

317: -- is being used then we must set to the 'current' argument value.
318: --
319: If (p_rec.benefit_action_id = hr_api.g_number) then
320: p_rec.benefit_action_id :=
321: ben_bli_shd.g_old_rec.benefit_action_id;
322: End If;
323: If (p_rec.person_id = hr_api.g_number) then
324: p_rec.person_id :=
325: ben_bli_shd.g_old_rec.person_id;

Line 325: ben_bli_shd.g_old_rec.person_id;

321: ben_bli_shd.g_old_rec.benefit_action_id;
322: End If;
323: If (p_rec.person_id = hr_api.g_number) then
324: p_rec.person_id :=
325: ben_bli_shd.g_old_rec.person_id;
326: End If;
327: If (p_rec.ler_id = hr_api.g_number) then
328: p_rec.ler_id :=
329: ben_bli_shd.g_old_rec.ler_id;

Line 329: ben_bli_shd.g_old_rec.ler_id;

325: ben_bli_shd.g_old_rec.person_id;
326: End If;
327: If (p_rec.ler_id = hr_api.g_number) then
328: p_rec.ler_id :=
329: ben_bli_shd.g_old_rec.ler_id;
330: End If;
331: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
332: p_rec.lf_evt_ocrd_dt :=
333: ben_bli_shd.g_old_rec.lf_evt_ocrd_dt;

Line 333: ben_bli_shd.g_old_rec.lf_evt_ocrd_dt;

329: ben_bli_shd.g_old_rec.ler_id;
330: End If;
331: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
332: p_rec.lf_evt_ocrd_dt :=
333: ben_bli_shd.g_old_rec.lf_evt_ocrd_dt;
334: End If;
335: If (p_rec.replcd_flag = hr_api.g_varchar2) then
336: p_rec.replcd_flag :=
337: ben_bli_shd.g_old_rec.replcd_flag;

Line 337: ben_bli_shd.g_old_rec.replcd_flag;

333: ben_bli_shd.g_old_rec.lf_evt_ocrd_dt;
334: End If;
335: If (p_rec.replcd_flag = hr_api.g_varchar2) then
336: p_rec.replcd_flag :=
337: ben_bli_shd.g_old_rec.replcd_flag;
338: End If;
339: If (p_rec.crtd_flag = hr_api.g_varchar2) then
340: p_rec.crtd_flag :=
341: ben_bli_shd.g_old_rec.crtd_flag;

Line 341: ben_bli_shd.g_old_rec.crtd_flag;

337: ben_bli_shd.g_old_rec.replcd_flag;
338: End If;
339: If (p_rec.crtd_flag = hr_api.g_varchar2) then
340: p_rec.crtd_flag :=
341: ben_bli_shd.g_old_rec.crtd_flag;
342: End If;
343: If (p_rec.tmprl_flag = hr_api.g_varchar2) then
344: p_rec.tmprl_flag :=
345: ben_bli_shd.g_old_rec.tmprl_flag;

Line 345: ben_bli_shd.g_old_rec.tmprl_flag;

341: ben_bli_shd.g_old_rec.crtd_flag;
342: End If;
343: If (p_rec.tmprl_flag = hr_api.g_varchar2) then
344: p_rec.tmprl_flag :=
345: ben_bli_shd.g_old_rec.tmprl_flag;
346: End If;
347: If (p_rec.dltd_flag = hr_api.g_varchar2) then
348: p_rec.dltd_flag :=
349: ben_bli_shd.g_old_rec.dltd_flag;

Line 349: ben_bli_shd.g_old_rec.dltd_flag;

345: ben_bli_shd.g_old_rec.tmprl_flag;
346: End If;
347: If (p_rec.dltd_flag = hr_api.g_varchar2) then
348: p_rec.dltd_flag :=
349: ben_bli_shd.g_old_rec.dltd_flag;
350: End If;
351: If (p_rec.open_and_clsd_flag = hr_api.g_varchar2) then
352: p_rec.open_and_clsd_flag :=
353: ben_bli_shd.g_old_rec.open_and_clsd_flag;

Line 353: ben_bli_shd.g_old_rec.open_and_clsd_flag;

349: ben_bli_shd.g_old_rec.dltd_flag;
350: End If;
351: If (p_rec.open_and_clsd_flag = hr_api.g_varchar2) then
352: p_rec.open_and_clsd_flag :=
353: ben_bli_shd.g_old_rec.open_and_clsd_flag;
354: End If;
355: If (p_rec.clsd_flag = hr_api.g_varchar2) then
356: p_rec.clsd_flag :=
357: ben_bli_shd.g_old_rec.clsd_flag;

Line 357: ben_bli_shd.g_old_rec.clsd_flag;

353: ben_bli_shd.g_old_rec.open_and_clsd_flag;
354: End If;
355: If (p_rec.clsd_flag = hr_api.g_varchar2) then
356: p_rec.clsd_flag :=
357: ben_bli_shd.g_old_rec.clsd_flag;
358: End If;
359: If (p_rec.not_crtd_flag = hr_api.g_varchar2) then
360: p_rec.not_crtd_flag :=
361: ben_bli_shd.g_old_rec.not_crtd_flag;

Line 361: ben_bli_shd.g_old_rec.not_crtd_flag;

357: ben_bli_shd.g_old_rec.clsd_flag;
358: End If;
359: If (p_rec.not_crtd_flag = hr_api.g_varchar2) then
360: p_rec.not_crtd_flag :=
361: ben_bli_shd.g_old_rec.not_crtd_flag;
362: End If;
363: If (p_rec.stl_actv_flag = hr_api.g_varchar2) then
364: p_rec.stl_actv_flag :=
365: ben_bli_shd.g_old_rec.stl_actv_flag;

Line 365: ben_bli_shd.g_old_rec.stl_actv_flag;

361: ben_bli_shd.g_old_rec.not_crtd_flag;
362: End If;
363: If (p_rec.stl_actv_flag = hr_api.g_varchar2) then
364: p_rec.stl_actv_flag :=
365: ben_bli_shd.g_old_rec.stl_actv_flag;
366: End If;
367: If (p_rec.clpsd_flag = hr_api.g_varchar2) then
368: p_rec.clpsd_flag :=
369: ben_bli_shd.g_old_rec.clpsd_flag;

Line 369: ben_bli_shd.g_old_rec.clpsd_flag;

365: ben_bli_shd.g_old_rec.stl_actv_flag;
366: End If;
367: If (p_rec.clpsd_flag = hr_api.g_varchar2) then
368: p_rec.clpsd_flag :=
369: ben_bli_shd.g_old_rec.clpsd_flag;
370: End If;
371: If (p_rec.clsn_flag = hr_api.g_varchar2) then
372: p_rec.clsn_flag :=
373: ben_bli_shd.g_old_rec.clsn_flag;

Line 373: ben_bli_shd.g_old_rec.clsn_flag;

369: ben_bli_shd.g_old_rec.clpsd_flag;
370: End If;
371: If (p_rec.clsn_flag = hr_api.g_varchar2) then
372: p_rec.clsn_flag :=
373: ben_bli_shd.g_old_rec.clsn_flag;
374: End If;
375: If (p_rec.no_effect_flag = hr_api.g_varchar2) then
376: p_rec.no_effect_flag :=
377: ben_bli_shd.g_old_rec.no_effect_flag;

Line 377: ben_bli_shd.g_old_rec.no_effect_flag;

373: ben_bli_shd.g_old_rec.clsn_flag;
374: End If;
375: If (p_rec.no_effect_flag = hr_api.g_varchar2) then
376: p_rec.no_effect_flag :=
377: ben_bli_shd.g_old_rec.no_effect_flag;
378: End If;
379: If (p_rec.cvrge_rt_prem_flag = hr_api.g_varchar2) then
380: p_rec.cvrge_rt_prem_flag :=
381: ben_bli_shd.g_old_rec.cvrge_rt_prem_flag;

Line 381: ben_bli_shd.g_old_rec.cvrge_rt_prem_flag;

377: ben_bli_shd.g_old_rec.no_effect_flag;
378: End If;
379: If (p_rec.cvrge_rt_prem_flag = hr_api.g_varchar2) then
380: p_rec.cvrge_rt_prem_flag :=
381: ben_bli_shd.g_old_rec.cvrge_rt_prem_flag;
382: End If;
383: If (p_rec.per_in_ler_id = hr_api.g_number) then
384: p_rec.per_in_ler_id :=
385: ben_bli_shd.g_old_rec.per_in_ler_id;

Line 385: ben_bli_shd.g_old_rec.per_in_ler_id;

381: ben_bli_shd.g_old_rec.cvrge_rt_prem_flag;
382: End If;
383: If (p_rec.per_in_ler_id = hr_api.g_number) then
384: p_rec.per_in_ler_id :=
385: ben_bli_shd.g_old_rec.per_in_ler_id;
386: End If;
387: If (p_rec.business_group_id = hr_api.g_number) then
388: p_rec.business_group_id :=
389: ben_bli_shd.g_old_rec.business_group_id;

Line 389: ben_bli_shd.g_old_rec.business_group_id;

385: ben_bli_shd.g_old_rec.per_in_ler_id;
386: End If;
387: If (p_rec.business_group_id = hr_api.g_number) then
388: p_rec.business_group_id :=
389: ben_bli_shd.g_old_rec.business_group_id;
390: End If;
391:
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 403: p_rec in out nocopy ben_bli_shd.g_rec_type

399: -- ----------------------------------------------------------------------------
400: Procedure upd
401: (
402: p_effective_date in date,
403: p_rec in out nocopy ben_bli_shd.g_rec_type
404: ) is
405: --
406: l_proc varchar2(72) := g_package||'upd';
407: --

Line 413: ben_bli_shd.lck

409: hr_utility.set_location('Entering:'||l_proc, 5);
410: --
411: -- We must lock the row which we need to update.
412: --
413: ben_bli_shd.lck
414: (
415: p_rec.batch_ler_id,
416: p_rec.object_version_number
417: );

Line 470: l_rec ben_bli_shd.g_rec_type;

466: p_business_group_id in number default hr_api.g_number,
467: p_object_version_number in out nocopy number
468: ) is
469: --
470: l_rec ben_bli_shd.g_rec_type;
471: l_proc varchar2(72) := g_package||'upd';
472: --
473: Begin
474: hr_utility.set_location('Entering:'||l_proc, 5);

Line 480: ben_bli_shd.convert_args

476: -- Call conversion function to turn arguments into the
477: -- l_rec structure.
478: --
479: l_rec :=
480: ben_bli_shd.convert_args
481: (
482: p_batch_ler_id,
483: p_benefit_action_id,
484: p_person_id,