DBA Data[Home] [Help]

APPS.HR_LEI_UPD dependencies on HR_LEI_SHD

Line 54: Procedure update_dml(p_rec in out nocopy hr_lei_shd.g_rec_type) is

50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy hr_lei_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: -- hr_lei_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: -- hr_lei_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the hr_location_extra_info Row
68: --
69: update hr_location_extra_info

Line 133: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status

129: lei_information30 = p_rec.lei_information30,
130: object_version_number = p_rec.object_version_number
131: where location_extra_info_id = p_rec.location_extra_info_id;
132: --
133: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
134: --
135: hr_utility.set_location(' Leaving:'||l_proc, 10);
136: --
137: Exception

Line 140: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status

136: --
137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
141: hr_lei_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.parent_integrity_violated Then
144: -- Parent integrity has been violated

Line 141: hr_lei_shd.constraint_error

137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
141: hr_lei_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.parent_integrity_violated Then
144: -- Parent integrity has been violated
145: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status

Line 145: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status

141: hr_lei_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.parent_integrity_violated Then
144: -- Parent integrity has been violated
145: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
146: hr_lei_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: -- Unique integrity has been violated

Line 146: hr_lei_shd.constraint_error

142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.parent_integrity_violated Then
144: -- Parent integrity has been violated
145: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
146: hr_lei_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: -- Unique integrity has been violated
150: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status

Line 150: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status

146: hr_lei_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: -- Unique integrity has been violated
150: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
151: hr_lei_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When Others Then
154: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status

Line 151: hr_lei_shd.constraint_error

147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: -- Unique integrity has been violated
150: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
151: hr_lei_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When Others Then
154: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
155: Raise;

Line 154: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status

150: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
151: hr_lei_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When Others Then
154: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
155: Raise;
156: End update_dml;
157: --
158: -- ----------------------------------------------------------------------------

Line 190: Procedure pre_update(p_rec in hr_lei_shd.g_rec_type) is

186: -- Internal Table Handler Use Only.
187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure pre_update(p_rec in hr_lei_shd.g_rec_type) is
191: --
192: l_proc varchar2(72) := g_package||'pre_update';
193: --
194: Begin

Line 232: Procedure post_update(p_rec in hr_lei_shd.g_rec_type) is

228: -- Internal Table Handler Use Only.
229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure post_update(p_rec in hr_lei_shd.g_rec_type) is
233: --
234: l_proc varchar2(72) := g_package||'post_update';
235: --
236: Begin

Line 302: p_information_type_o => hr_lei_shd.g_old_rec.information_type,

298: p_lei_information27 => p_rec.lei_information27,
299: p_lei_information28 => p_rec.lei_information28,
300: p_lei_information29 => p_rec.lei_information29,
301: p_lei_information30 => p_rec.lei_information30,
302: p_information_type_o => hr_lei_shd.g_old_rec.information_type,
303: p_location_id_o => hr_lei_shd.g_old_rec.location_id,
304: p_request_id_o => hr_lei_shd.g_old_rec.request_id,
305: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
306: p_program_id_o => hr_lei_shd.g_old_rec.program_id,

Line 303: p_location_id_o => hr_lei_shd.g_old_rec.location_id,

299: p_lei_information28 => p_rec.lei_information28,
300: p_lei_information29 => p_rec.lei_information29,
301: p_lei_information30 => p_rec.lei_information30,
302: p_information_type_o => hr_lei_shd.g_old_rec.information_type,
303: p_location_id_o => hr_lei_shd.g_old_rec.location_id,
304: p_request_id_o => hr_lei_shd.g_old_rec.request_id,
305: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
306: p_program_id_o => hr_lei_shd.g_old_rec.program_id,
307: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,

Line 304: p_request_id_o => hr_lei_shd.g_old_rec.request_id,

300: p_lei_information29 => p_rec.lei_information29,
301: p_lei_information30 => p_rec.lei_information30,
302: p_information_type_o => hr_lei_shd.g_old_rec.information_type,
303: p_location_id_o => hr_lei_shd.g_old_rec.location_id,
304: p_request_id_o => hr_lei_shd.g_old_rec.request_id,
305: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
306: p_program_id_o => hr_lei_shd.g_old_rec.program_id,
307: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
308: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,

Line 305: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,

301: p_lei_information30 => p_rec.lei_information30,
302: p_information_type_o => hr_lei_shd.g_old_rec.information_type,
303: p_location_id_o => hr_lei_shd.g_old_rec.location_id,
304: p_request_id_o => hr_lei_shd.g_old_rec.request_id,
305: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
306: p_program_id_o => hr_lei_shd.g_old_rec.program_id,
307: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
308: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
309: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,

Line 306: p_program_id_o => hr_lei_shd.g_old_rec.program_id,

302: p_information_type_o => hr_lei_shd.g_old_rec.information_type,
303: p_location_id_o => hr_lei_shd.g_old_rec.location_id,
304: p_request_id_o => hr_lei_shd.g_old_rec.request_id,
305: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
306: p_program_id_o => hr_lei_shd.g_old_rec.program_id,
307: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
308: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
309: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
310: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,

Line 307: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,

303: p_location_id_o => hr_lei_shd.g_old_rec.location_id,
304: p_request_id_o => hr_lei_shd.g_old_rec.request_id,
305: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
306: p_program_id_o => hr_lei_shd.g_old_rec.program_id,
307: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
308: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
309: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
310: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
311: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,

Line 308: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,

304: p_request_id_o => hr_lei_shd.g_old_rec.request_id,
305: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
306: p_program_id_o => hr_lei_shd.g_old_rec.program_id,
307: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
308: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
309: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
310: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
311: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
312: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,

Line 309: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,

305: p_program_application_id_o => hr_lei_shd.g_old_rec.program_application_id,
306: p_program_id_o => hr_lei_shd.g_old_rec.program_id,
307: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
308: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
309: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
310: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
311: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
312: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
313: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,

Line 310: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,

306: p_program_id_o => hr_lei_shd.g_old_rec.program_id,
307: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
308: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
309: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
310: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
311: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
312: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
313: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
314: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,

