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_PCG_DEL dependencies on BEN_PCG_SHD

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

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

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

61: --
62: delete from ben_prtt_clm_gd_or_svc_typ
63: where prtt_clm_gd_or_svc_typ_id = p_rec.prtt_clm_gd_or_svc_typ_id;
64: --
65: ben_pcg_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_pcg_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_pcg_shd.g_api_dml := false; -- Unset the api dml status
73: ben_pcg_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_pcg_shd.constraint_error

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

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

72: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status
73: ben_pcg_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_pcg_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 150: Procedure pre_delete(p_rec in ben_pcg_shd.g_rec_type) is

146: -- Internal Row Handler Use Only.
147: --
148: -- {End Of Comments}
149: -- ----------------------------------------------------------------------------
150: Procedure pre_delete(p_rec in ben_pcg_shd.g_rec_type) is
151: --
152: l_proc varchar2(72) := g_package||'pre_delete';
153: --
154: Begin

Line 192: Procedure post_delete(p_rec in ben_pcg_shd.g_rec_type) is

188: -- Internal table Handler Use Only.
189: --
190: -- {End Of Comments}
191: -- ----------------------------------------------------------------------------
192: Procedure post_delete(p_rec in ben_pcg_shd.g_rec_type) is
193: --
194: l_proc varchar2(72) := g_package||'post_delete';
195: --
196: Begin

Line 207: ,p_prtt_reimbmt_rqst_id_o =>ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id

