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.GHR_REI_UPD dependencies on GHR_REI_SHD

Line 50: Procedure update_dml(p_rec in out nocopy ghr_rei_shd.g_rec_type) is

46: -- Internal Table Handler Use Only.
47: --
48: -- {End Of Comments}
49: -- ----------------------------------------------------------------------------
50: Procedure update_dml(p_rec in out nocopy ghr_rei_shd.g_rec_type) is
51: --
52: l_proc varchar2(72) := g_package||'update_dml';
53: --
54: Begin

Line 132: ghr_rei_shd.constraint_error

128: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ghr_rei_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: ghr_rei_shd.constraint_error

Line 136: ghr_rei_shd.constraint_error

132: ghr_rei_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: ghr_rei_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: ghr_rei_shd.constraint_error

Line 140: ghr_rei_shd.constraint_error

136: ghr_rei_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: ghr_rei_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: Raise;
144: End update_dml;

Line 178: Procedure pre_update(p_rec in ghr_rei_shd.g_rec_type) is

174: -- Internal Table Handler Use Only.
175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure pre_update(p_rec in ghr_rei_shd.g_rec_type) is
179: --
180: l_proc varchar2(72) := g_package||'pre_update';
181: --
182: Begin

Line 220: Procedure post_update(p_rec in ghr_rei_shd.g_rec_type) is

216: -- Internal Table Handler Use Only.
217: --
218: -- {End Of Comments}
219: -- ----------------------------------------------------------------------------
220: Procedure post_update(p_rec in ghr_rei_shd.g_rec_type) is
221: --
222: l_proc varchar2(72) := g_package||'post_update';
223: --
224: Begin

Line 290: p_pa_request_id_o => ghr_rei_shd.g_old_rec.pa_request_id ,

286: p_request_id => p_rec.request_id ,
287: p_program_application_id => p_rec.program_application_id ,
288: p_program_id => p_rec.program_id ,
289: p_program_update_date => p_rec.program_update_date ,
290: p_pa_request_id_o => ghr_rei_shd.g_old_rec.pa_request_id ,
291: p_information_type_o => ghr_rei_shd.g_old_rec.information_type ,
292: p_rei_attribute_category_o => ghr_rei_shd.g_old_rec.rei_attribute_category ,
293: p_rei_attribute1_o => ghr_rei_shd.g_old_rec.rei_attribute1 ,
294: p_rei_attribute2_o => ghr_rei_shd.g_old_rec.rei_attribute2 ,

Line 291: p_information_type_o => ghr_rei_shd.g_old_rec.information_type ,

287: p_program_application_id => p_rec.program_application_id ,
288: p_program_id => p_rec.program_id ,
289: p_program_update_date => p_rec.program_update_date ,
290: p_pa_request_id_o => ghr_rei_shd.g_old_rec.pa_request_id ,
291: p_information_type_o => ghr_rei_shd.g_old_rec.information_type ,
292: p_rei_attribute_category_o => ghr_rei_shd.g_old_rec.rei_attribute_category ,
293: p_rei_attribute1_o => ghr_rei_shd.g_old_rec.rei_attribute1 ,
294: p_rei_attribute2_o => ghr_rei_shd.g_old_rec.rei_attribute2 ,
295: p_rei_attribute3_o => ghr_rei_shd.g_old_rec.rei_attribute3 ,

Line 292: p_rei_attribute_category_o => ghr_rei_shd.g_old_rec.rei_attribute_category ,

288: p_program_id => p_rec.program_id ,
289: p_program_update_date => p_rec.program_update_date ,
290: p_pa_request_id_o => ghr_rei_shd.g_old_rec.pa_request_id ,
291: p_information_type_o => ghr_rei_shd.g_old_rec.information_type ,
292: p_rei_attribute_category_o => ghr_rei_shd.g_old_rec.rei_attribute_category ,
293: p_rei_attribute1_o => ghr_rei_shd.g_old_rec.rei_attribute1 ,
294: p_rei_attribute2_o => ghr_rei_shd.g_old_rec.rei_attribute2 ,
295: p_rei_attribute3_o => ghr_rei_shd.g_old_rec.rei_attribute3 ,
296: p_rei_attribute4_o => ghr_rei_shd.g_old_rec.rei_attribute4 ,

Line 293: p_rei_attribute1_o => ghr_rei_shd.g_old_rec.rei_attribute1 ,

289: p_program_update_date => p_rec.program_update_date ,
290: p_pa_request_id_o => ghr_rei_shd.g_old_rec.pa_request_id ,
291: p_information_type_o => ghr_rei_shd.g_old_rec.information_type ,
292: p_rei_attribute_category_o => ghr_rei_shd.g_old_rec.rei_attribute_category ,
293: p_rei_attribute1_o => ghr_rei_shd.g_old_rec.rei_attribute1 ,
294: p_rei_attribute2_o => ghr_rei_shd.g_old_rec.rei_attribute2 ,
295: p_rei_attribute3_o => ghr_rei_shd.g_old_rec.rei_attribute3 ,
296: p_rei_attribute4_o => ghr_rei_shd.g_old_rec.rei_attribute4 ,
297: p_rei_attribute5_o => ghr_rei_shd.g_old_rec.rei_attribute5 ,

Line 294: p_rei_attribute2_o => ghr_rei_shd.g_old_rec.rei_attribute2 ,

290: p_pa_request_id_o => ghr_rei_shd.g_old_rec.pa_request_id ,
291: p_information_type_o => ghr_rei_shd.g_old_rec.information_type ,
292: p_rei_attribute_category_o => ghr_rei_shd.g_old_rec.rei_attribute_category ,
293: p_rei_attribute1_o => ghr_rei_shd.g_old_rec.rei_attribute1 ,
294: p_rei_attribute2_o => ghr_rei_shd.g_old_rec.rei_attribute2 ,
295: p_rei_attribute3_o => ghr_rei_shd.g_old_rec.rei_attribute3 ,
296: p_rei_attribute4_o => ghr_rei_shd.g_old_rec.rei_attribute4 ,
297: p_rei_attribute5_o => ghr_rei_shd.g_old_rec.rei_attribute5 ,
298: p_rei_attribute6_o => ghr_rei_shd.g_old_rec.rei_attribute6 ,

Line 295: p_rei_attribute3_o => ghr_rei_shd.g_old_rec.rei_attribute3 ,

291: p_information_type_o => ghr_rei_shd.g_old_rec.information_type ,
292: p_rei_attribute_category_o => ghr_rei_shd.g_old_rec.rei_attribute_category ,
293: p_rei_attribute1_o => ghr_rei_shd.g_old_rec.rei_attribute1 ,
294: p_rei_attribute2_o => ghr_rei_shd.g_old_rec.rei_attribute2 ,
295: p_rei_attribute3_o => ghr_rei_shd.g_old_rec.rei_attribute3 ,
296: p_rei_attribute4_o => ghr_rei_shd.g_old_rec.rei_attribute4 ,
297: p_rei_attribute5_o => ghr_rei_shd.g_old_rec.rei_attribute5 ,
298: p_rei_attribute6_o => ghr_rei_shd.g_old_rec.rei_attribute6 ,
299: p_rei_attribute7_o => ghr_rei_shd.g_old_rec.rei_attribute7 ,

Line 296: p_rei_attribute4_o => ghr_rei_shd.g_old_rec.rei_attribute4 ,

292: p_rei_attribute_category_o => ghr_rei_shd.g_old_rec.rei_attribute_category ,
293: p_rei_attribute1_o => ghr_rei_shd.g_old_rec.rei_attribute1 ,
294: p_rei_attribute2_o => ghr_rei_shd.g_old_rec.rei_attribute2 ,
295: p_rei_attribute3_o => ghr_rei_shd.g_old_rec.rei_attribute3 ,
296: p_rei_attribute4_o => ghr_rei_shd.g_old_rec.rei_attribute4 ,
297: p_rei_attribute5_o => ghr_rei_shd.g_old_rec.rei_attribute5 ,
298: p_rei_attribute6_o => ghr_rei_shd.g_old_rec.rei_attribute6 ,
299: p_rei_attribute7_o => ghr_rei_shd.g_old_rec.rei_attribute7 ,
300: p_rei_attribute8_o => ghr_rei_shd.g_old_rec.rei_attribute8 ,

Line 297: p_rei_attribute5_o => ghr_rei_shd.g_old_rec.rei_attribute5 ,

293: p_rei_attribute1_o => ghr_rei_shd.g_old_rec.rei_attribute1 ,
294: p_rei_attribute2_o => ghr_rei_shd.g_old_rec.rei_attribute2 ,
295: p_rei_attribute3_o => ghr_rei_shd.g_old_rec.rei_attribute3 ,
296: p_rei_attribute4_o => ghr_rei_shd.g_old_rec.rei_attribute4 ,
297: p_rei_attribute5_o => ghr_rei_shd.g_old_rec.rei_attribute5 ,
298: p_rei_attribute6_o => ghr_rei_shd.g_old_rec.rei_attribute6 ,
299: p_rei_attribute7_o => ghr_rei_shd.g_old_rec.rei_attribute7 ,
300: p_rei_attribute8_o => ghr_rei_shd.g_old_rec.rei_attribute8 ,
301: p_rei_attribute9_o => ghr_rei_shd.g_old_rec.rei_attribute9 ,

Line 298: p_rei_attribute6_o => ghr_rei_shd.g_old_rec.rei_attribute6 ,

294: p_rei_attribute2_o => ghr_rei_shd.g_old_rec.rei_attribute2 ,
295: p_rei_attribute3_o => ghr_rei_shd.g_old_rec.rei_attribute3 ,
296: p_rei_attribute4_o => ghr_rei_shd.g_old_rec.rei_attribute4 ,
297: p_rei_attribute5_o => ghr_rei_shd.g_old_rec.rei_attribute5 ,
298: p_rei_attribute6_o => ghr_rei_shd.g_old_rec.rei_attribute6 ,
299: p_rei_attribute7_o => ghr_rei_shd.g_old_rec.rei_attribute7 ,
300: p_rei_attribute8_o => ghr_rei_shd.g_old_rec.rei_attribute8 ,
301: p_rei_attribute9_o => ghr_rei_shd.g_old_rec.rei_attribute9 ,
302: p_rei_attribute10_o => ghr_rei_shd.g_old_rec.rei_attribute10 ,

Line 299: p_rei_attribute7_o => ghr_rei_shd.g_old_rec.rei_attribute7 ,

295: p_rei_attribute3_o => ghr_rei_shd.g_old_rec.rei_attribute3 ,
296: p_rei_attribute4_o => ghr_rei_shd.g_old_rec.rei_attribute4 ,
297: p_rei_attribute5_o => ghr_rei_shd.g_old_rec.rei_attribute5 ,
298: p_rei_attribute6_o => ghr_rei_shd.g_old_rec.rei_attribute6 ,
299: p_rei_attribute7_o => ghr_rei_shd.g_old_rec.rei_attribute7 ,
300: p_rei_attribute8_o => ghr_rei_shd.g_old_rec.rei_attribute8 ,
301: p_rei_attribute9_o => ghr_rei_shd.g_old_rec.rei_attribute9 ,
302: p_rei_attribute10_o => ghr_rei_shd.g_old_rec.rei_attribute10 ,
303: p_rei_attribute11_o => ghr_rei_shd.g_old_rec.rei_attribute11 ,

Line 300: p_rei_attribute8_o => ghr_rei_shd.g_old_rec.rei_attribute8 ,

296: p_rei_attribute4_o => ghr_rei_shd.g_old_rec.rei_attribute4 ,
297: p_rei_attribute5_o => ghr_rei_shd.g_old_rec.rei_attribute5 ,
298: p_rei_attribute6_o => ghr_rei_shd.g_old_rec.rei_attribute6 ,
299: p_rei_attribute7_o => ghr_rei_shd.g_old_rec.rei_attribute7 ,
300: p_rei_attribute8_o => ghr_rei_shd.g_old_rec.rei_attribute8 ,
301: p_rei_attribute9_o => ghr_rei_shd.g_old_rec.rei_attribute9 ,
302: p_rei_attribute10_o => ghr_rei_shd.g_old_rec.rei_attribute10 ,
303: p_rei_attribute11_o => ghr_rei_shd.g_old_rec.rei_attribute11 ,
304: p_rei_attribute12_o => ghr_rei_shd.g_old_rec.rei_attribute12 ,

Line 301: p_rei_attribute9_o => ghr_rei_shd.g_old_rec.rei_attribute9 ,

297: p_rei_attribute5_o => ghr_rei_shd.g_old_rec.rei_attribute5 ,
298: p_rei_attribute6_o => ghr_rei_shd.g_old_rec.rei_attribute6 ,
299: p_rei_attribute7_o => ghr_rei_shd.g_old_rec.rei_attribute7 ,
300: p_rei_attribute8_o => ghr_rei_shd.g_old_rec.rei_attribute8 ,
301: p_rei_attribute9_o => ghr_rei_shd.g_old_rec.rei_attribute9 ,
302: p_rei_attribute10_o => ghr_rei_shd.g_old_rec.rei_attribute10 ,
303: p_rei_attribute11_o => ghr_rei_shd.g_old_rec.rei_attribute11 ,
304: p_rei_attribute12_o => ghr_rei_shd.g_old_rec.rei_attribute12 ,
305: p_rei_attribute13_o => ghr_rei_shd.g_old_rec.rei_attribute13 ,

Line 302: p_rei_attribute10_o => ghr_rei_shd.g_old_rec.rei_attribute10 ,

298: p_rei_attribute6_o => ghr_rei_shd.g_old_rec.rei_attribute6 ,
299: p_rei_attribute7_o => ghr_rei_shd.g_old_rec.rei_attribute7 ,
300: p_rei_attribute8_o => ghr_rei_shd.g_old_rec.rei_attribute8 ,
301: p_rei_attribute9_o => ghr_rei_shd.g_old_rec.rei_attribute9 ,
302: p_rei_attribute10_o => ghr_rei_shd.g_old_rec.rei_attribute10 ,
303: p_rei_attribute11_o => ghr_rei_shd.g_old_rec.rei_attribute11 ,
304: p_rei_attribute12_o => ghr_rei_shd.g_old_rec.rei_attribute12 ,
305: p_rei_attribute13_o => ghr_rei_shd.g_old_rec.rei_attribute13 ,
306: p_rei_attribute14_o => ghr_rei_shd.g_old_rec.rei_attribute14 ,

Line 303: p_rei_attribute11_o => ghr_rei_shd.g_old_rec.rei_attribute11 ,

299: p_rei_attribute7_o => ghr_rei_shd.g_old_rec.rei_attribute7 ,
300: p_rei_attribute8_o => ghr_rei_shd.g_old_rec.rei_attribute8 ,
301: p_rei_attribute9_o => ghr_rei_shd.g_old_rec.rei_attribute9 ,
302: p_rei_attribute10_o => ghr_rei_shd.g_old_rec.rei_attribute10 ,
303: p_rei_attribute11_o => ghr_rei_shd.g_old_rec.rei_attribute11 ,
304: p_rei_attribute12_o => ghr_rei_shd.g_old_rec.rei_attribute12 ,
305: p_rei_attribute13_o => ghr_rei_shd.g_old_rec.rei_attribute13 ,
306: p_rei_attribute14_o => ghr_rei_shd.g_old_rec.rei_attribute14 ,
307: p_rei_attribute15_o => ghr_rei_shd.g_old_rec.rei_attribute15 ,

Line 304: p_rei_attribute12_o => ghr_rei_shd.g_old_rec.rei_attribute12 ,

300: p_rei_attribute8_o => ghr_rei_shd.g_old_rec.rei_attribute8 ,
301: p_rei_attribute9_o => ghr_rei_shd.g_old_rec.rei_attribute9 ,
302: p_rei_attribute10_o => ghr_rei_shd.g_old_rec.rei_attribute10 ,
303: p_rei_attribute11_o => ghr_rei_shd.g_old_rec.rei_attribute11 ,
304: p_rei_attribute12_o => ghr_rei_shd.g_old_rec.rei_attribute12 ,
305: p_rei_attribute13_o => ghr_rei_shd.g_old_rec.rei_attribute13 ,
306: p_rei_attribute14_o => ghr_rei_shd.g_old_rec.rei_attribute14 ,
307: p_rei_attribute15_o => ghr_rei_shd.g_old_rec.rei_attribute15 ,
308: p_rei_attribute16_o => ghr_rei_shd.g_old_rec.rei_attribute16 ,

Line 305: p_rei_attribute13_o => ghr_rei_shd.g_old_rec.rei_attribute13 ,

301: p_rei_attribute9_o => ghr_rei_shd.g_old_rec.rei_attribute9 ,
302: p_rei_attribute10_o => ghr_rei_shd.g_old_rec.rei_attribute10 ,
303: p_rei_attribute11_o => ghr_rei_shd.g_old_rec.rei_attribute11 ,
304: p_rei_attribute12_o => ghr_rei_shd.g_old_rec.rei_attribute12 ,
305: p_rei_attribute13_o => ghr_rei_shd.g_old_rec.rei_attribute13 ,
306: p_rei_attribute14_o => ghr_rei_shd.g_old_rec.rei_attribute14 ,
307: p_rei_attribute15_o => ghr_rei_shd.g_old_rec.rei_attribute15 ,
308: p_rei_attribute16_o => ghr_rei_shd.g_old_rec.rei_attribute16 ,
309: p_rei_attribute17_o => ghr_rei_shd.g_old_rec.rei_attribute17 ,

Line 306: p_rei_attribute14_o => ghr_rei_shd.g_old_rec.rei_attribute14 ,

302: p_rei_attribute10_o => ghr_rei_shd.g_old_rec.rei_attribute10 ,
303: p_rei_attribute11_o => ghr_rei_shd.g_old_rec.rei_attribute11 ,
304: p_rei_attribute12_o => ghr_rei_shd.g_old_rec.rei_attribute12 ,
305: p_rei_attribute13_o => ghr_rei_shd.g_old_rec.rei_attribute13 ,
306: p_rei_attribute14_o => ghr_rei_shd.g_old_rec.rei_attribute14 ,
307: p_rei_attribute15_o => ghr_rei_shd.g_old_rec.rei_attribute15 ,
308: p_rei_attribute16_o => ghr_rei_shd.g_old_rec.rei_attribute16 ,
309: p_rei_attribute17_o => ghr_rei_shd.g_old_rec.rei_attribute17 ,
310: p_rei_attribute18_o => ghr_rei_shd.g_old_rec.rei_attribute18 ,

Line 307: p_rei_attribute15_o => ghr_rei_shd.g_old_rec.rei_attribute15 ,

303: p_rei_attribute11_o => ghr_rei_shd.g_old_rec.rei_attribute11 ,
304: p_rei_attribute12_o => ghr_rei_shd.g_old_rec.rei_attribute12 ,
305: p_rei_attribute13_o => ghr_rei_shd.g_old_rec.rei_attribute13 ,
306: p_rei_attribute14_o => ghr_rei_shd.g_old_rec.rei_attribute14 ,
307: p_rei_attribute15_o => ghr_rei_shd.g_old_rec.rei_attribute15 ,
308: p_rei_attribute16_o => ghr_rei_shd.g_old_rec.rei_attribute16 ,
309: p_rei_attribute17_o => ghr_rei_shd.g_old_rec.rei_attribute17 ,
310: p_rei_attribute18_o => ghr_rei_shd.g_old_rec.rei_attribute18 ,
311: p_rei_attribute19_o => ghr_rei_shd.g_old_rec.rei_attribute19 ,

Line 308: p_rei_attribute16_o => ghr_rei_shd.g_old_rec.rei_attribute16 ,

304: p_rei_attribute12_o => ghr_rei_shd.g_old_rec.rei_attribute12 ,
305: p_rei_attribute13_o => ghr_rei_shd.g_old_rec.rei_attribute13 ,
306: p_rei_attribute14_o => ghr_rei_shd.g_old_rec.rei_attribute14 ,
307: p_rei_attribute15_o => ghr_rei_shd.g_old_rec.rei_attribute15 ,
308: p_rei_attribute16_o => ghr_rei_shd.g_old_rec.rei_attribute16 ,
309: p_rei_attribute17_o => ghr_rei_shd.g_old_rec.rei_attribute17 ,
310: p_rei_attribute18_o => ghr_rei_shd.g_old_rec.rei_attribute18 ,
311: p_rei_attribute19_o => ghr_rei_shd.g_old_rec.rei_attribute19 ,
312: p_rei_attribute20_o => ghr_rei_shd.g_old_rec.rei_attribute20 ,

Line 309: p_rei_attribute17_o => ghr_rei_shd.g_old_rec.rei_attribute17 ,

305: p_rei_attribute13_o => ghr_rei_shd.g_old_rec.rei_attribute13 ,
306: p_rei_attribute14_o => ghr_rei_shd.g_old_rec.rei_attribute14 ,
307: p_rei_attribute15_o => ghr_rei_shd.g_old_rec.rei_attribute15 ,
308: p_rei_attribute16_o => ghr_rei_shd.g_old_rec.rei_attribute16 ,
309: p_rei_attribute17_o => ghr_rei_shd.g_old_rec.rei_attribute17 ,
310: p_rei_attribute18_o => ghr_rei_shd.g_old_rec.rei_attribute18 ,
311: p_rei_attribute19_o => ghr_rei_shd.g_old_rec.rei_attribute19 ,
312: p_rei_attribute20_o => ghr_rei_shd.g_old_rec.rei_attribute20 ,
313: p_rei_information_category_o => ghr_rei_shd.g_old_rec.rei_information_category ,

Line 310: p_rei_attribute18_o => ghr_rei_shd.g_old_rec.rei_attribute18 ,

306: p_rei_attribute14_o => ghr_rei_shd.g_old_rec.rei_attribute14 ,
307: p_rei_attribute15_o => ghr_rei_shd.g_old_rec.rei_attribute15 ,
308: p_rei_attribute16_o => ghr_rei_shd.g_old_rec.rei_attribute16 ,
309: p_rei_attribute17_o => ghr_rei_shd.g_old_rec.rei_attribute17 ,
310: p_rei_attribute18_o => ghr_rei_shd.g_old_rec.rei_attribute18 ,
311: p_rei_attribute19_o => ghr_rei_shd.g_old_rec.rei_attribute19 ,
312: p_rei_attribute20_o => ghr_rei_shd.g_old_rec.rei_attribute20 ,
313: p_rei_information_category_o => ghr_rei_shd.g_old_rec.rei_information_category ,
314: p_rei_information1_o => ghr_rei_shd.g_old_rec.rei_information1 ,

