eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PE_PEI_UPD dependencies on PE_PEI_SHD

Line 58: Procedure update_dml(p_rec in out NOCOPY pe_pei_shd.g_rec_type) is

54: -- Internal Table Handler Use Only.
55: --
56: -- {End Of Comments}
57: -- ----------------------------------------------------------------------------
58: Procedure update_dml(p_rec in out NOCOPY pe_pei_shd.g_rec_type) is
59: --
60: l_proc varchar2(72) := g_package||'update_dml';
61: --
62: Begin

Line 138: pe_pei_shd.constraint_error

134: --
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: pe_pei_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.parent_integrity_violated Then
141: -- Parent integrity has been violated
142: pe_pei_shd.constraint_error

Line 142: pe_pei_shd.constraint_error

138: pe_pei_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.parent_integrity_violated Then
141: -- Parent integrity has been violated
142: pe_pei_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: pe_pei_shd.constraint_error

Line 146: pe_pei_shd.constraint_error

142: pe_pei_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: pe_pei_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: Raise;
150: End update_dml;

Line 184: Procedure pre_update(p_rec in pe_pei_shd.g_rec_type) is

180: -- Internal Table Handler Use Only.
181: --
182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure pre_update(p_rec in pe_pei_shd.g_rec_type) is
185: --
186: l_proc varchar2(72) := g_package||'pre_update';
187: --
188: Begin

Line 226: Procedure post_update(p_rec in pe_pei_shd.g_rec_type) is

222: -- Internal Table Handler Use Only.
223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure post_update(p_rec in pe_pei_shd.g_rec_type) is
227: --
228: l_proc varchar2(72) := g_package||'post_update';
229: l_eot date := to_date('31/12/4712','dd/mm/yyyy');
230: --

Line 297: p_person_id_o => pe_pei_shd.g_old_rec.person_id ,

293: p_pei_information27 => p_rec.pei_information27 ,
294: p_pei_information28 => p_rec.pei_information28 ,
295: p_pei_information29 => p_rec.pei_information29 ,
296: p_pei_information30 => p_rec.pei_information30 ,
297: p_person_id_o => pe_pei_shd.g_old_rec.person_id ,
298: p_information_type_o => pe_pei_shd.g_old_rec.information_type ,
299: p_request_id_o => pe_pei_shd.g_old_rec.request_id ,
300: p_program_application_id_o => pe_pei_shd.g_old_rec.program_application_id ,
301: p_program_id_o => pe_pei_shd.g_old_rec.program_id ,

Line 298: p_information_type_o => pe_pei_shd.g_old_rec.information_type ,

294: p_pei_information28 => p_rec.pei_information28 ,
295: p_pei_information29 => p_rec.pei_information29 ,
296: p_pei_information30 => p_rec.pei_information30 ,
297: p_person_id_o => pe_pei_shd.g_old_rec.person_id ,
298: p_information_type_o => pe_pei_shd.g_old_rec.information_type ,
299: p_request_id_o => pe_pei_shd.g_old_rec.request_id ,
300: p_program_application_id_o => pe_pei_shd.g_old_rec.program_application_id ,
301: p_program_id_o => pe_pei_shd.g_old_rec.program_id ,
302: p_program_update_date_o => pe_pei_shd.g_old_rec.program_update_date ,

Line 299: p_request_id_o => pe_pei_shd.g_old_rec.request_id ,

295: p_pei_information29 => p_rec.pei_information29 ,
296: p_pei_information30 => p_rec.pei_information30 ,
297: p_person_id_o => pe_pei_shd.g_old_rec.person_id ,
298: p_information_type_o => pe_pei_shd.g_old_rec.information_type ,
299: p_request_id_o => pe_pei_shd.g_old_rec.request_id ,
300: p_program_application_id_o => pe_pei_shd.g_old_rec.program_application_id ,
301: p_program_id_o => pe_pei_shd.g_old_rec.program_id ,
302: p_program_update_date_o => pe_pei_shd.g_old_rec.program_update_date ,
303: p_pei_attribute_category_o => pe_pei_shd.g_old_rec.pei_attribute_category ,

Line 300: p_program_application_id_o => pe_pei_shd.g_old_rec.program_application_id ,

296: p_pei_information30 => p_rec.pei_information30 ,
297: p_person_id_o => pe_pei_shd.g_old_rec.person_id ,
298: p_information_type_o => pe_pei_shd.g_old_rec.information_type ,
299: p_request_id_o => pe_pei_shd.g_old_rec.request_id ,
300: p_program_application_id_o => pe_pei_shd.g_old_rec.program_application_id ,
301: p_program_id_o => pe_pei_shd.g_old_rec.program_id ,
302: p_program_update_date_o => pe_pei_shd.g_old_rec.program_update_date ,
303: p_pei_attribute_category_o => pe_pei_shd.g_old_rec.pei_attribute_category ,
304: p_pei_attribute1_o => pe_pei_shd.g_old_rec.pei_attribute1 ,

Line 301: p_program_id_o => pe_pei_shd.g_old_rec.program_id ,

297: p_person_id_o => pe_pei_shd.g_old_rec.person_id ,
298: p_information_type_o => pe_pei_shd.g_old_rec.information_type ,
299: p_request_id_o => pe_pei_shd.g_old_rec.request_id ,
300: p_program_application_id_o => pe_pei_shd.g_old_rec.program_application_id ,
301: p_program_id_o => pe_pei_shd.g_old_rec.program_id ,
302: p_program_update_date_o => pe_pei_shd.g_old_rec.program_update_date ,
303: p_pei_attribute_category_o => pe_pei_shd.g_old_rec.pei_attribute_category ,
304: p_pei_attribute1_o => pe_pei_shd.g_old_rec.pei_attribute1 ,
305: p_pei_attribute2_o => pe_pei_shd.g_old_rec.pei_attribute2 ,

Line 302: p_program_update_date_o => pe_pei_shd.g_old_rec.program_update_date ,

298: p_information_type_o => pe_pei_shd.g_old_rec.information_type ,
299: p_request_id_o => pe_pei_shd.g_old_rec.request_id ,
300: p_program_application_id_o => pe_pei_shd.g_old_rec.program_application_id ,
301: p_program_id_o => pe_pei_shd.g_old_rec.program_id ,
302: p_program_update_date_o => pe_pei_shd.g_old_rec.program_update_date ,
303: p_pei_attribute_category_o => pe_pei_shd.g_old_rec.pei_attribute_category ,
304: p_pei_attribute1_o => pe_pei_shd.g_old_rec.pei_attribute1 ,
305: p_pei_attribute2_o => pe_pei_shd.g_old_rec.pei_attribute2 ,
306: p_pei_attribute3_o => pe_pei_shd.g_old_rec.pei_attribute3 ,

Line 303: p_pei_attribute_category_o => pe_pei_shd.g_old_rec.pei_attribute_category ,

299: p_request_id_o => pe_pei_shd.g_old_rec.request_id ,
300: p_program_application_id_o => pe_pei_shd.g_old_rec.program_application_id ,
301: p_program_id_o => pe_pei_shd.g_old_rec.program_id ,
302: p_program_update_date_o => pe_pei_shd.g_old_rec.program_update_date ,
303: p_pei_attribute_category_o => pe_pei_shd.g_old_rec.pei_attribute_category ,
304: p_pei_attribute1_o => pe_pei_shd.g_old_rec.pei_attribute1 ,
305: p_pei_attribute2_o => pe_pei_shd.g_old_rec.pei_attribute2 ,
306: p_pei_attribute3_o => pe_pei_shd.g_old_rec.pei_attribute3 ,
307: p_pei_attribute4_o => pe_pei_shd.g_old_rec.pei_attribute4 ,

Line 304: p_pei_attribute1_o => pe_pei_shd.g_old_rec.pei_attribute1 ,

300: p_program_application_id_o => pe_pei_shd.g_old_rec.program_application_id ,
301: p_program_id_o => pe_pei_shd.g_old_rec.program_id ,
302: p_program_update_date_o => pe_pei_shd.g_old_rec.program_update_date ,
303: p_pei_attribute_category_o => pe_pei_shd.g_old_rec.pei_attribute_category ,
304: p_pei_attribute1_o => pe_pei_shd.g_old_rec.pei_attribute1 ,
305: p_pei_attribute2_o => pe_pei_shd.g_old_rec.pei_attribute2 ,
306: p_pei_attribute3_o => pe_pei_shd.g_old_rec.pei_attribute3 ,
307: p_pei_attribute4_o => pe_pei_shd.g_old_rec.pei_attribute4 ,
308: p_pei_attribute5_o => pe_pei_shd.g_old_rec.pei_attribute5 ,

Line 305: p_pei_attribute2_o => pe_pei_shd.g_old_rec.pei_attribute2 ,

301: p_program_id_o => pe_pei_shd.g_old_rec.program_id ,
302: p_program_update_date_o => pe_pei_shd.g_old_rec.program_update_date ,
303: p_pei_attribute_category_o => pe_pei_shd.g_old_rec.pei_attribute_category ,
304: p_pei_attribute1_o => pe_pei_shd.g_old_rec.pei_attribute1 ,
305: p_pei_attribute2_o => pe_pei_shd.g_old_rec.pei_attribute2 ,
306: p_pei_attribute3_o => pe_pei_shd.g_old_rec.pei_attribute3 ,
307: p_pei_attribute4_o => pe_pei_shd.g_old_rec.pei_attribute4 ,
308: p_pei_attribute5_o => pe_pei_shd.g_old_rec.pei_attribute5 ,
309: p_pei_attribute6_o => pe_pei_shd.g_old_rec.pei_attribute6 ,

Line 306: p_pei_attribute3_o => pe_pei_shd.g_old_rec.pei_attribute3 ,

302: p_program_update_date_o => pe_pei_shd.g_old_rec.program_update_date ,
303: p_pei_attribute_category_o => pe_pei_shd.g_old_rec.pei_attribute_category ,
304: p_pei_attribute1_o => pe_pei_shd.g_old_rec.pei_attribute1 ,
305: p_pei_attribute2_o => pe_pei_shd.g_old_rec.pei_attribute2 ,
306: p_pei_attribute3_o => pe_pei_shd.g_old_rec.pei_attribute3 ,
307: p_pei_attribute4_o => pe_pei_shd.g_old_rec.pei_attribute4 ,
308: p_pei_attribute5_o => pe_pei_shd.g_old_rec.pei_attribute5 ,
309: p_pei_attribute6_o => pe_pei_shd.g_old_rec.pei_attribute6 ,
310: p_pei_attribute7_o => pe_pei_shd.g_old_rec.pei_attribute7 ,

Line 307: p_pei_attribute4_o => pe_pei_shd.g_old_rec.pei_attribute4 ,

303: p_pei_attribute_category_o => pe_pei_shd.g_old_rec.pei_attribute_category ,
304: p_pei_attribute1_o => pe_pei_shd.g_old_rec.pei_attribute1 ,
305: p_pei_attribute2_o => pe_pei_shd.g_old_rec.pei_attribute2 ,
306: p_pei_attribute3_o => pe_pei_shd.g_old_rec.pei_attribute3 ,
307: p_pei_attribute4_o => pe_pei_shd.g_old_rec.pei_attribute4 ,
308: p_pei_attribute5_o => pe_pei_shd.g_old_rec.pei_attribute5 ,
309: p_pei_attribute6_o => pe_pei_shd.g_old_rec.pei_attribute6 ,
310: p_pei_attribute7_o => pe_pei_shd.g_old_rec.pei_attribute7 ,
311: p_pei_attribute8_o => pe_pei_shd.g_old_rec.pei_attribute8 ,

