42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --
44: -- Ensure that all the mandatory parameter are not null
45: --
46: hr_api.mandatory_arg_error
47: (p_api_name => l_proc
48: ,p_argument => 'checklist_item_id'
49: ,p_argument_value => p_checklist_item_id
50: );
65: close csr_sec_grp;
66: --
67: -- Set the security_group_id in CLIENT_INFO
68: --
69: hr_api.set_security_group_id
70: (p_security_group_id => l_security_group_id
71: );
72: --
73: hr_utility.set_location(' Leaving:'|| l_proc, 20);
102: hr_utility.set_location('Entering:'|| l_proc, 10);
103: --
104: -- Ensure that all the mandatory parameter are not null
105: --
106: hr_api.mandatory_arg_error
107: (p_api_name => l_proc
108: ,p_argument => 'checklist_item_id'
109: ,p_argument_value => p_checklist_item_id
110: );
108: ,p_argument => 'checklist_item_id'
109: ,p_argument_value => p_checklist_item_id
110: );
111: --
112: if ( nvl(per_chk_bus.g_checklist_item_id, hr_api.g_number)
113: = p_checklist_item_id) then
114: --
115: -- The legislation code has already been found with a previous
116: -- call to this function. Just return the value in the global
197: end if;
198: --
199: hr_utility.set_location(l_proc, 6);
200: --
201: if nvl(p_rec.checklist_item_id,hr_api.g_number)
202: <> nvl(per_chk_shd.g_old_rec.checklist_item_id,hr_api.g_number) then
203: l_argument := 'checklist_item_id';
204: raise l_error;
205: end if;
198: --
199: hr_utility.set_location(l_proc, 6);
200: --
201: if nvl(p_rec.checklist_item_id,hr_api.g_number)
202: <> nvl(per_chk_shd.g_old_rec.checklist_item_id,hr_api.g_number) then
203: l_argument := 'checklist_item_id';
204: raise l_error;
205: end if;
206: hr_utility.set_location(l_proc, 7);
204: raise l_error;
205: end if;
206: hr_utility.set_location(l_proc, 7);
207: --
208: if nvl(p_rec.person_id,hr_api.g_number)
209: <> nvl(per_chk_shd.g_old_rec.person_id,hr_api.g_number) then
210: l_argument := 'person_id';
211: raise l_error;
212: end if;
205: end if;
206: hr_utility.set_location(l_proc, 7);
207: --
208: if nvl(p_rec.person_id,hr_api.g_number)
209: <> nvl(per_chk_shd.g_old_rec.person_id,hr_api.g_number) then
210: l_argument := 'person_id';
211: raise l_error;
212: end if;
213: hr_utility.set_location(l_proc, 8);
211: raise l_error;
212: end if;
213: hr_utility.set_location(l_proc, 8);
214: --
215: if nvl(p_rec.item_code,hr_api.g_varchar2)
216: <> nvl(per_chk_shd.g_old_rec.item_code,hr_api.g_varchar2) then
217: l_argument := 'item_code';
218: raise l_error;
219: end if;
212: end if;
213: hr_utility.set_location(l_proc, 8);
214: --
215: if nvl(p_rec.item_code,hr_api.g_varchar2)
216: <> nvl(per_chk_shd.g_old_rec.item_code,hr_api.g_varchar2) then
217: l_argument := 'item_code';
218: raise l_error;
219: end if;
220: hr_utility.set_location(l_proc, 9);
220: hr_utility.set_location(l_proc, 9);
221: --
222: exception
223: when l_error then
224: hr_api.argument_changed_error
225: (p_api_name => l_proc
226: ,p_argument => l_argument);
227: when others then
228: raise;
318: --
319: hr_utility.set_location('Entering:'||l_proc, 5);
320: --
321: if (p_checklist_item_id is not null and p_status is not null and
322: (nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
323: <> nvl(p_status,hr_api.g_varchar2)))
324: or ( p_checklist_item_id is null and p_status is not null)
325: then
326:
319: hr_utility.set_location('Entering:'||l_proc, 5);
320: --
321: if (p_checklist_item_id is not null and p_status is not null and
322: (nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)
323: <> nvl(p_status,hr_api.g_varchar2)))
324: or ( p_checklist_item_id is null and p_status is not null)
325: then
326:
327: IF hr_api.not_exists_in_hr_lookups( p_effective_date => p_effective_date,
323: <> nvl(p_status,hr_api.g_varchar2)))
324: or ( p_checklist_item_id is null and p_status is not null)
325: then
326:
327: IF hr_api.not_exists_in_hr_lookups( p_effective_date => p_effective_date,
328: p_lookup_type => 'CHECKLIST_STATUS',
329: p_lookup_code => p_status ) THEN
330: -- Error Message : Invalid checklist status
331: fnd_message.set_name('PER', 'HR_52781_CHK_INVALID_STATUS');
373: --
374: hr_utility.set_location('Entering:'||l_proc, 10);
375:
376: -- Checking to see if the item code is valid
377: IF hr_api.not_exists_in_hr_lookups( p_effective_date => p_effective_date,
378: p_lookup_type => 'CHECKLIST_ITEM',
379: p_lookup_code => p_item_code ) THEN
380: -- Error Message - Invalid Checklist value
381: fnd_message.set_name('PER', 'HR_52778_CHK_INVALID_ITEM');
485: --
486: --
487: If ( (p_rec.checklist_item_id is not null)
488: and
489: ( (nvl(per_chk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
491: nvl(per_chk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute1, hr_api.g_varchar2) or
493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
486: --
487: If ( (p_rec.checklist_item_id is not null)
488: and
489: ( (nvl(per_chk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
491: nvl(per_chk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute1, hr_api.g_varchar2) or
493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute2, hr_api.g_varchar2) or
487: If ( (p_rec.checklist_item_id is not null)
488: and
489: ( (nvl(per_chk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
491: nvl(per_chk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute1, hr_api.g_varchar2) or
493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute2, hr_api.g_varchar2) or
495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
488: and
489: ( (nvl(per_chk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
491: nvl(per_chk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute1, hr_api.g_varchar2) or
493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute2, hr_api.g_varchar2) or
495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute3, hr_api.g_varchar2) or
489: ( (nvl(per_chk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
491: nvl(per_chk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute1, hr_api.g_varchar2) or
493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute2, hr_api.g_varchar2) or
495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute3, hr_api.g_varchar2) or
497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
491: nvl(per_chk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute1, hr_api.g_varchar2) or
493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute2, hr_api.g_varchar2) or
495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute3, hr_api.g_varchar2) or
497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute4, hr_api.g_varchar2) or
491: nvl(per_chk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute1, hr_api.g_varchar2) or
493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute2, hr_api.g_varchar2) or
495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute3, hr_api.g_varchar2) or
497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute4, hr_api.g_varchar2) or
499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute1, hr_api.g_varchar2) or
493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute2, hr_api.g_varchar2) or
495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute3, hr_api.g_varchar2) or
497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute4, hr_api.g_varchar2) or
499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute5, hr_api.g_varchar2) or
493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute2, hr_api.g_varchar2) or
495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute3, hr_api.g_varchar2) or
497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute4, hr_api.g_varchar2) or
499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute5, hr_api.g_varchar2) or
501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute2, hr_api.g_varchar2) or
495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute3, hr_api.g_varchar2) or
497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute4, hr_api.g_varchar2) or
499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute5, hr_api.g_varchar2) or
501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute6, hr_api.g_varchar2) or
495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute3, hr_api.g_varchar2) or
497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute4, hr_api.g_varchar2) or
499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute5, hr_api.g_varchar2) or
501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute6, hr_api.g_varchar2) or
503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute3, hr_api.g_varchar2) or
497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute4, hr_api.g_varchar2) or
499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute5, hr_api.g_varchar2) or
501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute6, hr_api.g_varchar2) or
503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute7, hr_api.g_varchar2) or
497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute4, hr_api.g_varchar2) or
499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute5, hr_api.g_varchar2) or
501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute6, hr_api.g_varchar2) or
503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute7, hr_api.g_varchar2) or
505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute4, hr_api.g_varchar2) or
499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute5, hr_api.g_varchar2) or
501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute6, hr_api.g_varchar2) or
503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute7, hr_api.g_varchar2) or
505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
506: nvl(p_rec.attribute8, hr_api.g_varchar2) or
499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute5, hr_api.g_varchar2) or
501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute6, hr_api.g_varchar2) or
503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute7, hr_api.g_varchar2) or
505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
506: nvl(p_rec.attribute8, hr_api.g_varchar2) or
507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute5, hr_api.g_varchar2) or
501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute6, hr_api.g_varchar2) or
503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute7, hr_api.g_varchar2) or
505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
506: nvl(p_rec.attribute8, hr_api.g_varchar2) or
507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute9, hr_api.g_varchar2) or
501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute6, hr_api.g_varchar2) or
503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute7, hr_api.g_varchar2) or
505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
506: nvl(p_rec.attribute8, hr_api.g_varchar2) or
507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute9, hr_api.g_varchar2) or
509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute6, hr_api.g_varchar2) or
503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute7, hr_api.g_varchar2) or
505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
506: nvl(p_rec.attribute8, hr_api.g_varchar2) or
507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute9, hr_api.g_varchar2) or
509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute10, hr_api.g_varchar2) or
503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute7, hr_api.g_varchar2) or
505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
506: nvl(p_rec.attribute8, hr_api.g_varchar2) or
507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute9, hr_api.g_varchar2) or
509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute10, hr_api.g_varchar2) or
511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute7, hr_api.g_varchar2) or
505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
506: nvl(p_rec.attribute8, hr_api.g_varchar2) or
507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute9, hr_api.g_varchar2) or
509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute10, hr_api.g_varchar2) or
511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute11, hr_api.g_varchar2) or
505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
506: nvl(p_rec.attribute8, hr_api.g_varchar2) or
507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute9, hr_api.g_varchar2) or
509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute10, hr_api.g_varchar2) or
511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute11, hr_api.g_varchar2) or
513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
506: nvl(p_rec.attribute8, hr_api.g_varchar2) or
507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute9, hr_api.g_varchar2) or
509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute10, hr_api.g_varchar2) or
511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute11, hr_api.g_varchar2) or
513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute12, hr_api.g_varchar2) or
507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute9, hr_api.g_varchar2) or
509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute10, hr_api.g_varchar2) or
511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute11, hr_api.g_varchar2) or
513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute12, hr_api.g_varchar2) or
515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute9, hr_api.g_varchar2) or
509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute10, hr_api.g_varchar2) or
511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute11, hr_api.g_varchar2) or
513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute12, hr_api.g_varchar2) or
515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute13, hr_api.g_varchar2) or
509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute10, hr_api.g_varchar2) or
511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute11, hr_api.g_varchar2) or
513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute12, hr_api.g_varchar2) or
515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute13, hr_api.g_varchar2) or
517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute10, hr_api.g_varchar2) or
511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute11, hr_api.g_varchar2) or
513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute12, hr_api.g_varchar2) or
515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute13, hr_api.g_varchar2) or
517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute14, hr_api.g_varchar2) or
511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute11, hr_api.g_varchar2) or
513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute12, hr_api.g_varchar2) or
515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute13, hr_api.g_varchar2) or
517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute14, hr_api.g_varchar2) or
519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute11, hr_api.g_varchar2) or
513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute12, hr_api.g_varchar2) or
515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute13, hr_api.g_varchar2) or
517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute14, hr_api.g_varchar2) or
519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute15, hr_api.g_varchar2) or
513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute12, hr_api.g_varchar2) or
515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute13, hr_api.g_varchar2) or
517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute14, hr_api.g_varchar2) or
519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute15, hr_api.g_varchar2) or
521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute12, hr_api.g_varchar2) or
515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute13, hr_api.g_varchar2) or
517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute14, hr_api.g_varchar2) or
519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute15, hr_api.g_varchar2) or
521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute16, hr_api.g_varchar2) or
515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute13, hr_api.g_varchar2) or
517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute14, hr_api.g_varchar2) or
519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute15, hr_api.g_varchar2) or
521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute16, hr_api.g_varchar2) or
523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute13, hr_api.g_varchar2) or
517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute14, hr_api.g_varchar2) or
519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute15, hr_api.g_varchar2) or
521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute16, hr_api.g_varchar2) or
523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute17, hr_api.g_varchar2) or
517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute14, hr_api.g_varchar2) or
519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute15, hr_api.g_varchar2) or
521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute16, hr_api.g_varchar2) or
523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute17, hr_api.g_varchar2) or
525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute14, hr_api.g_varchar2) or
519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute15, hr_api.g_varchar2) or
521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute16, hr_api.g_varchar2) or
523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute17, hr_api.g_varchar2) or
525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute18, hr_api.g_varchar2) or
519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute15, hr_api.g_varchar2) or
521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute16, hr_api.g_varchar2) or
523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute17, hr_api.g_varchar2) or
525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute18, hr_api.g_varchar2) or
527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute15, hr_api.g_varchar2) or
521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute16, hr_api.g_varchar2) or
523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute17, hr_api.g_varchar2) or
525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute18, hr_api.g_varchar2) or
527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute19, hr_api.g_varchar2) or
521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute16, hr_api.g_varchar2) or
523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute17, hr_api.g_varchar2) or
525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute18, hr_api.g_varchar2) or
527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute19, hr_api.g_varchar2) or
529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute16, hr_api.g_varchar2) or
523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute17, hr_api.g_varchar2) or
525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute18, hr_api.g_varchar2) or
527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute19, hr_api.g_varchar2) or
529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute20, hr_api.g_varchar2) or
523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute17, hr_api.g_varchar2) or
525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute18, hr_api.g_varchar2) or
527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute19, hr_api.g_varchar2) or
529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute20, hr_api.g_varchar2) or
531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute17, hr_api.g_varchar2) or
525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute18, hr_api.g_varchar2) or
527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute19, hr_api.g_varchar2) or
529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute20, hr_api.g_varchar2) or
531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute21, hr_api.g_varchar2) or
525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute18, hr_api.g_varchar2) or
527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute19, hr_api.g_varchar2) or
529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute20, hr_api.g_varchar2) or
531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute21, hr_api.g_varchar2) or
533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute18, hr_api.g_varchar2) or
527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute19, hr_api.g_varchar2) or
529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute20, hr_api.g_varchar2) or
531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute21, hr_api.g_varchar2) or
533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute22, hr_api.g_varchar2) or
527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute19, hr_api.g_varchar2) or
529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute20, hr_api.g_varchar2) or
531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute21, hr_api.g_varchar2) or
533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute22, hr_api.g_varchar2) or
535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute19, hr_api.g_varchar2) or
529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute20, hr_api.g_varchar2) or
531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute21, hr_api.g_varchar2) or
533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute22, hr_api.g_varchar2) or
535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute23, hr_api.g_varchar2) or
529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute20, hr_api.g_varchar2) or
531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute21, hr_api.g_varchar2) or
533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute22, hr_api.g_varchar2) or
535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute23, hr_api.g_varchar2) or
537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute20, hr_api.g_varchar2) or
531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute21, hr_api.g_varchar2) or
533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute22, hr_api.g_varchar2) or
535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute23, hr_api.g_varchar2) or
537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute24, hr_api.g_varchar2) or
531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute21, hr_api.g_varchar2) or
533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute22, hr_api.g_varchar2) or
535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute23, hr_api.g_varchar2) or
537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute24, hr_api.g_varchar2) or
539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute21, hr_api.g_varchar2) or
533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute22, hr_api.g_varchar2) or
535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute23, hr_api.g_varchar2) or
537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute24, hr_api.g_varchar2) or
539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute25, hr_api.g_varchar2) or
533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute22, hr_api.g_varchar2) or
535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute23, hr_api.g_varchar2) or
537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute24, hr_api.g_varchar2) or
539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute25, hr_api.g_varchar2) or
541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute22, hr_api.g_varchar2) or
535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute23, hr_api.g_varchar2) or
537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute24, hr_api.g_varchar2) or
539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute25, hr_api.g_varchar2) or
541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute26, hr_api.g_varchar2) or
535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute23, hr_api.g_varchar2) or
537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute24, hr_api.g_varchar2) or
539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute25, hr_api.g_varchar2) or
541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute26, hr_api.g_varchar2) or
543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute23, hr_api.g_varchar2) or
537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute24, hr_api.g_varchar2) or
539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute25, hr_api.g_varchar2) or
541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute26, hr_api.g_varchar2) or
543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute27, hr_api.g_varchar2) or
537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute24, hr_api.g_varchar2) or
539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute25, hr_api.g_varchar2) or
541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute26, hr_api.g_varchar2) or
543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute27, hr_api.g_varchar2) or
545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute24, hr_api.g_varchar2) or
539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute25, hr_api.g_varchar2) or
541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute26, hr_api.g_varchar2) or
543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute27, hr_api.g_varchar2) or
545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute28, hr_api.g_varchar2) or
539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute25, hr_api.g_varchar2) or
541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute26, hr_api.g_varchar2) or
543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute27, hr_api.g_varchar2) or
545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute28, hr_api.g_varchar2) or
547: nvl(per_chk_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute25, hr_api.g_varchar2) or
541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute26, hr_api.g_varchar2) or
543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute27, hr_api.g_varchar2) or
545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute28, hr_api.g_varchar2) or
547: nvl(per_chk_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute29, hr_api.g_varchar2) or
541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute26, hr_api.g_varchar2) or
543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute27, hr_api.g_varchar2) or
545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute28, hr_api.g_varchar2) or
547: nvl(per_chk_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute29, hr_api.g_varchar2) or
549: nvl(per_chk_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute26, hr_api.g_varchar2) or
543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute27, hr_api.g_varchar2) or
545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute28, hr_api.g_varchar2) or
547: nvl(per_chk_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute29, hr_api.g_varchar2) or
549: nvl(per_chk_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute30, hr_api.g_varchar2)
543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute27, hr_api.g_varchar2) or
545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute28, hr_api.g_varchar2) or
547: nvl(per_chk_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute29, hr_api.g_varchar2) or
549: nvl(per_chk_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute30, hr_api.g_varchar2)
551: )
544: nvl(p_rec.attribute27, hr_api.g_varchar2) or
545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute28, hr_api.g_varchar2) or
547: nvl(per_chk_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute29, hr_api.g_varchar2) or
549: nvl(per_chk_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute30, hr_api.g_varchar2)
551: )
552: or
545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute28, hr_api.g_varchar2) or
547: nvl(per_chk_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute29, hr_api.g_varchar2) or
549: nvl(per_chk_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute30, hr_api.g_varchar2)
551: )
552: or
553: (
546: nvl(p_rec.attribute28, hr_api.g_varchar2) or
547: nvl(per_chk_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute29, hr_api.g_varchar2) or
549: nvl(per_chk_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute30, hr_api.g_varchar2)
551: )
552: or
553: (
554: (p_rec.attribute_category is null) and
675: hr_utility.set_location('Entering:'||l_proc, 5);
676: --
677: -- Check mandatory arguments have been set
678: --
679: hr_api.mandatory_arg_error
680: (p_api_name => l_proc
681: ,p_argument => 'effective_date'
682: ,p_argument_value => p_effective_date
683: );
681: ,p_argument => 'effective_date'
682: ,p_argument_value => p_effective_date
683: );
684:
685: hr_api.mandatory_arg_error
686: (p_api_name => l_proc
687: ,p_argument => 'person_id'
688: ,p_argument_value => p_rec.person_id
689: );
687: ,p_argument => 'person_id'
688: ,p_argument_value => p_rec.person_id
689: );
690:
691: hr_api.mandatory_arg_error
692: (p_api_name => l_proc
693: ,p_argument => 'item_code'
694: ,p_argument_value => p_rec.item_code
695: );
752: hr_utility.set_location('Entering:'||l_proc, 5);
753: --
754: -- Check mandatory arguments have been set
755: --
756: hr_api.mandatory_arg_error
757: (p_api_name => l_proc
758: ,p_argument => 'effective_date'
759: ,p_argument_value => p_effective_date
760: );
758: ,p_argument => 'effective_date'
759: ,p_argument_value => p_effective_date
760: );
761:
762: hr_api.mandatory_arg_error
763: (p_api_name => l_proc
764: ,p_argument => 'person_id'
765: ,p_argument_value => p_rec.person_id
766: );
764: ,p_argument => 'person_id'
765: ,p_argument_value => p_rec.person_id
766: );
767:
768: hr_api.mandatory_arg_error
769: (p_api_name => l_proc
770: ,p_argument => 'item_code'
771: ,p_argument_value => p_rec.item_code
772: );