eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PIL_DEL dependencies on BEN_PIL_SHD

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

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

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

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ben_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

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

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

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

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_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

Line 73: ben_pil_shd.constraint_error

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;

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

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: -- ----------------------------------------------------------------------------

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

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

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

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

Line 170: ,p_per_in_ler_stat_cd_o =>ben_pil_shd.g_old_rec.per_in_ler_stat_cd

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

Line 171: ,p_prvs_stat_cd_o =>ben_pil_shd.g_old_rec.prvs_stat_cd

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

Line 172: ,p_lf_evt_ocrd_dt_o =>ben_pil_shd.g_old_rec.lf_evt_ocrd_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

Line 173: ,p_trgr_table_pk_id_o =>ben_pil_shd.g_old_rec.trgr_table_pk_id

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

Line 174: ,p_procd_dt_o =>ben_pil_shd.g_old_rec.procd_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

Line 175: ,p_strtd_dt_o =>ben_pil_shd.g_old_rec.strtd_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

Line 176: ,p_voidd_dt_o =>ben_pil_shd.g_old_rec.voidd_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

Line 177: ,p_bckt_dt_o =>ben_pil_shd.g_old_rec.bckt_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
181: ,p_bckt_per_in_ler_id_o =>ben_pil_shd.g_old_rec.bckt_per_in_ler_id

Line 178: ,p_clsd_dt_o =>ben_pil_shd.g_old_rec.clsd_dt

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

Line 179: ,p_ntfn_dt_o =>ben_pil_shd.g_old_rec.ntfn_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
183: ,p_person_id_o =>ben_pil_shd.g_old_rec.person_id

Line 180: ,p_ptnl_ler_for_per_id_o =>ben_pil_shd.g_old_rec.ptnl_ler_for_per_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

Line 181: ,p_bckt_per_in_ler_id_o =>ben_pil_shd.g_old_rec.bckt_per_in_ler_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

Line 182: ,p_ler_id_o =>ben_pil_shd.g_old_rec.ler_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

Line 183: ,p_person_id_o =>ben_pil_shd.g_old_rec.person_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

Line 184: ,p_business_group_id_o =>ben_pil_shd.g_old_rec.business_group_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

Line 185: ,p_ASSIGNMENT_ID_o => ben_pil_shd.g_old_rec.ASSIGNMENT_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
189: ,p_pil_attribute_category_o =>ben_pil_shd.g_old_rec.pil_attribute_category

Line 186: ,p_WS_MGR_ID_o => ben_pil_shd.g_old_rec.WS_MGR_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
190: ,p_pil_attribute1_o =>ben_pil_shd.g_old_rec.pil_attribute1

Line 187: ,p_GROUP_PL_ID_o => ben_pil_shd.g_old_rec.GROUP_PL_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
191: ,p_pil_attribute2_o =>ben_pil_shd.g_old_rec.pil_attribute2

Line 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

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

Line 189: ,p_pil_attribute_category_o =>ben_pil_shd.g_old_rec.pil_attribute_category

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

Line 190: ,p_pil_attribute1_o =>ben_pil_shd.g_old_rec.pil_attribute1

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

Line 191: ,p_pil_attribute2_o =>ben_pil_shd.g_old_rec.pil_attribute2

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

Line 192: ,p_pil_attribute3_o =>ben_pil_shd.g_old_rec.pil_attribute3

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

Line 193: ,p_pil_attribute4_o =>ben_pil_shd.g_old_rec.pil_attribute4

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

Line 194: ,p_pil_attribute5_o =>ben_pil_shd.g_old_rec.pil_attribute5

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

Line 195: ,p_pil_attribute6_o =>ben_pil_shd.g_old_rec.pil_attribute6

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

Line 196: ,p_pil_attribute7_o =>ben_pil_shd.g_old_rec.pil_attribute7

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

Line 197: ,p_pil_attribute8_o =>ben_pil_shd.g_old_rec.pil_attribute8

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

Line 198: ,p_pil_attribute9_o =>ben_pil_shd.g_old_rec.pil_attribute9

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

Line 199: ,p_pil_attribute10_o =>ben_pil_shd.g_old_rec.pil_attribute10

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

Line 200: ,p_pil_attribute11_o =>ben_pil_shd.g_old_rec.pil_attribute11

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

Line 201: ,p_pil_attribute12_o =>ben_pil_shd.g_old_rec.pil_attribute12

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

Line 202: ,p_pil_attribute13_o =>ben_pil_shd.g_old_rec.pil_attribute13

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

Line 203: ,p_pil_attribute14_o =>ben_pil_shd.g_old_rec.pil_attribute14

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

Line 204: ,p_pil_attribute15_o =>ben_pil_shd.g_old_rec.pil_attribute15

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

Line 205: ,p_pil_attribute16_o =>ben_pil_shd.g_old_rec.pil_attribute16

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

Line 206: ,p_pil_attribute17_o =>ben_pil_shd.g_old_rec.pil_attribute17

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

Line 207: ,p_pil_attribute18_o =>ben_pil_shd.g_old_rec.pil_attribute18

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

Line 208: ,p_pil_attribute19_o =>ben_pil_shd.g_old_rec.pil_attribute19

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

Line 209: ,p_pil_attribute20_o =>ben_pil_shd.g_old_rec.pil_attribute20

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

Line 210: ,p_pil_attribute21_o =>ben_pil_shd.g_old_rec.pil_attribute21

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

Line 211: ,p_pil_attribute22_o =>ben_pil_shd.g_old_rec.pil_attribute22

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

Line 212: ,p_pil_attribute23_o =>ben_pil_shd.g_old_rec.pil_attribute23

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

Line 213: ,p_pil_attribute24_o =>ben_pil_shd.g_old_rec.pil_attribute24

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

Line 214: ,p_pil_attribute25_o =>ben_pil_shd.g_old_rec.pil_attribute25

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

Line 215: ,p_pil_attribute26_o =>ben_pil_shd.g_old_rec.pil_attribute26

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

Line 216: ,p_pil_attribute27_o =>ben_pil_shd.g_old_rec.pil_attribute27

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

Line 217: ,p_pil_attribute28_o =>ben_pil_shd.g_old_rec.pil_attribute28

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

Line 218: ,p_pil_attribute29_o =>ben_pil_shd.g_old_rec.pil_attribute29

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

Line 219: ,p_pil_attribute30_o =>ben_pil_shd.g_old_rec.pil_attribute30

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

Line 220: ,p_request_id_o =>ben_pil_shd.g_old_rec.request_id

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

Line 221: ,p_program_application_id_o =>ben_pil_shd.g_old_rec.program_application_id

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: );

Line 222: ,p_program_id_o =>ben_pil_shd.g_old_rec.program_id

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: --

Line 223: ,p_program_update_date_o =>ben_pil_shd.g_old_rec.program_update_date

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

Line 224: ,p_object_version_number_o =>ben_pil_shd.g_old_rec.object_version_number

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: --

Line 249: p_rec in ben_pil_shd.g_rec_type

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: --

Line 259: ben_pil_shd.lck

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: );

Line 294: l_rec ben_pil_shd.g_rec_type;

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);