Line 311: p_rei_attribute19_o => ghr_rei_shd.g_old_rec.rei_attribute19 ,

307: p_rei_attribute15_o => ghr_rei_shd.g_old_rec.rei_attribute15 ,
308: p_rei_attribute16_o => ghr_rei_shd.g_old_rec.rei_attribute16 ,
309: p_rei_attribute17_o => ghr_rei_shd.g_old_rec.rei_attribute17 ,
310: p_rei_attribute18_o => ghr_rei_shd.g_old_rec.rei_attribute18 ,
311: p_rei_attribute19_o => ghr_rei_shd.g_old_rec.rei_attribute19 ,
312: p_rei_attribute20_o => ghr_rei_shd.g_old_rec.rei_attribute20 ,
313: p_rei_information_category_o => ghr_rei_shd.g_old_rec.rei_information_category ,
314: p_rei_information1_o => ghr_rei_shd.g_old_rec.rei_information1 ,
315: p_rei_information2_o => ghr_rei_shd.g_old_rec.rei_information2 ,

Line 312: p_rei_attribute20_o => ghr_rei_shd.g_old_rec.rei_attribute20 ,

308: p_rei_attribute16_o => ghr_rei_shd.g_old_rec.rei_attribute16 ,
309: p_rei_attribute17_o => ghr_rei_shd.g_old_rec.rei_attribute17 ,
310: p_rei_attribute18_o => ghr_rei_shd.g_old_rec.rei_attribute18 ,
311: p_rei_attribute19_o => ghr_rei_shd.g_old_rec.rei_attribute19 ,
312: p_rei_attribute20_o => ghr_rei_shd.g_old_rec.rei_attribute20 ,
313: p_rei_information_category_o => ghr_rei_shd.g_old_rec.rei_information_category ,
314: p_rei_information1_o => ghr_rei_shd.g_old_rec.rei_information1 ,
315: p_rei_information2_o => ghr_rei_shd.g_old_rec.rei_information2 ,
316: p_rei_information3_o => ghr_rei_shd.g_old_rec.rei_information3 ,

Line 313: p_rei_information_category_o => ghr_rei_shd.g_old_rec.rei_information_category ,

309: p_rei_attribute17_o => ghr_rei_shd.g_old_rec.rei_attribute17 ,
310: p_rei_attribute18_o => ghr_rei_shd.g_old_rec.rei_attribute18 ,
311: p_rei_attribute19_o => ghr_rei_shd.g_old_rec.rei_attribute19 ,
312: p_rei_attribute20_o => ghr_rei_shd.g_old_rec.rei_attribute20 ,
313: p_rei_information_category_o => ghr_rei_shd.g_old_rec.rei_information_category ,
314: p_rei_information1_o => ghr_rei_shd.g_old_rec.rei_information1 ,
315: p_rei_information2_o => ghr_rei_shd.g_old_rec.rei_information2 ,
316: p_rei_information3_o => ghr_rei_shd.g_old_rec.rei_information3 ,
317: p_rei_information4_o => ghr_rei_shd.g_old_rec.rei_information4 ,

Line 314: p_rei_information1_o => ghr_rei_shd.g_old_rec.rei_information1 ,

310: p_rei_attribute18_o => ghr_rei_shd.g_old_rec.rei_attribute18 ,
311: p_rei_attribute19_o => ghr_rei_shd.g_old_rec.rei_attribute19 ,
312: p_rei_attribute20_o => ghr_rei_shd.g_old_rec.rei_attribute20 ,
313: p_rei_information_category_o => ghr_rei_shd.g_old_rec.rei_information_category ,
314: p_rei_information1_o => ghr_rei_shd.g_old_rec.rei_information1 ,
315: p_rei_information2_o => ghr_rei_shd.g_old_rec.rei_information2 ,
316: p_rei_information3_o => ghr_rei_shd.g_old_rec.rei_information3 ,
317: p_rei_information4_o => ghr_rei_shd.g_old_rec.rei_information4 ,
318: p_rei_information5_o => ghr_rei_shd.g_old_rec.rei_information5 ,

Line 315: p_rei_information2_o => ghr_rei_shd.g_old_rec.rei_information2 ,

311: p_rei_attribute19_o => ghr_rei_shd.g_old_rec.rei_attribute19 ,
312: p_rei_attribute20_o => ghr_rei_shd.g_old_rec.rei_attribute20 ,
313: p_rei_information_category_o => ghr_rei_shd.g_old_rec.rei_information_category ,
314: p_rei_information1_o => ghr_rei_shd.g_old_rec.rei_information1 ,
315: p_rei_information2_o => ghr_rei_shd.g_old_rec.rei_information2 ,
316: p_rei_information3_o => ghr_rei_shd.g_old_rec.rei_information3 ,
317: p_rei_information4_o => ghr_rei_shd.g_old_rec.rei_information4 ,
318: p_rei_information5_o => ghr_rei_shd.g_old_rec.rei_information5 ,
319: p_rei_information6_o => ghr_rei_shd.g_old_rec.rei_information6 ,

Line 316: p_rei_information3_o => ghr_rei_shd.g_old_rec.rei_information3 ,

312: p_rei_attribute20_o => ghr_rei_shd.g_old_rec.rei_attribute20 ,
313: p_rei_information_category_o => ghr_rei_shd.g_old_rec.rei_information_category ,
314: p_rei_information1_o => ghr_rei_shd.g_old_rec.rei_information1 ,
315: p_rei_information2_o => ghr_rei_shd.g_old_rec.rei_information2 ,
316: p_rei_information3_o => ghr_rei_shd.g_old_rec.rei_information3 ,
317: p_rei_information4_o => ghr_rei_shd.g_old_rec.rei_information4 ,
318: p_rei_information5_o => ghr_rei_shd.g_old_rec.rei_information5 ,
319: p_rei_information6_o => ghr_rei_shd.g_old_rec.rei_information6 ,
320: p_rei_information7_o => ghr_rei_shd.g_old_rec.rei_information7 ,

Line 317: p_rei_information4_o => ghr_rei_shd.g_old_rec.rei_information4 ,

313: p_rei_information_category_o => ghr_rei_shd.g_old_rec.rei_information_category ,
314: p_rei_information1_o => ghr_rei_shd.g_old_rec.rei_information1 ,
315: p_rei_information2_o => ghr_rei_shd.g_old_rec.rei_information2 ,
316: p_rei_information3_o => ghr_rei_shd.g_old_rec.rei_information3 ,
317: p_rei_information4_o => ghr_rei_shd.g_old_rec.rei_information4 ,
318: p_rei_information5_o => ghr_rei_shd.g_old_rec.rei_information5 ,
319: p_rei_information6_o => ghr_rei_shd.g_old_rec.rei_information6 ,
320: p_rei_information7_o => ghr_rei_shd.g_old_rec.rei_information7 ,
321: p_rei_information8_o => ghr_rei_shd.g_old_rec.rei_information8 ,

Line 318: p_rei_information5_o => ghr_rei_shd.g_old_rec.rei_information5 ,

314: p_rei_information1_o => ghr_rei_shd.g_old_rec.rei_information1 ,
315: p_rei_information2_o => ghr_rei_shd.g_old_rec.rei_information2 ,
316: p_rei_information3_o => ghr_rei_shd.g_old_rec.rei_information3 ,
317: p_rei_information4_o => ghr_rei_shd.g_old_rec.rei_information4 ,
318: p_rei_information5_o => ghr_rei_shd.g_old_rec.rei_information5 ,
319: p_rei_information6_o => ghr_rei_shd.g_old_rec.rei_information6 ,
320: p_rei_information7_o => ghr_rei_shd.g_old_rec.rei_information7 ,
321: p_rei_information8_o => ghr_rei_shd.g_old_rec.rei_information8 ,
322: p_rei_information9_o => ghr_rei_shd.g_old_rec.rei_information9 ,

Line 319: p_rei_information6_o => ghr_rei_shd.g_old_rec.rei_information6 ,

315: p_rei_information2_o => ghr_rei_shd.g_old_rec.rei_information2 ,
316: p_rei_information3_o => ghr_rei_shd.g_old_rec.rei_information3 ,
317: p_rei_information4_o => ghr_rei_shd.g_old_rec.rei_information4 ,
318: p_rei_information5_o => ghr_rei_shd.g_old_rec.rei_information5 ,
319: p_rei_information6_o => ghr_rei_shd.g_old_rec.rei_information6 ,
320: p_rei_information7_o => ghr_rei_shd.g_old_rec.rei_information7 ,
321: p_rei_information8_o => ghr_rei_shd.g_old_rec.rei_information8 ,
322: p_rei_information9_o => ghr_rei_shd.g_old_rec.rei_information9 ,
323: p_rei_information10_o => ghr_rei_shd.g_old_rec.rei_information10 ,

Line 320: p_rei_information7_o => ghr_rei_shd.g_old_rec.rei_information7 ,

316: p_rei_information3_o => ghr_rei_shd.g_old_rec.rei_information3 ,
317: p_rei_information4_o => ghr_rei_shd.g_old_rec.rei_information4 ,
318: p_rei_information5_o => ghr_rei_shd.g_old_rec.rei_information5 ,
319: p_rei_information6_o => ghr_rei_shd.g_old_rec.rei_information6 ,
320: p_rei_information7_o => ghr_rei_shd.g_old_rec.rei_information7 ,
321: p_rei_information8_o => ghr_rei_shd.g_old_rec.rei_information8 ,
322: p_rei_information9_o => ghr_rei_shd.g_old_rec.rei_information9 ,
323: p_rei_information10_o => ghr_rei_shd.g_old_rec.rei_information10 ,
324: p_rei_information11_o => ghr_rei_shd.g_old_rec.rei_information11 ,

Line 321: p_rei_information8_o => ghr_rei_shd.g_old_rec.rei_information8 ,

317: p_rei_information4_o => ghr_rei_shd.g_old_rec.rei_information4 ,
318: p_rei_information5_o => ghr_rei_shd.g_old_rec.rei_information5 ,
319: p_rei_information6_o => ghr_rei_shd.g_old_rec.rei_information6 ,
320: p_rei_information7_o => ghr_rei_shd.g_old_rec.rei_information7 ,
321: p_rei_information8_o => ghr_rei_shd.g_old_rec.rei_information8 ,
322: p_rei_information9_o => ghr_rei_shd.g_old_rec.rei_information9 ,
323: p_rei_information10_o => ghr_rei_shd.g_old_rec.rei_information10 ,
324: p_rei_information11_o => ghr_rei_shd.g_old_rec.rei_information11 ,
325: p_rei_information12_o => ghr_rei_shd.g_old_rec.rei_information12 ,

Line 322: p_rei_information9_o => ghr_rei_shd.g_old_rec.rei_information9 ,

318: p_rei_information5_o => ghr_rei_shd.g_old_rec.rei_information5 ,
319: p_rei_information6_o => ghr_rei_shd.g_old_rec.rei_information6 ,
320: p_rei_information7_o => ghr_rei_shd.g_old_rec.rei_information7 ,
321: p_rei_information8_o => ghr_rei_shd.g_old_rec.rei_information8 ,
322: p_rei_information9_o => ghr_rei_shd.g_old_rec.rei_information9 ,
323: p_rei_information10_o => ghr_rei_shd.g_old_rec.rei_information10 ,
324: p_rei_information11_o => ghr_rei_shd.g_old_rec.rei_information11 ,
325: p_rei_information12_o => ghr_rei_shd.g_old_rec.rei_information12 ,
326: p_rei_information13_o => ghr_rei_shd.g_old_rec.rei_information13 ,

Line 323: p_rei_information10_o => ghr_rei_shd.g_old_rec.rei_information10 ,

319: p_rei_information6_o => ghr_rei_shd.g_old_rec.rei_information6 ,
320: p_rei_information7_o => ghr_rei_shd.g_old_rec.rei_information7 ,
321: p_rei_information8_o => ghr_rei_shd.g_old_rec.rei_information8 ,
322: p_rei_information9_o => ghr_rei_shd.g_old_rec.rei_information9 ,
323: p_rei_information10_o => ghr_rei_shd.g_old_rec.rei_information10 ,
324: p_rei_information11_o => ghr_rei_shd.g_old_rec.rei_information11 ,
325: p_rei_information12_o => ghr_rei_shd.g_old_rec.rei_information12 ,
326: p_rei_information13_o => ghr_rei_shd.g_old_rec.rei_information13 ,
327: p_rei_information14_o => ghr_rei_shd.g_old_rec.rei_information14 ,

Line 324: p_rei_information11_o => ghr_rei_shd.g_old_rec.rei_information11 ,

320: p_rei_information7_o => ghr_rei_shd.g_old_rec.rei_information7 ,
321: p_rei_information8_o => ghr_rei_shd.g_old_rec.rei_information8 ,
322: p_rei_information9_o => ghr_rei_shd.g_old_rec.rei_information9 ,
323: p_rei_information10_o => ghr_rei_shd.g_old_rec.rei_information10 ,
324: p_rei_information11_o => ghr_rei_shd.g_old_rec.rei_information11 ,
325: p_rei_information12_o => ghr_rei_shd.g_old_rec.rei_information12 ,
326: p_rei_information13_o => ghr_rei_shd.g_old_rec.rei_information13 ,
327: p_rei_information14_o => ghr_rei_shd.g_old_rec.rei_information14 ,
328: p_rei_information15_o => ghr_rei_shd.g_old_rec.rei_information15 ,

Line 325: p_rei_information12_o => ghr_rei_shd.g_old_rec.rei_information12 ,

321: p_rei_information8_o => ghr_rei_shd.g_old_rec.rei_information8 ,
322: p_rei_information9_o => ghr_rei_shd.g_old_rec.rei_information9 ,
323: p_rei_information10_o => ghr_rei_shd.g_old_rec.rei_information10 ,
324: p_rei_information11_o => ghr_rei_shd.g_old_rec.rei_information11 ,
325: p_rei_information12_o => ghr_rei_shd.g_old_rec.rei_information12 ,
326: p_rei_information13_o => ghr_rei_shd.g_old_rec.rei_information13 ,
327: p_rei_information14_o => ghr_rei_shd.g_old_rec.rei_information14 ,
328: p_rei_information15_o => ghr_rei_shd.g_old_rec.rei_information15 ,
329: p_rei_information16_o => ghr_rei_shd.g_old_rec.rei_information16 ,

Line 326: p_rei_information13_o => ghr_rei_shd.g_old_rec.rei_information13 ,

322: p_rei_information9_o => ghr_rei_shd.g_old_rec.rei_information9 ,
323: p_rei_information10_o => ghr_rei_shd.g_old_rec.rei_information10 ,
324: p_rei_information11_o => ghr_rei_shd.g_old_rec.rei_information11 ,
325: p_rei_information12_o => ghr_rei_shd.g_old_rec.rei_information12 ,
326: p_rei_information13_o => ghr_rei_shd.g_old_rec.rei_information13 ,
327: p_rei_information14_o => ghr_rei_shd.g_old_rec.rei_information14 ,
328: p_rei_information15_o => ghr_rei_shd.g_old_rec.rei_information15 ,
329: p_rei_information16_o => ghr_rei_shd.g_old_rec.rei_information16 ,
330: p_rei_information17_o => ghr_rei_shd.g_old_rec.rei_information17 ,

Line 327: p_rei_information14_o => ghr_rei_shd.g_old_rec.rei_information14 ,

323: p_rei_information10_o => ghr_rei_shd.g_old_rec.rei_information10 ,
324: p_rei_information11_o => ghr_rei_shd.g_old_rec.rei_information11 ,
325: p_rei_information12_o => ghr_rei_shd.g_old_rec.rei_information12 ,
326: p_rei_information13_o => ghr_rei_shd.g_old_rec.rei_information13 ,
327: p_rei_information14_o => ghr_rei_shd.g_old_rec.rei_information14 ,
328: p_rei_information15_o => ghr_rei_shd.g_old_rec.rei_information15 ,
329: p_rei_information16_o => ghr_rei_shd.g_old_rec.rei_information16 ,
330: p_rei_information17_o => ghr_rei_shd.g_old_rec.rei_information17 ,
331: p_rei_information18_o => ghr_rei_shd.g_old_rec.rei_information18 ,

Line 328: p_rei_information15_o => ghr_rei_shd.g_old_rec.rei_information15 ,

324: p_rei_information11_o => ghr_rei_shd.g_old_rec.rei_information11 ,
325: p_rei_information12_o => ghr_rei_shd.g_old_rec.rei_information12 ,
326: p_rei_information13_o => ghr_rei_shd.g_old_rec.rei_information13 ,
327: p_rei_information14_o => ghr_rei_shd.g_old_rec.rei_information14 ,
328: p_rei_information15_o => ghr_rei_shd.g_old_rec.rei_information15 ,
329: p_rei_information16_o => ghr_rei_shd.g_old_rec.rei_information16 ,
330: p_rei_information17_o => ghr_rei_shd.g_old_rec.rei_information17 ,
331: p_rei_information18_o => ghr_rei_shd.g_old_rec.rei_information18 ,
332: p_rei_information19_o => ghr_rei_shd.g_old_rec.rei_information19 ,

Line 329: p_rei_information16_o => ghr_rei_shd.g_old_rec.rei_information16 ,

325: p_rei_information12_o => ghr_rei_shd.g_old_rec.rei_information12 ,
326: p_rei_information13_o => ghr_rei_shd.g_old_rec.rei_information13 ,
327: p_rei_information14_o => ghr_rei_shd.g_old_rec.rei_information14 ,
328: p_rei_information15_o => ghr_rei_shd.g_old_rec.rei_information15 ,
329: p_rei_information16_o => ghr_rei_shd.g_old_rec.rei_information16 ,
330: p_rei_information17_o => ghr_rei_shd.g_old_rec.rei_information17 ,
331: p_rei_information18_o => ghr_rei_shd.g_old_rec.rei_information18 ,
332: p_rei_information19_o => ghr_rei_shd.g_old_rec.rei_information19 ,
333: p_rei_information20_o => ghr_rei_shd.g_old_rec.rei_information20 ,

Line 330: p_rei_information17_o => ghr_rei_shd.g_old_rec.rei_information17 ,

326: p_rei_information13_o => ghr_rei_shd.g_old_rec.rei_information13 ,
327: p_rei_information14_o => ghr_rei_shd.g_old_rec.rei_information14 ,
328: p_rei_information15_o => ghr_rei_shd.g_old_rec.rei_information15 ,
329: p_rei_information16_o => ghr_rei_shd.g_old_rec.rei_information16 ,
330: p_rei_information17_o => ghr_rei_shd.g_old_rec.rei_information17 ,
331: p_rei_information18_o => ghr_rei_shd.g_old_rec.rei_information18 ,
332: p_rei_information19_o => ghr_rei_shd.g_old_rec.rei_information19 ,
333: p_rei_information20_o => ghr_rei_shd.g_old_rec.rei_information20 ,
334: p_rei_information21_o => ghr_rei_shd.g_old_rec.rei_information21 ,

Line 331: p_rei_information18_o => ghr_rei_shd.g_old_rec.rei_information18 ,

327: p_rei_information14_o => ghr_rei_shd.g_old_rec.rei_information14 ,
328: p_rei_information15_o => ghr_rei_shd.g_old_rec.rei_information15 ,
329: p_rei_information16_o => ghr_rei_shd.g_old_rec.rei_information16 ,
330: p_rei_information17_o => ghr_rei_shd.g_old_rec.rei_information17 ,
331: p_rei_information18_o => ghr_rei_shd.g_old_rec.rei_information18 ,
332: p_rei_information19_o => ghr_rei_shd.g_old_rec.rei_information19 ,
333: p_rei_information20_o => ghr_rei_shd.g_old_rec.rei_information20 ,
334: p_rei_information21_o => ghr_rei_shd.g_old_rec.rei_information21 ,
335: p_rei_information22_o => ghr_rei_shd.g_old_rec.rei_information22 ,

Line 332: p_rei_information19_o => ghr_rei_shd.g_old_rec.rei_information19 ,

328: p_rei_information15_o => ghr_rei_shd.g_old_rec.rei_information15 ,
329: p_rei_information16_o => ghr_rei_shd.g_old_rec.rei_information16 ,
330: p_rei_information17_o => ghr_rei_shd.g_old_rec.rei_information17 ,
331: p_rei_information18_o => ghr_rei_shd.g_old_rec.rei_information18 ,
332: p_rei_information19_o => ghr_rei_shd.g_old_rec.rei_information19 ,
333: p_rei_information20_o => ghr_rei_shd.g_old_rec.rei_information20 ,
334: p_rei_information21_o => ghr_rei_shd.g_old_rec.rei_information21 ,
335: p_rei_information22_o => ghr_rei_shd.g_old_rec.rei_information22 ,
336: p_rei_information28_o => ghr_rei_shd.g_old_rec.rei_information28 ,

Line 333: p_rei_information20_o => ghr_rei_shd.g_old_rec.rei_information20 ,

329: p_rei_information16_o => ghr_rei_shd.g_old_rec.rei_information16 ,
330: p_rei_information17_o => ghr_rei_shd.g_old_rec.rei_information17 ,
331: p_rei_information18_o => ghr_rei_shd.g_old_rec.rei_information18 ,
332: p_rei_information19_o => ghr_rei_shd.g_old_rec.rei_information19 ,
333: p_rei_information20_o => ghr_rei_shd.g_old_rec.rei_information20 ,
334: p_rei_information21_o => ghr_rei_shd.g_old_rec.rei_information21 ,
335: p_rei_information22_o => ghr_rei_shd.g_old_rec.rei_information22 ,
336: p_rei_information28_o => ghr_rei_shd.g_old_rec.rei_information28 ,
337: p_rei_information29_o => ghr_rei_shd.g_old_rec.rei_information29 ,

