APPS.PER_PSS_BUS dependencies on HR_API

Line 51: and nvl(p_salary_survey_id,hr_api.g_number)

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: --

Line 125: and salary_survey_id <> nvl(p_salary_survey_id,hr_api.g_number);

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);

Line 163: and nvl(per_pss_shd.g_old_rec.survey_name, hr_api.g_varchar2)

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)

Line 164: <> nvl(p_survey_name,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))

Line 167: nvl(per_pss_shd.g_old_rec.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

Line 168: <> nvl(p_survey_company_code,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
172: --

Line 244: hr_api.mandatory_arg_error

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: );

Line 257: hr_api.g_varchar2) <> nvl(p_survey_company_code,

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: --

Line 258: hr_api.g_varchar2))

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);

Line 270: --if hr_api.not_exists_in_hrstanlookups

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

Line 271: if hr_api.not_exists_in_hr_lookups

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

Line 409: hr_api.g_varchar2) <> nvl(p_currency_code,

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: --

Line 410: hr_api.g_varchar2))

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);

Line 490: hr_api.mandatory_arg_error

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: );

Line 512: hr_api.g_varchar2) <> nvl(p_survey_type_code,

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: --

Line 513: hr_api.g_varchar2))

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);

Line 523: if hr_api.not_exists_in_hrstanlookups

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

Line 660: if nvl(p_rec.survey_company_code, hr_api.g_varchar2) <>

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;

Line 661: nvl(per_pss_shd.g_old_rec.survey_company_code,hr_api.g_varchar2)

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;

Line 669: if nvl(p_rec.identifier, hr_api.g_varchar2) <>

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;

Line 670: nvl(per_pss_shd.g_old_rec.identifier,hr_api.g_varchar2)

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;

Line 680: hr_api.argument_changed_error

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

Line 727: nvl(per_pss_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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) <>

Line 728: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

Line 729: nvl(per_pss_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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) <>

Line 730: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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

Line 731: nvl(per_pss_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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) <>

Line 732: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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

Line 733: nvl(per_pss_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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) <>

Line 734: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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

Line 735: nvl(per_pss_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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) <>

Line 736: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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

Line 737: nvl(per_pss_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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) <>

Line 738: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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

Line 739: nvl(per_pss_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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) <>

Line 740: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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

Line 741: nvl(per_pss_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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) <>

Line 742: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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

Line 743: nvl(per_pss_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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) <>

Line 744: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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

Line 745: nvl(per_pss_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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) <>

Line 746: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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

Line 747: nvl(per_pss_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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) <>

Line 748: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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

Line 749: nvl(per_pss_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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) <>

Line 750: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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

Line 751: nvl(per_pss_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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) <>

Line 752: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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

Line 753: nvl(per_pss_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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) <>

Line 754: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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

Line 755: nvl(per_pss_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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) <>

Line 756: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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

Line 757: nvl(per_pss_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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) <>

Line 758: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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

Line 759: nvl(per_pss_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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) <>

Line 760: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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

Line 761: nvl(per_pss_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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) <>

Line 762: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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

Line 763: nvl(per_pss_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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) <>

Line 764: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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)))

Line 765: nvl(per_pss_shd.g_old_rec.attribute19, 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

Line 766: nvl(p_rec.attribute19, hr_api.g_varchar2) 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

Line 767: nvl(per_pss_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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: --

Line 768: nvl(p_rec.attribute20, 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: --
772: -- Only execute the validation if absolutely necessary: