47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ben_pil_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ben_pil_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_per_in_ler row.
61: --
62: delete from ben_per_in_ler
61: --
62: delete from ben_per_in_ler
63: where per_in_ler_id = p_rec.per_in_ler_id;
64: --
65: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception
68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
73: ben_pil_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
73: ben_pil_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
72: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
73: ben_pil_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_pil_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------
108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in ben_pil_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(
155: p_effective_date in date,p_rec in ben_pil_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin
166: --
167: ben_pil_rkd.after_delete
168: (
169: p_per_in_ler_id =>p_rec.per_in_ler_id
170: ,p_per_in_ler_stat_cd_o =>ben_pil_shd.g_old_rec.per_in_ler_stat_cd
171: ,p_prvs_stat_cd_o =>ben_pil_shd.g_old_rec.prvs_stat_cd
172: ,p_lf_evt_ocrd_dt_o =>ben_pil_shd.g_old_rec.lf_evt_ocrd_dt
173: ,p_trgr_table_pk_id_o =>ben_pil_shd.g_old_rec.trgr_table_pk_id
174: ,p_procd_dt_o =>ben_pil_shd.g_old_rec.procd_dt
167: ben_pil_rkd.after_delete
168: (
169: p_per_in_ler_id =>p_rec.per_in_ler_id
170: ,p_per_in_ler_stat_cd_o =>ben_pil_shd.g_old_rec.per_in_ler_stat_cd
171: ,p_prvs_stat_cd_o =>ben_pil_shd.g_old_rec.prvs_stat_cd
172: ,p_lf_evt_ocrd_dt_o =>ben_pil_shd.g_old_rec.lf_evt_ocrd_dt
173: ,p_trgr_table_pk_id_o =>ben_pil_shd.g_old_rec.trgr_table_pk_id
174: ,p_procd_dt_o =>ben_pil_shd.g_old_rec.procd_dt
175: ,p_strtd_dt_o =>ben_pil_shd.g_old_rec.strtd_dt
168: (
169: p_per_in_ler_id =>p_rec.per_in_ler_id
170: ,p_per_in_ler_stat_cd_o =>ben_pil_shd.g_old_rec.per_in_ler_stat_cd
171: ,p_prvs_stat_cd_o =>ben_pil_shd.g_old_rec.prvs_stat_cd
172: ,p_lf_evt_ocrd_dt_o =>ben_pil_shd.g_old_rec.lf_evt_ocrd_dt
173: ,p_trgr_table_pk_id_o =>ben_pil_shd.g_old_rec.trgr_table_pk_id
174: ,p_procd_dt_o =>ben_pil_shd.g_old_rec.procd_dt
175: ,p_strtd_dt_o =>ben_pil_shd.g_old_rec.strtd_dt
176: ,p_voidd_dt_o =>ben_pil_shd.g_old_rec.voidd_dt
169: p_per_in_ler_id =>p_rec.per_in_ler_id
170: ,p_per_in_ler_stat_cd_o =>ben_pil_shd.g_old_rec.per_in_ler_stat_cd
171: ,p_prvs_stat_cd_o =>ben_pil_shd.g_old_rec.prvs_stat_cd
172: ,p_lf_evt_ocrd_dt_o =>ben_pil_shd.g_old_rec.lf_evt_ocrd_dt
173: ,p_trgr_table_pk_id_o =>ben_pil_shd.g_old_rec.trgr_table_pk_id
174: ,p_procd_dt_o =>ben_pil_shd.g_old_rec.procd_dt
175: ,p_strtd_dt_o =>ben_pil_shd.g_old_rec.strtd_dt
176: ,p_voidd_dt_o =>ben_pil_shd.g_old_rec.voidd_dt
177: ,p_bckt_dt_o =>ben_pil_shd.g_old_rec.bckt_dt
170: ,p_per_in_ler_stat_cd_o =>ben_pil_shd.g_old_rec.per_in_ler_stat_cd
171: ,p_prvs_stat_cd_o =>ben_pil_shd.g_old_rec.prvs_stat_cd
172: ,p_lf_evt_ocrd_dt_o =>ben_pil_shd.g_old_rec.lf_evt_ocrd_dt
173: ,p_trgr_table_pk_id_o =>ben_pil_shd.g_old_rec.trgr_table_pk_id
174: ,p_procd_dt_o =>ben_pil_shd.g_old_rec.procd_dt
175: ,p_strtd_dt_o =>ben_pil_shd.g_old_rec.strtd_dt
176: ,p_voidd_dt_o =>ben_pil_shd.g_old_rec.voidd_dt
177: ,p_bckt_dt_o =>ben_pil_shd.g_old_rec.bckt_dt
178: ,p_clsd_dt_o =>ben_pil_shd.g_old_rec.clsd_dt
171: ,p_prvs_stat_cd_o =>ben_pil_shd.g_old_rec.prvs_stat_cd
172: ,p_lf_evt_ocrd_dt_o =>ben_pil_shd.g_old_rec.lf_evt_ocrd_dt
173: ,p_trgr_table_pk_id_o =>ben_pil_shd.g_old_rec.trgr_table_pk_id
174: ,p_procd_dt_o =>ben_pil_shd.g_old_rec.procd_dt
175: ,p_strtd_dt_o =>ben_pil_shd.g_old_rec.strtd_dt
176: ,p_voidd_dt_o =>ben_pil_shd.g_old_rec.voidd_dt
177: ,p_bckt_dt_o =>ben_pil_shd.g_old_rec.bckt_dt
178: ,p_clsd_dt_o =>ben_pil_shd.g_old_rec.clsd_dt
179: ,p_ntfn_dt_o =>ben_pil_shd.g_old_rec.ntfn_dt
172: ,p_lf_evt_ocrd_dt_o =>ben_pil_shd.g_old_rec.lf_evt_ocrd_dt
173: ,p_trgr_table_pk_id_o =>ben_pil_shd.g_old_rec.trgr_table_pk_id
174: ,p_procd_dt_o =>ben_pil_shd.g_old_rec.procd_dt
175: ,p_strtd_dt_o =>ben_pil_shd.g_old_rec.strtd_dt
176: ,p_voidd_dt_o =>ben_pil_shd.g_old_rec.voidd_dt
177: ,p_bckt_dt_o =>ben_pil_shd.g_old_rec.bckt_dt
178: ,p_clsd_dt_o =>ben_pil_shd.g_old_rec.clsd_dt
179: ,p_ntfn_dt_o =>ben_pil_shd.g_old_rec.ntfn_dt
180: ,p_ptnl_ler_for_per_id_o =>ben_pil_shd.g_old_rec.ptnl_ler_for_per_id
173: ,p_trgr_table_pk_id_o =>ben_pil_shd.g_old_rec.trgr_table_pk_id
174: ,p_procd_dt_o =>ben_pil_shd.g_old_rec.procd_dt
175: ,p_strtd_dt_o =>ben_pil_shd.g_old_rec.strtd_dt
176: ,p_voidd_dt_o =>ben_pil_shd.g_old_rec.voidd_dt
177: ,p_bckt_dt_o =>ben_pil_shd.g_old_rec.bckt_dt
178: ,p_clsd_dt_o =>ben_pil_shd.g_old_rec.clsd_dt
179: ,p_ntfn_dt_o =>ben_pil_shd.g_old_rec.ntfn_dt
180: ,p_ptnl_ler_for_per_id_o =>ben_pil_shd.g_old_rec.ptnl_ler_for_per_id
181: ,p_bckt_per_in_ler_id_o =>ben_pil_shd.g_old_rec.bckt_per_in_ler_id
174: ,p_procd_dt_o =>ben_pil_shd.g_old_rec.procd_dt
175: ,p_strtd_dt_o =>ben_pil_shd.g_old_rec.strtd_dt
176: ,p_voidd_dt_o =>ben_pil_shd.g_old_rec.voidd_dt
177: ,p_bckt_dt_o =>ben_pil_shd.g_old_rec.bckt_dt
178: ,p_clsd_dt_o =>ben_pil_shd.g_old_rec.clsd_dt
179: ,p_ntfn_dt_o =>ben_pil_shd.g_old_rec.ntfn_dt
180: ,p_ptnl_ler_for_per_id_o =>ben_pil_shd.g_old_rec.ptnl_ler_for_per_id
181: ,p_bckt_per_in_ler_id_o =>ben_pil_shd.g_old_rec.bckt_per_in_ler_id
182: ,p_ler_id_o =>ben_pil_shd.g_old_rec.ler_id
175: ,p_strtd_dt_o =>ben_pil_shd.g_old_rec.strtd_dt
176: ,p_voidd_dt_o =>ben_pil_shd.g_old_rec.voidd_dt
177: ,p_bckt_dt_o =>ben_pil_shd.g_old_rec.bckt_dt
178: ,p_clsd_dt_o =>ben_pil_shd.g_old_rec.clsd_dt
179: ,p_ntfn_dt_o =>ben_pil_shd.g_old_rec.ntfn_dt
180: ,p_ptnl_ler_for_per_id_o =>ben_pil_shd.g_old_rec.ptnl_ler_for_per_id
181: ,p_bckt_per_in_ler_id_o =>ben_pil_shd.g_old_rec.bckt_per_in_ler_id
182: ,p_ler_id_o =>ben_pil_shd.g_old_rec.ler_id
183: ,p_person_id_o =>ben_pil_shd.g_old_rec.person_id
176: ,p_voidd_dt_o =>ben_pil_shd.g_old_rec.voidd_dt
177: ,p_bckt_dt_o =>ben_pil_shd.g_old_rec.bckt_dt
178: ,p_clsd_dt_o =>ben_pil_shd.g_old_rec.clsd_dt
179: ,p_ntfn_dt_o =>ben_pil_shd.g_old_rec.ntfn_dt
180: ,p_ptnl_ler_for_per_id_o =>ben_pil_shd.g_old_rec.ptnl_ler_for_per_id
181: ,p_bckt_per_in_ler_id_o =>ben_pil_shd.g_old_rec.bckt_per_in_ler_id
182: ,p_ler_id_o =>ben_pil_shd.g_old_rec.ler_id
183: ,p_person_id_o =>ben_pil_shd.g_old_rec.person_id
184: ,p_business_group_id_o =>ben_pil_shd.g_old_rec.business_group_id
177: ,p_bckt_dt_o =>ben_pil_shd.g_old_rec.bckt_dt
178: ,p_clsd_dt_o =>ben_pil_shd.g_old_rec.clsd_dt
179: ,p_ntfn_dt_o =>ben_pil_shd.g_old_rec.ntfn_dt
180: ,p_ptnl_ler_for_per_id_o =>ben_pil_shd.g_old_rec.ptnl_ler_for_per_id
181: ,p_bckt_per_in_ler_id_o =>ben_pil_shd.g_old_rec.bckt_per_in_ler_id
182: ,p_ler_id_o =>ben_pil_shd.g_old_rec.ler_id
183: ,p_person_id_o =>ben_pil_shd.g_old_rec.person_id
184: ,p_business_group_id_o =>ben_pil_shd.g_old_rec.business_group_id
185: ,p_ASSIGNMENT_ID_o => ben_pil_shd.g_old_rec.ASSIGNMENT_ID
178: ,p_clsd_dt_o =>ben_pil_shd.g_old_rec.clsd_dt
179: ,p_ntfn_dt_o =>ben_pil_shd.g_old_rec.ntfn_dt
180: ,p_ptnl_ler_for_per_id_o =>ben_pil_shd.g_old_rec.ptnl_ler_for_per_id
181: ,p_bckt_per_in_ler_id_o =>ben_pil_shd.g_old_rec.bckt_per_in_ler_id
182: ,p_ler_id_o =>ben_pil_shd.g_old_rec.ler_id
183: ,p_person_id_o =>ben_pil_shd.g_old_rec.person_id
184: ,p_business_group_id_o =>ben_pil_shd.g_old_rec.business_group_id
185: ,p_ASSIGNMENT_ID_o => ben_pil_shd.g_old_rec.ASSIGNMENT_ID
186: ,p_WS_MGR_ID_o => ben_pil_shd.g_old_rec.WS_MGR_ID
179: ,p_ntfn_dt_o =>ben_pil_shd.g_old_rec.ntfn_dt
180: ,p_ptnl_ler_for_per_id_o =>ben_pil_shd.g_old_rec.ptnl_ler_for_per_id
181: ,p_bckt_per_in_ler_id_o =>ben_pil_shd.g_old_rec.bckt_per_in_ler_id
182: ,p_ler_id_o =>ben_pil_shd.g_old_rec.ler_id
183: ,p_person_id_o =>ben_pil_shd.g_old_rec.person_id
184: ,p_business_group_id_o =>ben_pil_shd.g_old_rec.business_group_id
185: ,p_ASSIGNMENT_ID_o => ben_pil_shd.g_old_rec.ASSIGNMENT_ID
186: ,p_WS_MGR_ID_o => ben_pil_shd.g_old_rec.WS_MGR_ID
187: ,p_GROUP_PL_ID_o => ben_pil_shd.g_old_rec.GROUP_PL_ID
180: ,p_ptnl_ler_for_per_id_o =>ben_pil_shd.g_old_rec.ptnl_ler_for_per_id
181: ,p_bckt_per_in_ler_id_o =>ben_pil_shd.g_old_rec.bckt_per_in_ler_id
182: ,p_ler_id_o =>ben_pil_shd.g_old_rec.ler_id
183: ,p_person_id_o =>ben_pil_shd.g_old_rec.person_id
184: ,p_business_group_id_o =>ben_pil_shd.g_old_rec.business_group_id
185: ,p_ASSIGNMENT_ID_o => ben_pil_shd.g_old_rec.ASSIGNMENT_ID
186: ,p_WS_MGR_ID_o => ben_pil_shd.g_old_rec.WS_MGR_ID
187: ,p_GROUP_PL_ID_o => ben_pil_shd.g_old_rec.GROUP_PL_ID
188: ,p_MGR_OVRID_PERSON_ID_o => ben_pil_shd.g_old_rec.MGR_OVRID_PERSON_ID ,p_MGR_OVRID_DT_o => ben_pil_shd.g_old_rec.MGR_OVRID_DT
181: ,p_bckt_per_in_ler_id_o =>ben_pil_shd.g_old_rec.bckt_per_in_ler_id
182: ,p_ler_id_o =>ben_pil_shd.g_old_rec.ler_id
183: ,p_person_id_o =>ben_pil_shd.g_old_rec.person_id
184: ,p_business_group_id_o =>ben_pil_shd.g_old_rec.business_group_id
185: ,p_ASSIGNMENT_ID_o => ben_pil_shd.g_old_rec.ASSIGNMENT_ID
186: ,p_WS_MGR_ID_o => ben_pil_shd.g_old_rec.WS_MGR_ID
187: ,p_GROUP_PL_ID_o => ben_pil_shd.g_old_rec.GROUP_PL_ID
188: ,p_MGR_OVRID_PERSON_ID_o => ben_pil_shd.g_old_rec.MGR_OVRID_PERSON_ID ,p_MGR_OVRID_DT_o => ben_pil_shd.g_old_rec.MGR_OVRID_DT
189: ,p_pil_attribute_category_o =>ben_pil_shd.g_old_rec.pil_attribute_category
182: ,p_ler_id_o =>ben_pil_shd.g_old_rec.ler_id
183: ,p_person_id_o =>ben_pil_shd.g_old_rec.person_id
184: ,p_business_group_id_o =>ben_pil_shd.g_old_rec.business_group_id
185: ,p_ASSIGNMENT_ID_o => ben_pil_shd.g_old_rec.ASSIGNMENT_ID
186: ,p_WS_MGR_ID_o => ben_pil_shd.g_old_rec.WS_MGR_ID
187: ,p_GROUP_PL_ID_o => ben_pil_shd.g_old_rec.GROUP_PL_ID
188: ,p_MGR_OVRID_PERSON_ID_o => ben_pil_shd.g_old_rec.MGR_OVRID_PERSON_ID ,p_MGR_OVRID_DT_o => ben_pil_shd.g_old_rec.MGR_OVRID_DT
189: ,p_pil_attribute_category_o =>ben_pil_shd.g_old_rec.pil_attribute_category
190: ,p_pil_attribute1_o =>ben_pil_shd.g_old_rec.pil_attribute1
183: ,p_person_id_o =>ben_pil_shd.g_old_rec.person_id
184: ,p_business_group_id_o =>ben_pil_shd.g_old_rec.business_group_id
185: ,p_ASSIGNMENT_ID_o => ben_pil_shd.g_old_rec.ASSIGNMENT_ID
186: ,p_WS_MGR_ID_o => ben_pil_shd.g_old_rec.WS_MGR_ID
187: ,p_GROUP_PL_ID_o => ben_pil_shd.g_old_rec.GROUP_PL_ID
188: ,p_MGR_OVRID_PERSON_ID_o => ben_pil_shd.g_old_rec.MGR_OVRID_PERSON_ID ,p_MGR_OVRID_DT_o => ben_pil_shd.g_old_rec.MGR_OVRID_DT
189: ,p_pil_attribute_category_o =>ben_pil_shd.g_old_rec.pil_attribute_category
190: ,p_pil_attribute1_o =>ben_pil_shd.g_old_rec.pil_attribute1
191: ,p_pil_attribute2_o =>ben_pil_shd.g_old_rec.pil_attribute2
184: ,p_business_group_id_o =>ben_pil_shd.g_old_rec.business_group_id
185: ,p_ASSIGNMENT_ID_o => ben_pil_shd.g_old_rec.ASSIGNMENT_ID
186: ,p_WS_MGR_ID_o => ben_pil_shd.g_old_rec.WS_MGR_ID
187: ,p_GROUP_PL_ID_o => ben_pil_shd.g_old_rec.GROUP_PL_ID
188: ,p_MGR_OVRID_PERSON_ID_o => ben_pil_shd.g_old_rec.MGR_OVRID_PERSON_ID ,p_MGR_OVRID_DT_o => ben_pil_shd.g_old_rec.MGR_OVRID_DT
189: ,p_pil_attribute_category_o =>ben_pil_shd.g_old_rec.pil_attribute_category
190: ,p_pil_attribute1_o =>ben_pil_shd.g_old_rec.pil_attribute1
191: ,p_pil_attribute2_o =>ben_pil_shd.g_old_rec.pil_attribute2
192: ,p_pil_attribute3_o =>ben_pil_shd.g_old_rec.pil_attribute3
185: ,p_ASSIGNMENT_ID_o => ben_pil_shd.g_old_rec.ASSIGNMENT_ID
186: ,p_WS_MGR_ID_o => ben_pil_shd.g_old_rec.WS_MGR_ID
187: ,p_GROUP_PL_ID_o => ben_pil_shd.g_old_rec.GROUP_PL_ID
188: ,p_MGR_OVRID_PERSON_ID_o => ben_pil_shd.g_old_rec.MGR_OVRID_PERSON_ID ,p_MGR_OVRID_DT_o => ben_pil_shd.g_old_rec.MGR_OVRID_DT
189: ,p_pil_attribute_category_o =>ben_pil_shd.g_old_rec.pil_attribute_category
190: ,p_pil_attribute1_o =>ben_pil_shd.g_old_rec.pil_attribute1
191: ,p_pil_attribute2_o =>ben_pil_shd.g_old_rec.pil_attribute2
192: ,p_pil_attribute3_o =>ben_pil_shd.g_old_rec.pil_attribute3
193: ,p_pil_attribute4_o =>ben_pil_shd.g_old_rec.pil_attribute4
186: ,p_WS_MGR_ID_o => ben_pil_shd.g_old_rec.WS_MGR_ID
187: ,p_GROUP_PL_ID_o => ben_pil_shd.g_old_rec.GROUP_PL_ID
188: ,p_MGR_OVRID_PERSON_ID_o => ben_pil_shd.g_old_rec.MGR_OVRID_PERSON_ID ,p_MGR_OVRID_DT_o => ben_pil_shd.g_old_rec.MGR_OVRID_DT
189: ,p_pil_attribute_category_o =>ben_pil_shd.g_old_rec.pil_attribute_category
190: ,p_pil_attribute1_o =>ben_pil_shd.g_old_rec.pil_attribute1
191: ,p_pil_attribute2_o =>ben_pil_shd.g_old_rec.pil_attribute2
192: ,p_pil_attribute3_o =>ben_pil_shd.g_old_rec.pil_attribute3
193: ,p_pil_attribute4_o =>ben_pil_shd.g_old_rec.pil_attribute4
194: ,p_pil_attribute5_o =>ben_pil_shd.g_old_rec.pil_attribute5
187: ,p_GROUP_PL_ID_o => ben_pil_shd.g_old_rec.GROUP_PL_ID
188: ,p_MGR_OVRID_PERSON_ID_o => ben_pil_shd.g_old_rec.MGR_OVRID_PERSON_ID ,p_MGR_OVRID_DT_o => ben_pil_shd.g_old_rec.MGR_OVRID_DT
189: ,p_pil_attribute_category_o =>ben_pil_shd.g_old_rec.pil_attribute_category
190: ,p_pil_attribute1_o =>ben_pil_shd.g_old_rec.pil_attribute1
191: ,p_pil_attribute2_o =>ben_pil_shd.g_old_rec.pil_attribute2
192: ,p_pil_attribute3_o =>ben_pil_shd.g_old_rec.pil_attribute3
193: ,p_pil_attribute4_o =>ben_pil_shd.g_old_rec.pil_attribute4
194: ,p_pil_attribute5_o =>ben_pil_shd.g_old_rec.pil_attribute5
195: ,p_pil_attribute6_o =>ben_pil_shd.g_old_rec.pil_attribute6
188: ,p_MGR_OVRID_PERSON_ID_o => ben_pil_shd.g_old_rec.MGR_OVRID_PERSON_ID ,p_MGR_OVRID_DT_o => ben_pil_shd.g_old_rec.MGR_OVRID_DT
189: ,p_pil_attribute_category_o =>ben_pil_shd.g_old_rec.pil_attribute_category
190: ,p_pil_attribute1_o =>ben_pil_shd.g_old_rec.pil_attribute1
191: ,p_pil_attribute2_o =>ben_pil_shd.g_old_rec.pil_attribute2
192: ,p_pil_attribute3_o =>ben_pil_shd.g_old_rec.pil_attribute3
193: ,p_pil_attribute4_o =>ben_pil_shd.g_old_rec.pil_attribute4
194: ,p_pil_attribute5_o =>ben_pil_shd.g_old_rec.pil_attribute5
195: ,p_pil_attribute6_o =>ben_pil_shd.g_old_rec.pil_attribute6
196: ,p_pil_attribute7_o =>ben_pil_shd.g_old_rec.pil_attribute7
189: ,p_pil_attribute_category_o =>ben_pil_shd.g_old_rec.pil_attribute_category
190: ,p_pil_attribute1_o =>ben_pil_shd.g_old_rec.pil_attribute1
191: ,p_pil_attribute2_o =>ben_pil_shd.g_old_rec.pil_attribute2
192: ,p_pil_attribute3_o =>ben_pil_shd.g_old_rec.pil_attribute3
193: ,p_pil_attribute4_o =>ben_pil_shd.g_old_rec.pil_attribute4
194: ,p_pil_attribute5_o =>ben_pil_shd.g_old_rec.pil_attribute5
195: ,p_pil_attribute6_o =>ben_pil_shd.g_old_rec.pil_attribute6
196: ,p_pil_attribute7_o =>ben_pil_shd.g_old_rec.pil_attribute7
197: ,p_pil_attribute8_o =>ben_pil_shd.g_old_rec.pil_attribute8
190: ,p_pil_attribute1_o =>ben_pil_shd.g_old_rec.pil_attribute1
191: ,p_pil_attribute2_o =>ben_pil_shd.g_old_rec.pil_attribute2
192: ,p_pil_attribute3_o =>ben_pil_shd.g_old_rec.pil_attribute3
193: ,p_pil_attribute4_o =>ben_pil_shd.g_old_rec.pil_attribute4
194: ,p_pil_attribute5_o =>ben_pil_shd.g_old_rec.pil_attribute5
195: ,p_pil_attribute6_o =>ben_pil_shd.g_old_rec.pil_attribute6
196: ,p_pil_attribute7_o =>ben_pil_shd.g_old_rec.pil_attribute7
197: ,p_pil_attribute8_o =>ben_pil_shd.g_old_rec.pil_attribute8
198: ,p_pil_attribute9_o =>ben_pil_shd.g_old_rec.pil_attribute9
191: ,p_pil_attribute2_o =>ben_pil_shd.g_old_rec.pil_attribute2
192: ,p_pil_attribute3_o =>ben_pil_shd.g_old_rec.pil_attribute3
193: ,p_pil_attribute4_o =>ben_pil_shd.g_old_rec.pil_attribute4
194: ,p_pil_attribute5_o =>ben_pil_shd.g_old_rec.pil_attribute5
195: ,p_pil_attribute6_o =>ben_pil_shd.g_old_rec.pil_attribute6
196: ,p_pil_attribute7_o =>ben_pil_shd.g_old_rec.pil_attribute7
197: ,p_pil_attribute8_o =>ben_pil_shd.g_old_rec.pil_attribute8
198: ,p_pil_attribute9_o =>ben_pil_shd.g_old_rec.pil_attribute9
199: ,p_pil_attribute10_o =>ben_pil_shd.g_old_rec.pil_attribute10
192: ,p_pil_attribute3_o =>ben_pil_shd.g_old_rec.pil_attribute3
193: ,p_pil_attribute4_o =>ben_pil_shd.g_old_rec.pil_attribute4
194: ,p_pil_attribute5_o =>ben_pil_shd.g_old_rec.pil_attribute5
195: ,p_pil_attribute6_o =>ben_pil_shd.g_old_rec.pil_attribute6
196: ,p_pil_attribute7_o =>ben_pil_shd.g_old_rec.pil_attribute7
197: ,p_pil_attribute8_o =>ben_pil_shd.g_old_rec.pil_attribute8
198: ,p_pil_attribute9_o =>ben_pil_shd.g_old_rec.pil_attribute9
199: ,p_pil_attribute10_o =>ben_pil_shd.g_old_rec.pil_attribute10
200: ,p_pil_attribute11_o =>ben_pil_shd.g_old_rec.pil_attribute11
193: ,p_pil_attribute4_o =>ben_pil_shd.g_old_rec.pil_attribute4
194: ,p_pil_attribute5_o =>ben_pil_shd.g_old_rec.pil_attribute5
195: ,p_pil_attribute6_o =>ben_pil_shd.g_old_rec.pil_attribute6
196: ,p_pil_attribute7_o =>ben_pil_shd.g_old_rec.pil_attribute7
197: ,p_pil_attribute8_o =>ben_pil_shd.g_old_rec.pil_attribute8
198: ,p_pil_attribute9_o =>ben_pil_shd.g_old_rec.pil_attribute9
199: ,p_pil_attribute10_o =>ben_pil_shd.g_old_rec.pil_attribute10
200: ,p_pil_attribute11_o =>ben_pil_shd.g_old_rec.pil_attribute11
201: ,p_pil_attribute12_o =>ben_pil_shd.g_old_rec.pil_attribute12
194: ,p_pil_attribute5_o =>ben_pil_shd.g_old_rec.pil_attribute5
195: ,p_pil_attribute6_o =>ben_pil_shd.g_old_rec.pil_attribute6
196: ,p_pil_attribute7_o =>ben_pil_shd.g_old_rec.pil_attribute7
197: ,p_pil_attribute8_o =>ben_pil_shd.g_old_rec.pil_attribute8
198: ,p_pil_attribute9_o =>ben_pil_shd.g_old_rec.pil_attribute9
199: ,p_pil_attribute10_o =>ben_pil_shd.g_old_rec.pil_attribute10
200: ,p_pil_attribute11_o =>ben_pil_shd.g_old_rec.pil_attribute11
201: ,p_pil_attribute12_o =>ben_pil_shd.g_old_rec.pil_attribute12
202: ,p_pil_attribute13_o =>ben_pil_shd.g_old_rec.pil_attribute13
195: ,p_pil_attribute6_o =>ben_pil_shd.g_old_rec.pil_attribute6
196: ,p_pil_attribute7_o =>ben_pil_shd.g_old_rec.pil_attribute7
197: ,p_pil_attribute8_o =>ben_pil_shd.g_old_rec.pil_attribute8
198: ,p_pil_attribute9_o =>ben_pil_shd.g_old_rec.pil_attribute9
199: ,p_pil_attribute10_o =>ben_pil_shd.g_old_rec.pil_attribute10
200: ,p_pil_attribute11_o =>ben_pil_shd.g_old_rec.pil_attribute11
201: ,p_pil_attribute12_o =>ben_pil_shd.g_old_rec.pil_attribute12
202: ,p_pil_attribute13_o =>ben_pil_shd.g_old_rec.pil_attribute13
203: ,p_pil_attribute14_o =>ben_pil_shd.g_old_rec.pil_attribute14
196: ,p_pil_attribute7_o =>ben_pil_shd.g_old_rec.pil_attribute7
197: ,p_pil_attribute8_o =>ben_pil_shd.g_old_rec.pil_attribute8
198: ,p_pil_attribute9_o =>ben_pil_shd.g_old_rec.pil_attribute9
199: ,p_pil_attribute10_o =>ben_pil_shd.g_old_rec.pil_attribute10
200: ,p_pil_attribute11_o =>ben_pil_shd.g_old_rec.pil_attribute11
201: ,p_pil_attribute12_o =>ben_pil_shd.g_old_rec.pil_attribute12
202: ,p_pil_attribute13_o =>ben_pil_shd.g_old_rec.pil_attribute13
203: ,p_pil_attribute14_o =>ben_pil_shd.g_old_rec.pil_attribute14
204: ,p_pil_attribute15_o =>ben_pil_shd.g_old_rec.pil_attribute15
197: ,p_pil_attribute8_o =>ben_pil_shd.g_old_rec.pil_attribute8
198: ,p_pil_attribute9_o =>ben_pil_shd.g_old_rec.pil_attribute9
199: ,p_pil_attribute10_o =>ben_pil_shd.g_old_rec.pil_attribute10
200: ,p_pil_attribute11_o =>ben_pil_shd.g_old_rec.pil_attribute11
201: ,p_pil_attribute12_o =>ben_pil_shd.g_old_rec.pil_attribute12
202: ,p_pil_attribute13_o =>ben_pil_shd.g_old_rec.pil_attribute13
203: ,p_pil_attribute14_o =>ben_pil_shd.g_old_rec.pil_attribute14
204: ,p_pil_attribute15_o =>ben_pil_shd.g_old_rec.pil_attribute15
205: ,p_pil_attribute16_o =>ben_pil_shd.g_old_rec.pil_attribute16
198: ,p_pil_attribute9_o =>ben_pil_shd.g_old_rec.pil_attribute9
199: ,p_pil_attribute10_o =>ben_pil_shd.g_old_rec.pil_attribute10
200: ,p_pil_attribute11_o =>ben_pil_shd.g_old_rec.pil_attribute11
201: ,p_pil_attribute12_o =>ben_pil_shd.g_old_rec.pil_attribute12
202: ,p_pil_attribute13_o =>ben_pil_shd.g_old_rec.pil_attribute13
203: ,p_pil_attribute14_o =>ben_pil_shd.g_old_rec.pil_attribute14
204: ,p_pil_attribute15_o =>ben_pil_shd.g_old_rec.pil_attribute15
205: ,p_pil_attribute16_o =>ben_pil_shd.g_old_rec.pil_attribute16
206: ,p_pil_attribute17_o =>ben_pil_shd.g_old_rec.pil_attribute17
199: ,p_pil_attribute10_o =>ben_pil_shd.g_old_rec.pil_attribute10
200: ,p_pil_attribute11_o =>ben_pil_shd.g_old_rec.pil_attribute11
201: ,p_pil_attribute12_o =>ben_pil_shd.g_old_rec.pil_attribute12
202: ,p_pil_attribute13_o =>ben_pil_shd.g_old_rec.pil_attribute13
203: ,p_pil_attribute14_o =>ben_pil_shd.g_old_rec.pil_attribute14
204: ,p_pil_attribute15_o =>ben_pil_shd.g_old_rec.pil_attribute15
205: ,p_pil_attribute16_o =>ben_pil_shd.g_old_rec.pil_attribute16
206: ,p_pil_attribute17_o =>ben_pil_shd.g_old_rec.pil_attribute17
207: ,p_pil_attribute18_o =>ben_pil_shd.g_old_rec.pil_attribute18
200: ,p_pil_attribute11_o =>ben_pil_shd.g_old_rec.pil_attribute11
201: ,p_pil_attribute12_o =>ben_pil_shd.g_old_rec.pil_attribute12
202: ,p_pil_attribute13_o =>ben_pil_shd.g_old_rec.pil_attribute13
203: ,p_pil_attribute14_o =>ben_pil_shd.g_old_rec.pil_attribute14
204: ,p_pil_attribute15_o =>ben_pil_shd.g_old_rec.pil_attribute15
205: ,p_pil_attribute16_o =>ben_pil_shd.g_old_rec.pil_attribute16
206: ,p_pil_attribute17_o =>ben_pil_shd.g_old_rec.pil_attribute17
207: ,p_pil_attribute18_o =>ben_pil_shd.g_old_rec.pil_attribute18
208: ,p_pil_attribute19_o =>ben_pil_shd.g_old_rec.pil_attribute19
201: ,p_pil_attribute12_o =>ben_pil_shd.g_old_rec.pil_attribute12
202: ,p_pil_attribute13_o =>ben_pil_shd.g_old_rec.pil_attribute13
203: ,p_pil_attribute14_o =>ben_pil_shd.g_old_rec.pil_attribute14
204: ,p_pil_attribute15_o =>ben_pil_shd.g_old_rec.pil_attribute15
205: ,p_pil_attribute16_o =>ben_pil_shd.g_old_rec.pil_attribute16
206: ,p_pil_attribute17_o =>ben_pil_shd.g_old_rec.pil_attribute17
207: ,p_pil_attribute18_o =>ben_pil_shd.g_old_rec.pil_attribute18
208: ,p_pil_attribute19_o =>ben_pil_shd.g_old_rec.pil_attribute19
209: ,p_pil_attribute20_o =>ben_pil_shd.g_old_rec.pil_attribute20
202: ,p_pil_attribute13_o =>ben_pil_shd.g_old_rec.pil_attribute13
203: ,p_pil_attribute14_o =>ben_pil_shd.g_old_rec.pil_attribute14
204: ,p_pil_attribute15_o =>ben_pil_shd.g_old_rec.pil_attribute15
205: ,p_pil_attribute16_o =>ben_pil_shd.g_old_rec.pil_attribute16
206: ,p_pil_attribute17_o =>ben_pil_shd.g_old_rec.pil_attribute17
207: ,p_pil_attribute18_o =>ben_pil_shd.g_old_rec.pil_attribute18
208: ,p_pil_attribute19_o =>ben_pil_shd.g_old_rec.pil_attribute19
209: ,p_pil_attribute20_o =>ben_pil_shd.g_old_rec.pil_attribute20
210: ,p_pil_attribute21_o =>ben_pil_shd.g_old_rec.pil_attribute21
203: ,p_pil_attribute14_o =>ben_pil_shd.g_old_rec.pil_attribute14
204: ,p_pil_attribute15_o =>ben_pil_shd.g_old_rec.pil_attribute15
205: ,p_pil_attribute16_o =>ben_pil_shd.g_old_rec.pil_attribute16
206: ,p_pil_attribute17_o =>ben_pil_shd.g_old_rec.pil_attribute17
207: ,p_pil_attribute18_o =>ben_pil_shd.g_old_rec.pil_attribute18
208: ,p_pil_attribute19_o =>ben_pil_shd.g_old_rec.pil_attribute19
209: ,p_pil_attribute20_o =>ben_pil_shd.g_old_rec.pil_attribute20
210: ,p_pil_attribute21_o =>ben_pil_shd.g_old_rec.pil_attribute21
211: ,p_pil_attribute22_o =>ben_pil_shd.g_old_rec.pil_attribute22
204: ,p_pil_attribute15_o =>ben_pil_shd.g_old_rec.pil_attribute15
205: ,p_pil_attribute16_o =>ben_pil_shd.g_old_rec.pil_attribute16
206: ,p_pil_attribute17_o =>ben_pil_shd.g_old_rec.pil_attribute17
207: ,p_pil_attribute18_o =>ben_pil_shd.g_old_rec.pil_attribute18
208: ,p_pil_attribute19_o =>ben_pil_shd.g_old_rec.pil_attribute19
209: ,p_pil_attribute20_o =>ben_pil_shd.g_old_rec.pil_attribute20
210: ,p_pil_attribute21_o =>ben_pil_shd.g_old_rec.pil_attribute21
211: ,p_pil_attribute22_o =>ben_pil_shd.g_old_rec.pil_attribute22
212: ,p_pil_attribute23_o =>ben_pil_shd.g_old_rec.pil_attribute23
205: ,p_pil_attribute16_o =>ben_pil_shd.g_old_rec.pil_attribute16
206: ,p_pil_attribute17_o =>ben_pil_shd.g_old_rec.pil_attribute17
207: ,p_pil_attribute18_o =>ben_pil_shd.g_old_rec.pil_attribute18
208: ,p_pil_attribute19_o =>ben_pil_shd.g_old_rec.pil_attribute19
209: ,p_pil_attribute20_o =>ben_pil_shd.g_old_rec.pil_attribute20
210: ,p_pil_attribute21_o =>ben_pil_shd.g_old_rec.pil_attribute21
211: ,p_pil_attribute22_o =>ben_pil_shd.g_old_rec.pil_attribute22
212: ,p_pil_attribute23_o =>ben_pil_shd.g_old_rec.pil_attribute23
213: ,p_pil_attribute24_o =>ben_pil_shd.g_old_rec.pil_attribute24
206: ,p_pil_attribute17_o =>ben_pil_shd.g_old_rec.pil_attribute17
207: ,p_pil_attribute18_o =>ben_pil_shd.g_old_rec.pil_attribute18
208: ,p_pil_attribute19_o =>ben_pil_shd.g_old_rec.pil_attribute19
209: ,p_pil_attribute20_o =>ben_pil_shd.g_old_rec.pil_attribute20
210: ,p_pil_attribute21_o =>ben_pil_shd.g_old_rec.pil_attribute21
211: ,p_pil_attribute22_o =>ben_pil_shd.g_old_rec.pil_attribute22
212: ,p_pil_attribute23_o =>ben_pil_shd.g_old_rec.pil_attribute23
213: ,p_pil_attribute24_o =>ben_pil_shd.g_old_rec.pil_attribute24
214: ,p_pil_attribute25_o =>ben_pil_shd.g_old_rec.pil_attribute25
207: ,p_pil_attribute18_o =>ben_pil_shd.g_old_rec.pil_attribute18
208: ,p_pil_attribute19_o =>ben_pil_shd.g_old_rec.pil_attribute19
209: ,p_pil_attribute20_o =>ben_pil_shd.g_old_rec.pil_attribute20
210: ,p_pil_attribute21_o =>ben_pil_shd.g_old_rec.pil_attribute21
211: ,p_pil_attribute22_o =>ben_pil_shd.g_old_rec.pil_attribute22
212: ,p_pil_attribute23_o =>ben_pil_shd.g_old_rec.pil_attribute23
213: ,p_pil_attribute24_o =>ben_pil_shd.g_old_rec.pil_attribute24
214: ,p_pil_attribute25_o =>ben_pil_shd.g_old_rec.pil_attribute25
215: ,p_pil_attribute26_o =>ben_pil_shd.g_old_rec.pil_attribute26
208: ,p_pil_attribute19_o =>ben_pil_shd.g_old_rec.pil_attribute19
209: ,p_pil_attribute20_o =>ben_pil_shd.g_old_rec.pil_attribute20
210: ,p_pil_attribute21_o =>ben_pil_shd.g_old_rec.pil_attribute21
211: ,p_pil_attribute22_o =>ben_pil_shd.g_old_rec.pil_attribute22
212: ,p_pil_attribute23_o =>ben_pil_shd.g_old_rec.pil_attribute23
213: ,p_pil_attribute24_o =>ben_pil_shd.g_old_rec.pil_attribute24
214: ,p_pil_attribute25_o =>ben_pil_shd.g_old_rec.pil_attribute25
215: ,p_pil_attribute26_o =>ben_pil_shd.g_old_rec.pil_attribute26
216: ,p_pil_attribute27_o =>ben_pil_shd.g_old_rec.pil_attribute27
209: ,p_pil_attribute20_o =>ben_pil_shd.g_old_rec.pil_attribute20
210: ,p_pil_attribute21_o =>ben_pil_shd.g_old_rec.pil_attribute21
211: ,p_pil_attribute22_o =>ben_pil_shd.g_old_rec.pil_attribute22
212: ,p_pil_attribute23_o =>ben_pil_shd.g_old_rec.pil_attribute23
213: ,p_pil_attribute24_o =>ben_pil_shd.g_old_rec.pil_attribute24
214: ,p_pil_attribute25_o =>ben_pil_shd.g_old_rec.pil_attribute25
215: ,p_pil_attribute26_o =>ben_pil_shd.g_old_rec.pil_attribute26
216: ,p_pil_attribute27_o =>ben_pil_shd.g_old_rec.pil_attribute27
217: ,p_pil_attribute28_o =>ben_pil_shd.g_old_rec.pil_attribute28
210: ,p_pil_attribute21_o =>ben_pil_shd.g_old_rec.pil_attribute21
211: ,p_pil_attribute22_o =>ben_pil_shd.g_old_rec.pil_attribute22
212: ,p_pil_attribute23_o =>ben_pil_shd.g_old_rec.pil_attribute23
213: ,p_pil_attribute24_o =>ben_pil_shd.g_old_rec.pil_attribute24
214: ,p_pil_attribute25_o =>ben_pil_shd.g_old_rec.pil_attribute25
215: ,p_pil_attribute26_o =>ben_pil_shd.g_old_rec.pil_attribute26
216: ,p_pil_attribute27_o =>ben_pil_shd.g_old_rec.pil_attribute27
217: ,p_pil_attribute28_o =>ben_pil_shd.g_old_rec.pil_attribute28
218: ,p_pil_attribute29_o =>ben_pil_shd.g_old_rec.pil_attribute29
211: ,p_pil_attribute22_o =>ben_pil_shd.g_old_rec.pil_attribute22
212: ,p_pil_attribute23_o =>ben_pil_shd.g_old_rec.pil_attribute23
213: ,p_pil_attribute24_o =>ben_pil_shd.g_old_rec.pil_attribute24
214: ,p_pil_attribute25_o =>ben_pil_shd.g_old_rec.pil_attribute25
215: ,p_pil_attribute26_o =>ben_pil_shd.g_old_rec.pil_attribute26
216: ,p_pil_attribute27_o =>ben_pil_shd.g_old_rec.pil_attribute27
217: ,p_pil_attribute28_o =>ben_pil_shd.g_old_rec.pil_attribute28
218: ,p_pil_attribute29_o =>ben_pil_shd.g_old_rec.pil_attribute29
219: ,p_pil_attribute30_o =>ben_pil_shd.g_old_rec.pil_attribute30
212: ,p_pil_attribute23_o =>ben_pil_shd.g_old_rec.pil_attribute23
213: ,p_pil_attribute24_o =>ben_pil_shd.g_old_rec.pil_attribute24
214: ,p_pil_attribute25_o =>ben_pil_shd.g_old_rec.pil_attribute25
215: ,p_pil_attribute26_o =>ben_pil_shd.g_old_rec.pil_attribute26
216: ,p_pil_attribute27_o =>ben_pil_shd.g_old_rec.pil_attribute27
217: ,p_pil_attribute28_o =>ben_pil_shd.g_old_rec.pil_attribute28
218: ,p_pil_attribute29_o =>ben_pil_shd.g_old_rec.pil_attribute29
219: ,p_pil_attribute30_o =>ben_pil_shd.g_old_rec.pil_attribute30
220: ,p_request_id_o =>ben_pil_shd.g_old_rec.request_id
213: ,p_pil_attribute24_o =>ben_pil_shd.g_old_rec.pil_attribute24
214: ,p_pil_attribute25_o =>ben_pil_shd.g_old_rec.pil_attribute25
215: ,p_pil_attribute26_o =>ben_pil_shd.g_old_rec.pil_attribute26
216: ,p_pil_attribute27_o =>ben_pil_shd.g_old_rec.pil_attribute27
217: ,p_pil_attribute28_o =>ben_pil_shd.g_old_rec.pil_attribute28
218: ,p_pil_attribute29_o =>ben_pil_shd.g_old_rec.pil_attribute29
219: ,p_pil_attribute30_o =>ben_pil_shd.g_old_rec.pil_attribute30
220: ,p_request_id_o =>ben_pil_shd.g_old_rec.request_id
221: ,p_program_application_id_o =>ben_pil_shd.g_old_rec.program_application_id
214: ,p_pil_attribute25_o =>ben_pil_shd.g_old_rec.pil_attribute25
215: ,p_pil_attribute26_o =>ben_pil_shd.g_old_rec.pil_attribute26
216: ,p_pil_attribute27_o =>ben_pil_shd.g_old_rec.pil_attribute27
217: ,p_pil_attribute28_o =>ben_pil_shd.g_old_rec.pil_attribute28
218: ,p_pil_attribute29_o =>ben_pil_shd.g_old_rec.pil_attribute29
219: ,p_pil_attribute30_o =>ben_pil_shd.g_old_rec.pil_attribute30
220: ,p_request_id_o =>ben_pil_shd.g_old_rec.request_id
221: ,p_program_application_id_o =>ben_pil_shd.g_old_rec.program_application_id
222: ,p_program_id_o =>ben_pil_shd.g_old_rec.program_id
215: ,p_pil_attribute26_o =>ben_pil_shd.g_old_rec.pil_attribute26
216: ,p_pil_attribute27_o =>ben_pil_shd.g_old_rec.pil_attribute27
217: ,p_pil_attribute28_o =>ben_pil_shd.g_old_rec.pil_attribute28
218: ,p_pil_attribute29_o =>ben_pil_shd.g_old_rec.pil_attribute29
219: ,p_pil_attribute30_o =>ben_pil_shd.g_old_rec.pil_attribute30
220: ,p_request_id_o =>ben_pil_shd.g_old_rec.request_id
221: ,p_program_application_id_o =>ben_pil_shd.g_old_rec.program_application_id
222: ,p_program_id_o =>ben_pil_shd.g_old_rec.program_id
223: ,p_program_update_date_o =>ben_pil_shd.g_old_rec.program_update_date
216: ,p_pil_attribute27_o =>ben_pil_shd.g_old_rec.pil_attribute27
217: ,p_pil_attribute28_o =>ben_pil_shd.g_old_rec.pil_attribute28
218: ,p_pil_attribute29_o =>ben_pil_shd.g_old_rec.pil_attribute29
219: ,p_pil_attribute30_o =>ben_pil_shd.g_old_rec.pil_attribute30
220: ,p_request_id_o =>ben_pil_shd.g_old_rec.request_id
221: ,p_program_application_id_o =>ben_pil_shd.g_old_rec.program_application_id
222: ,p_program_id_o =>ben_pil_shd.g_old_rec.program_id
223: ,p_program_update_date_o =>ben_pil_shd.g_old_rec.program_update_date
224: ,p_object_version_number_o =>ben_pil_shd.g_old_rec.object_version_number
217: ,p_pil_attribute28_o =>ben_pil_shd.g_old_rec.pil_attribute28
218: ,p_pil_attribute29_o =>ben_pil_shd.g_old_rec.pil_attribute29
219: ,p_pil_attribute30_o =>ben_pil_shd.g_old_rec.pil_attribute30
220: ,p_request_id_o =>ben_pil_shd.g_old_rec.request_id
221: ,p_program_application_id_o =>ben_pil_shd.g_old_rec.program_application_id
222: ,p_program_id_o =>ben_pil_shd.g_old_rec.program_id
223: ,p_program_update_date_o =>ben_pil_shd.g_old_rec.program_update_date
224: ,p_object_version_number_o =>ben_pil_shd.g_old_rec.object_version_number
225: );
218: ,p_pil_attribute29_o =>ben_pil_shd.g_old_rec.pil_attribute29
219: ,p_pil_attribute30_o =>ben_pil_shd.g_old_rec.pil_attribute30
220: ,p_request_id_o =>ben_pil_shd.g_old_rec.request_id
221: ,p_program_application_id_o =>ben_pil_shd.g_old_rec.program_application_id
222: ,p_program_id_o =>ben_pil_shd.g_old_rec.program_id
223: ,p_program_update_date_o =>ben_pil_shd.g_old_rec.program_update_date
224: ,p_object_version_number_o =>ben_pil_shd.g_old_rec.object_version_number
225: );
226: --
219: ,p_pil_attribute30_o =>ben_pil_shd.g_old_rec.pil_attribute30
220: ,p_request_id_o =>ben_pil_shd.g_old_rec.request_id
221: ,p_program_application_id_o =>ben_pil_shd.g_old_rec.program_application_id
222: ,p_program_id_o =>ben_pil_shd.g_old_rec.program_id
223: ,p_program_update_date_o =>ben_pil_shd.g_old_rec.program_update_date
224: ,p_object_version_number_o =>ben_pil_shd.g_old_rec.object_version_number
225: );
226: --
227: exception
220: ,p_request_id_o =>ben_pil_shd.g_old_rec.request_id
221: ,p_program_application_id_o =>ben_pil_shd.g_old_rec.program_application_id
222: ,p_program_id_o =>ben_pil_shd.g_old_rec.program_id
223: ,p_program_update_date_o =>ben_pil_shd.g_old_rec.program_update_date
224: ,p_object_version_number_o =>ben_pil_shd.g_old_rec.object_version_number
225: );
226: --
227: exception
228: --
245: -- ----------------------------------------------------------------------------
246: Procedure del
247: (
248: p_effective_date in date,
249: p_rec in ben_pil_shd.g_rec_type
250: ) is
251: --
252: l_proc varchar2(72) := g_package||'del';
253: --
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: -- We must lock the row which we need to delete.
258: --
259: ben_pil_shd.lck
260: (
261: p_rec.per_in_ler_id,
262: p_rec.object_version_number
263: );
290: p_per_in_ler_id in number,
291: p_object_version_number in number
292: ) is
293: --
294: l_rec ben_pil_shd.g_rec_type;
295: l_proc varchar2(72) := g_package||'del';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);