Line 311: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,

307: p_program_update_date_o => hr_lei_shd.g_old_rec.program_update_date,
308: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
309: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
310: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
311: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
312: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
313: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
314: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
315: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,

Line 312: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,

308: p_lei_attribute_category_o => hr_lei_shd.g_old_rec.lei_attribute_category,
309: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
310: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
311: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
312: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
313: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
314: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
315: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
316: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,

Line 313: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,

309: p_lei_attribute1_o => hr_lei_shd.g_old_rec.lei_attribute1,
310: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
311: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
312: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
313: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
314: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
315: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
316: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
317: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,

Line 314: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,

310: p_lei_attribute2_o => hr_lei_shd.g_old_rec.lei_attribute2,
311: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
312: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
313: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
314: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
315: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
316: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
317: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
318: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,

Line 315: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,

311: p_lei_attribute3_o => hr_lei_shd.g_old_rec.lei_attribute3,
312: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
313: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
314: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
315: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
316: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
317: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
318: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
319: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,

Line 316: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,

312: p_lei_attribute4_o => hr_lei_shd.g_old_rec.lei_attribute4,
313: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
314: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
315: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
316: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
317: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
318: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
319: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
320: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,

Line 317: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,

313: p_lei_attribute5_o => hr_lei_shd.g_old_rec.lei_attribute5,
314: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
315: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
316: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
317: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
318: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
319: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
320: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
321: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,

Line 318: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,

314: p_lei_attribute6_o => hr_lei_shd.g_old_rec.lei_attribute6,
315: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
316: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
317: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
318: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
319: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
320: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
321: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
322: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,

Line 319: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,

315: p_lei_attribute7_o => hr_lei_shd.g_old_rec.lei_attribute7,
316: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
317: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
318: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
319: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
320: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
321: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
322: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
323: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,

Line 320: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,

316: p_lei_attribute8_o => hr_lei_shd.g_old_rec.lei_attribute8,
317: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
318: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
319: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
320: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
321: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
322: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
323: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
324: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,

Line 321: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,

317: p_lei_attribute9_o => hr_lei_shd.g_old_rec.lei_attribute9,
318: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
319: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
320: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
321: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
322: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
323: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
324: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
325: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,

Line 322: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,

318: p_lei_attribute10_o => hr_lei_shd.g_old_rec.lei_attribute10,
319: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
320: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
321: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
322: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
323: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
324: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
325: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
326: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,

Line 323: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,

319: p_lei_attribute11_o => hr_lei_shd.g_old_rec.lei_attribute11,
320: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
321: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
322: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
323: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
324: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
325: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
326: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
327: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,

Line 324: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,

320: p_lei_attribute12_o => hr_lei_shd.g_old_rec.lei_attribute12,
321: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
322: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
323: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
324: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
325: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
326: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
327: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
328: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,

Line 325: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,

321: p_lei_attribute13_o => hr_lei_shd.g_old_rec.lei_attribute13,
322: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
323: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
324: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
325: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
326: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
327: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
328: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
329: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,

Line 326: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,

322: p_lei_attribute14_o => hr_lei_shd.g_old_rec.lei_attribute14,
323: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
324: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
325: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
326: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
327: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
328: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
329: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
330: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,

Line 327: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,

323: p_lei_attribute15_o => hr_lei_shd.g_old_rec.lei_attribute15,
324: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
325: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
326: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
327: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
328: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
329: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
330: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
331: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,

Line 328: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,

324: p_lei_attribute16_o => hr_lei_shd.g_old_rec.lei_attribute16,
325: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
326: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
327: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
328: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
329: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
330: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
331: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
332: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,

Line 329: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,

325: p_lei_attribute17_o => hr_lei_shd.g_old_rec.lei_attribute17,
326: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
327: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
328: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
329: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
330: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
331: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
332: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
333: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,

Line 330: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,

326: p_lei_attribute18_o => hr_lei_shd.g_old_rec.lei_attribute18,
327: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
328: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
329: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
330: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
331: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
332: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
333: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
334: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,

Line 331: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,

327: p_lei_attribute19_o => hr_lei_shd.g_old_rec.lei_attribute19,
328: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
329: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
330: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
331: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
332: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
333: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
334: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
335: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,

Line 332: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,

328: p_lei_attribute20_o => hr_lei_shd.g_old_rec.lei_attribute20,
329: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
330: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
331: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
332: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
333: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
334: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
335: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
336: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,

Line 333: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,

329: p_lei_information_category_o => hr_lei_shd.g_old_rec.lei_information_category,
330: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
331: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
332: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
333: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
334: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
335: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
336: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
337: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,

Line 334: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,

330: p_lei_information1_o => hr_lei_shd.g_old_rec.lei_information1,
331: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
332: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
333: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
334: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
335: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
336: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
337: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
338: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,

Line 335: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,

331: p_lei_information2_o => hr_lei_shd.g_old_rec.lei_information2,
332: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
333: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
334: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
335: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
336: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
337: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
338: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
339: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,

Line 336: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,

332: p_lei_information3_o => hr_lei_shd.g_old_rec.lei_information3,
333: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
334: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
335: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
336: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
337: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
338: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
339: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
340: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,

Line 337: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,

333: p_lei_information4_o => hr_lei_shd.g_old_rec.lei_information4,
334: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
335: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
336: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
337: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
338: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
339: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
340: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
341: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,

Line 338: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,

334: p_lei_information5_o => hr_lei_shd.g_old_rec.lei_information5,
335: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
336: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
337: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
338: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
339: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
340: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
341: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
342: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,

Line 339: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,

335: p_lei_information6_o => hr_lei_shd.g_old_rec.lei_information6,
336: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
337: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
338: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
339: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
340: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
341: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
342: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
343: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,

Line 340: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,

336: p_lei_information7_o => hr_lei_shd.g_old_rec.lei_information7,
337: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
338: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
339: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
340: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
341: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
342: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
343: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
344: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,

Line 341: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,

337: p_lei_information8_o => hr_lei_shd.g_old_rec.lei_information8,
338: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
339: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
340: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
341: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
342: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
343: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
344: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
345: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,

