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:

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

246: validation has to be there both while updating as well
247: as inserting new records*/
248:
249: -- if ((l_api_updating
250: -- and nvl(per_phn_shd.g_old_rec.phone_type, hr_api.g_varchar2) <>
251: -- nvl(p_phone_type, hr_api.g_varchar2))
252: -- or
253: -- (NOT l_api_updating)) then
254: hr_utility.set_location(l_proc, 2);

Line 403: l_api_updating := per_phn_shd.api_updating

399: -- Only proceed with validation if :
400: -- a) The current g_old_rec is current and
401: -- b) The value for phone type, date_to, or date_from has changed
402: --
403: l_api_updating := per_phn_shd.api_updating
404: (p_phone_id => p_phone_id
405: ,p_object_version_number => p_object_version_number);
406: --
407: hr_utility.set_location(l_proc, 2);

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

406: --
407: hr_utility.set_location(l_proc, 2);
408: --
409: if ((l_api_updating
410: and (per_phn_shd.g_old_rec.phone_type <> p_phone_type
411: or per_phn_shd.g_old_rec.date_from <> p_date_from
412: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot) <>
413: nvl(p_date_to,hr_api.g_eot)))
414: OR

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

407: hr_utility.set_location(l_proc, 2);
408: --
409: if ((l_api_updating
410: and (per_phn_shd.g_old_rec.phone_type <> p_phone_type
411: or per_phn_shd.g_old_rec.date_from <> p_date_from
412: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot) <>
413: nvl(p_date_to,hr_api.g_eot)))
414: OR
415: (NOT l_api_updating)) then

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

408: --
409: if ((l_api_updating
410: and (per_phn_shd.g_old_rec.phone_type <> p_phone_type
411: or per_phn_shd.g_old_rec.date_from <> p_date_from
412: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot) <>
413: nvl(p_date_to,hr_api.g_eot)))
414: OR
415: (NOT l_api_updating)) then
416: --

Line 615: l_api_updating := per_phn_shd.api_updating

611: -- Only proceed with validation if :
612: -- a) The current g_old_rec is current and
613: -- b) The date_from value has changed
614: --
615: l_api_updating := per_phn_shd.api_updating
616: (p_phone_id => p_phone_id
617: ,p_object_version_number => p_object_version_number);
618: --
619: if ((l_api_updating and per_phn_shd.g_old_rec.parent_id <> p_parent_id)

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

615: l_api_updating := per_phn_shd.api_updating
616: (p_phone_id => p_phone_id
617: ,p_object_version_number => p_object_version_number);
618: --
619: if ((l_api_updating and per_phn_shd.g_old_rec.parent_id <> p_parent_id)
620: or
621: (NOT l_api_updating)) then
622: --
623: hr_utility.set_location(l_proc, 4);

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

639: --
640: --UPDATE not allowed unless currently null
641: --
642: if (l_api_updating
643: and nvl(per_phn_shd.g_old_rec.parent_id,hr_api.g_number) <> hr_api.g_number
644: and per_phn_shd.g_old_rec.parent_id <> p_parent_id
645: ) then
646: hr_utility.set_location(l_proc, 11);
647: hr_utility.set_message(800, 'HR_289949_INV_UPD_PARENT_ID');

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

640: --UPDATE not allowed unless currently null
641: --
642: if (l_api_updating
643: and nvl(per_phn_shd.g_old_rec.parent_id,hr_api.g_number) <> hr_api.g_number
644: and per_phn_shd.g_old_rec.parent_id <> p_parent_id
645: ) then
646: hr_utility.set_location(l_proc, 11);
647: hr_utility.set_message(800, 'HR_289949_INV_UPD_PARENT_ID');
648: hr_utility.raise_error;

Line 709: p_rec in out nocopy per_phn_shd.g_rec_type

705: -- Access Status:
706: -- Internal Table Handler Use Only.
707: --
708: Procedure chk_party_id(
709: p_rec in out nocopy per_phn_shd.g_rec_type
710: ,p_effective_date in date
711: )is
712: --
713: l_proc varchar2(72) := g_package||'chk_party_id';

Line 883: (p_rec in per_phn_shd.g_rec_type) is

879: -- Access Status:
880: -- Internal Table Handler Use Only.
881: -- ---------------------------------------------------------------------------
882: procedure df_update_validate
883: (p_rec in per_phn_shd.g_rec_type) is
884: --
885: l_proc varchar2(72) := g_package||'df_update_validate';
886: --
887: begin

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

886: --
887: begin
888: hr_utility.set_location('Entering:'||l_proc, 10);
889: --
890: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute1, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

888: hr_utility.set_location('Entering:'||l_proc, 10);
889: --
890: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute1, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute2, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

890: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
892: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute1, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute2, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute3, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

892: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute1, hr_api.g_varchar2) or
894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute2, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute3, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute4, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

894: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute2, hr_api.g_varchar2) or
896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute3, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute4, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute5, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

896: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute3, hr_api.g_varchar2) or
898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute4, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute5, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute6, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

898: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute4, hr_api.g_varchar2) or
900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute5, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute6, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute7, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

900: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute5, hr_api.g_varchar2) or
902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute6, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute7, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute8, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

902: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute6, hr_api.g_varchar2) or
904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute7, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute8, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute9, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

904: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute7, hr_api.g_varchar2) or
906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute8, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute9, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute10, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

906: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute8, hr_api.g_varchar2) or
908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute9, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute10, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute11, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

908: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute9, hr_api.g_varchar2) or
910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute10, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute11, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute12, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

910: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute10, hr_api.g_varchar2) or
912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute11, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute12, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute13, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

912: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute11, hr_api.g_varchar2) or
914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute12, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute13, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute14, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

914: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute12, hr_api.g_varchar2) or
916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute13, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute14, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute15, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

916: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute13, hr_api.g_varchar2) or
918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute14, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute15, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute16, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

918: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute14, hr_api.g_varchar2) or
920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute15, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute16, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute17, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

920: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute15, hr_api.g_varchar2) or
922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute16, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute17, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute18, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

922: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute16, hr_api.g_varchar2) or
924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute17, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute18, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute19, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

924: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute17, hr_api.g_varchar2) or
926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute18, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute19, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute20, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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

926: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute18, hr_api.g_varchar2) or
928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute19, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute20, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute21, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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

928: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute19, hr_api.g_varchar2) or
930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute20, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute21, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute22, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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

930: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute20, hr_api.g_varchar2) or
932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute21, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute22, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute23, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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

932: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute21, hr_api.g_varchar2) or
934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute22, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute23, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute24, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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

934: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute22, hr_api.g_varchar2) or
936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute23, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute24, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute25, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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

936: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute23, hr_api.g_varchar2) or
938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute24, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute25, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute26, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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

938: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute24, hr_api.g_varchar2) or
940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute25, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute26, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute27, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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

940: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
941: nvl(p_rec.attribute25, hr_api.g_varchar2) or
942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute26, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute27, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute28, hr_api.g_varchar2) or
948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

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

942: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
943: nvl(p_rec.attribute26, hr_api.g_varchar2) or
944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute27, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute28, hr_api.g_varchar2) or
948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute29, hr_api.g_varchar2) or
950: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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

944: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
945: nvl(p_rec.attribute27, hr_api.g_varchar2) or
946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute28, hr_api.g_varchar2) or
948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute29, hr_api.g_varchar2) or
950: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
951: nvl(p_rec.attribute30, hr_api.g_varchar2) or
952: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge

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

946: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
947: nvl(p_rec.attribute28, hr_api.g_varchar2) or
948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute29, hr_api.g_varchar2) or
950: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
951: nvl(p_rec.attribute30, hr_api.g_varchar2) or
952: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
953: nvl(p_rec.party_id, hr_api.g_number) --
954: then

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

948: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
949: nvl(p_rec.attribute29, hr_api.g_varchar2) or
950: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
951: nvl(p_rec.attribute30, hr_api.g_varchar2) or
952: nvl(per_phn_shd.g_old_rec.party_id, hr_api.g_number) <> -- HR/TCA merge
953: nvl(p_rec.party_id, hr_api.g_number) --
954: then
955: -- either the attribute_category or attribute1..30 have changed
956: -- so we must call the flex stub

