678: AND second_noa_id = p_second_noa_id;
679: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,
680: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS
681: SELECT *
682: FROM ghr_dual_proc_methods
683: WHERE LOWER(noa_family_code) = LOWER(p_noa_family_code)
684: AND LOWER(form_field_name) = LOWER(p_form_field_name);
685: TYPE fld_names_typ is TABLE of fields_type
686: INDEX BY BINARY_INTEGER;
1506: l_count2 number :=0;
1507: l_from_to varchar2(1) ;
1508: l_field_name varchar2(150);
1509: l_to_field_name varchar2(150);
1510: l_dual_actions ghr_dual_proc_methods%rowtype;
1511: l_session_var ghr_history_api.g_session_var_type;
1512: l_pa_history_id ghr_pa_history.pa_history_id%type;
1513: l_to_field varchar2(2000);
1514: l_proc varchar2(30):='copy_to_new_rg_shared';