Line 342: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,

338: p_lei_information9_o => hr_lei_shd.g_old_rec.lei_information9,
339: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
340: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
341: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
342: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
343: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
344: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
345: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
346: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,

Line 343: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,

339: p_lei_information10_o => hr_lei_shd.g_old_rec.lei_information10,
340: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
341: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
342: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
343: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
344: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
345: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
346: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
347: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,

Line 344: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,

340: p_lei_information11_o => hr_lei_shd.g_old_rec.lei_information11,
341: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
342: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
343: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
344: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
345: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
346: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
347: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
348: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,

Line 345: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,

341: p_lei_information12_o => hr_lei_shd.g_old_rec.lei_information12,
342: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
343: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
344: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
345: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
346: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
347: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
348: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
349: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,

Line 346: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,

342: p_lei_information13_o => hr_lei_shd.g_old_rec.lei_information13,
343: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
344: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
345: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
346: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
347: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
348: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
349: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
350: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,

Line 347: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,

343: p_lei_information14_o => hr_lei_shd.g_old_rec.lei_information14,
344: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
345: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
346: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
347: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
348: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
349: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
350: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
351: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,

Line 348: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,

344: p_lei_information15_o => hr_lei_shd.g_old_rec.lei_information15,
345: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
346: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
347: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
348: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
349: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
350: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
351: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
352: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,

Line 349: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,

345: p_lei_information16_o => hr_lei_shd.g_old_rec.lei_information16,
346: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
347: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
348: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
349: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
350: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
351: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
352: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
353: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,

Line 350: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,

346: p_lei_information17_o => hr_lei_shd.g_old_rec.lei_information17,
347: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
348: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
349: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
350: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
351: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
352: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
353: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
354: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,

Line 351: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,

347: p_lei_information18_o => hr_lei_shd.g_old_rec.lei_information18,
348: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
349: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
350: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
351: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
352: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
353: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
354: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
355: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,

Line 352: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,

348: p_lei_information19_o => hr_lei_shd.g_old_rec.lei_information19,
349: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
350: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
351: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
352: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
353: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
354: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
355: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
356: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,

Line 353: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,

349: p_lei_information20_o => hr_lei_shd.g_old_rec.lei_information20,
350: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
351: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
352: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
353: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
354: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
355: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
356: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
357: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,

Line 354: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,

350: p_lei_information21_o => hr_lei_shd.g_old_rec.lei_information21,
351: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
352: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
353: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
354: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
355: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
356: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
357: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,
358: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,

Line 355: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,

351: p_lei_information22_o => hr_lei_shd.g_old_rec.lei_information22,
352: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
353: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
354: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
355: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
356: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
357: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,
358: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,
359: p_lei_information30_o => hr_lei_shd.g_old_rec.lei_information30

Line 356: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,

352: p_lei_information23_o => hr_lei_shd.g_old_rec.lei_information23,
353: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
354: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
355: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
356: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
357: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,
358: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,
359: p_lei_information30_o => hr_lei_shd.g_old_rec.lei_information30
360: );

Line 357: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,

353: p_lei_information24_o => hr_lei_shd.g_old_rec.lei_information24,
354: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
355: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
356: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
357: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,
358: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,
359: p_lei_information30_o => hr_lei_shd.g_old_rec.lei_information30
360: );
361: exception

Line 358: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,

354: p_lei_information25_o => hr_lei_shd.g_old_rec.lei_information25,
355: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
356: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
357: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,
358: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,
359: p_lei_information30_o => hr_lei_shd.g_old_rec.lei_information30
360: );
361: exception
362: when hr_api.cannot_find_prog_unit then

Line 359: p_lei_information30_o => hr_lei_shd.g_old_rec.lei_information30

355: p_lei_information26_o => hr_lei_shd.g_old_rec.lei_information26,
356: p_lei_information27_o => hr_lei_shd.g_old_rec.lei_information27,
357: p_lei_information28_o => hr_lei_shd.g_old_rec.lei_information28,
358: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,
359: p_lei_information30_o => hr_lei_shd.g_old_rec.lei_information30
360: );
361: exception
362: when hr_api.cannot_find_prog_unit then
363: hr_api.cannot_find_prog_unit_error

Line 417: Procedure convert_defs(p_rec in out nocopy hr_lei_shd.g_rec_type) is

413: -- Internal Table Handler Use Only.
414: --
415: -- {End Of Comments}
416: -- ----------------------------------------------------------------------------
417: Procedure convert_defs(p_rec in out nocopy hr_lei_shd.g_rec_type) is
418: --
419: l_proc varchar2(72) := g_package||'convert_defs';
420: --
421: Begin

Line 432: hr_lei_shd.g_old_rec.information_type;

428: -- is being used then we must set to the 'current' argument value.
429: --
430: If (p_rec.information_type = hr_api.g_varchar2) then
431: p_rec.information_type :=
432: hr_lei_shd.g_old_rec.information_type;
433: End If;
434: If (p_rec.location_id = hr_api.g_number) then
435: p_rec.location_id :=
436: hr_lei_shd.g_old_rec.location_id;

Line 436: hr_lei_shd.g_old_rec.location_id;

432: hr_lei_shd.g_old_rec.information_type;
433: End If;
434: If (p_rec.location_id = hr_api.g_number) then
435: p_rec.location_id :=
436: hr_lei_shd.g_old_rec.location_id;
437: End If;
438: If (p_rec.request_id = hr_api.g_number) then
439: p_rec.request_id :=
440: hr_lei_shd.g_old_rec.request_id;

Line 440: hr_lei_shd.g_old_rec.request_id;

436: hr_lei_shd.g_old_rec.location_id;
437: End If;
438: If (p_rec.request_id = hr_api.g_number) then
439: p_rec.request_id :=
440: hr_lei_shd.g_old_rec.request_id;
441: End If;
442: If (p_rec.program_application_id = hr_api.g_number) then
443: p_rec.program_application_id :=
444: hr_lei_shd.g_old_rec.program_application_id;

