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.

APPS.GHR_PROCESS_SF52 dependencies on GHR_DUAL_ACTIONS

Line 765: CURSOR get_dual_family( p_first_noa_id in ghr_dual_actions.first_noa_id%type,

761: CONNECT BY pa_request_id = prior altered_pa_request_id
762: START WITH pa_request_id = cp_pa_request_id)
763: AND ghrpah_1.nature_of_action_id = cp_noa_id;
764:
765: CURSOR get_dual_family( p_first_noa_id in ghr_dual_actions.first_noa_id%type,
766: p_second_noa_id in ghr_dual_actions.second_noa_id%type) IS
767: SELECT noa_family_code
768: FROM ghr_dual_actions
769: WHERE first_noa_id = p_first_noa_id

Line 766: p_second_noa_id in ghr_dual_actions.second_noa_id%type) IS

762: START WITH pa_request_id = cp_pa_request_id)
763: AND ghrpah_1.nature_of_action_id = cp_noa_id;
764:
765: CURSOR get_dual_family( p_first_noa_id in ghr_dual_actions.first_noa_id%type,
766: p_second_noa_id in ghr_dual_actions.second_noa_id%type) IS
767: SELECT noa_family_code
768: FROM ghr_dual_actions
769: WHERE first_noa_id = p_first_noa_id
770: AND second_noa_id = p_second_noa_id;

Line 768: FROM ghr_dual_actions

764:
765: CURSOR get_dual_family( p_first_noa_id in ghr_dual_actions.first_noa_id%type,
766: p_second_noa_id in ghr_dual_actions.second_noa_id%type) IS
767: SELECT noa_family_code
768: FROM ghr_dual_actions
769: WHERE first_noa_id = p_first_noa_id
770: AND second_noa_id = p_second_noa_id;
771: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,
772: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS

Line 771: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,

767: SELECT noa_family_code
768: FROM ghr_dual_actions
769: WHERE first_noa_id = p_first_noa_id
770: AND second_noa_id = p_second_noa_id;
771: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,
772: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS
773: SELECT *
774: FROM ghr_dual_proc_methods
775: WHERE LOWER(noa_family_code) = LOWER(p_noa_family_code)

Line 772: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS

768: FROM ghr_dual_actions
769: WHERE first_noa_id = p_first_noa_id
770: AND second_noa_id = p_second_noa_id;
771: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,
772: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS
773: SELECT *
774: FROM ghr_dual_proc_methods
775: WHERE LOWER(noa_family_code) = LOWER(p_noa_family_code)
776: AND LOWER(form_field_name) = LOWER(p_form_field_name);

Line 791: l_noa_family_code ghr_dual_actions.noa_family_code%type := null;

787: l_non_from_pa_req ghr_pa_requests%rowtype;
788: l_correction boolean:= null;
789: l_pa_req_ref ghr_pa_requests%rowtype;
790: l_pa_req_ref2 ghr_pa_requests%rowtype;
791: l_noa_family_code ghr_dual_actions.noa_family_code%type := null;
792: tmp_varchar varchar2(150);
793:
794: l_proc varchar2(30):='assign_new_rg';
795: