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_CLA_DEL dependencies on BEN_CLA_SHD

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

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

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

61: --
62: delete from ben_cmbn_age_los_fctr
63: where cmbn_age_los_fctr_id = p_rec.cmbn_age_los_fctr_id;
64: --
65: ben_cla_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_cla_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_cla_shd.g_api_dml := false; -- Unset the api dml status
73: ben_cla_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_cla_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ben_cla_shd.constraint_error

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

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

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

Line 169: ,p_business_group_id_o =>ben_cla_shd.g_old_rec.business_group_id

165: --
166: ben_cla_rkd.after_delete
167: (
168: p_cmbn_age_los_fctr_id =>p_rec.cmbn_age_los_fctr_id
169: ,p_business_group_id_o =>ben_cla_shd.g_old_rec.business_group_id
170: ,p_los_fctr_id_o =>ben_cla_shd.g_old_rec.los_fctr_id
171: ,p_age_fctr_id_o =>ben_cla_shd.g_old_rec.age_fctr_id
172: ,p_cmbnd_min_val_o =>ben_cla_shd.g_old_rec.cmbnd_min_val
173: ,p_cmbnd_max_val_o =>ben_cla_shd.g_old_rec.cmbnd_max_val

Line 170: ,p_los_fctr_id_o =>ben_cla_shd.g_old_rec.los_fctr_id

166: ben_cla_rkd.after_delete
167: (
168: p_cmbn_age_los_fctr_id =>p_rec.cmbn_age_los_fctr_id
169: ,p_business_group_id_o =>ben_cla_shd.g_old_rec.business_group_id
170: ,p_los_fctr_id_o =>ben_cla_shd.g_old_rec.los_fctr_id
171: ,p_age_fctr_id_o =>ben_cla_shd.g_old_rec.age_fctr_id
172: ,p_cmbnd_min_val_o =>ben_cla_shd.g_old_rec.cmbnd_min_val
173: ,p_cmbnd_max_val_o =>ben_cla_shd.g_old_rec.cmbnd_max_val
174: ,p_ordr_num_o =>ben_cla_shd.g_old_rec.ordr_num

Line 171: ,p_age_fctr_id_o =>ben_cla_shd.g_old_rec.age_fctr_id

167: (
168: p_cmbn_age_los_fctr_id =>p_rec.cmbn_age_los_fctr_id
169: ,p_business_group_id_o =>ben_cla_shd.g_old_rec.business_group_id
170: ,p_los_fctr_id_o =>ben_cla_shd.g_old_rec.los_fctr_id
171: ,p_age_fctr_id_o =>ben_cla_shd.g_old_rec.age_fctr_id
172: ,p_cmbnd_min_val_o =>ben_cla_shd.g_old_rec.cmbnd_min_val
173: ,p_cmbnd_max_val_o =>ben_cla_shd.g_old_rec.cmbnd_max_val
174: ,p_ordr_num_o =>ben_cla_shd.g_old_rec.ordr_num
175: ,p_cla_attribute_category_o =>ben_cla_shd.g_old_rec.cla_attribute_category

Line 172: ,p_cmbnd_min_val_o =>ben_cla_shd.g_old_rec.cmbnd_min_val

168: p_cmbn_age_los_fctr_id =>p_rec.cmbn_age_los_fctr_id
169: ,p_business_group_id_o =>ben_cla_shd.g_old_rec.business_group_id
170: ,p_los_fctr_id_o =>ben_cla_shd.g_old_rec.los_fctr_id
171: ,p_age_fctr_id_o =>ben_cla_shd.g_old_rec.age_fctr_id
172: ,p_cmbnd_min_val_o =>ben_cla_shd.g_old_rec.cmbnd_min_val
173: ,p_cmbnd_max_val_o =>ben_cla_shd.g_old_rec.cmbnd_max_val
174: ,p_ordr_num_o =>ben_cla_shd.g_old_rec.ordr_num
175: ,p_cla_attribute_category_o =>ben_cla_shd.g_old_rec.cla_attribute_category
176: ,p_cla_attribute1_o =>ben_cla_shd.g_old_rec.cla_attribute1

Line 173: ,p_cmbnd_max_val_o =>ben_cla_shd.g_old_rec.cmbnd_max_val

169: ,p_business_group_id_o =>ben_cla_shd.g_old_rec.business_group_id
170: ,p_los_fctr_id_o =>ben_cla_shd.g_old_rec.los_fctr_id
171: ,p_age_fctr_id_o =>ben_cla_shd.g_old_rec.age_fctr_id
172: ,p_cmbnd_min_val_o =>ben_cla_shd.g_old_rec.cmbnd_min_val
173: ,p_cmbnd_max_val_o =>ben_cla_shd.g_old_rec.cmbnd_max_val
174: ,p_ordr_num_o =>ben_cla_shd.g_old_rec.ordr_num
175: ,p_cla_attribute_category_o =>ben_cla_shd.g_old_rec.cla_attribute_category
176: ,p_cla_attribute1_o =>ben_cla_shd.g_old_rec.cla_attribute1
177: ,p_cla_attribute2_o =>ben_cla_shd.g_old_rec.cla_attribute2

Line 174: ,p_ordr_num_o =>ben_cla_shd.g_old_rec.ordr_num

170: ,p_los_fctr_id_o =>ben_cla_shd.g_old_rec.los_fctr_id
171: ,p_age_fctr_id_o =>ben_cla_shd.g_old_rec.age_fctr_id
172: ,p_cmbnd_min_val_o =>ben_cla_shd.g_old_rec.cmbnd_min_val
173: ,p_cmbnd_max_val_o =>ben_cla_shd.g_old_rec.cmbnd_max_val
174: ,p_ordr_num_o =>ben_cla_shd.g_old_rec.ordr_num
175: ,p_cla_attribute_category_o =>ben_cla_shd.g_old_rec.cla_attribute_category
176: ,p_cla_attribute1_o =>ben_cla_shd.g_old_rec.cla_attribute1
177: ,p_cla_attribute2_o =>ben_cla_shd.g_old_rec.cla_attribute2
178: ,p_cla_attribute3_o =>ben_cla_shd.g_old_rec.cla_attribute3

Line 175: ,p_cla_attribute_category_o =>ben_cla_shd.g_old_rec.cla_attribute_category

171: ,p_age_fctr_id_o =>ben_cla_shd.g_old_rec.age_fctr_id
172: ,p_cmbnd_min_val_o =>ben_cla_shd.g_old_rec.cmbnd_min_val
173: ,p_cmbnd_max_val_o =>ben_cla_shd.g_old_rec.cmbnd_max_val
174: ,p_ordr_num_o =>ben_cla_shd.g_old_rec.ordr_num
175: ,p_cla_attribute_category_o =>ben_cla_shd.g_old_rec.cla_attribute_category
176: ,p_cla_attribute1_o =>ben_cla_shd.g_old_rec.cla_attribute1
177: ,p_cla_attribute2_o =>ben_cla_shd.g_old_rec.cla_attribute2
178: ,p_cla_attribute3_o =>ben_cla_shd.g_old_rec.cla_attribute3
179: ,p_cla_attribute4_o =>ben_cla_shd.g_old_rec.cla_attribute4

Line 176: ,p_cla_attribute1_o =>ben_cla_shd.g_old_rec.cla_attribute1

172: ,p_cmbnd_min_val_o =>ben_cla_shd.g_old_rec.cmbnd_min_val
173: ,p_cmbnd_max_val_o =>ben_cla_shd.g_old_rec.cmbnd_max_val
174: ,p_ordr_num_o =>ben_cla_shd.g_old_rec.ordr_num
175: ,p_cla_attribute_category_o =>ben_cla_shd.g_old_rec.cla_attribute_category
176: ,p_cla_attribute1_o =>ben_cla_shd.g_old_rec.cla_attribute1
177: ,p_cla_attribute2_o =>ben_cla_shd.g_old_rec.cla_attribute2
178: ,p_cla_attribute3_o =>ben_cla_shd.g_old_rec.cla_attribute3
179: ,p_cla_attribute4_o =>ben_cla_shd.g_old_rec.cla_attribute4
180: ,p_cla_attribute5_o =>ben_cla_shd.g_old_rec.cla_attribute5

Line 177: ,p_cla_attribute2_o =>ben_cla_shd.g_old_rec.cla_attribute2

173: ,p_cmbnd_max_val_o =>ben_cla_shd.g_old_rec.cmbnd_max_val
174: ,p_ordr_num_o =>ben_cla_shd.g_old_rec.ordr_num
175: ,p_cla_attribute_category_o =>ben_cla_shd.g_old_rec.cla_attribute_category
176: ,p_cla_attribute1_o =>ben_cla_shd.g_old_rec.cla_attribute1
177: ,p_cla_attribute2_o =>ben_cla_shd.g_old_rec.cla_attribute2
178: ,p_cla_attribute3_o =>ben_cla_shd.g_old_rec.cla_attribute3
179: ,p_cla_attribute4_o =>ben_cla_shd.g_old_rec.cla_attribute4
180: ,p_cla_attribute5_o =>ben_cla_shd.g_old_rec.cla_attribute5
181: ,p_cla_attribute6_o =>ben_cla_shd.g_old_rec.cla_attribute6

Line 178: ,p_cla_attribute3_o =>ben_cla_shd.g_old_rec.cla_attribute3

174: ,p_ordr_num_o =>ben_cla_shd.g_old_rec.ordr_num
175: ,p_cla_attribute_category_o =>ben_cla_shd.g_old_rec.cla_attribute_category
176: ,p_cla_attribute1_o =>ben_cla_shd.g_old_rec.cla_attribute1
177: ,p_cla_attribute2_o =>ben_cla_shd.g_old_rec.cla_attribute2
178: ,p_cla_attribute3_o =>ben_cla_shd.g_old_rec.cla_attribute3
179: ,p_cla_attribute4_o =>ben_cla_shd.g_old_rec.cla_attribute4
180: ,p_cla_attribute5_o =>ben_cla_shd.g_old_rec.cla_attribute5
181: ,p_cla_attribute6_o =>ben_cla_shd.g_old_rec.cla_attribute6
182: ,p_cla_attribute7_o =>ben_cla_shd.g_old_rec.cla_attribute7

Line 179: ,p_cla_attribute4_o =>ben_cla_shd.g_old_rec.cla_attribute4

175: ,p_cla_attribute_category_o =>ben_cla_shd.g_old_rec.cla_attribute_category
176: ,p_cla_attribute1_o =>ben_cla_shd.g_old_rec.cla_attribute1
177: ,p_cla_attribute2_o =>ben_cla_shd.g_old_rec.cla_attribute2
178: ,p_cla_attribute3_o =>ben_cla_shd.g_old_rec.cla_attribute3
179: ,p_cla_attribute4_o =>ben_cla_shd.g_old_rec.cla_attribute4
180: ,p_cla_attribute5_o =>ben_cla_shd.g_old_rec.cla_attribute5
181: ,p_cla_attribute6_o =>ben_cla_shd.g_old_rec.cla_attribute6
182: ,p_cla_attribute7_o =>ben_cla_shd.g_old_rec.cla_attribute7
183: ,p_cla_attribute8_o =>ben_cla_shd.g_old_rec.cla_attribute8

Line 180: ,p_cla_attribute5_o =>ben_cla_shd.g_old_rec.cla_attribute5

176: ,p_cla_attribute1_o =>ben_cla_shd.g_old_rec.cla_attribute1
177: ,p_cla_attribute2_o =>ben_cla_shd.g_old_rec.cla_attribute2
178: ,p_cla_attribute3_o =>ben_cla_shd.g_old_rec.cla_attribute3
179: ,p_cla_attribute4_o =>ben_cla_shd.g_old_rec.cla_attribute4
180: ,p_cla_attribute5_o =>ben_cla_shd.g_old_rec.cla_attribute5
181: ,p_cla_attribute6_o =>ben_cla_shd.g_old_rec.cla_attribute6
182: ,p_cla_attribute7_o =>ben_cla_shd.g_old_rec.cla_attribute7
183: ,p_cla_attribute8_o =>ben_cla_shd.g_old_rec.cla_attribute8
184: ,p_cla_attribute9_o =>ben_cla_shd.g_old_rec.cla_attribute9

Line 181: ,p_cla_attribute6_o =>ben_cla_shd.g_old_rec.cla_attribute6

177: ,p_cla_attribute2_o =>ben_cla_shd.g_old_rec.cla_attribute2
178: ,p_cla_attribute3_o =>ben_cla_shd.g_old_rec.cla_attribute3
179: ,p_cla_attribute4_o =>ben_cla_shd.g_old_rec.cla_attribute4
180: ,p_cla_attribute5_o =>ben_cla_shd.g_old_rec.cla_attribute5
181: ,p_cla_attribute6_o =>ben_cla_shd.g_old_rec.cla_attribute6
182: ,p_cla_attribute7_o =>ben_cla_shd.g_old_rec.cla_attribute7
183: ,p_cla_attribute8_o =>ben_cla_shd.g_old_rec.cla_attribute8
184: ,p_cla_attribute9_o =>ben_cla_shd.g_old_rec.cla_attribute9
185: ,p_cla_attribute10_o =>ben_cla_shd.g_old_rec.cla_attribute10

Line 182: ,p_cla_attribute7_o =>ben_cla_shd.g_old_rec.cla_attribute7

178: ,p_cla_attribute3_o =>ben_cla_shd.g_old_rec.cla_attribute3
179: ,p_cla_attribute4_o =>ben_cla_shd.g_old_rec.cla_attribute4
180: ,p_cla_attribute5_o =>ben_cla_shd.g_old_rec.cla_attribute5
181: ,p_cla_attribute6_o =>ben_cla_shd.g_old_rec.cla_attribute6
182: ,p_cla_attribute7_o =>ben_cla_shd.g_old_rec.cla_attribute7
183: ,p_cla_attribute8_o =>ben_cla_shd.g_old_rec.cla_attribute8
184: ,p_cla_attribute9_o =>ben_cla_shd.g_old_rec.cla_attribute9
185: ,p_cla_attribute10_o =>ben_cla_shd.g_old_rec.cla_attribute10
186: ,p_cla_attribute11_o =>ben_cla_shd.g_old_rec.cla_attribute11

Line 183: ,p_cla_attribute8_o =>ben_cla_shd.g_old_rec.cla_attribute8

179: ,p_cla_attribute4_o =>ben_cla_shd.g_old_rec.cla_attribute4
180: ,p_cla_attribute5_o =>ben_cla_shd.g_old_rec.cla_attribute5
181: ,p_cla_attribute6_o =>ben_cla_shd.g_old_rec.cla_attribute6
182: ,p_cla_attribute7_o =>ben_cla_shd.g_old_rec.cla_attribute7
183: ,p_cla_attribute8_o =>ben_cla_shd.g_old_rec.cla_attribute8
184: ,p_cla_attribute9_o =>ben_cla_shd.g_old_rec.cla_attribute9
185: ,p_cla_attribute10_o =>ben_cla_shd.g_old_rec.cla_attribute10
186: ,p_cla_attribute11_o =>ben_cla_shd.g_old_rec.cla_attribute11
187: ,p_cla_attribute12_o =>ben_cla_shd.g_old_rec.cla_attribute12

Line 184: ,p_cla_attribute9_o =>ben_cla_shd.g_old_rec.cla_attribute9

180: ,p_cla_attribute5_o =>ben_cla_shd.g_old_rec.cla_attribute5
181: ,p_cla_attribute6_o =>ben_cla_shd.g_old_rec.cla_attribute6
182: ,p_cla_attribute7_o =>ben_cla_shd.g_old_rec.cla_attribute7
183: ,p_cla_attribute8_o =>ben_cla_shd.g_old_rec.cla_attribute8
184: ,p_cla_attribute9_o =>ben_cla_shd.g_old_rec.cla_attribute9
185: ,p_cla_attribute10_o =>ben_cla_shd.g_old_rec.cla_attribute10
186: ,p_cla_attribute11_o =>ben_cla_shd.g_old_rec.cla_attribute11
187: ,p_cla_attribute12_o =>ben_cla_shd.g_old_rec.cla_attribute12
188: ,p_cla_attribute13_o =>ben_cla_shd.g_old_rec.cla_attribute13

Line 185: ,p_cla_attribute10_o =>ben_cla_shd.g_old_rec.cla_attribute10

181: ,p_cla_attribute6_o =>ben_cla_shd.g_old_rec.cla_attribute6
182: ,p_cla_attribute7_o =>ben_cla_shd.g_old_rec.cla_attribute7
183: ,p_cla_attribute8_o =>ben_cla_shd.g_old_rec.cla_attribute8
184: ,p_cla_attribute9_o =>ben_cla_shd.g_old_rec.cla_attribute9
185: ,p_cla_attribute10_o =>ben_cla_shd.g_old_rec.cla_attribute10
186: ,p_cla_attribute11_o =>ben_cla_shd.g_old_rec.cla_attribute11
187: ,p_cla_attribute12_o =>ben_cla_shd.g_old_rec.cla_attribute12
188: ,p_cla_attribute13_o =>ben_cla_shd.g_old_rec.cla_attribute13
189: ,p_cla_attribute14_o =>ben_cla_shd.g_old_rec.cla_attribute14

Line 186: ,p_cla_attribute11_o =>ben_cla_shd.g_old_rec.cla_attribute11

182: ,p_cla_attribute7_o =>ben_cla_shd.g_old_rec.cla_attribute7
183: ,p_cla_attribute8_o =>ben_cla_shd.g_old_rec.cla_attribute8
184: ,p_cla_attribute9_o =>ben_cla_shd.g_old_rec.cla_attribute9
185: ,p_cla_attribute10_o =>ben_cla_shd.g_old_rec.cla_attribute10
186: ,p_cla_attribute11_o =>ben_cla_shd.g_old_rec.cla_attribute11
187: ,p_cla_attribute12_o =>ben_cla_shd.g_old_rec.cla_attribute12
188: ,p_cla_attribute13_o =>ben_cla_shd.g_old_rec.cla_attribute13
189: ,p_cla_attribute14_o =>ben_cla_shd.g_old_rec.cla_attribute14
190: ,p_cla_attribute15_o =>ben_cla_shd.g_old_rec.cla_attribute15

Line 187: ,p_cla_attribute12_o =>ben_cla_shd.g_old_rec.cla_attribute12

183: ,p_cla_attribute8_o =>ben_cla_shd.g_old_rec.cla_attribute8
184: ,p_cla_attribute9_o =>ben_cla_shd.g_old_rec.cla_attribute9
185: ,p_cla_attribute10_o =>ben_cla_shd.g_old_rec.cla_attribute10
186: ,p_cla_attribute11_o =>ben_cla_shd.g_old_rec.cla_attribute11
187: ,p_cla_attribute12_o =>ben_cla_shd.g_old_rec.cla_attribute12
188: ,p_cla_attribute13_o =>ben_cla_shd.g_old_rec.cla_attribute13
189: ,p_cla_attribute14_o =>ben_cla_shd.g_old_rec.cla_attribute14
190: ,p_cla_attribute15_o =>ben_cla_shd.g_old_rec.cla_attribute15
191: ,p_cla_attribute16_o =>ben_cla_shd.g_old_rec.cla_attribute16

Line 188: ,p_cla_attribute13_o =>ben_cla_shd.g_old_rec.cla_attribute13

184: ,p_cla_attribute9_o =>ben_cla_shd.g_old_rec.cla_attribute9
185: ,p_cla_attribute10_o =>ben_cla_shd.g_old_rec.cla_attribute10
186: ,p_cla_attribute11_o =>ben_cla_shd.g_old_rec.cla_attribute11
187: ,p_cla_attribute12_o =>ben_cla_shd.g_old_rec.cla_attribute12
188: ,p_cla_attribute13_o =>ben_cla_shd.g_old_rec.cla_attribute13
189: ,p_cla_attribute14_o =>ben_cla_shd.g_old_rec.cla_attribute14
190: ,p_cla_attribute15_o =>ben_cla_shd.g_old_rec.cla_attribute15
191: ,p_cla_attribute16_o =>ben_cla_shd.g_old_rec.cla_attribute16
192: ,p_cla_attribute17_o =>ben_cla_shd.g_old_rec.cla_attribute17

Line 189: ,p_cla_attribute14_o =>ben_cla_shd.g_old_rec.cla_attribute14

185: ,p_cla_attribute10_o =>ben_cla_shd.g_old_rec.cla_attribute10
186: ,p_cla_attribute11_o =>ben_cla_shd.g_old_rec.cla_attribute11
187: ,p_cla_attribute12_o =>ben_cla_shd.g_old_rec.cla_attribute12
188: ,p_cla_attribute13_o =>ben_cla_shd.g_old_rec.cla_attribute13
189: ,p_cla_attribute14_o =>ben_cla_shd.g_old_rec.cla_attribute14
190: ,p_cla_attribute15_o =>ben_cla_shd.g_old_rec.cla_attribute15
191: ,p_cla_attribute16_o =>ben_cla_shd.g_old_rec.cla_attribute16
192: ,p_cla_attribute17_o =>ben_cla_shd.g_old_rec.cla_attribute17
193: ,p_cla_attribute18_o =>ben_cla_shd.g_old_rec.cla_attribute18

Line 190: ,p_cla_attribute15_o =>ben_cla_shd.g_old_rec.cla_attribute15

186: ,p_cla_attribute11_o =>ben_cla_shd.g_old_rec.cla_attribute11
187: ,p_cla_attribute12_o =>ben_cla_shd.g_old_rec.cla_attribute12
188: ,p_cla_attribute13_o =>ben_cla_shd.g_old_rec.cla_attribute13
189: ,p_cla_attribute14_o =>ben_cla_shd.g_old_rec.cla_attribute14
190: ,p_cla_attribute15_o =>ben_cla_shd.g_old_rec.cla_attribute15
191: ,p_cla_attribute16_o =>ben_cla_shd.g_old_rec.cla_attribute16
192: ,p_cla_attribute17_o =>ben_cla_shd.g_old_rec.cla_attribute17
193: ,p_cla_attribute18_o =>ben_cla_shd.g_old_rec.cla_attribute18
194: ,p_cla_attribute19_o =>ben_cla_shd.g_old_rec.cla_attribute19

Line 191: ,p_cla_attribute16_o =>ben_cla_shd.g_old_rec.cla_attribute16

187: ,p_cla_attribute12_o =>ben_cla_shd.g_old_rec.cla_attribute12
188: ,p_cla_attribute13_o =>ben_cla_shd.g_old_rec.cla_attribute13
189: ,p_cla_attribute14_o =>ben_cla_shd.g_old_rec.cla_attribute14
190: ,p_cla_attribute15_o =>ben_cla_shd.g_old_rec.cla_attribute15
191: ,p_cla_attribute16_o =>ben_cla_shd.g_old_rec.cla_attribute16
192: ,p_cla_attribute17_o =>ben_cla_shd.g_old_rec.cla_attribute17
193: ,p_cla_attribute18_o =>ben_cla_shd.g_old_rec.cla_attribute18
194: ,p_cla_attribute19_o =>ben_cla_shd.g_old_rec.cla_attribute19
195: ,p_cla_attribute20_o =>ben_cla_shd.g_old_rec.cla_attribute20

Line 192: ,p_cla_attribute17_o =>ben_cla_shd.g_old_rec.cla_attribute17

188: ,p_cla_attribute13_o =>ben_cla_shd.g_old_rec.cla_attribute13
189: ,p_cla_attribute14_o =>ben_cla_shd.g_old_rec.cla_attribute14
190: ,p_cla_attribute15_o =>ben_cla_shd.g_old_rec.cla_attribute15
191: ,p_cla_attribute16_o =>ben_cla_shd.g_old_rec.cla_attribute16
192: ,p_cla_attribute17_o =>ben_cla_shd.g_old_rec.cla_attribute17
193: ,p_cla_attribute18_o =>ben_cla_shd.g_old_rec.cla_attribute18
194: ,p_cla_attribute19_o =>ben_cla_shd.g_old_rec.cla_attribute19
195: ,p_cla_attribute20_o =>ben_cla_shd.g_old_rec.cla_attribute20
196: ,p_cla_attribute21_o =>ben_cla_shd.g_old_rec.cla_attribute21

Line 193: ,p_cla_attribute18_o =>ben_cla_shd.g_old_rec.cla_attribute18

189: ,p_cla_attribute14_o =>ben_cla_shd.g_old_rec.cla_attribute14
190: ,p_cla_attribute15_o =>ben_cla_shd.g_old_rec.cla_attribute15
191: ,p_cla_attribute16_o =>ben_cla_shd.g_old_rec.cla_attribute16
192: ,p_cla_attribute17_o =>ben_cla_shd.g_old_rec.cla_attribute17
193: ,p_cla_attribute18_o =>ben_cla_shd.g_old_rec.cla_attribute18
194: ,p_cla_attribute19_o =>ben_cla_shd.g_old_rec.cla_attribute19
195: ,p_cla_attribute20_o =>ben_cla_shd.g_old_rec.cla_attribute20
196: ,p_cla_attribute21_o =>ben_cla_shd.g_old_rec.cla_attribute21
197: ,p_cla_attribute22_o =>ben_cla_shd.g_old_rec.cla_attribute22

Line 194: ,p_cla_attribute19_o =>ben_cla_shd.g_old_rec.cla_attribute19

190: ,p_cla_attribute15_o =>ben_cla_shd.g_old_rec.cla_attribute15
191: ,p_cla_attribute16_o =>ben_cla_shd.g_old_rec.cla_attribute16
192: ,p_cla_attribute17_o =>ben_cla_shd.g_old_rec.cla_attribute17
193: ,p_cla_attribute18_o =>ben_cla_shd.g_old_rec.cla_attribute18
194: ,p_cla_attribute19_o =>ben_cla_shd.g_old_rec.cla_attribute19
195: ,p_cla_attribute20_o =>ben_cla_shd.g_old_rec.cla_attribute20
196: ,p_cla_attribute21_o =>ben_cla_shd.g_old_rec.cla_attribute21
197: ,p_cla_attribute22_o =>ben_cla_shd.g_old_rec.cla_attribute22
198: ,p_cla_attribute23_o =>ben_cla_shd.g_old_rec.cla_attribute23

Line 195: ,p_cla_attribute20_o =>ben_cla_shd.g_old_rec.cla_attribute20

191: ,p_cla_attribute16_o =>ben_cla_shd.g_old_rec.cla_attribute16
192: ,p_cla_attribute17_o =>ben_cla_shd.g_old_rec.cla_attribute17
193: ,p_cla_attribute18_o =>ben_cla_shd.g_old_rec.cla_attribute18
194: ,p_cla_attribute19_o =>ben_cla_shd.g_old_rec.cla_attribute19
195: ,p_cla_attribute20_o =>ben_cla_shd.g_old_rec.cla_attribute20
196: ,p_cla_attribute21_o =>ben_cla_shd.g_old_rec.cla_attribute21
197: ,p_cla_attribute22_o =>ben_cla_shd.g_old_rec.cla_attribute22
198: ,p_cla_attribute23_o =>ben_cla_shd.g_old_rec.cla_attribute23
199: ,p_cla_attribute24_o =>ben_cla_shd.g_old_rec.cla_attribute24

Line 196: ,p_cla_attribute21_o =>ben_cla_shd.g_old_rec.cla_attribute21

192: ,p_cla_attribute17_o =>ben_cla_shd.g_old_rec.cla_attribute17
193: ,p_cla_attribute18_o =>ben_cla_shd.g_old_rec.cla_attribute18
194: ,p_cla_attribute19_o =>ben_cla_shd.g_old_rec.cla_attribute19
195: ,p_cla_attribute20_o =>ben_cla_shd.g_old_rec.cla_attribute20
196: ,p_cla_attribute21_o =>ben_cla_shd.g_old_rec.cla_attribute21
197: ,p_cla_attribute22_o =>ben_cla_shd.g_old_rec.cla_attribute22
198: ,p_cla_attribute23_o =>ben_cla_shd.g_old_rec.cla_attribute23
199: ,p_cla_attribute24_o =>ben_cla_shd.g_old_rec.cla_attribute24
200: ,p_cla_attribute25_o =>ben_cla_shd.g_old_rec.cla_attribute25

Line 197: ,p_cla_attribute22_o =>ben_cla_shd.g_old_rec.cla_attribute22

193: ,p_cla_attribute18_o =>ben_cla_shd.g_old_rec.cla_attribute18
194: ,p_cla_attribute19_o =>ben_cla_shd.g_old_rec.cla_attribute19
195: ,p_cla_attribute20_o =>ben_cla_shd.g_old_rec.cla_attribute20
196: ,p_cla_attribute21_o =>ben_cla_shd.g_old_rec.cla_attribute21
197: ,p_cla_attribute22_o =>ben_cla_shd.g_old_rec.cla_attribute22
198: ,p_cla_attribute23_o =>ben_cla_shd.g_old_rec.cla_attribute23
199: ,p_cla_attribute24_o =>ben_cla_shd.g_old_rec.cla_attribute24
200: ,p_cla_attribute25_o =>ben_cla_shd.g_old_rec.cla_attribute25
201: ,p_cla_attribute26_o =>ben_cla_shd.g_old_rec.cla_attribute26

Line 198: ,p_cla_attribute23_o =>ben_cla_shd.g_old_rec.cla_attribute23

194: ,p_cla_attribute19_o =>ben_cla_shd.g_old_rec.cla_attribute19
195: ,p_cla_attribute20_o =>ben_cla_shd.g_old_rec.cla_attribute20
196: ,p_cla_attribute21_o =>ben_cla_shd.g_old_rec.cla_attribute21
197: ,p_cla_attribute22_o =>ben_cla_shd.g_old_rec.cla_attribute22
198: ,p_cla_attribute23_o =>ben_cla_shd.g_old_rec.cla_attribute23
199: ,p_cla_attribute24_o =>ben_cla_shd.g_old_rec.cla_attribute24
200: ,p_cla_attribute25_o =>ben_cla_shd.g_old_rec.cla_attribute25
201: ,p_cla_attribute26_o =>ben_cla_shd.g_old_rec.cla_attribute26
202: ,p_cla_attribute27_o =>ben_cla_shd.g_old_rec.cla_attribute27

Line 199: ,p_cla_attribute24_o =>ben_cla_shd.g_old_rec.cla_attribute24

195: ,p_cla_attribute20_o =>ben_cla_shd.g_old_rec.cla_attribute20
196: ,p_cla_attribute21_o =>ben_cla_shd.g_old_rec.cla_attribute21
197: ,p_cla_attribute22_o =>ben_cla_shd.g_old_rec.cla_attribute22
198: ,p_cla_attribute23_o =>ben_cla_shd.g_old_rec.cla_attribute23
199: ,p_cla_attribute24_o =>ben_cla_shd.g_old_rec.cla_attribute24
200: ,p_cla_attribute25_o =>ben_cla_shd.g_old_rec.cla_attribute25
201: ,p_cla_attribute26_o =>ben_cla_shd.g_old_rec.cla_attribute26
202: ,p_cla_attribute27_o =>ben_cla_shd.g_old_rec.cla_attribute27
203: ,p_cla_attribute28_o =>ben_cla_shd.g_old_rec.cla_attribute28

Line 200: ,p_cla_attribute25_o =>ben_cla_shd.g_old_rec.cla_attribute25

196: ,p_cla_attribute21_o =>ben_cla_shd.g_old_rec.cla_attribute21
197: ,p_cla_attribute22_o =>ben_cla_shd.g_old_rec.cla_attribute22
198: ,p_cla_attribute23_o =>ben_cla_shd.g_old_rec.cla_attribute23
199: ,p_cla_attribute24_o =>ben_cla_shd.g_old_rec.cla_attribute24
200: ,p_cla_attribute25_o =>ben_cla_shd.g_old_rec.cla_attribute25
201: ,p_cla_attribute26_o =>ben_cla_shd.g_old_rec.cla_attribute26
202: ,p_cla_attribute27_o =>ben_cla_shd.g_old_rec.cla_attribute27
203: ,p_cla_attribute28_o =>ben_cla_shd.g_old_rec.cla_attribute28
204: ,p_cla_attribute29_o =>ben_cla_shd.g_old_rec.cla_attribute29

Line 201: ,p_cla_attribute26_o =>ben_cla_shd.g_old_rec.cla_attribute26

197: ,p_cla_attribute22_o =>ben_cla_shd.g_old_rec.cla_attribute22
198: ,p_cla_attribute23_o =>ben_cla_shd.g_old_rec.cla_attribute23
199: ,p_cla_attribute24_o =>ben_cla_shd.g_old_rec.cla_attribute24
200: ,p_cla_attribute25_o =>ben_cla_shd.g_old_rec.cla_attribute25
201: ,p_cla_attribute26_o =>ben_cla_shd.g_old_rec.cla_attribute26
202: ,p_cla_attribute27_o =>ben_cla_shd.g_old_rec.cla_attribute27
203: ,p_cla_attribute28_o =>ben_cla_shd.g_old_rec.cla_attribute28
204: ,p_cla_attribute29_o =>ben_cla_shd.g_old_rec.cla_attribute29
205: ,p_cla_attribute30_o =>ben_cla_shd.g_old_rec.cla_attribute30

Line 202: ,p_cla_attribute27_o =>ben_cla_shd.g_old_rec.cla_attribute27

198: ,p_cla_attribute23_o =>ben_cla_shd.g_old_rec.cla_attribute23
199: ,p_cla_attribute24_o =>ben_cla_shd.g_old_rec.cla_attribute24
200: ,p_cla_attribute25_o =>ben_cla_shd.g_old_rec.cla_attribute25
201: ,p_cla_attribute26_o =>ben_cla_shd.g_old_rec.cla_attribute26
202: ,p_cla_attribute27_o =>ben_cla_shd.g_old_rec.cla_attribute27
203: ,p_cla_attribute28_o =>ben_cla_shd.g_old_rec.cla_attribute28
204: ,p_cla_attribute29_o =>ben_cla_shd.g_old_rec.cla_attribute29
205: ,p_cla_attribute30_o =>ben_cla_shd.g_old_rec.cla_attribute30
206: ,p_object_version_number_o =>ben_cla_shd.g_old_rec.object_version_number

Line 203: ,p_cla_attribute28_o =>ben_cla_shd.g_old_rec.cla_attribute28

199: ,p_cla_attribute24_o =>ben_cla_shd.g_old_rec.cla_attribute24
200: ,p_cla_attribute25_o =>ben_cla_shd.g_old_rec.cla_attribute25
201: ,p_cla_attribute26_o =>ben_cla_shd.g_old_rec.cla_attribute26
202: ,p_cla_attribute27_o =>ben_cla_shd.g_old_rec.cla_attribute27
203: ,p_cla_attribute28_o =>ben_cla_shd.g_old_rec.cla_attribute28
204: ,p_cla_attribute29_o =>ben_cla_shd.g_old_rec.cla_attribute29
205: ,p_cla_attribute30_o =>ben_cla_shd.g_old_rec.cla_attribute30
206: ,p_object_version_number_o =>ben_cla_shd.g_old_rec.object_version_number
207: ,p_name_o =>ben_cla_shd.g_old_rec.name

Line 204: ,p_cla_attribute29_o =>ben_cla_shd.g_old_rec.cla_attribute29

200: ,p_cla_attribute25_o =>ben_cla_shd.g_old_rec.cla_attribute25
201: ,p_cla_attribute26_o =>ben_cla_shd.g_old_rec.cla_attribute26
202: ,p_cla_attribute27_o =>ben_cla_shd.g_old_rec.cla_attribute27
203: ,p_cla_attribute28_o =>ben_cla_shd.g_old_rec.cla_attribute28
204: ,p_cla_attribute29_o =>ben_cla_shd.g_old_rec.cla_attribute29
205: ,p_cla_attribute30_o =>ben_cla_shd.g_old_rec.cla_attribute30
206: ,p_object_version_number_o =>ben_cla_shd.g_old_rec.object_version_number
207: ,p_name_o =>ben_cla_shd.g_old_rec.name
208: );

Line 205: ,p_cla_attribute30_o =>ben_cla_shd.g_old_rec.cla_attribute30

201: ,p_cla_attribute26_o =>ben_cla_shd.g_old_rec.cla_attribute26
202: ,p_cla_attribute27_o =>ben_cla_shd.g_old_rec.cla_attribute27
203: ,p_cla_attribute28_o =>ben_cla_shd.g_old_rec.cla_attribute28
204: ,p_cla_attribute29_o =>ben_cla_shd.g_old_rec.cla_attribute29
205: ,p_cla_attribute30_o =>ben_cla_shd.g_old_rec.cla_attribute30
206: ,p_object_version_number_o =>ben_cla_shd.g_old_rec.object_version_number
207: ,p_name_o =>ben_cla_shd.g_old_rec.name
208: );
209: --

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

202: ,p_cla_attribute27_o =>ben_cla_shd.g_old_rec.cla_attribute27
203: ,p_cla_attribute28_o =>ben_cla_shd.g_old_rec.cla_attribute28
204: ,p_cla_attribute29_o =>ben_cla_shd.g_old_rec.cla_attribute29
205: ,p_cla_attribute30_o =>ben_cla_shd.g_old_rec.cla_attribute30
206: ,p_object_version_number_o =>ben_cla_shd.g_old_rec.object_version_number
207: ,p_name_o =>ben_cla_shd.g_old_rec.name
208: );
209: --
210: exception

