577: -- Get the next message log id from the sequence
578: --
579: SELECT hri_adm_msg_log_s.nextval
580: INTO l_msg_log_id
581: FROM dual;
582: --
583: -- Increment the array index at which the infromation is stored
584: --
585: g_index := g_index+1;
746: -- Cursor returning whether an error or warning has occurred
747: --
748: CURSOR error_csr(v_mthd_action_id NUMBER) IS
749: SELECT 'Y'
750: FROM dual
751: WHERE EXISTS
752: (SELECT null
753: FROM hri_adm_msg_log
754: WHERE mthd_action_id = v_mthd_action_id