Line 308: p_pei_attribute5_o => pe_pei_shd.g_old_rec.pei_attribute5 ,

304: p_pei_attribute1_o => pe_pei_shd.g_old_rec.pei_attribute1 ,
305: p_pei_attribute2_o => pe_pei_shd.g_old_rec.pei_attribute2 ,
306: p_pei_attribute3_o => pe_pei_shd.g_old_rec.pei_attribute3 ,
307: p_pei_attribute4_o => pe_pei_shd.g_old_rec.pei_attribute4 ,
308: p_pei_attribute5_o => pe_pei_shd.g_old_rec.pei_attribute5 ,
309: p_pei_attribute6_o => pe_pei_shd.g_old_rec.pei_attribute6 ,
310: p_pei_attribute7_o => pe_pei_shd.g_old_rec.pei_attribute7 ,
311: p_pei_attribute8_o => pe_pei_shd.g_old_rec.pei_attribute8 ,
312: p_pei_attribute9_o => pe_pei_shd.g_old_rec.pei_attribute9 ,

Line 309: p_pei_attribute6_o => pe_pei_shd.g_old_rec.pei_attribute6 ,

305: p_pei_attribute2_o => pe_pei_shd.g_old_rec.pei_attribute2 ,
306: p_pei_attribute3_o => pe_pei_shd.g_old_rec.pei_attribute3 ,
307: p_pei_attribute4_o => pe_pei_shd.g_old_rec.pei_attribute4 ,
308: p_pei_attribute5_o => pe_pei_shd.g_old_rec.pei_attribute5 ,
309: p_pei_attribute6_o => pe_pei_shd.g_old_rec.pei_attribute6 ,
310: p_pei_attribute7_o => pe_pei_shd.g_old_rec.pei_attribute7 ,
311: p_pei_attribute8_o => pe_pei_shd.g_old_rec.pei_attribute8 ,
312: p_pei_attribute9_o => pe_pei_shd.g_old_rec.pei_attribute9 ,
313: p_pei_attribute10_o => pe_pei_shd.g_old_rec.pei_attribute10 ,

Line 310: p_pei_attribute7_o => pe_pei_shd.g_old_rec.pei_attribute7 ,

306: p_pei_attribute3_o => pe_pei_shd.g_old_rec.pei_attribute3 ,
307: p_pei_attribute4_o => pe_pei_shd.g_old_rec.pei_attribute4 ,
308: p_pei_attribute5_o => pe_pei_shd.g_old_rec.pei_attribute5 ,
309: p_pei_attribute6_o => pe_pei_shd.g_old_rec.pei_attribute6 ,
310: p_pei_attribute7_o => pe_pei_shd.g_old_rec.pei_attribute7 ,
311: p_pei_attribute8_o => pe_pei_shd.g_old_rec.pei_attribute8 ,
312: p_pei_attribute9_o => pe_pei_shd.g_old_rec.pei_attribute9 ,
313: p_pei_attribute10_o => pe_pei_shd.g_old_rec.pei_attribute10 ,
314: p_pei_attribute11_o => pe_pei_shd.g_old_rec.pei_attribute11 ,

Line 311: p_pei_attribute8_o => pe_pei_shd.g_old_rec.pei_attribute8 ,

307: p_pei_attribute4_o => pe_pei_shd.g_old_rec.pei_attribute4 ,
308: p_pei_attribute5_o => pe_pei_shd.g_old_rec.pei_attribute5 ,
309: p_pei_attribute6_o => pe_pei_shd.g_old_rec.pei_attribute6 ,
310: p_pei_attribute7_o => pe_pei_shd.g_old_rec.pei_attribute7 ,
311: p_pei_attribute8_o => pe_pei_shd.g_old_rec.pei_attribute8 ,
312: p_pei_attribute9_o => pe_pei_shd.g_old_rec.pei_attribute9 ,
313: p_pei_attribute10_o => pe_pei_shd.g_old_rec.pei_attribute10 ,
314: p_pei_attribute11_o => pe_pei_shd.g_old_rec.pei_attribute11 ,
315: p_pei_attribute12_o => pe_pei_shd.g_old_rec.pei_attribute12 ,

Line 312: p_pei_attribute9_o => pe_pei_shd.g_old_rec.pei_attribute9 ,

308: p_pei_attribute5_o => pe_pei_shd.g_old_rec.pei_attribute5 ,
309: p_pei_attribute6_o => pe_pei_shd.g_old_rec.pei_attribute6 ,
310: p_pei_attribute7_o => pe_pei_shd.g_old_rec.pei_attribute7 ,
311: p_pei_attribute8_o => pe_pei_shd.g_old_rec.pei_attribute8 ,
312: p_pei_attribute9_o => pe_pei_shd.g_old_rec.pei_attribute9 ,
313: p_pei_attribute10_o => pe_pei_shd.g_old_rec.pei_attribute10 ,
314: p_pei_attribute11_o => pe_pei_shd.g_old_rec.pei_attribute11 ,
315: p_pei_attribute12_o => pe_pei_shd.g_old_rec.pei_attribute12 ,
316: p_pei_attribute13_o => pe_pei_shd.g_old_rec.pei_attribute13 ,

Line 313: p_pei_attribute10_o => pe_pei_shd.g_old_rec.pei_attribute10 ,

309: p_pei_attribute6_o => pe_pei_shd.g_old_rec.pei_attribute6 ,
310: p_pei_attribute7_o => pe_pei_shd.g_old_rec.pei_attribute7 ,
311: p_pei_attribute8_o => pe_pei_shd.g_old_rec.pei_attribute8 ,
312: p_pei_attribute9_o => pe_pei_shd.g_old_rec.pei_attribute9 ,
313: p_pei_attribute10_o => pe_pei_shd.g_old_rec.pei_attribute10 ,
314: p_pei_attribute11_o => pe_pei_shd.g_old_rec.pei_attribute11 ,
315: p_pei_attribute12_o => pe_pei_shd.g_old_rec.pei_attribute12 ,
316: p_pei_attribute13_o => pe_pei_shd.g_old_rec.pei_attribute13 ,
317: p_pei_attribute14_o => pe_pei_shd.g_old_rec.pei_attribute14 ,

Line 314: p_pei_attribute11_o => pe_pei_shd.g_old_rec.pei_attribute11 ,

310: p_pei_attribute7_o => pe_pei_shd.g_old_rec.pei_attribute7 ,
311: p_pei_attribute8_o => pe_pei_shd.g_old_rec.pei_attribute8 ,
312: p_pei_attribute9_o => pe_pei_shd.g_old_rec.pei_attribute9 ,
313: p_pei_attribute10_o => pe_pei_shd.g_old_rec.pei_attribute10 ,
314: p_pei_attribute11_o => pe_pei_shd.g_old_rec.pei_attribute11 ,
315: p_pei_attribute12_o => pe_pei_shd.g_old_rec.pei_attribute12 ,
316: p_pei_attribute13_o => pe_pei_shd.g_old_rec.pei_attribute13 ,
317: p_pei_attribute14_o => pe_pei_shd.g_old_rec.pei_attribute14 ,
318: p_pei_attribute15_o => pe_pei_shd.g_old_rec.pei_attribute15 ,

Line 315: p_pei_attribute12_o => pe_pei_shd.g_old_rec.pei_attribute12 ,

311: p_pei_attribute8_o => pe_pei_shd.g_old_rec.pei_attribute8 ,
312: p_pei_attribute9_o => pe_pei_shd.g_old_rec.pei_attribute9 ,
313: p_pei_attribute10_o => pe_pei_shd.g_old_rec.pei_attribute10 ,
314: p_pei_attribute11_o => pe_pei_shd.g_old_rec.pei_attribute11 ,
315: p_pei_attribute12_o => pe_pei_shd.g_old_rec.pei_attribute12 ,
316: p_pei_attribute13_o => pe_pei_shd.g_old_rec.pei_attribute13 ,
317: p_pei_attribute14_o => pe_pei_shd.g_old_rec.pei_attribute14 ,
318: p_pei_attribute15_o => pe_pei_shd.g_old_rec.pei_attribute15 ,
319: p_pei_attribute16_o => pe_pei_shd.g_old_rec.pei_attribute16 ,

Line 316: p_pei_attribute13_o => pe_pei_shd.g_old_rec.pei_attribute13 ,

312: p_pei_attribute9_o => pe_pei_shd.g_old_rec.pei_attribute9 ,
313: p_pei_attribute10_o => pe_pei_shd.g_old_rec.pei_attribute10 ,
314: p_pei_attribute11_o => pe_pei_shd.g_old_rec.pei_attribute11 ,
315: p_pei_attribute12_o => pe_pei_shd.g_old_rec.pei_attribute12 ,
316: p_pei_attribute13_o => pe_pei_shd.g_old_rec.pei_attribute13 ,
317: p_pei_attribute14_o => pe_pei_shd.g_old_rec.pei_attribute14 ,
318: p_pei_attribute15_o => pe_pei_shd.g_old_rec.pei_attribute15 ,
319: p_pei_attribute16_o => pe_pei_shd.g_old_rec.pei_attribute16 ,
320: p_pei_attribute17_o => pe_pei_shd.g_old_rec.pei_attribute17 ,

Line 317: p_pei_attribute14_o => pe_pei_shd.g_old_rec.pei_attribute14 ,

313: p_pei_attribute10_o => pe_pei_shd.g_old_rec.pei_attribute10 ,
314: p_pei_attribute11_o => pe_pei_shd.g_old_rec.pei_attribute11 ,
315: p_pei_attribute12_o => pe_pei_shd.g_old_rec.pei_attribute12 ,
316: p_pei_attribute13_o => pe_pei_shd.g_old_rec.pei_attribute13 ,
317: p_pei_attribute14_o => pe_pei_shd.g_old_rec.pei_attribute14 ,
318: p_pei_attribute15_o => pe_pei_shd.g_old_rec.pei_attribute15 ,
319: p_pei_attribute16_o => pe_pei_shd.g_old_rec.pei_attribute16 ,
320: p_pei_attribute17_o => pe_pei_shd.g_old_rec.pei_attribute17 ,
321: p_pei_attribute18_o => pe_pei_shd.g_old_rec.pei_attribute18 ,

Line 318: p_pei_attribute15_o => pe_pei_shd.g_old_rec.pei_attribute15 ,

314: p_pei_attribute11_o => pe_pei_shd.g_old_rec.pei_attribute11 ,
315: p_pei_attribute12_o => pe_pei_shd.g_old_rec.pei_attribute12 ,
316: p_pei_attribute13_o => pe_pei_shd.g_old_rec.pei_attribute13 ,
317: p_pei_attribute14_o => pe_pei_shd.g_old_rec.pei_attribute14 ,
318: p_pei_attribute15_o => pe_pei_shd.g_old_rec.pei_attribute15 ,
319: p_pei_attribute16_o => pe_pei_shd.g_old_rec.pei_attribute16 ,
320: p_pei_attribute17_o => pe_pei_shd.g_old_rec.pei_attribute17 ,
321: p_pei_attribute18_o => pe_pei_shd.g_old_rec.pei_attribute18 ,
322: p_pei_attribute19_o => pe_pei_shd.g_old_rec.pei_attribute19 ,

Line 319: p_pei_attribute16_o => pe_pei_shd.g_old_rec.pei_attribute16 ,

315: p_pei_attribute12_o => pe_pei_shd.g_old_rec.pei_attribute12 ,
316: p_pei_attribute13_o => pe_pei_shd.g_old_rec.pei_attribute13 ,
317: p_pei_attribute14_o => pe_pei_shd.g_old_rec.pei_attribute14 ,
318: p_pei_attribute15_o => pe_pei_shd.g_old_rec.pei_attribute15 ,
319: p_pei_attribute16_o => pe_pei_shd.g_old_rec.pei_attribute16 ,
320: p_pei_attribute17_o => pe_pei_shd.g_old_rec.pei_attribute17 ,
321: p_pei_attribute18_o => pe_pei_shd.g_old_rec.pei_attribute18 ,
322: p_pei_attribute19_o => pe_pei_shd.g_old_rec.pei_attribute19 ,
323: p_pei_attribute20_o => pe_pei_shd.g_old_rec.pei_attribute20 ,

Line 320: p_pei_attribute17_o => pe_pei_shd.g_old_rec.pei_attribute17 ,

316: p_pei_attribute13_o => pe_pei_shd.g_old_rec.pei_attribute13 ,
317: p_pei_attribute14_o => pe_pei_shd.g_old_rec.pei_attribute14 ,
318: p_pei_attribute15_o => pe_pei_shd.g_old_rec.pei_attribute15 ,
319: p_pei_attribute16_o => pe_pei_shd.g_old_rec.pei_attribute16 ,
320: p_pei_attribute17_o => pe_pei_shd.g_old_rec.pei_attribute17 ,
321: p_pei_attribute18_o => pe_pei_shd.g_old_rec.pei_attribute18 ,
322: p_pei_attribute19_o => pe_pei_shd.g_old_rec.pei_attribute19 ,
323: p_pei_attribute20_o => pe_pei_shd.g_old_rec.pei_attribute20 ,
324: p_pei_information_category_o => pe_pei_shd.g_old_rec.pei_information_category ,

Line 321: p_pei_attribute18_o => pe_pei_shd.g_old_rec.pei_attribute18 ,

317: p_pei_attribute14_o => pe_pei_shd.g_old_rec.pei_attribute14 ,
318: p_pei_attribute15_o => pe_pei_shd.g_old_rec.pei_attribute15 ,
319: p_pei_attribute16_o => pe_pei_shd.g_old_rec.pei_attribute16 ,
320: p_pei_attribute17_o => pe_pei_shd.g_old_rec.pei_attribute17 ,
321: p_pei_attribute18_o => pe_pei_shd.g_old_rec.pei_attribute18 ,
322: p_pei_attribute19_o => pe_pei_shd.g_old_rec.pei_attribute19 ,
323: p_pei_attribute20_o => pe_pei_shd.g_old_rec.pei_attribute20 ,
324: p_pei_information_category_o => pe_pei_shd.g_old_rec.pei_information_category ,
325: p_pei_information1_o => pe_pei_shd.g_old_rec.pei_information1 ,

Line 322: p_pei_attribute19_o => pe_pei_shd.g_old_rec.pei_attribute19 ,

318: p_pei_attribute15_o => pe_pei_shd.g_old_rec.pei_attribute15 ,
319: p_pei_attribute16_o => pe_pei_shd.g_old_rec.pei_attribute16 ,
320: p_pei_attribute17_o => pe_pei_shd.g_old_rec.pei_attribute17 ,
321: p_pei_attribute18_o => pe_pei_shd.g_old_rec.pei_attribute18 ,
322: p_pei_attribute19_o => pe_pei_shd.g_old_rec.pei_attribute19 ,
323: p_pei_attribute20_o => pe_pei_shd.g_old_rec.pei_attribute20 ,
324: p_pei_information_category_o => pe_pei_shd.g_old_rec.pei_information_category ,
325: p_pei_information1_o => pe_pei_shd.g_old_rec.pei_information1 ,
326: p_pei_information2_o => pe_pei_shd.g_old_rec.pei_information2 ,

Line 323: p_pei_attribute20_o => pe_pei_shd.g_old_rec.pei_attribute20 ,

319: p_pei_attribute16_o => pe_pei_shd.g_old_rec.pei_attribute16 ,
320: p_pei_attribute17_o => pe_pei_shd.g_old_rec.pei_attribute17 ,
321: p_pei_attribute18_o => pe_pei_shd.g_old_rec.pei_attribute18 ,
322: p_pei_attribute19_o => pe_pei_shd.g_old_rec.pei_attribute19 ,
323: p_pei_attribute20_o => pe_pei_shd.g_old_rec.pei_attribute20 ,
324: p_pei_information_category_o => pe_pei_shd.g_old_rec.pei_information_category ,
325: p_pei_information1_o => pe_pei_shd.g_old_rec.pei_information1 ,
326: p_pei_information2_o => pe_pei_shd.g_old_rec.pei_information2 ,
327: p_pei_information3_o => pe_pei_shd.g_old_rec.pei_information3 ,

Line 324: p_pei_information_category_o => pe_pei_shd.g_old_rec.pei_information_category ,

320: p_pei_attribute17_o => pe_pei_shd.g_old_rec.pei_attribute17 ,
321: p_pei_attribute18_o => pe_pei_shd.g_old_rec.pei_attribute18 ,
322: p_pei_attribute19_o => pe_pei_shd.g_old_rec.pei_attribute19 ,
323: p_pei_attribute20_o => pe_pei_shd.g_old_rec.pei_attribute20 ,
324: p_pei_information_category_o => pe_pei_shd.g_old_rec.pei_information_category ,
325: p_pei_information1_o => pe_pei_shd.g_old_rec.pei_information1 ,
326: p_pei_information2_o => pe_pei_shd.g_old_rec.pei_information2 ,
327: p_pei_information3_o => pe_pei_shd.g_old_rec.pei_information3 ,
328: p_pei_information4_o => pe_pei_shd.g_old_rec.pei_information4 ,

Line 325: p_pei_information1_o => pe_pei_shd.g_old_rec.pei_information1 ,

321: p_pei_attribute18_o => pe_pei_shd.g_old_rec.pei_attribute18 ,
322: p_pei_attribute19_o => pe_pei_shd.g_old_rec.pei_attribute19 ,
323: p_pei_attribute20_o => pe_pei_shd.g_old_rec.pei_attribute20 ,
324: p_pei_information_category_o => pe_pei_shd.g_old_rec.pei_information_category ,
325: p_pei_information1_o => pe_pei_shd.g_old_rec.pei_information1 ,
326: p_pei_information2_o => pe_pei_shd.g_old_rec.pei_information2 ,
327: p_pei_information3_o => pe_pei_shd.g_old_rec.pei_information3 ,
328: p_pei_information4_o => pe_pei_shd.g_old_rec.pei_information4 ,
329: p_pei_information5_o => pe_pei_shd.g_old_rec.pei_information5 ,

Line 326: p_pei_information2_o => pe_pei_shd.g_old_rec.pei_information2 ,

322: p_pei_attribute19_o => pe_pei_shd.g_old_rec.pei_attribute19 ,
323: p_pei_attribute20_o => pe_pei_shd.g_old_rec.pei_attribute20 ,
324: p_pei_information_category_o => pe_pei_shd.g_old_rec.pei_information_category ,
325: p_pei_information1_o => pe_pei_shd.g_old_rec.pei_information1 ,
326: p_pei_information2_o => pe_pei_shd.g_old_rec.pei_information2 ,
327: p_pei_information3_o => pe_pei_shd.g_old_rec.pei_information3 ,
328: p_pei_information4_o => pe_pei_shd.g_old_rec.pei_information4 ,
329: p_pei_information5_o => pe_pei_shd.g_old_rec.pei_information5 ,
330: p_pei_information6_o => pe_pei_shd.g_old_rec.pei_information6 ,

Line 327: p_pei_information3_o => pe_pei_shd.g_old_rec.pei_information3 ,

323: p_pei_attribute20_o => pe_pei_shd.g_old_rec.pei_attribute20 ,
324: p_pei_information_category_o => pe_pei_shd.g_old_rec.pei_information_category ,
325: p_pei_information1_o => pe_pei_shd.g_old_rec.pei_information1 ,
326: p_pei_information2_o => pe_pei_shd.g_old_rec.pei_information2 ,
327: p_pei_information3_o => pe_pei_shd.g_old_rec.pei_information3 ,
328: p_pei_information4_o => pe_pei_shd.g_old_rec.pei_information4 ,
329: p_pei_information5_o => pe_pei_shd.g_old_rec.pei_information5 ,
330: p_pei_information6_o => pe_pei_shd.g_old_rec.pei_information6 ,
331: p_pei_information7_o => pe_pei_shd.g_old_rec.pei_information7 ,

Line 328: p_pei_information4_o => pe_pei_shd.g_old_rec.pei_information4 ,

324: p_pei_information_category_o => pe_pei_shd.g_old_rec.pei_information_category ,
325: p_pei_information1_o => pe_pei_shd.g_old_rec.pei_information1 ,
326: p_pei_information2_o => pe_pei_shd.g_old_rec.pei_information2 ,
327: p_pei_information3_o => pe_pei_shd.g_old_rec.pei_information3 ,
328: p_pei_information4_o => pe_pei_shd.g_old_rec.pei_information4 ,
329: p_pei_information5_o => pe_pei_shd.g_old_rec.pei_information5 ,
330: p_pei_information6_o => pe_pei_shd.g_old_rec.pei_information6 ,
331: p_pei_information7_o => pe_pei_shd.g_old_rec.pei_information7 ,
332: p_pei_information8_o => pe_pei_shd.g_old_rec.pei_information8 ,

Line 329: p_pei_information5_o => pe_pei_shd.g_old_rec.pei_information5 ,

325: p_pei_information1_o => pe_pei_shd.g_old_rec.pei_information1 ,
326: p_pei_information2_o => pe_pei_shd.g_old_rec.pei_information2 ,
327: p_pei_information3_o => pe_pei_shd.g_old_rec.pei_information3 ,
328: p_pei_information4_o => pe_pei_shd.g_old_rec.pei_information4 ,
329: p_pei_information5_o => pe_pei_shd.g_old_rec.pei_information5 ,
330: p_pei_information6_o => pe_pei_shd.g_old_rec.pei_information6 ,
331: p_pei_information7_o => pe_pei_shd.g_old_rec.pei_information7 ,
332: p_pei_information8_o => pe_pei_shd.g_old_rec.pei_information8 ,
333: p_pei_information9_o => pe_pei_shd.g_old_rec.pei_information9 ,

Line 330: p_pei_information6_o => pe_pei_shd.g_old_rec.pei_information6 ,

326: p_pei_information2_o => pe_pei_shd.g_old_rec.pei_information2 ,
327: p_pei_information3_o => pe_pei_shd.g_old_rec.pei_information3 ,
328: p_pei_information4_o => pe_pei_shd.g_old_rec.pei_information4 ,
329: p_pei_information5_o => pe_pei_shd.g_old_rec.pei_information5 ,
330: p_pei_information6_o => pe_pei_shd.g_old_rec.pei_information6 ,
331: p_pei_information7_o => pe_pei_shd.g_old_rec.pei_information7 ,
332: p_pei_information8_o => pe_pei_shd.g_old_rec.pei_information8 ,
333: p_pei_information9_o => pe_pei_shd.g_old_rec.pei_information9 ,
334: p_pei_information10_o => pe_pei_shd.g_old_rec.pei_information10 ,

Line 331: p_pei_information7_o => pe_pei_shd.g_old_rec.pei_information7 ,

327: p_pei_information3_o => pe_pei_shd.g_old_rec.pei_information3 ,
328: p_pei_information4_o => pe_pei_shd.g_old_rec.pei_information4 ,
329: p_pei_information5_o => pe_pei_shd.g_old_rec.pei_information5 ,
330: p_pei_information6_o => pe_pei_shd.g_old_rec.pei_information6 ,
331: p_pei_information7_o => pe_pei_shd.g_old_rec.pei_information7 ,
332: p_pei_information8_o => pe_pei_shd.g_old_rec.pei_information8 ,
333: p_pei_information9_o => pe_pei_shd.g_old_rec.pei_information9 ,
334: p_pei_information10_o => pe_pei_shd.g_old_rec.pei_information10 ,
335: p_pei_information11_o => pe_pei_shd.g_old_rec.pei_information11 ,

Line 332: p_pei_information8_o => pe_pei_shd.g_old_rec.pei_information8 ,

328: p_pei_information4_o => pe_pei_shd.g_old_rec.pei_information4 ,
329: p_pei_information5_o => pe_pei_shd.g_old_rec.pei_information5 ,
330: p_pei_information6_o => pe_pei_shd.g_old_rec.pei_information6 ,
331: p_pei_information7_o => pe_pei_shd.g_old_rec.pei_information7 ,
332: p_pei_information8_o => pe_pei_shd.g_old_rec.pei_information8 ,
333: p_pei_information9_o => pe_pei_shd.g_old_rec.pei_information9 ,
334: p_pei_information10_o => pe_pei_shd.g_old_rec.pei_information10 ,
335: p_pei_information11_o => pe_pei_shd.g_old_rec.pei_information11 ,
336: p_pei_information12_o => pe_pei_shd.g_old_rec.pei_information12 ,

Line 333: p_pei_information9_o => pe_pei_shd.g_old_rec.pei_information9 ,

329: p_pei_information5_o => pe_pei_shd.g_old_rec.pei_information5 ,
330: p_pei_information6_o => pe_pei_shd.g_old_rec.pei_information6 ,
331: p_pei_information7_o => pe_pei_shd.g_old_rec.pei_information7 ,
332: p_pei_information8_o => pe_pei_shd.g_old_rec.pei_information8 ,
333: p_pei_information9_o => pe_pei_shd.g_old_rec.pei_information9 ,
334: p_pei_information10_o => pe_pei_shd.g_old_rec.pei_information10 ,
335: p_pei_information11_o => pe_pei_shd.g_old_rec.pei_information11 ,
336: p_pei_information12_o => pe_pei_shd.g_old_rec.pei_information12 ,
337: p_pei_information13_o => pe_pei_shd.g_old_rec.pei_information13 ,

Line 334: p_pei_information10_o => pe_pei_shd.g_old_rec.pei_information10 ,

330: p_pei_information6_o => pe_pei_shd.g_old_rec.pei_information6 ,
331: p_pei_information7_o => pe_pei_shd.g_old_rec.pei_information7 ,
332: p_pei_information8_o => pe_pei_shd.g_old_rec.pei_information8 ,
333: p_pei_information9_o => pe_pei_shd.g_old_rec.pei_information9 ,
334: p_pei_information10_o => pe_pei_shd.g_old_rec.pei_information10 ,
335: p_pei_information11_o => pe_pei_shd.g_old_rec.pei_information11 ,
336: p_pei_information12_o => pe_pei_shd.g_old_rec.pei_information12 ,
337: p_pei_information13_o => pe_pei_shd.g_old_rec.pei_information13 ,
338: p_pei_information14_o => pe_pei_shd.g_old_rec.pei_information14 ,

Line 335: p_pei_information11_o => pe_pei_shd.g_old_rec.pei_information11 ,

331: p_pei_information7_o => pe_pei_shd.g_old_rec.pei_information7 ,
332: p_pei_information8_o => pe_pei_shd.g_old_rec.pei_information8 ,
333: p_pei_information9_o => pe_pei_shd.g_old_rec.pei_information9 ,
334: p_pei_information10_o => pe_pei_shd.g_old_rec.pei_information10 ,
335: p_pei_information11_o => pe_pei_shd.g_old_rec.pei_information11 ,
336: p_pei_information12_o => pe_pei_shd.g_old_rec.pei_information12 ,
337: p_pei_information13_o => pe_pei_shd.g_old_rec.pei_information13 ,
338: p_pei_information14_o => pe_pei_shd.g_old_rec.pei_information14 ,
339: p_pei_information15_o => pe_pei_shd.g_old_rec.pei_information15 ,

Line 336: p_pei_information12_o => pe_pei_shd.g_old_rec.pei_information12 ,

332: p_pei_information8_o => pe_pei_shd.g_old_rec.pei_information8 ,
333: p_pei_information9_o => pe_pei_shd.g_old_rec.pei_information9 ,
334: p_pei_information10_o => pe_pei_shd.g_old_rec.pei_information10 ,
335: p_pei_information11_o => pe_pei_shd.g_old_rec.pei_information11 ,
336: p_pei_information12_o => pe_pei_shd.g_old_rec.pei_information12 ,
337: p_pei_information13_o => pe_pei_shd.g_old_rec.pei_information13 ,
338: p_pei_information14_o => pe_pei_shd.g_old_rec.pei_information14 ,
339: p_pei_information15_o => pe_pei_shd.g_old_rec.pei_information15 ,
340: p_pei_information16_o => pe_pei_shd.g_old_rec.pei_information16 ,

Line 337: p_pei_information13_o => pe_pei_shd.g_old_rec.pei_information13 ,

333: p_pei_information9_o => pe_pei_shd.g_old_rec.pei_information9 ,
334: p_pei_information10_o => pe_pei_shd.g_old_rec.pei_information10 ,
335: p_pei_information11_o => pe_pei_shd.g_old_rec.pei_information11 ,
336: p_pei_information12_o => pe_pei_shd.g_old_rec.pei_information12 ,
337: p_pei_information13_o => pe_pei_shd.g_old_rec.pei_information13 ,
338: p_pei_information14_o => pe_pei_shd.g_old_rec.pei_information14 ,
339: p_pei_information15_o => pe_pei_shd.g_old_rec.pei_information15 ,
340: p_pei_information16_o => pe_pei_shd.g_old_rec.pei_information16 ,
341: p_pei_information17_o => pe_pei_shd.g_old_rec.pei_information17 ,

Line 338: p_pei_information14_o => pe_pei_shd.g_old_rec.pei_information14 ,

334: p_pei_information10_o => pe_pei_shd.g_old_rec.pei_information10 ,
335: p_pei_information11_o => pe_pei_shd.g_old_rec.pei_information11 ,
336: p_pei_information12_o => pe_pei_shd.g_old_rec.pei_information12 ,
337: p_pei_information13_o => pe_pei_shd.g_old_rec.pei_information13 ,
338: p_pei_information14_o => pe_pei_shd.g_old_rec.pei_information14 ,
339: p_pei_information15_o => pe_pei_shd.g_old_rec.pei_information15 ,
340: p_pei_information16_o => pe_pei_shd.g_old_rec.pei_information16 ,
341: p_pei_information17_o => pe_pei_shd.g_old_rec.pei_information17 ,
342: p_pei_information18_o => pe_pei_shd.g_old_rec.pei_information18 ,

Line 339: p_pei_information15_o => pe_pei_shd.g_old_rec.pei_information15 ,

335: p_pei_information11_o => pe_pei_shd.g_old_rec.pei_information11 ,
336: p_pei_information12_o => pe_pei_shd.g_old_rec.pei_information12 ,
337: p_pei_information13_o => pe_pei_shd.g_old_rec.pei_information13 ,
338: p_pei_information14_o => pe_pei_shd.g_old_rec.pei_information14 ,
339: p_pei_information15_o => pe_pei_shd.g_old_rec.pei_information15 ,
340: p_pei_information16_o => pe_pei_shd.g_old_rec.pei_information16 ,
341: p_pei_information17_o => pe_pei_shd.g_old_rec.pei_information17 ,
342: p_pei_information18_o => pe_pei_shd.g_old_rec.pei_information18 ,
343: p_pei_information19_o => pe_pei_shd.g_old_rec.pei_information19 ,

Line 340: p_pei_information16_o => pe_pei_shd.g_old_rec.pei_information16 ,

336: p_pei_information12_o => pe_pei_shd.g_old_rec.pei_information12 ,
337: p_pei_information13_o => pe_pei_shd.g_old_rec.pei_information13 ,
338: p_pei_information14_o => pe_pei_shd.g_old_rec.pei_information14 ,
339: p_pei_information15_o => pe_pei_shd.g_old_rec.pei_information15 ,
340: p_pei_information16_o => pe_pei_shd.g_old_rec.pei_information16 ,
341: p_pei_information17_o => pe_pei_shd.g_old_rec.pei_information17 ,
342: p_pei_information18_o => pe_pei_shd.g_old_rec.pei_information18 ,
343: p_pei_information19_o => pe_pei_shd.g_old_rec.pei_information19 ,
344: p_pei_information20_o => pe_pei_shd.g_old_rec.pei_information20 ,

Line 341: p_pei_information17_o => pe_pei_shd.g_old_rec.pei_information17 ,

337: p_pei_information13_o => pe_pei_shd.g_old_rec.pei_information13 ,
338: p_pei_information14_o => pe_pei_shd.g_old_rec.pei_information14 ,
339: p_pei_information15_o => pe_pei_shd.g_old_rec.pei_information15 ,
340: p_pei_information16_o => pe_pei_shd.g_old_rec.pei_information16 ,
341: p_pei_information17_o => pe_pei_shd.g_old_rec.pei_information17 ,
342: p_pei_information18_o => pe_pei_shd.g_old_rec.pei_information18 ,
343: p_pei_information19_o => pe_pei_shd.g_old_rec.pei_information19 ,
344: p_pei_information20_o => pe_pei_shd.g_old_rec.pei_information20 ,
345: p_pei_information21_o => pe_pei_shd.g_old_rec.pei_information21 ,

Line 342: p_pei_information18_o => pe_pei_shd.g_old_rec.pei_information18 ,

338: p_pei_information14_o => pe_pei_shd.g_old_rec.pei_information14 ,
339: p_pei_information15_o => pe_pei_shd.g_old_rec.pei_information15 ,
340: p_pei_information16_o => pe_pei_shd.g_old_rec.pei_information16 ,
341: p_pei_information17_o => pe_pei_shd.g_old_rec.pei_information17 ,
342: p_pei_information18_o => pe_pei_shd.g_old_rec.pei_information18 ,
343: p_pei_information19_o => pe_pei_shd.g_old_rec.pei_information19 ,
344: p_pei_information20_o => pe_pei_shd.g_old_rec.pei_information20 ,
345: p_pei_information21_o => pe_pei_shd.g_old_rec.pei_information21 ,
346: p_pei_information22_o => pe_pei_shd.g_old_rec.pei_information22 ,

Line 343: p_pei_information19_o => pe_pei_shd.g_old_rec.pei_information19 ,

339: p_pei_information15_o => pe_pei_shd.g_old_rec.pei_information15 ,
340: p_pei_information16_o => pe_pei_shd.g_old_rec.pei_information16 ,
341: p_pei_information17_o => pe_pei_shd.g_old_rec.pei_information17 ,
342: p_pei_information18_o => pe_pei_shd.g_old_rec.pei_information18 ,
343: p_pei_information19_o => pe_pei_shd.g_old_rec.pei_information19 ,
344: p_pei_information20_o => pe_pei_shd.g_old_rec.pei_information20 ,
345: p_pei_information21_o => pe_pei_shd.g_old_rec.pei_information21 ,
346: p_pei_information22_o => pe_pei_shd.g_old_rec.pei_information22 ,
347: p_pei_information23_o => pe_pei_shd.g_old_rec.pei_information23 ,

Line 344: p_pei_information20_o => pe_pei_shd.g_old_rec.pei_information20 ,

340: p_pei_information16_o => pe_pei_shd.g_old_rec.pei_information16 ,
341: p_pei_information17_o => pe_pei_shd.g_old_rec.pei_information17 ,
342: p_pei_information18_o => pe_pei_shd.g_old_rec.pei_information18 ,
343: p_pei_information19_o => pe_pei_shd.g_old_rec.pei_information19 ,
344: p_pei_information20_o => pe_pei_shd.g_old_rec.pei_information20 ,
345: p_pei_information21_o => pe_pei_shd.g_old_rec.pei_information21 ,
346: p_pei_information22_o => pe_pei_shd.g_old_rec.pei_information22 ,
347: p_pei_information23_o => pe_pei_shd.g_old_rec.pei_information23 ,
348: p_pei_information24_o => pe_pei_shd.g_old_rec.pei_information24 ,

Line 345: p_pei_information21_o => pe_pei_shd.g_old_rec.pei_information21 ,

341: p_pei_information17_o => pe_pei_shd.g_old_rec.pei_information17 ,
342: p_pei_information18_o => pe_pei_shd.g_old_rec.pei_information18 ,
343: p_pei_information19_o => pe_pei_shd.g_old_rec.pei_information19 ,
344: p_pei_information20_o => pe_pei_shd.g_old_rec.pei_information20 ,
345: p_pei_information21_o => pe_pei_shd.g_old_rec.pei_information21 ,
346: p_pei_information22_o => pe_pei_shd.g_old_rec.pei_information22 ,
347: p_pei_information23_o => pe_pei_shd.g_old_rec.pei_information23 ,
348: p_pei_information24_o => pe_pei_shd.g_old_rec.pei_information24 ,
349: p_pei_information25_o => pe_pei_shd.g_old_rec.pei_information25 ,

Line 346: p_pei_information22_o => pe_pei_shd.g_old_rec.pei_information22 ,

342: p_pei_information18_o => pe_pei_shd.g_old_rec.pei_information18 ,
343: p_pei_information19_o => pe_pei_shd.g_old_rec.pei_information19 ,
344: p_pei_information20_o => pe_pei_shd.g_old_rec.pei_information20 ,
345: p_pei_information21_o => pe_pei_shd.g_old_rec.pei_information21 ,
346: p_pei_information22_o => pe_pei_shd.g_old_rec.pei_information22 ,
347: p_pei_information23_o => pe_pei_shd.g_old_rec.pei_information23 ,
348: p_pei_information24_o => pe_pei_shd.g_old_rec.pei_information24 ,
349: p_pei_information25_o => pe_pei_shd.g_old_rec.pei_information25 ,
350: p_pei_information26_o => pe_pei_shd.g_old_rec.pei_information26 ,

Line 347: p_pei_information23_o => pe_pei_shd.g_old_rec.pei_information23 ,

343: p_pei_information19_o => pe_pei_shd.g_old_rec.pei_information19 ,
344: p_pei_information20_o => pe_pei_shd.g_old_rec.pei_information20 ,
345: p_pei_information21_o => pe_pei_shd.g_old_rec.pei_information21 ,
346: p_pei_information22_o => pe_pei_shd.g_old_rec.pei_information22 ,
347: p_pei_information23_o => pe_pei_shd.g_old_rec.pei_information23 ,
348: p_pei_information24_o => pe_pei_shd.g_old_rec.pei_information24 ,
349: p_pei_information25_o => pe_pei_shd.g_old_rec.pei_information25 ,
350: p_pei_information26_o => pe_pei_shd.g_old_rec.pei_information26 ,
351: p_pei_information27_o => pe_pei_shd.g_old_rec.pei_information27 ,

Line 348: p_pei_information24_o => pe_pei_shd.g_old_rec.pei_information24 ,

344: p_pei_information20_o => pe_pei_shd.g_old_rec.pei_information20 ,
345: p_pei_information21_o => pe_pei_shd.g_old_rec.pei_information21 ,
346: p_pei_information22_o => pe_pei_shd.g_old_rec.pei_information22 ,
347: p_pei_information23_o => pe_pei_shd.g_old_rec.pei_information23 ,
348: p_pei_information24_o => pe_pei_shd.g_old_rec.pei_information24 ,
349: p_pei_information25_o => pe_pei_shd.g_old_rec.pei_information25 ,
350: p_pei_information26_o => pe_pei_shd.g_old_rec.pei_information26 ,
351: p_pei_information27_o => pe_pei_shd.g_old_rec.pei_information27 ,
352: p_pei_information28_o => pe_pei_shd.g_old_rec.pei_information28 ,

Line 349: p_pei_information25_o => pe_pei_shd.g_old_rec.pei_information25 ,

345: p_pei_information21_o => pe_pei_shd.g_old_rec.pei_information21 ,
346: p_pei_information22_o => pe_pei_shd.g_old_rec.pei_information22 ,
347: p_pei_information23_o => pe_pei_shd.g_old_rec.pei_information23 ,
348: p_pei_information24_o => pe_pei_shd.g_old_rec.pei_information24 ,
349: p_pei_information25_o => pe_pei_shd.g_old_rec.pei_information25 ,
350: p_pei_information26_o => pe_pei_shd.g_old_rec.pei_information26 ,
351: p_pei_information27_o => pe_pei_shd.g_old_rec.pei_information27 ,
352: p_pei_information28_o => pe_pei_shd.g_old_rec.pei_information28 ,
353: p_pei_information29_o => pe_pei_shd.g_old_rec.pei_information29 ,

Line 350: p_pei_information26_o => pe_pei_shd.g_old_rec.pei_information26 ,

346: p_pei_information22_o => pe_pei_shd.g_old_rec.pei_information22 ,
347: p_pei_information23_o => pe_pei_shd.g_old_rec.pei_information23 ,
348: p_pei_information24_o => pe_pei_shd.g_old_rec.pei_information24 ,
349: p_pei_information25_o => pe_pei_shd.g_old_rec.pei_information25 ,
350: p_pei_information26_o => pe_pei_shd.g_old_rec.pei_information26 ,
351: p_pei_information27_o => pe_pei_shd.g_old_rec.pei_information27 ,
352: p_pei_information28_o => pe_pei_shd.g_old_rec.pei_information28 ,
353: p_pei_information29_o => pe_pei_shd.g_old_rec.pei_information29 ,
354: p_pei_information30_o => pe_pei_shd.g_old_rec.pei_information30

Line 351: p_pei_information27_o => pe_pei_shd.g_old_rec.pei_information27 ,

347: p_pei_information23_o => pe_pei_shd.g_old_rec.pei_information23 ,
348: p_pei_information24_o => pe_pei_shd.g_old_rec.pei_information24 ,
349: p_pei_information25_o => pe_pei_shd.g_old_rec.pei_information25 ,
350: p_pei_information26_o => pe_pei_shd.g_old_rec.pei_information26 ,
351: p_pei_information27_o => pe_pei_shd.g_old_rec.pei_information27 ,
352: p_pei_information28_o => pe_pei_shd.g_old_rec.pei_information28 ,
353: p_pei_information29_o => pe_pei_shd.g_old_rec.pei_information29 ,
354: p_pei_information30_o => pe_pei_shd.g_old_rec.pei_information30
355: );

Line 352: p_pei_information28_o => pe_pei_shd.g_old_rec.pei_information28 ,

348: p_pei_information24_o => pe_pei_shd.g_old_rec.pei_information24 ,
349: p_pei_information25_o => pe_pei_shd.g_old_rec.pei_information25 ,
350: p_pei_information26_o => pe_pei_shd.g_old_rec.pei_information26 ,
351: p_pei_information27_o => pe_pei_shd.g_old_rec.pei_information27 ,
352: p_pei_information28_o => pe_pei_shd.g_old_rec.pei_information28 ,
353: p_pei_information29_o => pe_pei_shd.g_old_rec.pei_information29 ,
354: p_pei_information30_o => pe_pei_shd.g_old_rec.pei_information30
355: );
356: exception

Line 353: p_pei_information29_o => pe_pei_shd.g_old_rec.pei_information29 ,

349: p_pei_information25_o => pe_pei_shd.g_old_rec.pei_information25 ,
350: p_pei_information26_o => pe_pei_shd.g_old_rec.pei_information26 ,
351: p_pei_information27_o => pe_pei_shd.g_old_rec.pei_information27 ,
352: p_pei_information28_o => pe_pei_shd.g_old_rec.pei_information28 ,
353: p_pei_information29_o => pe_pei_shd.g_old_rec.pei_information29 ,
354: p_pei_information30_o => pe_pei_shd.g_old_rec.pei_information30
355: );
356: exception
357: when hr_api.cannot_find_prog_unit then

Line 354: p_pei_information30_o => pe_pei_shd.g_old_rec.pei_information30

350: p_pei_information26_o => pe_pei_shd.g_old_rec.pei_information26 ,
351: p_pei_information27_o => pe_pei_shd.g_old_rec.pei_information27 ,
352: p_pei_information28_o => pe_pei_shd.g_old_rec.pei_information28 ,
353: p_pei_information29_o => pe_pei_shd.g_old_rec.pei_information29 ,
354: p_pei_information30_o => pe_pei_shd.g_old_rec.pei_information30
355: );
356: exception
357: when hr_api.cannot_find_prog_unit then
358: hr_api.cannot_find_prog_unit_error

Line 367: if nvl(pe_pei_shd.g_old_rec.pei_information5,'N') = 'N'

363: -- End of API User Hook for post_update.
364: --
365: --
366: if p_rec.INFORMATION_TYPE = 'PQH_ROLE_USERS' then
367: if nvl(pe_pei_shd.g_old_rec.pei_information5,'N') = 'N'
368: and nvl(p_rec.PEI_INFORMATION5,'N') = 'Y' then
369: declare
370: l_user_name varchar2(50);
371: l_start_date date;

Line 393: elsif nvl(pe_pei_shd.g_old_rec.pei_information5,'N') = 'Y'

389: else
390: close c1;
391: end if;
392: end;
393: elsif nvl(pe_pei_shd.g_old_rec.pei_information5,'N') = 'Y'
394: and nvl(p_rec.PEI_INFORMATION5,'N') = 'Y'
395: and (pe_pei_shd.g_old_rec.pei_information3 <> p_rec.PEI_INFORMATION3) then
396: declare
397: l_user_name varchar2(50);

Line 395: and (pe_pei_shd.g_old_rec.pei_information3 <> p_rec.PEI_INFORMATION3) then

391: end if;
392: end;
393: elsif nvl(pe_pei_shd.g_old_rec.pei_information5,'N') = 'Y'
394: and nvl(p_rec.PEI_INFORMATION5,'N') = 'Y'
395: and (pe_pei_shd.g_old_rec.pei_information3 <> p_rec.PEI_INFORMATION3) then
396: declare
397: l_user_name varchar2(50);
398: l_start_date date;
399: l_expiration_date date;

