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.PQH_REI_UPD dependencies on PQH_REI_SHD

Line 55: (p_rec in out nocopy pqh_rei_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqh_rei_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 152: pqh_rei_shd.constraint_error

148: Exception
149: When hr_api.check_integrity_violated Then
150: -- A check constraint has been violated
151: --
152: pqh_rei_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.parent_integrity_violated Then
155: -- Parent integrity has been violated
156: --

Line 157: pqh_rei_shd.constraint_error

153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.parent_integrity_violated Then
155: -- Parent integrity has been violated
156: --
157: pqh_rei_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: --

Line 162: pqh_rei_shd.constraint_error

158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: --
162: pqh_rei_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When Others Then
165: --
166: Raise;

Line 202: (p_rec in pqh_rei_shd.g_rec_type

198: --
199: -- {End Of Comments}
200: -- ----------------------------------------------------------------------------
201: Procedure pre_update
202: (p_rec in pqh_rei_shd.g_rec_type
203: ) is
204: --
205: l_proc varchar2(72) := g_package||'pre_update';
206: --

Line 246: (p_rec in pqh_rei_shd.g_rec_type

242: --
243: -- {End Of Comments}
244: -- ----------------------------------------------------------------------------
245: Procedure post_update
246: (p_rec in pqh_rei_shd.g_rec_type
247: ) is
248: --
249: l_proc varchar2(72) := g_package||'post_update';
250: --

Line 326: ,p_role_id_o => pqh_rei_shd.g_old_rec.role_id

322: ,p_information28 => p_rec.information28
323: ,p_information29 => p_rec.information29
324: ,p_information30 => p_rec.information30
325: ,p_object_version_number => p_rec.object_version_number
326: ,p_role_id_o => pqh_rei_shd.g_old_rec.role_id
327: ,p_information_type_o => pqh_rei_shd.g_old_rec.information_type
328: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
329: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
330: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id

Line 327: ,p_information_type_o => pqh_rei_shd.g_old_rec.information_type

323: ,p_information29 => p_rec.information29
324: ,p_information30 => p_rec.information30
325: ,p_object_version_number => p_rec.object_version_number
326: ,p_role_id_o => pqh_rei_shd.g_old_rec.role_id
327: ,p_information_type_o => pqh_rei_shd.g_old_rec.information_type
328: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
329: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
330: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
331: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date

Line 328: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id

324: ,p_information30 => p_rec.information30
325: ,p_object_version_number => p_rec.object_version_number
326: ,p_role_id_o => pqh_rei_shd.g_old_rec.role_id
327: ,p_information_type_o => pqh_rei_shd.g_old_rec.information_type
328: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
329: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
330: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
331: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
332: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category

Line 329: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id

325: ,p_object_version_number => p_rec.object_version_number
326: ,p_role_id_o => pqh_rei_shd.g_old_rec.role_id
327: ,p_information_type_o => pqh_rei_shd.g_old_rec.information_type
328: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
329: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
330: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
331: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
332: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
333: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1

Line 330: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id

326: ,p_role_id_o => pqh_rei_shd.g_old_rec.role_id
327: ,p_information_type_o => pqh_rei_shd.g_old_rec.information_type
328: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
329: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
330: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
331: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
332: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
333: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
334: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2

Line 331: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date

327: ,p_information_type_o => pqh_rei_shd.g_old_rec.information_type
328: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
329: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
330: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
331: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
332: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
333: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
334: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
335: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3

Line 332: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category

328: ,p_request_id_o => pqh_rei_shd.g_old_rec.request_id
329: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
330: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
331: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
332: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
333: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
334: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
335: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
336: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4

Line 333: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1

329: ,p_program_application_id_o => pqh_rei_shd.g_old_rec.program_application_id
330: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
331: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
332: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
333: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
334: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
335: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
336: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
337: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5

Line 334: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2

330: ,p_program_id_o => pqh_rei_shd.g_old_rec.program_id
331: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
332: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
333: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
334: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
335: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
336: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
337: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
338: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6

Line 335: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3

331: ,p_program_update_date_o => pqh_rei_shd.g_old_rec.program_update_date
332: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
333: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
334: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
335: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
336: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
337: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
338: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
339: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7

Line 336: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4

332: ,p_attribute_category_o => pqh_rei_shd.g_old_rec.attribute_category
333: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
334: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
335: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
336: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
337: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
338: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
339: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
340: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8

Line 337: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5

333: ,p_attribute1_o => pqh_rei_shd.g_old_rec.attribute1
334: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
335: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
336: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
337: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
338: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
339: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
340: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
341: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9

Line 338: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6

334: ,p_attribute2_o => pqh_rei_shd.g_old_rec.attribute2
335: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
336: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
337: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
338: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
339: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
340: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
341: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
342: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10

Line 339: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7

335: ,p_attribute3_o => pqh_rei_shd.g_old_rec.attribute3
336: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
337: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
338: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
339: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
340: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
341: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
342: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
343: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11

Line 340: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8

336: ,p_attribute4_o => pqh_rei_shd.g_old_rec.attribute4
337: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
338: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
339: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
340: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
341: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
342: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
343: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
344: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12

Line 341: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9

337: ,p_attribute5_o => pqh_rei_shd.g_old_rec.attribute5
338: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
339: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
340: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
341: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
342: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
343: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
344: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
345: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13

Line 342: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10

338: ,p_attribute6_o => pqh_rei_shd.g_old_rec.attribute6
339: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
340: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
341: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
342: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
343: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
344: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
345: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
346: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14

Line 343: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11

339: ,p_attribute7_o => pqh_rei_shd.g_old_rec.attribute7
340: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
341: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
342: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
343: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
344: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
345: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
346: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
347: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15

Line 344: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12

340: ,p_attribute8_o => pqh_rei_shd.g_old_rec.attribute8
341: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
342: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
343: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
344: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
345: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
346: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
347: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
348: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16

Line 345: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13

341: ,p_attribute9_o => pqh_rei_shd.g_old_rec.attribute9
342: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
343: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
344: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
345: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
346: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
347: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
348: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
349: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17

Line 346: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14

342: ,p_attribute10_o => pqh_rei_shd.g_old_rec.attribute10
343: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
344: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
345: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
346: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
347: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
348: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
349: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
350: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18

Line 347: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15

343: ,p_attribute11_o => pqh_rei_shd.g_old_rec.attribute11
344: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
345: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
346: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
347: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
348: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
349: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
350: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
351: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19

Line 348: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16

344: ,p_attribute12_o => pqh_rei_shd.g_old_rec.attribute12
345: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
346: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
347: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
348: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
349: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
350: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
351: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
352: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20

Line 349: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17

345: ,p_attribute13_o => pqh_rei_shd.g_old_rec.attribute13
346: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
347: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
348: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
349: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
350: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
351: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
352: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
353: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21

Line 350: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18

346: ,p_attribute14_o => pqh_rei_shd.g_old_rec.attribute14
347: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
348: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
349: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
350: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
351: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
352: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
353: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
354: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22

Line 351: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19

347: ,p_attribute15_o => pqh_rei_shd.g_old_rec.attribute15
348: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
349: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
350: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
351: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
352: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
353: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
354: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
355: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23

Line 352: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20

348: ,p_attribute16_o => pqh_rei_shd.g_old_rec.attribute16
349: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
350: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
351: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
352: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
353: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
354: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
355: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
356: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24

Line 353: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21

349: ,p_attribute17_o => pqh_rei_shd.g_old_rec.attribute17
350: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
351: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
352: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
353: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
354: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
355: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
356: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
357: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25

Line 354: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22

350: ,p_attribute18_o => pqh_rei_shd.g_old_rec.attribute18
351: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
352: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
353: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
354: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
355: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
356: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
357: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
358: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26

Line 355: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23

351: ,p_attribute19_o => pqh_rei_shd.g_old_rec.attribute19
352: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
353: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
354: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
355: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
356: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
357: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
358: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
359: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27

Line 356: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24

352: ,p_attribute20_o => pqh_rei_shd.g_old_rec.attribute20
353: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
354: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
355: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
356: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
357: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
358: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
359: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
360: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28

Line 357: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25

353: ,p_attribute21_o => pqh_rei_shd.g_old_rec.attribute21
354: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
355: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
356: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
357: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
358: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
359: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
360: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
361: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29

Line 358: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26

354: ,p_attribute22_o => pqh_rei_shd.g_old_rec.attribute22
355: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
356: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
357: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
358: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
359: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
360: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
361: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
362: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30

Line 359: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27

355: ,p_attribute23_o => pqh_rei_shd.g_old_rec.attribute23
356: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
357: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
358: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
359: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
360: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
361: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
362: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
363: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category

Line 360: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28

356: ,p_attribute24_o => pqh_rei_shd.g_old_rec.attribute24
357: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
358: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
359: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
360: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
361: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
362: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
363: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
364: ,p_information1_o => pqh_rei_shd.g_old_rec.information1

Line 361: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29

357: ,p_attribute25_o => pqh_rei_shd.g_old_rec.attribute25
358: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
359: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
360: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
361: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
362: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
363: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
364: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
365: ,p_information2_o => pqh_rei_shd.g_old_rec.information2

Line 362: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30

358: ,p_attribute26_o => pqh_rei_shd.g_old_rec.attribute26
359: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
360: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
361: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
362: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
363: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
364: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
365: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
366: ,p_information3_o => pqh_rei_shd.g_old_rec.information3

Line 363: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category

359: ,p_attribute27_o => pqh_rei_shd.g_old_rec.attribute27
360: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
361: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
362: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
363: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
364: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
365: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
366: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
367: ,p_information4_o => pqh_rei_shd.g_old_rec.information4

Line 364: ,p_information1_o => pqh_rei_shd.g_old_rec.information1

360: ,p_attribute28_o => pqh_rei_shd.g_old_rec.attribute28
361: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
362: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
363: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
364: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
365: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
366: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
367: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
368: ,p_information5_o => pqh_rei_shd.g_old_rec.information5

Line 365: ,p_information2_o => pqh_rei_shd.g_old_rec.information2

361: ,p_attribute29_o => pqh_rei_shd.g_old_rec.attribute29
362: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
363: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
364: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
365: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
366: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
367: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
368: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
369: ,p_information6_o => pqh_rei_shd.g_old_rec.information6

Line 366: ,p_information3_o => pqh_rei_shd.g_old_rec.information3

362: ,p_attribute30_o => pqh_rei_shd.g_old_rec.attribute30
363: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
364: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
365: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
366: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
367: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
368: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
369: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
370: ,p_information7_o => pqh_rei_shd.g_old_rec.information7

Line 367: ,p_information4_o => pqh_rei_shd.g_old_rec.information4

363: ,p_information_category_o => pqh_rei_shd.g_old_rec.information_category
364: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
365: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
366: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
367: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
368: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
369: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
370: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
371: ,p_information8_o => pqh_rei_shd.g_old_rec.information8

Line 368: ,p_information5_o => pqh_rei_shd.g_old_rec.information5

364: ,p_information1_o => pqh_rei_shd.g_old_rec.information1
365: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
366: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
367: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
368: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
369: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
370: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
371: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
372: ,p_information9_o => pqh_rei_shd.g_old_rec.information9

Line 369: ,p_information6_o => pqh_rei_shd.g_old_rec.information6

365: ,p_information2_o => pqh_rei_shd.g_old_rec.information2
366: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
367: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
368: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
369: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
370: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
371: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
372: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
373: ,p_information10_o => pqh_rei_shd.g_old_rec.information10

Line 370: ,p_information7_o => pqh_rei_shd.g_old_rec.information7

366: ,p_information3_o => pqh_rei_shd.g_old_rec.information3
367: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
368: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
369: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
370: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
371: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
372: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
373: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
374: ,p_information11_o => pqh_rei_shd.g_old_rec.information11

Line 371: ,p_information8_o => pqh_rei_shd.g_old_rec.information8

367: ,p_information4_o => pqh_rei_shd.g_old_rec.information4
368: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
369: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
370: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
371: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
372: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
373: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
374: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
375: ,p_information12_o => pqh_rei_shd.g_old_rec.information12

Line 372: ,p_information9_o => pqh_rei_shd.g_old_rec.information9

368: ,p_information5_o => pqh_rei_shd.g_old_rec.information5
369: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
370: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
371: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
372: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
373: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
374: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
375: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
376: ,p_information13_o => pqh_rei_shd.g_old_rec.information13

Line 373: ,p_information10_o => pqh_rei_shd.g_old_rec.information10

369: ,p_information6_o => pqh_rei_shd.g_old_rec.information6
370: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
371: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
372: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
373: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
374: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
375: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
376: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
377: ,p_information14_o => pqh_rei_shd.g_old_rec.information14

Line 374: ,p_information11_o => pqh_rei_shd.g_old_rec.information11

370: ,p_information7_o => pqh_rei_shd.g_old_rec.information7
371: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
372: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
373: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
374: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
375: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
376: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
377: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
378: ,p_information15_o => pqh_rei_shd.g_old_rec.information15

Line 375: ,p_information12_o => pqh_rei_shd.g_old_rec.information12

371: ,p_information8_o => pqh_rei_shd.g_old_rec.information8
372: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
373: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
374: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
375: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
376: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
377: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
378: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
379: ,p_information16_o => pqh_rei_shd.g_old_rec.information16

Line 376: ,p_information13_o => pqh_rei_shd.g_old_rec.information13

372: ,p_information9_o => pqh_rei_shd.g_old_rec.information9
373: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
374: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
375: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
376: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
377: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
378: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
379: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
380: ,p_information17_o => pqh_rei_shd.g_old_rec.information17

Line 377: ,p_information14_o => pqh_rei_shd.g_old_rec.information14

373: ,p_information10_o => pqh_rei_shd.g_old_rec.information10
374: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
375: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
376: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
377: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
378: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
379: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
380: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
381: ,p_information18_o => pqh_rei_shd.g_old_rec.information18

Line 378: ,p_information15_o => pqh_rei_shd.g_old_rec.information15

374: ,p_information11_o => pqh_rei_shd.g_old_rec.information11
375: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
376: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
377: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
378: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
379: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
380: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
381: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
382: ,p_information19_o => pqh_rei_shd.g_old_rec.information19

Line 379: ,p_information16_o => pqh_rei_shd.g_old_rec.information16

375: ,p_information12_o => pqh_rei_shd.g_old_rec.information12
376: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
377: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
378: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
379: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
380: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
381: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
382: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
383: ,p_information20_o => pqh_rei_shd.g_old_rec.information20

Line 380: ,p_information17_o => pqh_rei_shd.g_old_rec.information17

376: ,p_information13_o => pqh_rei_shd.g_old_rec.information13
377: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
378: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
379: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
380: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
381: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
382: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
383: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
384: ,p_information21_o => pqh_rei_shd.g_old_rec.information21

Line 381: ,p_information18_o => pqh_rei_shd.g_old_rec.information18

377: ,p_information14_o => pqh_rei_shd.g_old_rec.information14
378: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
379: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
380: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
381: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
382: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
383: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
384: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
385: ,p_information22_o => pqh_rei_shd.g_old_rec.information22

Line 382: ,p_information19_o => pqh_rei_shd.g_old_rec.information19

378: ,p_information15_o => pqh_rei_shd.g_old_rec.information15
379: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
380: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
381: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
382: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
383: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
384: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
385: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
386: ,p_information23_o => pqh_rei_shd.g_old_rec.information23

Line 383: ,p_information20_o => pqh_rei_shd.g_old_rec.information20

379: ,p_information16_o => pqh_rei_shd.g_old_rec.information16
380: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
381: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
382: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
383: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
384: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
385: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
386: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
387: ,p_information24_o => pqh_rei_shd.g_old_rec.information24

Line 384: ,p_information21_o => pqh_rei_shd.g_old_rec.information21

380: ,p_information17_o => pqh_rei_shd.g_old_rec.information17
381: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
382: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
383: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
384: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
385: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
386: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
387: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
388: ,p_information25_o => pqh_rei_shd.g_old_rec.information25

Line 385: ,p_information22_o => pqh_rei_shd.g_old_rec.information22

381: ,p_information18_o => pqh_rei_shd.g_old_rec.information18
382: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
383: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
384: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
385: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
386: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
387: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
388: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
389: ,p_information26_o => pqh_rei_shd.g_old_rec.information26

Line 386: ,p_information23_o => pqh_rei_shd.g_old_rec.information23

382: ,p_information19_o => pqh_rei_shd.g_old_rec.information19
383: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
384: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
385: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
386: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
387: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
388: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
389: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
390: ,p_information27_o => pqh_rei_shd.g_old_rec.information27

Line 387: ,p_information24_o => pqh_rei_shd.g_old_rec.information24

383: ,p_information20_o => pqh_rei_shd.g_old_rec.information20
384: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
385: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
386: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
387: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
388: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
389: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
390: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
391: ,p_information28_o => pqh_rei_shd.g_old_rec.information28

Line 388: ,p_information25_o => pqh_rei_shd.g_old_rec.information25

384: ,p_information21_o => pqh_rei_shd.g_old_rec.information21
385: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
386: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
387: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
388: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
389: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
390: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
391: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
392: ,p_information29_o => pqh_rei_shd.g_old_rec.information29

Line 389: ,p_information26_o => pqh_rei_shd.g_old_rec.information26

385: ,p_information22_o => pqh_rei_shd.g_old_rec.information22
386: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
387: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
388: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
389: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
390: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
391: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
392: ,p_information29_o => pqh_rei_shd.g_old_rec.information29
393: ,p_information30_o => pqh_rei_shd.g_old_rec.information30

Line 390: ,p_information27_o => pqh_rei_shd.g_old_rec.information27

386: ,p_information23_o => pqh_rei_shd.g_old_rec.information23
387: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
388: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
389: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
390: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
391: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
392: ,p_information29_o => pqh_rei_shd.g_old_rec.information29
393: ,p_information30_o => pqh_rei_shd.g_old_rec.information30
394: ,p_object_version_number_o => pqh_rei_shd.g_old_rec.object_version_number

Line 391: ,p_information28_o => pqh_rei_shd.g_old_rec.information28

387: ,p_information24_o => pqh_rei_shd.g_old_rec.information24
388: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
389: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
390: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
391: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
392: ,p_information29_o => pqh_rei_shd.g_old_rec.information29
393: ,p_information30_o => pqh_rei_shd.g_old_rec.information30
394: ,p_object_version_number_o => pqh_rei_shd.g_old_rec.object_version_number
395: );

Line 392: ,p_information29_o => pqh_rei_shd.g_old_rec.information29

388: ,p_information25_o => pqh_rei_shd.g_old_rec.information25
389: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
390: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
391: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
392: ,p_information29_o => pqh_rei_shd.g_old_rec.information29
393: ,p_information30_o => pqh_rei_shd.g_old_rec.information30
394: ,p_object_version_number_o => pqh_rei_shd.g_old_rec.object_version_number
395: );
396: --

Line 393: ,p_information30_o => pqh_rei_shd.g_old_rec.information30

389: ,p_information26_o => pqh_rei_shd.g_old_rec.information26
390: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
391: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
392: ,p_information29_o => pqh_rei_shd.g_old_rec.information29
393: ,p_information30_o => pqh_rei_shd.g_old_rec.information30
394: ,p_object_version_number_o => pqh_rei_shd.g_old_rec.object_version_number
395: );
396: --
397: exception

Line 394: ,p_object_version_number_o => pqh_rei_shd.g_old_rec.object_version_number

390: ,p_information27_o => pqh_rei_shd.g_old_rec.information27
391: ,p_information28_o => pqh_rei_shd.g_old_rec.information28
392: ,p_information29_o => pqh_rei_shd.g_old_rec.information29
393: ,p_information30_o => pqh_rei_shd.g_old_rec.information30
394: ,p_object_version_number_o => pqh_rei_shd.g_old_rec.object_version_number
395: );
396: --
397: exception
398: --

Line 454: (p_rec in out nocopy pqh_rei_shd.g_rec_type

450: --
451: -- {End Of Comments}
452: -- ----------------------------------------------------------------------------
453: Procedure convert_defs
454: (p_rec in out nocopy pqh_rei_shd.g_rec_type
455: ) is
456: --
457: Begin
458: --

Line 466: pqh_rei_shd.g_old_rec.role_id;

462: -- is being used then we must set to the 'current' argument value.
463: --
464: If (p_rec.role_id = hr_api.g_number) then
465: p_rec.role_id :=
466: pqh_rei_shd.g_old_rec.role_id;
467: End If;
468: If (p_rec.information_type = hr_api.g_varchar2) then
469: p_rec.information_type :=
470: pqh_rei_shd.g_old_rec.information_type;

Line 470: pqh_rei_shd.g_old_rec.information_type;

466: pqh_rei_shd.g_old_rec.role_id;
467: End If;
468: If (p_rec.information_type = hr_api.g_varchar2) then
469: p_rec.information_type :=
470: pqh_rei_shd.g_old_rec.information_type;
471: End If;
472: If (p_rec.request_id = hr_api.g_number) then
473: p_rec.request_id :=
474: pqh_rei_shd.g_old_rec.request_id;

Line 474: pqh_rei_shd.g_old_rec.request_id;

470: pqh_rei_shd.g_old_rec.information_type;
471: End If;
472: If (p_rec.request_id = hr_api.g_number) then
473: p_rec.request_id :=
474: pqh_rei_shd.g_old_rec.request_id;
475: End If;
476: If (p_rec.program_application_id = hr_api.g_number) then
477: p_rec.program_application_id :=
478: pqh_rei_shd.g_old_rec.program_application_id;

Line 478: pqh_rei_shd.g_old_rec.program_application_id;

474: pqh_rei_shd.g_old_rec.request_id;
475: End If;
476: If (p_rec.program_application_id = hr_api.g_number) then
477: p_rec.program_application_id :=
478: pqh_rei_shd.g_old_rec.program_application_id;
479: End If;
480: If (p_rec.program_id = hr_api.g_number) then
481: p_rec.program_id :=
482: pqh_rei_shd.g_old_rec.program_id;

Line 482: pqh_rei_shd.g_old_rec.program_id;

478: pqh_rei_shd.g_old_rec.program_application_id;
479: End If;
480: If (p_rec.program_id = hr_api.g_number) then
481: p_rec.program_id :=
482: pqh_rei_shd.g_old_rec.program_id;
483: End If;
484: If (p_rec.program_update_date = hr_api.g_date) then
485: p_rec.program_update_date :=
486: pqh_rei_shd.g_old_rec.program_update_date;

Line 486: pqh_rei_shd.g_old_rec.program_update_date;

482: pqh_rei_shd.g_old_rec.program_id;
483: End If;
484: If (p_rec.program_update_date = hr_api.g_date) then
485: p_rec.program_update_date :=
486: pqh_rei_shd.g_old_rec.program_update_date;
487: End If;
488: If (p_rec.attribute_category = hr_api.g_varchar2) then
489: p_rec.attribute_category :=
490: pqh_rei_shd.g_old_rec.attribute_category;

Line 490: pqh_rei_shd.g_old_rec.attribute_category;

486: pqh_rei_shd.g_old_rec.program_update_date;
487: End If;
488: If (p_rec.attribute_category = hr_api.g_varchar2) then
489: p_rec.attribute_category :=
490: pqh_rei_shd.g_old_rec.attribute_category;
491: End If;
492: If (p_rec.attribute1 = hr_api.g_varchar2) then
493: p_rec.attribute1 :=
494: pqh_rei_shd.g_old_rec.attribute1;

Line 494: pqh_rei_shd.g_old_rec.attribute1;

490: pqh_rei_shd.g_old_rec.attribute_category;
491: End If;
492: If (p_rec.attribute1 = hr_api.g_varchar2) then
493: p_rec.attribute1 :=
494: pqh_rei_shd.g_old_rec.attribute1;
495: End If;
496: If (p_rec.attribute2 = hr_api.g_varchar2) then
497: p_rec.attribute2 :=
498: pqh_rei_shd.g_old_rec.attribute2;

Line 498: pqh_rei_shd.g_old_rec.attribute2;

494: pqh_rei_shd.g_old_rec.attribute1;
495: End If;
496: If (p_rec.attribute2 = hr_api.g_varchar2) then
497: p_rec.attribute2 :=
498: pqh_rei_shd.g_old_rec.attribute2;
499: End If;
500: If (p_rec.attribute3 = hr_api.g_varchar2) then
501: p_rec.attribute3 :=
502: pqh_rei_shd.g_old_rec.attribute3;

Line 502: pqh_rei_shd.g_old_rec.attribute3;

498: pqh_rei_shd.g_old_rec.attribute2;
499: End If;
500: If (p_rec.attribute3 = hr_api.g_varchar2) then
501: p_rec.attribute3 :=
502: pqh_rei_shd.g_old_rec.attribute3;
503: End If;
504: If (p_rec.attribute4 = hr_api.g_varchar2) then
505: p_rec.attribute4 :=
506: pqh_rei_shd.g_old_rec.attribute4;

Line 506: pqh_rei_shd.g_old_rec.attribute4;

502: pqh_rei_shd.g_old_rec.attribute3;
503: End If;
504: If (p_rec.attribute4 = hr_api.g_varchar2) then
505: p_rec.attribute4 :=
506: pqh_rei_shd.g_old_rec.attribute4;
507: End If;
508: If (p_rec.attribute5 = hr_api.g_varchar2) then
509: p_rec.attribute5 :=
510: pqh_rei_shd.g_old_rec.attribute5;

Line 510: pqh_rei_shd.g_old_rec.attribute5;

506: pqh_rei_shd.g_old_rec.attribute4;
507: End If;
508: If (p_rec.attribute5 = hr_api.g_varchar2) then
509: p_rec.attribute5 :=
510: pqh_rei_shd.g_old_rec.attribute5;
511: End If;
512: If (p_rec.attribute6 = hr_api.g_varchar2) then
513: p_rec.attribute6 :=
514: pqh_rei_shd.g_old_rec.attribute6;

Line 514: pqh_rei_shd.g_old_rec.attribute6;

510: pqh_rei_shd.g_old_rec.attribute5;
511: End If;
512: If (p_rec.attribute6 = hr_api.g_varchar2) then
513: p_rec.attribute6 :=
514: pqh_rei_shd.g_old_rec.attribute6;
515: End If;
516: If (p_rec.attribute7 = hr_api.g_varchar2) then
517: p_rec.attribute7 :=
518: pqh_rei_shd.g_old_rec.attribute7;

Line 518: pqh_rei_shd.g_old_rec.attribute7;

514: pqh_rei_shd.g_old_rec.attribute6;
515: End If;
516: If (p_rec.attribute7 = hr_api.g_varchar2) then
517: p_rec.attribute7 :=
518: pqh_rei_shd.g_old_rec.attribute7;
519: End If;
520: If (p_rec.attribute8 = hr_api.g_varchar2) then
521: p_rec.attribute8 :=
522: pqh_rei_shd.g_old_rec.attribute8;

Line 522: pqh_rei_shd.g_old_rec.attribute8;

518: pqh_rei_shd.g_old_rec.attribute7;
519: End If;
520: If (p_rec.attribute8 = hr_api.g_varchar2) then
521: p_rec.attribute8 :=
522: pqh_rei_shd.g_old_rec.attribute8;
523: End If;
524: If (p_rec.attribute9 = hr_api.g_varchar2) then
525: p_rec.attribute9 :=
526: pqh_rei_shd.g_old_rec.attribute9;

Line 526: pqh_rei_shd.g_old_rec.attribute9;

522: pqh_rei_shd.g_old_rec.attribute8;
523: End If;
524: If (p_rec.attribute9 = hr_api.g_varchar2) then
525: p_rec.attribute9 :=
526: pqh_rei_shd.g_old_rec.attribute9;
527: End If;
528: If (p_rec.attribute10 = hr_api.g_varchar2) then
529: p_rec.attribute10 :=
530: pqh_rei_shd.g_old_rec.attribute10;

Line 530: pqh_rei_shd.g_old_rec.attribute10;

526: pqh_rei_shd.g_old_rec.attribute9;
527: End If;
528: If (p_rec.attribute10 = hr_api.g_varchar2) then
529: p_rec.attribute10 :=
530: pqh_rei_shd.g_old_rec.attribute10;
531: End If;
532: If (p_rec.attribute11 = hr_api.g_varchar2) then
533: p_rec.attribute11 :=
534: pqh_rei_shd.g_old_rec.attribute11;

Line 534: pqh_rei_shd.g_old_rec.attribute11;

530: pqh_rei_shd.g_old_rec.attribute10;
531: End If;
532: If (p_rec.attribute11 = hr_api.g_varchar2) then
533: p_rec.attribute11 :=
534: pqh_rei_shd.g_old_rec.attribute11;
535: End If;
536: If (p_rec.attribute12 = hr_api.g_varchar2) then
537: p_rec.attribute12 :=
538: pqh_rei_shd.g_old_rec.attribute12;

Line 538: pqh_rei_shd.g_old_rec.attribute12;

534: pqh_rei_shd.g_old_rec.attribute11;
535: End If;
536: If (p_rec.attribute12 = hr_api.g_varchar2) then
537: p_rec.attribute12 :=
538: pqh_rei_shd.g_old_rec.attribute12;
539: End If;
540: If (p_rec.attribute13 = hr_api.g_varchar2) then
541: p_rec.attribute13 :=
542: pqh_rei_shd.g_old_rec.attribute13;

Line 542: pqh_rei_shd.g_old_rec.attribute13;

538: pqh_rei_shd.g_old_rec.attribute12;
539: End If;
540: If (p_rec.attribute13 = hr_api.g_varchar2) then
541: p_rec.attribute13 :=
542: pqh_rei_shd.g_old_rec.attribute13;
543: End If;
544: If (p_rec.attribute14 = hr_api.g_varchar2) then
545: p_rec.attribute14 :=
546: pqh_rei_shd.g_old_rec.attribute14;

Line 546: pqh_rei_shd.g_old_rec.attribute14;

542: pqh_rei_shd.g_old_rec.attribute13;
543: End If;
544: If (p_rec.attribute14 = hr_api.g_varchar2) then
545: p_rec.attribute14 :=
546: pqh_rei_shd.g_old_rec.attribute14;
547: End If;
548: If (p_rec.attribute15 = hr_api.g_varchar2) then
549: p_rec.attribute15 :=
550: pqh_rei_shd.g_old_rec.attribute15;

Line 550: pqh_rei_shd.g_old_rec.attribute15;

546: pqh_rei_shd.g_old_rec.attribute14;
547: End If;
548: If (p_rec.attribute15 = hr_api.g_varchar2) then
549: p_rec.attribute15 :=
550: pqh_rei_shd.g_old_rec.attribute15;
551: End If;
552: If (p_rec.attribute16 = hr_api.g_varchar2) then
553: p_rec.attribute16 :=
554: pqh_rei_shd.g_old_rec.attribute16;

Line 554: pqh_rei_shd.g_old_rec.attribute16;

550: pqh_rei_shd.g_old_rec.attribute15;
551: End If;
552: If (p_rec.attribute16 = hr_api.g_varchar2) then
553: p_rec.attribute16 :=
554: pqh_rei_shd.g_old_rec.attribute16;
555: End If;
556: If (p_rec.attribute17 = hr_api.g_varchar2) then
557: p_rec.attribute17 :=
558: pqh_rei_shd.g_old_rec.attribute17;

Line 558: pqh_rei_shd.g_old_rec.attribute17;

554: pqh_rei_shd.g_old_rec.attribute16;
555: End If;
556: If (p_rec.attribute17 = hr_api.g_varchar2) then
557: p_rec.attribute17 :=
558: pqh_rei_shd.g_old_rec.attribute17;
559: End If;
560: If (p_rec.attribute18 = hr_api.g_varchar2) then
561: p_rec.attribute18 :=
562: pqh_rei_shd.g_old_rec.attribute18;

Line 562: pqh_rei_shd.g_old_rec.attribute18;

558: pqh_rei_shd.g_old_rec.attribute17;
559: End If;
560: If (p_rec.attribute18 = hr_api.g_varchar2) then
561: p_rec.attribute18 :=
562: pqh_rei_shd.g_old_rec.attribute18;
563: End If;
564: If (p_rec.attribute19 = hr_api.g_varchar2) then
565: p_rec.attribute19 :=
566: pqh_rei_shd.g_old_rec.attribute19;

Line 566: pqh_rei_shd.g_old_rec.attribute19;

562: pqh_rei_shd.g_old_rec.attribute18;
563: End If;
564: If (p_rec.attribute19 = hr_api.g_varchar2) then
565: p_rec.attribute19 :=
566: pqh_rei_shd.g_old_rec.attribute19;
567: End If;
568: If (p_rec.attribute20 = hr_api.g_varchar2) then
569: p_rec.attribute20 :=
570: pqh_rei_shd.g_old_rec.attribute20;

Line 570: pqh_rei_shd.g_old_rec.attribute20;

566: pqh_rei_shd.g_old_rec.attribute19;
567: End If;
568: If (p_rec.attribute20 = hr_api.g_varchar2) then
569: p_rec.attribute20 :=
570: pqh_rei_shd.g_old_rec.attribute20;
571: End If;
572: If (p_rec.attribute21 = hr_api.g_varchar2) then
573: p_rec.attribute21 :=
574: pqh_rei_shd.g_old_rec.attribute21;

Line 574: pqh_rei_shd.g_old_rec.attribute21;

570: pqh_rei_shd.g_old_rec.attribute20;
571: End If;
572: If (p_rec.attribute21 = hr_api.g_varchar2) then
573: p_rec.attribute21 :=
574: pqh_rei_shd.g_old_rec.attribute21;
575: End If;
576: If (p_rec.attribute22 = hr_api.g_varchar2) then
577: p_rec.attribute22 :=
578: pqh_rei_shd.g_old_rec.attribute22;

Line 578: pqh_rei_shd.g_old_rec.attribute22;

574: pqh_rei_shd.g_old_rec.attribute21;
575: End If;
576: If (p_rec.attribute22 = hr_api.g_varchar2) then
577: p_rec.attribute22 :=
578: pqh_rei_shd.g_old_rec.attribute22;
579: End If;
580: If (p_rec.attribute23 = hr_api.g_varchar2) then
581: p_rec.attribute23 :=
582: pqh_rei_shd.g_old_rec.attribute23;

Line 582: pqh_rei_shd.g_old_rec.attribute23;

578: pqh_rei_shd.g_old_rec.attribute22;
579: End If;
580: If (p_rec.attribute23 = hr_api.g_varchar2) then
581: p_rec.attribute23 :=
582: pqh_rei_shd.g_old_rec.attribute23;
583: End If;
584: If (p_rec.attribute24 = hr_api.g_varchar2) then
585: p_rec.attribute24 :=
586: pqh_rei_shd.g_old_rec.attribute24;

Line 586: pqh_rei_shd.g_old_rec.attribute24;

582: pqh_rei_shd.g_old_rec.attribute23;
583: End If;
584: If (p_rec.attribute24 = hr_api.g_varchar2) then
585: p_rec.attribute24 :=
586: pqh_rei_shd.g_old_rec.attribute24;
587: End If;
588: If (p_rec.attribute25 = hr_api.g_varchar2) then
589: p_rec.attribute25 :=
590: pqh_rei_shd.g_old_rec.attribute25;

Line 590: pqh_rei_shd.g_old_rec.attribute25;

586: pqh_rei_shd.g_old_rec.attribute24;
587: End If;
588: If (p_rec.attribute25 = hr_api.g_varchar2) then
589: p_rec.attribute25 :=
590: pqh_rei_shd.g_old_rec.attribute25;
591: End If;
592: If (p_rec.attribute26 = hr_api.g_varchar2) then
593: p_rec.attribute26 :=
594: pqh_rei_shd.g_old_rec.attribute26;

Line 594: pqh_rei_shd.g_old_rec.attribute26;

590: pqh_rei_shd.g_old_rec.attribute25;
591: End If;
592: If (p_rec.attribute26 = hr_api.g_varchar2) then
593: p_rec.attribute26 :=
594: pqh_rei_shd.g_old_rec.attribute26;
595: End If;
596: If (p_rec.attribute27 = hr_api.g_varchar2) then
597: p_rec.attribute27 :=
598: pqh_rei_shd.g_old_rec.attribute27;

Line 598: pqh_rei_shd.g_old_rec.attribute27;

594: pqh_rei_shd.g_old_rec.attribute26;
595: End If;
596: If (p_rec.attribute27 = hr_api.g_varchar2) then
597: p_rec.attribute27 :=
598: pqh_rei_shd.g_old_rec.attribute27;
599: End If;
600: If (p_rec.attribute28 = hr_api.g_varchar2) then
601: p_rec.attribute28 :=
602: pqh_rei_shd.g_old_rec.attribute28;

Line 602: pqh_rei_shd.g_old_rec.attribute28;

598: pqh_rei_shd.g_old_rec.attribute27;
599: End If;
600: If (p_rec.attribute28 = hr_api.g_varchar2) then
601: p_rec.attribute28 :=
602: pqh_rei_shd.g_old_rec.attribute28;
603: End If;
604: If (p_rec.attribute29 = hr_api.g_varchar2) then
605: p_rec.attribute29 :=
606: pqh_rei_shd.g_old_rec.attribute29;

Line 606: pqh_rei_shd.g_old_rec.attribute29;

602: pqh_rei_shd.g_old_rec.attribute28;
603: End If;
604: If (p_rec.attribute29 = hr_api.g_varchar2) then
605: p_rec.attribute29 :=
606: pqh_rei_shd.g_old_rec.attribute29;
607: End If;
608: If (p_rec.attribute30 = hr_api.g_varchar2) then
609: p_rec.attribute30 :=
610: pqh_rei_shd.g_old_rec.attribute30;

Line 610: pqh_rei_shd.g_old_rec.attribute30;

606: pqh_rei_shd.g_old_rec.attribute29;
607: End If;
608: If (p_rec.attribute30 = hr_api.g_varchar2) then
609: p_rec.attribute30 :=
610: pqh_rei_shd.g_old_rec.attribute30;
611: End If;
612:
613: If (p_rec.information_category = hr_api.g_varchar2) then
614: p_rec.information_category :=

Line 615: pqh_rei_shd.g_old_rec.information_category;

611: End If;
612:
613: If (p_rec.information_category = hr_api.g_varchar2) then
614: p_rec.information_category :=
615: pqh_rei_shd.g_old_rec.information_category;
616: End If;
617: If (p_rec.information1 = hr_api.g_varchar2) then
618: p_rec.information1 :=
619: pqh_rei_shd.g_old_rec.information1;

Line 619: pqh_rei_shd.g_old_rec.information1;

615: pqh_rei_shd.g_old_rec.information_category;
616: End If;
617: If (p_rec.information1 = hr_api.g_varchar2) then
618: p_rec.information1 :=
619: pqh_rei_shd.g_old_rec.information1;
620: End If;
621: If (p_rec.information2 = hr_api.g_varchar2) then
622: p_rec.information2 :=
623: pqh_rei_shd.g_old_rec.information2;

Line 623: pqh_rei_shd.g_old_rec.information2;

619: pqh_rei_shd.g_old_rec.information1;
620: End If;
621: If (p_rec.information2 = hr_api.g_varchar2) then
622: p_rec.information2 :=
623: pqh_rei_shd.g_old_rec.information2;
624: End If;
625: If (p_rec.information3 = hr_api.g_varchar2) then
626: p_rec.information3 :=
627: pqh_rei_shd.g_old_rec.information3;

Line 627: pqh_rei_shd.g_old_rec.information3;

623: pqh_rei_shd.g_old_rec.information2;
624: End If;
625: If (p_rec.information3 = hr_api.g_varchar2) then
626: p_rec.information3 :=
627: pqh_rei_shd.g_old_rec.information3;
628: End If;
629: If (p_rec.information4 = hr_api.g_varchar2) then
630: p_rec.information4 :=
631: pqh_rei_shd.g_old_rec.information4;

Line 631: pqh_rei_shd.g_old_rec.information4;

627: pqh_rei_shd.g_old_rec.information3;
628: End If;
629: If (p_rec.information4 = hr_api.g_varchar2) then
630: p_rec.information4 :=
631: pqh_rei_shd.g_old_rec.information4;
632: End If;
633: If (p_rec.information5 = hr_api.g_varchar2) then
634: p_rec.information5 :=
635: pqh_rei_shd.g_old_rec.information5;

Line 635: pqh_rei_shd.g_old_rec.information5;

631: pqh_rei_shd.g_old_rec.information4;
632: End If;
633: If (p_rec.information5 = hr_api.g_varchar2) then
634: p_rec.information5 :=
635: pqh_rei_shd.g_old_rec.information5;
636: End If;
637: If (p_rec.information6 = hr_api.g_varchar2) then
638: p_rec.information6 :=
639: pqh_rei_shd.g_old_rec.information6;

Line 639: pqh_rei_shd.g_old_rec.information6;

635: pqh_rei_shd.g_old_rec.information5;
636: End If;
637: If (p_rec.information6 = hr_api.g_varchar2) then
638: p_rec.information6 :=
639: pqh_rei_shd.g_old_rec.information6;
640: End If;
641: If (p_rec.information7 = hr_api.g_varchar2) then
642: p_rec.information7 :=
643: pqh_rei_shd.g_old_rec.information7;

Line 643: pqh_rei_shd.g_old_rec.information7;

639: pqh_rei_shd.g_old_rec.information6;
640: End If;
641: If (p_rec.information7 = hr_api.g_varchar2) then
642: p_rec.information7 :=
643: pqh_rei_shd.g_old_rec.information7;
644: End If;
645: If (p_rec.information8 = hr_api.g_varchar2) then
646: p_rec.information8 :=
647: pqh_rei_shd.g_old_rec.information8;

Line 647: pqh_rei_shd.g_old_rec.information8;

643: pqh_rei_shd.g_old_rec.information7;
644: End If;
645: If (p_rec.information8 = hr_api.g_varchar2) then
646: p_rec.information8 :=
647: pqh_rei_shd.g_old_rec.information8;
648: End If;
649: If (p_rec.information9 = hr_api.g_varchar2) then
650: p_rec.information9 :=
651: pqh_rei_shd.g_old_rec.information9;

Line 651: pqh_rei_shd.g_old_rec.information9;

647: pqh_rei_shd.g_old_rec.information8;
648: End If;
649: If (p_rec.information9 = hr_api.g_varchar2) then
650: p_rec.information9 :=
651: pqh_rei_shd.g_old_rec.information9;
652: End If;
653: If (p_rec.information10 = hr_api.g_varchar2) then
654: p_rec.information10 :=
655: pqh_rei_shd.g_old_rec.information10;

Line 655: pqh_rei_shd.g_old_rec.information10;

651: pqh_rei_shd.g_old_rec.information9;
652: End If;
653: If (p_rec.information10 = hr_api.g_varchar2) then
654: p_rec.information10 :=
655: pqh_rei_shd.g_old_rec.information10;
656: End If;
657: If (p_rec.information11 = hr_api.g_varchar2) then
658: p_rec.information11 :=
659: pqh_rei_shd.g_old_rec.information11;

Line 659: pqh_rei_shd.g_old_rec.information11;

655: pqh_rei_shd.g_old_rec.information10;
656: End If;
657: If (p_rec.information11 = hr_api.g_varchar2) then
658: p_rec.information11 :=
659: pqh_rei_shd.g_old_rec.information11;
660: End If;
661: If (p_rec.information12 = hr_api.g_varchar2) then
662: p_rec.information12 :=
663: pqh_rei_shd.g_old_rec.information12;

Line 663: pqh_rei_shd.g_old_rec.information12;

659: pqh_rei_shd.g_old_rec.information11;
660: End If;
661: If (p_rec.information12 = hr_api.g_varchar2) then
662: p_rec.information12 :=
663: pqh_rei_shd.g_old_rec.information12;
664: End If;
665: If (p_rec.information13 = hr_api.g_varchar2) then
666: p_rec.information13 :=
667: pqh_rei_shd.g_old_rec.information13;

Line 667: pqh_rei_shd.g_old_rec.information13;

663: pqh_rei_shd.g_old_rec.information12;
664: End If;
665: If (p_rec.information13 = hr_api.g_varchar2) then
666: p_rec.information13 :=
667: pqh_rei_shd.g_old_rec.information13;
668: End If;
669: If (p_rec.information14 = hr_api.g_varchar2) then
670: p_rec.information14 :=
671: pqh_rei_shd.g_old_rec.information14;

Line 671: pqh_rei_shd.g_old_rec.information14;

667: pqh_rei_shd.g_old_rec.information13;
668: End If;
669: If (p_rec.information14 = hr_api.g_varchar2) then
670: p_rec.information14 :=
671: pqh_rei_shd.g_old_rec.information14;
672: End If;
673: If (p_rec.information15 = hr_api.g_varchar2) then
674: p_rec.information15 :=
675: pqh_rei_shd.g_old_rec.information15;

Line 675: pqh_rei_shd.g_old_rec.information15;

671: pqh_rei_shd.g_old_rec.information14;
672: End If;
673: If (p_rec.information15 = hr_api.g_varchar2) then
674: p_rec.information15 :=
675: pqh_rei_shd.g_old_rec.information15;
676: End If;
677: If (p_rec.information16 = hr_api.g_varchar2) then
678: p_rec.information16 :=
679: pqh_rei_shd.g_old_rec.information16;

Line 679: pqh_rei_shd.g_old_rec.information16;

675: pqh_rei_shd.g_old_rec.information15;
676: End If;
677: If (p_rec.information16 = hr_api.g_varchar2) then
678: p_rec.information16 :=
679: pqh_rei_shd.g_old_rec.information16;
680: End If;
681: If (p_rec.information17 = hr_api.g_varchar2) then
682: p_rec.information17 :=
683: pqh_rei_shd.g_old_rec.information17;

Line 683: pqh_rei_shd.g_old_rec.information17;

679: pqh_rei_shd.g_old_rec.information16;
680: End If;
681: If (p_rec.information17 = hr_api.g_varchar2) then
682: p_rec.information17 :=
683: pqh_rei_shd.g_old_rec.information17;
684: End If;
685: If (p_rec.information18 = hr_api.g_varchar2) then
686: p_rec.information18 :=
687: pqh_rei_shd.g_old_rec.information18;

Line 687: pqh_rei_shd.g_old_rec.information18;

683: pqh_rei_shd.g_old_rec.information17;
684: End If;
685: If (p_rec.information18 = hr_api.g_varchar2) then
686: p_rec.information18 :=
687: pqh_rei_shd.g_old_rec.information18;
688: End If;
689: If (p_rec.information19 = hr_api.g_varchar2) then
690: p_rec.information19 :=
691: pqh_rei_shd.g_old_rec.information19;

Line 691: pqh_rei_shd.g_old_rec.information19;

687: pqh_rei_shd.g_old_rec.information18;
688: End If;
689: If (p_rec.information19 = hr_api.g_varchar2) then
690: p_rec.information19 :=
691: pqh_rei_shd.g_old_rec.information19;
692: End If;
693: If (p_rec.information20 = hr_api.g_varchar2) then
694: p_rec.information20 :=
695: pqh_rei_shd.g_old_rec.information20;

Line 695: pqh_rei_shd.g_old_rec.information20;

691: pqh_rei_shd.g_old_rec.information19;
692: End If;
693: If (p_rec.information20 = hr_api.g_varchar2) then
694: p_rec.information20 :=
695: pqh_rei_shd.g_old_rec.information20;
696: End If;
697: If (p_rec.information21 = hr_api.g_varchar2) then
698: p_rec.information21 :=
699: pqh_rei_shd.g_old_rec.information21;

Line 699: pqh_rei_shd.g_old_rec.information21;

695: pqh_rei_shd.g_old_rec.information20;
696: End If;
697: If (p_rec.information21 = hr_api.g_varchar2) then
698: p_rec.information21 :=
699: pqh_rei_shd.g_old_rec.information21;
700: End If;
701: If (p_rec.information22 = hr_api.g_varchar2) then
702: p_rec.information22 :=
703: pqh_rei_shd.g_old_rec.information22;

Line 703: pqh_rei_shd.g_old_rec.information22;

699: pqh_rei_shd.g_old_rec.information21;
700: End If;
701: If (p_rec.information22 = hr_api.g_varchar2) then
702: p_rec.information22 :=
703: pqh_rei_shd.g_old_rec.information22;
704: End If;
705: If (p_rec.information23 = hr_api.g_varchar2) then
706: p_rec.information23 :=
707: pqh_rei_shd.g_old_rec.information23;

Line 707: pqh_rei_shd.g_old_rec.information23;

703: pqh_rei_shd.g_old_rec.information22;
704: End If;
705: If (p_rec.information23 = hr_api.g_varchar2) then
706: p_rec.information23 :=
707: pqh_rei_shd.g_old_rec.information23;
708: End If;
709: If (p_rec.information24 = hr_api.g_varchar2) then
710: p_rec.information24 :=
711: pqh_rei_shd.g_old_rec.information24;

Line 711: pqh_rei_shd.g_old_rec.information24;

707: pqh_rei_shd.g_old_rec.information23;
708: End If;
709: If (p_rec.information24 = hr_api.g_varchar2) then
710: p_rec.information24 :=
711: pqh_rei_shd.g_old_rec.information24;
712: End If;
713: If (p_rec.information25 = hr_api.g_varchar2) then
714: p_rec.information25 :=
715: pqh_rei_shd.g_old_rec.information25;

Line 715: pqh_rei_shd.g_old_rec.information25;

711: pqh_rei_shd.g_old_rec.information24;
712: End If;
713: If (p_rec.information25 = hr_api.g_varchar2) then
714: p_rec.information25 :=
715: pqh_rei_shd.g_old_rec.information25;
716: End If;
717: If (p_rec.information26 = hr_api.g_varchar2) then
718: p_rec.information26 :=
719: pqh_rei_shd.g_old_rec.information26;

Line 719: pqh_rei_shd.g_old_rec.information26;

715: pqh_rei_shd.g_old_rec.information25;
716: End If;
717: If (p_rec.information26 = hr_api.g_varchar2) then
718: p_rec.information26 :=
719: pqh_rei_shd.g_old_rec.information26;
720: End If;
721: If (p_rec.information27 = hr_api.g_varchar2) then
722: p_rec.information27 :=
723: pqh_rei_shd.g_old_rec.information27;

Line 723: pqh_rei_shd.g_old_rec.information27;

719: pqh_rei_shd.g_old_rec.information26;
720: End If;
721: If (p_rec.information27 = hr_api.g_varchar2) then
722: p_rec.information27 :=
723: pqh_rei_shd.g_old_rec.information27;
724: End If;
725: If (p_rec.information28 = hr_api.g_varchar2) then
726: p_rec.information28 :=
727: pqh_rei_shd.g_old_rec.information28;

Line 727: pqh_rei_shd.g_old_rec.information28;

723: pqh_rei_shd.g_old_rec.information27;
724: End If;
725: If (p_rec.information28 = hr_api.g_varchar2) then
726: p_rec.information28 :=
727: pqh_rei_shd.g_old_rec.information28;
728: End If;
729: If (p_rec.information29 = hr_api.g_varchar2) then
730: p_rec.information29 :=
731: pqh_rei_shd.g_old_rec.information29;

Line 731: pqh_rei_shd.g_old_rec.information29;

727: pqh_rei_shd.g_old_rec.information28;
728: End If;
729: If (p_rec.information29 = hr_api.g_varchar2) then
730: p_rec.information29 :=
731: pqh_rei_shd.g_old_rec.information29;
732: End If;
733: If (p_rec.information30 = hr_api.g_varchar2) then
734: p_rec.information30 :=
735: pqh_rei_shd.g_old_rec.information30;

Line 735: pqh_rei_shd.g_old_rec.information30;

731: pqh_rei_shd.g_old_rec.information29;
732: End If;
733: If (p_rec.information30 = hr_api.g_varchar2) then
734: p_rec.information30 :=
735: pqh_rei_shd.g_old_rec.information30;
736: End If;
737: --
738: End convert_defs;
739: --

Line 744: (p_rec in out nocopy pqh_rei_shd.g_rec_type

740: -- ----------------------------------------------------------------------------
741: -- |---------------------------------< upd >----------------------------------|
742: -- ----------------------------------------------------------------------------
743: Procedure upd
744: (p_rec in out nocopy pqh_rei_shd.g_rec_type
745: ,p_validate in boolean
746: ) is
747: --
748: l_proc varchar2(72) := g_package||'upd';

Line 766: pqh_rei_shd.lck

762: --
763: -- We must lock the row which we need to update.
764: --
765:
766: pqh_rei_shd.lck
767: (p_rec.role_extra_info_id
768: ,p_rec.object_version_number
769: );
770: --

Line 891: l_rec pqh_rei_shd.g_rec_type;

887: ,p_information30 in varchar2
888: ,p_validate in boolean
889: ) is
890: --
891: l_rec pqh_rei_shd.g_rec_type;
892: l_proc varchar2(72) := g_package||'upd';
893: --
894: Begin
895: hr_utility.set_location('Entering:'||l_proc, 5);

Line 901: pqh_rei_shd.convert_args

897: -- Call conversion function to turn arguments into the
898: -- l_rec structure.
899: --
900: l_rec :=
901: pqh_rei_shd.convert_args
902: (p_role_extra_info_id
903: ,p_role_id
904: ,p_information_type
905: ,p_request_id