37: -- are updteable if null. Present code makes it non updateable hence
38: -- commented
39: --
40: /*
41: if nvl(p_rec.parent_id, hr_api.g_number) <>
42: nvl(per_phn_shd.g_old_rec.parent_id
43: ,hr_api.g_number
44: ) then
45: --
39: --
40: /*
41: if nvl(p_rec.parent_id, hr_api.g_number) <>
42: nvl(per_phn_shd.g_old_rec.parent_id
43: ,hr_api.g_number
44: ) then
45: --
46: hr_api.argument_changed_error
47: (p_api_name => l_proc
42: nvl(per_phn_shd.g_old_rec.parent_id
43: ,hr_api.g_number
44: ) then
45: --
46: hr_api.argument_changed_error
47: (p_api_name => l_proc
48: ,p_argument => 'PARENT_ID'
49: ,p_base_table => per_phn_shd.g_tab_nam
50: );
51: --
52: end if;
53: --
54: hr_utility.set_location(l_proc, 40);
55: if nvl(p_rec.parent_table, hr_api.g_varchar2) <>
56: nvl(per_phn_shd.g_old_rec.parent_table
57: ,hr_api.g_varchar2
58: ) then
59: --
53: --
54: hr_utility.set_location(l_proc, 40);
55: if nvl(p_rec.parent_table, hr_api.g_varchar2) <>
56: nvl(per_phn_shd.g_old_rec.parent_table
57: ,hr_api.g_varchar2
58: ) then
59: --
60: hr_api.argument_changed_error
61: (p_api_name => l_proc
56: nvl(per_phn_shd.g_old_rec.parent_table
57: ,hr_api.g_varchar2
58: ) then
59: --
60: hr_api.argument_changed_error
61: (p_api_name => l_proc
62: ,p_argument => 'PARENT_TABLE'
63: ,p_base_table => per_phn_shd.g_tab_nam
64: );
116: hr_utility.set_location('Entering:'||l_proc, 1);
117: --
118: -- Check mandatory parameters have been set
119: --
120: hr_api.mandatory_arg_error
121: (p_api_name => l_proc
122: ,p_argument => 'date_from'
123: ,p_argument_value => p_date_from
124: );
131: (p_phone_id => p_phone_id
132: ,p_object_version_number => p_object_version_number);
133: --
134: if (l_api_updating and
135: (nvl(per_phn_shd.g_old_rec.date_from,hr_api.g_eot)
136: <> nvl(p_date_from,hr_api.g_eot)
137: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot)
138: <> nvl(p_date_to,hr_api.g_eot)))
139: or
132: ,p_object_version_number => p_object_version_number);
133: --
134: if (l_api_updating and
135: (nvl(per_phn_shd.g_old_rec.date_from,hr_api.g_eot)
136: <> nvl(p_date_from,hr_api.g_eot)
137: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot)
138: <> nvl(p_date_to,hr_api.g_eot)))
139: or
140: (NOT l_api_updating) then
133: --
134: if (l_api_updating and
135: (nvl(per_phn_shd.g_old_rec.date_from,hr_api.g_eot)
136: <> nvl(p_date_from,hr_api.g_eot)
137: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot)
138: <> nvl(p_date_to,hr_api.g_eot)))
139: or
140: (NOT l_api_updating) then
141: hr_utility.set_location(l_proc, 2);
134: if (l_api_updating and
135: (nvl(per_phn_shd.g_old_rec.date_from,hr_api.g_eot)
136: <> nvl(p_date_from,hr_api.g_eot)
137: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot)
138: <> nvl(p_date_to,hr_api.g_eot)))
139: or
140: (NOT l_api_updating) then
141: hr_utility.set_location(l_proc, 2);
142: --
142: --
143: -- Check that the date_from value is less than or equal to the date_to
144: -- value for the current record
145: --
146: if p_date_from > nvl(p_date_to,hr_api.g_eot)then
147: hr_utility.set_message(801,'PER_7004_ALL_DATE_TO_FROM');
148: hr_utility.raise_error;
149: end if;
150: end if;
215: hr_utility.set_location('Entering:'|| l_proc, 1);
216: --
217: -- Check mandatory parameters have been set
218: --
219: hr_api.mandatory_arg_error
220: (p_api_name => l_proc
221: ,p_argument => 'effective_date'
222: ,p_argument_value => p_effective_date
223: );
221: ,p_argument => 'effective_date'
222: ,p_argument_value => p_effective_date
223: );
224: --
225: hr_api.mandatory_arg_error
226: (p_api_name => l_proc
227: ,p_argument => 'phone_type'
228: ,p_argument_value => p_phone_type
229: );
246: validation has to be there both while updating as well
247: as inserting new records*/
248:
249: -- if ((l_api_updating
250: -- and nvl(per_phn_shd.g_old_rec.phone_type, hr_api.g_varchar2) <>
251: -- nvl(p_phone_type, hr_api.g_varchar2))
252: -- or
253: -- (NOT l_api_updating)) then
254: hr_utility.set_location(l_proc, 2);
247: as inserting new records*/
248:
249: -- if ((l_api_updating
250: -- and nvl(per_phn_shd.g_old_rec.phone_type, hr_api.g_varchar2) <>
251: -- nvl(p_phone_type, hr_api.g_varchar2))
252: -- or
253: -- (NOT l_api_updating)) then
254: hr_utility.set_location(l_proc, 2);
255: --
256: -- Checks that the value for phone_type is
257: -- valid and exists on hr_lookups within the
258: -- specified date range
259: --
260: if hr_api.not_exists_in_hr_lookups
261: (p_effective_date => p_effective_date
262: ,p_lookup_type => 'PHONE_TYPE'
263: ,p_lookup_code => p_phone_type
264: ) then
333: cursor csr_home_phone_limit is
334: select phn.phone_id
335: from per_phones phn
336: where phn.phone_type = 'H1'
337: and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
338: and (
339: p_date_from between phn.date_from and
340: nvl(phn.date_to,hr_api.g_eot)
341: OR
336: where phn.phone_type = 'H1'
337: and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
338: and (
339: p_date_from between phn.date_from and
340: nvl(phn.date_to,hr_api.g_eot)
341: OR
342: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
343: nvl(phn.date_to,hr_api.g_eot)
344: OR
338: and (
339: p_date_from between phn.date_from and
340: nvl(phn.date_to,hr_api.g_eot)
341: OR
342: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
343: nvl(phn.date_to,hr_api.g_eot)
344: OR
345: phn.date_from between p_date_from and
346: nvl(p_date_to,hr_api.g_eot)
339: p_date_from between phn.date_from and
340: nvl(phn.date_to,hr_api.g_eot)
341: OR
342: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
343: nvl(phn.date_to,hr_api.g_eot)
344: OR
345: phn.date_from between p_date_from and
346: nvl(p_date_to,hr_api.g_eot)
347: OR
342: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
343: nvl(phn.date_to,hr_api.g_eot)
344: OR
345: phn.date_from between p_date_from and
346: nvl(p_date_to,hr_api.g_eot)
347: OR
348: nvl(phn.date_to,hr_api.g_eot) between p_date_from and
349: nvl(p_date_to,hr_api.g_eot)
350: )
344: OR
345: phn.date_from between p_date_from and
346: nvl(p_date_to,hr_api.g_eot)
347: OR
348: nvl(phn.date_to,hr_api.g_eot) between p_date_from and
349: nvl(p_date_to,hr_api.g_eot)
350: )
351: and (
352: (phn.parent_id = p_parent_id --
345: phn.date_from between p_date_from and
346: nvl(p_date_to,hr_api.g_eot)
347: OR
348: nvl(phn.date_to,hr_api.g_eot) between p_date_from and
349: nvl(p_date_to,hr_api.g_eot)
350: )
351: and (
352: (phn.parent_id = p_parent_id --
353: and phn.parent_table = p_parent_table) -- HR/TCA merge
359: cursor csr_work_phone_limit is
360: select phn.phone_id
361: from per_phones phn
362: where phn.phone_type = 'W1'
363: and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
364: and (
365: p_date_from between phn.date_from and
366: nvl(phn.date_to,hr_api.g_eot)
367: OR
362: where phn.phone_type = 'W1'
363: and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
364: and (
365: p_date_from between phn.date_from and
366: nvl(phn.date_to,hr_api.g_eot)
367: OR
368: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
369: nvl(phn.date_to,hr_api.g_eot)
370: OR
364: and (
365: p_date_from between phn.date_from and
366: nvl(phn.date_to,hr_api.g_eot)
367: OR
368: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
369: nvl(phn.date_to,hr_api.g_eot)
370: OR
371: phn.date_from between p_date_from and
372: nvl(p_date_to,hr_api.g_eot)
365: p_date_from between phn.date_from and
366: nvl(phn.date_to,hr_api.g_eot)
367: OR
368: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
369: nvl(phn.date_to,hr_api.g_eot)
370: OR
371: phn.date_from between p_date_from and
372: nvl(p_date_to,hr_api.g_eot)
373: OR
368: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
369: nvl(phn.date_to,hr_api.g_eot)
370: OR
371: phn.date_from between p_date_from and
372: nvl(p_date_to,hr_api.g_eot)
373: OR
374: nvl(phn.date_to,hr_api.g_eot) between p_date_from and
375: nvl(p_date_to,hr_api.g_eot)
376: )
370: OR
371: phn.date_from between p_date_from and
372: nvl(p_date_to,hr_api.g_eot)
373: OR
374: nvl(phn.date_to,hr_api.g_eot) between p_date_from and
375: nvl(p_date_to,hr_api.g_eot)
376: )
377: and (
378: (phn.parent_id = p_parent_id --
371: phn.date_from between p_date_from and
372: nvl(p_date_to,hr_api.g_eot)
373: OR
374: nvl(phn.date_to,hr_api.g_eot) between p_date_from and
375: nvl(p_date_to,hr_api.g_eot)
376: )
377: and (
378: (phn.parent_id = p_parent_id --
379: and phn.parent_table = p_parent_table) -- HR/TCA merge
408: --
409: if ((l_api_updating
410: and (per_phn_shd.g_old_rec.phone_type <> p_phone_type
411: or per_phn_shd.g_old_rec.date_from <> p_date_from
412: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot) <>
413: nvl(p_date_to,hr_api.g_eot)))
414: OR
415: (NOT l_api_updating)) then
416: --
409: if ((l_api_updating
410: and (per_phn_shd.g_old_rec.phone_type <> p_phone_type
411: or per_phn_shd.g_old_rec.date_from <> p_date_from
412: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot) <>
413: nvl(p_date_to,hr_api.g_eot)))
414: OR
415: (NOT l_api_updating)) then
416: --
417: hr_utility.set_location(l_proc, 3);
505: hr_utility.set_location('Entering:'||l_proc, 1);
506: --
507: -- Check mandatory parameters have been set
508: --
509: hr_api.mandatory_arg_error
510: (p_api_name => l_proc
511: ,p_argument => 'parent_table'
512: ,p_argument_value => p_parent_table
513: );
593: hr_utility.set_location('Entering:'||l_proc, 1);
594: --
595: -- Check mandatory parameters have been set
596: --
597: hr_api.mandatory_arg_error
598: (p_api_name => l_proc
599: ,p_argument => 'parent_id'
600: ,p_argument_value => p_parent_id
601: );
639: --
640: --UPDATE not allowed unless currently null
641: --
642: if (l_api_updating
643: and nvl(per_phn_shd.g_old_rec.parent_id,hr_api.g_number) <> hr_api.g_number
644: and per_phn_shd.g_old_rec.parent_id <> p_parent_id
645: ) then
646: hr_utility.set_location(l_proc, 11);
647: hr_utility.set_message(800, 'HR_289949_INV_UPD_PARENT_ID');
649: end if;
650: --
651: hr_utility.set_location(l_proc, 15);
652: --
653: if ((nvl(p_parent_id,hr_api.g_number) <> hr_api.g_number)
654: and (nvl(p_parent_table,hr_api.g_varchar2) = hr_api.g_varchar2)) then
655: hr_utility.set_location(l_proc, 16);
656: hr_utility.set_message(800, 'HR_289946_INV_PARENT_TABLE');
657: hr_utility.raise_error;
650: --
651: hr_utility.set_location(l_proc, 15);
652: --
653: if ((nvl(p_parent_id,hr_api.g_number) <> hr_api.g_number)
654: and (nvl(p_parent_table,hr_api.g_varchar2) = hr_api.g_varchar2)) then
655: hr_utility.set_location(l_proc, 16);
656: hr_utility.set_message(800, 'HR_289946_INV_PARENT_TABLE');
657: hr_utility.raise_error;
658: end if;
722: from per_all_people_f per
723: where per.person_id = p_rec.parent_id
724: and p_effective_date
725: between per.effective_start_date
726: and nvl(per.effective_end_date,hr_api.g_eot)
727: and rownum <2; -- Performace bug fix #3387297
728: --
729: cursor csr_valid_party_id is
730: select party_id
838: hr_utility.set_location('Entering:'||l_proc, 1);
839: --
840: -- Check mandatory parameters have been set
841: --
842: hr_api.mandatory_arg_error
843: (p_api_name => l_proc
844: ,p_argument => 'object_version_number'
845: ,p_argument_value => p_object_version_number
846: );
886: --
887: begin
888: hr_utility.set_location('Entering:'||l_proc, 10);
889: --
890: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute1, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
887: begin
888: hr_utility.set_location('Entering:'||l_proc, 10);
889: --
890: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute1, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute2, hr_api.g_varchar2) or
888: hr_utility.set_location('Entering:'||l_proc, 10);
889: --
890: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute1, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute2, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
889: --
890: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute1, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute2, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute3, hr_api.g_varchar2) or
890: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute1, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute2, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute3, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute1, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute2, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute3, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute4, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute1, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute2, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute3, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute4, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute1, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute2, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute3, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute4, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute5, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute2, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute3, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute4, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute5, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute2, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute3, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute4, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute5, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute6, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute3, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute4, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute5, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute6, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute3, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute4, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute5, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute6, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute7, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute4, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute5, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute6, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute7, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute4, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute5, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute6, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute7, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute8, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute5, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute6, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute7, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute8, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute5, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute6, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute7, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute8, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute9, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute6, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute7, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute8, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute9, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute6, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute7, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute8, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute9, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute10, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute7, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute8, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute9, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute10, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute7, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute8, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute9, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute10, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute11, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute8, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute9, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute10, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute11, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute8, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute9, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute10, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute11, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute12, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute9, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute10, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute11, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute12, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute9, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute10, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute11, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute12, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute13, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute10, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute11, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute12, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute13, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute10, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute11, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute12, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute13, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute14, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute11, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute12, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute13, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute14, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute11, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute12, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute13, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute14, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute15, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute12, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute13, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute14, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute15, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute12, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute13, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute14, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute15, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute16, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute13, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute14, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute15, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute16, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute13, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute14, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute15, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute16, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute17, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute14, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute15, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute16, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute17, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute14, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute15, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute16, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute17, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute18, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute15, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute16, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute17, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute18, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute15, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute16, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute17, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute18, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute19, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute16, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute17, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute18, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute19, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute16, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute17, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute18, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute19, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute20, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute17, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute18, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute19, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute20, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute17, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute18, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute19, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute20, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute21, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute18, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute19, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute20, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute21, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute18, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute19, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute20, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute21, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute22, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute19, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute20, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute21, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute22, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute19, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute20, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute21, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute22, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute23, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute20, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute21, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute22, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute23, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute20, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute21, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute22, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute23, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute24, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute21, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute22, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute23, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute24, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute21, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute22, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute23, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute24, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute25, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute22, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute23, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute24, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute25, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute22, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute23, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute24, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute25, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute26, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute23, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute24, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute25, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute26, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute23, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute24, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute25, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute26, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute27, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute24, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute25, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute26, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute27, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute24, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute25, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute26, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute27, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute28, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute25, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute26, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute27, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute28, hr_api.g_varchar2) or
948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute25, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute26, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute27, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute28, hr_api.g_varchar2) or
948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute29, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute26, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute27, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute28, hr_api.g_varchar2) or
948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute29, hr_api.g_varchar2) or
950: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute26, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute27, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute28, hr_api.g_varchar2) or
948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute29, hr_api.g_varchar2) or
950: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
951: nvl(p_rec.attribute30, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute27, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute28, hr_api.g_varchar2) or
948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute29, hr_api.g_varchar2) or
950: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
951: nvl(p_rec.attribute30, hr_api.g_varchar2) or
952: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
945: nvl(p_rec.attribute27, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute28, hr_api.g_varchar2) or
948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute29, hr_api.g_varchar2) or
950: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
951: nvl(p_rec.attribute30, hr_api.g_varchar2) or
952: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
953: nvl(p_rec.party_id, hr_api.g_number) --
946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute28, hr_api.g_varchar2) or
948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute29, hr_api.g_varchar2) or
950: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
951: nvl(p_rec.attribute30, hr_api.g_varchar2) or
952: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
953: nvl(p_rec.party_id, hr_api.g_number) --
954: then
947: nvl(p_rec.attribute28, hr_api.g_varchar2) or
948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute29, hr_api.g_varchar2) or
950: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
951: nvl(p_rec.attribute30, hr_api.g_varchar2) or
952: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
953: nvl(p_rec.party_id, hr_api.g_number) --
954: then
955: -- either the attribute_category or attribute1..30 have changed
948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute29, hr_api.g_varchar2) or
950: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
951: nvl(p_rec.attribute30, hr_api.g_varchar2) or
952: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
953: nvl(p_rec.party_id, hr_api.g_number) --
954: then
955: -- either the attribute_category or attribute1..30 have changed
956: -- so we must call the flex stub
949: nvl(p_rec.attribute29, hr_api.g_varchar2) or
950: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
951: nvl(p_rec.attribute30, hr_api.g_varchar2) or
952: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
953: nvl(p_rec.party_id, hr_api.g_number) --
954: then
955: -- either the attribute_category or attribute1..30 have changed
956: -- so we must call the flex stub
957: per_phn_flex.df(p_rec => p_rec);
995: begin
996: hr_utility.set_location('Entering:'||l_proc, 10);
997: --
998: if ((p_rec.phone_id is not null) and (
999: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
996: hr_utility.set_location('Entering:'||l_proc, 10);
997: --
998: if ((p_rec.phone_id is not null) and (
999: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute2, hr_api.g_varchar2) or
997: --
998: if ((p_rec.phone_id is not null) and (
999: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
998: if ((p_rec.phone_id is not null) and (
999: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute3, hr_api.g_varchar2) or
999: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1057: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1057: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1057: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1059: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1057: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1059: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute30, hr_api.g_varchar2)))
1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1057: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1059: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute30, hr_api.g_varchar2)))
1061: or
1054: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1057: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1059: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute30, hr_api.g_varchar2)))
1061: or
1062: (p_rec.phone_id is null) then
1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1057: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1059: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute30, hr_api.g_varchar2)))
1061: or
1062: (p_rec.phone_id is null) then
1063: --
1056: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1057: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1059: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute30, hr_api.g_varchar2)))
1061: or
1062: (p_rec.phone_id is null) then
1063: --
1064: -- Only execute the validation if absolutely necessary:
1177: hr_utility.set_location('Entering:'||l_proc, 5);
1178: If p_validity is not null
1179: then
1180: hr_utility.set_location(l_proc, 10);
1181: If hr_api.not_exists_in_hr_lookups
1182: (p_effective_date => p_effective_date
1183: ,p_lookup_type => 'IRC_CONTACT_TIMES'
1184: ,p_lookup_code => p_validity
1185: )
1505: hr_utility.set_location('Entering:'|| l_proc, 10);
1506: --
1507: -- Ensure that all the mandatory parameter are not null
1508: --
1509: hr_api.mandatory_arg_error(p_api_name => l_proc,
1510: p_argument => 'phone_id',
1511: p_argument_value => p_phone_id);
1512: --
1513: if nvl(g_phone_id, hr_api.g_number) = p_phone_id then
1509: hr_api.mandatory_arg_error(p_api_name => l_proc,
1510: p_argument => 'phone_id',
1511: p_argument_value => p_phone_id);
1512: --
1513: if nvl(g_phone_id, hr_api.g_number) = p_phone_id then
1514: --
1515: -- The legislation code has already been found with a previous
1516: -- call to this function. Just return the value in the global
1517: -- variable.