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_EAT_DEL dependencies on BEN_EAT_SHD

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

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

Line 70: ben_eat_shd.g_api_dml := false; -- Unset the api dml status

66: --
67: delete from ben_actn_typ_tl
68: where actn_typ_id = p_rec.actn_typ_id;
69: --
70: ben_eat_shd.g_api_dml := false; -- Unset the api dml status
71: --
72: hr_utility.set_location(' Leaving:'||l_proc, 10);
73: --
74: Exception

Line 77: ben_eat_shd.g_api_dml := false; -- Unset the api dml status

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

Line 78: ben_eat_shd.constraint_error

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

Line 81: ben_eat_shd.g_api_dml := false; -- Unset the api dml status

77: ben_eat_shd.g_api_dml := false; -- Unset the api dml status
78: ben_eat_shd.constraint_error
79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
80: When Others Then
81: ben_eat_shd.g_api_dml := false; -- Unset the api dml status
82: Raise;
83: End delete_dml;
84: --
85: -- ----------------------------------------------------------------------------

Line 117: Procedure pre_delete(p_rec in ben_eat_shd.g_rec_type) is

113: -- Internal Row Handler Use Only.
114: --
115: -- {End Of Comments}
116: -- ----------------------------------------------------------------------------
117: Procedure pre_delete(p_rec in ben_eat_shd.g_rec_type) is
118: --
119: l_proc varchar2(72) := g_package||'pre_delete';
120: --
121: Begin

Line 160: p_effective_date in date,p_rec in ben_eat_shd.g_rec_type) is

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

Line 175: ,p_business_group_id_o =>ben_eat_shd.g_old_rec.business_group_id