Line 444: hr_lei_shd.g_old_rec.program_application_id;

440: hr_lei_shd.g_old_rec.request_id;
441: End If;
442: If (p_rec.program_application_id = hr_api.g_number) then
443: p_rec.program_application_id :=
444: hr_lei_shd.g_old_rec.program_application_id;
445: End If;
446: If (p_rec.program_id = hr_api.g_number) then
447: p_rec.program_id :=
448: hr_lei_shd.g_old_rec.program_id;

Line 448: hr_lei_shd.g_old_rec.program_id;

444: hr_lei_shd.g_old_rec.program_application_id;
445: End If;
446: If (p_rec.program_id = hr_api.g_number) then
447: p_rec.program_id :=
448: hr_lei_shd.g_old_rec.program_id;
449: End If;
450: If (p_rec.program_update_date = hr_api.g_date) then
451: p_rec.program_update_date :=
452: hr_lei_shd.g_old_rec.program_update_date;

Line 452: hr_lei_shd.g_old_rec.program_update_date;

448: hr_lei_shd.g_old_rec.program_id;
449: End If;
450: If (p_rec.program_update_date = hr_api.g_date) then
451: p_rec.program_update_date :=
452: hr_lei_shd.g_old_rec.program_update_date;
453: End If;
454: If (p_rec.lei_attribute_category = hr_api.g_varchar2) then
455: p_rec.lei_attribute_category :=
456: hr_lei_shd.g_old_rec.lei_attribute_category;

Line 456: hr_lei_shd.g_old_rec.lei_attribute_category;

452: hr_lei_shd.g_old_rec.program_update_date;
453: End If;
454: If (p_rec.lei_attribute_category = hr_api.g_varchar2) then
455: p_rec.lei_attribute_category :=
456: hr_lei_shd.g_old_rec.lei_attribute_category;
457: End If;
458: If (p_rec.lei_attribute1 = hr_api.g_varchar2) then
459: p_rec.lei_attribute1 :=
460: hr_lei_shd.g_old_rec.lei_attribute1;

Line 460: hr_lei_shd.g_old_rec.lei_attribute1;

456: hr_lei_shd.g_old_rec.lei_attribute_category;
457: End If;
458: If (p_rec.lei_attribute1 = hr_api.g_varchar2) then
459: p_rec.lei_attribute1 :=
460: hr_lei_shd.g_old_rec.lei_attribute1;
461: End If;
462: If (p_rec.lei_attribute2 = hr_api.g_varchar2) then
463: p_rec.lei_attribute2 :=
464: hr_lei_shd.g_old_rec.lei_attribute2;

Line 464: hr_lei_shd.g_old_rec.lei_attribute2;

460: hr_lei_shd.g_old_rec.lei_attribute1;
461: End If;
462: If (p_rec.lei_attribute2 = hr_api.g_varchar2) then
463: p_rec.lei_attribute2 :=
464: hr_lei_shd.g_old_rec.lei_attribute2;
465: End If;
466: If (p_rec.lei_attribute3 = hr_api.g_varchar2) then
467: p_rec.lei_attribute3 :=
468: hr_lei_shd.g_old_rec.lei_attribute3;

Line 468: hr_lei_shd.g_old_rec.lei_attribute3;

464: hr_lei_shd.g_old_rec.lei_attribute2;
465: End If;
466: If (p_rec.lei_attribute3 = hr_api.g_varchar2) then
467: p_rec.lei_attribute3 :=
468: hr_lei_shd.g_old_rec.lei_attribute3;
469: End If;
470: If (p_rec.lei_attribute4 = hr_api.g_varchar2) then
471: p_rec.lei_attribute4 :=
472: hr_lei_shd.g_old_rec.lei_attribute4;

Line 472: hr_lei_shd.g_old_rec.lei_attribute4;

468: hr_lei_shd.g_old_rec.lei_attribute3;
469: End If;
470: If (p_rec.lei_attribute4 = hr_api.g_varchar2) then
471: p_rec.lei_attribute4 :=
472: hr_lei_shd.g_old_rec.lei_attribute4;
473: End If;
474: If (p_rec.lei_attribute5 = hr_api.g_varchar2) then
475: p_rec.lei_attribute5 :=
476: hr_lei_shd.g_old_rec.lei_attribute5;

Line 476: hr_lei_shd.g_old_rec.lei_attribute5;

472: hr_lei_shd.g_old_rec.lei_attribute4;
473: End If;
474: If (p_rec.lei_attribute5 = hr_api.g_varchar2) then
475: p_rec.lei_attribute5 :=
476: hr_lei_shd.g_old_rec.lei_attribute5;
477: End If;
478: If (p_rec.lei_attribute6 = hr_api.g_varchar2) then
479: p_rec.lei_attribute6 :=
480: hr_lei_shd.g_old_rec.lei_attribute6;

Line 480: hr_lei_shd.g_old_rec.lei_attribute6;

476: hr_lei_shd.g_old_rec.lei_attribute5;
477: End If;
478: If (p_rec.lei_attribute6 = hr_api.g_varchar2) then
479: p_rec.lei_attribute6 :=
480: hr_lei_shd.g_old_rec.lei_attribute6;
481: End If;
482: If (p_rec.lei_attribute7 = hr_api.g_varchar2) then
483: p_rec.lei_attribute7 :=
484: hr_lei_shd.g_old_rec.lei_attribute7;

Line 484: hr_lei_shd.g_old_rec.lei_attribute7;

480: hr_lei_shd.g_old_rec.lei_attribute6;
481: End If;
482: If (p_rec.lei_attribute7 = hr_api.g_varchar2) then
483: p_rec.lei_attribute7 :=
484: hr_lei_shd.g_old_rec.lei_attribute7;
485: End If;
486: If (p_rec.lei_attribute8 = hr_api.g_varchar2) then
487: p_rec.lei_attribute8 :=
488: hr_lei_shd.g_old_rec.lei_attribute8;

Line 488: hr_lei_shd.g_old_rec.lei_attribute8;

