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_SSM_BUS dependencies on PER_SSM_SHD

Line 73: Procedure chk_non_updateable_args(p_rec in per_ssm_shd.g_rec_type) is

69: -- ----------------------------------------------------------------------------
70: -- |----------------------< chk_non_updateable_args >-----------------------|
71: -- ----------------------------------------------------------------------------
72: --
73: Procedure chk_non_updateable_args(p_rec in per_ssm_shd.g_rec_type) is
74: --
75: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
76: l_error exception;
77: l_argument varchar2(30);

Line 85: if not per_ssm_shd.api_updating

81: --
82: -- Only proceed with validation if a row exists for
83: -- the current record in the HR Schema
84: --
85: if not per_ssm_shd.api_updating
86: (p_salary_survey_mapping_id => p_rec.salary_survey_mapping_id
87: ,p_object_version_number => p_rec.object_version_number
88: ) then
89: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 97: nvl(per_ssm_shd.g_old_rec.business_group_id, hr_api.g_number) then

93: --
94: hr_utility.set_location(l_proc, 6);
95: --
96: if nvl(p_rec.business_group_id, hr_api.g_number) <>
97: nvl(per_ssm_shd.g_old_rec.business_group_id, hr_api.g_number) then
98: l_argument := 'business_group_id';
99: raise l_error;
100: elsif nvl(p_rec.salary_survey_line_id, hr_api.g_number) <>
101: nvl(per_ssm_shd.g_old_rec.salary_survey_line_id, hr_api.g_number) then

Line 101: nvl(per_ssm_shd.g_old_rec.salary_survey_line_id, hr_api.g_number) then

97: nvl(per_ssm_shd.g_old_rec.business_group_id, hr_api.g_number) then
98: l_argument := 'business_group_id';
99: raise l_error;
100: elsif nvl(p_rec.salary_survey_line_id, hr_api.g_number) <>
101: nvl(per_ssm_shd.g_old_rec.salary_survey_line_id, hr_api.g_number) then
102: l_argument := 'salary_survey_line_id';
103: raise l_error;
104: elsif nvl(p_rec.parent_id, hr_api.g_number) <>
105: nvl(per_ssm_shd.g_old_rec.parent_id, hr_api.g_number) then

Line 105: nvl(per_ssm_shd.g_old_rec.parent_id, hr_api.g_number) then

101: nvl(per_ssm_shd.g_old_rec.salary_survey_line_id, hr_api.g_number) then
102: l_argument := 'salary_survey_line_id';
103: raise l_error;
104: elsif nvl(p_rec.parent_id, hr_api.g_number) <>
105: nvl(per_ssm_shd.g_old_rec.parent_id, hr_api.g_number) then
106: l_argument := 'parent_id';
107: raise l_error;
108: elsif nvl(p_rec.parent_table_name, hr_api.g_varchar2) <>
109: nvl(per_ssm_shd.g_old_rec.parent_table_name, hr_api.g_varchar2) then

Line 109: nvl(per_ssm_shd.g_old_rec.parent_table_name, hr_api.g_varchar2) then

105: nvl(per_ssm_shd.g_old_rec.parent_id, hr_api.g_number) then
106: l_argument := 'parent_id';
107: raise l_error;
108: elsif nvl(p_rec.parent_table_name, hr_api.g_varchar2) <>
109: nvl(per_ssm_shd.g_old_rec.parent_table_name, hr_api.g_varchar2) then
110: l_argument := 'parent_table_name';
111: raise l_error;
112: end if;
113: hr_utility.set_location(l_proc, 11);

Line 286: l_api_updating := per_ssm_shd.api_updating

282: -- );
283: --
284: hr_utility.set_location(l_proc,6);
285: --
286: l_api_updating := per_ssm_shd.api_updating
287: (p_salary_survey_mapping_id => p_salary_survey_mapping_id,
288: p_object_version_number => p_object_version_number);
289: --
290: If not l_api_updating and p_salary_survey_line_id is null then

Line 312: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK1');

