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_ECO_BUS dependencies on PER_ECO_SHD

Line 76: l_api_updating := per_eco_shd.api_updating

72: hr_utility.set_location(l_proc, 20);
73: --
74: -- Check if inserting or updating with modified values
75: --
76: l_api_updating := per_eco_shd.api_updating
77: (p_election_constituency_id => p_election_constituency_id
78: ,p_object_version_number => p_object_version_number
79: );
80: --

Line 81: if ((l_api_updating and per_eco_shd.g_old_rec.election_id <> p_election_id)

77: (p_election_constituency_id => p_election_constituency_id
78: ,p_object_version_number => p_object_version_number
79: );
80: --
81: if ((l_api_updating and per_eco_shd.g_old_rec.election_id <> p_election_id)
82: or
83: (NOT l_api_updating))
84: then
85: hr_utility.set_location(l_proc, 30);

Line 321: l_api_updating := per_eco_shd.api_updating

317: hr_utility.set_location(l_proc, 20);
318: --
319: -- Check if inserting or updating with modified values
320: --
321: l_api_updating := per_eco_shd.api_updating
322: (p_election_constituency_id => p_election_constituency_id
323: ,p_object_version_number => p_object_version_number
324: );
325: --

Line 326: if ((l_api_updating and per_eco_shd.g_old_rec.constituency_id <> p_constituency_id)

322: (p_election_constituency_id => p_election_constituency_id
323: ,p_object_version_number => p_object_version_number
324: );
325: --
326: if ((l_api_updating and per_eco_shd.g_old_rec.constituency_id <> p_constituency_id)
327: or
328: (NOT l_api_updating))
329: then
330: hr_utility.set_location(l_proc, 30);

Line 512: (p_rec in per_eco_shd.g_rec_type

508: -- Internal Row Handler Use Only.
509: --
510: -- ----------------------------------------------------------------------------
511: procedure chk_df
512: (p_rec in per_eco_shd.g_rec_type
513: ) is
514: --
515: l_proc varchar2(72) := g_package || 'chk_df';
516: --

Line 521: nvl(per_eco_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

517: begin
518: hr_utility.set_location('Entering:'||l_proc,10);
519: --
520: if ((p_rec.election_constituency_id is not null) and (
521: nvl(per_eco_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
523: nvl(per_eco_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute1, hr_api.g_varchar2) or
525: nvl(per_eco_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 523: nvl(per_eco_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

519: --
520: if ((p_rec.election_constituency_id is not null) and (
521: nvl(per_eco_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
523: nvl(per_eco_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute1, hr_api.g_varchar2) or
525: nvl(per_eco_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute2, hr_api.g_varchar2) or
527: nvl(per_eco_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 525: nvl(per_eco_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

521: nvl(per_eco_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
523: nvl(per_eco_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute1, hr_api.g_varchar2) or
525: nvl(per_eco_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute2, hr_api.g_varchar2) or
527: nvl(per_eco_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute3, hr_api.g_varchar2) or
529: nvl(per_eco_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 527: nvl(per_eco_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

523: nvl(per_eco_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute1, hr_api.g_varchar2) or
525: nvl(per_eco_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute2, hr_api.g_varchar2) or
527: nvl(per_eco_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute3, hr_api.g_varchar2) or
529: nvl(per_eco_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute4, hr_api.g_varchar2) or
531: nvl(per_eco_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 529: nvl(per_eco_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

525: nvl(per_eco_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute2, hr_api.g_varchar2) or
527: nvl(per_eco_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute3, hr_api.g_varchar2) or
529: nvl(per_eco_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute4, hr_api.g_varchar2) or
531: nvl(per_eco_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute5, hr_api.g_varchar2) or
533: nvl(per_eco_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 531: nvl(per_eco_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

527: nvl(per_eco_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute3, hr_api.g_varchar2) or
529: nvl(per_eco_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute4, hr_api.g_varchar2) or
531: nvl(per_eco_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute5, hr_api.g_varchar2) or
533: nvl(per_eco_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute6, hr_api.g_varchar2) or
535: nvl(per_eco_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 533: nvl(per_eco_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

529: nvl(per_eco_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute4, hr_api.g_varchar2) or
531: nvl(per_eco_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute5, hr_api.g_varchar2) or
533: nvl(per_eco_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute6, hr_api.g_varchar2) or
535: nvl(per_eco_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute7, hr_api.g_varchar2) or
537: nvl(per_eco_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 535: nvl(per_eco_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

531: nvl(per_eco_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute5, hr_api.g_varchar2) or
533: nvl(per_eco_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute6, hr_api.g_varchar2) or
535: nvl(per_eco_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute7, hr_api.g_varchar2) or
537: nvl(per_eco_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute8, hr_api.g_varchar2) or
539: nvl(per_eco_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 537: nvl(per_eco_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

533: nvl(per_eco_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute6, hr_api.g_varchar2) or
535: nvl(per_eco_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute7, hr_api.g_varchar2) or
537: nvl(per_eco_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute8, hr_api.g_varchar2) or
539: nvl(per_eco_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute9, hr_api.g_varchar2) or
541: nvl(per_eco_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 539: nvl(per_eco_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

535: nvl(per_eco_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute7, hr_api.g_varchar2) or
537: nvl(per_eco_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute8, hr_api.g_varchar2) or
539: nvl(per_eco_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute9, hr_api.g_varchar2) or
541: nvl(per_eco_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute10, hr_api.g_varchar2) or
543: nvl(per_eco_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 541: nvl(per_eco_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

537: nvl(per_eco_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute8, hr_api.g_varchar2) or
539: nvl(per_eco_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute9, hr_api.g_varchar2) or
541: nvl(per_eco_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute10, hr_api.g_varchar2) or
543: nvl(per_eco_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute11, hr_api.g_varchar2) or
545: nvl(per_eco_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 543: nvl(per_eco_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

539: nvl(per_eco_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute9, hr_api.g_varchar2) or
541: nvl(per_eco_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute10, hr_api.g_varchar2) or
543: nvl(per_eco_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute11, hr_api.g_varchar2) or
545: nvl(per_eco_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute12, hr_api.g_varchar2) or
547: nvl(per_eco_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 545: nvl(per_eco_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

541: nvl(per_eco_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute10, hr_api.g_varchar2) or
543: nvl(per_eco_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute11, hr_api.g_varchar2) or
545: nvl(per_eco_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute12, hr_api.g_varchar2) or
547: nvl(per_eco_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute13, hr_api.g_varchar2) or
549: nvl(per_eco_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 547: nvl(per_eco_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

543: nvl(per_eco_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute11, hr_api.g_varchar2) or
545: nvl(per_eco_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute12, hr_api.g_varchar2) or
547: nvl(per_eco_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute13, hr_api.g_varchar2) or
549: nvl(per_eco_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute14, hr_api.g_varchar2) or
551: nvl(per_eco_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 549: nvl(per_eco_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

545: nvl(per_eco_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute12, hr_api.g_varchar2) or
547: nvl(per_eco_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute13, hr_api.g_varchar2) or
549: nvl(per_eco_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute14, hr_api.g_varchar2) or
551: nvl(per_eco_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
552: nvl(p_rec.attribute15, hr_api.g_varchar2) or
553: nvl(per_eco_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 551: nvl(per_eco_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

547: nvl(per_eco_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute13, hr_api.g_varchar2) or
549: nvl(per_eco_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute14, hr_api.g_varchar2) or
551: nvl(per_eco_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
552: nvl(p_rec.attribute15, hr_api.g_varchar2) or
553: nvl(per_eco_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
554: nvl(p_rec.attribute16, hr_api.g_varchar2) or
555: nvl(per_eco_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 553: nvl(per_eco_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

549: nvl(per_eco_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute14, hr_api.g_varchar2) or
551: nvl(per_eco_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
552: nvl(p_rec.attribute15, hr_api.g_varchar2) or
553: nvl(per_eco_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
554: nvl(p_rec.attribute16, hr_api.g_varchar2) or
555: nvl(per_eco_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
556: nvl(p_rec.attribute17, hr_api.g_varchar2) or
557: nvl(per_eco_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 555: nvl(per_eco_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

551: nvl(per_eco_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
552: nvl(p_rec.attribute15, hr_api.g_varchar2) or
553: nvl(per_eco_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
554: nvl(p_rec.attribute16, hr_api.g_varchar2) or
555: nvl(per_eco_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
556: nvl(p_rec.attribute17, hr_api.g_varchar2) or
557: nvl(per_eco_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
558: nvl(p_rec.attribute18, hr_api.g_varchar2) or
559: nvl(per_eco_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 557: nvl(per_eco_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

553: nvl(per_eco_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
554: nvl(p_rec.attribute16, hr_api.g_varchar2) or
555: nvl(per_eco_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
556: nvl(p_rec.attribute17, hr_api.g_varchar2) or
557: nvl(per_eco_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
558: nvl(p_rec.attribute18, hr_api.g_varchar2) or
559: nvl(per_eco_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
560: nvl(p_rec.attribute19, hr_api.g_varchar2) or
561: nvl(per_eco_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 559: nvl(per_eco_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

555: nvl(per_eco_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
556: nvl(p_rec.attribute17, hr_api.g_varchar2) or
557: nvl(per_eco_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
558: nvl(p_rec.attribute18, hr_api.g_varchar2) or
559: nvl(per_eco_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
560: nvl(p_rec.attribute19, hr_api.g_varchar2) or
561: nvl(per_eco_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
562: nvl(p_rec.attribute20, hr_api.g_varchar2) or
563: nvl(per_eco_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 561: nvl(per_eco_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

557: nvl(per_eco_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
558: nvl(p_rec.attribute18, hr_api.g_varchar2) or
559: nvl(per_eco_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
560: nvl(p_rec.attribute19, hr_api.g_varchar2) or
561: nvl(per_eco_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
562: nvl(p_rec.attribute20, hr_api.g_varchar2) or
563: nvl(per_eco_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
564: nvl(p_rec.attribute21, hr_api.g_varchar2) or
565: nvl(per_eco_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 563: nvl(per_eco_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

559: nvl(per_eco_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
560: nvl(p_rec.attribute19, hr_api.g_varchar2) or
561: nvl(per_eco_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
562: nvl(p_rec.attribute20, hr_api.g_varchar2) or
563: nvl(per_eco_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
564: nvl(p_rec.attribute21, hr_api.g_varchar2) or
565: nvl(per_eco_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
566: nvl(p_rec.attribute22, hr_api.g_varchar2) or
567: nvl(per_eco_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 565: nvl(per_eco_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

561: nvl(per_eco_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
562: nvl(p_rec.attribute20, hr_api.g_varchar2) or
563: nvl(per_eco_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
564: nvl(p_rec.attribute21, hr_api.g_varchar2) or
565: nvl(per_eco_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
566: nvl(p_rec.attribute22, hr_api.g_varchar2) or
567: nvl(per_eco_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
568: nvl(p_rec.attribute23, hr_api.g_varchar2) or
569: nvl(per_eco_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 567: nvl(per_eco_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

563: nvl(per_eco_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
564: nvl(p_rec.attribute21, hr_api.g_varchar2) or
565: nvl(per_eco_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
566: nvl(p_rec.attribute22, hr_api.g_varchar2) or
567: nvl(per_eco_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
568: nvl(p_rec.attribute23, hr_api.g_varchar2) or
569: nvl(per_eco_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
570: nvl(p_rec.attribute24, hr_api.g_varchar2) or
571: nvl(per_eco_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 569: nvl(per_eco_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

565: nvl(per_eco_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
566: nvl(p_rec.attribute22, hr_api.g_varchar2) or
567: nvl(per_eco_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
568: nvl(p_rec.attribute23, hr_api.g_varchar2) or
569: nvl(per_eco_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
570: nvl(p_rec.attribute24, hr_api.g_varchar2) or
571: nvl(per_eco_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
572: nvl(p_rec.attribute25, hr_api.g_varchar2) or
573: nvl(per_eco_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 571: nvl(per_eco_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

567: nvl(per_eco_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
568: nvl(p_rec.attribute23, hr_api.g_varchar2) or
569: nvl(per_eco_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
570: nvl(p_rec.attribute24, hr_api.g_varchar2) or
571: nvl(per_eco_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
572: nvl(p_rec.attribute25, hr_api.g_varchar2) or
573: nvl(per_eco_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
574: nvl(p_rec.attribute26, hr_api.g_varchar2) or
575: nvl(per_eco_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 573: nvl(per_eco_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

569: nvl(per_eco_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
570: nvl(p_rec.attribute24, hr_api.g_varchar2) or
571: nvl(per_eco_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
572: nvl(p_rec.attribute25, hr_api.g_varchar2) or
573: nvl(per_eco_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
574: nvl(p_rec.attribute26, hr_api.g_varchar2) or
575: nvl(per_eco_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
576: nvl(p_rec.attribute27, hr_api.g_varchar2) or
577: nvl(per_eco_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 575: nvl(per_eco_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

571: nvl(per_eco_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
572: nvl(p_rec.attribute25, hr_api.g_varchar2) or
573: nvl(per_eco_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
574: nvl(p_rec.attribute26, hr_api.g_varchar2) or
575: nvl(per_eco_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
576: nvl(p_rec.attribute27, hr_api.g_varchar2) or
577: nvl(per_eco_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
578: nvl(p_rec.attribute28, hr_api.g_varchar2) or
579: nvl(per_eco_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 577: nvl(per_eco_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

573: nvl(per_eco_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
574: nvl(p_rec.attribute26, hr_api.g_varchar2) or
575: nvl(per_eco_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
576: nvl(p_rec.attribute27, hr_api.g_varchar2) or
577: nvl(per_eco_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
578: nvl(p_rec.attribute28, hr_api.g_varchar2) or
579: nvl(per_eco_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
580: nvl(p_rec.attribute29, hr_api.g_varchar2) or
581: nvl(per_eco_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 579: nvl(per_eco_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

575: nvl(per_eco_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
576: nvl(p_rec.attribute27, hr_api.g_varchar2) or
577: nvl(per_eco_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
578: nvl(p_rec.attribute28, hr_api.g_varchar2) or
579: nvl(per_eco_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
580: nvl(p_rec.attribute29, hr_api.g_varchar2) or
581: nvl(per_eco_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
582: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
583: or (p_rec.election_constituency_id is null) then

Line 581: nvl(per_eco_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

577: nvl(per_eco_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
578: nvl(p_rec.attribute28, hr_api.g_varchar2) or
579: nvl(per_eco_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
580: nvl(p_rec.attribute29, hr_api.g_varchar2) or
581: nvl(per_eco_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
582: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
583: or (p_rec.election_constituency_id is null) then
584: --
585: -- Only execute the validation if absolutely necessary:

Line 689: ,p_rec in per_eco_shd.g_rec_type

685: -- {End Of Comments}
686: -- ----------------------------------------------------------------------------
687: Procedure chk_non_updateable_args
688: (p_effective_date in date
689: ,p_rec in per_eco_shd.g_rec_type
690: ) IS
691: --
692: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
693: l_error EXCEPTION;

Line 701: IF NOT per_eco_shd.api_updating

697: --
698: -- Only proceed with the validation if a row exists for the current
699: -- record in the HR Schema.
700: --
701: IF NOT per_eco_shd.api_updating
702: (p_election_constituency_id => p_rec.election_constituency_id
703: ,p_object_version_number => p_rec.object_version_number
704: ) THEN
705: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 728: ,p_rec in per_eco_shd.g_rec_type

724: -- |---------------------------< insert_validate >----------------------------|
725: -- ----------------------------------------------------------------------------
726: Procedure insert_validate
727: (p_effective_date in date
728: ,p_rec in per_eco_shd.g_rec_type
729: ) is
730: --
731: l_proc varchar2(72) := g_package||'insert_validate';
732: --

Line 774: ,p_rec in per_eco_shd.g_rec_type

770: -- |---------------------------< update_validate >----------------------------|
771: -- ----------------------------------------------------------------------------
772: Procedure update_validate
773: (p_effective_date in date
774: ,p_rec in per_eco_shd.g_rec_type
775: ) is
776: --
777: l_proc varchar2(72) := g_package||'update_validate';
778: --

Line 824: (p_rec in per_eco_shd.g_rec_type

820: -- ----------------------------------------------------------------------------
821: -- |---------------------------< delete_validate >----------------------------|
822: -- ----------------------------------------------------------------------------
823: Procedure delete_validate
824: (p_rec in per_eco_shd.g_rec_type
825: ) is
826: --
827: l_proc varchar2(72) := g_package||'delete_validate';
828: --