Line 334: p_rei_information21_o => ghr_rei_shd.g_old_rec.rei_information21 ,

330: p_rei_information17_o => ghr_rei_shd.g_old_rec.rei_information17 ,
331: p_rei_information18_o => ghr_rei_shd.g_old_rec.rei_information18 ,
332: p_rei_information19_o => ghr_rei_shd.g_old_rec.rei_information19 ,
333: p_rei_information20_o => ghr_rei_shd.g_old_rec.rei_information20 ,
334: p_rei_information21_o => ghr_rei_shd.g_old_rec.rei_information21 ,
335: p_rei_information22_o => ghr_rei_shd.g_old_rec.rei_information22 ,
336: p_rei_information28_o => ghr_rei_shd.g_old_rec.rei_information28 ,
337: p_rei_information29_o => ghr_rei_shd.g_old_rec.rei_information29 ,
338: p_rei_information23_o => ghr_rei_shd.g_old_rec.rei_information23 ,

Line 335: p_rei_information22_o => ghr_rei_shd.g_old_rec.rei_information22 ,

331: p_rei_information18_o => ghr_rei_shd.g_old_rec.rei_information18 ,
332: p_rei_information19_o => ghr_rei_shd.g_old_rec.rei_information19 ,
333: p_rei_information20_o => ghr_rei_shd.g_old_rec.rei_information20 ,
334: p_rei_information21_o => ghr_rei_shd.g_old_rec.rei_information21 ,
335: p_rei_information22_o => ghr_rei_shd.g_old_rec.rei_information22 ,
336: p_rei_information28_o => ghr_rei_shd.g_old_rec.rei_information28 ,
337: p_rei_information29_o => ghr_rei_shd.g_old_rec.rei_information29 ,
338: p_rei_information23_o => ghr_rei_shd.g_old_rec.rei_information23 ,
339: p_rei_information24_o => ghr_rei_shd.g_old_rec.rei_information24 ,

Line 336: p_rei_information28_o => ghr_rei_shd.g_old_rec.rei_information28 ,

332: p_rei_information19_o => ghr_rei_shd.g_old_rec.rei_information19 ,
333: p_rei_information20_o => ghr_rei_shd.g_old_rec.rei_information20 ,
334: p_rei_information21_o => ghr_rei_shd.g_old_rec.rei_information21 ,
335: p_rei_information22_o => ghr_rei_shd.g_old_rec.rei_information22 ,
336: p_rei_information28_o => ghr_rei_shd.g_old_rec.rei_information28 ,
337: p_rei_information29_o => ghr_rei_shd.g_old_rec.rei_information29 ,
338: p_rei_information23_o => ghr_rei_shd.g_old_rec.rei_information23 ,
339: p_rei_information24_o => ghr_rei_shd.g_old_rec.rei_information24 ,
340: p_rei_information25_o => ghr_rei_shd.g_old_rec.rei_information25 ,

Line 337: p_rei_information29_o => ghr_rei_shd.g_old_rec.rei_information29 ,

333: p_rei_information20_o => ghr_rei_shd.g_old_rec.rei_information20 ,
334: p_rei_information21_o => ghr_rei_shd.g_old_rec.rei_information21 ,
335: p_rei_information22_o => ghr_rei_shd.g_old_rec.rei_information22 ,
336: p_rei_information28_o => ghr_rei_shd.g_old_rec.rei_information28 ,
337: p_rei_information29_o => ghr_rei_shd.g_old_rec.rei_information29 ,
338: p_rei_information23_o => ghr_rei_shd.g_old_rec.rei_information23 ,
339: p_rei_information24_o => ghr_rei_shd.g_old_rec.rei_information24 ,
340: p_rei_information25_o => ghr_rei_shd.g_old_rec.rei_information25 ,
341: p_rei_information26_o => ghr_rei_shd.g_old_rec.rei_information26 ,

Line 338: p_rei_information23_o => ghr_rei_shd.g_old_rec.rei_information23 ,

334: p_rei_information21_o => ghr_rei_shd.g_old_rec.rei_information21 ,
335: p_rei_information22_o => ghr_rei_shd.g_old_rec.rei_information22 ,
336: p_rei_information28_o => ghr_rei_shd.g_old_rec.rei_information28 ,
337: p_rei_information29_o => ghr_rei_shd.g_old_rec.rei_information29 ,
338: p_rei_information23_o => ghr_rei_shd.g_old_rec.rei_information23 ,
339: p_rei_information24_o => ghr_rei_shd.g_old_rec.rei_information24 ,
340: p_rei_information25_o => ghr_rei_shd.g_old_rec.rei_information25 ,
341: p_rei_information26_o => ghr_rei_shd.g_old_rec.rei_information26 ,
342: p_rei_information27_o => ghr_rei_shd.g_old_rec.rei_information27 ,

Line 339: p_rei_information24_o => ghr_rei_shd.g_old_rec.rei_information24 ,

335: p_rei_information22_o => ghr_rei_shd.g_old_rec.rei_information22 ,
336: p_rei_information28_o => ghr_rei_shd.g_old_rec.rei_information28 ,
337: p_rei_information29_o => ghr_rei_shd.g_old_rec.rei_information29 ,
338: p_rei_information23_o => ghr_rei_shd.g_old_rec.rei_information23 ,
339: p_rei_information24_o => ghr_rei_shd.g_old_rec.rei_information24 ,
340: p_rei_information25_o => ghr_rei_shd.g_old_rec.rei_information25 ,
341: p_rei_information26_o => ghr_rei_shd.g_old_rec.rei_information26 ,
342: p_rei_information27_o => ghr_rei_shd.g_old_rec.rei_information27 ,
343: p_rei_information30_o => ghr_rei_shd.g_old_rec.rei_information30 ,

Line 340: p_rei_information25_o => ghr_rei_shd.g_old_rec.rei_information25 ,

336: p_rei_information28_o => ghr_rei_shd.g_old_rec.rei_information28 ,
337: p_rei_information29_o => ghr_rei_shd.g_old_rec.rei_information29 ,
338: p_rei_information23_o => ghr_rei_shd.g_old_rec.rei_information23 ,
339: p_rei_information24_o => ghr_rei_shd.g_old_rec.rei_information24 ,
340: p_rei_information25_o => ghr_rei_shd.g_old_rec.rei_information25 ,
341: p_rei_information26_o => ghr_rei_shd.g_old_rec.rei_information26 ,
342: p_rei_information27_o => ghr_rei_shd.g_old_rec.rei_information27 ,
343: p_rei_information30_o => ghr_rei_shd.g_old_rec.rei_information30 ,
344: p_request_id_o => ghr_rei_shd.g_old_rec.request_id ,

Line 341: p_rei_information26_o => ghr_rei_shd.g_old_rec.rei_information26 ,

337: p_rei_information29_o => ghr_rei_shd.g_old_rec.rei_information29 ,
338: p_rei_information23_o => ghr_rei_shd.g_old_rec.rei_information23 ,
339: p_rei_information24_o => ghr_rei_shd.g_old_rec.rei_information24 ,
340: p_rei_information25_o => ghr_rei_shd.g_old_rec.rei_information25 ,
341: p_rei_information26_o => ghr_rei_shd.g_old_rec.rei_information26 ,
342: p_rei_information27_o => ghr_rei_shd.g_old_rec.rei_information27 ,
343: p_rei_information30_o => ghr_rei_shd.g_old_rec.rei_information30 ,
344: p_request_id_o => ghr_rei_shd.g_old_rec.request_id ,
345: p_program_application_id_o => ghr_rei_shd.g_old_rec.program_application_id ,

Line 342: p_rei_information27_o => ghr_rei_shd.g_old_rec.rei_information27 ,

338: p_rei_information23_o => ghr_rei_shd.g_old_rec.rei_information23 ,
339: p_rei_information24_o => ghr_rei_shd.g_old_rec.rei_information24 ,
340: p_rei_information25_o => ghr_rei_shd.g_old_rec.rei_information25 ,
341: p_rei_information26_o => ghr_rei_shd.g_old_rec.rei_information26 ,
342: p_rei_information27_o => ghr_rei_shd.g_old_rec.rei_information27 ,
343: p_rei_information30_o => ghr_rei_shd.g_old_rec.rei_information30 ,
344: p_request_id_o => ghr_rei_shd.g_old_rec.request_id ,
345: p_program_application_id_o => ghr_rei_shd.g_old_rec.program_application_id ,
346: p_program_id_o => ghr_rei_shd.g_old_rec.program_id ,

Line 343: p_rei_information30_o => ghr_rei_shd.g_old_rec.rei_information30 ,

339: p_rei_information24_o => ghr_rei_shd.g_old_rec.rei_information24 ,
340: p_rei_information25_o => ghr_rei_shd.g_old_rec.rei_information25 ,
341: p_rei_information26_o => ghr_rei_shd.g_old_rec.rei_information26 ,
342: p_rei_information27_o => ghr_rei_shd.g_old_rec.rei_information27 ,
343: p_rei_information30_o => ghr_rei_shd.g_old_rec.rei_information30 ,
344: p_request_id_o => ghr_rei_shd.g_old_rec.request_id ,
345: p_program_application_id_o => ghr_rei_shd.g_old_rec.program_application_id ,
346: p_program_id_o => ghr_rei_shd.g_old_rec.program_id ,
347: p_program_update_date_o => ghr_rei_shd.g_old_rec.program_update_date

Line 344: p_request_id_o => ghr_rei_shd.g_old_rec.request_id ,

340: p_rei_information25_o => ghr_rei_shd.g_old_rec.rei_information25 ,
341: p_rei_information26_o => ghr_rei_shd.g_old_rec.rei_information26 ,
342: p_rei_information27_o => ghr_rei_shd.g_old_rec.rei_information27 ,
343: p_rei_information30_o => ghr_rei_shd.g_old_rec.rei_information30 ,
344: p_request_id_o => ghr_rei_shd.g_old_rec.request_id ,
345: p_program_application_id_o => ghr_rei_shd.g_old_rec.program_application_id ,
346: p_program_id_o => ghr_rei_shd.g_old_rec.program_id ,
347: p_program_update_date_o => ghr_rei_shd.g_old_rec.program_update_date
348: );

Line 345: p_program_application_id_o => ghr_rei_shd.g_old_rec.program_application_id ,

341: p_rei_information26_o => ghr_rei_shd.g_old_rec.rei_information26 ,
342: p_rei_information27_o => ghr_rei_shd.g_old_rec.rei_information27 ,
343: p_rei_information30_o => ghr_rei_shd.g_old_rec.rei_information30 ,
344: p_request_id_o => ghr_rei_shd.g_old_rec.request_id ,
345: p_program_application_id_o => ghr_rei_shd.g_old_rec.program_application_id ,
346: p_program_id_o => ghr_rei_shd.g_old_rec.program_id ,
347: p_program_update_date_o => ghr_rei_shd.g_old_rec.program_update_date
348: );
349: exception

Line 346: p_program_id_o => ghr_rei_shd.g_old_rec.program_id ,