484: hr_lei_shd.g_old_rec.lei_attribute7;
485: End If;
486: If (p_rec.lei_attribute8 = hr_api.g_varchar2) then
487: p_rec.lei_attribute8 :=
488: hr_lei_shd.g_old_rec.lei_attribute8;
489: End If;
490: If (p_rec.lei_attribute9 = hr_api.g_varchar2) then
491: p_rec.lei_attribute9 :=
492: hr_lei_shd.g_old_rec.lei_attribute9;

Line 492: hr_lei_shd.g_old_rec.lei_attribute9;

488: hr_lei_shd.g_old_rec.lei_attribute8;
489: End If;
490: If (p_rec.lei_attribute9 = hr_api.g_varchar2) then
491: p_rec.lei_attribute9 :=
492: hr_lei_shd.g_old_rec.lei_attribute9;
493: End If;
494: If (p_rec.lei_attribute10 = hr_api.g_varchar2) then
495: p_rec.lei_attribute10 :=
496: hr_lei_shd.g_old_rec.lei_attribute10;

Line 496: hr_lei_shd.g_old_rec.lei_attribute10;

492: hr_lei_shd.g_old_rec.lei_attribute9;
493: End If;
494: If (p_rec.lei_attribute10 = hr_api.g_varchar2) then
495: p_rec.lei_attribute10 :=
496: hr_lei_shd.g_old_rec.lei_attribute10;
497: End If;
498: If (p_rec.lei_attribute11 = hr_api.g_varchar2) then
499: p_rec.lei_attribute11 :=
500: hr_lei_shd.g_old_rec.lei_attribute11;

Line 500: hr_lei_shd.g_old_rec.lei_attribute11;

496: hr_lei_shd.g_old_rec.lei_attribute10;
497: End If;
498: If (p_rec.lei_attribute11 = hr_api.g_varchar2) then
499: p_rec.lei_attribute11 :=
500: hr_lei_shd.g_old_rec.lei_attribute11;
501: End If;
502: If (p_rec.lei_attribute12 = hr_api.g_varchar2) then
503: p_rec.lei_attribute12 :=
504: hr_lei_shd.g_old_rec.lei_attribute12;

Line 504: hr_lei_shd.g_old_rec.lei_attribute12;

500: hr_lei_shd.g_old_rec.lei_attribute11;
501: End If;
502: If (p_rec.lei_attribute12 = hr_api.g_varchar2) then
503: p_rec.lei_attribute12 :=
504: hr_lei_shd.g_old_rec.lei_attribute12;
505: End If;
506: If (p_rec.lei_attribute13 = hr_api.g_varchar2) then
507: p_rec.lei_attribute13 :=
508: hr_lei_shd.g_old_rec.lei_attribute13;

Line 508: hr_lei_shd.g_old_rec.lei_attribute13;

504: hr_lei_shd.g_old_rec.lei_attribute12;
505: End If;
506: If (p_rec.lei_attribute13 = hr_api.g_varchar2) then
507: p_rec.lei_attribute13 :=
508: hr_lei_shd.g_old_rec.lei_attribute13;
509: End If;
510: If (p_rec.lei_attribute14 = hr_api.g_varchar2) then
511: p_rec.lei_attribute14 :=
512: hr_lei_shd.g_old_rec.lei_attribute14;

Line 512: hr_lei_shd.g_old_rec.lei_attribute14;

508: hr_lei_shd.g_old_rec.lei_attribute13;
509: End If;
510: If (p_rec.lei_attribute14 = hr_api.g_varchar2) then
511: p_rec.lei_attribute14 :=
512: hr_lei_shd.g_old_rec.lei_attribute14;
513: End If;
514: If (p_rec.lei_attribute15 = hr_api.g_varchar2) then
515: p_rec.lei_attribute15 :=
516: hr_lei_shd.g_old_rec.lei_attribute15;

Line 516: hr_lei_shd.g_old_rec.lei_attribute15;

512: hr_lei_shd.g_old_rec.lei_attribute14;
513: End If;
514: If (p_rec.lei_attribute15 = hr_api.g_varchar2) then
515: p_rec.lei_attribute15 :=
516: hr_lei_shd.g_old_rec.lei_attribute15;
517: End If;
518: If (p_rec.lei_attribute16 = hr_api.g_varchar2) then
519: p_rec.lei_attribute16 :=
520: hr_lei_shd.g_old_rec.lei_attribute16;

Line 520: hr_lei_shd.g_old_rec.lei_attribute16;

516: hr_lei_shd.g_old_rec.lei_attribute15;
517: End If;
518: If (p_rec.lei_attribute16 = hr_api.g_varchar2) then
519: p_rec.lei_attribute16 :=
520: hr_lei_shd.g_old_rec.lei_attribute16;
521: End If;
522: If (p_rec.lei_attribute17 = hr_api.g_varchar2) then
523: p_rec.lei_attribute17 :=
524: hr_lei_shd.g_old_rec.lei_attribute17;

Line 524: hr_lei_shd.g_old_rec.lei_attribute17;

520: hr_lei_shd.g_old_rec.lei_attribute16;
521: End If;
522: If (p_rec.lei_attribute17 = hr_api.g_varchar2) then
523: p_rec.lei_attribute17 :=
524: hr_lei_shd.g_old_rec.lei_attribute17;
525: End If;
526: If (p_rec.lei_attribute18 = hr_api.g_varchar2) then
527: p_rec.lei_attribute18 :=
528: hr_lei_shd.g_old_rec.lei_attribute18;

Line 528: hr_lei_shd.g_old_rec.lei_attribute18;

524: hr_lei_shd.g_old_rec.lei_attribute17;
525: End If;
526: If (p_rec.lei_attribute18 = hr_api.g_varchar2) then
527: p_rec.lei_attribute18 :=
528: hr_lei_shd.g_old_rec.lei_attribute18;
529: End If;
530: If (p_rec.lei_attribute19 = hr_api.g_varchar2) then
531: p_rec.lei_attribute19 :=
532: hr_lei_shd.g_old_rec.lei_attribute19;

Line 532: hr_lei_shd.g_old_rec.lei_attribute19;

