[Home] [Help]
16: -- ----------------------------------------------------------------------------
17: -- |----------------------< check_non_updateable_args >-----------------------|
18: -- ----------------------------------------------------------------------------
19: --
20: Procedure check_non_updateable_args(p_rec in per_cel_shd.g_rec_type) is
21: --
22: l_proc varchar2(72) := g_package||'check_non_updateable_args';
23: --
24: Begin
27: -- Only proceed with validation if a row exists for
28: -- the current record in the HR Schema
29:
30: --
31: if not per_cel_shd.api_updating
32: (p_competence_element_id => p_rec.competence_element_id
33: ,p_object_version_number => p_rec.object_version_number
34: ) then
35: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: end if;
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
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: );
48: end if;
49: hr_utility.set_location(l_proc, 7);
50: --
47: );
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
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: );
57: end if;
58: hr_utility.set_location(l_proc, 8);
59: --
57: end if;
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
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: );
67:
68: end if;
69: hr_utility.set_location(l_proc, 9);
68: end if;
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
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: );
78: end if;
79: hr_utility.set_location(l_proc, 10);
80: --
77: );
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
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: );
87: end if;
88: hr_utility.set_location(l_proc, 13);
89: --
88: hr_utility.set_location(l_proc, 13);
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
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: );
98: end if;
99: -- HR/TCA merge support party_id
100: -- But allow change to NULL or if currently NULL
97: );
98: end if;
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'
98: end if;
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
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: );
108: end if;
109:
110: hr_utility.set_location(l_proc, 15);
108: end if;
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
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: );
118:
119: end if;
120: hr_utility.set_location(l_proc, 16);
118:
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
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: );
128: end if;
129: hr_utility.set_location(l_proc, 16);
130: --
127: );
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
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: );
137: end if;
138: hr_utility.set_location(l_proc, 17);
139:
137: end if;
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
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: );
147: end if;
148: hr_utility.set_location(l_proc, 18);
149: --
147: end if;
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
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: );
157: end if;
158: hr_utility.set_location(l_proc, 20);
159:
158: hr_utility.set_location(l_proc, 20);
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
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: );
168: end if;
169: hr_utility.set_location(l_proc, 22);
170: --
167: );
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
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: );
177: end if;
178: hr_utility.set_location(l_proc, 25);
179: --
176: );
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
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: );
186: end if;
187: --
188: if p_rec.object_name <> per_cel_shd.g_old_rec.object_name then
184: ,p_base_table => per_cel_shd.g_tab_nam
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
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: );
194: end if;
195: end check_non_updateable_args;
196: --
256:
257: -- a) The current g_old_rec is current and
258: -- b) The value for mandatory has changed
259: --
260: l_api_updating := per_cel_shd.api_updating
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,
260: l_api_updating := per_cel_shd.api_updating
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);
360: -- Only proceed with validation if :
361: -- a) The current g_old_rec is current and
362: -- b) The value for certification_method has changed
363: --
364: l_api_updating := per_cel_shd.api_updating
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,
364: l_api_updating := per_cel_shd.api_updating
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);
463: -- Only proceed with validation if :
464: -- a) The current g_old_rec is current and
465: -- b) The value for certification_method has changed
466: --
467: l_api_updating := per_cel_shd.api_updating
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,
467: l_api_updating := per_cel_shd.api_updating
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)))
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: --
581: --
582: -- Only Proceed if the value for g_old_rec is current
583: -- and the value for the certification method has changed
584: --
585: l_api_updating := per_cel_shd.api_updating
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,
585: l_api_updating := per_cel_shd.api_updating
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))
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))
595: then hr_utility.set_location(l_proc, 6);
596: --
701: -- Only proceed with validation if :
702: -- a) The current g_old_rec is current and
703: -- b) The value for competence_type has changed
704: --
705: l_api_updating := per_cel_shd.api_updating
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,
705: l_api_updating := per_cel_shd.api_updating
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:
809: -- Only proceed with validation if :
810: -- a) The current g_old_rec is current and
811: -- b) The value for source_of_proficiency has changed
812: --
813: l_api_updating := per_cel_shd.api_updating
814: (p_competence_element_id => p_competence_element_id
815: ,p_object_version_number => p_object_version_number);
816: --
817: if (l_api_updating AND
814: (p_competence_element_id => p_competence_element_id
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
922: ,p_argument_value => p_type
923: );
924: --
925: --
926: l_api_updating := per_cel_shd.api_updating
927: (p_competence_element_id => p_competence_element_id
928:
929: ,p_object_version_number => p_object_version_number);
930: --
1302: --
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
1314: --
1315: -- We only proceed with the checking if it is not updating and
1316: -- the p_person_id is not null.
1317: --
1318: l_api_updating := per_cel_shd.api_updating
1319: (p_competence_element_id => p_competence_element_id
1320: ,p_object_version_number => p_object_version_number);
1321: --
1322: IF ( NOT l_api_updating ) then
1331: fetch csr_valid_person_id into l_business_group_id,l_start_date,l_end_date;
1332: if csr_valid_person_id%notfound then
1333: --hr_utility.set_location(l_proc, 10);
1334: close csr_valid_person_id;
1335: --per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK7');
1336: else
1337:
1338: close csr_valid_person_id;
1339: if
1341: --
1342: -- The person_id exists in a different_business_group_id.
1343: --
1344: hr_utility.set_location(l_proc, 15);
1345: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1346: elsif invalid_person_dates(p_effective_date_from,p_effective_date_to) then
1347: --
1348: -- The person_id is not date valid
1349: -- Part of fix for bug 572277
1347: --
1348: -- The person_id is not date valid
1349: -- Part of fix for bug 572277
1350: --
1351: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK19');
1352: end if;
1353: end if;
1354: --
1355: end if;
1377: --
1378: -- The activity_version exists in a different_business_group_id.
1379: --
1380: hr_utility.set_location(l_proc, 50);
1381: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1382: --
1383: elsif l_start_date > p_effective_date_from or
1384: l_end_date < nvl(p_effective_date_to, l_end_date) then
1385: --
1407: fetch csr_valid_job_id into l_business_group_id, l_start_date,l_end_date;
1408: if csr_valid_job_id%notfound then
1409: hr_utility.set_location(l_proc, 85);
1410: close csr_valid_job_id;
1411: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK8');
1412: else
1413: close csr_valid_job_id;
1414: if
1415: p_business_group_id <> l_business_group_id then
1417: --
1418: -- The job_id exists in a different_business_group_id.
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: --
1425: --
1426: -- The job_id is not date valid
1427: -- Part of fix for bug 572277
1428: --
1429: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK20');
1430:
1431:
1432: end if;
1433: end if;
1456: --
1457: -- The valid_grade_id exists in a different_business_group_id.
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: --
1464: --
1465: -- The valid_grade_id is not date valid
1466: -- Part of fix for bug 572277
1467: --
1468: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK22');
1469:
1470: end if;
1471: end if;
1472: --
1482: fetch csr_valid_position_id into l_business_group_id,l_start_date,l_end_date;
1483: if csr_valid_position_id%notfound then
1484: hr_utility.set_location(l_proc, 100);
1485: close csr_valid_position_id;
1486: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK9');
1487: else
1488: close csr_valid_position_id;
1489: if
1490: p_business_group_id <> l_business_group_id then
1491: --
1492: -- The position_id exists in a different_business_group_id.
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: --
1499: --
1500: -- The position_id is not date valid
1501: -- Part of fix for bug 572277
1502: --
1503: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK20');
1504:
1505: end if;
1506: end if;
1507: --
1515: fetch csr_valid_organization_id into l_business_group_id,l_start_date,l_end_date;
1516: if csr_valid_organization_id%notfound then
1517: hr_utility.set_location(l_proc, 115);
1518: close csr_valid_organization_id;
1519: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK10');
1520: else
1521: close csr_valid_organization_id;
1522: if
1523: p_business_group_id <> l_business_group_id then
1525: -- The organization_id exists in a different_business_group_id.
1526: --
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: --
1533: --
1534: -- The organization_id is not date valid
1535: -- Part of fix for bug 572277
1536: --
1537: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK20');
1538: end if;
1539: --
1540: end if;
1541: --
1550:
1551: if csr_valid_assessment_id%notfound then
1552: hr_utility.set_location(l_proc, 130);
1553: close csr_valid_assessment_id;
1554: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK14');
1555: else
1556: close csr_valid_assessment_id;
1557: if
1558: p_business_group_id <> l_business_group_id then
1559: --
1560: -- The assessment_id exists in a different_business_group_id.
1561: --
1562: hr_utility.set_location(l_proc, 135);
1563: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1564:
1565: end if;
1566: --
1567: end if;
1578: if csr_valid_assessment_type_id%notfound then
1579:
1580: hr_utility.set_location(l_proc, 152);
1581: close csr_valid_assessment_type_id;
1582: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK15');
1583: else
1584: close csr_valid_assessment_type_id;
1585: if
1586: p_business_group_id <> l_business_group_id then
1587: --
1588: -- The assessment_type_id exists in a different_business_group_id.
1589: --
1590: hr_utility.set_location(l_proc, 153);
1591: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1592: end if;
1593:
1594: --
1595: end if;
1604: if csr_valid_comp_id%notfound then
1605: hr_utility.set_location(l_proc, 160);
1606: close csr_valid_comp_id;
1607:
1608: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK18');
1609: else
1610: close csr_valid_comp_id;
1611: if
1612: p_business_group_id <> l_business_group_id then
1614: -- The parent_comp_element_id exists in
1615: -- a different_business_group_id.
1616: --
1617: hr_utility.set_location(l_proc, 165);
1618: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1619: end if;
1620: --
1621:
1622: end if;
1632: fetch csr_val_prof_id into l_business_group_id;
1633: if csr_val_prof_id%notfound then
1634: hr_utility.set_location(l_proc, 210);
1635: close csr_val_prof_id;
1636: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK6');
1637: else
1638:
1639: close csr_val_prof_id;
1640: if
1643: -- The high_proficiency_level_id exists in a
1644: -- different_business_group_id.
1645: --
1646: hr_utility.set_location(l_proc, 215);
1647: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1648: end if;
1649: end if;
1650: --
1651: end if;
1660: fetch csr_val_prof_id into l_business_group_id;
1661: if csr_val_prof_id%notfound then
1662: hr_utility.set_location(l_proc, 225);
1663: close csr_val_prof_id;
1664: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK5');
1665: else
1666:
1667: hr_utility.set_location(l_proc, 226);
1668: close csr_val_prof_id;
1674: -- The proficiency_level_id exists
1675: -- in a different_business_group_id.
1676: --
1677: hr_utility.set_location(l_proc, 230);
1678: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1679: end if;
1680: end if;
1681:
1682: --
1690: fetch csr_val_prof_id into l_business_group_id;
1691: if csr_val_prof_id%notfound then
1692: hr_utility.set_location(l_proc, 240);
1693: close csr_val_prof_id;
1694: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK17');
1695:
1696: else
1697: close csr_val_prof_id;
1698: if
1701: -- The weighting_level_id exists in
1702: -- a different_business_group_id.
1703: --
1704: hr_utility.set_location(l_proc, 245);
1705: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1706: end if;
1707: end if;
1708: --
1709:
1717: fetch csr_val_prof_id into l_business_group_id;
1718: if csr_val_prof_id%notfound then
1719: hr_utility.set_location(l_proc, 255);
1720: close csr_val_prof_id;
1721: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK16');
1722: else
1723:
1724: close csr_val_prof_id;
1725: -- ngundura changes done for pa requirements
1728: --
1729: -- The rating_level_id exists in a different_business_group_id.
1730: --
1731: hr_utility.set_location(l_proc, 260);
1732: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1733: end if;
1734: end if;
1735: --
1736: end if;
1745: open csr_usage_competence_id;
1746: fetch csr_usage_competence_id into l_business_group_id;
1747: if csr_usage_competence_id%notfound then
1748: close csr_usage_competence_id;
1749: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK1');
1750: else
1751: close csr_usage_competence_id;
1752: -- ngundura changes done for pa requirements
1753: -- added the AND condition in the following if
1755: p_business_group_id <> l_business_group_id and l_business_group_id is not null then
1756: --
1757: -- The competence_id exists in a different_business_group_id.
1758: --
1759: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1760: end if;
1761: end if;
1762: else
1763: open csr_valid_competence_id;
1766: hr_utility.set_location(l_proc, 267);
1767: if csr_valid_competence_id%notfound then
1768: hr_utility.set_location(l_proc, 270);
1769: close csr_valid_competence_id;
1770: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK1');
1771: else
1772: hr_utility.set_location(l_proc, 271);
1773: close csr_valid_competence_id;
1774: -- ngundura changes done for pa requirement
1778: --
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: --
1786: --
1787: -- The competence_id is not date valid
1788: -- Part of fix for bug 572277
1789: --
1790: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK21');
1791:
1792: end if;
1793: end if;
1794: --
1794: --
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
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: --
1810: fetch csr_val_prof_id into l_business_group_id;
1811: if csr_val_prof_id%notfound then
1812: hr_utility.set_location(l_proc, 285);
1813: close csr_val_prof_id;
1814: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK6');
1815: else
1816: close csr_val_prof_id;
1817: -- ngundura changes for pa requirements
1818: if
1822: -- different_business_group_id.
1823:
1824: --
1825: hr_utility.set_location(l_proc, 290);
1826: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1827: end if;
1828: end if;
1829: --
1830: end if;
1838: fetch csr_val_prof_id into l_business_group_id;
1839: if csr_val_prof_id%notfound then
1840: hr_utility.set_location(l_proc, 300);
1841: close csr_val_prof_id;
1842: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK5');
1843: else
1844: close csr_val_prof_id;
1845: -- ngundura changes for pa requirements
1846: -- added the AND condition in the following if
1851: -- different_business_group_id.
1852: --
1853:
1854: hr_utility.set_location(l_proc, 305);
1855: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK2');
1856: end if;
1857: end if;
1858: --
1859: end if;
1881: --
1882: -- The person_id is not date valid
1883: -- Part of fix for bug 572277
1884: --
1885: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK19');
1886: end if;
1887: --
1888: end if;
1889: --
1927: --
1928: -- The job_id is not date valid
1929: -- Part of fix for bug 572277
1930: --
1931: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK20');
1932: end if;
1933: --
1934: end if;
1935: --
1946: --
1947: -- The valid_grade_id is not date valid
1948: -- Part of fix for bug 572277
1949: --
1950: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK22');
1951:
1952: end if;
1953: --
1954: end if;
1968: --
1969: -- The position_id is not date valid
1970: -- Part of fix for bug 572277
1971: --
1972: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK20');
1973:
1974: end if;
1975: --
1976: end if;
1988: --
1989: -- The organization_id is not date valid
1990: -- Part of fix for bug 572277
1991: --
1992: per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK20');
1993: end if;
1994: --
1995: end if;
1996: --
2008: --
2009: -- The competence_id is not date valid
2010: -- Part of fix for bug 572277
2011: --
2012: Per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK21');
2013:
2014: end if;
2015: --
2016: end if;
2024: fetch csr_valid_qualification_type into l_qualification_type_id;
2025:
2026: if csr_valid_qualification_type%NOTFOUND then
2027: close csr_valid_qualification_type;
2028: Per_cel_shd.constraint_error('PER_COMPETENCE_ELEMENTS_FK23');
2029: else
2030: close csr_valid_qualification_type;
2031: end if;
2032: --
2067: -- Internal Table Handler Use Only.
2068: --
2069: --
2070: Procedure chk_party_id(
2071: p_rec in out nocopy per_cel_shd.g_rec_type
2072: ,p_effective_date in date
2073: )is
2074: --
2075: l_proc varchar2(72) := g_package||'chk_party_id';
2306: --
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
2320: -- a) The current g_old_rec is current and
2321: -- b) The value for proficiency has changed
2322: --
2323: --
2324: l_api_updating := per_cel_shd.api_updating
2325: (p_competence_element_id => p_competence_element_id
2326: ,p_object_version_number => p_object_version_number);
2327: --
2328: --
2325: (p_competence_element_id => p_competence_element_id
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
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
2503: --
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
2520: -- a) The current g_old_rec is current and
2521: -- b) The value for proficiency has changed
2522: --
2523: --
2524: l_api_updating := per_cel_shd.api_updating
2525: (p_competence_element_id => p_competence_element_id
2526: ,p_object_version_number => p_object_version_number);
2527: --
2528: -- only do this procedure if the type is assessment.
2528: -- only do this procedure if the type is assessment.
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
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
2772: --
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
2785: -- a) The current g_old_rec is current and
2786: -- b) The value for proficiency has changed
2787: --
2788: --
2789: l_api_updating := per_cel_shd.api_updating
2790: (p_competence_element_id => p_competence_element_id
2791: ,p_object_version_number => p_object_version_number);
2792: --
2793: --
2790: (p_competence_element_id => p_competence_element_id
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
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
2946: -- b) The value for elapse_duration or unit has changed
2947: --
2948:
2949: --
2950: l_api_updating := per_cel_shd.api_updating
2951: (p_competence_element_id => p_competence_element_id
2952: ,p_object_version_number => p_object_version_number);
2953: --
2954: --
2951: (p_competence_element_id => p_competence_element_id
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))
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:
3118: --
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
3133: -- a) The current g_old_rec is current and
3134: -- b) The value for rating_level_id or weighting level_id has changed.
3135: --
3136: --
3137: l_api_updating := per_cel_shd.api_updating
3138:
3139: (p_competence_element_id => p_competence_element_id
3140: ,p_object_version_number => p_object_version_number);
3141: --
3139: (p_competence_element_id => p_competence_element_id
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
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
3403: -- mandatory parameter
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
3431: --
3432: -- NOTE: Only updateable parameters are checked
3433: --
3434: --
3435: l_api_updating := per_cel_shd.api_updating
3436: (p_competence_element_id => p_competence_element_id
3437:
3438: ,p_object_version_number => p_object_version_number);
3439:
3437:
3438: ,p_object_version_number => p_object_version_number);
3439:
3440: --
3441: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
3442: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
3443: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
3444: nvl(p_competence_type,hr_api.g_varchar2) OR
3445: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
3439:
3440: --
3441: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
3442: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
3443: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
3444: nvl(p_competence_type,hr_api.g_varchar2) OR
3445: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
3446: nvl(p_effective_date_from,hr_api.g_date) OR
3447: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>
3441: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
3442: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
3443: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
3444: nvl(p_competence_type,hr_api.g_varchar2) OR
3445: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
3446: nvl(p_effective_date_from,hr_api.g_date) OR
3447: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>
3448: nvl(p_effective_date_to,hr_api.g_date) OR
3449: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>
3443: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
3444: nvl(p_competence_type,hr_api.g_varchar2) OR
3445: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
3446: nvl(p_effective_date_from,hr_api.g_date) OR
3447: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>
3448: nvl(p_effective_date_to,hr_api.g_date) OR
3449: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>
3450: nvl(p_high_proficiency_level_id,hr_api.g_number) OR
3451: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>
3445: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
3446: nvl(p_effective_date_from,hr_api.g_date) OR
3447: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>
3448: nvl(p_effective_date_to,hr_api.g_date) OR
3449: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>
3450: nvl(p_high_proficiency_level_id,hr_api.g_number) OR
3451: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>
3452: nvl(p_mandatory,hr_api.g_varchar2) OR
3453: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>
3447: nvl(per_cel_shd.g_old_rec.effective_date_to,hr_api.g_date) <>
3448: nvl(p_effective_date_to,hr_api.g_date) OR
3449: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>
3450: nvl(p_high_proficiency_level_id,hr_api.g_number) OR
3451: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>
3452: nvl(p_mandatory,hr_api.g_varchar2) OR
3453: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>
3454: nvl(p_normal_elapse_duration,hr_api.g_number) OR
3455: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
3449: nvl(per_cel_shd.g_old_rec.high_proficiency_level_id,hr_api.g_number) <>
3450: nvl(p_high_proficiency_level_id,hr_api.g_number) OR
3451: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>
3452: nvl(p_mandatory,hr_api.g_varchar2) OR
3453: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>
3454: nvl(p_normal_elapse_duration,hr_api.g_number) OR
3455: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
3456: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR
3457: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>
3451: nvl(per_cel_shd.g_old_rec.mandatory,hr_api.g_varchar2) <>
3452: nvl(p_mandatory,hr_api.g_varchar2) OR
3453: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>
3454: nvl(p_normal_elapse_duration,hr_api.g_number) OR
3455: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
3456: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR
3457: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>
3458: nvl(p_sequence_number,hr_api.g_number) OR
3459: nvl(per_cel_shd.g_old_rec.certification_date,hr_api.g_date) <>
3453: nvl(per_cel_shd.g_old_rec.normal_elapse_duration,hr_api.g_number) <>
3454: nvl(p_normal_elapse_duration,hr_api.g_number) OR
3455: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
3456: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR
3457: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>
3458: nvl(p_sequence_number,hr_api.g_number) OR
3459: nvl(per_cel_shd.g_old_rec.certification_date,hr_api.g_date) <>
3460: nvl(p_certification_date,hr_api.g_date) OR
3461: nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,
3455: nvl(per_cel_shd.g_old_rec.normal_elapse_duration_unit,hr_api.g_varchar2)
3456: <> nvl(p_normal_elapse_duration_unit,hr_api.g_varchar2) OR
3457: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>
3458: nvl(p_sequence_number,hr_api.g_number) OR
3459: nvl(per_cel_shd.g_old_rec.certification_date,hr_api.g_date) <>
3460: nvl(p_certification_date,hr_api.g_date) OR
3461: nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,
3462: hr_api.g_varchar2) <>
3463: nvl(p_source_of_proficiency_level,hr_api.g_varchar2) OR
3457: nvl(per_cel_shd.g_old_rec.sequence_number,hr_api.g_number) <>
3458: nvl(p_sequence_number,hr_api.g_number) OR
3459: nvl(per_cel_shd.g_old_rec.certification_date,hr_api.g_date) <>
3460: nvl(p_certification_date,hr_api.g_date) OR
3461: nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,
3462: hr_api.g_varchar2) <>
3463: nvl(p_source_of_proficiency_level,hr_api.g_varchar2) OR
3464: nvl(per_cel_shd.g_old_rec.certification_method,hr_api.g_varchar2) <>
3465: nvl(p_certification_method,hr_api.g_varchar2) OR
3460: nvl(p_certification_date,hr_api.g_date) OR
3461: nvl(per_cel_shd.g_old_rec.source_of_proficiency_level,
3462: hr_api.g_varchar2) <>
3463: nvl(p_source_of_proficiency_level,hr_api.g_varchar2) OR
3464: nvl(per_cel_shd.g_old_rec.certification_method,hr_api.g_varchar2) <>
3465: nvl(p_certification_method,hr_api.g_varchar2) OR
3466: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>
3467: nvl(p_next_certification_date,hr_api.g_date)OR
3468: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>
3462: hr_api.g_varchar2) <>
3463: nvl(p_source_of_proficiency_level,hr_api.g_varchar2) OR
3464: nvl(per_cel_shd.g_old_rec.certification_method,hr_api.g_varchar2) <>
3465: nvl(p_certification_method,hr_api.g_varchar2) OR
3466: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>
3467: nvl(p_next_certification_date,hr_api.g_date)OR
3468: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>
3469: nvl(p_proficiency_level_id,hr_api.g_number) OR
3470: nvl(per_cel_shd.g_old_rec.line_score,hr_api.g_number) <>
3464: nvl(per_cel_shd.g_old_rec.certification_method,hr_api.g_varchar2) <>
3465: nvl(p_certification_method,hr_api.g_varchar2) OR
3466: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>
3467: nvl(p_next_certification_date,hr_api.g_date)OR
3468: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>
3469: nvl(p_proficiency_level_id,hr_api.g_number) OR
3470: nvl(per_cel_shd.g_old_rec.line_score,hr_api.g_number) <>
3471: nvl(p_line_score,hr_api.g_number) OR
3472: nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number) <>
3466: nvl(per_cel_shd.g_old_rec.next_certification_date,hr_api.g_date) <>
3467: nvl(p_next_certification_date,hr_api.g_date)OR
3468: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>
3469: nvl(p_proficiency_level_id,hr_api.g_number) OR
3470: nvl(per_cel_shd.g_old_rec.line_score,hr_api.g_number) <>
3471: nvl(p_line_score,hr_api.g_number) OR
3472: nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number) <>
3473: nvl(p_qualification_type_id,hr_api.g_number))
3474: OR NOT l_api_updating) then
3468: nvl(per_cel_shd.g_old_rec.proficiency_level_id,hr_api.g_number) <>
3469: nvl(p_proficiency_level_id,hr_api.g_number) OR
3470: nvl(per_cel_shd.g_old_rec.line_score,hr_api.g_number) <>
3471: nvl(p_line_score,hr_api.g_number) OR
3472: nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number) <>
3473: nvl(p_qualification_type_id,hr_api.g_number))
3474: OR NOT l_api_updating) then
3475: hr_utility.set_location(l_proc, 6);
3476: --
4107: );
4108: -- mandatory parameter
4109: --
4110: -- ngundura this check should not be there for global competence elements
4111: if per_cel_shd.g_bus_grp then
4112: hr_api.mandatory_arg_error
4113: (p_api_name => l_proc
4114: ,p_argument => 'business_group_id'
4115: ,p_argument_value => p_business_group_id
4122: -- b) The value for group_competence_type,competence_type,effective_date_from
4123: -- or any of the above in arguments has changed.
4124: --
4125: --
4126: l_api_updating := per_cel_shd.api_updating
4127: (p_competence_element_id => p_competence_element_id
4128: ,p_object_version_number => p_object_version_number);
4129: --
4130: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
4126: l_api_updating := per_cel_shd.api_updating
4127: (p_competence_element_id => p_competence_element_id
4128: ,p_object_version_number => p_object_version_number);
4129: --
4130: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
4131: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
4132: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
4133: nvl(p_competence_type,hr_api.g_varchar2) OR
4134: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
4128: ,p_object_version_number => p_object_version_number);
4129: --
4130: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
4131: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
4132: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
4133: nvl(p_competence_type,hr_api.g_varchar2) OR
4134: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
4135: nvl(p_effective_date_from,hr_api.g_date))
4136: OR NOT l_api_updating) then
4130: if (l_api_updating AND (nvl(per_cel_shd.g_old_rec.group_competence_type,
4131: hr_api.g_varchar2) <> nvl(p_group_competence_type,hr_api.g_varchar2)
4132: OR nvl(per_cel_shd.g_old_rec.competence_type,hr_api.g_varchar2) <>
4133: nvl(p_competence_type,hr_api.g_varchar2) OR
4134: nvl(per_cel_shd.g_old_rec.effective_date_from,hr_api.g_date) <>
4135: nvl(p_effective_date_from,hr_api.g_date))
4136: OR NOT l_api_updating) then
4137: hr_utility.set_location(l_proc, 6);
4138: --
4391: -- Only proceed with validation if :
4392: -- a) The current g_old_rec is current and
4393: -- b) The value for competence_id or qualification_type_id have changed
4394: --
4395: l_api_updating := per_cel_shd.api_updating
4396: (p_competence_element_id => p_competence_element_id
4397: ,p_object_version_number => p_object_version_number);
4398: --
4399: if (l_api_updating
4396: (p_competence_element_id => p_competence_element_id
4397: ,p_object_version_number => p_object_version_number);
4398: --
4399: if (l_api_updating
4400: and nvl(per_cel_shd.g_old_rec.competence_id,
4401: hr_api.g_number) = nvl(p_competence_id, hr_api.g_number)
4402: and nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number)
4403: = nvl(p_qualification_type_id, hr_api.g_number)
4404: ) then
4398: --
4399: if (l_api_updating
4400: and nvl(per_cel_shd.g_old_rec.competence_id,
4401: hr_api.g_number) = nvl(p_competence_id, hr_api.g_number)
4402: and nvl(per_cel_shd.g_old_rec.qualification_type_id,hr_api.g_number)
4403: = nvl(p_qualification_type_id, hr_api.g_number)
4404: ) then
4405: hr_utility.set_location('Leaving.... ' || l_proc,20);
4406: return;
4671: -- Access Status:
4672: -- Internal Row Handler Use Only.
4673: --
4674: procedure chk_df
4675: (p_rec in per_cel_shd.g_rec_type) is
4676: --
4677: l_proc varchar2(72) := g_package||'chk_df';
4678: --
4679: begin
4679: begin
4680: hr_utility.set_location('Entering:'||l_proc, 10);
4681: --
4682: if ((p_rec.valid_grade_id is not null) and (
4683: nvl(per_cel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
4684: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
4685: nvl(per_cel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
4686: nvl(p_rec.attribute1, hr_api.g_varchar2) or
4687: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
4681: --
4682: if ((p_rec.valid_grade_id is not null) and (
4683: nvl(per_cel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
4684: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
4685: nvl(per_cel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
4686: nvl(p_rec.attribute1, hr_api.g_varchar2) or
4687: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
4688: nvl(p_rec.attribute2, hr_api.g_varchar2) or
4689: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
4683: nvl(per_cel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
4684: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
4685: nvl(per_cel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
4686: nvl(p_rec.attribute1, hr_api.g_varchar2) or
4687: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
4688: nvl(p_rec.attribute2, hr_api.g_varchar2) or
4689: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
4690: nvl(p_rec.attribute3, hr_api.g_varchar2) or
4691: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
4685: nvl(per_cel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
4686: nvl(p_rec.attribute1, hr_api.g_varchar2) or
4687: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
4688: nvl(p_rec.attribute2, hr_api.g_varchar2) or
4689: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
4690: nvl(p_rec.attribute3, hr_api.g_varchar2) or
4691: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
4692: nvl(p_rec.attribute4, hr_api.g_varchar2) or
4693: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
4687: nvl(per_cel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
4688: nvl(p_rec.attribute2, hr_api.g_varchar2) or
4689: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
4690: nvl(p_rec.attribute3, hr_api.g_varchar2) or
4691: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
4692: nvl(p_rec.attribute4, hr_api.g_varchar2) or
4693: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
4694: nvl(p_rec.attribute5, hr_api.g_varchar2) or
4695: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
4689: nvl(per_cel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
4690: nvl(p_rec.attribute3, hr_api.g_varchar2) or
4691: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
4692: nvl(p_rec.attribute4, hr_api.g_varchar2) or
4693: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
4694: nvl(p_rec.attribute5, hr_api.g_varchar2) or
4695: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
4696: nvl(p_rec.attribute6, hr_api.g_varchar2) or
4697: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
4691: nvl(per_cel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
4692: nvl(p_rec.attribute4, hr_api.g_varchar2) or
4693: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
4694: nvl(p_rec.attribute5, hr_api.g_varchar2) or
4695: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
4696: nvl(p_rec.attribute6, hr_api.g_varchar2) or
4697: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
4698: nvl(p_rec.attribute7, hr_api.g_varchar2) or
4699: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
4693: nvl(per_cel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
4694: nvl(p_rec.attribute5, hr_api.g_varchar2) or
4695: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
4696: nvl(p_rec.attribute6, hr_api.g_varchar2) or
4697: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
4698: nvl(p_rec.attribute7, hr_api.g_varchar2) or
4699: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
4700: nvl(p_rec.attribute8, hr_api.g_varchar2) or
4701: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
4695: nvl(per_cel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
4696: nvl(p_rec.attribute6, hr_api.g_varchar2) or
4697: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
4698: nvl(p_rec.attribute7, hr_api.g_varchar2) or
4699: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
4700: nvl(p_rec.attribute8, hr_api.g_varchar2) or
4701: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
4702: nvl(p_rec.attribute9, hr_api.g_varchar2) or
4703: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
4697: nvl(per_cel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
4698: nvl(p_rec.attribute7, hr_api.g_varchar2) or
4699: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
4700: nvl(p_rec.attribute8, hr_api.g_varchar2) or
4701: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
4702: nvl(p_rec.attribute9, hr_api.g_varchar2) or
4703: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
4704: nvl(p_rec.attribute10, hr_api.g_varchar2) or
4705: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
4699: nvl(per_cel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
4700: nvl(p_rec.attribute8, hr_api.g_varchar2) or
4701: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
4702: nvl(p_rec.attribute9, hr_api.g_varchar2) or
4703: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
4704: nvl(p_rec.attribute10, hr_api.g_varchar2) or
4705: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
4706: nvl(p_rec.attribute11, hr_api.g_varchar2) or
4707: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
4701: nvl(per_cel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
4702: nvl(p_rec.attribute9, hr_api.g_varchar2) or
4703: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
4704: nvl(p_rec.attribute10, hr_api.g_varchar2) or
4705: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
4706: nvl(p_rec.attribute11, hr_api.g_varchar2) or
4707: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
4708: nvl(p_rec.attribute12, hr_api.g_varchar2) or
4709: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
4703: nvl(per_cel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
4704: nvl(p_rec.attribute10, hr_api.g_varchar2) or
4705: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
4706: nvl(p_rec.attribute11, hr_api.g_varchar2) or
4707: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
4708: nvl(p_rec.attribute12, hr_api.g_varchar2) or
4709: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
4710: nvl(p_rec.attribute13, hr_api.g_varchar2) or
4711: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
4705: nvl(per_cel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
4706: nvl(p_rec.attribute11, hr_api.g_varchar2) or
4707: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
4708: nvl(p_rec.attribute12, hr_api.g_varchar2) or
4709: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
4710: nvl(p_rec.attribute13, hr_api.g_varchar2) or
4711: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
4712: nvl(p_rec.attribute14, hr_api.g_varchar2) or
4713: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
4707: nvl(per_cel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
4708: nvl(p_rec.attribute12, hr_api.g_varchar2) or
4709: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
4710: nvl(p_rec.attribute13, hr_api.g_varchar2) or
4711: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
4712: nvl(p_rec.attribute14, hr_api.g_varchar2) or
4713: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
4714: nvl(p_rec.attribute15, hr_api.g_varchar2) or
4715: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
4709: nvl(per_cel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
4710: nvl(p_rec.attribute13, hr_api.g_varchar2) or
4711: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
4712: nvl(p_rec.attribute14, hr_api.g_varchar2) or
4713: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
4714: nvl(p_rec.attribute15, hr_api.g_varchar2) or
4715: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
4716: nvl(p_rec.attribute16, hr_api.g_varchar2) or
4717: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
4711: nvl(per_cel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
4712: nvl(p_rec.attribute14, hr_api.g_varchar2) or
4713: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
4714: nvl(p_rec.attribute15, hr_api.g_varchar2) or
4715: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
4716: nvl(p_rec.attribute16, hr_api.g_varchar2) or
4717: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
4718: nvl(p_rec.attribute17, hr_api.g_varchar2) or
4719: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
4713: nvl(per_cel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
4714: nvl(p_rec.attribute15, hr_api.g_varchar2) or
4715: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
4716: nvl(p_rec.attribute16, hr_api.g_varchar2) or
4717: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
4718: nvl(p_rec.attribute17, hr_api.g_varchar2) or
4719: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
4720: nvl(p_rec.attribute18, hr_api.g_varchar2) or
4721: nvl(per_cel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
4715: nvl(per_cel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
4716: nvl(p_rec.attribute16, hr_api.g_varchar2) or
4717: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
4718: nvl(p_rec.attribute17, hr_api.g_varchar2) or
4719: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
4720: nvl(p_rec.attribute18, hr_api.g_varchar2) or
4721: nvl(per_cel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
4722: nvl(p_rec.attribute19, hr_api.g_varchar2) or
4723: nvl(per_cel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
4717: nvl(per_cel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
4718: nvl(p_rec.attribute17, hr_api.g_varchar2) or
4719: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
4720: nvl(p_rec.attribute18, hr_api.g_varchar2) or
4721: nvl(per_cel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
4722: nvl(p_rec.attribute19, hr_api.g_varchar2) or
4723: nvl(per_cel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
4724: nvl(p_rec.attribute20, hr_api.g_varchar2)))
4725: or
4719: nvl(per_cel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
4720: nvl(p_rec.attribute18, hr_api.g_varchar2) or
4721: nvl(per_cel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
4722: nvl(p_rec.attribute19, hr_api.g_varchar2) or
4723: nvl(per_cel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
4724: nvl(p_rec.attribute20, hr_api.g_varchar2)))
4725: or
4726: (p_rec.valid_grade_id is null) then
4727: --
4809: -- Internal Row Handler Use Only.
4810: --
4811: -- ----------------------------------------------------------------------------
4812: procedure chk_ddf
4813: (p_rec in per_cel_shd.g_rec_type
4814: ) is
4815: --
4816: l_proc varchar2(72) := g_package || 'chk_ddf';
4817: --
4818: begin
4819: hr_utility.set_location('Entering:'||l_proc,10);
4820: --
4821: if ((p_rec.competence_element_id is not null) and (
4822: nvl(per_cel_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
4823: nvl(p_rec.information_category, hr_api.g_varchar2) or
4824: nvl(per_cel_shd.g_old_rec.information1, hr_api.g_varchar2) <>
4825: nvl(p_rec.information1, hr_api.g_varchar2) or
4826: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>
4820: --
4821: if ((p_rec.competence_element_id is not null) and (
4822: nvl(per_cel_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
4823: nvl(p_rec.information_category, hr_api.g_varchar2) or
4824: nvl(per_cel_shd.g_old_rec.information1, hr_api.g_varchar2) <>
4825: nvl(p_rec.information1, hr_api.g_varchar2) or
4826: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>
4827: nvl(p_rec.information2, hr_api.g_varchar2) or
4828: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>
4822: nvl(per_cel_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
4823: nvl(p_rec.information_category, hr_api.g_varchar2) or
4824: nvl(per_cel_shd.g_old_rec.information1, hr_api.g_varchar2) <>
4825: nvl(p_rec.information1, hr_api.g_varchar2) or
4826: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>
4827: nvl(p_rec.information2, hr_api.g_varchar2) or
4828: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>
4829: nvl(p_rec.information3, hr_api.g_varchar2) or
4830: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>
4824: nvl(per_cel_shd.g_old_rec.information1, hr_api.g_varchar2) <>
4825: nvl(p_rec.information1, hr_api.g_varchar2) or
4826: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>
4827: nvl(p_rec.information2, hr_api.g_varchar2) or
4828: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>
4829: nvl(p_rec.information3, hr_api.g_varchar2) or
4830: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>
4831: nvl(p_rec.information4, hr_api.g_varchar2) or
4832: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>
4826: nvl(per_cel_shd.g_old_rec.information2, hr_api.g_varchar2) <>
4827: nvl(p_rec.information2, hr_api.g_varchar2) or
4828: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>
4829: nvl(p_rec.information3, hr_api.g_varchar2) or
4830: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>
4831: nvl(p_rec.information4, hr_api.g_varchar2) or
4832: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>
4833: nvl(p_rec.information5, hr_api.g_varchar2) or
4834: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>
4828: nvl(per_cel_shd.g_old_rec.information3, hr_api.g_varchar2) <>
4829: nvl(p_rec.information3, hr_api.g_varchar2) or
4830: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>
4831: nvl(p_rec.information4, hr_api.g_varchar2) or
4832: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>
4833: nvl(p_rec.information5, hr_api.g_varchar2) or
4834: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>
4835: nvl(p_rec.information6, hr_api.g_varchar2) or
4836: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>
4830: nvl(per_cel_shd.g_old_rec.information4, hr_api.g_varchar2) <>
4831: nvl(p_rec.information4, hr_api.g_varchar2) or
4832: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>
4833: nvl(p_rec.information5, hr_api.g_varchar2) or
4834: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>
4835: nvl(p_rec.information6, hr_api.g_varchar2) or
4836: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>
4837: nvl(p_rec.information7, hr_api.g_varchar2) or
4838: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>
4832: nvl(per_cel_shd.g_old_rec.information5, hr_api.g_varchar2) <>
4833: nvl(p_rec.information5, hr_api.g_varchar2) or
4834: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>
4835: nvl(p_rec.information6, hr_api.g_varchar2) or
4836: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>
4837: nvl(p_rec.information7, hr_api.g_varchar2) or
4838: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>
4839: nvl(p_rec.information8, hr_api.g_varchar2) or
4840: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>
4834: nvl(per_cel_shd.g_old_rec.information6, hr_api.g_varchar2) <>
4835: nvl(p_rec.information6, hr_api.g_varchar2) or
4836: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>
4837: nvl(p_rec.information7, hr_api.g_varchar2) or
4838: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>
4839: nvl(p_rec.information8, hr_api.g_varchar2) or
4840: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>
4841: nvl(p_rec.information9, hr_api.g_varchar2) or
4842: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>
4836: nvl(per_cel_shd.g_old_rec.information7, hr_api.g_varchar2) <>
4837: nvl(p_rec.information7, hr_api.g_varchar2) or
4838: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>
4839: nvl(p_rec.information8, hr_api.g_varchar2) or
4840: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>
4841: nvl(p_rec.information9, hr_api.g_varchar2) or
4842: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>
4843: nvl(p_rec.information10, hr_api.g_varchar2) or
4844: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>
4838: nvl(per_cel_shd.g_old_rec.information8, hr_api.g_varchar2) <>
4839: nvl(p_rec.information8, hr_api.g_varchar2) or
4840: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>
4841: nvl(p_rec.information9, hr_api.g_varchar2) or
4842: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>
4843: nvl(p_rec.information10, hr_api.g_varchar2) or
4844: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>
4845: nvl(p_rec.information11, hr_api.g_varchar2) or
4846: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>
4840: nvl(per_cel_shd.g_old_rec.information9, hr_api.g_varchar2) <>
4841: nvl(p_rec.information9, hr_api.g_varchar2) or
4842: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>
4843: nvl(p_rec.information10, hr_api.g_varchar2) or
4844: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>
4845: nvl(p_rec.information11, hr_api.g_varchar2) or
4846: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>
4847: nvl(p_rec.information13, hr_api.g_varchar2) or
4848: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>
4842: nvl(per_cel_shd.g_old_rec.information10, hr_api.g_varchar2) <>
4843: nvl(p_rec.information10, hr_api.g_varchar2) or
4844: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>
4845: nvl(p_rec.information11, hr_api.g_varchar2) or
4846: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>
4847: nvl(p_rec.information13, hr_api.g_varchar2) or
4848: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>
4849: nvl(p_rec.information14, hr_api.g_varchar2) or
4850: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>
4844: nvl(per_cel_shd.g_old_rec.information11, hr_api.g_varchar2) <>
4845: nvl(p_rec.information11, hr_api.g_varchar2) or
4846: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>
4847: nvl(p_rec.information13, hr_api.g_varchar2) or
4848: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>
4849: nvl(p_rec.information14, hr_api.g_varchar2) or
4850: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>
4851: nvl(p_rec.information15, hr_api.g_varchar2) or
4852: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>
4846: nvl(per_cel_shd.g_old_rec.information13, hr_api.g_varchar2) <>
4847: nvl(p_rec.information13, hr_api.g_varchar2) or
4848: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>
4849: nvl(p_rec.information14, hr_api.g_varchar2) or
4850: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>
4851: nvl(p_rec.information15, hr_api.g_varchar2) or
4852: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>
4853: nvl(p_rec.information16, hr_api.g_varchar2) or
4854: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>
4848: nvl(per_cel_shd.g_old_rec.information14, hr_api.g_varchar2) <>
4849: nvl(p_rec.information14, hr_api.g_varchar2) or
4850: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>
4851: nvl(p_rec.information15, hr_api.g_varchar2) or
4852: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>
4853: nvl(p_rec.information16, hr_api.g_varchar2) or
4854: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>
4855: nvl(p_rec.information17, hr_api.g_varchar2) or
4856: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>
4850: nvl(per_cel_shd.g_old_rec.information15, hr_api.g_varchar2) <>
4851: nvl(p_rec.information15, hr_api.g_varchar2) or
4852: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>
4853: nvl(p_rec.information16, hr_api.g_varchar2) or
4854: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>
4855: nvl(p_rec.information17, hr_api.g_varchar2) or
4856: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>
4857: nvl(p_rec.information18, hr_api.g_varchar2) or
4858: nvl(per_cel_shd.g_old_rec.information19, hr_api.g_varchar2) <>
4852: nvl(per_cel_shd.g_old_rec.information16, hr_api.g_varchar2) <>
4853: nvl(p_rec.information16, hr_api.g_varchar2) or
4854: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>
4855: nvl(p_rec.information17, hr_api.g_varchar2) or
4856: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>
4857: nvl(p_rec.information18, hr_api.g_varchar2) or
4858: nvl(per_cel_shd.g_old_rec.information19, hr_api.g_varchar2) <>
4859: nvl(p_rec.information19, hr_api.g_varchar2) or
4860: nvl(per_cel_shd.g_old_rec.information20, hr_api.g_varchar2) <>
4854: nvl(per_cel_shd.g_old_rec.information17, hr_api.g_varchar2) <>
4855: nvl(p_rec.information17, hr_api.g_varchar2) or
4856: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>
4857: nvl(p_rec.information18, hr_api.g_varchar2) or
4858: nvl(per_cel_shd.g_old_rec.information19, hr_api.g_varchar2) <>
4859: nvl(p_rec.information19, hr_api.g_varchar2) or
4860: nvl(per_cel_shd.g_old_rec.information20, hr_api.g_varchar2) <>
4861: nvl(p_rec.information20, hr_api.g_varchar2)))
4862: or (p_rec.competence_element_id is not null) then
4856: nvl(per_cel_shd.g_old_rec.information18, hr_api.g_varchar2) <>
4857: nvl(p_rec.information18, hr_api.g_varchar2) or
4858: nvl(per_cel_shd.g_old_rec.information19, hr_api.g_varchar2) <>
4859: nvl(p_rec.information19, hr_api.g_varchar2) or
4860: nvl(per_cel_shd.g_old_rec.information20, hr_api.g_varchar2) <>
4861: nvl(p_rec.information20, hr_api.g_varchar2)))
4862: or (p_rec.competence_element_id is not null) then
4863: --
4864: -- Only execute the validation if absolutely necessary:
4918: --
4919: -- ----------------------------------------------------------------------------
4920: -- |---------------------------< insert_validate >----------------------------|
4921: -- ----------------------------------------------------------------------------
4922: Procedure insert_validate(p_rec in out nocopy per_cel_shd.g_rec_type,
4923: p_effective_date in Date) is
4924: --
4925: l_proc varchar2(72) := g_package||'insert_validate';
4926: --
4942: if ( p_rec.type not in ('PROJECT_ROLE','OPEN_ASSIGNMENT','QUALIFICATION','ASSESSMENT_GROUP','ASSESSMENT_COMPETENCE')) then
4943: -- Validate Bus Grp
4944: hr_api.validate_bus_grp_id(
4945: p_business_group_id => p_rec.business_group_id
4946: ,p_associated_column1 => per_cel_shd.g_tab_nam ||
4947: '.BUSINESS_GROUP_ID'
4948: );
4949: --
4950: -- After validating the set of important attributes,
4952: -- one error has been found then abort further validation.
4953: --
4954: hr_multi_message.end_validation_set;
4955: --
4956: per_cel_shd.g_bus_grp := true;
4957: else
4958: per_cel_shd.g_bus_grp := false;
4959: end if;
4960: else
4954: hr_multi_message.end_validation_set;
4955: --
4956: per_cel_shd.g_bus_grp := true;
4957: else
4958: per_cel_shd.g_bus_grp := false;
4959: end if;
4960: else
4961: per_cel_shd.g_bus_grp := false;
4962: end if;
4957: else
4958: per_cel_shd.g_bus_grp := false;
4959: end if;
4960: else
4961: per_cel_shd.g_bus_grp := false;
4962: end if;
4963: --
4964: -- Business Rule Mapping
4965: -- =====================
5316: --
5317: -- ----------------------------------------------------------------------------
5318: -- |---------------------------< update_validate >----------------------------|
5319: -- ----------------------------------------------------------------------------
5320: Procedure update_validate(p_rec in per_cel_shd.g_rec_type,
5321: p_effective_date in Date) is
5322: --
5323: l_proc varchar2(72) := g_package||'update_validate';
5324: --
5338: --
5339: if ( p_rec.type not in ('PROJECT_ROLE','OPEN_ASSIGNMENT','QUALIFICATION','ASSESSMENT_GROUP','ASSESSMENT_COMPETENCE')) then
5340: hr_api.validate_bus_grp_id(
5341: p_business_group_id => p_rec.business_group_id
5342: ,p_associated_column1 => per_cel_shd.g_tab_nam ||
5343: '.BUSINESS_GROUP_ID'
5344: );
5345: --
5346: -- After validating the set of important attributes,
5348: -- one error has been found then abort further validation.
5349: --
5350: hr_multi_message.end_validation_set;
5351: --
5352: per_cel_shd.g_bus_grp := true;
5353: else
5354: per_cel_shd.g_bus_grp := false;
5355: end if;
5356: else
5350: hr_multi_message.end_validation_set;
5351: --
5352: per_cel_shd.g_bus_grp := true;
5353: else
5354: per_cel_shd.g_bus_grp := false;
5355: end if;
5356: else
5357: per_cel_shd.g_bus_grp := false;
5358: end if;
5353: else
5354: per_cel_shd.g_bus_grp := false;
5355: end if;
5356: else
5357: per_cel_shd.g_bus_grp := false;
5358: end if;
5359: --
5360: --
5361: per_cel_bus.check_non_updateable_args
5697: --
5698: -- ----------------------------------------------------------------------------
5699: -- |---------------------------< delete_validate >----------------------------|
5700: -- ----------------------------------------------------------------------------
5701: Procedure delete_validate(p_rec in per_cel_shd.g_rec_type) is
5702: --
5703: l_proc varchar2(72) := g_package||'delete_validate';
5704: --
5705: Begin
5710: -- =====================
5711: -- CHK_COMP_ELEMENT_DELETE
5712: chk_comp_element_delete
5713:
5714: (p_competence_element_id => per_cel_shd.g_old_rec.competence_element_id
5715: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
5716: ,p_parent_competence_element_id
5717: => per_cel_shd.g_old_rec.parent_competence_element_id
5718: ,p_type => per_cel_shd.g_old_rec.type
5711: -- CHK_COMP_ELEMENT_DELETE
5712: chk_comp_element_delete
5713:
5714: (p_competence_element_id => per_cel_shd.g_old_rec.competence_element_id
5715: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
5716: ,p_parent_competence_element_id
5717: => per_cel_shd.g_old_rec.parent_competence_element_id
5718: ,p_type => per_cel_shd.g_old_rec.type
5719: ,p_competence_type => per_cel_shd.g_old_rec.competence_type
5713:
5714: (p_competence_element_id => per_cel_shd.g_old_rec.competence_element_id
5715: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
5716: ,p_parent_competence_element_id
5717: => per_cel_shd.g_old_rec.parent_competence_element_id
5718: ,p_type => per_cel_shd.g_old_rec.type
5719: ,p_competence_type => per_cel_shd.g_old_rec.competence_type
5720: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
5721: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
5714: (p_competence_element_id => per_cel_shd.g_old_rec.competence_element_id
5715: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
5716: ,p_parent_competence_element_id
5717: => per_cel_shd.g_old_rec.parent_competence_element_id
5718: ,p_type => per_cel_shd.g_old_rec.type
5719: ,p_competence_type => per_cel_shd.g_old_rec.competence_type
5720: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
5721: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
5722: ,p_competence_id => per_cel_shd.g_old_rec.competence_id
5715: ,p_business_group_id => per_cel_shd.g_old_rec.business_group_id
5716: ,p_parent_competence_element_id
5717: => per_cel_shd.g_old_rec.parent_competence_element_id
5718: ,p_type => per_cel_shd.g_old_rec.type
5719: ,p_competence_type => per_cel_shd.g_old_rec.competence_type
5720: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
5721: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
5722: ,p_competence_id => per_cel_shd.g_old_rec.competence_id
5723: ,p_group_competence_type => per_cel_shd.g_old_rec.group_competence_type
5716: ,p_parent_competence_element_id
5717: => per_cel_shd.g_old_rec.parent_competence_element_id
5718: ,p_type => per_cel_shd.g_old_rec.type
5719: ,p_competence_type => per_cel_shd.g_old_rec.competence_type
5720: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
5721: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
5722: ,p_competence_id => per_cel_shd.g_old_rec.competence_id
5723: ,p_group_competence_type => per_cel_shd.g_old_rec.group_competence_type
5724: );
5717: => per_cel_shd.g_old_rec.parent_competence_element_id
5718: ,p_type => per_cel_shd.g_old_rec.type
5719: ,p_competence_type => per_cel_shd.g_old_rec.competence_type
5720: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
5721: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
5722: ,p_competence_id => per_cel_shd.g_old_rec.competence_id
5723: ,p_group_competence_type => per_cel_shd.g_old_rec.group_competence_type
5724: );
5725: --
5718: ,p_type => per_cel_shd.g_old_rec.type
5719: ,p_competence_type => per_cel_shd.g_old_rec.competence_type
5720: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
5721: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
5722: ,p_competence_id => per_cel_shd.g_old_rec.competence_id
5723: ,p_group_competence_type => per_cel_shd.g_old_rec.group_competence_type
5724: );
5725: --
5726:
5719: ,p_competence_type => per_cel_shd.g_old_rec.competence_type
5720: ,p_assessment_id => per_cel_shd.g_old_rec.assessment_id
5721: ,p_assessment_type_id => per_cel_shd.g_old_rec.assessment_type_id
5722: ,p_competence_id => per_cel_shd.g_old_rec.competence_id
5723: ,p_group_competence_type => per_cel_shd.g_old_rec.group_competence_type
5724: );
5725: --
5726:
5727: hr_utility.set_location(' Leaving:'||l_proc, 10);