APPS.BEN_PCP_DEL dependencies on BEN_PCP_SHD

Line 52: (p_rec in ben_pcp_shd.g_rec_type

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

Line 60: ben_pcp_shd.g_api_dml := true; -- Set the api dml status

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

Line 67: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 74: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 75: ben_pcp_shd.constraint_error

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;

Line 78: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status

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

Line 114: Procedure pre_delete(p_rec in ben_pcp_shd.g_rec_type) is

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

Line 156: Procedure post_delete(p_rec in ben_pcp_shd.g_rec_type) is

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

Line 168: => ben_pcp_shd.g_old_rec.pl_id

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

Line 170: => ben_pcp_shd.g_old_rec.business_group_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
173: ,p_pcp_dsgn_cd_o
174: => ben_pcp_shd.g_old_rec.pcp_dsgn_cd

Line 172: => ben_pcp_shd.g_old_rec.pcp_strt_dt_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

Line 174: => ben_pcp_shd.g_old_rec.pcp_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

Line 176: => ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd

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

Line 178: => ben_pcp_shd.g_old_rec.pcp_rpstry_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

Line 180: => ben_pcp_shd.g_old_rec.pcp_can_keep_flag

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

Line 182: => ben_pcp_shd.g_old_rec.pcp_radius

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

Line 184: => ben_pcp_shd.g_old_rec.pcp_radius_uom

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

Line 186: => ben_pcp_shd.g_old_rec.pcp_radius_warn_flag

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

Line 188: => ben_pcp_shd.g_old_rec.pcp_num_chgs

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

Line 190: => ben_pcp_shd.g_old_rec.pcp_num_chgs_uom

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

Line 192: => ben_pcp_shd.g_old_rec.pcp_attribute_category

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

Line 194: => ben_pcp_shd.g_old_rec.pcp_attribute1

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

Line 196: => ben_pcp_shd.g_old_rec.pcp_attribute2

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

Line 198: => ben_pcp_shd.g_old_rec.pcp_attribute3

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

Line 200: => ben_pcp_shd.g_old_rec.pcp_attribute4

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

Line 202: => ben_pcp_shd.g_old_rec.pcp_attribute5

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

Line 204: => ben_pcp_shd.g_old_rec.pcp_attribute6

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

Line 206: => ben_pcp_shd.g_old_rec.pcp_attribute7

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

Line 208: => ben_pcp_shd.g_old_rec.pcp_attribute8

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

Line 210: => ben_pcp_shd.g_old_rec.pcp_attribute9

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

Line 212: => ben_pcp_shd.g_old_rec.pcp_attribute10

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

Line 214: => ben_pcp_shd.g_old_rec.pcp_attribute11

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

Line 216: => ben_pcp_shd.g_old_rec.pcp_attribute12

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

Line 218: => ben_pcp_shd.g_old_rec.pcp_attribute13

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

Line 220: => ben_pcp_shd.g_old_rec.pcp_attribute14

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

Line 222: => ben_pcp_shd.g_old_rec.pcp_attribute15

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

Line 224: => ben_pcp_shd.g_old_rec.pcp_attribute16

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

Line 226: => ben_pcp_shd.g_old_rec.pcp_attribute17

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

Line 228: => ben_pcp_shd.g_old_rec.pcp_attribute18

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

Line 230: => ben_pcp_shd.g_old_rec.pcp_attribute19

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

Line 232: => ben_pcp_shd.g_old_rec.pcp_attribute20

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

Line 234: => ben_pcp_shd.g_old_rec.pcp_attribute21

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

Line 236: => ben_pcp_shd.g_old_rec.pcp_attribute22

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

Line 238: => ben_pcp_shd.g_old_rec.pcp_attribute23

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

Line 240: => ben_pcp_shd.g_old_rec.pcp_attribute24

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

Line 242: => ben_pcp_shd.g_old_rec.pcp_attribute25

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

Line 244: => ben_pcp_shd.g_old_rec.pcp_attribute26

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

Line 246: => ben_pcp_shd.g_old_rec.pcp_attribute27

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

Line 248: => ben_pcp_shd.g_old_rec.pcp_attribute28

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

Line 250: => ben_pcp_shd.g_old_rec.pcp_attribute29

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

Line 252: => ben_pcp_shd.g_old_rec.pcp_attribute30

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

Line 254: => ben_pcp_shd.g_old_rec.object_version_number

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

Line 274: (p_rec in ben_pcp_shd.g_rec_type

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

Line 284: ben_pcp_shd.lck

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

Line 320: l_rec ben_pcp_shd.g_rec_type;

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