528: hr_lei_shd.g_old_rec.lei_attribute18;
529: End If;
530: If (p_rec.lei_attribute19 = hr_api.g_varchar2) then
531: p_rec.lei_attribute19 :=
532: hr_lei_shd.g_old_rec.lei_attribute19;
533: End If;
534: If (p_rec.lei_attribute20 = hr_api.g_varchar2) then
535: p_rec.lei_attribute20 :=
536: hr_lei_shd.g_old_rec.lei_attribute20;

Line 536: hr_lei_shd.g_old_rec.lei_attribute20;

532: hr_lei_shd.g_old_rec.lei_attribute19;
533: End If;
534: If (p_rec.lei_attribute20 = hr_api.g_varchar2) then
535: p_rec.lei_attribute20 :=
536: hr_lei_shd.g_old_rec.lei_attribute20;
537: End If;
538: If (p_rec.lei_information_category = hr_api.g_varchar2) then
539: p_rec.lei_information_category :=
540: hr_lei_shd.g_old_rec.lei_information_category;

Line 540: hr_lei_shd.g_old_rec.lei_information_category;

536: hr_lei_shd.g_old_rec.lei_attribute20;
537: End If;
538: If (p_rec.lei_information_category = hr_api.g_varchar2) then
539: p_rec.lei_information_category :=
540: hr_lei_shd.g_old_rec.lei_information_category;
541: End If;
542: If (p_rec.lei_information1 = hr_api.g_varchar2) then
543: p_rec.lei_information1 :=
544: hr_lei_shd.g_old_rec.lei_information1;

Line 544: hr_lei_shd.g_old_rec.lei_information1;

540: hr_lei_shd.g_old_rec.lei_information_category;
541: End If;
542: If (p_rec.lei_information1 = hr_api.g_varchar2) then
543: p_rec.lei_information1 :=
544: hr_lei_shd.g_old_rec.lei_information1;
545: End If;
546: If (p_rec.lei_information2 = hr_api.g_varchar2) then
547: p_rec.lei_information2 :=
548: hr_lei_shd.g_old_rec.lei_information2;

Line 548: hr_lei_shd.g_old_rec.lei_information2;

544: hr_lei_shd.g_old_rec.lei_information1;
545: End If;
546: If (p_rec.lei_information2 = hr_api.g_varchar2) then
547: p_rec.lei_information2 :=
548: hr_lei_shd.g_old_rec.lei_information2;
549: End If;
550: If (p_rec.lei_information3 = hr_api.g_varchar2) then
551: p_rec.lei_information3 :=
552: hr_lei_shd.g_old_rec.lei_information3;

Line 552: hr_lei_shd.g_old_rec.lei_information3;

548: hr_lei_shd.g_old_rec.lei_information2;
549: End If;
550: If (p_rec.lei_information3 = hr_api.g_varchar2) then
551: p_rec.lei_information3 :=
552: hr_lei_shd.g_old_rec.lei_information3;
553: End If;
554: If (p_rec.lei_information4 = hr_api.g_varchar2) then
555: p_rec.lei_information4 :=
556: hr_lei_shd.g_old_rec.lei_information4;

Line 556: hr_lei_shd.g_old_rec.lei_information4;

552: hr_lei_shd.g_old_rec.lei_information3;
553: End If;
554: If (p_rec.lei_information4 = hr_api.g_varchar2) then
555: p_rec.lei_information4 :=
556: hr_lei_shd.g_old_rec.lei_information4;
557: End If;
558: If (p_rec.lei_information5 = hr_api.g_varchar2) then
559: p_rec.lei_information5 :=
560: hr_lei_shd.g_old_rec.lei_information5;

Line 560: hr_lei_shd.g_old_rec.lei_information5;

556: hr_lei_shd.g_old_rec.lei_information4;
557: End If;
558: If (p_rec.lei_information5 = hr_api.g_varchar2) then
559: p_rec.lei_information5 :=
560: hr_lei_shd.g_old_rec.lei_information5;
561: End If;
562: If (p_rec.lei_information6 = hr_api.g_varchar2) then
563: p_rec.lei_information6 :=
564: hr_lei_shd.g_old_rec.lei_information6;

Line 564: hr_lei_shd.g_old_rec.lei_information6;

560: hr_lei_shd.g_old_rec.lei_information5;
561: End If;
562: If (p_rec.lei_information6 = hr_api.g_varchar2) then
563: p_rec.lei_information6 :=
564: hr_lei_shd.g_old_rec.lei_information6;
565: End If;
566: If (p_rec.lei_information7 = hr_api.g_varchar2) then
567: p_rec.lei_information7 :=
568: hr_lei_shd.g_old_rec.lei_information7;

Line 568: hr_lei_shd.g_old_rec.lei_information7;

564: hr_lei_shd.g_old_rec.lei_information6;
565: End If;
566: If (p_rec.lei_information7 = hr_api.g_varchar2) then
567: p_rec.lei_information7 :=
568: hr_lei_shd.g_old_rec.lei_information7;
569: End If;
570: If (p_rec.lei_information8 = hr_api.g_varchar2) then
571: p_rec.lei_information8 :=
572: hr_lei_shd.g_old_rec.lei_information8;

Line 572: hr_lei_shd.g_old_rec.lei_information8;

568: hr_lei_shd.g_old_rec.lei_information7;
569: End If;
570: If (p_rec.lei_information8 = hr_api.g_varchar2) then
571: p_rec.lei_information8 :=
572: hr_lei_shd.g_old_rec.lei_information8;
573: End If;
574: If (p_rec.lei_information9 = hr_api.g_varchar2) then
575: p_rec.lei_information9 :=
576: hr_lei_shd.g_old_rec.lei_information9;

Line 576: hr_lei_shd.g_old_rec.lei_information9;

572: hr_lei_shd.g_old_rec.lei_information8;
573: End If;
574: If (p_rec.lei_information9 = hr_api.g_varchar2) then
575: p_rec.lei_information9 :=
576: hr_lei_shd.g_old_rec.lei_information9;
577: End If;
578: If (p_rec.lei_information10 = hr_api.g_varchar2) then
579: p_rec.lei_information10 :=
580: hr_lei_shd.g_old_rec.lei_information10;

