[Home] [Help]
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: );
241: (p_phone_id => p_phone_id
242: ,p_object_version_number => p_object_version_number);
243: --
244: if ((l_api_updating
245: and nvl(per_phn_shd.g_old_rec.phone_type, hr_api.g_varchar2) <>
246: nvl(p_phone_type, hr_api.g_varchar2))
247: or
248: (NOT l_api_updating)) then
249: hr_utility.set_location(l_proc, 2);
242: ,p_object_version_number => p_object_version_number);
243: --
244: if ((l_api_updating
245: and nvl(per_phn_shd.g_old_rec.phone_type, hr_api.g_varchar2) <>
246: nvl(p_phone_type, hr_api.g_varchar2))
247: or
248: (NOT l_api_updating)) then
249: hr_utility.set_location(l_proc, 2);
250: --
251: -- Checks that the value for phone_type is
252: -- valid and exists on hr_lookups within the
253: -- specified date range
254: --
255: if hr_api.not_exists_in_hr_lookups
256: (p_effective_date => p_effective_date
257: ,p_lookup_type => 'PHONE_TYPE'
258: ,p_lookup_code => p_phone_type
259: ) then
327: cursor csr_home_phone_limit is
328: select phn.phone_id
329: from per_phones phn
330: where phn.phone_type = 'H1'
331: and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
332: and (
333: p_date_from between phn.date_from and
334: nvl(phn.date_to,hr_api.g_eot)
335: OR
330: where phn.phone_type = 'H1'
331: and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
332: and (
333: p_date_from between phn.date_from and
334: nvl(phn.date_to,hr_api.g_eot)
335: OR
336: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
337: nvl(phn.date_to,hr_api.g_eot)
338: OR
332: and (
333: p_date_from between phn.date_from and
334: nvl(phn.date_to,hr_api.g_eot)
335: OR
336: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
337: nvl(phn.date_to,hr_api.g_eot)
338: OR
339: phn.date_from between p_date_from and
340: nvl(p_date_to,hr_api.g_eot)
333: p_date_from between phn.date_from and
334: nvl(phn.date_to,hr_api.g_eot)
335: OR
336: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
337: nvl(phn.date_to,hr_api.g_eot)
338: OR
339: phn.date_from between p_date_from and
340: nvl(p_date_to,hr_api.g_eot)
341: OR
336: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
337: nvl(phn.date_to,hr_api.g_eot)
338: OR
339: phn.date_from between p_date_from and
340: nvl(p_date_to,hr_api.g_eot)
341: OR
342: nvl(phn.date_to,hr_api.g_eot) between p_date_from and
343: nvl(p_date_to,hr_api.g_eot)
344: )
338: OR
339: phn.date_from between p_date_from and
340: nvl(p_date_to,hr_api.g_eot)
341: OR
342: nvl(phn.date_to,hr_api.g_eot) between p_date_from and
343: nvl(p_date_to,hr_api.g_eot)
344: )
345: and (
346: (phn.parent_id = p_parent_id --
339: phn.date_from between p_date_from and
340: nvl(p_date_to,hr_api.g_eot)
341: OR
342: nvl(phn.date_to,hr_api.g_eot) between p_date_from and
343: nvl(p_date_to,hr_api.g_eot)
344: )
345: and (
346: (phn.parent_id = p_parent_id --
347: and phn.parent_table = p_parent_table) -- HR/TCA merge
353: cursor csr_work_phone_limit is
354: select phn.phone_id
355: from per_phones phn
356: where phn.phone_type = 'W1'
357: and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
358: and (
359: p_date_from between phn.date_from and
360: nvl(phn.date_to,hr_api.g_eot)
361: OR
356: where phn.phone_type = 'W1'
357: and phn.phone_id <> nvl(p_phone_id,hr_api.g_number)
358: and (
359: p_date_from between phn.date_from and
360: nvl(phn.date_to,hr_api.g_eot)
361: OR
362: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
363: nvl(phn.date_to,hr_api.g_eot)
364: OR
358: and (
359: p_date_from between phn.date_from and
360: nvl(phn.date_to,hr_api.g_eot)
361: OR
362: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
363: nvl(phn.date_to,hr_api.g_eot)
364: OR
365: phn.date_from between p_date_from and
366: nvl(p_date_to,hr_api.g_eot)
359: p_date_from between phn.date_from and
360: nvl(phn.date_to,hr_api.g_eot)
361: OR
362: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
363: nvl(phn.date_to,hr_api.g_eot)
364: OR
365: phn.date_from between p_date_from and
366: nvl(p_date_to,hr_api.g_eot)
367: OR
362: nvl(p_date_to,hr_api.g_eot) between phn.date_from and
363: nvl(phn.date_to,hr_api.g_eot)
364: OR
365: phn.date_from between p_date_from and
366: nvl(p_date_to,hr_api.g_eot)
367: OR
368: nvl(phn.date_to,hr_api.g_eot) between p_date_from and
369: nvl(p_date_to,hr_api.g_eot)
370: )
364: OR
365: phn.date_from between p_date_from and
366: nvl(p_date_to,hr_api.g_eot)
367: OR
368: nvl(phn.date_to,hr_api.g_eot) between p_date_from and
369: nvl(p_date_to,hr_api.g_eot)
370: )
371: and (
372: (phn.parent_id = p_parent_id --
365: phn.date_from between p_date_from and
366: nvl(p_date_to,hr_api.g_eot)
367: OR
368: nvl(phn.date_to,hr_api.g_eot) between p_date_from and
369: nvl(p_date_to,hr_api.g_eot)
370: )
371: and (
372: (phn.parent_id = p_parent_id --
373: and phn.parent_table = p_parent_table) -- HR/TCA merge
402: --
403: if ((l_api_updating
404: and (per_phn_shd.g_old_rec.phone_type <> p_phone_type
405: or per_phn_shd.g_old_rec.date_from <> p_date_from
406: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot) <>
407: nvl(p_date_to,hr_api.g_eot)))
408: OR
409: (NOT l_api_updating)) then
410: --
403: if ((l_api_updating
404: and (per_phn_shd.g_old_rec.phone_type <> p_phone_type
405: or per_phn_shd.g_old_rec.date_from <> p_date_from
406: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot) <>
407: nvl(p_date_to,hr_api.g_eot)))
408: OR
409: (NOT l_api_updating)) then
410: --
411: hr_utility.set_location(l_proc, 3);
499: hr_utility.set_location('Entering:'||l_proc, 1);
500: --
501: -- Check mandatory parameters have been set
502: --
503: hr_api.mandatory_arg_error
504: (p_api_name => l_proc
505: ,p_argument => 'parent_table'
506: ,p_argument_value => p_parent_table
507: );
587: hr_utility.set_location('Entering:'||l_proc, 1);
588: --
589: -- Check mandatory parameters have been set
590: --
591: hr_api.mandatory_arg_error
592: (p_api_name => l_proc
593: ,p_argument => 'parent_id'
594: ,p_argument_value => p_parent_id
595: );
633: --
634: --UPDATE not allowed unless currently null
635: --
636: if (l_api_updating
637: and nvl(per_phn_shd.g_old_rec.parent_id,hr_api.g_number) <> hr_api.g_number
638: and per_phn_shd.g_old_rec.parent_id <> p_parent_id
639: ) then
640: hr_utility.set_location(l_proc, 11);
641: hr_utility.set_message(800, 'HR_289949_INV_UPD_PARENT_ID');
643: end if;
644: --
645: hr_utility.set_location(l_proc, 15);
646: --
647: if ((nvl(p_parent_id,hr_api.g_number) <> hr_api.g_number)
648: and (nvl(p_parent_table,hr_api.g_varchar2) = hr_api.g_varchar2)) then
649: hr_utility.set_location(l_proc, 16);
650: hr_utility.set_message(800, 'HR_289946_INV_PARENT_TABLE');
651: hr_utility.raise_error;
644: --
645: hr_utility.set_location(l_proc, 15);
646: --
647: if ((nvl(p_parent_id,hr_api.g_number) <> hr_api.g_number)
648: and (nvl(p_parent_table,hr_api.g_varchar2) = hr_api.g_varchar2)) then
649: hr_utility.set_location(l_proc, 16);
650: hr_utility.set_message(800, 'HR_289946_INV_PARENT_TABLE');
651: hr_utility.raise_error;
652: end if;
716: from per_all_people_f per
717: where per.person_id = p_rec.parent_id
718: and p_effective_date
719: between per.effective_start_date
720: and nvl(per.effective_end_date,hr_api.g_eot)
721: and rownum <2; -- Performace bug fix #3387297
722: --
723: cursor csr_valid_party_id is
724: select party_id
832: hr_utility.set_location('Entering:'||l_proc, 1);
833: --
834: -- Check mandatory parameters have been set
835: --
836: hr_api.mandatory_arg_error
837: (p_api_name => l_proc
838: ,p_argument => 'object_version_number'
839: ,p_argument_value => p_object_version_number
840: );
880: --
881: begin
882: hr_utility.set_location('Entering:'||l_proc, 10);
883: --
884: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
886: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute1, hr_api.g_varchar2) or
888: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
881: begin
882: hr_utility.set_location('Entering:'||l_proc, 10);
883: --
884: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
886: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute1, hr_api.g_varchar2) or
888: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute2, hr_api.g_varchar2) or
882: hr_utility.set_location('Entering:'||l_proc, 10);
883: --
884: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
886: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute1, hr_api.g_varchar2) or
888: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute2, hr_api.g_varchar2) or
890: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
883: --
884: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
886: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute1, hr_api.g_varchar2) or
888: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute2, hr_api.g_varchar2) or
890: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute3, hr_api.g_varchar2) or
884: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
886: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute1, hr_api.g_varchar2) or
888: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute2, hr_api.g_varchar2) or
890: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute3, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
886: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute1, hr_api.g_varchar2) or
888: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute2, hr_api.g_varchar2) or
890: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute3, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute4, hr_api.g_varchar2) or
886: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute1, hr_api.g_varchar2) or
888: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute2, hr_api.g_varchar2) or
890: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute3, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute4, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute1, hr_api.g_varchar2) or
888: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute2, hr_api.g_varchar2) or
890: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute3, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute4, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute5, hr_api.g_varchar2) or
888: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute2, hr_api.g_varchar2) or
890: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute3, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute4, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute5, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute2, hr_api.g_varchar2) or
890: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute3, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute4, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute5, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute6, hr_api.g_varchar2) or
890: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute3, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute4, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute5, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute6, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute3, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute4, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute5, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute6, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute7, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute4, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute5, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute6, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute7, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute4, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute5, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute6, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute7, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute8, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute5, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute6, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute7, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute8, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute5, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute6, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute7, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute8, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute9, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute6, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute7, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute8, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute9, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute6, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute7, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute8, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute9, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute10, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute7, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute8, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute9, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute10, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute7, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute8, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute9, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute10, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute11, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute8, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute9, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute10, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute11, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute8, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute9, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute10, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute11, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute12, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute9, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute10, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute11, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute12, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute9, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute10, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute11, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute12, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute13, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute10, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute11, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute12, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute13, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute10, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute11, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute12, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute13, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute14, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute11, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute12, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute13, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute14, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute11, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute12, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute13, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute14, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute15, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute12, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute13, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute14, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute15, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute12, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute13, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute14, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute15, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute16, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute13, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute14, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute15, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute16, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute13, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute14, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute15, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute16, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute17, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute14, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute15, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute16, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute17, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute14, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute15, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute16, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute17, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute18, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute15, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute16, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute17, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute18, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute15, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute16, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute17, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute18, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute19, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute16, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute17, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute18, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute19, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute16, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute17, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute18, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute19, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute20, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute17, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute18, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute19, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute20, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute17, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute18, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute19, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute20, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute21, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute18, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute19, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute20, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute21, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute18, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute19, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute20, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute21, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute22, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute19, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute20, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute21, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute22, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute19, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute20, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute21, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute22, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute23, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute20, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute21, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute22, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute23, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute20, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute21, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute22, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute23, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute24, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute21, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute22, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute23, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute24, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute21, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute22, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute23, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute24, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute25, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute22, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute23, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute24, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute25, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute22, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute23, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute24, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute25, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute26, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute23, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute24, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute25, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute26, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute23, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute24, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute25, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute26, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute27, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute24, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute25, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute26, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute27, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute24, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute25, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute26, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute27, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute28, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute25, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute26, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute27, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute28, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute25, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute26, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute27, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute28, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute29, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute26, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute27, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute28, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute29, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute26, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute27, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute28, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute29, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute30, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute27, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute28, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute29, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute30, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
939: nvl(p_rec.attribute27, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute28, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute29, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute30, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
947: nvl(p_rec.party_id, hr_api.g_number) --
940: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute28, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute29, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute30, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
947: nvl(p_rec.party_id, hr_api.g_number) --
948: then
941: nvl(p_rec.attribute28, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute29, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute30, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
947: nvl(p_rec.party_id, hr_api.g_number) --
948: then
949: -- either the attribute_category or attribute1..30 have changed
942: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute29, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute30, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
947: nvl(p_rec.party_id, hr_api.g_number) --
948: then
949: -- either the attribute_category or attribute1..30 have changed
950: -- so we must call the flex stub
943: nvl(p_rec.attribute29, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute30, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
947: nvl(p_rec.party_id, hr_api.g_number) --
948: then
949: -- either the attribute_category or attribute1..30 have changed
950: -- so we must call the flex stub
951: per_phn_flex.df(p_rec => p_rec);
989: begin
990: hr_utility.set_location('Entering:'||l_proc, 10);
991: --
992: if ((p_rec.phone_id is not null) and (
993: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
995: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute1, hr_api.g_varchar2) or
997: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
990: hr_utility.set_location('Entering:'||l_proc, 10);
991: --
992: if ((p_rec.phone_id is not null) and (
993: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
995: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute1, hr_api.g_varchar2) or
997: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute2, hr_api.g_varchar2) or
991: --
992: if ((p_rec.phone_id is not null) and (
993: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
995: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute1, hr_api.g_varchar2) or
997: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute2, hr_api.g_varchar2) or
999: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
992: if ((p_rec.phone_id is not null) and (
993: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
995: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute1, hr_api.g_varchar2) or
997: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute2, hr_api.g_varchar2) or
999: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute3, hr_api.g_varchar2) or
993: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
995: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute1, hr_api.g_varchar2) or
997: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute2, hr_api.g_varchar2) or
999: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
995: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute1, hr_api.g_varchar2) or
997: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute2, hr_api.g_varchar2) or
999: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute4, hr_api.g_varchar2) or
995: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute1, hr_api.g_varchar2) or
997: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute2, hr_api.g_varchar2) or
999: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
996: nvl(p_rec.attribute1, hr_api.g_varchar2) or
997: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute2, hr_api.g_varchar2) or
999: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute5, hr_api.g_varchar2) or
997: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute2, hr_api.g_varchar2) or
999: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
998: nvl(p_rec.attribute2, hr_api.g_varchar2) or
999: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute6, hr_api.g_varchar2) or
999: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute30, hr_api.g_varchar2)))
1047: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute30, hr_api.g_varchar2)))
1055: or
1048: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute30, hr_api.g_varchar2)))
1055: or
1056: (p_rec.phone_id is null) then
1049: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute30, hr_api.g_varchar2)))
1055: or
1056: (p_rec.phone_id is null) then
1057: --
1050: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute30, hr_api.g_varchar2)))
1055: or
1056: (p_rec.phone_id is null) then
1057: --
1058: -- Only execute the validation if absolutely necessary:
1171: hr_utility.set_location('Entering:'||l_proc, 5);
1172: If p_validity is not null
1173: then
1174: hr_utility.set_location(l_proc, 10);
1175: If hr_api.not_exists_in_hr_lookups
1176: (p_effective_date => p_effective_date
1177: ,p_lookup_type => 'IRC_CONTACT_TIMES'
1178: ,p_lookup_code => p_validity
1179: )
1454: hr_utility.set_location('Entering:'|| l_proc, 10);
1455: --
1456: -- Ensure that all the mandatory parameter are not null
1457: --
1458: hr_api.mandatory_arg_error(p_api_name => l_proc,
1459: p_argument => 'phone_id',
1460: p_argument_value => p_phone_id);
1461: --
1462: if nvl(g_phone_id, hr_api.g_number) = p_phone_id then
1458: hr_api.mandatory_arg_error(p_api_name => l_proc,
1459: p_argument => 'phone_id',
1460: p_argument_value => p_phone_id);
1461: --
1462: if nvl(g_phone_id, hr_api.g_number) = p_phone_id then
1463: --
1464: -- The legislation code has already been found with a previous
1465: -- call to this function. Just return the value in the global
1466: -- variable.