171: --
172: ben_eat_rkd.after_delete
173: (
174: p_actn_typ_id =>p_rec.actn_typ_id
175: ,p_business_group_id_o =>ben_eat_shd.g_old_rec.business_group_id
176: ,p_type_cd_o =>ben_eat_shd.g_old_rec.type_cd
177: ,p_name_o =>ben_eat_shd.g_old_rec.name
178: ,p_description_o =>ben_eat_shd.g_old_rec.description
179: ,p_eat_attribute_category_o =>ben_eat_shd.g_old_rec.eat_attribute_category

Line 176: ,p_type_cd_o =>ben_eat_shd.g_old_rec.type_cd

172: ben_eat_rkd.after_delete
173: (
174: p_actn_typ_id =>p_rec.actn_typ_id
175: ,p_business_group_id_o =>ben_eat_shd.g_old_rec.business_group_id
176: ,p_type_cd_o =>ben_eat_shd.g_old_rec.type_cd
177: ,p_name_o =>ben_eat_shd.g_old_rec.name
178: ,p_description_o =>ben_eat_shd.g_old_rec.description
179: ,p_eat_attribute_category_o =>ben_eat_shd.g_old_rec.eat_attribute_category
180: ,p_eat_attribute1_o =>ben_eat_shd.g_old_rec.eat_attribute1

Line 177: ,p_name_o =>ben_eat_shd.g_old_rec.name

173: (
174: p_actn_typ_id =>p_rec.actn_typ_id
175: ,p_business_group_id_o =>ben_eat_shd.g_old_rec.business_group_id
176: ,p_type_cd_o =>ben_eat_shd.g_old_rec.type_cd
177: ,p_name_o =>ben_eat_shd.g_old_rec.name
178: ,p_description_o =>ben_eat_shd.g_old_rec.description
179: ,p_eat_attribute_category_o =>ben_eat_shd.g_old_rec.eat_attribute_category
180: ,p_eat_attribute1_o =>ben_eat_shd.g_old_rec.eat_attribute1
181: ,p_eat_attribute2_o =>ben_eat_shd.g_old_rec.eat_attribute2

Line 178: ,p_description_o =>ben_eat_shd.g_old_rec.description

174: p_actn_typ_id =>p_rec.actn_typ_id
175: ,p_business_group_id_o =>ben_eat_shd.g_old_rec.business_group_id
176: ,p_type_cd_o =>ben_eat_shd.g_old_rec.type_cd
177: ,p_name_o =>ben_eat_shd.g_old_rec.name
178: ,p_description_o =>ben_eat_shd.g_old_rec.description
179: ,p_eat_attribute_category_o =>ben_eat_shd.g_old_rec.eat_attribute_category
180: ,p_eat_attribute1_o =>ben_eat_shd.g_old_rec.eat_attribute1
181: ,p_eat_attribute2_o =>ben_eat_shd.g_old_rec.eat_attribute2
182: ,p_eat_attribute3_o =>ben_eat_shd.g_old_rec.eat_attribute3

Line 179: ,p_eat_attribute_category_o =>ben_eat_shd.g_old_rec.eat_attribute_category

175: ,p_business_group_id_o =>ben_eat_shd.g_old_rec.business_group_id
176: ,p_type_cd_o =>ben_eat_shd.g_old_rec.type_cd
177: ,p_name_o =>ben_eat_shd.g_old_rec.name
178: ,p_description_o =>ben_eat_shd.g_old_rec.description
179: ,p_eat_attribute_category_o =>ben_eat_shd.g_old_rec.eat_attribute_category
180: ,p_eat_attribute1_o =>ben_eat_shd.g_old_rec.eat_attribute1
181: ,p_eat_attribute2_o =>ben_eat_shd.g_old_rec.eat_attribute2
182: ,p_eat_attribute3_o =>ben_eat_shd.g_old_rec.eat_attribute3
183: ,p_eat_attribute4_o =>ben_eat_shd.g_old_rec.eat_attribute4

Line 180: ,p_eat_attribute1_o =>ben_eat_shd.g_old_rec.eat_attribute1

176: ,p_type_cd_o =>ben_eat_shd.g_old_rec.type_cd
177: ,p_name_o =>ben_eat_shd.g_old_rec.name
178: ,p_description_o =>ben_eat_shd.g_old_rec.description
179: ,p_eat_attribute_category_o =>ben_eat_shd.g_old_rec.eat_attribute_category
180: ,p_eat_attribute1_o =>ben_eat_shd.g_old_rec.eat_attribute1
181: ,p_eat_attribute2_o =>ben_eat_shd.g_old_rec.eat_attribute2
182: ,p_eat_attribute3_o =>ben_eat_shd.g_old_rec.eat_attribute3
183: ,p_eat_attribute4_o =>ben_eat_shd.g_old_rec.eat_attribute4
184: ,p_eat_attribute5_o =>ben_eat_shd.g_old_rec.eat_attribute5

Line 181: ,p_eat_attribute2_o =>ben_eat_shd.g_old_rec.eat_attribute2

177: ,p_name_o =>ben_eat_shd.g_old_rec.name
178: ,p_description_o =>ben_eat_shd.g_old_rec.description
179: ,p_eat_attribute_category_o =>ben_eat_shd.g_old_rec.eat_attribute_category
180: ,p_eat_attribute1_o =>ben_eat_shd.g_old_rec.eat_attribute1
181: ,p_eat_attribute2_o =>ben_eat_shd.g_old_rec.eat_attribute2
182: ,p_eat_attribute3_o =>ben_eat_shd.g_old_rec.eat_attribute3
183: ,p_eat_attribute4_o =>ben_eat_shd.g_old_rec.eat_attribute4
184: ,p_eat_attribute5_o =>ben_eat_shd.g_old_rec.eat_attribute5
185: ,p_eat_attribute6_o =>ben_eat_shd.g_old_rec.eat_attribute6

Line 182: ,p_eat_attribute3_o =>ben_eat_shd.g_old_rec.eat_attribute3

178: ,p_description_o =>ben_eat_shd.g_old_rec.description
179: ,p_eat_attribute_category_o =>ben_eat_shd.g_old_rec.eat_attribute_category
180: ,p_eat_attribute1_o =>ben_eat_shd.g_old_rec.eat_attribute1
181: ,p_eat_attribute2_o =>ben_eat_shd.g_old_rec.eat_attribute2
182: ,p_eat_attribute3_o =>ben_eat_shd.g_old_rec.eat_attribute3
183: ,p_eat_attribute4_o =>ben_eat_shd.g_old_rec.eat_attribute4
184: ,p_eat_attribute5_o =>ben_eat_shd.g_old_rec.eat_attribute5
185: ,p_eat_attribute6_o =>ben_eat_shd.g_old_rec.eat_attribute6
186: ,p_eat_attribute7_o =>ben_eat_shd.g_old_rec.eat_attribute7

Line 183: ,p_eat_attribute4_o =>ben_eat_shd.g_old_rec.eat_attribute4

179: ,p_eat_attribute_category_o =>ben_eat_shd.g_old_rec.eat_attribute_category
180: ,p_eat_attribute1_o =>ben_eat_shd.g_old_rec.eat_attribute1
181: ,p_eat_attribute2_o =>ben_eat_shd.g_old_rec.eat_attribute2
182: ,p_eat_attribute3_o =>ben_eat_shd.g_old_rec.eat_attribute3
183: ,p_eat_attribute4_o =>ben_eat_shd.g_old_rec.eat_attribute4
184: ,p_eat_attribute5_o =>ben_eat_shd.g_old_rec.eat_attribute5
185: ,p_eat_attribute6_o =>ben_eat_shd.g_old_rec.eat_attribute6
186: ,p_eat_attribute7_o =>ben_eat_shd.g_old_rec.eat_attribute7
187: ,p_eat_attribute8_o =>ben_eat_shd.g_old_rec.eat_attribute8

Line 184: ,p_eat_attribute5_o =>ben_eat_shd.g_old_rec.eat_attribute5

180: ,p_eat_attribute1_o =>ben_eat_shd.g_old_rec.eat_attribute1
181: ,p_eat_attribute2_o =>ben_eat_shd.g_old_rec.eat_attribute2
182: ,p_eat_attribute3_o =>ben_eat_shd.g_old_rec.eat_attribute3
183: ,p_eat_attribute4_o =>ben_eat_shd.g_old_rec.eat_attribute4
184: ,p_eat_attribute5_o =>ben_eat_shd.g_old_rec.eat_attribute5
185: ,p_eat_attribute6_o =>ben_eat_shd.g_old_rec.eat_attribute6
186: ,p_eat_attribute7_o =>ben_eat_shd.g_old_rec.eat_attribute7
187: ,p_eat_attribute8_o =>ben_eat_shd.g_old_rec.eat_attribute8
188: ,p_eat_attribute9_o =>ben_eat_shd.g_old_rec.eat_attribute9

Line 185: ,p_eat_attribute6_o =>ben_eat_shd.g_old_rec.eat_attribute6

181: ,p_eat_attribute2_o =>ben_eat_shd.g_old_rec.eat_attribute2
182: ,p_eat_attribute3_o =>ben_eat_shd.g_old_rec.eat_attribute3
183: ,p_eat_attribute4_o =>ben_eat_shd.g_old_rec.eat_attribute4
184: ,p_eat_attribute5_o =>ben_eat_shd.g_old_rec.eat_attribute5
185: ,p_eat_attribute6_o =>ben_eat_shd.g_old_rec.eat_attribute6
186: ,p_eat_attribute7_o =>ben_eat_shd.g_old_rec.eat_attribute7
187: ,p_eat_attribute8_o =>ben_eat_shd.g_old_rec.eat_attribute8
188: ,p_eat_attribute9_o =>ben_eat_shd.g_old_rec.eat_attribute9
189: ,p_eat_attribute10_o =>ben_eat_shd.g_old_rec.eat_attribute10

Line 186: ,p_eat_attribute7_o =>ben_eat_shd.g_old_rec.eat_attribute7

182: ,p_eat_attribute3_o =>ben_eat_shd.g_old_rec.eat_attribute3
183: ,p_eat_attribute4_o =>ben_eat_shd.g_old_rec.eat_attribute4
184: ,p_eat_attribute5_o =>ben_eat_shd.g_old_rec.eat_attribute5
185: ,p_eat_attribute6_o =>ben_eat_shd.g_old_rec.eat_attribute6
186: ,p_eat_attribute7_o =>ben_eat_shd.g_old_rec.eat_attribute7
187: ,p_eat_attribute8_o =>ben_eat_shd.g_old_rec.eat_attribute8
188: ,p_eat_attribute9_o =>ben_eat_shd.g_old_rec.eat_attribute9
189: ,p_eat_attribute10_o =>ben_eat_shd.g_old_rec.eat_attribute10
190: ,p_eat_attribute11_o =>ben_eat_shd.g_old_rec.eat_attribute11

Line 187: ,p_eat_attribute8_o =>ben_eat_shd.g_old_rec.eat_attribute8

183: ,p_eat_attribute4_o =>ben_eat_shd.g_old_rec.eat_attribute4
184: ,p_eat_attribute5_o =>ben_eat_shd.g_old_rec.eat_attribute5
185: ,p_eat_attribute6_o =>ben_eat_shd.g_old_rec.eat_attribute6
186: ,p_eat_attribute7_o =>ben_eat_shd.g_old_rec.eat_attribute7
187: ,p_eat_attribute8_o =>ben_eat_shd.g_old_rec.eat_attribute8
188: ,p_eat_attribute9_o =>ben_eat_shd.g_old_rec.eat_attribute9
189: ,p_eat_attribute10_o =>ben_eat_shd.g_old_rec.eat_attribute10
190: ,p_eat_attribute11_o =>ben_eat_shd.g_old_rec.eat_attribute11
191: ,p_eat_attribute12_o =>ben_eat_shd.g_old_rec.eat_attribute12

Line 188: ,p_eat_attribute9_o =>ben_eat_shd.g_old_rec.eat_attribute9

184: ,p_eat_attribute5_o =>ben_eat_shd.g_old_rec.eat_attribute5
185: ,p_eat_attribute6_o =>ben_eat_shd.g_old_rec.eat_attribute6
186: ,p_eat_attribute7_o =>ben_eat_shd.g_old_rec.eat_attribute7
187: ,p_eat_attribute8_o =>ben_eat_shd.g_old_rec.eat_attribute8
188: ,p_eat_attribute9_o =>ben_eat_shd.g_old_rec.eat_attribute9
189: ,p_eat_attribute10_o =>ben_eat_shd.g_old_rec.eat_attribute10
190: ,p_eat_attribute11_o =>ben_eat_shd.g_old_rec.eat_attribute11
191: ,p_eat_attribute12_o =>ben_eat_shd.g_old_rec.eat_attribute12
192: ,p_eat_attribute13_o =>ben_eat_shd.g_old_rec.eat_attribute13

Line 189: ,p_eat_attribute10_o =>ben_eat_shd.g_old_rec.eat_attribute10

185: ,p_eat_attribute6_o =>ben_eat_shd.g_old_rec.eat_attribute6
186: ,p_eat_attribute7_o =>ben_eat_shd.g_old_rec.eat_attribute7
187: ,p_eat_attribute8_o =>ben_eat_shd.g_old_rec.eat_attribute8
188: ,p_eat_attribute9_o =>ben_eat_shd.g_old_rec.eat_attribute9
189: ,p_eat_attribute10_o =>ben_eat_shd.g_old_rec.eat_attribute10
190: ,p_eat_attribute11_o =>ben_eat_shd.g_old_rec.eat_attribute11
191: ,p_eat_attribute12_o =>ben_eat_shd.g_old_rec.eat_attribute12
192: ,p_eat_attribute13_o =>ben_eat_shd.g_old_rec.eat_attribute13
193: ,p_eat_attribute14_o =>ben_eat_shd.g_old_rec.eat_attribute14

Line 190: ,p_eat_attribute11_o =>ben_eat_shd.g_old_rec.eat_attribute11

186: ,p_eat_attribute7_o =>ben_eat_shd.g_old_rec.eat_attribute7
187: ,p_eat_attribute8_o =>ben_eat_shd.g_old_rec.eat_attribute8
188: ,p_eat_attribute9_o =>ben_eat_shd.g_old_rec.eat_attribute9
189: ,p_eat_attribute10_o =>ben_eat_shd.g_old_rec.eat_attribute10
190: ,p_eat_attribute11_o =>ben_eat_shd.g_old_rec.eat_attribute11
191: ,p_eat_attribute12_o =>ben_eat_shd.g_old_rec.eat_attribute12
192: ,p_eat_attribute13_o =>ben_eat_shd.g_old_rec.eat_attribute13
193: ,p_eat_attribute14_o =>ben_eat_shd.g_old_rec.eat_attribute14
194: ,p_eat_attribute15_o =>ben_eat_shd.g_old_rec.eat_attribute15

Line 191: ,p_eat_attribute12_o =>ben_eat_shd.g_old_rec.eat_attribute12

187: ,p_eat_attribute8_o =>ben_eat_shd.g_old_rec.eat_attribute8
188: ,p_eat_attribute9_o =>ben_eat_shd.g_old_rec.eat_attribute9
189: ,p_eat_attribute10_o =>ben_eat_shd.g_old_rec.eat_attribute10
190: ,p_eat_attribute11_o =>ben_eat_shd.g_old_rec.eat_attribute11
191: ,p_eat_attribute12_o =>ben_eat_shd.g_old_rec.eat_attribute12
192: ,p_eat_attribute13_o =>ben_eat_shd.g_old_rec.eat_attribute13
193: ,p_eat_attribute14_o =>ben_eat_shd.g_old_rec.eat_attribute14
194: ,p_eat_attribute15_o =>ben_eat_shd.g_old_rec.eat_attribute15
195: ,p_eat_attribute16_o =>ben_eat_shd.g_old_rec.eat_attribute16

Line 192: ,p_eat_attribute13_o =>ben_eat_shd.g_old_rec.eat_attribute13

188: ,p_eat_attribute9_o =>ben_eat_shd.g_old_rec.eat_attribute9
189: ,p_eat_attribute10_o =>ben_eat_shd.g_old_rec.eat_attribute10
190: ,p_eat_attribute11_o =>ben_eat_shd.g_old_rec.eat_attribute11
191: ,p_eat_attribute12_o =>ben_eat_shd.g_old_rec.eat_attribute12
192: ,p_eat_attribute13_o =>ben_eat_shd.g_old_rec.eat_attribute13
193: ,p_eat_attribute14_o =>ben_eat_shd.g_old_rec.eat_attribute14
194: ,p_eat_attribute15_o =>ben_eat_shd.g_old_rec.eat_attribute15
195: ,p_eat_attribute16_o =>ben_eat_shd.g_old_rec.eat_attribute16
196: ,p_eat_attribute17_o =>ben_eat_shd.g_old_rec.eat_attribute17

Line 193: ,p_eat_attribute14_o =>ben_eat_shd.g_old_rec.eat_attribute14

189: ,p_eat_attribute10_o =>ben_eat_shd.g_old_rec.eat_attribute10
190: ,p_eat_attribute11_o =>ben_eat_shd.g_old_rec.eat_attribute11
191: ,p_eat_attribute12_o =>ben_eat_shd.g_old_rec.eat_attribute12
192: ,p_eat_attribute13_o =>ben_eat_shd.g_old_rec.eat_attribute13
193: ,p_eat_attribute14_o =>ben_eat_shd.g_old_rec.eat_attribute14
194: ,p_eat_attribute15_o =>ben_eat_shd.g_old_rec.eat_attribute15
195: ,p_eat_attribute16_o =>ben_eat_shd.g_old_rec.eat_attribute16
196: ,p_eat_attribute17_o =>ben_eat_shd.g_old_rec.eat_attribute17
197: ,p_eat_attribute18_o =>ben_eat_shd.g_old_rec.eat_attribute18

Line 194: ,p_eat_attribute15_o =>ben_eat_shd.g_old_rec.eat_attribute15

190: ,p_eat_attribute11_o =>ben_eat_shd.g_old_rec.eat_attribute11
191: ,p_eat_attribute12_o =>ben_eat_shd.g_old_rec.eat_attribute12
192: ,p_eat_attribute13_o =>ben_eat_shd.g_old_rec.eat_attribute13
193: ,p_eat_attribute14_o =>ben_eat_shd.g_old_rec.eat_attribute14
194: ,p_eat_attribute15_o =>ben_eat_shd.g_old_rec.eat_attribute15
195: ,p_eat_attribute16_o =>ben_eat_shd.g_old_rec.eat_attribute16
196: ,p_eat_attribute17_o =>ben_eat_shd.g_old_rec.eat_attribute17
197: ,p_eat_attribute18_o =>ben_eat_shd.g_old_rec.eat_attribute18
198: ,p_eat_attribute19_o =>ben_eat_shd.g_old_rec.eat_attribute19

Line 195: ,p_eat_attribute16_o =>ben_eat_shd.g_old_rec.eat_attribute16

191: ,p_eat_attribute12_o =>ben_eat_shd.g_old_rec.eat_attribute12
192: ,p_eat_attribute13_o =>ben_eat_shd.g_old_rec.eat_attribute13
193: ,p_eat_attribute14_o =>ben_eat_shd.g_old_rec.eat_attribute14
194: ,p_eat_attribute15_o =>ben_eat_shd.g_old_rec.eat_attribute15
195: ,p_eat_attribute16_o =>ben_eat_shd.g_old_rec.eat_attribute16
196: ,p_eat_attribute17_o =>ben_eat_shd.g_old_rec.eat_attribute17
197: ,p_eat_attribute18_o =>ben_eat_shd.g_old_rec.eat_attribute18
198: ,p_eat_attribute19_o =>ben_eat_shd.g_old_rec.eat_attribute19
199: ,p_eat_attribute20_o =>ben_eat_shd.g_old_rec.eat_attribute20

Line 196: ,p_eat_attribute17_o =>ben_eat_shd.g_old_rec.eat_attribute17

192: ,p_eat_attribute13_o =>ben_eat_shd.g_old_rec.eat_attribute13
193: ,p_eat_attribute14_o =>ben_eat_shd.g_old_rec.eat_attribute14
194: ,p_eat_attribute15_o =>ben_eat_shd.g_old_rec.eat_attribute15
195: ,p_eat_attribute16_o =>ben_eat_shd.g_old_rec.eat_attribute16
196: ,p_eat_attribute17_o =>ben_eat_shd.g_old_rec.eat_attribute17
197: ,p_eat_attribute18_o =>ben_eat_shd.g_old_rec.eat_attribute18
198: ,p_eat_attribute19_o =>ben_eat_shd.g_old_rec.eat_attribute19
199: ,p_eat_attribute20_o =>ben_eat_shd.g_old_rec.eat_attribute20
200: ,p_eat_attribute21_o =>ben_eat_shd.g_old_rec.eat_attribute21

Line 197: ,p_eat_attribute18_o =>ben_eat_shd.g_old_rec.eat_attribute18

193: ,p_eat_attribute14_o =>ben_eat_shd.g_old_rec.eat_attribute14
194: ,p_eat_attribute15_o =>ben_eat_shd.g_old_rec.eat_attribute15
195: ,p_eat_attribute16_o =>ben_eat_shd.g_old_rec.eat_attribute16
196: ,p_eat_attribute17_o =>ben_eat_shd.g_old_rec.eat_attribute17
197: ,p_eat_attribute18_o =>ben_eat_shd.g_old_rec.eat_attribute18
198: ,p_eat_attribute19_o =>ben_eat_shd.g_old_rec.eat_attribute19
199: ,p_eat_attribute20_o =>ben_eat_shd.g_old_rec.eat_attribute20
200: ,p_eat_attribute21_o =>ben_eat_shd.g_old_rec.eat_attribute21
201: ,p_eat_attribute22_o =>ben_eat_shd.g_old_rec.eat_attribute22

Line 198: ,p_eat_attribute19_o =>ben_eat_shd.g_old_rec.eat_attribute19

194: ,p_eat_attribute15_o =>ben_eat_shd.g_old_rec.eat_attribute15
195: ,p_eat_attribute16_o =>ben_eat_shd.g_old_rec.eat_attribute16
196: ,p_eat_attribute17_o =>ben_eat_shd.g_old_rec.eat_attribute17
197: ,p_eat_attribute18_o =>ben_eat_shd.g_old_rec.eat_attribute18
198: ,p_eat_attribute19_o =>ben_eat_shd.g_old_rec.eat_attribute19
199: ,p_eat_attribute20_o =>ben_eat_shd.g_old_rec.eat_attribute20
200: ,p_eat_attribute21_o =>ben_eat_shd.g_old_rec.eat_attribute21
201: ,p_eat_attribute22_o =>ben_eat_shd.g_old_rec.eat_attribute22
202: ,p_eat_attribute23_o =>ben_eat_shd.g_old_rec.eat_attribute23

Line 199: ,p_eat_attribute20_o =>ben_eat_shd.g_old_rec.eat_attribute20

195: ,p_eat_attribute16_o =>ben_eat_shd.g_old_rec.eat_attribute16
196: ,p_eat_attribute17_o =>ben_eat_shd.g_old_rec.eat_attribute17
197: ,p_eat_attribute18_o =>ben_eat_shd.g_old_rec.eat_attribute18
198: ,p_eat_attribute19_o =>ben_eat_shd.g_old_rec.eat_attribute19
199: ,p_eat_attribute20_o =>ben_eat_shd.g_old_rec.eat_attribute20
200: ,p_eat_attribute21_o =>ben_eat_shd.g_old_rec.eat_attribute21
201: ,p_eat_attribute22_o =>ben_eat_shd.g_old_rec.eat_attribute22
202: ,p_eat_attribute23_o =>ben_eat_shd.g_old_rec.eat_attribute23
203: ,p_eat_attribute24_o =>ben_eat_shd.g_old_rec.eat_attribute24

Line 200: ,p_eat_attribute21_o =>ben_eat_shd.g_old_rec.eat_attribute21

196: ,p_eat_attribute17_o =>ben_eat_shd.g_old_rec.eat_attribute17
197: ,p_eat_attribute18_o =>ben_eat_shd.g_old_rec.eat_attribute18
198: ,p_eat_attribute19_o =>ben_eat_shd.g_old_rec.eat_attribute19
199: ,p_eat_attribute20_o =>ben_eat_shd.g_old_rec.eat_attribute20
200: ,p_eat_attribute21_o =>ben_eat_shd.g_old_rec.eat_attribute21
201: ,p_eat_attribute22_o =>ben_eat_shd.g_old_rec.eat_attribute22
202: ,p_eat_attribute23_o =>ben_eat_shd.g_old_rec.eat_attribute23
203: ,p_eat_attribute24_o =>ben_eat_shd.g_old_rec.eat_attribute24
204: ,p_eat_attribute25_o =>ben_eat_shd.g_old_rec.eat_attribute25

Line 201: ,p_eat_attribute22_o =>ben_eat_shd.g_old_rec.eat_attribute22

197: ,p_eat_attribute18_o =>ben_eat_shd.g_old_rec.eat_attribute18
198: ,p_eat_attribute19_o =>ben_eat_shd.g_old_rec.eat_attribute19
199: ,p_eat_attribute20_o =>ben_eat_shd.g_old_rec.eat_attribute20
200: ,p_eat_attribute21_o =>ben_eat_shd.g_old_rec.eat_attribute21
201: ,p_eat_attribute22_o =>ben_eat_shd.g_old_rec.eat_attribute22
202: ,p_eat_attribute23_o =>ben_eat_shd.g_old_rec.eat_attribute23
203: ,p_eat_attribute24_o =>ben_eat_shd.g_old_rec.eat_attribute24
204: ,p_eat_attribute25_o =>ben_eat_shd.g_old_rec.eat_attribute25
205: ,p_eat_attribute26_o =>ben_eat_shd.g_old_rec.eat_attribute26

Line 202: ,p_eat_attribute23_o =>ben_eat_shd.g_old_rec.eat_attribute23

198: ,p_eat_attribute19_o =>ben_eat_shd.g_old_rec.eat_attribute19
199: ,p_eat_attribute20_o =>ben_eat_shd.g_old_rec.eat_attribute20
200: ,p_eat_attribute21_o =>ben_eat_shd.g_old_rec.eat_attribute21
201: ,p_eat_attribute22_o =>ben_eat_shd.g_old_rec.eat_attribute22
202: ,p_eat_attribute23_o =>ben_eat_shd.g_old_rec.eat_attribute23
203: ,p_eat_attribute24_o =>ben_eat_shd.g_old_rec.eat_attribute24
204: ,p_eat_attribute25_o =>ben_eat_shd.g_old_rec.eat_attribute25
205: ,p_eat_attribute26_o =>ben_eat_shd.g_old_rec.eat_attribute26
206: ,p_eat_attribute27_o =>ben_eat_shd.g_old_rec.eat_attribute27

Line 203: ,p_eat_attribute24_o =>ben_eat_shd.g_old_rec.eat_attribute24

199: ,p_eat_attribute20_o =>ben_eat_shd.g_old_rec.eat_attribute20
200: ,p_eat_attribute21_o =>ben_eat_shd.g_old_rec.eat_attribute21
201: ,p_eat_attribute22_o =>ben_eat_shd.g_old_rec.eat_attribute22
202: ,p_eat_attribute23_o =>ben_eat_shd.g_old_rec.eat_attribute23
203: ,p_eat_attribute24_o =>ben_eat_shd.g_old_rec.eat_attribute24
204: ,p_eat_attribute25_o =>ben_eat_shd.g_old_rec.eat_attribute25
205: ,p_eat_attribute26_o =>ben_eat_shd.g_old_rec.eat_attribute26
206: ,p_eat_attribute27_o =>ben_eat_shd.g_old_rec.eat_attribute27
207: ,p_eat_attribute28_o =>ben_eat_shd.g_old_rec.eat_attribute28

Line 204: ,p_eat_attribute25_o =>ben_eat_shd.g_old_rec.eat_attribute25

200: ,p_eat_attribute21_o =>ben_eat_shd.g_old_rec.eat_attribute21
201: ,p_eat_attribute22_o =>ben_eat_shd.g_old_rec.eat_attribute22
202: ,p_eat_attribute23_o =>ben_eat_shd.g_old_rec.eat_attribute23
203: ,p_eat_attribute24_o =>ben_eat_shd.g_old_rec.eat_attribute24
204: ,p_eat_attribute25_o =>ben_eat_shd.g_old_rec.eat_attribute25
205: ,p_eat_attribute26_o =>ben_eat_shd.g_old_rec.eat_attribute26
206: ,p_eat_attribute27_o =>ben_eat_shd.g_old_rec.eat_attribute27
207: ,p_eat_attribute28_o =>ben_eat_shd.g_old_rec.eat_attribute28
208: ,p_eat_attribute29_o =>ben_eat_shd.g_old_rec.eat_attribute29

Line 205: ,p_eat_attribute26_o =>ben_eat_shd.g_old_rec.eat_attribute26

201: ,p_eat_attribute22_o =>ben_eat_shd.g_old_rec.eat_attribute22
202: ,p_eat_attribute23_o =>ben_eat_shd.g_old_rec.eat_attribute23
203: ,p_eat_attribute24_o =>ben_eat_shd.g_old_rec.eat_attribute24
204: ,p_eat_attribute25_o =>ben_eat_shd.g_old_rec.eat_attribute25
205: ,p_eat_attribute26_o =>ben_eat_shd.g_old_rec.eat_attribute26
206: ,p_eat_attribute27_o =>ben_eat_shd.g_old_rec.eat_attribute27
207: ,p_eat_attribute28_o =>ben_eat_shd.g_old_rec.eat_attribute28
208: ,p_eat_attribute29_o =>ben_eat_shd.g_old_rec.eat_attribute29
209: ,p_eat_attribute30_o =>ben_eat_shd.g_old_rec.eat_attribute30

Line 206: ,p_eat_attribute27_o =>ben_eat_shd.g_old_rec.eat_attribute27

202: ,p_eat_attribute23_o =>ben_eat_shd.g_old_rec.eat_attribute23
203: ,p_eat_attribute24_o =>ben_eat_shd.g_old_rec.eat_attribute24
204: ,p_eat_attribute25_o =>ben_eat_shd.g_old_rec.eat_attribute25
205: ,p_eat_attribute26_o =>ben_eat_shd.g_old_rec.eat_attribute26
206: ,p_eat_attribute27_o =>ben_eat_shd.g_old_rec.eat_attribute27
207: ,p_eat_attribute28_o =>ben_eat_shd.g_old_rec.eat_attribute28
208: ,p_eat_attribute29_o =>ben_eat_shd.g_old_rec.eat_attribute29
209: ,p_eat_attribute30_o =>ben_eat_shd.g_old_rec.eat_attribute30
210: ,p_object_version_number_o =>ben_eat_shd.g_old_rec.object_version_number

Line 207: ,p_eat_attribute28_o =>ben_eat_shd.g_old_rec.eat_attribute28

203: ,p_eat_attribute24_o =>ben_eat_shd.g_old_rec.eat_attribute24
204: ,p_eat_attribute25_o =>ben_eat_shd.g_old_rec.eat_attribute25
205: ,p_eat_attribute26_o =>ben_eat_shd.g_old_rec.eat_attribute26
206: ,p_eat_attribute27_o =>ben_eat_shd.g_old_rec.eat_attribute27
207: ,p_eat_attribute28_o =>ben_eat_shd.g_old_rec.eat_attribute28
208: ,p_eat_attribute29_o =>ben_eat_shd.g_old_rec.eat_attribute29
209: ,p_eat_attribute30_o =>ben_eat_shd.g_old_rec.eat_attribute30
210: ,p_object_version_number_o =>ben_eat_shd.g_old_rec.object_version_number
211: );

Line 208: ,p_eat_attribute29_o =>ben_eat_shd.g_old_rec.eat_attribute29

204: ,p_eat_attribute25_o =>ben_eat_shd.g_old_rec.eat_attribute25
205: ,p_eat_attribute26_o =>ben_eat_shd.g_old_rec.eat_attribute26
206: ,p_eat_attribute27_o =>ben_eat_shd.g_old_rec.eat_attribute27
207: ,p_eat_attribute28_o =>ben_eat_shd.g_old_rec.eat_attribute28
208: ,p_eat_attribute29_o =>ben_eat_shd.g_old_rec.eat_attribute29
209: ,p_eat_attribute30_o =>ben_eat_shd.g_old_rec.eat_attribute30
210: ,p_object_version_number_o =>ben_eat_shd.g_old_rec.object_version_number
211: );
212: --

Line 209: ,p_eat_attribute30_o =>ben_eat_shd.g_old_rec.eat_attribute30

205: ,p_eat_attribute26_o =>ben_eat_shd.g_old_rec.eat_attribute26
206: ,p_eat_attribute27_o =>ben_eat_shd.g_old_rec.eat_attribute27
207: ,p_eat_attribute28_o =>ben_eat_shd.g_old_rec.eat_attribute28
208: ,p_eat_attribute29_o =>ben_eat_shd.g_old_rec.eat_attribute29
209: ,p_eat_attribute30_o =>ben_eat_shd.g_old_rec.eat_attribute30
210: ,p_object_version_number_o =>ben_eat_shd.g_old_rec.object_version_number
211: );
212: --
213: exception

Line 210: ,p_object_version_number_o =>ben_eat_shd.g_old_rec.object_version_number

206: ,p_eat_attribute27_o =>ben_eat_shd.g_old_rec.eat_attribute27
207: ,p_eat_attribute28_o =>ben_eat_shd.g_old_rec.eat_attribute28
208: ,p_eat_attribute29_o =>ben_eat_shd.g_old_rec.eat_attribute29
209: ,p_eat_attribute30_o =>ben_eat_shd.g_old_rec.eat_attribute30
210: ,p_object_version_number_o =>ben_eat_shd.g_old_rec.object_version_number
211: );
212: --
213: exception
214: --

Line 235: p_rec in ben_eat_shd.g_rec_type

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

Line 245: ben_eat_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_eat_shd.lck
246: (
247: p_rec.actn_typ_id,
248: p_rec.object_version_number
249: );

Line 280: l_rec ben_eat_shd.g_rec_type;

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