Line 412: p_user_orig_system_id => pe_pei_shd.g_old_rec.person_id,

408: if c1%found then
409: close c1;
410:
411: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => 'PER',
412: p_user_orig_system_id => pe_pei_shd.g_old_rec.person_id,
413: p_role_orig_system => 'PQH_ROLE',
414: p_role_orig_system_id => pe_pei_shd.g_old_rec.pei_information3,
415: p_start_date => l_start_date,
416: p_expiration_date => l_expiration_date

Line 414: p_role_orig_system_id => pe_pei_shd.g_old_rec.pei_information3,

410:
411: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => 'PER',
412: p_user_orig_system_id => pe_pei_shd.g_old_rec.person_id,
413: p_role_orig_system => 'PQH_ROLE',
414: p_role_orig_system_id => pe_pei_shd.g_old_rec.pei_information3,
415: p_start_date => l_start_date,
416: p_expiration_date => l_expiration_date
417: );
418: else

Line 446: elsif nvl(pe_pei_shd.g_old_rec.pei_information5,'N') = 'Y'

442: else
443: close c1;
444: end if;
445: end;
446: elsif nvl(pe_pei_shd.g_old_rec.pei_information5,'N') = 'Y'
447: and nvl(p_rec.PEI_INFORMATION5,'N') = 'N' then
448: declare
449: l_user_name varchar2(50);
450: l_start_date date;

Line 463: p_user_orig_system_id => pe_pei_shd.g_old_rec.person_id,

459: fetch c1 into l_user_name, l_start_date, l_expiration_date;
460: if c1%found then
461: close c1;
462: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => 'PER',
463: p_user_orig_system_id => pe_pei_shd.g_old_rec.person_id,
464: p_role_orig_system => 'PQH_ROLE',
465: p_role_orig_system_id => pe_pei_shd.g_old_rec.pei_information3,
466: p_start_date => l_start_date,
467: p_expiration_date => l_expiration_date);

Line 465: p_role_orig_system_id => pe_pei_shd.g_old_rec.pei_information3,

461: close c1;
462: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => 'PER',
463: p_user_orig_system_id => pe_pei_shd.g_old_rec.person_id,
464: p_role_orig_system => 'PQH_ROLE',
465: p_role_orig_system_id => pe_pei_shd.g_old_rec.pei_information3,
466: p_start_date => l_start_date,
467: p_expiration_date => l_expiration_date);
468: else
469: close c1;

Line 521: Procedure convert_defs(p_rec in out NOCOPY pe_pei_shd.g_rec_type) is

517: -- Internal Table Handler Use Only.
518: --
519: -- {End Of Comments}
520: -- ----------------------------------------------------------------------------
521: Procedure convert_defs(p_rec in out NOCOPY pe_pei_shd.g_rec_type) is
522: --
523: l_proc varchar2(72) := g_package||'convert_defs';
524: --
525: Begin

Line 536: pe_pei_shd.g_old_rec.person_id;

532: -- is being used then we must set to the 'current' argument value.
533: --
534: If (p_rec.person_id = hr_api.g_number) then
535: p_rec.person_id :=
536: pe_pei_shd.g_old_rec.person_id;
537: End If;
538: If (p_rec.information_type = hr_api.g_varchar2) then
539: p_rec.information_type :=
540: pe_pei_shd.g_old_rec.information_type;

Line 540: pe_pei_shd.g_old_rec.information_type;

536: pe_pei_shd.g_old_rec.person_id;
537: End If;
538: If (p_rec.information_type = hr_api.g_varchar2) then
539: p_rec.information_type :=
540: pe_pei_shd.g_old_rec.information_type;
541: End If;
542: If (p_rec.request_id = hr_api.g_number) then
543: p_rec.request_id :=
544: pe_pei_shd.g_old_rec.request_id;

Line 544: pe_pei_shd.g_old_rec.request_id;

540: pe_pei_shd.g_old_rec.information_type;
541: End If;
542: If (p_rec.request_id = hr_api.g_number) then
543: p_rec.request_id :=
544: pe_pei_shd.g_old_rec.request_id;
545: End If;
546: If (p_rec.program_application_id = hr_api.g_number) then
547: p_rec.program_application_id :=
548: pe_pei_shd.g_old_rec.program_application_id;

Line 548: pe_pei_shd.g_old_rec.program_application_id;

544: pe_pei_shd.g_old_rec.request_id;
545: End If;
546: If (p_rec.program_application_id = hr_api.g_number) then
547: p_rec.program_application_id :=
548: pe_pei_shd.g_old_rec.program_application_id;
549: End If;
550: If (p_rec.program_id = hr_api.g_number) then
551: p_rec.program_id :=
552: pe_pei_shd.g_old_rec.program_id;

Line 552: pe_pei_shd.g_old_rec.program_id;

548: pe_pei_shd.g_old_rec.program_application_id;
549: End If;
550: If (p_rec.program_id = hr_api.g_number) then
551: p_rec.program_id :=
552: pe_pei_shd.g_old_rec.program_id;
553: End If;
554: If (p_rec.program_update_date = hr_api.g_date) then
555: p_rec.program_update_date :=
556: pe_pei_shd.g_old_rec.program_update_date;

Line 556: pe_pei_shd.g_old_rec.program_update_date;

552: pe_pei_shd.g_old_rec.program_id;
553: End If;
554: If (p_rec.program_update_date = hr_api.g_date) then
555: p_rec.program_update_date :=
556: pe_pei_shd.g_old_rec.program_update_date;
557: End If;
558: If (p_rec.pei_attribute_category = hr_api.g_varchar2) then
559: p_rec.pei_attribute_category :=
560: pe_pei_shd.g_old_rec.pei_attribute_category;

Line 560: pe_pei_shd.g_old_rec.pei_attribute_category;

556: pe_pei_shd.g_old_rec.program_update_date;
557: End If;
558: If (p_rec.pei_attribute_category = hr_api.g_varchar2) then
559: p_rec.pei_attribute_category :=
560: pe_pei_shd.g_old_rec.pei_attribute_category;
561: End If;
562: If (p_rec.pei_attribute1 = hr_api.g_varchar2) then
563: p_rec.pei_attribute1 :=
564: pe_pei_shd.g_old_rec.pei_attribute1;

Line 564: pe_pei_shd.g_old_rec.pei_attribute1;

560: pe_pei_shd.g_old_rec.pei_attribute_category;
561: End If;
562: If (p_rec.pei_attribute1 = hr_api.g_varchar2) then
563: p_rec.pei_attribute1 :=
564: pe_pei_shd.g_old_rec.pei_attribute1;
565: End If;
566: If (p_rec.pei_attribute2 = hr_api.g_varchar2) then
567: p_rec.pei_attribute2 :=
568: pe_pei_shd.g_old_rec.pei_attribute2;

Line 568: pe_pei_shd.g_old_rec.pei_attribute2;

564: pe_pei_shd.g_old_rec.pei_attribute1;
565: End If;
566: If (p_rec.pei_attribute2 = hr_api.g_varchar2) then
567: p_rec.pei_attribute2 :=
568: pe_pei_shd.g_old_rec.pei_attribute2;
569: End If;
570: If (p_rec.pei_attribute3 = hr_api.g_varchar2) then
571: p_rec.pei_attribute3 :=
572: pe_pei_shd.g_old_rec.pei_attribute3;

Line 572: pe_pei_shd.g_old_rec.pei_attribute3;

568: pe_pei_shd.g_old_rec.pei_attribute2;
569: End If;
570: If (p_rec.pei_attribute3 = hr_api.g_varchar2) then
571: p_rec.pei_attribute3 :=
572: pe_pei_shd.g_old_rec.pei_attribute3;
573: End If;
574: If (p_rec.pei_attribute4 = hr_api.g_varchar2) then
575: p_rec.pei_attribute4 :=
576: pe_pei_shd.g_old_rec.pei_attribute4;

Line 576: pe_pei_shd.g_old_rec.pei_attribute4;

572: pe_pei_shd.g_old_rec.pei_attribute3;
573: End If;
574: If (p_rec.pei_attribute4 = hr_api.g_varchar2) then
575: p_rec.pei_attribute4 :=
576: pe_pei_shd.g_old_rec.pei_attribute4;
577: End If;
578: If (p_rec.pei_attribute5 = hr_api.g_varchar2) then
579: p_rec.pei_attribute5 :=
580: pe_pei_shd.g_old_rec.pei_attribute5;

Line 580: pe_pei_shd.g_old_rec.pei_attribute5;

576: pe_pei_shd.g_old_rec.pei_attribute4;
577: End If;
578: If (p_rec.pei_attribute5 = hr_api.g_varchar2) then
579: p_rec.pei_attribute5 :=
580: pe_pei_shd.g_old_rec.pei_attribute5;
581: End If;
582: If (p_rec.pei_attribute6 = hr_api.g_varchar2) then
583: p_rec.pei_attribute6 :=
584: pe_pei_shd.g_old_rec.pei_attribute6;

Line 584: pe_pei_shd.g_old_rec.pei_attribute6;

580: pe_pei_shd.g_old_rec.pei_attribute5;
581: End If;
582: If (p_rec.pei_attribute6 = hr_api.g_varchar2) then
583: p_rec.pei_attribute6 :=
584: pe_pei_shd.g_old_rec.pei_attribute6;
585: End If;
586: If (p_rec.pei_attribute7 = hr_api.g_varchar2) then
587: p_rec.pei_attribute7 :=
588: pe_pei_shd.g_old_rec.pei_attribute7;

Line 588: pe_pei_shd.g_old_rec.pei_attribute7;

584: pe_pei_shd.g_old_rec.pei_attribute6;
585: End If;
586: If (p_rec.pei_attribute7 = hr_api.g_varchar2) then
587: p_rec.pei_attribute7 :=
588: pe_pei_shd.g_old_rec.pei_attribute7;
589: End If;
590: If (p_rec.pei_attribute8 = hr_api.g_varchar2) then
591: p_rec.pei_attribute8 :=
592: pe_pei_shd.g_old_rec.pei_attribute8;

Line 592: pe_pei_shd.g_old_rec.pei_attribute8;

588: pe_pei_shd.g_old_rec.pei_attribute7;
589: End If;
590: If (p_rec.pei_attribute8 = hr_api.g_varchar2) then
591: p_rec.pei_attribute8 :=
592: pe_pei_shd.g_old_rec.pei_attribute8;
593: End If;
594: If (p_rec.pei_attribute9 = hr_api.g_varchar2) then
595: p_rec.pei_attribute9 :=
596: pe_pei_shd.g_old_rec.pei_attribute9;

Line 596: pe_pei_shd.g_old_rec.pei_attribute9;

592: pe_pei_shd.g_old_rec.pei_attribute8;
593: End If;
594: If (p_rec.pei_attribute9 = hr_api.g_varchar2) then
595: p_rec.pei_attribute9 :=
596: pe_pei_shd.g_old_rec.pei_attribute9;
597: End If;
598: If (p_rec.pei_attribute10 = hr_api.g_varchar2) then
599: p_rec.pei_attribute10 :=
600: pe_pei_shd.g_old_rec.pei_attribute10;

Line 600: pe_pei_shd.g_old_rec.pei_attribute10;

