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_CEL_BUS dependencies on HR_API

Line 43: hr_api.argument_changed_error

39: --
40: hr_utility.set_location(l_proc, 6);
41: --
42: if p_rec.business_group_id <> per_cel_shd.g_old_rec.business_group_id then
43: hr_api.argument_changed_error
44: (p_api_name => l_proc
45: ,p_argument => 'BUSINESS_GROUP_ID'
46: ,p_base_table => per_cel_shd.g_tab_nam
47: );

Line 52: hr_api.argument_changed_error

48: end if;
49: hr_utility.set_location(l_proc, 7);
50: --
51: if p_rec.competence_id <> per_cel_shd.g_old_rec.competence_id then
52: hr_api.argument_changed_error
53: (p_api_name => l_proc
54: ,p_argument => 'COMPETENCE_ID'
55: ,p_base_table => per_cel_shd.g_tab_nam
56: );

Line 62: hr_api.argument_changed_error

58: hr_utility.set_location(l_proc, 8);
59: --
60: if p_rec.competence_element_id <>
61: per_cel_shd.g_old_rec.competence_element_id then
62: hr_api.argument_changed_error
63: (p_api_name => l_proc
64: ,p_argument => 'COMPETENCE_ELEMENT_ID'
65: ,p_base_table => per_cel_shd.g_tab_nam
66: );

Line 73: hr_api.argument_changed_error

69: hr_utility.set_location(l_proc, 9);
70: --
71: if p_rec.parent_competence_element_id <>
72: per_cel_shd.g_old_rec.parent_competence_element_id then
73: hr_api.argument_changed_error
74: (p_api_name => l_proc
75: ,p_argument => 'PARENT_COMPETENCE_ELEMENT_ID'
76: ,p_base_table => per_cel_shd.g_tab_nam
77: );

Line 82: hr_api.argument_changed_error

78: end if;
79: hr_utility.set_location(l_proc, 10);
80: --
81: if p_rec.activity_version_id <> per_cel_shd.g_old_rec.activity_version_id then
82: hr_api.argument_changed_error
83: (p_api_name => l_proc
84: ,p_argument => 'ACTIVITY_VERSION_ID'
85: ,p_base_table => per_cel_shd.g_tab_nam
86: );

Line 93: hr_api.argument_changed_error

89: --
90: hr_utility.set_location(l_proc, 14);
91: --
92: if p_rec.person_id <> per_cel_shd.g_old_rec.person_id then
93: hr_api.argument_changed_error
94: (p_api_name => l_proc
95: ,p_argument => 'PERSON_ID'
96: ,p_base_table => per_cel_shd.g_tab_nam
97: );

Line 103: hr_api.argument_changed_error

99: -- HR/TCA merge support party_id
100: -- But allow change to NULL or if currently NULL
101: if nvl(p_rec.party_id,per_cel_shd.g_old_rec.party_id) <>
102: nvl(per_cel_shd.g_old_rec.party_id,p_rec.party_id) then
103: hr_api.argument_changed_error
104: (p_api_name => l_proc
105: ,p_argument => 'PARTY_ID'
106: ,p_base_table => per_cel_shd.g_tab_nam
107: );

Line 113: hr_api.argument_changed_error

109:
110: hr_utility.set_location(l_proc, 15);
111: --
112: if p_rec.job_id <> per_cel_shd.g_old_rec.job_id then
113: hr_api.argument_changed_error
114: (p_api_name => l_proc
115: ,p_argument => 'JOB_ID'
116: ,p_base_table => per_cel_shd.g_tab_nam
117: );

Line 123: hr_api.argument_changed_error

119: end if;
120: hr_utility.set_location(l_proc, 16);
121: --
122: if p_rec.valid_grade_id <> per_cel_shd.g_old_rec.valid_grade_id then
123: hr_api.argument_changed_error
124: (p_api_name => l_proc
125: ,p_argument => 'VALID_GRADE_ID'
126: ,p_base_table => per_cel_shd.g_tab_nam
127: );

Line 132: hr_api.argument_changed_error

128: end if;
129: hr_utility.set_location(l_proc, 16);
130: --
131: if p_rec.organization_id <> per_cel_shd.g_old_rec.organization_id then
132: hr_api.argument_changed_error
133: (p_api_name => l_proc
134: ,p_argument => 'ORGANIZATION_ID'
135: ,p_base_table => per_cel_shd.g_tab_nam
136: );

Line 142: hr_api.argument_changed_error

138: hr_utility.set_location(l_proc, 17);
139:
140: --
141: if p_rec.assessment_id <> per_cel_shd.g_old_rec.assessment_id then
142: hr_api.argument_changed_error
143: (p_api_name => l_proc
144: ,p_argument => 'ASSESSMENT_ID'
145: ,p_base_table => per_cel_shd.g_tab_nam
146: );

Line 152: hr_api.argument_changed_error

148: hr_utility.set_location(l_proc, 18);
149: --
150: --
151: if p_rec.enterprise_id <> per_cel_shd.g_old_rec.enterprise_id then
152: hr_api.argument_changed_error
153: (p_api_name => l_proc
154: ,p_argument => 'ENTERPRISE_ID'
155: ,p_base_table => per_cel_shd.g_tab_nam
156: );

Line 163: hr_api.argument_changed_error

159:
160: --
161: --
162: if p_rec.position_id <> per_cel_shd.g_old_rec.position_id then
163: hr_api.argument_changed_error
164: (p_api_name => l_proc
165: ,p_argument => 'POSITION_ID'
166: ,p_base_table => per_cel_shd.g_tab_nam
167: );

Line 172: hr_api.argument_changed_error

168: end if;
169: hr_utility.set_location(l_proc, 22);
170: --
171: if p_rec.type <> per_cel_shd.g_old_rec.type then
172: hr_api.argument_changed_error
173: (p_api_name => l_proc
174: ,p_argument => 'TYPE'
175: ,p_base_table => per_cel_shd.g_tab_nam
176: );

Line 181: hr_api.argument_changed_error

177: end if;
178: hr_utility.set_location(l_proc, 25);
179: --
180: if p_rec.object_id <> per_cel_shd.g_old_rec.object_id then
181: hr_api.argument_changed_error
182: (p_api_name => l_proc
183: ,p_argument => 'OBJECT_ID'
184: ,p_base_table => per_cel_shd.g_tab_nam
185: );

Line 189: hr_api.argument_changed_error

185: );
186: end if;
187: --
188: if p_rec.object_name <> per_cel_shd.g_old_rec.object_name then
189: hr_api.argument_changed_error
190: (p_api_name => l_proc
191: ,p_argument => 'OBJECT_NAME'
192: ,p_base_table => per_cel_shd.g_tab_nam
193: );

Line 249: hr_api.mandatory_arg_error

245: hr_utility.set_location('Entering:'|| l_proc, 1);
246: --
247: -- Check mandatory parameters have being set.
248: --
249: hr_api.mandatory_arg_error
250: (p_api_name => l_proc
251: ,p_argument => 'effective_date'
252: ,p_argument_value => p_effective_date
253: );

Line 265: hr_api.g_varchar2) <>

261: (p_competence_element_id => p_competence_element_id
262: ,p_object_version_number => p_object_version_number);
263: --
264: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.mandatory,
265: hr_api.g_varchar2) <>
266: nvl(p_mandatory,hr_api.g_varchar2))
267: OR not l_api_updating ) then
268: hr_utility.set_location(l_proc, 6);
269: --

Line 266: nvl(p_mandatory,hr_api.g_varchar2))

262: ,p_object_version_number => p_object_version_number);
263: --
264: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.mandatory,
265: hr_api.g_varchar2) <>
266: nvl(p_mandatory,hr_api.g_varchar2))
267: OR not l_api_updating ) then
268: hr_utility.set_location(l_proc, 6);
269: --
270: -- check that the p_mandatory exists in hr_lookups.

Line 273: if hr_api.not_exists_in_hr_lookups

269: --
270: -- check that the p_mandatory exists in hr_lookups.
271: --
272: if (p_mandatory IS NOT NULL ) then
273: if hr_api.not_exists_in_hr_lookups
274: (p_effective_date => p_effective_date
275: ,p_lookup_type => 'YES_NO'
276: ,p_lookup_code => p_mandatory
277: ) then

Line 354: hr_api.mandatory_arg_error

350: hr_utility.set_location('Entering:'|| l_proc, 1);
351: --
352: -- Check mandatory parameters have being set.
353: --
354: hr_api.mandatory_arg_error
355: (p_api_name => l_proc
356: ,p_argument => 'effective_date'
357: ,p_argument_value => p_effective_date
358: );

Line 369: hr_api.g_varchar2) <>

365: (p_competence_element_id => p_competence_element_id
366: ,p_object_version_number => p_object_version_number);
367: --
368: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.certification_method,
369: hr_api.g_varchar2) <>
370: nvl(p_certification_method,hr_api.g_varchar2))
371: OR not l_api_updating ) then
372: hr_utility.set_location(l_proc, 6);
373: --

Line 370: nvl(p_certification_method,hr_api.g_varchar2))

366: ,p_object_version_number => p_object_version_number);
367: --
368: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.certification_method,
369: hr_api.g_varchar2) <>
370: nvl(p_certification_method,hr_api.g_varchar2))
371: OR not l_api_updating ) then
372: hr_utility.set_location(l_proc, 6);
373: --
374: -- check that the p_certification_method exists in hr_lookups.

Line 378: if hr_api.not_exists_in_hr_lookups

374: -- check that the p_certification_method exists in hr_lookups.
375: --
376:
377: if (p_certification_method IS NOT NULL ) then
378: if hr_api.not_exists_in_hr_lookups
379: (p_effective_date => p_effective_date
380: ,p_lookup_type => 'CERTIFICATION_METHOD'
381: ,p_lookup_code => p_certification_method
382: ) then

Line 472: hr_api.g_varchar2) <>

468: (p_competence_element_id => p_competence_element_id
469: ,p_object_version_number => p_object_version_number);
470: --
471: if (l_api_updating AND ((nvl(per_cel_shd.g_old_rec.certification_method,
472: hr_api.g_varchar2) <>
473: nvl(p_certification_method,hr_api.g_varchar2)) OR
474: (nvl(per_cel_shd.g_old_rec.certification_date , hr_api.g_date ) <>
475: nvl(p_certification_date,hr_api.g_date)))
476: OR not l_api_updating ) then

Line 473: nvl(p_certification_method,hr_api.g_varchar2)) OR

469: ,p_object_version_number => p_object_version_number);
470: --
471: if (l_api_updating AND ((nvl(per_cel_shd.g_old_rec.certification_method,
472: hr_api.g_varchar2) <>
473: nvl(p_certification_method,hr_api.g_varchar2)) OR
474: (nvl(per_cel_shd.g_old_rec.certification_date , hr_api.g_date ) <>
475: nvl(p_certification_date,hr_api.g_date)))
476: OR not l_api_updating ) then
477: hr_utility.set_location(l_proc, 6);

Line 474: (nvl(per_cel_shd.g_old_rec.certification_date , hr_api.g_date ) <>

470: --
471: if (l_api_updating AND ((nvl(per_cel_shd.g_old_rec.certification_method,
472: hr_api.g_varchar2) <>
473: nvl(p_certification_method,hr_api.g_varchar2)) OR
474: (nvl(per_cel_shd.g_old_rec.certification_date , hr_api.g_date ) <>
475: nvl(p_certification_date,hr_api.g_date)))
476: OR not l_api_updating ) then
477: hr_utility.set_location(l_proc, 6);
478: --

Line 475: nvl(p_certification_date,hr_api.g_date)))

471: if (l_api_updating AND ((nvl(per_cel_shd.g_old_rec.certification_method,
472: hr_api.g_varchar2) <>
473: nvl(p_certification_method,hr_api.g_varchar2)) OR
474: (nvl(per_cel_shd.g_old_rec.certification_date , hr_api.g_date ) <>
475: nvl(p_certification_date,hr_api.g_date)))
476: OR not l_api_updating ) then
477: hr_utility.set_location(l_proc, 6);
478: --
479: -- if the certification_date is null and certification_method is

Line 590: hr_api.g_date)<> nvl(p_certification_date,hr_api.g_date))

586: (p_competence_element_id =>p_competence_element_id
587: ,p_object_version_number =>p_object_version_number);
588:
589: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.certification_date,
590: hr_api.g_date)<> nvl(p_certification_date,hr_api.g_date))
591: OR
592: (l_api_updating AND (nvl(per_cel_shd.g_old_rec.next_certification_date,
593: hr_api.g_date)<> nvl(p_next_certification_date,hr_api.g_date))
594: OR not l_api_updating))

Line 593: hr_api.g_date)<> nvl(p_next_certification_date,hr_api.g_date))

589: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.certification_date,
590: hr_api.g_date)<> nvl(p_certification_date,hr_api.g_date))
591: OR
592: (l_api_updating AND (nvl(per_cel_shd.g_old_rec.next_certification_date,
593: hr_api.g_date)<> nvl(p_next_certification_date,hr_api.g_date))
594: OR not l_api_updating))
595: then hr_utility.set_location(l_proc, 6);
596: --
597: -- Raise error if certification date is NULL

Line 694: hr_api.mandatory_arg_error

690: hr_utility.set_location('Entering:'|| l_proc, 1);
691: --
692: -- Check mandatory parameters have being set.
693: --
694: hr_api.mandatory_arg_error
695: (p_api_name => l_proc
696: ,p_argument => 'effective_date'
697: ,p_argument_value => p_effective_date
698: );

Line 710: hr_api.g_varchar2) <>

