47: (p_salary_survey_id => p_salary_survey_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_salary_survey_id,hr_api.g_number)
52: <> per_pss_shd.g_old_rec.salary_survey_id) then
53: --
54: -- raise error as PK has changed
55: --
121: select null
122: from per_salary_surveys
123: where upper(survey_name) = upper(p_survey_name)
124: and survey_company_code = p_survey_company_code
125: and salary_survey_id <> nvl(p_salary_survey_id,hr_api.g_number);
126: --
127: Begin
128: --
129: hr_utility.set_location('Entering:'||l_proc, 5);
159: --
160: hr_utility.set_location(l_proc, 20);
161: --
162: if ((l_api_updating
163: and nvl(per_pss_shd.g_old_rec.survey_name, hr_api.g_varchar2)
164: <> nvl(p_survey_name,hr_api.g_varchar2))
165: or
166: (l_api_updating and
167: nvl(per_pss_shd.g_old_rec.survey_company_code,hr_api.g_varchar2)
160: hr_utility.set_location(l_proc, 20);
161: --
162: if ((l_api_updating
163: and nvl(per_pss_shd.g_old_rec.survey_name, hr_api.g_varchar2)
164: <> nvl(p_survey_name,hr_api.g_varchar2))
165: or
166: (l_api_updating and
167: nvl(per_pss_shd.g_old_rec.survey_company_code,hr_api.g_varchar2)
168: <> nvl(p_survey_company_code,hr_api.g_varchar2))
163: and nvl(per_pss_shd.g_old_rec.survey_name, hr_api.g_varchar2)
164: <> nvl(p_survey_name,hr_api.g_varchar2))
165: or
166: (l_api_updating and
167: nvl(per_pss_shd.g_old_rec.survey_company_code,hr_api.g_varchar2)
168: <> nvl(p_survey_company_code,hr_api.g_varchar2))
169: or
170: (NOT l_api_updating))
171: then
164: <> nvl(p_survey_name,hr_api.g_varchar2))
165: or
166: (l_api_updating and
167: nvl(per_pss_shd.g_old_rec.survey_company_code,hr_api.g_varchar2)
168: <> nvl(p_survey_company_code,hr_api.g_varchar2))
169: or
170: (NOT l_api_updating))
171: then
172: --
240: hr_utility.set_location('Entering:'|| l_proc, 10);
241: --
242: -- Check mandatory parameters have been set
243: --
244: hr_api.mandatory_arg_error
245: (p_api_name => l_proc
246: ,p_argument => 'effective date'
247: ,p_argument_value => p_effective_date
248: );
253: -- b) This is an insert.
254: --
255: if (((p_salary_survey_id is not null) and
256: nvl(per_pss_shd.g_old_rec.survey_company_code,
257: hr_api.g_varchar2) <> nvl(p_survey_company_code,
258: hr_api.g_varchar2))
259: or
260: (p_salary_survey_id is null)) then
261: --
254: --
255: if (((p_salary_survey_id is not null) and
256: nvl(per_pss_shd.g_old_rec.survey_company_code,
257: hr_api.g_varchar2) <> nvl(p_survey_company_code,
258: hr_api.g_varchar2))
259: or
260: (p_salary_survey_id is null)) then
261: --
262: hr_utility.set_location(l_proc, 20);
266: -- in hr_standard_lookups where the lookup_type is 'SURVEY_COMPANY'
267: --
268: if p_survey_company_code is not null then
269: -- code commented for bug5439193 by amigarg
270: --if hr_api.not_exists_in_hrstanlookups
271: if hr_api.not_exists_in_hr_lookups
272: (p_effective_date => p_effective_date
273: ,p_lookup_type => 'SURVEY_COMPANY'
274: ,p_lookup_code => p_survey_company_code
267: --
268: if p_survey_company_code is not null then
269: -- code commented for bug5439193 by amigarg
270: --if hr_api.not_exists_in_hrstanlookups
271: if hr_api.not_exists_in_hr_lookups
272: (p_effective_date => p_effective_date
273: ,p_lookup_type => 'SURVEY_COMPANY'
274: ,p_lookup_code => p_survey_company_code
275: ) then
405: -- b) This is an insert.
406: --
407: if (((p_salary_survey_id is not null) and
408: nvl(per_pss_shd.g_old_rec.currency_code,
409: hr_api.g_varchar2) <> nvl(p_currency_code,
410: hr_api.g_varchar2))
411: or
412: (p_salary_survey_id is null)) then
413: --
406: --
407: if (((p_salary_survey_id is not null) and
408: nvl(per_pss_shd.g_old_rec.currency_code,
409: hr_api.g_varchar2) <> nvl(p_currency_code,
410: hr_api.g_varchar2))
411: or
412: (p_salary_survey_id is null)) then
413: --
414: hr_utility.set_location(l_proc, 20);
486: hr_utility.set_location('Entering:'|| l_proc, 10);
487: --
488: -- Check mandatory parameters have been set
489: --
490: hr_api.mandatory_arg_error
491: (p_api_name => l_proc
492: ,p_argument => 'effective date'
493: ,p_argument_value => p_effective_date
494: );
508: -- b) This is an insert.
509: --
510: if (((p_salary_survey_id is not null) and
511: nvl(per_pss_shd.g_old_rec.survey_type_code,
512: hr_api.g_varchar2) <> nvl(p_survey_type_code,
513: hr_api.g_varchar2))
514: or
515: (p_salary_survey_id is null)) then
516: --
509: --
510: if (((p_salary_survey_id is not null) and
511: nvl(per_pss_shd.g_old_rec.survey_type_code,
512: hr_api.g_varchar2) <> nvl(p_survey_type_code,
513: hr_api.g_varchar2))
514: or
515: (p_salary_survey_id is null)) then
516: --
517: hr_utility.set_location(l_proc, 20);
519: -- If survey_type_code is not null then
520: -- Check if the survey_type_code value exists
521: -- in hr_standard_lookups where the lookup_type is 'PAY_BASIS'
522: --
523: if hr_api.not_exists_in_hrstanlookups
524: (p_effective_date => p_effective_date
525: ,p_lookup_type => 'PAY_BASIS'
526: ,p_lookup_code => p_survey_type_code
527: ) then
656: end if;
657: --
658: hr_utility.set_location(l_proc, 30);
659: --
660: if nvl(p_rec.survey_company_code, hr_api.g_varchar2) <>
661: nvl(per_pss_shd.g_old_rec.survey_company_code,hr_api.g_varchar2)
662: then
663: l_argument := 'survey_company_code';
664: raise l_error;
657: --
658: hr_utility.set_location(l_proc, 30);
659: --
660: if nvl(p_rec.survey_company_code, hr_api.g_varchar2) <>
661: nvl(per_pss_shd.g_old_rec.survey_company_code,hr_api.g_varchar2)
662: then
663: l_argument := 'survey_company_code';
664: raise l_error;
665: end if;
665: end if;
666: --
667: hr_utility.set_location(l_proc, 40);
668: --
669: if nvl(p_rec.identifier, hr_api.g_varchar2) <>
670: nvl(per_pss_shd.g_old_rec.identifier,hr_api.g_varchar2)
671: then
672: l_argument := 'identifier';
673: raise l_error;
666: --
667: hr_utility.set_location(l_proc, 40);
668: --
669: if nvl(p_rec.identifier, hr_api.g_varchar2) <>
670: nvl(per_pss_shd.g_old_rec.identifier,hr_api.g_varchar2)
671: then
672: l_argument := 'identifier';
673: raise l_error;
674: end if;
676: hr_utility.set_location(l_proc, 50);
677: --
678: exception
679: when l_error then
680: hr_api.argument_changed_error
681: (p_api_name => l_proc
682: ,p_argument => l_argument
683: );
684: when others then
723: begin
724: hr_utility.set_location('Entering:'||l_proc, 10);
725: --
726: if ((p_rec.salary_survey_id is not null) and (
727: nvl(per_pss_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
729: nvl(per_pss_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute1, hr_api.g_varchar2) or
731: nvl(per_pss_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
724: hr_utility.set_location('Entering:'||l_proc, 10);
725: --
726: if ((p_rec.salary_survey_id is not null) and (
727: nvl(per_pss_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
729: nvl(per_pss_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute1, hr_api.g_varchar2) or
731: nvl(per_pss_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute2, hr_api.g_varchar2) or
725: --
726: if ((p_rec.salary_survey_id is not null) and (
727: nvl(per_pss_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
729: nvl(per_pss_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute1, hr_api.g_varchar2) or
731: nvl(per_pss_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute2, hr_api.g_varchar2) or
733: nvl(per_pss_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
726: if ((p_rec.salary_survey_id is not null) and (
727: nvl(per_pss_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
729: nvl(per_pss_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute1, hr_api.g_varchar2) or
731: nvl(per_pss_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute2, hr_api.g_varchar2) or
733: nvl(per_pss_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute3, hr_api.g_varchar2) or
727: nvl(per_pss_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
729: nvl(per_pss_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute1, hr_api.g_varchar2) or
731: nvl(per_pss_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute2, hr_api.g_varchar2) or
733: nvl(per_pss_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute3, hr_api.g_varchar2) or
735: nvl(per_pss_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
728: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
729: nvl(per_pss_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute1, hr_api.g_varchar2) or
731: nvl(per_pss_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute2, hr_api.g_varchar2) or
733: nvl(per_pss_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute3, hr_api.g_varchar2) or
735: nvl(per_pss_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute4, hr_api.g_varchar2) or
729: nvl(per_pss_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute1, hr_api.g_varchar2) or
731: nvl(per_pss_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute2, hr_api.g_varchar2) or
733: nvl(per_pss_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute3, hr_api.g_varchar2) or
735: nvl(per_pss_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute4, hr_api.g_varchar2) or
737: nvl(per_pss_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
730: nvl(p_rec.attribute1, hr_api.g_varchar2) or
731: nvl(per_pss_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute2, hr_api.g_varchar2) or
733: nvl(per_pss_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute3, hr_api.g_varchar2) or
735: nvl(per_pss_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute4, hr_api.g_varchar2) or
737: nvl(per_pss_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute5, hr_api.g_varchar2) or
731: nvl(per_pss_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute2, hr_api.g_varchar2) or
733: nvl(per_pss_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute3, hr_api.g_varchar2) or
735: nvl(per_pss_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute4, hr_api.g_varchar2) or
737: nvl(per_pss_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute5, hr_api.g_varchar2) or
739: nvl(per_pss_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
732: nvl(p_rec.attribute2, hr_api.g_varchar2) or
733: nvl(per_pss_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute3, hr_api.g_varchar2) or
735: nvl(per_pss_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute4, hr_api.g_varchar2) or
737: nvl(per_pss_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute5, hr_api.g_varchar2) or
739: nvl(per_pss_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute6, hr_api.g_varchar2) or
733: nvl(per_pss_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute3, hr_api.g_varchar2) or
735: nvl(per_pss_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute4, hr_api.g_varchar2) or
737: nvl(per_pss_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute5, hr_api.g_varchar2) or
739: nvl(per_pss_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute6, hr_api.g_varchar2) or
741: nvl(per_pss_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
734: nvl(p_rec.attribute3, hr_api.g_varchar2) or
735: nvl(per_pss_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute4, hr_api.g_varchar2) or
737: nvl(per_pss_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute5, hr_api.g_varchar2) or
739: nvl(per_pss_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute6, hr_api.g_varchar2) or
741: nvl(per_pss_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute7, hr_api.g_varchar2) or
735: nvl(per_pss_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute4, hr_api.g_varchar2) or
737: nvl(per_pss_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute5, hr_api.g_varchar2) or
739: nvl(per_pss_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute6, hr_api.g_varchar2) or
741: nvl(per_pss_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute7, hr_api.g_varchar2) or
743: nvl(per_pss_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
736: nvl(p_rec.attribute4, hr_api.g_varchar2) or
737: nvl(per_pss_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute5, hr_api.g_varchar2) or
739: nvl(per_pss_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute6, hr_api.g_varchar2) or
741: nvl(per_pss_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute7, hr_api.g_varchar2) or
743: nvl(per_pss_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute8, hr_api.g_varchar2) or
737: nvl(per_pss_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute5, hr_api.g_varchar2) or
739: nvl(per_pss_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute6, hr_api.g_varchar2) or
741: nvl(per_pss_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute7, hr_api.g_varchar2) or
743: nvl(per_pss_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute8, hr_api.g_varchar2) or
745: nvl(per_pss_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
738: nvl(p_rec.attribute5, hr_api.g_varchar2) or
739: nvl(per_pss_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute6, hr_api.g_varchar2) or
741: nvl(per_pss_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute7, hr_api.g_varchar2) or
743: nvl(per_pss_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute8, hr_api.g_varchar2) or
745: nvl(per_pss_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute9, hr_api.g_varchar2) or
739: nvl(per_pss_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute6, hr_api.g_varchar2) or
741: nvl(per_pss_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute7, hr_api.g_varchar2) or
743: nvl(per_pss_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute8, hr_api.g_varchar2) or
745: nvl(per_pss_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute9, hr_api.g_varchar2) or
747: nvl(per_pss_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
740: nvl(p_rec.attribute6, hr_api.g_varchar2) or
741: nvl(per_pss_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute7, hr_api.g_varchar2) or
743: nvl(per_pss_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute8, hr_api.g_varchar2) or
745: nvl(per_pss_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute9, hr_api.g_varchar2) or
747: nvl(per_pss_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute10, hr_api.g_varchar2) or
741: nvl(per_pss_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute7, hr_api.g_varchar2) or
743: nvl(per_pss_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute8, hr_api.g_varchar2) or
745: nvl(per_pss_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute9, hr_api.g_varchar2) or
747: nvl(per_pss_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute10, hr_api.g_varchar2) or
749: nvl(per_pss_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
742: nvl(p_rec.attribute7, hr_api.g_varchar2) or
743: nvl(per_pss_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute8, hr_api.g_varchar2) or
745: nvl(per_pss_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute9, hr_api.g_varchar2) or
747: nvl(per_pss_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute10, hr_api.g_varchar2) or
749: nvl(per_pss_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute11, hr_api.g_varchar2) or
743: nvl(per_pss_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute8, hr_api.g_varchar2) or
745: nvl(per_pss_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute9, hr_api.g_varchar2) or
747: nvl(per_pss_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute10, hr_api.g_varchar2) or
749: nvl(per_pss_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute11, hr_api.g_varchar2) or
751: nvl(per_pss_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
744: nvl(p_rec.attribute8, hr_api.g_varchar2) or
745: nvl(per_pss_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute9, hr_api.g_varchar2) or
747: nvl(per_pss_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute10, hr_api.g_varchar2) or
749: nvl(per_pss_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute11, hr_api.g_varchar2) or
751: nvl(per_pss_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute12, hr_api.g_varchar2) or
745: nvl(per_pss_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute9, hr_api.g_varchar2) or
747: nvl(per_pss_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute10, hr_api.g_varchar2) or
749: nvl(per_pss_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute11, hr_api.g_varchar2) or
751: nvl(per_pss_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute12, hr_api.g_varchar2) or
753: nvl(per_pss_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
746: nvl(p_rec.attribute9, hr_api.g_varchar2) or
747: nvl(per_pss_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute10, hr_api.g_varchar2) or
749: nvl(per_pss_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute11, hr_api.g_varchar2) or
751: nvl(per_pss_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute12, hr_api.g_varchar2) or
753: nvl(per_pss_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute13, hr_api.g_varchar2) or
747: nvl(per_pss_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute10, hr_api.g_varchar2) or
749: nvl(per_pss_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute11, hr_api.g_varchar2) or
751: nvl(per_pss_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute12, hr_api.g_varchar2) or
753: nvl(per_pss_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute13, hr_api.g_varchar2) or
755: nvl(per_pss_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
748: nvl(p_rec.attribute10, hr_api.g_varchar2) or
749: nvl(per_pss_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute11, hr_api.g_varchar2) or
751: nvl(per_pss_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute12, hr_api.g_varchar2) or
753: nvl(per_pss_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute13, hr_api.g_varchar2) or
755: nvl(per_pss_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute14, hr_api.g_varchar2) or
749: nvl(per_pss_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute11, hr_api.g_varchar2) or
751: nvl(per_pss_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute12, hr_api.g_varchar2) or
753: nvl(per_pss_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute13, hr_api.g_varchar2) or
755: nvl(per_pss_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute14, hr_api.g_varchar2) or
757: nvl(per_pss_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
750: nvl(p_rec.attribute11, hr_api.g_varchar2) or
751: nvl(per_pss_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute12, hr_api.g_varchar2) or
753: nvl(per_pss_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute13, hr_api.g_varchar2) or
755: nvl(per_pss_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute14, hr_api.g_varchar2) or
757: nvl(per_pss_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute15, hr_api.g_varchar2) or
751: nvl(per_pss_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute12, hr_api.g_varchar2) or
753: nvl(per_pss_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute13, hr_api.g_varchar2) or
755: nvl(per_pss_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute14, hr_api.g_varchar2) or
757: nvl(per_pss_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute15, hr_api.g_varchar2) or
759: nvl(per_pss_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
752: nvl(p_rec.attribute12, hr_api.g_varchar2) or
753: nvl(per_pss_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute13, hr_api.g_varchar2) or
755: nvl(per_pss_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute14, hr_api.g_varchar2) or
757: nvl(per_pss_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute15, hr_api.g_varchar2) or
759: nvl(per_pss_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute16, hr_api.g_varchar2) or
753: nvl(per_pss_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute13, hr_api.g_varchar2) or
755: nvl(per_pss_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute14, hr_api.g_varchar2) or
757: nvl(per_pss_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute15, hr_api.g_varchar2) or
759: nvl(per_pss_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute16, hr_api.g_varchar2) or
761: nvl(per_pss_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
754: nvl(p_rec.attribute13, hr_api.g_varchar2) or
755: nvl(per_pss_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute14, hr_api.g_varchar2) or
757: nvl(per_pss_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute15, hr_api.g_varchar2) or
759: nvl(per_pss_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute16, hr_api.g_varchar2) or
761: nvl(per_pss_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
762: nvl(p_rec.attribute17, hr_api.g_varchar2) or
755: nvl(per_pss_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute14, hr_api.g_varchar2) or
757: nvl(per_pss_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute15, hr_api.g_varchar2) or
759: nvl(per_pss_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute16, hr_api.g_varchar2) or
761: nvl(per_pss_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
762: nvl(p_rec.attribute17, hr_api.g_varchar2) or
763: nvl(per_pss_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
756: nvl(p_rec.attribute14, hr_api.g_varchar2) or
757: nvl(per_pss_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute15, hr_api.g_varchar2) or
759: nvl(per_pss_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute16, hr_api.g_varchar2) or
761: nvl(per_pss_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
762: nvl(p_rec.attribute17, hr_api.g_varchar2) or
763: nvl(per_pss_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
764: nvl(p_rec.attribute18, hr_api.g_varchar2) or
757: nvl(per_pss_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute15, hr_api.g_varchar2) or
759: nvl(per_pss_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute16, hr_api.g_varchar2) or
761: nvl(per_pss_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
762: nvl(p_rec.attribute17, hr_api.g_varchar2) or
763: nvl(per_pss_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
764: nvl(p_rec.attribute18, hr_api.g_varchar2) or
765: nvl(per_pss_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
758: nvl(p_rec.attribute15, hr_api.g_varchar2) or
759: nvl(per_pss_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute16, hr_api.g_varchar2) or
761: nvl(per_pss_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
762: nvl(p_rec.attribute17, hr_api.g_varchar2) or
763: nvl(per_pss_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
764: nvl(p_rec.attribute18, hr_api.g_varchar2) or
765: nvl(per_pss_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
766: nvl(p_rec.attribute19, hr_api.g_varchar2) or
759: nvl(per_pss_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute16, hr_api.g_varchar2) or
761: nvl(per_pss_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
762: nvl(p_rec.attribute17, hr_api.g_varchar2) or
763: nvl(per_pss_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
764: nvl(p_rec.attribute18, hr_api.g_varchar2) or
765: nvl(per_pss_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
766: nvl(p_rec.attribute19, hr_api.g_varchar2) or
767: nvl(per_pss_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
760: nvl(p_rec.attribute16, hr_api.g_varchar2) or
761: nvl(per_pss_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
762: nvl(p_rec.attribute17, hr_api.g_varchar2) or
763: nvl(per_pss_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
764: nvl(p_rec.attribute18, hr_api.g_varchar2) or
765: nvl(per_pss_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
766: nvl(p_rec.attribute19, hr_api.g_varchar2) or
767: nvl(per_pss_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
768: nvl(p_rec.attribute20, hr_api.g_varchar2)))
761: nvl(per_pss_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
762: nvl(p_rec.attribute17, hr_api.g_varchar2) or
763: nvl(per_pss_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
764: nvl(p_rec.attribute18, hr_api.g_varchar2) or
765: nvl(per_pss_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
766: nvl(p_rec.attribute19, hr_api.g_varchar2) or
767: nvl(per_pss_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
768: nvl(p_rec.attribute20, hr_api.g_varchar2)))
769: or
762: nvl(p_rec.attribute17, hr_api.g_varchar2) or
763: nvl(per_pss_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
764: nvl(p_rec.attribute18, hr_api.g_varchar2) or
765: nvl(per_pss_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
766: nvl(p_rec.attribute19, hr_api.g_varchar2) or
767: nvl(per_pss_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
768: nvl(p_rec.attribute20, hr_api.g_varchar2)))
769: or
770: (p_rec.salary_survey_id is null) then
763: nvl(per_pss_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
764: nvl(p_rec.attribute18, hr_api.g_varchar2) or
765: nvl(per_pss_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
766: nvl(p_rec.attribute19, hr_api.g_varchar2) or
767: nvl(per_pss_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
768: nvl(p_rec.attribute20, hr_api.g_varchar2)))
769: or
770: (p_rec.salary_survey_id is null) then
771: --
764: nvl(p_rec.attribute18, hr_api.g_varchar2) or
765: nvl(per_pss_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
766: nvl(p_rec.attribute19, hr_api.g_varchar2) or
767: nvl(per_pss_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
768: nvl(p_rec.attribute20, hr_api.g_varchar2)))
769: or
770: (p_rec.salary_survey_id is null) then
771: --
772: -- Only execute the validation if absolutely necessary: