APPS.PQH_ASSIGN_ACCOMMODATIONS_API dependencies on PQH_ASSIGN_ACCOMMODATIONS_F

Line 102: l_assignment_acco_id pqh_assign_accommodations_f.assignment_acco_id%TYPE;

98: --
99:
100: l_proc varchar2(72) := g_package||'CREATE_ASSIGN_ACCOMMODATION';
101:
102: l_assignment_acco_id pqh_assign_accommodations_f.assignment_acco_id%TYPE;
103: l_object_version_number pqh_assign_accommodations_f.object_version_number%TYPE;
104: l_effective_start_date pqh_assign_accommodations_f.effective_start_date%TYPE;
105: l_effective_end_date pqh_assign_accommodations_f.effective_end_date%TYPE;
106: --

Line 103: l_object_version_number pqh_assign_accommodations_f.object_version_number%TYPE;

99:
100: l_proc varchar2(72) := g_package||'CREATE_ASSIGN_ACCOMMODATION';
101:
102: l_assignment_acco_id pqh_assign_accommodations_f.assignment_acco_id%TYPE;
103: l_object_version_number pqh_assign_accommodations_f.object_version_number%TYPE;
104: l_effective_start_date pqh_assign_accommodations_f.effective_start_date%TYPE;
105: l_effective_end_date pqh_assign_accommodations_f.effective_end_date%TYPE;
106: --
107: begin

Line 104: l_effective_start_date pqh_assign_accommodations_f.effective_start_date%TYPE;

100: l_proc varchar2(72) := g_package||'CREATE_ASSIGN_ACCOMMODATION';
101:
102: l_assignment_acco_id pqh_assign_accommodations_f.assignment_acco_id%TYPE;
103: l_object_version_number pqh_assign_accommodations_f.object_version_number%TYPE;
104: l_effective_start_date pqh_assign_accommodations_f.effective_start_date%TYPE;
105: l_effective_end_date pqh_assign_accommodations_f.effective_end_date%TYPE;
106: --
107: begin
108: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 105: l_effective_end_date pqh_assign_accommodations_f.effective_end_date%TYPE;

101:
102: l_assignment_acco_id pqh_assign_accommodations_f.assignment_acco_id%TYPE;
103: l_object_version_number pqh_assign_accommodations_f.object_version_number%TYPE;
104: l_effective_start_date pqh_assign_accommodations_f.effective_start_date%TYPE;
105: l_effective_end_date pqh_assign_accommodations_f.effective_end_date%TYPE;
106: --
107: begin
108: hr_utility.set_location('Entering:'|| l_proc, 10);
109: --

Line 537: l_effective_start_date pqh_assign_accommodations_f.effective_start_date%TYPE;

533: --
534:
535: l_proc varchar2(72) := g_package||'UPDATE_ASSIGN_ACCOMMODATION';
536:
537: l_effective_start_date pqh_assign_accommodations_f.effective_start_date%TYPE;
538: l_effective_end_date pqh_assign_accommodations_f.effective_end_date%TYPE;
539: l_object_version_number number := p_object_version_number;
540: --
541: begin

Line 538: l_effective_end_date pqh_assign_accommodations_f.effective_end_date%TYPE;

534:
535: l_proc varchar2(72) := g_package||'UPDATE_ASSIGN_ACCOMMODATION';
536:
537: l_effective_start_date pqh_assign_accommodations_f.effective_start_date%TYPE;
538: l_effective_end_date pqh_assign_accommodations_f.effective_end_date%TYPE;
539: l_object_version_number number := p_object_version_number;
540: --
541: begin
542: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 896: l_effective_start_date pqh_assign_accommodations_f.effective_start_date%TYPE;

892: -- Declare cursors and local variables
893: --
894:
895: l_proc varchar2(72) := g_package||'DELETE_SITUATION';
896: l_effective_start_date pqh_assign_accommodations_f.effective_start_date%TYPE;
897: l_effective_end_date pqh_assign_accommodations_f.effective_end_date%TYPE;
898: l_object_version_number number := p_object_version_number;
899:
900: --

Line 897: l_effective_end_date pqh_assign_accommodations_f.effective_end_date%TYPE;

893: --
894:
895: l_proc varchar2(72) := g_package||'DELETE_SITUATION';
896: l_effective_start_date pqh_assign_accommodations_f.effective_start_date%TYPE;
897: l_effective_end_date pqh_assign_accommodations_f.effective_end_date%TYPE;
898: l_object_version_number number := p_object_version_number;
899:
900: --
901: begin