APPS.PQH_ACCOMMODATIONS_API dependencies on PQH_ACCOMMODATIONS_F

Line 116: l_accommodation_id pqh_accommodations_f.accommodation_id%TYPE;

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: --

Line 117: l_object_version_number pqh_accommodations_f.object_version_number%TYPE;

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

Line 118: l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;

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);

Line 119: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;

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: --

Line 607: l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;

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

Line 608: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;

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);

Line 1010: l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;

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

Line 1011: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;

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);