706: (p_competence_element_id => p_competence_element_id
707: ,p_object_version_number => p_object_version_number);
708: --
709: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.competence_type,
710: hr_api.g_varchar2) <>
711: nvl(p_competence_type,hr_api.g_varchar2))
712: OR not l_api_updating ) then
713:
714: hr_utility.set_location(l_proc, 6);

Line 711: nvl(p_competence_type,hr_api.g_varchar2))

707: ,p_object_version_number => p_object_version_number);
708: --
709: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.competence_type,
710: hr_api.g_varchar2) <>
711: nvl(p_competence_type,hr_api.g_varchar2))
712: OR not l_api_updating ) then
713:
714: hr_utility.set_location(l_proc, 6);
715: --

Line 719: if hr_api.not_exists_in_hr_lookups

715: --
716: -- check that the p_competence_type exists in hr_lookups.
717: --
718: if (p_competence_type IS NOT NULL ) then
719: if hr_api.not_exists_in_hr_lookups
720: (p_effective_date => p_effective_date
721: ,p_lookup_type => 'COMPETENCE_TYPE'
722: ,p_lookup_code => p_competence_type
723: ) then

Line 801: hr_api.mandatory_arg_error

797: hr_utility.set_location('Entering:'|| l_proc, 1);
798: --
799: -- Check mandatory parameters have being set.
800: --
801: hr_api.mandatory_arg_error
802: (p_api_name => l_proc
803: ,p_argument => 'effective_date'
804: ,p_argument_value => p_effective_date
805: );

Line 819: hr_api.g_varchar2) <>

815: ,p_object_version_number => p_object_version_number);
816: --
817: if (l_api_updating AND
818: (nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,
819: hr_api.g_varchar2) <>
820:
821: nvl(p_source_of_proficiency_level,hr_api.g_varchar2))
822: OR not l_api_updating ) then
823: hr_utility.set_location(l_proc, 6);

Line 821: nvl(p_source_of_proficiency_level,hr_api.g_varchar2))

817: if (l_api_updating AND
818: (nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,
819: hr_api.g_varchar2) <>
820:
821: nvl(p_source_of_proficiency_level,hr_api.g_varchar2))
822: OR not l_api_updating ) then
823: hr_utility.set_location(l_proc, 6);
824: --
825: -- check that the p_source_of_proficiency exists in hr_lookups.

Line 828: if hr_api.not_exists_in_hr_lookups

824: --
825: -- check that the p_source_of_proficiency exists in hr_lookups.
826: --
827: if (p_source_of_proficiency_level IS NOT NULL ) then
828: if hr_api.not_exists_in_hr_lookups
829: (p_effective_date => p_effective_date
830: ,p_lookup_type => 'PROFICIENCY_SOURCE'
831: ,p_lookup_code => p_source_of_proficiency_level
832: ) then

Line 913: hr_api.mandatory_arg_error

909: --
910: -- Check mandatory parameters have being set.
911: --
912: --
913: hr_api.mandatory_arg_error
914: (p_api_name => l_proc
915: ,p_argument => 'effective_date'
916: ,p_argument_value => p_effective_date
917: );

Line 919: hr_api.mandatory_arg_error

915: ,p_argument => 'effective_date'
916: ,p_argument_value => p_effective_date
917: );
918: --
919: hr_api.mandatory_arg_error
920: (p_api_name => l_proc
921: ,p_argument => 'type'
922: ,p_argument_value => p_type
923: );

Line 937: if hr_api.not_exists_in_hr_lookups

933: -- check that the p_type exists in hr_lookups.
934: --
935: if (NOT l_api_updating) then
936: if (p_type IS NOT NULL ) then
937: if hr_api.not_exists_in_hr_lookups
938: (p_effective_date => p_effective_date
939: ,p_lookup_type => 'COMPETENCE_ELEMENT_TYPE'
940: ,p_lookup_code => p_type
941: ) then

Line 1122: --and nvl(p_effective_date_to,hr_api.g_eot)<=

1118: select business_group_id,date_from,date_to
1119: from per_jobs_v
1120: where p_job_id = job_id;
1121: --and p_effective_date_from >= date_from
1122: --and nvl(p_effective_date_to,hr_api.g_eot)<=
1123: -- nvl(date_to,hr_api.g_eot);
1124: --
1125: -- cursor to check that the valid_grade_id exists.
1126: --

Line 1123: -- nvl(date_to,hr_api.g_eot);

1119: from per_jobs_v
1120: where p_job_id = job_id;
1121: --and p_effective_date_from >= date_from
1122: --and nvl(p_effective_date_to,hr_api.g_eot)<=
1123: -- nvl(date_to,hr_api.g_eot);
1124: --
1125: -- cursor to check that the valid_grade_id exists.
1126: --
1127: cursor csr_valid_grade_id is

Line 1133: --and nvl(p_effective_date_to,hr_api.g_eot)<=

1129: select business_group_id, date_from, date_to
1130: from per_valid_grades
1131: where p_valid_grade_id = valid_grade_id;
1132: --and p_effective_date_from >= date_from
1133: --and nvl(p_effective_date_to,hr_api.g_eot)<=
1134: -- nvl(date_to,hr_api.g_eot);
1135: --
1136: --
1137: --

Line 1134: -- nvl(date_to,hr_api.g_eot);

1130: from per_valid_grades
1131: where p_valid_grade_id = valid_grade_id;
1132: --and p_effective_date_from >= date_from
1133: --and nvl(p_effective_date_to,hr_api.g_eot)<=
1134: -- nvl(date_to,hr_api.g_eot);
1135: --
1136: --
1137: --
1138: -- cursor to check that the activity_version_id exists.

Line 1143: nvl(actv.end_date, hr_api.g_eot)

1139: --
1140: cursor csr_valid_activity_id is
1141: select actd.business_group_id,
1142: actv.start_date,
1143: nvl(actv.end_date, hr_api.g_eot)
1144: from ota_activity_versions actv,
1145: ota_activity_definitions actd
1146: where p_activity_version_id = actv.activity_version_id
1147: and actv.activity_id = actd.activity_id;

Line 1193: --and nvl(p_effective_date_to,hr_api.g_eot)<=

1189: -- and p_effective_date
1190: -- between effective_start_date
1191: -- and effective_end_date;
1192: --and p_effective_date_from >= date_effective
1193: --and nvl(p_effective_date_to,hr_api.g_eot)<=
1194: -- nvl(date_end,hr_api.g_eot);
1195: --
1196: -- Cursor to check that competence_id exists
1197: --

Line 1194: -- nvl(date_end,hr_api.g_eot);

1190: -- between effective_start_date
1191: -- and effective_end_date;
1192: --and p_effective_date_from >= date_effective
1193: --and nvl(p_effective_date_to,hr_api.g_eot)<=
1194: -- nvl(date_end,hr_api.g_eot);
1195: --
1196: -- Cursor to check that competence_id exists
1197: --
1198: cursor csr_valid_competence_id is

Line 1202: -- and nvl(p_effective_date_from,hr_api.g_eot) >= date_from

1198: cursor csr_valid_competence_id is
1199: select business_group_id, date_from, date_to
1200: from per_competences
1201: where p_competence_id = competence_id;
1202: -- and nvl(p_effective_date_from,hr_api.g_eot) >= date_from
1203: -- and nvl(p_effective_date_to,hr_api.g_eot)<=
1204: -- nvl(date_to,hr_api.g_eot);
1205: --
1206:

Line 1203: -- and nvl(p_effective_date_to,hr_api.g_eot)<=

1199: select business_group_id, date_from, date_to
1200: from per_competences
1201: where p_competence_id = competence_id;
1202: -- and nvl(p_effective_date_from,hr_api.g_eot) >= date_from
1203: -- and nvl(p_effective_date_to,hr_api.g_eot)<=
1204: -- nvl(date_to,hr_api.g_eot);
1205: --
1206:
1207: --

Line 1204: -- nvl(date_to,hr_api.g_eot);

1200: from per_competences
1201: where p_competence_id = competence_id;
1202: -- and nvl(p_effective_date_from,hr_api.g_eot) >= date_from
1203: -- and nvl(p_effective_date_to,hr_api.g_eot)<=
1204: -- nvl(date_to,hr_api.g_eot);
1205: --
1206:
1207: --
1208: -- Cursor to check that competence_id when the type is 'COMPETENCE_USAGE'

Line 1226: -- and nvl(p_effective_date_to,hr_api.g_eot)<=

1222: select business_group_id,date_from,date_to
1223: from hr_organization_units
1224: where organization_id = p_organization_id;
1225: -- and p_effective_date_from >= date_from
1226: -- and nvl(p_effective_date_to,hr_api.g_eot)<=
1227: -- nvl(date_to,hr_api.g_eot);
1228: --
1229: -- cursor to check that the assessment_id is valid
1230: --

Line 1227: -- nvl(date_to,hr_api.g_eot);

1223: from hr_organization_units
1224: where organization_id = p_organization_id;
1225: -- and p_effective_date_from >= date_from
1226: -- and nvl(p_effective_date_to,hr_api.g_eot)<=
1227: -- nvl(date_to,hr_api.g_eot);
1228: --
1229: -- cursor to check that the assessment_id is valid
1230: --
1231: cursor csr_valid_assessment_id is

Line 1289: if p_date_from < nvl(l_date_of_birth, hr_api.g_sot) THEN

1285: --
1286: l_date_of_birth := NULL;
1287: open csr_valid_date_of_birth;
1288: fetch csr_valid_date_of_birth into l_date_of_birth;
1289: if p_date_from < nvl(l_date_of_birth, hr_api.g_sot) THEN
1290: close csr_valid_date_of_birth;
1291: return true;
1292: else
1293: close csr_valid_date_of_birth;

Line 1307: hr_api.mandatory_arg_error

1303: -- Check mandatory parameters have being set.
1304: -- ngundura should check only if object_type is not
1305: -- PROJECT_ROLE AND OPEN_ASSIGNMENT
1306: if per_cel_shd.g_bus_grp then
1307: hr_api.mandatory_arg_error
1308: (p_api_name => l_proc
1309: ,p_argument => 'business_group_id'
1310: ,p_argument_value => p_business_group_id
1311: );

Line 1423: (nvl(p_effective_date_to,hr_api.g_eot) >

1419: --
1420: hr_utility.set_location(l_proc, 90);
1421: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1422: elsif (p_effective_date_from < l_start_date) OR
1423: (nvl(p_effective_date_to,hr_api.g_eot) >
1424: nvl(l_end_date,hr_api.g_eot)) THEN
1425: --
1426: -- The job_id is not date valid
1427: -- Part of fix for bug 572277

Line 1424: nvl(l_end_date,hr_api.g_eot)) THEN

1420: hr_utility.set_location(l_proc, 90);
1421: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1422: elsif (p_effective_date_from < l_start_date) OR
1423: (nvl(p_effective_date_to,hr_api.g_eot) >
1424: nvl(l_end_date,hr_api.g_eot)) THEN
1425: --
1426: -- The job_id is not date valid
1427: -- Part of fix for bug 572277
1428: --

Line 1462: (nvl(p_effective_date_to,hr_api.g_eot) >

1458: --
1459: hr_utility.set_location(l_proc, 84);
1460: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1461: elsif (p_effective_date_from < l_start_date) OR
1462: (nvl(p_effective_date_to,hr_api.g_eot) >
1463: nvl(l_end_date,hr_api.g_eot)) THEN
1464: --
1465: -- The valid_grade_id is not date valid
1466: -- Part of fix for bug 572277

Line 1463: nvl(l_end_date,hr_api.g_eot)) THEN

1459: hr_utility.set_location(l_proc, 84);
1460: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1461: elsif (p_effective_date_from < l_start_date) OR
1462: (nvl(p_effective_date_to,hr_api.g_eot) >
1463: nvl(l_end_date,hr_api.g_eot)) THEN
1464: --
1465: -- The valid_grade_id is not date valid
1466: -- Part of fix for bug 572277
1467: --

Line 1497: (nvl(p_effective_date_to,hr_api.g_eot) >

1493: --
1494: hr_utility.set_location(l_proc, 105);
1495: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1496: elsif (p_effective_date_from < l_start_date) OR
1497: (nvl(p_effective_date_to,hr_api.g_eot) >
1498: nvl(l_end_date,hr_api.g_eot)) THEN
1499: --
1500: -- The position_id is not date valid
1501: -- Part of fix for bug 572277

Line 1498: nvl(l_end_date,hr_api.g_eot)) THEN

1494: hr_utility.set_location(l_proc, 105);
1495: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1496: elsif (p_effective_date_from < l_start_date) OR
1497: (nvl(p_effective_date_to,hr_api.g_eot) >
1498: nvl(l_end_date,hr_api.g_eot)) THEN
1499: --
1500: -- The position_id is not date valid
1501: -- Part of fix for bug 572277
1502: --

Line 1531: (nvl(p_effective_date_to,hr_api.g_eot) >

1527: hr_utility.set_location(l_proc, 120);
1528:
1529: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1530: elsif (p_effective_date_from < l_start_date) OR
1531: (nvl(p_effective_date_to,hr_api.g_eot) >
1532: nvl(l_end_date,hr_api.g_eot)) THEN
1533: --
1534: -- The organization_id is not date valid
1535: -- Part of fix for bug 572277

Line 1532: nvl(l_end_date,hr_api.g_eot)) THEN

1528:
1529: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1530: elsif (p_effective_date_from < l_start_date) OR
1531: (nvl(p_effective_date_to,hr_api.g_eot) >
1532: nvl(l_end_date,hr_api.g_eot)) THEN
1533: --
1534: -- The organization_id is not date valid
1535: -- Part of fix for bug 572277
1536: --

Line 1783: elsif (nvl(p_effective_date_from,hr_api.g_eot) <

1779: -- The competence_id exists in a different_business_group_id.
1780: --
1781: hr_utility.set_location(l_proc, 275);
1782: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1783: elsif (nvl(p_effective_date_from,hr_api.g_eot) <
1784: nvl(l_start_date,hr_api.g_eot)) OR
1785: (nvl(p_effective_date_to,nvl(l_end_date,hr_api.g_eot)) > nvl(l_end_date,hr_api.g_eot)) THEN
1786: --
1787: -- The competence_id is not date valid

Line 1784: nvl(l_start_date,hr_api.g_eot)) OR

1780: --
1781: hr_utility.set_location(l_proc, 275);
1782: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1783: elsif (nvl(p_effective_date_from,hr_api.g_eot) <
1784: nvl(l_start_date,hr_api.g_eot)) OR
1785: (nvl(p_effective_date_to,nvl(l_end_date,hr_api.g_eot)) > nvl(l_end_date,hr_api.g_eot)) THEN
1786: --
1787: -- The competence_id is not date valid
1788: -- Part of fix for bug 572277

Line 1785: (nvl(p_effective_date_to,nvl(l_end_date,hr_api.g_eot)) > nvl(l_end_date,hr_api.g_eot)) THEN

1781: hr_utility.set_location(l_proc, 275);
1782: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1783: elsif (nvl(p_effective_date_from,hr_api.g_eot) <
1784: nvl(l_start_date,hr_api.g_eot)) OR
1785: (nvl(p_effective_date_to,nvl(l_end_date,hr_api.g_eot)) > nvl(l_end_date,hr_api.g_eot)) THEN
1786: --
1787: -- The competence_id is not date valid
1788: -- Part of fix for bug 572277
1789: --

Line 1799: hr_api.g_number)

1795: end if;
1796: end if;
1797: --
1798: elsif (l_api_updating and (nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,
1799: hr_api.g_number)
1800: <> nvl(p_high_proficiency_level_id,hr_api.g_number) OR
1801: nvl(per_cel_shd.g_old_rec.proficiency_level_id, hr_api.g_number)
1802: <> nvl(p_proficiency_level_id,hr_api.g_number))) then
1803: --

Line 1800: <> nvl(p_high_proficiency_level_id,hr_api.g_number) OR

1796: end if;
1797: --
1798: elsif (l_api_updating and (nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,
1799: hr_api.g_number)
1800: <> nvl(p_high_proficiency_level_id,hr_api.g_number) OR
1801: nvl(per_cel_shd.g_old_rec.proficiency_level_id, hr_api.g_number)
1802: <> nvl(p_proficiency_level_id,hr_api.g_number))) then
1803: --
1804: -- check that the high_proficiency_level_id is valid

Line 1801: nvl(per_cel_shd.g_old_rec.proficiency_level_id, hr_api.g_number)

1797: --
1798: elsif (l_api_updating and (nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,
1799: hr_api.g_number)
1800: <> nvl(p_high_proficiency_level_id,hr_api.g_number) OR
1801: nvl(per_cel_shd.g_old_rec.proficiency_level_id, hr_api.g_number)
1802: <> nvl(p_proficiency_level_id,hr_api.g_number))) then
1803: --
1804: -- check that the high_proficiency_level_id is valid
1805: --

Line 1802: <> nvl(p_proficiency_level_id,hr_api.g_number))) then

1798: elsif (l_api_updating and (nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,
1799: hr_api.g_number)
1800: <> nvl(p_high_proficiency_level_id,hr_api.g_number) OR
1801: nvl(per_cel_shd.g_old_rec.proficiency_level_id, hr_api.g_number)
1802: <> nvl(p_proficiency_level_id,hr_api.g_number))) then
1803: --
1804: -- check that the high_proficiency_level_id is valid
1805: --
1806: if(p_high_proficiency_level_id IS NOT NULL) then

Line 1925: (nvl(p_effective_date_to,hr_api.g_eot) >

1921: open csr_valid_job_id;
1922: fetch csr_valid_job_id into l_business_group_id, l_start_date,l_end_date;
1923: close csr_valid_job_id;
1924: if (p_effective_date_from < l_start_date) OR
1925: (nvl(p_effective_date_to,hr_api.g_eot) >
1926: nvl(l_end_date,hr_api.g_eot)) THEN
1927: --
1928: -- The job_id is not date valid
1929: -- Part of fix for bug 572277

Line 1926: nvl(l_end_date,hr_api.g_eot)) THEN

1922: fetch csr_valid_job_id into l_business_group_id, l_start_date,l_end_date;
1923: close csr_valid_job_id;
1924: if (p_effective_date_from < l_start_date) OR
1925: (nvl(p_effective_date_to,hr_api.g_eot) >
1926: nvl(l_end_date,hr_api.g_eot)) THEN
1927: --
1928: -- The job_id is not date valid
1929: -- Part of fix for bug 572277
1930: --

Line 1944: (nvl(p_effective_date_to,hr_api.g_eot) >

1940: open csr_valid_grade_id;
1941: fetch csr_valid_grade_id into l_business_group_id,l_start_date,l_end_date;
1942: close csr_valid_grade_id;
1943: if (p_effective_date_from < l_start_date) OR
1944: (nvl(p_effective_date_to,hr_api.g_eot) >
1945: nvl(l_end_date,hr_api.g_eot)) THEN
1946: --
1947: -- The valid_grade_id is not date valid
1948: -- Part of fix for bug 572277

Line 1945: nvl(l_end_date,hr_api.g_eot)) THEN

1941: fetch csr_valid_grade_id into l_business_group_id,l_start_date,l_end_date;
1942: close csr_valid_grade_id;
1943: if (p_effective_date_from < l_start_date) OR
1944: (nvl(p_effective_date_to,hr_api.g_eot) >
1945: nvl(l_end_date,hr_api.g_eot)) THEN
1946: --
1947: -- The valid_grade_id is not date valid
1948: -- Part of fix for bug 572277
1949: --

Line 1966: (nvl(p_effective_date_to,hr_api.g_eot) >

1962: open csr_valid_position_id;
1963: fetch csr_valid_position_id into l_business_group_id,l_start_date,l_end_date;
1964: close csr_valid_position_id;
1965: if (p_effective_date_from < l_start_date) OR
1966: (nvl(p_effective_date_to,hr_api.g_eot) >
1967: nvl(l_end_date,hr_api.g_eot)) THEN
1968: --
1969: -- The position_id is not date valid
1970: -- Part of fix for bug 572277

Line 1967: nvl(l_end_date,hr_api.g_eot)) THEN

1963: fetch csr_valid_position_id into l_business_group_id,l_start_date,l_end_date;
1964: close csr_valid_position_id;
1965: if (p_effective_date_from < l_start_date) OR
1966: (nvl(p_effective_date_to,hr_api.g_eot) >
1967: nvl(l_end_date,hr_api.g_eot)) THEN
1968: --
1969: -- The position_id is not date valid
1970: -- Part of fix for bug 572277
1971: --

Line 1986: (nvl(p_effective_date_to,hr_api.g_eot) >

1982: open csr_valid_organization_id;
1983: fetch csr_valid_organization_id into l_business_group_id,l_start_date,l_end_date;
1984: close csr_valid_organization_id;
1985: if (p_effective_date_from < l_start_date) OR
1986: (nvl(p_effective_date_to,hr_api.g_eot) >
1987: nvl(l_end_date,hr_api.g_eot)) THEN
1988: --
1989: -- The organization_id is not date valid
1990: -- Part of fix for bug 572277

Line 1987: nvl(l_end_date,hr_api.g_eot)) THEN

1983: fetch csr_valid_organization_id into l_business_group_id,l_start_date,l_end_date;
1984: close csr_valid_organization_id;
1985: if (p_effective_date_from < l_start_date) OR
1986: (nvl(p_effective_date_to,hr_api.g_eot) >
1987: nvl(l_end_date,hr_api.g_eot)) THEN
1988: --
1989: -- The organization_id is not date valid
1990: -- Part of fix for bug 572277
1991: --

Line 2004: if (nvl(p_effective_date_from,hr_api.g_eot) <

2000: hr_utility.set_location(l_proc, 380);
2001: open csr_valid_competence_id;
2002: fetch csr_valid_competence_id into l_business_group_id,l_start_date,l_end_date;
2003: close csr_valid_competence_id;
2004: if (nvl(p_effective_date_from,hr_api.g_eot) <
2005: nvl(l_start_date,hr_api.g_eot)) OR
2006: (nvl(p_effective_date_to,nvl(l_end_date,hr_api.g_eot)) >
2007: nvl(l_end_date,hr_api.g_eot)) THEN
2008: --

Line 2005: nvl(l_start_date,hr_api.g_eot)) OR

2001: open csr_valid_competence_id;
2002: fetch csr_valid_competence_id into l_business_group_id,l_start_date,l_end_date;
2003: close csr_valid_competence_id;
2004: if (nvl(p_effective_date_from,hr_api.g_eot) <
2005: nvl(l_start_date,hr_api.g_eot)) OR
2006: (nvl(p_effective_date_to,nvl(l_end_date,hr_api.g_eot)) >
2007: nvl(l_end_date,hr_api.g_eot)) THEN
2008: --
2009: -- The competence_id is not date valid

Line 2006: (nvl(p_effective_date_to,nvl(l_end_date,hr_api.g_eot)) >

2002: fetch csr_valid_competence_id into l_business_group_id,l_start_date,l_end_date;
2003: close csr_valid_competence_id;
2004: if (nvl(p_effective_date_from,hr_api.g_eot) <
2005: nvl(l_start_date,hr_api.g_eot)) OR
2006: (nvl(p_effective_date_to,nvl(l_end_date,hr_api.g_eot)) >
2007: nvl(l_end_date,hr_api.g_eot)) THEN
2008: --
2009: -- The competence_id is not date valid
2010: -- Part of fix for bug 572277

Line 2007: nvl(l_end_date,hr_api.g_eot)) THEN

2003: close csr_valid_competence_id;
2004: if (nvl(p_effective_date_from,hr_api.g_eot) <
2005: nvl(l_start_date,hr_api.g_eot)) OR
2006: (nvl(p_effective_date_to,nvl(l_end_date,hr_api.g_eot)) >
2007: nvl(l_end_date,hr_api.g_eot)) THEN
2008: --
2009: -- The competence_id is not date valid
2010: -- Part of fix for bug 572277
2011: --

Line 2088: and nvl(per.effective_end_date,hr_api.g_eot);

2084: from per_all_people_f per
2085: where per.person_id = p_rec.person_id
2086: and p_effective_date
2087: between per.effective_start_date
2088: and nvl(per.effective_end_date,hr_api.g_eot);
2089: --
2090: cursor csr_valid_party_id is
2091: select party_id
2092: from hz_parties hzp

Line 2311: hr_api.mandatory_arg_error

2307: --
2308: -- Check mandatory parameters have being set.
2309: -- ngundura check for business group_id only if its business_group specific
2310: if per_cel_shd.g_bus_grp then
2311: hr_api.mandatory_arg_error
2312: (p_api_name => l_proc
2313: ,p_argument => 'business_group_id'
2314: ,p_argument_value => p_business_group_id
2315: );

Line 2330: hr_api.g_number)<> nvl(p_proficiency_level_id,hr_api.g_number) OR

2326: ,p_object_version_number => p_object_version_number);
2327: --
2328: --
2329: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.proficiency_level_id,
2330: hr_api.g_number)<> nvl(p_proficiency_level_id,hr_api.g_number) OR
2331: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number)
2332: <> nvl(p_high_proficiency_level_id,hr_api.g_number))
2333: OR not l_api_updating) then
2334: --

Line 2331: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number)

2327: --
2328: --
2329: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.proficiency_level_id,
2330: hr_api.g_number)<> nvl(p_proficiency_level_id,hr_api.g_number) OR
2331: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number)
2332: <> nvl(p_high_proficiency_level_id,hr_api.g_number))
2333: OR not l_api_updating) then
2334: --
2335: -- do nothing if both high and low proficiencies are null

Line 2332: <> nvl(p_high_proficiency_level_id,hr_api.g_number))

2328: --
2329: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.proficiency_level_id,
2330: hr_api.g_number)<> nvl(p_proficiency_level_id,hr_api.g_number) OR
2331: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number)
2332: <> nvl(p_high_proficiency_level_id,hr_api.g_number))
2333: OR not l_api_updating) then
2334: --
2335: -- do nothing if both high and low proficiencies are null
2336: --

Line 2508: hr_api.mandatory_arg_error

2504: --
2505: -- Check mandatory parameters have being set.
2506: -- ngundura check should only be for business group specific
2507: if per_cel_shd.g_bus_grp then
2508: hr_api.mandatory_arg_error
2509: (p_api_name => l_proc
2510: ,p_argument => 'business_group_id'
2511: ,p_argument_value => p_business_group_id
2512: );

Line 2533: hr_api.g_number)<> nvl(p_rating_level_id,hr_api.g_number) OR

2529: --
2530: if p_type = 'ASSESSMENT' then
2531: --
2532: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.rating_level_id,
2533: hr_api.g_number)<> nvl(p_rating_level_id,hr_api.g_number) OR
2534: nvl(per_cel_shd.g_old_rec.weighting_level_id,hr_api.g_number)
2535: <> nvl(p_weighting_level_id,hr_api.g_number))
2536: OR not l_api_updating) then
2537: --

Line 2534: nvl(per_cel_shd.g_old_rec.weighting_level_id,hr_api.g_number)

2530: if p_type = 'ASSESSMENT' then
2531: --
2532: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.rating_level_id,
2533: hr_api.g_number)<> nvl(p_rating_level_id,hr_api.g_number) OR
2534: nvl(per_cel_shd.g_old_rec.weighting_level_id,hr_api.g_number)
2535: <> nvl(p_weighting_level_id,hr_api.g_number))
2536: OR not l_api_updating) then
2537: --
2538: -- do nothing if both rating and weighting are null

Line 2535: <> nvl(p_weighting_level_id,hr_api.g_number))

2531: --
2532: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.rating_level_id,
2533: hr_api.g_number)<> nvl(p_rating_level_id,hr_api.g_number) OR
2534: nvl(per_cel_shd.g_old_rec.weighting_level_id,hr_api.g_number)
2535: <> nvl(p_weighting_level_id,hr_api.g_number))
2536: OR not l_api_updating) then
2537: --
2538: -- do nothing if both rating and weighting are null
2539: --

Line 2720: hr_api.g_eot,p_effective_date_to, hr_api.g_eot,

2716: || ' and nvl(:p_effective_date_to,:eot2) >= effective_date_from'
2717: || ' and (competence_element_id <> :p_competence_element_id1 or :p_competence_element_id2 is null)'
2718: || ' and decode(:p_valid_grade_null,''Y'',valid_grade_id,null) is null'
2719: using p_key_id,p_competence_id,p_business_group_id,p_effective_date_from,
2720: hr_api.g_eot,p_effective_date_to, hr_api.g_eot,
2721: p_competence_element_id,p_competence_element_id,p_valid_grade_null;
2722:
2723: fetch csr_check_dates into l_exists;
2724: if csr_check_dates%found then

Line 2777: hr_api.mandatory_arg_error

2773: --
2774: -- Check mandatory parameters have being set.
2775: -- ngundura this check should not be there for global competences
2776: if per_cel_shd.g_bus_grp then
2777: hr_api.mandatory_arg_error
2778: (p_api_name => l_proc
2779: ,p_argument => 'business_group_id'
2780: ,p_argument_value => p_business_group_id
2781: );

Line 2795: hr_api.g_date)<> nvl(p_effective_date_from,hr_api.g_date) OR

2791: ,p_object_version_number => p_object_version_number);
2792: --
2793: --
2794: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.effective_date_from,
2795: hr_api.g_date)<> nvl(p_effective_date_from,hr_api.g_date) OR
2796: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date)
2797: <> nvl(p_effective_date_to,hr_api.g_date))
2798: OR not l_api_updating) then
2799: --

Line 2796: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date)

2792: --
2793: --
2794: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.effective_date_from,
2795: hr_api.g_date)<> nvl(p_effective_date_from,hr_api.g_date) OR
2796: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date)
2797: <> nvl(p_effective_date_to,hr_api.g_date))
2798: OR not l_api_updating) then
2799: --
2800: -- check that the effective_date_from is before the effective_date_to

Line 2797: <> nvl(p_effective_date_to,hr_api.g_date))

2793: --
2794: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.effective_date_from,
2795: hr_api.g_date)<> nvl(p_effective_date_from,hr_api.g_date) OR
2796: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date)
2797: <> nvl(p_effective_date_to,hr_api.g_date))
2798: OR not l_api_updating) then
2799: --
2800: -- check that the effective_date_from is before the effective_date_to
2801: --

Line 2802: if (p_effective_date_from > nvl(p_effective_date_to,hr_api.g_eot))

2798: OR not l_api_updating) then
2799: --
2800: -- check that the effective_date_from is before the effective_date_to
2801: --
2802: if (p_effective_date_from > nvl(p_effective_date_to,hr_api.g_eot))
2803: then
2804: hr_utility.set_location(l_proc,10);
2805: hr_utility.set_message(801,'HR_51647_CEL_DATES_INVL');
2806: --

Line 2938: hr_api.mandatory_arg_error

2934:
2935: --
2936: -- Check mandatory parameters have being set.
2937: --
2938: hr_api.mandatory_arg_error
2939: (p_api_name => l_proc
2940: ,p_argument => 'effective_date'
2941: ,p_argument_value => p_effective_date
2942: );

Line 2956: hr_api.g_number)

2952: ,p_object_version_number => p_object_version_number);
2953: --
2954: --
2955: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.normal_elapse_duration,
2956: hr_api.g_number)
2957: <> nvl(p_normal_elapse_duration,hr_api.g_number) OR
2958: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
2959: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2))
2960: OR not l_api_updating) then

Line 2957: <> nvl(p_normal_elapse_duration,hr_api.g_number) OR

2953: --
2954: --
2955: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.normal_elapse_duration,
2956: hr_api.g_number)
2957: <> nvl(p_normal_elapse_duration,hr_api.g_number) OR
2958: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
2959: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2))
2960: OR not l_api_updating) then
2961: if (p_normal_elapse_duration IS NULL AND

Line 2958: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)

2954: --
2955: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.normal_elapse_duration,
2956: hr_api.g_number)
2957: <> nvl(p_normal_elapse_duration,hr_api.g_number) OR
2958: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
2959: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2))
2960: OR not l_api_updating) then
2961: if (p_normal_elapse_duration IS NULL AND
2962:

Line 2959: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2))

2955: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.normal_elapse_duration,
2956: hr_api.g_number)
2957: <> nvl(p_normal_elapse_duration,hr_api.g_number) OR
2958: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
2959: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2))
2960: OR not l_api_updating) then
2961: if (p_normal_elapse_duration IS NULL AND
2962:
2963: p_normal_elapse_duration_unit IS NULL) then

Line 2988: if hr_api.not_exists_in_hr_lookups

2984: --
2985: -- Check that the p_normal_elapse_duration_unit exists in
2986: -- hr_lookups.
2987: --
2988: if hr_api.not_exists_in_hr_lookups
2989: (p_effective_date => p_effective_date
2990: ,p_lookup_type => 'ELAPSE_DURATION'
2991: ,p_lookup_code => p_normal_elapse_duration_unit
2992: )then

Line 3123: hr_api.mandatory_arg_error

3119: --
3120: -- Check mandatory parameters have being set.
3121: -- ngundura this check should not be there for global competence elements
3122: if per_cel_shd.g_bus_grp then
3123: hr_api.mandatory_arg_error
3124: (p_api_name => l_proc
3125: ,p_argument => 'business_group_id'
3126: ,p_argument_value => p_business_group_id
3127: );

Line 3144: hr_api.g_number)<> nvl(p_rating_level_id,hr_api.g_number) OR

3140: ,p_object_version_number => p_object_version_number);
3141: --
3142: --
3143: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.rating_level_id,
3144: hr_api.g_number)<> nvl(p_rating_level_id,hr_api.g_number) OR
3145: nvl(per_cel_shd.g_old_rec.weighting_level_id,hr_api.g_number)
3146: <> nvl(p_weighting_level_id,hr_api.g_number))
3147: OR not l_api_updating) then
3148: --

Line 3145: nvl(per_cel_shd.g_old_rec.weighting_level_id,hr_api.g_number)

3141: --
3142: --
3143: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.rating_level_id,
3144: hr_api.g_number)<> nvl(p_rating_level_id,hr_api.g_number) OR
3145: nvl(per_cel_shd.g_old_rec.weighting_level_id,hr_api.g_number)
3146: <> nvl(p_weighting_level_id,hr_api.g_number))
3147: OR not l_api_updating) then
3148: --
3149: -- Do nothing if the assessment_type and assessment_id are null

Line 3146: <> nvl(p_weighting_level_id,hr_api.g_number))

3142: --
3143: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.rating_level_id,
3144: hr_api.g_number)<> nvl(p_rating_level_id,hr_api.g_number) OR
3145: nvl(per_cel_shd.g_old_rec.weighting_level_id,hr_api.g_number)
3146: <> nvl(p_weighting_level_id,hr_api.g_number))
3147: OR not l_api_updating) then
3148: --
3149: -- Do nothing if the assessment_type and assessment_id are null
3150: --

Line 3371: and (p_effective_date_from <= nvl(cel.effective_date_to, hr_api.g_eot)

3367: where cel.competence_id = p_competence_id
3368: and cel.qualification_type_id = p_qualification_type_id
3369: and cel.type = 'QUALIFICATION'
3370: and cel.qualification_type_id = p_qualification_type_id
3371: and (p_effective_date_from <= nvl(cel.effective_date_to, hr_api.g_eot)
3372: and NVL(p_effective_date_to, hr_api.g_eot) >= cel.effective_date_from);
3373:
3374: cursor csr_upd_comp_qual_link is
3375: select null from per_competence_elements cel

Line 3372: and NVL(p_effective_date_to, hr_api.g_eot) >= cel.effective_date_from);

3368: and cel.qualification_type_id = p_qualification_type_id
3369: and cel.type = 'QUALIFICATION'
3370: and cel.qualification_type_id = p_qualification_type_id
3371: and (p_effective_date_from <= nvl(cel.effective_date_to, hr_api.g_eot)
3372: and NVL(p_effective_date_to, hr_api.g_eot) >= cel.effective_date_from);
3373:
3374: cursor csr_upd_comp_qual_link is
3375: select null from per_competence_elements cel
3376: where cel.competence_element_id <> p_competence_element_id

Line 3381: and (p_effective_date_from <= nvl(cel.effective_date_to, hr_api.g_eot)

3377: and cel.competence_id = p_competence_id
3378: and cel.qualification_type_id = p_qualification_type_id
3379: and cel.type = 'QUALIFICATION'
3380: and cel.qualification_type_id = p_qualification_type_id
3381: and (p_effective_date_from <= nvl(cel.effective_date_to, hr_api.g_eot)
3382: and NVL(p_effective_date_to, hr_api.g_eot) >= cel.effective_date_from);
3383:
3384: --
3385: l_proc varchar2(72)

Line 3382: and NVL(p_effective_date_to, hr_api.g_eot) >= cel.effective_date_from);

3378: and cel.qualification_type_id = p_qualification_type_id
3379: and cel.type = 'QUALIFICATION'
3380: and cel.qualification_type_id = p_qualification_type_id
3381: and (p_effective_date_from <= nvl(cel.effective_date_to, hr_api.g_eot)
3382: and NVL(p_effective_date_to, hr_api.g_eot) >= cel.effective_date_from);
3383:
3384: --
3385: l_proc varchar2(72)
3386: := g_package||'chk_type_and_validation';

Line 3398: hr_api.mandatory_arg_error

3394: (p_check_column1 => 'PER_COMPETENCE_ELEMENTS.TYPE') then
3395: --
3396: -- Check mandatory parameters have being set.
3397: --
3398: hr_api.mandatory_arg_error
3399: (p_api_name => l_proc
3400: ,p_argument => 'type'
3401: ,p_argument_value => p_type
3402: );

Line 3408: hr_api.mandatory_arg_error

3404: --
3405: -- ngundura should check only when p_type is not
3406: -- 'PROJECT_ROLE' and 'OPEN_ASSIGNMENT'
3407: if per_cel_shd.g_bus_grp then
3408: hr_api.mandatory_arg_error
3409: (p_api_name => l_proc
3410: ,p_argument => 'business_group_id'
3411: ,p_argument_value => p_business_group_id
3412: );

Line 3443: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)

3439: ,p_object_version_number => p_object_version_number);
3440:
3441: --
3442: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
3443: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
3444: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
3445: nvl(p_competence_type,hr_api.g_varchar2) OR
3446: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
3447: nvl(p_effective_date_from,hr_api.g_date) OR

Line 3444: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>

3440:
3441: --
3442: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
3443: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
3444: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
3445: nvl(p_competence_type,hr_api.g_varchar2) OR
3446: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
3447: nvl(p_effective_date_from,hr_api.g_date) OR
3448: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>

Line 3445: nvl(p_competence_type,hr_api.g_varchar2) OR

3441: --
3442: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
3443: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
3444: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
3445: nvl(p_competence_type,hr_api.g_varchar2) OR
3446: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
3447: nvl(p_effective_date_from,hr_api.g_date) OR
3448: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>
3449: nvl(p_effective_date_to,hr_api.g_date) OR

Line 3446: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>

3442: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
3443: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
3444: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
3445: nvl(p_competence_type,hr_api.g_varchar2) OR
3446: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
3447: nvl(p_effective_date_from,hr_api.g_date) OR
3448: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>
3449: nvl(p_effective_date_to,hr_api.g_date) OR
3450: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>

Line 3447: nvl(p_effective_date_from,hr_api.g_date) OR

3443: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
3444: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
3445: nvl(p_competence_type,hr_api.g_varchar2) OR
3446: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
3447: nvl(p_effective_date_from,hr_api.g_date) OR
3448: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>
3449: nvl(p_effective_date_to,hr_api.g_date) OR
3450: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>
3451: nvl(p_high_proficiency_level_id,hr_api.g_number) OR

Line 3448: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>

3444: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
3445: nvl(p_competence_type,hr_api.g_varchar2) OR
3446: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
3447: nvl(p_effective_date_from,hr_api.g_date) OR
3448: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>
3449: nvl(p_effective_date_to,hr_api.g_date) OR
3450: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>
3451: nvl(p_high_proficiency_level_id,hr_api.g_number) OR
3452: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>

Line 3449: nvl(p_effective_date_to,hr_api.g_date) OR

3445: nvl(p_competence_type,hr_api.g_varchar2) OR
3446: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
3447: nvl(p_effective_date_from,hr_api.g_date) OR
3448: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>
3449: nvl(p_effective_date_to,hr_api.g_date) OR
3450: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>
3451: nvl(p_high_proficiency_level_id,hr_api.g_number) OR
3452: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>
3453: nvl(p_mandatory,hr_api.g_varchar2) OR

Line 3450: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>

3446: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
3447: nvl(p_effective_date_from,hr_api.g_date) OR
3448: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>
3449: nvl(p_effective_date_to,hr_api.g_date) OR
3450: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>
3451: nvl(p_high_proficiency_level_id,hr_api.g_number) OR
3452: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>
3453: nvl(p_mandatory,hr_api.g_varchar2) OR
3454: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>

Line 3451: nvl(p_high_proficiency_level_id,hr_api.g_number) OR

3447: nvl(p_effective_date_from,hr_api.g_date) OR
3448: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>
3449: nvl(p_effective_date_to,hr_api.g_date) OR
3450: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>
3451: nvl(p_high_proficiency_level_id,hr_api.g_number) OR
3452: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>
3453: nvl(p_mandatory,hr_api.g_varchar2) OR
3454: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>
3455: nvl(p_normal_elapse_duration,hr_api.g_number) OR

Line 3452: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>

3448: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>
3449: nvl(p_effective_date_to,hr_api.g_date) OR
3450: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>
3451: nvl(p_high_proficiency_level_id,hr_api.g_number) OR
3452: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>
3453: nvl(p_mandatory,hr_api.g_varchar2) OR
3454: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>
3455: nvl(p_normal_elapse_duration,hr_api.g_number) OR
3456: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)

Line 3453: nvl(p_mandatory,hr_api.g_varchar2) OR

3449: nvl(p_effective_date_to,hr_api.g_date) OR
3450: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>
3451: nvl(p_high_proficiency_level_id,hr_api.g_number) OR
3452: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>
3453: nvl(p_mandatory,hr_api.g_varchar2) OR
3454: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>
3455: nvl(p_normal_elapse_duration,hr_api.g_number) OR
3456: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
3457: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR

Line 3454: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>

3450: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>
3451: nvl(p_high_proficiency_level_id,hr_api.g_number) OR
3452: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>
3453: nvl(p_mandatory,hr_api.g_varchar2) OR
3454: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>
3455: nvl(p_normal_elapse_duration,hr_api.g_number) OR
3456: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
3457: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR
3458: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>

Line 3455: nvl(p_normal_elapse_duration,hr_api.g_number) OR

3451: nvl(p_high_proficiency_level_id,hr_api.g_number) OR
3452: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>
3453: nvl(p_mandatory,hr_api.g_varchar2) OR
3454: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>
3455: nvl(p_normal_elapse_duration,hr_api.g_number) OR
3456: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
3457: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR
3458: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>
3459: nvl(p_sequence_number,hr_api.g_number) OR

Line 3456: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)

3452: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>
3453: nvl(p_mandatory,hr_api.g_varchar2) OR
3454: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>
3455: nvl(p_normal_elapse_duration,hr_api.g_number) OR
3456: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
3457: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR
3458: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>
3459: nvl(p_sequence_number,hr_api.g_number) OR
3460: nvl(per_cel_shd.g_old_rec.certification_date,hr_api.g_date) <>

Line 3457: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR

3453: nvl(p_mandatory,hr_api.g_varchar2) OR
3454: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>
3455: nvl(p_normal_elapse_duration,hr_api.g_number) OR
3456: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
3457: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR
3458: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>
3459: nvl(p_sequence_number,hr_api.g_number) OR
3460: nvl(per_cel_shd.g_old_rec.certification_date,hr_api.g_date) <>
3461: nvl(p_certification_date,hr_api.g_date) OR

Line 3458: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>

3454: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>
3455: nvl(p_normal_elapse_duration,hr_api.g_number) OR
3456: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
3457: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR
3458: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>
3459: nvl(p_sequence_number,hr_api.g_number) OR
3460: nvl(per_cel_shd.g_old_rec.certification_date,hr_api.g_date) <>
3461: nvl(p_certification_date,hr_api.g_date) OR
3462: nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,

Line 3459: nvl(p_sequence_number,hr_api.g_number) OR

3455: nvl(p_normal_elapse_duration,hr_api.g_number) OR
3456: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
3457: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR
3458: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>
3459: nvl(p_sequence_number,hr_api.g_number) OR
3460: nvl(per_cel_shd.g_old_rec.certification_date,hr_api.g_date) <>
3461: nvl(p_certification_date,hr_api.g_date) OR
3462: nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,
3463: hr_api.g_varchar2) <>

Line 3460: nvl(per_cel_shd.g_old_rec.certification_date,hr_api.g_date) <>

3456: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
3457: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR
3458: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>
3459: nvl(p_sequence_number,hr_api.g_number) OR
3460: nvl(per_cel_shd.g_old_rec.certification_date,hr_api.g_date) <>
3461: nvl(p_certification_date,hr_api.g_date) OR
3462: nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,
3463: hr_api.g_varchar2) <>
3464: nvl(p_source_of_proficiency_level,hr_api.g_varchar2) OR

Line 3461: nvl(p_certification_date,hr_api.g_date) OR

3457: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR
3458: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>
3459: nvl(p_sequence_number,hr_api.g_number) OR
3460: nvl(per_cel_shd.g_old_rec.certification_date,hr_api.g_date) <>
3461: nvl(p_certification_date,hr_api.g_date) OR
3462: nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,
3463: hr_api.g_varchar2) <>
3464: nvl(p_source_of_proficiency_level,hr_api.g_varchar2) OR
3465: nvl(per_cel_shd.g_old_rec.certification_method,hr_api.g_varchar2) <>

Line 3463: hr_api.g_varchar2) <>

3459: nvl(p_sequence_number,hr_api.g_number) OR
3460: nvl(per_cel_shd.g_old_rec.certification_date,hr_api.g_date) <>
3461: nvl(p_certification_date,hr_api.g_date) OR
3462: nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,
3463: hr_api.g_varchar2) <>
3464: nvl(p_source_of_proficiency_level,hr_api.g_varchar2) OR
3465: nvl(per_cel_shd.g_old_rec.certification_method,hr_api.g_varchar2) <>
3466: nvl(p_certification_method,hr_api.g_varchar2) OR
3467: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>

Line 3464: nvl(p_source_of_proficiency_level,hr_api.g_varchar2) OR

3460: nvl(per_cel_shd.g_old_rec.certification_date,hr_api.g_date) <>
3461: nvl(p_certification_date,hr_api.g_date) OR
3462: nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,
3463: hr_api.g_varchar2) <>
3464: nvl(p_source_of_proficiency_level,hr_api.g_varchar2) OR
3465: nvl(per_cel_shd.g_old_rec.certification_method,hr_api.g_varchar2) <>
3466: nvl(p_certification_method,hr_api.g_varchar2) OR
3467: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>
3468: nvl(p_next_certification_date,hr_api.g_date)OR

Line 3465: nvl(per_cel_shd.g_old_rec.certification_method,hr_api.g_varchar2) <>

3461: nvl(p_certification_date,hr_api.g_date) OR
3462: nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,
3463: hr_api.g_varchar2) <>
3464: nvl(p_source_of_proficiency_level,hr_api.g_varchar2) OR
3465: nvl(per_cel_shd.g_old_rec.certification_method,hr_api.g_varchar2) <>
3466: nvl(p_certification_method,hr_api.g_varchar2) OR
3467: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>
3468: nvl(p_next_certification_date,hr_api.g_date)OR
3469: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>

Line 3466: nvl(p_certification_method,hr_api.g_varchar2) OR

3462: nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,
3463: hr_api.g_varchar2) <>
3464: nvl(p_source_of_proficiency_level,hr_api.g_varchar2) OR
3465: nvl(per_cel_shd.g_old_rec.certification_method,hr_api.g_varchar2) <>
3466: nvl(p_certification_method,hr_api.g_varchar2) OR
3467: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>
3468: nvl(p_next_certification_date,hr_api.g_date)OR
3469: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>
3470: nvl(p_proficiency_level_id,hr_api.g_number) OR

Line 3467: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>

3463: hr_api.g_varchar2) <>
3464: nvl(p_source_of_proficiency_level,hr_api.g_varchar2) OR
3465: nvl(per_cel_shd.g_old_rec.certification_method,hr_api.g_varchar2) <>
3466: nvl(p_certification_method,hr_api.g_varchar2) OR
3467: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>
3468: nvl(p_next_certification_date,hr_api.g_date)OR
3469: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>
3470: nvl(p_proficiency_level_id,hr_api.g_number) OR
3471: nvl(per_cel_shd.g_old_rec.line_score,hr_api.g_number) <>

Line 3468: nvl(p_next_certification_date,hr_api.g_date)OR

3464: nvl(p_source_of_proficiency_level,hr_api.g_varchar2) OR
3465: nvl(per_cel_shd.g_old_rec.certification_method,hr_api.g_varchar2) <>
3466: nvl(p_certification_method,hr_api.g_varchar2) OR
3467: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>
3468: nvl(p_next_certification_date,hr_api.g_date)OR
3469: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>
3470: nvl(p_proficiency_level_id,hr_api.g_number) OR
3471: nvl(per_cel_shd.g_old_rec.line_score,hr_api.g_number) <>
3472: nvl(p_line_score,hr_api.g_number) OR

Line 3469: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>

3465: nvl(per_cel_shd.g_old_rec.certification_method,hr_api.g_varchar2) <>
3466: nvl(p_certification_method,hr_api.g_varchar2) OR
3467: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>
3468: nvl(p_next_certification_date,hr_api.g_date)OR
3469: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>
3470: nvl(p_proficiency_level_id,hr_api.g_number) OR
3471: nvl(per_cel_shd.g_old_rec.line_score,hr_api.g_number) <>
3472: nvl(p_line_score,hr_api.g_number) OR
3473: nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number) <>

Line 3470: nvl(p_proficiency_level_id,hr_api.g_number) OR

3466: nvl(p_certification_method,hr_api.g_varchar2) OR
3467: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>
3468: nvl(p_next_certification_date,hr_api.g_date)OR
3469: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>
3470: nvl(p_proficiency_level_id,hr_api.g_number) OR
3471: nvl(per_cel_shd.g_old_rec.line_score,hr_api.g_number) <>
3472: nvl(p_line_score,hr_api.g_number) OR
3473: nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number) <>
3474: nvl(p_qualification_type_id,hr_api.g_number))

Line 3471: nvl(per_cel_shd.g_old_rec.line_score,hr_api.g_number) <>

3467: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>
3468: nvl(p_next_certification_date,hr_api.g_date)OR
3469: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>
3470: nvl(p_proficiency_level_id,hr_api.g_number) OR
3471: nvl(per_cel_shd.g_old_rec.line_score,hr_api.g_number) <>
3472: nvl(p_line_score,hr_api.g_number) OR
3473: nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number) <>
3474: nvl(p_qualification_type_id,hr_api.g_number))
3475: OR NOT l_api_updating) then

Line 3472: nvl(p_line_score,hr_api.g_number) OR

3468: nvl(p_next_certification_date,hr_api.g_date)OR
3469: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>
3470: nvl(p_proficiency_level_id,hr_api.g_number) OR
3471: nvl(per_cel_shd.g_old_rec.line_score,hr_api.g_number) <>
3472: nvl(p_line_score,hr_api.g_number) OR
3473: nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number) <>
3474: nvl(p_qualification_type_id,hr_api.g_number))
3475: OR NOT l_api_updating) then
3476: hr_utility.set_location(l_proc, 6);

Line 3473: nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number) <>

3469: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>
3470: nvl(p_proficiency_level_id,hr_api.g_number) OR
3471: nvl(per_cel_shd.g_old_rec.line_score,hr_api.g_number) <>
3472: nvl(p_line_score,hr_api.g_number) OR
3473: nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number) <>
3474: nvl(p_qualification_type_id,hr_api.g_number))
3475: OR NOT l_api_updating) then
3476: hr_utility.set_location(l_proc, 6);
3477: --

Line 3474: nvl(p_qualification_type_id,hr_api.g_number))

3470: nvl(p_proficiency_level_id,hr_api.g_number) OR
3471: nvl(per_cel_shd.g_old_rec.line_score,hr_api.g_number) <>
3472: nvl(p_line_score,hr_api.g_number) OR
3473: nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number) <>
3474: nvl(p_qualification_type_id,hr_api.g_number))
3475: OR NOT l_api_updating) then
3476: hr_utility.set_location(l_proc, 6);
3477: --
3478: -- Check the parameters status when the type is 'REQUIREMENT'

Line 3950: hr_api.mandatory_arg_error

3946:
3947: --
3948: -- Mandatory parameter check
3949: --
3950: hr_api.mandatory_arg_error
3951: (p_api_name => l_proc,
3952: p_argument => 'qualification_type_id',
3953: p_argument_value => p_qualification_type_id);
3954:

Line 3955: hr_api.mandatory_arg_error

3951: (p_api_name => l_proc,
3952: p_argument => 'qualification_type_id',
3953: p_argument_value => p_qualification_type_id);
3954:
3955: hr_api.mandatory_arg_error
3956: (p_api_name => l_proc,
3957: p_argument => 'effective_date_from',
3958: p_argument_value => p_effective_date_from);
3959: --

Line 3965: hr_api.mandatory_arg_error

3961: hr_utility.set_location(l_proc, 103);
3962: --
3963: -- Mandatory parameter check
3964: --
3965: hr_api.mandatory_arg_error
3966: (p_api_name => l_proc,
3967: p_argument => 'competence_id',
3968: p_argument_value => p_competence_id);
3969:

Line 4104: hr_api.mandatory_arg_error

4100: (p_check_column1 => 'PER_COMPETENCE_ELEMENTS.TYPE') then
4101: --
4102: -- Check mandatory parameters have being set.
4103: --
4104: hr_api.mandatory_arg_error
4105: (p_api_name => l_proc
4106: ,p_argument => 'type'
4107: ,p_argument_value => p_type
4108: );

Line 4113: hr_api.mandatory_arg_error

4109: -- mandatory parameter
4110: --
4111: -- ngundura this check should not be there for global competence elements
4112: if per_cel_shd.g_bus_grp then
4113: hr_api.mandatory_arg_error
4114: (p_api_name => l_proc
4115: ,p_argument => 'business_group_id'
4116: ,p_argument_value => p_business_group_id
4117: );

Line 4132: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)

4128: (p_competence_element_id => p_competence_element_id
4129: ,p_object_version_number => p_object_version_number);
4130: --
4131: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
4132: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
4133: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
4134: nvl(p_competence_type,hr_api.g_varchar2) OR
4135: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
4136: nvl(p_effective_date_from,hr_api.g_date))

Line 4133: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>

4129: ,p_object_version_number => p_object_version_number);
4130: --
4131: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
4132: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
4133: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
4134: nvl(p_competence_type,hr_api.g_varchar2) OR
4135: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
4136: nvl(p_effective_date_from,hr_api.g_date))
4137: OR NOT l_api_updating) then

Line 4134: nvl(p_competence_type,hr_api.g_varchar2) OR

4130: --
4131: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
4132: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
4133: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
4134: nvl(p_competence_type,hr_api.g_varchar2) OR
4135: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
4136: nvl(p_effective_date_from,hr_api.g_date))
4137: OR NOT l_api_updating) then
4138: hr_utility.set_location(l_proc, 6);

Line 4135: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>

4131: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
4132: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
4133: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
4134: nvl(p_competence_type,hr_api.g_varchar2) OR
4135: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
4136: nvl(p_effective_date_from,hr_api.g_date))
4137: OR NOT l_api_updating) then
4138: hr_utility.set_location(l_proc, 6);
4139: --

Line 4136: nvl(p_effective_date_from,hr_api.g_date))

4132: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
4133: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
4134: nvl(p_competence_type,hr_api.g_varchar2) OR
4135: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
4136: nvl(p_effective_date_from,hr_api.g_date))
4137: OR NOT l_api_updating) then
4138: hr_utility.set_location(l_proc, 6);
4139: --
4140: -- build the NATIVE dynamic SQL

Line 4385: and nvl(effective_date_to,hr_api.g_eot);

4381: where type = 'QUALIFICATION'
4382: and competence_id = p_competence_id
4383: and qualification_type_id = p_qualification_type_id
4384: and p_effective_date between effective_date_from
4385: and nvl(effective_date_to,hr_api.g_eot);
4386: Begin
4387: --
4388: hr_utility.set_location('Entering:'||l_proc,10);
4389: if p_qualification_type_id is not NULL and p_competence_id is not NULL

Line 4402: hr_api.g_number) = nvl(p_competence_id, hr_api.g_number)

4398: ,p_object_version_number => p_object_version_number);
4399: --
4400: if (l_api_updating
4401: and nvl(per_cel_shd.g_old_rec.competence_id,
4402: hr_api.g_number) = nvl(p_competence_id, hr_api.g_number)
4403: and nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number)
4404: = nvl(p_qualification_type_id, hr_api.g_number)
4405: ) then
4406: hr_utility.set_location('Leaving.... ' || l_proc,20);

Line 4403: and nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number)

4399: --
4400: if (l_api_updating
4401: and nvl(per_cel_shd.g_old_rec.competence_id,
4402: hr_api.g_number) = nvl(p_competence_id, hr_api.g_number)
4403: and nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number)
4404: = nvl(p_qualification_type_id, hr_api.g_number)
4405: ) then
4406: hr_utility.set_location('Leaving.... ' || l_proc,20);
4407: return;

Line 4404: = nvl(p_qualification_type_id, hr_api.g_number)

4400: if (l_api_updating
4401: and nvl(per_cel_shd.g_old_rec.competence_id,
4402: hr_api.g_number) = nvl(p_competence_id, hr_api.g_number)
4403: and nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number)
4404: = nvl(p_qualification_type_id, hr_api.g_number)
4405: ) then
4406: hr_utility.set_location('Leaving.... ' || l_proc,20);
4407: return;
4408: end if;

