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.PER_PTU_UPD dependencies on PER_PTU_SHD

Line 52: (p_rec in out nocopy per_ptu_shd.g_rec_type,

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure dt_update_dml
52: (p_rec in out nocopy per_ptu_shd.g_rec_type,
53: p_effective_date in date,
54: p_datetrack_mode in varchar2,
55: p_validation_start_date in date,
56: p_validation_end_date in date) is

Line 134: per_ptu_shd.constraint_error

130: hr_utility.set_location(' Leaving:'||l_proc, 15);
131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: per_ptu_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: per_ptu_shd.constraint_error

Line 138: per_ptu_shd.constraint_error

134: per_ptu_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: per_ptu_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
141: Raise;
142: End dt_update_dml;

Line 176: (p_rec in out nocopy per_ptu_shd.g_rec_type,

172: --
173: -- {End Of Comments}
174: -- ----------------------------------------------------------------------------
175: Procedure update_dml
176: (p_rec in out nocopy per_ptu_shd.g_rec_type,
177: p_effective_date in date,
178: p_datetrack_mode in varchar2,
179: p_validation_start_date in date,
180: p_validation_end_date in date) is

Line 240: (p_rec in out nocopy per_ptu_shd.g_rec_type,

236: --
237: -- {End Of Comments}
238: -- ----------------------------------------------------------------------------
239: Procedure dt_pre_update
240: (p_rec in out nocopy per_ptu_shd.g_rec_type,
241: p_effective_date in date,
242: p_datetrack_mode in varchar2,
243: p_validation_start_date in date,
244: p_validation_end_date in date) is

Line 256: per_ptu_shd.upd_effective_end_date

252: hr_utility.set_location(l_proc, 10);
253: --
254: -- Update the current effective end date
255: --
256: per_ptu_shd.upd_effective_end_date
257: (p_effective_date => p_effective_date,
258: p_base_key_value => p_rec.person_type_usage_id,
259: p_new_effective_end_date => (p_validation_start_date - 1),
260: p_validation_start_date => p_validation_start_date,

Line 325: (p_rec in out nocopy per_ptu_shd.g_rec_type,

321: --
322: -- {End Of Comments}
323: -- ----------------------------------------------------------------------------
324: Procedure pre_update
325: (p_rec in out nocopy per_ptu_shd.g_rec_type,
326: p_effective_date in date,
327: p_datetrack_mode in varchar2,
328: p_validation_start_date in date,
329: p_validation_end_date in date) is

Line 381: (p_rec in per_ptu_shd.g_rec_type,

377: --
378: -- {End Of Comments}
379: -- ----------------------------------------------------------------------------
380: Procedure post_update
381: (p_rec in per_ptu_shd.g_rec_type,
382: p_effective_date in date,
383: p_datetrack_mode in varchar2,
384: p_validation_start_date in date,
385: p_validation_end_date in date) is

Line 449: ,p_person_id_o => per_ptu_shd.g_old_rec.person_id,

445: ,p_effective_date => p_effective_date
446: ,p_validation_start_date => p_validation_start_date
447: ,p_validation_end_date => p_validation_end_date
448: ,p_datetrack_mode => p_datetrack_mode
449: ,p_person_id_o => per_ptu_shd.g_old_rec.person_id,
450: p_person_type_id_o => per_ptu_shd.g_old_rec.person_type_id,
451: p_effective_start_date_o
452: => per_ptu_shd.g_old_rec.effective_start_date,
453: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,

Line 450: p_person_type_id_o => per_ptu_shd.g_old_rec.person_type_id,

446: ,p_validation_start_date => p_validation_start_date
447: ,p_validation_end_date => p_validation_end_date
448: ,p_datetrack_mode => p_datetrack_mode
449: ,p_person_id_o => per_ptu_shd.g_old_rec.person_id,
450: p_person_type_id_o => per_ptu_shd.g_old_rec.person_type_id,
451: p_effective_start_date_o
452: => per_ptu_shd.g_old_rec.effective_start_date,
453: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,
454: p_object_version_number_o

Line 452: => per_ptu_shd.g_old_rec.effective_start_date,

448: ,p_datetrack_mode => p_datetrack_mode
449: ,p_person_id_o => per_ptu_shd.g_old_rec.person_id,
450: p_person_type_id_o => per_ptu_shd.g_old_rec.person_type_id,
451: p_effective_start_date_o
452: => per_ptu_shd.g_old_rec.effective_start_date,
453: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,
454: p_object_version_number_o
455: => per_ptu_shd.g_old_rec.object_version_number,
456: p_request_id_o => per_ptu_shd.g_old_rec.request_id,

Line 453: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,

449: ,p_person_id_o => per_ptu_shd.g_old_rec.person_id,
450: p_person_type_id_o => per_ptu_shd.g_old_rec.person_type_id,
451: p_effective_start_date_o
452: => per_ptu_shd.g_old_rec.effective_start_date,
453: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,
454: p_object_version_number_o
455: => per_ptu_shd.g_old_rec.object_version_number,
456: p_request_id_o => per_ptu_shd.g_old_rec.request_id,
457: p_program_application_id_o

Line 455: => per_ptu_shd.g_old_rec.object_version_number,

451: p_effective_start_date_o
452: => per_ptu_shd.g_old_rec.effective_start_date,
453: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,
454: p_object_version_number_o
455: => per_ptu_shd.g_old_rec.object_version_number,
456: p_request_id_o => per_ptu_shd.g_old_rec.request_id,
457: p_program_application_id_o
458: => per_ptu_shd.g_old_rec.program_application_id,
459: p_program_id_o => per_ptu_shd.g_old_rec.program_id,

Line 456: p_request_id_o => per_ptu_shd.g_old_rec.request_id,

452: => per_ptu_shd.g_old_rec.effective_start_date,
453: p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,
454: p_object_version_number_o
455: => per_ptu_shd.g_old_rec.object_version_number,
456: p_request_id_o => per_ptu_shd.g_old_rec.request_id,
457: p_program_application_id_o
458: => per_ptu_shd.g_old_rec.program_application_id,
459: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
460: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date

Line 458: => per_ptu_shd.g_old_rec.program_application_id,

454: p_object_version_number_o
455: => per_ptu_shd.g_old_rec.object_version_number,
456: p_request_id_o => per_ptu_shd.g_old_rec.request_id,
457: p_program_application_id_o
458: => per_ptu_shd.g_old_rec.program_application_id,
459: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
460: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
461: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
462: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1

Line 459: p_program_id_o => per_ptu_shd.g_old_rec.program_id,

455: => per_ptu_shd.g_old_rec.object_version_number,
456: p_request_id_o => per_ptu_shd.g_old_rec.request_id,
457: p_program_application_id_o
458: => per_ptu_shd.g_old_rec.program_application_id,
459: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
460: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
461: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
462: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
463: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2

Line 460: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date

456: p_request_id_o => per_ptu_shd.g_old_rec.request_id,
457: p_program_application_id_o
458: => per_ptu_shd.g_old_rec.program_application_id,
459: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
460: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
461: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
462: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
463: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
464: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3

Line 461: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category

457: p_program_application_id_o
458: => per_ptu_shd.g_old_rec.program_application_id,
459: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
460: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
461: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
462: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
463: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
464: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
465: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4

Line 462: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1

458: => per_ptu_shd.g_old_rec.program_application_id,
459: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
460: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
461: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
462: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
463: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
464: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
465: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
466: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5

Line 463: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2

459: p_program_id_o => per_ptu_shd.g_old_rec.program_id,
460: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
461: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
462: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
463: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
464: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
465: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
466: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
467: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6

Line 464: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3

460: p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
461: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
462: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
463: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
464: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
465: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
466: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
467: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
468: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7

Line 465: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4

461: ,p_attribute_category_o => per_ptu_shd.g_old_rec.attribute_category
462: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
463: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
464: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
465: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
466: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
467: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
468: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
469: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8

Line 466: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5

462: ,p_attribute1_o => per_ptu_shd.g_old_rec.attribute1
463: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
464: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
465: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
466: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
467: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
468: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
469: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
470: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9

Line 467: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6

463: ,p_attribute2_o => per_ptu_shd.g_old_rec.attribute2
464: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
465: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
466: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
467: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
468: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
469: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
470: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
471: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10

Line 468: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7

464: ,p_attribute3_o => per_ptu_shd.g_old_rec.attribute3
465: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
466: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
467: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
468: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
469: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
470: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
471: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
472: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11

Line 469: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8

465: ,p_attribute4_o => per_ptu_shd.g_old_rec.attribute4
466: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
467: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
468: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
469: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
470: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
471: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
472: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
473: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12

Line 470: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9

466: ,p_attribute5_o => per_ptu_shd.g_old_rec.attribute5
467: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
468: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
469: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
470: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
471: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
472: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
473: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
474: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13

Line 471: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10

467: ,p_attribute6_o => per_ptu_shd.g_old_rec.attribute6
468: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
469: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
470: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
471: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
472: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
473: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
474: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
475: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14

Line 472: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11

468: ,p_attribute7_o => per_ptu_shd.g_old_rec.attribute7
469: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
470: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
471: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
472: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
473: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
474: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
475: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
476: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15

Line 473: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12

469: ,p_attribute8_o => per_ptu_shd.g_old_rec.attribute8
470: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
471: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
472: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
473: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
474: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
475: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
476: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
477: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16

Line 474: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13

470: ,p_attribute9_o => per_ptu_shd.g_old_rec.attribute9
471: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
472: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
473: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
474: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
475: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
476: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
477: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
478: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17

Line 475: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14

471: ,p_attribute10_o => per_ptu_shd.g_old_rec.attribute10
472: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
473: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
474: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
475: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
476: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
477: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
478: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
479: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18

Line 476: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15

472: ,p_attribute11_o => per_ptu_shd.g_old_rec.attribute11
473: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
474: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
475: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
476: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
477: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
478: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
479: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
480: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19

Line 477: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16

473: ,p_attribute12_o => per_ptu_shd.g_old_rec.attribute12
474: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
475: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
476: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
477: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
478: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
479: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
480: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
481: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20

Line 478: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17

474: ,p_attribute13_o => per_ptu_shd.g_old_rec.attribute13
475: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
476: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
477: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
478: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
479: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
480: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
481: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
482: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21

Line 479: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18

475: ,p_attribute14_o => per_ptu_shd.g_old_rec.attribute14
476: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
477: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
478: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
479: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
480: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
481: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
482: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
483: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22

Line 480: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19

476: ,p_attribute15_o => per_ptu_shd.g_old_rec.attribute15
477: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
478: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
479: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
480: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
481: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
482: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
483: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
484: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23

Line 481: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20

477: ,p_attribute16_o => per_ptu_shd.g_old_rec.attribute16
478: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
479: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
480: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
481: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
482: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
483: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
484: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
485: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24

Line 482: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21

478: ,p_attribute17_o => per_ptu_shd.g_old_rec.attribute17
479: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
480: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
481: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
482: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
483: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
484: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
485: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
486: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25

Line 483: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22

479: ,p_attribute18_o => per_ptu_shd.g_old_rec.attribute18
480: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
481: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
482: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
483: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
484: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
485: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
486: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
487: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26

Line 484: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23

480: ,p_attribute19_o => per_ptu_shd.g_old_rec.attribute19
481: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
482: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
483: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
484: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
485: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
486: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
487: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
488: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27

Line 485: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24

481: ,p_attribute20_o => per_ptu_shd.g_old_rec.attribute20
482: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
483: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
484: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
485: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
486: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
487: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
488: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
489: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28

Line 486: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25

482: ,p_attribute21_o => per_ptu_shd.g_old_rec.attribute21
483: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
484: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
485: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
486: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
487: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
488: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
489: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28
490: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29

Line 487: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26

483: ,p_attribute22_o => per_ptu_shd.g_old_rec.attribute22
484: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
485: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
486: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
487: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
488: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
489: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28
490: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29
491: ,p_attribute30_o => per_ptu_shd.g_old_rec.attribute30

Line 488: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27

484: ,p_attribute23_o => per_ptu_shd.g_old_rec.attribute23
485: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
486: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
487: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
488: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
489: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28
490: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29
491: ,p_attribute30_o => per_ptu_shd.g_old_rec.attribute30
492: );

Line 489: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28

485: ,p_attribute24_o => per_ptu_shd.g_old_rec.attribute24
486: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
487: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
488: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
489: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28
490: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29
491: ,p_attribute30_o => per_ptu_shd.g_old_rec.attribute30
492: );
493: exception

Line 490: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29

486: ,p_attribute25_o => per_ptu_shd.g_old_rec.attribute25
487: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
488: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
489: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28
490: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29
491: ,p_attribute30_o => per_ptu_shd.g_old_rec.attribute30
492: );
493: exception
494: when hr_api.cannot_find_prog_unit then

Line 491: ,p_attribute30_o => per_ptu_shd.g_old_rec.attribute30

487: ,p_attribute26_o => per_ptu_shd.g_old_rec.attribute26
488: ,p_attribute27_o => per_ptu_shd.g_old_rec.attribute27
489: ,p_attribute28_o => per_ptu_shd.g_old_rec.attribute28
490: ,p_attribute29_o => per_ptu_shd.g_old_rec.attribute29
491: ,p_attribute30_o => per_ptu_shd.g_old_rec.attribute30
492: );
493: exception
494: when hr_api.cannot_find_prog_unit then
495: hr_api.cannot_find_prog_unit_error

Line 503: l_old.person_type_usage_id := per_ptu_shd.g_old_rec.person_type_usage_id;

499: end;
500: --
501: -- Start of Fix for WWBUG 1408379
502: --
503: l_old.person_type_usage_id := per_ptu_shd.g_old_rec.person_type_usage_id;
504: l_old.person_id := per_ptu_shd.g_old_rec.person_id;
505: l_old.person_type_id := per_ptu_shd.g_old_rec.person_type_id;
506: l_old.effective_start_date := per_ptu_shd.g_old_rec.effective_start_date;
507: l_old.effective_end_date := per_ptu_shd.g_old_rec.effective_end_date;

Line 504: l_old.person_id := per_ptu_shd.g_old_rec.person_id;

500: --
501: -- Start of Fix for WWBUG 1408379
502: --
503: l_old.person_type_usage_id := per_ptu_shd.g_old_rec.person_type_usage_id;
504: l_old.person_id := per_ptu_shd.g_old_rec.person_id;
505: l_old.person_type_id := per_ptu_shd.g_old_rec.person_type_id;
506: l_old.effective_start_date := per_ptu_shd.g_old_rec.effective_start_date;
507: l_old.effective_end_date := per_ptu_shd.g_old_rec.effective_end_date;
508: l_new.person_type_usage_id := p_rec.person_type_usage_id;

Line 505: l_old.person_type_id := per_ptu_shd.g_old_rec.person_type_id;

501: -- Start of Fix for WWBUG 1408379
502: --
503: l_old.person_type_usage_id := per_ptu_shd.g_old_rec.person_type_usage_id;
504: l_old.person_id := per_ptu_shd.g_old_rec.person_id;
505: l_old.person_type_id := per_ptu_shd.g_old_rec.person_type_id;
506: l_old.effective_start_date := per_ptu_shd.g_old_rec.effective_start_date;
507: l_old.effective_end_date := per_ptu_shd.g_old_rec.effective_end_date;
508: l_new.person_type_usage_id := p_rec.person_type_usage_id;
509: l_new.person_id := p_rec.person_id;

Line 506: l_old.effective_start_date := per_ptu_shd.g_old_rec.effective_start_date;

502: --
503: l_old.person_type_usage_id := per_ptu_shd.g_old_rec.person_type_usage_id;
504: l_old.person_id := per_ptu_shd.g_old_rec.person_id;
505: l_old.person_type_id := per_ptu_shd.g_old_rec.person_type_id;
506: l_old.effective_start_date := per_ptu_shd.g_old_rec.effective_start_date;
507: l_old.effective_end_date := per_ptu_shd.g_old_rec.effective_end_date;
508: l_new.person_type_usage_id := p_rec.person_type_usage_id;
509: l_new.person_id := p_rec.person_id;
510: l_new.person_type_id := p_rec.person_type_id;

Line 507: l_old.effective_end_date := per_ptu_shd.g_old_rec.effective_end_date;

503: l_old.person_type_usage_id := per_ptu_shd.g_old_rec.person_type_usage_id;
504: l_old.person_id := per_ptu_shd.g_old_rec.person_id;
505: l_old.person_type_id := per_ptu_shd.g_old_rec.person_type_id;
506: l_old.effective_start_date := per_ptu_shd.g_old_rec.effective_start_date;
507: l_old.effective_end_date := per_ptu_shd.g_old_rec.effective_end_date;
508: l_new.person_type_usage_id := p_rec.person_type_usage_id;
509: l_new.person_id := p_rec.person_id;
510: l_new.person_type_id := p_rec.person_type_id;
511: l_new.effective_start_date := p_rec.effective_start_date;

Line 568: Procedure convert_defs(p_rec in out nocopy per_ptu_shd.g_rec_type) is

564: -- Internal Row Handler Use Only.
565: --
566: -- {End Of Comments}
567: -- ----------------------------------------------------------------------------
568: Procedure convert_defs(p_rec in out nocopy per_ptu_shd.g_rec_type) is
569: --
570: l_proc varchar2(72) := g_package||'convert_defs';
571: --
572: Begin

Line 583: per_ptu_shd.g_old_rec.person_id;

579: -- is being used then we must set to the 'current' argument value.
580: --
581: If (p_rec.person_id = hr_api.g_number) then
582: p_rec.person_id :=
583: per_ptu_shd.g_old_rec.person_id;
584: End If;
585: If (p_rec.person_type_id = hr_api.g_number) then
586: p_rec.person_type_id :=
587: per_ptu_shd.g_old_rec.person_type_id;

Line 587: per_ptu_shd.g_old_rec.person_type_id;

583: per_ptu_shd.g_old_rec.person_id;
584: End If;
585: If (p_rec.person_type_id = hr_api.g_number) then
586: p_rec.person_type_id :=
587: per_ptu_shd.g_old_rec.person_type_id;
588: End If;
589: If (p_rec.request_id = hr_api.g_number) then
590: p_rec.request_id :=
591: per_ptu_shd.g_old_rec.request_id;

Line 591: per_ptu_shd.g_old_rec.request_id;

587: per_ptu_shd.g_old_rec.person_type_id;
588: End If;
589: If (p_rec.request_id = hr_api.g_number) then
590: p_rec.request_id :=
591: per_ptu_shd.g_old_rec.request_id;
592: End If;
593: If (p_rec.program_application_id = hr_api.g_number) then
594: p_rec.program_application_id :=
595: per_ptu_shd.g_old_rec.program_application_id;

Line 595: per_ptu_shd.g_old_rec.program_application_id;

591: per_ptu_shd.g_old_rec.request_id;
592: End If;
593: If (p_rec.program_application_id = hr_api.g_number) then
594: p_rec.program_application_id :=
595: per_ptu_shd.g_old_rec.program_application_id;
596: End If;
597: If (p_rec.program_id = hr_api.g_number) then
598: p_rec.program_id :=
599: per_ptu_shd.g_old_rec.program_id;

Line 599: per_ptu_shd.g_old_rec.program_id;

595: per_ptu_shd.g_old_rec.program_application_id;
596: End If;
597: If (p_rec.program_id = hr_api.g_number) then
598: p_rec.program_id :=
599: per_ptu_shd.g_old_rec.program_id;
600: End If;
601: If (p_rec.program_update_date = hr_api.g_date) then
602: p_rec.program_update_date :=
603: per_ptu_shd.g_old_rec.program_update_date;

Line 603: per_ptu_shd.g_old_rec.program_update_date;

599: per_ptu_shd.g_old_rec.program_id;
600: End If;
601: If (p_rec.program_update_date = hr_api.g_date) then
602: p_rec.program_update_date :=
603: per_ptu_shd.g_old_rec.program_update_date;
604: End If;
605: If (p_rec.attribute_category = hr_api.g_varchar2) then
606: p_rec.attribute_category :=
607: per_ptu_shd.g_old_rec.attribute_category;

Line 607: per_ptu_shd.g_old_rec.attribute_category;

603: per_ptu_shd.g_old_rec.program_update_date;
604: End If;
605: If (p_rec.attribute_category = hr_api.g_varchar2) then
606: p_rec.attribute_category :=
607: per_ptu_shd.g_old_rec.attribute_category;
608: End If;
609: If (p_rec.attribute1 = hr_api.g_varchar2) then
610: p_rec.attribute1 :=
611: per_ptu_shd.g_old_rec.attribute1;

Line 611: per_ptu_shd.g_old_rec.attribute1;

607: per_ptu_shd.g_old_rec.attribute_category;
608: End If;
609: If (p_rec.attribute1 = hr_api.g_varchar2) then
610: p_rec.attribute1 :=
611: per_ptu_shd.g_old_rec.attribute1;
612: End If;
613: If (p_rec.attribute2 = hr_api.g_varchar2) then
614: p_rec.attribute2 :=
615: per_ptu_shd.g_old_rec.attribute2;

Line 615: per_ptu_shd.g_old_rec.attribute2;

611: per_ptu_shd.g_old_rec.attribute1;
612: End If;
613: If (p_rec.attribute2 = hr_api.g_varchar2) then
614: p_rec.attribute2 :=
615: per_ptu_shd.g_old_rec.attribute2;
616: End If;
617: If (p_rec.attribute3 = hr_api.g_varchar2) then
618: p_rec.attribute3 :=
619: per_ptu_shd.g_old_rec.attribute3;

Line 619: per_ptu_shd.g_old_rec.attribute3;

615: per_ptu_shd.g_old_rec.attribute2;
616: End If;
617: If (p_rec.attribute3 = hr_api.g_varchar2) then
618: p_rec.attribute3 :=
619: per_ptu_shd.g_old_rec.attribute3;
620: End If;
621: If (p_rec.attribute4 = hr_api.g_varchar2) then
622: p_rec.attribute4 :=
623: per_ptu_shd.g_old_rec.attribute4;

Line 623: per_ptu_shd.g_old_rec.attribute4;

619: per_ptu_shd.g_old_rec.attribute3;
620: End If;
621: If (p_rec.attribute4 = hr_api.g_varchar2) then
622: p_rec.attribute4 :=
623: per_ptu_shd.g_old_rec.attribute4;
624: End If;
625: If (p_rec.attribute5 = hr_api.g_varchar2) then
626: p_rec.attribute5 :=
627: per_ptu_shd.g_old_rec.attribute5;

Line 627: per_ptu_shd.g_old_rec.attribute5;

623: per_ptu_shd.g_old_rec.attribute4;
624: End If;
625: If (p_rec.attribute5 = hr_api.g_varchar2) then
626: p_rec.attribute5 :=
627: per_ptu_shd.g_old_rec.attribute5;
628: End If;
629: If (p_rec.attribute6 = hr_api.g_varchar2) then
630: p_rec.attribute6 :=
631: per_ptu_shd.g_old_rec.attribute6;

Line 631: per_ptu_shd.g_old_rec.attribute6;

627: per_ptu_shd.g_old_rec.attribute5;
628: End If;
629: If (p_rec.attribute6 = hr_api.g_varchar2) then
630: p_rec.attribute6 :=
631: per_ptu_shd.g_old_rec.attribute6;
632: End If;
633: If (p_rec.attribute7 = hr_api.g_varchar2) then
634: p_rec.attribute7 :=
635: per_ptu_shd.g_old_rec.attribute7;

Line 635: per_ptu_shd.g_old_rec.attribute7;

631: per_ptu_shd.g_old_rec.attribute6;
632: End If;
633: If (p_rec.attribute7 = hr_api.g_varchar2) then
634: p_rec.attribute7 :=
635: per_ptu_shd.g_old_rec.attribute7;
636: End If;
637: If (p_rec.attribute8 = hr_api.g_varchar2) then
638: p_rec.attribute8 :=
639: per_ptu_shd.g_old_rec.attribute8;

Line 639: per_ptu_shd.g_old_rec.attribute8;

635: per_ptu_shd.g_old_rec.attribute7;
636: End If;
637: If (p_rec.attribute8 = hr_api.g_varchar2) then
638: p_rec.attribute8 :=
639: per_ptu_shd.g_old_rec.attribute8;
640: End If;
641: If (p_rec.attribute9 = hr_api.g_varchar2) then
642: p_rec.attribute9 :=
643: per_ptu_shd.g_old_rec.attribute9;

Line 643: per_ptu_shd.g_old_rec.attribute9;

639: per_ptu_shd.g_old_rec.attribute8;
640: End If;
641: If (p_rec.attribute9 = hr_api.g_varchar2) then
642: p_rec.attribute9 :=
643: per_ptu_shd.g_old_rec.attribute9;
644: End If;
645: If (p_rec.attribute10 = hr_api.g_varchar2) then
646: p_rec.attribute10 :=
647: per_ptu_shd.g_old_rec.attribute10;

Line 647: per_ptu_shd.g_old_rec.attribute10;

643: per_ptu_shd.g_old_rec.attribute9;
644: End If;
645: If (p_rec.attribute10 = hr_api.g_varchar2) then
646: p_rec.attribute10 :=
647: per_ptu_shd.g_old_rec.attribute10;
648: End If;
649: If (p_rec.attribute11 = hr_api.g_varchar2) then
650: p_rec.attribute11 :=
651: per_ptu_shd.g_old_rec.attribute11;

Line 651: per_ptu_shd.g_old_rec.attribute11;

647: per_ptu_shd.g_old_rec.attribute10;
648: End If;
649: If (p_rec.attribute11 = hr_api.g_varchar2) then
650: p_rec.attribute11 :=
651: per_ptu_shd.g_old_rec.attribute11;
652: End If;
653: If (p_rec.attribute12 = hr_api.g_varchar2) then
654: p_rec.attribute12 :=
655: per_ptu_shd.g_old_rec.attribute12;

Line 655: per_ptu_shd.g_old_rec.attribute12;

651: per_ptu_shd.g_old_rec.attribute11;
652: End If;
653: If (p_rec.attribute12 = hr_api.g_varchar2) then
654: p_rec.attribute12 :=
655: per_ptu_shd.g_old_rec.attribute12;
656: End If;
657: If (p_rec.attribute13 = hr_api.g_varchar2) then
658: p_rec.attribute13 :=
659: per_ptu_shd.g_old_rec.attribute13;

Line 659: per_ptu_shd.g_old_rec.attribute13;

655: per_ptu_shd.g_old_rec.attribute12;
656: End If;
657: If (p_rec.attribute13 = hr_api.g_varchar2) then
658: p_rec.attribute13 :=
659: per_ptu_shd.g_old_rec.attribute13;
660: End If;
661: If (p_rec.attribute14 = hr_api.g_varchar2) then
662: p_rec.attribute14 :=
663: per_ptu_shd.g_old_rec.attribute14;

Line 663: per_ptu_shd.g_old_rec.attribute14;

659: per_ptu_shd.g_old_rec.attribute13;
660: End If;
661: If (p_rec.attribute14 = hr_api.g_varchar2) then
662: p_rec.attribute14 :=
663: per_ptu_shd.g_old_rec.attribute14;
664: End If;
665: If (p_rec.attribute15 = hr_api.g_varchar2) then
666: p_rec.attribute15 :=
667: per_ptu_shd.g_old_rec.attribute15;

Line 667: per_ptu_shd.g_old_rec.attribute15;

663: per_ptu_shd.g_old_rec.attribute14;
664: End If;
665: If (p_rec.attribute15 = hr_api.g_varchar2) then
666: p_rec.attribute15 :=
667: per_ptu_shd.g_old_rec.attribute15;
668: End If;
669: If (p_rec.attribute16 = hr_api.g_varchar2) then
670: p_rec.attribute16 :=
671: per_ptu_shd.g_old_rec.attribute16;

Line 671: per_ptu_shd.g_old_rec.attribute16;

667: per_ptu_shd.g_old_rec.attribute15;
668: End If;
669: If (p_rec.attribute16 = hr_api.g_varchar2) then
670: p_rec.attribute16 :=
671: per_ptu_shd.g_old_rec.attribute16;
672: End If;
673: If (p_rec.attribute17 = hr_api.g_varchar2) then
674: p_rec.attribute17 :=
675: per_ptu_shd.g_old_rec.attribute17;

Line 675: per_ptu_shd.g_old_rec.attribute17;

671: per_ptu_shd.g_old_rec.attribute16;
672: End If;
673: If (p_rec.attribute17 = hr_api.g_varchar2) then
674: p_rec.attribute17 :=
675: per_ptu_shd.g_old_rec.attribute17;
676: End If;
677: If (p_rec.attribute18 = hr_api.g_varchar2) then
678: p_rec.attribute18 :=
679: per_ptu_shd.g_old_rec.attribute18;

Line 679: per_ptu_shd.g_old_rec.attribute18;

675: per_ptu_shd.g_old_rec.attribute17;
676: End If;
677: If (p_rec.attribute18 = hr_api.g_varchar2) then
678: p_rec.attribute18 :=
679: per_ptu_shd.g_old_rec.attribute18;
680: End If;
681: If (p_rec.attribute19 = hr_api.g_varchar2) then
682: p_rec.attribute19 :=
683: per_ptu_shd.g_old_rec.attribute19;

Line 683: per_ptu_shd.g_old_rec.attribute19;

679: per_ptu_shd.g_old_rec.attribute18;
680: End If;
681: If (p_rec.attribute19 = hr_api.g_varchar2) then
682: p_rec.attribute19 :=
683: per_ptu_shd.g_old_rec.attribute19;
684: End If;
685: If (p_rec.attribute20 = hr_api.g_varchar2) then
686: p_rec.attribute20 :=
687: per_ptu_shd.g_old_rec.attribute20;

Line 687: per_ptu_shd.g_old_rec.attribute20;

683: per_ptu_shd.g_old_rec.attribute19;
684: End If;
685: If (p_rec.attribute20 = hr_api.g_varchar2) then
686: p_rec.attribute20 :=
687: per_ptu_shd.g_old_rec.attribute20;
688: End If;
689: If (p_rec.attribute21 = hr_api.g_varchar2) then
690: p_rec.attribute21 :=
691: per_ptu_shd.g_old_rec.attribute21;

Line 691: per_ptu_shd.g_old_rec.attribute21;

687: per_ptu_shd.g_old_rec.attribute20;
688: End If;
689: If (p_rec.attribute21 = hr_api.g_varchar2) then
690: p_rec.attribute21 :=
691: per_ptu_shd.g_old_rec.attribute21;
692: End If;
693: If (p_rec.attribute22 = hr_api.g_varchar2) then
694: p_rec.attribute22 :=
695: per_ptu_shd.g_old_rec.attribute22;

Line 695: per_ptu_shd.g_old_rec.attribute22;

691: per_ptu_shd.g_old_rec.attribute21;
692: End If;
693: If (p_rec.attribute22 = hr_api.g_varchar2) then
694: p_rec.attribute22 :=
695: per_ptu_shd.g_old_rec.attribute22;
696: End If;
697: If (p_rec.attribute23 = hr_api.g_varchar2) then
698: p_rec.attribute23 :=
699: per_ptu_shd.g_old_rec.attribute23;

Line 699: per_ptu_shd.g_old_rec.attribute23;

695: per_ptu_shd.g_old_rec.attribute22;
696: End If;
697: If (p_rec.attribute23 = hr_api.g_varchar2) then
698: p_rec.attribute23 :=
699: per_ptu_shd.g_old_rec.attribute23;
700: End If;
701: If (p_rec.attribute24 = hr_api.g_varchar2) then
702: p_rec.attribute24 :=
703: per_ptu_shd.g_old_rec.attribute24;

Line 703: per_ptu_shd.g_old_rec.attribute24;

699: per_ptu_shd.g_old_rec.attribute23;
700: End If;
701: If (p_rec.attribute24 = hr_api.g_varchar2) then
702: p_rec.attribute24 :=
703: per_ptu_shd.g_old_rec.attribute24;
704: End If;
705: If (p_rec.attribute25 = hr_api.g_varchar2) then
706: p_rec.attribute25 :=
707: per_ptu_shd.g_old_rec.attribute25;

Line 707: per_ptu_shd.g_old_rec.attribute25;

703: per_ptu_shd.g_old_rec.attribute24;
704: End If;
705: If (p_rec.attribute25 = hr_api.g_varchar2) then
706: p_rec.attribute25 :=
707: per_ptu_shd.g_old_rec.attribute25;
708: End If;
709: If (p_rec.attribute26 = hr_api.g_varchar2) then
710: p_rec.attribute26 :=
711: per_ptu_shd.g_old_rec.attribute26;

Line 711: per_ptu_shd.g_old_rec.attribute26;

707: per_ptu_shd.g_old_rec.attribute25;
708: End If;
709: If (p_rec.attribute26 = hr_api.g_varchar2) then
710: p_rec.attribute26 :=
711: per_ptu_shd.g_old_rec.attribute26;
712: End If;
713: If (p_rec.attribute27 = hr_api.g_varchar2) then
714: p_rec.attribute27 :=
715: per_ptu_shd.g_old_rec.attribute27;

Line 715: per_ptu_shd.g_old_rec.attribute27;

711: per_ptu_shd.g_old_rec.attribute26;
712: End If;
713: If (p_rec.attribute27 = hr_api.g_varchar2) then
714: p_rec.attribute27 :=
715: per_ptu_shd.g_old_rec.attribute27;
716: End If;
717: If (p_rec.attribute28 = hr_api.g_varchar2) then
718: p_rec.attribute28 :=
719: per_ptu_shd.g_old_rec.attribute28;

Line 719: per_ptu_shd.g_old_rec.attribute28;

715: per_ptu_shd.g_old_rec.attribute27;
716: End If;
717: If (p_rec.attribute28 = hr_api.g_varchar2) then
718: p_rec.attribute28 :=
719: per_ptu_shd.g_old_rec.attribute28;
720: End If;
721: If (p_rec.attribute29 = hr_api.g_varchar2) then
722: p_rec.attribute29 :=
723: per_ptu_shd.g_old_rec.attribute29;

Line 723: per_ptu_shd.g_old_rec.attribute29;

719: per_ptu_shd.g_old_rec.attribute28;
720: End If;
721: If (p_rec.attribute29 = hr_api.g_varchar2) then
722: p_rec.attribute29 :=
723: per_ptu_shd.g_old_rec.attribute29;
724: End If;
725: If (p_rec.attribute30 = hr_api.g_varchar2) then
726: p_rec.attribute30 :=
727: per_ptu_shd.g_old_rec.attribute30;

Line 727: per_ptu_shd.g_old_rec.attribute30;

723: per_ptu_shd.g_old_rec.attribute29;
724: End If;
725: If (p_rec.attribute30 = hr_api.g_varchar2) then
726: p_rec.attribute30 :=
727: per_ptu_shd.g_old_rec.attribute30;
728: End If;
729: --
730: hr_utility.set_location(' Leaving:'||l_proc, 10);
731: --

Line 739: p_rec in out nocopy per_ptu_shd.g_rec_type,

735: -- |---------------------------------< upd >----------------------------------|
736: -- ----------------------------------------------------------------------------
737: Procedure upd
738: (
739: p_rec in out nocopy per_ptu_shd.g_rec_type,
740: p_effective_date in date,
741: p_datetrack_mode in varchar2
742: ) is
743: --

Line 757: per_ptu_shd.lck

753: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
754: --
755: -- We must lock the row which we need to update.
756: --
757: per_ptu_shd.lck
758: (p_effective_date => p_effective_date,
759: p_datetrack_mode => p_datetrack_mode,
760: p_person_type_usage_id => p_rec.person_type_usage_id,
761: p_object_version_number => p_rec.object_version_number,

Line 856: l_rec per_ptu_shd.g_rec_type;

852: p_effective_date in date,
853: p_datetrack_mode in varchar2
854: ) is
855: --
856: l_rec per_ptu_shd.g_rec_type;
857: l_proc varchar2(72) := g_package||'upd';
858: --
859: Begin
860: hr_utility.set_location('Entering:'||l_proc, 5);

Line 866: per_ptu_shd.convert_args

862: -- Call conversion function to turn arguments into the
863: -- l_rec structure.
864: --
865: l_rec :=
866: per_ptu_shd.convert_args
867: (
868: p_person_type_usage_id,
869: hr_api.g_number,
870: p_person_type_id,