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

APPS.PER_CHK_BUS dependencies on HR_API

Line 46: hr_api.mandatory_arg_error

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: );

Line 69: hr_api.set_security_group_id

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);

Line 106: hr_api.mandatory_arg_error

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: );

Line 112: if ( nvl(per_chk_bus.g_checklist_item_id, hr_api.g_number)

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

Line 201: if nvl(p_rec.checklist_item_id,hr_api.g_number)

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;

Line 202: <> nvl(per_chk_shd.g_old_rec.checklist_item_id,hr_api.g_number) then

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);

Line 208: if nvl(p_rec.person_id,hr_api.g_number)

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;

Line 209: <> nvl(per_chk_shd.g_old_rec.person_id,hr_api.g_number) then

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);

Line 215: if nvl(p_rec.item_code,hr_api.g_varchar2)

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;

Line 216: <> nvl(per_chk_shd.g_old_rec.item_code,hr_api.g_varchar2) then

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);

Line 224: hr_api.argument_changed_error

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;

Line 322: (nvl(per_chk_shd.g_old_rec.status,hr_api.g_varchar2)

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:

Line 323: <> nvl(p_status,hr_api.g_varchar2)))

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,

Line 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');

Line 377: IF hr_api.not_exists_in_hr_lookups( p_effective_date => p_effective_date,

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');

Line 489: ( (nvl(per_chk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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) <>

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

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

Line 491: nvl(per_chk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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) <>

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

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

Line 493: nvl(per_chk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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) <>

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

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

Line 495: nvl(per_chk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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) <>

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

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

Line 497: nvl(per_chk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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) <>

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

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

Line 499: nvl(per_chk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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) <>

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

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

Line 501: nvl(per_chk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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) <>

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

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

Line 503: nvl(per_chk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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) <>

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

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

Line 505: nvl(per_chk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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) <>

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

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

Line 507: nvl(per_chk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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) <>

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

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

Line 509: nvl(per_chk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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) <>

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

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

Line 511: nvl(per_chk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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) <>

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

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

Line 513: nvl(per_chk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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) <>

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

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

Line 515: nvl(per_chk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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) <>

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

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

Line 517: nvl(per_chk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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) <>

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

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

Line 519: nvl(per_chk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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) <>

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

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

Line 521: nvl(per_chk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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) <>

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

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

Line 523: nvl(per_chk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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) <>

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

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

Line 525: nvl(per_chk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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) <>

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

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

Line 527: nvl(per_chk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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) <>

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

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

Line 529: nvl(per_chk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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) <>

Line 530: nvl(p_rec.attribute20, hr_api.g_varchar2) or

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

Line 531: nvl(per_chk_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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) <>

Line 532: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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

Line 533: nvl(per_chk_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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) <>

Line 534: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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

Line 535: nvl(per_chk_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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) <>

Line 536: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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

Line 537: nvl(per_chk_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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) <>

Line 538: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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

Line 539: nvl(per_chk_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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) <>

Line 540: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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

Line 541: nvl(per_chk_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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) <>

Line 542: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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

Line 543: nvl(per_chk_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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) <>

Line 544: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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

Line 545: nvl(per_chk_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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) <>

Line 546: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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)

Line 547: nvl(per_chk_shd.g_old_rec.attribute29, 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: )

Line 548: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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

Line 549: nvl(per_chk_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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: (

Line 550: nvl(p_rec.attribute30, 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: (
554: (p_rec.attribute_category is null) and

Line 679: hr_api.mandatory_arg_error

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: );

Line 685: hr_api.mandatory_arg_error

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: );

Line 691: hr_api.mandatory_arg_error

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: );

Line 756: hr_api.mandatory_arg_error

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: );

Line 762: hr_api.mandatory_arg_error

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: );

Line 768: hr_api.mandatory_arg_error

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: );