Line 4684: nvl(per_cel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

4680: begin
4681: hr_utility.set_location('Entering:'||l_proc, 10);
4682: --
4683: if ((p_rec.valid_grade_id is not null) and (
4684: nvl(per_cel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
4685: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
4686: nvl(per_cel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
4687: nvl(p_rec.attribute1, hr_api.g_varchar2) or
4688: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

4681: hr_utility.set_location('Entering:'||l_proc, 10);
4682: --
4683: if ((p_rec.valid_grade_id is not null) and (
4684: nvl(per_cel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
4685: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
4686: nvl(per_cel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
4687: nvl(p_rec.attribute1, hr_api.g_varchar2) or
4688: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
4689: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 4686: nvl(per_cel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

4682: --
4683: if ((p_rec.valid_grade_id is not null) and (
4684: nvl(per_cel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
4685: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
4686: nvl(per_cel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
4687: nvl(p_rec.attribute1, hr_api.g_varchar2) or
4688: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
4689: nvl(p_rec.attribute2, hr_api.g_varchar2) or
4690: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

4683: if ((p_rec.valid_grade_id is not null) and (
4684: nvl(per_cel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
4685: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
4686: nvl(per_cel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
4687: nvl(p_rec.attribute1, hr_api.g_varchar2) or
4688: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
4689: nvl(p_rec.attribute2, hr_api.g_varchar2) or
4690: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
4691: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 4688: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

4684: nvl(per_cel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
4685: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
4686: nvl(per_cel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
4687: nvl(p_rec.attribute1, hr_api.g_varchar2) or
4688: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
4689: nvl(p_rec.attribute2, hr_api.g_varchar2) or
4690: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
4691: nvl(p_rec.attribute3, hr_api.g_varchar2) or
4692: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

4685: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
4686: nvl(per_cel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
4687: nvl(p_rec.attribute1, hr_api.g_varchar2) or
4688: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
4689: nvl(p_rec.attribute2, hr_api.g_varchar2) or
4690: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
4691: nvl(p_rec.attribute3, hr_api.g_varchar2) or
4692: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
4693: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 4690: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

4686: nvl(per_cel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
4687: nvl(p_rec.attribute1, hr_api.g_varchar2) or
4688: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
4689: nvl(p_rec.attribute2, hr_api.g_varchar2) or
4690: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
4691: nvl(p_rec.attribute3, hr_api.g_varchar2) or
4692: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
4693: nvl(p_rec.attribute4, hr_api.g_varchar2) or
4694: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

4687: nvl(p_rec.attribute1, hr_api.g_varchar2) or
4688: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
4689: nvl(p_rec.attribute2, hr_api.g_varchar2) or
4690: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
4691: nvl(p_rec.attribute3, hr_api.g_varchar2) or
4692: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
4693: nvl(p_rec.attribute4, hr_api.g_varchar2) or
4694: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
4695: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 4692: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

4688: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
4689: nvl(p_rec.attribute2, hr_api.g_varchar2) or
4690: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
4691: nvl(p_rec.attribute3, hr_api.g_varchar2) or
4692: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
4693: nvl(p_rec.attribute4, hr_api.g_varchar2) or
4694: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
4695: nvl(p_rec.attribute5, hr_api.g_varchar2) or
4696: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

4689: nvl(p_rec.attribute2, hr_api.g_varchar2) or
4690: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
4691: nvl(p_rec.attribute3, hr_api.g_varchar2) or
4692: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
4693: nvl(p_rec.attribute4, hr_api.g_varchar2) or
4694: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
4695: nvl(p_rec.attribute5, hr_api.g_varchar2) or
4696: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
4697: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 4694: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

4690: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
4691: nvl(p_rec.attribute3, hr_api.g_varchar2) or
4692: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
4693: nvl(p_rec.attribute4, hr_api.g_varchar2) or
4694: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
4695: nvl(p_rec.attribute5, hr_api.g_varchar2) or
4696: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
4697: nvl(p_rec.attribute6, hr_api.g_varchar2) or
4698: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

4691: nvl(p_rec.attribute3, hr_api.g_varchar2) or
4692: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
4693: nvl(p_rec.attribute4, hr_api.g_varchar2) or
4694: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
4695: nvl(p_rec.attribute5, hr_api.g_varchar2) or
4696: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
4697: nvl(p_rec.attribute6, hr_api.g_varchar2) or
4698: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
4699: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 4696: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

4692: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
4693: nvl(p_rec.attribute4, hr_api.g_varchar2) or
4694: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
4695: nvl(p_rec.attribute5, hr_api.g_varchar2) or
4696: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
4697: nvl(p_rec.attribute6, hr_api.g_varchar2) or
4698: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
4699: nvl(p_rec.attribute7, hr_api.g_varchar2) or
4700: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

4693: nvl(p_rec.attribute4, hr_api.g_varchar2) or
4694: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
4695: nvl(p_rec.attribute5, hr_api.g_varchar2) or
4696: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
4697: nvl(p_rec.attribute6, hr_api.g_varchar2) or
4698: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
4699: nvl(p_rec.attribute7, hr_api.g_varchar2) or
4700: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
4701: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 4698: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

4694: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
4695: nvl(p_rec.attribute5, hr_api.g_varchar2) or
4696: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
4697: nvl(p_rec.attribute6, hr_api.g_varchar2) or
4698: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
4699: nvl(p_rec.attribute7, hr_api.g_varchar2) or
4700: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
4701: nvl(p_rec.attribute8, hr_api.g_varchar2) or
4702: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

4695: nvl(p_rec.attribute5, hr_api.g_varchar2) or
4696: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
4697: nvl(p_rec.attribute6, hr_api.g_varchar2) or
4698: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
4699: nvl(p_rec.attribute7, hr_api.g_varchar2) or
4700: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
4701: nvl(p_rec.attribute8, hr_api.g_varchar2) or
4702: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
4703: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 4700: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

4696: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
4697: nvl(p_rec.attribute6, hr_api.g_varchar2) or
4698: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
4699: nvl(p_rec.attribute7, hr_api.g_varchar2) or
4700: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
4701: nvl(p_rec.attribute8, hr_api.g_varchar2) or
4702: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
4703: nvl(p_rec.attribute9, hr_api.g_varchar2) or
4704: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

4697: nvl(p_rec.attribute6, hr_api.g_varchar2) or
4698: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
4699: nvl(p_rec.attribute7, hr_api.g_varchar2) or
4700: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
4701: nvl(p_rec.attribute8, hr_api.g_varchar2) or
4702: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
4703: nvl(p_rec.attribute9, hr_api.g_varchar2) or
4704: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
4705: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 4702: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

4698: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
4699: nvl(p_rec.attribute7, hr_api.g_varchar2) or
4700: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
4701: nvl(p_rec.attribute8, hr_api.g_varchar2) or
4702: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
4703: nvl(p_rec.attribute9, hr_api.g_varchar2) or
4704: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
4705: nvl(p_rec.attribute10, hr_api.g_varchar2) or
4706: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

4699: nvl(p_rec.attribute7, hr_api.g_varchar2) or
4700: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
4701: nvl(p_rec.attribute8, hr_api.g_varchar2) or
4702: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
4703: nvl(p_rec.attribute9, hr_api.g_varchar2) or
4704: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
4705: nvl(p_rec.attribute10, hr_api.g_varchar2) or
4706: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
4707: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 4704: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

4700: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
4701: nvl(p_rec.attribute8, hr_api.g_varchar2) or
4702: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
4703: nvl(p_rec.attribute9, hr_api.g_varchar2) or
4704: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
4705: nvl(p_rec.attribute10, hr_api.g_varchar2) or
4706: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
4707: nvl(p_rec.attribute11, hr_api.g_varchar2) or
4708: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

4701: nvl(p_rec.attribute8, hr_api.g_varchar2) or
4702: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
4703: nvl(p_rec.attribute9, hr_api.g_varchar2) or
4704: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
4705: nvl(p_rec.attribute10, hr_api.g_varchar2) or
4706: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
4707: nvl(p_rec.attribute11, hr_api.g_varchar2) or
4708: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
4709: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 4706: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

4702: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
4703: nvl(p_rec.attribute9, hr_api.g_varchar2) or
4704: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
4705: nvl(p_rec.attribute10, hr_api.g_varchar2) or
4706: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
4707: nvl(p_rec.attribute11, hr_api.g_varchar2) or
4708: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
4709: nvl(p_rec.attribute12, hr_api.g_varchar2) or
4710: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

4703: nvl(p_rec.attribute9, hr_api.g_varchar2) or
4704: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
4705: nvl(p_rec.attribute10, hr_api.g_varchar2) or
4706: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
4707: nvl(p_rec.attribute11, hr_api.g_varchar2) or
4708: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
4709: nvl(p_rec.attribute12, hr_api.g_varchar2) or
4710: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
4711: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 4708: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

4704: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
4705: nvl(p_rec.attribute10, hr_api.g_varchar2) or
4706: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
4707: nvl(p_rec.attribute11, hr_api.g_varchar2) or
4708: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
4709: nvl(p_rec.attribute12, hr_api.g_varchar2) or
4710: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
4711: nvl(p_rec.attribute13, hr_api.g_varchar2) or
4712: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

4705: nvl(p_rec.attribute10, hr_api.g_varchar2) or
4706: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
4707: nvl(p_rec.attribute11, hr_api.g_varchar2) or
4708: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
4709: nvl(p_rec.attribute12, hr_api.g_varchar2) or
4710: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
4711: nvl(p_rec.attribute13, hr_api.g_varchar2) or
4712: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
4713: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 4710: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

4706: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
4707: nvl(p_rec.attribute11, hr_api.g_varchar2) or
4708: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
4709: nvl(p_rec.attribute12, hr_api.g_varchar2) or
4710: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
4711: nvl(p_rec.attribute13, hr_api.g_varchar2) or
4712: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
4713: nvl(p_rec.attribute14, hr_api.g_varchar2) or
4714: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

4707: nvl(p_rec.attribute11, hr_api.g_varchar2) or
4708: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
4709: nvl(p_rec.attribute12, hr_api.g_varchar2) or
4710: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
4711: nvl(p_rec.attribute13, hr_api.g_varchar2) or
4712: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
4713: nvl(p_rec.attribute14, hr_api.g_varchar2) or
4714: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
4715: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 4712: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

4708: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
4709: nvl(p_rec.attribute12, hr_api.g_varchar2) or
4710: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
4711: nvl(p_rec.attribute13, hr_api.g_varchar2) or
4712: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
4713: nvl(p_rec.attribute14, hr_api.g_varchar2) or
4714: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
4715: nvl(p_rec.attribute15, hr_api.g_varchar2) or
4716: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

4709: nvl(p_rec.attribute12, hr_api.g_varchar2) or
4710: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
4711: nvl(p_rec.attribute13, hr_api.g_varchar2) or
4712: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
4713: nvl(p_rec.attribute14, hr_api.g_varchar2) or
4714: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
4715: nvl(p_rec.attribute15, hr_api.g_varchar2) or
4716: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
4717: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 4714: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

4710: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
4711: nvl(p_rec.attribute13, hr_api.g_varchar2) or
4712: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
4713: nvl(p_rec.attribute14, hr_api.g_varchar2) or
4714: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
4715: nvl(p_rec.attribute15, hr_api.g_varchar2) or
4716: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
4717: nvl(p_rec.attribute16, hr_api.g_varchar2) or
4718: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

4711: nvl(p_rec.attribute13, hr_api.g_varchar2) or
4712: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
4713: nvl(p_rec.attribute14, hr_api.g_varchar2) or
4714: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
4715: nvl(p_rec.attribute15, hr_api.g_varchar2) or
4716: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
4717: nvl(p_rec.attribute16, hr_api.g_varchar2) or
4718: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
4719: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 4716: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

4712: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
4713: nvl(p_rec.attribute14, hr_api.g_varchar2) or
4714: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
4715: nvl(p_rec.attribute15, hr_api.g_varchar2) or
4716: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
4717: nvl(p_rec.attribute16, hr_api.g_varchar2) or
4718: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
4719: nvl(p_rec.attribute17, hr_api.g_varchar2) or
4720: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

4713: nvl(p_rec.attribute14, hr_api.g_varchar2) or
4714: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
4715: nvl(p_rec.attribute15, hr_api.g_varchar2) or
4716: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
4717: nvl(p_rec.attribute16, hr_api.g_varchar2) or
4718: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
4719: nvl(p_rec.attribute17, hr_api.g_varchar2) or
4720: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
4721: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 4718: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

4714: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
4715: nvl(p_rec.attribute15, hr_api.g_varchar2) or
4716: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
4717: nvl(p_rec.attribute16, hr_api.g_varchar2) or
4718: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
4719: nvl(p_rec.attribute17, hr_api.g_varchar2) or
4720: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
4721: nvl(p_rec.attribute18, hr_api.g_varchar2) or
4722: nvl(per_cel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

4715: nvl(p_rec.attribute15, hr_api.g_varchar2) or
4716: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
4717: nvl(p_rec.attribute16, hr_api.g_varchar2) or
4718: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
4719: nvl(p_rec.attribute17, hr_api.g_varchar2) or
4720: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
4721: nvl(p_rec.attribute18, hr_api.g_varchar2) or
4722: nvl(per_cel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
4723: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 4720: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

4716: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
4717: nvl(p_rec.attribute16, hr_api.g_varchar2) or
4718: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
4719: nvl(p_rec.attribute17, hr_api.g_varchar2) or
4720: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
4721: nvl(p_rec.attribute18, hr_api.g_varchar2) or
4722: nvl(per_cel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
4723: nvl(p_rec.attribute19, hr_api.g_varchar2) or
4724: nvl(per_cel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

4717: nvl(p_rec.attribute16, hr_api.g_varchar2) or
4718: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
4719: nvl(p_rec.attribute17, hr_api.g_varchar2) or
4720: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
4721: nvl(p_rec.attribute18, hr_api.g_varchar2) or
4722: nvl(per_cel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
4723: nvl(p_rec.attribute19, hr_api.g_varchar2) or
4724: nvl(per_cel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
4725: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 4722: nvl(per_cel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

4718: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
4719: nvl(p_rec.attribute17, hr_api.g_varchar2) or
4720: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
4721: nvl(p_rec.attribute18, hr_api.g_varchar2) or
4722: nvl(per_cel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
4723: nvl(p_rec.attribute19, hr_api.g_varchar2) or
4724: nvl(per_cel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
4725: nvl(p_rec.attribute20, hr_api.g_varchar2)))
4726: or

Line 4723: nvl(p_rec.attribute19, hr_api.g_varchar2) or

4719: nvl(p_rec.attribute17, hr_api.g_varchar2) or
4720: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
4721: nvl(p_rec.attribute18, hr_api.g_varchar2) or
4722: nvl(per_cel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
4723: nvl(p_rec.attribute19, hr_api.g_varchar2) or
4724: nvl(per_cel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
4725: nvl(p_rec.attribute20, hr_api.g_varchar2)))
4726: or
4727: (p_rec.valid_grade_id is null) then

Line 4724: nvl(per_cel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

4720: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
4721: nvl(p_rec.attribute18, hr_api.g_varchar2) or
4722: nvl(per_cel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
4723: nvl(p_rec.attribute19, hr_api.g_varchar2) or
4724: nvl(per_cel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
4725: nvl(p_rec.attribute20, hr_api.g_varchar2)))
4726: or
4727: (p_rec.valid_grade_id is null) then
4728: --

Line 4725: nvl(p_rec.attribute20, hr_api.g_varchar2)))

4721: nvl(p_rec.attribute18, hr_api.g_varchar2) or
4722: nvl(per_cel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
4723: nvl(p_rec.attribute19, hr_api.g_varchar2) or
4724: nvl(per_cel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
4725: nvl(p_rec.attribute20, hr_api.g_varchar2)))
4726: or
4727: (p_rec.valid_grade_id is null) then
4728: --
4729: -- Only execute the validation if absolutely necessary:

Line 4823: nvl(per_cel_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

4819: begin
4820: hr_utility.set_location('Entering:'||l_proc,10);
4821: --
4822: if ((p_rec.competence_element_id is not null) and (
4823: nvl(per_cel_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
4824: nvl(p_rec.information_category, hr_api.g_varchar2) or
4825: nvl(per_cel_shd.g_old_rec.information1, hr_api.g_varchar2) <>
4826: nvl(p_rec.information1, hr_api.g_varchar2) or
4827: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 4824: nvl(p_rec.information_category, hr_api.g_varchar2) or

4820: hr_utility.set_location('Entering:'||l_proc,10);
4821: --
4822: if ((p_rec.competence_element_id is not null) and (
4823: nvl(per_cel_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
4824: nvl(p_rec.information_category, hr_api.g_varchar2) or
4825: nvl(per_cel_shd.g_old_rec.information1, hr_api.g_varchar2) <>
4826: nvl(p_rec.information1, hr_api.g_varchar2) or
4827: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>
4828: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 4825: nvl(per_cel_shd.g_old_rec.information1, hr_api.g_varchar2) <>

4821: --
4822: if ((p_rec.competence_element_id is not null) and (
4823: nvl(per_cel_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
4824: nvl(p_rec.information_category, hr_api.g_varchar2) or
4825: nvl(per_cel_shd.g_old_rec.information1, hr_api.g_varchar2) <>
4826: nvl(p_rec.information1, hr_api.g_varchar2) or
4827: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>
4828: nvl(p_rec.information2, hr_api.g_varchar2) or
4829: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 4826: nvl(p_rec.information1, hr_api.g_varchar2) or

4822: if ((p_rec.competence_element_id is not null) and (
4823: nvl(per_cel_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
4824: nvl(p_rec.information_category, hr_api.g_varchar2) or
4825: nvl(per_cel_shd.g_old_rec.information1, hr_api.g_varchar2) <>
4826: nvl(p_rec.information1, hr_api.g_varchar2) or
4827: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>
4828: nvl(p_rec.information2, hr_api.g_varchar2) or
4829: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>
4830: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 4827: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>

4823: nvl(per_cel_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
4824: nvl(p_rec.information_category, hr_api.g_varchar2) or
4825: nvl(per_cel_shd.g_old_rec.information1, hr_api.g_varchar2) <>
4826: nvl(p_rec.information1, hr_api.g_varchar2) or
4827: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>
4828: nvl(p_rec.information2, hr_api.g_varchar2) or
4829: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>
4830: nvl(p_rec.information3, hr_api.g_varchar2) or
4831: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 4828: nvl(p_rec.information2, hr_api.g_varchar2) or

4824: nvl(p_rec.information_category, hr_api.g_varchar2) or
4825: nvl(per_cel_shd.g_old_rec.information1, hr_api.g_varchar2) <>
4826: nvl(p_rec.information1, hr_api.g_varchar2) or
4827: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>
4828: nvl(p_rec.information2, hr_api.g_varchar2) or
4829: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>
4830: nvl(p_rec.information3, hr_api.g_varchar2) or
4831: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>
4832: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 4829: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>

4825: nvl(per_cel_shd.g_old_rec.information1, hr_api.g_varchar2) <>
4826: nvl(p_rec.information1, hr_api.g_varchar2) or
4827: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>
4828: nvl(p_rec.information2, hr_api.g_varchar2) or
4829: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>
4830: nvl(p_rec.information3, hr_api.g_varchar2) or
4831: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>
4832: nvl(p_rec.information4, hr_api.g_varchar2) or
4833: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 4830: nvl(p_rec.information3, hr_api.g_varchar2) or

4826: nvl(p_rec.information1, hr_api.g_varchar2) or
4827: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>
4828: nvl(p_rec.information2, hr_api.g_varchar2) or
4829: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>
4830: nvl(p_rec.information3, hr_api.g_varchar2) or
4831: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>
4832: nvl(p_rec.information4, hr_api.g_varchar2) or
4833: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>
4834: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 4831: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>

4827: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>
4828: nvl(p_rec.information2, hr_api.g_varchar2) or
4829: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>
4830: nvl(p_rec.information3, hr_api.g_varchar2) or
4831: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>
4832: nvl(p_rec.information4, hr_api.g_varchar2) or
4833: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>
4834: nvl(p_rec.information5, hr_api.g_varchar2) or
4835: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 4832: nvl(p_rec.information4, hr_api.g_varchar2) or

4828: nvl(p_rec.information2, hr_api.g_varchar2) or
4829: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>
4830: nvl(p_rec.information3, hr_api.g_varchar2) or
4831: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>
4832: nvl(p_rec.information4, hr_api.g_varchar2) or
4833: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>
4834: nvl(p_rec.information5, hr_api.g_varchar2) or
4835: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>
4836: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 4833: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>

4829: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>
4830: nvl(p_rec.information3, hr_api.g_varchar2) or
4831: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>
4832: nvl(p_rec.information4, hr_api.g_varchar2) or
4833: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>
4834: nvl(p_rec.information5, hr_api.g_varchar2) or
4835: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>
4836: nvl(p_rec.information6, hr_api.g_varchar2) or
4837: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 4834: nvl(p_rec.information5, hr_api.g_varchar2) or

4830: nvl(p_rec.information3, hr_api.g_varchar2) or
4831: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>
4832: nvl(p_rec.information4, hr_api.g_varchar2) or
4833: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>
4834: nvl(p_rec.information5, hr_api.g_varchar2) or
4835: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>
4836: nvl(p_rec.information6, hr_api.g_varchar2) or
4837: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>
4838: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 4835: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>

4831: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>
4832: nvl(p_rec.information4, hr_api.g_varchar2) or
4833: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>
4834: nvl(p_rec.information5, hr_api.g_varchar2) or
4835: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>
4836: nvl(p_rec.information6, hr_api.g_varchar2) or
4837: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>
4838: nvl(p_rec.information7, hr_api.g_varchar2) or
4839: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 4836: nvl(p_rec.information6, hr_api.g_varchar2) or

4832: nvl(p_rec.information4, hr_api.g_varchar2) or
4833: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>
4834: nvl(p_rec.information5, hr_api.g_varchar2) or
4835: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>
4836: nvl(p_rec.information6, hr_api.g_varchar2) or
4837: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>
4838: nvl(p_rec.information7, hr_api.g_varchar2) or
4839: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>
4840: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 4837: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>

4833: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>
4834: nvl(p_rec.information5, hr_api.g_varchar2) or
4835: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>
4836: nvl(p_rec.information6, hr_api.g_varchar2) or
4837: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>
4838: nvl(p_rec.information7, hr_api.g_varchar2) or
4839: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>
4840: nvl(p_rec.information8, hr_api.g_varchar2) or
4841: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 4838: nvl(p_rec.information7, hr_api.g_varchar2) or

4834: nvl(p_rec.information5, hr_api.g_varchar2) or
4835: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>
4836: nvl(p_rec.information6, hr_api.g_varchar2) or
4837: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>
4838: nvl(p_rec.information7, hr_api.g_varchar2) or
4839: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>
4840: nvl(p_rec.information8, hr_api.g_varchar2) or
4841: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>
4842: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 4839: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>

4835: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>
4836: nvl(p_rec.information6, hr_api.g_varchar2) or
4837: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>
4838: nvl(p_rec.information7, hr_api.g_varchar2) or
4839: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>
4840: nvl(p_rec.information8, hr_api.g_varchar2) or
4841: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>
4842: nvl(p_rec.information9, hr_api.g_varchar2) or
4843: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 4840: nvl(p_rec.information8, hr_api.g_varchar2) or

4836: nvl(p_rec.information6, hr_api.g_varchar2) or
4837: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>
4838: nvl(p_rec.information7, hr_api.g_varchar2) or
4839: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>
4840: nvl(p_rec.information8, hr_api.g_varchar2) or
4841: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>
4842: nvl(p_rec.information9, hr_api.g_varchar2) or
4843: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>
4844: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 4841: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>

4837: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>
4838: nvl(p_rec.information7, hr_api.g_varchar2) or
4839: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>
4840: nvl(p_rec.information8, hr_api.g_varchar2) or
4841: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>
4842: nvl(p_rec.information9, hr_api.g_varchar2) or
4843: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>
4844: nvl(p_rec.information10, hr_api.g_varchar2) or
4845: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 4842: nvl(p_rec.information9, hr_api.g_varchar2) or

4838: nvl(p_rec.information7, hr_api.g_varchar2) or
4839: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>
4840: nvl(p_rec.information8, hr_api.g_varchar2) or
4841: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>
4842: nvl(p_rec.information9, hr_api.g_varchar2) or
4843: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>
4844: nvl(p_rec.information10, hr_api.g_varchar2) or
4845: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>
4846: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 4843: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>

4839: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>
4840: nvl(p_rec.information8, hr_api.g_varchar2) or
4841: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>
4842: nvl(p_rec.information9, hr_api.g_varchar2) or
4843: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>
4844: nvl(p_rec.information10, hr_api.g_varchar2) or
4845: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>
4846: nvl(p_rec.information11, hr_api.g_varchar2) or
4847: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 4844: nvl(p_rec.information10, hr_api.g_varchar2) or

4840: nvl(p_rec.information8, hr_api.g_varchar2) or
4841: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>
4842: nvl(p_rec.information9, hr_api.g_varchar2) or
4843: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>
4844: nvl(p_rec.information10, hr_api.g_varchar2) or
4845: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>
4846: nvl(p_rec.information11, hr_api.g_varchar2) or
4847: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>
4848: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 4845: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>

4841: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>
4842: nvl(p_rec.information9, hr_api.g_varchar2) or
4843: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>
4844: nvl(p_rec.information10, hr_api.g_varchar2) or
4845: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>
4846: nvl(p_rec.information11, hr_api.g_varchar2) or
4847: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>
4848: nvl(p_rec.information13, hr_api.g_varchar2) or
4849: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 4846: nvl(p_rec.information11, hr_api.g_varchar2) or

4842: nvl(p_rec.information9, hr_api.g_varchar2) or
4843: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>
4844: nvl(p_rec.information10, hr_api.g_varchar2) or
4845: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>
4846: nvl(p_rec.information11, hr_api.g_varchar2) or
4847: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>
4848: nvl(p_rec.information13, hr_api.g_varchar2) or
4849: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>
4850: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 4847: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>

4843: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>
4844: nvl(p_rec.information10, hr_api.g_varchar2) or
4845: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>
4846: nvl(p_rec.information11, hr_api.g_varchar2) or
4847: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>
4848: nvl(p_rec.information13, hr_api.g_varchar2) or
4849: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>
4850: nvl(p_rec.information14, hr_api.g_varchar2) or
4851: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 4848: nvl(p_rec.information13, hr_api.g_varchar2) or

4844: nvl(p_rec.information10, hr_api.g_varchar2) or
4845: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>
4846: nvl(p_rec.information11, hr_api.g_varchar2) or
4847: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>
4848: nvl(p_rec.information13, hr_api.g_varchar2) or
4849: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>
4850: nvl(p_rec.information14, hr_api.g_varchar2) or
4851: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>
4852: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 4849: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>

4845: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>
4846: nvl(p_rec.information11, hr_api.g_varchar2) or
4847: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>
4848: nvl(p_rec.information13, hr_api.g_varchar2) or
4849: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>
4850: nvl(p_rec.information14, hr_api.g_varchar2) or
4851: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>
4852: nvl(p_rec.information15, hr_api.g_varchar2) or
4853: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 4850: nvl(p_rec.information14, hr_api.g_varchar2) or

4846: nvl(p_rec.information11, hr_api.g_varchar2) or
4847: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>
4848: nvl(p_rec.information13, hr_api.g_varchar2) or
4849: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>
4850: nvl(p_rec.information14, hr_api.g_varchar2) or
4851: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>
4852: nvl(p_rec.information15, hr_api.g_varchar2) or
4853: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>
4854: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 4851: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>

4847: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>
4848: nvl(p_rec.information13, hr_api.g_varchar2) or
4849: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>
4850: nvl(p_rec.information14, hr_api.g_varchar2) or
4851: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>
4852: nvl(p_rec.information15, hr_api.g_varchar2) or
4853: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>
4854: nvl(p_rec.information16, hr_api.g_varchar2) or
4855: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 4852: nvl(p_rec.information15, hr_api.g_varchar2) or

4848: nvl(p_rec.information13, hr_api.g_varchar2) or
4849: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>
4850: nvl(p_rec.information14, hr_api.g_varchar2) or
4851: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>
4852: nvl(p_rec.information15, hr_api.g_varchar2) or
4853: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>
4854: nvl(p_rec.information16, hr_api.g_varchar2) or
4855: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>
4856: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 4853: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>

4849: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>
4850: nvl(p_rec.information14, hr_api.g_varchar2) or
4851: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>
4852: nvl(p_rec.information15, hr_api.g_varchar2) or
4853: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>
4854: nvl(p_rec.information16, hr_api.g_varchar2) or
4855: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>
4856: nvl(p_rec.information17, hr_api.g_varchar2) or
4857: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 4854: nvl(p_rec.information16, hr_api.g_varchar2) or

4850: nvl(p_rec.information14, hr_api.g_varchar2) or
4851: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>
4852: nvl(p_rec.information15, hr_api.g_varchar2) or
4853: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>
4854: nvl(p_rec.information16, hr_api.g_varchar2) or
4855: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>
4856: nvl(p_rec.information17, hr_api.g_varchar2) or
4857: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>
4858: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 4855: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>

4851: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>
4852: nvl(p_rec.information15, hr_api.g_varchar2) or
4853: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>
4854: nvl(p_rec.information16, hr_api.g_varchar2) or
4855: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>
4856: nvl(p_rec.information17, hr_api.g_varchar2) or
4857: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>
4858: nvl(p_rec.information18, hr_api.g_varchar2) or
4859: nvl(per_cel_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 4856: nvl(p_rec.information17, hr_api.g_varchar2) or

4852: nvl(p_rec.information15, hr_api.g_varchar2) or
4853: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>
4854: nvl(p_rec.information16, hr_api.g_varchar2) or
4855: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>
4856: nvl(p_rec.information17, hr_api.g_varchar2) or
4857: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>
4858: nvl(p_rec.information18, hr_api.g_varchar2) or
4859: nvl(per_cel_shd.g_old_rec.information19, hr_api.g_varchar2) <>
4860: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 4857: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>

4853: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>
4854: nvl(p_rec.information16, hr_api.g_varchar2) or
4855: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>
4856: nvl(p_rec.information17, hr_api.g_varchar2) or
4857: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>
4858: nvl(p_rec.information18, hr_api.g_varchar2) or
4859: nvl(per_cel_shd.g_old_rec.information19, hr_api.g_varchar2) <>
4860: nvl(p_rec.information19, hr_api.g_varchar2) or
4861: nvl(per_cel_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 4858: nvl(p_rec.information18, hr_api.g_varchar2) or

4854: nvl(p_rec.information16, hr_api.g_varchar2) or
4855: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>
4856: nvl(p_rec.information17, hr_api.g_varchar2) or
4857: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>
4858: nvl(p_rec.information18, hr_api.g_varchar2) or
4859: nvl(per_cel_shd.g_old_rec.information19, hr_api.g_varchar2) <>
4860: nvl(p_rec.information19, hr_api.g_varchar2) or
4861: nvl(per_cel_shd.g_old_rec.information20, hr_api.g_varchar2) <>
4862: nvl(p_rec.information20, hr_api.g_varchar2)))

Line 4859: nvl(per_cel_shd.g_old_rec.information19, hr_api.g_varchar2) <>

4855: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>
4856: nvl(p_rec.information17, hr_api.g_varchar2) or
4857: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>
4858: nvl(p_rec.information18, hr_api.g_varchar2) or
4859: nvl(per_cel_shd.g_old_rec.information19, hr_api.g_varchar2) <>
4860: nvl(p_rec.information19, hr_api.g_varchar2) or
4861: nvl(per_cel_shd.g_old_rec.information20, hr_api.g_varchar2) <>
4862: nvl(p_rec.information20, hr_api.g_varchar2)))
4863: or (p_rec.competence_element_id is not null) then

Line 4860: nvl(p_rec.information19, hr_api.g_varchar2) or

4856: nvl(p_rec.information17, hr_api.g_varchar2) or
4857: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>
4858: nvl(p_rec.information18, hr_api.g_varchar2) or
4859: nvl(per_cel_shd.g_old_rec.information19, hr_api.g_varchar2) <>
4860: nvl(p_rec.information19, hr_api.g_varchar2) or
4861: nvl(per_cel_shd.g_old_rec.information20, hr_api.g_varchar2) <>
4862: nvl(p_rec.information20, hr_api.g_varchar2)))
4863: or (p_rec.competence_element_id is not null) then
4864: --

Line 4861: nvl(per_cel_shd.g_old_rec.information20, hr_api.g_varchar2) <>

4857: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>
4858: nvl(p_rec.information18, hr_api.g_varchar2) or
4859: nvl(per_cel_shd.g_old_rec.information19, hr_api.g_varchar2) <>
4860: nvl(p_rec.information19, hr_api.g_varchar2) or
4861: nvl(per_cel_shd.g_old_rec.information20, hr_api.g_varchar2) <>
4862: nvl(p_rec.information20, hr_api.g_varchar2)))
4863: or (p_rec.competence_element_id is not null) then
4864: --
4865: -- Only execute the validation if absolutely necessary:

Line 4862: nvl(p_rec.information20, hr_api.g_varchar2)))

4858: nvl(p_rec.information18, hr_api.g_varchar2) or
4859: nvl(per_cel_shd.g_old_rec.information19, hr_api.g_varchar2) <>
4860: nvl(p_rec.information19, hr_api.g_varchar2) or
4861: nvl(per_cel_shd.g_old_rec.information20, hr_api.g_varchar2) <>
4862: nvl(p_rec.information20, hr_api.g_varchar2)))
4863: or (p_rec.competence_element_id is not null) then
4864: --
4865: -- Only execute the validation if absolutely necessary:
4866: -- a) During update, the structure column value or any

Line 4945: hr_api.validate_bus_grp_id(

4941: -- ngundura added this if condition
4942:
4943: if ( p_rec.type not in ('PROJECT_ROLE','OPEN_ASSIGNMENT','QUALIFICATION','ASSESSMENT_GROUP','ASSESSMENT_COMPETENCE')) then
4944: -- Validate Bus Grp
4945: hr_api.validate_bus_grp_id(
4946: p_business_group_id => p_rec.business_group_id
4947: ,p_associated_column1 => per_cel_shd.g_tab_nam ||
4948: '.BUSINESS_GROUP_ID'
4949: );

Line 5341: hr_api.validate_bus_grp_id(

5337: --
5338: -- Validate business_group_id
5339: --
5340: if ( p_rec.type not in ('PROJECT_ROLE','OPEN_ASSIGNMENT','QUALIFICATION','ASSESSMENT_GROUP','ASSESSMENT_COMPETENCE')) then
5341: hr_api.validate_bus_grp_id(
5342: p_business_group_id => p_rec.business_group_id
5343: ,p_associated_column1 => per_cel_shd.g_tab_nam ||
5344: '.BUSINESS_GROUP_ID'
5345: );

Line 5756: hr_api.mandatory_arg_error (p_api_name => l_proc,

5752: hr_utility.set_location('Entering:'||l_proc, 5);
5753: --
5754: -- Ensure that all the mandatory parameters are not null
5755: --
5756: hr_api.mandatory_arg_error (p_api_name => l_proc,
5757: p_argument => 'competence_element_id',
5758: p_argument_value => p_competence_element_id );
5759: --
5760: Select 'Y' into l_business_group_flag

Line 5770: if nvl(g_competence_element_id, hr_api.g_number) = p_competence_element_id then

5766: if l_business_group_flag = 'Y' then
5767: return null;
5768: end if;
5769:
5770: if nvl(g_competence_element_id, hr_api.g_number) = p_competence_element_id then
5771: --
5772: -- The legislation code has already been found with a previous
5773: -- call to this function. Just return the value in the global
5774: -- variable.