48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in ben_pcp_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: ben_pcp_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the ben_pl_pcp row.
63: --
64: delete from ben_pl_pcp
63: --
64: delete from ben_pl_pcp
65: where pl_pcp_id = p_rec.pl_pcp_id;
66: --
67: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception
70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
75: ben_pcp_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
75: ben_pcp_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
74: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
75: ben_pcp_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
79: Raise;
80: End delete_dml;
81: --
82: -- ----------------------------------------------------------------------------
110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in ben_pcp_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin
152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in ben_pcp_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin
164: ben_pcp_rkd.after_delete
165: (p_pl_pcp_id
166: => p_rec.pl_pcp_id
167: ,p_pl_id_o
168: => ben_pcp_shd.g_old_rec.pl_id
169: ,p_business_group_id_o
170: => ben_pcp_shd.g_old_rec.business_group_id
171: ,p_pcp_strt_dt_cd_o
172: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
166: => p_rec.pl_pcp_id
167: ,p_pl_id_o
168: => ben_pcp_shd.g_old_rec.pl_id
169: ,p_business_group_id_o
170: => ben_pcp_shd.g_old_rec.business_group_id
171: ,p_pcp_strt_dt_cd_o
172: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
173: ,p_pcp_dsgn_cd_o
174: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
168: => ben_pcp_shd.g_old_rec.pl_id
169: ,p_business_group_id_o
170: => ben_pcp_shd.g_old_rec.business_group_id
171: ,p_pcp_strt_dt_cd_o
172: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
173: ,p_pcp_dsgn_cd_o
174: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
175: ,p_pcp_dpnt_dsgn_cd_o
176: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
170: => ben_pcp_shd.g_old_rec.business_group_id
171: ,p_pcp_strt_dt_cd_o
172: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
173: ,p_pcp_dsgn_cd_o
174: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
175: ,p_pcp_dpnt_dsgn_cd_o
176: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
177: ,p_pcp_rpstry_flag_o
178: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
172: => ben_pcp_shd.g_old_rec.pcp_strt_dt_cd
173: ,p_pcp_dsgn_cd_o
174: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
175: ,p_pcp_dpnt_dsgn_cd_o
176: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
177: ,p_pcp_rpstry_flag_o
178: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
179: ,p_pcp_can_keep_flag_o
180: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
174: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd
175: ,p_pcp_dpnt_dsgn_cd_o
176: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
177: ,p_pcp_rpstry_flag_o
178: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
179: ,p_pcp_can_keep_flag_o
180: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
181: ,p_pcp_radius_o
182: => ben_pcp_shd.g_old_rec.pcp_radius
176: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd
177: ,p_pcp_rpstry_flag_o
178: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
179: ,p_pcp_can_keep_flag_o
180: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
181: ,p_pcp_radius_o
182: => ben_pcp_shd.g_old_rec.pcp_radius
183: ,p_pcp_radius_uom_o
184: => ben_pcp_shd.g_old_rec.pcp_radius_uom
178: => ben_pcp_shd.g_old_rec.pcp_rpstry_flag
179: ,p_pcp_can_keep_flag_o
180: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
181: ,p_pcp_radius_o
182: => ben_pcp_shd.g_old_rec.pcp_radius
183: ,p_pcp_radius_uom_o
184: => ben_pcp_shd.g_old_rec.pcp_radius_uom
185: ,p_pcp_radius_warn_flag_o
186: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
180: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag
181: ,p_pcp_radius_o
182: => ben_pcp_shd.g_old_rec.pcp_radius
183: ,p_pcp_radius_uom_o
184: => ben_pcp_shd.g_old_rec.pcp_radius_uom
185: ,p_pcp_radius_warn_flag_o
186: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
187: ,p_pcp_num_chgs_o
188: => ben_pcp_shd.g_old_rec.pcp_num_chgs
182: => ben_pcp_shd.g_old_rec.pcp_radius
183: ,p_pcp_radius_uom_o
184: => ben_pcp_shd.g_old_rec.pcp_radius_uom
185: ,p_pcp_radius_warn_flag_o
186: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
187: ,p_pcp_num_chgs_o
188: => ben_pcp_shd.g_old_rec.pcp_num_chgs
189: ,p_pcp_num_chgs_uom_o
190: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
184: => ben_pcp_shd.g_old_rec.pcp_radius_uom
185: ,p_pcp_radius_warn_flag_o
186: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
187: ,p_pcp_num_chgs_o
188: => ben_pcp_shd.g_old_rec.pcp_num_chgs
189: ,p_pcp_num_chgs_uom_o
190: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
191: ,p_pcp_attribute_category_o
192: => ben_pcp_shd.g_old_rec.pcp_attribute_category
186: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag
187: ,p_pcp_num_chgs_o
188: => ben_pcp_shd.g_old_rec.pcp_num_chgs
189: ,p_pcp_num_chgs_uom_o
190: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
191: ,p_pcp_attribute_category_o
192: => ben_pcp_shd.g_old_rec.pcp_attribute_category
193: ,p_pcp_attribute1_o
194: => ben_pcp_shd.g_old_rec.pcp_attribute1
188: => ben_pcp_shd.g_old_rec.pcp_num_chgs
189: ,p_pcp_num_chgs_uom_o
190: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
191: ,p_pcp_attribute_category_o
192: => ben_pcp_shd.g_old_rec.pcp_attribute_category
193: ,p_pcp_attribute1_o
194: => ben_pcp_shd.g_old_rec.pcp_attribute1
195: ,p_pcp_attribute2_o
196: => ben_pcp_shd.g_old_rec.pcp_attribute2
190: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom
191: ,p_pcp_attribute_category_o
192: => ben_pcp_shd.g_old_rec.pcp_attribute_category
193: ,p_pcp_attribute1_o
194: => ben_pcp_shd.g_old_rec.pcp_attribute1
195: ,p_pcp_attribute2_o
196: => ben_pcp_shd.g_old_rec.pcp_attribute2
197: ,p_pcp_attribute3_o
198: => ben_pcp_shd.g_old_rec.pcp_attribute3
192: => ben_pcp_shd.g_old_rec.pcp_attribute_category
193: ,p_pcp_attribute1_o
194: => ben_pcp_shd.g_old_rec.pcp_attribute1
195: ,p_pcp_attribute2_o
196: => ben_pcp_shd.g_old_rec.pcp_attribute2
197: ,p_pcp_attribute3_o
198: => ben_pcp_shd.g_old_rec.pcp_attribute3
199: ,p_pcp_attribute4_o
200: => ben_pcp_shd.g_old_rec.pcp_attribute4
194: => ben_pcp_shd.g_old_rec.pcp_attribute1
195: ,p_pcp_attribute2_o
196: => ben_pcp_shd.g_old_rec.pcp_attribute2
197: ,p_pcp_attribute3_o
198: => ben_pcp_shd.g_old_rec.pcp_attribute3
199: ,p_pcp_attribute4_o
200: => ben_pcp_shd.g_old_rec.pcp_attribute4
201: ,p_pcp_attribute5_o
202: => ben_pcp_shd.g_old_rec.pcp_attribute5
196: => ben_pcp_shd.g_old_rec.pcp_attribute2
197: ,p_pcp_attribute3_o
198: => ben_pcp_shd.g_old_rec.pcp_attribute3
199: ,p_pcp_attribute4_o
200: => ben_pcp_shd.g_old_rec.pcp_attribute4
201: ,p_pcp_attribute5_o
202: => ben_pcp_shd.g_old_rec.pcp_attribute5
203: ,p_pcp_attribute6_o
204: => ben_pcp_shd.g_old_rec.pcp_attribute6
198: => ben_pcp_shd.g_old_rec.pcp_attribute3
199: ,p_pcp_attribute4_o
200: => ben_pcp_shd.g_old_rec.pcp_attribute4
201: ,p_pcp_attribute5_o
202: => ben_pcp_shd.g_old_rec.pcp_attribute5
203: ,p_pcp_attribute6_o
204: => ben_pcp_shd.g_old_rec.pcp_attribute6
205: ,p_pcp_attribute7_o
206: => ben_pcp_shd.g_old_rec.pcp_attribute7
200: => ben_pcp_shd.g_old_rec.pcp_attribute4
201: ,p_pcp_attribute5_o
202: => ben_pcp_shd.g_old_rec.pcp_attribute5
203: ,p_pcp_attribute6_o
204: => ben_pcp_shd.g_old_rec.pcp_attribute6
205: ,p_pcp_attribute7_o
206: => ben_pcp_shd.g_old_rec.pcp_attribute7
207: ,p_pcp_attribute8_o
208: => ben_pcp_shd.g_old_rec.pcp_attribute8
202: => ben_pcp_shd.g_old_rec.pcp_attribute5
203: ,p_pcp_attribute6_o
204: => ben_pcp_shd.g_old_rec.pcp_attribute6
205: ,p_pcp_attribute7_o
206: => ben_pcp_shd.g_old_rec.pcp_attribute7
207: ,p_pcp_attribute8_o
208: => ben_pcp_shd.g_old_rec.pcp_attribute8
209: ,p_pcp_attribute9_o
210: => ben_pcp_shd.g_old_rec.pcp_attribute9
204: => ben_pcp_shd.g_old_rec.pcp_attribute6
205: ,p_pcp_attribute7_o
206: => ben_pcp_shd.g_old_rec.pcp_attribute7
207: ,p_pcp_attribute8_o
208: => ben_pcp_shd.g_old_rec.pcp_attribute8
209: ,p_pcp_attribute9_o
210: => ben_pcp_shd.g_old_rec.pcp_attribute9
211: ,p_pcp_attribute10_o
212: => ben_pcp_shd.g_old_rec.pcp_attribute10
206: => ben_pcp_shd.g_old_rec.pcp_attribute7
207: ,p_pcp_attribute8_o
208: => ben_pcp_shd.g_old_rec.pcp_attribute8
209: ,p_pcp_attribute9_o
210: => ben_pcp_shd.g_old_rec.pcp_attribute9
211: ,p_pcp_attribute10_o
212: => ben_pcp_shd.g_old_rec.pcp_attribute10
213: ,p_pcp_attribute11_o
214: => ben_pcp_shd.g_old_rec.pcp_attribute11
208: => ben_pcp_shd.g_old_rec.pcp_attribute8
209: ,p_pcp_attribute9_o
210: => ben_pcp_shd.g_old_rec.pcp_attribute9
211: ,p_pcp_attribute10_o
212: => ben_pcp_shd.g_old_rec.pcp_attribute10
213: ,p_pcp_attribute11_o
214: => ben_pcp_shd.g_old_rec.pcp_attribute11
215: ,p_pcp_attribute12_o
216: => ben_pcp_shd.g_old_rec.pcp_attribute12
210: => ben_pcp_shd.g_old_rec.pcp_attribute9
211: ,p_pcp_attribute10_o
212: => ben_pcp_shd.g_old_rec.pcp_attribute10
213: ,p_pcp_attribute11_o
214: => ben_pcp_shd.g_old_rec.pcp_attribute11
215: ,p_pcp_attribute12_o
216: => ben_pcp_shd.g_old_rec.pcp_attribute12
217: ,p_pcp_attribute13_o
218: => ben_pcp_shd.g_old_rec.pcp_attribute13
212: => ben_pcp_shd.g_old_rec.pcp_attribute10
213: ,p_pcp_attribute11_o
214: => ben_pcp_shd.g_old_rec.pcp_attribute11
215: ,p_pcp_attribute12_o
216: => ben_pcp_shd.g_old_rec.pcp_attribute12
217: ,p_pcp_attribute13_o
218: => ben_pcp_shd.g_old_rec.pcp_attribute13
219: ,p_pcp_attribute14_o
220: => ben_pcp_shd.g_old_rec.pcp_attribute14
214: => ben_pcp_shd.g_old_rec.pcp_attribute11
215: ,p_pcp_attribute12_o
216: => ben_pcp_shd.g_old_rec.pcp_attribute12
217: ,p_pcp_attribute13_o
218: => ben_pcp_shd.g_old_rec.pcp_attribute13
219: ,p_pcp_attribute14_o
220: => ben_pcp_shd.g_old_rec.pcp_attribute14
221: ,p_pcp_attribute15_o
222: => ben_pcp_shd.g_old_rec.pcp_attribute15
216: => ben_pcp_shd.g_old_rec.pcp_attribute12
217: ,p_pcp_attribute13_o
218: => ben_pcp_shd.g_old_rec.pcp_attribute13
219: ,p_pcp_attribute14_o
220: => ben_pcp_shd.g_old_rec.pcp_attribute14
221: ,p_pcp_attribute15_o
222: => ben_pcp_shd.g_old_rec.pcp_attribute15
223: ,p_pcp_attribute16_o
224: => ben_pcp_shd.g_old_rec.pcp_attribute16
218: => ben_pcp_shd.g_old_rec.pcp_attribute13
219: ,p_pcp_attribute14_o
220: => ben_pcp_shd.g_old_rec.pcp_attribute14
221: ,p_pcp_attribute15_o
222: => ben_pcp_shd.g_old_rec.pcp_attribute15
223: ,p_pcp_attribute16_o
224: => ben_pcp_shd.g_old_rec.pcp_attribute16
225: ,p_pcp_attribute17_o
226: => ben_pcp_shd.g_old_rec.pcp_attribute17
220: => ben_pcp_shd.g_old_rec.pcp_attribute14
221: ,p_pcp_attribute15_o
222: => ben_pcp_shd.g_old_rec.pcp_attribute15
223: ,p_pcp_attribute16_o
224: => ben_pcp_shd.g_old_rec.pcp_attribute16
225: ,p_pcp_attribute17_o
226: => ben_pcp_shd.g_old_rec.pcp_attribute17
227: ,p_pcp_attribute18_o
228: => ben_pcp_shd.g_old_rec.pcp_attribute18
222: => ben_pcp_shd.g_old_rec.pcp_attribute15
223: ,p_pcp_attribute16_o
224: => ben_pcp_shd.g_old_rec.pcp_attribute16
225: ,p_pcp_attribute17_o
226: => ben_pcp_shd.g_old_rec.pcp_attribute17
227: ,p_pcp_attribute18_o
228: => ben_pcp_shd.g_old_rec.pcp_attribute18
229: ,p_pcp_attribute19_o
230: => ben_pcp_shd.g_old_rec.pcp_attribute19
224: => ben_pcp_shd.g_old_rec.pcp_attribute16
225: ,p_pcp_attribute17_o
226: => ben_pcp_shd.g_old_rec.pcp_attribute17
227: ,p_pcp_attribute18_o
228: => ben_pcp_shd.g_old_rec.pcp_attribute18
229: ,p_pcp_attribute19_o
230: => ben_pcp_shd.g_old_rec.pcp_attribute19
231: ,p_pcp_attribute20_o
232: => ben_pcp_shd.g_old_rec.pcp_attribute20
226: => ben_pcp_shd.g_old_rec.pcp_attribute17
227: ,p_pcp_attribute18_o
228: => ben_pcp_shd.g_old_rec.pcp_attribute18
229: ,p_pcp_attribute19_o
230: => ben_pcp_shd.g_old_rec.pcp_attribute19
231: ,p_pcp_attribute20_o
232: => ben_pcp_shd.g_old_rec.pcp_attribute20
233: ,p_pcp_attribute21_o
234: => ben_pcp_shd.g_old_rec.pcp_attribute21
228: => ben_pcp_shd.g_old_rec.pcp_attribute18
229: ,p_pcp_attribute19_o
230: => ben_pcp_shd.g_old_rec.pcp_attribute19
231: ,p_pcp_attribute20_o
232: => ben_pcp_shd.g_old_rec.pcp_attribute20
233: ,p_pcp_attribute21_o
234: => ben_pcp_shd.g_old_rec.pcp_attribute21
235: ,p_pcp_attribute22_o
236: => ben_pcp_shd.g_old_rec.pcp_attribute22
230: => ben_pcp_shd.g_old_rec.pcp_attribute19
231: ,p_pcp_attribute20_o
232: => ben_pcp_shd.g_old_rec.pcp_attribute20
233: ,p_pcp_attribute21_o
234: => ben_pcp_shd.g_old_rec.pcp_attribute21
235: ,p_pcp_attribute22_o
236: => ben_pcp_shd.g_old_rec.pcp_attribute22
237: ,p_pcp_attribute23_o
238: => ben_pcp_shd.g_old_rec.pcp_attribute23
232: => ben_pcp_shd.g_old_rec.pcp_attribute20
233: ,p_pcp_attribute21_o
234: => ben_pcp_shd.g_old_rec.pcp_attribute21
235: ,p_pcp_attribute22_o
236: => ben_pcp_shd.g_old_rec.pcp_attribute22
237: ,p_pcp_attribute23_o
238: => ben_pcp_shd.g_old_rec.pcp_attribute23
239: ,p_pcp_attribute24_o
240: => ben_pcp_shd.g_old_rec.pcp_attribute24
234: => ben_pcp_shd.g_old_rec.pcp_attribute21
235: ,p_pcp_attribute22_o
236: => ben_pcp_shd.g_old_rec.pcp_attribute22
237: ,p_pcp_attribute23_o
238: => ben_pcp_shd.g_old_rec.pcp_attribute23
239: ,p_pcp_attribute24_o
240: => ben_pcp_shd.g_old_rec.pcp_attribute24
241: ,p_pcp_attribute25_o
242: => ben_pcp_shd.g_old_rec.pcp_attribute25
236: => ben_pcp_shd.g_old_rec.pcp_attribute22
237: ,p_pcp_attribute23_o
238: => ben_pcp_shd.g_old_rec.pcp_attribute23
239: ,p_pcp_attribute24_o
240: => ben_pcp_shd.g_old_rec.pcp_attribute24
241: ,p_pcp_attribute25_o
242: => ben_pcp_shd.g_old_rec.pcp_attribute25
243: ,p_pcp_attribute26_o
244: => ben_pcp_shd.g_old_rec.pcp_attribute26
238: => ben_pcp_shd.g_old_rec.pcp_attribute23
239: ,p_pcp_attribute24_o
240: => ben_pcp_shd.g_old_rec.pcp_attribute24
241: ,p_pcp_attribute25_o
242: => ben_pcp_shd.g_old_rec.pcp_attribute25
243: ,p_pcp_attribute26_o
244: => ben_pcp_shd.g_old_rec.pcp_attribute26
245: ,p_pcp_attribute27_o
246: => ben_pcp_shd.g_old_rec.pcp_attribute27
240: => ben_pcp_shd.g_old_rec.pcp_attribute24
241: ,p_pcp_attribute25_o
242: => ben_pcp_shd.g_old_rec.pcp_attribute25
243: ,p_pcp_attribute26_o
244: => ben_pcp_shd.g_old_rec.pcp_attribute26
245: ,p_pcp_attribute27_o
246: => ben_pcp_shd.g_old_rec.pcp_attribute27
247: ,p_pcp_attribute28_o
248: => ben_pcp_shd.g_old_rec.pcp_attribute28
242: => ben_pcp_shd.g_old_rec.pcp_attribute25
243: ,p_pcp_attribute26_o
244: => ben_pcp_shd.g_old_rec.pcp_attribute26
245: ,p_pcp_attribute27_o
246: => ben_pcp_shd.g_old_rec.pcp_attribute27
247: ,p_pcp_attribute28_o
248: => ben_pcp_shd.g_old_rec.pcp_attribute28
249: ,p_pcp_attribute29_o
250: => ben_pcp_shd.g_old_rec.pcp_attribute29
244: => ben_pcp_shd.g_old_rec.pcp_attribute26
245: ,p_pcp_attribute27_o
246: => ben_pcp_shd.g_old_rec.pcp_attribute27
247: ,p_pcp_attribute28_o
248: => ben_pcp_shd.g_old_rec.pcp_attribute28
249: ,p_pcp_attribute29_o
250: => ben_pcp_shd.g_old_rec.pcp_attribute29
251: ,p_pcp_attribute30_o
252: => ben_pcp_shd.g_old_rec.pcp_attribute30
246: => ben_pcp_shd.g_old_rec.pcp_attribute27
247: ,p_pcp_attribute28_o
248: => ben_pcp_shd.g_old_rec.pcp_attribute28
249: ,p_pcp_attribute29_o
250: => ben_pcp_shd.g_old_rec.pcp_attribute29
251: ,p_pcp_attribute30_o
252: => ben_pcp_shd.g_old_rec.pcp_attribute30
253: ,p_object_version_number_o
254: => ben_pcp_shd.g_old_rec.object_version_number
248: => ben_pcp_shd.g_old_rec.pcp_attribute28
249: ,p_pcp_attribute29_o
250: => ben_pcp_shd.g_old_rec.pcp_attribute29
251: ,p_pcp_attribute30_o
252: => ben_pcp_shd.g_old_rec.pcp_attribute30
253: ,p_object_version_number_o
254: => ben_pcp_shd.g_old_rec.object_version_number
255: );
256: --
250: => ben_pcp_shd.g_old_rec.pcp_attribute29
251: ,p_pcp_attribute30_o
252: => ben_pcp_shd.g_old_rec.pcp_attribute30
253: ,p_object_version_number_o
254: => ben_pcp_shd.g_old_rec.object_version_number
255: );
256: --
257: exception
258: --
270: -- ----------------------------------------------------------------------------
271: -- |---------------------------------< del >----------------------------------|
272: -- ----------------------------------------------------------------------------
273: Procedure del
274: (p_rec in ben_pcp_shd.g_rec_type
275: ) is
276: --
277: l_proc varchar2(72) := g_package||'del';
278: --
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: -- We must lock the row which we need to delete.
283: --
284: ben_pcp_shd.lck
285: (p_rec.pl_pcp_id
286: ,p_rec.object_version_number
287: );
288: --
316: (p_pl_pcp_id in number
317: ,p_object_version_number in number
318: ) is
319: --
320: l_rec ben_pcp_shd.g_rec_type;
321: l_proc varchar2(72) := g_package||'del';
322: --
323: Begin
324: hr_utility.set_location('Entering:'||l_proc, 5);