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.PER_GRS_DEL dependencies on PER_GRS_SHD

Line 51: Procedure delete_dml(p_rec in per_grs_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in per_grs_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: per_grs_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: per_grs_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the per_cagr_grade_structures row.
61: --
62: delete from per_cagr_grade_structures

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

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

Line 73: per_grs_shd.constraint_error

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

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

72: per_grs_shd.g_api_dml := false; -- Unset the api dml status
73: per_grs_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_grs_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 113: p_rec in per_grs_shd.g_rec_type) is

109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_effective_date in date,
113: p_rec in per_grs_shd.g_rec_type) is
114: --
115: l_proc varchar2(72) := g_package||'pre_delete';
116: --
117: Begin

Line 156: p_rec in per_grs_shd.g_rec_type) is

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

Line 171: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id

167: --
168: per_grs_rkd.after_delete
169: (
170: p_cagr_grade_structure_id =>p_rec.cagr_grade_structure_id
171: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
172: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
173: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
174: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
175: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category

Line 172: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number

168: per_grs_rkd.after_delete
169: (
170: p_cagr_grade_structure_id =>p_rec.cagr_grade_structure_id
171: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
172: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
173: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
174: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
175: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
176: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1

Line 173: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num

169: (
170: p_cagr_grade_structure_id =>p_rec.cagr_grade_structure_id
171: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
172: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
173: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
174: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
175: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
176: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
177: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2

Line 174: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed

170: p_cagr_grade_structure_id =>p_rec.cagr_grade_structure_id
171: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
172: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
173: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
174: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
175: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
176: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
177: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
178: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3

Line 175: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category

171: ,p_collective_agreement_id_o =>per_grs_shd.g_old_rec.collective_agreement_id
172: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
173: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
174: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
175: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
176: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
177: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
178: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
179: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4

Line 176: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1

172: ,p_object_version_number_o =>per_grs_shd.g_old_rec.object_version_number
173: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
174: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
175: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
176: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
177: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
178: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
179: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
180: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5

Line 177: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2

173: ,p_id_flex_num_o =>per_grs_shd.g_old_rec.id_flex_num
174: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
175: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
176: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
177: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
178: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
179: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
180: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
181: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6

Line 178: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3

174: ,p_dynamic_insert_allowed_o =>per_grs_shd.g_old_rec.dynamic_insert_allowed
175: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
176: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
177: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
178: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
179: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
180: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
181: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
182: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7

Line 179: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4

175: ,p_attribute_category_o =>per_grs_shd.g_old_rec.attribute_category
176: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
177: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
178: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
179: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
180: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
181: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
182: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
183: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8

Line 180: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5

176: ,p_attribute1_o =>per_grs_shd.g_old_rec.attribute1
177: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
178: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
179: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
180: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
181: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
182: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
183: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
184: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9

Line 181: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6

177: ,p_attribute2_o =>per_grs_shd.g_old_rec.attribute2
178: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
179: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
180: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
181: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
182: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
183: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
184: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
185: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10

Line 182: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7

178: ,p_attribute3_o =>per_grs_shd.g_old_rec.attribute3
179: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
180: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
181: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
182: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
183: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
184: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
185: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
186: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11

Line 183: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8

179: ,p_attribute4_o =>per_grs_shd.g_old_rec.attribute4
180: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
181: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
182: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
183: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
184: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
185: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
186: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
187: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12

Line 184: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9

180: ,p_attribute5_o =>per_grs_shd.g_old_rec.attribute5
181: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
182: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
183: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
184: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
185: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
186: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
187: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
188: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13

Line 185: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10

181: ,p_attribute6_o =>per_grs_shd.g_old_rec.attribute6
182: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
183: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
184: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
185: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
186: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
187: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
188: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
189: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14

Line 186: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11

182: ,p_attribute7_o =>per_grs_shd.g_old_rec.attribute7
183: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
184: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
185: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
186: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
187: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
188: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
189: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
190: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15

Line 187: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12

183: ,p_attribute8_o =>per_grs_shd.g_old_rec.attribute8
184: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
185: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
186: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
187: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
188: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
189: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
190: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
191: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16

Line 188: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13

184: ,p_attribute9_o =>per_grs_shd.g_old_rec.attribute9
185: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
186: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
187: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
188: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
189: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
190: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
191: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
192: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17

Line 189: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14

185: ,p_attribute10_o =>per_grs_shd.g_old_rec.attribute10
186: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
187: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
188: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
189: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
190: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
191: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
192: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
193: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18

Line 190: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15

186: ,p_attribute11_o =>per_grs_shd.g_old_rec.attribute11
187: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
188: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
189: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
190: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
191: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
192: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
193: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
194: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19

Line 191: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16

187: ,p_attribute12_o =>per_grs_shd.g_old_rec.attribute12
188: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
189: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
190: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
191: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
192: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
193: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
194: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
195: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20

Line 192: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17

188: ,p_attribute13_o =>per_grs_shd.g_old_rec.attribute13
189: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
190: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
191: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
192: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
193: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
194: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
195: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20
196: ,p_effective_date =>p_effective_date

Line 193: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18

189: ,p_attribute14_o =>per_grs_shd.g_old_rec.attribute14
190: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
191: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
192: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
193: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
194: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
195: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20
196: ,p_effective_date =>p_effective_date
197: );

Line 194: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19

190: ,p_attribute15_o =>per_grs_shd.g_old_rec.attribute15
191: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
192: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
193: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
194: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
195: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20
196: ,p_effective_date =>p_effective_date
197: );
198: --

Line 195: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20

191: ,p_attribute16_o =>per_grs_shd.g_old_rec.attribute16
192: ,p_attribute17_o =>per_grs_shd.g_old_rec.attribute17
193: ,p_attribute18_o =>per_grs_shd.g_old_rec.attribute18
194: ,p_attribute19_o =>per_grs_shd.g_old_rec.attribute19
195: ,p_attribute20_o =>per_grs_shd.g_old_rec.attribute20
196: ,p_effective_date =>p_effective_date
197: );
198: --
199: exception

Line 220: p_rec in per_grs_shd.g_rec_type

216: -- |---------------------------------< del >----------------------------------|
217: -- ----------------------------------------------------------------------------
218: Procedure del
219: (p_effective_date in date,
220: p_rec in per_grs_shd.g_rec_type
221: ) is
222: --
223: l_proc varchar2(72) := g_package||'del';
224: --

Line 230: per_grs_shd.lck

226: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: -- We must lock the row which we need to delete.
229: --
230: per_grs_shd.lck
231: (p_effective_date => p_effective_date,
232: p_cagr_grade_structure_id => p_rec.cagr_grade_structure_id,
233: p_object_version_number => p_rec.object_version_number
234: );

Line 268: l_rec per_grs_shd.g_rec_type;

264: p_object_version_number in number,
265: p_effective_date in date
266: ) is
267: --
268: l_rec per_grs_shd.g_rec_type;
269: l_proc varchar2(72) := g_package||'del';
270: --
271: Begin
272: hr_utility.set_location('Entering:'||l_proc, 5);