[Home] [Help]
647:
648: CURSOR c_get_item_properties
649: IS
650: SELECT COUNT(*)
651: FROM gr_item_properties ip
652: WHERE ip.property_id = p_property_id;
653:
654: BEGIN
655:
668: OPEN c_get_item_properties;
669: FETCH c_get_item_properties INTO l_record_count;
670: IF l_record_count <> 0 THEN
671: l_return_status := 'E';
672: l_msg_data := l_msg_data || 'gr_item_properties, ';
673: END IF;
674: CLOSE c_get_item_properties;
675:
676: /* Now sort out the error messaging */