342: p_rei_information27_o => ghr_rei_shd.g_old_rec.rei_information27 ,
343: p_rei_information30_o => ghr_rei_shd.g_old_rec.rei_information30 ,
344: p_request_id_o => ghr_rei_shd.g_old_rec.request_id ,
345: p_program_application_id_o => ghr_rei_shd.g_old_rec.program_application_id ,
346: p_program_id_o => ghr_rei_shd.g_old_rec.program_id ,
347: p_program_update_date_o => ghr_rei_shd.g_old_rec.program_update_date
348: );
349: exception
350: when hr_api.cannot_find_prog_unit then

Line 347: p_program_update_date_o => ghr_rei_shd.g_old_rec.program_update_date

343: p_rei_information30_o => ghr_rei_shd.g_old_rec.rei_information30 ,
344: p_request_id_o => ghr_rei_shd.g_old_rec.request_id ,
345: p_program_application_id_o => ghr_rei_shd.g_old_rec.program_application_id ,
346: p_program_id_o => ghr_rei_shd.g_old_rec.program_id ,
347: p_program_update_date_o => ghr_rei_shd.g_old_rec.program_update_date
348: );
349: exception
350: when hr_api.cannot_find_prog_unit then
351: hr_api.cannot_find_prog_unit_error

Line 404: Procedure convert_defs(p_rec in out nocopy ghr_rei_shd.g_rec_type) is

400: -- Internal Table Handler Use Only.
401: --
402: -- {End Of Comments}
403: -- ----------------------------------------------------------------------------
404: Procedure convert_defs(p_rec in out nocopy ghr_rei_shd.g_rec_type) is
405: --
406: l_proc varchar2(72) := g_package||'convert_defs';
407: --
408: Begin

Line 419: ghr_rei_shd.g_old_rec.pa_request_id;

415: -- is being used then we must set to the 'current' argument value.
416: --
417: If (p_rec.pa_request_id = hr_api.g_number) then
418: p_rec.pa_request_id :=
419: ghr_rei_shd.g_old_rec.pa_request_id;
420: End If;
421: If (p_rec.information_type = hr_api.g_varchar2) then
422: p_rec.information_type :=
423: ghr_rei_shd.g_old_rec.information_type;

Line 423: ghr_rei_shd.g_old_rec.information_type;

419: ghr_rei_shd.g_old_rec.pa_request_id;
420: End If;
421: If (p_rec.information_type = hr_api.g_varchar2) then
422: p_rec.information_type :=
423: ghr_rei_shd.g_old_rec.information_type;
424: End If;
425: If (p_rec.rei_attribute_category = hr_api.g_varchar2) then
426: p_rec.rei_attribute_category :=
427: ghr_rei_shd.g_old_rec.rei_attribute_category;

Line 427: ghr_rei_shd.g_old_rec.rei_attribute_category;

423: ghr_rei_shd.g_old_rec.information_type;
424: End If;
425: If (p_rec.rei_attribute_category = hr_api.g_varchar2) then
426: p_rec.rei_attribute_category :=
427: ghr_rei_shd.g_old_rec.rei_attribute_category;
428: End If;
429: If (p_rec.rei_attribute1 = hr_api.g_varchar2) then
430: p_rec.rei_attribute1 :=
431: ghr_rei_shd.g_old_rec.rei_attribute1;

Line 431: ghr_rei_shd.g_old_rec.rei_attribute1;

427: ghr_rei_shd.g_old_rec.rei_attribute_category;
428: End If;
429: If (p_rec.rei_attribute1 = hr_api.g_varchar2) then
430: p_rec.rei_attribute1 :=
431: ghr_rei_shd.g_old_rec.rei_attribute1;
432: End If;
433: If (p_rec.rei_attribute2 = hr_api.g_varchar2) then
434: p_rec.rei_attribute2 :=
435: ghr_rei_shd.g_old_rec.rei_attribute2;

Line 435: ghr_rei_shd.g_old_rec.rei_attribute2;

431: ghr_rei_shd.g_old_rec.rei_attribute1;
432: End If;
433: If (p_rec.rei_attribute2 = hr_api.g_varchar2) then
434: p_rec.rei_attribute2 :=
435: ghr_rei_shd.g_old_rec.rei_attribute2;
436: End If;
437: If (p_rec.rei_attribute3 = hr_api.g_varchar2) then
438: p_rec.rei_attribute3 :=
439: ghr_rei_shd.g_old_rec.rei_attribute3;

Line 439: ghr_rei_shd.g_old_rec.rei_attribute3;

435: ghr_rei_shd.g_old_rec.rei_attribute2;
436: End If;
437: If (p_rec.rei_attribute3 = hr_api.g_varchar2) then
438: p_rec.rei_attribute3 :=
439: ghr_rei_shd.g_old_rec.rei_attribute3;
440: End If;
441: If (p_rec.rei_attribute4 = hr_api.g_varchar2) then
442: p_rec.rei_attribute4 :=
443: ghr_rei_shd.g_old_rec.rei_attribute4;

Line 443: ghr_rei_shd.g_old_rec.rei_attribute4;

439: ghr_rei_shd.g_old_rec.rei_attribute3;
440: End If;
441: If (p_rec.rei_attribute4 = hr_api.g_varchar2) then
442: p_rec.rei_attribute4 :=
443: ghr_rei_shd.g_old_rec.rei_attribute4;
444: End If;
445: If (p_rec.rei_attribute5 = hr_api.g_varchar2) then
446: p_rec.rei_attribute5 :=
447: ghr_rei_shd.g_old_rec.rei_attribute5;

Line 447: ghr_rei_shd.g_old_rec.rei_attribute5;

443: ghr_rei_shd.g_old_rec.rei_attribute4;
444: End If;
445: If (p_rec.rei_attribute5 = hr_api.g_varchar2) then
446: p_rec.rei_attribute5 :=
447: ghr_rei_shd.g_old_rec.rei_attribute5;
448: End If;
449: If (p_rec.rei_attribute6 = hr_api.g_varchar2) then
450: p_rec.rei_attribute6 :=
451: ghr_rei_shd.g_old_rec.rei_attribute6;

Line 451: ghr_rei_shd.g_old_rec.rei_attribute6;

447: ghr_rei_shd.g_old_rec.rei_attribute5;
448: End If;
449: If (p_rec.rei_attribute6 = hr_api.g_varchar2) then
450: p_rec.rei_attribute6 :=
451: ghr_rei_shd.g_old_rec.rei_attribute6;
452: End If;
453: If (p_rec.rei_attribute7 = hr_api.g_varchar2) then
454: p_rec.rei_attribute7 :=
455: ghr_rei_shd.g_old_rec.rei_attribute7;

Line 455: ghr_rei_shd.g_old_rec.rei_attribute7;

451: ghr_rei_shd.g_old_rec.rei_attribute6;
452: End If;
453: If (p_rec.rei_attribute7 = hr_api.g_varchar2) then
454: p_rec.rei_attribute7 :=
455: ghr_rei_shd.g_old_rec.rei_attribute7;
456: End If;
457: If (p_rec.rei_attribute8 = hr_api.g_varchar2) then
458: p_rec.rei_attribute8 :=
459: ghr_rei_shd.g_old_rec.rei_attribute8;

Line 459: ghr_rei_shd.g_old_rec.rei_attribute8;

455: ghr_rei_shd.g_old_rec.rei_attribute7;
456: End If;
457: If (p_rec.rei_attribute8 = hr_api.g_varchar2) then
458: p_rec.rei_attribute8 :=
459: ghr_rei_shd.g_old_rec.rei_attribute8;
460: End If;
461: If (p_rec.rei_attribute9 = hr_api.g_varchar2) then
462: p_rec.rei_attribute9 :=
463: ghr_rei_shd.g_old_rec.rei_attribute9;

Line 463: ghr_rei_shd.g_old_rec.rei_attribute9;

459: ghr_rei_shd.g_old_rec.rei_attribute8;
460: End If;
461: If (p_rec.rei_attribute9 = hr_api.g_varchar2) then
462: p_rec.rei_attribute9 :=
463: ghr_rei_shd.g_old_rec.rei_attribute9;
464: End If;
465: If (p_rec.rei_attribute10 = hr_api.g_varchar2) then
466: p_rec.rei_attribute10 :=
467: ghr_rei_shd.g_old_rec.rei_attribute10;

Line 467: ghr_rei_shd.g_old_rec.rei_attribute10;

463: ghr_rei_shd.g_old_rec.rei_attribute9;
464: End If;
465: If (p_rec.rei_attribute10 = hr_api.g_varchar2) then
466: p_rec.rei_attribute10 :=
467: ghr_rei_shd.g_old_rec.rei_attribute10;
468: End If;
469: If (p_rec.rei_attribute11 = hr_api.g_varchar2) then
470: p_rec.rei_attribute11 :=
471: ghr_rei_shd.g_old_rec.rei_attribute11;

Line 471: ghr_rei_shd.g_old_rec.rei_attribute11;

467: ghr_rei_shd.g_old_rec.rei_attribute10;
468: End If;
469: If (p_rec.rei_attribute11 = hr_api.g_varchar2) then
470: p_rec.rei_attribute11 :=
471: ghr_rei_shd.g_old_rec.rei_attribute11;
472: End If;
473: If (p_rec.rei_attribute12 = hr_api.g_varchar2) then
474: p_rec.rei_attribute12 :=
475: ghr_rei_shd.g_old_rec.rei_attribute12;

Line 475: ghr_rei_shd.g_old_rec.rei_attribute12;

471: ghr_rei_shd.g_old_rec.rei_attribute11;
472: End If;
473: If (p_rec.rei_attribute12 = hr_api.g_varchar2) then
474: p_rec.rei_attribute12 :=
475: ghr_rei_shd.g_old_rec.rei_attribute12;
476: End If;
477: If (p_rec.rei_attribute13 = hr_api.g_varchar2) then
478: p_rec.rei_attribute13 :=
479: ghr_rei_shd.g_old_rec.rei_attribute13;

Line 479: ghr_rei_shd.g_old_rec.rei_attribute13;

475: ghr_rei_shd.g_old_rec.rei_attribute12;
476: End If;
477: If (p_rec.rei_attribute13 = hr_api.g_varchar2) then
478: p_rec.rei_attribute13 :=
479: ghr_rei_shd.g_old_rec.rei_attribute13;
480: End If;
481: If (p_rec.rei_attribute14 = hr_api.g_varchar2) then
482: p_rec.rei_attribute14 :=
483: ghr_rei_shd.g_old_rec.rei_attribute14;

Line 483: ghr_rei_shd.g_old_rec.rei_attribute14;

479: ghr_rei_shd.g_old_rec.rei_attribute13;
480: End If;
481: If (p_rec.rei_attribute14 = hr_api.g_varchar2) then
482: p_rec.rei_attribute14 :=
483: ghr_rei_shd.g_old_rec.rei_attribute14;
484: End If;
485: If (p_rec.rei_attribute15 = hr_api.g_varchar2) then
486: p_rec.rei_attribute15 :=
487: ghr_rei_shd.g_old_rec.rei_attribute15;

Line 487: ghr_rei_shd.g_old_rec.rei_attribute15;