308: --
309: -- raise error as FK does not relate to PK in per_salary_survey_lines
310: -- table.
311: --
312: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK1');
313: --
314: End If;
315: --
316: close csr_chk_survey_line_exists;

Line 409: l_api_updating := per_ssm_shd.api_updating

405: -- );
406: --
407: hr_utility.set_location(l_proc,6);
408: --
409: l_api_updating := per_ssm_shd.api_updating
410: (p_salary_survey_mapping_id => p_salary_survey_mapping_id,
411: p_object_version_number => p_object_version_number);
412: --
413: hr_utility.set_location(l_proc,7);

Line 417: <> nvl(per_ssm_shd.g_old_rec.parent_id,hr_api.g_number)

413: hr_utility.set_location(l_proc,7);
414: --
415: If l_api_updating and
416: (nvl(p_parent_id,hr_api.g_number)
417: <> nvl(per_ssm_shd.g_old_rec.parent_id,hr_api.g_number)
418: or nvl(p_parent_table_name,hr_api.g_varchar2)
419: <> nvl(per_ssm_shd.g_old_rec.parent_table_name,hr_api.g_varchar2)) then
420: --
421: hr_utility.set_location(l_proc,8);

Line 419: <> nvl(per_ssm_shd.g_old_rec.parent_table_name,hr_api.g_varchar2)) then

415: If l_api_updating and
416: (nvl(p_parent_id,hr_api.g_number)
417: <> nvl(per_ssm_shd.g_old_rec.parent_id,hr_api.g_number)
418: or nvl(p_parent_table_name,hr_api.g_varchar2)
419: <> nvl(per_ssm_shd.g_old_rec.parent_table_name,hr_api.g_varchar2)) then
420: --
421: hr_utility.set_location(l_proc,8);
422: --
423: -- Trying to update parent_id or parent_table_name.

Line 658: l_api_updating := per_ssm_shd.api_updating

654: -- Check mandatory parameters have been set
655: --
656: hr_utility.set_location(l_proc,6);
657: --
658: l_api_updating := per_ssm_shd.api_updating
659: (p_salary_survey_mapping_id => p_salary_survey_mapping_id,
660: p_object_version_number => p_object_version_number);
661: --
662: hr_utility.set_location(l_proc,8);

Line 669: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_UK');

665: open csr_chk_unique_key;
666: fetch csr_chk_unique_key into l_exists;
667: If csr_chk_unique_key%found Then
668: close csr_chk_unique_key;
669: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_UK');
670: Else
671: close csr_chk_unique_key;
672: End If;
673: End If;

Line 743: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK2');

739: --
740: -- raise error as FK does not relate to PK in hr_locations
741: -- table.
742: --
743: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK2');
744: --
745: Elsif l_loc_date_to < p_ssl_start_date then
746: --
747: close csr_chk_location_exists;

Line 823: l_api_updating := per_ssm_shd.api_updating

819: Begin
820: --
821: hr_utility.set_location('Entering:'||l_proc,5);
822: --
823: l_api_updating := per_ssm_shd.api_updating
824: (p_salary_survey_mapping_id => p_salary_survey_mapping_id
825: ,p_object_version_number => p_object_version_number
826: );
827: --

Line 844: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK3');

840: --
841: -- raise error as FK does not relate to PK in per_grades
842: -- table.
843: --
844: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK3');
845: --
846: -- Elsif l_business_group_id <> p_business_group_id then
847: Elsif l_business_group_id <> l_bg then
848: close csr_chk_grade_exists;

Line 926: l_api_updating := per_ssm_shd.api_updating

922: Begin
923: --
924: hr_utility.set_location('Entering:'||l_proc,5);
925: --
926: l_api_updating := per_ssm_shd.api_updating
927: (p_salary_survey_mapping_id => p_salary_survey_mapping_id
928: ,p_object_version_number => p_object_version_number
929: );
930: --

Line 950: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK5');