Line 580: hr_lei_shd.g_old_rec.lei_information10;

576: hr_lei_shd.g_old_rec.lei_information9;
577: End If;
578: If (p_rec.lei_information10 = hr_api.g_varchar2) then
579: p_rec.lei_information10 :=
580: hr_lei_shd.g_old_rec.lei_information10;
581: End If;
582: If (p_rec.lei_information11 = hr_api.g_varchar2) then
583: p_rec.lei_information11 :=
584: hr_lei_shd.g_old_rec.lei_information11;

Line 584: hr_lei_shd.g_old_rec.lei_information11;

580: hr_lei_shd.g_old_rec.lei_information10;
581: End If;
582: If (p_rec.lei_information11 = hr_api.g_varchar2) then
583: p_rec.lei_information11 :=
584: hr_lei_shd.g_old_rec.lei_information11;
585: End If;
586: If (p_rec.lei_information12 = hr_api.g_varchar2) then
587: p_rec.lei_information12 :=
588: hr_lei_shd.g_old_rec.lei_information12;

Line 588: hr_lei_shd.g_old_rec.lei_information12;

584: hr_lei_shd.g_old_rec.lei_information11;
585: End If;
586: If (p_rec.lei_information12 = hr_api.g_varchar2) then
587: p_rec.lei_information12 :=
588: hr_lei_shd.g_old_rec.lei_information12;
589: End If;
590: If (p_rec.lei_information13 = hr_api.g_varchar2) then
591: p_rec.lei_information13 :=
592: hr_lei_shd.g_old_rec.lei_information13;

Line 592: hr_lei_shd.g_old_rec.lei_information13;

588: hr_lei_shd.g_old_rec.lei_information12;
589: End If;
590: If (p_rec.lei_information13 = hr_api.g_varchar2) then
591: p_rec.lei_information13 :=
592: hr_lei_shd.g_old_rec.lei_information13;
593: End If;
594: If (p_rec.lei_information14 = hr_api.g_varchar2) then
595: p_rec.lei_information14 :=
596: hr_lei_shd.g_old_rec.lei_information14;

Line 596: hr_lei_shd.g_old_rec.lei_information14;

592: hr_lei_shd.g_old_rec.lei_information13;
593: End If;
594: If (p_rec.lei_information14 = hr_api.g_varchar2) then
595: p_rec.lei_information14 :=
596: hr_lei_shd.g_old_rec.lei_information14;
597: End If;
598: If (p_rec.lei_information15 = hr_api.g_varchar2) then
599: p_rec.lei_information15 :=
600: hr_lei_shd.g_old_rec.lei_information15;

Line 600: hr_lei_shd.g_old_rec.lei_information15;

596: hr_lei_shd.g_old_rec.lei_information14;
597: End If;
598: If (p_rec.lei_information15 = hr_api.g_varchar2) then
599: p_rec.lei_information15 :=
600: hr_lei_shd.g_old_rec.lei_information15;
601: End If;
602: If (p_rec.lei_information16 = hr_api.g_varchar2) then
603: p_rec.lei_information16 :=
604: hr_lei_shd.g_old_rec.lei_information16;

Line 604: hr_lei_shd.g_old_rec.lei_information16;

600: hr_lei_shd.g_old_rec.lei_information15;
601: End If;
602: If (p_rec.lei_information16 = hr_api.g_varchar2) then
603: p_rec.lei_information16 :=
604: hr_lei_shd.g_old_rec.lei_information16;
605: End If;
606: If (p_rec.lei_information17 = hr_api.g_varchar2) then
607: p_rec.lei_information17 :=
608: hr_lei_shd.g_old_rec.lei_information17;

Line 608: hr_lei_shd.g_old_rec.lei_information17;

604: hr_lei_shd.g_old_rec.lei_information16;
605: End If;
606: If (p_rec.lei_information17 = hr_api.g_varchar2) then
607: p_rec.lei_information17 :=
608: hr_lei_shd.g_old_rec.lei_information17;
609: End If;
610: If (p_rec.lei_information18 = hr_api.g_varchar2) then
611: p_rec.lei_information18 :=
612: hr_lei_shd.g_old_rec.lei_information18;

Line 612: hr_lei_shd.g_old_rec.lei_information18;

608: hr_lei_shd.g_old_rec.lei_information17;
609: End If;
610: If (p_rec.lei_information18 = hr_api.g_varchar2) then
611: p_rec.lei_information18 :=
612: hr_lei_shd.g_old_rec.lei_information18;
613: End If;
614: If (p_rec.lei_information19 = hr_api.g_varchar2) then
615: p_rec.lei_information19 :=
616: hr_lei_shd.g_old_rec.lei_information19;

Line 616: hr_lei_shd.g_old_rec.lei_information19;

612: hr_lei_shd.g_old_rec.lei_information18;
613: End If;
614: If (p_rec.lei_information19 = hr_api.g_varchar2) then
615: p_rec.lei_information19 :=
616: hr_lei_shd.g_old_rec.lei_information19;
617: End If;
618: If (p_rec.lei_information20 = hr_api.g_varchar2) then
619: p_rec.lei_information20 :=
620: hr_lei_shd.g_old_rec.lei_information20;

Line 620: hr_lei_shd.g_old_rec.lei_information20;

616: hr_lei_shd.g_old_rec.lei_information19;
617: End If;
618: If (p_rec.lei_information20 = hr_api.g_varchar2) then
619: p_rec.lei_information20 :=
620: hr_lei_shd.g_old_rec.lei_information20;
621: End If;
622: If (p_rec.lei_information21 = hr_api.g_varchar2) then
623: p_rec.lei_information21 :=
624: hr_lei_shd.g_old_rec.lei_information21;

Line 624: hr_lei_shd.g_old_rec.lei_information21;