203: --
204: ben_pcg_rkd.after_delete
205: (
206: p_prtt_clm_gd_or_svc_typ_id =>p_rec.prtt_clm_gd_or_svc_typ_id
207: ,p_prtt_reimbmt_rqst_id_o =>ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id
208: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id
209: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
210: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
211: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1

Line 208: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id

204: ben_pcg_rkd.after_delete
205: (
206: p_prtt_clm_gd_or_svc_typ_id =>p_rec.prtt_clm_gd_or_svc_typ_id
207: ,p_prtt_reimbmt_rqst_id_o =>ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id
208: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id
209: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
210: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
211: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
212: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2

Line 209: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id

205: (
206: p_prtt_clm_gd_or_svc_typ_id =>p_rec.prtt_clm_gd_or_svc_typ_id
207: ,p_prtt_reimbmt_rqst_id_o =>ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id
208: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id
209: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
210: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
211: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
212: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
213: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3

Line 210: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category

206: p_prtt_clm_gd_or_svc_typ_id =>p_rec.prtt_clm_gd_or_svc_typ_id
207: ,p_prtt_reimbmt_rqst_id_o =>ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id
208: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id
209: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
210: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
211: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
212: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
213: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
214: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4

Line 211: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1

207: ,p_prtt_reimbmt_rqst_id_o =>ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id
208: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id
209: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
210: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
211: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
212: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
213: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
214: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
215: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5

Line 212: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2

208: ,p_gd_or_svc_typ_id_o =>ben_pcg_shd.g_old_rec.gd_or_svc_typ_id
209: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
210: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
211: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
212: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
213: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
214: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
215: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
216: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6

Line 213: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3

209: ,p_business_group_id_o =>ben_pcg_shd.g_old_rec.business_group_id
210: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
211: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
212: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
213: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
214: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
215: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
216: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
217: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7

Line 214: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4

210: ,p_pcg_attribute_category_o =>ben_pcg_shd.g_old_rec.pcg_attribute_category
211: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
212: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
213: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
214: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
215: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
216: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
217: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
218: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8

Line 215: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5

211: ,p_pcg_attribute1_o =>ben_pcg_shd.g_old_rec.pcg_attribute1
212: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
213: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
214: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
215: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
216: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
217: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
218: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
219: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9

Line 216: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6

212: ,p_pcg_attribute2_o =>ben_pcg_shd.g_old_rec.pcg_attribute2
213: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
214: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
215: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
216: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
217: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
218: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
219: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
220: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10

Line 217: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7

213: ,p_pcg_attribute3_o =>ben_pcg_shd.g_old_rec.pcg_attribute3
214: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
215: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
216: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
217: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
218: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
219: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
220: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
221: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11

Line 218: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8

214: ,p_pcg_attribute4_o =>ben_pcg_shd.g_old_rec.pcg_attribute4
215: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
216: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
217: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
218: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
219: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
220: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
221: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
222: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12

Line 219: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9

215: ,p_pcg_attribute5_o =>ben_pcg_shd.g_old_rec.pcg_attribute5
216: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
217: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
218: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
219: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
220: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
221: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
222: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
223: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13

Line 220: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10

216: ,p_pcg_attribute6_o =>ben_pcg_shd.g_old_rec.pcg_attribute6
217: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
218: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
219: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
220: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
221: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
222: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
223: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
224: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14

Line 221: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11

217: ,p_pcg_attribute7_o =>ben_pcg_shd.g_old_rec.pcg_attribute7
218: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
219: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
220: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
221: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
222: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
223: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
224: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
225: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15

Line 222: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12

218: ,p_pcg_attribute8_o =>ben_pcg_shd.g_old_rec.pcg_attribute8
219: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
220: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
221: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
222: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
223: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
224: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
225: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
226: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16

Line 223: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13

219: ,p_pcg_attribute9_o =>ben_pcg_shd.g_old_rec.pcg_attribute9
220: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
221: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
222: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
223: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
224: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
225: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
226: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
227: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17

Line 224: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14

220: ,p_pcg_attribute10_o =>ben_pcg_shd.g_old_rec.pcg_attribute10
221: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
222: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
223: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
224: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
225: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
226: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
227: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
228: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18

Line 225: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15

221: ,p_pcg_attribute11_o =>ben_pcg_shd.g_old_rec.pcg_attribute11
222: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
223: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
224: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
225: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
226: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
227: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
228: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
229: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19

Line 226: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16

222: ,p_pcg_attribute12_o =>ben_pcg_shd.g_old_rec.pcg_attribute12
223: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
224: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
225: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
226: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
227: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
228: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
229: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
230: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20

Line 227: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17

223: ,p_pcg_attribute13_o =>ben_pcg_shd.g_old_rec.pcg_attribute13
224: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
225: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
226: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
227: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
228: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
229: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
230: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
231: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21

Line 228: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18

224: ,p_pcg_attribute14_o =>ben_pcg_shd.g_old_rec.pcg_attribute14
225: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
226: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
227: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
228: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
229: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
230: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
231: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
232: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22

Line 229: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19

225: ,p_pcg_attribute15_o =>ben_pcg_shd.g_old_rec.pcg_attribute15
226: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
227: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
228: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
229: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
230: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
231: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
232: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
233: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23

Line 230: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20

226: ,p_pcg_attribute16_o =>ben_pcg_shd.g_old_rec.pcg_attribute16
227: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
228: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
229: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
230: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
231: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
232: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
233: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
234: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24

Line 231: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21

227: ,p_pcg_attribute17_o =>ben_pcg_shd.g_old_rec.pcg_attribute17
228: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
229: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
230: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
231: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
232: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
233: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
234: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
235: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25

Line 232: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22

228: ,p_pcg_attribute18_o =>ben_pcg_shd.g_old_rec.pcg_attribute18
229: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
230: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
231: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
232: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
233: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
234: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
235: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
236: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26

Line 233: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23

229: ,p_pcg_attribute19_o =>ben_pcg_shd.g_old_rec.pcg_attribute19
230: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
231: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
232: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
233: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
234: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
235: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
236: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
237: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27

Line 234: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24

230: ,p_pcg_attribute20_o =>ben_pcg_shd.g_old_rec.pcg_attribute20
231: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
232: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
233: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
234: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
235: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
236: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
237: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
238: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28

Line 235: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25

231: ,p_pcg_attribute21_o =>ben_pcg_shd.g_old_rec.pcg_attribute21
232: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
233: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
234: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
235: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
236: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
237: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
238: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
239: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29

Line 236: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26

232: ,p_pcg_attribute22_o =>ben_pcg_shd.g_old_rec.pcg_attribute22
233: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
234: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
235: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
236: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
237: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
238: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
239: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
240: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30

Line 237: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27

233: ,p_pcg_attribute23_o =>ben_pcg_shd.g_old_rec.pcg_attribute23
234: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
235: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
236: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
237: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
238: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
239: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
240: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30
241: ,p_object_version_number_o =>ben_pcg_shd.g_old_rec.object_version_number

Line 238: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28

234: ,p_pcg_attribute24_o =>ben_pcg_shd.g_old_rec.pcg_attribute24
235: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
236: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
237: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
238: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
239: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
240: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30
241: ,p_object_version_number_o =>ben_pcg_shd.g_old_rec.object_version_number
242: ,p_pl_gd_or_svc_id_o =>ben_pcg_shd.g_old_rec.pl_gd_or_svc_id

Line 239: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29

235: ,p_pcg_attribute25_o =>ben_pcg_shd.g_old_rec.pcg_attribute25
236: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
237: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
238: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
239: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
240: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30
241: ,p_object_version_number_o =>ben_pcg_shd.g_old_rec.object_version_number
242: ,p_pl_gd_or_svc_id_o =>ben_pcg_shd.g_old_rec.pl_gd_or_svc_id
243: );

Line 240: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30

236: ,p_pcg_attribute26_o =>ben_pcg_shd.g_old_rec.pcg_attribute26
237: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
238: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
239: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
240: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30
241: ,p_object_version_number_o =>ben_pcg_shd.g_old_rec.object_version_number
242: ,p_pl_gd_or_svc_id_o =>ben_pcg_shd.g_old_rec.pl_gd_or_svc_id
243: );
244: --

Line 241: ,p_object_version_number_o =>ben_pcg_shd.g_old_rec.object_version_number

237: ,p_pcg_attribute27_o =>ben_pcg_shd.g_old_rec.pcg_attribute27
238: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
239: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
240: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30
241: ,p_object_version_number_o =>ben_pcg_shd.g_old_rec.object_version_number
242: ,p_pl_gd_or_svc_id_o =>ben_pcg_shd.g_old_rec.pl_gd_or_svc_id
243: );
244: --
245: exception