946: --
947: -- raise error as FK does not relate to PK in hr_all_organization_units
948: -- table.
949: --
950: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK5');
951: --
952: -- Elsif l_business_group_id <> p_business_group_id then
953: Elsif l_business_group_id <> l_bg then
954: hr_utility.set_location(l_proc,30);

Line 1035: -- per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK');

1031: --
1032: -- raise error as FK does not relate to PK in hr_all_organization_units
1033: -- table.
1034: --
1035: -- per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK');
1036: fnd_message.set_name('PER','PER_52495_SSM_AGE_DATE_INVL');
1037: fnd_message.raise_error;
1038: --
1039: Else

Line 1132: (p_rec in per_ssm_shd.g_rec_type) is

1128: -- Access Status:
1129: -- Internal Row Handler Use Only.
1130: --
1131: Procedure chk_df
1132: (p_rec in per_ssm_shd.g_rec_type) is
1133: --
1134: l_proc varchar2(72) := g_package||'chk_df';
1135: --
1136: Begin

Line 1140: nvl(per_ssm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1136: Begin
1137: hr_utility.set_location('Entering:'||l_proc, 10);
1138: --
1139: If ((p_rec.salary_survey_mapping_id is not null) and (
1140: nvl(per_ssm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1142: nvl(per_ssm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1143: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1142: nvl(per_ssm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1138: --
1139: If ((p_rec.salary_survey_mapping_id is not null) and (
1140: nvl(per_ssm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1142: nvl(per_ssm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1143: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1140: nvl(per_ssm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1141: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1142: nvl(per_ssm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1143: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1142: nvl(per_ssm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1143: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1144: nvl(per_ssm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1145: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1146: nvl(per_ssm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1147: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1148: nvl(per_ssm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1149: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1150: nvl(per_ssm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1151: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1152: nvl(per_ssm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1153: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1154: nvl(per_ssm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1155: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1156: nvl(per_ssm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1157: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1158: nvl(per_ssm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1159: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1160: nvl(per_ssm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1161: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1162: nvl(per_ssm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1163: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1164: nvl(per_ssm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1165: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1166: nvl(per_ssm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1167: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1168: nvl(per_ssm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1169: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1170: nvl(per_ssm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1171: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1172: nvl(per_ssm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1173: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1179: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1180: nvl(per_ssm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1174: nvl(per_ssm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1175: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1179: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1180: nvl(per_ssm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1181: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1182: or

Line 1180: nvl(per_ssm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1176: nvl(per_ssm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1177: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1178: nvl(per_ssm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1179: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1180: nvl(per_ssm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1181: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1182: or
1183: (p_rec.salary_survey_mapping_id is null) Then
1184: --

Line 1245: Procedure insert_validate(p_rec in per_ssm_shd.g_rec_type

1241: --
1242: -- ----------------------------------------------------------------------------
1243: -- |---------------------------< insert_validate >----------------------------|
1244: -- ----------------------------------------------------------------------------
1245: Procedure insert_validate(p_rec in per_ssm_shd.g_rec_type
1246: ,p_effective_date in date) is
1247: --
1248: l_proc varchar2(72) := g_package||'insert_validate';
1249: l_ssl_start_date date;

Line 1343: Procedure update_validate(p_rec in per_ssm_shd.g_rec_type

1339: --
1340: -- ----------------------------------------------------------------------------
1341: -- |---------------------------< update_validate >----------------------------|
1342: -- ----------------------------------------------------------------------------
1343: Procedure update_validate(p_rec in per_ssm_shd.g_rec_type
1344: ,p_effective_date in date) is
1345: --
1346: l_proc varchar2(72) := g_package||'update_validate';
1347: l_ssl_start_date date;

Line 1449: Procedure delete_validate(p_rec in per_ssm_shd.g_rec_type) is

1445: --
1446: -- ----------------------------------------------------------------------------
1447: -- |---------------------------< delete_validate >----------------------------|
1448: -- ----------------------------------------------------------------------------
1449: Procedure delete_validate(p_rec in per_ssm_shd.g_rec_type) is
1450: --
1451: l_proc varchar2(72) := g_package||'delete_validate';
1452: --
1453: Begin