[Home] [Help]
50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_egd_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_egd_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_elig_dpnt Row
68: --
69: update ben_elig_dpnt
120: program_update_date = p_rec.program_update_date,
121: object_version_number = p_rec.object_version_number
122: where elig_dpnt_id = p_rec.elig_dpnt_id;
123: --
124: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: --
128: Exception
127: --
128: Exception
129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
131: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
132: ben_egd_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
128: Exception
129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
131: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
132: ben_egd_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
132: ben_egd_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
137: ben_egd_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
137: ben_egd_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
137: ben_egd_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
142: ben_egd_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others Then
145: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
142: ben_egd_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others Then
145: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
146: Raise;
141: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
142: ben_egd_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others Then
145: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
146: Raise;
147: End update_dml;
148: --
149: -- ----------------------------------------------------------------------------
177: -- Internal Row Handler Use Only.
178: --
179: -- {End Of Comments}
180: -- ----------------------------------------------------------------------------
181: Procedure pre_update(p_rec in ben_egd_shd.g_rec_type) is
182: --
183: l_proc varchar2(72) := g_package||'pre_update';
184: --
185: Begin
220: --
221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure post_update(
224: p_effective_date in date,p_rec in ben_egd_shd.g_rec_type) is
225: --
226: l_proc varchar2(72) := g_package||'post_update';
227: --
228: l_old_rec ben_egd_ler.g_egd_ler_rec;
232: hr_utility.set_location('Entering:'||l_proc, 5);
233: --
234: -- Life event trigger
235: --
236: l_old_rec.business_group_id := ben_egd_shd.g_old_rec.business_group_id;
237: l_old_rec.dpnt_person_id := ben_egd_shd.g_old_rec.dpnt_person_id;
238: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
239: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
240: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
233: --
234: -- Life event trigger
235: --
236: l_old_rec.business_group_id := ben_egd_shd.g_old_rec.business_group_id;
237: l_old_rec.dpnt_person_id := ben_egd_shd.g_old_rec.dpnt_person_id;
238: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
239: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
240: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
241: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
234: -- Life event trigger
235: --
236: l_old_rec.business_group_id := ben_egd_shd.g_old_rec.business_group_id;
237: l_old_rec.dpnt_person_id := ben_egd_shd.g_old_rec.dpnt_person_id;
238: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
239: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
240: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
241: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
242: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
235: --
236: l_old_rec.business_group_id := ben_egd_shd.g_old_rec.business_group_id;
237: l_old_rec.dpnt_person_id := ben_egd_shd.g_old_rec.dpnt_person_id;
238: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
239: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
240: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
241: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
242: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
243: l_old_rec.create_dt := ben_egd_shd.g_old_rec.create_dt;
236: l_old_rec.business_group_id := ben_egd_shd.g_old_rec.business_group_id;
237: l_old_rec.dpnt_person_id := ben_egd_shd.g_old_rec.dpnt_person_id;
238: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
239: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
240: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
241: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
242: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
243: l_old_rec.create_dt := ben_egd_shd.g_old_rec.create_dt;
244: l_old_rec.per_in_ler_id := ben_egd_shd.g_old_rec.per_in_ler_id;
237: l_old_rec.dpnt_person_id := ben_egd_shd.g_old_rec.dpnt_person_id;
238: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
239: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
240: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
241: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
242: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
243: l_old_rec.create_dt := ben_egd_shd.g_old_rec.create_dt;
244: l_old_rec.per_in_ler_id := ben_egd_shd.g_old_rec.per_in_ler_id;
245: --
238: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
239: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
240: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
241: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
242: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
243: l_old_rec.create_dt := ben_egd_shd.g_old_rec.create_dt;
244: l_old_rec.per_in_ler_id := ben_egd_shd.g_old_rec.per_in_ler_id;
245: --
246: l_new_rec.business_group_id := p_rec.business_group_id;
239: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
240: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
241: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
242: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
243: l_old_rec.create_dt := ben_egd_shd.g_old_rec.create_dt;
244: l_old_rec.per_in_ler_id := ben_egd_shd.g_old_rec.per_in_ler_id;
245: --
246: l_new_rec.business_group_id := p_rec.business_group_id;
247: l_new_rec.dpnt_person_id := p_rec.dpnt_person_id;
240: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
241: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
242: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
243: l_old_rec.create_dt := ben_egd_shd.g_old_rec.create_dt;
244: l_old_rec.per_in_ler_id := ben_egd_shd.g_old_rec.per_in_ler_id;
245: --
246: l_new_rec.business_group_id := p_rec.business_group_id;
247: l_new_rec.dpnt_person_id := p_rec.dpnt_person_id;
248: l_new_rec.elig_strt_dt := p_rec.elig_strt_dt;
314: ,p_program_id =>p_rec.program_id
315: ,p_program_update_date =>p_rec.program_update_date
316: ,p_object_version_number =>p_rec.object_version_number
317: ,p_effective_date =>p_effective_date
318: ,p_create_dt_o =>ben_egd_shd.g_old_rec.create_dt
319: ,p_elig_strt_dt_o =>ben_egd_shd.g_old_rec.elig_strt_dt
320: ,p_elig_thru_dt_o =>ben_egd_shd.g_old_rec.elig_thru_dt
321: ,p_ovrdn_flag_o =>ben_egd_shd.g_old_rec.ovrdn_flag
322: ,p_ovrdn_thru_dt_o =>ben_egd_shd.g_old_rec.ovrdn_thru_dt
315: ,p_program_update_date =>p_rec.program_update_date
316: ,p_object_version_number =>p_rec.object_version_number
317: ,p_effective_date =>p_effective_date
318: ,p_create_dt_o =>ben_egd_shd.g_old_rec.create_dt
319: ,p_elig_strt_dt_o =>ben_egd_shd.g_old_rec.elig_strt_dt
320: ,p_elig_thru_dt_o =>ben_egd_shd.g_old_rec.elig_thru_dt
321: ,p_ovrdn_flag_o =>ben_egd_shd.g_old_rec.ovrdn_flag
322: ,p_ovrdn_thru_dt_o =>ben_egd_shd.g_old_rec.ovrdn_thru_dt
323: ,p_inelg_rsn_cd_o =>ben_egd_shd.g_old_rec.inelg_rsn_cd
316: ,p_object_version_number =>p_rec.object_version_number
317: ,p_effective_date =>p_effective_date
318: ,p_create_dt_o =>ben_egd_shd.g_old_rec.create_dt
319: ,p_elig_strt_dt_o =>ben_egd_shd.g_old_rec.elig_strt_dt
320: ,p_elig_thru_dt_o =>ben_egd_shd.g_old_rec.elig_thru_dt
321: ,p_ovrdn_flag_o =>ben_egd_shd.g_old_rec.ovrdn_flag
322: ,p_ovrdn_thru_dt_o =>ben_egd_shd.g_old_rec.ovrdn_thru_dt
323: ,p_inelg_rsn_cd_o =>ben_egd_shd.g_old_rec.inelg_rsn_cd
324: ,p_dpnt_inelig_flag_o =>ben_egd_shd.g_old_rec.dpnt_inelig_flag
317: ,p_effective_date =>p_effective_date
318: ,p_create_dt_o =>ben_egd_shd.g_old_rec.create_dt
319: ,p_elig_strt_dt_o =>ben_egd_shd.g_old_rec.elig_strt_dt
320: ,p_elig_thru_dt_o =>ben_egd_shd.g_old_rec.elig_thru_dt
321: ,p_ovrdn_flag_o =>ben_egd_shd.g_old_rec.ovrdn_flag
322: ,p_ovrdn_thru_dt_o =>ben_egd_shd.g_old_rec.ovrdn_thru_dt
323: ,p_inelg_rsn_cd_o =>ben_egd_shd.g_old_rec.inelg_rsn_cd
324: ,p_dpnt_inelig_flag_o =>ben_egd_shd.g_old_rec.dpnt_inelig_flag
325: ,p_elig_per_elctbl_chc_id_o =>ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id
318: ,p_create_dt_o =>ben_egd_shd.g_old_rec.create_dt
319: ,p_elig_strt_dt_o =>ben_egd_shd.g_old_rec.elig_strt_dt
320: ,p_elig_thru_dt_o =>ben_egd_shd.g_old_rec.elig_thru_dt
321: ,p_ovrdn_flag_o =>ben_egd_shd.g_old_rec.ovrdn_flag
322: ,p_ovrdn_thru_dt_o =>ben_egd_shd.g_old_rec.ovrdn_thru_dt
323: ,p_inelg_rsn_cd_o =>ben_egd_shd.g_old_rec.inelg_rsn_cd
324: ,p_dpnt_inelig_flag_o =>ben_egd_shd.g_old_rec.dpnt_inelig_flag
325: ,p_elig_per_elctbl_chc_id_o =>ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id
326: ,p_per_in_ler_id_o =>ben_egd_shd.g_old_rec.per_in_ler_id
319: ,p_elig_strt_dt_o =>ben_egd_shd.g_old_rec.elig_strt_dt
320: ,p_elig_thru_dt_o =>ben_egd_shd.g_old_rec.elig_thru_dt
321: ,p_ovrdn_flag_o =>ben_egd_shd.g_old_rec.ovrdn_flag
322: ,p_ovrdn_thru_dt_o =>ben_egd_shd.g_old_rec.ovrdn_thru_dt
323: ,p_inelg_rsn_cd_o =>ben_egd_shd.g_old_rec.inelg_rsn_cd
324: ,p_dpnt_inelig_flag_o =>ben_egd_shd.g_old_rec.dpnt_inelig_flag
325: ,p_elig_per_elctbl_chc_id_o =>ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id
326: ,p_per_in_ler_id_o =>ben_egd_shd.g_old_rec.per_in_ler_id
327: ,p_elig_per_id_o =>ben_egd_shd.g_old_rec.elig_per_id
320: ,p_elig_thru_dt_o =>ben_egd_shd.g_old_rec.elig_thru_dt
321: ,p_ovrdn_flag_o =>ben_egd_shd.g_old_rec.ovrdn_flag
322: ,p_ovrdn_thru_dt_o =>ben_egd_shd.g_old_rec.ovrdn_thru_dt
323: ,p_inelg_rsn_cd_o =>ben_egd_shd.g_old_rec.inelg_rsn_cd
324: ,p_dpnt_inelig_flag_o =>ben_egd_shd.g_old_rec.dpnt_inelig_flag
325: ,p_elig_per_elctbl_chc_id_o =>ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id
326: ,p_per_in_ler_id_o =>ben_egd_shd.g_old_rec.per_in_ler_id
327: ,p_elig_per_id_o =>ben_egd_shd.g_old_rec.elig_per_id
328: ,p_elig_per_opt_id_o =>ben_egd_shd.g_old_rec.elig_per_opt_id
321: ,p_ovrdn_flag_o =>ben_egd_shd.g_old_rec.ovrdn_flag
322: ,p_ovrdn_thru_dt_o =>ben_egd_shd.g_old_rec.ovrdn_thru_dt
323: ,p_inelg_rsn_cd_o =>ben_egd_shd.g_old_rec.inelg_rsn_cd
324: ,p_dpnt_inelig_flag_o =>ben_egd_shd.g_old_rec.dpnt_inelig_flag
325: ,p_elig_per_elctbl_chc_id_o =>ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id
326: ,p_per_in_ler_id_o =>ben_egd_shd.g_old_rec.per_in_ler_id
327: ,p_elig_per_id_o =>ben_egd_shd.g_old_rec.elig_per_id
328: ,p_elig_per_opt_id_o =>ben_egd_shd.g_old_rec.elig_per_opt_id
329: ,p_elig_cvrd_dpnt_id_o =>ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id
322: ,p_ovrdn_thru_dt_o =>ben_egd_shd.g_old_rec.ovrdn_thru_dt
323: ,p_inelg_rsn_cd_o =>ben_egd_shd.g_old_rec.inelg_rsn_cd
324: ,p_dpnt_inelig_flag_o =>ben_egd_shd.g_old_rec.dpnt_inelig_flag
325: ,p_elig_per_elctbl_chc_id_o =>ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id
326: ,p_per_in_ler_id_o =>ben_egd_shd.g_old_rec.per_in_ler_id
327: ,p_elig_per_id_o =>ben_egd_shd.g_old_rec.elig_per_id
328: ,p_elig_per_opt_id_o =>ben_egd_shd.g_old_rec.elig_per_opt_id
329: ,p_elig_cvrd_dpnt_id_o =>ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id
330: ,p_dpnt_person_id_o =>ben_egd_shd.g_old_rec.dpnt_person_id
323: ,p_inelg_rsn_cd_o =>ben_egd_shd.g_old_rec.inelg_rsn_cd
324: ,p_dpnt_inelig_flag_o =>ben_egd_shd.g_old_rec.dpnt_inelig_flag
325: ,p_elig_per_elctbl_chc_id_o =>ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id
326: ,p_per_in_ler_id_o =>ben_egd_shd.g_old_rec.per_in_ler_id
327: ,p_elig_per_id_o =>ben_egd_shd.g_old_rec.elig_per_id
328: ,p_elig_per_opt_id_o =>ben_egd_shd.g_old_rec.elig_per_opt_id
329: ,p_elig_cvrd_dpnt_id_o =>ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id
330: ,p_dpnt_person_id_o =>ben_egd_shd.g_old_rec.dpnt_person_id
331: ,p_business_group_id_o =>ben_egd_shd.g_old_rec.business_group_id
324: ,p_dpnt_inelig_flag_o =>ben_egd_shd.g_old_rec.dpnt_inelig_flag
325: ,p_elig_per_elctbl_chc_id_o =>ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id
326: ,p_per_in_ler_id_o =>ben_egd_shd.g_old_rec.per_in_ler_id
327: ,p_elig_per_id_o =>ben_egd_shd.g_old_rec.elig_per_id
328: ,p_elig_per_opt_id_o =>ben_egd_shd.g_old_rec.elig_per_opt_id
329: ,p_elig_cvrd_dpnt_id_o =>ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id
330: ,p_dpnt_person_id_o =>ben_egd_shd.g_old_rec.dpnt_person_id
331: ,p_business_group_id_o =>ben_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o =>ben_egd_shd.g_old_rec.egd_attribute_category
325: ,p_elig_per_elctbl_chc_id_o =>ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id
326: ,p_per_in_ler_id_o =>ben_egd_shd.g_old_rec.per_in_ler_id
327: ,p_elig_per_id_o =>ben_egd_shd.g_old_rec.elig_per_id
328: ,p_elig_per_opt_id_o =>ben_egd_shd.g_old_rec.elig_per_opt_id
329: ,p_elig_cvrd_dpnt_id_o =>ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id
330: ,p_dpnt_person_id_o =>ben_egd_shd.g_old_rec.dpnt_person_id
331: ,p_business_group_id_o =>ben_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o =>ben_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o =>ben_egd_shd.g_old_rec.egd_attribute1
326: ,p_per_in_ler_id_o =>ben_egd_shd.g_old_rec.per_in_ler_id
327: ,p_elig_per_id_o =>ben_egd_shd.g_old_rec.elig_per_id
328: ,p_elig_per_opt_id_o =>ben_egd_shd.g_old_rec.elig_per_opt_id
329: ,p_elig_cvrd_dpnt_id_o =>ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id
330: ,p_dpnt_person_id_o =>ben_egd_shd.g_old_rec.dpnt_person_id
331: ,p_business_group_id_o =>ben_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o =>ben_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o =>ben_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o =>ben_egd_shd.g_old_rec.egd_attribute2
327: ,p_elig_per_id_o =>ben_egd_shd.g_old_rec.elig_per_id
328: ,p_elig_per_opt_id_o =>ben_egd_shd.g_old_rec.elig_per_opt_id
329: ,p_elig_cvrd_dpnt_id_o =>ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id
330: ,p_dpnt_person_id_o =>ben_egd_shd.g_old_rec.dpnt_person_id
331: ,p_business_group_id_o =>ben_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o =>ben_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o =>ben_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o =>ben_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o =>ben_egd_shd.g_old_rec.egd_attribute3
328: ,p_elig_per_opt_id_o =>ben_egd_shd.g_old_rec.elig_per_opt_id
329: ,p_elig_cvrd_dpnt_id_o =>ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id
330: ,p_dpnt_person_id_o =>ben_egd_shd.g_old_rec.dpnt_person_id
331: ,p_business_group_id_o =>ben_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o =>ben_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o =>ben_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o =>ben_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o =>ben_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o =>ben_egd_shd.g_old_rec.egd_attribute4
329: ,p_elig_cvrd_dpnt_id_o =>ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id
330: ,p_dpnt_person_id_o =>ben_egd_shd.g_old_rec.dpnt_person_id
331: ,p_business_group_id_o =>ben_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o =>ben_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o =>ben_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o =>ben_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o =>ben_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o =>ben_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o =>ben_egd_shd.g_old_rec.egd_attribute5
330: ,p_dpnt_person_id_o =>ben_egd_shd.g_old_rec.dpnt_person_id
331: ,p_business_group_id_o =>ben_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o =>ben_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o =>ben_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o =>ben_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o =>ben_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o =>ben_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o =>ben_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o =>ben_egd_shd.g_old_rec.egd_attribute6
331: ,p_business_group_id_o =>ben_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o =>ben_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o =>ben_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o =>ben_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o =>ben_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o =>ben_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o =>ben_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o =>ben_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o =>ben_egd_shd.g_old_rec.egd_attribute7
332: ,p_egd_attribute_category_o =>ben_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o =>ben_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o =>ben_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o =>ben_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o =>ben_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o =>ben_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o =>ben_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o =>ben_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o =>ben_egd_shd.g_old_rec.egd_attribute8
333: ,p_egd_attribute1_o =>ben_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o =>ben_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o =>ben_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o =>ben_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o =>ben_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o =>ben_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o =>ben_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o =>ben_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o =>ben_egd_shd.g_old_rec.egd_attribute9
334: ,p_egd_attribute2_o =>ben_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o =>ben_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o =>ben_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o =>ben_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o =>ben_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o =>ben_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o =>ben_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o =>ben_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o =>ben_egd_shd.g_old_rec.egd_attribute10
335: ,p_egd_attribute3_o =>ben_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o =>ben_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o =>ben_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o =>ben_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o =>ben_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o =>ben_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o =>ben_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o =>ben_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o =>ben_egd_shd.g_old_rec.egd_attribute11
336: ,p_egd_attribute4_o =>ben_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o =>ben_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o =>ben_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o =>ben_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o =>ben_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o =>ben_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o =>ben_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o =>ben_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o =>ben_egd_shd.g_old_rec.egd_attribute12
337: ,p_egd_attribute5_o =>ben_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o =>ben_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o =>ben_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o =>ben_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o =>ben_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o =>ben_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o =>ben_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o =>ben_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o =>ben_egd_shd.g_old_rec.egd_attribute13
338: ,p_egd_attribute6_o =>ben_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o =>ben_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o =>ben_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o =>ben_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o =>ben_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o =>ben_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o =>ben_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o =>ben_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o =>ben_egd_shd.g_old_rec.egd_attribute14
339: ,p_egd_attribute7_o =>ben_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o =>ben_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o =>ben_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o =>ben_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o =>ben_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o =>ben_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o =>ben_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o =>ben_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o =>ben_egd_shd.g_old_rec.egd_attribute15
340: ,p_egd_attribute8_o =>ben_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o =>ben_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o =>ben_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o =>ben_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o =>ben_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o =>ben_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o =>ben_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o =>ben_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o =>ben_egd_shd.g_old_rec.egd_attribute16
341: ,p_egd_attribute9_o =>ben_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o =>ben_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o =>ben_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o =>ben_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o =>ben_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o =>ben_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o =>ben_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o =>ben_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o =>ben_egd_shd.g_old_rec.egd_attribute17
342: ,p_egd_attribute10_o =>ben_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o =>ben_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o =>ben_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o =>ben_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o =>ben_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o =>ben_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o =>ben_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o =>ben_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o =>ben_egd_shd.g_old_rec.egd_attribute18
343: ,p_egd_attribute11_o =>ben_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o =>ben_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o =>ben_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o =>ben_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o =>ben_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o =>ben_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o =>ben_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o =>ben_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o =>ben_egd_shd.g_old_rec.egd_attribute19
344: ,p_egd_attribute12_o =>ben_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o =>ben_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o =>ben_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o =>ben_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o =>ben_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o =>ben_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o =>ben_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o =>ben_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o =>ben_egd_shd.g_old_rec.egd_attribute20
345: ,p_egd_attribute13_o =>ben_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o =>ben_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o =>ben_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o =>ben_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o =>ben_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o =>ben_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o =>ben_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o =>ben_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o =>ben_egd_shd.g_old_rec.egd_attribute21
346: ,p_egd_attribute14_o =>ben_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o =>ben_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o =>ben_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o =>ben_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o =>ben_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o =>ben_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o =>ben_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o =>ben_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o =>ben_egd_shd.g_old_rec.egd_attribute22
347: ,p_egd_attribute15_o =>ben_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o =>ben_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o =>ben_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o =>ben_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o =>ben_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o =>ben_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o =>ben_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o =>ben_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o =>ben_egd_shd.g_old_rec.egd_attribute23
348: ,p_egd_attribute16_o =>ben_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o =>ben_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o =>ben_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o =>ben_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o =>ben_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o =>ben_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o =>ben_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o =>ben_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o =>ben_egd_shd.g_old_rec.egd_attribute24
349: ,p_egd_attribute17_o =>ben_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o =>ben_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o =>ben_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o =>ben_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o =>ben_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o =>ben_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o =>ben_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o =>ben_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o =>ben_egd_shd.g_old_rec.egd_attribute25
350: ,p_egd_attribute18_o =>ben_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o =>ben_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o =>ben_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o =>ben_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o =>ben_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o =>ben_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o =>ben_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o =>ben_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o =>ben_egd_shd.g_old_rec.egd_attribute26
351: ,p_egd_attribute19_o =>ben_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o =>ben_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o =>ben_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o =>ben_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o =>ben_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o =>ben_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o =>ben_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o =>ben_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o =>ben_egd_shd.g_old_rec.egd_attribute27
352: ,p_egd_attribute20_o =>ben_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o =>ben_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o =>ben_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o =>ben_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o =>ben_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o =>ben_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o =>ben_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o =>ben_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o =>ben_egd_shd.g_old_rec.egd_attribute28
353: ,p_egd_attribute21_o =>ben_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o =>ben_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o =>ben_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o =>ben_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o =>ben_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o =>ben_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o =>ben_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o =>ben_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o =>ben_egd_shd.g_old_rec.egd_attribute29
354: ,p_egd_attribute22_o =>ben_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o =>ben_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o =>ben_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o =>ben_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o =>ben_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o =>ben_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o =>ben_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o =>ben_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o =>ben_egd_shd.g_old_rec.egd_attribute30
355: ,p_egd_attribute23_o =>ben_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o =>ben_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o =>ben_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o =>ben_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o =>ben_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o =>ben_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o =>ben_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o =>ben_egd_shd.g_old_rec.egd_attribute30
363: ,p_request_id_o =>ben_egd_shd.g_old_rec.request_id
356: ,p_egd_attribute24_o =>ben_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o =>ben_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o =>ben_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o =>ben_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o =>ben_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o =>ben_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o =>ben_egd_shd.g_old_rec.egd_attribute30
363: ,p_request_id_o =>ben_egd_shd.g_old_rec.request_id
364: ,p_program_application_id_o =>ben_egd_shd.g_old_rec.program_application_id
357: ,p_egd_attribute25_o =>ben_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o =>ben_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o =>ben_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o =>ben_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o =>ben_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o =>ben_egd_shd.g_old_rec.egd_attribute30
363: ,p_request_id_o =>ben_egd_shd.g_old_rec.request_id
364: ,p_program_application_id_o =>ben_egd_shd.g_old_rec.program_application_id
365: ,p_program_id_o =>ben_egd_shd.g_old_rec.program_id
358: ,p_egd_attribute26_o =>ben_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o =>ben_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o =>ben_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o =>ben_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o =>ben_egd_shd.g_old_rec.egd_attribute30
363: ,p_request_id_o =>ben_egd_shd.g_old_rec.request_id
364: ,p_program_application_id_o =>ben_egd_shd.g_old_rec.program_application_id
365: ,p_program_id_o =>ben_egd_shd.g_old_rec.program_id
366: ,p_program_update_date_o =>ben_egd_shd.g_old_rec.program_update_date
359: ,p_egd_attribute27_o =>ben_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o =>ben_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o =>ben_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o =>ben_egd_shd.g_old_rec.egd_attribute30
363: ,p_request_id_o =>ben_egd_shd.g_old_rec.request_id
364: ,p_program_application_id_o =>ben_egd_shd.g_old_rec.program_application_id
365: ,p_program_id_o =>ben_egd_shd.g_old_rec.program_id
366: ,p_program_update_date_o =>ben_egd_shd.g_old_rec.program_update_date
367: ,p_object_version_number_o =>ben_egd_shd.g_old_rec.object_version_number
360: ,p_egd_attribute28_o =>ben_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o =>ben_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o =>ben_egd_shd.g_old_rec.egd_attribute30
363: ,p_request_id_o =>ben_egd_shd.g_old_rec.request_id
364: ,p_program_application_id_o =>ben_egd_shd.g_old_rec.program_application_id
365: ,p_program_id_o =>ben_egd_shd.g_old_rec.program_id
366: ,p_program_update_date_o =>ben_egd_shd.g_old_rec.program_update_date
367: ,p_object_version_number_o =>ben_egd_shd.g_old_rec.object_version_number
368: );
361: ,p_egd_attribute29_o =>ben_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o =>ben_egd_shd.g_old_rec.egd_attribute30
363: ,p_request_id_o =>ben_egd_shd.g_old_rec.request_id
364: ,p_program_application_id_o =>ben_egd_shd.g_old_rec.program_application_id
365: ,p_program_id_o =>ben_egd_shd.g_old_rec.program_id
366: ,p_program_update_date_o =>ben_egd_shd.g_old_rec.program_update_date
367: ,p_object_version_number_o =>ben_egd_shd.g_old_rec.object_version_number
368: );
369: --
362: ,p_egd_attribute30_o =>ben_egd_shd.g_old_rec.egd_attribute30
363: ,p_request_id_o =>ben_egd_shd.g_old_rec.request_id
364: ,p_program_application_id_o =>ben_egd_shd.g_old_rec.program_application_id
365: ,p_program_id_o =>ben_egd_shd.g_old_rec.program_id
366: ,p_program_update_date_o =>ben_egd_shd.g_old_rec.program_update_date
367: ,p_object_version_number_o =>ben_egd_shd.g_old_rec.object_version_number
368: );
369: --
370: exception
363: ,p_request_id_o =>ben_egd_shd.g_old_rec.request_id
364: ,p_program_application_id_o =>ben_egd_shd.g_old_rec.program_application_id
365: ,p_program_id_o =>ben_egd_shd.g_old_rec.program_id
366: ,p_program_update_date_o =>ben_egd_shd.g_old_rec.program_update_date
367: ,p_object_version_number_o =>ben_egd_shd.g_old_rec.object_version_number
368: );
369: --
370: exception
371: --
425: -- Internal Row Handler Use Only.
426: --
427: -- {End Of Comments}
428: -- ----------------------------------------------------------------------------
429: Procedure convert_defs(p_rec in out nocopy ben_egd_shd.g_rec_type) is
430: --
431: l_proc varchar2(72) := g_package||'convert_defs';
432: --
433: Begin
440: -- is being used then we must set to the 'current' argument value.
441: --
442: If (p_rec.create_dt = hr_api.g_date) then
443: p_rec.create_dt :=
444: ben_egd_shd.g_old_rec.create_dt;
445: End If;
446: If (p_rec.elig_strt_dt = hr_api.g_date) then
447: p_rec.elig_strt_dt :=
448: ben_egd_shd.g_old_rec.elig_strt_dt;
444: ben_egd_shd.g_old_rec.create_dt;
445: End If;
446: If (p_rec.elig_strt_dt = hr_api.g_date) then
447: p_rec.elig_strt_dt :=
448: ben_egd_shd.g_old_rec.elig_strt_dt;
449: End If;
450: If (p_rec.elig_thru_dt = hr_api.g_date) then
451: p_rec.elig_thru_dt :=
452: ben_egd_shd.g_old_rec.elig_thru_dt;
448: ben_egd_shd.g_old_rec.elig_strt_dt;
449: End If;
450: If (p_rec.elig_thru_dt = hr_api.g_date) then
451: p_rec.elig_thru_dt :=
452: ben_egd_shd.g_old_rec.elig_thru_dt;
453: End If;
454: If (p_rec.ovrdn_flag = hr_api.g_varchar2) then
455: p_rec.ovrdn_flag :=
456: ben_egd_shd.g_old_rec.ovrdn_flag;
452: ben_egd_shd.g_old_rec.elig_thru_dt;
453: End If;
454: If (p_rec.ovrdn_flag = hr_api.g_varchar2) then
455: p_rec.ovrdn_flag :=
456: ben_egd_shd.g_old_rec.ovrdn_flag;
457: End If;
458: If (p_rec.ovrdn_thru_dt = hr_api.g_date) then
459: p_rec.ovrdn_thru_dt :=
460: ben_egd_shd.g_old_rec.ovrdn_thru_dt;
456: ben_egd_shd.g_old_rec.ovrdn_flag;
457: End If;
458: If (p_rec.ovrdn_thru_dt = hr_api.g_date) then
459: p_rec.ovrdn_thru_dt :=
460: ben_egd_shd.g_old_rec.ovrdn_thru_dt;
461: End If;
462: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
463: p_rec.inelg_rsn_cd :=
464: ben_egd_shd.g_old_rec.inelg_rsn_cd;
460: ben_egd_shd.g_old_rec.ovrdn_thru_dt;
461: End If;
462: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
463: p_rec.inelg_rsn_cd :=
464: ben_egd_shd.g_old_rec.inelg_rsn_cd;
465: End If;
466: If (p_rec.dpnt_inelig_flag = hr_api.g_varchar2) then
467: p_rec.dpnt_inelig_flag :=
468: ben_egd_shd.g_old_rec.dpnt_inelig_flag;
464: ben_egd_shd.g_old_rec.inelg_rsn_cd;
465: End If;
466: If (p_rec.dpnt_inelig_flag = hr_api.g_varchar2) then
467: p_rec.dpnt_inelig_flag :=
468: ben_egd_shd.g_old_rec.dpnt_inelig_flag;
469: End If;
470: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then
471: p_rec.elig_per_elctbl_chc_id :=
472: ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id;
468: ben_egd_shd.g_old_rec.dpnt_inelig_flag;
469: End If;
470: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then
471: p_rec.elig_per_elctbl_chc_id :=
472: ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id;
473: End If;
474: If (p_rec.per_in_ler_id = hr_api.g_number) then
475: p_rec.per_in_ler_id :=
476: ben_egd_shd.g_old_rec.per_in_ler_id;
472: ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id;
473: End If;
474: If (p_rec.per_in_ler_id = hr_api.g_number) then
475: p_rec.per_in_ler_id :=
476: ben_egd_shd.g_old_rec.per_in_ler_id;
477: End If;
478: If (p_rec.elig_per_id = hr_api.g_number) then
479: p_rec.elig_per_id :=
480: ben_egd_shd.g_old_rec.elig_per_id;
476: ben_egd_shd.g_old_rec.per_in_ler_id;
477: End If;
478: If (p_rec.elig_per_id = hr_api.g_number) then
479: p_rec.elig_per_id :=
480: ben_egd_shd.g_old_rec.elig_per_id;
481: End If;
482: If (p_rec.elig_per_opt_id = hr_api.g_number) then
483: p_rec.elig_per_opt_id :=
484: ben_egd_shd.g_old_rec.elig_per_opt_id;
480: ben_egd_shd.g_old_rec.elig_per_id;
481: End If;
482: If (p_rec.elig_per_opt_id = hr_api.g_number) then
483: p_rec.elig_per_opt_id :=
484: ben_egd_shd.g_old_rec.elig_per_opt_id;
485: End If;
486: If (p_rec.elig_cvrd_dpnt_id = hr_api.g_number) then
487: p_rec.elig_cvrd_dpnt_id :=
488: ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id;
484: ben_egd_shd.g_old_rec.elig_per_opt_id;
485: End If;
486: If (p_rec.elig_cvrd_dpnt_id = hr_api.g_number) then
487: p_rec.elig_cvrd_dpnt_id :=
488: ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id;
489: End If;
490: If (p_rec.dpnt_person_id = hr_api.g_number) then
491: p_rec.dpnt_person_id :=
492: ben_egd_shd.g_old_rec.dpnt_person_id;
488: ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id;
489: End If;
490: If (p_rec.dpnt_person_id = hr_api.g_number) then
491: p_rec.dpnt_person_id :=
492: ben_egd_shd.g_old_rec.dpnt_person_id;
493: End If;
494: If (p_rec.business_group_id = hr_api.g_number) then
495: p_rec.business_group_id :=
496: ben_egd_shd.g_old_rec.business_group_id;
492: ben_egd_shd.g_old_rec.dpnt_person_id;
493: End If;
494: If (p_rec.business_group_id = hr_api.g_number) then
495: p_rec.business_group_id :=
496: ben_egd_shd.g_old_rec.business_group_id;
497: End If;
498: If (p_rec.egd_attribute_category = hr_api.g_varchar2) then
499: p_rec.egd_attribute_category :=
500: ben_egd_shd.g_old_rec.egd_attribute_category;
496: ben_egd_shd.g_old_rec.business_group_id;
497: End If;
498: If (p_rec.egd_attribute_category = hr_api.g_varchar2) then
499: p_rec.egd_attribute_category :=
500: ben_egd_shd.g_old_rec.egd_attribute_category;
501: End If;
502: If (p_rec.egd_attribute1 = hr_api.g_varchar2) then
503: p_rec.egd_attribute1 :=
504: ben_egd_shd.g_old_rec.egd_attribute1;
500: ben_egd_shd.g_old_rec.egd_attribute_category;
501: End If;
502: If (p_rec.egd_attribute1 = hr_api.g_varchar2) then
503: p_rec.egd_attribute1 :=
504: ben_egd_shd.g_old_rec.egd_attribute1;
505: End If;
506: If (p_rec.egd_attribute2 = hr_api.g_varchar2) then
507: p_rec.egd_attribute2 :=
508: ben_egd_shd.g_old_rec.egd_attribute2;
504: ben_egd_shd.g_old_rec.egd_attribute1;
505: End If;
506: If (p_rec.egd_attribute2 = hr_api.g_varchar2) then
507: p_rec.egd_attribute2 :=
508: ben_egd_shd.g_old_rec.egd_attribute2;
509: End If;
510: If (p_rec.egd_attribute3 = hr_api.g_varchar2) then
511: p_rec.egd_attribute3 :=
512: ben_egd_shd.g_old_rec.egd_attribute3;
508: ben_egd_shd.g_old_rec.egd_attribute2;
509: End If;
510: If (p_rec.egd_attribute3 = hr_api.g_varchar2) then
511: p_rec.egd_attribute3 :=
512: ben_egd_shd.g_old_rec.egd_attribute3;
513: End If;
514: If (p_rec.egd_attribute4 = hr_api.g_varchar2) then
515: p_rec.egd_attribute4 :=
516: ben_egd_shd.g_old_rec.egd_attribute4;
512: ben_egd_shd.g_old_rec.egd_attribute3;
513: End If;
514: If (p_rec.egd_attribute4 = hr_api.g_varchar2) then
515: p_rec.egd_attribute4 :=
516: ben_egd_shd.g_old_rec.egd_attribute4;
517: End If;
518: If (p_rec.egd_attribute5 = hr_api.g_varchar2) then
519: p_rec.egd_attribute5 :=
520: ben_egd_shd.g_old_rec.egd_attribute5;
516: ben_egd_shd.g_old_rec.egd_attribute4;
517: End If;
518: If (p_rec.egd_attribute5 = hr_api.g_varchar2) then
519: p_rec.egd_attribute5 :=
520: ben_egd_shd.g_old_rec.egd_attribute5;
521: End If;
522: If (p_rec.egd_attribute6 = hr_api.g_varchar2) then
523: p_rec.egd_attribute6 :=
524: ben_egd_shd.g_old_rec.egd_attribute6;
520: ben_egd_shd.g_old_rec.egd_attribute5;
521: End If;
522: If (p_rec.egd_attribute6 = hr_api.g_varchar2) then
523: p_rec.egd_attribute6 :=
524: ben_egd_shd.g_old_rec.egd_attribute6;
525: End If;
526: If (p_rec.egd_attribute7 = hr_api.g_varchar2) then
527: p_rec.egd_attribute7 :=
528: ben_egd_shd.g_old_rec.egd_attribute7;
524: ben_egd_shd.g_old_rec.egd_attribute6;
525: End If;
526: If (p_rec.egd_attribute7 = hr_api.g_varchar2) then
527: p_rec.egd_attribute7 :=
528: ben_egd_shd.g_old_rec.egd_attribute7;
529: End If;
530: If (p_rec.egd_attribute8 = hr_api.g_varchar2) then
531: p_rec.egd_attribute8 :=
532: ben_egd_shd.g_old_rec.egd_attribute8;
528: ben_egd_shd.g_old_rec.egd_attribute7;
529: End If;
530: If (p_rec.egd_attribute8 = hr_api.g_varchar2) then
531: p_rec.egd_attribute8 :=
532: ben_egd_shd.g_old_rec.egd_attribute8;
533: End If;
534: If (p_rec.egd_attribute9 = hr_api.g_varchar2) then
535: p_rec.egd_attribute9 :=
536: ben_egd_shd.g_old_rec.egd_attribute9;
532: ben_egd_shd.g_old_rec.egd_attribute8;
533: End If;
534: If (p_rec.egd_attribute9 = hr_api.g_varchar2) then
535: p_rec.egd_attribute9 :=
536: ben_egd_shd.g_old_rec.egd_attribute9;
537: End If;
538: If (p_rec.egd_attribute10 = hr_api.g_varchar2) then
539: p_rec.egd_attribute10 :=
540: ben_egd_shd.g_old_rec.egd_attribute10;
536: ben_egd_shd.g_old_rec.egd_attribute9;
537: End If;
538: If (p_rec.egd_attribute10 = hr_api.g_varchar2) then
539: p_rec.egd_attribute10 :=
540: ben_egd_shd.g_old_rec.egd_attribute10;
541: End If;
542: If (p_rec.egd_attribute11 = hr_api.g_varchar2) then
543: p_rec.egd_attribute11 :=
544: ben_egd_shd.g_old_rec.egd_attribute11;
540: ben_egd_shd.g_old_rec.egd_attribute10;
541: End If;
542: If (p_rec.egd_attribute11 = hr_api.g_varchar2) then
543: p_rec.egd_attribute11 :=
544: ben_egd_shd.g_old_rec.egd_attribute11;
545: End If;
546: If (p_rec.egd_attribute12 = hr_api.g_varchar2) then
547: p_rec.egd_attribute12 :=
548: ben_egd_shd.g_old_rec.egd_attribute12;
544: ben_egd_shd.g_old_rec.egd_attribute11;
545: End If;
546: If (p_rec.egd_attribute12 = hr_api.g_varchar2) then
547: p_rec.egd_attribute12 :=
548: ben_egd_shd.g_old_rec.egd_attribute12;
549: End If;
550: If (p_rec.egd_attribute13 = hr_api.g_varchar2) then
551: p_rec.egd_attribute13 :=
552: ben_egd_shd.g_old_rec.egd_attribute13;
548: ben_egd_shd.g_old_rec.egd_attribute12;
549: End If;
550: If (p_rec.egd_attribute13 = hr_api.g_varchar2) then
551: p_rec.egd_attribute13 :=
552: ben_egd_shd.g_old_rec.egd_attribute13;
553: End If;
554: If (p_rec.egd_attribute14 = hr_api.g_varchar2) then
555: p_rec.egd_attribute14 :=
556: ben_egd_shd.g_old_rec.egd_attribute14;
552: ben_egd_shd.g_old_rec.egd_attribute13;
553: End If;
554: If (p_rec.egd_attribute14 = hr_api.g_varchar2) then
555: p_rec.egd_attribute14 :=
556: ben_egd_shd.g_old_rec.egd_attribute14;
557: End If;
558: If (p_rec.egd_attribute15 = hr_api.g_varchar2) then
559: p_rec.egd_attribute15 :=
560: ben_egd_shd.g_old_rec.egd_attribute15;
556: ben_egd_shd.g_old_rec.egd_attribute14;
557: End If;
558: If (p_rec.egd_attribute15 = hr_api.g_varchar2) then
559: p_rec.egd_attribute15 :=
560: ben_egd_shd.g_old_rec.egd_attribute15;
561: End If;
562: If (p_rec.egd_attribute16 = hr_api.g_varchar2) then
563: p_rec.egd_attribute16 :=
564: ben_egd_shd.g_old_rec.egd_attribute16;
560: ben_egd_shd.g_old_rec.egd_attribute15;
561: End If;
562: If (p_rec.egd_attribute16 = hr_api.g_varchar2) then
563: p_rec.egd_attribute16 :=
564: ben_egd_shd.g_old_rec.egd_attribute16;
565: End If;
566: If (p_rec.egd_attribute17 = hr_api.g_varchar2) then
567: p_rec.egd_attribute17 :=
568: ben_egd_shd.g_old_rec.egd_attribute17;
564: ben_egd_shd.g_old_rec.egd_attribute16;
565: End If;
566: If (p_rec.egd_attribute17 = hr_api.g_varchar2) then
567: p_rec.egd_attribute17 :=
568: ben_egd_shd.g_old_rec.egd_attribute17;
569: End If;
570: If (p_rec.egd_attribute18 = hr_api.g_varchar2) then
571: p_rec.egd_attribute18 :=
572: ben_egd_shd.g_old_rec.egd_attribute18;
568: ben_egd_shd.g_old_rec.egd_attribute17;
569: End If;
570: If (p_rec.egd_attribute18 = hr_api.g_varchar2) then
571: p_rec.egd_attribute18 :=
572: ben_egd_shd.g_old_rec.egd_attribute18;
573: End If;
574: If (p_rec.egd_attribute19 = hr_api.g_varchar2) then
575: p_rec.egd_attribute19 :=
576: ben_egd_shd.g_old_rec.egd_attribute19;
572: ben_egd_shd.g_old_rec.egd_attribute18;
573: End If;
574: If (p_rec.egd_attribute19 = hr_api.g_varchar2) then
575: p_rec.egd_attribute19 :=
576: ben_egd_shd.g_old_rec.egd_attribute19;
577: End If;
578: If (p_rec.egd_attribute20 = hr_api.g_varchar2) then
579: p_rec.egd_attribute20 :=
580: ben_egd_shd.g_old_rec.egd_attribute20;
576: ben_egd_shd.g_old_rec.egd_attribute19;
577: End If;
578: If (p_rec.egd_attribute20 = hr_api.g_varchar2) then
579: p_rec.egd_attribute20 :=
580: ben_egd_shd.g_old_rec.egd_attribute20;
581: End If;
582: If (p_rec.egd_attribute21 = hr_api.g_varchar2) then
583: p_rec.egd_attribute21 :=
584: ben_egd_shd.g_old_rec.egd_attribute21;
580: ben_egd_shd.g_old_rec.egd_attribute20;
581: End If;
582: If (p_rec.egd_attribute21 = hr_api.g_varchar2) then
583: p_rec.egd_attribute21 :=
584: ben_egd_shd.g_old_rec.egd_attribute21;
585: End If;
586: If (p_rec.egd_attribute22 = hr_api.g_varchar2) then
587: p_rec.egd_attribute22 :=
588: ben_egd_shd.g_old_rec.egd_attribute22;
584: ben_egd_shd.g_old_rec.egd_attribute21;
585: End If;
586: If (p_rec.egd_attribute22 = hr_api.g_varchar2) then
587: p_rec.egd_attribute22 :=
588: ben_egd_shd.g_old_rec.egd_attribute22;
589: End If;
590: If (p_rec.egd_attribute23 = hr_api.g_varchar2) then
591: p_rec.egd_attribute23 :=
592: ben_egd_shd.g_old_rec.egd_attribute23;
588: ben_egd_shd.g_old_rec.egd_attribute22;
589: End If;
590: If (p_rec.egd_attribute23 = hr_api.g_varchar2) then
591: p_rec.egd_attribute23 :=
592: ben_egd_shd.g_old_rec.egd_attribute23;
593: End If;
594: If (p_rec.egd_attribute24 = hr_api.g_varchar2) then
595: p_rec.egd_attribute24 :=
596: ben_egd_shd.g_old_rec.egd_attribute24;
592: ben_egd_shd.g_old_rec.egd_attribute23;
593: End If;
594: If (p_rec.egd_attribute24 = hr_api.g_varchar2) then
595: p_rec.egd_attribute24 :=
596: ben_egd_shd.g_old_rec.egd_attribute24;
597: End If;
598: If (p_rec.egd_attribute25 = hr_api.g_varchar2) then
599: p_rec.egd_attribute25 :=
600: ben_egd_shd.g_old_rec.egd_attribute25;
596: ben_egd_shd.g_old_rec.egd_attribute24;
597: End If;
598: If (p_rec.egd_attribute25 = hr_api.g_varchar2) then
599: p_rec.egd_attribute25 :=
600: ben_egd_shd.g_old_rec.egd_attribute25;
601: End If;
602: If (p_rec.egd_attribute26 = hr_api.g_varchar2) then
603: p_rec.egd_attribute26 :=
604: ben_egd_shd.g_old_rec.egd_attribute26;
600: ben_egd_shd.g_old_rec.egd_attribute25;
601: End If;
602: If (p_rec.egd_attribute26 = hr_api.g_varchar2) then
603: p_rec.egd_attribute26 :=
604: ben_egd_shd.g_old_rec.egd_attribute26;
605: End If;
606: If (p_rec.egd_attribute27 = hr_api.g_varchar2) then
607: p_rec.egd_attribute27 :=
608: ben_egd_shd.g_old_rec.egd_attribute27;
604: ben_egd_shd.g_old_rec.egd_attribute26;
605: End If;
606: If (p_rec.egd_attribute27 = hr_api.g_varchar2) then
607: p_rec.egd_attribute27 :=
608: ben_egd_shd.g_old_rec.egd_attribute27;
609: End If;
610: If (p_rec.egd_attribute28 = hr_api.g_varchar2) then
611: p_rec.egd_attribute28 :=
612: ben_egd_shd.g_old_rec.egd_attribute28;
608: ben_egd_shd.g_old_rec.egd_attribute27;
609: End If;
610: If (p_rec.egd_attribute28 = hr_api.g_varchar2) then
611: p_rec.egd_attribute28 :=
612: ben_egd_shd.g_old_rec.egd_attribute28;
613: End If;
614: If (p_rec.egd_attribute29 = hr_api.g_varchar2) then
615: p_rec.egd_attribute29 :=
616: ben_egd_shd.g_old_rec.egd_attribute29;
612: ben_egd_shd.g_old_rec.egd_attribute28;
613: End If;
614: If (p_rec.egd_attribute29 = hr_api.g_varchar2) then
615: p_rec.egd_attribute29 :=
616: ben_egd_shd.g_old_rec.egd_attribute29;
617: End If;
618: If (p_rec.egd_attribute30 = hr_api.g_varchar2) then
619: p_rec.egd_attribute30 :=
620: ben_egd_shd.g_old_rec.egd_attribute30;
616: ben_egd_shd.g_old_rec.egd_attribute29;
617: End If;
618: If (p_rec.egd_attribute30 = hr_api.g_varchar2) then
619: p_rec.egd_attribute30 :=
620: ben_egd_shd.g_old_rec.egd_attribute30;
621: End If;
622: If (p_rec.request_id = hr_api.g_number) then
623: p_rec.request_id :=
624: ben_egd_shd.g_old_rec.request_id;
620: ben_egd_shd.g_old_rec.egd_attribute30;
621: End If;
622: If (p_rec.request_id = hr_api.g_number) then
623: p_rec.request_id :=
624: ben_egd_shd.g_old_rec.request_id;
625: End If;
626: If (p_rec.program_application_id = hr_api.g_number) then
627: p_rec.program_application_id :=
628: ben_egd_shd.g_old_rec.program_application_id;
624: ben_egd_shd.g_old_rec.request_id;
625: End If;
626: If (p_rec.program_application_id = hr_api.g_number) then
627: p_rec.program_application_id :=
628: ben_egd_shd.g_old_rec.program_application_id;
629: End If;
630: If (p_rec.program_id = hr_api.g_number) then
631: p_rec.program_id :=
632: ben_egd_shd.g_old_rec.program_id;
628: ben_egd_shd.g_old_rec.program_application_id;
629: End If;
630: If (p_rec.program_id = hr_api.g_number) then
631: p_rec.program_id :=
632: ben_egd_shd.g_old_rec.program_id;
633: End If;
634: If (p_rec.program_update_date = hr_api.g_date) then
635: p_rec.program_update_date :=
636: ben_egd_shd.g_old_rec.program_update_date;
632: ben_egd_shd.g_old_rec.program_id;
633: End If;
634: If (p_rec.program_update_date = hr_api.g_date) then
635: p_rec.program_update_date :=
636: ben_egd_shd.g_old_rec.program_update_date;
637: End If;
638:
639: --
640: hr_utility.set_location(' Leaving:'||l_proc, 10);
646: -- ----------------------------------------------------------------------------
647: Procedure upd
648: (
649: p_effective_date in date,
650: p_rec in out nocopy ben_egd_shd.g_rec_type
651: ) is
652: --
653: l_proc varchar2(72) := g_package||'upd';
654: --
656: hr_utility.set_location('Entering:'||l_proc, 5);
657: --
658: -- We must lock the row which we need to update.
659: --
660: ben_egd_shd.lck
661: (
662: p_rec.elig_dpnt_id,
663: p_rec.object_version_number
664: );
745: p_program_update_date in date default hr_api.g_date,
746: p_object_version_number in out nocopy number
747: ) is
748: --
749: l_rec ben_egd_shd.g_rec_type;
750: l_proc varchar2(72) := g_package||'upd';
751: --
752: Begin
753: hr_utility.set_location('Entering:'||l_proc, 5);
755: -- Call conversion function to turn arguments into the
756: -- l_rec structure.
757: --
758: l_rec :=
759: ben_egd_shd.convert_args
760: (
761: p_elig_dpnt_id,
762: p_create_dt,
763: p_elig_strt_dt,