APPS.GHR_UPD_HR_VALIDATION dependencies on GHR_PA_REQUESTS

Line 114: PROCEDURE check_required(p_pa_requests_type IN ghr_pa_requests%ROWTYPE

110: --
111: END set_form_item_name;
112: --
113: -- Sundar Bug 4582970 - Added 3 parameters for benefits eit validation
114: PROCEDURE check_required(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
115: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
116: ,p_per_group1_type IN ghr_api.per_group1_type
117: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type
118: ,p_per_retained_grade_type IN ghr_api.per_retained_grade_type

Line 300: PROCEDURE check_insertion_values(p_pa_requests_type IN ghr_pa_requests%ROWTYPE) IS

296: END IF;
297:
298: END check_required;
299: --
300: PROCEDURE check_insertion_values(p_pa_requests_type IN ghr_pa_requests%ROWTYPE) IS
301: --
302: l_proc varchar2(72) := g_package||'check_insertion_values';
303: BEGIN
304: -- This procedure just checks that if insertion values should have been entered they

Line 359: PROCEDURE main_validation(p_pa_requests_type IN ghr_pa_requests%ROWTYPE

355: hr_utility.set_location('Leaving:'||l_proc, 40);
356: --
357: END check_insertion_values;
358: --
359: PROCEDURE main_validation(p_pa_requests_type IN ghr_pa_requests%ROWTYPE
360: ,p_asg_non_sf52_type IN ghr_api.asg_non_sf52_type
361: ,p_asg_nte_dates_type IN ghr_api.asg_nte_dates_type
362: ,p_per_group1_type IN ghr_api.per_group1_type
363: ,p_per_uniformed_services_type IN ghr_api.per_uniformed_services_type

Line 743: from ghr_pa_requests

739: l_person_id per_people_f.person_id%TYPE;
740:
741: CURSOR cur_rpa_data IS
742: select effective_date, person_id, to_position_id
743: from ghr_pa_requests
744: where pa_request_id = p_pa_request_id;
745:
746: /****AVR Commented. 27-FEB-2003
747: CURSOR cur_asg_end_date IS