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_YRP_DEL dependencies on BEN_YRP_SHD

Line 51: Procedure delete_dml(p_rec in ben_yrp_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_yrp_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: ben_yrp_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_yrp_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_yr_perd row.
61: --
62: delete from ben_yr_perd

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

61: --
62: delete from ben_yr_perd
63: where yr_perd_id = p_rec.yr_perd_id;
64: --
65: ben_yrp_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_yrp_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_yrp_shd.g_api_dml := false; -- Unset the api dml status
73: ben_yrp_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_yrp_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_yrp_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_yrp_shd.g_api_dml := false; -- Unset the api dml status
73: ben_yrp_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_yrp_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

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

72: ben_yrp_shd.g_api_dml := false; -- Unset the api dml status
73: ben_yrp_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_yrp_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_yrp_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_yrp_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_yrp_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_yrp_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin

Line 170: ,p_perds_in_yr_num_o =>ben_yrp_shd.g_old_rec.perds_in_yr_num

166: --
167: ben_yrp_rkd.after_delete
168: (
169: p_yr_perd_id =>p_rec.yr_perd_id
170: ,p_perds_in_yr_num_o =>ben_yrp_shd.g_old_rec.perds_in_yr_num
171: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd
172: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
173: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
174: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date

Line 171: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd

167: ben_yrp_rkd.after_delete
168: (
169: p_yr_perd_id =>p_rec.yr_perd_id
170: ,p_perds_in_yr_num_o =>ben_yrp_shd.g_old_rec.perds_in_yr_num
171: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd
172: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
173: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
174: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
175: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt

Line 172: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd

168: (
169: p_yr_perd_id =>p_rec.yr_perd_id
170: ,p_perds_in_yr_num_o =>ben_yrp_shd.g_old_rec.perds_in_yr_num
171: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd
172: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
173: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
174: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
175: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
176: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt

Line 173: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date

169: p_yr_perd_id =>p_rec.yr_perd_id
170: ,p_perds_in_yr_num_o =>ben_yrp_shd.g_old_rec.perds_in_yr_num
171: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd
172: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
173: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
174: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
175: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
176: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
177: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id

Line 174: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date

170: ,p_perds_in_yr_num_o =>ben_yrp_shd.g_old_rec.perds_in_yr_num
171: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd
172: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
173: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
174: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
175: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
176: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
177: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
178: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category

Line 175: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt

171: ,p_perd_tm_uom_cd_o =>ben_yrp_shd.g_old_rec.perd_tm_uom_cd
172: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
173: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
174: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
175: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
176: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
177: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
178: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
179: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1

Line 176: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt

172: ,p_perd_typ_cd_o =>ben_yrp_shd.g_old_rec.perd_typ_cd
173: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
174: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
175: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
176: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
177: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
178: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
179: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
180: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2

Line 177: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id

173: ,p_end_date_o =>ben_yrp_shd.g_old_rec.end_date
174: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
175: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
176: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
177: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
178: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
179: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
180: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
181: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3

Line 178: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category

174: ,p_start_date_o =>ben_yrp_shd.g_old_rec.start_date
175: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
176: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
177: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
178: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
179: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
180: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
181: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
182: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4

Line 179: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1

175: ,p_lmtn_yr_strt_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_strt_dt
176: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
177: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
178: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
179: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
180: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
181: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
182: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
183: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5

Line 180: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2

176: ,p_lmtn_yr_end_dt_o =>ben_yrp_shd.g_old_rec.lmtn_yr_end_dt
177: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
178: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
179: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
180: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
181: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
182: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
183: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
184: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6

Line 181: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3

177: ,p_business_group_id_o =>ben_yrp_shd.g_old_rec.business_group_id
178: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
179: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
180: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
181: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
182: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
183: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
184: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
185: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7

Line 182: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4

178: ,p_yrp_attribute_category_o =>ben_yrp_shd.g_old_rec.yrp_attribute_category
179: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
180: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
181: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
182: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
183: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
184: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
185: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
186: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8

Line 183: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5

179: ,p_yrp_attribute1_o =>ben_yrp_shd.g_old_rec.yrp_attribute1
180: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
181: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
182: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
183: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
184: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
185: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
186: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
187: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9

Line 184: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6

180: ,p_yrp_attribute2_o =>ben_yrp_shd.g_old_rec.yrp_attribute2
181: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
182: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
183: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
184: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
185: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
186: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
187: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
188: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10

Line 185: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7

181: ,p_yrp_attribute3_o =>ben_yrp_shd.g_old_rec.yrp_attribute3
182: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
183: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
184: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
185: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
186: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
187: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
188: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
189: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11

Line 186: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8

182: ,p_yrp_attribute4_o =>ben_yrp_shd.g_old_rec.yrp_attribute4
183: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
184: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
185: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
186: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
187: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
188: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
189: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
190: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12

Line 187: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9

183: ,p_yrp_attribute5_o =>ben_yrp_shd.g_old_rec.yrp_attribute5
184: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
185: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
186: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
187: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
188: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
189: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
190: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
191: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13

Line 188: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10

184: ,p_yrp_attribute6_o =>ben_yrp_shd.g_old_rec.yrp_attribute6
185: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
186: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
187: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
188: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
189: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
190: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
191: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
192: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14

Line 189: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11

185: ,p_yrp_attribute7_o =>ben_yrp_shd.g_old_rec.yrp_attribute7
186: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
187: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
188: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
189: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
190: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
191: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
192: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
193: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15

Line 190: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12

186: ,p_yrp_attribute8_o =>ben_yrp_shd.g_old_rec.yrp_attribute8
187: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
188: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
189: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
190: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
191: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
192: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
193: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
194: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16

Line 191: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13

187: ,p_yrp_attribute9_o =>ben_yrp_shd.g_old_rec.yrp_attribute9
188: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
189: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
190: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
191: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
192: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
193: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
194: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
195: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17

Line 192: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14

188: ,p_yrp_attribute10_o =>ben_yrp_shd.g_old_rec.yrp_attribute10
189: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
190: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
191: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
192: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
193: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
194: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
195: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
196: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18

Line 193: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15

189: ,p_yrp_attribute11_o =>ben_yrp_shd.g_old_rec.yrp_attribute11
190: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
191: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
192: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
193: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
194: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
195: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
196: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
197: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19

Line 194: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16

190: ,p_yrp_attribute12_o =>ben_yrp_shd.g_old_rec.yrp_attribute12
191: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
192: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
193: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
194: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
195: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
196: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
197: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
198: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20

Line 195: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17

191: ,p_yrp_attribute13_o =>ben_yrp_shd.g_old_rec.yrp_attribute13
192: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
193: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
194: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
195: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
196: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
197: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
198: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
199: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21

Line 196: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18

192: ,p_yrp_attribute14_o =>ben_yrp_shd.g_old_rec.yrp_attribute14
193: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
194: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
195: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
196: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
197: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
198: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
199: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
200: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22

Line 197: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19

193: ,p_yrp_attribute15_o =>ben_yrp_shd.g_old_rec.yrp_attribute15
194: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
195: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
196: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
197: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
198: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
199: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
200: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
201: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23

Line 198: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20

194: ,p_yrp_attribute16_o =>ben_yrp_shd.g_old_rec.yrp_attribute16
195: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
196: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
197: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
198: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
199: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
200: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
201: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
202: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24

Line 199: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21

195: ,p_yrp_attribute17_o =>ben_yrp_shd.g_old_rec.yrp_attribute17
196: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
197: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
198: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
199: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
200: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
201: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
202: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
203: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25

Line 200: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22

196: ,p_yrp_attribute18_o =>ben_yrp_shd.g_old_rec.yrp_attribute18
197: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
198: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
199: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
200: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
201: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
202: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
203: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
204: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26

Line 201: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23

197: ,p_yrp_attribute19_o =>ben_yrp_shd.g_old_rec.yrp_attribute19
198: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
199: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
200: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
201: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
202: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
203: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
204: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
205: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27

Line 202: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24

198: ,p_yrp_attribute20_o =>ben_yrp_shd.g_old_rec.yrp_attribute20
199: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
200: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
201: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
202: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
203: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
204: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
205: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
206: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28

Line 203: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25

199: ,p_yrp_attribute21_o =>ben_yrp_shd.g_old_rec.yrp_attribute21
200: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
201: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
202: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
203: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
204: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
205: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
206: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
207: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29

Line 204: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26

200: ,p_yrp_attribute22_o =>ben_yrp_shd.g_old_rec.yrp_attribute22
201: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
202: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
203: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
204: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
205: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
206: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
207: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29
208: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30

Line 205: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27

201: ,p_yrp_attribute23_o =>ben_yrp_shd.g_old_rec.yrp_attribute23
202: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
203: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
204: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
205: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
206: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
207: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29
208: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30
209: ,p_object_version_number_o =>ben_yrp_shd.g_old_rec.object_version_number

Line 206: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28

202: ,p_yrp_attribute24_o =>ben_yrp_shd.g_old_rec.yrp_attribute24
203: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
204: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
205: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
206: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
207: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29
208: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30
209: ,p_object_version_number_o =>ben_yrp_shd.g_old_rec.object_version_number
210: );

Line 207: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29

203: ,p_yrp_attribute25_o =>ben_yrp_shd.g_old_rec.yrp_attribute25
204: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
205: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
206: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
207: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29
208: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30
209: ,p_object_version_number_o =>ben_yrp_shd.g_old_rec.object_version_number
210: );
211: --

Line 208: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30

204: ,p_yrp_attribute26_o =>ben_yrp_shd.g_old_rec.yrp_attribute26
205: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
206: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
207: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29
208: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30
209: ,p_object_version_number_o =>ben_yrp_shd.g_old_rec.object_version_number
210: );
211: --
212: exception

Line 209: ,p_object_version_number_o =>ben_yrp_shd.g_old_rec.object_version_number

205: ,p_yrp_attribute27_o =>ben_yrp_shd.g_old_rec.yrp_attribute27
206: ,p_yrp_attribute28_o =>ben_yrp_shd.g_old_rec.yrp_attribute28
207: ,p_yrp_attribute29_o =>ben_yrp_shd.g_old_rec.yrp_attribute29
208: ,p_yrp_attribute30_o =>ben_yrp_shd.g_old_rec.yrp_attribute30
209: ,p_object_version_number_o =>ben_yrp_shd.g_old_rec.object_version_number
210: );
211: --
212: exception
213: --

Line 234: p_rec in ben_yrp_shd.g_rec_type

230: -- ----------------------------------------------------------------------------
231: Procedure del
232: (
233: p_effective_date in date,
234: p_rec in ben_yrp_shd.g_rec_type
235: ) is
236: --
237: l_proc varchar2(72) := g_package||'del';
238: --

Line 244: ben_yrp_shd.lck

240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: -- We must lock the row which we need to delete.
243: --
244: ben_yrp_shd.lck
245: (
246: p_rec.yr_perd_id,
247: p_rec.object_version_number
248: );

Line 279: l_rec ben_yrp_shd.g_rec_type;

275: p_yr_perd_id in number,
276: p_object_version_number in number
277: ) is
278: --
279: l_rec ben_yrp_shd.g_rec_type;
280: l_proc varchar2(72) := g_package||'del';
281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 5);