483: ghr_rei_shd.g_old_rec.rei_attribute14;
484: End If;
485: If (p_rec.rei_attribute15 = hr_api.g_varchar2) then
486: p_rec.rei_attribute15 :=
487: ghr_rei_shd.g_old_rec.rei_attribute15;
488: End If;
489: If (p_rec.rei_attribute16 = hr_api.g_varchar2) then
490: p_rec.rei_attribute16 :=
491: ghr_rei_shd.g_old_rec.rei_attribute16;

Line 491: ghr_rei_shd.g_old_rec.rei_attribute16;

487: ghr_rei_shd.g_old_rec.rei_attribute15;
488: End If;
489: If (p_rec.rei_attribute16 = hr_api.g_varchar2) then
490: p_rec.rei_attribute16 :=
491: ghr_rei_shd.g_old_rec.rei_attribute16;
492: End If;
493: If (p_rec.rei_attribute17 = hr_api.g_varchar2) then
494: p_rec.rei_attribute17 :=
495: ghr_rei_shd.g_old_rec.rei_attribute17;

Line 495: ghr_rei_shd.g_old_rec.rei_attribute17;

491: ghr_rei_shd.g_old_rec.rei_attribute16;
492: End If;
493: If (p_rec.rei_attribute17 = hr_api.g_varchar2) then
494: p_rec.rei_attribute17 :=
495: ghr_rei_shd.g_old_rec.rei_attribute17;
496: End If;
497: If (p_rec.rei_attribute18 = hr_api.g_varchar2) then
498: p_rec.rei_attribute18 :=
499: ghr_rei_shd.g_old_rec.rei_attribute18;

Line 499: ghr_rei_shd.g_old_rec.rei_attribute18;

495: ghr_rei_shd.g_old_rec.rei_attribute17;
496: End If;
497: If (p_rec.rei_attribute18 = hr_api.g_varchar2) then
498: p_rec.rei_attribute18 :=
499: ghr_rei_shd.g_old_rec.rei_attribute18;
500: End If;
501: If (p_rec.rei_attribute19 = hr_api.g_varchar2) then
502: p_rec.rei_attribute19 :=
503: ghr_rei_shd.g_old_rec.rei_attribute19;

Line 503: ghr_rei_shd.g_old_rec.rei_attribute19;

499: ghr_rei_shd.g_old_rec.rei_attribute18;
500: End If;
501: If (p_rec.rei_attribute19 = hr_api.g_varchar2) then
502: p_rec.rei_attribute19 :=
503: ghr_rei_shd.g_old_rec.rei_attribute19;
504: End If;
505: If (p_rec.rei_attribute20 = hr_api.g_varchar2) then
506: p_rec.rei_attribute20 :=
507: ghr_rei_shd.g_old_rec.rei_attribute20;

Line 507: ghr_rei_shd.g_old_rec.rei_attribute20;

503: ghr_rei_shd.g_old_rec.rei_attribute19;
504: End If;
505: If (p_rec.rei_attribute20 = hr_api.g_varchar2) then
506: p_rec.rei_attribute20 :=
507: ghr_rei_shd.g_old_rec.rei_attribute20;
508: End If;
509: If (p_rec.rei_information_category = hr_api.g_varchar2) then
510: p_rec.rei_information_category :=
511: ghr_rei_shd.g_old_rec.rei_information_category;

Line 511: ghr_rei_shd.g_old_rec.rei_information_category;

507: ghr_rei_shd.g_old_rec.rei_attribute20;
508: End If;
509: If (p_rec.rei_information_category = hr_api.g_varchar2) then
510: p_rec.rei_information_category :=
511: ghr_rei_shd.g_old_rec.rei_information_category;
512: End If;
513: If (p_rec.rei_information1 = hr_api.g_varchar2) then
514: p_rec.rei_information1 :=
515: ghr_rei_shd.g_old_rec.rei_information1;

Line 515: ghr_rei_shd.g_old_rec.rei_information1;

511: ghr_rei_shd.g_old_rec.rei_information_category;
512: End If;
513: If (p_rec.rei_information1 = hr_api.g_varchar2) then
514: p_rec.rei_information1 :=
515: ghr_rei_shd.g_old_rec.rei_information1;
516: End If;
517: If (p_rec.rei_information2 = hr_api.g_varchar2) then
518: p_rec.rei_information2 :=
519: ghr_rei_shd.g_old_rec.rei_information2;

Line 519: ghr_rei_shd.g_old_rec.rei_information2;

515: ghr_rei_shd.g_old_rec.rei_information1;
516: End If;
517: If (p_rec.rei_information2 = hr_api.g_varchar2) then
518: p_rec.rei_information2 :=
519: ghr_rei_shd.g_old_rec.rei_information2;
520: End If;
521: If (p_rec.rei_information3 = hr_api.g_varchar2) then
522: p_rec.rei_information3 :=
523: ghr_rei_shd.g_old_rec.rei_information3;

Line 523: ghr_rei_shd.g_old_rec.rei_information3;

519: ghr_rei_shd.g_old_rec.rei_information2;
520: End If;
521: If (p_rec.rei_information3 = hr_api.g_varchar2) then
522: p_rec.rei_information3 :=
523: ghr_rei_shd.g_old_rec.rei_information3;
524: End If;
525: If (p_rec.rei_information4 = hr_api.g_varchar2) then
526: p_rec.rei_information4 :=
527: ghr_rei_shd.g_old_rec.rei_information4;

Line 527: ghr_rei_shd.g_old_rec.rei_information4;

523: ghr_rei_shd.g_old_rec.rei_information3;
524: End If;
525: If (p_rec.rei_information4 = hr_api.g_varchar2) then
526: p_rec.rei_information4 :=
527: ghr_rei_shd.g_old_rec.rei_information4;
528: End If;
529: If (p_rec.rei_information5 = hr_api.g_varchar2) then
530: p_rec.rei_information5 :=
531: ghr_rei_shd.g_old_rec.rei_information5;

Line 531: ghr_rei_shd.g_old_rec.rei_information5;

527: ghr_rei_shd.g_old_rec.rei_information4;
528: End If;
529: If (p_rec.rei_information5 = hr_api.g_varchar2) then
530: p_rec.rei_information5 :=
531: ghr_rei_shd.g_old_rec.rei_information5;
532: End If;
533: If (p_rec.rei_information6 = hr_api.g_varchar2) then
534: p_rec.rei_information6 :=
535: ghr_rei_shd.g_old_rec.rei_information6;

Line 535: ghr_rei_shd.g_old_rec.rei_information6;

531: ghr_rei_shd.g_old_rec.rei_information5;
532: End If;
533: If (p_rec.rei_information6 = hr_api.g_varchar2) then
534: p_rec.rei_information6 :=
535: ghr_rei_shd.g_old_rec.rei_information6;
536: End If;
537: If (p_rec.rei_information7 = hr_api.g_varchar2) then
538: p_rec.rei_information7 :=
539: ghr_rei_shd.g_old_rec.rei_information7;

Line 539: ghr_rei_shd.g_old_rec.rei_information7;

535: ghr_rei_shd.g_old_rec.rei_information6;
536: End If;
537: If (p_rec.rei_information7 = hr_api.g_varchar2) then
538: p_rec.rei_information7 :=
539: ghr_rei_shd.g_old_rec.rei_information7;
540: End If;
541: If (p_rec.rei_information8 = hr_api.g_varchar2) then
542: p_rec.rei_information8 :=
543: ghr_rei_shd.g_old_rec.rei_information8;

Line 543: ghr_rei_shd.g_old_rec.rei_information8;

539: ghr_rei_shd.g_old_rec.rei_information7;
540: End If;
541: If (p_rec.rei_information8 = hr_api.g_varchar2) then
542: p_rec.rei_information8 :=
543: ghr_rei_shd.g_old_rec.rei_information8;
544: End If;
545: If (p_rec.rei_information9 = hr_api.g_varchar2) then
546: p_rec.rei_information9 :=
547: ghr_rei_shd.g_old_rec.rei_information9;

Line 547: ghr_rei_shd.g_old_rec.rei_information9;

543: ghr_rei_shd.g_old_rec.rei_information8;
544: End If;
545: If (p_rec.rei_information9 = hr_api.g_varchar2) then
546: p_rec.rei_information9 :=
547: ghr_rei_shd.g_old_rec.rei_information9;
548: End If;
549: If (p_rec.rei_information10 = hr_api.g_varchar2) then
550: p_rec.rei_information10 :=
551: ghr_rei_shd.g_old_rec.rei_information10;

Line 551: ghr_rei_shd.g_old_rec.rei_information10;

547: ghr_rei_shd.g_old_rec.rei_information9;
548: End If;
549: If (p_rec.rei_information10 = hr_api.g_varchar2) then
550: p_rec.rei_information10 :=
551: ghr_rei_shd.g_old_rec.rei_information10;
552: End If;
553: If (p_rec.rei_information11 = hr_api.g_varchar2) then
554: p_rec.rei_information11 :=
555: ghr_rei_shd.g_old_rec.rei_information11;

Line 555: ghr_rei_shd.g_old_rec.rei_information11;

551: ghr_rei_shd.g_old_rec.rei_information10;
552: End If;
553: If (p_rec.rei_information11 = hr_api.g_varchar2) then
554: p_rec.rei_information11 :=
555: ghr_rei_shd.g_old_rec.rei_information11;
556: End If;
557: If (p_rec.rei_information12 = hr_api.g_varchar2) then
558: p_rec.rei_information12 :=
559: ghr_rei_shd.g_old_rec.rei_information12;

Line 559: ghr_rei_shd.g_old_rec.rei_information12;

555: ghr_rei_shd.g_old_rec.rei_information11;
556: End If;
557: If (p_rec.rei_information12 = hr_api.g_varchar2) then
558: p_rec.rei_information12 :=
559: ghr_rei_shd.g_old_rec.rei_information12;
560: End If;
561: If (p_rec.rei_information13 = hr_api.g_varchar2) then
562: p_rec.rei_information13 :=
563: ghr_rei_shd.g_old_rec.rei_information13;

Line 563: ghr_rei_shd.g_old_rec.rei_information13;

559: ghr_rei_shd.g_old_rec.rei_information12;
560: End If;
561: If (p_rec.rei_information13 = hr_api.g_varchar2) then
562: p_rec.rei_information13 :=
563: ghr_rei_shd.g_old_rec.rei_information13;
564: End If;
565: If (p_rec.rei_information14 = hr_api.g_varchar2) then
566: p_rec.rei_information14 :=
567: ghr_rei_shd.g_old_rec.rei_information14;

Line 567: ghr_rei_shd.g_old_rec.rei_information14;

563: ghr_rei_shd.g_old_rec.rei_information13;
564: End If;
565: If (p_rec.rei_information14 = hr_api.g_varchar2) then
566: p_rec.rei_information14 :=
567: ghr_rei_shd.g_old_rec.rei_information14;
568: End If;
569: If (p_rec.rei_information15 = hr_api.g_varchar2) then
570: p_rec.rei_information15 :=
571: ghr_rei_shd.g_old_rec.rei_information15;

Line 571: ghr_rei_shd.g_old_rec.rei_information15;

567: ghr_rei_shd.g_old_rec.rei_information14;
568: End If;
569: If (p_rec.rei_information15 = hr_api.g_varchar2) then
570: p_rec.rei_information15 :=
571: ghr_rei_shd.g_old_rec.rei_information15;
572: End If;
573: If (p_rec.rei_information16 = hr_api.g_varchar2) then
574: p_rec.rei_information16 :=
575: ghr_rei_shd.g_old_rec.rei_information16;

