44: -- Internal Table Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy pe_poi_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_poi_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_poi_shd.constraint_error
128: pe_poi_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_poi_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_poi_shd.constraint_error
132: pe_poi_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_poi_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_poi_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_poi_shd.g_rec_type) is
217: --
218: l_proc varchar2(72) := g_package||'post_update';
219: --
220: Begin
282: p_poei_information27 => p_rec.poei_information27 ,
283: p_poei_information28 => p_rec.poei_information28 ,
284: p_poei_information29 => p_rec.poei_information29 ,
285: p_poei_information30 => p_rec.poei_information30 ,
286: p_position_id_o => pe_poi_shd.g_old_rec.position_id ,
287: p_information_type_o => pe_poi_shd.g_old_rec.information_type ,
288: p_request_id_o => pe_poi_shd.g_old_rec.request_id ,
289: p_program_application_id_o => pe_poi_shd.g_old_rec.program_application_id ,
290: p_program_id_o => pe_poi_shd.g_old_rec.program_id ,
283: p_poei_information28 => p_rec.poei_information28 ,
284: p_poei_information29 => p_rec.poei_information29 ,
285: p_poei_information30 => p_rec.poei_information30 ,
286: p_position_id_o => pe_poi_shd.g_old_rec.position_id ,
287: p_information_type_o => pe_poi_shd.g_old_rec.information_type ,
288: p_request_id_o => pe_poi_shd.g_old_rec.request_id ,
289: p_program_application_id_o => pe_poi_shd.g_old_rec.program_application_id ,
290: p_program_id_o => pe_poi_shd.g_old_rec.program_id ,
291: p_program_update_date_o => pe_poi_shd.g_old_rec.program_update_date ,
284: p_poei_information29 => p_rec.poei_information29 ,
285: p_poei_information30 => p_rec.poei_information30 ,
286: p_position_id_o => pe_poi_shd.g_old_rec.position_id ,
287: p_information_type_o => pe_poi_shd.g_old_rec.information_type ,
288: p_request_id_o => pe_poi_shd.g_old_rec.request_id ,
289: p_program_application_id_o => pe_poi_shd.g_old_rec.program_application_id ,
290: p_program_id_o => pe_poi_shd.g_old_rec.program_id ,
291: p_program_update_date_o => pe_poi_shd.g_old_rec.program_update_date ,
292: p_poei_attribute_category_o => pe_poi_shd.g_old_rec.poei_attribute_category ,
285: p_poei_information30 => p_rec.poei_information30 ,
286: p_position_id_o => pe_poi_shd.g_old_rec.position_id ,
287: p_information_type_o => pe_poi_shd.g_old_rec.information_type ,
288: p_request_id_o => pe_poi_shd.g_old_rec.request_id ,
289: p_program_application_id_o => pe_poi_shd.g_old_rec.program_application_id ,
290: p_program_id_o => pe_poi_shd.g_old_rec.program_id ,
291: p_program_update_date_o => pe_poi_shd.g_old_rec.program_update_date ,
292: p_poei_attribute_category_o => pe_poi_shd.g_old_rec.poei_attribute_category ,
293: p_poei_attribute1_o => pe_poi_shd.g_old_rec.poei_attribute1 ,
286: p_position_id_o => pe_poi_shd.g_old_rec.position_id ,
287: p_information_type_o => pe_poi_shd.g_old_rec.information_type ,
288: p_request_id_o => pe_poi_shd.g_old_rec.request_id ,
289: p_program_application_id_o => pe_poi_shd.g_old_rec.program_application_id ,
290: p_program_id_o => pe_poi_shd.g_old_rec.program_id ,
291: p_program_update_date_o => pe_poi_shd.g_old_rec.program_update_date ,
292: p_poei_attribute_category_o => pe_poi_shd.g_old_rec.poei_attribute_category ,
293: p_poei_attribute1_o => pe_poi_shd.g_old_rec.poei_attribute1 ,
294: p_poei_attribute2_o => pe_poi_shd.g_old_rec.poei_attribute2 ,
287: p_information_type_o => pe_poi_shd.g_old_rec.information_type ,
288: p_request_id_o => pe_poi_shd.g_old_rec.request_id ,
289: p_program_application_id_o => pe_poi_shd.g_old_rec.program_application_id ,
290: p_program_id_o => pe_poi_shd.g_old_rec.program_id ,
291: p_program_update_date_o => pe_poi_shd.g_old_rec.program_update_date ,
292: p_poei_attribute_category_o => pe_poi_shd.g_old_rec.poei_attribute_category ,
293: p_poei_attribute1_o => pe_poi_shd.g_old_rec.poei_attribute1 ,
294: p_poei_attribute2_o => pe_poi_shd.g_old_rec.poei_attribute2 ,
295: p_poei_attribute3_o => pe_poi_shd.g_old_rec.poei_attribute3 ,
288: p_request_id_o => pe_poi_shd.g_old_rec.request_id ,
289: p_program_application_id_o => pe_poi_shd.g_old_rec.program_application_id ,
290: p_program_id_o => pe_poi_shd.g_old_rec.program_id ,
291: p_program_update_date_o => pe_poi_shd.g_old_rec.program_update_date ,
292: p_poei_attribute_category_o => pe_poi_shd.g_old_rec.poei_attribute_category ,
293: p_poei_attribute1_o => pe_poi_shd.g_old_rec.poei_attribute1 ,
294: p_poei_attribute2_o => pe_poi_shd.g_old_rec.poei_attribute2 ,
295: p_poei_attribute3_o => pe_poi_shd.g_old_rec.poei_attribute3 ,
296: p_poei_attribute4_o => pe_poi_shd.g_old_rec.poei_attribute4 ,
289: p_program_application_id_o => pe_poi_shd.g_old_rec.program_application_id ,
290: p_program_id_o => pe_poi_shd.g_old_rec.program_id ,
291: p_program_update_date_o => pe_poi_shd.g_old_rec.program_update_date ,
292: p_poei_attribute_category_o => pe_poi_shd.g_old_rec.poei_attribute_category ,
293: p_poei_attribute1_o => pe_poi_shd.g_old_rec.poei_attribute1 ,
294: p_poei_attribute2_o => pe_poi_shd.g_old_rec.poei_attribute2 ,
295: p_poei_attribute3_o => pe_poi_shd.g_old_rec.poei_attribute3 ,
296: p_poei_attribute4_o => pe_poi_shd.g_old_rec.poei_attribute4 ,
297: p_poei_attribute5_o => pe_poi_shd.g_old_rec.poei_attribute5 ,
290: p_program_id_o => pe_poi_shd.g_old_rec.program_id ,
291: p_program_update_date_o => pe_poi_shd.g_old_rec.program_update_date ,
292: p_poei_attribute_category_o => pe_poi_shd.g_old_rec.poei_attribute_category ,
293: p_poei_attribute1_o => pe_poi_shd.g_old_rec.poei_attribute1 ,
294: p_poei_attribute2_o => pe_poi_shd.g_old_rec.poei_attribute2 ,
295: p_poei_attribute3_o => pe_poi_shd.g_old_rec.poei_attribute3 ,
296: p_poei_attribute4_o => pe_poi_shd.g_old_rec.poei_attribute4 ,
297: p_poei_attribute5_o => pe_poi_shd.g_old_rec.poei_attribute5 ,
298: p_poei_attribute6_o => pe_poi_shd.g_old_rec.poei_attribute6 ,
291: p_program_update_date_o => pe_poi_shd.g_old_rec.program_update_date ,
292: p_poei_attribute_category_o => pe_poi_shd.g_old_rec.poei_attribute_category ,
293: p_poei_attribute1_o => pe_poi_shd.g_old_rec.poei_attribute1 ,
294: p_poei_attribute2_o => pe_poi_shd.g_old_rec.poei_attribute2 ,
295: p_poei_attribute3_o => pe_poi_shd.g_old_rec.poei_attribute3 ,
296: p_poei_attribute4_o => pe_poi_shd.g_old_rec.poei_attribute4 ,
297: p_poei_attribute5_o => pe_poi_shd.g_old_rec.poei_attribute5 ,
298: p_poei_attribute6_o => pe_poi_shd.g_old_rec.poei_attribute6 ,
299: p_poei_attribute7_o => pe_poi_shd.g_old_rec.poei_attribute7 ,
292: p_poei_attribute_category_o => pe_poi_shd.g_old_rec.poei_attribute_category ,
293: p_poei_attribute1_o => pe_poi_shd.g_old_rec.poei_attribute1 ,
294: p_poei_attribute2_o => pe_poi_shd.g_old_rec.poei_attribute2 ,
295: p_poei_attribute3_o => pe_poi_shd.g_old_rec.poei_attribute3 ,
296: p_poei_attribute4_o => pe_poi_shd.g_old_rec.poei_attribute4 ,
297: p_poei_attribute5_o => pe_poi_shd.g_old_rec.poei_attribute5 ,
298: p_poei_attribute6_o => pe_poi_shd.g_old_rec.poei_attribute6 ,
299: p_poei_attribute7_o => pe_poi_shd.g_old_rec.poei_attribute7 ,
300: p_poei_attribute8_o => pe_poi_shd.g_old_rec.poei_attribute8 ,
293: p_poei_attribute1_o => pe_poi_shd.g_old_rec.poei_attribute1 ,
294: p_poei_attribute2_o => pe_poi_shd.g_old_rec.poei_attribute2 ,
295: p_poei_attribute3_o => pe_poi_shd.g_old_rec.poei_attribute3 ,
296: p_poei_attribute4_o => pe_poi_shd.g_old_rec.poei_attribute4 ,
297: p_poei_attribute5_o => pe_poi_shd.g_old_rec.poei_attribute5 ,
298: p_poei_attribute6_o => pe_poi_shd.g_old_rec.poei_attribute6 ,
299: p_poei_attribute7_o => pe_poi_shd.g_old_rec.poei_attribute7 ,
300: p_poei_attribute8_o => pe_poi_shd.g_old_rec.poei_attribute8 ,
301: p_poei_attribute9_o => pe_poi_shd.g_old_rec.poei_attribute9 ,
294: p_poei_attribute2_o => pe_poi_shd.g_old_rec.poei_attribute2 ,
295: p_poei_attribute3_o => pe_poi_shd.g_old_rec.poei_attribute3 ,
296: p_poei_attribute4_o => pe_poi_shd.g_old_rec.poei_attribute4 ,
297: p_poei_attribute5_o => pe_poi_shd.g_old_rec.poei_attribute5 ,
298: p_poei_attribute6_o => pe_poi_shd.g_old_rec.poei_attribute6 ,
299: p_poei_attribute7_o => pe_poi_shd.g_old_rec.poei_attribute7 ,
300: p_poei_attribute8_o => pe_poi_shd.g_old_rec.poei_attribute8 ,
301: p_poei_attribute9_o => pe_poi_shd.g_old_rec.poei_attribute9 ,
302: p_poei_attribute10_o => pe_poi_shd.g_old_rec.poei_attribute10 ,
295: p_poei_attribute3_o => pe_poi_shd.g_old_rec.poei_attribute3 ,
296: p_poei_attribute4_o => pe_poi_shd.g_old_rec.poei_attribute4 ,
297: p_poei_attribute5_o => pe_poi_shd.g_old_rec.poei_attribute5 ,
298: p_poei_attribute6_o => pe_poi_shd.g_old_rec.poei_attribute6 ,
299: p_poei_attribute7_o => pe_poi_shd.g_old_rec.poei_attribute7 ,
300: p_poei_attribute8_o => pe_poi_shd.g_old_rec.poei_attribute8 ,
301: p_poei_attribute9_o => pe_poi_shd.g_old_rec.poei_attribute9 ,
302: p_poei_attribute10_o => pe_poi_shd.g_old_rec.poei_attribute10 ,
303: p_poei_attribute11_o => pe_poi_shd.g_old_rec.poei_attribute11 ,
296: p_poei_attribute4_o => pe_poi_shd.g_old_rec.poei_attribute4 ,
297: p_poei_attribute5_o => pe_poi_shd.g_old_rec.poei_attribute5 ,
298: p_poei_attribute6_o => pe_poi_shd.g_old_rec.poei_attribute6 ,
299: p_poei_attribute7_o => pe_poi_shd.g_old_rec.poei_attribute7 ,
300: p_poei_attribute8_o => pe_poi_shd.g_old_rec.poei_attribute8 ,
301: p_poei_attribute9_o => pe_poi_shd.g_old_rec.poei_attribute9 ,
302: p_poei_attribute10_o => pe_poi_shd.g_old_rec.poei_attribute10 ,
303: p_poei_attribute11_o => pe_poi_shd.g_old_rec.poei_attribute11 ,
304: p_poei_attribute12_o => pe_poi_shd.g_old_rec.poei_attribute12 ,
297: p_poei_attribute5_o => pe_poi_shd.g_old_rec.poei_attribute5 ,
298: p_poei_attribute6_o => pe_poi_shd.g_old_rec.poei_attribute6 ,
299: p_poei_attribute7_o => pe_poi_shd.g_old_rec.poei_attribute7 ,
300: p_poei_attribute8_o => pe_poi_shd.g_old_rec.poei_attribute8 ,
301: p_poei_attribute9_o => pe_poi_shd.g_old_rec.poei_attribute9 ,
302: p_poei_attribute10_o => pe_poi_shd.g_old_rec.poei_attribute10 ,
303: p_poei_attribute11_o => pe_poi_shd.g_old_rec.poei_attribute11 ,
304: p_poei_attribute12_o => pe_poi_shd.g_old_rec.poei_attribute12 ,
305: p_poei_attribute13_o => pe_poi_shd.g_old_rec.poei_attribute13 ,
298: p_poei_attribute6_o => pe_poi_shd.g_old_rec.poei_attribute6 ,
299: p_poei_attribute7_o => pe_poi_shd.g_old_rec.poei_attribute7 ,
300: p_poei_attribute8_o => pe_poi_shd.g_old_rec.poei_attribute8 ,
301: p_poei_attribute9_o => pe_poi_shd.g_old_rec.poei_attribute9 ,
302: p_poei_attribute10_o => pe_poi_shd.g_old_rec.poei_attribute10 ,
303: p_poei_attribute11_o => pe_poi_shd.g_old_rec.poei_attribute11 ,
304: p_poei_attribute12_o => pe_poi_shd.g_old_rec.poei_attribute12 ,
305: p_poei_attribute13_o => pe_poi_shd.g_old_rec.poei_attribute13 ,
306: p_poei_attribute14_o => pe_poi_shd.g_old_rec.poei_attribute14 ,
299: p_poei_attribute7_o => pe_poi_shd.g_old_rec.poei_attribute7 ,
300: p_poei_attribute8_o => pe_poi_shd.g_old_rec.poei_attribute8 ,
301: p_poei_attribute9_o => pe_poi_shd.g_old_rec.poei_attribute9 ,
302: p_poei_attribute10_o => pe_poi_shd.g_old_rec.poei_attribute10 ,
303: p_poei_attribute11_o => pe_poi_shd.g_old_rec.poei_attribute11 ,
304: p_poei_attribute12_o => pe_poi_shd.g_old_rec.poei_attribute12 ,
305: p_poei_attribute13_o => pe_poi_shd.g_old_rec.poei_attribute13 ,
306: p_poei_attribute14_o => pe_poi_shd.g_old_rec.poei_attribute14 ,
307: p_poei_attribute15_o => pe_poi_shd.g_old_rec.poei_attribute15 ,
300: p_poei_attribute8_o => pe_poi_shd.g_old_rec.poei_attribute8 ,
301: p_poei_attribute9_o => pe_poi_shd.g_old_rec.poei_attribute9 ,
302: p_poei_attribute10_o => pe_poi_shd.g_old_rec.poei_attribute10 ,
303: p_poei_attribute11_o => pe_poi_shd.g_old_rec.poei_attribute11 ,
304: p_poei_attribute12_o => pe_poi_shd.g_old_rec.poei_attribute12 ,
305: p_poei_attribute13_o => pe_poi_shd.g_old_rec.poei_attribute13 ,
306: p_poei_attribute14_o => pe_poi_shd.g_old_rec.poei_attribute14 ,
307: p_poei_attribute15_o => pe_poi_shd.g_old_rec.poei_attribute15 ,
308: p_poei_attribute16_o => pe_poi_shd.g_old_rec.poei_attribute16 ,
301: p_poei_attribute9_o => pe_poi_shd.g_old_rec.poei_attribute9 ,
302: p_poei_attribute10_o => pe_poi_shd.g_old_rec.poei_attribute10 ,
303: p_poei_attribute11_o => pe_poi_shd.g_old_rec.poei_attribute11 ,
304: p_poei_attribute12_o => pe_poi_shd.g_old_rec.poei_attribute12 ,
305: p_poei_attribute13_o => pe_poi_shd.g_old_rec.poei_attribute13 ,
306: p_poei_attribute14_o => pe_poi_shd.g_old_rec.poei_attribute14 ,
307: p_poei_attribute15_o => pe_poi_shd.g_old_rec.poei_attribute15 ,
308: p_poei_attribute16_o => pe_poi_shd.g_old_rec.poei_attribute16 ,
309: p_poei_attribute17_o => pe_poi_shd.g_old_rec.poei_attribute17 ,
302: p_poei_attribute10_o => pe_poi_shd.g_old_rec.poei_attribute10 ,
303: p_poei_attribute11_o => pe_poi_shd.g_old_rec.poei_attribute11 ,
304: p_poei_attribute12_o => pe_poi_shd.g_old_rec.poei_attribute12 ,
305: p_poei_attribute13_o => pe_poi_shd.g_old_rec.poei_attribute13 ,
306: p_poei_attribute14_o => pe_poi_shd.g_old_rec.poei_attribute14 ,
307: p_poei_attribute15_o => pe_poi_shd.g_old_rec.poei_attribute15 ,
308: p_poei_attribute16_o => pe_poi_shd.g_old_rec.poei_attribute16 ,
309: p_poei_attribute17_o => pe_poi_shd.g_old_rec.poei_attribute17 ,
310: p_poei_attribute18_o => pe_poi_shd.g_old_rec.poei_attribute18 ,
303: p_poei_attribute11_o => pe_poi_shd.g_old_rec.poei_attribute11 ,
304: p_poei_attribute12_o => pe_poi_shd.g_old_rec.poei_attribute12 ,
305: p_poei_attribute13_o => pe_poi_shd.g_old_rec.poei_attribute13 ,
306: p_poei_attribute14_o => pe_poi_shd.g_old_rec.poei_attribute14 ,
307: p_poei_attribute15_o => pe_poi_shd.g_old_rec.poei_attribute15 ,
308: p_poei_attribute16_o => pe_poi_shd.g_old_rec.poei_attribute16 ,
309: p_poei_attribute17_o => pe_poi_shd.g_old_rec.poei_attribute17 ,
310: p_poei_attribute18_o => pe_poi_shd.g_old_rec.poei_attribute18 ,
311: p_poei_attribute19_o => pe_poi_shd.g_old_rec.poei_attribute19 ,
304: p_poei_attribute12_o => pe_poi_shd.g_old_rec.poei_attribute12 ,
305: p_poei_attribute13_o => pe_poi_shd.g_old_rec.poei_attribute13 ,
306: p_poei_attribute14_o => pe_poi_shd.g_old_rec.poei_attribute14 ,
307: p_poei_attribute15_o => pe_poi_shd.g_old_rec.poei_attribute15 ,
308: p_poei_attribute16_o => pe_poi_shd.g_old_rec.poei_attribute16 ,
309: p_poei_attribute17_o => pe_poi_shd.g_old_rec.poei_attribute17 ,
310: p_poei_attribute18_o => pe_poi_shd.g_old_rec.poei_attribute18 ,
311: p_poei_attribute19_o => pe_poi_shd.g_old_rec.poei_attribute19 ,
312: p_poei_attribute20_o => pe_poi_shd.g_old_rec.poei_attribute20 ,
305: p_poei_attribute13_o => pe_poi_shd.g_old_rec.poei_attribute13 ,
306: p_poei_attribute14_o => pe_poi_shd.g_old_rec.poei_attribute14 ,
307: p_poei_attribute15_o => pe_poi_shd.g_old_rec.poei_attribute15 ,
308: p_poei_attribute16_o => pe_poi_shd.g_old_rec.poei_attribute16 ,
309: p_poei_attribute17_o => pe_poi_shd.g_old_rec.poei_attribute17 ,
310: p_poei_attribute18_o => pe_poi_shd.g_old_rec.poei_attribute18 ,
311: p_poei_attribute19_o => pe_poi_shd.g_old_rec.poei_attribute19 ,
312: p_poei_attribute20_o => pe_poi_shd.g_old_rec.poei_attribute20 ,
313: p_poei_information_category_o => pe_poi_shd.g_old_rec.poei_information_category ,
306: p_poei_attribute14_o => pe_poi_shd.g_old_rec.poei_attribute14 ,
307: p_poei_attribute15_o => pe_poi_shd.g_old_rec.poei_attribute15 ,
308: p_poei_attribute16_o => pe_poi_shd.g_old_rec.poei_attribute16 ,
309: p_poei_attribute17_o => pe_poi_shd.g_old_rec.poei_attribute17 ,
310: p_poei_attribute18_o => pe_poi_shd.g_old_rec.poei_attribute18 ,
311: p_poei_attribute19_o => pe_poi_shd.g_old_rec.poei_attribute19 ,
312: p_poei_attribute20_o => pe_poi_shd.g_old_rec.poei_attribute20 ,
313: p_poei_information_category_o => pe_poi_shd.g_old_rec.poei_information_category ,
314: p_poei_information1_o => pe_poi_shd.g_old_rec.poei_information1 ,
307: p_poei_attribute15_o => pe_poi_shd.g_old_rec.poei_attribute15 ,
308: p_poei_attribute16_o => pe_poi_shd.g_old_rec.poei_attribute16 ,
309: p_poei_attribute17_o => pe_poi_shd.g_old_rec.poei_attribute17 ,
310: p_poei_attribute18_o => pe_poi_shd.g_old_rec.poei_attribute18 ,
311: p_poei_attribute19_o => pe_poi_shd.g_old_rec.poei_attribute19 ,
312: p_poei_attribute20_o => pe_poi_shd.g_old_rec.poei_attribute20 ,
313: p_poei_information_category_o => pe_poi_shd.g_old_rec.poei_information_category ,
314: p_poei_information1_o => pe_poi_shd.g_old_rec.poei_information1 ,
315: p_poei_information2_o => pe_poi_shd.g_old_rec.poei_information2 ,
308: p_poei_attribute16_o => pe_poi_shd.g_old_rec.poei_attribute16 ,
309: p_poei_attribute17_o => pe_poi_shd.g_old_rec.poei_attribute17 ,
310: p_poei_attribute18_o => pe_poi_shd.g_old_rec.poei_attribute18 ,
311: p_poei_attribute19_o => pe_poi_shd.g_old_rec.poei_attribute19 ,
312: p_poei_attribute20_o => pe_poi_shd.g_old_rec.poei_attribute20 ,
313: p_poei_information_category_o => pe_poi_shd.g_old_rec.poei_information_category ,
314: p_poei_information1_o => pe_poi_shd.g_old_rec.poei_information1 ,
315: p_poei_information2_o => pe_poi_shd.g_old_rec.poei_information2 ,
316: p_poei_information3_o => pe_poi_shd.g_old_rec.poei_information3 ,
309: p_poei_attribute17_o => pe_poi_shd.g_old_rec.poei_attribute17 ,
310: p_poei_attribute18_o => pe_poi_shd.g_old_rec.poei_attribute18 ,
311: p_poei_attribute19_o => pe_poi_shd.g_old_rec.poei_attribute19 ,
312: p_poei_attribute20_o => pe_poi_shd.g_old_rec.poei_attribute20 ,
313: p_poei_information_category_o => pe_poi_shd.g_old_rec.poei_information_category ,
314: p_poei_information1_o => pe_poi_shd.g_old_rec.poei_information1 ,
315: p_poei_information2_o => pe_poi_shd.g_old_rec.poei_information2 ,
316: p_poei_information3_o => pe_poi_shd.g_old_rec.poei_information3 ,
317: p_poei_information4_o => pe_poi_shd.g_old_rec.poei_information4 ,
310: p_poei_attribute18_o => pe_poi_shd.g_old_rec.poei_attribute18 ,
311: p_poei_attribute19_o => pe_poi_shd.g_old_rec.poei_attribute19 ,
312: p_poei_attribute20_o => pe_poi_shd.g_old_rec.poei_attribute20 ,
313: p_poei_information_category_o => pe_poi_shd.g_old_rec.poei_information_category ,
314: p_poei_information1_o => pe_poi_shd.g_old_rec.poei_information1 ,
315: p_poei_information2_o => pe_poi_shd.g_old_rec.poei_information2 ,
316: p_poei_information3_o => pe_poi_shd.g_old_rec.poei_information3 ,
317: p_poei_information4_o => pe_poi_shd.g_old_rec.poei_information4 ,
318: p_poei_information5_o => pe_poi_shd.g_old_rec.poei_information5 ,
311: p_poei_attribute19_o => pe_poi_shd.g_old_rec.poei_attribute19 ,
312: p_poei_attribute20_o => pe_poi_shd.g_old_rec.poei_attribute20 ,
313: p_poei_information_category_o => pe_poi_shd.g_old_rec.poei_information_category ,
314: p_poei_information1_o => pe_poi_shd.g_old_rec.poei_information1 ,
315: p_poei_information2_o => pe_poi_shd.g_old_rec.poei_information2 ,
316: p_poei_information3_o => pe_poi_shd.g_old_rec.poei_information3 ,
317: p_poei_information4_o => pe_poi_shd.g_old_rec.poei_information4 ,
318: p_poei_information5_o => pe_poi_shd.g_old_rec.poei_information5 ,
319: p_poei_information6_o => pe_poi_shd.g_old_rec.poei_information6 ,
312: p_poei_attribute20_o => pe_poi_shd.g_old_rec.poei_attribute20 ,
313: p_poei_information_category_o => pe_poi_shd.g_old_rec.poei_information_category ,
314: p_poei_information1_o => pe_poi_shd.g_old_rec.poei_information1 ,
315: p_poei_information2_o => pe_poi_shd.g_old_rec.poei_information2 ,
316: p_poei_information3_o => pe_poi_shd.g_old_rec.poei_information3 ,
317: p_poei_information4_o => pe_poi_shd.g_old_rec.poei_information4 ,
318: p_poei_information5_o => pe_poi_shd.g_old_rec.poei_information5 ,
319: p_poei_information6_o => pe_poi_shd.g_old_rec.poei_information6 ,
320: p_poei_information7_o => pe_poi_shd.g_old_rec.poei_information7 ,
313: p_poei_information_category_o => pe_poi_shd.g_old_rec.poei_information_category ,
314: p_poei_information1_o => pe_poi_shd.g_old_rec.poei_information1 ,
315: p_poei_information2_o => pe_poi_shd.g_old_rec.poei_information2 ,
316: p_poei_information3_o => pe_poi_shd.g_old_rec.poei_information3 ,
317: p_poei_information4_o => pe_poi_shd.g_old_rec.poei_information4 ,
318: p_poei_information5_o => pe_poi_shd.g_old_rec.poei_information5 ,
319: p_poei_information6_o => pe_poi_shd.g_old_rec.poei_information6 ,
320: p_poei_information7_o => pe_poi_shd.g_old_rec.poei_information7 ,
321: p_poei_information8_o => pe_poi_shd.g_old_rec.poei_information8 ,
314: p_poei_information1_o => pe_poi_shd.g_old_rec.poei_information1 ,
315: p_poei_information2_o => pe_poi_shd.g_old_rec.poei_information2 ,
316: p_poei_information3_o => pe_poi_shd.g_old_rec.poei_information3 ,
317: p_poei_information4_o => pe_poi_shd.g_old_rec.poei_information4 ,
318: p_poei_information5_o => pe_poi_shd.g_old_rec.poei_information5 ,
319: p_poei_information6_o => pe_poi_shd.g_old_rec.poei_information6 ,
320: p_poei_information7_o => pe_poi_shd.g_old_rec.poei_information7 ,
321: p_poei_information8_o => pe_poi_shd.g_old_rec.poei_information8 ,
322: p_poei_information9_o => pe_poi_shd.g_old_rec.poei_information9 ,
315: p_poei_information2_o => pe_poi_shd.g_old_rec.poei_information2 ,
316: p_poei_information3_o => pe_poi_shd.g_old_rec.poei_information3 ,
317: p_poei_information4_o => pe_poi_shd.g_old_rec.poei_information4 ,
318: p_poei_information5_o => pe_poi_shd.g_old_rec.poei_information5 ,
319: p_poei_information6_o => pe_poi_shd.g_old_rec.poei_information6 ,
320: p_poei_information7_o => pe_poi_shd.g_old_rec.poei_information7 ,
321: p_poei_information8_o => pe_poi_shd.g_old_rec.poei_information8 ,
322: p_poei_information9_o => pe_poi_shd.g_old_rec.poei_information9 ,
323: p_poei_information10_o => pe_poi_shd.g_old_rec.poei_information10 ,
316: p_poei_information3_o => pe_poi_shd.g_old_rec.poei_information3 ,
317: p_poei_information4_o => pe_poi_shd.g_old_rec.poei_information4 ,
318: p_poei_information5_o => pe_poi_shd.g_old_rec.poei_information5 ,
319: p_poei_information6_o => pe_poi_shd.g_old_rec.poei_information6 ,
320: p_poei_information7_o => pe_poi_shd.g_old_rec.poei_information7 ,
321: p_poei_information8_o => pe_poi_shd.g_old_rec.poei_information8 ,
322: p_poei_information9_o => pe_poi_shd.g_old_rec.poei_information9 ,
323: p_poei_information10_o => pe_poi_shd.g_old_rec.poei_information10 ,
324: p_poei_information11_o => pe_poi_shd.g_old_rec.poei_information11 ,
317: p_poei_information4_o => pe_poi_shd.g_old_rec.poei_information4 ,
318: p_poei_information5_o => pe_poi_shd.g_old_rec.poei_information5 ,
319: p_poei_information6_o => pe_poi_shd.g_old_rec.poei_information6 ,
320: p_poei_information7_o => pe_poi_shd.g_old_rec.poei_information7 ,
321: p_poei_information8_o => pe_poi_shd.g_old_rec.poei_information8 ,
322: p_poei_information9_o => pe_poi_shd.g_old_rec.poei_information9 ,
323: p_poei_information10_o => pe_poi_shd.g_old_rec.poei_information10 ,
324: p_poei_information11_o => pe_poi_shd.g_old_rec.poei_information11 ,
325: p_poei_information12_o => pe_poi_shd.g_old_rec.poei_information12 ,
318: p_poei_information5_o => pe_poi_shd.g_old_rec.poei_information5 ,
319: p_poei_information6_o => pe_poi_shd.g_old_rec.poei_information6 ,
320: p_poei_information7_o => pe_poi_shd.g_old_rec.poei_information7 ,
321: p_poei_information8_o => pe_poi_shd.g_old_rec.poei_information8 ,
322: p_poei_information9_o => pe_poi_shd.g_old_rec.poei_information9 ,
323: p_poei_information10_o => pe_poi_shd.g_old_rec.poei_information10 ,
324: p_poei_information11_o => pe_poi_shd.g_old_rec.poei_information11 ,
325: p_poei_information12_o => pe_poi_shd.g_old_rec.poei_information12 ,
326: p_poei_information13_o => pe_poi_shd.g_old_rec.poei_information13 ,
319: p_poei_information6_o => pe_poi_shd.g_old_rec.poei_information6 ,
320: p_poei_information7_o => pe_poi_shd.g_old_rec.poei_information7 ,
321: p_poei_information8_o => pe_poi_shd.g_old_rec.poei_information8 ,
322: p_poei_information9_o => pe_poi_shd.g_old_rec.poei_information9 ,
323: p_poei_information10_o => pe_poi_shd.g_old_rec.poei_information10 ,
324: p_poei_information11_o => pe_poi_shd.g_old_rec.poei_information11 ,
325: p_poei_information12_o => pe_poi_shd.g_old_rec.poei_information12 ,
326: p_poei_information13_o => pe_poi_shd.g_old_rec.poei_information13 ,
327: p_poei_information14_o => pe_poi_shd.g_old_rec.poei_information14 ,
320: p_poei_information7_o => pe_poi_shd.g_old_rec.poei_information7 ,
321: p_poei_information8_o => pe_poi_shd.g_old_rec.poei_information8 ,
322: p_poei_information9_o => pe_poi_shd.g_old_rec.poei_information9 ,
323: p_poei_information10_o => pe_poi_shd.g_old_rec.poei_information10 ,
324: p_poei_information11_o => pe_poi_shd.g_old_rec.poei_information11 ,
325: p_poei_information12_o => pe_poi_shd.g_old_rec.poei_information12 ,
326: p_poei_information13_o => pe_poi_shd.g_old_rec.poei_information13 ,
327: p_poei_information14_o => pe_poi_shd.g_old_rec.poei_information14 ,
328: p_poei_information15_o => pe_poi_shd.g_old_rec.poei_information15 ,
321: p_poei_information8_o => pe_poi_shd.g_old_rec.poei_information8 ,
322: p_poei_information9_o => pe_poi_shd.g_old_rec.poei_information9 ,
323: p_poei_information10_o => pe_poi_shd.g_old_rec.poei_information10 ,
324: p_poei_information11_o => pe_poi_shd.g_old_rec.poei_information11 ,
325: p_poei_information12_o => pe_poi_shd.g_old_rec.poei_information12 ,
326: p_poei_information13_o => pe_poi_shd.g_old_rec.poei_information13 ,
327: p_poei_information14_o => pe_poi_shd.g_old_rec.poei_information14 ,
328: p_poei_information15_o => pe_poi_shd.g_old_rec.poei_information15 ,
329: p_poei_information16_o => pe_poi_shd.g_old_rec.poei_information16 ,
322: p_poei_information9_o => pe_poi_shd.g_old_rec.poei_information9 ,
323: p_poei_information10_o => pe_poi_shd.g_old_rec.poei_information10 ,
324: p_poei_information11_o => pe_poi_shd.g_old_rec.poei_information11 ,
325: p_poei_information12_o => pe_poi_shd.g_old_rec.poei_information12 ,
326: p_poei_information13_o => pe_poi_shd.g_old_rec.poei_information13 ,
327: p_poei_information14_o => pe_poi_shd.g_old_rec.poei_information14 ,
328: p_poei_information15_o => pe_poi_shd.g_old_rec.poei_information15 ,
329: p_poei_information16_o => pe_poi_shd.g_old_rec.poei_information16 ,
330: p_poei_information17_o => pe_poi_shd.g_old_rec.poei_information17 ,
323: p_poei_information10_o => pe_poi_shd.g_old_rec.poei_information10 ,
324: p_poei_information11_o => pe_poi_shd.g_old_rec.poei_information11 ,
325: p_poei_information12_o => pe_poi_shd.g_old_rec.poei_information12 ,
326: p_poei_information13_o => pe_poi_shd.g_old_rec.poei_information13 ,
327: p_poei_information14_o => pe_poi_shd.g_old_rec.poei_information14 ,
328: p_poei_information15_o => pe_poi_shd.g_old_rec.poei_information15 ,
329: p_poei_information16_o => pe_poi_shd.g_old_rec.poei_information16 ,
330: p_poei_information17_o => pe_poi_shd.g_old_rec.poei_information17 ,
331: p_poei_information18_o => pe_poi_shd.g_old_rec.poei_information18 ,
324: p_poei_information11_o => pe_poi_shd.g_old_rec.poei_information11 ,
325: p_poei_information12_o => pe_poi_shd.g_old_rec.poei_information12 ,
326: p_poei_information13_o => pe_poi_shd.g_old_rec.poei_information13 ,
327: p_poei_information14_o => pe_poi_shd.g_old_rec.poei_information14 ,
328: p_poei_information15_o => pe_poi_shd.g_old_rec.poei_information15 ,
329: p_poei_information16_o => pe_poi_shd.g_old_rec.poei_information16 ,
330: p_poei_information17_o => pe_poi_shd.g_old_rec.poei_information17 ,
331: p_poei_information18_o => pe_poi_shd.g_old_rec.poei_information18 ,
332: p_poei_information19_o => pe_poi_shd.g_old_rec.poei_information19 ,
325: p_poei_information12_o => pe_poi_shd.g_old_rec.poei_information12 ,
326: p_poei_information13_o => pe_poi_shd.g_old_rec.poei_information13 ,
327: p_poei_information14_o => pe_poi_shd.g_old_rec.poei_information14 ,
328: p_poei_information15_o => pe_poi_shd.g_old_rec.poei_information15 ,
329: p_poei_information16_o => pe_poi_shd.g_old_rec.poei_information16 ,
330: p_poei_information17_o => pe_poi_shd.g_old_rec.poei_information17 ,
331: p_poei_information18_o => pe_poi_shd.g_old_rec.poei_information18 ,
332: p_poei_information19_o => pe_poi_shd.g_old_rec.poei_information19 ,
333: p_poei_information20_o => pe_poi_shd.g_old_rec.poei_information20 ,
326: p_poei_information13_o => pe_poi_shd.g_old_rec.poei_information13 ,
327: p_poei_information14_o => pe_poi_shd.g_old_rec.poei_information14 ,
328: p_poei_information15_o => pe_poi_shd.g_old_rec.poei_information15 ,
329: p_poei_information16_o => pe_poi_shd.g_old_rec.poei_information16 ,
330: p_poei_information17_o => pe_poi_shd.g_old_rec.poei_information17 ,
331: p_poei_information18_o => pe_poi_shd.g_old_rec.poei_information18 ,
332: p_poei_information19_o => pe_poi_shd.g_old_rec.poei_information19 ,
333: p_poei_information20_o => pe_poi_shd.g_old_rec.poei_information20 ,
334: p_poei_information21_o => pe_poi_shd.g_old_rec.poei_information21 ,
327: p_poei_information14_o => pe_poi_shd.g_old_rec.poei_information14 ,
328: p_poei_information15_o => pe_poi_shd.g_old_rec.poei_information15 ,
329: p_poei_information16_o => pe_poi_shd.g_old_rec.poei_information16 ,
330: p_poei_information17_o => pe_poi_shd.g_old_rec.poei_information17 ,
331: p_poei_information18_o => pe_poi_shd.g_old_rec.poei_information18 ,
332: p_poei_information19_o => pe_poi_shd.g_old_rec.poei_information19 ,
333: p_poei_information20_o => pe_poi_shd.g_old_rec.poei_information20 ,
334: p_poei_information21_o => pe_poi_shd.g_old_rec.poei_information21 ,
335: p_poei_information22_o => pe_poi_shd.g_old_rec.poei_information22 ,
328: p_poei_information15_o => pe_poi_shd.g_old_rec.poei_information15 ,
329: p_poei_information16_o => pe_poi_shd.g_old_rec.poei_information16 ,
330: p_poei_information17_o => pe_poi_shd.g_old_rec.poei_information17 ,
331: p_poei_information18_o => pe_poi_shd.g_old_rec.poei_information18 ,
332: p_poei_information19_o => pe_poi_shd.g_old_rec.poei_information19 ,
333: p_poei_information20_o => pe_poi_shd.g_old_rec.poei_information20 ,
334: p_poei_information21_o => pe_poi_shd.g_old_rec.poei_information21 ,
335: p_poei_information22_o => pe_poi_shd.g_old_rec.poei_information22 ,
336: p_poei_information23_o => pe_poi_shd.g_old_rec.poei_information23 ,
329: p_poei_information16_o => pe_poi_shd.g_old_rec.poei_information16 ,
330: p_poei_information17_o => pe_poi_shd.g_old_rec.poei_information17 ,
331: p_poei_information18_o => pe_poi_shd.g_old_rec.poei_information18 ,
332: p_poei_information19_o => pe_poi_shd.g_old_rec.poei_information19 ,
333: p_poei_information20_o => pe_poi_shd.g_old_rec.poei_information20 ,
334: p_poei_information21_o => pe_poi_shd.g_old_rec.poei_information21 ,
335: p_poei_information22_o => pe_poi_shd.g_old_rec.poei_information22 ,
336: p_poei_information23_o => pe_poi_shd.g_old_rec.poei_information23 ,
337: p_poei_information24_o => pe_poi_shd.g_old_rec.poei_information24 ,
330: p_poei_information17_o => pe_poi_shd.g_old_rec.poei_information17 ,
331: p_poei_information18_o => pe_poi_shd.g_old_rec.poei_information18 ,
332: p_poei_information19_o => pe_poi_shd.g_old_rec.poei_information19 ,
333: p_poei_information20_o => pe_poi_shd.g_old_rec.poei_information20 ,
334: p_poei_information21_o => pe_poi_shd.g_old_rec.poei_information21 ,
335: p_poei_information22_o => pe_poi_shd.g_old_rec.poei_information22 ,
336: p_poei_information23_o => pe_poi_shd.g_old_rec.poei_information23 ,
337: p_poei_information24_o => pe_poi_shd.g_old_rec.poei_information24 ,
338: p_poei_information25_o => pe_poi_shd.g_old_rec.poei_information25 ,
331: p_poei_information18_o => pe_poi_shd.g_old_rec.poei_information18 ,
332: p_poei_information19_o => pe_poi_shd.g_old_rec.poei_information19 ,
333: p_poei_information20_o => pe_poi_shd.g_old_rec.poei_information20 ,
334: p_poei_information21_o => pe_poi_shd.g_old_rec.poei_information21 ,
335: p_poei_information22_o => pe_poi_shd.g_old_rec.poei_information22 ,
336: p_poei_information23_o => pe_poi_shd.g_old_rec.poei_information23 ,
337: p_poei_information24_o => pe_poi_shd.g_old_rec.poei_information24 ,
338: p_poei_information25_o => pe_poi_shd.g_old_rec.poei_information25 ,
339: p_poei_information26_o => pe_poi_shd.g_old_rec.poei_information26 ,
332: p_poei_information19_o => pe_poi_shd.g_old_rec.poei_information19 ,
333: p_poei_information20_o => pe_poi_shd.g_old_rec.poei_information20 ,
334: p_poei_information21_o => pe_poi_shd.g_old_rec.poei_information21 ,
335: p_poei_information22_o => pe_poi_shd.g_old_rec.poei_information22 ,
336: p_poei_information23_o => pe_poi_shd.g_old_rec.poei_information23 ,
337: p_poei_information24_o => pe_poi_shd.g_old_rec.poei_information24 ,
338: p_poei_information25_o => pe_poi_shd.g_old_rec.poei_information25 ,
339: p_poei_information26_o => pe_poi_shd.g_old_rec.poei_information26 ,
340: p_poei_information27_o => pe_poi_shd.g_old_rec.poei_information27 ,
333: p_poei_information20_o => pe_poi_shd.g_old_rec.poei_information20 ,
334: p_poei_information21_o => pe_poi_shd.g_old_rec.poei_information21 ,
335: p_poei_information22_o => pe_poi_shd.g_old_rec.poei_information22 ,
336: p_poei_information23_o => pe_poi_shd.g_old_rec.poei_information23 ,
337: p_poei_information24_o => pe_poi_shd.g_old_rec.poei_information24 ,
338: p_poei_information25_o => pe_poi_shd.g_old_rec.poei_information25 ,
339: p_poei_information26_o => pe_poi_shd.g_old_rec.poei_information26 ,
340: p_poei_information27_o => pe_poi_shd.g_old_rec.poei_information27 ,
341: p_poei_information28_o => pe_poi_shd.g_old_rec.poei_information28 ,
334: p_poei_information21_o => pe_poi_shd.g_old_rec.poei_information21 ,
335: p_poei_information22_o => pe_poi_shd.g_old_rec.poei_information22 ,
336: p_poei_information23_o => pe_poi_shd.g_old_rec.poei_information23 ,
337: p_poei_information24_o => pe_poi_shd.g_old_rec.poei_information24 ,
338: p_poei_information25_o => pe_poi_shd.g_old_rec.poei_information25 ,
339: p_poei_information26_o => pe_poi_shd.g_old_rec.poei_information26 ,
340: p_poei_information27_o => pe_poi_shd.g_old_rec.poei_information27 ,
341: p_poei_information28_o => pe_poi_shd.g_old_rec.poei_information28 ,
342: p_poei_information29_o => pe_poi_shd.g_old_rec.poei_information29 ,
335: p_poei_information22_o => pe_poi_shd.g_old_rec.poei_information22 ,
336: p_poei_information23_o => pe_poi_shd.g_old_rec.poei_information23 ,
337: p_poei_information24_o => pe_poi_shd.g_old_rec.poei_information24 ,
338: p_poei_information25_o => pe_poi_shd.g_old_rec.poei_information25 ,
339: p_poei_information26_o => pe_poi_shd.g_old_rec.poei_information26 ,
340: p_poei_information27_o => pe_poi_shd.g_old_rec.poei_information27 ,
341: p_poei_information28_o => pe_poi_shd.g_old_rec.poei_information28 ,
342: p_poei_information29_o => pe_poi_shd.g_old_rec.poei_information29 ,
343: p_poei_information30_o => pe_poi_shd.g_old_rec.poei_information30
336: p_poei_information23_o => pe_poi_shd.g_old_rec.poei_information23 ,
337: p_poei_information24_o => pe_poi_shd.g_old_rec.poei_information24 ,
338: p_poei_information25_o => pe_poi_shd.g_old_rec.poei_information25 ,
339: p_poei_information26_o => pe_poi_shd.g_old_rec.poei_information26 ,
340: p_poei_information27_o => pe_poi_shd.g_old_rec.poei_information27 ,
341: p_poei_information28_o => pe_poi_shd.g_old_rec.poei_information28 ,
342: p_poei_information29_o => pe_poi_shd.g_old_rec.poei_information29 ,
343: p_poei_information30_o => pe_poi_shd.g_old_rec.poei_information30
344: );
337: p_poei_information24_o => pe_poi_shd.g_old_rec.poei_information24 ,
338: p_poei_information25_o => pe_poi_shd.g_old_rec.poei_information25 ,
339: p_poei_information26_o => pe_poi_shd.g_old_rec.poei_information26 ,
340: p_poei_information27_o => pe_poi_shd.g_old_rec.poei_information27 ,
341: p_poei_information28_o => pe_poi_shd.g_old_rec.poei_information28 ,
342: p_poei_information29_o => pe_poi_shd.g_old_rec.poei_information29 ,
343: p_poei_information30_o => pe_poi_shd.g_old_rec.poei_information30
344: );
345: exception
338: p_poei_information25_o => pe_poi_shd.g_old_rec.poei_information25 ,
339: p_poei_information26_o => pe_poi_shd.g_old_rec.poei_information26 ,
340: p_poei_information27_o => pe_poi_shd.g_old_rec.poei_information27 ,
341: p_poei_information28_o => pe_poi_shd.g_old_rec.poei_information28 ,
342: p_poei_information29_o => pe_poi_shd.g_old_rec.poei_information29 ,
343: p_poei_information30_o => pe_poi_shd.g_old_rec.poei_information30
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
339: p_poei_information26_o => pe_poi_shd.g_old_rec.poei_information26 ,
340: p_poei_information27_o => pe_poi_shd.g_old_rec.poei_information27 ,
341: p_poei_information28_o => pe_poi_shd.g_old_rec.poei_information28 ,
342: p_poei_information29_o => pe_poi_shd.g_old_rec.poei_information29 ,
343: p_poei_information30_o => pe_poi_shd.g_old_rec.poei_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_poi_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.position_id = hr_api.g_number) then
415: p_rec.position_id :=
416: pe_poi_shd.g_old_rec.position_id;
417: End If;
418: If (p_rec.information_type = hr_api.g_varchar2) then
419: p_rec.information_type :=
420: pe_poi_shd.g_old_rec.information_type;
416: pe_poi_shd.g_old_rec.position_id;
417: End If;
418: If (p_rec.information_type = hr_api.g_varchar2) then
419: p_rec.information_type :=
420: pe_poi_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_poi_shd.g_old_rec.request_id;
420: pe_poi_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_poi_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_poi_shd.g_old_rec.program_application_id;
424: pe_poi_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_poi_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_poi_shd.g_old_rec.program_id;
428: pe_poi_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_poi_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_poi_shd.g_old_rec.program_update_date;
432: pe_poi_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_poi_shd.g_old_rec.program_update_date;
437: End If;
438: If (p_rec.poei_attribute_category = hr_api.g_varchar2) then
439: p_rec.poei_attribute_category :=
440: pe_poi_shd.g_old_rec.poei_attribute_category;
436: pe_poi_shd.g_old_rec.program_update_date;
437: End If;
438: If (p_rec.poei_attribute_category = hr_api.g_varchar2) then
439: p_rec.poei_attribute_category :=
440: pe_poi_shd.g_old_rec.poei_attribute_category;
441: End If;
442: If (p_rec.poei_attribute1 = hr_api.g_varchar2) then
443: p_rec.poei_attribute1 :=
444: pe_poi_shd.g_old_rec.poei_attribute1;
440: pe_poi_shd.g_old_rec.poei_attribute_category;
441: End If;
442: If (p_rec.poei_attribute1 = hr_api.g_varchar2) then
443: p_rec.poei_attribute1 :=
444: pe_poi_shd.g_old_rec.poei_attribute1;
445: End If;
446: If (p_rec.poei_attribute2 = hr_api.g_varchar2) then
447: p_rec.poei_attribute2 :=
448: pe_poi_shd.g_old_rec.poei_attribute2;
444: pe_poi_shd.g_old_rec.poei_attribute1;
445: End If;
446: If (p_rec.poei_attribute2 = hr_api.g_varchar2) then
447: p_rec.poei_attribute2 :=
448: pe_poi_shd.g_old_rec.poei_attribute2;
449: End If;
450: If (p_rec.poei_attribute3 = hr_api.g_varchar2) then
451: p_rec.poei_attribute3 :=
452: pe_poi_shd.g_old_rec.poei_attribute3;
448: pe_poi_shd.g_old_rec.poei_attribute2;
449: End If;
450: If (p_rec.poei_attribute3 = hr_api.g_varchar2) then
451: p_rec.poei_attribute3 :=
452: pe_poi_shd.g_old_rec.poei_attribute3;
453: End If;
454: If (p_rec.poei_attribute4 = hr_api.g_varchar2) then
455: p_rec.poei_attribute4 :=
456: pe_poi_shd.g_old_rec.poei_attribute4;
452: pe_poi_shd.g_old_rec.poei_attribute3;
453: End If;
454: If (p_rec.poei_attribute4 = hr_api.g_varchar2) then
455: p_rec.poei_attribute4 :=
456: pe_poi_shd.g_old_rec.poei_attribute4;
457: End If;
458: If (p_rec.poei_attribute5 = hr_api.g_varchar2) then
459: p_rec.poei_attribute5 :=
460: pe_poi_shd.g_old_rec.poei_attribute5;
456: pe_poi_shd.g_old_rec.poei_attribute4;
457: End If;
458: If (p_rec.poei_attribute5 = hr_api.g_varchar2) then
459: p_rec.poei_attribute5 :=
460: pe_poi_shd.g_old_rec.poei_attribute5;
461: End If;
462: If (p_rec.poei_attribute6 = hr_api.g_varchar2) then
463: p_rec.poei_attribute6 :=
464: pe_poi_shd.g_old_rec.poei_attribute6;
460: pe_poi_shd.g_old_rec.poei_attribute5;
461: End If;
462: If (p_rec.poei_attribute6 = hr_api.g_varchar2) then
463: p_rec.poei_attribute6 :=
464: pe_poi_shd.g_old_rec.poei_attribute6;
465: End If;
466: If (p_rec.poei_attribute7 = hr_api.g_varchar2) then
467: p_rec.poei_attribute7 :=
468: pe_poi_shd.g_old_rec.poei_attribute7;
464: pe_poi_shd.g_old_rec.poei_attribute6;
465: End If;
466: If (p_rec.poei_attribute7 = hr_api.g_varchar2) then
467: p_rec.poei_attribute7 :=
468: pe_poi_shd.g_old_rec.poei_attribute7;
469: End If;
470: If (p_rec.poei_attribute8 = hr_api.g_varchar2) then
471: p_rec.poei_attribute8 :=
472: pe_poi_shd.g_old_rec.poei_attribute8;
468: pe_poi_shd.g_old_rec.poei_attribute7;
469: End If;
470: If (p_rec.poei_attribute8 = hr_api.g_varchar2) then
471: p_rec.poei_attribute8 :=
472: pe_poi_shd.g_old_rec.poei_attribute8;
473: End If;
474: If (p_rec.poei_attribute9 = hr_api.g_varchar2) then
475: p_rec.poei_attribute9 :=
476: pe_poi_shd.g_old_rec.poei_attribute9;
472: pe_poi_shd.g_old_rec.poei_attribute8;
473: End If;
474: If (p_rec.poei_attribute9 = hr_api.g_varchar2) then
475: p_rec.poei_attribute9 :=
476: pe_poi_shd.g_old_rec.poei_attribute9;
477: End If;
478: If (p_rec.poei_attribute10 = hr_api.g_varchar2) then
479: p_rec.poei_attribute10 :=
480: pe_poi_shd.g_old_rec.poei_attribute10;
476: pe_poi_shd.g_old_rec.poei_attribute9;
477: End If;
478: If (p_rec.poei_attribute10 = hr_api.g_varchar2) then
479: p_rec.poei_attribute10 :=
480: pe_poi_shd.g_old_rec.poei_attribute10;
481: End If;
482: If (p_rec.poei_attribute11 = hr_api.g_varchar2) then
483: p_rec.poei_attribute11 :=
484: pe_poi_shd.g_old_rec.poei_attribute11;
480: pe_poi_shd.g_old_rec.poei_attribute10;
481: End If;
482: If (p_rec.poei_attribute11 = hr_api.g_varchar2) then
483: p_rec.poei_attribute11 :=
484: pe_poi_shd.g_old_rec.poei_attribute11;
485: End If;
486: If (p_rec.poei_attribute12 = hr_api.g_varchar2) then
487: p_rec.poei_attribute12 :=
488: pe_poi_shd.g_old_rec.poei_attribute12;
484: pe_poi_shd.g_old_rec.poei_attribute11;
485: End If;
486: If (p_rec.poei_attribute12 = hr_api.g_varchar2) then
487: p_rec.poei_attribute12 :=
488: pe_poi_shd.g_old_rec.poei_attribute12;
489: End If;
490: If (p_rec.poei_attribute13 = hr_api.g_varchar2) then
491: p_rec.poei_attribute13 :=
492: pe_poi_shd.g_old_rec.poei_attribute13;
488: pe_poi_shd.g_old_rec.poei_attribute12;
489: End If;
490: If (p_rec.poei_attribute13 = hr_api.g_varchar2) then
491: p_rec.poei_attribute13 :=
492: pe_poi_shd.g_old_rec.poei_attribute13;
493: End If;
494: If (p_rec.poei_attribute14 = hr_api.g_varchar2) then
495: p_rec.poei_attribute14 :=
496: pe_poi_shd.g_old_rec.poei_attribute14;
492: pe_poi_shd.g_old_rec.poei_attribute13;
493: End If;
494: If (p_rec.poei_attribute14 = hr_api.g_varchar2) then
495: p_rec.poei_attribute14 :=
496: pe_poi_shd.g_old_rec.poei_attribute14;
497: End If;
498: If (p_rec.poei_attribute15 = hr_api.g_varchar2) then
499: p_rec.poei_attribute15 :=
500: pe_poi_shd.g_old_rec.poei_attribute15;
496: pe_poi_shd.g_old_rec.poei_attribute14;
497: End If;
498: If (p_rec.poei_attribute15 = hr_api.g_varchar2) then
499: p_rec.poei_attribute15 :=
500: pe_poi_shd.g_old_rec.poei_attribute15;
501: End If;
502: If (p_rec.poei_attribute16 = hr_api.g_varchar2) then
503: p_rec.poei_attribute16 :=
504: pe_poi_shd.g_old_rec.poei_attribute16;
500: pe_poi_shd.g_old_rec.poei_attribute15;
501: End If;
502: If (p_rec.poei_attribute16 = hr_api.g_varchar2) then
503: p_rec.poei_attribute16 :=
504: pe_poi_shd.g_old_rec.poei_attribute16;
505: End If;
506: If (p_rec.poei_attribute17 = hr_api.g_varchar2) then
507: p_rec.poei_attribute17 :=
508: pe_poi_shd.g_old_rec.poei_attribute17;
504: pe_poi_shd.g_old_rec.poei_attribute16;
505: End If;
506: If (p_rec.poei_attribute17 = hr_api.g_varchar2) then
507: p_rec.poei_attribute17 :=
508: pe_poi_shd.g_old_rec.poei_attribute17;
509: End If;
510: If (p_rec.poei_attribute18 = hr_api.g_varchar2) then
511: p_rec.poei_attribute18 :=
512: pe_poi_shd.g_old_rec.poei_attribute18;
508: pe_poi_shd.g_old_rec.poei_attribute17;
509: End If;
510: If (p_rec.poei_attribute18 = hr_api.g_varchar2) then
511: p_rec.poei_attribute18 :=
512: pe_poi_shd.g_old_rec.poei_attribute18;
513: End If;
514: If (p_rec.poei_attribute19 = hr_api.g_varchar2) then
515: p_rec.poei_attribute19 :=
516: pe_poi_shd.g_old_rec.poei_attribute19;
512: pe_poi_shd.g_old_rec.poei_attribute18;
513: End If;
514: If (p_rec.poei_attribute19 = hr_api.g_varchar2) then
515: p_rec.poei_attribute19 :=
516: pe_poi_shd.g_old_rec.poei_attribute19;
517: End If;
518: If (p_rec.poei_attribute20 = hr_api.g_varchar2) then
519: p_rec.poei_attribute20 :=
520: pe_poi_shd.g_old_rec.poei_attribute20;
516: pe_poi_shd.g_old_rec.poei_attribute19;
517: End If;
518: If (p_rec.poei_attribute20 = hr_api.g_varchar2) then
519: p_rec.poei_attribute20 :=
520: pe_poi_shd.g_old_rec.poei_attribute20;
521: End If;
522: If (p_rec.poei_information_category = hr_api.g_varchar2) then
523: p_rec.poei_information_category :=
524: pe_poi_shd.g_old_rec.poei_information_category;
520: pe_poi_shd.g_old_rec.poei_attribute20;
521: End If;
522: If (p_rec.poei_information_category = hr_api.g_varchar2) then
523: p_rec.poei_information_category :=
524: pe_poi_shd.g_old_rec.poei_information_category;
525: End If;
526: If (p_rec.poei_information1 = hr_api.g_varchar2) then
527: p_rec.poei_information1 :=
528: pe_poi_shd.g_old_rec.poei_information1;
524: pe_poi_shd.g_old_rec.poei_information_category;
525: End If;
526: If (p_rec.poei_information1 = hr_api.g_varchar2) then
527: p_rec.poei_information1 :=
528: pe_poi_shd.g_old_rec.poei_information1;
529: End If;
530: If (p_rec.poei_information2 = hr_api.g_varchar2) then
531: p_rec.poei_information2 :=
532: pe_poi_shd.g_old_rec.poei_information2;
528: pe_poi_shd.g_old_rec.poei_information1;
529: End If;
530: If (p_rec.poei_information2 = hr_api.g_varchar2) then
531: p_rec.poei_information2 :=
532: pe_poi_shd.g_old_rec.poei_information2;
533: End If;
534: If (p_rec.poei_information3 = hr_api.g_varchar2) then
535: p_rec.poei_information3 :=
536: pe_poi_shd.g_old_rec.poei_information3;
532: pe_poi_shd.g_old_rec.poei_information2;
533: End If;
534: If (p_rec.poei_information3 = hr_api.g_varchar2) then
535: p_rec.poei_information3 :=
536: pe_poi_shd.g_old_rec.poei_information3;
537: End If;
538: If (p_rec.poei_information4 = hr_api.g_varchar2) then
539: p_rec.poei_information4 :=
540: pe_poi_shd.g_old_rec.poei_information4;
536: pe_poi_shd.g_old_rec.poei_information3;
537: End If;
538: If (p_rec.poei_information4 = hr_api.g_varchar2) then
539: p_rec.poei_information4 :=
540: pe_poi_shd.g_old_rec.poei_information4;
541: End If;
542: If (p_rec.poei_information5 = hr_api.g_varchar2) then
543: p_rec.poei_information5 :=
544: pe_poi_shd.g_old_rec.poei_information5;
540: pe_poi_shd.g_old_rec.poei_information4;
541: End If;
542: If (p_rec.poei_information5 = hr_api.g_varchar2) then
543: p_rec.poei_information5 :=
544: pe_poi_shd.g_old_rec.poei_information5;
545: End If;
546: If (p_rec.poei_information6 = hr_api.g_varchar2) then
547: p_rec.poei_information6 :=
548: pe_poi_shd.g_old_rec.poei_information6;
544: pe_poi_shd.g_old_rec.poei_information5;
545: End If;
546: If (p_rec.poei_information6 = hr_api.g_varchar2) then
547: p_rec.poei_information6 :=
548: pe_poi_shd.g_old_rec.poei_information6;
549: End If;
550: If (p_rec.poei_information7 = hr_api.g_varchar2) then
551: p_rec.poei_information7 :=
552: pe_poi_shd.g_old_rec.poei_information7;
548: pe_poi_shd.g_old_rec.poei_information6;
549: End If;
550: If (p_rec.poei_information7 = hr_api.g_varchar2) then
551: p_rec.poei_information7 :=
552: pe_poi_shd.g_old_rec.poei_information7;
553: End If;
554: If (p_rec.poei_information8 = hr_api.g_varchar2) then
555: p_rec.poei_information8 :=
556: pe_poi_shd.g_old_rec.poei_information8;
552: pe_poi_shd.g_old_rec.poei_information7;
553: End If;
554: If (p_rec.poei_information8 = hr_api.g_varchar2) then
555: p_rec.poei_information8 :=
556: pe_poi_shd.g_old_rec.poei_information8;
557: End If;
558: If (p_rec.poei_information9 = hr_api.g_varchar2) then
559: p_rec.poei_information9 :=
560: pe_poi_shd.g_old_rec.poei_information9;
556: pe_poi_shd.g_old_rec.poei_information8;
557: End If;
558: If (p_rec.poei_information9 = hr_api.g_varchar2) then
559: p_rec.poei_information9 :=
560: pe_poi_shd.g_old_rec.poei_information9;
561: End If;
562: If (p_rec.poei_information10 = hr_api.g_varchar2) then
563: p_rec.poei_information10 :=
564: pe_poi_shd.g_old_rec.poei_information10;
560: pe_poi_shd.g_old_rec.poei_information9;
561: End If;
562: If (p_rec.poei_information10 = hr_api.g_varchar2) then
563: p_rec.poei_information10 :=
564: pe_poi_shd.g_old_rec.poei_information10;
565: End If;
566: If (p_rec.poei_information11 = hr_api.g_varchar2) then
567: p_rec.poei_information11 :=
568: pe_poi_shd.g_old_rec.poei_information11;
564: pe_poi_shd.g_old_rec.poei_information10;
565: End If;
566: If (p_rec.poei_information11 = hr_api.g_varchar2) then
567: p_rec.poei_information11 :=
568: pe_poi_shd.g_old_rec.poei_information11;
569: End If;
570: If (p_rec.poei_information12 = hr_api.g_varchar2) then
571: p_rec.poei_information12 :=
572: pe_poi_shd.g_old_rec.poei_information12;
568: pe_poi_shd.g_old_rec.poei_information11;
569: End If;
570: If (p_rec.poei_information12 = hr_api.g_varchar2) then
571: p_rec.poei_information12 :=
572: pe_poi_shd.g_old_rec.poei_information12;
573: End If;
574: If (p_rec.poei_information13 = hr_api.g_varchar2) then
575: p_rec.poei_information13 :=
576: pe_poi_shd.g_old_rec.poei_information13;
572: pe_poi_shd.g_old_rec.poei_information12;
573: End If;
574: If (p_rec.poei_information13 = hr_api.g_varchar2) then
575: p_rec.poei_information13 :=
576: pe_poi_shd.g_old_rec.poei_information13;
577: End If;
578: If (p_rec.poei_information14 = hr_api.g_varchar2) then
579: p_rec.poei_information14 :=
580: pe_poi_shd.g_old_rec.poei_information14;
576: pe_poi_shd.g_old_rec.poei_information13;
577: End If;
578: If (p_rec.poei_information14 = hr_api.g_varchar2) then
579: p_rec.poei_information14 :=
580: pe_poi_shd.g_old_rec.poei_information14;
581: End If;
582: If (p_rec.poei_information15 = hr_api.g_varchar2) then
583: p_rec.poei_information15 :=
584: pe_poi_shd.g_old_rec.poei_information15;
580: pe_poi_shd.g_old_rec.poei_information14;
581: End If;
582: If (p_rec.poei_information15 = hr_api.g_varchar2) then
583: p_rec.poei_information15 :=
584: pe_poi_shd.g_old_rec.poei_information15;
585: End If;
586: If (p_rec.poei_information16 = hr_api.g_varchar2) then
587: p_rec.poei_information16 :=
588: pe_poi_shd.g_old_rec.poei_information16;
584: pe_poi_shd.g_old_rec.poei_information15;
585: End If;
586: If (p_rec.poei_information16 = hr_api.g_varchar2) then
587: p_rec.poei_information16 :=
588: pe_poi_shd.g_old_rec.poei_information16;
589: End If;
590: If (p_rec.poei_information17 = hr_api.g_varchar2) then
591: p_rec.poei_information17 :=
592: pe_poi_shd.g_old_rec.poei_information17;
588: pe_poi_shd.g_old_rec.poei_information16;
589: End If;
590: If (p_rec.poei_information17 = hr_api.g_varchar2) then
591: p_rec.poei_information17 :=
592: pe_poi_shd.g_old_rec.poei_information17;
593: End If;
594: If (p_rec.poei_information18 = hr_api.g_varchar2) then
595: p_rec.poei_information18 :=
596: pe_poi_shd.g_old_rec.poei_information18;
592: pe_poi_shd.g_old_rec.poei_information17;
593: End If;
594: If (p_rec.poei_information18 = hr_api.g_varchar2) then
595: p_rec.poei_information18 :=
596: pe_poi_shd.g_old_rec.poei_information18;
597: End If;
598: If (p_rec.poei_information19 = hr_api.g_varchar2) then
599: p_rec.poei_information19 :=
600: pe_poi_shd.g_old_rec.poei_information19;
596: pe_poi_shd.g_old_rec.poei_information18;
597: End If;
598: If (p_rec.poei_information19 = hr_api.g_varchar2) then
599: p_rec.poei_information19 :=
600: pe_poi_shd.g_old_rec.poei_information19;
601: End If;
602: If (p_rec.poei_information20 = hr_api.g_varchar2) then
603: p_rec.poei_information20 :=
604: pe_poi_shd.g_old_rec.poei_information20;
600: pe_poi_shd.g_old_rec.poei_information19;
601: End If;
602: If (p_rec.poei_information20 = hr_api.g_varchar2) then
603: p_rec.poei_information20 :=
604: pe_poi_shd.g_old_rec.poei_information20;
605: End If;
606: If (p_rec.poei_information21 = hr_api.g_varchar2) then
607: p_rec.poei_information21 :=
608: pe_poi_shd.g_old_rec.poei_information21;
604: pe_poi_shd.g_old_rec.poei_information20;
605: End If;
606: If (p_rec.poei_information21 = hr_api.g_varchar2) then
607: p_rec.poei_information21 :=
608: pe_poi_shd.g_old_rec.poei_information21;
609: End If;
610: If (p_rec.poei_information22 = hr_api.g_varchar2) then
611: p_rec.poei_information22 :=
612: pe_poi_shd.g_old_rec.poei_information22;
608: pe_poi_shd.g_old_rec.poei_information21;
609: End If;
610: If (p_rec.poei_information22 = hr_api.g_varchar2) then
611: p_rec.poei_information22 :=
612: pe_poi_shd.g_old_rec.poei_information22;
613: End If;
614: If (p_rec.poei_information23 = hr_api.g_varchar2) then
615: p_rec.poei_information23 :=
616: pe_poi_shd.g_old_rec.poei_information23;
612: pe_poi_shd.g_old_rec.poei_information22;
613: End If;
614: If (p_rec.poei_information23 = hr_api.g_varchar2) then
615: p_rec.poei_information23 :=
616: pe_poi_shd.g_old_rec.poei_information23;
617: End If;
618: If (p_rec.poei_information24 = hr_api.g_varchar2) then
619: p_rec.poei_information24 :=
620: pe_poi_shd.g_old_rec.poei_information24;
616: pe_poi_shd.g_old_rec.poei_information23;
617: End If;
618: If (p_rec.poei_information24 = hr_api.g_varchar2) then
619: p_rec.poei_information24 :=
620: pe_poi_shd.g_old_rec.poei_information24;
621: End If;
622: If (p_rec.poei_information25 = hr_api.g_varchar2) then
623: p_rec.poei_information25 :=
624: pe_poi_shd.g_old_rec.poei_information25;
620: pe_poi_shd.g_old_rec.poei_information24;
621: End If;
622: If (p_rec.poei_information25 = hr_api.g_varchar2) then
623: p_rec.poei_information25 :=
624: pe_poi_shd.g_old_rec.poei_information25;
625: End If;
626: If (p_rec.poei_information26 = hr_api.g_varchar2) then
627: p_rec.poei_information26 :=
628: pe_poi_shd.g_old_rec.poei_information26;
624: pe_poi_shd.g_old_rec.poei_information25;
625: End If;
626: If (p_rec.poei_information26 = hr_api.g_varchar2) then
627: p_rec.poei_information26 :=
628: pe_poi_shd.g_old_rec.poei_information26;
629: End If;
630: If (p_rec.poei_information27 = hr_api.g_varchar2) then
631: p_rec.poei_information27 :=
632: pe_poi_shd.g_old_rec.poei_information27;
628: pe_poi_shd.g_old_rec.poei_information26;
629: End If;
630: If (p_rec.poei_information27 = hr_api.g_varchar2) then
631: p_rec.poei_information27 :=
632: pe_poi_shd.g_old_rec.poei_information27;
633: End If;
634: If (p_rec.poei_information28 = hr_api.g_varchar2) then
635: p_rec.poei_information28 :=
636: pe_poi_shd.g_old_rec.poei_information28;
632: pe_poi_shd.g_old_rec.poei_information27;
633: End If;
634: If (p_rec.poei_information28 = hr_api.g_varchar2) then
635: p_rec.poei_information28 :=
636: pe_poi_shd.g_old_rec.poei_information28;
637: End If;
638: If (p_rec.poei_information29 = hr_api.g_varchar2) then
639: p_rec.poei_information29 :=
640: pe_poi_shd.g_old_rec.poei_information29;
636: pe_poi_shd.g_old_rec.poei_information28;
637: End If;
638: If (p_rec.poei_information29 = hr_api.g_varchar2) then
639: p_rec.poei_information29 :=
640: pe_poi_shd.g_old_rec.poei_information29;
641: End If;
642: If (p_rec.poei_information30 = hr_api.g_varchar2) then
643: p_rec.poei_information30 :=
644: pe_poi_shd.g_old_rec.poei_information30;
640: pe_poi_shd.g_old_rec.poei_information29;
641: End If;
642: If (p_rec.poei_information30 = hr_api.g_varchar2) then
643: p_rec.poei_information30 :=
644: pe_poi_shd.g_old_rec.poei_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_poi_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_poi_shd.lck
678: (
679: p_rec.position_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_poi_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_poi_shd.convert_args
797: (
798: p_position_extra_info_id,
799: hr_api.g_number, -- p_position_id,
800: hr_api.g_varchar2, -- p_information_type,