APPS.PE_POI_BUS dependencies on HR_API

Line 54: hr_api.mandatory_arg_error

50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: --
52: -- Ensure that all the mandatory parameter are not null
53: --
54: hr_api.mandatory_arg_error
55: (p_api_name => l_proc
56: ,p_argument => 'position_extra_info_id'
57: ,p_argument_value => p_position_extra_info_id
58: );

Line 77: hr_api.set_security_group_id

73: close csr_sec_grp;
74: --
75: -- Set the security_group_id in CLIENT_INFO
76: --
77: hr_api.set_security_group_id
78: (p_security_group_id => l_security_group_id
79: );
80: --
81: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 123: hr_api.mandatory_arg_error

119: --
120: --
121: -- Ensure that all the mandatory parameter are not null
122: --
123: hr_api.mandatory_arg_error
124: (p_api_name => l_proc
125: ,p_argument => 'position_extra_info_id'
126: ,p_argument_value => p_position_extra_info_id
127: );

Line 129: if ( nvl(pe_poi_bus.g_position_extra_info_id, hr_api.g_number)

125: ,p_argument => 'position_extra_info_id'
126: ,p_argument_value => p_position_extra_info_id
127: );
128: --
129: if ( nvl(pe_poi_bus.g_position_extra_info_id, hr_api.g_number)
130: = p_position_extra_info_id) then
131: --
132: -- The legislation code has already been found with a previous
133: -- call to this function. Just return the value in the global

Line 218: hr_api.mandatory_arg_error