596: pe_pei_shd.g_old_rec.pei_attribute9;
597: End If;
598: If (p_rec.pei_attribute10 = hr_api.g_varchar2) then
599: p_rec.pei_attribute10 :=
600: pe_pei_shd.g_old_rec.pei_attribute10;
601: End If;
602: If (p_rec.pei_attribute11 = hr_api.g_varchar2) then
603: p_rec.pei_attribute11 :=
604: pe_pei_shd.g_old_rec.pei_attribute11;

Line 604: pe_pei_shd.g_old_rec.pei_attribute11;

600: pe_pei_shd.g_old_rec.pei_attribute10;
601: End If;
602: If (p_rec.pei_attribute11 = hr_api.g_varchar2) then
603: p_rec.pei_attribute11 :=
604: pe_pei_shd.g_old_rec.pei_attribute11;
605: End If;
606: If (p_rec.pei_attribute12 = hr_api.g_varchar2) then
607: p_rec.pei_attribute12 :=
608: pe_pei_shd.g_old_rec.pei_attribute12;

Line 608: pe_pei_shd.g_old_rec.pei_attribute12;

604: pe_pei_shd.g_old_rec.pei_attribute11;
605: End If;
606: If (p_rec.pei_attribute12 = hr_api.g_varchar2) then
607: p_rec.pei_attribute12 :=
608: pe_pei_shd.g_old_rec.pei_attribute12;
609: End If;
610: If (p_rec.pei_attribute13 = hr_api.g_varchar2) then
611: p_rec.pei_attribute13 :=
612: pe_pei_shd.g_old_rec.pei_attribute13;

Line 612: pe_pei_shd.g_old_rec.pei_attribute13;

608: pe_pei_shd.g_old_rec.pei_attribute12;
609: End If;
610: If (p_rec.pei_attribute13 = hr_api.g_varchar2) then
611: p_rec.pei_attribute13 :=
612: pe_pei_shd.g_old_rec.pei_attribute13;
613: End If;
614: If (p_rec.pei_attribute14 = hr_api.g_varchar2) then
615: p_rec.pei_attribute14 :=
616: pe_pei_shd.g_old_rec.pei_attribute14;

Line 616: pe_pei_shd.g_old_rec.pei_attribute14;

612: pe_pei_shd.g_old_rec.pei_attribute13;
613: End If;
614: If (p_rec.pei_attribute14 = hr_api.g_varchar2) then
615: p_rec.pei_attribute14 :=
616: pe_pei_shd.g_old_rec.pei_attribute14;
617: End If;
618: If (p_rec.pei_attribute15 = hr_api.g_varchar2) then
619: p_rec.pei_attribute15 :=
620: pe_pei_shd.g_old_rec.pei_attribute15;

Line 620: pe_pei_shd.g_old_rec.pei_attribute15;

616: pe_pei_shd.g_old_rec.pei_attribute14;
617: End If;
618: If (p_rec.pei_attribute15 = hr_api.g_varchar2) then
619: p_rec.pei_attribute15 :=
620: pe_pei_shd.g_old_rec.pei_attribute15;
621: End If;
622: If (p_rec.pei_attribute16 = hr_api.g_varchar2) then
623: p_rec.pei_attribute16 :=
624: pe_pei_shd.g_old_rec.pei_attribute16;

Line 624: pe_pei_shd.g_old_rec.pei_attribute16;

620: pe_pei_shd.g_old_rec.pei_attribute15;
621: End If;
622: If (p_rec.pei_attribute16 = hr_api.g_varchar2) then
623: p_rec.pei_attribute16 :=
624: pe_pei_shd.g_old_rec.pei_attribute16;
625: End If;
626: If (p_rec.pei_attribute17 = hr_api.g_varchar2) then
627: p_rec.pei_attribute17 :=
628: pe_pei_shd.g_old_rec.pei_attribute17;

Line 628: pe_pei_shd.g_old_rec.pei_attribute17;

624: pe_pei_shd.g_old_rec.pei_attribute16;
625: End If;
626: If (p_rec.pei_attribute17 = hr_api.g_varchar2) then
627: p_rec.pei_attribute17 :=
628: pe_pei_shd.g_old_rec.pei_attribute17;
629: End If;
630: If (p_rec.pei_attribute18 = hr_api.g_varchar2) then
631: p_rec.pei_attribute18 :=
632: pe_pei_shd.g_old_rec.pei_attribute18;

Line 632: pe_pei_shd.g_old_rec.pei_attribute18;

628: pe_pei_shd.g_old_rec.pei_attribute17;
629: End If;
630: If (p_rec.pei_attribute18 = hr_api.g_varchar2) then
631: p_rec.pei_attribute18 :=
632: pe_pei_shd.g_old_rec.pei_attribute18;
633: End If;
634: If (p_rec.pei_attribute19 = hr_api.g_varchar2) then
635: p_rec.pei_attribute19 :=
636: pe_pei_shd.g_old_rec.pei_attribute19;

Line 636: pe_pei_shd.g_old_rec.pei_attribute19;

632: pe_pei_shd.g_old_rec.pei_attribute18;
633: End If;
634: If (p_rec.pei_attribute19 = hr_api.g_varchar2) then
635: p_rec.pei_attribute19 :=
636: pe_pei_shd.g_old_rec.pei_attribute19;
637: End If;
638: If (p_rec.pei_attribute20 = hr_api.g_varchar2) then
639: p_rec.pei_attribute20 :=
640: pe_pei_shd.g_old_rec.pei_attribute20;

Line 640: pe_pei_shd.g_old_rec.pei_attribute20;

636: pe_pei_shd.g_old_rec.pei_attribute19;
637: End If;
638: If (p_rec.pei_attribute20 = hr_api.g_varchar2) then
639: p_rec.pei_attribute20 :=
640: pe_pei_shd.g_old_rec.pei_attribute20;
641: End If;
642: If (p_rec.pei_information_category = hr_api.g_varchar2) then
643: p_rec.pei_information_category :=
644: pe_pei_shd.g_old_rec.pei_information_category;

Line 644: pe_pei_shd.g_old_rec.pei_information_category;

640: pe_pei_shd.g_old_rec.pei_attribute20;
641: End If;
642: If (p_rec.pei_information_category = hr_api.g_varchar2) then
643: p_rec.pei_information_category :=
644: pe_pei_shd.g_old_rec.pei_information_category;
645: End If;
646: If (p_rec.pei_information1 = hr_api.g_varchar2) then
647: p_rec.pei_information1 :=
648: pe_pei_shd.g_old_rec.pei_information1;

Line 648: pe_pei_shd.g_old_rec.pei_information1;

644: pe_pei_shd.g_old_rec.pei_information_category;
645: End If;
646: If (p_rec.pei_information1 = hr_api.g_varchar2) then
647: p_rec.pei_information1 :=
648: pe_pei_shd.g_old_rec.pei_information1;
649: End If;
650: If (p_rec.pei_information2 = hr_api.g_varchar2) then
651: p_rec.pei_information2 :=
652: pe_pei_shd.g_old_rec.pei_information2;

Line 652: pe_pei_shd.g_old_rec.pei_information2;

648: pe_pei_shd.g_old_rec.pei_information1;
649: End If;
650: If (p_rec.pei_information2 = hr_api.g_varchar2) then
651: p_rec.pei_information2 :=
652: pe_pei_shd.g_old_rec.pei_information2;
653: End If;
654: If (p_rec.pei_information3 = hr_api.g_varchar2) then
655: p_rec.pei_information3 :=
656: pe_pei_shd.g_old_rec.pei_information3;

Line 656: pe_pei_shd.g_old_rec.pei_information3;

652: pe_pei_shd.g_old_rec.pei_information2;
653: End If;
654: If (p_rec.pei_information3 = hr_api.g_varchar2) then
655: p_rec.pei_information3 :=
656: pe_pei_shd.g_old_rec.pei_information3;
657: End If;
658: If (p_rec.pei_information4 = hr_api.g_varchar2) then
659: p_rec.pei_information4 :=
660: pe_pei_shd.g_old_rec.pei_information4;

Line 660: pe_pei_shd.g_old_rec.pei_information4;

656: pe_pei_shd.g_old_rec.pei_information3;
657: End If;
658: If (p_rec.pei_information4 = hr_api.g_varchar2) then
659: p_rec.pei_information4 :=
660: pe_pei_shd.g_old_rec.pei_information4;
661: End If;
662: If (p_rec.pei_information5 = hr_api.g_varchar2) then
663: p_rec.pei_information5 :=
664: pe_pei_shd.g_old_rec.pei_information5;

Line 664: pe_pei_shd.g_old_rec.pei_information5;

660: pe_pei_shd.g_old_rec.pei_information4;
661: End If;
662: If (p_rec.pei_information5 = hr_api.g_varchar2) then
663: p_rec.pei_information5 :=
664: pe_pei_shd.g_old_rec.pei_information5;
665: End If;
666: If (p_rec.pei_information6 = hr_api.g_varchar2) then
667: p_rec.pei_information6 :=
668: pe_pei_shd.g_old_rec.pei_information6;

Line 668: pe_pei_shd.g_old_rec.pei_information6;

664: pe_pei_shd.g_old_rec.pei_information5;
665: End If;
666: If (p_rec.pei_information6 = hr_api.g_varchar2) then
667: p_rec.pei_information6 :=
668: pe_pei_shd.g_old_rec.pei_information6;
669: End If;
670: If (p_rec.pei_information7 = hr_api.g_varchar2) then
671: p_rec.pei_information7 :=
672: pe_pei_shd.g_old_rec.pei_information7;

Line 672: pe_pei_shd.g_old_rec.pei_information7;

668: pe_pei_shd.g_old_rec.pei_information6;
669: End If;
670: If (p_rec.pei_information7 = hr_api.g_varchar2) then
671: p_rec.pei_information7 :=
672: pe_pei_shd.g_old_rec.pei_information7;
673: End If;
674: If (p_rec.pei_information8 = hr_api.g_varchar2) then
675: p_rec.pei_information8 :=
676: pe_pei_shd.g_old_rec.pei_information8;

Line 676: pe_pei_shd.g_old_rec.pei_information8;

672: pe_pei_shd.g_old_rec.pei_information7;
673: End If;
674: If (p_rec.pei_information8 = hr_api.g_varchar2) then
675: p_rec.pei_information8 :=
676: pe_pei_shd.g_old_rec.pei_information8;
677: End If;
678: If (p_rec.pei_information9 = hr_api.g_varchar2) then
679: p_rec.pei_information9 :=
680: pe_pei_shd.g_old_rec.pei_information9;

Line 680: pe_pei_shd.g_old_rec.pei_information9;

676: pe_pei_shd.g_old_rec.pei_information8;
677: End If;
678: If (p_rec.pei_information9 = hr_api.g_varchar2) then
679: p_rec.pei_information9 :=
680: pe_pei_shd.g_old_rec.pei_information9;
681: End If;
682: If (p_rec.pei_information10 = hr_api.g_varchar2) then
683: p_rec.pei_information10 :=
684: pe_pei_shd.g_old_rec.pei_information10;

Line 684: pe_pei_shd.g_old_rec.pei_information10;

680: pe_pei_shd.g_old_rec.pei_information9;
681: End If;
682: If (p_rec.pei_information10 = hr_api.g_varchar2) then
683: p_rec.pei_information10 :=
684: pe_pei_shd.g_old_rec.pei_information10;
685: End If;
686: If (p_rec.pei_information11 = hr_api.g_varchar2) then
687: p_rec.pei_information11 :=
688: pe_pei_shd.g_old_rec.pei_information11;