Line 242: ,p_pl_gd_or_svc_id_o =>ben_pcg_shd.g_old_rec.pl_gd_or_svc_id

238: ,p_pcg_attribute28_o =>ben_pcg_shd.g_old_rec.pcg_attribute28
239: ,p_pcg_attribute29_o =>ben_pcg_shd.g_old_rec.pcg_attribute29
240: ,p_pcg_attribute30_o =>ben_pcg_shd.g_old_rec.pcg_attribute30
241: ,p_object_version_number_o =>ben_pcg_shd.g_old_rec.object_version_number
242: ,p_pl_gd_or_svc_id_o =>ben_pcg_shd.g_old_rec.pl_gd_or_svc_id
243: );
244: --
245: exception
246: --

Line 266: p_rec in ben_pcg_shd.g_rec_type

262: -- |---------------------------------< del >----------------------------------|
263: -- ----------------------------------------------------------------------------
264: Procedure del
265: (
266: p_rec in ben_pcg_shd.g_rec_type
267: ) is
268: --
269: l_proc varchar2(72) := g_package||'del';
270: --

Line 276: ben_pcg_shd.lck

272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: -- We must lock the row which we need to delete.
275: --
276: ben_pcg_shd.lck
277: (
278: p_rec.prtt_clm_gd_or_svc_typ_id,
279: p_rec.object_version_number
280: );

Line 309: l_rec ben_pcg_shd.g_rec_type;

305: p_prtt_clm_gd_or_svc_typ_id in number,
306: p_object_version_number in number
307: ) is
308: --
309: l_rec ben_pcg_shd.g_rec_type;
310: l_proc varchar2(72) := g_package||'del';
311: --
312: Begin
313: hr_utility.set_location('Entering:'||l_proc, 5);