eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PSS_BUS dependencies on PER_PSS_SHD

Line 46: l_api_updating := per_pss_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := per_pss_shd.api_updating
47: (p_salary_survey_id => p_salary_survey_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> per_pss_shd.g_old_rec.salary_survey_id) then

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: --
56: per_pss_shd.constraint_error('PER_SALARY_SURVEYS_PK');

Line 56: per_pss_shd.constraint_error('PER_SALARY_SURVEYS_PK');

52: <> per_pss_shd.g_old_rec.salary_survey_id) then
53: --
54: -- raise error as PK has changed
55: --
56: per_pss_shd.constraint_error('PER_SALARY_SURVEYS_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: per_pss_shd.constraint_error('PER_SALARY_SURVEYS_PK');

62: if p_salary_survey_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: per_pss_shd.constraint_error('PER_SALARY_SURVEYS_PK');
67: --
68: end if;
69: --
70: end if;

Line 155: l_api_updating := per_pss_shd.api_updating

151: -- The survey_name value has changed or
152: -- The survey_company_code value has changed or
153: -- A record is being inserted
154: --
155: l_api_updating := per_pss_shd.api_updating
156: (p_salary_survey_id => p_salary_survey_id
157: ,p_object_version_number => p_object_version_number
158: );
159: --

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 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 184: per_pss_shd.constraint_error(p_constraint_name =>

180: fetch csr_unique_surv_name_comp_code into l_exists;
181: --
182: if csr_unique_surv_name_comp_code%found then
183: --
184: per_pss_shd.constraint_error(p_constraint_name =>
185: 'PER_SALARY_SURVEYS_UK1');
186: --
187: end if;
188: --

Line 256: nvl(per_pss_shd.g_old_rec.survey_company_code,

252: -- another not null value.
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

Line 408: nvl(per_pss_shd.g_old_rec.currency_code,

404: -- another not null value.
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

Line 511: nvl(per_pss_shd.g_old_rec.survey_type_code,

507: -- another not null value.
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

Line 635: (p_rec in per_pss_shd.g_rec_type,

631: --
632: -- {End Of Comments}
633:
634: Procedure chk_non_updateable_args
635: (p_rec in per_pss_shd.g_rec_type,
636: p_effective_date in date
637: ) is
638: --
639: l_proc varchar2(72) := g_package||'chk_non_updateable_args';

Line 649: if not per_pss_shd.api_updating

645: --
646: -- Only proceed with validation if a row exists for
647: -- the current record in the HR Schema
648: --
649: if not per_pss_shd.api_updating
650: (p_salary_survey_id => p_rec.salary_survey_id
651: ,p_object_version_number => p_rec.object_version_number
652: ) then
653: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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 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 719: (p_rec in per_pss_shd.g_rec_type) is

715: -- Access Status:
716: -- Internal Row Handler Use Only.
717: --
718: procedure chk_df
719: (p_rec in per_pss_shd.g_rec_type) is
720: --
721: l_proc varchar2(72) := g_package||'chk_df';
722: --
723: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 832: Procedure insert_validate(p_rec in per_pss_shd.g_rec_type,

828: --
829: -- ----------------------------------------------------------------------------
830: -- |---------------------------< insert_validate >----------------------------|
831: -- ----------------------------------------------------------------------------
832: Procedure insert_validate(p_rec in per_pss_shd.g_rec_type,
833: p_effective_date in date) is
834: --
835: l_proc varchar2(72) := g_package||'insert_validate';
836: --

Line 900: Procedure update_validate(p_rec in per_pss_shd.g_rec_type,

896: --
897: -- ----------------------------------------------------------------------------
898: -- |---------------------------< update_validate >----------------------------|
899: -- ----------------------------------------------------------------------------
900: Procedure update_validate(p_rec in per_pss_shd.g_rec_type,
901: p_effective_date in date) is
902: --
903: l_proc varchar2(72) := g_package||'update_validate';
904: --

Line 960: Procedure delete_validate(p_rec in per_pss_shd.g_rec_type) is

956: --
957: -- ----------------------------------------------------------------------------
958: -- |---------------------------< delete_validate >----------------------------|
959: -- ----------------------------------------------------------------------------
960: Procedure delete_validate(p_rec in per_pss_shd.g_rec_type) is
961: --
962: l_proc varchar2(72) := g_package||'delete_validate';
963: --
964: Begin