[Home] [Help]
1: Package Body hr_phone_api as
2: /* $Header: pephnapi.pkb 120.0.12010000.1 2008/07/28 05:16:50 appldev ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: pephnapi.pkb 120.0.12010000.1 2008/07/28 05:16:50 appldev ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'hr_phone_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-----------------------------< create_phone >-----------------------------|
10: -- ----------------------------------------------------------------------------
767: --
768: -- insert the data
769: --
770: hr_utility.set_location(l_proc||l_phn_rec.parent_id, 50);
771: hr_phone_api.create_phone
772: (p_date_from => l_phn_rec.date_from
773: ,p_date_to => l_phn_rec.date_to
774: ,p_phone_type => l_phn_rec.phone_type
775: ,p_phone_number => l_phn_rec.phone_number
862: -- correct the data
863: --
864: hr_utility.set_location(l_proc, 140);
865: --
866: hr_phone_api.update_phone
867: (p_date_from => l_phn_rec.date_from
868: ,p_date_to => l_phn_rec.date_to
869: ,p_phone_type => l_phn_rec.phone_type
870: ,p_phone_number => l_phn_rec.phone_number
929: hr_utility.set_location(l_proc, 180);
930: --
931: -- end the old phone number
932: --
933: hr_phone_api.update_phone
934: (p_phone_id => l_phn_rec.phone_id
935: ,p_date_to => l_effective_date-1
936: ,p_object_version_number => l_phn_rec.object_version_number
937: ,p_validate => FALSE
940: hr_utility.set_location(l_proc, 190);
941: --
942: -- insert the new phone number
943: --
944: hr_phone_api.create_phone
945: (p_date_from => l_effective_date
946: ,p_date_to => l_phn_rec.date_to
947: ,p_phone_type => l_phn_rec.phone_type
948: ,p_phone_number => l_phn_rec.phone_number
1013: raise;
1014: --
1015: end create_or_update_phone;
1016: --
1017: end hr_phone_api;