620: hr_lei_shd.g_old_rec.lei_information20;
621: End If;
622: If (p_rec.lei_information21 = hr_api.g_varchar2) then
623: p_rec.lei_information21 :=
624: hr_lei_shd.g_old_rec.lei_information21;
625: End If;
626: If (p_rec.lei_information22 = hr_api.g_varchar2) then
627: p_rec.lei_information22 :=
628: hr_lei_shd.g_old_rec.lei_information22;

Line 628: hr_lei_shd.g_old_rec.lei_information22;

624: hr_lei_shd.g_old_rec.lei_information21;
625: End If;
626: If (p_rec.lei_information22 = hr_api.g_varchar2) then
627: p_rec.lei_information22 :=
628: hr_lei_shd.g_old_rec.lei_information22;
629: End If;
630: If (p_rec.lei_information23 = hr_api.g_varchar2) then
631: p_rec.lei_information23 :=
632: hr_lei_shd.g_old_rec.lei_information23;

Line 632: hr_lei_shd.g_old_rec.lei_information23;

628: hr_lei_shd.g_old_rec.lei_information22;
629: End If;
630: If (p_rec.lei_information23 = hr_api.g_varchar2) then
631: p_rec.lei_information23 :=
632: hr_lei_shd.g_old_rec.lei_information23;
633: End If;
634: If (p_rec.lei_information24 = hr_api.g_varchar2) then
635: p_rec.lei_information24 :=
636: hr_lei_shd.g_old_rec.lei_information24;

Line 636: hr_lei_shd.g_old_rec.lei_information24;

632: hr_lei_shd.g_old_rec.lei_information23;
633: End If;
634: If (p_rec.lei_information24 = hr_api.g_varchar2) then
635: p_rec.lei_information24 :=
636: hr_lei_shd.g_old_rec.lei_information24;
637: End If;
638: If (p_rec.lei_information25 = hr_api.g_varchar2) then
639: p_rec.lei_information25 :=
640: hr_lei_shd.g_old_rec.lei_information25;

Line 640: hr_lei_shd.g_old_rec.lei_information25;

636: hr_lei_shd.g_old_rec.lei_information24;
637: End If;
638: If (p_rec.lei_information25 = hr_api.g_varchar2) then
639: p_rec.lei_information25 :=
640: hr_lei_shd.g_old_rec.lei_information25;
641: End If;
642: If (p_rec.lei_information26 = hr_api.g_varchar2) then
643: p_rec.lei_information26 :=
644: hr_lei_shd.g_old_rec.lei_information26;

Line 644: hr_lei_shd.g_old_rec.lei_information26;

640: hr_lei_shd.g_old_rec.lei_information25;
641: End If;
642: If (p_rec.lei_information26 = hr_api.g_varchar2) then
643: p_rec.lei_information26 :=
644: hr_lei_shd.g_old_rec.lei_information26;
645: End If;
646: If (p_rec.lei_information27 = hr_api.g_varchar2) then
647: p_rec.lei_information27 :=
648: hr_lei_shd.g_old_rec.lei_information27;

Line 648: hr_lei_shd.g_old_rec.lei_information27;

644: hr_lei_shd.g_old_rec.lei_information26;
645: End If;
646: If (p_rec.lei_information27 = hr_api.g_varchar2) then
647: p_rec.lei_information27 :=
648: hr_lei_shd.g_old_rec.lei_information27;
649: End If;
650: If (p_rec.lei_information28 = hr_api.g_varchar2) then
651: p_rec.lei_information28 :=
652: hr_lei_shd.g_old_rec.lei_information28;

Line 652: hr_lei_shd.g_old_rec.lei_information28;

648: hr_lei_shd.g_old_rec.lei_information27;
649: End If;
650: If (p_rec.lei_information28 = hr_api.g_varchar2) then
651: p_rec.lei_information28 :=
652: hr_lei_shd.g_old_rec.lei_information28;
653: End If;
654: If (p_rec.lei_information29 = hr_api.g_varchar2) then
655: p_rec.lei_information29 :=
656: hr_lei_shd.g_old_rec.lei_information29;

Line 656: hr_lei_shd.g_old_rec.lei_information29;

652: hr_lei_shd.g_old_rec.lei_information28;
653: End If;
654: If (p_rec.lei_information29 = hr_api.g_varchar2) then
655: p_rec.lei_information29 :=
656: hr_lei_shd.g_old_rec.lei_information29;
657: End If;
658: If (p_rec.lei_information30 = hr_api.g_varchar2) then
659: p_rec.lei_information30 :=
660: hr_lei_shd.g_old_rec.lei_information30;

Line 660: hr_lei_shd.g_old_rec.lei_information30;

656: hr_lei_shd.g_old_rec.lei_information29;
657: End If;
658: If (p_rec.lei_information30 = hr_api.g_varchar2) then
659: p_rec.lei_information30 :=
660: hr_lei_shd.g_old_rec.lei_information30;
661: End If;
662:
663: --
664: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 673: p_rec in out nocopy hr_lei_shd.g_rec_type,

669: -- |---------------------------------< upd >----------------------------------|
670: -- ----------------------------------------------------------------------------
671: Procedure upd
672: (
673: p_rec in out nocopy hr_lei_shd.g_rec_type,
674: p_validate in boolean default false
675: ) is
676: --
677: l_proc varchar2(72) := g_package||'upd';

Line 693: hr_lei_shd.lck

689: End If;
690: --
691: -- We must lock the row which we need to update.
692: --
693: hr_lei_shd.lck
694: (
695: p_rec.location_extra_info_id,
696: p_rec.object_version_number
697: );

Line 804: l_rec hr_lei_shd.g_rec_type;

800: p_object_version_number in out nocopy number,
801: p_validate in boolean default false
802: ) is
803: --
804: l_rec hr_lei_shd.g_rec_type;
805: l_proc varchar2(72) := g_package||'upd';
806: --
807: Begin
808: hr_utility.set_location('Entering:'||l_proc, 5);

Line 814: hr_lei_shd.convert_args

810: -- Call conversion function to turn arguments into the
811: -- l_rec structure.
812: --
813: l_rec :=
814: hr_lei_shd.convert_args
815: (
816: p_location_extra_info_id,
817: p_information_type,
818: p_location_id,