214: hr_utility.set_location('Entering:'||l_proc, 1);
215: --
216: -- Check mandatory parameters have been set
217: --
218: hr_api.mandatory_arg_error
219: (
220: p_api_name => l_proc,
221: p_argument => 'information_type',
222: p_argument_value => p_information_type

Line 299: hr_api.mandatory_arg_error

295: hr_utility.set_location('Entering:'||l_proc, 1);
296: --
297: -- Check mandatory parameters have been set
298: --
299: hr_api.mandatory_arg_error
300: (
301: p_api_name => l_proc,
302: p_argument => 'position_id',
303: p_argument_value => p_position_id

Line 464: if nvl(p_rec.information_type, hr_api.g_varchar2) <>

460: end if;
461: --
462: hr_utility.set_location(l_proc, 30);
463: --
464: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
465: nvl(pe_poi_shd.g_old_rec.information_type, hr_api.g_varchar2) then
466: l_argument := 'information_type';
467: raise l_error;
468: end if;

Line 465: nvl(pe_poi_shd.g_old_rec.information_type, hr_api.g_varchar2) then

461: --
462: hr_utility.set_location(l_proc, 30);
463: --
464: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
465: nvl(pe_poi_shd.g_old_rec.information_type, hr_api.g_varchar2) then
466: l_argument := 'information_type';
467: raise l_error;
468: end if;
469: --

Line 472: if nvl(p_rec.position_id, hr_api.g_number) <>

468: end if;
469: --
470: hr_utility.set_location(l_proc, 40);
471: --
472: if nvl(p_rec.position_id, hr_api.g_number) <>
473: nvl(pe_poi_shd.g_old_rec.position_id, hr_api.g_number) then
474: l_argument := 'position_id';
475: raise l_error;
476: end if;

Line 473: nvl(pe_poi_shd.g_old_rec.position_id, hr_api.g_number) then

469: --
470: hr_utility.set_location(l_proc, 40);
471: --
472: if nvl(p_rec.position_id, hr_api.g_number) <>
473: nvl(pe_poi_shd.g_old_rec.position_id, hr_api.g_number) then
474: l_argument := 'position_id';
475: raise l_error;
476: end if;
477: --

Line 481: hr_api.argument_changed_error

477: --
478: hr_utility.set_location(' Leaving:'||l_proc, 50);
479: exception
480: when l_error then
481: hr_api.argument_changed_error
482: (p_api_name => l_proc
483: ,p_argument => l_argument
484: );
485: hr_utility.set_location(l_proc, 60);

Line 527: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>

523: begin
524: hr_utility.set_location('Entering:'||l_proc, 10);
525: --
526: if ((p_rec.position_extra_info_id is not null) and (
527: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
528: nvl(p_rec.poei_attribute_category, hr_api.g_varchar2) or
529: nvl(pe_poi_shd.g_old_rec.poei_attribute1, hr_api.g_varchar2) <>
530: nvl(p_rec.poei_attribute1, hr_api.g_varchar2) or
531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>

Line 528: nvl(p_rec.poei_attribute_category, hr_api.g_varchar2) or

524: hr_utility.set_location('Entering:'||l_proc, 10);
525: --
526: if ((p_rec.position_extra_info_id is not null) and (
527: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
528: nvl(p_rec.poei_attribute_category, hr_api.g_varchar2) or
529: nvl(pe_poi_shd.g_old_rec.poei_attribute1, hr_api.g_varchar2) <>
530: nvl(p_rec.poei_attribute1, hr_api.g_varchar2) or
531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>
532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or

Line 529: nvl(pe_poi_shd.g_old_rec.poei_attribute1, hr_api.g_varchar2) <>

525: --
526: if ((p_rec.position_extra_info_id is not null) and (
527: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
528: nvl(p_rec.poei_attribute_category, hr_api.g_varchar2) or
529: nvl(pe_poi_shd.g_old_rec.poei_attribute1, hr_api.g_varchar2) <>
530: nvl(p_rec.poei_attribute1, hr_api.g_varchar2) or
531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>
532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or
533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>

Line 530: nvl(p_rec.poei_attribute1, hr_api.g_varchar2) or

526: if ((p_rec.position_extra_info_id is not null) and (
527: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
528: nvl(p_rec.poei_attribute_category, hr_api.g_varchar2) or
529: nvl(pe_poi_shd.g_old_rec.poei_attribute1, hr_api.g_varchar2) <>
530: nvl(p_rec.poei_attribute1, hr_api.g_varchar2) or
531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>
532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or
533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>
534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or

Line 531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>

527: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
528: nvl(p_rec.poei_attribute_category, hr_api.g_varchar2) or
529: nvl(pe_poi_shd.g_old_rec.poei_attribute1, hr_api.g_varchar2) <>
530: nvl(p_rec.poei_attribute1, hr_api.g_varchar2) or
531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>
532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or
533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>
534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or
535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>

Line 532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or

528: nvl(p_rec.poei_attribute_category, hr_api.g_varchar2) or
529: nvl(pe_poi_shd.g_old_rec.poei_attribute1, hr_api.g_varchar2) <>
530: nvl(p_rec.poei_attribute1, hr_api.g_varchar2) or
531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>
532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or
533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>
534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or
535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>
536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or

Line 533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>

529: nvl(pe_poi_shd.g_old_rec.poei_attribute1, hr_api.g_varchar2) <>
530: nvl(p_rec.poei_attribute1, hr_api.g_varchar2) or
531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>
532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or
533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>
534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or
535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>
536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or
537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>

Line 534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or

530: nvl(p_rec.poei_attribute1, hr_api.g_varchar2) or
531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>
532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or
533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>
534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or
535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>
536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or
537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>
538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or

Line 535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>

531: nvl(pe_poi_shd.g_old_rec.poei_attribute2, hr_api.g_varchar2) <>
532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or
533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>
534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or
535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>
536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or
537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>
538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or
539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>

Line 536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or

532: nvl(p_rec.poei_attribute2, hr_api.g_varchar2) or
533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>
534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or
535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>
536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or
537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>
538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or
539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>
540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or

Line 537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>

533: nvl(pe_poi_shd.g_old_rec.poei_attribute3, hr_api.g_varchar2) <>
534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or
535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>
536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or
537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>
538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or
539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>
540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or
541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>

Line 538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or

534: nvl(p_rec.poei_attribute3, hr_api.g_varchar2) or
535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>
536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or
537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>
538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or
539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>
540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or
541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>
542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or

Line 539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>

535: nvl(pe_poi_shd.g_old_rec.poei_attribute4, hr_api.g_varchar2) <>
536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or
537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>
538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or
539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>
540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or
541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>
542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or
543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>

Line 540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or

536: nvl(p_rec.poei_attribute4, hr_api.g_varchar2) or
537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>
538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or
539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>
540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or
541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>
542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or
543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>
544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or

Line 541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>

537: nvl(pe_poi_shd.g_old_rec.poei_attribute5, hr_api.g_varchar2) <>
538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or
539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>
540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or
541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>
542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or
543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>
544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or
545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>

Line 542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or

538: nvl(p_rec.poei_attribute5, hr_api.g_varchar2) or
539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>
540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or
541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>
542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or
543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>
544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or
545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>
546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or

Line 543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>

539: nvl(pe_poi_shd.g_old_rec.poei_attribute6, hr_api.g_varchar2) <>
540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or
541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>
542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or
543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>
544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or
545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>
546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or
547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>

Line 544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or

540: nvl(p_rec.poei_attribute6, hr_api.g_varchar2) or
541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>
542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or
543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>
544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or
545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>
546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or
547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>
548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or

Line 545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>

541: nvl(pe_poi_shd.g_old_rec.poei_attribute7, hr_api.g_varchar2) <>
542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or
543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>
544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or
545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>
546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or
547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>
548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or
549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>

Line 546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or

542: nvl(p_rec.poei_attribute7, hr_api.g_varchar2) or
543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>
544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or
545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>
546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or
547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>
548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or
549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>
550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or

Line 547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>

543: nvl(pe_poi_shd.g_old_rec.poei_attribute8, hr_api.g_varchar2) <>
544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or
545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>
546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or
547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>
548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or
549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>
550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or
551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>

Line 548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or

544: nvl(p_rec.poei_attribute8, hr_api.g_varchar2) or
545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>
546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or
547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>
548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or
549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>
550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or
551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>
552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or

Line 549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>

545: nvl(pe_poi_shd.g_old_rec.poei_attribute9, hr_api.g_varchar2) <>
546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or
547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>
548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or
549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>
550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or
551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>
552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or
553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>

Line 550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or

546: nvl(p_rec.poei_attribute9, hr_api.g_varchar2) or
547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>
548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or
549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>
550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or
551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>
552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or
553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>
554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or

Line 551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>

547: nvl(pe_poi_shd.g_old_rec.poei_attribute10, hr_api.g_varchar2) <>
548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or
549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>
550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or
551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>
552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or
553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>
554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or
555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>

Line 552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or

548: nvl(p_rec.poei_attribute10, hr_api.g_varchar2) or
549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>
550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or
551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>
552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or
553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>
554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or
555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>
556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or

Line 553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>

549: nvl(pe_poi_shd.g_old_rec.poei_attribute11, hr_api.g_varchar2) <>
550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or
551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>
552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or
553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>
554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or
555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>
556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or
557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>

Line 554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or

550: nvl(p_rec.poei_attribute11, hr_api.g_varchar2) or
551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>
552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or
553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>
554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or
555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>
556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or
557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>
558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or

Line 555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>

551: nvl(pe_poi_shd.g_old_rec.poei_attribute12, hr_api.g_varchar2) <>
552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or
553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>
554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or
555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>
556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or
557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>
558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or
559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>

Line 556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or

552: nvl(p_rec.poei_attribute12, hr_api.g_varchar2) or
553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>
554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or
555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>
556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or
557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>
558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or
559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>
560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or

Line 557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>

553: nvl(pe_poi_shd.g_old_rec.poei_attribute13, hr_api.g_varchar2) <>
554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or
555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>
556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or
557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>
558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or
559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>
560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or
561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>

Line 558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or

554: nvl(p_rec.poei_attribute13, hr_api.g_varchar2) or
555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>
556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or
557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>
558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or
559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>
560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or
561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>
562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or

Line 559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>

555: nvl(pe_poi_shd.g_old_rec.poei_attribute14, hr_api.g_varchar2) <>
556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or
557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>
558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or
559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>
560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or
561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>
562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or
563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>

Line 560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or

556: nvl(p_rec.poei_attribute14, hr_api.g_varchar2) or
557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>
558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or
559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>
560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or
561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>
562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or
563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>
564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or

Line 561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>

557: nvl(pe_poi_shd.g_old_rec.poei_attribute15, hr_api.g_varchar2) <>
558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or
559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>
560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or
561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>
562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or
563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>
564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or
565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>

Line 562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or

558: nvl(p_rec.poei_attribute15, hr_api.g_varchar2) or
559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>
560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or
561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>
562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or
563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>
564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or
565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>
566: nvl(p_rec.poei_attribute19, hr_api.g_varchar2) or

Line 563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>

559: nvl(pe_poi_shd.g_old_rec.poei_attribute16, hr_api.g_varchar2) <>
560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or
561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>
562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or
563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>
564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or
565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>
566: nvl(p_rec.poei_attribute19, hr_api.g_varchar2) or
567: nvl(pe_poi_shd.g_old_rec.poei_attribute20, hr_api.g_varchar2) <>

Line 564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or

560: nvl(p_rec.poei_attribute16, hr_api.g_varchar2) or
561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>
562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or
563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>
564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or
565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>
566: nvl(p_rec.poei_attribute19, hr_api.g_varchar2) or
567: nvl(pe_poi_shd.g_old_rec.poei_attribute20, hr_api.g_varchar2) <>
568: nvl(p_rec.poei_attribute20, hr_api.g_varchar2)))

Line 565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>

561: nvl(pe_poi_shd.g_old_rec.poei_attribute17, hr_api.g_varchar2) <>
562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or
563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>
564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or
565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>
566: nvl(p_rec.poei_attribute19, hr_api.g_varchar2) or
567: nvl(pe_poi_shd.g_old_rec.poei_attribute20, hr_api.g_varchar2) <>
568: nvl(p_rec.poei_attribute20, hr_api.g_varchar2)))
569: or

Line 566: nvl(p_rec.poei_attribute19, hr_api.g_varchar2) or

562: nvl(p_rec.poei_attribute17, hr_api.g_varchar2) or
563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>
564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or
565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>
566: nvl(p_rec.poei_attribute19, hr_api.g_varchar2) or
567: nvl(pe_poi_shd.g_old_rec.poei_attribute20, hr_api.g_varchar2) <>
568: nvl(p_rec.poei_attribute20, hr_api.g_varchar2)))
569: or
570: (p_rec.position_extra_info_id is null) then

Line 567: nvl(pe_poi_shd.g_old_rec.poei_attribute20, hr_api.g_varchar2) <>

563: nvl(pe_poi_shd.g_old_rec.poei_attribute18, hr_api.g_varchar2) <>
564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or
565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>
566: nvl(p_rec.poei_attribute19, hr_api.g_varchar2) or
567: nvl(pe_poi_shd.g_old_rec.poei_attribute20, hr_api.g_varchar2) <>
568: nvl(p_rec.poei_attribute20, hr_api.g_varchar2)))
569: or
570: (p_rec.position_extra_info_id is null) then
571: --

Line 568: nvl(p_rec.poei_attribute20, hr_api.g_varchar2)))

