[Home] [Help]
581:
582: CURSOR c_get_item_toxic
583: IS
584: SELECT COUNT(*)
585: FROM gr_item_toxic
586: WHERE toxic_effect_code = p_toxic_effect_code;
587: ToxicRecord c_get_item_toxic%ROWTYPE;
588:
589: BEGIN
602: CLOSE c_get_item_toxic;
603:
604: IF l_record_count <> 0 THEN
605: l_return_status := 'E';
606: l_msg_data := l_msg_data || ' gr_item_toxic';
607: END IF;
608: /*
609: ** Now sort out the error messaging
610: */