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_BNR_DEL dependencies on BEN_BNR_SHD

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

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

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

63: where rptg_grp_id = p_rec.rptg_grp_id;
64: --
65: delete from ben_rptg_grp_tl
66: where rptg_grp_id = p_rec.rptg_grp_id;
67: ben_bnr_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_bnr_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_bnr_shd.g_api_dml := false; -- Unset the api dml status
75: ben_bnr_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status

Line 75: ben_bnr_shd.constraint_error

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

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

74: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status
75: ben_bnr_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: ben_bnr_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_bnr_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_bnr_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 157: p_effective_date in date,p_rec in ben_bnr_shd.g_rec_type) is

153: --
154: -- {End Of Comments}
155: -- ----------------------------------------------------------------------------
156: Procedure post_delete(
157: p_effective_date in date,p_rec in ben_bnr_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'post_delete';
160: --
161: Begin

Line 172: ,p_name_o =>ben_bnr_shd.g_old_rec.name

168: --
169: ben_bnr_rkd.after_delete
170: (
171: p_rptg_grp_id =>p_rec.rptg_grp_id
172: ,p_name_o =>ben_bnr_shd.g_old_rec.name
173: ,p_business_group_id_o =>ben_bnr_shd.g_old_rec.business_group_id
174: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
175: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
176: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category

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

169: ben_bnr_rkd.after_delete
170: (
171: p_rptg_grp_id =>p_rec.rptg_grp_id
172: ,p_name_o =>ben_bnr_shd.g_old_rec.name
173: ,p_business_group_id_o =>ben_bnr_shd.g_old_rec.business_group_id
174: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
175: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
176: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
177: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1

Line 174: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd

170: (
171: p_rptg_grp_id =>p_rec.rptg_grp_id
172: ,p_name_o =>ben_bnr_shd.g_old_rec.name
173: ,p_business_group_id_o =>ben_bnr_shd.g_old_rec.business_group_id
174: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
175: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
176: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
177: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
178: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2

Line 175: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc

171: p_rptg_grp_id =>p_rec.rptg_grp_id
172: ,p_name_o =>ben_bnr_shd.g_old_rec.name
173: ,p_business_group_id_o =>ben_bnr_shd.g_old_rec.business_group_id
174: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
175: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
176: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
177: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
178: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
179: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3

Line 176: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category

172: ,p_name_o =>ben_bnr_shd.g_old_rec.name
173: ,p_business_group_id_o =>ben_bnr_shd.g_old_rec.business_group_id
174: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
175: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
176: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
177: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
178: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
179: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
180: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4

Line 177: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1

173: ,p_business_group_id_o =>ben_bnr_shd.g_old_rec.business_group_id
174: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
175: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
176: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
177: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
178: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
179: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
180: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
181: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5

Line 178: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2

174: ,p_rptg_prps_cd_o =>ben_bnr_shd.g_old_rec.rptg_prps_cd
175: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
176: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
177: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
178: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
179: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
180: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
181: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
182: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6

Line 179: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3

175: ,p_rpg_desc_o =>ben_bnr_shd.g_old_rec.rpg_desc
176: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
177: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
178: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
179: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
180: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
181: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
182: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
183: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7

Line 180: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4

176: ,p_bnr_attribute_category_o =>ben_bnr_shd.g_old_rec.bnr_attribute_category
177: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
178: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
179: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
180: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
181: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
182: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
183: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
184: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8

Line 181: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5

177: ,p_bnr_attribute1_o =>ben_bnr_shd.g_old_rec.bnr_attribute1
178: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
179: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
180: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
181: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
182: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
183: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
184: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
185: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9

Line 182: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6

178: ,p_bnr_attribute2_o =>ben_bnr_shd.g_old_rec.bnr_attribute2
179: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
180: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
181: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
182: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
183: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
184: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
185: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
186: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10

Line 183: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7

179: ,p_bnr_attribute3_o =>ben_bnr_shd.g_old_rec.bnr_attribute3
180: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
181: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
182: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
183: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
184: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
185: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
186: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
187: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11

Line 184: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8

180: ,p_bnr_attribute4_o =>ben_bnr_shd.g_old_rec.bnr_attribute4
181: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
182: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
183: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
184: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
185: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
186: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
187: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
188: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12

Line 185: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9

181: ,p_bnr_attribute5_o =>ben_bnr_shd.g_old_rec.bnr_attribute5
182: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
183: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
184: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
185: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
186: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
187: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
188: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
189: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13

Line 186: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10

182: ,p_bnr_attribute6_o =>ben_bnr_shd.g_old_rec.bnr_attribute6
183: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
184: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
185: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
186: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
187: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
188: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
189: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
190: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14

Line 187: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11

183: ,p_bnr_attribute7_o =>ben_bnr_shd.g_old_rec.bnr_attribute7
184: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
185: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
186: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
187: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
188: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
189: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
190: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
191: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15

Line 188: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12

184: ,p_bnr_attribute8_o =>ben_bnr_shd.g_old_rec.bnr_attribute8
185: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
186: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
187: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
188: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
189: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
190: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
191: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
192: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16

Line 189: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13

185: ,p_bnr_attribute9_o =>ben_bnr_shd.g_old_rec.bnr_attribute9
186: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
187: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
188: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
189: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
190: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
191: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
192: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
193: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17

Line 190: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14

186: ,p_bnr_attribute10_o =>ben_bnr_shd.g_old_rec.bnr_attribute10
187: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
188: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
189: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
190: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
191: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
192: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
193: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
194: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18

Line 191: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15

187: ,p_bnr_attribute11_o =>ben_bnr_shd.g_old_rec.bnr_attribute11
188: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
189: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
190: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
191: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
192: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
193: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
194: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
195: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19

Line 192: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16

188: ,p_bnr_attribute12_o =>ben_bnr_shd.g_old_rec.bnr_attribute12
189: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
190: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
191: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
192: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
193: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
194: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
195: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
196: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20

Line 193: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17

189: ,p_bnr_attribute13_o =>ben_bnr_shd.g_old_rec.bnr_attribute13
190: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
191: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
192: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
193: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
194: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
195: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
196: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
197: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21

Line 194: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18

190: ,p_bnr_attribute14_o =>ben_bnr_shd.g_old_rec.bnr_attribute14
191: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
192: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
193: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
194: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
195: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
196: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
197: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
198: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22

Line 195: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19

191: ,p_bnr_attribute15_o =>ben_bnr_shd.g_old_rec.bnr_attribute15
192: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
193: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
194: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
195: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
196: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
197: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
198: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
199: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23

Line 196: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20

192: ,p_bnr_attribute16_o =>ben_bnr_shd.g_old_rec.bnr_attribute16
193: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
194: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
195: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
196: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
197: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
198: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
199: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
200: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24

Line 197: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21

193: ,p_bnr_attribute17_o =>ben_bnr_shd.g_old_rec.bnr_attribute17
194: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
195: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
196: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
197: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
198: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
199: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
200: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
201: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25

Line 198: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22

194: ,p_bnr_attribute18_o =>ben_bnr_shd.g_old_rec.bnr_attribute18
195: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
196: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
197: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
198: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
199: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
200: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
201: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
202: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26

Line 199: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23

195: ,p_bnr_attribute19_o =>ben_bnr_shd.g_old_rec.bnr_attribute19
196: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
197: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
198: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
199: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
200: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
201: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
202: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
203: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27

Line 200: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24

196: ,p_bnr_attribute20_o =>ben_bnr_shd.g_old_rec.bnr_attribute20
197: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
198: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
199: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
200: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
201: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
202: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
203: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
204: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28

Line 201: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25

197: ,p_bnr_attribute21_o =>ben_bnr_shd.g_old_rec.bnr_attribute21
198: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
199: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
200: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
201: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
202: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
203: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
204: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
205: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29

Line 202: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26

198: ,p_bnr_attribute22_o =>ben_bnr_shd.g_old_rec.bnr_attribute22
199: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
200: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
201: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
202: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
203: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
204: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
205: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
206: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30

Line 203: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27

199: ,p_bnr_attribute23_o =>ben_bnr_shd.g_old_rec.bnr_attribute23
200: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
201: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
202: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
203: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
204: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
205: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
206: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
207: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code

Line 204: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28

200: ,p_bnr_attribute24_o =>ben_bnr_shd.g_old_rec.bnr_attribute24
201: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
202: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
203: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
204: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
205: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
206: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
207: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
208: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code

Line 205: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29

201: ,p_bnr_attribute25_o =>ben_bnr_shd.g_old_rec.bnr_attribute25
202: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
203: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
204: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
205: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
206: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
207: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
208: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code
209: ,p_object_version_number_o =>ben_bnr_shd.g_old_rec.object_version_number

Line 206: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30

202: ,p_bnr_attribute26_o =>ben_bnr_shd.g_old_rec.bnr_attribute26
203: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
204: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
205: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
206: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
207: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
208: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code
209: ,p_object_version_number_o =>ben_bnr_shd.g_old_rec.object_version_number
210: ,p_ordr_num_o =>ben_bnr_shd.g_old_rec.ordr_num --iRec

Line 207: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code

203: ,p_bnr_attribute27_o =>ben_bnr_shd.g_old_rec.bnr_attribute27
204: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
205: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
206: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
207: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
208: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code
209: ,p_object_version_number_o =>ben_bnr_shd.g_old_rec.object_version_number
210: ,p_ordr_num_o =>ben_bnr_shd.g_old_rec.ordr_num --iRec
211: );

Line 208: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code

204: ,p_bnr_attribute28_o =>ben_bnr_shd.g_old_rec.bnr_attribute28
205: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
206: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
207: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
208: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code
209: ,p_object_version_number_o =>ben_bnr_shd.g_old_rec.object_version_number
210: ,p_ordr_num_o =>ben_bnr_shd.g_old_rec.ordr_num --iRec
211: );
212: --

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

205: ,p_bnr_attribute29_o =>ben_bnr_shd.g_old_rec.bnr_attribute29
206: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
207: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
208: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code
209: ,p_object_version_number_o =>ben_bnr_shd.g_old_rec.object_version_number
210: ,p_ordr_num_o =>ben_bnr_shd.g_old_rec.ordr_num --iRec
211: );
212: --
213: exception

Line 210: ,p_ordr_num_o =>ben_bnr_shd.g_old_rec.ordr_num --iRec

206: ,p_bnr_attribute30_o =>ben_bnr_shd.g_old_rec.bnr_attribute30
207: ,p_function_code_o =>ben_bnr_shd.g_old_rec.function_code
208: ,p_legislation_code_o =>ben_bnr_shd.g_old_rec.legislation_code
209: ,p_object_version_number_o =>ben_bnr_shd.g_old_rec.object_version_number
210: ,p_ordr_num_o =>ben_bnr_shd.g_old_rec.ordr_num --iRec
211: );
212: --
213: exception
214: --

Line 235: p_rec in ben_bnr_shd.g_rec_type

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

Line 245: ben_bnr_shd.lck

241: hr_utility.set_location('Entering:'||l_proc, 5);
242: --
243: -- We must lock the row which we need to delete.
244: --
245: ben_bnr_shd.lck
246: (
247: p_rec.rptg_grp_id,
248: p_rec.object_version_number
249: );

Line 280: l_rec ben_bnr_shd.g_rec_type;

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