564: nvl(p_rec.poei_attribute18, hr_api.g_varchar2) or
565: nvl(pe_poi_shd.g_old_rec.poei_attribute19, hr_api.g_varchar2) <>
566: nvl(p_rec.poei_attribute19, hr_api.g_varchar2) or
567: nvl(pe_poi_shd.g_old_rec.poei_attribute20, hr_api.g_varchar2) <>
568: nvl(p_rec.poei_attribute20, hr_api.g_varchar2)))
569: or
570: (p_rec.position_extra_info_id is null) then
571: --
572: -- Only execute the validation if absolutely necessary:

Line 672: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>

668: --
669: if (p_rec.position_extra_info_id is null)
670: or ((p_rec.position_extra_info_id is not null)
671: and
672: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
673: nvl(p_rec.poei_information_category, hr_api.g_varchar2) or
674: nvl(pe_poi_shd.g_old_rec.poei_information1, hr_api.g_varchar2) <>
675: nvl(p_rec.poei_information1, hr_api.g_varchar2) or
676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>

Line 673: nvl(p_rec.poei_information_category, hr_api.g_varchar2) or

669: if (p_rec.position_extra_info_id is null)
670: or ((p_rec.position_extra_info_id is not null)
671: and
672: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
673: nvl(p_rec.poei_information_category, hr_api.g_varchar2) or
674: nvl(pe_poi_shd.g_old_rec.poei_information1, hr_api.g_varchar2) <>
675: nvl(p_rec.poei_information1, hr_api.g_varchar2) or
676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>
677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or

Line 674: nvl(pe_poi_shd.g_old_rec.poei_information1, hr_api.g_varchar2) <>

670: or ((p_rec.position_extra_info_id is not null)
671: and
672: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
673: nvl(p_rec.poei_information_category, hr_api.g_varchar2) or
674: nvl(pe_poi_shd.g_old_rec.poei_information1, hr_api.g_varchar2) <>
675: nvl(p_rec.poei_information1, hr_api.g_varchar2) or
676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>
677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or
678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>

Line 675: nvl(p_rec.poei_information1, hr_api.g_varchar2) or

671: and
672: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
673: nvl(p_rec.poei_information_category, hr_api.g_varchar2) or
674: nvl(pe_poi_shd.g_old_rec.poei_information1, hr_api.g_varchar2) <>
675: nvl(p_rec.poei_information1, hr_api.g_varchar2) or
676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>
677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or
678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>
679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or

Line 676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>

672: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
673: nvl(p_rec.poei_information_category, hr_api.g_varchar2) or
674: nvl(pe_poi_shd.g_old_rec.poei_information1, hr_api.g_varchar2) <>
675: nvl(p_rec.poei_information1, hr_api.g_varchar2) or
676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>
677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or
678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>
679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or
680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>

Line 677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or

673: nvl(p_rec.poei_information_category, hr_api.g_varchar2) or
674: nvl(pe_poi_shd.g_old_rec.poei_information1, hr_api.g_varchar2) <>
675: nvl(p_rec.poei_information1, hr_api.g_varchar2) or
676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>
677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or
678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>
679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or
680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>
681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or

Line 678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>

674: nvl(pe_poi_shd.g_old_rec.poei_information1, hr_api.g_varchar2) <>
675: nvl(p_rec.poei_information1, hr_api.g_varchar2) or
676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>
677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or
678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>
679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or
680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>
681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or
682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>

Line 679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or

675: nvl(p_rec.poei_information1, hr_api.g_varchar2) or
676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>
677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or
678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>
679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or
680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>
681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or
682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>
683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or

Line 680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>

676: nvl(pe_poi_shd.g_old_rec.poei_information2, hr_api.g_varchar2) <>
677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or
678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>
679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or
680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>
681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or
682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>
683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or
684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>

Line 681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or

677: nvl(p_rec.poei_information2, hr_api.g_varchar2) or
678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>
679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or
680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>
681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or
682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>
683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or
684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>
685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or

Line 682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>

678: nvl(pe_poi_shd.g_old_rec.poei_information3, hr_api.g_varchar2) <>
679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or
680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>
681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or
682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>
683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or
684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>
685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or
686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>

Line 683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or

679: nvl(p_rec.poei_information3, hr_api.g_varchar2) or
680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>
681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or
682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>
683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or
684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>
685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or
686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>
687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or

Line 684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>

680: nvl(pe_poi_shd.g_old_rec.poei_information4, hr_api.g_varchar2) <>
681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or
682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>
683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or
684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>
685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or
686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>
687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or
688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>

Line 685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or

681: nvl(p_rec.poei_information4, hr_api.g_varchar2) or
682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>
683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or
684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>
685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or
686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>
687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or
688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>
689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or

Line 686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>

682: nvl(pe_poi_shd.g_old_rec.poei_information5, hr_api.g_varchar2) <>
683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or
684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>
685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or
686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>
687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or
688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>
689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or
690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>

Line 687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or

683: nvl(p_rec.poei_information5, hr_api.g_varchar2) or
684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>
685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or
686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>
687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or
688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>
689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or
690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>
691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or

Line 688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>

684: nvl(pe_poi_shd.g_old_rec.poei_information6, hr_api.g_varchar2) <>
685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or
686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>
687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or
688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>
689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or
690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>
691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or
692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>

Line 689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or

685: nvl(p_rec.poei_information6, hr_api.g_varchar2) or
686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>
687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or
688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>
689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or
690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>
691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or
692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>
693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or

Line 690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>

686: nvl(pe_poi_shd.g_old_rec.poei_information7, hr_api.g_varchar2) <>
687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or
688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>
689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or
690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>
691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or
692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>
693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or
694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>

Line 691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or

687: nvl(p_rec.poei_information7, hr_api.g_varchar2) or
688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>
689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or
690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>
691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or
692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>
693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or
694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>
695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or

Line 692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>

688: nvl(pe_poi_shd.g_old_rec.poei_information8, hr_api.g_varchar2) <>
689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or
690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>
691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or
692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>
693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or
694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>
695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or
696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>

Line 693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or

689: nvl(p_rec.poei_information8, hr_api.g_varchar2) or
690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>
691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or
692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>
693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or
694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>
695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or
696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>
697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or

Line 694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>

690: nvl(pe_poi_shd.g_old_rec.poei_information9, hr_api.g_varchar2) <>
691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or
692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>
693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or
694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>
695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or
696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>
697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or
698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>

Line 695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or

691: nvl(p_rec.poei_information9, hr_api.g_varchar2) or
692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>
693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or
694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>
695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or
696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>
697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or
698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>
699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or

Line 696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>

692: nvl(pe_poi_shd.g_old_rec.poei_information10, hr_api.g_varchar2) <>
693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or
694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>
695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or
696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>
697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or
698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>
699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or
700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>

Line 697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or

693: nvl(p_rec.poei_information10, hr_api.g_varchar2) or
694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>
695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or
696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>
697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or
698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>
699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or
700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>
701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or

Line 698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>

694: nvl(pe_poi_shd.g_old_rec.poei_information11, hr_api.g_varchar2) <>
695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or
696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>
697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or
698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>
699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or
700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>
701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or
702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>

Line 699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or

695: nvl(p_rec.poei_information11, hr_api.g_varchar2) or
696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>
697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or
698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>
699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or
700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>
701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or
702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>
703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or

Line 700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>

696: nvl(pe_poi_shd.g_old_rec.poei_information12, hr_api.g_varchar2) <>
697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or
698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>
699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or
700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>
701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or
702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>
703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or
704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>

Line 701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or

697: nvl(p_rec.poei_information12, hr_api.g_varchar2) or
698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>
699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or
700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>
701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or
702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>
703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or
704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>
705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or

Line 702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>

698: nvl(pe_poi_shd.g_old_rec.poei_information13, hr_api.g_varchar2) <>
699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or
700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>
701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or
702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>
703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or
704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>
705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or
706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>

Line 703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or

699: nvl(p_rec.poei_information13, hr_api.g_varchar2) or
700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>
701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or
702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>
703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or
704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>
705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or
706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>
707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or

Line 704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>

700: nvl(pe_poi_shd.g_old_rec.poei_information14, hr_api.g_varchar2) <>
701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or
702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>
703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or
704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>
705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or
706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>
707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or
708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>

Line 705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or

701: nvl(p_rec.poei_information14, hr_api.g_varchar2) or
702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>
703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or
704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>
705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or
706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>
707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or
708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>
709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or

Line 706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>

702: nvl(pe_poi_shd.g_old_rec.poei_information15, hr_api.g_varchar2) <>
703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or
704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>
705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or
706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>
707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or
708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>
709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or
710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>

Line 707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or

703: nvl(p_rec.poei_information15, hr_api.g_varchar2) or
704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>
705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or
706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>
707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or
708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>
709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or
710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>
711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or

Line 708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>

704: nvl(pe_poi_shd.g_old_rec.poei_information16, hr_api.g_varchar2) <>
705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or
706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>
707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or
708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>
709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or
710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>
711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or
712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>

Line 709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or

705: nvl(p_rec.poei_information16, hr_api.g_varchar2) or
706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>
707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or
708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>
709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or
710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>
711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or
712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>
713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or

Line 710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>

706: nvl(pe_poi_shd.g_old_rec.poei_information17, hr_api.g_varchar2) <>
707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or
708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>
709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or
710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>
711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or
712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>
713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or
714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>

Line 711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or

707: nvl(p_rec.poei_information17, hr_api.g_varchar2) or
708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>
709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or
710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>
711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or
712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>
713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or
714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>
715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or

Line 712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>

708: nvl(pe_poi_shd.g_old_rec.poei_information18, hr_api.g_varchar2) <>
709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or
710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>
711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or
712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>
713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or
714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>
715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or
716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>

Line 713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or

709: nvl(p_rec.poei_information18, hr_api.g_varchar2) or
710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>
711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or
712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>
713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or
714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>
715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or
716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>
717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or

Line 714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>

710: nvl(pe_poi_shd.g_old_rec.poei_information19, hr_api.g_varchar2) <>
711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or
712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>
713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or
714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>
715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or
716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>
717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or
718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>

Line 715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or

711: nvl(p_rec.poei_information19, hr_api.g_varchar2) or
712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>
713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or
714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>
715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or
716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>
717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or
718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>
719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or

Line 716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>

712: nvl(pe_poi_shd.g_old_rec.poei_information20, hr_api.g_varchar2) <>
713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or
714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>
715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or
716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>
717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or
718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>
719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or
720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>

Line 717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or

713: nvl(p_rec.poei_information20, hr_api.g_varchar2) or
714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>
715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or
716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>
717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or
718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>
719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or
720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>
721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or

Line 718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>

714: nvl(pe_poi_shd.g_old_rec.poei_information21, hr_api.g_varchar2) <>
715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or
716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>
717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or
718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>
719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or
720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>
721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or
722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>

Line 719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or

715: nvl(p_rec.poei_information21, hr_api.g_varchar2) or
716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>
717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or
718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>
719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or
720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>
721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or
722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>
723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or

Line 720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>

716: nvl(pe_poi_shd.g_old_rec.poei_information22, hr_api.g_varchar2) <>
717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or
718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>
719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or
720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>
721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or
722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>
723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or
724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>

Line 721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or

717: nvl(p_rec.poei_information22, hr_api.g_varchar2) or
718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>
719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or
720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>
721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or
722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>
723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or
724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>
725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or

Line 722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>

718: nvl(pe_poi_shd.g_old_rec.poei_information23, hr_api.g_varchar2) <>
719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or
720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>
721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or
722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>
723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or
724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>
725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or
726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>

Line 723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or

719: nvl(p_rec.poei_information23, hr_api.g_varchar2) or
720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>
721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or
722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>
723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or
724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>
725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or
726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>
727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or

Line 724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>

720: nvl(pe_poi_shd.g_old_rec.poei_information24, hr_api.g_varchar2) <>
721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or
722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>
723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or
724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>
725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or
726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>
727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or
728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>

Line 725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or

721: nvl(p_rec.poei_information24, hr_api.g_varchar2) or
722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>
723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or
724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>
725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or
726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>
727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or
728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>
729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or

Line 726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>

722: nvl(pe_poi_shd.g_old_rec.poei_information25, hr_api.g_varchar2) <>
723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or
724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>
725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or
726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>
727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or
728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>
729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or
730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>

Line 727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or

723: nvl(p_rec.poei_information25, hr_api.g_varchar2) or
724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>
725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or
726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>
727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or
728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>
729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or
730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>
731: nvl(p_rec.poei_information29, hr_api.g_varchar2) or

Line 728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>

724: nvl(pe_poi_shd.g_old_rec.poei_information26, hr_api.g_varchar2) <>
725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or
726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>
727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or
728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>
729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or
730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>
731: nvl(p_rec.poei_information29, hr_api.g_varchar2) or
732: nvl(pe_poi_shd.g_old_rec.poei_information30, hr_api.g_varchar2) <>

Line 729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or

725: nvl(p_rec.poei_information26, hr_api.g_varchar2) or
726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>
727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or
728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>
729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or
730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>
731: nvl(p_rec.poei_information29, hr_api.g_varchar2) or
732: nvl(pe_poi_shd.g_old_rec.poei_information30, hr_api.g_varchar2) <>
733: nvl(p_rec.poei_information30, hr_api.g_varchar2))

Line 730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>

726: nvl(pe_poi_shd.g_old_rec.poei_information27, hr_api.g_varchar2) <>
727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or
728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>
729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or
730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>
731: nvl(p_rec.poei_information29, hr_api.g_varchar2) or
732: nvl(pe_poi_shd.g_old_rec.poei_information30, hr_api.g_varchar2) <>
733: nvl(p_rec.poei_information30, hr_api.g_varchar2))
734: then

Line 731: nvl(p_rec.poei_information29, hr_api.g_varchar2) or

727: nvl(p_rec.poei_information27, hr_api.g_varchar2) or
728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>
729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or
730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>
731: nvl(p_rec.poei_information29, hr_api.g_varchar2) or
732: nvl(pe_poi_shd.g_old_rec.poei_information30, hr_api.g_varchar2) <>
733: nvl(p_rec.poei_information30, hr_api.g_varchar2))
734: then
735: --

Line 732: nvl(pe_poi_shd.g_old_rec.poei_information30, hr_api.g_varchar2) <>

728: nvl(pe_poi_shd.g_old_rec.poei_information28, hr_api.g_varchar2) <>
729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or
730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>
731: nvl(p_rec.poei_information29, hr_api.g_varchar2) or
732: nvl(pe_poi_shd.g_old_rec.poei_information30, hr_api.g_varchar2) <>
733: nvl(p_rec.poei_information30, hr_api.g_varchar2))
734: then
735: --
736: hr_dflex_utility.ins_or_upd_descflex_attribs

Line 733: nvl(p_rec.poei_information30, hr_api.g_varchar2))

729: nvl(p_rec.poei_information28, hr_api.g_varchar2) or
730: nvl(pe_poi_shd.g_old_rec.poei_information29, hr_api.g_varchar2) <>
731: nvl(p_rec.poei_information29, hr_api.g_varchar2) or
732: nvl(pe_poi_shd.g_old_rec.poei_information30, hr_api.g_varchar2) <>
733: nvl(p_rec.poei_information30, hr_api.g_varchar2))
734: then
735: --
736: hr_dflex_utility.ins_or_upd_descflex_attribs
737: (p_appl_short_name => 'PER'