eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GHR_MASS_SEL_NOA dependencies on GHR_PA_REQUEST_EI_SHADOW

Line 346: FROM ghr_pa_request_ei_shadow

342:
343: CURSOR cur_rpa_ei_shadow
344: (p_pa_request_id IN number) IS
345: SELECT pa_request_extra_info_id
346: FROM ghr_pa_request_ei_shadow
347: WHERE information_type = l_information_type
348: AND pa_request_id = p_pa_request_id;
349:
350: CURSOR cur_rpa_dtl

Line 520: INTO ghr_pa_request_ei_shadow (pa_request_extra_info_id

516: hr_utility.set_location (l_proc, 17);
517:
518: IF p_noa_action IN ('471','472', '460','430') THEN
519: INSERT
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

Line 530: INTO ghr_pa_request_ei_shadow (pa_request_extra_info_id

526: , l_information_type
527: , l_employment_type);
528: ELSIF p_noa_action IN ('280', '292') THEN
529: INSERT
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

Line 540: INTO ghr_pa_request_ei_shadow (pa_request_extra_info_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
539: INSERT
540: INTO ghr_pa_request_ei_shadow (pa_request_extra_info_id
541: , pa_request_id
542: , information_type
543: , rei_information3
544: , rei_information4

Line 557: UPDATE ghr_pa_request_ei_shadow

553: ELSE
554: hr_utility.set_location (l_proc, 18);
555:
556: IF p_noa_action IN ('471','472', '460','430') THEN
557: UPDATE ghr_pa_request_ei_shadow
558: SET rei_information3 = l_employment_type
559: WHERE pa_request_extra_info_id = l_pa_request_extra_info_sh_id;
560: ELSIF p_noa_action IN ('280', '292') THEN
561: UPDATE ghr_pa_request_ei_shadow

Line 561: UPDATE ghr_pa_request_ei_shadow

557: UPDATE ghr_pa_request_ei_shadow
558: SET rei_information3 = l_employment_type
559: WHERE pa_request_extra_info_id = l_pa_request_extra_info_sh_id;
560: ELSIF p_noa_action IN ('280', '292') THEN
561: UPDATE ghr_pa_request_ei_shadow
562: SET rei_information8 = l_employment_type
563: WHERE pa_request_extra_info_id = l_pa_request_extra_info_sh_id;
564: ELSIF p_noa_action IN ('800') AND l_target_agency_code_subelmt IS NOT NULL THEN
565: UPDATE ghr_pa_request_ei_shadow

Line 565: UPDATE ghr_pa_request_ei_shadow

561: UPDATE ghr_pa_request_ei_shadow
562: SET rei_information8 = l_employment_type
563: WHERE pa_request_extra_info_id = l_pa_request_extra_info_sh_id;
564: ELSIF p_noa_action IN ('800') AND l_target_agency_code_subelmt IS NOT NULL THEN
565: UPDATE ghr_pa_request_ei_shadow
566: SET rei_information3 = l_eit_poi
567: ,rei_information4 = l_pos_agency_code
568: ,rei_information5 = l_eit_poi_dt
569: WHERE pa_request_extra_info_id = l_pa_request_extra_info_sh_id;