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

APPS.PER_PHN_BUS dependencies on PER_PHN_SHD

Line 15: (p_rec in per_phn_shd.g_rec_type

11: -- |-----------------------< chk_non_updateable_args >--------------|
12: -- -----------------------------------------------------------------
13: --
14: Procedure chk_non_updateable_args
15: (p_rec in per_phn_shd.g_rec_type
16: ) is
17: --
18: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
19: --

Line 26: if not per_phn_shd.api_updating

22: --
23: -- Only proceed with validation if a row exists for
24: -- the current record in the HR Schema
25: --
26: if not per_phn_shd.api_updating
27: (p_phone_id => p_rec.phone_id,
28: p_object_version_number => p_rec.object_version_number)
29: then
30: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 42: nvl(per_phn_shd.g_old_rec.parent_id

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: --
46: hr_api.argument_changed_error

Line 49: ,p_base_table => per_phn_shd.g_tab_nam

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

Line 56: nvl(per_phn_shd.g_old_rec.parent_table

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: --
60: hr_api.argument_changed_error

Line 63: ,p_base_table => per_phn_shd.g_tab_nam

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: );
65: --
66: end if;
67: --

Line 130: l_api_updating := per_phn_shd.api_updating

126: -- Only proceed with validation if :
127: -- a) The current g_old_rec is current and
128: -- b) The date_from or date_to value has changed
129: --
130: l_api_updating := per_phn_shd.api_updating
131: (p_phone_id => p_phone_id
132: ,p_object_version_number => p_object_version_number);
133: --
134: if (l_api_updating and

Line 135: (nvl(per_phn_shd.g_old_rec.date_from,hr_api.g_eot)

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

Line 137: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot)

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

Line 240: l_api_updating := per_phn_shd.api_updating

236: -- Only proceed with validation if :
237: -- a) The current g_old_rec is current and
238: -- b) The value for phone type has changed
239: --
240: l_api_updating := per_phn_shd.api_updating
241: (p_phone_id => p_phone_id
242: ,p_object_version_number => p_object_version_number);
243: --
244: if ((l_api_updating

Line 245: and nvl(per_phn_shd.g_old_rec.phone_type, hr_api.g_varchar2) <>

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

Line 397: l_api_updating := per_phn_shd.api_updating

393: -- Only proceed with validation if :
394: -- a) The current g_old_rec is current and
395: -- b) The value for phone type, date_to, or date_from has changed
396: --
397: l_api_updating := per_phn_shd.api_updating
398: (p_phone_id => p_phone_id
399: ,p_object_version_number => p_object_version_number);
400: --
401: hr_utility.set_location(l_proc, 2);

Line 404: and (per_phn_shd.g_old_rec.phone_type <> p_phone_type

400: --
401: hr_utility.set_location(l_proc, 2);
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

Line 405: or per_phn_shd.g_old_rec.date_from <> p_date_from

401: hr_utility.set_location(l_proc, 2);
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

Line 406: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot) <>

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

Line 609: l_api_updating := per_phn_shd.api_updating