Line 575: ghr_rei_shd.g_old_rec.rei_information16;

571: ghr_rei_shd.g_old_rec.rei_information15;
572: End If;
573: If (p_rec.rei_information16 = hr_api.g_varchar2) then
574: p_rec.rei_information16 :=
575: ghr_rei_shd.g_old_rec.rei_information16;
576: End If;
577: If (p_rec.rei_information17 = hr_api.g_varchar2) then
578: p_rec.rei_information17 :=
579: ghr_rei_shd.g_old_rec.rei_information17;

Line 579: ghr_rei_shd.g_old_rec.rei_information17;

575: ghr_rei_shd.g_old_rec.rei_information16;
576: End If;
577: If (p_rec.rei_information17 = hr_api.g_varchar2) then
578: p_rec.rei_information17 :=
579: ghr_rei_shd.g_old_rec.rei_information17;
580: End If;
581: If (p_rec.rei_information18 = hr_api.g_varchar2) then
582: p_rec.rei_information18 :=
583: ghr_rei_shd.g_old_rec.rei_information18;

Line 583: ghr_rei_shd.g_old_rec.rei_information18;

579: ghr_rei_shd.g_old_rec.rei_information17;
580: End If;
581: If (p_rec.rei_information18 = hr_api.g_varchar2) then
582: p_rec.rei_information18 :=
583: ghr_rei_shd.g_old_rec.rei_information18;
584: End If;
585: If (p_rec.rei_information19 = hr_api.g_varchar2) then
586: p_rec.rei_information19 :=
587: ghr_rei_shd.g_old_rec.rei_information19;

Line 587: ghr_rei_shd.g_old_rec.rei_information19;

583: ghr_rei_shd.g_old_rec.rei_information18;
584: End If;
585: If (p_rec.rei_information19 = hr_api.g_varchar2) then
586: p_rec.rei_information19 :=
587: ghr_rei_shd.g_old_rec.rei_information19;
588: End If;
589: If (p_rec.rei_information20 = hr_api.g_varchar2) then
590: p_rec.rei_information20 :=
591: ghr_rei_shd.g_old_rec.rei_information20;

Line 591: ghr_rei_shd.g_old_rec.rei_information20;

587: ghr_rei_shd.g_old_rec.rei_information19;
588: End If;
589: If (p_rec.rei_information20 = hr_api.g_varchar2) then
590: p_rec.rei_information20 :=
591: ghr_rei_shd.g_old_rec.rei_information20;
592: End If;
593: If (p_rec.rei_information21 = hr_api.g_varchar2) then
594: p_rec.rei_information21 :=
595: ghr_rei_shd.g_old_rec.rei_information21;

Line 595: ghr_rei_shd.g_old_rec.rei_information21;

591: ghr_rei_shd.g_old_rec.rei_information20;
592: End If;
593: If (p_rec.rei_information21 = hr_api.g_varchar2) then
594: p_rec.rei_information21 :=
595: ghr_rei_shd.g_old_rec.rei_information21;
596: End If;
597: If (p_rec.rei_information22 = hr_api.g_varchar2) then
598: p_rec.rei_information22 :=
599: ghr_rei_shd.g_old_rec.rei_information22;

Line 599: ghr_rei_shd.g_old_rec.rei_information22;

595: ghr_rei_shd.g_old_rec.rei_information21;
596: End If;
597: If (p_rec.rei_information22 = hr_api.g_varchar2) then
598: p_rec.rei_information22 :=
599: ghr_rei_shd.g_old_rec.rei_information22;
600: End If;
601: If (p_rec.rei_information28 = hr_api.g_varchar2) then
602: p_rec.rei_information28 :=
603: ghr_rei_shd.g_old_rec.rei_information28;

Line 603: ghr_rei_shd.g_old_rec.rei_information28;

599: ghr_rei_shd.g_old_rec.rei_information22;
600: End If;
601: If (p_rec.rei_information28 = hr_api.g_varchar2) then
602: p_rec.rei_information28 :=
603: ghr_rei_shd.g_old_rec.rei_information28;
604: End If;
605: If (p_rec.rei_information29 = hr_api.g_varchar2) then
606: p_rec.rei_information29 :=
607: ghr_rei_shd.g_old_rec.rei_information29;

Line 607: ghr_rei_shd.g_old_rec.rei_information29;

603: ghr_rei_shd.g_old_rec.rei_information28;
604: End If;
605: If (p_rec.rei_information29 = hr_api.g_varchar2) then
606: p_rec.rei_information29 :=
607: ghr_rei_shd.g_old_rec.rei_information29;
608: End If;
609: If (p_rec.rei_information23 = hr_api.g_varchar2) then
610: p_rec.rei_information23 :=
611: ghr_rei_shd.g_old_rec.rei_information23;

Line 611: ghr_rei_shd.g_old_rec.rei_information23;

607: ghr_rei_shd.g_old_rec.rei_information29;
608: End If;
609: If (p_rec.rei_information23 = hr_api.g_varchar2) then
610: p_rec.rei_information23 :=
611: ghr_rei_shd.g_old_rec.rei_information23;
612: End If;
613: If (p_rec.rei_information24 = hr_api.g_varchar2) then
614: p_rec.rei_information24 :=
615: ghr_rei_shd.g_old_rec.rei_information24;

Line 615: ghr_rei_shd.g_old_rec.rei_information24;

611: ghr_rei_shd.g_old_rec.rei_information23;
612: End If;
613: If (p_rec.rei_information24 = hr_api.g_varchar2) then
614: p_rec.rei_information24 :=
615: ghr_rei_shd.g_old_rec.rei_information24;
616: End If;
617: If (p_rec.rei_information25 = hr_api.g_varchar2) then
618: p_rec.rei_information25 :=
619: ghr_rei_shd.g_old_rec.rei_information25;

Line 619: ghr_rei_shd.g_old_rec.rei_information25;

615: ghr_rei_shd.g_old_rec.rei_information24;
616: End If;
617: If (p_rec.rei_information25 = hr_api.g_varchar2) then
618: p_rec.rei_information25 :=
619: ghr_rei_shd.g_old_rec.rei_information25;
620: End If;
621: If (p_rec.rei_information26 = hr_api.g_varchar2) then
622: p_rec.rei_information26 :=
623: ghr_rei_shd.g_old_rec.rei_information26;

Line 623: ghr_rei_shd.g_old_rec.rei_information26;

619: ghr_rei_shd.g_old_rec.rei_information25;
620: End If;
621: If (p_rec.rei_information26 = hr_api.g_varchar2) then
622: p_rec.rei_information26 :=
623: ghr_rei_shd.g_old_rec.rei_information26;
624: End If;
625: If (p_rec.rei_information27 = hr_api.g_varchar2) then
626: p_rec.rei_information27 :=
627: ghr_rei_shd.g_old_rec.rei_information27;

Line 627: ghr_rei_shd.g_old_rec.rei_information27;

623: ghr_rei_shd.g_old_rec.rei_information26;
624: End If;
625: If (p_rec.rei_information27 = hr_api.g_varchar2) then
626: p_rec.rei_information27 :=
627: ghr_rei_shd.g_old_rec.rei_information27;
628: End If;
629: If (p_rec.rei_information30 = hr_api.g_varchar2) then
630: p_rec.rei_information30 :=
631: ghr_rei_shd.g_old_rec.rei_information30;

Line 631: ghr_rei_shd.g_old_rec.rei_information30;

627: ghr_rei_shd.g_old_rec.rei_information27;
628: End If;
629: If (p_rec.rei_information30 = hr_api.g_varchar2) then
630: p_rec.rei_information30 :=
631: ghr_rei_shd.g_old_rec.rei_information30;
632: End If;
633: If (p_rec.request_id = hr_api.g_number) then
634: p_rec.request_id :=
635: ghr_rei_shd.g_old_rec.request_id;

Line 635: ghr_rei_shd.g_old_rec.request_id;

631: ghr_rei_shd.g_old_rec.rei_information30;
632: End If;
633: If (p_rec.request_id = hr_api.g_number) then
634: p_rec.request_id :=
635: ghr_rei_shd.g_old_rec.request_id;
636: End If;
637: If (p_rec.program_application_id = hr_api.g_number) then
638: p_rec.program_application_id :=
639: ghr_rei_shd.g_old_rec.program_application_id;

Line 639: ghr_rei_shd.g_old_rec.program_application_id;

635: ghr_rei_shd.g_old_rec.request_id;
636: End If;
637: If (p_rec.program_application_id = hr_api.g_number) then
638: p_rec.program_application_id :=
639: ghr_rei_shd.g_old_rec.program_application_id;
640: End If;
641: If (p_rec.program_id = hr_api.g_number) then
642: p_rec.program_id :=
643: ghr_rei_shd.g_old_rec.program_id;

Line 643: ghr_rei_shd.g_old_rec.program_id;

639: ghr_rei_shd.g_old_rec.program_application_id;
640: End If;
641: If (p_rec.program_id = hr_api.g_number) then
642: p_rec.program_id :=
643: ghr_rei_shd.g_old_rec.program_id;
644: End If;
645: If (p_rec.program_update_date = hr_api.g_date) then
646: p_rec.program_update_date :=
647: ghr_rei_shd.g_old_rec.program_update_date;

Line 647: ghr_rei_shd.g_old_rec.program_update_date;

643: ghr_rei_shd.g_old_rec.program_id;
644: End If;
645: If (p_rec.program_update_date = hr_api.g_date) then
646: p_rec.program_update_date :=
647: ghr_rei_shd.g_old_rec.program_update_date;
648: End If;
649: --
650: hr_utility.set_location(' Leaving:'||l_proc, 10);
651: --

Line 659: p_rec in out nocopy ghr_rei_shd.g_rec_type,

655: -- |---------------------------------< upd >----------------------------------|
656: -- ----------------------------------------------------------------------------
657: Procedure upd
658: (
659: p_rec in out nocopy ghr_rei_shd.g_rec_type,
660: p_validate in boolean default false
661: ) is
662: --
663: l_proc varchar2(72) := g_package||'upd';

Line 679: ghr_rei_shd.lck

675: End If;
676: --
677: -- We must lock the row which we need to update.
678: --
679: ghr_rei_shd.lck
680: (
681: p_rec.pa_request_extra_info_id,
682: p_rec.object_version_number
683: );

Line 790: l_rec ghr_rei_shd.g_rec_type;

786: p_program_update_date in date default hr_api.g_date,
787: p_validate in boolean default false
788: ) is
789: --
790: l_rec ghr_rei_shd.g_rec_type;
791: l_proc varchar2(72) := g_package||'upd';
792: --
793: Begin
794: hr_utility.set_location('Entering:'||l_proc, 5);

Line 800: ghr_rei_shd.convert_args

796: -- Call conversion function to turn arguments into the
797: -- l_rec structure.
798: --
799: l_rec :=
800: ghr_rei_shd.convert_args
801: (
802: p_pa_request_extra_info_id,
803: p_pa_request_id,
804: p_information_type,