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_EPR_DEL dependencies on BEN_EPR_SHD

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

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

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

61: --
62: delete from ben_enrt_prem
63: where enrt_prem_id = p_rec.enrt_prem_id;
64: --
65: ben_epr_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_epr_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_epr_shd.g_api_dml := false; -- Unset the api dml status
73: ben_epr_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_epr_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_epr_shd.constraint_error

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

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

72: ben_epr_shd.g_api_dml := false; -- Unset the api dml status
73: ben_epr_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_epr_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_epr_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_epr_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 154: Procedure post_delete(p_rec in ben_epr_shd.g_rec_type) is

150: -- Internal table Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(p_rec in ben_epr_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin

Line 169: ,p_val_o =>ben_epr_shd.g_old_rec.val

165: --
166: ben_epr_rkd.after_delete
167: (
168: p_enrt_prem_id =>p_rec.enrt_prem_id
169: ,p_val_o =>ben_epr_shd.g_old_rec.val
170: ,p_uom_o =>ben_epr_shd.g_old_rec.uom
171: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
172: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
173: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id

Line 170: ,p_uom_o =>ben_epr_shd.g_old_rec.uom

166: ben_epr_rkd.after_delete
167: (
168: p_enrt_prem_id =>p_rec.enrt_prem_id
169: ,p_val_o =>ben_epr_shd.g_old_rec.val
170: ,p_uom_o =>ben_epr_shd.g_old_rec.uom
171: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
172: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
173: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
174: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id

Line 171: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id

167: (
168: p_enrt_prem_id =>p_rec.enrt_prem_id
169: ,p_val_o =>ben_epr_shd.g_old_rec.val
170: ,p_uom_o =>ben_epr_shd.g_old_rec.uom
171: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
172: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
173: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
174: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
175: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category

Line 172: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id

168: p_enrt_prem_id =>p_rec.enrt_prem_id
169: ,p_val_o =>ben_epr_shd.g_old_rec.val
170: ,p_uom_o =>ben_epr_shd.g_old_rec.uom
171: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
172: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
173: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
174: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
175: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
176: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1

Line 173: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id

169: ,p_val_o =>ben_epr_shd.g_old_rec.val
170: ,p_uom_o =>ben_epr_shd.g_old_rec.uom
171: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
172: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
173: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
174: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
175: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
176: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
177: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2

Line 174: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id

170: ,p_uom_o =>ben_epr_shd.g_old_rec.uom
171: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
172: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
173: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
174: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
175: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
176: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
177: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
178: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3

Line 175: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category

171: ,p_elig_per_elctbl_chc_id_o =>ben_epr_shd.g_old_rec.elig_per_elctbl_chc_id
172: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
173: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
174: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
175: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
176: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
177: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
178: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
179: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4

Line 176: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1

172: ,p_enrt_bnft_id_o =>ben_epr_shd.g_old_rec.enrt_bnft_id
173: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
174: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
175: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
176: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
177: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
178: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
179: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
180: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5

Line 177: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2

173: ,p_actl_prem_id_o =>ben_epr_shd.g_old_rec.actl_prem_id
174: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
175: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
176: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
177: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
178: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
179: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
180: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
181: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6

Line 178: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3

174: ,p_business_group_id_o =>ben_epr_shd.g_old_rec.business_group_id
175: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
176: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
177: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
178: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
179: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
180: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
181: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
182: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7

Line 179: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4

175: ,p_epr_attribute_category_o =>ben_epr_shd.g_old_rec.epr_attribute_category
176: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
177: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
178: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
179: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
180: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
181: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
182: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
183: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8

Line 180: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5

176: ,p_epr_attribute1_o =>ben_epr_shd.g_old_rec.epr_attribute1
177: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
178: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
179: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
180: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
181: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
182: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
183: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
184: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9

Line 181: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6

177: ,p_epr_attribute2_o =>ben_epr_shd.g_old_rec.epr_attribute2
178: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
179: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
180: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
181: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
182: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
183: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
184: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
185: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10

Line 182: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7

178: ,p_epr_attribute3_o =>ben_epr_shd.g_old_rec.epr_attribute3
179: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
180: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
181: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
182: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
183: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
184: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
185: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
186: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11

Line 183: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8

179: ,p_epr_attribute4_o =>ben_epr_shd.g_old_rec.epr_attribute4
180: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
181: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
182: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
183: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
184: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
185: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
186: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
187: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12

Line 184: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9

180: ,p_epr_attribute5_o =>ben_epr_shd.g_old_rec.epr_attribute5
181: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
182: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
183: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
184: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
185: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
186: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
187: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
188: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13

Line 185: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10

181: ,p_epr_attribute6_o =>ben_epr_shd.g_old_rec.epr_attribute6
182: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
183: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
184: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
185: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
186: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
187: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
188: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
189: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14

Line 186: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11

182: ,p_epr_attribute7_o =>ben_epr_shd.g_old_rec.epr_attribute7
183: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
184: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
185: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
186: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
187: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
188: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
189: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
190: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15

Line 187: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12

183: ,p_epr_attribute8_o =>ben_epr_shd.g_old_rec.epr_attribute8
184: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
185: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
186: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
187: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
188: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
189: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
190: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
191: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16

Line 188: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13

184: ,p_epr_attribute9_o =>ben_epr_shd.g_old_rec.epr_attribute9
185: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
186: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
187: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
188: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
189: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
190: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
191: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
192: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17

Line 189: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14

185: ,p_epr_attribute10_o =>ben_epr_shd.g_old_rec.epr_attribute10
186: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
187: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
188: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
189: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
190: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
191: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
192: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
193: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18

Line 190: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15

186: ,p_epr_attribute11_o =>ben_epr_shd.g_old_rec.epr_attribute11
187: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
188: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
189: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
190: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
191: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
192: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
193: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
194: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19

Line 191: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16

187: ,p_epr_attribute12_o =>ben_epr_shd.g_old_rec.epr_attribute12
188: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
189: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
190: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
191: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
192: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
193: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
194: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
195: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20

Line 192: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17

188: ,p_epr_attribute13_o =>ben_epr_shd.g_old_rec.epr_attribute13
189: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
190: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
191: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
192: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
193: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
194: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
195: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
196: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21

Line 193: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18

189: ,p_epr_attribute14_o =>ben_epr_shd.g_old_rec.epr_attribute14
190: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
191: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
192: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
193: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
194: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
195: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
196: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
197: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22

Line 194: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19

190: ,p_epr_attribute15_o =>ben_epr_shd.g_old_rec.epr_attribute15
191: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
192: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
193: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
194: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
195: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
196: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
197: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
198: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23

Line 195: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20

191: ,p_epr_attribute16_o =>ben_epr_shd.g_old_rec.epr_attribute16
192: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
193: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
194: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
195: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
196: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
197: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
198: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
199: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24

Line 196: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21

192: ,p_epr_attribute17_o =>ben_epr_shd.g_old_rec.epr_attribute17
193: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
194: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
195: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
196: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
197: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
198: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
199: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
200: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25

Line 197: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22

193: ,p_epr_attribute18_o =>ben_epr_shd.g_old_rec.epr_attribute18
194: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
195: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
196: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
197: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
198: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
199: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
200: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
201: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26

Line 198: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23

194: ,p_epr_attribute19_o =>ben_epr_shd.g_old_rec.epr_attribute19
195: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
196: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
197: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
198: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
199: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
200: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
201: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
202: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27

Line 199: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24

195: ,p_epr_attribute20_o =>ben_epr_shd.g_old_rec.epr_attribute20
196: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
197: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
198: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
199: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
200: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
201: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
202: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
203: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28

Line 200: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25

196: ,p_epr_attribute21_o =>ben_epr_shd.g_old_rec.epr_attribute21
197: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
198: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
199: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
200: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
201: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
202: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
203: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
204: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29

Line 201: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26

197: ,p_epr_attribute22_o =>ben_epr_shd.g_old_rec.epr_attribute22
198: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
199: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
200: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
201: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
202: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
203: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
204: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
205: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30

Line 202: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27

198: ,p_epr_attribute23_o =>ben_epr_shd.g_old_rec.epr_attribute23
199: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
200: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
201: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
202: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
203: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
204: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
205: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
206: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number

Line 203: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28

199: ,p_epr_attribute24_o =>ben_epr_shd.g_old_rec.epr_attribute24
200: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
201: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
202: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
203: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
204: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
205: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
206: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
207: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id

Line 204: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29

200: ,p_epr_attribute25_o =>ben_epr_shd.g_old_rec.epr_attribute25
201: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
202: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
203: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
204: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
205: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
206: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
207: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id
208: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id

Line 205: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30

201: ,p_epr_attribute26_o =>ben_epr_shd.g_old_rec.epr_attribute26
202: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
203: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
204: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
205: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
206: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
207: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id
208: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id
209: ,p_program_id_o =>ben_epr_shd.g_old_rec.program_id

Line 206: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number

202: ,p_epr_attribute27_o =>ben_epr_shd.g_old_rec.epr_attribute27
203: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
204: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
205: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
206: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
207: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id
208: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id
209: ,p_program_id_o =>ben_epr_shd.g_old_rec.program_id
210: ,p_program_update_date_o =>ben_epr_shd.g_old_rec.program_update_date

Line 207: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id

203: ,p_epr_attribute28_o =>ben_epr_shd.g_old_rec.epr_attribute28
204: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
205: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
206: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
207: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id
208: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id
209: ,p_program_id_o =>ben_epr_shd.g_old_rec.program_id
210: ,p_program_update_date_o =>ben_epr_shd.g_old_rec.program_update_date
211: );

Line 208: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id

204: ,p_epr_attribute29_o =>ben_epr_shd.g_old_rec.epr_attribute29
205: ,p_epr_attribute30_o =>ben_epr_shd.g_old_rec.epr_attribute30
206: ,p_object_version_number_o =>ben_epr_shd.g_old_rec.object_version_number
207: ,p_request_id_o =>ben_epr_shd.g_old_rec.request_id
208: ,p_program_application_id_o =>ben_epr_shd.g_old_rec.program_application_id
209: ,p_program_id_o =>ben_epr_shd.g_old_rec.program_id
210: ,p_program_update_date_o =>ben_epr_shd.g_old_rec.program_update_date
211: );
212: --

Line 209: ,p_program_id_o =>ben_epr_shd.g_old_rec.program_id

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

Line 210: ,p_program_update_date_o =>ben_epr_shd.g_old_rec.program_update_date

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

Line 234: p_rec in ben_epr_shd.g_rec_type

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

Line 244: ben_epr_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_epr_shd.lck
245: (
246: p_rec.enrt_prem_id,
247: p_rec.object_version_number
248: );

Line 276: l_rec ben_epr_shd.g_rec_type;

272: p_enrt_prem_id in number,
273: p_object_version_number in number
274: ) is
275: --
276: l_rec ben_epr_shd.g_rec_type;
277: l_proc varchar2(72) := g_package||'del';
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);