DBA Data[Home] [Help]

APPS.HR_PHONE_API dependencies on PER_PHN_SHD

Line 692: l_phn_rec per_phn_shd.g_rec_type;

688: ) is
689: --
690: l_proc varchar2(72) := g_package||'create_or_update_phone';
691: l_api_updating boolean;
692: l_phn_rec per_phn_shd.g_rec_type;
693: l_null_phn_rec per_phn_shd.g_rec_type;
694: l_update_mode varchar2(30);
695: l_effective_date date;
696: --

Line 693: l_null_phn_rec per_phn_shd.g_rec_type;

689: --
690: l_proc varchar2(72) := g_package||'create_or_update_phone';
691: l_api_updating boolean;
692: l_phn_rec per_phn_shd.g_rec_type;
693: l_null_phn_rec per_phn_shd.g_rec_type;
694: l_update_mode varchar2(30);
695: l_effective_date date;
696: --
697: begin

Line 705: l_api_updating := per_phn_shd.api_updating

701: savepoint create_or_update_phone;
702: --
703: l_update_mode:=p_update_mode;
704: l_effective_date:=trunc(p_effective_date);
705: l_api_updating := per_phn_shd.api_updating
706: (p_phone_id => p_phone_id
707: ,p_object_version_number => p_object_version_number);
708: hr_utility.set_location(l_proc, 20);
709: --

Line 713: per_phn_shd.convert_args

709: --
710: -- set the record
711: --
712: l_phn_rec:=
713: per_phn_shd.convert_args
714: (p_phone_id,
715: trunc(p_date_from),
716: trunc(p_date_to),
717: p_phone_type,

Line 760: per_phn_shd.g_old_rec:=l_null_phn_rec;

756: if not l_api_updating then
757: --
758: -- set g_old_rec to null
759: --
760: per_phn_shd.g_old_rec:=l_null_phn_rec;
761: hr_utility.set_location(l_proc, 30);
762: --
763: -- convert the null values
764: --

Line 841: per_phn_shd.lck

837: hr_utility.raise_error;
838: end if;
839: hr_utility.set_location(l_proc, 110);
840: --
841: per_phn_shd.lck
842: (p_phone_id => p_phone_id
843: ,p_object_version_number => p_object_version_number);
844: --
845: -- convert the null values

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

849: --
850: -- check to see if the start date hasn't changed and is equal to the
851: -- effective date. This will always be a correction.
852: --
853: if per_phn_shd.g_old_rec.date_from = l_phn_rec.date_from
854: and l_phn_rec.date_from = l_effective_date then
855: l_update_mode:= hr_api.g_correction;
856: end if;
857: --

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

918: -- we have an error. A change of start date is the new start date for
919: -- the new record, so must be the effective date so that the phone numbers
920: -- are continuous.
921: --
922: if per_phn_shd.g_old_rec.date_from <> l_phn_rec.date_from
923: and l_phn_rec.date_from <> l_effective_date then
924: hr_utility.set_location(l_proc, 170);
925: hr_utility.set_message(800, 'HR_52859_PHN_INVALID_EFF_DATE');
926: hr_utility.raise_error;