Line 688: pe_pei_shd.g_old_rec.pei_information11;

684: pe_pei_shd.g_old_rec.pei_information10;
685: End If;
686: If (p_rec.pei_information11 = hr_api.g_varchar2) then
687: p_rec.pei_information11 :=
688: pe_pei_shd.g_old_rec.pei_information11;
689: End If;
690: If (p_rec.pei_information12 = hr_api.g_varchar2) then
691: p_rec.pei_information12 :=
692: pe_pei_shd.g_old_rec.pei_information12;

Line 692: pe_pei_shd.g_old_rec.pei_information12;

688: pe_pei_shd.g_old_rec.pei_information11;
689: End If;
690: If (p_rec.pei_information12 = hr_api.g_varchar2) then
691: p_rec.pei_information12 :=
692: pe_pei_shd.g_old_rec.pei_information12;
693: End If;
694: If (p_rec.pei_information13 = hr_api.g_varchar2) then
695: p_rec.pei_information13 :=
696: pe_pei_shd.g_old_rec.pei_information13;

Line 696: pe_pei_shd.g_old_rec.pei_information13;

692: pe_pei_shd.g_old_rec.pei_information12;
693: End If;
694: If (p_rec.pei_information13 = hr_api.g_varchar2) then
695: p_rec.pei_information13 :=
696: pe_pei_shd.g_old_rec.pei_information13;
697: End If;
698: If (p_rec.pei_information14 = hr_api.g_varchar2) then
699: p_rec.pei_information14 :=
700: pe_pei_shd.g_old_rec.pei_information14;

Line 700: pe_pei_shd.g_old_rec.pei_information14;

696: pe_pei_shd.g_old_rec.pei_information13;
697: End If;
698: If (p_rec.pei_information14 = hr_api.g_varchar2) then
699: p_rec.pei_information14 :=
700: pe_pei_shd.g_old_rec.pei_information14;
701: End If;
702: If (p_rec.pei_information15 = hr_api.g_varchar2) then
703: p_rec.pei_information15 :=
704: pe_pei_shd.g_old_rec.pei_information15;

Line 704: pe_pei_shd.g_old_rec.pei_information15;

700: pe_pei_shd.g_old_rec.pei_information14;
701: End If;
702: If (p_rec.pei_information15 = hr_api.g_varchar2) then
703: p_rec.pei_information15 :=
704: pe_pei_shd.g_old_rec.pei_information15;
705: End If;
706: If (p_rec.pei_information16 = hr_api.g_varchar2) then
707: p_rec.pei_information16 :=
708: pe_pei_shd.g_old_rec.pei_information16;

Line 708: pe_pei_shd.g_old_rec.pei_information16;

704: pe_pei_shd.g_old_rec.pei_information15;
705: End If;
706: If (p_rec.pei_information16 = hr_api.g_varchar2) then
707: p_rec.pei_information16 :=
708: pe_pei_shd.g_old_rec.pei_information16;
709: End If;
710: If (p_rec.pei_information17 = hr_api.g_varchar2) then
711: p_rec.pei_information17 :=
712: pe_pei_shd.g_old_rec.pei_information17;

Line 712: pe_pei_shd.g_old_rec.pei_information17;

708: pe_pei_shd.g_old_rec.pei_information16;
709: End If;
710: If (p_rec.pei_information17 = hr_api.g_varchar2) then
711: p_rec.pei_information17 :=
712: pe_pei_shd.g_old_rec.pei_information17;
713: End If;
714: If (p_rec.pei_information18 = hr_api.g_varchar2) then
715: p_rec.pei_information18 :=
716: pe_pei_shd.g_old_rec.pei_information18;

Line 716: pe_pei_shd.g_old_rec.pei_information18;

712: pe_pei_shd.g_old_rec.pei_information17;
713: End If;
714: If (p_rec.pei_information18 = hr_api.g_varchar2) then
715: p_rec.pei_information18 :=
716: pe_pei_shd.g_old_rec.pei_information18;
717: End If;
718: If (p_rec.pei_information19 = hr_api.g_varchar2) then
719: p_rec.pei_information19 :=
720: pe_pei_shd.g_old_rec.pei_information19;

Line 720: pe_pei_shd.g_old_rec.pei_information19;

716: pe_pei_shd.g_old_rec.pei_information18;
717: End If;
718: If (p_rec.pei_information19 = hr_api.g_varchar2) then
719: p_rec.pei_information19 :=
720: pe_pei_shd.g_old_rec.pei_information19;
721: End If;
722: If (p_rec.pei_information20 = hr_api.g_varchar2) then
723: p_rec.pei_information20 :=
724: pe_pei_shd.g_old_rec.pei_information20;

Line 724: pe_pei_shd.g_old_rec.pei_information20;

720: pe_pei_shd.g_old_rec.pei_information19;
721: End If;
722: If (p_rec.pei_information20 = hr_api.g_varchar2) then
723: p_rec.pei_information20 :=
724: pe_pei_shd.g_old_rec.pei_information20;
725: End If;
726: If (p_rec.pei_information21 = hr_api.g_varchar2) then
727: p_rec.pei_information21 :=
728: pe_pei_shd.g_old_rec.pei_information21;

Line 728: pe_pei_shd.g_old_rec.pei_information21;

724: pe_pei_shd.g_old_rec.pei_information20;
725: End If;
726: If (p_rec.pei_information21 = hr_api.g_varchar2) then
727: p_rec.pei_information21 :=
728: pe_pei_shd.g_old_rec.pei_information21;
729: End If;
730: If (p_rec.pei_information22 = hr_api.g_varchar2) then
731: p_rec.pei_information22 :=
732: pe_pei_shd.g_old_rec.pei_information22;

Line 732: pe_pei_shd.g_old_rec.pei_information22;

728: pe_pei_shd.g_old_rec.pei_information21;
729: End If;
730: If (p_rec.pei_information22 = hr_api.g_varchar2) then
731: p_rec.pei_information22 :=
732: pe_pei_shd.g_old_rec.pei_information22;
733: End If;
734: If (p_rec.pei_information23 = hr_api.g_varchar2) then
735: p_rec.pei_information23 :=
736: pe_pei_shd.g_old_rec.pei_information23;

Line 736: pe_pei_shd.g_old_rec.pei_information23;

732: pe_pei_shd.g_old_rec.pei_information22;
733: End If;
734: If (p_rec.pei_information23 = hr_api.g_varchar2) then
735: p_rec.pei_information23 :=
736: pe_pei_shd.g_old_rec.pei_information23;
737: End If;
738: If (p_rec.pei_information24 = hr_api.g_varchar2) then
739: p_rec.pei_information24 :=
740: pe_pei_shd.g_old_rec.pei_information24;

Line 740: pe_pei_shd.g_old_rec.pei_information24;

736: pe_pei_shd.g_old_rec.pei_information23;
737: End If;
738: If (p_rec.pei_information24 = hr_api.g_varchar2) then
739: p_rec.pei_information24 :=
740: pe_pei_shd.g_old_rec.pei_information24;
741: End If;
742: If (p_rec.pei_information25 = hr_api.g_varchar2) then
743: p_rec.pei_information25 :=
744: pe_pei_shd.g_old_rec.pei_information25;

Line 744: pe_pei_shd.g_old_rec.pei_information25;

740: pe_pei_shd.g_old_rec.pei_information24;
741: End If;
742: If (p_rec.pei_information25 = hr_api.g_varchar2) then
743: p_rec.pei_information25 :=
744: pe_pei_shd.g_old_rec.pei_information25;
745: End If;
746: If (p_rec.pei_information26 = hr_api.g_varchar2) then
747: p_rec.pei_information26 :=
748: pe_pei_shd.g_old_rec.pei_information26;

Line 748: pe_pei_shd.g_old_rec.pei_information26;

744: pe_pei_shd.g_old_rec.pei_information25;
745: End If;
746: If (p_rec.pei_information26 = hr_api.g_varchar2) then
747: p_rec.pei_information26 :=
748: pe_pei_shd.g_old_rec.pei_information26;
749: End If;
750: If (p_rec.pei_information27 = hr_api.g_varchar2) then
751: p_rec.pei_information27 :=
752: pe_pei_shd.g_old_rec.pei_information27;

Line 752: pe_pei_shd.g_old_rec.pei_information27;

748: pe_pei_shd.g_old_rec.pei_information26;
749: End If;
750: If (p_rec.pei_information27 = hr_api.g_varchar2) then
751: p_rec.pei_information27 :=
752: pe_pei_shd.g_old_rec.pei_information27;
753: End If;
754: If (p_rec.pei_information28 = hr_api.g_varchar2) then
755: p_rec.pei_information28 :=
756: pe_pei_shd.g_old_rec.pei_information28;

Line 756: pe_pei_shd.g_old_rec.pei_information28;

752: pe_pei_shd.g_old_rec.pei_information27;
753: End If;
754: If (p_rec.pei_information28 = hr_api.g_varchar2) then
755: p_rec.pei_information28 :=
756: pe_pei_shd.g_old_rec.pei_information28;
757: End If;
758: If (p_rec.pei_information29 = hr_api.g_varchar2) then
759: p_rec.pei_information29 :=
760: pe_pei_shd.g_old_rec.pei_information29;

Line 760: pe_pei_shd.g_old_rec.pei_information29;

756: pe_pei_shd.g_old_rec.pei_information28;
757: End If;
758: If (p_rec.pei_information29 = hr_api.g_varchar2) then
759: p_rec.pei_information29 :=
760: pe_pei_shd.g_old_rec.pei_information29;
761: End If;
762: If (p_rec.pei_information30 = hr_api.g_varchar2) then
763: p_rec.pei_information30 :=
764: pe_pei_shd.g_old_rec.pei_information30;

Line 764: pe_pei_shd.g_old_rec.pei_information30;

760: pe_pei_shd.g_old_rec.pei_information29;
761: End If;
762: If (p_rec.pei_information30 = hr_api.g_varchar2) then
763: p_rec.pei_information30 :=
764: pe_pei_shd.g_old_rec.pei_information30;
765: End If;
766:
767: --
768: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 777: p_rec in out NOCOPY pe_pei_shd.g_rec_type,

773: -- |---------------------------------< upd >----------------------------------|
774: -- ----------------------------------------------------------------------------
775: Procedure upd
776: (
777: p_rec in out NOCOPY pe_pei_shd.g_rec_type,
778: p_validate in boolean default false
779: ) is
780: --
781: l_proc varchar2(72) := g_package||'upd';

Line 797: pe_pei_shd.lck

793: End If;
794: --
795: -- We must lock the row which we need to update.
796: --
797: pe_pei_shd.lck
798: (
799: p_rec.person_extra_info_id,
800: p_rec.object_version_number
801: );

Line 906: l_rec pe_pei_shd.g_rec_type;

902: p_object_version_number in out NOCOPY number,
903: p_validate in boolean default false
904: ) is
905: --
906: l_rec pe_pei_shd.g_rec_type;
907: l_proc varchar2(72) := g_package||'upd';
908: --
909: Begin
910: hr_utility.set_location('Entering:'||l_proc, 5);

Line 916: pe_pei_shd.convert_args

912: -- Call conversion function to turn arguments into the
913: -- l_rec structure.
914: --
915: l_rec :=
916: pe_pei_shd.convert_args
917: (
918: p_person_extra_info_id,
919: hr_api.g_number,
920: hr_api.g_varchar2,