[Home] [Help]
44: -- Internal Table Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy pe_aei_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
124: --
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: pe_aei_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
132: pe_aei_shd.constraint_error
128: pe_aei_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
132: pe_aei_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: pe_aei_shd.constraint_error
132: pe_aei_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: pe_aei_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When Others Then
139: Raise;
140: End update_dml;
170: -- Internal Table Handler Use Only.
171: --
172: -- {End Of Comments}
173: -- ----------------------------------------------------------------------------
174: Procedure pre_update(p_rec in pe_aei_shd.g_rec_type) is
175: --
176: l_proc varchar2(72) := g_package||'pre_update';
177: --
178: Begin
212: -- Internal Table Handler Use Only.
213: --
214: -- {End Of Comments}
215: -- ----------------------------------------------------------------------------
216: Procedure post_update(p_rec in pe_aei_shd.g_rec_type) is
217: --
218: l_proc varchar2(72) := g_package||'post_update';
219: --
220: Begin
282: p_aei_information27 => p_rec.aei_information27,
283: p_aei_information28 => p_rec.aei_information28,
284: p_aei_information29 => p_rec.aei_information29,
285: p_aei_information30 => p_rec.aei_information30,
286: p_assignment_id_o => pe_aei_shd.g_old_rec.assignment_id,
287: p_information_type_o => pe_aei_shd.g_old_rec.information_type,
288: p_request_id_o => pe_aei_shd.g_old_rec.request_id,
289: p_program_application_id_o => pe_aei_shd.g_old_rec.program_application_id,
290: p_program_id_o => pe_aei_shd.g_old_rec.program_id,
283: p_aei_information28 => p_rec.aei_information28,
284: p_aei_information29 => p_rec.aei_information29,
285: p_aei_information30 => p_rec.aei_information30,
286: p_assignment_id_o => pe_aei_shd.g_old_rec.assignment_id,
287: p_information_type_o => pe_aei_shd.g_old_rec.information_type,
288: p_request_id_o => pe_aei_shd.g_old_rec.request_id,
289: p_program_application_id_o => pe_aei_shd.g_old_rec.program_application_id,
290: p_program_id_o => pe_aei_shd.g_old_rec.program_id,
291: p_program_update_date_o => pe_aei_shd.g_old_rec.program_update_date,
284: p_aei_information29 => p_rec.aei_information29,
285: p_aei_information30 => p_rec.aei_information30,
286: p_assignment_id_o => pe_aei_shd.g_old_rec.assignment_id,
287: p_information_type_o => pe_aei_shd.g_old_rec.information_type,
288: p_request_id_o => pe_aei_shd.g_old_rec.request_id,
289: p_program_application_id_o => pe_aei_shd.g_old_rec.program_application_id,
290: p_program_id_o => pe_aei_shd.g_old_rec.program_id,
291: p_program_update_date_o => pe_aei_shd.g_old_rec.program_update_date,
292: p_aei_attribute_category_o => pe_aei_shd.g_old_rec.aei_attribute_category,
285: p_aei_information30 => p_rec.aei_information30,
286: p_assignment_id_o => pe_aei_shd.g_old_rec.assignment_id,
287: p_information_type_o => pe_aei_shd.g_old_rec.information_type,
288: p_request_id_o => pe_aei_shd.g_old_rec.request_id,
289: p_program_application_id_o => pe_aei_shd.g_old_rec.program_application_id,
290: p_program_id_o => pe_aei_shd.g_old_rec.program_id,
291: p_program_update_date_o => pe_aei_shd.g_old_rec.program_update_date,
292: p_aei_attribute_category_o => pe_aei_shd.g_old_rec.aei_attribute_category,
293: p_aei_attribute1_o => pe_aei_shd.g_old_rec.aei_attribute1,
286: p_assignment_id_o => pe_aei_shd.g_old_rec.assignment_id,
287: p_information_type_o => pe_aei_shd.g_old_rec.information_type,
288: p_request_id_o => pe_aei_shd.g_old_rec.request_id,
289: p_program_application_id_o => pe_aei_shd.g_old_rec.program_application_id,
290: p_program_id_o => pe_aei_shd.g_old_rec.program_id,
291: p_program_update_date_o => pe_aei_shd.g_old_rec.program_update_date,
292: p_aei_attribute_category_o => pe_aei_shd.g_old_rec.aei_attribute_category,
293: p_aei_attribute1_o => pe_aei_shd.g_old_rec.aei_attribute1,
294: p_aei_attribute2_o => pe_aei_shd.g_old_rec.aei_attribute2,
287: p_information_type_o => pe_aei_shd.g_old_rec.information_type,
288: p_request_id_o => pe_aei_shd.g_old_rec.request_id,
289: p_program_application_id_o => pe_aei_shd.g_old_rec.program_application_id,
290: p_program_id_o => pe_aei_shd.g_old_rec.program_id,
291: p_program_update_date_o => pe_aei_shd.g_old_rec.program_update_date,
292: p_aei_attribute_category_o => pe_aei_shd.g_old_rec.aei_attribute_category,
293: p_aei_attribute1_o => pe_aei_shd.g_old_rec.aei_attribute1,
294: p_aei_attribute2_o => pe_aei_shd.g_old_rec.aei_attribute2,
295: p_aei_attribute3_o => pe_aei_shd.g_old_rec.aei_attribute3,
288: p_request_id_o => pe_aei_shd.g_old_rec.request_id,
289: p_program_application_id_o => pe_aei_shd.g_old_rec.program_application_id,
290: p_program_id_o => pe_aei_shd.g_old_rec.program_id,
291: p_program_update_date_o => pe_aei_shd.g_old_rec.program_update_date,
292: p_aei_attribute_category_o => pe_aei_shd.g_old_rec.aei_attribute_category,
293: p_aei_attribute1_o => pe_aei_shd.g_old_rec.aei_attribute1,
294: p_aei_attribute2_o => pe_aei_shd.g_old_rec.aei_attribute2,
295: p_aei_attribute3_o => pe_aei_shd.g_old_rec.aei_attribute3,
296: p_aei_attribute4_o => pe_aei_shd.g_old_rec.aei_attribute4,
289: p_program_application_id_o => pe_aei_shd.g_old_rec.program_application_id,
290: p_program_id_o => pe_aei_shd.g_old_rec.program_id,
291: p_program_update_date_o => pe_aei_shd.g_old_rec.program_update_date,
292: p_aei_attribute_category_o => pe_aei_shd.g_old_rec.aei_attribute_category,
293: p_aei_attribute1_o => pe_aei_shd.g_old_rec.aei_attribute1,
294: p_aei_attribute2_o => pe_aei_shd.g_old_rec.aei_attribute2,
295: p_aei_attribute3_o => pe_aei_shd.g_old_rec.aei_attribute3,
296: p_aei_attribute4_o => pe_aei_shd.g_old_rec.aei_attribute4,
297: p_aei_attribute5_o => pe_aei_shd.g_old_rec.aei_attribute5,
290: p_program_id_o => pe_aei_shd.g_old_rec.program_id,
291: p_program_update_date_o => pe_aei_shd.g_old_rec.program_update_date,
292: p_aei_attribute_category_o => pe_aei_shd.g_old_rec.aei_attribute_category,
293: p_aei_attribute1_o => pe_aei_shd.g_old_rec.aei_attribute1,
294: p_aei_attribute2_o => pe_aei_shd.g_old_rec.aei_attribute2,
295: p_aei_attribute3_o => pe_aei_shd.g_old_rec.aei_attribute3,
296: p_aei_attribute4_o => pe_aei_shd.g_old_rec.aei_attribute4,
297: p_aei_attribute5_o => pe_aei_shd.g_old_rec.aei_attribute5,
298: p_aei_attribute6_o => pe_aei_shd.g_old_rec.aei_attribute6,
291: p_program_update_date_o => pe_aei_shd.g_old_rec.program_update_date,
292: p_aei_attribute_category_o => pe_aei_shd.g_old_rec.aei_attribute_category,
293: p_aei_attribute1_o => pe_aei_shd.g_old_rec.aei_attribute1,
294: p_aei_attribute2_o => pe_aei_shd.g_old_rec.aei_attribute2,
295: p_aei_attribute3_o => pe_aei_shd.g_old_rec.aei_attribute3,
296: p_aei_attribute4_o => pe_aei_shd.g_old_rec.aei_attribute4,
297: p_aei_attribute5_o => pe_aei_shd.g_old_rec.aei_attribute5,
298: p_aei_attribute6_o => pe_aei_shd.g_old_rec.aei_attribute6,
299: p_aei_attribute7_o => pe_aei_shd.g_old_rec.aei_attribute7,
292: p_aei_attribute_category_o => pe_aei_shd.g_old_rec.aei_attribute_category,
293: p_aei_attribute1_o => pe_aei_shd.g_old_rec.aei_attribute1,
294: p_aei_attribute2_o => pe_aei_shd.g_old_rec.aei_attribute2,
295: p_aei_attribute3_o => pe_aei_shd.g_old_rec.aei_attribute3,
296: p_aei_attribute4_o => pe_aei_shd.g_old_rec.aei_attribute4,
297: p_aei_attribute5_o => pe_aei_shd.g_old_rec.aei_attribute5,
298: p_aei_attribute6_o => pe_aei_shd.g_old_rec.aei_attribute6,
299: p_aei_attribute7_o => pe_aei_shd.g_old_rec.aei_attribute7,
300: p_aei_attribute8_o => pe_aei_shd.g_old_rec.aei_attribute8,
293: p_aei_attribute1_o => pe_aei_shd.g_old_rec.aei_attribute1,
294: p_aei_attribute2_o => pe_aei_shd.g_old_rec.aei_attribute2,
295: p_aei_attribute3_o => pe_aei_shd.g_old_rec.aei_attribute3,
296: p_aei_attribute4_o => pe_aei_shd.g_old_rec.aei_attribute4,
297: p_aei_attribute5_o => pe_aei_shd.g_old_rec.aei_attribute5,
298: p_aei_attribute6_o => pe_aei_shd.g_old_rec.aei_attribute6,
299: p_aei_attribute7_o => pe_aei_shd.g_old_rec.aei_attribute7,
300: p_aei_attribute8_o => pe_aei_shd.g_old_rec.aei_attribute8,
301: p_aei_attribute9_o => pe_aei_shd.g_old_rec.aei_attribute9,
294: p_aei_attribute2_o => pe_aei_shd.g_old_rec.aei_attribute2,
295: p_aei_attribute3_o => pe_aei_shd.g_old_rec.aei_attribute3,
296: p_aei_attribute4_o => pe_aei_shd.g_old_rec.aei_attribute4,
297: p_aei_attribute5_o => pe_aei_shd.g_old_rec.aei_attribute5,
298: p_aei_attribute6_o => pe_aei_shd.g_old_rec.aei_attribute6,
299: p_aei_attribute7_o => pe_aei_shd.g_old_rec.aei_attribute7,
300: p_aei_attribute8_o => pe_aei_shd.g_old_rec.aei_attribute8,
301: p_aei_attribute9_o => pe_aei_shd.g_old_rec.aei_attribute9,
302: p_aei_attribute10_o => pe_aei_shd.g_old_rec.aei_attribute10,
295: p_aei_attribute3_o => pe_aei_shd.g_old_rec.aei_attribute3,
296: p_aei_attribute4_o => pe_aei_shd.g_old_rec.aei_attribute4,
297: p_aei_attribute5_o => pe_aei_shd.g_old_rec.aei_attribute5,
298: p_aei_attribute6_o => pe_aei_shd.g_old_rec.aei_attribute6,
299: p_aei_attribute7_o => pe_aei_shd.g_old_rec.aei_attribute7,
300: p_aei_attribute8_o => pe_aei_shd.g_old_rec.aei_attribute8,
301: p_aei_attribute9_o => pe_aei_shd.g_old_rec.aei_attribute9,
302: p_aei_attribute10_o => pe_aei_shd.g_old_rec.aei_attribute10,
303: p_aei_attribute11_o => pe_aei_shd.g_old_rec.aei_attribute11,
296: p_aei_attribute4_o => pe_aei_shd.g_old_rec.aei_attribute4,
297: p_aei_attribute5_o => pe_aei_shd.g_old_rec.aei_attribute5,
298: p_aei_attribute6_o => pe_aei_shd.g_old_rec.aei_attribute6,
299: p_aei_attribute7_o => pe_aei_shd.g_old_rec.aei_attribute7,
300: p_aei_attribute8_o => pe_aei_shd.g_old_rec.aei_attribute8,
301: p_aei_attribute9_o => pe_aei_shd.g_old_rec.aei_attribute9,
302: p_aei_attribute10_o => pe_aei_shd.g_old_rec.aei_attribute10,
303: p_aei_attribute11_o => pe_aei_shd.g_old_rec.aei_attribute11,
304: p_aei_attribute12_o => pe_aei_shd.g_old_rec.aei_attribute12,
297: p_aei_attribute5_o => pe_aei_shd.g_old_rec.aei_attribute5,
298: p_aei_attribute6_o => pe_aei_shd.g_old_rec.aei_attribute6,
299: p_aei_attribute7_o => pe_aei_shd.g_old_rec.aei_attribute7,
300: p_aei_attribute8_o => pe_aei_shd.g_old_rec.aei_attribute8,
301: p_aei_attribute9_o => pe_aei_shd.g_old_rec.aei_attribute9,
302: p_aei_attribute10_o => pe_aei_shd.g_old_rec.aei_attribute10,
303: p_aei_attribute11_o => pe_aei_shd.g_old_rec.aei_attribute11,
304: p_aei_attribute12_o => pe_aei_shd.g_old_rec.aei_attribute12,
305: p_aei_attribute13_o => pe_aei_shd.g_old_rec.aei_attribute13,
298: p_aei_attribute6_o => pe_aei_shd.g_old_rec.aei_attribute6,
299: p_aei_attribute7_o => pe_aei_shd.g_old_rec.aei_attribute7,
300: p_aei_attribute8_o => pe_aei_shd.g_old_rec.aei_attribute8,
301: p_aei_attribute9_o => pe_aei_shd.g_old_rec.aei_attribute9,
302: p_aei_attribute10_o => pe_aei_shd.g_old_rec.aei_attribute10,
303: p_aei_attribute11_o => pe_aei_shd.g_old_rec.aei_attribute11,
304: p_aei_attribute12_o => pe_aei_shd.g_old_rec.aei_attribute12,
305: p_aei_attribute13_o => pe_aei_shd.g_old_rec.aei_attribute13,
306: p_aei_attribute14_o => pe_aei_shd.g_old_rec.aei_attribute14,
299: p_aei_attribute7_o => pe_aei_shd.g_old_rec.aei_attribute7,
300: p_aei_attribute8_o => pe_aei_shd.g_old_rec.aei_attribute8,
301: p_aei_attribute9_o => pe_aei_shd.g_old_rec.aei_attribute9,
302: p_aei_attribute10_o => pe_aei_shd.g_old_rec.aei_attribute10,
303: p_aei_attribute11_o => pe_aei_shd.g_old_rec.aei_attribute11,
304: p_aei_attribute12_o => pe_aei_shd.g_old_rec.aei_attribute12,
305: p_aei_attribute13_o => pe_aei_shd.g_old_rec.aei_attribute13,
306: p_aei_attribute14_o => pe_aei_shd.g_old_rec.aei_attribute14,
307: p_aei_attribute15_o => pe_aei_shd.g_old_rec.aei_attribute15,
300: p_aei_attribute8_o => pe_aei_shd.g_old_rec.aei_attribute8,
301: p_aei_attribute9_o => pe_aei_shd.g_old_rec.aei_attribute9,
302: p_aei_attribute10_o => pe_aei_shd.g_old_rec.aei_attribute10,
303: p_aei_attribute11_o => pe_aei_shd.g_old_rec.aei_attribute11,
304: p_aei_attribute12_o => pe_aei_shd.g_old_rec.aei_attribute12,
305: p_aei_attribute13_o => pe_aei_shd.g_old_rec.aei_attribute13,
306: p_aei_attribute14_o => pe_aei_shd.g_old_rec.aei_attribute14,
307: p_aei_attribute15_o => pe_aei_shd.g_old_rec.aei_attribute15,
308: p_aei_attribute16_o => pe_aei_shd.g_old_rec.aei_attribute16,
301: p_aei_attribute9_o => pe_aei_shd.g_old_rec.aei_attribute9,
302: p_aei_attribute10_o => pe_aei_shd.g_old_rec.aei_attribute10,
303: p_aei_attribute11_o => pe_aei_shd.g_old_rec.aei_attribute11,
304: p_aei_attribute12_o => pe_aei_shd.g_old_rec.aei_attribute12,
305: p_aei_attribute13_o => pe_aei_shd.g_old_rec.aei_attribute13,
306: p_aei_attribute14_o => pe_aei_shd.g_old_rec.aei_attribute14,
307: p_aei_attribute15_o => pe_aei_shd.g_old_rec.aei_attribute15,
308: p_aei_attribute16_o => pe_aei_shd.g_old_rec.aei_attribute16,
309: p_aei_attribute17_o => pe_aei_shd.g_old_rec.aei_attribute17,
302: p_aei_attribute10_o => pe_aei_shd.g_old_rec.aei_attribute10,
303: p_aei_attribute11_o => pe_aei_shd.g_old_rec.aei_attribute11,
304: p_aei_attribute12_o => pe_aei_shd.g_old_rec.aei_attribute12,
305: p_aei_attribute13_o => pe_aei_shd.g_old_rec.aei_attribute13,
306: p_aei_attribute14_o => pe_aei_shd.g_old_rec.aei_attribute14,
307: p_aei_attribute15_o => pe_aei_shd.g_old_rec.aei_attribute15,
308: p_aei_attribute16_o => pe_aei_shd.g_old_rec.aei_attribute16,
309: p_aei_attribute17_o => pe_aei_shd.g_old_rec.aei_attribute17,
310: p_aei_attribute18_o => pe_aei_shd.g_old_rec.aei_attribute18,
303: p_aei_attribute11_o => pe_aei_shd.g_old_rec.aei_attribute11,
304: p_aei_attribute12_o => pe_aei_shd.g_old_rec.aei_attribute12,
305: p_aei_attribute13_o => pe_aei_shd.g_old_rec.aei_attribute13,
306: p_aei_attribute14_o => pe_aei_shd.g_old_rec.aei_attribute14,
307: p_aei_attribute15_o => pe_aei_shd.g_old_rec.aei_attribute15,
308: p_aei_attribute16_o => pe_aei_shd.g_old_rec.aei_attribute16,
309: p_aei_attribute17_o => pe_aei_shd.g_old_rec.aei_attribute17,
310: p_aei_attribute18_o => pe_aei_shd.g_old_rec.aei_attribute18,
311: p_aei_attribute19_o => pe_aei_shd.g_old_rec.aei_attribute19,
304: p_aei_attribute12_o => pe_aei_shd.g_old_rec.aei_attribute12,
305: p_aei_attribute13_o => pe_aei_shd.g_old_rec.aei_attribute13,
306: p_aei_attribute14_o => pe_aei_shd.g_old_rec.aei_attribute14,
307: p_aei_attribute15_o => pe_aei_shd.g_old_rec.aei_attribute15,
308: p_aei_attribute16_o => pe_aei_shd.g_old_rec.aei_attribute16,
309: p_aei_attribute17_o => pe_aei_shd.g_old_rec.aei_attribute17,
310: p_aei_attribute18_o => pe_aei_shd.g_old_rec.aei_attribute18,
311: p_aei_attribute19_o => pe_aei_shd.g_old_rec.aei_attribute19,
312: p_aei_attribute20_o => pe_aei_shd.g_old_rec.aei_attribute20,
305: p_aei_attribute13_o => pe_aei_shd.g_old_rec.aei_attribute13,
306: p_aei_attribute14_o => pe_aei_shd.g_old_rec.aei_attribute14,
307: p_aei_attribute15_o => pe_aei_shd.g_old_rec.aei_attribute15,
308: p_aei_attribute16_o => pe_aei_shd.g_old_rec.aei_attribute16,
309: p_aei_attribute17_o => pe_aei_shd.g_old_rec.aei_attribute17,
310: p_aei_attribute18_o => pe_aei_shd.g_old_rec.aei_attribute18,
311: p_aei_attribute19_o => pe_aei_shd.g_old_rec.aei_attribute19,
312: p_aei_attribute20_o => pe_aei_shd.g_old_rec.aei_attribute20,
313: p_aei_information_category_o => pe_aei_shd.g_old_rec.aei_information_category,
306: p_aei_attribute14_o => pe_aei_shd.g_old_rec.aei_attribute14,
307: p_aei_attribute15_o => pe_aei_shd.g_old_rec.aei_attribute15,
308: p_aei_attribute16_o => pe_aei_shd.g_old_rec.aei_attribute16,
309: p_aei_attribute17_o => pe_aei_shd.g_old_rec.aei_attribute17,
310: p_aei_attribute18_o => pe_aei_shd.g_old_rec.aei_attribute18,
311: p_aei_attribute19_o => pe_aei_shd.g_old_rec.aei_attribute19,
312: p_aei_attribute20_o => pe_aei_shd.g_old_rec.aei_attribute20,
313: p_aei_information_category_o => pe_aei_shd.g_old_rec.aei_information_category,
314: p_aei_information1_o => pe_aei_shd.g_old_rec.aei_information1,
307: p_aei_attribute15_o => pe_aei_shd.g_old_rec.aei_attribute15,
308: p_aei_attribute16_o => pe_aei_shd.g_old_rec.aei_attribute16,
309: p_aei_attribute17_o => pe_aei_shd.g_old_rec.aei_attribute17,
310: p_aei_attribute18_o => pe_aei_shd.g_old_rec.aei_attribute18,
311: p_aei_attribute19_o => pe_aei_shd.g_old_rec.aei_attribute19,
312: p_aei_attribute20_o => pe_aei_shd.g_old_rec.aei_attribute20,
313: p_aei_information_category_o => pe_aei_shd.g_old_rec.aei_information_category,
314: p_aei_information1_o => pe_aei_shd.g_old_rec.aei_information1,
315: p_aei_information2_o => pe_aei_shd.g_old_rec.aei_information2,
308: p_aei_attribute16_o => pe_aei_shd.g_old_rec.aei_attribute16,
309: p_aei_attribute17_o => pe_aei_shd.g_old_rec.aei_attribute17,
310: p_aei_attribute18_o => pe_aei_shd.g_old_rec.aei_attribute18,
311: p_aei_attribute19_o => pe_aei_shd.g_old_rec.aei_attribute19,
312: p_aei_attribute20_o => pe_aei_shd.g_old_rec.aei_attribute20,
313: p_aei_information_category_o => pe_aei_shd.g_old_rec.aei_information_category,
314: p_aei_information1_o => pe_aei_shd.g_old_rec.aei_information1,
315: p_aei_information2_o => pe_aei_shd.g_old_rec.aei_information2,
316: p_aei_information3_o => pe_aei_shd.g_old_rec.aei_information3,
309: p_aei_attribute17_o => pe_aei_shd.g_old_rec.aei_attribute17,
310: p_aei_attribute18_o => pe_aei_shd.g_old_rec.aei_attribute18,
311: p_aei_attribute19_o => pe_aei_shd.g_old_rec.aei_attribute19,
312: p_aei_attribute20_o => pe_aei_shd.g_old_rec.aei_attribute20,
313: p_aei_information_category_o => pe_aei_shd.g_old_rec.aei_information_category,
314: p_aei_information1_o => pe_aei_shd.g_old_rec.aei_information1,
315: p_aei_information2_o => pe_aei_shd.g_old_rec.aei_information2,
316: p_aei_information3_o => pe_aei_shd.g_old_rec.aei_information3,
317: p_aei_information4_o => pe_aei_shd.g_old_rec.aei_information4,
310: p_aei_attribute18_o => pe_aei_shd.g_old_rec.aei_attribute18,
311: p_aei_attribute19_o => pe_aei_shd.g_old_rec.aei_attribute19,
312: p_aei_attribute20_o => pe_aei_shd.g_old_rec.aei_attribute20,
313: p_aei_information_category_o => pe_aei_shd.g_old_rec.aei_information_category,
314: p_aei_information1_o => pe_aei_shd.g_old_rec.aei_information1,
315: p_aei_information2_o => pe_aei_shd.g_old_rec.aei_information2,
316: p_aei_information3_o => pe_aei_shd.g_old_rec.aei_information3,
317: p_aei_information4_o => pe_aei_shd.g_old_rec.aei_information4,
318: p_aei_information5_o => pe_aei_shd.g_old_rec.aei_information5,
311: p_aei_attribute19_o => pe_aei_shd.g_old_rec.aei_attribute19,
312: p_aei_attribute20_o => pe_aei_shd.g_old_rec.aei_attribute20,
313: p_aei_information_category_o => pe_aei_shd.g_old_rec.aei_information_category,
314: p_aei_information1_o => pe_aei_shd.g_old_rec.aei_information1,
315: p_aei_information2_o => pe_aei_shd.g_old_rec.aei_information2,
316: p_aei_information3_o => pe_aei_shd.g_old_rec.aei_information3,
317: p_aei_information4_o => pe_aei_shd.g_old_rec.aei_information4,
318: p_aei_information5_o => pe_aei_shd.g_old_rec.aei_information5,
319: p_aei_information6_o => pe_aei_shd.g_old_rec.aei_information6,
312: p_aei_attribute20_o => pe_aei_shd.g_old_rec.aei_attribute20,
313: p_aei_information_category_o => pe_aei_shd.g_old_rec.aei_information_category,
314: p_aei_information1_o => pe_aei_shd.g_old_rec.aei_information1,
315: p_aei_information2_o => pe_aei_shd.g_old_rec.aei_information2,
316: p_aei_information3_o => pe_aei_shd.g_old_rec.aei_information3,
317: p_aei_information4_o => pe_aei_shd.g_old_rec.aei_information4,
318: p_aei_information5_o => pe_aei_shd.g_old_rec.aei_information5,
319: p_aei_information6_o => pe_aei_shd.g_old_rec.aei_information6,
320: p_aei_information7_o => pe_aei_shd.g_old_rec.aei_information7,
313: p_aei_information_category_o => pe_aei_shd.g_old_rec.aei_information_category,
314: p_aei_information1_o => pe_aei_shd.g_old_rec.aei_information1,
315: p_aei_information2_o => pe_aei_shd.g_old_rec.aei_information2,
316: p_aei_information3_o => pe_aei_shd.g_old_rec.aei_information3,
317: p_aei_information4_o => pe_aei_shd.g_old_rec.aei_information4,
318: p_aei_information5_o => pe_aei_shd.g_old_rec.aei_information5,
319: p_aei_information6_o => pe_aei_shd.g_old_rec.aei_information6,
320: p_aei_information7_o => pe_aei_shd.g_old_rec.aei_information7,
321: p_aei_information8_o => pe_aei_shd.g_old_rec.aei_information8,
314: p_aei_information1_o => pe_aei_shd.g_old_rec.aei_information1,
315: p_aei_information2_o => pe_aei_shd.g_old_rec.aei_information2,
316: p_aei_information3_o => pe_aei_shd.g_old_rec.aei_information3,
317: p_aei_information4_o => pe_aei_shd.g_old_rec.aei_information4,
318: p_aei_information5_o => pe_aei_shd.g_old_rec.aei_information5,
319: p_aei_information6_o => pe_aei_shd.g_old_rec.aei_information6,
320: p_aei_information7_o => pe_aei_shd.g_old_rec.aei_information7,
321: p_aei_information8_o => pe_aei_shd.g_old_rec.aei_information8,
322: p_aei_information9_o => pe_aei_shd.g_old_rec.aei_information9,
315: p_aei_information2_o => pe_aei_shd.g_old_rec.aei_information2,
316: p_aei_information3_o => pe_aei_shd.g_old_rec.aei_information3,
317: p_aei_information4_o => pe_aei_shd.g_old_rec.aei_information4,
318: p_aei_information5_o => pe_aei_shd.g_old_rec.aei_information5,
319: p_aei_information6_o => pe_aei_shd.g_old_rec.aei_information6,
320: p_aei_information7_o => pe_aei_shd.g_old_rec.aei_information7,
321: p_aei_information8_o => pe_aei_shd.g_old_rec.aei_information8,
322: p_aei_information9_o => pe_aei_shd.g_old_rec.aei_information9,
323: p_aei_information10_o => pe_aei_shd.g_old_rec.aei_information10,
316: p_aei_information3_o => pe_aei_shd.g_old_rec.aei_information3,
317: p_aei_information4_o => pe_aei_shd.g_old_rec.aei_information4,
318: p_aei_information5_o => pe_aei_shd.g_old_rec.aei_information5,
319: p_aei_information6_o => pe_aei_shd.g_old_rec.aei_information6,
320: p_aei_information7_o => pe_aei_shd.g_old_rec.aei_information7,
321: p_aei_information8_o => pe_aei_shd.g_old_rec.aei_information8,
322: p_aei_information9_o => pe_aei_shd.g_old_rec.aei_information9,
323: p_aei_information10_o => pe_aei_shd.g_old_rec.aei_information10,
324: p_aei_information11_o => pe_aei_shd.g_old_rec.aei_information11,
317: p_aei_information4_o => pe_aei_shd.g_old_rec.aei_information4,
318: p_aei_information5_o => pe_aei_shd.g_old_rec.aei_information5,
319: p_aei_information6_o => pe_aei_shd.g_old_rec.aei_information6,
320: p_aei_information7_o => pe_aei_shd.g_old_rec.aei_information7,
321: p_aei_information8_o => pe_aei_shd.g_old_rec.aei_information8,
322: p_aei_information9_o => pe_aei_shd.g_old_rec.aei_information9,
323: p_aei_information10_o => pe_aei_shd.g_old_rec.aei_information10,
324: p_aei_information11_o => pe_aei_shd.g_old_rec.aei_information11,
325: p_aei_information12_o => pe_aei_shd.g_old_rec.aei_information12,
318: p_aei_information5_o => pe_aei_shd.g_old_rec.aei_information5,
319: p_aei_information6_o => pe_aei_shd.g_old_rec.aei_information6,
320: p_aei_information7_o => pe_aei_shd.g_old_rec.aei_information7,
321: p_aei_information8_o => pe_aei_shd.g_old_rec.aei_information8,
322: p_aei_information9_o => pe_aei_shd.g_old_rec.aei_information9,
323: p_aei_information10_o => pe_aei_shd.g_old_rec.aei_information10,
324: p_aei_information11_o => pe_aei_shd.g_old_rec.aei_information11,
325: p_aei_information12_o => pe_aei_shd.g_old_rec.aei_information12,
326: p_aei_information13_o => pe_aei_shd.g_old_rec.aei_information13,
319: p_aei_information6_o => pe_aei_shd.g_old_rec.aei_information6,
320: p_aei_information7_o => pe_aei_shd.g_old_rec.aei_information7,
321: p_aei_information8_o => pe_aei_shd.g_old_rec.aei_information8,
322: p_aei_information9_o => pe_aei_shd.g_old_rec.aei_information9,
323: p_aei_information10_o => pe_aei_shd.g_old_rec.aei_information10,
324: p_aei_information11_o => pe_aei_shd.g_old_rec.aei_information11,
325: p_aei_information12_o => pe_aei_shd.g_old_rec.aei_information12,
326: p_aei_information13_o => pe_aei_shd.g_old_rec.aei_information13,
327: p_aei_information14_o => pe_aei_shd.g_old_rec.aei_information14,
320: p_aei_information7_o => pe_aei_shd.g_old_rec.aei_information7,
321: p_aei_information8_o => pe_aei_shd.g_old_rec.aei_information8,
322: p_aei_information9_o => pe_aei_shd.g_old_rec.aei_information9,
323: p_aei_information10_o => pe_aei_shd.g_old_rec.aei_information10,
324: p_aei_information11_o => pe_aei_shd.g_old_rec.aei_information11,
325: p_aei_information12_o => pe_aei_shd.g_old_rec.aei_information12,
326: p_aei_information13_o => pe_aei_shd.g_old_rec.aei_information13,
327: p_aei_information14_o => pe_aei_shd.g_old_rec.aei_information14,
328: p_aei_information15_o => pe_aei_shd.g_old_rec.aei_information15,
321: p_aei_information8_o => pe_aei_shd.g_old_rec.aei_information8,
322: p_aei_information9_o => pe_aei_shd.g_old_rec.aei_information9,
323: p_aei_information10_o => pe_aei_shd.g_old_rec.aei_information10,
324: p_aei_information11_o => pe_aei_shd.g_old_rec.aei_information11,
325: p_aei_information12_o => pe_aei_shd.g_old_rec.aei_information12,
326: p_aei_information13_o => pe_aei_shd.g_old_rec.aei_information13,
327: p_aei_information14_o => pe_aei_shd.g_old_rec.aei_information14,
328: p_aei_information15_o => pe_aei_shd.g_old_rec.aei_information15,
329: p_aei_information16_o => pe_aei_shd.g_old_rec.aei_information16,
322: p_aei_information9_o => pe_aei_shd.g_old_rec.aei_information9,
323: p_aei_information10_o => pe_aei_shd.g_old_rec.aei_information10,
324: p_aei_information11_o => pe_aei_shd.g_old_rec.aei_information11,
325: p_aei_information12_o => pe_aei_shd.g_old_rec.aei_information12,
326: p_aei_information13_o => pe_aei_shd.g_old_rec.aei_information13,
327: p_aei_information14_o => pe_aei_shd.g_old_rec.aei_information14,
328: p_aei_information15_o => pe_aei_shd.g_old_rec.aei_information15,
329: p_aei_information16_o => pe_aei_shd.g_old_rec.aei_information16,
330: p_aei_information17_o => pe_aei_shd.g_old_rec.aei_information17,
323: p_aei_information10_o => pe_aei_shd.g_old_rec.aei_information10,
324: p_aei_information11_o => pe_aei_shd.g_old_rec.aei_information11,
325: p_aei_information12_o => pe_aei_shd.g_old_rec.aei_information12,
326: p_aei_information13_o => pe_aei_shd.g_old_rec.aei_information13,
327: p_aei_information14_o => pe_aei_shd.g_old_rec.aei_information14,
328: p_aei_information15_o => pe_aei_shd.g_old_rec.aei_information15,
329: p_aei_information16_o => pe_aei_shd.g_old_rec.aei_information16,
330: p_aei_information17_o => pe_aei_shd.g_old_rec.aei_information17,
331: p_aei_information18_o => pe_aei_shd.g_old_rec.aei_information18,
324: p_aei_information11_o => pe_aei_shd.g_old_rec.aei_information11,
325: p_aei_information12_o => pe_aei_shd.g_old_rec.aei_information12,
326: p_aei_information13_o => pe_aei_shd.g_old_rec.aei_information13,
327: p_aei_information14_o => pe_aei_shd.g_old_rec.aei_information14,
328: p_aei_information15_o => pe_aei_shd.g_old_rec.aei_information15,
329: p_aei_information16_o => pe_aei_shd.g_old_rec.aei_information16,
330: p_aei_information17_o => pe_aei_shd.g_old_rec.aei_information17,
331: p_aei_information18_o => pe_aei_shd.g_old_rec.aei_information18,
332: p_aei_information19_o => pe_aei_shd.g_old_rec.aei_information19,
325: p_aei_information12_o => pe_aei_shd.g_old_rec.aei_information12,
326: p_aei_information13_o => pe_aei_shd.g_old_rec.aei_information13,
327: p_aei_information14_o => pe_aei_shd.g_old_rec.aei_information14,
328: p_aei_information15_o => pe_aei_shd.g_old_rec.aei_information15,
329: p_aei_information16_o => pe_aei_shd.g_old_rec.aei_information16,
330: p_aei_information17_o => pe_aei_shd.g_old_rec.aei_information17,
331: p_aei_information18_o => pe_aei_shd.g_old_rec.aei_information18,
332: p_aei_information19_o => pe_aei_shd.g_old_rec.aei_information19,
333: p_aei_information20_o => pe_aei_shd.g_old_rec.aei_information20,
326: p_aei_information13_o => pe_aei_shd.g_old_rec.aei_information13,
327: p_aei_information14_o => pe_aei_shd.g_old_rec.aei_information14,
328: p_aei_information15_o => pe_aei_shd.g_old_rec.aei_information15,
329: p_aei_information16_o => pe_aei_shd.g_old_rec.aei_information16,
330: p_aei_information17_o => pe_aei_shd.g_old_rec.aei_information17,
331: p_aei_information18_o => pe_aei_shd.g_old_rec.aei_information18,
332: p_aei_information19_o => pe_aei_shd.g_old_rec.aei_information19,
333: p_aei_information20_o => pe_aei_shd.g_old_rec.aei_information20,
334: p_aei_information21_o => pe_aei_shd.g_old_rec.aei_information21,
327: p_aei_information14_o => pe_aei_shd.g_old_rec.aei_information14,
328: p_aei_information15_o => pe_aei_shd.g_old_rec.aei_information15,
329: p_aei_information16_o => pe_aei_shd.g_old_rec.aei_information16,
330: p_aei_information17_o => pe_aei_shd.g_old_rec.aei_information17,
331: p_aei_information18_o => pe_aei_shd.g_old_rec.aei_information18,
332: p_aei_information19_o => pe_aei_shd.g_old_rec.aei_information19,
333: p_aei_information20_o => pe_aei_shd.g_old_rec.aei_information20,
334: p_aei_information21_o => pe_aei_shd.g_old_rec.aei_information21,
335: p_aei_information22_o => pe_aei_shd.g_old_rec.aei_information22,
328: p_aei_information15_o => pe_aei_shd.g_old_rec.aei_information15,
329: p_aei_information16_o => pe_aei_shd.g_old_rec.aei_information16,
330: p_aei_information17_o => pe_aei_shd.g_old_rec.aei_information17,
331: p_aei_information18_o => pe_aei_shd.g_old_rec.aei_information18,
332: p_aei_information19_o => pe_aei_shd.g_old_rec.aei_information19,
333: p_aei_information20_o => pe_aei_shd.g_old_rec.aei_information20,
334: p_aei_information21_o => pe_aei_shd.g_old_rec.aei_information21,
335: p_aei_information22_o => pe_aei_shd.g_old_rec.aei_information22,
336: p_aei_information23_o => pe_aei_shd.g_old_rec.aei_information23,
329: p_aei_information16_o => pe_aei_shd.g_old_rec.aei_information16,
330: p_aei_information17_o => pe_aei_shd.g_old_rec.aei_information17,
331: p_aei_information18_o => pe_aei_shd.g_old_rec.aei_information18,
332: p_aei_information19_o => pe_aei_shd.g_old_rec.aei_information19,
333: p_aei_information20_o => pe_aei_shd.g_old_rec.aei_information20,
334: p_aei_information21_o => pe_aei_shd.g_old_rec.aei_information21,
335: p_aei_information22_o => pe_aei_shd.g_old_rec.aei_information22,
336: p_aei_information23_o => pe_aei_shd.g_old_rec.aei_information23,
337: p_aei_information24_o => pe_aei_shd.g_old_rec.aei_information24,
330: p_aei_information17_o => pe_aei_shd.g_old_rec.aei_information17,
331: p_aei_information18_o => pe_aei_shd.g_old_rec.aei_information18,
332: p_aei_information19_o => pe_aei_shd.g_old_rec.aei_information19,
333: p_aei_information20_o => pe_aei_shd.g_old_rec.aei_information20,
334: p_aei_information21_o => pe_aei_shd.g_old_rec.aei_information21,
335: p_aei_information22_o => pe_aei_shd.g_old_rec.aei_information22,
336: p_aei_information23_o => pe_aei_shd.g_old_rec.aei_information23,
337: p_aei_information24_o => pe_aei_shd.g_old_rec.aei_information24,
338: p_aei_information25_o => pe_aei_shd.g_old_rec.aei_information25,
331: p_aei_information18_o => pe_aei_shd.g_old_rec.aei_information18,
332: p_aei_information19_o => pe_aei_shd.g_old_rec.aei_information19,
333: p_aei_information20_o => pe_aei_shd.g_old_rec.aei_information20,
334: p_aei_information21_o => pe_aei_shd.g_old_rec.aei_information21,
335: p_aei_information22_o => pe_aei_shd.g_old_rec.aei_information22,
336: p_aei_information23_o => pe_aei_shd.g_old_rec.aei_information23,
337: p_aei_information24_o => pe_aei_shd.g_old_rec.aei_information24,
338: p_aei_information25_o => pe_aei_shd.g_old_rec.aei_information25,
339: p_aei_information26_o => pe_aei_shd.g_old_rec.aei_information26,
332: p_aei_information19_o => pe_aei_shd.g_old_rec.aei_information19,
333: p_aei_information20_o => pe_aei_shd.g_old_rec.aei_information20,
334: p_aei_information21_o => pe_aei_shd.g_old_rec.aei_information21,
335: p_aei_information22_o => pe_aei_shd.g_old_rec.aei_information22,
336: p_aei_information23_o => pe_aei_shd.g_old_rec.aei_information23,
337: p_aei_information24_o => pe_aei_shd.g_old_rec.aei_information24,
338: p_aei_information25_o => pe_aei_shd.g_old_rec.aei_information25,
339: p_aei_information26_o => pe_aei_shd.g_old_rec.aei_information26,
340: p_aei_information27_o => pe_aei_shd.g_old_rec.aei_information27,
333: p_aei_information20_o => pe_aei_shd.g_old_rec.aei_information20,
334: p_aei_information21_o => pe_aei_shd.g_old_rec.aei_information21,
335: p_aei_information22_o => pe_aei_shd.g_old_rec.aei_information22,
336: p_aei_information23_o => pe_aei_shd.g_old_rec.aei_information23,
337: p_aei_information24_o => pe_aei_shd.g_old_rec.aei_information24,
338: p_aei_information25_o => pe_aei_shd.g_old_rec.aei_information25,
339: p_aei_information26_o => pe_aei_shd.g_old_rec.aei_information26,
340: p_aei_information27_o => pe_aei_shd.g_old_rec.aei_information27,
341: p_aei_information28_o => pe_aei_shd.g_old_rec.aei_information28,
334: p_aei_information21_o => pe_aei_shd.g_old_rec.aei_information21,
335: p_aei_information22_o => pe_aei_shd.g_old_rec.aei_information22,
336: p_aei_information23_o => pe_aei_shd.g_old_rec.aei_information23,
337: p_aei_information24_o => pe_aei_shd.g_old_rec.aei_information24,
338: p_aei_information25_o => pe_aei_shd.g_old_rec.aei_information25,
339: p_aei_information26_o => pe_aei_shd.g_old_rec.aei_information26,
340: p_aei_information27_o => pe_aei_shd.g_old_rec.aei_information27,
341: p_aei_information28_o => pe_aei_shd.g_old_rec.aei_information28,
342: p_aei_information29_o => pe_aei_shd.g_old_rec.aei_information29,
335: p_aei_information22_o => pe_aei_shd.g_old_rec.aei_information22,
336: p_aei_information23_o => pe_aei_shd.g_old_rec.aei_information23,
337: p_aei_information24_o => pe_aei_shd.g_old_rec.aei_information24,
338: p_aei_information25_o => pe_aei_shd.g_old_rec.aei_information25,
339: p_aei_information26_o => pe_aei_shd.g_old_rec.aei_information26,
340: p_aei_information27_o => pe_aei_shd.g_old_rec.aei_information27,
341: p_aei_information28_o => pe_aei_shd.g_old_rec.aei_information28,
342: p_aei_information29_o => pe_aei_shd.g_old_rec.aei_information29,
343: p_aei_information30_o => pe_aei_shd.g_old_rec.aei_information30
336: p_aei_information23_o => pe_aei_shd.g_old_rec.aei_information23,
337: p_aei_information24_o => pe_aei_shd.g_old_rec.aei_information24,
338: p_aei_information25_o => pe_aei_shd.g_old_rec.aei_information25,
339: p_aei_information26_o => pe_aei_shd.g_old_rec.aei_information26,
340: p_aei_information27_o => pe_aei_shd.g_old_rec.aei_information27,
341: p_aei_information28_o => pe_aei_shd.g_old_rec.aei_information28,
342: p_aei_information29_o => pe_aei_shd.g_old_rec.aei_information29,
343: p_aei_information30_o => pe_aei_shd.g_old_rec.aei_information30
344: );
337: p_aei_information24_o => pe_aei_shd.g_old_rec.aei_information24,
338: p_aei_information25_o => pe_aei_shd.g_old_rec.aei_information25,
339: p_aei_information26_o => pe_aei_shd.g_old_rec.aei_information26,
340: p_aei_information27_o => pe_aei_shd.g_old_rec.aei_information27,
341: p_aei_information28_o => pe_aei_shd.g_old_rec.aei_information28,
342: p_aei_information29_o => pe_aei_shd.g_old_rec.aei_information29,
343: p_aei_information30_o => pe_aei_shd.g_old_rec.aei_information30
344: );
345: exception
338: p_aei_information25_o => pe_aei_shd.g_old_rec.aei_information25,
339: p_aei_information26_o => pe_aei_shd.g_old_rec.aei_information26,
340: p_aei_information27_o => pe_aei_shd.g_old_rec.aei_information27,
341: p_aei_information28_o => pe_aei_shd.g_old_rec.aei_information28,
342: p_aei_information29_o => pe_aei_shd.g_old_rec.aei_information29,
343: p_aei_information30_o => pe_aei_shd.g_old_rec.aei_information30
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
339: p_aei_information26_o => pe_aei_shd.g_old_rec.aei_information26,
340: p_aei_information27_o => pe_aei_shd.g_old_rec.aei_information27,
341: p_aei_information28_o => pe_aei_shd.g_old_rec.aei_information28,
342: p_aei_information29_o => pe_aei_shd.g_old_rec.aei_information29,
343: p_aei_information30_o => pe_aei_shd.g_old_rec.aei_information30
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
347: hr_api.cannot_find_prog_unit_error
397: -- Internal Table Handler Use Only.
398: --
399: -- {End Of Comments}
400: -- ----------------------------------------------------------------------------
401: Procedure convert_defs(p_rec in out nocopy pe_aei_shd.g_rec_type) is
402: --
403: l_proc varchar2(72) := g_package||'convert_defs';
404: --
405: Begin
412: -- is being used then we must set to the 'current' argument value.
413: --
414: If (p_rec.assignment_id = hr_api.g_number) then
415: p_rec.assignment_id :=
416: pe_aei_shd.g_old_rec.assignment_id;
417: End If;
418: If (p_rec.information_type = hr_api.g_varchar2) then
419: p_rec.information_type :=
420: pe_aei_shd.g_old_rec.information_type;
416: pe_aei_shd.g_old_rec.assignment_id;
417: End If;
418: If (p_rec.information_type = hr_api.g_varchar2) then
419: p_rec.information_type :=
420: pe_aei_shd.g_old_rec.information_type;
421: End If;
422: If (p_rec.request_id = hr_api.g_number) then
423: p_rec.request_id :=
424: pe_aei_shd.g_old_rec.request_id;
420: pe_aei_shd.g_old_rec.information_type;
421: End If;
422: If (p_rec.request_id = hr_api.g_number) then
423: p_rec.request_id :=
424: pe_aei_shd.g_old_rec.request_id;
425: End If;
426: If (p_rec.program_application_id = hr_api.g_number) then
427: p_rec.program_application_id :=
428: pe_aei_shd.g_old_rec.program_application_id;
424: pe_aei_shd.g_old_rec.request_id;
425: End If;
426: If (p_rec.program_application_id = hr_api.g_number) then
427: p_rec.program_application_id :=
428: pe_aei_shd.g_old_rec.program_application_id;
429: End If;
430: If (p_rec.program_id = hr_api.g_number) then
431: p_rec.program_id :=
432: pe_aei_shd.g_old_rec.program_id;
428: pe_aei_shd.g_old_rec.program_application_id;
429: End If;
430: If (p_rec.program_id = hr_api.g_number) then
431: p_rec.program_id :=
432: pe_aei_shd.g_old_rec.program_id;
433: End If;
434: If (p_rec.program_update_date = hr_api.g_date) then
435: p_rec.program_update_date :=
436: pe_aei_shd.g_old_rec.program_update_date;
432: pe_aei_shd.g_old_rec.program_id;
433: End If;
434: If (p_rec.program_update_date = hr_api.g_date) then
435: p_rec.program_update_date :=
436: pe_aei_shd.g_old_rec.program_update_date;
437: End If;
438: If (p_rec.aei_attribute_category = hr_api.g_varchar2) then
439: p_rec.aei_attribute_category :=
440: pe_aei_shd.g_old_rec.aei_attribute_category;
436: pe_aei_shd.g_old_rec.program_update_date;
437: End If;
438: If (p_rec.aei_attribute_category = hr_api.g_varchar2) then
439: p_rec.aei_attribute_category :=
440: pe_aei_shd.g_old_rec.aei_attribute_category;
441: End If;
442: If (p_rec.aei_attribute1 = hr_api.g_varchar2) then
443: p_rec.aei_attribute1 :=
444: pe_aei_shd.g_old_rec.aei_attribute1;
440: pe_aei_shd.g_old_rec.aei_attribute_category;
441: End If;
442: If (p_rec.aei_attribute1 = hr_api.g_varchar2) then
443: p_rec.aei_attribute1 :=
444: pe_aei_shd.g_old_rec.aei_attribute1;
445: End If;
446: If (p_rec.aei_attribute2 = hr_api.g_varchar2) then
447: p_rec.aei_attribute2 :=
448: pe_aei_shd.g_old_rec.aei_attribute2;
444: pe_aei_shd.g_old_rec.aei_attribute1;
445: End If;
446: If (p_rec.aei_attribute2 = hr_api.g_varchar2) then
447: p_rec.aei_attribute2 :=
448: pe_aei_shd.g_old_rec.aei_attribute2;
449: End If;
450: If (p_rec.aei_attribute3 = hr_api.g_varchar2) then
451: p_rec.aei_attribute3 :=
452: pe_aei_shd.g_old_rec.aei_attribute3;
448: pe_aei_shd.g_old_rec.aei_attribute2;
449: End If;
450: If (p_rec.aei_attribute3 = hr_api.g_varchar2) then
451: p_rec.aei_attribute3 :=
452: pe_aei_shd.g_old_rec.aei_attribute3;
453: End If;
454: If (p_rec.aei_attribute4 = hr_api.g_varchar2) then
455: p_rec.aei_attribute4 :=
456: pe_aei_shd.g_old_rec.aei_attribute4;
452: pe_aei_shd.g_old_rec.aei_attribute3;
453: End If;
454: If (p_rec.aei_attribute4 = hr_api.g_varchar2) then
455: p_rec.aei_attribute4 :=
456: pe_aei_shd.g_old_rec.aei_attribute4;
457: End If;
458: If (p_rec.aei_attribute5 = hr_api.g_varchar2) then
459: p_rec.aei_attribute5 :=
460: pe_aei_shd.g_old_rec.aei_attribute5;
456: pe_aei_shd.g_old_rec.aei_attribute4;
457: End If;
458: If (p_rec.aei_attribute5 = hr_api.g_varchar2) then
459: p_rec.aei_attribute5 :=
460: pe_aei_shd.g_old_rec.aei_attribute5;
461: End If;
462: If (p_rec.aei_attribute6 = hr_api.g_varchar2) then
463: p_rec.aei_attribute6 :=
464: pe_aei_shd.g_old_rec.aei_attribute6;
460: pe_aei_shd.g_old_rec.aei_attribute5;
461: End If;
462: If (p_rec.aei_attribute6 = hr_api.g_varchar2) then
463: p_rec.aei_attribute6 :=
464: pe_aei_shd.g_old_rec.aei_attribute6;
465: End If;
466: If (p_rec.aei_attribute7 = hr_api.g_varchar2) then
467: p_rec.aei_attribute7 :=
468: pe_aei_shd.g_old_rec.aei_attribute7;
464: pe_aei_shd.g_old_rec.aei_attribute6;
465: End If;
466: If (p_rec.aei_attribute7 = hr_api.g_varchar2) then
467: p_rec.aei_attribute7 :=
468: pe_aei_shd.g_old_rec.aei_attribute7;
469: End If;
470: If (p_rec.aei_attribute8 = hr_api.g_varchar2) then
471: p_rec.aei_attribute8 :=
472: pe_aei_shd.g_old_rec.aei_attribute8;
468: pe_aei_shd.g_old_rec.aei_attribute7;
469: End If;
470: If (p_rec.aei_attribute8 = hr_api.g_varchar2) then
471: p_rec.aei_attribute8 :=
472: pe_aei_shd.g_old_rec.aei_attribute8;
473: End If;
474: If (p_rec.aei_attribute9 = hr_api.g_varchar2) then
475: p_rec.aei_attribute9 :=
476: pe_aei_shd.g_old_rec.aei_attribute9;
472: pe_aei_shd.g_old_rec.aei_attribute8;
473: End If;
474: If (p_rec.aei_attribute9 = hr_api.g_varchar2) then
475: p_rec.aei_attribute9 :=
476: pe_aei_shd.g_old_rec.aei_attribute9;
477: End If;
478: If (p_rec.aei_attribute10 = hr_api.g_varchar2) then
479: p_rec.aei_attribute10 :=
480: pe_aei_shd.g_old_rec.aei_attribute10;
476: pe_aei_shd.g_old_rec.aei_attribute9;
477: End If;
478: If (p_rec.aei_attribute10 = hr_api.g_varchar2) then
479: p_rec.aei_attribute10 :=
480: pe_aei_shd.g_old_rec.aei_attribute10;
481: End If;
482: If (p_rec.aei_attribute11 = hr_api.g_varchar2) then
483: p_rec.aei_attribute11 :=
484: pe_aei_shd.g_old_rec.aei_attribute11;
480: pe_aei_shd.g_old_rec.aei_attribute10;
481: End If;
482: If (p_rec.aei_attribute11 = hr_api.g_varchar2) then
483: p_rec.aei_attribute11 :=
484: pe_aei_shd.g_old_rec.aei_attribute11;
485: End If;
486: If (p_rec.aei_attribute12 = hr_api.g_varchar2) then
487: p_rec.aei_attribute12 :=
488: pe_aei_shd.g_old_rec.aei_attribute12;
484: pe_aei_shd.g_old_rec.aei_attribute11;
485: End If;
486: If (p_rec.aei_attribute12 = hr_api.g_varchar2) then
487: p_rec.aei_attribute12 :=
488: pe_aei_shd.g_old_rec.aei_attribute12;
489: End If;
490: If (p_rec.aei_attribute13 = hr_api.g_varchar2) then
491: p_rec.aei_attribute13 :=
492: pe_aei_shd.g_old_rec.aei_attribute13;
488: pe_aei_shd.g_old_rec.aei_attribute12;
489: End If;
490: If (p_rec.aei_attribute13 = hr_api.g_varchar2) then
491: p_rec.aei_attribute13 :=
492: pe_aei_shd.g_old_rec.aei_attribute13;
493: End If;
494: If (p_rec.aei_attribute14 = hr_api.g_varchar2) then
495: p_rec.aei_attribute14 :=
496: pe_aei_shd.g_old_rec.aei_attribute14;
492: pe_aei_shd.g_old_rec.aei_attribute13;
493: End If;
494: If (p_rec.aei_attribute14 = hr_api.g_varchar2) then
495: p_rec.aei_attribute14 :=
496: pe_aei_shd.g_old_rec.aei_attribute14;
497: End If;
498: If (p_rec.aei_attribute15 = hr_api.g_varchar2) then
499: p_rec.aei_attribute15 :=
500: pe_aei_shd.g_old_rec.aei_attribute15;
496: pe_aei_shd.g_old_rec.aei_attribute14;
497: End If;
498: If (p_rec.aei_attribute15 = hr_api.g_varchar2) then
499: p_rec.aei_attribute15 :=
500: pe_aei_shd.g_old_rec.aei_attribute15;
501: End If;
502: If (p_rec.aei_attribute16 = hr_api.g_varchar2) then
503: p_rec.aei_attribute16 :=
504: pe_aei_shd.g_old_rec.aei_attribute16;
500: pe_aei_shd.g_old_rec.aei_attribute15;
501: End If;
502: If (p_rec.aei_attribute16 = hr_api.g_varchar2) then
503: p_rec.aei_attribute16 :=
504: pe_aei_shd.g_old_rec.aei_attribute16;
505: End If;
506: If (p_rec.aei_attribute17 = hr_api.g_varchar2) then
507: p_rec.aei_attribute17 :=
508: pe_aei_shd.g_old_rec.aei_attribute17;
504: pe_aei_shd.g_old_rec.aei_attribute16;
505: End If;
506: If (p_rec.aei_attribute17 = hr_api.g_varchar2) then
507: p_rec.aei_attribute17 :=
508: pe_aei_shd.g_old_rec.aei_attribute17;
509: End If;
510: If (p_rec.aei_attribute18 = hr_api.g_varchar2) then
511: p_rec.aei_attribute18 :=
512: pe_aei_shd.g_old_rec.aei_attribute18;
508: pe_aei_shd.g_old_rec.aei_attribute17;
509: End If;
510: If (p_rec.aei_attribute18 = hr_api.g_varchar2) then
511: p_rec.aei_attribute18 :=
512: pe_aei_shd.g_old_rec.aei_attribute18;
513: End If;
514: If (p_rec.aei_attribute19 = hr_api.g_varchar2) then
515: p_rec.aei_attribute19 :=
516: pe_aei_shd.g_old_rec.aei_attribute19;
512: pe_aei_shd.g_old_rec.aei_attribute18;
513: End If;
514: If (p_rec.aei_attribute19 = hr_api.g_varchar2) then
515: p_rec.aei_attribute19 :=
516: pe_aei_shd.g_old_rec.aei_attribute19;
517: End If;
518: If (p_rec.aei_attribute20 = hr_api.g_varchar2) then
519: p_rec.aei_attribute20 :=
520: pe_aei_shd.g_old_rec.aei_attribute20;
516: pe_aei_shd.g_old_rec.aei_attribute19;
517: End If;
518: If (p_rec.aei_attribute20 = hr_api.g_varchar2) then
519: p_rec.aei_attribute20 :=
520: pe_aei_shd.g_old_rec.aei_attribute20;
521: End If;
522: If (p_rec.aei_information_category = hr_api.g_varchar2) then
523: p_rec.aei_information_category :=
524: pe_aei_shd.g_old_rec.aei_information_category;
520: pe_aei_shd.g_old_rec.aei_attribute20;
521: End If;
522: If (p_rec.aei_information_category = hr_api.g_varchar2) then
523: p_rec.aei_information_category :=
524: pe_aei_shd.g_old_rec.aei_information_category;
525: End If;
526: If (p_rec.aei_information1 = hr_api.g_varchar2) then
527: p_rec.aei_information1 :=
528: pe_aei_shd.g_old_rec.aei_information1;
524: pe_aei_shd.g_old_rec.aei_information_category;
525: End If;
526: If (p_rec.aei_information1 = hr_api.g_varchar2) then
527: p_rec.aei_information1 :=
528: pe_aei_shd.g_old_rec.aei_information1;
529: End If;
530: If (p_rec.aei_information2 = hr_api.g_varchar2) then
531: p_rec.aei_information2 :=
532: pe_aei_shd.g_old_rec.aei_information2;
528: pe_aei_shd.g_old_rec.aei_information1;
529: End If;
530: If (p_rec.aei_information2 = hr_api.g_varchar2) then
531: p_rec.aei_information2 :=
532: pe_aei_shd.g_old_rec.aei_information2;
533: End If;
534: If (p_rec.aei_information3 = hr_api.g_varchar2) then
535: p_rec.aei_information3 :=
536: pe_aei_shd.g_old_rec.aei_information3;
532: pe_aei_shd.g_old_rec.aei_information2;
533: End If;
534: If (p_rec.aei_information3 = hr_api.g_varchar2) then
535: p_rec.aei_information3 :=
536: pe_aei_shd.g_old_rec.aei_information3;
537: End If;
538: If (p_rec.aei_information4 = hr_api.g_varchar2) then
539: p_rec.aei_information4 :=
540: pe_aei_shd.g_old_rec.aei_information4;
536: pe_aei_shd.g_old_rec.aei_information3;
537: End If;
538: If (p_rec.aei_information4 = hr_api.g_varchar2) then
539: p_rec.aei_information4 :=
540: pe_aei_shd.g_old_rec.aei_information4;
541: End If;
542: If (p_rec.aei_information5 = hr_api.g_varchar2) then
543: p_rec.aei_information5 :=
544: pe_aei_shd.g_old_rec.aei_information5;
540: pe_aei_shd.g_old_rec.aei_information4;
541: End If;
542: If (p_rec.aei_information5 = hr_api.g_varchar2) then
543: p_rec.aei_information5 :=
544: pe_aei_shd.g_old_rec.aei_information5;
545: End If;
546: If (p_rec.aei_information6 = hr_api.g_varchar2) then
547: p_rec.aei_information6 :=
548: pe_aei_shd.g_old_rec.aei_information6;
544: pe_aei_shd.g_old_rec.aei_information5;
545: End If;
546: If (p_rec.aei_information6 = hr_api.g_varchar2) then
547: p_rec.aei_information6 :=
548: pe_aei_shd.g_old_rec.aei_information6;
549: End If;
550: If (p_rec.aei_information7 = hr_api.g_varchar2) then
551: p_rec.aei_information7 :=
552: pe_aei_shd.g_old_rec.aei_information7;
548: pe_aei_shd.g_old_rec.aei_information6;
549: End If;
550: If (p_rec.aei_information7 = hr_api.g_varchar2) then
551: p_rec.aei_information7 :=
552: pe_aei_shd.g_old_rec.aei_information7;
553: End If;
554: If (p_rec.aei_information8 = hr_api.g_varchar2) then
555: p_rec.aei_information8 :=
556: pe_aei_shd.g_old_rec.aei_information8;
552: pe_aei_shd.g_old_rec.aei_information7;
553: End If;
554: If (p_rec.aei_information8 = hr_api.g_varchar2) then
555: p_rec.aei_information8 :=
556: pe_aei_shd.g_old_rec.aei_information8;
557: End If;
558: If (p_rec.aei_information9 = hr_api.g_varchar2) then
559: p_rec.aei_information9 :=
560: pe_aei_shd.g_old_rec.aei_information9;
556: pe_aei_shd.g_old_rec.aei_information8;
557: End If;
558: If (p_rec.aei_information9 = hr_api.g_varchar2) then
559: p_rec.aei_information9 :=
560: pe_aei_shd.g_old_rec.aei_information9;
561: End If;
562: If (p_rec.aei_information10 = hr_api.g_varchar2) then
563: p_rec.aei_information10 :=
564: pe_aei_shd.g_old_rec.aei_information10;
560: pe_aei_shd.g_old_rec.aei_information9;
561: End If;
562: If (p_rec.aei_information10 = hr_api.g_varchar2) then
563: p_rec.aei_information10 :=
564: pe_aei_shd.g_old_rec.aei_information10;
565: End If;
566: If (p_rec.aei_information11 = hr_api.g_varchar2) then
567: p_rec.aei_information11 :=
568: pe_aei_shd.g_old_rec.aei_information11;
564: pe_aei_shd.g_old_rec.aei_information10;
565: End If;
566: If (p_rec.aei_information11 = hr_api.g_varchar2) then
567: p_rec.aei_information11 :=
568: pe_aei_shd.g_old_rec.aei_information11;
569: End If;
570: If (p_rec.aei_information12 = hr_api.g_varchar2) then
571: p_rec.aei_information12 :=
572: pe_aei_shd.g_old_rec.aei_information12;
568: pe_aei_shd.g_old_rec.aei_information11;
569: End If;
570: If (p_rec.aei_information12 = hr_api.g_varchar2) then
571: p_rec.aei_information12 :=
572: pe_aei_shd.g_old_rec.aei_information12;
573: End If;
574: If (p_rec.aei_information13 = hr_api.g_varchar2) then
575: p_rec.aei_information13 :=
576: pe_aei_shd.g_old_rec.aei_information13;
572: pe_aei_shd.g_old_rec.aei_information12;
573: End If;
574: If (p_rec.aei_information13 = hr_api.g_varchar2) then
575: p_rec.aei_information13 :=
576: pe_aei_shd.g_old_rec.aei_information13;
577: End If;
578: If (p_rec.aei_information14 = hr_api.g_varchar2) then
579: p_rec.aei_information14 :=
580: pe_aei_shd.g_old_rec.aei_information14;
576: pe_aei_shd.g_old_rec.aei_information13;
577: End If;
578: If (p_rec.aei_information14 = hr_api.g_varchar2) then
579: p_rec.aei_information14 :=
580: pe_aei_shd.g_old_rec.aei_information14;
581: End If;
582: If (p_rec.aei_information15 = hr_api.g_varchar2) then
583: p_rec.aei_information15 :=
584: pe_aei_shd.g_old_rec.aei_information15;
580: pe_aei_shd.g_old_rec.aei_information14;
581: End If;
582: If (p_rec.aei_information15 = hr_api.g_varchar2) then
583: p_rec.aei_information15 :=
584: pe_aei_shd.g_old_rec.aei_information15;
585: End If;
586: If (p_rec.aei_information16 = hr_api.g_varchar2) then
587: p_rec.aei_information16 :=
588: pe_aei_shd.g_old_rec.aei_information16;
584: pe_aei_shd.g_old_rec.aei_information15;
585: End If;
586: If (p_rec.aei_information16 = hr_api.g_varchar2) then
587: p_rec.aei_information16 :=
588: pe_aei_shd.g_old_rec.aei_information16;
589: End If;
590: If (p_rec.aei_information17 = hr_api.g_varchar2) then
591: p_rec.aei_information17 :=
592: pe_aei_shd.g_old_rec.aei_information17;
588: pe_aei_shd.g_old_rec.aei_information16;
589: End If;
590: If (p_rec.aei_information17 = hr_api.g_varchar2) then
591: p_rec.aei_information17 :=
592: pe_aei_shd.g_old_rec.aei_information17;
593: End If;
594: If (p_rec.aei_information18 = hr_api.g_varchar2) then
595: p_rec.aei_information18 :=
596: pe_aei_shd.g_old_rec.aei_information18;
592: pe_aei_shd.g_old_rec.aei_information17;
593: End If;
594: If (p_rec.aei_information18 = hr_api.g_varchar2) then
595: p_rec.aei_information18 :=
596: pe_aei_shd.g_old_rec.aei_information18;
597: End If;
598: If (p_rec.aei_information19 = hr_api.g_varchar2) then
599: p_rec.aei_information19 :=
600: pe_aei_shd.g_old_rec.aei_information19;
596: pe_aei_shd.g_old_rec.aei_information18;
597: End If;
598: If (p_rec.aei_information19 = hr_api.g_varchar2) then
599: p_rec.aei_information19 :=
600: pe_aei_shd.g_old_rec.aei_information19;
601: End If;
602: If (p_rec.aei_information20 = hr_api.g_varchar2) then
603: p_rec.aei_information20 :=
604: pe_aei_shd.g_old_rec.aei_information20;
600: pe_aei_shd.g_old_rec.aei_information19;
601: End If;
602: If (p_rec.aei_information20 = hr_api.g_varchar2) then
603: p_rec.aei_information20 :=
604: pe_aei_shd.g_old_rec.aei_information20;
605: End If;
606: If (p_rec.aei_information21 = hr_api.g_varchar2) then
607: p_rec.aei_information21 :=
608: pe_aei_shd.g_old_rec.aei_information21;
604: pe_aei_shd.g_old_rec.aei_information20;
605: End If;
606: If (p_rec.aei_information21 = hr_api.g_varchar2) then
607: p_rec.aei_information21 :=
608: pe_aei_shd.g_old_rec.aei_information21;
609: End If;
610: If (p_rec.aei_information22 = hr_api.g_varchar2) then
611: p_rec.aei_information22 :=
612: pe_aei_shd.g_old_rec.aei_information22;
608: pe_aei_shd.g_old_rec.aei_information21;
609: End If;
610: If (p_rec.aei_information22 = hr_api.g_varchar2) then
611: p_rec.aei_information22 :=
612: pe_aei_shd.g_old_rec.aei_information22;
613: End If;
614: If (p_rec.aei_information23 = hr_api.g_varchar2) then
615: p_rec.aei_information23 :=
616: pe_aei_shd.g_old_rec.aei_information23;
612: pe_aei_shd.g_old_rec.aei_information22;
613: End If;
614: If (p_rec.aei_information23 = hr_api.g_varchar2) then
615: p_rec.aei_information23 :=
616: pe_aei_shd.g_old_rec.aei_information23;
617: End If;
618: If (p_rec.aei_information24 = hr_api.g_varchar2) then
619: p_rec.aei_information24 :=
620: pe_aei_shd.g_old_rec.aei_information24;
616: pe_aei_shd.g_old_rec.aei_information23;
617: End If;
618: If (p_rec.aei_information24 = hr_api.g_varchar2) then
619: p_rec.aei_information24 :=
620: pe_aei_shd.g_old_rec.aei_information24;
621: End If;
622: If (p_rec.aei_information25 = hr_api.g_varchar2) then
623: p_rec.aei_information25 :=
624: pe_aei_shd.g_old_rec.aei_information25;
620: pe_aei_shd.g_old_rec.aei_information24;
621: End If;
622: If (p_rec.aei_information25 = hr_api.g_varchar2) then
623: p_rec.aei_information25 :=
624: pe_aei_shd.g_old_rec.aei_information25;
625: End If;
626: If (p_rec.aei_information26 = hr_api.g_varchar2) then
627: p_rec.aei_information26 :=
628: pe_aei_shd.g_old_rec.aei_information26;
624: pe_aei_shd.g_old_rec.aei_information25;
625: End If;
626: If (p_rec.aei_information26 = hr_api.g_varchar2) then
627: p_rec.aei_information26 :=
628: pe_aei_shd.g_old_rec.aei_information26;
629: End If;
630: If (p_rec.aei_information27 = hr_api.g_varchar2) then
631: p_rec.aei_information27 :=
632: pe_aei_shd.g_old_rec.aei_information27;
628: pe_aei_shd.g_old_rec.aei_information26;
629: End If;
630: If (p_rec.aei_information27 = hr_api.g_varchar2) then
631: p_rec.aei_information27 :=
632: pe_aei_shd.g_old_rec.aei_information27;
633: End If;
634: If (p_rec.aei_information28 = hr_api.g_varchar2) then
635: p_rec.aei_information28 :=
636: pe_aei_shd.g_old_rec.aei_information28;
632: pe_aei_shd.g_old_rec.aei_information27;
633: End If;
634: If (p_rec.aei_information28 = hr_api.g_varchar2) then
635: p_rec.aei_information28 :=
636: pe_aei_shd.g_old_rec.aei_information28;
637: End If;
638: If (p_rec.aei_information29 = hr_api.g_varchar2) then
639: p_rec.aei_information29 :=
640: pe_aei_shd.g_old_rec.aei_information29;
636: pe_aei_shd.g_old_rec.aei_information28;
637: End If;
638: If (p_rec.aei_information29 = hr_api.g_varchar2) then
639: p_rec.aei_information29 :=
640: pe_aei_shd.g_old_rec.aei_information29;
641: End If;
642: If (p_rec.aei_information30 = hr_api.g_varchar2) then
643: p_rec.aei_information30 :=
644: pe_aei_shd.g_old_rec.aei_information30;
640: pe_aei_shd.g_old_rec.aei_information29;
641: End If;
642: If (p_rec.aei_information30 = hr_api.g_varchar2) then
643: p_rec.aei_information30 :=
644: pe_aei_shd.g_old_rec.aei_information30;
645: End If;
646:
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 10);
653: -- |---------------------------------< upd >----------------------------------|
654: -- ----------------------------------------------------------------------------
655: Procedure upd
656: (
657: p_rec in out nocopy pe_aei_shd.g_rec_type,
658: p_validate in boolean default false
659: ) is
660: --
661: l_proc varchar2(72) := g_package||'upd';
673: End If;
674: --
675: -- We must lock the row which we need to update.
676: --
677: pe_aei_shd.lck
678: (
679: p_rec.assignment_extra_info_id,
680: p_rec.object_version_number
681: );
782: p_object_version_number in out nocopy number,
783: p_validate in boolean default false
784: ) is
785: --
786: l_rec pe_aei_shd.g_rec_type;
787: l_proc varchar2(72) := g_package||'upd';
788: --
789: Begin
790: hr_utility.set_location('Entering:'||l_proc, 5);
792: -- Call conversion function to turn arguments into the
793: -- l_rec structure.
794: --
795: l_rec :=
796: pe_aei_shd.convert_args
797: (
798: p_assignment_extra_info_id,
799: hr_api.g_number, -- p_assignment_id,
800: hr_api.g_varchar2, -- p_information_type,