112: --
113:
114: l_proc varchar2(72) := g_package||'CREATE_ACCOMMODATION';
115:
116: l_accommodation_id pqh_accommodations_f.accommodation_id%TYPE;
117: l_object_version_number pqh_accommodations_f.object_version_number%TYPE;
118: l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;
119: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
120: --
113:
114: l_proc varchar2(72) := g_package||'CREATE_ACCOMMODATION';
115:
116: l_accommodation_id pqh_accommodations_f.accommodation_id%TYPE;
117: l_object_version_number pqh_accommodations_f.object_version_number%TYPE;
118: l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;
119: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
120: --
121: begin
114: l_proc varchar2(72) := g_package||'CREATE_ACCOMMODATION';
115:
116: l_accommodation_id pqh_accommodations_f.accommodation_id%TYPE;
117: l_object_version_number pqh_accommodations_f.object_version_number%TYPE;
118: l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;
119: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
120: --
121: begin
122: hr_utility.set_location('Entering:'|| l_proc, 10);
115:
116: l_accommodation_id pqh_accommodations_f.accommodation_id%TYPE;
117: l_object_version_number pqh_accommodations_f.object_version_number%TYPE;
118: l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;
119: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
120: --
121: begin
122: hr_utility.set_location('Entering:'|| l_proc, 10);
123: --
603: --
604:
605: l_proc varchar2(72) := g_package||'UPDATE_ACCOMMODATION';
606:
607: l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;
608: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
609: l_object_version_number number := p_object_version_number;
610: --
611: begin
604:
605: l_proc varchar2(72) := g_package||'UPDATE_ACCOMMODATION';
606:
607: l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;
608: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
609: l_object_version_number number := p_object_version_number;
610: --
611: begin
612: hr_utility.set_location('Entering:'|| l_proc, 10);
1006: -- Declare cursors and local variables
1007: --
1008:
1009: l_proc varchar2(72) := g_package||'DELETE_SITUATION';
1010: l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;
1011: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
1012: l_object_version_number number := p_object_version_number;
1013: --
1014: begin
1007: --
1008:
1009: l_proc varchar2(72) := g_package||'DELETE_SITUATION';
1010: l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;
1011: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
1012: l_object_version_number number := p_object_version_number;
1013: --
1014: begin
1015: hr_utility.set_location('Entering:'|| l_proc, 10);