605: -- Only proceed with validation if :
606: -- a) The current g_old_rec is current and
607: -- b) The date_from value has changed
608: --
609: l_api_updating := per_phn_shd.api_updating
610: (p_phone_id => p_phone_id
611: ,p_object_version_number => p_object_version_number);
612: --
613: if ((l_api_updating and per_phn_shd.g_old_rec.parent_id <> p_parent_id)

Line 613: if ((l_api_updating and per_phn_shd.g_old_rec.parent_id <> p_parent_id)

609: l_api_updating := per_phn_shd.api_updating
610: (p_phone_id => p_phone_id
611: ,p_object_version_number => p_object_version_number);
612: --
613: if ((l_api_updating and per_phn_shd.g_old_rec.parent_id <> p_parent_id)
614: or
615: (NOT l_api_updating)) then
616: --
617: hr_utility.set_location(l_proc, 4);

Line 637: and nvl(per_phn_shd.g_old_rec.parent_id,hr_api.g_number) <> hr_api.g_number

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

Line 638: and per_phn_shd.g_old_rec.parent_id <> p_parent_id

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');
642: hr_utility.raise_error;

Line 703: p_rec in out nocopy per_phn_shd.g_rec_type

699: -- Access Status:
700: -- Internal Table Handler Use Only.
701: --
702: Procedure chk_party_id(
703: p_rec in out nocopy per_phn_shd.g_rec_type
704: ,p_effective_date in date
705: )is
706: --
707: l_proc varchar2(72) := g_package||'chk_party_id';

Line 877: (p_rec in per_phn_shd.g_rec_type) is

873: -- Access Status:
874: -- Internal Table Handler Use Only.
875: -- ---------------------------------------------------------------------------
876: procedure df_update_validate
877: (p_rec in per_phn_shd.g_rec_type) is
878: --
879: l_proc varchar2(72) := g_package||'df_update_validate';
880: --
881: begin

Line 884: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

Line 886: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

Line 888: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

Line 890: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

Line 892: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

Line 894: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

Line 896: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

Line 898: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

Line 900: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

Line 902: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

Line 904: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

Line 906: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

Line 908: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

Line 910: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

Line 912: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

Line 914: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

Line 916: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

Line 918: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

Line 920: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

Line 922: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

Line 924: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

Line 926: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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

Line 928: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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

Line 930: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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

Line 932: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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

Line 934: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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

Line 936: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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

Line 938: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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

Line 940: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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

Line 942: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

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

Line 944: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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

Line 946: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge

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

Line 985: (p_rec in per_phn_shd.g_rec_type) is

981: -- Access Status:
982: -- Internal Row Handler Use Only.
983: --
984: procedure chk_df
985: (p_rec in per_phn_shd.g_rec_type) is
986: --
987: l_proc varchar2(72) := g_package||'chk_df';
988: --
989: begin

Line 993: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

Line 995: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

Line 997: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

Line 999: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

Line 1001: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

Line 1003: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

Line 1005: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

Line 1007: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

Line 1009: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

Line 1011: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

Line 1013: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

Line 1015: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

Line 1017: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

Line 1019: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

Line 1021: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

Line 1023: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

Line 1025: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

Line 1027: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

Line 1029: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

Line 1031: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

Line 1033: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

Line 1035: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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

Line 1037: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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

Line 1039: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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

Line 1041: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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

Line 1043: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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

Line 1045: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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

Line 1047: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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

Line 1049: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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

Line 1051: nvl(per_phn_shd.g_old_rec.attribute29, 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

Line 1053: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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

Line 1204: Procedure insert_validate(p_rec in out nocopy per_phn_shd.g_rec_type

1200: --
1201: -- ----------------------------------------------------------------------------
1202: -- |---------------------------< insert_validate >----------------------------|
1203: -- ----------------------------------------------------------------------------
1204: Procedure insert_validate(p_rec in out nocopy per_phn_shd.g_rec_type
1205: ,p_effective_date in date
1206: ) is
1207: --
1208: l_proc varchar2(72) := g_package||'insert_validate';

Line 1218: ,p_associated_column1 => per_phn_shd.g_tab_nam||'.PARENT_ID'

1214: if p_rec.parent_table = 'PER_ALL_PEOPLE_F' then
1215: per_per_bus.set_security_group_id
1216: (
1217: p_person_id => p_rec.parent_id
1218: ,p_associated_column1 => per_phn_shd.g_tab_nam||'.PARENT_ID'
1219: );
1220: end if;
1221: --
1222: -- After validating the set of important attributes,

Line 1310: Procedure update_validate(p_rec in per_phn_shd.g_rec_type

1306: --
1307: -- ----------------------------------------------------------------------------
1308: -- |---------------------------< update_validate >----------------------------|
1309: -- ----------------------------------------------------------------------------
1310: Procedure update_validate(p_rec in per_phn_shd.g_rec_type
1311: ,p_effective_date in date
1312: ) is
1313: --
1314: l_proc varchar2(72) := g_package||'update_validate';

Line 1323: ,p_associated_column1 => per_phn_shd.g_tab_nam||'.PARENT_ID'

1319: if p_rec.parent_table = 'PER_ALL_PEOPLE_F' then
1320: per_per_bus.set_security_group_id
1321: (
1322: p_person_id => p_rec.parent_id
1323: ,p_associated_column1 => per_phn_shd.g_tab_nam||'.PARENT_ID'
1324: );
1325: end if;
1326: --
1327: -- After validating the set of important attributes,

Line 1413: Procedure delete_validate(p_rec in per_phn_shd.g_rec_type) is

1409: --
1410: -- ----------------------------------------------------------------------------
1411: -- |---------------------------< delete_validate >----------------------------|
1412: -- ----------------------------------------------------------------------------
1413: Procedure delete_validate(p_rec in per_phn_shd.g_rec_type) is
1414: --
1415: l_proc varchar2(72) := g_package||'delete_validate';
1416: --
1417: Begin