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_ERC_DEL dependencies on BEN_ERC_SHD

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

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

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

61: --
62: delete from ben_enrt_rt_ctfn
63: where enrt_rt_ctfn_id = p_rec.enrt_rt_ctfn_id;
64: --
65: ben_erc_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_erc_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_erc_shd.g_api_dml := false; -- Unset the api dml status
73: ben_erc_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_erc_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_erc_shd.constraint_error

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

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

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

Line 170: ,p_enrt_ctfn_typ_cd_o =>ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd

166: --
167: ben_erc_rkd.after_delete
168: (
169: p_enrt_rt_ctfn_id =>p_rec.enrt_rt_ctfn_id
170: ,p_enrt_ctfn_typ_cd_o =>ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag
172: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
173: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
174: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category

Line 171: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag

167: ben_erc_rkd.after_delete
168: (
169: p_enrt_rt_ctfn_id =>p_rec.enrt_rt_ctfn_id
170: ,p_enrt_ctfn_typ_cd_o =>ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag
172: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
173: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
174: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
175: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1

Line 172: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id

168: (
169: p_enrt_rt_ctfn_id =>p_rec.enrt_rt_ctfn_id
170: ,p_enrt_ctfn_typ_cd_o =>ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag
172: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
173: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
174: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
175: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
176: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2

Line 173: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id

169: p_enrt_rt_ctfn_id =>p_rec.enrt_rt_ctfn_id
170: ,p_enrt_ctfn_typ_cd_o =>ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag
172: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
173: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
174: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
175: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
176: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
177: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3

Line 174: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category

170: ,p_enrt_ctfn_typ_cd_o =>ben_erc_shd.g_old_rec.enrt_ctfn_typ_cd
171: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag
172: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
173: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
174: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
175: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
176: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
177: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
178: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4

Line 175: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1

171: ,p_rqd_flag_o =>ben_erc_shd.g_old_rec.rqd_flag
172: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
173: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
174: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
175: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
176: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
177: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
178: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
179: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5

Line 176: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2

172: ,p_enrt_rt_id_o =>ben_erc_shd.g_old_rec.enrt_rt_id
173: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
174: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
175: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
176: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
177: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
178: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
179: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
180: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6

Line 177: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3

173: ,p_business_group_id_o =>ben_erc_shd.g_old_rec.business_group_id
174: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
175: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
176: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
177: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
178: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
179: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
180: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
181: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7

Line 178: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4

174: ,p_erc_attribute_category_o =>ben_erc_shd.g_old_rec.erc_attribute_category
175: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
176: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
177: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
178: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
179: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
180: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
181: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
182: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8

Line 179: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5

175: ,p_erc_attribute1_o =>ben_erc_shd.g_old_rec.erc_attribute1
176: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
177: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
178: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
179: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
180: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
181: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
182: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
183: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9

Line 180: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6

176: ,p_erc_attribute2_o =>ben_erc_shd.g_old_rec.erc_attribute2
177: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
178: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
179: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
180: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
181: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
182: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
183: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
184: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10

Line 181: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7

177: ,p_erc_attribute3_o =>ben_erc_shd.g_old_rec.erc_attribute3
178: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
179: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
180: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
181: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
182: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
183: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
184: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
185: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11

Line 182: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8

178: ,p_erc_attribute4_o =>ben_erc_shd.g_old_rec.erc_attribute4
179: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
180: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
181: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
182: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
183: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
184: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
185: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
186: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12

Line 183: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9

179: ,p_erc_attribute5_o =>ben_erc_shd.g_old_rec.erc_attribute5
180: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
181: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
182: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
183: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
184: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
185: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
186: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
187: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13

Line 184: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10

180: ,p_erc_attribute6_o =>ben_erc_shd.g_old_rec.erc_attribute6
181: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
182: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
183: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
184: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
185: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
186: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
187: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
188: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14

Line 185: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11

181: ,p_erc_attribute7_o =>ben_erc_shd.g_old_rec.erc_attribute7
182: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
183: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
184: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
185: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
186: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
187: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
188: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
189: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15

Line 186: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12

182: ,p_erc_attribute8_o =>ben_erc_shd.g_old_rec.erc_attribute8
183: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
184: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
185: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
186: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
187: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
188: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
189: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
190: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16

Line 187: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13

183: ,p_erc_attribute9_o =>ben_erc_shd.g_old_rec.erc_attribute9
184: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
185: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
186: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
187: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
188: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
189: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
190: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
191: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17

Line 188: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14

184: ,p_erc_attribute10_o =>ben_erc_shd.g_old_rec.erc_attribute10
185: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
186: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
187: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
188: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
189: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
190: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
191: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
192: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18

Line 189: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15

185: ,p_erc_attribute11_o =>ben_erc_shd.g_old_rec.erc_attribute11
186: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
187: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
188: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
189: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
190: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
191: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
192: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
193: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19

Line 190: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16

186: ,p_erc_attribute12_o =>ben_erc_shd.g_old_rec.erc_attribute12
187: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
188: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
189: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
190: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
191: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
192: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
193: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
194: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20

Line 191: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17

187: ,p_erc_attribute13_o =>ben_erc_shd.g_old_rec.erc_attribute13
188: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
189: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
190: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
191: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
192: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
193: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
194: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
195: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21

Line 192: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18

188: ,p_erc_attribute14_o =>ben_erc_shd.g_old_rec.erc_attribute14
189: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
190: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
191: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
192: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
193: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
194: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
195: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
196: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22

Line 193: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19

189: ,p_erc_attribute15_o =>ben_erc_shd.g_old_rec.erc_attribute15
190: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
191: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
192: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
193: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
194: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
195: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
196: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
197: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23

Line 194: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20

190: ,p_erc_attribute16_o =>ben_erc_shd.g_old_rec.erc_attribute16
191: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
192: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
193: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
194: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
195: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
196: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
197: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
198: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24

Line 195: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21

191: ,p_erc_attribute17_o =>ben_erc_shd.g_old_rec.erc_attribute17
192: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
193: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
194: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
195: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
196: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
197: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
198: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
199: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25

Line 196: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22

192: ,p_erc_attribute18_o =>ben_erc_shd.g_old_rec.erc_attribute18
193: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
194: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
195: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
196: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
197: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
198: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
199: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
200: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26

Line 197: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23

193: ,p_erc_attribute19_o =>ben_erc_shd.g_old_rec.erc_attribute19
194: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
195: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
196: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
197: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
198: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
199: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
200: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
201: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27

Line 198: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24

194: ,p_erc_attribute20_o =>ben_erc_shd.g_old_rec.erc_attribute20
195: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
196: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
197: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
198: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
199: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
200: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
201: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
202: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28

Line 199: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25

195: ,p_erc_attribute21_o =>ben_erc_shd.g_old_rec.erc_attribute21
196: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
197: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
198: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
199: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
200: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
201: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
202: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
203: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29

Line 200: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26

196: ,p_erc_attribute22_o =>ben_erc_shd.g_old_rec.erc_attribute22
197: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
198: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
199: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
200: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
201: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
202: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
203: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
204: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30

Line 201: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27

197: ,p_erc_attribute23_o =>ben_erc_shd.g_old_rec.erc_attribute23
198: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
199: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
200: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
201: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
202: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
203: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
204: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
205: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id

Line 202: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28

198: ,p_erc_attribute24_o =>ben_erc_shd.g_old_rec.erc_attribute24
199: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
200: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
201: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
202: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
203: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
204: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
205: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
206: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id

Line 203: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29

199: ,p_erc_attribute25_o =>ben_erc_shd.g_old_rec.erc_attribute25
200: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
201: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
202: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
203: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
204: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
205: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
206: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
207: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id

Line 204: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30

200: ,p_erc_attribute26_o =>ben_erc_shd.g_old_rec.erc_attribute26
201: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
202: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
203: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
204: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
205: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
206: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
207: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id
208: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date

Line 205: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id

201: ,p_erc_attribute27_o =>ben_erc_shd.g_old_rec.erc_attribute27
202: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
203: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
204: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
205: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
206: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
207: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id
208: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date
209: ,p_object_version_number_o =>ben_erc_shd.g_old_rec.object_version_number

Line 206: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id

202: ,p_erc_attribute28_o =>ben_erc_shd.g_old_rec.erc_attribute28
203: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
204: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
205: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
206: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
207: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id
208: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date
209: ,p_object_version_number_o =>ben_erc_shd.g_old_rec.object_version_number
210: );

Line 207: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id

203: ,p_erc_attribute29_o =>ben_erc_shd.g_old_rec.erc_attribute29
204: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
205: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
206: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
207: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id
208: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date
209: ,p_object_version_number_o =>ben_erc_shd.g_old_rec.object_version_number
210: );
211: --

Line 208: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date

204: ,p_erc_attribute30_o =>ben_erc_shd.g_old_rec.erc_attribute30
205: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
206: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
207: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id
208: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date
209: ,p_object_version_number_o =>ben_erc_shd.g_old_rec.object_version_number
210: );
211: --
212: exception

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

205: ,p_request_id_o =>ben_erc_shd.g_old_rec.request_id
206: ,p_program_application_id_o =>ben_erc_shd.g_old_rec.program_application_id
207: ,p_program_id_o =>ben_erc_shd.g_old_rec.program_id
208: ,p_program_update_date_o =>ben_erc_shd.g_old_rec.program_update_date
209: ,p_object_version_number_o =>ben_erc_shd.g_old_rec.object_version_number
210: );
211: --
212: exception
213: --

Line 234: p_rec in ben_erc_shd.g_rec_type

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

Line 244: ben_erc_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_erc_shd.lck
245: (
246: p_rec.enrt_rt_ctfn_id,
247: p_rec.object_version_number
248: );

Line 279: l_rec ben_erc_shd.g_rec_type;

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