Line 207: ,p_name_o =>ben_cla_shd.g_old_rec.name

203: ,p_cla_attribute28_o =>ben_cla_shd.g_old_rec.cla_attribute28
204: ,p_cla_attribute29_o =>ben_cla_shd.g_old_rec.cla_attribute29
205: ,p_cla_attribute30_o =>ben_cla_shd.g_old_rec.cla_attribute30
206: ,p_object_version_number_o =>ben_cla_shd.g_old_rec.object_version_number
207: ,p_name_o =>ben_cla_shd.g_old_rec.name
208: );
209: --
210: exception
211: --

Line 231: p_rec in ben_cla_shd.g_rec_type

227: -- |---------------------------------< del >----------------------------------|
228: -- ----------------------------------------------------------------------------
229: Procedure del
230: (
231: p_rec in ben_cla_shd.g_rec_type
232: ) is
233: --
234: l_proc varchar2(72) := g_package||'del';
235: --

Line 241: ben_cla_shd.lck

237: hr_utility.set_location('Entering:'||l_proc, 5);
238: --
239: -- We must lock the row which we need to delete.
240: --
241: ben_cla_shd.lck
242: (
243: p_rec.cmbn_age_los_fctr_id,
244: p_rec.object_version_number
245: );

Line 273: l_rec ben_cla_shd.g_rec_type;

269: p_cmbn_age_los_fctr_id in number,
270: p_object_version_number in number
271: ) is
272: --
273: l_rec ben_cla_shd.g_rec_type;
274: l_proc varchar2(72) := g_package||'del';
275: --
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);