DBA Data[Home] [Help]

APPS.PE_POI_UPD dependencies on PE_POI_SHD

Line 48: Procedure update_dml(p_rec in out nocopy pe_poi_shd.g_rec_type) is

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

Line 128: pe_poi_shd.constraint_error

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

Line 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

Line 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;

Line 174: Procedure pre_update(p_rec in pe_poi_shd.g_rec_type) is

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

Line 216: Procedure post_update(p_rec in pe_poi_shd.g_rec_type) is

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

Line 286: p_position_id_o => pe_poi_shd.g_old_rec.position_id ,

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 ,

Line 287: p_information_type_o => pe_poi_shd.g_old_rec.information_type ,

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 ,

Line 288: p_request_id_o => pe_poi_shd.g_old_rec.request_id ,

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 ,

Line 289: p_program_application_id_o => pe_poi_shd.g_old_rec.program_application_id ,

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 ,

Line 290: p_program_id_o => pe_poi_shd.g_old_rec.program_id ,

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 ,

Line 291: p_program_update_date_o => pe_poi_shd.g_old_rec.program_update_date ,

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 ,

Line 292: p_poei_attribute_category_o => pe_poi_shd.g_old_rec.poei_attribute_category ,

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 ,

Line 293: p_poei_attribute1_o => pe_poi_shd.g_old_rec.poei_attribute1 ,

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 ,

Line 294: p_poei_attribute2_o => pe_poi_shd.g_old_rec.poei_attribute2 ,

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 ,

Line 295: p_poei_attribute3_o => pe_poi_shd.g_old_rec.poei_attribute3 ,

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 ,

Line 296: p_poei_attribute4_o => pe_poi_shd.g_old_rec.poei_attribute4 ,

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 ,

Line 297: p_poei_attribute5_o => pe_poi_shd.g_old_rec.poei_attribute5 ,

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 ,

Line 298: p_poei_attribute6_o => pe_poi_shd.g_old_rec.poei_attribute6 ,

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 ,

Line 299: p_poei_attribute7_o => pe_poi_shd.g_old_rec.poei_attribute7 ,

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 ,

Line 300: p_poei_attribute8_o => pe_poi_shd.g_old_rec.poei_attribute8 ,

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 ,

Line 301: p_poei_attribute9_o => pe_poi_shd.g_old_rec.poei_attribute9 ,

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 ,

Line 302: p_poei_attribute10_o => pe_poi_shd.g_old_rec.poei_attribute10 ,

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 ,

Line 303: p_poei_attribute11_o => pe_poi_shd.g_old_rec.poei_attribute11 ,

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 ,

Line 304: p_poei_attribute12_o => pe_poi_shd.g_old_rec.poei_attribute12 ,

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 ,

Line 305: p_poei_attribute13_o => pe_poi_shd.g_old_rec.poei_attribute13 ,

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 ,

Line 306: p_poei_attribute14_o => pe_poi_shd.g_old_rec.poei_attribute14 ,

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 ,

Line 307: p_poei_attribute15_o => pe_poi_shd.g_old_rec.poei_attribute15 ,

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 ,

Line 308: p_poei_attribute16_o => pe_poi_shd.g_old_rec.poei_attribute16 ,

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 ,

Line 309: p_poei_attribute17_o => pe_poi_shd.g_old_rec.poei_attribute17 ,

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 ,

Line 310: p_poei_attribute18_o => pe_poi_shd.g_old_rec.poei_attribute18 ,

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 ,

Line 311: p_poei_attribute19_o => pe_poi_shd.g_old_rec.poei_attribute19 ,

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 ,

Line 312: p_poei_attribute20_o => pe_poi_shd.g_old_rec.poei_attribute20 ,

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 ,

Line 313: p_poei_information_category_o => pe_poi_shd.g_old_rec.poei_information_category ,

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 ,

Line 314: p_poei_information1_o => pe_poi_shd.g_old_rec.poei_information1 ,

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 ,

Line 315: p_poei_information2_o => pe_poi_shd.g_old_rec.poei_information2 ,

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 ,

Line 316: p_poei_information3_o => pe_poi_shd.g_old_rec.poei_information3 ,

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 ,

Line 317: p_poei_information4_o => pe_poi_shd.g_old_rec.poei_information4 ,

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 ,

Line 318: p_poei_information5_o => pe_poi_shd.g_old_rec.poei_information5 ,

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 ,

Line 319: p_poei_information6_o => pe_poi_shd.g_old_rec.poei_information6 ,

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 ,

Line 320: p_poei_information7_o => pe_poi_shd.g_old_rec.poei_information7 ,

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 ,

Line 321: p_poei_information8_o => pe_poi_shd.g_old_rec.poei_information8 ,

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 ,

Line 322: p_poei_information9_o => pe_poi_shd.g_old_rec.poei_information9 ,

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 ,

Line 323: p_poei_information10_o => pe_poi_shd.g_old_rec.poei_information10 ,

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 ,

Line 324: p_poei_information11_o => pe_poi_shd.g_old_rec.poei_information11 ,

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 ,

Line 325: p_poei_information12_o => pe_poi_shd.g_old_rec.poei_information12 ,

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 ,

Line 326: p_poei_information13_o => pe_poi_shd.g_old_rec.poei_information13 ,

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 ,

Line 327: p_poei_information14_o => pe_poi_shd.g_old_rec.poei_information14 ,

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 ,

Line 328: p_poei_information15_o => pe_poi_shd.g_old_rec.poei_information15 ,

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 ,

Line 329: p_poei_information16_o => pe_poi_shd.g_old_rec.poei_information16 ,

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 ,

Line 330: p_poei_information17_o => pe_poi_shd.g_old_rec.poei_information17 ,

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 ,

Line 331: p_poei_information18_o => pe_poi_shd.g_old_rec.poei_information18 ,

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 ,

Line 332: p_poei_information19_o => pe_poi_shd.g_old_rec.poei_information19 ,

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 ,

Line 333: p_poei_information20_o => pe_poi_shd.g_old_rec.poei_information20 ,

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 ,

Line 334: p_poei_information21_o => pe_poi_shd.g_old_rec.poei_information21 ,

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 ,

Line 335: p_poei_information22_o => pe_poi_shd.g_old_rec.poei_information22 ,

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 ,

Line 336: p_poei_information23_o => pe_poi_shd.g_old_rec.poei_information23 ,

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 ,

Line 337: p_poei_information24_o => pe_poi_shd.g_old_rec.poei_information24 ,

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 ,

Line 338: p_poei_information25_o => pe_poi_shd.g_old_rec.poei_information25 ,

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 ,

Line 339: p_poei_information26_o => pe_poi_shd.g_old_rec.poei_information26 ,

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

Line 340: p_poei_information27_o => pe_poi_shd.g_old_rec.poei_information27 ,

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: );

Line 341: p_poei_information28_o => pe_poi_shd.g_old_rec.poei_information28 ,

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

Line 342: p_poei_information29_o => pe_poi_shd.g_old_rec.poei_information29 ,

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

Line 343: p_poei_information30_o => pe_poi_shd.g_old_rec.poei_information30

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

Line 401: Procedure convert_defs(p_rec in out nocopy pe_poi_shd.g_rec_type) is

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

Line 416: pe_poi_shd.g_old_rec.position_id;

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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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);

Line 657: p_rec in out nocopy pe_poi_shd.g_rec_type,

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';

Line 677: pe_poi_shd.lck

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: );

Line 786: l_rec pe_poi_shd.g_rec_type;

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);

Line 796: pe_poi_shd.convert_args

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,