APPS.HR_CONTACT_EXTRA_INFO_API dependencies on PER_CONTACT_EXTRA_INFO_F

Line 80: l_contact_extra_info_id per_contact_extra_info_f.contact_extra_info_id%TYPE;

76: ) is
77: --
78: -- Declare cursors and local variables
79: --
80: l_contact_extra_info_id per_contact_extra_info_f.contact_extra_info_id%TYPE;
81: l_object_version_number per_contact_extra_info_f.object_version_number%TYPE;
82: l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;
83: l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;
84: l_proc varchar2(72) := g_package||'create_contact_extra_info';

Line 81: l_object_version_number per_contact_extra_info_f.object_version_number%TYPE;

77: --
78: -- Declare cursors and local variables
79: --
80: l_contact_extra_info_id per_contact_extra_info_f.contact_extra_info_id%TYPE;
81: l_object_version_number per_contact_extra_info_f.object_version_number%TYPE;
82: l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;
83: l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;
84: l_proc varchar2(72) := g_package||'create_contact_extra_info';
85: begin

Line 82: l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;

78: -- Declare cursors and local variables
79: --
80: l_contact_extra_info_id per_contact_extra_info_f.contact_extra_info_id%TYPE;
81: l_object_version_number per_contact_extra_info_f.object_version_number%TYPE;
82: l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;
83: l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;
84: l_proc varchar2(72) := g_package||'create_contact_extra_info';
85: begin
86: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 83: l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;

79: --
80: l_contact_extra_info_id per_contact_extra_info_f.contact_extra_info_id%TYPE;
81: l_object_version_number per_contact_extra_info_f.object_version_number%TYPE;
82: l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;
83: l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;
84: l_proc varchar2(72) := g_package||'create_contact_extra_info';
85: begin
86: hr_utility.set_location('Entering:'|| l_proc, 10);
87: --

Line 430: l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;

426: --
427: --
428: -- Declare cursors and local variables
429: --
430: l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;
431: l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;
432: l_proc varchar2(72) := g_package||'update_contact_extra_info';
433: l_temp_ovn number := p_object_version_number;
434: begin

Line 431: l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;

427: --
428: -- Declare cursors and local variables
429: --
430: l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;
431: l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;
432: l_proc varchar2(72) := g_package||'update_contact_extra_info';
433: l_temp_ovn number := p_object_version_number;
434: begin
435: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 727: l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;

723: ) is
724: --
725: -- Declare cursors and local variables
726: --
727: l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;
728: l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;
729: l_proc varchar2(72) := g_package||'delete_contact_extra_info';
730: l_temp_ovn number := p_object_version_number;
731: begin

Line 728: l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;

724: --
725: -- Declare cursors and local variables
726: --
727: l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;
728: l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;
729: l_proc varchar2(72) := g_package||'delete_contact_extra_info';
730: l_temp_ovn number := p_object_version_number;
731: begin
732: hr_utility.set_location('Entering:'|| l_proc, 10);