47: -- Internal Table Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in hr_lei_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: -- hr_lei_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the hr_location_extra_info row.
61: --
62: delete from hr_location_extra_info
61: --
62: delete from hr_location_extra_info
63: where location_extra_info_id = p_rec.location_extra_info_id;
64: --
65: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception
68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
73: hr_lei_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
73: hr_lei_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
72: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
73: hr_lei_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------
108: -- Internal Table Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in hr_lei_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin
150: -- Internal table Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(p_rec in hr_lei_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin
161: -- This is a hook point and the user hook for post_delete is called here.
162: --
163: begin
164: hr_lei_rkd.after_delete (
165: p_location_extra_info_id_o => hr_lei_shd.g_old_rec.location_extra_info_id,
166: p_information_type_o => hr_lei_shd.g_old_rec.information_type,
167: p_location_id_o => hr_lei_shd.g_old_rec.location_id,
168: p_request_id_o => hr_lei_shd.g_old_rec.request_id ,
169: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
162: --
163: begin
164: hr_lei_rkd.after_delete (
165: p_location_extra_info_id_o => hr_lei_shd.g_old_rec.location_extra_info_id,
166: p_information_type_o => hr_lei_shd.g_old_rec.information_type,
167: p_location_id_o => hr_lei_shd.g_old_rec.location_id,
168: p_request_id_o => hr_lei_shd.g_old_rec.request_id ,
169: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
170: p_program_id_o => hr_lei_shd.g_old_rec.program_id ,
163: begin
164: hr_lei_rkd.after_delete (
165: p_location_extra_info_id_o => hr_lei_shd.g_old_rec.location_extra_info_id,
166: p_information_type_o => hr_lei_shd.g_old_rec.information_type,
167: p_location_id_o => hr_lei_shd.g_old_rec.location_id,
168: p_request_id_o => hr_lei_shd.g_old_rec.request_id ,
169: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
170: p_program_id_o => hr_lei_shd.g_old_rec.program_id ,
171: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
164: hr_lei_rkd.after_delete (
165: p_location_extra_info_id_o => hr_lei_shd.g_old_rec.location_extra_info_id,
166: p_information_type_o => hr_lei_shd.g_old_rec.information_type,
167: p_location_id_o => hr_lei_shd.g_old_rec.location_id,
168: p_request_id_o => hr_lei_shd.g_old_rec.request_id ,
169: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
170: p_program_id_o => hr_lei_shd.g_old_rec.program_id ,
171: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
172: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
165: p_location_extra_info_id_o => hr_lei_shd.g_old_rec.location_extra_info_id,
166: p_information_type_o => hr_lei_shd.g_old_rec.information_type,
167: p_location_id_o => hr_lei_shd.g_old_rec.location_id,
168: p_request_id_o => hr_lei_shd.g_old_rec.request_id ,
169: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
170: p_program_id_o => hr_lei_shd.g_old_rec.program_id ,
171: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
172: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
173: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
166: p_information_type_o => hr_lei_shd.g_old_rec.information_type,
167: p_location_id_o => hr_lei_shd.g_old_rec.location_id,
168: p_request_id_o => hr_lei_shd.g_old_rec.request_id ,
169: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
170: p_program_id_o => hr_lei_shd.g_old_rec.program_id ,
171: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
172: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
173: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
174: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
167: p_location_id_o => hr_lei_shd.g_old_rec.location_id,
168: p_request_id_o => hr_lei_shd.g_old_rec.request_id ,
169: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
170: p_program_id_o => hr_lei_shd.g_old_rec.program_id ,
171: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
172: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
173: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
174: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
175: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
168: p_request_id_o => hr_lei_shd.g_old_rec.request_id ,
169: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
170: p_program_id_o => hr_lei_shd.g_old_rec.program_id ,
171: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
172: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
173: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
174: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
175: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
176: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
169: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
170: p_program_id_o => hr_lei_shd.g_old_rec.program_id ,
171: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
172: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
173: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
174: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
175: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
176: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
177: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
170: p_program_id_o => hr_lei_shd.g_old_rec.program_id ,
171: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
172: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
173: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
174: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
175: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
176: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
177: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
178: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
171: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
172: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
173: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
174: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
175: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
176: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
177: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
178: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
179: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
172: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
173: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
174: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
175: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
176: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
177: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
178: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
179: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
180: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
173: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
174: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
175: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
176: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
177: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
178: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
179: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
180: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
181: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
174: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
175: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
176: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
177: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
178: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
179: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
180: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
181: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
182: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
175: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
176: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
177: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
178: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
179: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
180: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
181: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
182: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
183: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
176: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
177: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
178: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
179: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
180: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
181: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
182: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
183: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
184: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
177: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
178: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
179: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
180: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
181: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
182: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
183: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
184: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
185: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
178: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
179: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
180: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
181: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
182: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
183: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
184: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
185: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
186: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
179: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
180: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
181: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
182: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
183: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
184: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
185: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
186: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
187: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
180: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
181: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
182: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
183: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
184: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
185: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
186: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
187: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
188: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
181: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
182: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
183: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
184: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
185: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
186: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
187: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
188: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
189: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
182: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
183: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
184: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
185: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
186: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
187: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
188: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
189: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
190: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
183: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
184: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
185: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
186: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
187: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
188: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
189: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
190: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
191: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
184: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
185: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
186: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
187: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
188: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
189: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
190: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
191: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
192: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
185: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
186: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
187: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
188: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
189: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
190: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
191: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
192: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
193: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
186: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
187: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
188: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
189: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
190: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
191: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
192: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
193: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
194: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
187: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
188: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
189: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
190: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
191: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
192: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
193: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
194: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
195: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
188: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
189: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
190: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
191: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
192: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
193: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
194: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
195: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
196: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
189: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
190: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
191: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
192: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
193: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
194: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
195: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
196: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
197: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
190: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
191: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
192: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
193: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
194: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
195: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
196: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
197: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
198: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
191: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
192: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
193: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
194: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
195: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
196: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
197: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
198: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
199: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
192: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
193: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
194: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
195: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
196: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
197: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
198: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
199: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
200: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
193: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
194: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
195: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
196: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
197: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
198: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
199: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
200: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
201: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
194: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
195: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
196: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
197: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
198: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
199: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
200: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
201: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
202: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
195: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
196: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
197: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
198: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
199: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
200: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
201: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
202: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
203: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
196: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
197: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
198: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
199: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
200: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
201: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
202: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
203: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
204: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
197: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
198: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
199: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
200: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
201: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
202: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
203: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
204: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
205: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
198: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
199: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
200: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
201: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
202: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
203: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
204: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
205: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
206: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
199: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
200: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
201: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
202: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
203: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
204: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
205: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
206: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
207: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
200: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
201: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
202: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
203: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
204: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
205: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
206: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
207: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
208: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
201: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
202: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
203: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
204: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
205: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
206: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
207: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
208: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
209: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
202: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
203: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
204: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
205: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
206: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
207: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
208: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
209: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
210: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
203: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
204: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
205: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
206: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
207: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
208: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
209: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
210: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
211: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
204: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
205: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
206: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
207: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
208: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
209: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
210: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
211: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
212: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
205: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
206: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
207: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
208: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
209: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
210: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
211: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
212: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
213: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
206: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
207: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
208: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
209: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
210: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
211: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
212: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
213: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
214: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
207: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
208: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
209: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
210: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
211: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
212: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
213: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
214: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
215: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
208: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
209: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
210: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
211: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
212: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
213: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
214: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
215: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
216: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
209: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
210: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
211: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
212: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
213: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
214: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
215: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
216: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
217: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
210: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
211: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
212: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
213: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
214: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
215: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
216: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
217: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
218: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
211: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
212: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
213: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
214: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
215: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
216: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
217: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
218: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
219: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
212: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
213: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
214: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
215: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
216: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
217: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
218: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
219: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
220: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
213: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
214: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
215: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
216: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
217: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
218: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
219: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
220: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
221: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,
214: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
215: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
216: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
217: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
218: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
219: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
220: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
221: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,
222: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,
215: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
216: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
217: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
218: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
219: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
220: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
221: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,
222: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,
223: p_lei_information30_o => hr_lei_shd.g_old_rec.lei_information30
216: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
217: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
218: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
219: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
220: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
221: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,
222: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,
223: p_lei_information30_o => hr_lei_shd.g_old_rec.lei_information30
224: );
217: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
218: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
219: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
220: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
221: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,
222: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,
223: p_lei_information30_o => hr_lei_shd.g_old_rec.lei_information30
224: );
225: exception
218: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
219: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
220: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
221: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,
222: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,
223: p_lei_information30_o => hr_lei_shd.g_old_rec.lei_information30
224: );
225: exception
226: when hr_api.cannot_find_prog_unit then
219: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
220: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
221: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,
222: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,
223: p_lei_information30_o => hr_lei_shd.g_old_rec.lei_information30
224: );
225: exception
226: when hr_api.cannot_find_prog_unit then
227: hr_api.cannot_find_prog_unit_error
238: -- |---------------------------------< del >----------------------------------|
239: -- ----------------------------------------------------------------------------
240: Procedure del
241: (
242: p_rec in hr_lei_shd.g_rec_type,
243: p_validate in boolean default false
244: ) is
245: --
246: l_proc varchar2(72) := g_package||'del';
258: End If;
259: --
260: -- We must lock the row which we need to delete.
261: --
262: hr_lei_shd.lck
263: (
264: p_rec.location_extra_info_id,
265: p_rec.object_version_number
266: );
306: p_object_version_number in number,
307: p_validate in boolean default false
308: ) is
309: --
310: l_rec hr_lei_shd.g_rec_type;
311: l_proc varchar2(72) := g_package||'del';
312: --
313: Begin
314: hr_utility.set_location('Entering:'||l_proc, 5);