Line 991: (p_rec in per_phn_shd.g_rec_type) is

987: -- Access Status:
988: -- Internal Row Handler Use Only.
989: --
990: procedure chk_df
991: (p_rec in per_phn_shd.g_rec_type) is
992: --
993: l_proc varchar2(72) := g_package||'chk_df';
994: --
995: begin

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

995: begin
996: hr_utility.set_location('Entering:'||l_proc, 10);
997: --
998: if ((p_rec.phone_id is not null) and (
999: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

997: --
998: if ((p_rec.phone_id is not null) and (
999: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

999: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1000: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1001: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

1001: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1002: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

1003: nvl(per_phn_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1004: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

1005: nvl(per_phn_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1006: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

1007: nvl(per_phn_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1008: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

1009: nvl(per_phn_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1010: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

1011: nvl(per_phn_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1012: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

1013: nvl(per_phn_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1014: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

1015: nvl(per_phn_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1016: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

1017: nvl(per_phn_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1018: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

1019: nvl(per_phn_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1020: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

1021: nvl(per_phn_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1022: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

1023: nvl(per_phn_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1024: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

1025: nvl(per_phn_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

1027: nvl(per_phn_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

1029: nvl(per_phn_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

1031: nvl(per_phn_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

1033: nvl(per_phn_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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

1035: nvl(per_phn_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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

1037: nvl(per_phn_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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

1039: nvl(per_phn_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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

1041: nvl(per_phn_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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

1043: nvl(per_phn_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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

1045: nvl(per_phn_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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

1047: nvl(per_phn_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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

1049: nvl(per_phn_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1057: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

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

1051: nvl(per_phn_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1057: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1059: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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

1053: nvl(per_phn_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1057: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1059: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute30, hr_api.g_varchar2)))
1061: or

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

1055: nvl(per_phn_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1057: nvl(per_phn_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1059: nvl(per_phn_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute30, hr_api.g_varchar2)))
1061: or
1062: (p_rec.phone_id is null) then
1063: --

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

1206: --
1207: -- ----------------------------------------------------------------------------
1208: -- |---------------------------< insert_validate >----------------------------|
1209: -- ----------------------------------------------------------------------------
1210: Procedure insert_validate(p_rec in out nocopy per_phn_shd.g_rec_type
1211: ,p_effective_date in date
1212: ) is
1213: --
1214: l_proc varchar2(72) := g_package||'insert_validate';

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

1220: if p_rec.parent_table = 'PER_ALL_PEOPLE_F' then
1221: per_per_bus.set_security_group_id
1222: (
1223: p_person_id => p_rec.parent_id
1224: ,p_associated_column1 => per_phn_shd.g_tab_nam||'.PARENT_ID'
1225: );
1226: end if;
1227: --
1228: -- After validating the set of important attributes,

Line 1338: Procedure update_validate(p_rec in per_phn_shd.g_rec_type

1334: --
1335: -- ----------------------------------------------------------------------------
1336: -- |---------------------------< update_validate >----------------------------|
1337: -- ----------------------------------------------------------------------------
1338: Procedure update_validate(p_rec in per_phn_shd.g_rec_type
1339: ,p_effective_date in date
1340: ) is
1341: --
1342: l_proc varchar2(72) := g_package||'update_validate';

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

1347: if p_rec.parent_table = 'PER_ALL_PEOPLE_F' then
1348: per_per_bus.set_security_group_id
1349: (
1350: p_person_id => p_rec.parent_id
1351: ,p_associated_column1 => per_phn_shd.g_tab_nam||'.PARENT_ID'
1352: );
1353: end if;
1354: --
1355: -- After validating the set of important attributes,

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

1460: --
1461: -- ----------------------------------------------------------------------------
1462: -- |---------------------------< delete_validate >----------------------------|
1463: -- ----------------------------------------------------------------------------
1464: Procedure delete_validate(p_rec in per_phn_shd.g_rec_type) is
1465: --
1466: l_proc varchar2(72) := g_package||'delete_validate';
1467: --
1468: Begin