DBA Data[Home] [Help]

APPS.PER_ECA_UPD dependencies on PER_ECA_SHD

Line 55: (p_rec in out nocopy per_eca_shd.g_rec_type

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

Line 162: per_eca_shd.constraint_error

158: Exception
159: When hr_api.check_integrity_violated Then
160: -- A check constraint has been violated
161: --
162: per_eca_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.parent_integrity_violated Then
165: -- Parent integrity has been violated
166: --

Line 167: per_eca_shd.constraint_error

163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.parent_integrity_violated Then
165: -- Parent integrity has been violated
166: --
167: per_eca_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When hr_api.unique_integrity_violated Then
170: -- Unique integrity has been violated
171: --

Line 172: per_eca_shd.constraint_error

168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When hr_api.unique_integrity_violated Then
170: -- Unique integrity has been violated
171: --
172: per_eca_shd.constraint_error
173: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
174: When Others Then
175: --
176: Raise;

Line 212: (p_rec in per_eca_shd.g_rec_type

208: --
209: -- {End Of Comments}
210: -- ----------------------------------------------------------------------------
211: Procedure pre_update
212: (p_rec in per_eca_shd.g_rec_type
213: ) is
214: --
215: l_proc varchar2(72) := g_package||'pre_update';
216: --

Line 256: (p_rec in per_eca_shd.g_rec_type

252: --
253: -- {End Of Comments}
254: -- ----------------------------------------------------------------------------
255: Procedure post_update
256: (p_rec in per_eca_shd.g_rec_type
257: ) is
258: --
259: l_proc varchar2(72) := g_package||'post_update';
260: --

Line 405: => per_eca_shd.g_old_rec.business_group_id

401: => p_rec.candidate_information30
402: ,p_object_version_number
403: => p_rec.object_version_number
404: ,p_business_group_id_o
405: => per_eca_shd.g_old_rec.business_group_id
406: ,p_election_id_o
407: => per_eca_shd.g_old_rec.election_id
408: ,p_person_id_o
409: => per_eca_shd.g_old_rec.person_id

Line 407: => per_eca_shd.g_old_rec.election_id

403: => p_rec.object_version_number
404: ,p_business_group_id_o
405: => per_eca_shd.g_old_rec.business_group_id
406: ,p_election_id_o
407: => per_eca_shd.g_old_rec.election_id
408: ,p_person_id_o
409: => per_eca_shd.g_old_rec.person_id
410: ,p_rank_o
411: => per_eca_shd.g_old_rec.rank

Line 409: => per_eca_shd.g_old_rec.person_id

405: => per_eca_shd.g_old_rec.business_group_id
406: ,p_election_id_o
407: => per_eca_shd.g_old_rec.election_id
408: ,p_person_id_o
409: => per_eca_shd.g_old_rec.person_id
410: ,p_rank_o
411: => per_eca_shd.g_old_rec.rank
412: ,p_role_id_o
413: => per_eca_shd.g_old_rec.role_id

Line 411: => per_eca_shd.g_old_rec.rank

407: => per_eca_shd.g_old_rec.election_id
408: ,p_person_id_o
409: => per_eca_shd.g_old_rec.person_id
410: ,p_rank_o
411: => per_eca_shd.g_old_rec.rank
412: ,p_role_id_o
413: => per_eca_shd.g_old_rec.role_id
414: ,p_attribute_category_o
415: => per_eca_shd.g_old_rec.attribute_category

Line 413: => per_eca_shd.g_old_rec.role_id

409: => per_eca_shd.g_old_rec.person_id
410: ,p_rank_o
411: => per_eca_shd.g_old_rec.rank
412: ,p_role_id_o
413: => per_eca_shd.g_old_rec.role_id
414: ,p_attribute_category_o
415: => per_eca_shd.g_old_rec.attribute_category
416: ,p_attribute1_o
417: => per_eca_shd.g_old_rec.attribute1

Line 415: => per_eca_shd.g_old_rec.attribute_category

411: => per_eca_shd.g_old_rec.rank
412: ,p_role_id_o
413: => per_eca_shd.g_old_rec.role_id
414: ,p_attribute_category_o
415: => per_eca_shd.g_old_rec.attribute_category
416: ,p_attribute1_o
417: => per_eca_shd.g_old_rec.attribute1
418: ,p_attribute2_o
419: => per_eca_shd.g_old_rec.attribute2

Line 417: => per_eca_shd.g_old_rec.attribute1

413: => per_eca_shd.g_old_rec.role_id
414: ,p_attribute_category_o
415: => per_eca_shd.g_old_rec.attribute_category
416: ,p_attribute1_o
417: => per_eca_shd.g_old_rec.attribute1
418: ,p_attribute2_o
419: => per_eca_shd.g_old_rec.attribute2
420: ,p_attribute3_o
421: => per_eca_shd.g_old_rec.attribute3

Line 419: => per_eca_shd.g_old_rec.attribute2

415: => per_eca_shd.g_old_rec.attribute_category
416: ,p_attribute1_o
417: => per_eca_shd.g_old_rec.attribute1
418: ,p_attribute2_o
419: => per_eca_shd.g_old_rec.attribute2
420: ,p_attribute3_o
421: => per_eca_shd.g_old_rec.attribute3
422: ,p_attribute4_o
423: => per_eca_shd.g_old_rec.attribute4

Line 421: => per_eca_shd.g_old_rec.attribute3

417: => per_eca_shd.g_old_rec.attribute1
418: ,p_attribute2_o
419: => per_eca_shd.g_old_rec.attribute2
420: ,p_attribute3_o
421: => per_eca_shd.g_old_rec.attribute3
422: ,p_attribute4_o
423: => per_eca_shd.g_old_rec.attribute4
424: ,p_attribute5_o
425: => per_eca_shd.g_old_rec.attribute5

Line 423: => per_eca_shd.g_old_rec.attribute4

419: => per_eca_shd.g_old_rec.attribute2
420: ,p_attribute3_o
421: => per_eca_shd.g_old_rec.attribute3
422: ,p_attribute4_o
423: => per_eca_shd.g_old_rec.attribute4
424: ,p_attribute5_o
425: => per_eca_shd.g_old_rec.attribute5
426: ,p_attribute6_o
427: => per_eca_shd.g_old_rec.attribute6

Line 425: => per_eca_shd.g_old_rec.attribute5

421: => per_eca_shd.g_old_rec.attribute3
422: ,p_attribute4_o
423: => per_eca_shd.g_old_rec.attribute4
424: ,p_attribute5_o
425: => per_eca_shd.g_old_rec.attribute5
426: ,p_attribute6_o
427: => per_eca_shd.g_old_rec.attribute6
428: ,p_attribute7_o
429: => per_eca_shd.g_old_rec.attribute7

Line 427: => per_eca_shd.g_old_rec.attribute6

423: => per_eca_shd.g_old_rec.attribute4
424: ,p_attribute5_o
425: => per_eca_shd.g_old_rec.attribute5
426: ,p_attribute6_o
427: => per_eca_shd.g_old_rec.attribute6
428: ,p_attribute7_o
429: => per_eca_shd.g_old_rec.attribute7
430: ,p_attribute8_o
431: => per_eca_shd.g_old_rec.attribute8

Line 429: => per_eca_shd.g_old_rec.attribute7

425: => per_eca_shd.g_old_rec.attribute5
426: ,p_attribute6_o
427: => per_eca_shd.g_old_rec.attribute6
428: ,p_attribute7_o
429: => per_eca_shd.g_old_rec.attribute7
430: ,p_attribute8_o
431: => per_eca_shd.g_old_rec.attribute8
432: ,p_attribute9_o
433: => per_eca_shd.g_old_rec.attribute9

Line 431: => per_eca_shd.g_old_rec.attribute8

427: => per_eca_shd.g_old_rec.attribute6
428: ,p_attribute7_o
429: => per_eca_shd.g_old_rec.attribute7
430: ,p_attribute8_o
431: => per_eca_shd.g_old_rec.attribute8
432: ,p_attribute9_o
433: => per_eca_shd.g_old_rec.attribute9
434: ,p_attribute10_o
435: => per_eca_shd.g_old_rec.attribute10

Line 433: => per_eca_shd.g_old_rec.attribute9

429: => per_eca_shd.g_old_rec.attribute7
430: ,p_attribute8_o
431: => per_eca_shd.g_old_rec.attribute8
432: ,p_attribute9_o
433: => per_eca_shd.g_old_rec.attribute9
434: ,p_attribute10_o
435: => per_eca_shd.g_old_rec.attribute10
436: ,p_attribute11_o
437: => per_eca_shd.g_old_rec.attribute11

Line 435: => per_eca_shd.g_old_rec.attribute10

431: => per_eca_shd.g_old_rec.attribute8
432: ,p_attribute9_o
433: => per_eca_shd.g_old_rec.attribute9
434: ,p_attribute10_o
435: => per_eca_shd.g_old_rec.attribute10
436: ,p_attribute11_o
437: => per_eca_shd.g_old_rec.attribute11
438: ,p_attribute12_o
439: => per_eca_shd.g_old_rec.attribute12

Line 437: => per_eca_shd.g_old_rec.attribute11

433: => per_eca_shd.g_old_rec.attribute9
434: ,p_attribute10_o
435: => per_eca_shd.g_old_rec.attribute10
436: ,p_attribute11_o
437: => per_eca_shd.g_old_rec.attribute11
438: ,p_attribute12_o
439: => per_eca_shd.g_old_rec.attribute12
440: ,p_attribute13_o
441: => per_eca_shd.g_old_rec.attribute13

Line 439: => per_eca_shd.g_old_rec.attribute12

435: => per_eca_shd.g_old_rec.attribute10
436: ,p_attribute11_o
437: => per_eca_shd.g_old_rec.attribute11
438: ,p_attribute12_o
439: => per_eca_shd.g_old_rec.attribute12
440: ,p_attribute13_o
441: => per_eca_shd.g_old_rec.attribute13
442: ,p_attribute14_o
443: => per_eca_shd.g_old_rec.attribute14

Line 441: => per_eca_shd.g_old_rec.attribute13

437: => per_eca_shd.g_old_rec.attribute11
438: ,p_attribute12_o
439: => per_eca_shd.g_old_rec.attribute12
440: ,p_attribute13_o
441: => per_eca_shd.g_old_rec.attribute13
442: ,p_attribute14_o
443: => per_eca_shd.g_old_rec.attribute14
444: ,p_attribute15_o
445: => per_eca_shd.g_old_rec.attribute15

Line 443: => per_eca_shd.g_old_rec.attribute14

439: => per_eca_shd.g_old_rec.attribute12
440: ,p_attribute13_o
441: => per_eca_shd.g_old_rec.attribute13
442: ,p_attribute14_o
443: => per_eca_shd.g_old_rec.attribute14
444: ,p_attribute15_o
445: => per_eca_shd.g_old_rec.attribute15
446: ,p_attribute16_o
447: => per_eca_shd.g_old_rec.attribute16

Line 445: => per_eca_shd.g_old_rec.attribute15

441: => per_eca_shd.g_old_rec.attribute13
442: ,p_attribute14_o
443: => per_eca_shd.g_old_rec.attribute14
444: ,p_attribute15_o
445: => per_eca_shd.g_old_rec.attribute15
446: ,p_attribute16_o
447: => per_eca_shd.g_old_rec.attribute16
448: ,p_attribute17_o
449: => per_eca_shd.g_old_rec.attribute17

Line 447: => per_eca_shd.g_old_rec.attribute16

443: => per_eca_shd.g_old_rec.attribute14
444: ,p_attribute15_o
445: => per_eca_shd.g_old_rec.attribute15
446: ,p_attribute16_o
447: => per_eca_shd.g_old_rec.attribute16
448: ,p_attribute17_o
449: => per_eca_shd.g_old_rec.attribute17
450: ,p_attribute18_o
451: => per_eca_shd.g_old_rec.attribute18

Line 449: => per_eca_shd.g_old_rec.attribute17

445: => per_eca_shd.g_old_rec.attribute15
446: ,p_attribute16_o
447: => per_eca_shd.g_old_rec.attribute16
448: ,p_attribute17_o
449: => per_eca_shd.g_old_rec.attribute17
450: ,p_attribute18_o
451: => per_eca_shd.g_old_rec.attribute18
452: ,p_attribute19_o
453: => per_eca_shd.g_old_rec.attribute19

Line 451: => per_eca_shd.g_old_rec.attribute18

447: => per_eca_shd.g_old_rec.attribute16
448: ,p_attribute17_o
449: => per_eca_shd.g_old_rec.attribute17
450: ,p_attribute18_o
451: => per_eca_shd.g_old_rec.attribute18
452: ,p_attribute19_o
453: => per_eca_shd.g_old_rec.attribute19
454: ,p_attribute20_o
455: => per_eca_shd.g_old_rec.attribute20

Line 453: => per_eca_shd.g_old_rec.attribute19

449: => per_eca_shd.g_old_rec.attribute17
450: ,p_attribute18_o
451: => per_eca_shd.g_old_rec.attribute18
452: ,p_attribute19_o
453: => per_eca_shd.g_old_rec.attribute19
454: ,p_attribute20_o
455: => per_eca_shd.g_old_rec.attribute20
456: ,p_attribute21_o
457: => per_eca_shd.g_old_rec.attribute21

Line 455: => per_eca_shd.g_old_rec.attribute20

451: => per_eca_shd.g_old_rec.attribute18
452: ,p_attribute19_o
453: => per_eca_shd.g_old_rec.attribute19
454: ,p_attribute20_o
455: => per_eca_shd.g_old_rec.attribute20
456: ,p_attribute21_o
457: => per_eca_shd.g_old_rec.attribute21
458: ,p_attribute22_o
459: => per_eca_shd.g_old_rec.attribute22

Line 457: => per_eca_shd.g_old_rec.attribute21

453: => per_eca_shd.g_old_rec.attribute19
454: ,p_attribute20_o
455: => per_eca_shd.g_old_rec.attribute20
456: ,p_attribute21_o
457: => per_eca_shd.g_old_rec.attribute21
458: ,p_attribute22_o
459: => per_eca_shd.g_old_rec.attribute22
460: ,p_attribute23_o
461: => per_eca_shd.g_old_rec.attribute23

Line 459: => per_eca_shd.g_old_rec.attribute22

455: => per_eca_shd.g_old_rec.attribute20
456: ,p_attribute21_o
457: => per_eca_shd.g_old_rec.attribute21
458: ,p_attribute22_o
459: => per_eca_shd.g_old_rec.attribute22
460: ,p_attribute23_o
461: => per_eca_shd.g_old_rec.attribute23
462: ,p_attribute24_o
463: => per_eca_shd.g_old_rec.attribute24

Line 461: => per_eca_shd.g_old_rec.attribute23

457: => per_eca_shd.g_old_rec.attribute21
458: ,p_attribute22_o
459: => per_eca_shd.g_old_rec.attribute22
460: ,p_attribute23_o
461: => per_eca_shd.g_old_rec.attribute23
462: ,p_attribute24_o
463: => per_eca_shd.g_old_rec.attribute24
464: ,p_attribute25_o
465: => per_eca_shd.g_old_rec.attribute25

Line 463: => per_eca_shd.g_old_rec.attribute24

459: => per_eca_shd.g_old_rec.attribute22
460: ,p_attribute23_o
461: => per_eca_shd.g_old_rec.attribute23
462: ,p_attribute24_o
463: => per_eca_shd.g_old_rec.attribute24
464: ,p_attribute25_o
465: => per_eca_shd.g_old_rec.attribute25
466: ,p_attribute26_o
467: => per_eca_shd.g_old_rec.attribute26

Line 465: => per_eca_shd.g_old_rec.attribute25

461: => per_eca_shd.g_old_rec.attribute23
462: ,p_attribute24_o
463: => per_eca_shd.g_old_rec.attribute24
464: ,p_attribute25_o
465: => per_eca_shd.g_old_rec.attribute25
466: ,p_attribute26_o
467: => per_eca_shd.g_old_rec.attribute26
468: ,p_attribute27_o
469: => per_eca_shd.g_old_rec.attribute27

Line 467: => per_eca_shd.g_old_rec.attribute26

463: => per_eca_shd.g_old_rec.attribute24
464: ,p_attribute25_o
465: => per_eca_shd.g_old_rec.attribute25
466: ,p_attribute26_o
467: => per_eca_shd.g_old_rec.attribute26
468: ,p_attribute27_o
469: => per_eca_shd.g_old_rec.attribute27
470: ,p_attribute28_o
471: => per_eca_shd.g_old_rec.attribute28

Line 469: => per_eca_shd.g_old_rec.attribute27

465: => per_eca_shd.g_old_rec.attribute25
466: ,p_attribute26_o
467: => per_eca_shd.g_old_rec.attribute26
468: ,p_attribute27_o
469: => per_eca_shd.g_old_rec.attribute27
470: ,p_attribute28_o
471: => per_eca_shd.g_old_rec.attribute28
472: ,p_attribute29_o
473: => per_eca_shd.g_old_rec.attribute29

Line 471: => per_eca_shd.g_old_rec.attribute28

467: => per_eca_shd.g_old_rec.attribute26
468: ,p_attribute27_o
469: => per_eca_shd.g_old_rec.attribute27
470: ,p_attribute28_o
471: => per_eca_shd.g_old_rec.attribute28
472: ,p_attribute29_o
473: => per_eca_shd.g_old_rec.attribute29
474: ,p_attribute30_o
475: => per_eca_shd.g_old_rec.attribute30

Line 473: => per_eca_shd.g_old_rec.attribute29

469: => per_eca_shd.g_old_rec.attribute27
470: ,p_attribute28_o
471: => per_eca_shd.g_old_rec.attribute28
472: ,p_attribute29_o
473: => per_eca_shd.g_old_rec.attribute29
474: ,p_attribute30_o
475: => per_eca_shd.g_old_rec.attribute30
476: ,p_candidate_information_cate_o
477: => per_eca_shd.g_old_rec.candidate_info_category

Line 475: => per_eca_shd.g_old_rec.attribute30

471: => per_eca_shd.g_old_rec.attribute28
472: ,p_attribute29_o
473: => per_eca_shd.g_old_rec.attribute29
474: ,p_attribute30_o
475: => per_eca_shd.g_old_rec.attribute30
476: ,p_candidate_information_cate_o
477: => per_eca_shd.g_old_rec.candidate_info_category
478: ,p_candidate_information1_o
479: => per_eca_shd.g_old_rec.candidate_information1

Line 477: => per_eca_shd.g_old_rec.candidate_info_category

473: => per_eca_shd.g_old_rec.attribute29
474: ,p_attribute30_o
475: => per_eca_shd.g_old_rec.attribute30
476: ,p_candidate_information_cate_o
477: => per_eca_shd.g_old_rec.candidate_info_category
478: ,p_candidate_information1_o
479: => per_eca_shd.g_old_rec.candidate_information1
480: ,p_candidate_information2_o
481: => per_eca_shd.g_old_rec.candidate_information2

Line 479: => per_eca_shd.g_old_rec.candidate_information1

475: => per_eca_shd.g_old_rec.attribute30
476: ,p_candidate_information_cate_o
477: => per_eca_shd.g_old_rec.candidate_info_category
478: ,p_candidate_information1_o
479: => per_eca_shd.g_old_rec.candidate_information1
480: ,p_candidate_information2_o
481: => per_eca_shd.g_old_rec.candidate_information2
482: ,p_candidate_information3_o
483: => per_eca_shd.g_old_rec.candidate_information3

Line 481: => per_eca_shd.g_old_rec.candidate_information2

477: => per_eca_shd.g_old_rec.candidate_info_category
478: ,p_candidate_information1_o
479: => per_eca_shd.g_old_rec.candidate_information1
480: ,p_candidate_information2_o
481: => per_eca_shd.g_old_rec.candidate_information2
482: ,p_candidate_information3_o
483: => per_eca_shd.g_old_rec.candidate_information3
484: ,p_candidate_information4_o
485: => per_eca_shd.g_old_rec.candidate_information4

Line 483: => per_eca_shd.g_old_rec.candidate_information3

479: => per_eca_shd.g_old_rec.candidate_information1
480: ,p_candidate_information2_o
481: => per_eca_shd.g_old_rec.candidate_information2
482: ,p_candidate_information3_o
483: => per_eca_shd.g_old_rec.candidate_information3
484: ,p_candidate_information4_o
485: => per_eca_shd.g_old_rec.candidate_information4
486: ,p_candidate_information5_o
487: => per_eca_shd.g_old_rec.candidate_information5

Line 485: => per_eca_shd.g_old_rec.candidate_information4

481: => per_eca_shd.g_old_rec.candidate_information2
482: ,p_candidate_information3_o
483: => per_eca_shd.g_old_rec.candidate_information3
484: ,p_candidate_information4_o
485: => per_eca_shd.g_old_rec.candidate_information4
486: ,p_candidate_information5_o
487: => per_eca_shd.g_old_rec.candidate_information5
488: ,p_candidate_information6_o
489: => per_eca_shd.g_old_rec.candidate_information6

Line 487: => per_eca_shd.g_old_rec.candidate_information5

483: => per_eca_shd.g_old_rec.candidate_information3
484: ,p_candidate_information4_o
485: => per_eca_shd.g_old_rec.candidate_information4
486: ,p_candidate_information5_o
487: => per_eca_shd.g_old_rec.candidate_information5
488: ,p_candidate_information6_o
489: => per_eca_shd.g_old_rec.candidate_information6
490: ,p_candidate_information7_o
491: => per_eca_shd.g_old_rec.candidate_information7

Line 489: => per_eca_shd.g_old_rec.candidate_information6

485: => per_eca_shd.g_old_rec.candidate_information4
486: ,p_candidate_information5_o
487: => per_eca_shd.g_old_rec.candidate_information5
488: ,p_candidate_information6_o
489: => per_eca_shd.g_old_rec.candidate_information6
490: ,p_candidate_information7_o
491: => per_eca_shd.g_old_rec.candidate_information7
492: ,p_candidate_information8_o
493: => per_eca_shd.g_old_rec.candidate_information8

Line 491: => per_eca_shd.g_old_rec.candidate_information7

487: => per_eca_shd.g_old_rec.candidate_information5
488: ,p_candidate_information6_o
489: => per_eca_shd.g_old_rec.candidate_information6
490: ,p_candidate_information7_o
491: => per_eca_shd.g_old_rec.candidate_information7
492: ,p_candidate_information8_o
493: => per_eca_shd.g_old_rec.candidate_information8
494: ,p_candidate_information9_o
495: => per_eca_shd.g_old_rec.candidate_information9

Line 493: => per_eca_shd.g_old_rec.candidate_information8

489: => per_eca_shd.g_old_rec.candidate_information6
490: ,p_candidate_information7_o
491: => per_eca_shd.g_old_rec.candidate_information7
492: ,p_candidate_information8_o
493: => per_eca_shd.g_old_rec.candidate_information8
494: ,p_candidate_information9_o
495: => per_eca_shd.g_old_rec.candidate_information9
496: ,p_candidate_information10_o
497: => per_eca_shd.g_old_rec.candidate_information10

Line 495: => per_eca_shd.g_old_rec.candidate_information9

491: => per_eca_shd.g_old_rec.candidate_information7
492: ,p_candidate_information8_o
493: => per_eca_shd.g_old_rec.candidate_information8
494: ,p_candidate_information9_o
495: => per_eca_shd.g_old_rec.candidate_information9
496: ,p_candidate_information10_o
497: => per_eca_shd.g_old_rec.candidate_information10
498: ,p_candidate_information11_o
499: => per_eca_shd.g_old_rec.candidate_information11

Line 497: => per_eca_shd.g_old_rec.candidate_information10

493: => per_eca_shd.g_old_rec.candidate_information8
494: ,p_candidate_information9_o
495: => per_eca_shd.g_old_rec.candidate_information9
496: ,p_candidate_information10_o
497: => per_eca_shd.g_old_rec.candidate_information10
498: ,p_candidate_information11_o
499: => per_eca_shd.g_old_rec.candidate_information11
500: ,p_candidate_information12_o
501: => per_eca_shd.g_old_rec.candidate_information12

Line 499: => per_eca_shd.g_old_rec.candidate_information11

495: => per_eca_shd.g_old_rec.candidate_information9
496: ,p_candidate_information10_o
497: => per_eca_shd.g_old_rec.candidate_information10
498: ,p_candidate_information11_o
499: => per_eca_shd.g_old_rec.candidate_information11
500: ,p_candidate_information12_o
501: => per_eca_shd.g_old_rec.candidate_information12
502: ,p_candidate_information13_o
503: => per_eca_shd.g_old_rec.candidate_information13

Line 501: => per_eca_shd.g_old_rec.candidate_information12

497: => per_eca_shd.g_old_rec.candidate_information10
498: ,p_candidate_information11_o
499: => per_eca_shd.g_old_rec.candidate_information11
500: ,p_candidate_information12_o
501: => per_eca_shd.g_old_rec.candidate_information12
502: ,p_candidate_information13_o
503: => per_eca_shd.g_old_rec.candidate_information13
504: ,p_candidate_information14_o
505: => per_eca_shd.g_old_rec.candidate_information14

Line 503: => per_eca_shd.g_old_rec.candidate_information13

499: => per_eca_shd.g_old_rec.candidate_information11
500: ,p_candidate_information12_o
501: => per_eca_shd.g_old_rec.candidate_information12
502: ,p_candidate_information13_o
503: => per_eca_shd.g_old_rec.candidate_information13
504: ,p_candidate_information14_o
505: => per_eca_shd.g_old_rec.candidate_information14
506: ,p_candidate_information15_o
507: => per_eca_shd.g_old_rec.candidate_information15

Line 505: => per_eca_shd.g_old_rec.candidate_information14

501: => per_eca_shd.g_old_rec.candidate_information12
502: ,p_candidate_information13_o
503: => per_eca_shd.g_old_rec.candidate_information13
504: ,p_candidate_information14_o
505: => per_eca_shd.g_old_rec.candidate_information14
506: ,p_candidate_information15_o
507: => per_eca_shd.g_old_rec.candidate_information15
508: ,p_candidate_information16_o
509: => per_eca_shd.g_old_rec.candidate_information16

Line 507: => per_eca_shd.g_old_rec.candidate_information15

503: => per_eca_shd.g_old_rec.candidate_information13
504: ,p_candidate_information14_o
505: => per_eca_shd.g_old_rec.candidate_information14
506: ,p_candidate_information15_o
507: => per_eca_shd.g_old_rec.candidate_information15
508: ,p_candidate_information16_o
509: => per_eca_shd.g_old_rec.candidate_information16
510: ,p_candidate_information17_o
511: => per_eca_shd.g_old_rec.candidate_information17

Line 509: => per_eca_shd.g_old_rec.candidate_information16

505: => per_eca_shd.g_old_rec.candidate_information14
506: ,p_candidate_information15_o
507: => per_eca_shd.g_old_rec.candidate_information15
508: ,p_candidate_information16_o
509: => per_eca_shd.g_old_rec.candidate_information16
510: ,p_candidate_information17_o
511: => per_eca_shd.g_old_rec.candidate_information17
512: ,p_candidate_information18_o
513: => per_eca_shd.g_old_rec.candidate_information18

Line 511: => per_eca_shd.g_old_rec.candidate_information17

507: => per_eca_shd.g_old_rec.candidate_information15
508: ,p_candidate_information16_o
509: => per_eca_shd.g_old_rec.candidate_information16
510: ,p_candidate_information17_o
511: => per_eca_shd.g_old_rec.candidate_information17
512: ,p_candidate_information18_o
513: => per_eca_shd.g_old_rec.candidate_information18
514: ,p_candidate_information19_o
515: => per_eca_shd.g_old_rec.candidate_information19

Line 513: => per_eca_shd.g_old_rec.candidate_information18

509: => per_eca_shd.g_old_rec.candidate_information16
510: ,p_candidate_information17_o
511: => per_eca_shd.g_old_rec.candidate_information17
512: ,p_candidate_information18_o
513: => per_eca_shd.g_old_rec.candidate_information18
514: ,p_candidate_information19_o
515: => per_eca_shd.g_old_rec.candidate_information19
516: ,p_candidate_information20_o
517: => per_eca_shd.g_old_rec.candidate_information20

Line 515: => per_eca_shd.g_old_rec.candidate_information19

511: => per_eca_shd.g_old_rec.candidate_information17
512: ,p_candidate_information18_o
513: => per_eca_shd.g_old_rec.candidate_information18
514: ,p_candidate_information19_o
515: => per_eca_shd.g_old_rec.candidate_information19
516: ,p_candidate_information20_o
517: => per_eca_shd.g_old_rec.candidate_information20
518: ,p_candidate_information21_o
519: => per_eca_shd.g_old_rec.candidate_information21

Line 517: => per_eca_shd.g_old_rec.candidate_information20

513: => per_eca_shd.g_old_rec.candidate_information18
514: ,p_candidate_information19_o
515: => per_eca_shd.g_old_rec.candidate_information19
516: ,p_candidate_information20_o
517: => per_eca_shd.g_old_rec.candidate_information20
518: ,p_candidate_information21_o
519: => per_eca_shd.g_old_rec.candidate_information21
520: ,p_candidate_information22_o
521: => per_eca_shd.g_old_rec.candidate_information22

Line 519: => per_eca_shd.g_old_rec.candidate_information21

515: => per_eca_shd.g_old_rec.candidate_information19
516: ,p_candidate_information20_o
517: => per_eca_shd.g_old_rec.candidate_information20
518: ,p_candidate_information21_o
519: => per_eca_shd.g_old_rec.candidate_information21
520: ,p_candidate_information22_o
521: => per_eca_shd.g_old_rec.candidate_information22
522: ,p_candidate_information23_o
523: => per_eca_shd.g_old_rec.candidate_information23

Line 521: => per_eca_shd.g_old_rec.candidate_information22

517: => per_eca_shd.g_old_rec.candidate_information20
518: ,p_candidate_information21_o
519: => per_eca_shd.g_old_rec.candidate_information21
520: ,p_candidate_information22_o
521: => per_eca_shd.g_old_rec.candidate_information22
522: ,p_candidate_information23_o
523: => per_eca_shd.g_old_rec.candidate_information23
524: ,p_candidate_information24_o
525: => per_eca_shd.g_old_rec.candidate_information24

Line 523: => per_eca_shd.g_old_rec.candidate_information23

519: => per_eca_shd.g_old_rec.candidate_information21
520: ,p_candidate_information22_o
521: => per_eca_shd.g_old_rec.candidate_information22
522: ,p_candidate_information23_o
523: => per_eca_shd.g_old_rec.candidate_information23
524: ,p_candidate_information24_o
525: => per_eca_shd.g_old_rec.candidate_information24
526: ,p_candidate_information25_o
527: => per_eca_shd.g_old_rec.candidate_information25

Line 525: => per_eca_shd.g_old_rec.candidate_information24

521: => per_eca_shd.g_old_rec.candidate_information22
522: ,p_candidate_information23_o
523: => per_eca_shd.g_old_rec.candidate_information23
524: ,p_candidate_information24_o
525: => per_eca_shd.g_old_rec.candidate_information24
526: ,p_candidate_information25_o
527: => per_eca_shd.g_old_rec.candidate_information25
528: ,p_candidate_information26_o
529: => per_eca_shd.g_old_rec.candidate_information26

Line 527: => per_eca_shd.g_old_rec.candidate_information25

523: => per_eca_shd.g_old_rec.candidate_information23
524: ,p_candidate_information24_o
525: => per_eca_shd.g_old_rec.candidate_information24
526: ,p_candidate_information25_o
527: => per_eca_shd.g_old_rec.candidate_information25
528: ,p_candidate_information26_o
529: => per_eca_shd.g_old_rec.candidate_information26
530: ,p_candidate_information27_o
531: => per_eca_shd.g_old_rec.candidate_information27

Line 529: => per_eca_shd.g_old_rec.candidate_information26

525: => per_eca_shd.g_old_rec.candidate_information24
526: ,p_candidate_information25_o
527: => per_eca_shd.g_old_rec.candidate_information25
528: ,p_candidate_information26_o
529: => per_eca_shd.g_old_rec.candidate_information26
530: ,p_candidate_information27_o
531: => per_eca_shd.g_old_rec.candidate_information27
532: ,p_candidate_information28_o
533: => per_eca_shd.g_old_rec.candidate_information28

Line 531: => per_eca_shd.g_old_rec.candidate_information27

527: => per_eca_shd.g_old_rec.candidate_information25
528: ,p_candidate_information26_o
529: => per_eca_shd.g_old_rec.candidate_information26
530: ,p_candidate_information27_o
531: => per_eca_shd.g_old_rec.candidate_information27
532: ,p_candidate_information28_o
533: => per_eca_shd.g_old_rec.candidate_information28
534: ,p_candidate_information29_o
535: => per_eca_shd.g_old_rec.candidate_information29

Line 533: => per_eca_shd.g_old_rec.candidate_information28

529: => per_eca_shd.g_old_rec.candidate_information26
530: ,p_candidate_information27_o
531: => per_eca_shd.g_old_rec.candidate_information27
532: ,p_candidate_information28_o
533: => per_eca_shd.g_old_rec.candidate_information28
534: ,p_candidate_information29_o
535: => per_eca_shd.g_old_rec.candidate_information29
536: ,p_candidate_information30_o
537: => per_eca_shd.g_old_rec.candidate_information30

Line 535: => per_eca_shd.g_old_rec.candidate_information29

531: => per_eca_shd.g_old_rec.candidate_information27
532: ,p_candidate_information28_o
533: => per_eca_shd.g_old_rec.candidate_information28
534: ,p_candidate_information29_o
535: => per_eca_shd.g_old_rec.candidate_information29
536: ,p_candidate_information30_o
537: => per_eca_shd.g_old_rec.candidate_information30
538: ,p_object_version_number_o
539: => per_eca_shd.g_old_rec.object_version_number

Line 537: => per_eca_shd.g_old_rec.candidate_information30

533: => per_eca_shd.g_old_rec.candidate_information28
534: ,p_candidate_information29_o
535: => per_eca_shd.g_old_rec.candidate_information29
536: ,p_candidate_information30_o
537: => per_eca_shd.g_old_rec.candidate_information30
538: ,p_object_version_number_o
539: => per_eca_shd.g_old_rec.object_version_number
540: );
541: --

Line 539: => per_eca_shd.g_old_rec.object_version_number

535: => per_eca_shd.g_old_rec.candidate_information29
536: ,p_candidate_information30_o
537: => per_eca_shd.g_old_rec.candidate_information30
538: ,p_object_version_number_o
539: => per_eca_shd.g_old_rec.object_version_number
540: );
541: --
542: exception
543: --

Line 599: (p_rec in out nocopy per_eca_shd.g_rec_type

595: --
596: -- {End Of Comments}
597: -- ----------------------------------------------------------------------------
598: Procedure convert_defs
599: (p_rec in out nocopy per_eca_shd.g_rec_type
600: ) is
601: --
602: Begin
603: --

Line 611: per_eca_shd.g_old_rec.business_group_id;

607: -- is being used then we must set to the 'current' argument value.
608: --
609: If (p_rec.business_group_id = hr_api.g_number) then
610: p_rec.business_group_id :=
611: per_eca_shd.g_old_rec.business_group_id;
612: End If;
613: If (p_rec.election_id = hr_api.g_number) then
614: p_rec.election_id :=
615: per_eca_shd.g_old_rec.election_id;

Line 615: per_eca_shd.g_old_rec.election_id;

611: per_eca_shd.g_old_rec.business_group_id;
612: End If;
613: If (p_rec.election_id = hr_api.g_number) then
614: p_rec.election_id :=
615: per_eca_shd.g_old_rec.election_id;
616: End If;
617: If (p_rec.person_id = hr_api.g_number) then
618: p_rec.person_id :=
619: per_eca_shd.g_old_rec.person_id;

Line 619: per_eca_shd.g_old_rec.person_id;

615: per_eca_shd.g_old_rec.election_id;
616: End If;
617: If (p_rec.person_id = hr_api.g_number) then
618: p_rec.person_id :=
619: per_eca_shd.g_old_rec.person_id;
620: End If;
621: If (p_rec.rank = hr_api.g_number) then
622: p_rec.rank :=
623: per_eca_shd.g_old_rec.rank;

Line 623: per_eca_shd.g_old_rec.rank;

619: per_eca_shd.g_old_rec.person_id;
620: End If;
621: If (p_rec.rank = hr_api.g_number) then
622: p_rec.rank :=
623: per_eca_shd.g_old_rec.rank;
624: End If;
625: If (p_rec.role_id = hr_api.g_number) then
626: p_rec.role_id :=
627: per_eca_shd.g_old_rec.role_id;

Line 627: per_eca_shd.g_old_rec.role_id;

623: per_eca_shd.g_old_rec.rank;
624: End If;
625: If (p_rec.role_id = hr_api.g_number) then
626: p_rec.role_id :=
627: per_eca_shd.g_old_rec.role_id;
628: End If;
629: If (p_rec.attribute_category = hr_api.g_varchar2) then
630: p_rec.attribute_category :=
631: per_eca_shd.g_old_rec.attribute_category;

Line 631: per_eca_shd.g_old_rec.attribute_category;

627: per_eca_shd.g_old_rec.role_id;
628: End If;
629: If (p_rec.attribute_category = hr_api.g_varchar2) then
630: p_rec.attribute_category :=
631: per_eca_shd.g_old_rec.attribute_category;
632: End If;
633: If (p_rec.attribute1 = hr_api.g_varchar2) then
634: p_rec.attribute1 :=
635: per_eca_shd.g_old_rec.attribute1;

Line 635: per_eca_shd.g_old_rec.attribute1;

631: per_eca_shd.g_old_rec.attribute_category;
632: End If;
633: If (p_rec.attribute1 = hr_api.g_varchar2) then
634: p_rec.attribute1 :=
635: per_eca_shd.g_old_rec.attribute1;
636: End If;
637: If (p_rec.attribute2 = hr_api.g_varchar2) then
638: p_rec.attribute2 :=
639: per_eca_shd.g_old_rec.attribute2;

Line 639: per_eca_shd.g_old_rec.attribute2;

635: per_eca_shd.g_old_rec.attribute1;
636: End If;
637: If (p_rec.attribute2 = hr_api.g_varchar2) then
638: p_rec.attribute2 :=
639: per_eca_shd.g_old_rec.attribute2;
640: End If;
641: If (p_rec.attribute3 = hr_api.g_varchar2) then
642: p_rec.attribute3 :=
643: per_eca_shd.g_old_rec.attribute3;

Line 643: per_eca_shd.g_old_rec.attribute3;

639: per_eca_shd.g_old_rec.attribute2;
640: End If;
641: If (p_rec.attribute3 = hr_api.g_varchar2) then
642: p_rec.attribute3 :=
643: per_eca_shd.g_old_rec.attribute3;
644: End If;
645: If (p_rec.attribute4 = hr_api.g_varchar2) then
646: p_rec.attribute4 :=
647: per_eca_shd.g_old_rec.attribute4;

Line 647: per_eca_shd.g_old_rec.attribute4;

643: per_eca_shd.g_old_rec.attribute3;
644: End If;
645: If (p_rec.attribute4 = hr_api.g_varchar2) then
646: p_rec.attribute4 :=
647: per_eca_shd.g_old_rec.attribute4;
648: End If;
649: If (p_rec.attribute5 = hr_api.g_varchar2) then
650: p_rec.attribute5 :=
651: per_eca_shd.g_old_rec.attribute5;

Line 651: per_eca_shd.g_old_rec.attribute5;

647: per_eca_shd.g_old_rec.attribute4;
648: End If;
649: If (p_rec.attribute5 = hr_api.g_varchar2) then
650: p_rec.attribute5 :=
651: per_eca_shd.g_old_rec.attribute5;
652: End If;
653: If (p_rec.attribute6 = hr_api.g_varchar2) then
654: p_rec.attribute6 :=
655: per_eca_shd.g_old_rec.attribute6;

Line 655: per_eca_shd.g_old_rec.attribute6;

651: per_eca_shd.g_old_rec.attribute5;
652: End If;
653: If (p_rec.attribute6 = hr_api.g_varchar2) then
654: p_rec.attribute6 :=
655: per_eca_shd.g_old_rec.attribute6;
656: End If;
657: If (p_rec.attribute7 = hr_api.g_varchar2) then
658: p_rec.attribute7 :=
659: per_eca_shd.g_old_rec.attribute7;

Line 659: per_eca_shd.g_old_rec.attribute7;

655: per_eca_shd.g_old_rec.attribute6;
656: End If;
657: If (p_rec.attribute7 = hr_api.g_varchar2) then
658: p_rec.attribute7 :=
659: per_eca_shd.g_old_rec.attribute7;
660: End If;
661: If (p_rec.attribute8 = hr_api.g_varchar2) then
662: p_rec.attribute8 :=
663: per_eca_shd.g_old_rec.attribute8;

Line 663: per_eca_shd.g_old_rec.attribute8;

659: per_eca_shd.g_old_rec.attribute7;
660: End If;
661: If (p_rec.attribute8 = hr_api.g_varchar2) then
662: p_rec.attribute8 :=
663: per_eca_shd.g_old_rec.attribute8;
664: End If;
665: If (p_rec.attribute9 = hr_api.g_varchar2) then
666: p_rec.attribute9 :=
667: per_eca_shd.g_old_rec.attribute9;

Line 667: per_eca_shd.g_old_rec.attribute9;

663: per_eca_shd.g_old_rec.attribute8;
664: End If;
665: If (p_rec.attribute9 = hr_api.g_varchar2) then
666: p_rec.attribute9 :=
667: per_eca_shd.g_old_rec.attribute9;
668: End If;
669: If (p_rec.attribute10 = hr_api.g_varchar2) then
670: p_rec.attribute10 :=
671: per_eca_shd.g_old_rec.attribute10;

Line 671: per_eca_shd.g_old_rec.attribute10;

667: per_eca_shd.g_old_rec.attribute9;
668: End If;
669: If (p_rec.attribute10 = hr_api.g_varchar2) then
670: p_rec.attribute10 :=
671: per_eca_shd.g_old_rec.attribute10;
672: End If;
673: If (p_rec.attribute11 = hr_api.g_varchar2) then
674: p_rec.attribute11 :=
675: per_eca_shd.g_old_rec.attribute11;

Line 675: per_eca_shd.g_old_rec.attribute11;

671: per_eca_shd.g_old_rec.attribute10;
672: End If;
673: If (p_rec.attribute11 = hr_api.g_varchar2) then
674: p_rec.attribute11 :=
675: per_eca_shd.g_old_rec.attribute11;
676: End If;
677: If (p_rec.attribute12 = hr_api.g_varchar2) then
678: p_rec.attribute12 :=
679: per_eca_shd.g_old_rec.attribute12;

Line 679: per_eca_shd.g_old_rec.attribute12;

675: per_eca_shd.g_old_rec.attribute11;
676: End If;
677: If (p_rec.attribute12 = hr_api.g_varchar2) then
678: p_rec.attribute12 :=
679: per_eca_shd.g_old_rec.attribute12;
680: End If;
681: If (p_rec.attribute13 = hr_api.g_varchar2) then
682: p_rec.attribute13 :=
683: per_eca_shd.g_old_rec.attribute13;

Line 683: per_eca_shd.g_old_rec.attribute13;

679: per_eca_shd.g_old_rec.attribute12;
680: End If;
681: If (p_rec.attribute13 = hr_api.g_varchar2) then
682: p_rec.attribute13 :=
683: per_eca_shd.g_old_rec.attribute13;
684: End If;
685: If (p_rec.attribute14 = hr_api.g_varchar2) then
686: p_rec.attribute14 :=
687: per_eca_shd.g_old_rec.attribute14;

Line 687: per_eca_shd.g_old_rec.attribute14;

683: per_eca_shd.g_old_rec.attribute13;
684: End If;
685: If (p_rec.attribute14 = hr_api.g_varchar2) then
686: p_rec.attribute14 :=
687: per_eca_shd.g_old_rec.attribute14;
688: End If;
689: If (p_rec.attribute15 = hr_api.g_varchar2) then
690: p_rec.attribute15 :=
691: per_eca_shd.g_old_rec.attribute15;

Line 691: per_eca_shd.g_old_rec.attribute15;

687: per_eca_shd.g_old_rec.attribute14;
688: End If;
689: If (p_rec.attribute15 = hr_api.g_varchar2) then
690: p_rec.attribute15 :=
691: per_eca_shd.g_old_rec.attribute15;
692: End If;
693: If (p_rec.attribute16 = hr_api.g_varchar2) then
694: p_rec.attribute16 :=
695: per_eca_shd.g_old_rec.attribute16;

Line 695: per_eca_shd.g_old_rec.attribute16;

691: per_eca_shd.g_old_rec.attribute15;
692: End If;
693: If (p_rec.attribute16 = hr_api.g_varchar2) then
694: p_rec.attribute16 :=
695: per_eca_shd.g_old_rec.attribute16;
696: End If;
697: If (p_rec.attribute17 = hr_api.g_varchar2) then
698: p_rec.attribute17 :=
699: per_eca_shd.g_old_rec.attribute17;

Line 699: per_eca_shd.g_old_rec.attribute17;

695: per_eca_shd.g_old_rec.attribute16;
696: End If;
697: If (p_rec.attribute17 = hr_api.g_varchar2) then
698: p_rec.attribute17 :=
699: per_eca_shd.g_old_rec.attribute17;
700: End If;
701: If (p_rec.attribute18 = hr_api.g_varchar2) then
702: p_rec.attribute18 :=
703: per_eca_shd.g_old_rec.attribute18;

Line 703: per_eca_shd.g_old_rec.attribute18;

699: per_eca_shd.g_old_rec.attribute17;
700: End If;
701: If (p_rec.attribute18 = hr_api.g_varchar2) then
702: p_rec.attribute18 :=
703: per_eca_shd.g_old_rec.attribute18;
704: End If;
705: If (p_rec.attribute19 = hr_api.g_varchar2) then
706: p_rec.attribute19 :=
707: per_eca_shd.g_old_rec.attribute19;

Line 707: per_eca_shd.g_old_rec.attribute19;

703: per_eca_shd.g_old_rec.attribute18;
704: End If;
705: If (p_rec.attribute19 = hr_api.g_varchar2) then
706: p_rec.attribute19 :=
707: per_eca_shd.g_old_rec.attribute19;
708: End If;
709: If (p_rec.attribute20 = hr_api.g_varchar2) then
710: p_rec.attribute20 :=
711: per_eca_shd.g_old_rec.attribute20;

Line 711: per_eca_shd.g_old_rec.attribute20;

707: per_eca_shd.g_old_rec.attribute19;
708: End If;
709: If (p_rec.attribute20 = hr_api.g_varchar2) then
710: p_rec.attribute20 :=
711: per_eca_shd.g_old_rec.attribute20;
712: End If;
713: If (p_rec.attribute21 = hr_api.g_varchar2) then
714: p_rec.attribute21 :=
715: per_eca_shd.g_old_rec.attribute21;

Line 715: per_eca_shd.g_old_rec.attribute21;

711: per_eca_shd.g_old_rec.attribute20;
712: End If;
713: If (p_rec.attribute21 = hr_api.g_varchar2) then
714: p_rec.attribute21 :=
715: per_eca_shd.g_old_rec.attribute21;
716: End If;
717: If (p_rec.attribute22 = hr_api.g_varchar2) then
718: p_rec.attribute22 :=
719: per_eca_shd.g_old_rec.attribute22;

Line 719: per_eca_shd.g_old_rec.attribute22;

715: per_eca_shd.g_old_rec.attribute21;
716: End If;
717: If (p_rec.attribute22 = hr_api.g_varchar2) then
718: p_rec.attribute22 :=
719: per_eca_shd.g_old_rec.attribute22;
720: End If;
721: If (p_rec.attribute23 = hr_api.g_varchar2) then
722: p_rec.attribute23 :=
723: per_eca_shd.g_old_rec.attribute23;

Line 723: per_eca_shd.g_old_rec.attribute23;

719: per_eca_shd.g_old_rec.attribute22;
720: End If;
721: If (p_rec.attribute23 = hr_api.g_varchar2) then
722: p_rec.attribute23 :=
723: per_eca_shd.g_old_rec.attribute23;
724: End If;
725: If (p_rec.attribute24 = hr_api.g_varchar2) then
726: p_rec.attribute24 :=
727: per_eca_shd.g_old_rec.attribute24;

Line 727: per_eca_shd.g_old_rec.attribute24;

723: per_eca_shd.g_old_rec.attribute23;
724: End If;
725: If (p_rec.attribute24 = hr_api.g_varchar2) then
726: p_rec.attribute24 :=
727: per_eca_shd.g_old_rec.attribute24;
728: End If;
729: If (p_rec.attribute25 = hr_api.g_varchar2) then
730: p_rec.attribute25 :=
731: per_eca_shd.g_old_rec.attribute25;

Line 731: per_eca_shd.g_old_rec.attribute25;

727: per_eca_shd.g_old_rec.attribute24;
728: End If;
729: If (p_rec.attribute25 = hr_api.g_varchar2) then
730: p_rec.attribute25 :=
731: per_eca_shd.g_old_rec.attribute25;
732: End If;
733: If (p_rec.attribute26 = hr_api.g_varchar2) then
734: p_rec.attribute26 :=
735: per_eca_shd.g_old_rec.attribute26;

Line 735: per_eca_shd.g_old_rec.attribute26;

731: per_eca_shd.g_old_rec.attribute25;
732: End If;
733: If (p_rec.attribute26 = hr_api.g_varchar2) then
734: p_rec.attribute26 :=
735: per_eca_shd.g_old_rec.attribute26;
736: End If;
737: If (p_rec.attribute27 = hr_api.g_varchar2) then
738: p_rec.attribute27 :=
739: per_eca_shd.g_old_rec.attribute27;

Line 739: per_eca_shd.g_old_rec.attribute27;

735: per_eca_shd.g_old_rec.attribute26;
736: End If;
737: If (p_rec.attribute27 = hr_api.g_varchar2) then
738: p_rec.attribute27 :=
739: per_eca_shd.g_old_rec.attribute27;
740: End If;
741: If (p_rec.attribute28 = hr_api.g_varchar2) then
742: p_rec.attribute28 :=
743: per_eca_shd.g_old_rec.attribute28;

Line 743: per_eca_shd.g_old_rec.attribute28;

739: per_eca_shd.g_old_rec.attribute27;
740: End If;
741: If (p_rec.attribute28 = hr_api.g_varchar2) then
742: p_rec.attribute28 :=
743: per_eca_shd.g_old_rec.attribute28;
744: End If;
745: If (p_rec.attribute29 = hr_api.g_varchar2) then
746: p_rec.attribute29 :=
747: per_eca_shd.g_old_rec.attribute29;

Line 747: per_eca_shd.g_old_rec.attribute29;

743: per_eca_shd.g_old_rec.attribute28;
744: End If;
745: If (p_rec.attribute29 = hr_api.g_varchar2) then
746: p_rec.attribute29 :=
747: per_eca_shd.g_old_rec.attribute29;
748: End If;
749: If (p_rec.attribute30 = hr_api.g_varchar2) then
750: p_rec.attribute30 :=
751: per_eca_shd.g_old_rec.attribute30;

Line 751: per_eca_shd.g_old_rec.attribute30;

747: per_eca_shd.g_old_rec.attribute29;
748: End If;
749: If (p_rec.attribute30 = hr_api.g_varchar2) then
750: p_rec.attribute30 :=
751: per_eca_shd.g_old_rec.attribute30;
752: End If;
753: If (p_rec.candidate_info_category = hr_api.g_varchar2) then
754: p_rec.candidate_info_category :=
755: per_eca_shd.g_old_rec.candidate_info_category;

Line 755: per_eca_shd.g_old_rec.candidate_info_category;

751: per_eca_shd.g_old_rec.attribute30;
752: End If;
753: If (p_rec.candidate_info_category = hr_api.g_varchar2) then
754: p_rec.candidate_info_category :=
755: per_eca_shd.g_old_rec.candidate_info_category;
756: End If;
757: If (p_rec.candidate_information1 = hr_api.g_varchar2) then
758: p_rec.candidate_information1 :=
759: per_eca_shd.g_old_rec.candidate_information1;

Line 759: per_eca_shd.g_old_rec.candidate_information1;

755: per_eca_shd.g_old_rec.candidate_info_category;
756: End If;
757: If (p_rec.candidate_information1 = hr_api.g_varchar2) then
758: p_rec.candidate_information1 :=
759: per_eca_shd.g_old_rec.candidate_information1;
760: End If;
761: If (p_rec.candidate_information2 = hr_api.g_varchar2) then
762: p_rec.candidate_information2 :=
763: per_eca_shd.g_old_rec.candidate_information2;

Line 763: per_eca_shd.g_old_rec.candidate_information2;

759: per_eca_shd.g_old_rec.candidate_information1;
760: End If;
761: If (p_rec.candidate_information2 = hr_api.g_varchar2) then
762: p_rec.candidate_information2 :=
763: per_eca_shd.g_old_rec.candidate_information2;
764: End If;
765: If (p_rec.candidate_information3 = hr_api.g_varchar2) then
766: p_rec.candidate_information3 :=
767: per_eca_shd.g_old_rec.candidate_information3;

Line 767: per_eca_shd.g_old_rec.candidate_information3;

763: per_eca_shd.g_old_rec.candidate_information2;
764: End If;
765: If (p_rec.candidate_information3 = hr_api.g_varchar2) then
766: p_rec.candidate_information3 :=
767: per_eca_shd.g_old_rec.candidate_information3;
768: End If;
769: If (p_rec.candidate_information4 = hr_api.g_varchar2) then
770: p_rec.candidate_information4 :=
771: per_eca_shd.g_old_rec.candidate_information4;

Line 771: per_eca_shd.g_old_rec.candidate_information4;

767: per_eca_shd.g_old_rec.candidate_information3;
768: End If;
769: If (p_rec.candidate_information4 = hr_api.g_varchar2) then
770: p_rec.candidate_information4 :=
771: per_eca_shd.g_old_rec.candidate_information4;
772: End If;
773: If (p_rec.candidate_information5 = hr_api.g_varchar2) then
774: p_rec.candidate_information5 :=
775: per_eca_shd.g_old_rec.candidate_information5;

Line 775: per_eca_shd.g_old_rec.candidate_information5;

771: per_eca_shd.g_old_rec.candidate_information4;
772: End If;
773: If (p_rec.candidate_information5 = hr_api.g_varchar2) then
774: p_rec.candidate_information5 :=
775: per_eca_shd.g_old_rec.candidate_information5;
776: End If;
777: If (p_rec.candidate_information6 = hr_api.g_varchar2) then
778: p_rec.candidate_information6 :=
779: per_eca_shd.g_old_rec.candidate_information6;

Line 779: per_eca_shd.g_old_rec.candidate_information6;

775: per_eca_shd.g_old_rec.candidate_information5;
776: End If;
777: If (p_rec.candidate_information6 = hr_api.g_varchar2) then
778: p_rec.candidate_information6 :=
779: per_eca_shd.g_old_rec.candidate_information6;
780: End If;
781: If (p_rec.candidate_information7 = hr_api.g_varchar2) then
782: p_rec.candidate_information7 :=
783: per_eca_shd.g_old_rec.candidate_information7;

Line 783: per_eca_shd.g_old_rec.candidate_information7;

779: per_eca_shd.g_old_rec.candidate_information6;
780: End If;
781: If (p_rec.candidate_information7 = hr_api.g_varchar2) then
782: p_rec.candidate_information7 :=
783: per_eca_shd.g_old_rec.candidate_information7;
784: End If;
785: If (p_rec.candidate_information8 = hr_api.g_varchar2) then
786: p_rec.candidate_information8 :=
787: per_eca_shd.g_old_rec.candidate_information8;

Line 787: per_eca_shd.g_old_rec.candidate_information8;

783: per_eca_shd.g_old_rec.candidate_information7;
784: End If;
785: If (p_rec.candidate_information8 = hr_api.g_varchar2) then
786: p_rec.candidate_information8 :=
787: per_eca_shd.g_old_rec.candidate_information8;
788: End If;
789: If (p_rec.candidate_information9 = hr_api.g_varchar2) then
790: p_rec.candidate_information9 :=
791: per_eca_shd.g_old_rec.candidate_information9;

Line 791: per_eca_shd.g_old_rec.candidate_information9;

787: per_eca_shd.g_old_rec.candidate_information8;
788: End If;
789: If (p_rec.candidate_information9 = hr_api.g_varchar2) then
790: p_rec.candidate_information9 :=
791: per_eca_shd.g_old_rec.candidate_information9;
792: End If;
793: If (p_rec.candidate_information10 = hr_api.g_varchar2) then
794: p_rec.candidate_information10 :=
795: per_eca_shd.g_old_rec.candidate_information10;

Line 795: per_eca_shd.g_old_rec.candidate_information10;

791: per_eca_shd.g_old_rec.candidate_information9;
792: End If;
793: If (p_rec.candidate_information10 = hr_api.g_varchar2) then
794: p_rec.candidate_information10 :=
795: per_eca_shd.g_old_rec.candidate_information10;
796: End If;
797: If (p_rec.candidate_information11 = hr_api.g_varchar2) then
798: p_rec.candidate_information11 :=
799: per_eca_shd.g_old_rec.candidate_information11;

Line 799: per_eca_shd.g_old_rec.candidate_information11;

795: per_eca_shd.g_old_rec.candidate_information10;
796: End If;
797: If (p_rec.candidate_information11 = hr_api.g_varchar2) then
798: p_rec.candidate_information11 :=
799: per_eca_shd.g_old_rec.candidate_information11;
800: End If;
801: If (p_rec.candidate_information12 = hr_api.g_varchar2) then
802: p_rec.candidate_information12 :=
803: per_eca_shd.g_old_rec.candidate_information12;

Line 803: per_eca_shd.g_old_rec.candidate_information12;

799: per_eca_shd.g_old_rec.candidate_information11;
800: End If;
801: If (p_rec.candidate_information12 = hr_api.g_varchar2) then
802: p_rec.candidate_information12 :=
803: per_eca_shd.g_old_rec.candidate_information12;
804: End If;
805: If (p_rec.candidate_information13 = hr_api.g_varchar2) then
806: p_rec.candidate_information13 :=
807: per_eca_shd.g_old_rec.candidate_information13;

Line 807: per_eca_shd.g_old_rec.candidate_information13;

803: per_eca_shd.g_old_rec.candidate_information12;
804: End If;
805: If (p_rec.candidate_information13 = hr_api.g_varchar2) then
806: p_rec.candidate_information13 :=
807: per_eca_shd.g_old_rec.candidate_information13;
808: End If;
809: If (p_rec.candidate_information14 = hr_api.g_varchar2) then
810: p_rec.candidate_information14 :=
811: per_eca_shd.g_old_rec.candidate_information14;

Line 811: per_eca_shd.g_old_rec.candidate_information14;

807: per_eca_shd.g_old_rec.candidate_information13;
808: End If;
809: If (p_rec.candidate_information14 = hr_api.g_varchar2) then
810: p_rec.candidate_information14 :=
811: per_eca_shd.g_old_rec.candidate_information14;
812: End If;
813: If (p_rec.candidate_information15 = hr_api.g_varchar2) then
814: p_rec.candidate_information15 :=
815: per_eca_shd.g_old_rec.candidate_information15;

Line 815: per_eca_shd.g_old_rec.candidate_information15;

811: per_eca_shd.g_old_rec.candidate_information14;
812: End If;
813: If (p_rec.candidate_information15 = hr_api.g_varchar2) then
814: p_rec.candidate_information15 :=
815: per_eca_shd.g_old_rec.candidate_information15;
816: End If;
817: If (p_rec.candidate_information16 = hr_api.g_varchar2) then
818: p_rec.candidate_information16 :=
819: per_eca_shd.g_old_rec.candidate_information16;

Line 819: per_eca_shd.g_old_rec.candidate_information16;

815: per_eca_shd.g_old_rec.candidate_information15;
816: End If;
817: If (p_rec.candidate_information16 = hr_api.g_varchar2) then
818: p_rec.candidate_information16 :=
819: per_eca_shd.g_old_rec.candidate_information16;
820: End If;
821: If (p_rec.candidate_information17 = hr_api.g_varchar2) then
822: p_rec.candidate_information17 :=
823: per_eca_shd.g_old_rec.candidate_information17;

Line 823: per_eca_shd.g_old_rec.candidate_information17;

819: per_eca_shd.g_old_rec.candidate_information16;
820: End If;
821: If (p_rec.candidate_information17 = hr_api.g_varchar2) then
822: p_rec.candidate_information17 :=
823: per_eca_shd.g_old_rec.candidate_information17;
824: End If;
825: If (p_rec.candidate_information18 = hr_api.g_varchar2) then
826: p_rec.candidate_information18 :=
827: per_eca_shd.g_old_rec.candidate_information18;

Line 827: per_eca_shd.g_old_rec.candidate_information18;

823: per_eca_shd.g_old_rec.candidate_information17;
824: End If;
825: If (p_rec.candidate_information18 = hr_api.g_varchar2) then
826: p_rec.candidate_information18 :=
827: per_eca_shd.g_old_rec.candidate_information18;
828: End If;
829: If (p_rec.candidate_information19 = hr_api.g_varchar2) then
830: p_rec.candidate_information19 :=
831: per_eca_shd.g_old_rec.candidate_information19;

Line 831: per_eca_shd.g_old_rec.candidate_information19;

827: per_eca_shd.g_old_rec.candidate_information18;
828: End If;
829: If (p_rec.candidate_information19 = hr_api.g_varchar2) then
830: p_rec.candidate_information19 :=
831: per_eca_shd.g_old_rec.candidate_information19;
832: End If;
833: If (p_rec.candidate_information20 = hr_api.g_varchar2) then
834: p_rec.candidate_information20 :=
835: per_eca_shd.g_old_rec.candidate_information20;

Line 835: per_eca_shd.g_old_rec.candidate_information20;

831: per_eca_shd.g_old_rec.candidate_information19;
832: End If;
833: If (p_rec.candidate_information20 = hr_api.g_varchar2) then
834: p_rec.candidate_information20 :=
835: per_eca_shd.g_old_rec.candidate_information20;
836: End If;
837: If (p_rec.candidate_information21 = hr_api.g_varchar2) then
838: p_rec.candidate_information21 :=
839: per_eca_shd.g_old_rec.candidate_information21;

Line 839: per_eca_shd.g_old_rec.candidate_information21;

835: per_eca_shd.g_old_rec.candidate_information20;
836: End If;
837: If (p_rec.candidate_information21 = hr_api.g_varchar2) then
838: p_rec.candidate_information21 :=
839: per_eca_shd.g_old_rec.candidate_information21;
840: End If;
841: If (p_rec.candidate_information22 = hr_api.g_varchar2) then
842: p_rec.candidate_information22 :=
843: per_eca_shd.g_old_rec.candidate_information22;

Line 843: per_eca_shd.g_old_rec.candidate_information22;

839: per_eca_shd.g_old_rec.candidate_information21;
840: End If;
841: If (p_rec.candidate_information22 = hr_api.g_varchar2) then
842: p_rec.candidate_information22 :=
843: per_eca_shd.g_old_rec.candidate_information22;
844: End If;
845: If (p_rec.candidate_information23 = hr_api.g_varchar2) then
846: p_rec.candidate_information23 :=
847: per_eca_shd.g_old_rec.candidate_information23;

Line 847: per_eca_shd.g_old_rec.candidate_information23;

843: per_eca_shd.g_old_rec.candidate_information22;
844: End If;
845: If (p_rec.candidate_information23 = hr_api.g_varchar2) then
846: p_rec.candidate_information23 :=
847: per_eca_shd.g_old_rec.candidate_information23;
848: End If;
849: If (p_rec.candidate_information24 = hr_api.g_varchar2) then
850: p_rec.candidate_information24 :=
851: per_eca_shd.g_old_rec.candidate_information24;

Line 851: per_eca_shd.g_old_rec.candidate_information24;

847: per_eca_shd.g_old_rec.candidate_information23;
848: End If;
849: If (p_rec.candidate_information24 = hr_api.g_varchar2) then
850: p_rec.candidate_information24 :=
851: per_eca_shd.g_old_rec.candidate_information24;
852: End If;
853: If (p_rec.candidate_information25 = hr_api.g_varchar2) then
854: p_rec.candidate_information25 :=
855: per_eca_shd.g_old_rec.candidate_information25;

Line 855: per_eca_shd.g_old_rec.candidate_information25;

851: per_eca_shd.g_old_rec.candidate_information24;
852: End If;
853: If (p_rec.candidate_information25 = hr_api.g_varchar2) then
854: p_rec.candidate_information25 :=
855: per_eca_shd.g_old_rec.candidate_information25;
856: End If;
857: If (p_rec.candidate_information26 = hr_api.g_varchar2) then
858: p_rec.candidate_information26 :=
859: per_eca_shd.g_old_rec.candidate_information26;

Line 859: per_eca_shd.g_old_rec.candidate_information26;

855: per_eca_shd.g_old_rec.candidate_information25;
856: End If;
857: If (p_rec.candidate_information26 = hr_api.g_varchar2) then
858: p_rec.candidate_information26 :=
859: per_eca_shd.g_old_rec.candidate_information26;
860: End If;
861: If (p_rec.candidate_information27 = hr_api.g_varchar2) then
862: p_rec.candidate_information27 :=
863: per_eca_shd.g_old_rec.candidate_information27;

Line 863: per_eca_shd.g_old_rec.candidate_information27;

859: per_eca_shd.g_old_rec.candidate_information26;
860: End If;
861: If (p_rec.candidate_information27 = hr_api.g_varchar2) then
862: p_rec.candidate_information27 :=
863: per_eca_shd.g_old_rec.candidate_information27;
864: End If;
865: If (p_rec.candidate_information28 = hr_api.g_varchar2) then
866: p_rec.candidate_information28 :=
867: per_eca_shd.g_old_rec.candidate_information28;

Line 867: per_eca_shd.g_old_rec.candidate_information28;

863: per_eca_shd.g_old_rec.candidate_information27;
864: End If;
865: If (p_rec.candidate_information28 = hr_api.g_varchar2) then
866: p_rec.candidate_information28 :=
867: per_eca_shd.g_old_rec.candidate_information28;
868: End If;
869: If (p_rec.candidate_information29 = hr_api.g_varchar2) then
870: p_rec.candidate_information29 :=
871: per_eca_shd.g_old_rec.candidate_information29;

Line 871: per_eca_shd.g_old_rec.candidate_information29;

867: per_eca_shd.g_old_rec.candidate_information28;
868: End If;
869: If (p_rec.candidate_information29 = hr_api.g_varchar2) then
870: p_rec.candidate_information29 :=
871: per_eca_shd.g_old_rec.candidate_information29;
872: End If;
873: If (p_rec.candidate_information30 = hr_api.g_varchar2) then
874: p_rec.candidate_information30 :=
875: per_eca_shd.g_old_rec.candidate_information30;

Line 875: per_eca_shd.g_old_rec.candidate_information30;

871: per_eca_shd.g_old_rec.candidate_information29;
872: End If;
873: If (p_rec.candidate_information30 = hr_api.g_varchar2) then
874: p_rec.candidate_information30 :=
875: per_eca_shd.g_old_rec.candidate_information30;
876: End If;
877: --
878: End convert_defs;
879: --

Line 884: (p_rec in out nocopy per_eca_shd.g_rec_type

880: -- ----------------------------------------------------------------------------
881: -- |---------------------------------< upd >----------------------------------|
882: -- ----------------------------------------------------------------------------
883: Procedure upd
884: (p_rec in out nocopy per_eca_shd.g_rec_type
885: ,p_validate in boolean default false
886:
887: ) is
888: --

Line 906: per_eca_shd.lck

902:
903: --
904: -- We must lock the row which we need to update.
905: --
906: per_eca_shd.lck
907: (p_rec.election_candidate_id
908: ,p_rec.object_version_number
909: );
910: --

Line 1028: l_rec per_eca_shd.g_rec_type;

1024: ,p_candidate_information29 in varchar2 default hr_api.g_varchar2
1025: ,p_candidate_information30 in varchar2 default hr_api.g_varchar2
1026: ) is
1027: --
1028: l_rec per_eca_shd.g_rec_type;
1029: l_proc varchar2(72) := g_package||'upd';
1030: --
1031: Begin
1032: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1038: per_eca_shd.convert_args

1034: -- Call conversion function to turn arguments into the
1035: -- l_rec structure.
1036: --
1037: l_rec :=
1038: per_eca_shd.convert_args
1039: (p_election_candidate_id
1040: ,p_business_group_id
1041: ,p_election_id
1042: ,p_person_id