APPS.GHR_MASS_SEL_NOA dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 331: l_eit_agency ghr_pa_request_extra_info.rei_information4%type;

327: l_rpa_nte_date date;
328: --Bug# 14456039
329: l_rpa_position_id ghr_pa_requests.from_position_id%type;
330: l_pos_agency_code ghr_pa_requests.agency_code%type;
331: l_eit_agency ghr_pa_request_extra_info.rei_information4%type;
332: l_eit_poi ghr_pa_request_extra_info.rei_information3%type;
333: l_eit_poi_dt ghr_pa_request_extra_info.rei_information5%type;
334:
335: CURSOR cur_rpa_ei

Line 332: l_eit_poi ghr_pa_request_extra_info.rei_information3%type;

328: --Bug# 14456039
329: l_rpa_position_id ghr_pa_requests.from_position_id%type;
330: l_pos_agency_code ghr_pa_requests.agency_code%type;
331: l_eit_agency ghr_pa_request_extra_info.rei_information4%type;
332: l_eit_poi ghr_pa_request_extra_info.rei_information3%type;
333: l_eit_poi_dt ghr_pa_request_extra_info.rei_information5%type;
334:
335: CURSOR cur_rpa_ei
336: (p_pa_request_id IN number) IS

Line 333: l_eit_poi_dt ghr_pa_request_extra_info.rei_information5%type;

329: l_rpa_position_id ghr_pa_requests.from_position_id%type;
330: l_pos_agency_code ghr_pa_requests.agency_code%type;
331: l_eit_agency ghr_pa_request_extra_info.rei_information4%type;
332: l_eit_poi ghr_pa_request_extra_info.rei_information3%type;
333: l_eit_poi_dt ghr_pa_request_extra_info.rei_information5%type;
334:
335: CURSOR cur_rpa_ei
336: (p_pa_request_id IN number) IS
337: SELECT pa_request_extra_info_id

Line 339: FROM ghr_pa_request_extra_info

335: CURSOR cur_rpa_ei
336: (p_pa_request_id IN number) IS
337: SELECT pa_request_extra_info_id
338: , object_version_number
339: FROM ghr_pa_request_extra_info
340: WHERE information_type = l_information_type
341: AND pa_request_id = p_pa_request_id;
342:
343: CURSOR cur_rpa_ei_shadow

Line 524: VALUES (ghr_pa_request_extra_info_s.nextval

520: INTO ghr_pa_request_ei_shadow (pa_request_extra_info_id
521: , pa_request_id
522: , information_type
523: , rei_information3)
524: VALUES (ghr_pa_request_extra_info_s.nextval
525: , p_pa_request_id
526: , l_information_type
527: , l_employment_type);
528: ELSIF p_noa_action IN ('280', '292') THEN

Line 534: VALUES (ghr_pa_request_extra_info_s.nextval

530: INTO ghr_pa_request_ei_shadow (pa_request_extra_info_id
531: , pa_request_id
532: , information_type
533: , rei_information8)
534: VALUES (ghr_pa_request_extra_info_s.nextval
535: , p_pa_request_id
536: , l_information_type
537: , l_employment_type);
538: ELSIF p_noa_action IN ('800') AND l_target_agency_code_subelmt IS NOT NULL THEN

Line 546: VALUES (ghr_pa_request_extra_info_s.nextval

542: , information_type
543: , rei_information3
544: , rei_information4
545: , rei_information5)
546: VALUES (ghr_pa_request_extra_info_s.nextval
547: , p_pa_request_id
548: , l_information_type
549: , l_eit_poi
550: ,l_pos_agency_code