DBA Data[Home] [Help]

APPS.HR_PHONE_API dependencies on PER_PHN_SHD

Line 712: l_phn_rec per_phn_shd.g_rec_type;

708: ) is
709: --
710: l_proc varchar2(72) := g_package||'create_or_update_phone';
711: l_api_updating boolean;
712: l_phn_rec per_phn_shd.g_rec_type;
713: l_null_phn_rec per_phn_shd.g_rec_type;
714: l_update_mode varchar2(30);
715: l_effective_date date;
716: --

Line 713: l_null_phn_rec per_phn_shd.g_rec_type;

709: --
710: l_proc varchar2(72) := g_package||'create_or_update_phone';
711: l_api_updating boolean;
712: l_phn_rec per_phn_shd.g_rec_type;
713: l_null_phn_rec per_phn_shd.g_rec_type;
714: l_update_mode varchar2(30);
715: l_effective_date date;
716: --
717: begin

Line 725: l_api_updating := per_phn_shd.api_updating

721: savepoint create_or_update_phone;
722: --
723: l_update_mode:=p_update_mode;
724: l_effective_date:=trunc(p_effective_date);
725: l_api_updating := per_phn_shd.api_updating
726: (p_phone_id => p_phone_id
727: ,p_object_version_number => p_object_version_number);
728: hr_utility.set_location(l_proc, 20);
729: --

Line 733: per_phn_shd.convert_args

729: --
730: -- set the record
731: --
732: l_phn_rec:=
733: per_phn_shd.convert_args
734: (p_phone_id,
735: trunc(p_date_from),
736: trunc(p_date_to),
737: p_phone_type,

Line 780: per_phn_shd.g_old_rec:=l_null_phn_rec;

776: if not l_api_updating then
777: --
778: -- set g_old_rec to null
779: --
780: per_phn_shd.g_old_rec:=l_null_phn_rec;
781: hr_utility.set_location(l_proc, 30);
782: --
783: -- convert the null values
784: --

Line 861: per_phn_shd.lck

857: hr_utility.raise_error;
858: end if;
859: hr_utility.set_location(l_proc, 110);
860: --
861: per_phn_shd.lck
862: (p_phone_id => p_phone_id
863: ,p_object_version_number => p_object_version_number);
864: --
865: -- convert the null values

Line 873: if per_phn_shd.g_old_rec.date_from = l_phn_rec.date_from

869: --
870: -- check to see if the start date hasn't changed and is equal to the
871: -- effective date. This will always be a correction.
872: --
873: if per_phn_shd.g_old_rec.date_from = l_phn_rec.date_from
874: and l_phn_rec.date_from = l_effective_date then
875: l_update_mode:= hr_api.g_correction;
876: end if;
877: --

Line 942: if per_phn_shd.g_old_rec.date_from <> l_phn_rec.date_from

938: -- we have an error. A change of start date is the new start date for
939: -- the new record, so must be the effective date so that the phone numbers
940: -- are continuous.
941: --
942: if per_phn_shd.g_old_rec.date_from <> l_phn_rec.date_from
943: and l_phn_rec.date_from <> l_effective_date then
944: hr_utility.set_location(l_proc, 170);
945: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');
946: hr_utility.raise_error;